A Professional with approx. 17 years of work experience in BI & Analytics field specialized in Excel, Visual Basic Application & Power BI. A curious VBA and Power BI Developer & Analyst with 7+ years of experience Confident in querying in SQL and DAX languages. 4+years of development experience in Microsoft Power BI tool and ETL tool. Assisting with and fulfilling organization by managing projects in various technologies such as Microsoft 365 Power platform (Power BI, Power Automate), SQL, OTBI Integration with applications Advance Excel, MS Access and Visual Basic Application with Power Automate (Desktop & Cloud). Good Knowledge on Power BI Data Modeling.
Analyzing the business needs of global leaders and Preparation of reports and delivery of these reports to respective leaders. Skillfully managed to report of various claims, Team Reports, Complex Compensation Report and Financial Reports. Handled professional experience in design, development, implementation and Support of reports. Maintained all MIS related tasks and preparing productivity reports for the process. Sharing utilization report of process to the management team, which contains Login Hours, AHT, Productivity, agents time tracker report, agent productivity report daily, weekly and monthly for managers on MS Excel by using Advance Excel and PPT.
Issue Resolution
7+ years of working experience in developing BI applications using Power BI, SQL Server, VBA Macros and Advance Excel. Extensively worked on Power Query Editor to clean and Transform Data. Experience in Reporting Service, Developed Reports using Power BI (Dashboard, Management Reports). Importing data from various data sources including Excel, SQL and Oracle. Develop complex calculation measures using DAX functions as required.
Collaborating with cross-functional teams to gather, analyze and interpret complex data sets to provide actionable insights and support strategic decision making. Conducting extensive testing and debugging to ensure reliability and accuracy of VBA automation solutions.