Techno Functional Social Media
Resume:
Sensitivity: Internal & Restricted
Vikash Kumar Singh
Techno Functional Consultant
Mobile No : +91-998*******
Email Id : **********@*****.***
Summary: 15yrs+ of IT experience
Over 15+ years of experience in IT industry
Excellent requirements management skills and coordination capabilities between client and development teams
Strong techno functional Implementation experience in OFSA 4.5..OFSAA 5.6,OFSAA 8.0.2 in various modules like FTP,PM,ALM,FCCM(AML,KYC,FATCA). I have done end to end Implementation which include ETL mapping to source system and technical designing and building solution for bank in OFSAA.
I have good experienced in reporting side as well which include OBIEE,COGNOS, Oracle Discoverer.
Experienced in working with various data sources like Oracle, MS SQL Server, XML, flat files, and MS-Excel
Trained on OFSA 4.5, OFSAA 5.6 and 8.0.1 on modules like EPM, LRM, FCCM.
Trained on Oracle Application GL,FAH,.
Good knowledge of MSSQL(Microsoft Structure Query Language) with MYSQL.
Experienced in OBIEE, BI Publisher, creating Dashboards and Reports
Strong experience in performance and tuning of Oracle database
Data Analytics – Informatica MDM, Information Management and Data Integration.
Data Governance – Structure and unstructured data (email, social media data)
Good Knowledge of Asset Liability Management.
Oracle Applications (ERP) – General Ledger, Financial Accounting Hub.
Good Understanding of business processes of ALM.
Involved in System Study, Analysis, Database Design, Integration and Implementation
Technically adept and confident lead software developer with good flair of processes and their implementation combined with good analytical and communication skills
Qualifications:
Graduation Post Graduation
Degree Institute Degree Institute
B.Sc
Computers
JPDC Purvanchal
University
M.C.A IAMT Ghaziabad
UPTECH
University
Technical Proficiency:
Data Governance
DWH & BI
:
:
Informatica Axion, Informatica EDC
OFSA 4.5 (FTP,PA,RM), OFSAA 5.6 (ALM,PM,FTP),
OFSAI 8.0(ALM,PM,FTP,KYC,AML,FATCA)
OBIEE 10g–BI Answers, BI Interactive Dashboards, BI Publisher, BI Administration tool, BI Scheduler, BI Delivers Web Technologies : Tomcat, Web Sphere HTML, XML,
Sensitivity: Internal & Restricted
Operating Systems : Windows, Unix
Databases : Oracle 11g, SQl, PLSQL,MSSQL,MYSQL
Modeling Tool : MS Visio, ERWin
IDE/Tools : Toad, PL/SQL Developer, SQL Navigator
ETL Tool : Data Stage, ODI
Reporting Tool : Discoverer, OBIEE, COGNOS, Report 10g, XML Report. Oracle ERP : Oracle GL, FAH, HRMS
Domain Knowledge:
Finance – Corporate Banking, Retail Banking
General Insurance
Manufacturing
Appreciations:
Was highly appreciated by customer–National Bank of Oman and Raiffeisen Bank, and was rated Outstanding for my work. Career Profile:
RiskInsight Unison Consulting (June 2023 till date..) 1. Project : FTP & PM Implementation
Client : PNB Bank
Duration : Jun 2023 till date
Technology : OFSAA 8.1 FTP & PM
Role
: Technical Lead (SME)
Description :
Bank was following the manual Excle process for RBI reporting so I have done Implemented FTP and profitability rule as per policy given by the bank. I have done the system study to understand the current system and find out the gap between current and to be state. I have
Estimated and summited the report explaining the time line effort for achieving to be state.
Responsibilities:
System study done for FTP and PM rules and implemented solution on OFSAA FTP system.
System study done for custom process and done mapping with new requirement.
Leading technical team assisting in Creating DEV and SIT environment.
Mapping and data modelling for custom and standard process
Integrating with client for new requirement like multi-currency. Sensitivity: Internal & Restricted
Dome mapping of TP COA and respective method to derive FTP rate.
Defining FTP configuration like IRC etc.
SHIMENTO (Sep 2022 till May 2023)
1. Project : ALM System Study & Enhancement
Client : SVB
Duration : Sep 2022 till May 2023
Technology : OFSAA 8.1 ALM
Role
: Technical Lead (SME)
Description :
Bank was willing to migrate and enhance their ALM rule as per policy change happened in bank. I have done the system study to understand the current system and find out the gap between current and to be state. Work on the design document defining ALM riles.
Responsibilities:
System study done for ALM rules and customizations current system.
System study done for custom process and done mapping with new requirement.
Leading technical team assisting in Creating DEV and SIT environment.
Mapping and data modelling for custom and standard process
Integrating with client for new requirement like multi-currency. Wipro (Jan 2018 till Sep 2022)
1. Project : FTP System Study & Enhancement
Client : FAB
Duration : Dec 2021 till Sep 2022
Technology : OFSAA 8.1 FTP & PM
Role
: Technical Lead (SME)
Description :
Bank was willing to migrate and enhance their FTP rule as per policy change happened in bank. I have done the system study to understand the current system and find out the gap between current and to be state. Supported the current system till the new system up and running. We have Estimated and summited the report explaining the time line effort for achieving to be state. Responsibilities:
Sensitivity: Internal & Restricted
System study done for FTP rules and customizations current system.
System study done for custom process and done mapping with new requirement.
Leading technical team assisting in Creating DEV and SIT environment.
Mapping and data modelling for custom and standard process
Integrating with client for new requirement like multi-currency. 2. Project : FTP & PM System Study & Enhancement
Client : Mashreq Bank
Duration : July 2021 till Dec 2021
Technology : OFSAA 8.1 FTP & PM
Role
: Technical Lead (SME)
Description :
Bank was willing to migrate and enhance their FTP and profitability rule as per policy change happened in bank. I have done the system study to understand the current system and find out the gap between current and to be state. We have Estimated and summited the report explaining the time line effort for achieving to be state.
Responsibilities:
System study done for FTP and PM rules and customizations current system.
System study done for custom process and done mapping with new requirement.
Leading technical team assisting in Creating DEV and SIT environment.
Mapping and data modelling for custom and standard process
Integrating with client for new requirement like multi-currency. 3. Project : ALM System Study & Enhancement
Client : HCOB
Duration : Nov 2020 to Jun 2021
Technology : OneSumX (EPM)
Role
: Technical Lead (SME)
Description :
Bank was willing to migrate upgrade ALM system and other modules like LRM which are currently in other technology like SAP etc. So we have done the system study and summited the report and given the upgrade plane. Sensitivity: Internal & Restricted
Responsibilities:
System study done for OneSumX current system.
System study done for custom process and done mapping with new feature in OneSumX
Leading technical team assisting in Creating DEV and SIT environment.
Mapping and data modelling for custom and standard process
Integrating with client for new requirement like multi-currency. 4. Project : Data Governance
Client : RSA UK
Duration : April 2020 to Oct 2020
Technology : Informatica Axon
Role
: Techno Functional Lead (SME)
Description :
Client want us to visit the CPR and SPR repots covering end to data flow which was built on business objects and all major KPIs coved in it. We have done the system study and give them the gaps report and solution in terms of data governance. Like DG concepts for data accuracy and quality. Building road map for Governance implantation and drilling down to granular lave for defining Data governance council that can take care of any kind of changes that Comes on KPIs. GDPR was also one of the important part that I have handle In the repotting process like PII information. .
Responsibilities:
Done system study.
Summited final road map to customer.
Created enterprise level definition for KPIs
System Setup and configuration.
Defined Qqalmark Rule setup as per requirement
Data injection from core banking to OFSAA 8.0 DB schema
Define data modeling standard and process in playbook
GDPR check on reporting data purging cycle and security. 5. Project : Data Governance
Client : OPTUS Sydney Australia
Duration : Sep 2019 to March 2020
Technology : Informatica Axon, EDC
Role
: Techno Functional Lead (SME)
Description :
Client want us to visit there business definition and find the data quality for their management reporting KPIs. We have done the system study and give them Sensitivity: Internal & Restricted
the gaps document covering data quality and business definition. I have redefined business definition covering two different business units. Axion is te tool used to redefine their business definition and solution in terms of data governance. Like DG concepts for data accuracy and quality. Building road map for Governance implantation and drilling down to granular lave for defining Data governance council that can take care of any kind of changes that Comes on KPIs. GDPR was also one of the important part that I have handle In the repotting process like PII information.
Responsibilities:
Done system study.
Summited final road map to customer.
Created enterprise level definition for KPIs
System Setup and configuration.
Defined Qqalmark Rule setup as per requirement
Define data modeling standard and process in playbook 6. Project : Data Governance
Client : UAEEXCHANGE, UAE ABUDABHI
Duration : March 2019 to Sep 2019
Technology : Axion
Role
: Technical Lead (SME)
Description :
Client wants us to suggest the end to end data governance platform for catching there all data quality related rules happening in their transection system also they asked for data health check report for all their transection systems. We have done system study and summited the report to the customer with road map to achieve what they want.
Responsibilities:
Done system study.
Summited final road map to customer.
Created team for AML implementation.
System Setup and configuration. Defined Qqalmark Rule setup as per requirement
Define data modeling standard and process in playbook 7. Project : OFSAA POC on LRM 8.0.3
Client : Corporation Bank
Duration : Sep 2018 to March 2019
Technology : OFSAAI 8.0 (LRM), OBIEE
Role
: Technical Lead (SME)
Description :
Sensitivity: Internal & Restricted
The bank asked us to give the solution for liquidity Risk Management. So we have analyzed and done the POC to categories the products into HQLA and EHQLA product. Second phase was to define computation rule for Inflow on basis of classification done in first phase. Third phase was to define assumption and computations outflow).The cash flow received from ALM and then all the three phase applied to arrive LCR percent.
Responsibilities:
Leading technical team assisting in Creating POC environment.
System Setup and configuration.
Preparing fictional Requirement Document for PM.
Designing Cost Allocation Rules
Configuring PM Rule setup as per requirement.
Data injection from core banking to OFSAA 8.0 DB schema 8. Project : OFSAA FCCM (KYC, AML) Management POC from 8.0.3 & Profitability Management POC
Client : Canara Bank, India
Duration : Jan 2018 to Sep 2018
Technology : OFSAAI 8.0 (FCCM), OBIEE
Role
: Technical Lead (SME)
Description :
The bank asked us to give the solution for Profitability management to understand their profitability at different KPI level like customer, branch, and region level. So we have visited their current system which was manual and also gone through their current requirement. Analyze the gap and design their POC solution .
Responsibilities:
Leading technical team assisting in Creating POC environment.
System Setup and configuration.
Preparing fictional Requirement Document for PM.
Designing Cost Allocation Rules
Configuring PM Rule setup as per requirement.
Data injection from core banking to OFSAA 8.0 DB schema
Mapping and data modeling for custom and standard process 8.0
Integrating with system to ETL real time processing. ENY (Feb 2016 till Jan2018)
1. Project : OFSAA Transfer Pricing & Performance Management Migration from 4.5 to 8.0
Client : OCBC,Singapore
Duration : Feb 2016to till Jan 2018
Technology : OFSA 4.5,OFSAAI 8.0 (EPM)
Sensitivity: Internal & Restricted
Role
: Technical Lead (SME)
Description :
Bank was willing to migrate from OFSA 4.5 older version to new OFSAAI 8.0 version. The major change came in staging layer and data warehousing of bank because of instrument table present in new OFSAA 8.0 dose not match with bank 4.5 tables. The second challenge was to map customization done in OFSA 4.5 and the logic written in staging layer with 8.0 features. Responsibilities:
System study done for OFSA 4.5 current system.
System study done for custom process and done mapping with new feature in OFSAA 8.0
Leading technical team assisting in Creating DEV and SIT environment.
Mapping and data modelling for custom and standard process of 4.5 in 8.0
Integrating with client for new requirement like multi-currency. ORACLE(Sep 2013 till Feb 2016)
1. Project : OFSAA LRM Product Development
Client : Internal
Duration : March 2015 to Feb 2016
Technology : OFSAA 8.0,OFSAAI
Role
: Techno Functional Consultant
Description :
LRM product development is the first project which I have done for product development rather than Implementing a product. LRM 8.0 is base product has been taken. The development is done for European Banking. The development is done in three phase (first phase was classifying data into HQLA and EHQLA as per Official Journals of the European Union. Second phase was to define computation rule for Inflow on basis of classification done in first phase. Third phase was to define assumption and computations outflow).The cash flow received from ALM and then all the three phase applied to arrive LCR percent. Responsibilities:
Done the technical design for phase 1 classification HQLA and EHQLA .
Done construction for phase 1 and phase 2 by defining Hierarchy, Measure, Business process, Data Set, Computation and Classification Rules, Assumptions.
Sensitivity: Internal & Restricted
Data Modal and T2T Changes for mapping and flags vales and computation values in LRM Instrument, Mitigant and Cash table.
Currently managing team of 10 member for phase three development.
2. Project : OFSAA FCCM(AML, KYC) Product Training and POC Client : Internal
Duration : JAN 2015to Feb 2015
Technology : OFSAA 8.0,OFSAAI, FCCM(AML,KYC,FATCA), RRS Role
: Techno Functional Consultant
Description :
This was professional training program on FCCM covering three modules ALM,KYC and FATCA. This program was conducted by Mantas people after takeover my oracle. It was hands on training with small POC.
Responsibilities:
Done the server setup for three layer for FCCM.
Uploaded the Golden Data in data base layer.
Run the process to generate AML alerts.
Done reporting using RRS .
3. Project : Migration OFSAA I & OFSAA 5.6 to 8.0 FTP Client : Internal
Duration : Oct 2014 to Jan 2015
Technology : OFSAA 5.6,OFSAA 8.0,OFSAAI
Role
: Techno Functional Consultant
Description :
The major challenge was there to use the new feature of OFSAAI 8.0 connectors instead of directly provided mapping in ODI. Second challenge was there to migrate seeded data and rule base data from 5.6 to 8.0 because one has the merged modal but 5.6 is not having merged data modal. Responsibilities:
Deploying the connecters in 8.0.
Data modal extract and upload from 5.6 to 8.0
Written script for migrating batches from 5.6 to 8.0 4. Project : OFSAA I & OFSAA Implementation EPM
Client : ADIB
Duration : Sep 2013to Sep 2014
Sensitivity: Internal & Restricted
Technology : OFSAA 6.1,OFSAAI
Role
: Techno Functional Consultant
Description :
Bank has the FTP process for loan in SYBASE which need to be implemented in same way in OFSAA. The major challenge was there to setup up cash flow process in OFSAA in same way what bank is running in their current system. I have designed the customize process to calculate NPV(Net Present Value) as per bank logic in current system for Loan product and used the same data in FTP engine to calculate TP rate and charge credit.
Responsibilities:
Design and code the complete process to calculate NPV.
Configured FTP process to consume calculated NPV and generate transfer rate and charge credit.
5. Project : OFSAA I & OFSAA Training
Client : OFSS
Duration : Sep 2013to Oct 2013
Technology : OFSAA 6.1,OFSAAI
Role
: Trainee
Description :
Trained on OFSAAI Object creation like dimension, Hierarchy, Filters, T2T, Formula etc. On security like creating User, User Group, Rolls etc. How to restrict user for accessing different modules in OFSAA application like EPM and ERM and there sub modules like FTP,PM,ALM.
Training includes the Installation of OFSAA 6.1 Infrastructure and EPM module. Responsibilities:
Learn and completed the training module and exercise for creating objects in OFSAII.
Learn and completed the training exercise on OFSAAI,OFSAA EPM Installation.
For Noor Islamic Bank Dubai. (Jan 2013 till Aug 2013) 1. Project : OFSAA & Hyperion Support
Client : Noor Islamic Bank Dubai
Duration : Jan 2013 to Aug 2013
Technology : OFSAA 5.6, OBIEE10g, BI Publisher, Oracle 10g Role : Support Manager
Sensitivity: Internal & Restricted
Description :
The bank requires the support for Fund transfer pricing and Asset Liability Management and Profitability Management. I have supported and done the enhancement for ALM and PM module.
Responsibilities:
Supporting the current batch process.
Enhancing process as per changes given by the bank.
Enhancing OBIEE report as per bank need.
Developed interface programs to load rates from MIS to OFSA application.
Used LS_Load process to upload data into ledger stat.
Developed an API for PM application to distribute fee from different org unit at account level. For developing this API the complete SDSC cycle was followed.
Created SQL IDs for automating user defined and system defined programs.
Supporting User in UAT & Production for ALM, FTP&PM module once successfully implementing in Development environment.
Functionally Designed and Created FTP and PM and ALM all the measure in OBIEE reports for the Bank as per the requirement it include designing of all the three layers
Physical, Business, Presentation. Dashboard designing and security like user creation
Role and user group.
For HCL Technologies. (Aug 2011 till Sep 2012
1. Project : FTP and PM Implementation and Test Support Client : Raiffeisen Bank International Austria
Duration : Aug-2011 to Sep 2012
Technology : OFSAA 5.2, OBIEE
Role : Project Lead (onsite)
Sensitivity: Internal & Restricted
Description:
Bank has a requirement to upgrade OFSA 4.5 to new version 5.6 and given a test support for customize part. In first phase we have upgraded the OFSA 4.5 to 5.6 and in second phase we have given support till product become stable. There were some enhancement given by the bank which was not part of version 4.5 that also we have address in second phase.
Responsibilities:
Understanding business requirement and designing the solution.
Managing team and client relation.
Designing migration activity which Include all dimension, FTP rule,PM Rules
Created User and Rolesas per the security requirements of the bank.
Done the complete setup for FTP and PM because it cannot be migrated.
Defining and adding the leaf columns in instrument and ledger stat.
Defining classification of tables in OFDM.
Created user defined table structure to meet the technical challenges and configured the table as PA table so that application
Developed interface programs to load rates from MIS to OFSA application.
Developed an API for PA application to distribute fee from different org unit at account level. For developing this API the complete SDSC cycle was followed.
For OFSS.(March 2006 till July 2011)
1. Project : CitiCheckingFlexcube Migration.
Client : CitiBank US
Duration : Oct-2009 to July2011
Technology : People Middleware, DataStage 8.1,TIBCO Role : Project Lead (onsite)
Description:
CitiBankUS, is migrating one of their existing application, CitiChecking to Flexcube. The project involves transferring the existing source systems data to CitiChecking application as well as Flexcube using DataStage 8.1 for batch interfaces and TIBCO for online interface..
Responsibilities:
Review/Analyze the requirements.
Review/Design the solution
Closing the SQA related activities like estimations for CUT Activity.
Leading the team for enhancement objects.
Sensitivity: Internal & Restricted
2. Project : Oracle Apps 11i FTP
Client : Oracle –Turkey
Duration : April-2009to Sep-2009
Technology : OFSA 11i, OBIEE
Role : Lead Developer
Description:
The bank asked us to give the solution for transfer pricing. We had visited the complete business rules and TP policy and suggest them solution to meet present bank need by OFSA FTP 11i. They asked reporting in OBIEE for PA and RM.
Responsibilities:
Onsite designing of complete Technical solution for Risk Manager, Transfer Pricing & Performance Analyzer and implementing the same in the Bank as per User requirements given.
Functionally Designed and Created TP and PA Discoverer reports for the Bank as per the requirement.
3. Project : Risk Manager, Transfer Pricing & Performance Client : National Bank Of Oman - Oman
Duration : Nov-2008toNov-2009
Technology : OFSA 4.5, OBIEE
Role : Senior Developer
Description:
The bank asked us to give the solution for transfer pricing and risk management. We had visited the complete business rules and TP policy and suggest them solution to meet present bank need by OFSA (RM, TP and PA)). They asked reporting in OBIEE for PA and RM
Because in future they want to switch on EBS Oracle Apps the major change what we got from them is the reporting all the scenarios in the local as well as the foreign currency. In terms of ETL also we have faces lots of challenges they have five source systems so it was challenging to maintain the data accuracy. Responsibilities:
Onsite designing of complete Technical solution for Risk Manager, Transfer Pricing & Performance Analyzer and implementing the same in the Bank as per User requirements given.
Created User and responsibility for keeping the security measure.
Done the complete setup for TP and PA
Defining and adding the leaf columns in instrument and ledger stat.
Defining classification of tables in OFDM.
Created user defined table structure to meet the technical challenges and configured the table as PA table so that application
Can interact with the user defined structure.
Developed interface programs to load rates from MIS to OFSA application. Sensitivity: Internal & Restricted
Used LS_Load process to upload data into ledger stat.
Developed an API for PA application to distribute fee from different org unit at account level. For developing this API the complete SDSC cycle was followed.
Created SQL IDs for automating user defined and system defined programs.
Supporting User in UAT & Production for Risk Manager, Transfer Pricing & Performance Analyzer module once successfully implementing in Development environment.
Functionally Designed and Created TP and PA OBIEE reports for the Bank as per the requirement
4. Project : RM System Study & Enhancement
Client : Dunia Bank – Dubai
Duration : Oct-2007 to Sep-2007
Technology : OFSA, Oracle 11i Windows 2K,Toad,Unix, Discoverer 4.1 Role :
Technical Consultant
Description:
The Flexcube to OFSA integration details the mapping between the tables of Flexcube and OFSA. It also covers the various validations which are required before transferring the data from OFSA to Flexcube and vise versa. facilitation of CMM L-5
Responsibilities:
Work directly under the Client Project Manager for Identifying the objects affected for Changes for ODP( On-demand Pay) and carry out a through Impact analysis and Submitted a detailed report to the Client Management.
Onsite designing of complete Technical solution for Risk Manager, Transfer Pricing & Performance Analyzer and implementing the same in the Bank as per User requirements given.
Created User and responsibility for keeping the security measure.
Done the complete setup for TP and PA
Defining and adding the leaf columns in instrument and ledger stat.
Defining classification of tables in OFDM.
Created user defined table structure to meet the technical challenges and configured the table as PA table so that application
Can interact with the user defined structure.
Developed interface programs to load rates from MIS to OFSA application.
Used LS_Load process to upload data into ledger stat.
Developed an API for PA application to distribute fee from different org unit at account level. For developing this API the complete SDSC cycle was followed.
Created SQL IDs for automating user defined and system defined programs.
Supporting User in UAT & Production for Risk Manager, Transfer Pricing & Performance Analyzer module once successfully implementing in Development environment.
Functionally Designed and Created TP and PA Discoverer reports for the Bank as per the requirement
Sensitivity: Internal & Restricted
5. Project : Performance Analyzer Enhancement
Client : Bank Danamone – Indonesia
Duration : July-2007 to Sep-2007
Technology : OFSA 4.5, Discoverer 4.1
Role : Technical Consultant
Description:
Bank Danamon OFSA(PA) enhancement was done because of change in cost allocation policy which was discussed decided during PAT phase and another factor was the change came in GL it was change from Flexcube GL to Oracle GL Responsibilities:
Onsite designing of complete Technical solution for Performance Analyzer and implementing the same in the Bank as per User requirements given.
Created User and responsibility for keeping the security measure.
Done the complete setup for PA
Defining and adding the leaf columns in instrument and ledger stat.
Defining classification of tables in OFDM.
Created user defined table structure to meet the technical challenges and configured the table as PA table so that application
Can interact with the user defined structure.
Created SQL IDs for automating user defined and system defined programs.
Supporting User in UAT & Production for Performance Analyzer module once successfully implementing in Development environment.
Functionally Designed and Created PA Discoverer reports for the Bank as per the requirement.
Ensured project adherence to the defined processes 6. Project
Client
:
:
RM System Study & Enhancement
National Bank Of OMAN
Duration : March-2007 to Jun-2007
Technology : OFSA 4.5, Business Object
Role : Technical Consultant
Description:
The client already had an OFSA which was implementer in way back 2004. They asked us to re-visit the complete OFSA (RM, TP and PA) and suggest them solution to meet present bank need. The major change they were looking for is to convert monthly process to daily.
Second they want to generate MAL and SAL report on daily basis.
.
Responsibilities:
Requirement Analysis, Fit-gap analysis, Detail Design and documentation of changes required for Transition Tool Development.
Done Mapping between the daily dump which bank hold in data warehouse Sensitivity: Internal & Restricted
With the instrument and GL data to ledger stat.
Designed an interface program that check all the validation and transfer the data from source system to interface table .
Created an API which calls the internal API to generate event id and store it at interface table.
Defining and adding the leaf columns in instrument and ledger stat.
Defining classification of tables in OFDM.
Created user defined table structure to meet the technical challenges and configured the table as PA table so that application 7. Project
Client
:
:
Risk Manager, Transfer Pricing & Performance Analyzer Bank Danamone – Indonesia
Duration : March-2006 to March-2007
Technology
Role
:
:
OFSA 4.5, Discoverer 4.1
Technical Consultant
Description:
The bank asked us to give the solution for transfer pricing and risk management. We had visited the complete business rules and TP policy and suggest them solution to meet present bank need by OFSA (RM, TP and PA)). The major change what we got from them is the reporting all the scenarios in the local as well as the foreign currency. In terms of ETL also we have faces lots of challenges they have five source systems so it was challenging to maintain the data accuracy. The Cost allocation policy given by the BA team of the bank was not straight forward they want account level allocation and that was delivered.
Responsibilities:
Involved in Scoping, Strategy Discussion and Formulation for Data Migration.
Onsite designing of complete Technical solution for Risk Manager, Transfer Pricing & Performance Analyzer and implementing the same in the Bank as per User requirements given.
Created User and responsibility for keeping the security measure.
Done the complete setup for TP and PA
Defining and adding the leaf columns in instrument and ledger stat.
Defining classification of tables in OFDM.
Created user defined table structure to meet the technical challenges and configured the table as PA table so that application
Can interact with the user defined structure.
Developed interface programs to load rates from MIS to OFSA application.
Used LS_Load process to upload data into ledger stat.
Developed an API for PA application to distribute fee from different org unit at account
Contact this candidate