Kavya

• 7+ Years of hands on Working Experience on Oracle Platform as Oracle BI Consultant.

• Strong experience in Oracle Analytics Cloud.

• Strong experience in Oracle Autonomous Data warehouse.

• Strong experience in Oracle Business Intelligence Cloud Service (Modeling and Report

Development).

• Strong experience in Oracle Data Visualization Cloud Service.

• Strong experience in OBIEE 11g/12c Dashboard, KPIs, Scorecard Development.

• Strong experience in OBIEE 11g/12c Security Development.

• Extensively worked on OBIEE Repository development.

• Installation Oracle DB 11g, OBIEE 11g/12c, ODI on Windows/Linux, Problem

finding and Solution.

• Strong experience in Data Warehousing and ETL using ODI(11g/12c).

• Extensively worked on data extraction, Transformation and loading data from various sources like

Oracle and Flat files.

• Well versed in developing the complex SQL queries, complex joins and oracle analytical functions.

• Experience in developing the Interface, Packages, Procedures, Scenarios and Load Plan using

ODI(Oracle Data Integrator) 11g / 12c.

• Data Warehouse Design.

• Well versed in UNIX shell scripting.

• Requirement Gathering, Analysis/Feasibility Study.

• Documentation of Technical Specification.

Project # 1

Title                                      :   Citizens development team

Client                                   :   Citizens Financial Group

Environment                   :  ODI & OBIEE, SQR  

Role                                      :   ODI consultant

Duration                             :   Jan 2020 to Till Date

Description:

Citizens Financial Group, Inc. is one of the oldest and largest financial services firms in the United States. Citizens offers retail and commercial banking products and services to individuals, small businesses, middle-market companies, large corporations and institutions.

                   The bank has been award-winning mobile apps, robust online offerings, a 24/7 customer contact center and the convenience of a large ATM and branch network that spans 11 states, As the 13th largest retail bank in the United States, It’s deliver a broad range of financial services to over five million individuals, companies, not for profits, and institutions.

Responsibilities:

• Involved in ODI development activates such as creating mapping, packages and load plans.
• As per business requirement, I have done some POC and understood SQR code logic, which has generated by people soft and replicated the same code logic in ODI.
• Worked on Proof of Concepts to check the design feasibilities and finalize the Integration Patterns with the Pros and Cons.
• Extensively worked on complex logic such as loading data from table to file and encrypting the file by using pgp. scripts and transfer the file to client SFTP server.
• Expertise and good understating in debugging agent logs & server log files to diagnostic infrastructure level issues.
• Having good hands on experience in performance tuning at SQL and ODI level
• Experience in implementing on Cloud extract and incremental extract by using Incremental IKM knowledge module.
• Experience in customization in IKM knowledge module to achieve complex requirement.
• Got good opportunity to involve in unit testing and migrating the code to dev to test, test to Prod instance.
• Coordinating effectively with offshore and onshore teams on all the technical aspects and code defect fixes and resolving issues in time.
• Good hands-on experience in enhancing the code logic as per client request.