Gautam Gupta
Business Analyst
Summary
A focused professional with 9+ years of experience into Business Analytics. A problem-solver dedicated to streamlining operations to decrease costs and promote organizational efficiency. Uses independent decision-making skills and sound judgment to positively impact company success.
Overview
9
9
years of professional experience
Work History
Process Manager
American Express
07.2022 - Current
- Streamlined process workflows by identifying inefficiencies and implementing targeted improvements.
- Collaborated with field teams and business planners to provide customized solutions, increasing report adoption rates and data accuracy.
- Empowered team members to take ownership of their roles by providing clear business understanding, guidance, and support.
- Evaluated and implemented new technologies or process enhancements for continuous improvement opportunities, staying current with industry trends and advancements.
- Enabled standardization of BAU reports among various reporting segments to provide visibly appealing and standard insights to all stakeholders and business.
Lead Assistant Manager
EXL Service
5 2021 - 07.2022
- Build POCs on reporting enhancement and perform analysis on various data sources that could be the best fit.
- Worked on SalesForce to snowflake integration, skipping any manual data source from BAU reportings.
- Created an automated and optimized SAS code and inherited it with certain auto QC checks that were necessary before publishing the dashboard.
- Developed polished visualizations to share results of data analyses.
Process Manager (Level I)
American Express
11.2018 - 04.2021
- Developed custom dashboards for management, enabling monthly tracking of critical KPIs without manual intervention required.
- Consulted with businesses to supply accurate product and service information.
- Assisted in target planning, utilizing precise spend forecasts based on historical trends and projected growth rates.
- Built relationships with customers and community to promote long term business growth.
Business Analyst
EXL Services Pvt. Ltd
01.2017 - 07.2018
- Involved in the development of models used to optimize the selection of claims using SAS BASE, SAS/Enterprise Miner and SAS Enterprise Guide
- Implemented model validation and developed diagnostic tables and graphs that demonstrated how model can be used to improve the efficiency of the selection process for a life insurance acquisition campaign.
- Involved in various automation projects to bring efficiency and timely delivery.
Setup Configuration Specialist
Aon Hewitt
02.2015 - 01.2017
- Delivering reports to clients on ad-hoc basis
- Worked in identifying the issue causing job error and restart/reran the job
- Performs defect analysis
- Reporting and Documentation
- To create detailed documentation for the existing production codes
- Extracted data from DB2 and SQL servers Data Warehousing tables and Data marts using SQL Pass through facility or Lib name method.
Education
Bachelor of Technology - Electrical, Electronics And Communications Engineering
GSMVN Institute of Engineering And Technology
Palwal 04.2001 -
Skills
SAS Base/Advanced, Python 30, Tableau
Agile - Scrum
Oracle 11g, DB2, PL/SQL, MS Excel, MS Access, Hive
Mainframes, Window SAS 94, TOAD(ORACLE), SAS Enterprise guide 70, Jupiter
Personal Information
- Father's Name: Mr. Satish Chand Gupta
- Date of Birth: 11/03/92
- Marital Status: Married
Timeline
Process Manager
American Express
07.2022 - Current
Process Manager (Level I)
American Express
11.2018 - 04.2021
Business Analyst
EXL Services Pvt. Ltd
01.2017 - 07.2018
Setup Configuration Specialist
Aon Hewitt
02.2015 - 01.2017
Bachelor of Technology - Electrical, Electronics And Communications Engineering
GSMVN Institute of Engineering And Technology
04.2001 -
Lead Assistant Manager
EXL Service
5 2021 - 07.2022