Soumya Das
Data professional with 4.1 years as a Data Analyst
Hire this person
Send a job offer directly to this candidate
About
Data professional with 4.1 years as a Data Analyst across e-commerce, manufacturing, and edtech domains. Proficient in SQL, Python, Power BI, Tableau, and Advanced Excel, with hands-on expertise in building automated data pipelines, data modelling, and interactive dashboards. Proven track record of eliminating manual workflows, optimizing business processes, and delivering real-time insights for large-scale datasets (26M+ users).
Experienced in KPI tracking, stakeholder collaboration, and leveraging data-driven insights to drive revenue growth and operational efficiency.
Experience
Data Analyst at Prohuman Technology, Client - Flipkart (2025-06 – 2026-04)
- Developed and maintained WBR Dashboard in Google Sheets tracking daily, weekly, and monthly performance for Plus and Black members.
- Pulled and analyzed data using advanced SQL queries for newly added metrics in the Weekly Business Review (WBR) dashboard, ensuring accurate and timely reporting.
- Independently developed complex SQL queries to deliver ad hoc reports within tight deadlines, supporting business decisions and stakeholder requirements.
- Built interactive Power BI dashboards with drill-down capabilities to visualize key KPIs and provide actionable insights to stakeholders.
- Developed Automated data pipeline using Python scripts on VM and Google Sheets API to execute SQL on FDP (Flipkart Data Platform) successfully eliminated 100% of manual data entry for the WBR dashboard at the backend.
- Created a high-frequency BBD Tracker to monitor daily, hourly and cumulative performance for Plus and TPC 10+ Plus cohorts across all Business Units, with real-time visualization in Power BI Dashboard.
Data Analyst at Infinity Learn (2025-02 – 2025-04)
- Automated weekly, monthly, and quarterly KPI dashboards using Advanced Excel to track student engagement, course completion, and active users, reducing manual reporting efforts by 60%.
- Utilized Python (Pandas) for data cleaning, transformation, and integration into Excel files, ensuring accurate and real-time reporting.
- Analyzed lead funnel performance using Excel, identifying high-converting sources and optimizing campaigns, which led to a 25% increase in qualified leads.
Associate – Business Analyst at Netscribes Data & Insights Private Limited (2024-08 – 2024-12)
- Conducted requirement gathering and analysis for a Tata Group internal web platform by coordinating with stakeholders and end users.
- Prepared comprehensive BRD Documents outlining functionalities such as automated email notifications to relevant Tata employees and event management workflows.
- Collaborated with the technical team to ensure the developed features aligned with the requirements and business expectations.
Data Analyst at Control Print Limited (2021-09 – 2024-08)
- Extracted raw data from the company's database using SQL and processed it for Excel reporting and Tableau Dashboards, displaying proficiency in data manipulation and analysis.
- Prepared and maintained MIS Reports and Sales Dashboard, utilizing SQL, Python, Advanced Excel, and Tableau.
- Developing computationally complex and practical SQL queries, ensuring the delivery of high-quality and accurate insights as per the problem statement asked by the stakeholders.
- Creating insightful presentations in Tableau, contributing to data-driven decision-making, and fostering a culture of informed choices.
- Developed Python scripts utilizing Pandas to automate data cleaning and processing tasks, significantly reducing manual work by 2 hours and increasing workflow efficiency.
MIS Executive at Control Print Limited (2019-06 – 2021-08)
- Created daily, weekly, and monthly MIS reports for sales, operations, and service performance.
- Generated detailed reports for internal review and management decision-making using Advanced Excel, like Pivot Tables, VLOOKUP, SUMIFS, and Conditional Formatting.
Service Trainee at Maruti Suzuki (2016-06 – 2019-05)
- Managed customer service requests, prepared job cards, and provided updates on vehicle repair status.
- Resolved customer queries and helped improve service experience by ensuring smooth communication between customers and workshop staff.
Service Engineer Intern at Ashok Leyland (2015-06 – 2016-05)
- Created job cards for each vehicle by listening to customer complaints, checking the vehicle's past service records, and writing down what work needed to be done before handing it over to the technician.
- Checked each vehicle to understand what service or repairs it needed, explained this clearly to the customer, and provided accurate expected delivery timelines to ensure transparency and customer satisfaction.
Education
B.Tech in Automobile Engineering – Biju Patnaik University of Technology (BPUT) (2011-05 – 2015-05)
