Summary
Overview
Work History
Education
Skills
TOOLS & TECHNOLOGIES
Certification
Awards, Accomplishments, and Honors
Timeline
Generic
Pooja Gautam

Pooja Gautam

Gurgaon

Summary

Detail-oriented Data Analyst with 9+ years of experience in leveraging tools like Power BI, Qlik Sense, and Python to transform complex data into actionable insights. Skilled in data modeling, visualization, and analytics to drive strategic decision-making and improve business performance.

Overview

9
9
years of professional experience
1
1
Certification

Work History

Deputy Manager-Business Intelligence

Make My Trip
Gurgaon
10.2023 - Current
  • Managing third-party supplier accounts, ensuring alignment with business goals and fostering
    long-term relationships.
  • Designed and implemented 5+ dashboards in Qlik Sense and Power BI, enabling stakeholders to track real-time sales data across regions and track progress against business goals.
  • Identified opportunities for discussion with vendor partners regarding low production and price parity across OTAs.
  • Automated reports using Python, reducing time by 50% and ensuring data accuracy.
  • Collaborated with cross-functional teams to gather requirements and develop tailored solutions, leading to a 25% improvement in business decision-making efficiency.
  • Conducted an in-depth analysis of customer behavior, sales data, and market trends, identifying key opportunities for business growth. Utilized Python libraries such as Pandas and NumPy for data wrangling and statistical analysis.
  • Visualized sales patterns and trends using Matplotlib and Seaborn, creating actionable insights that improved sales strategy and boosted revenue by 15%.
  • Extracted text data from online reviews using BeautifulSoup and Requests which reduced time for manual scrapping by 50%.

Assistant Manager

WNS Global Services
Gurgaon
10.2021 - 10.2023
  • Successfully managed the analytics team to achieve project objectives and deliverables.
  • Created interactive Power BI dashboards that reduced reporting turnaround by 50% for 10 business units.
  • Designed a predictive analytics model using Power BI, identifying sales trends and increasing revenue by 10%
  • Utilized SQL for efficient database management and analysis.

Senior Business Analyst

MetLife
Noida
09.2019 - 10.2021
  • Utilized MS Access DBMS, Power BI, advanced Excel, and advanced technical tools for analytics and reporting for delivering seamless service to onshore.
  • Worked on multiple interna tools to deliver the projects with SLA

Business Analyst

HCL Infosystems
Gurgaon
06.2018 - 08.2019

Generated comprehensive weekly and quarterly reports leveraging Microsoft Excel's advanced features, including pivot tables, VLOOKUP, HLOOKUP, and macros.

Project Manager

Bony Polymers
Faridabad
12.2016 - 02.2018

Successfully led project development for the Instafeed web app, native Android app, and hybrid iOS app.

Software Developer Intern

IYCWorld
Delhi
02.2016 - 12.2016
  • Designed and developed advanced Android applications.

Education

MBA - IT

Amity University
Noida
08-2019

B.Tech - Computer Science

MDU
08-2016

Skills

  • Project Management
  • Data Analysis & Visualization
  • Business Strategy and Analysis
  • Stakeholder Management
  • Business Process Modeling
  • Agile & Waterfall Methodologies
  • Problem-Solving & Critical Thinking
  • Process Improvement and Optimization

TOOLS & TECHNOLOGIES

  • Python (NumPy, Pandas, Matplotlib, Seaborn, BeautifulSoup)
  • Power BI
  • Qlik Sense
  • SQL
  • Data Modeling
  • ETL (Extract, Transform, Load)
  • KPI Development
  • Automation
  • API Integration

Certification

  • Certified in Google Data Analysis
  • Certified in Agile Scrum Master

Awards, Accomplishments, and Honors

  • Appreciated by dream team award in Make My Trip.
  • Appreciated as best performer by GSK stakeholder in WNS
  • Rates as exceed expectation for MetLife
  • Best New Joiner Performance for HCL

Timeline

Deputy Manager-Business Intelligence

Make My Trip
10.2023 - Current

Assistant Manager

WNS Global Services
10.2021 - 10.2023

Senior Business Analyst

MetLife
09.2019 - 10.2021

Business Analyst

HCL Infosystems
06.2018 - 08.2019

Project Manager

Bony Polymers
12.2016 - 02.2018

Software Developer Intern

IYCWorld
02.2016 - 12.2016

MBA - IT

Amity University

B.Tech - Computer Science

MDU
Pooja Gautam