Summary
Overview
Work History
Education
Skills
Certification
Languages
Accomplishments
Affiliations
Timeline
Generic

SHRADHA KUMARI

PUNE

Summary

Goal-oriented Data Analyst successfully assists companies by developing and implementing updates to operational standards, team organization and employee engagement strategies. Proactive and personable leader with top-notch skills in streamlining information, prioritizing tasks and approaching issues with analytical mindset. Bringing years of experience and demonstrated track record of success.

Overview

6
6
years of professional experience
1
1
Certification

Work History

Finance Analyst

Bonace Engineers Pvt Ltd (HINDUSTAN UNILEVER)
Thane
08.2022 - 11.2023
  • Supervised accounting activities and managed accounts payable, month-end close, account reconciliation and preparation of journal entries.
  • Verified documented and requested disbursements to facilitate payments.
  • Analyzed complex financial information to offer recommendations to management, driving decision-making.
  • Administered and maintained data to facilitate tracking and trending analysis.
  • Utilized financial software and advanced Excel functions to streamline data analysis and reporting processes.

Customer Support Executive

Strartek Aegis (FLIPKART)
Bangalore
12.2021 - 07.2022
  • Increased customer satisfaction ratings by 74%, by effectively answering questions, suggesting effective solutions, and resolving issues quickly.
  • Enhanced productivity and customer service levels by anticipating needs and delivering outstanding support.
  • Collaborated with sales team members to stay current on inventory levels and resolve item issues.
  • Drove customer escalations to resolution by engaging directly with clients.

Computer Teacher

GLOBAL PUBLIC SCHOOL
GURGAON
04.2020 - 09.2021
  • Planned and led lessons on basic computer skills, keyboard techniques and internet use.
  • Built and expanded knowledge of IT trends by attending professional workshops, seminars and conferences.
  • Created tests and assignments to assess student knowledge of presented coursework and lecture materials.
  • Collaborated with staff members on curriculum planning and incorporation of computers into different class lesson plans.
  • Expanded student learning by incorporating extra-curricular computer science activities.
  • Cultivated classroom environment centered on encouraging student engagement and performance with computer science work.

Data Analyst Intern

New India Assurance
Silvassa, Dadra And Nagar Haveli
08.2017 - 04.2018
  • Gathered data from multiple sources to assimilate meaningful inputs for databases.
  • Audited new data, identifying potential issues and corroborating reports.
  • Improved integrity and completeness of medical records by consulting with clinical staff to resolve diagnostic mistakes.
  • Extracted data to build metrics or create dashboards, tracking success toward KPIs.

Education

DATA ANALYST + PYTHON - DATA ANALYST

SKILLOVILLA
BANGALORE
05-2024

Bachelor of Education - Computer Science And Mathematics

Maharishi Dayanand University
Rohtak , Haryana
07-2021

Bachelor of Science - Computer Science And Programming

Savitribai Phule Pune University
Silvassa, Dadra Nagar Haveli
08-2017

High School Diploma -

Kendriya Vidyalaya Sangathan
Silvassa, Dadra And Nagar Haveli
05-2014

Skills

  • MySQL
  • Python
  • Data Visualization (POWER BI & TABLEAU)
  • Effective Communication
  • Data Validation
  • Statistical Analysis
  • Advanced Excel (VLOOKUP, INDEX-MATCH, PIVOT TABLES)

Certification

  • GOLD CERTIFIED IN DATA ANALYST AT SKILLOVILLA. (Sep 2023 - May 2024)

Languages

Hindi
First Language
English
Advanced (C1)
C1
Gujarati
Upper Intermediate (B2)
B2

Accomplishments

  • SKILLOVILLA PROJECTS ACCOMPLISHMENTS ARE LISTED BELOW
  • Freshco Hypermarket Capstone(Secured 90%): Freshco introduced a home delivery service in the year 2021. To ensure seamless operations and optimize customer satisfaction, the store diligently maintained a comprehensive transaction data sheet, containing detailed information at the order level.
  • Fundamentals of Excel, Data Manipulation & Working with Tables
  • Created a workbook having all the calculations (charts, tables, conditional formatting etc) to our insights. Maintained separate sheet in the workbook for every analysis. Hence created 4 sheets Order level Analysis, Customer Level Analysis, Delivery Analysis, and Completion Rate Analysis.
  • Used Advanced Excel formulas (VLOOKUP , INDEX-MATCH, PIVOT TABLES ) to exceed in this project.
  • Capstone Project - Airline Db (Secured 92%): Solved by writing SQL queries , Clauses like SELECT, FROM, WHERE , GROUP BY , ORDER BY, HAVING , INSERT, UPDATE, DELETE , and JOIN and Commands (DDL,DML,DQL), Using Aggregate Functions such as COUNT(), SUM(),AVG(), MIN(), MAX() . String Manipulation functions are often used CONCAT(), SUBSTRING(), UPPER(), LOWER().
  • SWIGGY FUNNEL ANALYSIS CAPSTONE (Secured 100%) : Created a document, mention all the insights related to the business case . The report included a list of dates having any order drop and hike as compared to last same day last week. Mentioned the reason for the drop in front of the date itself.
  • Identified the source of the traffic creating fluctuation also smaller conversions leading to the impact (L2M, M2C, C2P, P2O)
  • Supporting excel file : Created a workbook having all the calculations (charts, tables, conditional formatting etc) to our insights.
  • SHOPNEST STORE POWER BI CAPSTONE (Secured 92%) : Designed a comprehensive Power BI dashboard to address key business analytics for a retail dataset.
  • Created a dynamic visual that compares the number of delayed orders to the number of orders received earlier for each month. Utilized the drill through cross-report feature to provide a detailed analysis of late and on-time deliveries.
  • Analyzed the most frequently used payment methods by customers using a visually appealing representation, such as a pie chart or other suitable visuals.
  • Identified and visually represented states with high and low sales, providing a clear understanding of regional sales performance.
  • Determined the total revenue generated by ShopNest Store and analyzed how it changes over time(Yearly). Represented this information through suitable visuals to highlight trends and patterns.
  • PYTHON FUNDAMENTALS : Learned python basics , including the following elements: Boolean types, Strings, Mathematical operations , Lists and Loops, Dictionaries, Functions, Error checking. Familiar with Jupyter Notebooks.

Affiliations

  • CRICKET (AWARDED TWO TIMES WOMAN OF THE MATCH )
  • SINGING (NATIONAL LEVEL SINGING COMPETITION AT KENDRIYA VIDYALAYA AMBALA)
  • PAINTING
  • MARATHON RUNNING

Timeline

Finance Analyst

Bonace Engineers Pvt Ltd (HINDUSTAN UNILEVER)
08.2022 - 11.2023

Customer Support Executive

Strartek Aegis (FLIPKART)
12.2021 - 07.2022

Computer Teacher

GLOBAL PUBLIC SCHOOL
04.2020 - 09.2021

Data Analyst Intern

New India Assurance
08.2017 - 04.2018

DATA ANALYST + PYTHON - DATA ANALYST

SKILLOVILLA

Bachelor of Education - Computer Science And Mathematics

Maharishi Dayanand University

Bachelor of Science - Computer Science And Programming

Savitribai Phule Pune University

High School Diploma -

Kendriya Vidyalaya Sangathan
  • GOLD CERTIFIED IN DATA ANALYST AT SKILLOVILLA. (Sep 2023 - May 2024)
SHRADHA KUMARI