HEMANTH KUMAR
Data Analyst
Bengaluru
Summary
As a analyst, I am highly skilled in using data to inform business decisions. I have experience working with large sets of data, using various tools and techniques to identify patterns and possess strong analytical abilities in data visualization tools. I am comfortable working with different programming languages such as Python and SQL. I am a clear communicator, able to convey complex information to both technical and non-technical team members in an easy-to-understand way.
Overview
4
4
years of professional experience
18
18
years of post-secondary education
Work History
Data Analyst
Flipkart
3 2023 - Current
- Developed Python-based automations for multiple KPIs previously managed in Excel, resulting in reduced work time and increased accuracy
- Created multiple SQL queries to extract data from internal database according to team data requirements
- Developed insights and assessed their impact through data analysis, leading to actionable improvements and enhanced results.
- Conducted hypothetical analysis on 'Open Shipment' KPI, evaluating scenarios where orders were neither delivered to customers nor returned to origin, to evaluate potential impacts and enhance logistics strategies.
- Created automation script in Python (Pandas) that significantly improved accuracy and efficiency of Clear trip's MEC report generation, cutting processing time from 10-15 hours to 1.5 hours.
- Developed Python scripts for user automation testing to verify that rates were configured correctly in the internal system.
- Designed and presented descriptive analysis dashboards in Power BI for leadership, focusing on key metrics such as direct P&L revenue, leakage plugged, P&L goodness, potential leakage, leakage identified, potential provisions identified, and provisions prevented across various area
- Delivered statistical insights and developed Power BI dashboard to track disposal leakage, presenting month-on-month trends and identifying factors contributing to product liquidation. The dashboard provided detailed analysis on how different brands, categories, verticals, cities, and warehouses impact leakage
- Performed data manipulation, cleaning, and organization of big datasets to ensure accuracy and usability for analysis and reporting.
- Created documentation for automation scripts, detailing script functionality and providing clear explanations of their operations and purpose. Teaming up with colleagues to uncover and address business problems through data analysis.
MIS Analyst
MOJOCARE
2022.09 - 2023.03
- Creating and maintaining data dictionaries and other documentation to ensure that data is well understood and properly used across the organization
- Cleaning, transforming, and preprocessing data for analysis
- Building and maintaining databases and data systems
- Visualization of data using METABASE
- Optimization of SQL queries
- Produced monthly Management Information reports, clearly illustrating data trends to identify growth opportunities
- Providing training and support to other team members on how to use data and analytics tools
- Identifying opportunities for process improvements and automations using modern tools
- Developed and maintained Python automation scripts to streamline data collection, analysis, and reporting processes, resulting in significant time savings and improved data accuracy
- Creation of GST and settlement financial reports for the company
- Performed ad hoc data analysis and provided insights to management team to inform strategic decision-making
- Developed and maintained complex Excel macros to automate data analysis and reporting processes, resulting in 50% reduction in report generation time.
Operations Analyst
Rupeek
2020.07 - 2022.07
- Identifying trends and patterns in data
- Creating reports and visualizing reports using Power BI to communicate findings
- Developing and implementing data collection systems and other strategies that optimize statistical efficiency and data quality
- Collaborating with teams to identify and solve business problems using data
- Identifying areas for improvement and recommending solutions
- Staying up-to-date with industry trends and new technologies to enhance data analysis process
- Developed SQL queries to obtain complex data from tables in on-site and remote databases
- Communicating with upper management to develop strategic operations goals
- Designing of interactive pan India dashboard to analyze on time performance and fulfillment
- Receiving and responding to approvals and notifications
- Creating report to keep metrics on track
- SPOC for daily operations of organizing and facilitating team members, assuring on time daily delivery of Collateral, processing of checks
- Handled on ground escalation faced by ground team.
Education
Bachelor of Engineering - Electrical, Electronics And Communications Engineering
The Oxford College of Engineering
Bengaluru, India 2015.06 - 2019.07
Science - PCME
Vijaya Pre University College
Bengaluru, India 2013.07 - 2015.03
High School - Secondary Education
Lawrence High School
Bengaluru, India 2001.06 - 2013.04
Skills
Statistical Analysis
Advanced Excel
Python
Power Bi
Big Data
Microsoft Office
Postgresql
Data Visualization
ETL
Business Analysis
Data Analysis
Reporting And Analysis
Query Writing
Data Analyst
Generating insights
Hypothetical Analysis
Descriptive Analysis
Statistical Analysis
Predictive Analytics
Projects
PYTHON AND SQL PROJECTS, 153 Days, Performed advanced data manipulation and analysis using Python and SQL to deliver strategic insights and optimize business operations. Developed and implemented custom data pipelines to transform and clean large, complex datasets. Leveraged SQL to efficiently query and retrieve relevant data from relational databases. Utilized Python libraries such as Pandas and NumPy to conduct exploratory data analysis and generate insightful visualizations. Collaborated with cross-functional teams to identify and address data quality issues, resulting in improved data accuracy and reliability. Regularly communicated findings and recommendations to stakeholders to drive data-driven decision-making.
Timeline
MIS Analyst
MOJOCARE
2022.09 - 2023.03
Operations Analyst
Rupeek
2020.07 - 2022.07
Bachelor of Engineering - Electrical, Electronics And Communications Engineering
The Oxford College of Engineering
2015.06 - 2019.07
Science - PCME
Vijaya Pre University College
2013.07 - 2015.03
High School - Secondary Education
Lawrence High School
2001.06 - 2013.04
Data Analyst
Flipkart
3 2023 - Current
Similar Profiles
PRATITI PARNA SHAKHIPRATITI PARNA SHAKHI
Audio Transcriber and Customer Relationship Manage at FlipkartAudio Transcriber and Customer Relationship Manage at Flipkart
R VIVEK THANGARAJR VIVEK THANGARAJ
Planning Manager at FlipkartPlanning Manager at Flipkart
UJJWAL SATYAUJJWAL SATYA
Team Lead at FlipkartTeam Lead at Flipkart