Sagar Zadpe

• LQM (Liquidity Monitoring)

Details:

• LQM is used by Cash Management Operation to Manage bank's cash balance with central clearer (Direct participant or it's Nostros to control flow of transactions against banks liquidity pool, to ensure timely settlement on behalf of clients or manage balance and reduce overdraft charges.

Role:

• Designed data models for complex analysis needs.
• Managed multiple high-profile projects, delivering accurate and timely results under tight deadlines.
• Audited existing databases, identifying opportunities for improvement and recommending actionable steps for optimization.
• Developed scripts and processes for data integration and maintenance.
• Reduced server load by implementing partitioning strategies that optimized storage allocation and resource usage.
• Streamlined data processing workflows, reducing system bottlenecks and improving overall efficiency.

FROGs (Fair Value Rule based Override GUI System)

Detail:

• FROGs is use by product controller to assign fair values and DNA mapping to trades. Certain reports are generated to analyze trade flow to submit it to regulator..
• FROGs maintain static data into Oracle 12c database and actual trade data is stored on AWS (S3 bucket). Models are written into Python and R to fulfill business requirements.

Role:

• Develop python models as per business requirement and creating PLSQL functions to store meta data into oracle database.
• For strategic Implementation, created several flask micro services to accomplish file based architecture.
• Implemented CICD pipeline to involving automated unit testing and Docker Container deployment for flask micro services.

CCAR (Comprehensive Capital Analysis and Review)

Details:

• Comprehensive Capital Analysis and Review (CCAR) is annual exercise by Federal Reserve to ensure that institutions have well-defined and forward-looking capital planning processes that account for their unique risks and sufficient capital to continue operations through times of economic and financial stress.

Role:

• Developed PL/SQL code and integrate with R and Python wrapper to showcase data on dashboard also coordinate with client and business analyst to generate report as per business logic.
• Managed database deployment and implemented CICD for database deployment by using Liquibase framework.
• Participates in SDLC including client requirement discussion, Daily Scrum, functional testing, QA approval and production release in Agile framework.

Acquiring and Merchant Service

Details:

• MasterCard has built Acquiring Module for many banks to process credit, debit, and prepaid card payments on behalf of merchant. This module provides various functionality like Dispute procession, Dynamic currency conversion and UPI processing.

Role:

• Developed Packages, PL/SQL-Procedure, Functions, and Triggers for auto updating of attribute values. Tune SQL queries to fetch data from database for generating reports. Coordinate with client and business analyst to generate report as per business logic.
• Gathered and defined customer requirements to develop clear specifications for project plans.
• Adjusted design parameters to boost performance and incorporate new features.

EOS

Detail:

• Risk Management group of HSBC bank has requirement to build application which forecast profit and loss of bank in different sector. Certain reports are used for regulatory purpose.

Role:

• Developed PLSQL code to fetch data from database for generating reports as per business requirements.
• Evaluated diverse organizational systems to identify workflow, communication and resource utilization issues.
• Prepared detailed reports on updates to project specifications, progress, identified conflicts and team activities.
• Communicated technical development stages and provided design support to businesses and other stakeholders encouraging participation for on-time execution.
• Conducted regression testing, analyzed results and submitted observations to development team.

Cypress Insurance Group (US)

Detail:

• Cypress Policy Admin System is designed for Cypress Insurance Group. This system helps in creation of Quote proposal, Declarations, Policy and Premium calculation for homes and commercial properties of Texas and Florida citizens, their payments monthly, Quarterly, Half yearly and Yearly periods through Online and batch programs.

Role:

• Developed Packages, PL/SQL-Procedure, Functions, and Triggers for auto updating of attribute values.
• Reviewed project specifications and designed technology solutions that met or exceeded performance expectations.
• Prepare weekly report for related Project & send to Manager.