Jayanthi Manickam Sethu

Key Contributions:

• Improved operational efficiency through automation and data modeling.
• Delivered critical support for database migrations and system enhancements.
• Enhanced reporting accuracy and speed with advanced query optimizations.

Client Product and Profitability(2020-Present)

Expense Calculation: Managed data preparation, job monitoring in Airflow, and built models and cubes using SAS Cost and Profitability Management Tool.
Migration Testing: Actively contributed to Oracle to Hadoop migration testing.
Client Hierarchy System: Provided technical expertise by developing complex Oracle stored procedures for Asset Servicing.
Reporting Support: Assisted the reporting team with optimized queries in Oracle and Hive.
Process Automation: Automated a business report using Python (pandas, NumPy), reducing processing time from 1.5 hours to 20 minutes per cycle.

Overall Achievements:

• Proficient in Oracle 12c, Informatica 10.1, and end-to-end development cycles.
• Delivered impactful solutions through optimization, platform migration, and data integration.
• Recognized for leadership, mentorship, and delivering high-quality results on critical business initiatives.

CTT Data Platform (2017 - 2020)
Objective: Unified database architecture for tracking deal and loan workflows across life cycles.
Key Contributions:
Developed ETL processes integrating diverse data sources.
Conducted unit testing, coordinated UAT, and managed production migrations.
Delivered post-production support for smooth operations.
Impact: Centralized data model streamlined tracking and reporting for business processes.

CIT Profitability Analysis (2016 - 2020)
Objective: Revenue analytics and reporting across regions, segments, and client types.
Key Contributions:
Built ETL mappings with complex business logic and integrated multiple data sources.
Facilitated testing, production deployments, and issue resolution.
Impact: Provided a consolidated revenue dashboard, enhancing insights.

Transtar Migration (2017 - 2019)
Objective: Upgrade platform from Delphi to Java and migrate databases to the cloud.
Key Contributions:
Adapted queries for database changes and enabled data access through REST services.
Executed testing, production migrations, and post-production support.
Impact: Ensured compatibility and scalability with updated technologies.

Debt Service Engine (DSE) (2011 - 2017)
Objective: Payment system handling high-value transactions for BNY Mellon's Corporate Trust.
Key Contributions:
Designed tables, developed backend logic, and generated reports.
Optimized batch job performance, reducing processing time significantly.
Mentored team members and ensured delivery of assigned tasks.
Impact: Enhanced system reliability for processing $60 billion in daily transactions.

Key Contributions:

• Played a critical role in integrating and streamlining network fault management systems.
• Ensured efficient fault detection and information flow for quick resolution.

Project: INMS (Integrated Network Management System)
Client: Verizon, USA
Objective: Monitor network elements, detect faults, generate alarms, and facilitate fault rectification based on network topology.
Responsibilities:
Developed an adapter using Core Java as part of the IP Convergence initiative, merging two surveillance systems.
Integrated the system with SMARTS, a subtending system for network surveillance, to receive and process alarms for the Common Fault Handling (CFH) system.

Overall Contributions:

• Proficient in Java, J2EE, JSP, EJB, JSF, and Oracle 9i for creating robust banking solutions.
• Delivered critical modules for core banking, loan processing, and payment systems.
• Enhanced business operations through optimized workflows and rigorous testing practices.

Project 1: CORE BANKING-PANACEA (KCCB, Gujarat)
Objective: Develop a centralized core banking solution connecting 400+ branches and a data center.
Responsibilities:
Designed web forms using JavaScript, JSP, and JSF.
Developed business logic with J2EE design patterns and EJB.
Created reports using iReports and stored procedures in Oracle.
Conducted manual unit testing and domain functionality testing.

Project 2: KOSOVO ENTERPRISE PROGRAM (KEP Trust)
Objective: Support microfinance operations for small enterprises, marginalized groups, and agriculture through loan processing systems.
Responsibilities:
Built web forms with JavaScript, JSP, and JSF.
Developed business logic and applied J2EE design patterns.
Generated reports and tested functionalities.

Project 3: PROPHESY (Trade Finance Solution, Catholic Syrian Bank)
Objective: Implement trade finance modules (remittances, contracts, guarantees) in a core banking solution.
Responsibilities:
Used Java Server Faces (JSF) with MVC design patterns.
Developed beans with Java technology and EJB patterns.
Created test cases and reports while ensuring high functionality standards.

Project 4: LOANFLO (HDFC)
Objective: Streamline loan processing workflows from application to disbursement.
Responsibilities:
Created web forms using JavaScript and JSP.
Generated reports with iReports and conducted workflow-based testing.

Project 5: ENTERPRISE PAYMENT SYSTEM (Laser Soft Infosystems)
Objective: Enable real-time gross settlement (RTGS) for interbank fund transfers and customer payments in compliance with RBI standards.
Responsibilities:
Developed web forms and user interfaces using JavaScript and JSP.
Authored unit test cases and ensured seamless system functionality.