SWAPNEEL PANDA
Hyderabad
Summary
Dynamic Analytics Professional with over 5 years of experience in data analysis and visualization, driving impactful insights through advanced data science techniques. Proficient in SQL and Python, with a strong focus on developing and optimizing data pipelines, enhancing operational efficiency, training & deploying machine learning models and informing strategic decision-making. Skilled in leveraging tools such as Tableau and Power BI to transform complex datasets into clear, actionable visual reports that support cross-functional collaboration. Committed to continuous improvement and innovation in data management practices, ensuring alignment with business objectives and delivering value across diverse projects.
Overview
6
6
years of professional experience
Work History
Lead Data Analyst
Indium Software
Hyderabad
04.2025 - Current
- Led design and maintenance of advanced data science workflows and pipelines.
- Conducted in-depth analysis of large structured and unstructured datasets to extract actionable insights.
- Collaborated effectively with cross-functional teams to align innovative data solutions with business objectives.
- Transformed complex analyses into impact narratives and visualizations for strategic decision-making.
- Drove product experimentation and metric development to enhance operational performance.
- Built predictive models in Python (e.g., churn prediction, demand forecasting), leveraging scikit-learn.
- Analyzed large-scale event logs, unstructured app interaction data, to drive insights.
- Explored LLM-based solutions for query automation and human-in-the-loop chatbot systems.
SENIOR DATA ANALYST
Indium Software
Hyderabad
11.2023 - 03.2025
- Designed and deployed modular data science pipelines in Python and PySpark, incorporating SDKs to process data at scale with ownership from ingestion to reporting.
- Led advanced analytics on structured and unstructured datasets (clickstream / logs / customer behaviour), applying forecasting and causal inference methods to uncover key growth levers.
- Wrote and optimized complex SQL (CTEs, window functions) on large datasets; improved query runtimes by ~40% and reduced computational costs.
- Conducted product experiment analyses: defined metrics, set up A/B testing frameworks, and advised on feature optimization based on result.
- Built dashboards and visual reports (Tableau, Looker / Google Data Studio), translating data findings into executive dashboards that guided strategic product decisions.
- Managed ETL workflows using SQL CTEs and Python notebooks to automate data transformations and cleaning, delivering reliable datasets for downstream analyses.
- Performed opportunity analyses (e.g., SKU performance, sales trend forecasting), produced insights driving action in operations and marketing.
- Developed interactive dashboards in PowerBI and DOMO; presented to leadership and cross-functional stakeholders, enabling data-driven decisions.
- Ensured data accuracy through schema validation, error detection, and building alerts; maintained version control using Git.
- Designed and analysed A/B tests using causal inference methods to isolate treatment effects on user retention.
DATA ANALYST
Indium Software
Chennai
06.2022 - 10.2023
- Continued using SQL CTE queries to handle complex data management tasks.
- Maintained and enhanced Python notebooks for automation and data analysis.
- Expanded the use of data visualization tools, including Tableau, PowerBI, DOMO, and Google Data Studio, to provide comprehensive insights and reports.
- Focused on creating, maintaining, and deploying data pipelines to ensure efficient data processing.
- Utilized GIT for code management, ensuring robust version control and collaboration.
- Conducted query optimization to enhance performance and efficiency of data retrieval and processing tasks.
- Developed, maintained, and deployed SDK pipelines and other data pipelines, ensuring seamless data flow and processing.
SENIOR BUSINESS ANALYST
Victoria's Secret
09.2021 - 06.2022
- Performed A/B testing on newly launched site campaigns to assess performance and drive continuous improvement.
- Led conversion rate optimization initiatives, identifying and implementing strategies to enhance user experience and increase conversions.
- Continued managing client relationships, focusing on Victoria's Secret, to ensure seamless project execution.
- Documented all project phases, ensuring thorough records and knowledge transfer.
BUSINESS ANALYST
ConvertCart
01.2021 - 08.2021
- Executed complex SQL queries to create and manage data tables.
- Developed Python notebooks to automate data processing and analysis tasks, enhancing efficiency and accuracy.
- Designed and implemented interactive Tableau dashboards to provide actionable insights and support decision-making processes.
- Managed client relationships, ensuring clear communication and understanding of project requirements and deliverables.
- Conducted site surveys to identify opportunities for site modifications and improvements.
SR. ANALYST PROGRAMMER ANALYST
Tech Mahindra
06.2019 - 11.2019
- Built and maintained PowerBI dashboards to generate actionable insights and support business decision-making.
- Utilized PowerBI for advanced data visualization and reporting.
- Documented all project processes and deliverables to ensure comprehensive and accessible project records.
- Managed client relationships, ensuring effective communication and understanding of project goals and outcomes.
Education
Post Graduation Diploma In Data Analytics - Data analyst
Board Of Infinity
Mumbai01.2021
B.E - ME
Government College Of Engineering Kalahandi
Bhawanipatna01.2019
12th -
Kendriya Vidyalaya
Bhawanipatna01.2015
10th -
CBSE
Bhawanipatna01.2013
Skills
- Python and R programming
- SQL database management
- Data classification techniques
- Cluster analysis methods
- Deep learning algorithms
- Decision tree modeling
- Dimensionality reduction
- Random forest analysis
- Regression analysis techniques
- Sampling methodologies
- MS Excel proficiency
- Power BI visualization
- Tableau reporting
- Google Data Studio integration
- SDK pipeline development
- PySpark data processing
Timeline
Lead Data Analyst
Indium Software
04.2025 - Current
SENIOR DATA ANALYST
Indium Software
11.2023 - 03.2025
DATA ANALYST
Indium Software
06.2022 - 10.2023
SENIOR BUSINESS ANALYST
Victoria's Secret
09.2021 - 06.2022
BUSINESS ANALYST
ConvertCart
01.2021 - 08.2021
SR. ANALYST PROGRAMMER ANALYST
Tech Mahindra
06.2019 - 11.2019
Post Graduation Diploma In Data Analytics - Data analyst
Board Of Infinity
B.E - ME
Government College Of Engineering Kalahandi
12th -
Kendriya Vidyalaya
10th -
CBSE