About

Abhay Prasad is an innovative and versatile Business Intelligence Specialist with over 9 years of experience in data analysis, data engineering, dashboard creation, visualization, VBA automation, cloud, and SQL. He has expertise in creating user-friendly applications with Excel, Access, and SQL Server to capture, extract, and analyze medium to large data sets to generate accurate and easily understandable reporting. Abhay has a strong knowledge of Data Warehousing methodologies including star schemas and snowflakes concepts. He has worked on Azure Data Lake Analytics to analyze structured and non-structured data from various sources. Abhay has played a key role in reducing duplicate work by integrating SharePoint with Power BI to visualize the dashboard using Power Automate and creating various types of automation in VBA. He actively participates in customer meetings to understand the problem statements and business needs and comes up with BI solutions to solve business problems. Abhay has analyzed multiple data sources, investigated data, cleaned and profiled data, applied business rules and transformations, and integrated data into Data Mart. Abhay is proficient in programming languages, software, tools, and functionality such as Power BI, Azure Data Factory, Azure Synapse, Azure Storage, DataBricks, SQL, Alteryx, VBA, Microsoft Excel, Access, SQL Server Management Studio, Word, PowerPoint, SharePoint, stored procedures, views, loops, arrays, record sets, and collections. He has experience working with Agile methodology, improving business processes, problem-solving, and communication. Abhay is currently working as a Lead Data Analytics at Aon and has previously worked as a Senior Analyst at Aon and Senior Database Administrator at Microland Limited. He holds a Postgraduate Degree in Information Technology from Symbiosis and a Bachelor of Science (BS) in Information Technology from Kuvempu University. Abhay has also completed a course from NIIT. He has relevant experience of 7.94 years in SQL, Azure, Databricks, Data Engineering, and Integration.