Nishant Mahapatra
Streetsville,ON
Summary
I am a techno-functional leader with over 17 years of demonstrated history of working in Capital Markets, AML, Private Banking, Insurance, Technology and Retail business segments in Canada & international. Rich Industry experience and work ethics gained by working for clients such as TD – Canada, Scotiabank-Canada, Manulife- Canada, RBC – Canada, Microsoft-USA, ASDA Stores Pvt. Ltd-UK, Walmart – USA Global AML – Strong industry experience in KYC – Customer Risk Rating & Transaction Monitoring subject areas. Currently working in AML Business team as Capability Owner of Customer Risk Rating within TD Bank. Cloud Data Migration (Azure) – Migration of Global AML Applications of TD Bank (Enterprise) to Azure Cloud, hands on, broad knowledge of key Cloud components & capabilities including Data & platform. BIG Data Migration for RBC Insurance legacy platforms data into Big Data Lake for IFRS 17 requirements. Business Analysis for Robotics Process Automation using BluePrism for RBC Investor & Treasury services & Investments Middle office (Capital Markets). Business Analysis for MAXIMIS – Accounting platform BAU production project for MANULIFE – Back office (Capital Markets) Asset Management. Software development for ASDA’s (UK) daily sales reporting for executive level, WALMART’s (USA) product Catalog application, major platform integration project for MICROSOFT (USA). Strong communication, consulting & critical thinking, presentation skills, adaptable to change & latest best practices in the technology industry.
Overview
17
17
years of professional experience
1
1
Certification
Work History
Project Manager (Capability Owner)/ GAML CRR Business Operations/ GAML Azure Cloud Migration
TD – Enterprise | Data Platforms – Azure Cloud , OFSAA
07.2021 - Current
- Leading group of 12 Business Information Management Specialists in GAML's Customer Risk Rating program.
- Responsible for CRR Model enhancements, calibration, impact assessment due to new changes, defects.
- Responsible for managing changes pertaining to audit, model risk management, risk assessment.
- Managing CRR AOS reporting for executive's dashboard, e.g. – open report, Line of Business report, orphan report, etc.
- Documentation of all CRR processes including collaboration with consultants for Target Operating Model, Governance documentation, RACI matrix, KPI-KPIs for CRR.
- Cross training between teams for CRR Scoring, Entity resolution process, reference data management.
- Product owner for CRR BAU fixes, Defects, technology JIRA dashboards.
- Actively leading important meetings with GAML Advisory, Model Risk Management, Financial Investigation Unit and TD executives for CRR change management, Model Risk Management, defect triage, project pipeline and planning.
- Striving on honest & crystal-clear communication with executives, staying abreast with the latest technological trends in AML & data in reporting and AI space to keep the program in amalgamation with fast paced Industry.
- Project – AML CRR Business Application Change Delivery (Financial Crime Risk Management)
- Location – Downtown, Toronto
- Environment – Oracle – OFSAA – OAS, FCCM, SharePoint.
Project Manager Azure Cloud Migration
TD – Enterprise | Data Platforms – Azure Cloud , OFSAA
07.2021 - Current
- Conducted functional and technical requirement gathering and planning for migrating Global Anti Money Laundering’s (GAML) Enterprise Customer Risk Rating (ECRR) & Transaction Monitoring applications to Microsoft Azure Standardized and Curated zones and data out to downstream.
- Successfully migrated 27 GAML legacy applications to Production curated zone (Enterprise Data foundation) of TD’s enterprise Azure cloud for Enterprise Customer Risk Rating (ECRR) downstream application.
- Successfully on boarded customer and account transaction attributes for Transaction Monitoring project on EDF.
- Led a group of 8 BSAs, 10 Developers, 8 Quality Testers for fast & effective execution of Data migration & transformation on cloud.
- Led working group meeting for extensive project planning based on priority, complexity, availability of applications to onboard to Azure cloud.
- Cross functional collaboration with IT, Operations support, Business for seamless cloud integration, deployment and maintenance.
- Strong knowledge of Azure cloud architecture includes deployment of VMs, Storage Accounts, Terraform refactoring, RBAC and PIMs access controls, Network security flow logs, Data Bricks dashboards, data retention strategy, Synapse.
- Consulting for Data preparation, movement between EDF (Azure Curated zone) to Common Staging Area and OFSAA in Oracle.
- Privacy data assessment and classification, Ingestion and Outgoing data templates, Source to Target Mapping template, Functional and Non-Functional requirements.
- Collaborated with Application Owners, Data Owners, Product Owner, and Subject Matter Experts to understand current state and downstream requirements to help data modeler for the design of Curated zone and analysts to build mappings.
- Collaborated with Development, Quality testing – SIT, PAT Testing teams to onboard application(s) files to Azure cloud production.
- Assisted Test Data Management team with test data preparation, classification, masking, and quality requirements.
- Provided support for downstream GO-LIVE for CRR Application from the Cloud Curated zone – Actively on top of any production issues related to data movement from Azure curated zone to downstream, source data remediation.
- Supported Data Modelling to add Key Data Elements into the Enterprise model. Profiling source data to aid the model.
- Project – Azure Migration – Enterprise Data Foundation - GAML – Customer Risk Rating, Transaction Monitoring
- Location – Downtown, Toronto
- Environment – MS Azure – Data Bricks, Synapse, MS-SQL, Confluence, JIRA, ServiceNow
Manager - Requirements
Scotiabank - Global Banking & Markets
05.2020 - 07.2021
- Managed group of 6 Business Analysts in Scotiabank – GBM (Global Banking & Markets) Trade Confirmation Hub system for international trading platforms
- Conducted requirements planning & gathering, working group sessions with Business stakeholders & technology team
- End to End system support and enhancement for Confirmation Hub utility for International Trading Platforms pertaining to MUREX- FX, FI; LATAM; PEAK - Bond Forwards/Swaps.
- Automation of MUREX MEXICO Securities (Fixed Income & Treasury) for Trade Affirmations and Confirmations using Xceptor in the Confirmations Hub Utility team for Scotia Capital Markets Digital factory.
- New Trade Affirmation and Confirmation hub design catering to new trading projects.
- Kanban, User Story tracking and maintenance in JIRA. Handled Sprint Planning and Retrospective meetings.
- Project design and solution documentation in Confluence.
- Project – Confirmations Hub Utility – MUREX – Trade Automations
- Environment – Xceptor - Confirmation Hub, Elasticsearch, PL-SQL, JIRA, Confluence, ServiceNow
ScrumMaster/Business Systems Consultant – TD Personal Banking
TD – Personal Banking | Technology Solutions
11.2019 - 05.2020
- Business Analysis & Requirement gathering for TD Future ready initiative – Moving to Big Data enterprise – AKORA Data Lake – Host project road map meetings with stakeholders & IT, Current state analysis, future state change planning, created BA requirement documents (BRD, FSD), hosted workshops and interviews.
- ScrumMaster for TD Future ready Advice Scorecard project – Personal Banking.
- Host Daily sprint, Backlog grooming sessions, Sprint retrospective sessions and weekly stand-up meetings for the project.
- Manage deliverables of working group teams – Business, IT, Intelligent Automation, Dashboard owner with timely updates in JIRA.
- Helped project management team to create the Project roadmap and design strategy (wireframes) for moving the banking data from SQL server-based platform to AKORA Big data lake.
- Update Tableau scorecard (monthly & weekly dashboard) for upgrades/changes connecting to multiple live sources using Joins and linked servers (large datasets) of TD Personal Banking.
- Conducted Data lineage using Talend Data Catalogue for flow of data from legacy source applications to AKORA Data Lake.
- Team member in creating the ETL Strategy for onboarding banking data into NAS drive (landing zone) and to data lake.
- Consulted with RPA Automation team for PDF render and automation using Python.
- Analyzed and documented the required data to be brought into the Tableau reporting data model, what data needs to be shown on the report and what data can be parked in the data model for future usage.
- Project – TD Personal Banking – Advice Scorecards
- Location – Downtown, Toronto
- Environment – JIRA, Confluence, MS-SQL, Tableau, Talend
Senior Business Systems Analyst – Robotics Process Automation
RBC – Investor & Treasury Services
07.2018 - 10.2019
- Performed business process analysis (process mapping) for automating manual business processes for RBC finance.
- Lead creation of AS-IS process flows using MS Visio (current state) after understanding processes being done manually by financial analyst.
- Automated workflows for processes involved in Asset & Cash management & Fund Accounting.
- Automated workflows for Treasury system implementation automation capabilities with detailed study of end to end architectural and design workflows.
- Created TO-BE process flows using MS Visio for automating, enhancing, de-scoping the captured processes current state.
- Created detailed Click by Click (detailed process specification) required for system design and development of system automation using BluePrism RPA.
- Worked on a Scrum environment with timely updates of the processes in RALLY.
- Project – RBC I&TS – Robotics Process Automation
- Role – Senior Business Process Analyst
- Environment – MS Visio Professional 2019, BluePrism RPA, Rally (Agile)
Senior Business Systems Analyst – IFRS 17
RBC – Investor & Treasury Services
07.2018 - 03.2019
- Led a team of 3 BSAs for Requirements gathering for implementing IFRS 17 solution in RBC Insurance.
- Requirement gathering - Prepared Use Case diagrams, BRD, process flows, Metadata, Business Rules for moving existing RBC Systems of Record to Data foundation (Hadoop Data Lake)
- Supported end to end solution design and architecture with key inputs from requirements perspective.
- Identified business data to be brought into data lake for each System of Record, analyzing data to eliminate redundancy.
- Tracked project delivery for each System to be moved to Data Lake in JIRA – Uploading requirement artifacts, key emails, sign off documents, metadata templates, sample data files and updated status in timely manner to ensure productivity.
- Classified RBC Systems of Record data into RBC Internal/Sensitive/Confidential/Restricted data and working with RBCI Business and Data & Analytics team on the encryption strategy for the sensitive information to be brought into Insurance Data Lake.
- Liaised with the external Vendor owning systems to decide on extraction and retention strategy for the Data Lake.
- Extensive use of VB Macro (Advanced MS Excel) for source data comparison (data mapping) from the Insurance legacy applications.
- Supported Advanced Analytics team to leverage SAS framework for creating integrated risk models & hierarchy into unified data lake to cater to Credit risk.
- ETL Architecture to prepare Insurance data to data lake.
- Project Team – RBC Insurance – IFRS 17
- Role – Senior Business Systems Analyst – HADOOP Data Lake
- Environment – MS Office, MS SQL Server, VISIO, JIRA
Business Systems Analyst / Project Manager – Global Service Delivery, IT team – Capital Markets – Asset Management
Manulife Financial
11.2016 - 06.2018
- Supported Manulife’s admin & accounting book of records – SS&C’s Maximis Application. As a Business Systems analyst, I designed and implemented key projects and application upgrades for Maximis Asset Management.
- Owned all the discretionary work requests, projects, enhancements subjected to Maximis application.
- Extensive day to day experience on Data analysis, extraction, and data cleansing for the backend Oracle database for Maximis Accounting application. Owned all the major enhancements for data setup for Fixed Income and Equity assets in Manulife and asset and cash management processes.
- Played a key role to add Senior credit loan (short-term private bonds – bank loan) functionality to Maximis, working with various upstream/downstream teams to incorporate the new functionality in Maximis which includes feed file changes, data setup, pricing at master level/sub loan level, posting rules, changes in Maximis database views for downstream.
- Conducted project review sessions, obtain signoffs, Gap analysis and coordinated acceptance tests to ensure timely delivery of requirements.
- Automated the Daily Pricing upload process in UAT testing by creating a suitable pricing template for the business users.
- Managed annual Maximis application upgrade as Project Manager with the following deliverables:
- Created & updated the Business specifications, scope, estimated efforts, resource planning and allocation.
- Liaised with SS&C(vendor) for providing package fixes in delivery requested by Manulife for the upgrade.
- Hosted weekly project stakeholder meetings, weekly vendor meetings, daily status meetings for efficient planning & tracking of the project
- Review of vendor code delivery (Linux modules, Website modules, hot fixes)
- Owned the QA systems for testing & delivery
- Played a crucial role in Implementation planning, engaging all teams in implementation support of the upgrade
- Project Team – Maximis - Asset Management - Investments Back office, IT Service delivery
- Role – Business Systems Analyst + Project Manager
- Environment – Oracle, PL/SQL, MicroStrategy, Linux, Informatica ETL, XML, ServiceNow, JIRA, PPM, SharePoint, CAWA Scheduling tool, MS Office, Visio, VBA
Business Analyst – Capital Markets Practice team
Atos - Syntel Pvt. Ltd
10.2014 - 11.2016
- As a business analyst, I provided techno-functional solutions for transforming and re-engineering financial institution’s legacy AS-IS landscape, conforming to strategic business initiatives, aligned with Industry standard best practices
- Extensive knowledge in Asset & Cash Management, Accounting, Risk & Regulations for Banks, Treasury management system implementation.
- Enhanced Syntel’s in-house Data Quality product ‘SmartData’. This was a regular source and target data matching tool which we enhanced into a full-fledged data quality suite by adding features of Data enrichment, cleansing, standardization, and Business Rules based Data framework.
- Showcased expert level skills in analyzing, defining, and prioritizing the business requirements, functional specifications and operational architecture for projects aligned to Data Management, Trade processing and back-office applications.
- Domain: Capital Markets (Investments Back Office), Asset Management, Risk & regulatory reporting
- Environment: MS Visio, MS Office, SharePoint, Informatica Data Quality, PL/SQL, VBA
Software Developer/ Lead Solution Architect – Data warehousing & BI Practice team
Cognizant Technology Solutions Pvt. Ltd
09.2008 - 10.2014
- Served as Onsite Tech Lead for the project in Leeds, United Kingdom leading the Reporting track team of 5 and gathered requirements and provided estimation for the BI data model and SSRS Reports.
- Solution Design for Reporting data model, Report templates, layouts, and formatting.
- Conducted Source system data analysis, data mapping and data quality check for reporting needs.
- Development of SSRS Reports - Development of 8 Static Reports & 2 Dashboard Reports, deployment of SSRS reports using Reporting services Deployment utility.
- Client 2: ASDA Stores Pvt Ltd.
- Project Name: Daily Sales Report Automation
- Role: Project Lead (BI), Onsite lead Developer
- Location: Leeds, United Kingdom
- Environment: Tableau, SSRS, SSIS, PL/SQL, JIRA, Visio, Data quality – SSIS, VBA, XML, Data Structures
Software Developer/ Lead Solution Architect – Data warehousing & BI Practice team
Cognizant Technology Solutions Pvt. Ltd
09.2008 - 10.2014
- Design, development & deployment of cubes using Microsoft SSAS 2008.
- Led the design, development, deployment & maintenance of Reports/Dashboards using Microsoft SSRS 2008 and PPS server.
- Client 1: Microsoft
- Project Name: Project Unity - Microsoft Enterprise Services
- Role: Software Developer (DW-BI)
- Location: Bangalore, India
- Environment: SSIS, SSRS, PL/SQL, Microsoft SharePoint Server 2007, MS PowerPivot 2010, JAVA Scripting
Education
Bachelor of Engineering - undefined
RV College of Engineering
Bengaluru, IndiaSkills
- Capability Owner – AML-KYC (Customer Risk Rating) business operations – Financial Crime Risk Management
- Led solution design & delivery for major data migration and transformational Cloud, BIG Data, Data Warehousing, Reporting/Analytics, and application Upgrade projects
- Capital Markets – MO (Trade affirmation/Confirmations), BO (Accounting & Asset Management), Investor & Treasury services; AML
- Retail Markets – Shipping, Product Catalogue, Pricing
- Project Roadmap, Project planning & design
- Requirement Gathering – Business, System requirements –, Data quality, Architecture
- Liaison with Stakeholders, PMO, Development, Testing, Systems support & Vendor teams
- RDBMS – SQL Server, OFSAA (FCCM), OAS
- Big Data/Cloud – MS AZURE, Hadoop Data Lake
- ETL – Informatica, SSIS, Data Bricks (Python)
- BI – Tableau, SSRS, Pentaho, PowerBI, MS PowerPivot, MicroStrategy
- Data Quality & Metadata – Talend, Collibra
- Robotics Process Automation – BluePrism
- Project Management – JIRA, Confluence, RALLY, ServiceNow, MS Project
- Scripting – UNIX, Python
- BI Dashboards – PowerBI, MS SharePoint Server, Tableau
- Data Analytics – MS Data Mining – Cluster Network Model
- Business Analysis – MS Excel, MS Visio, MS PowerPoint, MS Word
- Wireframes, Architecture diagrams, Business Process and Workflow modeling
Certification
- Microsoft Certified Azure AZ900, DP900 certifications
- Agile - Certified ScrumMaster (CSM) with Scrum Alliance
- IBM Informix
- DB2 11.70 fundamentals certification
- Python programming certificate from University of Waterloo, ON, Canada
Skills
Capability Owner – AML-KYC (Customer Risk Rating) business operations – Financial Crime Risk Management, Led solution design & delivery for major data migration and transformational Cloud, BIG Data, Data Warehousing, Reporting/Analytics, and application Upgrade projects, Capital Markets – MO (Trade affirmation/Confirmations), BO (Accounting & Asset Management), Investor & Treasury services; AML, Retail Markets – Shipping, Product Catalogue, Pricing, Project Roadmap, Project planning & design, Requirement Gathering – Business, System requirements –, Data quality, Architecture, Liaison with Stakeholders, PMO, Development, Testing, Systems support & Vendor teams, RDBMS – SQL Server, OFSAA (FCCM), OAS, Big Data/Cloud – MS AZURE, Hadoop Data Lake, ETL – Informatica, SSIS, Data Bricks (Python), BI – Tableau, SSRS, Pentaho, PowerBI, MS PowerPivot, MicroStrategy, Data Quality & Metadata – Talend, Collibra, Robotics Process Automation – BluePrism, Project Management – JIRA, Confluence, RALLY, ServiceNow, MS Project, Scripting – UNIX, Python, BI Dashboards – PowerBI, MS SharePoint Server, Tableau, Data Analytics – MS Data Mining – Cluster Network Model, Business Analysis – MS Excel, MS Visio, MS PowerPoint, MS Word, Wireframes, Architecture diagrams, Business Process and Workflow modeling
Work Eligibility
Canadian Citizen
Personal Information
- Title: Project Manager/ Senior Business Consultant
- Visa Status: Canadian Citizen
- Nationality: Canadian Citizen
Timeline
Project Manager (Capability Owner)/ GAML CRR Business Operations/ GAML Azure Cloud Migration
TD – Enterprise | Data Platforms – Azure Cloud , OFSAA
07.2021 - Current
Project Manager Azure Cloud Migration
TD – Enterprise | Data Platforms – Azure Cloud , OFSAA
07.2021 - Current
Manager - Requirements
Scotiabank - Global Banking & Markets
05.2020 - 07.2021
ScrumMaster/Business Systems Consultant – TD Personal Banking
TD – Personal Banking | Technology Solutions
11.2019 - 05.2020
Senior Business Systems Analyst – Robotics Process Automation
RBC – Investor & Treasury Services
07.2018 - 10.2019
Senior Business Systems Analyst – IFRS 17
RBC – Investor & Treasury Services
07.2018 - 03.2019
Business Systems Analyst / Project Manager – Global Service Delivery, IT team – Capital Markets – Asset Management
Manulife Financial
11.2016 - 06.2018
Business Analyst – Capital Markets Practice team
Atos - Syntel Pvt. Ltd
10.2014 - 11.2016
Software Developer/ Lead Solution Architect – Data warehousing & BI Practice team
Cognizant Technology Solutions Pvt. Ltd
09.2008 - 10.2014
Software Developer/ Lead Solution Architect – Data warehousing & BI Practice team
Cognizant Technology Solutions Pvt. Ltd
09.2008 - 10.2014
Bachelor of Engineering - undefined
RV College of Engineering