eCommerce Sales Dashboard
Summary
Developed a comprehensive eCommerce sales dashboard to provide insights into sales performance, customer behavior, and product trends, aiding in strategic decision-making.
About
Highly analytical Data Analyst with 4 years of experience leveraging SQL and Power BI to transform complex data into actionable insights, driving operational efficiency and business growth. Adept at developing interactive dashboards, managing data integrity, and communicating findings to stakeholders to support strategic decision-making and project execution.
Work
SAGO Private Limited
|Associate Quality Analyst
Gurugram, Haryana, India
→
Summary
Led quality assurance and data analysis initiatives, developing complex queries and interactive dashboards to enhance operational efficiency and data integrity for key business projects.
Highlights
Developed and optimized complex SQL queries for 3+ years across multiple databases, significantly enhancing data accuracy and integrity for critical business analysis.
Designed and deployed interactive Power BI dashboards and reports, visualizing key business metrics and trends to inform strategic decision-making processes.
Spearheaded the management of 40+ MaxDiff projects and 100+ Upside Link projects, ensuring precise data collection and delivering insightful analysis for informed decision-making.
Resolved critical issues within the Confirmit platform, ensuring seamless execution of key projects and maintaining high data quality standards.
AI VARIANT
|Data Science Intern
Bengaluru, Karnataka, India
→
Summary
Contributed to Business Intelligence projects by leveraging SQL and Power BI to deliver precise and actionable data insights.
Highlights
Executed Business Intelligence (BI) projects with 90% accuracy, utilizing SQL and Power BI to generate precise and actionable insights that informed strategic decisions.
Contributed to data-driven initiatives by developing reports and dashboards, translating complex data into clear visualizations for stakeholders.
Education
Govind Ballabh Pant Institute of Engineering & Technology
Pauri Garhwal, Uttarakhand, India
→
Master of Computer Applications (MCA)
Computer Applications
Grade: 7.5 CGPA
Modern Institute of Technology (Affiliated to HNBGU)
Roorkee, Uttarakhand, India
→
Bachelor of Computer Applications (BCA)
Computer Applications
Grade: 7.8 CGPA
Skills
Data Analysis & Visualization
SQL, Power BI, Excel, Data Analysis, Data Processing, KPIs, Dashboards, Reporting.
Programming & Libraries
Python, NumPy, Pandas.
Projects
Employee Attrition Dashboard
Summary
Developed an employee attrition dashboard incorporating KPIs, utilizing pie charts, stacked column charts, matrices, area charts, and stacked bar charts to provide comprehensive insights and support strategic HR decision-making.
Music Store Data Analysis Project
Summary
The Music Store Data Analysis Project using SQL is a comprehensive approach to understanding and optimizing various aspects of a digital music store. By leveraging SQL for data analysis, the project uncovers valuable insights that can drive business growth.
Pharmaceutical Sales Performance Dashboard
Summary
Designed and developed a comprehensive Power BI dashboard to analyze pharmaceutical sales performance across regions, customer segments, and internal sales teams.
Distributor & Customer Analysis Dashboard
Summary
Developed a Distributor & Customer Analysis dashboard in Power BI to gain deep insights into product performance across customer demographics and distributor behavior.