Dec 2024 – Apr 2025 · 4 mos · Kolkata, West Bengal, India · On-site

• Data Architecture & Integrity: Maintained centralized databases for seller onboarding and product catalogs using Advanced Excel (Power Query, XLOOKUP); improved data accuracy by 30% through the implementation of automated validation scripts and error-checking protocols.
• Business Intelligence & Analytics: Executed deep-dive analysis on seller performance using Pivot Tables and Statistical Modeling to identify churn risks and growth patterns, contributing to a 15% increase in seller retention over 12 months.
• Process Automation: Streamlined data consolidation workflows by developing automated Excel macros and templates, reducing manual reporting time by 15+ hours per week and accelerating the new business acquisition cycle.
• Strategic MIS Reporting: Designed and deployed interactive MIS Dashboards featuring dynamic slicers and KPIs; translated complex datasets into actionable insights for senior leadership to drive operational decision-making and expansion strategies.
• Cross-Functional Optimization: Audited and reconciled multi-channel performance data to ensure 100% alignment between operational outputs and financial reporting, facilitating data-driven collaboration across marketing, sales, and logistics teams.

Jun 2024 – Jul 2024 · 1 mo · Kolkata, West Bengal, India

• Project: Competitor Mapping & Market Analysis
• Strategic Business Analysis: Conducted comprehensive Business Analysis of the organized flashlight market by cleaning and modeling complex competitor datasets; identified critical product gaps and pricing trends to inform long-term strategic positioning.
• Data-Driven Marketing Support: Provided high-level Marketing Support by benchmarking Eveready products against competitor offerings, translating technical data into a comparative marketing brochure that enhanced sales team effectiveness.
• Advanced Data Visualization: Leveraged Microsoft Power BI and Microsoft Excel to visualize market share and competitive feature sets, transforming raw research into dynamic dashboards for executive-level review.
• Actionable Market Insights: Identified significant product improvement opportunities through structured data comparison, resulting in actionable recommendations for product enhancement and strategic decision-making.
• Professional Communication & Reporting: Utilized advanced Communication skills to present analytical findings and "market trend" reports to cross-functional stakeholders, ensuring alignment between product development and marketing strategy.

Oct 2023 – Nov 2023 · 1 mo · Kolkata bowbazar · On-site

• Project: Retail Sales Performance & Customer Insights Analysis
• Retail Sales Analytics: Analyzed large-scale retail sales and customer datasets to track multi-store performance and identify emerging sales trends.
• KPI Tracking & Optimization: Monitored and reported on critical business metrics including Revenue, Conversion Rate, and Average Bill Value (ABV) to drive operational efficiency.
• Customer Behavior Intelligence: Conducted deep-dive customer behavior and product category analysis to identify high-demand segments within the jewelry sector.
• Strategic Inventory Management: Provided data-driven support for inventory planning and upselling strategies based on identified consumer purchasing patterns.
• Data Visualization & Reporting: Developed advanced Excel-based dashboards and automated reports to deliver actionable insights to store leadership for customer experience improvements.

Apr 2022 – Nov 2022 · 7 mos · Hyderabad · On-site

• Managed and validated complex healthcare datasets across billing, appointments, and patient records using Advanced Excel and APPEX CRM to ensure 100% data integrity for hospital operations.
• Engineered structured MIS reports and automated dashboards that provided leadership with real-time actionable insights for strategic operational planning.
• Streamlined patient flow and service efficiency by analyzing large-scale datasets to identify bottlenecks and monitor key performance indicators (KPIs).
• Executed data reconciliation and cleaning processes to eliminate redundancies, significantly improving the speed and accuracy of monthly financial and operational reporting.
• Collaborated with cross-functional teams to maintain CRM accuracy, supporting a data-driven environment that enhanced overall hospital performance tracking.

Mar 2021 – Mar 2022 · 1 yr · Hyderabad, Telangana, India

• Consolidated, analyzed, and maintained large-scale healthcare datasets related to patient flow, treatment schedules, billing, and operations using Advanced Excel, enabling accurate tracking of operational performance and service efficiency.
• Managed data cleaning, validation, and reconciliation processes to ensure accuracy, consistency, and compliance across patient, treatment, and financial records, supporting smooth day-to-day hospital operations.
• Developed and maintained Excel-based MIS reports and dashboards to monitor key operational metrics, resource utilization, and performance indicators, providing actionable insights to management.
• Supported operational planning and process improvement initiatives by analyzing historical data, identifying inefficiencies, and assisting leadership with data-driven decision-making.