Pragati Jain
+91 7869742324 | pragatijain519@gmail.com | LinkedIn | GitHub
SUMMARY: As an aspiring Data Analyst, I am passionate about working with data to uncover insights that drive better
decision-making. I have hands-on experience with tools like SQL, Excel, Python, Power BI, and Tableau, which I use to
automate reports, analyze datasets, and create clear visualizations. My focus is on making complex data easy to
understand and helping streamline processes to solve business challenges.
KEY SKILLS
Technical Skills: SQL, Python, Power BI, Power Query, Data Modeling, Data Visualization, Advanced MS
Excel, ETL, DAX, Tableau, Looker Studio, Accounting, Finance, Statistics, Marketing.
Developer Tools & Libraries: Power BI Desktop, MySQL Workbench, Tableau Desktop, Jupyter Notebook,
Google Collab, GitHub, MS Excel, Pivot Table, DAX Query.
Soft Skills: Teamwork, Communication, Leadership, Creativity, Handwork, Business Growth, Effective Listener.
EXPERIENCE
ProCapitas: Data Analyst Intern Nov 2024 – Apr 2025
· Emphasized Data Transformation: Optimized the entire data lifecycle, including data extraction, cleaning,
transformation, and analysis, by leveraging SQL to streamline processes and improve efficiency. Gained hands-
on experience in data analytics, utilizing advanced tools such as Power BI and MySQL to extract meaningful
insights from complex datasets.
· Engaged in Multiple Data Science Projects: Actively participated in various data science projects, applying
analytical skills to solve real-world business problems.
· Technical Skills Front and Center: Proficient in data analysis tools and technologies, like SQL, Power BI, Python
and MS-Excel.
India Mart: Sales Executive Aug 2024 – Oct 2024
· Managed upselling, cross-selling, and churn cases, ensuring customer retention and revenue growth. Resolved
customer issues by handling support tickets and providing effective solutions. (Skills: Sales, Customer Retention,
Problem-Solving, Account Management, Client Support).
PROJECTS
- Walmart Inventory Optimization Analysis- Analyzed stockout rates, forecast accuracy, sales uplift, and weather
impact on sales. Developed a predictive model, improving decision-making with 90% forecast accuracy. (Skills: Data
Analysis, Forecasting, SQL, Predictive Modeling, Business Intelligence, Retail Analytics)
- Pizza Sales Analysis- Examined sales data across time periods, locations, and products. Identified trends and insights
that boosted sales. Used SQL for case study analysis. (Skills: SQL, Data Analytics, Trend Analysis, Business Strategy,
Market Insights)
- Electric Vehicle Data Analysis- Built interactive dashboards in Tableau/Power BI to track battery performance,
charging demand, and regional adoption. Provided insights for better planning. (Skills: Data Visualization, Tableau,
Power BI, Dashboard Development, Market Analysis, Business Intelligence)
- E-Commerce sales Analysis- Analyzed customer behavior, optimized revenue management, streamlined logistics,
and improved customer satisfaction by identifying trends, optimizing pricing and inventory, enhancing shipping
efficiency, and addressing high return rates. (Skills: MS-Excel, Power BI, Python, Power Point)
EDUCATION
MBA (Finance & Marketing) | Renaissance University Indore | Madhya Pradesh | 2022-2024
Bachelor of Science (PCM) |Govt Autonomous Degree Collage Satna | Madhya Pradesh | 2016-2019
CERTIFICATION
Data and Business Analytics Program, Jobaaj Learnings
Data Science Job Simulation, Accenture
Data Analytics and Visualization Job Simulation, BCG
Data Analytics Job Simulation, Deloitte
