Shipra Pandey |9670152063|shipra6251@gmail.
com| linkedin| GitHub
Education:
Panjab University 2014
ME(Instrumentation& Control),CGPA 7.8/10
Allahabad Agricultural Institute 2008
[Link](Electrical & Electronics),CGPA 8.63/9.5
Skills
Analytical Tools: Programming Languages: Database:
• Power BI ● SQL (Structured Query Language) ● MySQL
• Advanced Excel ● Python ● Microsoft SQL Server
PROJECTS
Hospitality Analysis - Hotel Chain Business [Power BI | Excel] Presentation video Aug 2024
• Spearheaded Comprehensive Market and Competitor Analysis to identify key factors behind a 20% decline in
Market Share and Revenue.
• Collaborated with cross-functional teams to improve online presence and booking channels,resulting in a 30%
increase in online bookings and a 20% decreasein booking abandonment rate.
• Regained a 10% boost in Market Share and Revenue within six months through strategic implementation of
promotional offers.
Business Insights 360 for AtliQ Hardware[M y S Q L |Power BI]| Live Dashboard May 2024
• Engineered a multi-view Power BI dashboard for 5 departments (sales, finance, supply chain, executive, and
marketing) to analyze global selling patterns at Atliq Hardware.
• Data Imported from 2 sources (MYSQL and Excel), handling over 1 million records, performing ETL processes,
constructing data models, andvisualizations in Power BI.
• Optimized dashboard performance by 5% using DAX Studio,resulting in 30% storage savings and 5% performance
enhancement.
• Advocated for strategic direction, contributing to a projected 10% revenue increase and a 20% reduction in data-
related expenses.
• Collaborated with key stakeholders to refine analysis and drive impactful business decisions.
P&L Report - [Excel | Pivot Table | Power Query] April 2024
• Developed a 4-year P&L Report for Atliq Hardware, utilizing Pivot Tables and DAX in Excel to reveal revenue.
• Automated data cleaning using Power Query, enhancing the flow of data processing and saving approximately 4
hours of manual work.
• Deployed DAX measures, offering 25% more flexibility and user-friendly calculation.
Amazon Sales Analysis [Power BI | Excel] Live Dashboard March 2024
• Formulated strategies to influence sales and profit while reducing overall cost.
• Assessed sales channels, offline sales are notably 17% higher than online sales.
• Expressed findings and insights through visual dashboards to enhance decision-making.
• Resolved challenges related to declining sales over 8-year period (2010-2017) sales experienced a significant
decline, amounting to approximately $28 million.
• Europe and Sub-Saharan Africa contribute to over 50% of total sales.
Olympic Games data analysis- SQL Project Feb 2024
• Analyzed and harnessed the power of MySQL in finding highest and lowest participation,total sports played in
most successful countries.
• Designed effective queries and data flow processes for efficient analysis.
• Engaged in SSI (Sales, Service, and Inventory) data analysis to track performance metrics.
Work Experience (7YEARS )
Shri Ramswarop Engineering College_Lucknow_Assistant Professor Aug 2019 - Mar 2023
• Devised and implemented innovative teaching methodologies to enhance students(CS,IT,EE) practical
understanding of data analysis concepts.
• Expressed complex technical ideas clearly through effective teaching and communication skills.
• Led graduate students in data-driven research projects on data collection methods, analysis techniques, and
interpretation of findings, leading to a 30% placement surge.
• Demonstrated strong leadership in coordinating departmental projects and initiatives.
BBD Engineering College_Ghaziabad_Assistant Professor Jan 2013- Feb 2014
• Initiated effective training, yielded in a 25% improvement in project and presentation outcomes
• Cultivated strong communication skills and leadership among students through mentorship and guidance.
Certifications
• Data Analyst (Noob 1.0) Bootcamp from ‘ Grow Data Skills’.
• Fast Track Data Analyst Bootcamp from ' i Neuron’.
• Power BI Data Analytics for All levels 2.0 ‘Codebasics’
• Excel: Mother of Business Intelligence ‘Codebasics’
• SQL for Data science from 'Great Learning
