Chandra Prakash Kosaraju
Wakefield
Summary
Expertise in SQL, data warehousing, ETL development, and performance optimization. Solutions-oriented professional with extensive experience in designing and developing data warehouses, ensuring seamless data integration, and creating detailed test cases to validate ETL processes. Strong domain knowledge in banking and finance, adept at transforming complex data into actionable insights. Proven track record in debugging, performance tuning, and resolving data discrepancies. Skilled in developing and maintaining critical interfaces for Vision Plus Systems and Postilion platforms. Expert in managing end-to-end data projects, from requirement analysis to go-live support, ensuring timely delivery and adherence to quality standards. Proficiency in designing, creating, and implementing complex workflows, data flows, and ETL processes. Expert in developing and executing test cases, reconciliation, and release notes for ETL jobs.
Overview
15
15
years of professional experience
Work History
Sr. Data Engineer
Santander Consumer Bank Nordic States
01.2024 - Current
- Led the delivery of the migrating the IICS Mapping into PySpark
- Utilized the PySpark for Data Integration in building the new DWH Platform
- Developed and optimized ETL processes
- Conducted thorough testing, created test cases, and prepared reconciliation and release notes to ensure the validity and reliability of ETL jobs, supporting successful UAT and production implementation
Technical Lead, Sr. Data Engineer
Santander Consumer Bank Nordic States
01.2024 - Current
- Spearheaded the implementation of portfolio securitization mechanisms to enhance liquidity and financing options for companies, leveraging assets to generate income and fund projects
- Conducted comprehensive analysis of project specifications and source systems, developing and optimizing ETL processes to facilitate asset repackaging and collateralization
- Created test cases to validate development, preparing reconciliation and release notes for ETL jobs to ensure accuracy
- Played a pivotal role in defect analysis and resolution, participating in defect analysis calls and contributing to successful UAT and go-live implementations
Sr. Data Engineer
Santander Consumer Bank Nordic States
01.2022 - Current
- Led the delivery of the Basel Data Repository (BDR) as part of the Basel II project for Santander Nordic, ensuring compliance with regulatory standards and corporate requirements
- Developed and optimized ETL processes for the BDR DataMart, facilitating accurate calculation of regulatory capital and variables PD, LGD, and EAD
- Conducted thorough testing, created test cases, and prepared reconciliation and release notes to ensure the validity and reliability of ETL jobs, supporting successful UAT and production implementation
Sr. Data Engineer/Technical Lead
Pinion Services Private Limited
01.2010 - Current
- Led project design, requirement analysis, and source system analysis for multiple ETL and data integration projects
- Coordinated on-site and offshore teams to ensure seamless project execution and delivery
- Developed, tested, and optimized ETL workflows using tools such as SAP BODS, Informatica, AWS, PySpark, EMR and SQL Server Integration Services (SSIS)
Sr. Data Engineer
Santander Consumer Bank Nordic States
01.2021 - 01.2022
- Oversaw the implementation of the New Definition of Default Engine (NDD Engine) for IFRS9 at Santander Consumer Finance Nordics, ensuring compliance with European Banking Authority (EBA) regulations
- Utilized Informatica Intelligent Cloud Services (IICS) for Data Integration and MS-SQL Server 2016 to adapt databases to EBA guidelines, enabling daily default identification and tracking of days past due
- Conducted thorough requirement analysis, ETL development, testing, and optimization, creating test cases and documentation for validation and release
- Led UAT and production implementation, providing support and defect analysis to ensure successful project delivery
Sr. Data Engineer
LahiTapiola Rohoitus Finland
01.2020 - 01.2022
- Spearheaded the implementation of portfolio securitization mechanisms to enhance liquidity and financing options for companies, leveraging assets to generate income and fund projects
- Conducted comprehensive analysis of project specifications and source systems, developing and optimizing ETL processes to facilitate asset repackaging and collateralization
- Created test cases to validate development, preparing reconciliation and release notes for ETL jobs to ensure accuracy
- Played a pivotal role in defect analysis and resolution, participating in defect analysis calls and contributing to successful UAT and go-live implementations
Technical Lead
Santander Consumer Bank Nordic States
01.2020 - 01.2022
- Led project lifecycle from understanding project design specifications to ETL development, testing, and optimization
- Developed test cases ensuring the validity of development and prepared reconciliation and release notes for ETL jobs
- Conducted unit testing, created UTP and UTR, and provided support to SIT & UAT testing teams
Technical Lead
Santander Consumer Bank Nordic States
01.2018 - 01.2020
- Led project lifecycle includes design, requirement analysis, source system analysis, ETL development, and testing
- Developed various test cases to ensure development validity, preparing reconciliation and release notes for ETL jobs
- Conducted unit testing, created UTP and UTR, and supported SIT & UAT testing teams
Data Engineer /Technical Lead
Santander Consumer Bank Nordic States
01.2017 - 01.2020
- Developed SAS programs to validate data integrity post monthly loads, ensuring accuracy and reliability
- Functioned as an onsite coordinator, actively participating in project design, requirement analysis, source system analysis, ETL development, testing, and optimization
- Generated various test cases to validate development, prepared reconciliation and release notes for ETL jobs
Data Engineer /Technical Lead
Santander Consumer Bank Nordic States
01.2017 - 01.2018
- Generated solution documents for diverse interfaces within the Data Warehouse (DWH), ensuring clarity and coherence in project implementation
- Acted as an onsite coordinator, actively contributing to project design specification, requirement analysis, source system analysis, ETL development, testing, and optimization
- Developed a variety of test cases to validate the robustness of development efforts, while also preparing reconciliation and release notes for ETL jobs
Technical Lead
Santander Consumer Bank Nordic States
01.2017 - 12.2017
- Acted as an onsite coordinator for the Basel Data Repository (BDR) project at Santander Nordic, ensuring compliance with Basel II IRB-A regulations for calculating regulatory capital
- Conducted comprehensive project design specification, requirement analysis, source system analysis, ETL development, testing, and optimization
Technical Lead
Santander Consumer Bank Nordic States
01.2017 - 12.2017
- Led the upgrade of SAP Business Objects Data Integrator (BODI) version 3.2 to SAP Business Objects Data Services (BODS) version 4.2 SP8, ensuring seamless migration of ETL workflows
- Installed BODS 4.2 SP8 using IPS and upgraded data stores from SQL 2008 to SQL 2014, while upgrading the repository using Data Services Server Manager
- Acted as an onsite coordinator, handling project design specification, requirement analysis, source system analysis, ETL development, testing, and optimization
Education
Bachelor of Technology - Computer Science & Engineering
Jawaharlal Nehru Technological University
Skills
- Data Warehousing
- ETL Development
- SQL Programming
- Performance Tuning
- Data Migration
- Business Intelligence
- Data Governance
- Data Transformation
- Scripting & Automation
- System Troubleshooting
- API Integration
- Compliance & Regulatory Reporting
- Machine Learning Integration
- Process Improvement
- AWS
- PySpark
- EMR
- Git
- SAP Data Services (BODS)
- Informatica Intelligent Cloud Services (IICS)
- SQL Server Integration Services (SSIS)
- SQL Server Analysis Services (SSAS)
- SQL Server Reporting Services (SSRS)
- Power BI
- SAS
- Jira
- MSBI
- Data Integrator XI/122
- Postilion Server
- Postilion Real Time
- Postcard
- Postilion Office
- Transaction Manager
- Visa Test Simulator (VTS)
- MasterCard Test Stimulator MAS
- POS devices
- SIMPLICITY
- ASCERT test simulators
- INSYNCH
- FILE-AID
- CHANGE MAN
- OPC
- BETA92
- BETA93
- Enterprise Data Warehouse (EDW)
- Data Integration Platforms
- Vision Plus Systems
- SQL
- Data Warehouse Concepts
- ETL Concepts
Core Proficiencies
- Data Warehousing
- ETL Development
- SQL Programming
- Performance Tuning
- Data Migration
- Business Intelligence
- Data Governance
- Data Transformation
- Scripting & Automation
- System Troubleshooting
- API Integration
- Compliance & Regulatory Reporting
- Machine Learning Integration
- Process Improvement
Timeline
Sr. Data Engineer
Santander Consumer Bank Nordic States
01.2024 - Current
Technical Lead, Sr. Data Engineer
Santander Consumer Bank Nordic States
01.2024 - Current
Sr. Data Engineer
Santander Consumer Bank Nordic States
01.2022 - Current
Sr. Data Engineer
Santander Consumer Bank Nordic States
01.2021 - 01.2022
Sr. Data Engineer
LahiTapiola Rohoitus Finland
01.2020 - 01.2022
Technical Lead
Santander Consumer Bank Nordic States
01.2020 - 01.2022
Technical Lead
Santander Consumer Bank Nordic States
01.2018 - 01.2020
Data Engineer /Technical Lead
Santander Consumer Bank Nordic States
01.2017 - 01.2020
Data Engineer /Technical Lead
Santander Consumer Bank Nordic States
01.2017 - 01.2018
Technical Lead
Santander Consumer Bank Nordic States
01.2017 - 12.2017
Technical Lead
Santander Consumer Bank Nordic States
01.2017 - 12.2017
Sr. Data Engineer/Technical Lead
Pinion Services Private Limited
01.2010 - Current
Bachelor of Technology - Computer Science & Engineering
Jawaharlal Nehru Technological University
Similar Profiles
Maciej CiubaMaciej Ciuba
FX Expert, Technology Consultant, Senior BA at Santander Consumer And Investment BankFX Expert, Technology Consultant, Senior BA at Santander Consumer And Investment Bank
Karen MateoKaren Mateo
Relationship Banker at Santander Consumer USA BankRelationship Banker at Santander Consumer USA Bank
Clayton GeorgeClayton George
Senior Collections Agent at Santander Consumer USASenior Collections Agent at Santander Consumer USA
Kian McQuadeKian McQuade
Police Constable at West Yorkshire PolicePolice Constable at West Yorkshire Police
Charlie GiovincoCharlie Giovinco
Executive Chef at Hyatt Regency Boston HarborExecutive Chef at Hyatt Regency Boston Harbor