Santosh Kumar Yadav
System Analyst
Mumbai,MH
Summary
Dynamic IT professional with over 10 years of experience in the finance and banking sector, specializing in data architecture, sourcing, integration, and change management. Expertise in designing large-scale ETL solutions that seamlessly integrate multiple source systems and a strong command of database concepts. Proficient in implementing BI reporting architectures and providing strategic recommendations for reporting technologies, with a proven ability to resolve complex production issues across various tiers of the BI/DW technology stack. Skilled in managing all phases of the Data Warehouse and Business Intelligence lifecycle, from requirement analysis to solution implementation, while effectively prioritizing tasks in high-pressure environments.
Overview
14
14
years of professional experience
1
1
Certification
3
3
Languages
Work History
Manager - Finance BIU Data Engineer
HDFC Bank Ltd
07.2015 - Current
- Working as a Data Engineer and managing Retail Asset, Retail Liabilities finance DataMart of the bank, Wholesale, Alco and ALM vertical ensuring correct and timely data feed to the scheduled Dashboards and MIS reports.
- Participating in project planning sessions with senior managers, business analysts to analyse business requirements and outline the proposed solution.
- Analysis, Design and Development of various Data Migration projects using SAP BODS and SSIS tool.
- Extensively worked on BODS Administration Tasks like Repository Configuration, Job Server configuration, Local Repository configuration.
- Designing and developing project documents for implementing change requests in ETL jobs, SSIS packages, dashboard, SAP BO reports and tables as per business needs.
- Creating ETL batch job using various transform available in bods to ingest data from heterogenous sources like Netezza, IBM DB2, Oracle, Sql, xls, csv and flat files into target as per BRD and FRD, first in UAT environment and then moving it to Production environment after user’s sign off.
- Scheduling, monitoring and troubleshooting of ETL and SSIS jobs.
- Creating dashboard using SAP BO, WEBI and Tableau as per business requirement.
- Performance tuning of BOBJ reports by optimization of report queries.
- Optimizing, debugging and testing SQL queries for better performance.
- Testing developed ETL jobs and Dashboard on UAT environment and moving to production.
- Troubleshooting of dashboard related issues.
- Good knowledge & experience in Data Warehouse, MS-Excel and MS-Word, JIRA.
- Experience of solving complex problem and working with team members from different cultures.
- Project Details-CFX(Corporate Foreign Exchange)
- All foreign exchange deals are booked in this system which is an intra-net based online system designed for Foreign Exchange Corporate dealers in Citibank. It provides functionality for booking a deal, automating the deal booking & deal tree maintenance.
- Generating reports using Business Objects as a reporting tool.
- Making Daily, Weekly, Monthly, Quarterly and Adhoc Reports as per the end-user requirement.
- UAT and Production Testing for the reports and solving the bugs.
- BRD, FRD preparation for any new MIS needs.
- Good knowledge in writing process flow diagram, use & test cases.
Senior Software Engineer
NUCSOFT LTD. (CITIBANK N.A.)
04.2012 - 07.2015
- All foreign exchange deals are booked in this system which is an intra-net based online system designed for Foreign Exchange Corporate dealers in Citibank. It provides functionality for booking a deal, automating the deal booking & deal tree maintenance.
- Generating reports using Business Objects as a reporting tool.
- Making Daily, Weekly, Monthly, Quarterly and Adhoc Reports as per the end-user requirement.
- UAT and Production Testing for the reports and solving the bugs.
- BRD, FRD preparation for any new MIS needs.
- Good knowledge in writing process flow diagram, use & test cases.
Education
B.E. - Computer Science
University of Mumbai
01.2011
Higher Secondary School Certificate - undefined
Maharashtra Board
01.2006
Secondary School Certificate - undefined
Maharashtra Board
01.2004
Skills
SAP BODS expertise
Accomplishments
- Achieved TAT improvement of 4 days for Retail Liabilities DataMart, Retail Asset and Wholesale APR release for reporting to end users by implementing optimization methods in SAP BODS ETL jobs, database, tables and SQL queries.
- Resolved critical production issues related to ETL application and SAP BO reports which helped in saving extra cost from SAP vendor.
- Implemented migration project of ETL jobs, BO Reports and databases on a new production environment
- Delivered data purging project by deleting obsolete/unused data from 20 TB server which helped in saving 2 TB data space on server
- Successfully delivered 3 data migration projects.
- Winner of Tableau contest, Silver Star and Extramiler Award for BIU department.
Certification
Azure Data Fundamentals
Declaration
I hereby declare that the above details are true to the best of my knowledge and I bear the responsibility for the correctness of the above-mentioned particulars.
Timeline
Azure Data Fundamentals
09-2023
Manager - Finance BIU Data Engineer
HDFC Bank Ltd
07.2015 - Current
Senior Software Engineer
NUCSOFT LTD. (CITIBANK N.A.)
04.2012 - 07.2015
Higher Secondary School Certificate - undefined
Maharashtra Board
Secondary School Certificate - undefined
Maharashtra Board
B.E. - Computer Science
University of Mumbai