PRAMATHA CHANDRA BARIK
Data Analyst and Operations Specialist
About
Data Analyst and Operations Specialist with 5+ years of experience in the E-commerce and Supply Chain sectors (Flipkart, Amazon). Expert in SQL, Advanced Excel, and Power BI for Data Management, Operational Reporting, and Efficiency gains. Proven track record in leveraging AI/Automation to drive cost reduction, including a 75% reduction in pilferage at Azgo.
Skills & Expertise (16)
Work Experience
Business Analyst, Digital Marketing
Cleartrip (Flipkart Pvt Ltd)
Sep 2021 - Feb 2022
Pulled, tracked, and analysed key business metrics across various channels (Google, Affiliates, Meta) to monitor product and process performance. Collaborated closely with internal Cleartrip teams and stakeholders to identify critical data gaps and inform data-driven decisions. Conducted deep-dive analysis on booking data based on channels, product, device, segment, and revenue to understand variances and their effect on gross sales. Worked with tools including Google Cloud Platform, Google Ads, Delta-x, Data Studio, and QlikView for reporting and analysis.
Data Analyst
Flipkart Pvt Ltd
Sep 2019 - May 2021
Managed the end-to-end data analytics lifecycle, collaborating with business leadership from data acquisition and cleaning through to final reporting. Executed Performance Data Analysis, including data extraction, transformation, consolidation, and validation from various internal and external sources. Focused on stock views and selling performance for the Top 100 FSNs (Core & Seasonal) across two categories to optimize inventory planning and buying. Initiated the NLC (Net Landed Cost) process for FSNs to facilitate bulk purchasing and managed strategies for old stock with less NLC. Designed and improved existing MIS reports for multiple functions to enable informed daily, weekly, and monthly business decision-making.
Operations Analyst
Azgo (Delectable Technologies Pvt Ltd)
Mar 2023 - Present
Reduced monthly theft by 75% (from ₹4 lakh to ₹1 lakh) by designing and implementing pilferage analysis frameworks based on user and delivery behaviour data. Improved video monitoring compliance from 68% to 89% in 3 months, enhancing operational oversight and loss prevention through data-driven monitoring audits. Managed a network of 623 Vending Machines across major corporate hubs (Flipkart, HCL, TCS), ensuring high uptime and optimal stock availability. Automated the maintenance ticketing system, which reduced machine-related queries by 73% and improved issue resolution time and overall operational efficiency. Analysed real-time sales data using Excel and Metabase to forecast demand, optimize inventory levels, and shift procurement from weekly to monthly, resulting in cost reduction. Automated routine operational dashboards and follow-up workflows, significantly reducing manual tracking and improving team productivity.
Seller Data Operation
Amazon India Pvt Ltd
Jul 2018 - Jul 2019
Spearheaded Data Extraction, Transformation, and Loading (ETL) from different sources and DataMart for comprehensive reporting requirements. Collected, understood, and cleansed data per specific project requirements for quarterly and monthly reporting cycles. Interacted and collaborated with different internal departments and clients to ensure data integrity and project alignment.
Education
B.Sc. Mathematics - Nimapara Autonomous College
- 2016 · Afghanistan
