SHASHANK SHEKHAR SINGH
Hyderabad
Summary
Analytical and results-driven Data Analyst with over 3 years of experience in transforming complex datasets into actionable business insights. Technically proficient in SQL, Python, Power BI, DAX, Tableau, and Zapier, with proven experience in data analysis, data modeling, DAX calculations, and dashboard development. Delivered data-driven business solutions by developing interactive dashboards tracking real time performance of SLA initiatives worth $ 4.2 Bn, optimizing ETL pipelines, and translating business requirements into actionable analytical models. Identified $15M in missed transactions through anomaly detection using SQL on Databricks, improving financial accuracy and operational transparency. Automated 300+ weekly work hours by streamlining repetitive workflows with Zapier, considerably enhancing process efficiency and reporting timeliness. Holds an M.Tech. in Industrial Engineering from IIT Delhi and a B.Tech. in Production and Industrial Engineering from IIT Roorkee, with a strong foundation in statistical modeling and process optimization. Recognized for strong problem-solving, attention to detail, and stakeholder communication, enabling effective collaboration and delivery of impactful data insights.
Overview
3
3
years of professional experience
1
1
Certification
Work History
Business Associate
Accordion India
Hyderabad
11.2022 - Current
- Designed, built, and maintained robust data models and ETL pipelines using SQL and Python, ensuring scalability, consistency, and reliability across reporting systems.
- Developed and deployed interactive Power BI dashboards for a U.S.-based D2H client to track real time performance of the SLA initiatives worth $ 4.2 Bn in terms of financial performance, outlook, milestones, jeopardies and disputes, providing actionable insights for executive leadership.
- Collaborated cross-functionally to translate business requirements into analytical frameworks, leveraging complex DAX calculations, Smartsheet automation, and data modeling to deliver actionable insights and improve decision-making precision.
- Automated and streamlined recurring workflows through Zapier, optimizing operational efficiency and saving over 300+ work hours per week while enhancing process accuracy.
- Provided thought leadership to the team to understand the business requirements and execute the project as per client requirements.
- Managed client engagement on a tactical level, understanding their clear business requirements and pain points and delivering the outputs.
Senior Business Analyst
Accordion India
Hyderabad
11.2022 - 12.2024
- Validated, modularized, and optimized Python scripts on Databricks, leveraging anomaly detection techniques to uncover $15M in missed transactions, considerably improving data accuracy and financial tracking.
- Supported a high-impact customer retention project for a leading U.S.-based D2H service provider, providing actionable insights that strengthened client engagement and churn management strategies.
- Directed and executed comprehensive data analysis initiatives aimed at enhancing operational efficiency and cost optimization across key business processes.
- Collaborated with cross-functional business teams to define and refine KPIs and performance metrics, ensuring alignment with organizational objectives and reporting standards.
Education
M. Tech. - Industrial Engineering
Indian Institute of Technology
Delhi06-2019
B. Tech. - Production and Industrial Engineering
Indian Institute of Technology
Roorkee06-2016
Skills
- SQL
- Python for Data Analysis
- Power BI
- Tableau
- Excel
- Data Analysis & Visualization
- Business Intelligence & Reporting
- Data Modeling
- ETL Pipelines
- Process & Workflow Optimization
Certification
- Power BI Data Analyst Associate, Microsoft, 2024
- SQL for Data Science, Coursera UC DAVIS, 2025
- Programming for Everybody Specialization, Coursera Michigan, 2022
- Machine Learning, Coursera Stanford, 2022
Languages
English
Full Professional
Hindi
Native or Bilingual
Personal Information
Date of Birth: 11/22/94
Core Competencies
SQL, Python for Data Analysis, Power BI, Tableau, Zapier, Effective Communication, Adaptability, Quick learning, Teamwork, Problem Solving and Critical Thinking
Timeline
Business Associate
Accordion India
11.2022 - Current
Senior Business Analyst
Accordion India
11.2022 - 12.2024
M. Tech. - Industrial Engineering
Indian Institute of Technology
B. Tech. - Production and Industrial Engineering
Indian Institute of Technology