MAHIMA GAUR
Warsaw
Summary
Over 6+ years of industry experience in data analytics and project management, extensive hands-on expertise in data analysis using tools such as SQL, Tableau, Power BI, and Data analysis. Applying advanced data analysis techniques to derive actionable insights from company data. Collaborating with multiple teams across different departments to consistently achieve project deliverables within critical deadlines. Utilizing data warehousing, ETL, OLAP and reporting tools to conduct comprehensive quantitative analysis of company data, driving data-backed product enhancements. Reporting on project progress to key stakeholders crucial in ensuring continued funding. Maintaining a strong focus on meeting quality standards and key performance indicators (KPIs) for all projects. Active promoter of feedback and knowledge sharing culture within an organization, striving to contribute to a collaborative and successful work environment.
Overview
6
6
years of professional experience
Work History
Senior Insights and Analytics
Dynata
06.2024 - Current
- Performed data mining and manipulation using advanced SQL to extract meaningful patterns and insights on dataset with billions of records
- Authored and optimized complex SQL queries to generate data-driven reports using Tableau and actionable business insights
- Conducted in-depth analysis of datasets to derive conclusions, synthesizing results into actionable insights and strategic recommendations
- Delivered 100+ technical presentations of analytical findings to stakeholders, including business partners and executive management
- Partnered with the Technology and Data Foundation teams to define data requirements, develop semantic layers, integrate data streams, and architect new analytical tools and capabilities
Metrics and Reporting Specialist
Google Operations Center
06.2023 - 06.2024
- Maintained SQL codebase that powered Actioned Revenue Dashboard in Google Ads
- Enhanced stakeholder data insights by building new dashboard functionalities using Google Data/Looker Studio and proactively maintaining existing dashboards for accuracy, usability, and responsiveness to stakeholder questions
- Streamlined business operations by automating reports and building interactive SQL scripts and dashboards, delivering data-driven insights at scale to address critical business priorities
- Demonstrated proficiency in SQL data manipulation and anomaly detection to identify and address outliers, safeguarding data quality
- Leveraged SQL and dashboarding skills to bridge gap between data and stakeholders
Consultant Project Management
Cint
02.2019 - 06.2023
- Compiled and extracted data from various sources (SSRS, Power BI, Salesforce) via ETL pipelines into data warehouse and used reporting tools to present it to internal and external stakeholders
- Ensured validity by ingesting & analyzing data kept in data warehouse and generated reports using different reporting tools
- Set up technical Integrations and took ownership of data collections
- Implemented end-to-end process for multiple projects with clients in APAC, EMEA, and the US markets
- Handled 400+ projects in 2022 alone, highest number of projects by any
PM, across all verticals - Conducted regular audits to ensure that operational workflow is being followed according to the policy
- Collaborated with the account, sales, technical and resource management teams and managed expectations, project plans and communications with the clients
- Identified outliers and implemented corrective action to address the issues
- Developed strong working relationships with external client personnel, anticipating client needs in advance & communicating with the leadership
- Implemented end-to-end execution & problem-solving for the projects to resolve field issues and data reporting challenges
- Managed a team of 8 project analysts to deliver project management goals
Education
B.Tech - Computer Science With Specialization in Open Source & Open Software
University of Petroleum & Energy Studies
2018
Skills
- Advanced SQL
- Snowflake
- Power BI
- Tableau
- Data/Looker Studio
- Jira
- Data Migration
- Project Management
- Business Intelligence
- Google BigQuery
- Hadoop
Courses Certifications
- PRINCE2 Agile Project Management
- The Business Intelligence Analyst Course - Udemy
- Scrum: The Basics - LinkedIn
Languages
English
Proficient
C2
Awards
- Building Community, Cint, Awarded for conducting multiple trainings for colleagues to help them towards the combined goal of achieving the team target.
- Accountability, Cint, Awarded for exceptional accountability in handling 400+ projects in 2022, the highest number of projects by any PM, across all verticals.
- Recognized for exceptional problem-solving and efficiency in tackling complex BI tasks and tickets at Dynata.
Timeline
Senior Insights and Analytics
Dynata
06.2024 - Current
Metrics and Reporting Specialist
Google Operations Center
06.2023 - 06.2024
Consultant Project Management
Cint
02.2019 - 06.2023
B.Tech - Computer Science With Specialization in Open Source & Open Software
University of Petroleum & Energy Studies
Similar Profiles
Vesko PetrovVesko Petrov
Survey Analyst & Customer Support at DynataSurvey Analyst & Customer Support at Dynata
ARNAUD TIAMARNAUD TIAM
Senior PostgreSQL Engineer at DYNATASenior PostgreSQL Engineer at DYNATA
Sandra MalkinSandra Malkin
Data Analyst at DynataData Analyst at Dynata