Divya Sharma

Divya Sharma

Data Analyst
India

About Me

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-commer…

Experience

Data Analyst

Arbre Creations
Jan 2022 - Present · 4 years 5 months

Data Analysis with the help of Python , Pandas , Power Bi , PySpark .
Data Cleaning and Preprocessing:

Role: Prepare the collected data for analysis by cleaning and transforming it into a usable format.
Responsibilities:
Identify and handle missing, erroneous, or inconsistent data.
Normalize and standardize data to maintain consistency.
Perform data imputation and handle outliers.
Data Analysis and Modeling:

Role: Analyze the processed data to identify patterns, trends, and insights.
Responsibilities:
Apply statistical techniques and algorithms to derive meaningful insights from the data.
Utilize machine learning models for predictive modeling, clustering, classification, and regression analysis.
Validate and optimize models for accuracy and performance.
Data Analysis and Modeling:

Role: Analyze the processed data to identify patterns, trends, and insights.
Responsibilities:
Apply statistical techniques and algorithms to derive meaningful insights from the data.
Utilize machine learning models for predictive modeling, clustering, classification, and regression analysis.
Validate and optimize models for accuracy and performance.
Data Analysis and Modeling:
Data Visualization and Reporting:

Role: Present data insights in a visually compelling and understandable format.
Responsibilities:
Create informative visualizations using tools like Tableau, Power BI, or Python libraries (e.g., Matplotlib, Seaborn).
Develop dashboards and reports to communicate findings to stakeholders.
Tailor visualizations to the audience to effectively convey the message.

Data Analyst

Arbre Creations Pvt. Ltd.
Jan 2022 - Dec 2022 · 11 months

Accountable for data collection.
Accountable for data importing.
Accountable for employee management.
Accountable for exposure analytics.
Accountable for regulatory reporting.
Accountable for deep-dive loss analytics.
Worked on Power BI reports.
Worked on SQL Database.
Created data quality scripts using Pyspark and SQLspark to validate successful data load and quality of the data.
Performed cleaning and pre-import validation of data collected from various sources.
Performed data analysis through Pyspark using Azure Databricks and machine learning.
Developed Power BI reports and workflow automations using Power Automate for Kellogg Tolaram Eswatini factory, saving ~60 hours of monthly labor.

MIS Executive

Tech Mahindra
Sep 2020 - May 2021 · 8 months

Worked in CMB process of Flipkart and handled customers data on MySQL server.
Performed data analysis on raw customer data to extract demographic insights using Pandas and MS Excel.
Handled MIS on company's CRM and managed customers feedback database for sentiment analysis and product review.
Worked on data collection, data analysis, formatting and cleansing, data mining, demography analytics, and e-commerce terminology interpretation.
Analyzed financial losses due to catastrophe risks using analytical models and prepared dynamic and interactive Power BI reports for management ease.
Managed large data sets with multiple states, genders, behaviors, and age groups using NumPy, Pandas, and SQL Server.

MIS Executive

Atomants E-Services
Jul 2015 - Aug 2020 · 5 years 1 month

Accountable for ad-hoc projects including data collection, inventory analytics, sales analysis, customer analysis, regulatory reporting, and KPI analytics.
Prepared point of sale (PoS) reporting including exposure and loss analytics for the client’s prospective business.
Created multiple data validation and reporting dashboards using MS Excel to validate successful data load and quality of the data.
Prepared monthly and quarterly reporting infrastructure from the ground up using MS Excel and Power BI.
Developed dashboard reporting automation for multiple clients with Power BI, saving ~40 hours of monthly labor.
Worked with the marketing team to prepare automated reports for upper management.

Regional HR Coordinator

ICIC BANK LTD
Nov 2006 - Aug 2008 · 1 year 9 months

Handled back-office operations.
Handled HR operations.
Coordinated with sales team of Delhi/NCR Region.
Prepared salary and incentive according to performance.
Reported to ZH.

Skills

Analytics Data Analysis Professional Information Systems Management Data Mining Microsoft Access Statistical Analysis System (SAS) Structured Query Language (SQL) Data Representation Data Analysis Skills Power BI R Programming Language (R) Tableau Python Pyspark SQL Server Matplotlib Seaborn MS Excel Azure Databricks Machine Learning Pandas NumPy Power Automate Effective communication Project Management Process Optimization
Report this Profile?