Hi,I'm Pramod Choudhary, I have completed my MBA in Business Analytics & HR in 2024 from PUNJAB TECHNICAL UNIVERSITY. Also I have a specialization in Data Analyst with a 1 year internship from Pune.
I am a Data Analys…
Hi,I'm Pramod Choudhary, I have completed my MBA in Business Analytics & HR in 2024 from PUNJAB TECHNICAL UNIVERSITY. Also I have a specialization in Data Analyst with a 1 year internship from Pune.
I am a Data Analyst with strong expertise in SQL, Python, Power BI, Tableau, and Advanced Excel, dedicated to transforming complex datasets into clear, actionable insights. My professional focus is on building efficient data models, optimizing queries, and designing interactive dashboards that support data-driven decision-making across business functions.
With a proven ability to translate raw data into meaningful stories, I specialize in:
- SQL: Advanced query writing, aggregate functions, window functions, and performance optimization
- Power BI & Tableau: Developing interactive dashboards and visualizations that simplify complex information
- Python: Automating bulk data generation, cleaning, and integrating analytics workflows
- Advanced Excel: Leveraging pivot tables, formulas, and reporting tools for quick, reliable insights
I bring a methodical and detail-oriented approach to every project, ensuring accuracy, clarity, and efficiency. My strength lies in problem-solving—whether debugging errors, streamlining processes, or uncovering hidden patterns that drive measurable business outcomes. I thrive in collaborative environments where analytics directly contribute to organizational growth and strategic decision-making.
My short-term goal is to secure a Data Analyst role where I can apply my technical expertise to real-world challenges and deliver impactful solutions. Long term, I aspire to expand into advanced analytics and automation, building scalable solutions that enhance business intelligence capabilities
Assisted in data collection, cleaning, and pre-processing to ensure high-quality datasets.
Created summary reports and dashboards for client projects using Power BI.
Assisted in data collection, cleaning, and pre-processing to ensure high-quality datasets. Created summary reports and dashboards for client projects using Power BI.
E-Commerce Sales Trend Analysis Project📌 ObjectiveAnalyzed large-scale e-commerce sales data to uncover seasonal trends, customer behavior, and product performance. The goal was to generate actionable insights that support marketing, inventory, and pricing strategies.📊 Key Highlights- Conducted data cleaning & preprocessing to ensure accuracy.- Built pivot tables & dashboards in Excel to visualize monthly, quarterly, and yearly sales growth.- Identified top-performing categories (Electronics, Fashion) and tracked their contribution to overall revenue.- Performed customer segmentation analysis, highlighting repeat customers driving ~40–50% of sales.- Evaluated discount impact on sales volume vs. profit margins.- Delivered regional insights, showing growth opportunities in high-performing geographies.🛠 Tools & Techniques (Excel)- Pivot Tables: For grouping, aggregation, and trend analysis.- Charts (Line, Bar, Pie): To visualize sales growth, category performance, and regional comparisons.- Conditional Formatting: To highlight top products, profit margins, and anomalies.- Formulas & Functions: SUMIFS, AVERAGEIFS, VLOOKUP, INDEX-MATCH for deeper analysis.- Data Cleaning: Removing duplicates, handling missing values, formatting dates.📈 Business Impact :- Helped identify seasonal peaks (Nov–Dec festive season).- Supported inventory planning by predicting demand surges.- Guided marketing campaigns toward high-value customer segments.- Improved profitability analysis by balancing discounts with margins.💡 TakeawayThis project demonstrates my ability to transform raw data into strategic insights using Excel. It reflects my growing expertise in advanced Excel techniques and my focus on solving real-world business problems through data.
The AI-first Recruitment Operating System that unifies and automates the entire hiring lifecycle for modern enterprises worldwide.
Dr Job FZ LLC. 2026 © All Rights Reserved
