Sumith Kumar Singh profile photo 1 on Tal

Sumith Kumar Singh

Data Analyst @ EY | Analytics & Data Engineering | SQL, Python, Power BI | ETL, Azure Data Factory, Databricks | BI & Automation

Greater Bengaluru Area

2+ years of work experience

EY
Nov 20241 yr 11 mosPresent

Bengaluru, Karnataka, India

• Delivered 10+ data and process automation solutions using SQL, Python, Alteryx, VBA, Power BI, and Azure Data Factory, reducing manual processing effort by 50–70% across global financial reporting and compliance operations. • Engineered a global BEPS Pricing Analytics solution covering 60+ countries, leveraging Power BI, DAX, Power Query, and Azure Data Factory to transform complex financial data into scalable BI solutions and accelerate reporting and review cycles by 40%. • Architected end-to-end ETL and data engineering workflows for data extraction, transformation, cleansing, validation, reconciliation, and integration using SQL, Python, Alteryx, and Azure Data Factory, improving data quality and reducing manual intervention by 30%. • Developed financial analytics and Business Intelligence solutions, including a Foreign Tax Reclaim Dashboard and Rapid Reclaim Analyzer, applying SQL, financial modeling, and complex business logic to identify opportunities, strengthen risk assessment, and reduce analysis time by up to 40%. • Automated complex financial checks and data validation processes using SQL, Python, Alteryx, and statistical analysis, achieving 99% data accuracy and reducing rework cycles by 35% across global entities. • Collaborated with senior global stakeholders and cross-functional teams to gather business requirements, translate business problems into scalable data, analytics, BI, and automation solutions, and establish KPI reporting, data governance, and data quality standards.
Wiingy
Jul 20244 mosOct 2024

Bengaluru, Karnataka, India

• Analyzed revenue, profitability, customer, marketing, and operational KPIs to identify growth opportunities, optimize business spending, and support data-driven decisions across key business functions. • Built interactive Power BI dashboards using SQL and DAX for sales, revenue, lead generation, conversion, and performance analytics, improving visibility into business KPIs and contributing to a 10% improvement in conversion efficiency. • Conducted funnel and cohort analysis using SQL, Power BI, and Google Analytics to understand user journeys, identify conversion drop-offs, analyze customer behavior, and uncover opportunities to improve retention, engagement, and Customer Lifetime Value (CLV). • Developed SEO analytics dashboards using Google Search Console data to track impressions, clicks, search rankings, and organic traffic performance, enabling data-driven SEO optimization and contributing to a 20% improvement in organic search performance. • Built Google Analytics dashboards in Looker Studio to analyze acquisition, user behavior, engagement, and conversion metrics, generating insights that contributed to a 12% increase in user engagement. • Performed data wrangling, validation, visualization, and automation using Python and Advanced Excel, reducing manual reporting effort by 30% and improving data accuracy and efficiency. Applied prompt engineering to streamline analytical and reporting workflows.
Urban Company
Dec 20236 mosMay 2024

Bengaluru, Karnataka, India

• Partnered with cross-functional teams to understand business requirements, identify operational gaps, and translate business needs into data-driven solutions. • Developed KPI dashboards and performance reports that provided actionable insights and contributed to a 15% reduction in operational costs. • Designed Supply Operating Models (SOM) by translating business rules and operational metrics into structured processes, enabling supply teams to operate independently within defined performance thresholds. • Performed root cause analysis (RCA) and analyzed customer experience metrics, including NPS, to identify operational issues and recommend improvements to customer satisfaction and supply chain efficiency. • Used SQL, Excel, and Python for business analysis, data exploration, cohort analysis, reporting, and process automation to support data-driven decision-making. • Collaborated with stakeholders to monitor business KPIs, evaluate process performance, and identify opportunities for operational improvement and automation.
GitHub
@sumith78
YouTubeyoutube.com/@sumithrajput170
Personal portfoliosumith-portfolio.netlify.app

Sumith’s AI Stack

claude code
claude code
cursor
cursor
deepseek
deepseek
gemini
gemini
github copilot
github copilot
notebooklm
notebooklm

Education

Vemana Institute of Technology - Koramangala, Bengaluru

Bachelor of Engineering - BE, Computer Engineering

Vemana Institute of Technology - Koramangala, Bengaluru

20194 yrs2023

Join Sumith and 10k+ other professionals on

Tal Boss

Tal is the app where bosses meet engineers & builders directly, without middlemen

Download Tal Boss

Sumith Kumar Singh on Tal

Headline

Data Analyst @ EY | Analytics & Data Engineering | SQL, Python, Power BI | ETL, Azure Data Factory, Databricks | BI & Automation

About

I'm a Data Analyst with 2.8+ years across operations, finance, and product analytics — using data to find where processes break down, then building the automation and pipelines to fix them at scale. At EY, I've delivered: - 10+ automation workflows (VBA, Alteryx, SQL) cutting manual effort by 50–70% - A global Pricing Analytics solution across 60+ countries (Power BI, Azure Data Factory, DAX) - A Foreign Tax Reclaim Dashboard that earned EY's "Achievers Extraordinaire" award, cutting identification time by 40% - A Rapid Reclaim Analyzer improving opportunity identification by 25% and cutting analysis time by 40% - An automated data validation framework achieving 99% accuracy - Python/SQL automation that reduced rework cycles by 35% Core expertise: - Programming & Data: SQL, Python (Pandas, numpy), PySpark, Databricks, MySQL, PL/SQL - BI & Visualization: Power BI, DAX, Looker Studio - Automation & Engineering: Azure Data Factory, Alteryx, Power Query, ETL pipelines, VBA Macros - Cloud: Azure, BigQuery - Business Analytics: Financial modeling, KPI reporting, cohort & funnel analysis, statistical analysis - Governance & Stakeholder Skills: Data validation & reconciliation, requirement gathering, stakeholder management, cross-functional collaboration What sets me apart: I approach analyst work like an engineer — looking for the pipeline or process to automate, not just the query to run. Currently growing into a Senior Data Analyst / Business Analyst role, with a focus on advanced SQL, requirement gathering, stakeholder management, and scalable analytics engineering. Open to product, fintech, or consulting environments where data drives real business impact.

Location

Greater Bengaluru Area

AI stack

claude code

cursor

deepseek

gemini

github copilot

notebooklm

Work experience

Advanced Data Analyst at EY, Nov 2024 - Present · 1 yr 11 mos, Bengaluru, Karnataka, India, • Delivered 10+ data and process automation solutions using SQL, Python, Alteryx, VBA, Power BI, and Azure Data Factory, reducing manual processing effort by 50–70% across global financial reporting and compliance operations. • Engineered a global BEPS Pricing Analytics solution covering 60+ countries, leveraging Power BI, DAX, Power Query, and Azure Data Factory to transform complex financial data into scalable BI solutions and accelerate reporting and review cycles by 40%. • Architected end-to-end ETL and data engineering workflows for data extraction, transformation, cleansing, validation, reconciliation, and integration using SQL, Python, Alteryx, and Azure Data Factory, improving data quality and reducing manual intervention by 30%. • Developed financial analytics and Business Intelligence solutions, including a Foreign Tax Reclaim Dashboard and Rapid Reclaim Analyzer, applying SQL, financial modeling, and complex business logic to identify opportunities, strengthen risk assessment, and reduce analysis time by up to 40%. • Automated complex financial checks and data validation processes using SQL, Python, Alteryx, and statistical analysis, achieving 99% data accuracy and reducing rework cycles by 35% across global entities. • Collaborated with senior global stakeholders and cross-functional teams to gather business requirements, translate business problems into scalable data, analytics, BI, and automation solutions, and establish KPI reporting, data governance, and data quality standards.

Data Analyst at Wiingy, Jul 2024 - Oct 2024 · 4 mos, Bengaluru, Karnataka, India, • Analyzed revenue, profitability, customer, marketing, and operational KPIs to identify growth opportunities, optimize business spending, and support data-driven decisions across key business functions. • Built interactive Power BI dashboards using SQL and DAX for sales, revenue, lead generation, conversion, and performance analytics, improving visibility into business KPIs and contributing to a 10% improvement in conversion efficiency. • Conducted funnel and cohort analysis using SQL, Power BI, and Google Analytics to understand user journeys, identify conversion drop-offs, analyze customer behavior, and uncover opportunities to improve retention, engagement, and Customer Lifetime Value (CLV). • Developed SEO analytics dashboards using Google Search Console data to track impressions, clicks, search rankings, and organic traffic performance, enabling data-driven SEO optimization and contributing to a 20% improvement in organic search performance. • Built Google Analytics dashboards in Looker Studio to analyze acquisition, user behavior, engagement, and conversion metrics, generating insights that contributed to a 12% increase in user engagement. • Performed data wrangling, validation, visualization, and automation using Python and Advanced Excel, reducing manual reporting effort by 30% and improving data accuracy and efficiency. Applied prompt engineering to streamline analytical and reporting workflows.

Business Analyst at Urban Company, Dec 2023 - May 2024 · 6 mos, Bengaluru, Karnataka, India, • Partnered with cross-functional teams to understand business requirements, identify operational gaps, and translate business needs into data-driven solutions. • Developed KPI dashboards and performance reports that provided actionable insights and contributed to a 15% reduction in operational costs. • Designed Supply Operating Models (SOM) by translating business rules and operational metrics into structured processes, enabling supply teams to operate independently within defined performance thresholds. • Performed root cause analysis (RCA) and analyzed customer experience metrics, including NPS, to identify operational issues and recommend improvements to customer satisfaction and supply chain efficiency. • Used SQL, Excel, and Python for business analysis, data exploration, cohort analysis, reporting, and process automation to support data-driven decision-making. • Collaborated with stakeholders to monitor business KPIs, evaluate process performance, and identify opportunities for operational improvement and automation.

Education

Bachelor of Engineering - BE, Computer Engineering, Vemana Institute of Technology - Koramangala, Bengaluru

Public links

github: https://github.com/sumith78

youtube.com: https://youtube.com/@sumithrajput170

sumith-portfolio.netlify.app: https://sumith-portfolio.netlify.app/