Summary
Overview
Work History
Education
Skills
Timeline
Generic

Sunil Awnani

Bangalore

Summary

OFSAA Principal Consultant

  • Overall 14+ Years of Professional Experience in IT Industry, Including 11 years in OFSAA.
  • Worked Extensively on OFSAA Infrastructure including Data Ingestion, RRF, Batch Configuration, T2T, F2T, Data Set, Measure, Operations, Security and other modules of OFSAA.
  • Involved in various phases of OFS BASEL, ALM,LRM ,OIDF,FSDF,AFCS & IFRS9.
  • Have good experience in Implementations process, starting from Product Installation, Configuration, Customization, Development, Testing, Data Preparation and Debugging.
  • Working on BI publisher for Basel pillar 1 & Pillar3 for report designing.
  • Completed Oracle Cloud foundation ,OCA 10g and ITIL® V3 Foundation Certification successfully.
  • I was at onsite (Uk) to lead the OIDF/DIH implementation of data preparation for IFRS17 solution as a lead.
  • Have been doing training for OFSAA Infrastructure and SQL-PLSQL.

Overview

14
14
years of professional experience

Work History

Associate Consultant

Tata Consulting
Bnagalore
04.2021 - Current

FSDF, OIDF ,PMF & DIH Implementation for Leading banking & insurance firm in UK

  • Created multiple custom RRF,T2T,DT & DQ to apply the business logic to produce the CSM input for the IFRS17 reporting.
  • Developed GIC tagging engine(Group Insurance Contract),which has been integrated across all the different source feeds and serves as a core functionality within IFRS17 program.
  • Developed custom sub ledger applications to produce the accounting header & line files for ERP system.
  • Processed event-based, pass-through & manual journal data for GIC tagging.
  • Managed team of 15 associates to implement the project.

AFCS(OFSAA SaaS) Implementation for Saudi & US bank

  • Have been a part of AFCS technical design, data starting from HUB(source system) & EDMCS to Object store to AFCS to ERP.
  • Experienced in building the EDD's data extract, DIH pipeline creation, Connectors and data visualization of AFCS.
  • Constructed strategic solution for journal creation through Oracle AFCS and enabled data processing from object store to SLA AFCS.
  • Running DIH connector using PMF pipeline.

Principal Consultant

Oracle Financial Services
Bangalore
10.2018 - 04.2021

OFSAA BASEL Configuration & Implementation for Leading bank in Thailand , 2020

•Have been working of Basel configuration.

•Worked on other asset (GL) configuration.

•Worked on eligibility, funding and capital structure.

•Have been working on classification and computation rule.

•Batch execution for BOT consolidation run.

•Configuration of multiple runs for different legal entities.

•Extensively working on OFSAA 8+ infrastructure including RRF,T2T,DT,Excel Upload and other module of OFSAA Infrastructure.

OFSAA DIH & IFRS Configuration & Implementation for Leading bank in Thailand, 2019 - 2020

•Have been working on DIH Configuration.

•Working on OOB with customized Connectors.

•Analysis the source data and accordingly building the connector as per need of OFSAA APP.

•Part of IFRS9 configuration & Implementation.

•Have designed and configured EIR Adjustment.

Technical Lead

JMR
Bangalore
09.2017 - 09.2018

OFSAA ALM for Leading bank in INDIA, 2018

• Installation of Oracle Financial Services Analytical Applications Infra 8.0 and up gradation, including cloning activity.

• Supporting multiple OFSAA application for ongoing projects including ALM, LRM & IFRS.

• Have done the data migration from DEV to UAT & UAT to PROD with the OFSAA import export module.

Senior Technical Consultant

Capgemini
Bangalore
08.2015 - 09.2018

OFSAA ALM, LRM, Implementation for Leading bank in US

. Installation of Oracle Financial Services Analytical Applications Infra 8.0 and up gradation, including cloning activity.

. ALM-LRM Configuration & Integration.

. Cash-flow Analysis, Customization on OFSAA. Debugging and code fix on PLSQL Procedures.

. Worked on DataModel,RRF,T2T,Batch Processing, DQ and other modules of OFSAA.

. Involved in the entire lifecycle of the project right from initiation till go live covering following activities in the project

OFSAA Technical Analyst

Oracle Financial Services
Bangalore
07.2012 - 08.2015

OFSAA Product Support for multiple leading national and international bank

•Bug Fixing on Infrastructure & Operational Risk (OR) solution modules on 4.8, 5.0 and 6.0 versions as well as giving support all versions of OR solution with 7.X platform.

•Checking and Solving configuration issues related to Installation of infrastructure and solutions (OR & MRM).

•Installation, Management and Upgrade.

• Part of RPD deployment as part of OBIEE

Consultant

Capgemini
Mumbai
04.2010 - 07.2012

General Motors Remarketing Information System, Web Applications

The project was for the implementation and development of General Motors web applications called Remarketing Information Management system (RIMS).

•Worked as UNIX and Oracle programmer which involved completing the Data change requests as per the requirement of client.

•Involved in Root Cause Analysis (RCA) of various issues.

•Supported application from off-shore.

•Health checks process of the application.

Education

Bachelor of Engineering - Information Technology

LNCT
Bhopal

Skills

  • OFSAA Infrastructure Modules :T2T, F2T, RRF ,Data Model, Batch Processing, DQs, DTs, DiFi Forms
  • OFSAA Solution - BASEL ,ALM, LRM, OIDF, FSDF,DIH & AFCS
  • PLSQL & SQL
  • BI Publisher,ERWIN
  • UNIX, Weblogic ,Tidal
  • Certified in Oracle Cloud Infrastructure

Timeline

Associate Consultant

Tata Consulting
04.2021 - Current

Principal Consultant

Oracle Financial Services
10.2018 - 04.2021

Technical Lead

JMR
09.2017 - 09.2018

Senior Technical Consultant

Capgemini
08.2015 - 09.2018

OFSAA Technical Analyst

Oracle Financial Services
07.2012 - 08.2015

Consultant

Capgemini
04.2010 - 07.2012

Bachelor of Engineering - Information Technology

LNCT
Sunil Awnani