`

A dynamic professional having eight years of experiences in Transfer Agency product.

Strong knowledge about Mutual Fund Transaction Processing Flow.

Expert in PL/SQL / Performance tuning.

Sound knowledge in Solution delivery along with complete support of BAU activities.

Strong in client management and development cycle.

A keen planner with proven abilities in devising strategies to strengthen internal and external processes, independently handling client in onsite, data migration and end to end product implementation.

Independently handled end to end distributor commission processing revamping of a key client in Indian Mutual Fund industry.

Excellent communication and client relationship skills.

TECHNICAL SKILLS

Operating System : Windows XP/2000/98, Windows Vista

Programming Languages : Oracle PL/SQL

Databases & Tools : Toad, SQL Plus, SQL Developer

Reporting Tools : OBIP

EMPLOYEEMENT HISTORY

Company

Designation

Joining Date

End Date

ORACLE Financial Services Software Ltd.

Associate Consultant

12-Oct-2009

30- Jun-2013

ORACLE Financial Services Software Ltd.

Senior Consultant

01-May-2014

28-Apr-2017

Mindteck

Onsite Consultant

05-Feb-2018

28-Dec-2018

\

Projects Profile:

I. Project Title

Project Type

Claims Billing System

Development

Period

Feb2018 to Till Date

Client

Highmark

Description

Highmark is a non profit healthcare company based in Pittsburgh,Pennsylvania,United States .Claims billing system (CBS) works to process claims of self-funded insurance or multiple partners.

Environment

Tools

Role

Windows, PLSQL, Java

Cognos

Onsite Consultant

Work

Responsibilities

Gathering requirement and creating designing document

Functionality developed using PLSQL

Testing and fixing defects

Worked on fine tuning the queries in Cognos report optimization

Monitoring and support for production issues

II. Project Title

Project Type

PTBC offshore support

Support and Development

Period

May2016 to Apr2017

Client

Commonwealth Bank –Indonesia

Description

Commonwealth bank of Indonesia is using FLEXCUBE product for both banking and mutual fund operations. This project is make sure business runs asusual and also have any enhancement as per the request of the client.

Environment

Tools

Role

Windows, PLSQL

RAD,OBIP

Team Member

Work

Responsibilities

Gathering requirement and creating designing document

Functionality developed using PLSQL

Testing and fixing defects

Monitoring and support for month end account statement process

III. Project Title

Project Type

PTBC offshore support

Support and Development

Period

May2016 to Apr2017

Client

Commonwealth Bank –Indonesia

Description

Commonwealth bank of Indonesia is using FLEXCUBE product for both banking and mutual fund operations. This project is make sure business runs asusual and also have any enhancement as per the request of the client.

Environment

Tools

Role

Windows, PLSQL

RAD,OBIP

Team Member

Work

Responsibilities

Gathering requirement and creating designing document

Functionality developed using PLSQL

Testing and fixing defects

Monitoring and support for month end account statement process

IV.Project Title

Project Type

Report Automation

Development

Period

Sep2015 to Apr2016

Client

Sundaram BNP Fund Services – India

Description

Sundaram BNP Fund Services one of the Transfer Agency (TA) for Mutual Fund Operations in India, SBFS is using FCIS for their end to end TA operations to support Mutual Fund operations in india.

Sundaram BNP Fund Services were using OBIP as a front end for generating all the reports and planned to use APEX for developing the GUI for all their reporting requirement. Around 850 report of the client has been moved from OBIP to APEX module to overcome the performance issues faced.

Environment

Tools

Role

Windows, PLSQL

RAD

Technical lead

Work

Responsibilities

Reporting Development and Automation

Designing the database architecture to cater the client requirement for report generation.

Coordinating with the end users and understanding the reporting logics and parameters required for generating the requirement.

Coordinating with the other team members for template development user OBIP and creating a web service call from APEX to OBIP for each reports.

Developing Back end programs to generate the reports

Mailing the frequency based specific reports such as weekly, monthly, yearly etc., to the desired recipients through database scheduler.

Parallelizing the process for high time consuming reports.

Performance tuning.

User access control implementation for report generation.

UAT Coordination.

V.Project Title

Project Type

FCIS Onsite Support And Consulting

Development

Period

May2014 to Aug2015

Client

Sundaram BNP – India

Description

Sundaram BNP Fund Services one of the Transfer Agency (TA) for Mutual Fund Operations in India, SBFS is using FCIS for their end to end TA operations to support Mutual Fund operations in india.

Environment

Tools

Role

Windows, PLSQL

RAD tool (FLEXCUBE internal tool used to develop GUI)

Team Member

Work

Responsibilities

Production Support And Consulting

Understanding client requirement for new enhancements.

Preparing Functional Specification for the new requirements

Assisting client with the work around solution or exploring the product existing features to match the client’s new requirement.

First level analysis for the bugs raised by clients.

Coordinating between product team in OFSS and client for the bug raised in product features.

UAT deployment

UAT Support

Installing new enhancement objects in production.

VI.Project Title

Project Type

BNP Paribas Mutual Fund Migration Development

Period

Jul2012 to Junl2013

Client

Sundaram BNP – India

Description

Sundaram BNP Fund Services one of the Transfer Agency (TA) for Mutual Fund Operations in India, SBFS is using FCIS for their end to end TA operations to support Mutual Fund operations in india.

Environment

Tools

Role

Windows, PLSQL

RAD tool (FLEXCUBE internal tool used to develop GUI)

Team Member

Work

Responsibilities

BNP Paribas Mutual Fund Data Migration from legacy system.

Creating new database schema for the new Asset Management Company in FCIS in the given migration environment.

Conversion of legacy data into FCIS upload format migration environment.

Uploading Legacy data into FCIS migration environment.

Analysing the data issue in the migration environment

Ensuring the data integrity between legacy data and migrated data in FCIS migration environment.

Creating gold copy of the migrated data from the migration environment post all the integrity checks.

Supporting parallel processing between former TA and SBFS

VII.Project Title

Project Type

Flexcube Product Development

Development

Period

Jan2011 to Jun2013

Client

Sundaram BNP – India

Description

The "FlexCube Investor Services" is one of the privileged product of oracle which is used across various financial organization for dealing with Mutual fund portfolio. The product would be modified according to the requirement of the client and it would be implemented and supported.

Environment

Tools

Role

Windows, PLSQL

RAD tool (FLEXCUBE internal tool used to develop GUI)

Team Member

Work

Responsibilities

Developing GUI using RAD

Functionality developed using PLSQL

Testing and fixing defect.

VIII.Project Title

Project Type

DBFC Reports

Reengineering Project

Period

Client

January 2010 to December 2010

Deutsche Bank

Description

FastCollect report project involves migration of existing PowerBuilder-based application to a web-based application based on Java EE framework that is expected to provide all of the functionality supported by current application while re-using existing database .

FastCollect Report application provides the users with the facility to generate view and download various Reports. User will have a criteria screen where he/she needs to specify or select the different parameters depending on which the report will be generated. Report functionalities includes different output file formats, emailing, scheduling, access features etc.

Environment

Tools

Windows, Java, PLSQL, JSP

Jasper

Role

Team Member

Work

Responsibilities

Developing Report using iReport.

Developing Input screen using JSP and Java.

Testing and fixing defect in the report.

Fixing SIT/UAT defects.

IX.Project Title

Project Type

Dart and dbNavigate Production

Production Support

Period

Client

November 2009 to December 2009

Deutsche Bank

Description

DART (Dashboard and Reporting Tools) which is a complete data warehousing project which uses Hierarchy management concepts (Hyperion DRM), ETL Logic, Essbase concepts and Cognos reports.

Environment

Tools

Windows, UNIX, PLSQL

Informatica

Role

Team Member

Work

Responsibilities

Involved in monitoring/ (un) scheduling of workflows

Worked in the Development of ETL Process using Informatica

Extensively working on Informatica Designer, Workflow Manager, and Workflow Monitor

Informatica is used as ETL tool to extract data from different sources and to build Data Warehouse

Operational Highlights

Expert knowledge in FlexCube Investor Services (FCIS) and integration with (FlexCube Universal Banking) FCUBS applications.

Developing GUI using RAD tool (FLEXCUBE internal tool used to develop GUI)

Performance Tuning.

PL/SQL Programming.

Testing And Defect fixing.

Implementation and Support

Consulting in FCIS application.

Heading BAU Support and development life cycle.

Significant Accomplishments

Reviewed the entire transaction processing process and identified the pros and cons for the client SBFS

Developed around 600 reports in 10 months with a team size of 3 members.

100% development delivery within the committed time period.

Outstanding development quality with minimal defects.

Independently handled requirement gathering and function / design specification finalization.

Handled 20 million records data migration.

Distributor Commission Processing fine-tuned and processing time reduced from 28 hours to 6 hours.

Unit holder account statement generation process fine-tuned with the time benefit of 12 hours to 5 hours.

EDUCATIONAL CREDENTIALS

Bachelor of Technology (Computer Science)

SASTRA University in 2009.

Certification

ITIL Oracle internal certification

Foundation Program in Finance internal Certification

JANANI J

Address : apt 517,400 Camelot ct, Pittsburgh-15220

Contact : +1-412-***-**** (M)

Email : ac8bpw@r.postjobfree.com

AREAS OF EXPERTISE

- Transfer Agency/Mutual Funds

- PL/SQL

- Software Development Cycle

- BAU and Onsite Support

- Trouble Shooting

- Strategy Planning

- Requirement Gathering

- Client Handling

- UAT Coordination

- Implementation

- FS and DS

Documentation.

MANAGEMENT SKILLS

- Excellence in Analysis and

Problem Solving

- Sound Judgment and

Decision Making Skills

- Strong Influencing Skills

- Achievement oriented

Team Builder

- Persuasive Communicator

- Solution Delivery

Contact this candidate