DINESH KUMAR GUNDRA

Process Description: Project Delivery - iMatch Reconciliations, Business Intelligence

Environment/Tools: Intellimatch 9.2.7, Power Platform, MS SQL Server 2019

• Gathered requirements from client to study feed files, working of manual reconciliation and subsequently assessing feasibility of automating reconciliation to Intellimatch 9.1
• Prepared iMatch Architecture Diagrams, Design Overview, High Level Requirement and Detailed Requirement Specification Document of reconciliations in scope for automation
• Configured complex Cash and Securities reconciliations on Intellimatch via iMatch, Recollector and Admin modules
• Developed intricate SQL stored procedures to build customized reports for end users.
• Produced interactive Power BI reports, Dashboards, Power Pivot and Power View reports.
• Developed enterprise level App using Power Platform suite of tools like PowerApps, Power Automate and Power BI.
• Conducting QA and UAT for reconciliations build and consequently obtaining approval from stake holders by conducting walk-through of reconciliation solution to deploy reconciliation onto production environment

Notable Attainments:

• Awarded title of Contextual Master for building application related to Process, Risk and Controls within the bank.
• Received “On the Spot” award for building banks third most complex reconciliation till date.
• Highly acclaimed for solely building enterprise-wide app using Power Platform suite of tools.
• This application was widely acclaimed for digital transformation initiative that integrated digital technology in all areas of business. Optimized operational continuity by implementing enhanced inventory documentation.

Process Description: Hexad Reconciliations

Environment/Tools : Intellimatch 8.2/9.1, MS SQL Server 2012, MS Visio, JIRA, HP QC 11

• Identified the client/organizational needs and provide suitable agile system based solutions
• Lead and mentored teams using Agile/Scrum practices, facilitate Scrum meetings to remove obstacles
• Guided development teams to break down complex user story into simplified versions for execution
• Prepared reconciliation High Level Matrix and source system inventory for the existing recons
• Analyzed the existing configuration of match models and optimizing the recon build models
• Enhanced and migration of existing recons from Intellimatch 8.2 to intellimatch 9.1
• Ensured optimum utilization of resources and provided capacity planning reports to the clients
• Planned and tracked code migration activities; ensured migrations follow agreed procedures
• Provided visibility in progress by maintaining backlog, burn down charts, velocity analysis, etc

Notable Attainments:

• Successfully Lead the Scrum Team and migrated the Bank wide Depot stream of reconciliation onto iMatch platform.

Process Description : Business Process Modeling

• Evaluated existing business processes . Determined and outlined business process improvements.
• Worked closely with business process owners to design/ implement practical and optimal solutions to complex business problems
• Conducted focus groups, workshops, presenting findings and recommendations to the clients

Process Description : System Integration testing – Asia Receipts Matching

Environment/Tools: Informatica, Kofax, HP Quality Center 11

• Involved in Test plan, Test Strategy, Test Processes, Test Deliverables, Task allocations, monitoring & mentoring team members, Project Estimations, Interaction with client, Resource recruitment, Defect tracking process, prioritizing & assigning defects and Audit management
• Producing project definitions to include validated functional requirements, scope, roles, responsibilities, budgets, timescales and resources
• Responsible for project deliverables from evaluation, conception and completion
• Establishing milestones, anticipating issues, and monitoring adherence to project scope, schedules and requirements
• Preparation and review of Test scenarios and Test scripts
• Identifying the project risks, highlighting it to the stakeholders with possible impact, preparing and implementing the risk mitigation plan
• Recording/maintaining test statistics, providing daily metrics and status updates and signoffs
• Own and manage the testing activities of multiple application and releases throughout its software development lifecycle covering functional, non-functional & regression testing across systems at System Integration Test level and facilitating/coordinating the right level of UAT
• Prepared RFP work plans for proposals and reviewed these with the proposal team

Notable Attainments:

• Successfully delivered 4 major releases for ARM and on boarded 3 clients onto TLM
• Awarded for key contribution as a Test Manager for ARM by Bank of America Merrill lynch.

Process Description: System Integration Testing/User Acceptance Testing - CitiFT NA UAT (Fund Transfer System), Regional Balance Control System (Liquidity Management System) , Payment Flow Management (Payment Reporting System)

Environment/Tools: Global Pay Plus , Paylite, RBCS, PFM , HP Quality Center 11, HP QTP

• Using project management methodologies, principles and techniques to develop project plans to cost, resource and manage project
• Defining and implement communication strategy, Program best practices, standard templates etc
• Acting as a central reference and information source, providing guidance and assistance in the system project decision making process
• Analyzing technical specifications and developing comprehensive test strategies and plans
• Responding to RFPs (Request for Proposal) for the new business opportunities
• Gathered technical requirements from design sessions and translated/simplified requirements
• Skilled in providing functional specifications to the technical team to bring out technical solutions
• Preparation and review of Test scenarios and Test scripts for manual and automation testing
• Handling a span of 24 associates and conducting confirmation/appraisals for team members
• Structured Business Process Model capturing entire E2E functionality for CitiFT for North America

Notable Attainments:

• Successfully lead the team in delivering 3 major releases with zero post production issues.

Process Description : Fixed Income Cash, Repo, Collateral and Prime Brokerage Settlement

Environment/ Tools : Euclid, SQL, UNIX, UML, MS Word, Excel, Power point, MS Visio, TLM

• Responsible for confirmation, trade validations of cash, repo, prime brokerage & collateral reprising
• Processing payments, ensuring client's standing instructions for remittances are carried out
• Assisted change the bank (CTB) projects from concept to delivery
• Involved in all the phases of SDLC and was instrumental in achieving steady state (BAU) of the projects.

Process Description: OTC Credit Derivatives – Confirmation (Matching/Drafting)

Environment/Tools: DTCC, Markit Website, ICE, SQL, UML, MS Word/Excel/Power point, MS Visio

Responsible for ensuring:

• The trade booked in front office booking system matches with what UBS shows on DTCC
• All trades are verbally confirmed with counterparties within T+2 days
• Trades are confirmed in DTCC in a timely manner & investigation of breaks/alleges
• Apart from CDS, confirmations cover structured products such as ABS, CMBS, RMBS, CDO, ABX, CMBX, RMBX, TRX and Swaptions
• Confirmations – Paper / DTCC Drafting
• Responsible for investigating the drafting problem queues when a trade does not flow STP
• Setting up the Static's for new funds, drafting and reviewing of Master Confirmation Agreements
• Managing drafting of the paper docs as per ISDA standards for trades which are not DTCC eligible
• Identifying and resolving the trade booking discrepancies with the front office to ensure that UBS's booking is as per ISDA standards

Notable Attainments:

• Significantly migrated CD Paper Drafting Process from UBS London to Wipro Ltd on Business Visa.
• Recipient of two Process Improvement certifications, involving the automation of setting up the statics for the new clients which improved the accuracy and saved 2 hrs of production time per day
• Featured in UBS Investment Bank News letter for preparing and implementing a PEX project with resulted in the reduction of 2 Full Time Employees.

Process Description : Global Treasury Operation – Payments /Credit Administration - AOC

Responsibilities:

• Handling process deals of the payments which fail certain criteria predominantly due to lack of funds in the clients account with the releasing of the payments
• Coordinating with the Portfolio Managers to obtain the approvals for releasing the payments with insufficient funds in the client account
• Supervising credit facilities assigned to the clients like setting up of new limits to the clients, renewal and maintenance of the credit lines
• Ensuring compliance of, KYC and credit risk management to ensure stable credit portfolios.

Process Description : Global Treasury Operation – Asia Payments

Responsibilities:

• Processing of customer applications via SWIFT to various beneficiaries within the specified time both to local banks as well as overseas banks.
• Payment types such as MT103, MT202,MT191,MT192,MT199 were processed, verified and released.
• Adhering strict compliance with regards to payment processing like OFAC and AML.
  

Key Achievements:

• Transitioned the process of AOC from Bank of America London on a work permit
• Received 2 Six Sigma Automation Certification for the automation of the allocation spreadsheet which resulted in the reduction of one full time employee and automation of direct debit payments.
• Received Bank of America Spirit Platinum Award for 3 consecutive quarters of 2007