Saurabh Dhanik
Faridabad
Summary
Customer-focused professional with successful 9.6-years career in Multiple sectors. Dynamic successful applying Data Analytics and Reportings skills in busy business environment.
Overview
13
13
years of professional experience
2
2
Languages
Work History
Assistant Manager(Finance Revenue, Sales & Assets mgmt.)
Fidelity International India
03.2020 - Current
- Preparing Daily Business Reports, Dashboards and other OBIEE Financial reports depicting the Sales & AUM of company on the daily basis for the higher management (including CEO, CFO)
- Handling Data Ad hoc requests with inter and intra department on the requirement basis and , performing all the data analysis & Automation using MS Excel(VBA), EMIS(OBIEE) & SQL
- Managing all the business reports in sharepoint and distributing as per the request of stakeholders
- Handling all the Forecasting ,budgeting related data of FP&A team along with the financial analysis
- Involve in the Mutual funds, Asset Class, Funds & Share class analysis for the onshore business team as per their requirement with MS PowerBI
- Analyzing the Client activity on FIL and Partner platform like how much they are investing and redeeming with the help of Python
- Providing Historical sales & assets performance reports of FIL’s clients and their respective funds to the external agencies which are publishing the FIL’s financial report on their platform
- Coordinating with various stakeholders, business teams (Around the globe) for the additional business requirements
- Acting as a bridge between technical and functional team for any business improvements queries and UAT requirement.
Senior Manager(Marketing Analytics)
Finnew Solutions Pvt. Ltd.
12.2018 - 06.2019
- Handling the data analysis , adhoc , MIS and marketing campaign of Company’s Global forex card/Salary card
- Generating Daily /Weekly/Monthly Reports and Dashboards as per Marketing team’s requirement
- Involved in A/B testing for comparing two versions of app
- Tracking & Analysing SMS/Whatsapp/APP Notifications Campaigns through Sendgrid , Gupshup and CleverTap
- Report generation(SAS,SQL & Excel), automation(VBA) and handling adhoc requests from other departments.
Sr. Associate
BNP Paribas India Solution Pvt. Ltd.
08.2016 - 12.2018
- Automate the existing prototype and reports using VBA (Macros)for smoothening the process
- Preparing prototypes using PL/SQL/BI 4.6/BOXI queries and extracting data in to excel file
- Doing analysis according to the requirement of onshore team of Paris
- Working on the project of SRS – Shared Reporting System in Credit risk domain
- Mapping accounting data with Risk data to prepare the input and output of SRS
- Coordinating with Onshore team (Paris & APAC) on establishing this whole process in Shared reporting service
- Responsible for all the critical daily, monthly reports and automating maximum of them
- Doing extensive RCA on the issues develop on the day to day reporting of financial data.
Senior Executive-MIS
Jabong.com
02.2014 - 01.2015
- Created reports in Excel using MS-SQL queries that gave information regarding business and operational activities
- Designed reporting formats to provide accurate information in a clear and concise manner
- Created new reports or modify old one to smoothen the process of logistic and supply chain operations
- Coordinated with other departments i.e
- Order fulfillment , Logistics by solving their adhoc request
- Prepared forecasting of sales orders in the season of Jabong super sales i.e in GOSF, Festival sales
- Responsible for automating the critical reports of logistics with VBA(macros) which helped in reducing the backlog of pending orders in Seasonal sales of Jabong
- Responsible for Data Analysis and number crunching on the data.
Research Associate
Infollion Research Services Pvt. Ltd.
11.2012 - 06.2013
- Responsible for Primary , Secondary research and some MIS work in the company.
Design Engineer
Reva Cranes
07.2011 - 10.2012
- Designing hoist and cranes using AutoCAD and MATLAB software.
Education
Post Graduate Program in Business Analytics - Business Analytics With Big Data
Symbiosis Centre For Management And Human Resource
Pune, India 04.2001 -
Bachelor of Technology - Mechanical Engineering
YMCA Institute of Engineering, Faridabad
Faridabad 04.2001 -
High School Diploma -
CBSE(PCM)
Faridabad, India 04.2001 -
GED -
CBSE
Faridabad 04.2001 -
Skills
SQL
Excel
VBA
PowerBI
Python
OBIEE
Data Analytics
Business Intelligence
Accomplishments
- Saved lots of money by automating some manual process in my current and previous companies
- Excellent in academics specially in Mathematics
- In Top 4% candidates in AIEEE-2007
Tools Techniques Skills
- Proficient in MS Excel (VBA-Macros), MS Access, Data retrieving from SQL,BI 4.6, BOXI & Salesforce,METABASE,EMIS
- Statistical techniques : Logistic and Linear regression(R Software) , Python, SAS
- Domain Knowledge : HR Analytics,Sales & Marketing Analytics, Finance and Operations Analytics
- Functional Skills : Risk data and accounting
Age
33 years
Personal Information
Gender: Male
Extracurricular Activities
Social Responsibility – Blood donation, Volunteering in EARN-Drive (CSR activity initiated by SCMHRD, Pune(Aug’15), Half marathon runner and also the keen participant of CSR activities in company Other interests – Swimming, Travelling, Workout(GYM),Net-Surfing, Music, Singing, Adventurous Sport
Timeline
Assistant Manager(Finance Revenue, Sales & Assets mgmt.)
Fidelity International India
03.2020 - Current
Senior Manager(Marketing Analytics)
Finnew Solutions Pvt. Ltd.
12.2018 - 06.2019
Sr. Associate
BNP Paribas India Solution Pvt. Ltd.
08.2016 - 12.2018
Senior Executive-MIS
Jabong.com
02.2014 - 01.2015
Research Associate
Infollion Research Services Pvt. Ltd.
11.2012 - 06.2013
Design Engineer
Reva Cranes
07.2011 - 10.2012
Post Graduate Program in Business Analytics - Business Analytics With Big Data
Symbiosis Centre For Management And Human Resource
04.2001 -
Bachelor of Technology - Mechanical Engineering
YMCA Institute of Engineering, Faridabad
04.2001 -
High School Diploma -
CBSE(PCM)
04.2001 -
GED -
CBSE
04.2001 -