Prasoon Kumar
Senior Manager - Zonal Analytics & Business Support
Bengaluru
Summary
Data Analyst with experience in interpreting and analyzing data for driving business solutions. Excellent understanding of business operations and analytics tools to discover different dimensions as per business needs through data.
Overview
5
5
years of professional experience
7
7
years of post-secondary education
1
1
Certificate
Work History
Senior Manager - Zonal Analytics
Reliance Nippon Life Insurance
Bengaluru
06.2022 - Current
- Responsible for Zonal Analytics for South Zone.
- Performing raw data analysis and developing Day On Day to Year On Year MIS Report for South Zone.
- Providing Strong Reporting & Analytical information support to leadership for business management.
- Performing on - call duties & off hour support as required.
- Managing Onboarding process for CDA, PTE, TM & RM - South Zone.
- Keeping track of CFR & documents check for CDA, PTE, ARF
- Managing Salesforce data for South Zone on monthly basis.
- Managing Invoice & Payout process for CDA & PTE.
- Handling mapping process for CDA, PTE, RM and TM.
- Limbo Reinstatement for terminated CDA Code or PTE Code
- Solving pending payout queries for CDA & PTE
- Established parallel Coordination with HO team for smooth management of workflow.
- Employee travel data management as per event qualification
Data Analyst (Consultant)
CollegeStop
Bengaluru
06.2020 - 05.2022
- Responsible to analyse raw data, Manipulate, Cleanse and Process data using Advance Excel/SQL
- Perform data analysis in collaboration with business and product teams to make recommendations on key initiatives.
- Designed and implemented reporting dashboards on Tableau to track key business management metrics and provide actionable insights.
- Identify opportunities for business improvement and define/measuring success of those initiatives.
Business Development Executive
Unbound B2B
Pune
07.2018 - 04.2019
- Campaign Analytics
- Appointment generation.
- Acquiring data from primary or secondary data sources for database management.
- Imported, exported, and manipulated large data sets in databases under tight deadlines.
- Designed and developed Tableau visualization solutions.
- Manipulated files and their associated data for rapid delivery to clients or loading onto internal databases.
- Helping clients in identifying right target markets.
Data Research Executive
Markets and Markets Research Pvt Ltd.
Pune
08.2016 - 05.2018
- Data cleansing, data interpretation, data analysis.
- Identifying patterns and trends in data sets.
- Performed analysis and presented results using Advanced Excel, SQL, and MS Access.
- Create daily reports in designed Excel spreadsheets with pivot tables.
- Generating advanced Tableau dashboards with quick/context/ global filter, parameters and calculated fields using various data sources.
- Conduct research to identify potential prospects from primary and secondary data sources.
- Working alongside team members to establish business needs
Education
MBA - Finance And Marketing
Manav Bharti University
Solan, Himachal Pradesh 07.2013 - 05.2015
Bachelor of Commerce - Account Hon.
St. Xavier's College
Ranchi 06.2010 - 07.2013
High School Diploma -
Tata D.A.V Public School
Sijua, Dhanbad 07.2008 - 06.2010
Additional Information
- Designed a classification model using Linear Regression in R to predict Customer lifetime value for a new customer from a marketing point of view, with statistical measures of R2, Adjusted R2 (higher the value better the model), MAPE (lower MAPE better model) , RMSE (lower the value better the model).
- Developed a scorecard using Logistic Regression in R indicating which all are the customers who are likely to leave the telecom company.
- Forecasted sales using Time Series Model in R with statistical measures of ADF Test and ARIMA.
- Designed and deployed rich graphic visualizations using Tableau to identify better performing sales region based on different matrices and identify potential regions for marketing investment according to10 different locations and parameters.
Affiliations
- Excel/VBA/Power Query.
- SQL
- R/Python.
- Statistical Modelling, Linear Regression, Logistics Regression, Time series, Clustering, Decision Trees.
- Experience in common data science toolkits such as NumPy, SciPy, Pandas, SciKit-learn, Matplotlib, Jupyter notebooks.
- Adept at data visualization tool, Tableau.
Certification
Business and Data Analytics Certification from IVY Pro School
Accomplishments
- Certified Data Analyst with proficiency in Advance Excel, MS SQL, Tableau, VBA, R, and Python as tools to perform Statistical Modelling from IVY Professional School.
- Awarded Certificate of Appreciation for Best Performance in Researcher Category (2017).
Timeline
Senior Manager - Zonal Analytics
Reliance Nippon Life Insurance
06.2022 - Current
Data Analyst (Consultant)
CollegeStop
06.2020 - 05.2022
Business and Data Analytics Certification from IVY Pro School
05-2019
Business Development Executive
Unbound B2B
07.2018 - 04.2019
Data Research Executive
Markets and Markets Research Pvt Ltd.
08.2016 - 05.2018
MBA - Finance And Marketing
Manav Bharti University
07.2013 - 05.2015
Bachelor of Commerce - Account Hon.
St. Xavier's College
06.2010 - 07.2013
High School Diploma -
Tata D.A.V Public School
07.2008 - 06.2010
Similar Profiles
BAJRANG PAULBAJRANG PAUL
Senior Branch Manger at Reliance Nippon Life InsuranceSenior Branch Manger at Reliance Nippon Life Insurance
Aman DubeyAman Dubey
Sr. Manager (Group Employee Benefits) at Reliance Nippon Life InsuranceSr. Manager (Group Employee Benefits) at Reliance Nippon Life Insurance
Swapnil TatkareSwapnil Tatkare
Associate Vice President – (DM Channel) Governance at RELIANCE NIPPON LIFE INSURANCE CO. LTD.Associate Vice President – (DM Channel) Governance at RELIANCE NIPPON LIFE INSURANCE CO. LTD.
Shiva SoniShiva Soni
Sr. Branch Manager at Reliance Nippon Life Insurance Co Ltd.Sr. Branch Manager at Reliance Nippon Life Insurance Co Ltd.
Bharath Reddy KBharath Reddy K
Lead Securities Analyst at Wells FargoLead Securities Analyst at Wells Fargo