Divya Sharma
Data Analyst FMCG
Arbre Creations Pvt. Ltd.
+91 7982876999
[email protected]Profile Summary
MIS Executive with Over 8+ years of overall experience as an MIS Executive and 2+ years in Data Analysis, Cleaning, Mining,
& Visualization with data sets of Structured and Unstructured Data in FMCG, Tourism and E-commerce.
Work Experience
Data Analyst - Arbre Creations Pvt. Ltd.
Client - Kellogg Tolaram Eswatini | Jan 2022 – Dec 2022
As a data analyst in the project, accountable for data collection, data importing, employee management, exposure
analytics, regulatory reporting, deep-dive loss analytics etc.
Worked on Power BI Reports, SQL Database .
Created Data Quality Scripts using Pyspark and SQLspark to validate successful data load and quality of the data.
Cleaning, Pre-import Validation of data collected from various sources & performing Data Analysis through Pyspark
using Azure Databricks.
Developed Power BI reports and work flow automations using power Automate for Kellogg Tolaram Eswatini factory, saving ~60hours of
monthly labor.
MIS Executive
Tech Mahindra | Sep 2020 - May 2021
Worked in CMB process of Flipkart and handled customers data on MySQL server.
Data Analysis on raw data of customers to extract demographic insights using Pandas & MS Excel.
Handling MIS on company's CRM and managing customers feedback database for sentiment analysis and product review.
Exposed to facets of E-commerce business viz. Data Collection, Data Analysis, Formatting and Cleansing, Data Mining,
Demography Analytics, and E-commerce terminology interpretation.
Analyzing financial losses due to the catastrophe risks using analytical models and preparing dynamic & interactive
Power BI reports for management ease.
Managing large data sets with multiple states, genders, behaviors, and age groups including extensive use of NumPy,
Pandas, and SQL Server
MIS Executive - Atomants E-Services
Ad-Hoc Clients - Journey2India | Travel Tagline | Hashtagrani | Adhunik Products | Aquasovi
July 2015 - Aug 2020
As an MIS Executive of the project, accountable for Ad-hoc projects which include data collection, inventory analytics,
sales analysis, customer analysis, regulatory reporting, KPI analytics etc.
Prepared point of sale (PoS) reporting which includes exposure and loss analytics for the client’s prospective business.
Created multiple data validation & reporting dashboards using MS Excel to validate successful data load and quality of
the data.
Preparing monthly & quarterly reporting infrastructure from the ground up using MS Excel & Power BI.
Developed dashboard reporting automation for multiple clients with Power BI, saving ~40hours of monthly labor.
Work with the marketing team to prepare automated reports for upper management.
Regional HR Coordinator -ICIC BANK LTD
Nov 2006 - Aug 2008
Back-office operations, HR operations and coordination with sales team of Delhi/NCR Region . Preparing their salary
and incentive according to the performance and reporting to ZH
Get in touch! Technical Skills
Mobile: Programming Languages - Python, SQL
7982876999
Framework & Software- Pyspark, SQL-Server
Email: Reporting & Visualization - Power BI, Matplotlib, Seaborn & MS Excel
[email protected] Reporting - Power BI, Ms Excel.
Address: Cloud - Azure, Databricks
B -709 SCC Sapphire,
Raj Nagar Extension, Ghaziabad
Uttar Pradesh - 201017
Education & Certification
Masters in Data Science With Power BI Certification
Console Flare (Jun 2021 – Nov 2021)
Post Graduate Diploma in Business Administration
Symbiosis Centre For Distance learning (2006 – 2010)
Bachelor of Commerce
Vinayaka Mission University (2002 – 2005)
Skills & Abilities
Effective communication skills
Transition/Onboarding of new clients
Project Management & Process Optimization
