Retail Sales & Inventory Analysis Dashboard
→
Summary
Designed and developed a comprehensive, interactive dashboard for a multi-channel retail company, focusing on sales trends, inventory management, and regional performance.
About
Highly analytical and results-driven Data Analyst with 3 years of experience in transforming complex datasets into actionable business intelligence. Proven expertise in developing interactive dashboards, optimizing ETL processes, and advanced data modeling using Python, SQL, Power BI, and Excel. Adept at leveraging data from diverse sources to drive operational efficiency and enhance strategic decision-making.
Work
Websoft IT Solution
|Data Analyst (Client: UrbanCart E-Commerce Pvt. Ltd.)
→
Summary
Led data analysis initiatives for UrbanCart E-Commerce, developing customer retention strategies and enhancing marketing campaign effectiveness through advanced analytics and interactive dashboards.
Highlights
Developed and deployed an interactive Customer Retention Dashboard in Power BI, visualizing key performance indicators (KPIs) such as churn rate, customer segmentation, and purchase frequency to inform strategic marketing decisions.
Extracted, cleaned, and transformed 12 months of transactional data from MySQL using SQL and Python (Pandas) for advanced analytics and robust reporting.
Automated the monthly data refresh pipeline using Python scripting, achieving a 100% reduction in manual update time and improving data currency.
Provided data-driven insights to the marketing team, directly contributing to a 12% improvement in re-engagement campaign ROI.
Pulled critical customer and order data for 12 months from MySQL using complex SQL queries, ensuring comprehensive data availability for analytical projects.
Websoft IT Solution
|Data Analyst (Client: Civitas Resources)
→
Summary
Managed data analysis and reporting for Civitas Resources, enhancing data accuracy and consistency across multiple SQL databases to support data-driven decision-making.
Highlights
Created and maintained interactive Power BI dashboards, significantly improving reporting accuracy by 25% through meticulous data visualization and validation.
Collaborated with cross-functional stakeholders to design and implement efficient data models, automating reporting workflows for enhanced operational efficiency.
Extracted and transformed data from multiple SQL databases, ensuring data integrity, accuracy, and consistency across all reports.
Conducted comprehensive end-to-end testing of dashboards and reporting pipelines, streamlining operations and fostering a data-driven culture.
Education
Jiwaji University Gwalior
Gwalior, Madhya Pradesh, India
→
Bachelor
Commerce
Certificates
Data Science - Machine Learning & AI
Issued By
Uncodemy
Skills
Programming & Scripting
Python (Pandas, NumPy), SQL, DAX.
Data Visualization & BI
Power BI, Excel (Pivot Tables, Charts, Power Query), Jupyter Notebook, Dashboard Development.
Databases
SQL Server, Oracle, MySQL.
ETL & Data Management
Data Cleaning, Data Modeling, ETL Workflows, Windows Task Scheduler.
Analytical & Soft Skills
Data Storytelling, Business Requirement Gathering, Stakeholder Communication, Problem-Solving, Data Interpretation, Strategic Prioritization.