Summary
Overview
Work History
Education
Skills
Accomplishments
Tools Techniques Skills
Age
Personal Information
Extracurricular Activities
Timeline
Generic

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

undefined

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 -

Similar Profiles

  • SUMIT KUMAR

    SUMIT KUMARSUMIT KUMAR

    Transport Executive/Travel Coordinator at FIL India Business and Research Pvt. Ltd, Fidelity InternationalTransport Executive/Travel Coordinator at FIL India Business and Research Pvt. Ltd, Fidelity International

  • Margaret Libernan

    Margaret LibernanMargaret Libernan

    Fund accountant at Fidelity InternationalFund accountant at Fidelity International

  • Vishal Chauhan

    Vishal ChauhanVishal Chauhan

    Senior Analyst Programmer at Fidelity InternationalSenior Analyst Programmer at Fidelity International

  • DEEPTI KHURANA

    DEEPTI KHURANADEEPTI KHURANA

    Accounts Manager, HR & Administrator at SKS Law AssociatesAccounts Manager, HR & Administrator at SKS Law Associates

  • MANORANJAN SAHOO

    MANORANJAN SAHOOMANORANJAN SAHOO

    Finance and Administration Manager at Insearch (India) LLP. (UTS College)Finance and Administration Manager at Insearch (India) LLP. (UTS College)

CREATE PROFILE
Saurabh Dhanik