Sajesh Kanhirakkadavath
Senior Data Integrator/ETL Consultant
Summary
Senior Data Integrator/ETL Consultant with 14+ years of experience in Financial domain. Proven ability to lead complex data migration projects,data warehousing projects , design and develop ETL processes and optimize data architectures for performance.
Overview
8
8
years of professional experience
4
4
years of post-secondary education
2
2
Certifications
Work History
Senior Data integrator
Saudi Central Bank
02.2014
- Provided subject matter expertise and design expertise for Investment Data reporting
- Designed and implemented an integration environment and Data mart to process the portfolio data provided by different custodians and reference market datasets provided by Rimes, Refinitiv, ICE and Bloomberg
- Automated amalgamation of data from 170+ daily data feed files into a single, clean dataset for downstream analysis and reporting
- Developed 100+ stored procedures, functions, packages, and triggers to process data and 30+ complex hive queries for business reporting
- Worked with data providers to fill data gaps and/or to adjust source-system data structures to facilitate analysis and integration with other company data
- Successfully delivered 6 major projects and several change requests
- Key achievement: Migrated Legacy manual data load process to an automated integration environment, moving away from an obsolete system and decreasing end user waiting times by up to 80%.
Team Lead
Emirates National Bank of Dubai
03.2012 - 12.2013
- Prepared requirement documents, Business blueprint, functional specifications, technical specifications, test cases and scenarios, defect trackers
- Led the development of ETL processes to transform data from multiple sources into a single, clean dataset for downstream analysis and Payment, AML and Risk applications reporting.
Senior Software Developer
Development Bank of Singapore
02.2010 - 02.2012
- Developed complex multi-Threaded applications to process the data for the measuring, monitoring, controlling and reporting of the structural interest rate risk system DBS QRM.
Software Engineer
Erideon Pvt Ltd, Singapore
11.2009 - 01.2010
Application Developer
Integral Solutions (Asia) Pte Ltd,Singapore
04.2008 - 10.2009
Developer
Phykon Solutions Pvt Ltd,India
06.2007 - 02.2008
Graduate Engineer
KELTRON,India
10.2005 - 05.2007
Education
Bachelor of Technology - Computer Science and Engineering
Cochin University of Science And Technology
06.2001 - 05.2005
Skills
Skilled in data analysis, data requirement analysis and data integration
Technically proficient in C#, Python, VB6, VBA, SQL, PL/SQL, TSQL, SQL CLR, SSIS, BIDS, SAP BODS, SAP SDI, SAP HANA, Oracle, MS-SQL SERVER
Proven ability to lead complex data migration projects, design and develop ETL processes, and optimize data architectures for performanceExpert in RDBMS, Database design, Database programming, Database and ETL Performance TuningDemonstrated experience in developing business intelligence and data warehousing solutionsExpertise in business blueprint, functional and technical specificationsParticipated in all phases of SDLC starting from analysis to delivery of the application development projects and supported enhancements and maintenance of existing applicationsPlayed roles of Developer, Technical Lead & Junior Application ArchitectInnovative business professional with expertise in analyzing business requirements and transforming them into technical solutionsSufficient exposure to Performance and Attribution measurement (equity and fixed income), Portfolio Compliance and Fraud & Money Laundering domains and practicesExpertise in data management and ingestion of various reference market datasets Rimes, Refinitiv, ICE and BloombergManaged multiple projects simultaneously with high efficiency, proactive team player with capability of handling responsibilities independentlyCertification
Microsoft Technology Associate: Introduction to Programming Using Python
Timeline
SAP Certified Associate: SAP Certified Application Associate - Data Integration with SAP Data Services 4.2
04-2021
Microsoft Technology Associate: Introduction to Programming Using Python
10-2020
Senior Data integrator
Saudi Central Bank
02.2014
Team Lead
Emirates National Bank of Dubai
03.2012 - 12.2013
Senior Software Developer
Development Bank of Singapore
02.2010 - 02.2012
Software Engineer
Erideon Pvt Ltd, Singapore
11.2009 - 01.2010
Application Developer
Integral Solutions (Asia) Pte Ltd,Singapore
04.2008 - 10.2009
Developer
Phykon Solutions Pvt Ltd,India
06.2007 - 02.2008
Graduate Engineer
KELTRON,India
10.2005 - 05.2007
Bachelor of Technology - Computer Science and Engineering
Cochin University of Science And Technology
06.2001 - 05.2005