Rashika Sharma

Data Analyst

Gwalior, IN.

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

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.

Projects

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.