Awantika Gupta
Data Analyst
Kanpur,UP
Summary
Dynamic data analysis professional committed to delivering impactful insights that drive informed business decisions. Expertise in data visualization, statistical analysis, and database management, complemented by a strong emphasis on collaboration and adaptability within team environments. Recognized for reliability, analytical thinking, and a results-driven approach that consistently meets organizational goals. Proficient in Python, SQL, and Excel, ensuring the development of robust data solutions and strategic recommendations tailored to enhance business performance.
Overview
6
6
years of professional experience
3
3
Certifications
Work History
Data Analyst
Balenzia Pvt Ltd
08.2023 - Current
- - Introduced Power BI and DAX across the company, transforming reporting workflows and enabling predictive sales forecasting that contributed to 41% YoY sales growth.
- - Automated discounting strategies based on inventory, sales velocity, and portal-wise logic, reducing manual work and improving pricing accuracy.
- - Automated marketplace uploads (Amazon, Myntra, AJIO, Flipkart), reducing manual reporting time by 80%.
- - Led extensive SAP improvements by correcting SKU mismatches, barcode duplications, incorrect MRPs, pack-size errors, and unit-price inconsistencies, and also established a new SAP creation and validation workflow to ensure error-free master data and prevent unauthorized changes.
- - Coordinated SAP–Unicommerce–Amazon integrations, resolved ASIN conflicts, improved stock sync accuracy, and reduced operational discrepancies.
- - Implemented maximum order limit rules and secured SAP access controls to prevent external vendor overrides.
- - Developed automated DSR dashboards and workflow tools for factory and management teams, eliminating repetitive reporting.
- - Conducted SKU-level retail arrangement and demand analysis leading to improved replenishment and a 15% reduction in excess inventory.
- - Improved data acquisition speed by 20% and accuracy by 15% through automation and streamlined processes.
- Full-time
Freelance Data Analyst
Australian Utilities
01.2023 - 07.2023
- - Designed Excel dashboards and automated workflows for client reporting needs.
- - Performed data cleaning, transformation, pivoting, and reporting.
- - Created advanced Excel formula systems to automate recurring tasks.
- Remote
Business Development Specialist
BYJU'S
01.2021 - 05.2021
- - Negotiated high-value partnerships contributing to 40 percent revenue growth.
- - Analyzed competitor strategies and developed KPI tracking systems.
- - Strengthened communication and customer engagement strategies.
- Full-time
Software Engineer
LTI - Larsen & Toubro Infotech
07.2018 - 01.2021
- - Developed front-end modules using AngularJS, JavaScript, SQL.
- - Automated 150–200 UI test cases daily, improving QA efficiency.
- - Collaborated with QA and engineering teams to deliver stable, production-ready modules.
- Full-time
Education
B.Tech -
PSIT Kanpur
01.2018
Skills
Power BI,
DAX,
SQL,
Advanced Excel,
VBA Automation,
SAP,
Unicommerce,
Tableau,
Python,
Data Cleaning,
Data Visualization,
Reporting & Analysis
Certification
Tableau Specialization – Jobaaj Learnings
Timeline
Data Analyst
Balenzia Pvt Ltd
08.2023 - Current
Freelance Data Analyst
Australian Utilities
01.2023 - 07.2023
Business Development Specialist
BYJU'S
01.2021 - 05.2021
Software Engineer
LTI - Larsen & Toubro Infotech
07.2018 - 01.2021
B.Tech -
PSIT Kanpur