Profile Summary

MIS Executive with Over *+ 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

Ad-Hoc Clients - Journey2India Travel Tagline Hashtagrani Adhunik Products Aquasovi 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. 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

Data Analyst FMCG

Arbre Creations Pvt. Ltd.

As a data analyst in the project, accountable for data collection, data importing, employee management, exposure analytics, regulatory reporting, deep-dive loss analytics etc. 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 monthly labor.

+91-798******* adzsd8@r.postjobfree.com

Worked on Power BI Reports, SQL Database .

Developed Power BI reports and work flow automations using power Automate for Kellogg Tolaram Eswatini factory, saving ~60hours of MIS Executive - Atomants E-Services

July 2015 - Aug 2020

MIS Executive

Tech Mahindra Sep 2020 - May 2021

Data Analyst - Arbre Creations Pvt. Ltd.

Client - Kellogg Tolaram Eswatini Jan 2022 – Dec 2022 Divya Sharma

Regional HR Coordinator -ICIC BANK LTD

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 Nov 2006 - Aug 2008

using Azure Databricks and Machine learning .

adzsd8@r.postjobfree.com

Get in touch!

798-***-****

adzsd8@r.postjobfree.com

B -709 SCC Sapphire,

Raj Nagar Extension, Ghaziabad

Uttar Pradesh - 201017

Education & Certification

Symbiosis Centre For Distance learning (2006 – 2010) Vinayaka Mission University (2002 – 2005)

Technical Skills

Effective communication skills

Transition/Onboarding of new clients

Project Management & Process Optimization

Skills & Abilities

Console Flare (Jun 2021 – Nov 2021)

Mobile:

Email:

Address:

Post Graduate Diploma in Business Administration

Bachelor of Commerce

Programming Languages - Python, SQL

Framework & Software- Pyspark, SQL-Server

Reporting & Visualization - Power BI, Matplotlib, Seaborn & MS Excel Reporting - Power BI, Ms Excel.

Cloud - Azure, Databricks

Masters in Data Science With Power BI Certification

Contact this candidate