Pravina Mapuskar
Thane
Summary
Business Intelligence Developer with nearly 10 years of experience in data analysis and report/dashboard design. Expertise in SQL and relational databases, with a strong focus on developing and optimizing ETL processes. Proven track record in leveraging cloud technologies, particularly Microsoft Azure, to create scalable data-driven solutions.
Overview
10
10
years of professional experience
3
3
Certifications
Work History
Application Development Specialist (Team Lead)
Accenture
Mumbai
04.2020 - Current
- Working for one of the leading Wealth Management Organization.
- Expertise in Pharmaceutical and HR domain.
- Collaborated with BAs and stakeholders to define KPIs and requirements as POC for offshore reporting team.
- Built ETL pipelines using Azure Data Factory and SSIS, optimizing SQL queries, views, and triggers.
- Designed dynamic Power BI dashboards and efficient data models for KPI and trend analysis.
- Administered Azure SQL Databases, monitored DTU usage, and enhanced performance using SQL Profiler.
- Managed Power BI Gateways, datasets, scheduled refreshes, and report sharing via Power BI Server and SharePoint.
- Embedded Power BI reports in web applications while integrating Power Apps for data entry.
- Automated transformations using Alteryx, ensuring up-to-date documentation on Confluence.
Analyst (Workforce Analytics)
XPO Logistics
Mumbai
05.2019 - 04.2020
- Connected to SQL server, loading data in Power BI or Excel per client requirements.
- Wrote SQL queries for precise data extraction.
- Modeled data, creating relationships between tables to achieve desired results.
- Created calculated columns for additional required data fields.
- Developed DAX measures for enhanced visual representations.
- Planned and designed visuals to encompass all business KPIs.
- Designed dynamic reports to optimize file size, including trend charts and KPI cards.
- Modified M queries as needed to ensure accuracy and relevance.
Software Developer
Atos India Pvt Ltd
Mumbai
04.2016 - 05.2019
- Designed SAP reports according to requirements, enhancing data accessibility.
- Created SAP queries in SQ01 and integrated them into relevant user groups.
- Defined query variants based on varying requirements for improved data accuracy.
- Managed user accounts, including creation, deletion, and permission assignments.
- Scheduled and executed SAP queries to ensure timely data retrieval.
- Conducted data quality assurance before report distribution for accuracy.
- Automated data-driven reports using UIPATH for efficiency.
- Developed and refreshed Bex queries and Power BI reports for effective data presentation.
Education
Bachelor of Engineering -
Saraswati College of Engineering
Navi Mumbai, Maharashtra07.2014
HSC - Engineering
Khalsa College of Arts, Commerce and Science
Mumbai, Maharashtra07.2010
SSC -
Shivaji Vidyalaya
Mumbai, Maharashtra05.2008
Skills
- Power BI and Alteryx
- Azure Data Factory and SQL Server
- Data modeling and visualization
- KPI analysis and reporting
- ETL pipeline development
- Power Apps and automation
Personal Information
- Date of Birth: 02/25/92
- Gender: Female
- Nationality: Indian
- Marital Status: Married
Languages
English
Proficient (C2)
C2
Hindi
Proficient (C2)
C2
Marathi
Native
Native
Certification
Microsoft Certified: Azure Fundamentals (A900)
Accomplishments
ACE Award, Accenture, 2022
Timeline
Application Development Specialist (Team Lead)
Accenture
04.2020 - Current
Analyst (Workforce Analytics)
XPO Logistics
05.2019 - 04.2020
Software Developer
Atos India Pvt Ltd
04.2016 - 05.2019
Bachelor of Engineering -
Saraswati College of Engineering
HSC - Engineering
Khalsa College of Arts, Commerce and Science
SSC -
Shivaji Vidyalaya