MANASWINI PATTNAIK
Bangalore
Summary
Results-driven data engineer specializing in Python automation and AWS services, with experience at Dish Network Technologies. Achieved a 75% reduction in claims through innovative data analysis and SQL querying. Proficient in Tableau and advanced Excel, delivering actionable insights while collaborating with cross-functional teams.
Overview
8
8
years of professional experience
Work History
Data Engineer
Dish Network Technologies
Bangalore, Karnataka
03.2023 - Current
- Project: Network Development & Analysis for Sites, Regions & Markets
- Write optimized Snowflake and Amazon Redshift code to automate extraction, transformation, and loading of large-scale network datasets, improving query performance and reducing execution time.
- Collaborated with data engineering teams to design data models and optimize ETL workflows, ensuring data integrity and reducing reporting latency.
- Design and implement automated Python scripts to extract drone data, process it using AWS Redshift queries, and store results in S3 for scalable and cost-efficient storage.
- Automate recurring data ingestion and processing workflows using AWS Step Functions and Python, reducing manual intervention and improving data freshness.
- Develop advanced Tableau and Looker Studio dashboards using custom SQL, calculated fields, and parameterized reports to provide actionable insights on network performance across sites, regions, and markets.
- Implemented data validation checks, error handling, and exception monitoring in Python pipelines to enhance data quality and consistency.
- Monitor and troubleshoot AWS services including S3, Instances, and Textract to support operational efficiency, availability, and failure recovery.
- Integrated LLM-powered solutions with Python and SQL workflows to automate data analysis, generate natural-language insights, and accelerate network performance reporting across sites, regions, and markets.
- Implemented Generative AI capabilities to automate report generation, summarize network KPIs and trends, and reduce manual effort in recurring analytics and reporting workflows.
- Presented network performance reports to stakeholders, utilizing metrics, KPIs, and trend analysis to inform business decisions.
Data Analyst
Flipkart Internet Pvt. Ltd.
11.2019 - 03.2023
- Developed NLP model for token extraction from customer responses, identifying key pain points and generating actionable recommendations for stakeholders.
- Wrote complex SQL queries to identify impacted numbers for rewards and retrieve product/customer data across platforms including Myntra, PhonePe, Paytm, and Cleartrip.
- Developed and maintained analytical matrices for brands including Hotstar, ZEE5, YouTube, Times Prime, Myntra, and Storytel to support data-driven decision-making.
- Used R/RStudio with packages including dplyr, stringr, wordcloud, tm, and ggplot2 for detailed analysis and reporting.
- Used Advanced Excel functions including VLOOKUP, HLOOKUP, Pivot Tables, conditional formatting, and other formulas for data analysis and reporting.
- Tested and verified customer data capture and collected Orders, GMV Units, and Revenue metrics using Omniture.
- Exported data for brands including Myntra, Super Coin Pay, PhonePe, and Reward Store using Linux commands and Python scripts.
- Spearheaded process improvements during BBD; despite a 7X increase in rewards claimed, reduced issues/claims by 75% and reduced Q2R from 48 hours to 24 hours.
- Managed Flipkart Plus Control Tower project for Supercoin Pay, enhancing project execution and stakeholder engagement.
- Formulated a pilot A/B testing strategy for extended returns on selected categories, improving Return NPS (RNPS) by 5% for Flipkart Plus.
- Built and ran multi-inventory jobs in Jenkins to calculate live rewards on Flipkart Plus.
- Created Power BI dashboards to differentiate customer reviews for Amazon Prime Video and Flipkart Plus Video and shared impacted-review percentages through social platforms.
Data Analyst
Flipkart (Sellers)
11.2018 - 11.2019
- Performed data analysis and SQL querying, supported management/customer requests, and translated client requirements into deliverables.
- Applied MS Excel automation, data extraction, transformation, and reporting for operational analysis.
- Managed product pricing changes on Flipkart Seller Hub to optimize pricing strategy.
- Executed promotions and approved sellers and vendors within timelines to mitigate potential business losses.
- Utilized troubleshooting, analytical, and creative problem-solving skills to address data-related challenges.
Data Analyst
Innovays Business Services Private Limited
08.2018 - 11.2018
- Executed data extraction, transformation, and manipulation for reporting and aggregation-focused business analysis.
- Created analytical reports using Advanced Excel features including Pivot Tables, VLOOKUP, and charts.
- Conducted data analysis, designed SQL databases, developed queries, and managed deployment processes.
- Created Pivot Tables for data summaries that met client requirements.
Education
Computer Science & Engineering
Biju Patnaik University of Technology
Diploma - Computer Science & Engineering
SCTE & VT
Skills
- Snowflake
- AWS services
- SQL
- Python Automation
- Jenkins
- Tableau – Dashboard Design
- Power BI
- Looker Studio
- Google Analytics
- JIRA management
- ServiceNow
- Gen AI - Basics
- Agentic AI - KIRO
- Nexys One
- Data processing , Data transformation
- Advance Excel
- Google Sheets
Personal Information
Title: DATA ENGINEER
LANGUAGES
English – Fluent | Hindi – Fluent | Odia – Fluent
INTERESTS
Badminton | Fitness | Idea Building | Painting | Travelling | Novel Reading
Accomplishments
- Best Employee of the Year – 2021
- Best Plus Team Performance – Flipkart Plus
Timeline
Data Engineer
Dish Network Technologies
03.2023 - Current
Data Analyst
Flipkart Internet Pvt. Ltd.
11.2019 - 03.2023
Data Analyst
Flipkart (Sellers)
11.2018 - 11.2019
Data Analyst
Innovays Business Services Private Limited
08.2018 - 11.2018
Computer Science & Engineering
Biju Patnaik University of Technology
Diploma - Computer Science & Engineering
SCTE & VT