Karan Gupta
Greater Noida West
Summary
Results-driven Data & Operations Specialist with over 7 years of experience in data analytics. Expertise in SQL, Power BI, and Excel for effective data cleaning, modeling, and visualization. Proven track record in automating reporting processes and enhancing data accuracy, leading to improved decision-making. Skilled in managing ETL workflows and KPI tracking to align analytics with business goals and drive operational success.
Overview
11
11
years of professional experience
1
1
Certification
Work History
Senior Operations & Data Analyst
STARK CARPETS
10.2020 - Current
- Designed and deployed interactive Power BI dashboards to track KPIs, vendor performance, and purchase order timelines.
- Built SQL queries to extract and transform ERP data for operational and financial reporting.
- Automated Excel-based reporting using VBA macros, saving hours of manual work.
- Led ERP data migration ensuring 99% accuracy and full historical data mapping.
- Developed forecasting models in Power BI and Excel to optimize inventory planning, reducing overstock.
- Created vendor scorecards to monitor lead times, delivery accuracy, and quality metrics, reducing late deliveries.
- Conducted data quality audits and implemented SOPs to maintain accuracy and consistency.
- Collaborated with procurement, sales, and logistics to resolve process bottlenecks, boosting productivity.
- Provided training sessions on Bl tools and reporting best practices to improve data literacy across teams.
- Maintained documentation of all the processes related to Data Analysis.
- Collaborated with cross-functional teams to improve data reporting processes and methodologies.
- Created dashboards using visualization tools to track sales performance and market insights.
- Trained team members on data analysis techniques and software usage for project efficiency.
- Worked with internal teams to understand business needs and changing strategies.
Data Management Executive
PAPPOO STORES
Lucknow
01.2017 - 01.2019
- Improved CRM and inventory workflows, increasing data accuracy and reducing stock discrepancies.
- Performed sales and inventory analysis to enhance forecasting and reporting accuracy.
- Created SOPs for data entry and reporting processes to maintain consistency.
- Consolidated inventory and customer databases, facilitating smoother data migration and reducing duplication across digital platforms.
- Standardized data validation protocols to improve integrity across inventory, sales, and customer datasets, supporting higher confidence in decision-making processes.
- Developed data management protocols to streamline operations across multiple departments.
- Oversaw inventory tracking systems to maintain up-to-date product information.
- Assisted in generating reports for inventory levels and sales trends analysis.
- Collected, outlined and refined requirements, led design processes and oversaw project progress.
MIS Executive / Circle Manager
Singh & Mishra Chartered Accountants
Lucknow
01.2015 - 01.2017
- Managed financial MIS dashboards for audits, reconciliations, and budgets.
- Centralized financial reporting systems, reducing duplication and improving efficiency.
- Managed data entry and maintenance in financial software systems.
- Developed and maintained comprehensive reports for client accounts.
- Analyzed data trends to support decision-making processes.
- Trained staff on software applications and data management practices.
Customer Care Executive
AGIES (Airtel Process)
Lucknow
04.2014 - 02.2015
- Analyzed customer complaint trends and implemented process improvements, lowering repeat escalations by 15%.
- Fielded high-volume inbound calls, addressing customer inquiries and resolving account issues while maintaining service quality benchmarks.
- Documented account updates and service modifications in CRM systems to facilitate seamless information flow and accurate resolution tracking across departments.
Education
Master of Arts - Economics
Lucknow University
Lucknow01.2017
Bachelor of Commerce -
Lucknow University
Lucknow01.2014
Skills
- Power BI and Tableau proficiency
- Business analytics strategies
- Data transformation techniques
- SQL database management
- Automated ETL workflows
- Statistical forecasting methods
- Operations oversight and reporting
- Time management and problem resolution skills
- Interdepartmental collaboration abilities
- Performance measurement strategies
- documentation best practices
- data integrity checks
- decision-making analysis
- development of training materials
- data visualization techniques
Certification
- CCC, National Institute of Electronics and IT (NIELIT)
- Power BI workshop, Office Masters, 2025
- Data analysis using Microsoft Excel, Coursera, 2023
- Power BI Advanced Data Visualization, Coursera, 2022
References
Vishal Gupta, Senior Software Developer, NatWest, vishu0792@gmail.com, +91-9560222974
Languages
Hindi
First Language
English
Proficient (C2)
C2
Timeline
Senior Operations & Data Analyst
STARK CARPETS
10.2020 - Current
Data Management Executive
PAPPOO STORES
01.2017 - 01.2019
MIS Executive / Circle Manager
Singh & Mishra Chartered Accountants
01.2015 - 01.2017
Customer Care Executive
AGIES (Airtel Process)
04.2014 - 02.2015
Master of Arts - Economics
Lucknow University
Bachelor of Commerce -
Lucknow University
Similar Profiles
Sandeep NattSandeep Natt
Construction Site Supervisor at Stark Homes (Stark Engineering & Constructions)Construction Site Supervisor at Stark Homes (Stark Engineering & Constructions)
IVAN TUSHABEIVAN TUSHABE
Carpet salesperson at PERFECT TEXTILE AND CARPETS TRADINGCarpet salesperson at PERFECT TEXTILE AND CARPETS TRADING
Ginto GeorgeGinto George
Deputy Manager at Standard Carpets Ind. LLCDeputy Manager at Standard Carpets Ind. LLC
SHIVANKIT MATHURSHIVANKIT MATHUR
SENIOR DELIVERY LEAD - GLOBAL RECONCILIATION COE at MetLife Global Operations Service CenterSENIOR DELIVERY LEAD - GLOBAL RECONCILIATION COE at MetLife Global Operations Service Center
Shubham JhaShubham Jha
Software Engineer at CognizantSoftware Engineer at Cognizant