Gaurav Sappal

Interac payments AWS cloud migration

• Enabling migration of Interac inbound and outbound payments from legacy system to AWS cloud.
• Mapping data from MT 103 to Pacs.008 format for customer payments.
• Designing SaaS solution for end of day reporting for new ISO20022 MX messages for wires and existing Interac e-Transfer messages reports (ECMU, EMCD, ECCX).
• Created mapping documents to Include additional payment information (remittance data) for Interac e-Transfer and remittance advice for outgoing Wires.

TDS Payments Modernization

UI Design| API| User Stories |Use Cases|Payments|ISO20022|MT-MX

• Analyzed XML, JSON data schema to enable developers to build API swagger documentation and testing the end points. Mapped payment messages from MT to Internal format to XML to JSON.
• Enabled MX ISO20022 through an API end point for a payment channel for payments to customers
• Worked and managed entire SDLC lifecycle, requirement management lifecycle, technical documentation, consultation to developers, testing and UAT.
• Delivered high quality BA artifacts ensuring accuracy of the business requirements documentation to mitigate against project changes and reduce/manage cost to the project.
• Responsible for facilitating requirements sessions and design sessions with multiple stakeholders, gathering and eliciting requirements, writing user stories, creating story maps, conducting scrums, maintaining JIRA Kanban boards, and sprint planning.
• Responsible for gathering and eliciting business requirements through workshops, interviews etc., analyzing, documenting and getting timely approvals on business and system requirements from stakeholders.
• Maintained full requirements traceability and work with the business to prioritize requirements and scope changes to ensure business needs are met.
• Achieved successful system deployments by coordinating cross-functional teams throughout all stages of development.
• Utilized data visualization techniques to present and explain complex data sets.

High Value Payment Modernization

• Integrating orchestration layer, Payment engine, posting system, sanction Screening, and AML to generate data stream to be consumed by Azure DB for API based receivable reporting tool. Worked with solution architect to design flow.
• Supported integration of Kafka Topic to listen to stream of posting data.
• Enabled MX ISO20022 for a high value payment channel for outbound Swift payments to domestic and international banks Integrating Wallstreet FX with an API
• Designed and implemented web based solution for end of day reporting for new ISO20022 MX messages. Mapped payments to Azure DB for API call to display data on the UI.
• Successfully planned and migrated high value payment channels from shared payment server to dedicated high value payment server.
• Responsible for trade finance channel migration to updated version of transaction manager to adopt new SR2021 messages.
• Managing multiple high value payment channels migration from legacy payment system to modern system.
• Evaluated financial and system feasibility of integration and adoption of new payment engine replacing 40 year old legacy system.

• Performed impact analysis, GAP analysis , analyzed data to assess business and financial feasibility of adopting new digital technologies.
• Use comprehensive SQL queries to extract data from various tables and compare actual results from application, translate data into meaningful visual insights using analytic and reporting tools such as Tableau.
• Creating end to end test scenarios and cases, tracking issues to resolution and facilitating UAT with customers.
• Conducted thorough analyses of client requirements, translating them into actionable project goals and objectives.
• Implemented advanced analytics techniques to identify trends, patterns, and anomalies in complex datasets.
• Ensured data quality by implementing robust validation procedures and addressing inconsistencies proactively.
• Leveraged advanced SQL skills to conduct in-depth data mining for the purpose of uncovering previously hidden insights.
• Developed customized reports, summarizing and presenting data in visually appealing format.

• Designed and implemented multiple data analytics and Payment’s solutions for major Singapore and US banks.
• Modernization of payment engine to process inbound and outbound Swift wires.
• Conducted feasibility analysis to adopt ISO20022 MX format for payment wires.
• Conducted cost benefit analysis to adopt new payment engine to process inbound and outbound domestic and international Swift wires.
• Planned and conducted scoping, requirements definition and prioritization activities for enhancements and new developments related to automation, development and integration of solutions in waterfall and hybrid methodologies.
• Collaborate with development team and architects to provide recommendations to support requirements and design, testing plans, artifacts/deliverables to ensure business needs are met Ensure project issues and concerns are addressed for clear articulation of business requirements.

• Mapped and facilitated setup and integration of data analytical system with our enterprise system to provision production of data and management reports maintaining 20 years of historical data.
• Performed market analysis to identify gaps in existing similar products and effectively liaising with various stakeholders and clients to effectively use feedback to influence product decisions.
• Effectively collaborate with different teams such as the Product team, Development, Creative design, diagnostic consulting to brainstorm ideas, provide end to end analysis and appropriate recommendations to build IP research solutions.
• Created artifacts like business requirements documents (BRDs), Functional Requirement Documents (FRDs) and other documentation.
• Assisted key stakeholders in preparing the business case and project management plan and schedule
• Evaluating business processes and uncovered areas for improvement, and later on developed and implemented solutions and used Fishbone analysis.