Trekking
Diptanshu Gautam
Data Scientist
Bangalore/Bengaluru
Summary
Meticulous Data Scientist accomplished in compiling, transforming and analyzing complex information while communicating it to Stakeholder. Experienced in Stakeholder Management. Expert in machine learning and large dataset management. Demonstrated success in identifying relationships and building solutions to business problems.
Overview
6
6
years of professional experience
6
6
years of post-secondary education
Work History
Data Scientist
VMware India
Bangalore
05.2021 - Current
- Utilized advanced querying, visualization and analytics tools to analyze and process complex data sets.
- Worked on large datasets to create complex and scalable models for finance and survey data which reduced effort of team by over 8-10 hours per week.
- Worked on HIVE, Python, Presto to create data pipelines for curated datasets
- Worked on E2E projects, dashboards with Stakeholder to deliver projects related to Survey Analytics which includes but not limited to Word Cloud Analytics, Sentiment Analysis
- Created logic to calculated overall renewal rates of recurring revenue accounts, which is still being used across multiple team as standard definition and logic. This reduced over 8-10 additional man hours across APJ region
- Helped in creating standard hierarchical structure for Geo level to standardize way data is being shown across globe for business
- Worked with Analytics and Data Engineering team to doing multi layered UAT testing and brought many data tables to common platform
- Mentored new joiners towards data understanding and data models and helped them design new solutions for business
- Worked with telemetry for specific products and helped team design solution with bench marking capabilities.
Research Executive
Nielsen
Bangalore
02.2020 - 05.2021
- Build and execute multiple forecasting time series models such as ARIMA using R and Python.
- Creating Excel based Simulator for clients for various forecasting models which increased recurring customers by 10%
- Worked with multiple offshore teams closely to create weekly time series ARIMA forecasting during pandemic period and delivered to clients on time which improved revenue of forecasting team by 16%
- Work with team in anticipating key client issues and regularly offers suggestions on how our data can help.
- Ensure deliverables required are delivered on time and on quality for all assigned projects
- Multitasking and attention to details. Being able to manage 7 client projects at the same time.
- Deliver insights, outcomes and added value to clients, whilst working closely with senior members of team. Having ability to form strong internal relationships and network in order to have more opportunities to collaborate.
- Develops deep product and application which included multi single model and multi variate multi models for at least 10 clients, which resulted in revenue generation of close to ~$1mn.
- Understand strengths and weaknesses opportunities and threats faced by key market players. Proactively seeking opportunities for improvements, working with other market analytics contacts to bring in best in class practices from other markets.
- Working closely with senior members of teams in defining service level and analytical
priorities.
Financial Planning Analyst
Ameriprise Financials
Gurgaon
06.2017 - 07.2019
- Prepared comprehensive financial reports by collecting, formatting and analyzing key data points.
- Used cost and schedule analysis to measure program performance trends and forecast delivery.
- Maintained robust technical knowledge by regularly attending educational workshops and reviewing industry publications.
- Recommended financial actions by assessing options in relation to company goals increasing ROI.
- Developed monthly variance reports to highlight significant variances in cash flow and capital expenditures.
- Monitored KPI to identify cause of unexpected variances.
- Doing case analysis of financial plans and understanding the patterns within.
- Creating financial plans for the clients to save their taxes and optimize their investments.
- Worked on various retirement products such as IRA, 401(k), 403(b), SEP IRA.
- Understanding tax structure of the clients by analyzing their 1040 statements and implementing them in the plan.
- Understanding the strategies such as Roth Conversion, debt modification and debt consolidations and using them when required in the planning.
- Understanding the various tax benefits, a client is eligible to avail at his present age and give suitable recommendations to save taxes and create wealth in long term
Education
Master of Science - Data Analytics
Christ University
Bangalore 07.2022 - Current
MBA - Finance
Christ University
Delhi 06.2015 - 07.2017
Bachelor of Science - Physics
Banaras Hindu University
Varanasi 08.2012 - 07.2015
Skills
Machine learning
Statistical analysis
Python
SQL
Tableau
R
JIRA
Data Modelling
Excel
Data Mining
Planning and Coordination
Analytical and Critical Thinking
Problem-Solving
Self-Motivated
Training and Development
Interests
Reading
Adventure
Dedicated
Disciplined
Timeline
Master of Science - Data Analytics
Christ University
07.2022 - Current
Data Scientist
VMware India
05.2021 - Current
Research Executive
Nielsen
02.2020 - 05.2021
Financial Planning Analyst
Ameriprise Financials
06.2017 - 07.2019
MBA - Finance
Christ University
06.2015 - 07.2017
Bachelor of Science - Physics
Banaras Hindu University
08.2012 - 07.2015