Senior Manager/Lead Product Consultant - Technical
Cognizant
مجموع سنوات الخبرة :19 years, 2 أشهر
Currently working for the client State Street (SSBT) - USA, as overall Technical Delivery Manager and Architect to manage end to end reconciliation onboarding using TLM Premium, with the team of 10 offshore and 2 onshore members.
OTC CFD and IM Recon migration from Legacy Platform (DHUB) to TLM Premium with team size of 10
Sep 2019 - Till Date - Toronto, Canada
• OTC CFD (Contracts For Differences) and IM (Investment Management) Funds Migrations from DHUB platform to TLM premium.
• Position, Corporate Action, Profit and Loss and ETD reconciliation delivery using STI Provided Proofing model for both CCY and Asset Level.
• Data Feed integration with 4 source systems DHUB, MCH, DEH and FDR using Message Queues for ledger, broker and NAV feeds.
• Ledger Data Refresh functionality integrated in TLP with complete audit, Versioning and Auto PIT Proof process including auto approval.
• Customization in proofing model to include Tolerance Models (Zero/Standard and Client Specific), BPS/Capstock calculation using NAV values.
• One TLP screen to track overall reconciliation status by management - oversight dashboard implementation.
• Total ETD portfolio reconciliation proofing that covers Cash balances, Positions, Dividends and Profit and Loss Data Values
• Asynchronous AUTO PIT Proof process to avoid manual intervention using custom control process and schedulers as per SLAs.
• Position Recon Implementation for Fidelity client with exception management. Adjustment reports are sent dynamically to client as per the coding done by reconcilers. Custom control process is defined to extract the adjustments and send over to downstream Message Queue, that further reach to client via SFTP.
• Delivered using Agile methodologies picking one epic for each reconciliation.
Hedge Funds (AIS) Recon migration from Legacy Platform (RecXpress) to TLM Premium with team size of 12
Aug 2016 to Aug 2019 - Quincy, Boston, USA
• Worked with STI vendor to get the custom proofing reconciliation model that suits as per the legacy platform, to perform proofing with approval workflow. The proofing models include for Cash, Positions, Corporate Action, Profit and Loss and ETD (combination of Cash, Position and Dividends)
• Day Zero process implementation for Cash Recon Migration
• Customization to the proofing model, introduction of data refresh functionality and versioning for Ledger data.
• Data connectivity for Ledger (GLS), Broker feeds and asset register feeds, using SFTP.
• Proof Exception Storming and aging, along with bulk exception notes, custom reason, resolutions and ops notes.
• Asset Register config for business unit specific territory code and custom bulk manual asset register upload option.
• Delivered using Agile methodologies picking up bunch of clients for each epic, covering around 25 clients.
• Static Migration Utility enhancements to handle custom static information to achieve data refresh and proofing models.
• Managed the changes to SOC, SOP and SOT mapping templates to extend the list of attributes required for new Business Units.
• TLP Upgrade from TLM Premium 2.6 to 3.x, coordinate business users to perform regression testing and support business checkout activities.
• Team Lead for all recon development team, to manage new reconciliation onboarding, changes to existing recons
• Swift standard yearly release - Analysis of yearly swift standard release on functional & non-functional impact on Rec tool. Mainly for (MT940, MT950, MT535, MT536, MT300, MT320, MT330, MT970 & MT608) - SR 25 and SR 28.
• IFAC - Investment Fund Act Compliance, daily position reconciliation implementation.
• TLP Integration with LAZAR (Audit Management System) and MIS (Management Information System).
• Ownership on TLP/SQL components review and prepare release packs.
• Production Release management - collaborate with QA, Business and Environment team.
• Team Lead for all recon development team, to manage new reconciliation onboarding, changes to existing recons
• Swift standard yearly release - Analysis of yearly swift standard release on functional & non-functional impact on Rec tool. Mainly for (MT940, MT950, MT535, MT536, MT300, MT320, MT330, MT970 & MT608) - SR 25 and SR 28.
• IFAC - Investment Fund Act Compliance, daily position reconciliation implementation.
• TLP Integration with LAZAR (Audit Management System) and MIS (Management Information System).
• Ownership on TLP/SQL components review and prepare release packs.
• Production Release management - collaborate with QA, Business and Environment team.
• Collaborative project with SmartStream to implement TLM Premium 2.1 for CIBC, to migrate Cash and Position recons from SSR to Premium.
• Worked with SmartStream development team to deliver matching configurations, dashboards, user views in TLM Premium 2.1 using SmartStudio and Recon Admin.
• Unit test the components for Cash and Position recon, and demo to business users.
Worked as Senior Manager - IT Projects, to handle end to end reconciliation migration/onboarding projects using SmarStream TLM 2.1 (For GL Recs), Questor (home grown recon application) and other supporting tools to improve user workflow processing times and adhere to audit compliance.
• Cash General Ledger Reconciliation migration from manual to TLM 2.1 for the clients GE Commercial Finance and GE Money.
• Lead the vendor team members to track all development activities across projects using JIRA.
• Business User Testing, Signoff, release activities and production support using SNOW tickets.
• Review the TLM components - KB changes, Dashboard configuration, Match Rules and BLTs.
• Work with reporting team - business objects, to consolidate the SQL scripts to retrieve the reporting data from TLM Database.
• Implemented home grown recon application Questor for multiple clients with the user base between 25 to 50.
• Lead the team to deliver any custom changes required in the application framework using Microsoft ASP and SQL Server.
Worked as consultant from SQL International to Genpact, for GL Recon Implementation and develop all business processing support tools using Microsoft Visual Basic, ASP and SQL Server
• Improved the process automation the process for New Hires, Trasfers and Sliding in GE Payroll, using Visual Basic scripting. The program interacts with Payroll Mainframe system and performs all activity as per the input file/mail and generates the output report of performed actions. This improved 2 FTE in the process to handle all these activities manually
• Implemented the tool Image Uploading and Capturing to perform invoice processing for the clients GE Amersham, GE Edwards and GE Security, using Microsoft Visual Basic and SQL Server
• Trained on SmartStream TLM 2.1 and part of GE Commercial Finance GL Reconciliation Implementation
Worked as Microsoft developer to build health care product modules using Microsoft Visual Basic, Oracle and .Net technologies
• Implemented LAB QC module to validate the equipment quality by applying Westgard rules and Youden plot at Hinduja Hospitals, Mumbai.
• Deployed OPD, Billing, Wards, Doctor Desk modules and support at Yashoda Hospitals, Hyderabad.
• Enhanced payroll module, implementing multi-currency cash collection and voucher generation, deployed for the client Nairobi Hospitals, Kenya.
• Developed shared library using Microsoft DLL (Dynamic Link Libraries).
• Generating reports and integration using Crystal Report Application Programming Interface (API).
• Interfacing with Lab Equipment using custom interface application library and visual basic object interfaces.
Worked as Software Engineer to build travel booking product modules using Microsoft Visual Basic, Oracle and .Net technologies
• Develop ticket booking screens using Visual Basic 6.0 and Oracle.
• Integrate billing using Crystal Report.
• Deploy the components at client locations and schedules demos to end users.
Master in Computer Science
-B.Sc. in Computer Science and Electronics