Ankit Pratap Singh Email & Phone Number

Gurugram, Haryana, India

Gurugram, Haryana, India

• Developed business intelligence dashboard to track key performance indicators.• Created healthcare dashboard to provide comprehensive view of insurance portfolio that allows us to compare financial performance of the partners.• Migrated SSAS based data models by leveraging Power query, DAX thereby enabling more efficient and dynamic reports in Power BI.• Designed and implemented semantic model by automating data extraction from multiple sources, reducing manual efforts by… Show more • Developed business intelligence dashboard to track key performance indicators.• Created healthcare dashboard to provide comprehensive view of insurance portfolio that allows us to compare financial performance of the partners.• Migrated SSAS based data models by leveraging Power query, DAX thereby enabling more efficient and dynamic reports in Power BI.• Designed and implemented semantic model by automating data extraction from multiple sources, reducing manual efforts by leveraging dataflow capabilities.• Enabled necessary row level security to control financial figures across different region.• Introduced report-based alerts, which shoots mail alerts when data in the report changes drastically.• Created multiple paginated reports by pulling data from SQL server into report builder and publishing final report into power bi service. Show less

Chandigarh Area, India

Interacting and communicating with BUs for requirement gathering; collaborating with the Client & Testing Team toimplement improvements in application performance.• Conducting system study and coordinating with team members for System Design & Integration and ApplicationMaintenance.• Maintaining and updating SharePoint Applications, configuring the company SharePoint systems to specifiedrequirements.• Addressing defects and fixing bugs for the existing and New Power BI… Show more Interacting and communicating with BUs for requirement gathering; collaborating with the Client & Testing Team toimplement improvements in application performance.• Conducting system study and coordinating with team members for System Design & Integration and ApplicationMaintenance.• Maintaining and updating SharePoint Applications, configuring the company SharePoint systems to specifiedrequirements.• Addressing defects and fixing bugs for the existing and New Power BI reports.• Adept in developing, publishing and scheduling refresh for Power BI reports as per business requirements.Highlights• Embedded Power BI reports on SharePoint and managed access rights based on role.• Implemented Power BI gateway to connect Power BI and on-premises data source.• Excellent in analytical thinking for translating data into informative visuals and reports.• Responsible for Dataflow creation, scheduling, and maintenance. Show less

Chandigarh, India

Mysore, Karnataka, India

Gurugram, Haryana, India

Master Of Business Administration - Mba, Information Technology, A

B.Tech (Cse), Computer Science, A

Activities and Societies: Actively participated in organizing college fest. I was part of free open source club.

Intermediate, Computer Science

High School, Science

Activities and Societies: I was a part of school basketball team.