SUMMARY:

• He has over 17 years of strong technical implementation experience with 9 years focused in banking & financial services industry (BFSI) and 8 years of experience with Non - banking & financial services industry (BFSI).
• Mandeep has extensive experience in leading large teams towards
• Delivering business & functional requirements, acquisition of the transactional data
• Implementing ETL, data quality, and validation rules
• Performing data modeling for data warehouses/data stores using standard FSDM or IBM BDWM or customize data models
• Conducting SIT/UAT and overall end to end technology design of various regulatory reporting regarding Basel III HC-R/FFIEC101, SNC, CCAR 14 A/Q/M and Liquidity 5G regulatory reporting
• Recently, Mandeep has started to focus on implementation towards big data technologies around Horton works platform on Microsoft Azure Cloud
• Business Analyst experience: Mandeep has experience in delivering end to end requirements for implementations, consisting of Business requirements (BRD), functional requirements (FRD), mapping end to end data process flows, technical ETL mapping requirements around regulatory subject areas. such as Basel II implementation for Netherlands, Basel III Standardized implementations for US, Shared National Credit, GL & FY9C reconciliation for Capital market sub ledger systems
• Data modeling experience: Mandeep has experience in implementing IBM Banking & Financial services Data Warehouse model (BDWM), Oracle FSDM and customized models for retail, wholesale and capital markets.
• Data Quality experience: Mandeep has hands-on experience with scripting data quality rules for a large volume of data using Python (PETL and Pandas Packages), SQL and PL/SQL.
• Reporting Experience: Mandeep has hands-on experience in creation of end user reports & dashboard using tools such as Business Object, COGNOS and Power BI
• Source Data exposure: Mandeep has designed in past the file structure & ETL rules for sourcing data from banking applications such as Fidelity Retail Mortgage System (MSP), Fidelity Wholesale Loan System (ACBS), Loan-Net, Loan-IQ, Credit Cards application (FDR), Installment Loans System (ACLS), Dealer Floorplan Loan system (Data-scan),Multifamily Loan system (ELMS), INTRADER (Aladdin), FENICS, OPICS, Phase3, Murex, Calypso, Summit and Imagine.

TECHNICAL SKILLS:

Regulatory Experience: Mandeep has led engagements focused on implementations revolving around various regulatory reporting e.g. Basel II, Basel III, CCAR 14A/Q/M, SNC

Capital Calculation Engines: Mandeep has worked in past with implementation of Moody Analytics/Risk Authority (Formerly Moody s Fermat) and OFSAA (formerly Oracle REVELEUS) for Basel reporting

Testing experience: Mandeep has experience in leading teams to conduct SIT/UAT using SQL scripts, python scripts, Excel and MS Access

Database technologies experience: Oracle, MS Sql Server, IBM DB2, MS Access, SAS Base

Big Data Technologies: Mandeep has recently implemented a big data cluster based on HDP2.6 on Microsoft Azure and created a POC with big data files on Spark 2.0 using python interface and front end Python Flask package.

PROFESSIONAL EXPERIENCE:

Confidential

Manager in the Advisory, Technolog

Responsibilities:

• Vendor tool assessment
• Business requirements document
• Functional requirements document
• High-Level design and conceptual as well as Logical data model using Power Designer
• Creating user stories for agile development
• Creating IT implementation plan and budget

Confidential

Responsibilities:

• Producing business requirements document
• Producing functional requirements document
• Defining 150 edit checks (80 Fed prescribed and 70 internal)
• Creating the mockups for UX(User experience)
• Creating customized data model for the solution using ERWIN
• Creating data dictionary and lineage for around 80 SNC attributes across approx. 4 hops with wholesale Loan system carrying assets of approx. $150B
• Conducting the system integration testing and facilitating the User acceptance testing

Confidential

Responsibilities:

• Source system data specifications required for Basel III Standardized calculations
• Producing the business requirements document
• Producing the functional requirements document
• ETL Mapping of the source systems for treasury products, wholesale loans and retail portfolio towards OFSAA Financial services data model
• Creation of DQ rules for the data sent from source systems
• Design and execution of the reconciliation for the sourced data with GL, FY9-C & 10Q disclosures fillings to confirm the Asset side data population
• Reviewing the DQ validation results and reconciliation reports with executive management
• Producing mapping for OFSAA output data to Basel III HC-R schedules

Confidential

Responsibilities:

• Test project plan & timeline
• Creating Automated robot test case for the production environment in Unix
• Conducting SQL based DQ validation on the data delivered by source systems
• Conducting validation of exposure logic for counter-party aggregation
• Conducting reconciliation of exposure reports with GL
• Reporting the SIT/UAT status to executive management

Confidential

Responsibilities:

• Creating assessment framework and questionnaire
• Conducting system owner interviews, aggregating the responses and assigning ratings to the existing controls
• Presenting the findings and next steps to the management

Confidential

Senior in the Advisory

Responsibilities:

• Execution of Monthly GL reconciliation for 11 source systems consisting of derivatives & Repo data using MS access for small data set, Python Pandas for huge data sets
• Execution of aggregated Quarterly reconciliation for derivatives & Repo data with 10 Q and FY-9C fillings
• Creation of the GL reconciliation procedure manual and walking the bank team through the established process
• Reviewing & explaining breaks with middle office operations team and GL Controllers for the 11 source systems
• Reviewing the reconciliation reports with executive management

Confidential

Responsibilities:

• Formatting the Confidential technical metadata in input sourcing format readable by ASG Rochade
• Running and validating the loaded metadata in ASG Rochade
• Creating a procedure manual for the process
• bank staff to follow the procedure in BAU

Mandeep led an internal campaign in Confidential & Confidential LLP, for defining the data requirements regarding compliance towards Dodd-Frank Act under topics such as Volcker Rule, OTC Derivatives, Consumer protection, Securitization, Living Wills & Systemic Regulation. He was responsible for

• Gathering reporting requirements
• Developing a business data model
• Identifying key data elements required for various structured data classes for Dodd-Frank reporting requirements

Confidential

Associate Consultant

Responsibilities:

• Identifying data requirements for Basel II calculation
• Defining an interface structure between the source system(s) and the customized internal IBM BDWM based data warehouse
• Mapping the source data to the IBM BDW data structures
• Creating source system extract definitions for the Reveleus Basel II Capital calculation engine.
• Engaging source systems owners in mapping the data sourcing requirements
• Execution of data quality validation and reconciliation of the received sourced data to GL
• Discussing breaks with source system operations and IT teams
• Reporting data sourcing, validation and reconciliation reports to executive management

Confidential

Responsibilities:

• Designing and testing ETL data interfaces between various bank source systems and Moody Fermat Basel II solution
• Mapping the source data into IBM Banking Data Warehouse (IBM BDWM)
• Mapping the calculated RWA results back into IBM BDWM
• Design of specific data marts for Basel II reporting