Summary
Overview
Work History
Education
Skills
Websites
Certification
Timeline
Generic

Sarthak Kumar Bal

Summary

Dynamic data professional with a proven track record in designing and managing robust data pipelines, quality frameworks, and interactive dashboards. I streamline processes, enhance data integrity, and drive operational efficiency while saving significant resources. I excel in identifying and resolving complex data issues, developing comprehensive data lineage and quality reporting solutions. A collaborative and agile thinker, I thrive on continuous improvement and innovative problem-solving, that empower stakeholders and support strategic decision-making.

Overview

3
3
years of professional experience
1
1
Certification

Work History

Data Analyst (Retail Banking-Data Management)

NatWest Group
06.2023 - Current
  • Managed and Oversaw Data Quality:
    Leveraged SQL on Snowflake, Athena (AWS), and Hadoop to manage data pipelines for retail products. Collaborated with cross-functional teams and communicated effectively to ensure data accuracy, consistency, and robust governance.
  • Analyzed Fail Data on Quality Metrics:
    Conducted granular analyses of failure data to pinpoint key SQL logic issues and data inconsistencies. This critical, data-driven investigation led to actionable insights that refined SQL logic and improved overall data quality. Built strong relationships with stakeholders and incorporated constructive feedback
  • Created Comprehensive Data Quality Report:
    Designed and implemented a one-stop solution for business stakeholders to monitor data quality scores for Critical Data Elements. By integrating thresholds, targets, and flexible filters (e.g., Data Owners), the report empowered informed decision-making, and fostered a culture of continuous improvement.
  • Developed Data Lineage Documentation:
    Authored 12 comprehensive data lineage documents to streamline root cause analysis and ensure end-to-end traceability across systems. Took ownership of this initiative, aligning with a “One Bank” philosophy.
  • Led Strategic Data Governance Projects:
    Spearheaded projects to elevate data governance and improve score metrics (e.g., Retail Maturity Index).

Data Scientist Intern

Pfizer Pvt. Ltd.
Mumbai
04.2022 - 08.2022
  • Designed interactive Tableau Dashboards for emerging Asia (7 markets), showcasing strategic reporting for sales projections, data reconciliation, and forecasts across 200+ SKUs
  • Onboarded new markets (Hong Kong & Taiwan) for data reporting platforms, ensuring seamless integration and alignment with global asset management systems
  • Developed and implemented 10+ VBA macros to streamline revenue impact reporting, data consolidation, and inventory holding processes, improving workflow accuracy
  • Saved efforts equivalent to 50 man-hours monthly & the project was given a Bold move recognition
  • Provided actionable insights by designing dashboards to analyze Profit & Loss in 3 markets, reconciling discrepancies and ensuring data completeness for key stakeholders
  • Following the successful run for the above markets, we deployed this Dashboard to the APAC region giving better visibility to planners & suppliers

Education

MBA - Big Data Analytics

Goa Institute of Management
Goa
04-2023

Bachelor of Science - Computer Science

S.G.T.B Khalsa College, Delhi University
Delhi
03-2021

High School Diploma -

Bal Bhavan Public School
Delhi
03-2017

High School Diploma -

Bal Bhavan Public School
Delhi
03-2015

Skills

  • Data utilization
  • Tableau software
  • Database management
  • Query languages
  • Technical analysis
  • Verbal and written communication
  • Data analysis
  • Snowflake, Hadoop, Athena, Neo4j
  • SQL, Python, and Excel programming

Certification

  • SQL Intermediate Exploratory Analysis, DataCamp, 2024
  • Neo4j Fundamentals, Neo4j, 2024
  • Excel Basics for Data Analysis, IBM, 2022
  • Introduction to ChatGPT and GenAI, DataCamp, 2024

Timeline

Data Analyst (Retail Banking-Data Management)

NatWest Group
06.2023 - Current

Data Scientist Intern

Pfizer Pvt. Ltd.
04.2022 - 08.2022

MBA - Big Data Analytics

Goa Institute of Management

Bachelor of Science - Computer Science

S.G.T.B Khalsa College, Delhi University

High School Diploma -

Bal Bhavan Public School

High School Diploma -

Bal Bhavan Public School

Similar Profiles

CREATE PROFILE
Sarthak Kumar Bal