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
Goa04-2023
Bachelor of Science - Computer Science
S.G.T.B Khalsa College, Delhi University
Delhi03-2021
High School Diploma -
Bal Bhavan Public School
Delhi03-2017
High School Diploma -
Bal Bhavan Public School
Delhi03-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
Ethan SewellEthan Sewell
Personal Banker at NatWest GroupPersonal Banker at NatWest Group
Virag NemethVirag Nemeth
Human Resources Graduate at NatWest GroupHuman Resources Graduate at NatWest Group
Gayathri RajamohanGayathri Rajamohan
Risk and Controls Assurance Analyst at Natwest GroupRisk and Controls Assurance Analyst at Natwest Group