ASISH SANKAR

OFSAA Modules : FSDF, DIH , GL RECON, AHCS, BASEL(OSFI)

• Technical SME, and SPOC for OFSAA technical issues.
• Leading a team of consultants in implementing OFSAA solutions
• Managing technical issues and working the clients technical team for resolutions.
• Conducting regular meetings with clients to understand their requirements and provide updates.
• Coordinating with the development and support teams to troubleshoot and resolve technical issues.

OFSAA Modules: DIH and FSDF

• Advisory role to the client with FSDF (Financial Services Data Foundation), DIH (Data Integration Hub), and AAI.
• Assist the client in defining their strategic objectives and aligning the capabilities of FSDF, DIH, and AAI with their business goals.
• Design comprehensive solutions that integrate FSDF, DIH, and AAI to meet the client’s business needs. This includes data modeling, process design, and system configuration.
• Regularly communicate project status, issues, and risks to all stakeholders, including the client’s senior management.
• Regularly review the solution’s performance and recommend improvements to enhance its effectiveness and efficiency.

Applications & Modules : OFSAAI, FSDF, DIH, GL RECON and Upgrade of OFSAAI 803 (Legacy) to 8.1.x (OCI)

• Technical Lead for the upgrade phase of Desjardins OFSAAI from 8.0.3 to 8.1.x
• Working closely with the clients technical and functional teams to guide them through a smooth transition from 8.0.3 to 8.1.x version of OFSAAI.
• Understand and document the impact of the upgrade from 8.0.3 to 8.1.x
• Provide the client with a clear documentation of the Technical Impact of the Upgrade to the existing customized metadata/objects.
• Document a retrofit plan for the impacted objects.
• Support the Bank through multiple upgrade runs in OCI before going live.
• Provide support to Banks production support team post go-live.
• Performing advisory assistance for the Bank in the implementation activities.
• Understand FSDF downstream business requirements. Review the DSL with the downstream business/technical team.
• Discussions with business architects on possible transformations required for the Desjardins Treasury Project (IATR).
• Development of T2T’s F2Ts, T2Fs, Post Load Changes (Data Transformation), Datasets, Measures, Hierarchies, Business Processor, Rule, Process, Run, Operations module (Batches) etc.
• Working on Data Quality rules and groups.
• Configuring all DIH components – EDSs, EDDs, Connectors. Understanding of DIH physical/logical architecture surrounding OFSAA data model, DIH and ODI.
• Database performance management for OFSAA metadata and SQL tuning.
• Coordinated with the development team to troubleshoot and resolve technical issues

POC on OFSAAI, FSDF, DIH and GL Recon

• TD bank - POC to demonstrate that FSDF Data Model and OFSAA capabilities satisfying TD's Risk Management and Regulatory Reporting needs using TD's data and business processes to establish OFSAA as the Target State Data Warehouse for Risk, Finance and Treasury.
• Intesa Sanpaolo - POC to test the use cases that relate to moving the data from the Flexcube’s FCUBS module into FSDF, and verify the data inbound into FSDF from FCUBS.
• Individual knowledge transfer sessions with the client.
• Guiding the client through the process of Installing and configuring the OFSAA modules and components.
• Integration of the FCUBS interface with DIH, and configuring and testing the OOB FCUBS connectors.
• Implementing the OOB OBIEE reports.
• Implementing the GL Reconciliation and FSDF solutions.

OFSAA Modules: OFSAAI, FSDF, USFED Regulatory Reporting, GL Recon and AgileReporter.

• Understanding the business requirement, and continuous discussions with business to understand any changes or inputs required.
• Install and configure OFSAAI, USFED Regulatory Reporting.
• Configuring Data Model to meet the requirements of the client.
• Requirement Analysis and Fit gap analysis.
• Analyzed data loaded from different sources and perform data quality checks and participated in system integration testing.
• AAI Configuration including Data Sources, T2T's, F2T's, Post Load Transformations, Data Quality Rules, Measures, Hierarchy, Dimensions, Datasets, Rules, Process and Run.
• Configuration of Process Flow in terms of Batches and Performing maintenance, execution, monitoring and scheduling of the End to End Batch Run.
• Leverage OFSAAI framework to demonstrate the capabilities to modify data, load data into FSDF Results layer, perform computational rules etc.
• Configuration and testing OOB Report and dashboards in AgileReporter.
• Tuning the performance and optimizing the FSDF and Regulatory reporting components.
• Guided the infrastructure team for setting up the development and UAT environment.
• Conducted handover training sessions for business and technical users.

OFSAA Modules : OFSAAI and FCCM - AML

• Installation and configuration of the OFSAA-BDF, AML 8.0.2 suite and KYC
• End-end implementation of the AML solution, including Ingestion Manager, Behavior detection, Threshold Customization, Mantas scenarios base thresholds setting.
• Preparation and execution of AML and KYC batches.
• Development of BDF data maps and scenarios as per client’s requirement.
• Analyzing defects and providing fixes.
• Shell scripting to automate the process of executing jobs.
• Preparing the DIS data map as per the requirement.
• PL-SQL procedures code development.
• Code migration across environments.

OFSAA Modules: OFSAAI, FTP, OFSOR and ODIEE

• Creation of OFSAA T2T, Business Processes, Hierarchies, Run Rule, and Process.
• Created batches OFSAA ICC and Run Rule batch.
• Code Deployment across all environments.
• Created unit test cases to test the Interfaces and functionalities of developed code.
• Data Model Design using Erwin.
• Shell Scripting.
• PL-SQL procedures code development.
• Technical Process flow Documentation.
• UAT support.
• Production Cutover.
• Post-Go Live Support.

OFSAA Modules: OFSAAI, FCCM, FSDF, FTP and Basel II

• Installation and configuration of OFSAAI, FCCM, FTP, ALM, LRM, Basel II.
• Running of Basel, ALM and KYC batches.
• Cloning of the Environments.
• Support to all the client environments.
• Preparing and Modification of the data model using Erwin 7.3/9.2, and upload of the data model.
• Production incidents raised by the client provided with appropriate solutions.
• Knowledge on the entire flow of the Basel solution and understanding how the solution works.
• For Change requests from the client, detailed study of the impact of the change and making appropriate changes.
• Querying and understanding of DB queries written in logs to arrive at a solution.