SWAPNEEL PANDA
Hyderabad
Summary
Dynamic analytics professional with over 5 years of experience in data analysis and visualization, dedicated to driving impactful insights through advanced data science techniques. Expertise in SQL and Python, with a strong emphasis on developing and optimizing data pipelines to enhance operational efficiency, as well as training and deploying machine learning models to inform strategic decision-making. Proficient in utilizing tools such as Tableau and Power BI to transform complex datasets into clear, actionable visual reports that foster cross-functional collaboration. Committed to continuous improvement and innovation in data management practices, ensuring alignment with business objectives while delivering value across diverse projects.
Overview
7
7
years of professional experience
Work History
Lead Data Analyst
Indium Software
Hyderabad
04.2025 - Current
- Engineered and sustained robust data science workflows and pipelines, ensuring seamless data integration and analysis.
- Analyzed significant volumes of structured and unstructured data to identify trends and generate actionable recommendations.
- Coordinated efforts with cross-functional teams to integrate innovative data solutions that support business objectives.
- Converted intricate analyses into clear narratives and visualizations, facilitating informed strategic decisions.
- Designed and implemented product experimentation frameworks and metrics to elevate overall operational performance.
- Designed and implemented predictive modeling solutions in Python, leveraging scikit-learn to optimize target forecasting processes.
- Interpreted large-scale event logs alongside unstructured app interaction data to identify trends and enhance user experience.
- Analyzed LLM-driven approaches for automating queries and integrating human oversight in chatbot systems.
- Evaluated and refined queries, models, and dashboards for junior analysts, resulting in enhanced analytical quality and operational efficiency.
- Developed and implemented training programs for new hires, focusing on SQL and Python proficiency.
- Led data analysis initiatives to enhance decision-making processes across multiple departments.
- Led the migration of legacy systems to modern platforms, resulting in reduced maintenance costs and increased operational efficiency.
- Championed the adoption of agile methodologies within the analytics team, improving project delivery times and overall productivity levels.
SENIOR DATA ANALYST
Indium Software
Hyderabad
11.2023 - 03.2025
- Managed end-to-end data processing workflows in Python and PySpark, from data ingestion to reporting, enhancing overall data pipeline efficiency.
- Interpreted complex datasets to extract actionable insights on customer behavior, facilitating informed decision-making for business growth.
- Evaluated large datasets to construct and enhance SQL queries, resulting in significant improvements in runtime efficiency and cost management.
- Performed in-depth analyses of product experiments, implementing A/B testing frameworks to improve feature effectiveness.
- Designed comprehensive data visualizations and reports that highlighted essential metrics and trends, enhancing executive-level strategic planning.
- Implemented data cleaning and transformation techniques using SQL CTEs and Python notebooks, enhancing dataset integrity for subsequent analytical tasks.
- Achieved improved data accuracy by implementing proactive schema validation error detection and establishing alert mechanisms. Enhanced project management efficiency through effective version control practices with git.
- Analyzed data through hypothesis testing and regression analysis to identify key variables affecting business performance.
- Analyzed experimental data through rigorous A/B testing methods, confirming statistical significance and reliability of outcomes.
- Engaged with product engineering and operations to identify and measure product success metrics, driving strategic alignment across initiatives.
- Investigated data trends to uncover significant contributors to membership attrition and renewal drops, informing strategic enhancement initiatives.
- Designed and managed detailed SQL queries, focusing on efficient data extraction and comprehensive analysis.
- Implemented data-driven strategies to optimize business intelligence processes and support informed decision-making.
- Analyzed complex data sets to identify trends and insights, driving informed business decisions.
- Developed interactive dashboards using Tableau to visualize key performance indicators for cross-functional teams.
DATA ANALYST
Indium Software
Chennai
06.2022 - 10.2023
- Implemented SQL CTE queries to address intricate data management challenges effectively.
- 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.
- Analyzed large datasets to identify trends, delivering actionable insights for business strategies.
- Developed and maintained interactive dashboards using Tableau to visualize key performance indicators.
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.
- Analyzed sales data to identify trends, enhancing strategic decision-making processes.
- Collaborated with cross-functional teams to gather requirements and define project scope.
- Analyzed business processes to identify inefficiencies and recommend improvements.
- Developed data-driven reports to support decision-making and strategic planning initiatives.
- Led workshops to facilitate stakeholder engagement and align on project objectives.
- Implemented process optimization strategies, enhancing operational efficiency across departments.
- Utilized advanced analytics tools to extract insights from large datasets for business growth.
- Drove initiatives that improved customer experience through targeted recommendations based on user behavior analysis.
- Developed high-quality documentation to support training efforts, helping employees fully understand new systems and procedures.
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
Tech Mahindra
Bhubaneswar
06.2019 - 11.2019
- Crafted and maintained Power BI dashboards, enabling comprehensive data analysis and strategic decision-making.
- Implemented Power BI to enhance data visualization and reporting capabilities, supporting strategic decision-making.
- Developed an organized system for project documentation to facilitate quick access to critical information.
- Nurtured client relationships, facilitating effective communication and transparency regarding project aims and deliverables.
- Interpreted complex datasets to support data-driven decision-making and streamline operational processes.
- Interpreted complex data sets to identify trends that guide strategic planning and decision-making.
- Oversaw cross-functional initiatives to drive process improvements, resulting in enhanced operational efficiency.
- Analyzed complex data sets to identify trends and drive strategic decision-making.
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
- Proficient in Python and R
- Proficient in SQL database operations
- Random forest data analysis
- Quantitative regression analysis
- Power BI dashboard creation
- Tableau dashboard creation
- Experience with Google Data Studio integration
- Building efficient SDK pipelines
Languages
English
Bilingual or Proficient (C2)
Hindi
Bilingual or Proficient (C2)
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
Tech Mahindra
06.2019 - 11.2019
B.E - ME
Government College Of Engineering Kalahandi
Post Graduation Diploma In Data Analytics - Data analyst
Board Of Infinity
12th -
Kendriya Vidyalaya
10th -
CBSE