Shubham Mane
Kalyan,India
Summary
Detail-oriented professional with expertise in SQL query, SAS programming, Python programming, Power BI visualisations, and MS Excel. Adapt at leveraging data analysis and visualisation skills to drive business insights and support decision-making processes. Committed to continuous learning and career growth within the field of data analytics.
Overview
3
3
years of professional experience
4
4
years of post-secondary education
Work history
Data Analytics
Kotak Mahindra Bank
Thane
2022.01 - 2025.04
- Processing and delivering MIS reports through SAS Software
- Convert and validate raw data such as Excel files, and text files into SAS datasets.
- Understand the Business logic and develop extraction logic for the requirements.
- Frequent use of Proc SQL, Proc FREQ, Proc Format, Joins, Macros, Datasets, and Merge, Reporting in MS Excel, and creating pivots.
- Worked on Various LDM and done Sybase activities in Data Modelling team as a Modeler.
- Communicate with multiple stakeholders and business teams like analytics team and scoring team for better undertanding of the campaigns.
- Working on sql for data engineering part and also on python for product analysis.
Education
Bachelor of Engineering - Mechanical Engineering
Model English High School
Kalyan, Maharashtra 2015.06 - 2019.06
Skills
- SQL query
- SAS programming
- Python programming
- Power BI visualisations
- MS Excel
Languages
English
Upper intermediate
Hindi
Fluent
Marathi
Fluent
Projects
- Work on post-campaign analysis and preparing monthly MIS, AD Hoc, and daily frequency reports based on the specific client requirements by turning the programs and getting better performance by automation.
- Handled the (Credit Card Product) for a year and continued on MIS for TPP products like GPA, Smart cash, and Insta cover.
- Used Macros and pivot table in MS Excel for showcasing the credit card campaign analysis.
- Converted the SAS code into Python for the products and worked on numpy and pandas library.
Timeline
Data Analytics
Kotak Mahindra Bank
2022.01 - 2025.04
Bachelor of Engineering - Mechanical Engineering
Model English High School
2015.06 - 2019.06