Pooja Kumari Sureka
Summary
Data Analyst | 2+ Years of Experience | Expert in MySQL, Python, Advanced Excel, Power BI, Power Query, DAX, Reporting, ETL, Pivot Table, V-Lookup, SQL Joins, SQL Analytical Functions, Business Insights Dashboarding, and KPI Analysis, Reporting
Overview
3
3
years of professional experience
Work History
Data Analyst
JCBL Accessories
07.2024 - Current
- Optimized and accelerated inventory planning by identifying the top 20% high-performing products, and shortening the procurement-to-sale cycle, driving a 100% increase in sales within just 4 months.
- Engineered and automated a Python script to calculate Turnaround Time (TAT) for over 10,000 orders, cutting dispatch time from 3 to 4 days to 2 days, and significantly boosting operational efficiency.
- Developed and automated aging reports for 5+ non-moving product categories worth ₹1.1 crore+, delivering actionable insights for inventory control, purchasing decisions, and stock clearance.
- Enabled a 100% surge in organizational sales within 6 months by producing and delivering 15+ weekly performance reports on net sales vs. targets to support strategic, data-driven decisions.
- Conducted in-depth analysis of weekly aging reports and spearheaded targeted liquidation strategies, resulting in a 50% reduction in stock value within 6 months.
- Established, standardized, and enforced SOPs for RGPS issuance and closure within a 21-day SLA, and streamlined NRGP documentation to enhance compliance, strengthen operational governance, and improve workflow accuracy.
Business Analyst Intern
AppSynergies
09.2023 - 10.2023
- Conducted a comprehensive analysis of the application to identify where users were getting stuckin the registration process, resulting in a 10% increase in user profile creation.
- Performed daily analyses on generated leads to understand conversion rates and identify profitable marketing campaigns for the organization.
Data Science Intern
iNeuron
04.2023 - 08.2023
- Analyzed and processed extensive datasetsfor 30,000 users using Python libraries for data extraction, cleaning, and interpretation.
- The framework led to a 15% improvement in understanding flight fare fluctuations, considering factors such as journey month, duration, total stops, and airline.
Education
Bachelor of Science - Economics
University of Calcutta
Kolkata11.2020
Full Stack Data Science - Analytics
INeuron
Bengaluru11.2023
Skills
- SQL: PostgreSQL, MySQL, MS SQL Server, MongoDB
- Python: Numpy, Pandas, Seaborn, Scikit-Learn, Matplotlib
- Machine Learning: ML Algorithms
- Analytical Tools: Power BI, DAX, MS-Excel
- Data visualization and presentations
- Analytical problem solving
Accomplishments
Ad-hoc Insights - Consumer Goods Domain
● Analyzed data and interpreted that the company is experiencing 36.33% growth, expanding its portfolio from 245 to 334 items in FY 2021, thereby enhancing market visibility.
● Examined 2021 data and found that 73% of gross sales are contributed by the Retailer channel, generating a significant revenue of 19,241.7 million, demonstrating successful sales channel optimization.
● Utilized SQL methodologies to identify crucial sales trends, revealing that November is the month in which the company achieves the maximum gross sales
Credit Card Analysis Using Consumer Spending Behavior
● Analyzed consumer behavior patterns and gained insights that 31% of total spending is done using credit cards by individuals in the age bracket 25–45.
● Explored spending habits and discovered that 77% of total spending (₹412M) is concentrated in the top 6 categories.
● Suggested family-friendly deals and partnerships with health & wellness brands, leading to a 21% boost in credit card usage among people aged 25–45 and older..
Timeline
Data Analyst
JCBL Accessories
07.2024 - Current
Business Analyst Intern
AppSynergies
09.2023 - 10.2023
Data Science Intern
iNeuron
04.2023 - 08.2023
Bachelor of Science - Economics
University of Calcutta
Full Stack Data Science - Analytics
INeuron