Kranthikiran Chokkarapu Mobile: 996-***-****

Email: aceet0@r.postjobfree.com

Objective:

To obtain a challenging position in Business Intelligence domain,

where I shall handle challenging assignments and varied responsibilities to

make significant contribution towards the growth of the organization while

augmenting my professional and personal growth.

Experience Summary:

Is OBIEE (BIAPPS) technical consultant having 3.10 years of experience in

the areas of Oracle Business Intelligence Enterprise Edition

(OBIEE10g&11g), Informatica Power Center,Oracle Business Intelligence

Applications, Data warehouse Administration Console (DAC) and SQL

Professional Experience Details:

Presently working as a Senior Consultant with Apps Associates Pvt. Ltd,

Hyderabad.

Work focus is mainly on the areas of Informatica (8&9), OBIEE (10g&11g) and

Business Intelligence Applications (7.9.6.2 and 7.9.6.3).

Actively involved in training programs being conducted by the company to

provide the technology, knowledge and vision to the new recruits.

Expertise in Informatica Power Center, OBIEE (10g&11g) and Data Warehouse

Administration Console (DAC 10.1.3.4.1).

Extensive experience in analysis, design, modeling, development,

implementation, testing and support of various Business Intelligence

applications.

Have hands on experience in customizing the RPD 3 layers which includes

importing physical tables, developing BMM layer with dimensional modeling

concept, logical aggregations, dimensional hierarchies and presentation

layer.

Implemented the security in OBIEE10g/11g

Developed the BI custom Analysis and Dashboards, even customized the

standard reports & Dashboards

Worked on Agents and Presentation Security

Solid work experience with Informatica ETL tool (Mapping Design,

Development, Unit Testing Trouble Shooting & Debugging) and OBIEE10g/11g (

Building RPD 3 layers and developing reports)

Experience/Exposure with fine tuning Informatica mappings, sessions and

workflows.

Thorough experience with data extraction, transformation and loading using

data warehousing ETL tool Informatica

Extensively worked with Source Analyzer, Transformation Designer, Mapping

Designer and Mapplet Designer.

Worked on Mapplets, parameters and variables to facilitate the reusability

of code.

Worked on migration of ETL objects(workflows, mappings) from one instance

to another instance

Worked on DAC to run and schedule the Informatica workflows, passing the

variables.

Created DAC Subject Areas, Execution Plans to run the Informatica mappings.

Implemented the below modules in BIAPPS

Supply Chain & Order management

Financial Analytics

Project Analytics

Property Management Analytics

Fixed Analytics

Procurement and Spend Analytics

Technical Skills:

Languages SQL, PL/SQL

Databases Oracle 10G, 11g

Operating Systems Windows XP/98/2000,UNIX

BI Reporting Tools OBIEE 10g, OBIEE 11g, OBI Applications 7.9.6.x

ETL Tools Informatica Power Center 8.6.x, Power Center 9.01 HF2,

Data Warehouse Administration Console(DAC) 10.1.3.4,

Toad, SQL Developer.

Project Details:

Project VI Unity Reporting and Analytics

Client Celgene Corporation

Role OBIEE Developer

Tools OBIEE 11.1.1.7.0, Informatica - 9.1.0, and DAC -

11.1.6.4

Applications Financials, Procurement and Spend, Projects,SOCM and

HRMS

Website www.americantower.com

Project Description

Celgene Corporation is an American biotechnology company that manufactures

drug therapies for cancer and inflammatory disorders. It is incorporated in

Delaware and headquartered in Summit, New Jersey. Celgene Cellular

Therapeutics, a subsidiary, is a public cord blood bank. There are hundreds

of clinical trials at major medical centers evaluating compounds from

Celgene. The company's major products are Thalomid and Revlimid. Citing a

market capitalization of US$67 billion, and stock appreciation of 107%,

Celgene was Forbes Magazine's number 2 ranked drug Company of 2013.

Responsibilities:

As a Team Lead of the project, communicating with on site to discuss on

the requirements and assigning the tasks to the team members

Verifying the work done by team

Identifying, analyzing and implementing the solutions in Reporting

Designing the RPD with new objects and customizing the standard objects

Developing the new analysis, interactive dashboards and enhancing the

existing analysis with new columns, layout in OBIEE11g

Developing the new ETL objects(mappings, workflows) in Informatica and

loading the data into facts and dimensions through DAC

Validating the reports data against Source System (EBS) by preparing the

Validation Queries

Project V ATC- BI Support Project

Client American Tower Corporation

Role ETL Developer

Tools OBIEE 11.1.1.6.5, Informatica - 9.0.1, DAC -

10.1.3.4.1

Applications Financials, Property Manager and Fixed Assets

Website www.americantower.com

Project Description:

ATC is a leading independent owner and operator of wireless and broadcast

communication sites. In addition to leasing space on towers, it provides

customized collocation solutions through our Distributed Antenna Systems

that support seamless in-building and outdoor wireless coverage.

Project Involves the support to the BIAPPS project for Financial Analytics,

Project Accounting and Property Management modules

Responsibilities:

As a Team Lead of the project, communicating with onsite and clients to

discuss on the issues and assigning the tasks to the team members

Providing the support to the clients in BIAPPS project

Identifying, analyzing and implementing the solutions to the mentioned

issues related to ETL code, report level and data level in the LIVE (PROD)

environment

Developing the new ETL objects(mappings, workflows) in Informatica and

loading the data into facts and dimensions through DAC

Developing the new analysis, interactive dashboards and enhancing the

existing analysis with new columns, layout in OBIEE11g

Finally, giving training to the clients in Oracle BI domain.

Project IV BIAPPS - PA, FA and Financials Analytics

Implementation

Client American Tower Corporation

Role ETL Developer

Tools Informatica - 9.0.1, DAC - 10.1.3.4.1

Applications Financials, Property Manager and Fixed Assets

Website www.americantower.com

Project Description:

ATC is a leading independent owner and operator of wireless and broadcast

communication sites. In addition to leasing space on towers, it provides

customized collocation solutions through our Distributed Antenna Systems

that support seamless in-building and outdoor wireless coverage.

Project Involves the Implementation of Financial Analytics and Integrating

with Property Manager and Fixed Assets with Oracle BI Apps 7963 which

contains complete Implementation of PM and FA.

Responsibilities:

Identifying required Dimensions, Facts, Hierarchy tables and Designing the

star and snowflakes.

Creating the Required Informatica Mappings, Sessions, Workflows.

Creating Physical/logical Sources to the Oracle in the DAC.

Creating DAC Tasks, Subject Ares, Execution Plans.

Configuration of Informatica Repository, Integration Services in the DAC.

Customization of Out-Of-Box mappings, to extend the custom columns and to

integrate with other Out of box Modules.

Preparing Test-cases, Migration of Repositories from DEV to Test Instance.

Creating the Informatica Repository, Integration Services and importing the

Contents from the external repository files.

Co-ordinate with Onsite team and clients to gather the requirements

Identifying, and fixing the issues in PROD environment and giving the

support to the clients in their daily transactions

Project III Welch's BIAPPS Implementation

Client WELCH'S

Role ETL Developer

Tools Informatica - 8.6.1, DAC - 10.1.3.4.1, OBIEE 10.1.3.4

Website www.welchs.com

Project Summary

Welch's Implements the BI Apps modules Financials and SCOM Analytics and

Procurement and Spend Analytics. The development of reports based on client

requirements.

The current project involves, BI APPS implementation of current Trade

Management Project needs to extend the time dimension to week information

Responsibilities:

Creating the Required custom Informatica Mappings, Sessions, Workflows.

Creating Physical/logical sources to the oracle in the DAC.

Creating DAC Tasks, Subject Ares, Execution Plans.

Preparing Test-cases, Migration of Repositories from DEV to Test Instance.

Co-ordinate with Onsite team to gather the requirements

Supporting the project to solve and fixing the issues after development of

the project

Project II SMITHS DEMAND SPIKE SOLUTIONS

Client SMITH'S Medical

Role OBIEE Developer

Tools OBIEE 10.1.3.4,Oracle Apps 11i, Informatica - 8.6.1,

DAC - 10.1.3.4.1,

Website www.smiths.com

Project Summary

Smiths Medical is a leading global provider of medical devices for the

hospital, emergency, home and specialist environments. Our products are

used during critical and intensive care, surgery, post-operative care

during recovery, and in a series of high-end home infusion therapies.

Smiths Demand Spike Solutions is to bring data into custom table based upon

the logic and need to bring show this data in the reports for SCOM module

Responsibilities:

Gathering the requirements to load the data from Source to warehouse

through a package

Creating a package to load the data from Source data base custom target

table in the warehouse

Created a Concurrent Program in Oracle Apps 11i in SCOM module to load the

data from source to custom table

Developing the custom reports and dashboard.

Project I SMITHS SCOM BIAPPS IMPLEMENTATION

Client SMITH'S Medical

Role OBIEE Developer

Tools OBIEE 10.1.3.4

Applications Supply Chain & Order Management

Website www.smiths.com

Project Summary

Smiths Medical is a leading global provider of medical devices for the

hospital, emergency, home and specialist environments. Our products are

used during critical and intensive care, surgery, post-operative care

during recovery, and in a series of high-end home infusion therapies.

Smiths BIApps Implementation is developing reports by bringing the source

system data for SC & OM module to data ware house.

Project Involves the Implementation of Supply Chain and Order Management

Analytics with Oracle BI Apps 7963.

Responsibilities:

Identifying required Dimensions, Facts, tables and Designing the star and

snowflakes.

Customizing the RPD physical, BMM and presentation layer objects like

tables, joins between them, creating dimension hierarchies, logical and

aggregate tables, columns and Presentation tables, Subject Areas.

Creating new users and giving them required security levels

Creating Required custom reports, dashboards, ibots and assigning security

levels to these dashboards

Customizing the OOB reports, dashboards

Preparing Test-cases, Migration of Reports from DEV to Test Instance using

Catalog Manager.

Co-ordinate with Onsite team to gather the requirements

Supporting the project to solve and fixing the issues after development of

the project

Educational Details:

Master's Degree : Master of Computer Applications (MCA) with 67.6% from

OU.

Bachelor Degree : Bachelor of Science with 77.4% from Osmania

University.

Junior College : 10+2 with of 86.4% from Aravindo Junior College,

Choutuppal.

School : SSC with an 85.1% from VBHS, Choutuppal.

1 Personal Profile:

Name Kranthikiran. CH

Marital Status Unmarried

Sex Male

Nationality Indian

Contact Address Choutuppal, Nalgonda -508252

Career Achievements:

Awarded as a 'Best Resource' for the first project 'SMITHS SCOM BIAPPS

IMPLEMENTATION'

CONCLUSION:

I hereby declare that the above written particulars are true to best of my

knowledge and belief.

(Kranthikiran)

Contact this candidate