Madhusudan Sivva

Citi's Issuer Services Workstation is a single point of entry application portal in Custody Business which supports Agency & Trust, Profile, CARS, Citidirect for Securities, Admin Workstation, MIFT etc . Applications receive and process various types of data feed managed by Operations globally and maintain in the data warehouse for transaction processing and reporting system.

• SME of Application, Redesigned ETL framework with Ab Initio, Talend, Created Reporting platform with Cognos
• Worked with Business, gathered, documented the requirements, Developed Various reports and automated with Cognos Analytics for Operations which saved time and reduced manual work by 75%
• Conducted in-depth performance analysis and reported key metrics to Operations driving huge improvement in operational efficiency
• Implemented new data visualization techniques, enhancing report clarity and stakeholder understanding, leading to more informed decision-making
• Analyzed and processed structured and unstructured data from multiple sources resulting in improved data quality and reliability.
• Developed number of Talend Jobs, joblets and reusable components to load multi million records into DW
• Developed Periodic reports for Management, Operations, Technology and Prod support
• Created number of shell scripts
• Managed a large database migration project with SQL Server 2019

Worked on Kirkland's ETL Data migration project. Responsibilities include reviewing DataStage jobs, understanding Business rules, creating Business and Technical Documents, and developing Talend ETL jobs which process multi-million records and various reports.

Lead and managed Agile Application Development with a team of ETL professionals handling data analysis, building data feeds for reconciliation of CRM and SAP for different business areas.

Worked on integrating Gene, Cell, Nucleic Acid, Protein and Antibody biomolecules Data with Talend, Big Data, Structured and Non-Structured Data sources

Worked on the project to integrate and automate the process using Talend ETL with Salesforce and REST services

• Worked the Project to replace Java parsers, AbInitio ETL with Talend ETL to lower the licensing and maintenance cost and for better performance and customizable framework
• Also worked on creating various reports for Operations and clients using Cognos.

Worked as Technical Specialist / Project Lead and involved in all stages of Software Development Life Cycle (SDLC) for Corporate Action platform using vendor product Xcitek Solutions Plus (XSP / SunGard) since inception.

• Responsible to Develop Data Extraction and Loading process with Ab Initio ETL

Worked as Technical Specialist and implemented Corporate Action Platform with XSP 4.5 with Industry leading CA Vendor Product Xcitek Solutions Plus (XSP).

Worked on the Client Data Integration Layer (CDIL) Application, providing Ab Initio ETL services to different Business areas within the Securities and Fund Services (SFS) Business.