G M KRISHNA PRASAD

Email id: acg0q5@r.postjobfree.com

Phone no: +91-880*******

Synopsis

To be part of the leading team that delivers world-class solution for improving the efficiency

of the company by utilizing the resources effectively.

Professional Summary

More than 4 years of experience in Full System Development Life-Cycle Implementation of various

OBIEE, BI Apps and ETL like Informatica Projects.

Expertise in Configuring Repository using Administration Tool.

Experience in OBIA, OBIEE, OSSM.

Experience in Data Warehousing Concepts like Star Schema, Snowflake Schema Methodologies

Experienced in gathering reporting and analysis requirements, documenting the report specifications,

implementing the metadata layers including Physical, Business Model and Mapping, and Presentation

layer.

Create/Manage Dashboards, Answers and Delivers.

Extensive experience in OBIEE Administration Tool, OBIEE Answers, OBIEE Interactive

Dashboards, BI Publisher and iBots within OBIEE Suite.

Created Users, Groups and giving the permissions in Administration Tool and verified the permissions

of the users in the OBI domain.

Expertise in End to End system design, System Feasibility study, system redesign/engineering and

implementation with significant experience in Data Modeling/Data Quality Analysis.

Proficient in Merging/Importing Objects from Different Repositories using OBI Admin Tool.

Good experience in DAC Client, Server and Informatica.

Experienced in working with Variable Manager to define session and repository variables and

initialization blocks to streamline administrative tasks and modify metadata content dynamically.

Expert in using OBIEE Answers to create queries, format views, charts, and add user interactivity and

dynamic content to enhance the user experience

Experience in RPD security development. Experience in pulling session logs and debugging the RPD

detects.

Created, modified, and administered analytics Intelligence Dashboards with links to web sites; HTML

text; links to documents; and embedded content, such as images, text, chart; and tables.

Good exposure with BI Apps like HR Analytics, Financial Analytics.

Extensive experience in creating executive reports with BI Publisher integrated with OBIEE.

Up gradation Obiee10g to Obiee11g.

Had knowledge with ODI.

Good experience with Informatica and DAC.

Ability to rapidly learn new concepts together with excellent interpersonal skills.

Excellent problem solving skills with a strong technical background and result oriented team player

with excellent communication and interpersonal skills.

Academics:

B.Sc(Computer Science) from Acharya Nagarjuna University

Professional Experience

Currently working as OBI developer in Gateway Techno labs from April 2012 to till date.

Working as a BI Consultant in ITCG Solutions Pvt. Ltd from July 2010 to March 2012.

Technical Skills:

Reporting Tools : OBIEE 10g/11g, OBIA

ETL Tools : Informatica, DAC, ODI

Database : Oracle, SQL Server

Operating Systems : Windows, UNIX and MS-DOS.

Languages : SQL, C, HTML.

Case Tools : Oracle SQL Developer.

Project 4: Nordic IT

Client: Nordic IT

Environment: OBIEE,OBIA,OSSM,BI Publisher, Ldap Security, Informatica, DAC, Oracle Ebs, winscp,

putty, Sql Developer, Windows/Unix, BMC Remedy.

Description: Nordic IT has been helping businesses communicate more efficiently since the early 1980’s. A

lot has happened since, and while the digital revolution has created more and more options, they have used

the technological possibilities as a crucial tool in crafting the most innovative and time-saving software

system, as well as providing the most efficient and up-to-date IT support for clients all over the world. They

believe in personal and face-to-face interaction with our clients. That is why we are proud to say we have a

multicultural staff situated in offices all around the world, ready to serve clients in their homeland. With

Headquarters in Copenhagen, our offices currently include Singapore, Russia, Dubai and Shanghai, as well

as our partners in Canada, Germany, Norway, Netherlands, Hong Kong & China.

Roles and Responsibilities:

• Interacted with the business users in analyzing and preparing the OBI data, report requirements.

• Created MUD (Multi User Development) environment by utilizing projects in OBIEE.

• Created/Modified Metadata repository (.rpd) by using Administration Tool: Physical, Business Model

and Mapping and Presentation Layers.

• Created connection pools, imported the physical tables and then creating aliases, defined joins and

implemented authorizations in the physical layer of the repository.

• Involved in creating reports using OBIEE Answers using forced selection prom pts, OBIEE XML

editing, common go button for multiple prompts, guided navigation,GO URL and many other

features.

• Developed the necessary star schemas in the BMM layer and modified them in order to accommodate

the new business requirements.

• Created different Hierarchies, Levels and implemented Business Logic by creating level based

measures.

• Developed the Facts, Dimensions, necessary hierarchies and complex joins between the logical

tables, adding aggregates in the BMM layer.

• Creating Users and Groups and managing the object level and data level security.

• Implemented the external table authentication and utilized the external table by implementing dynamic

session variables and Initialization blocks in repository.

• Extensively used different performance tuning methods like Caching, Aggregate tables and creating

indexes on tables.

• Developed many Ad-hoc and standard Reports / Dashboards with different Analytics Views (Drill-

Down / Dynamic, Pivot Table, Chart, Column Selector, Tabular with global and local Filters) using in

the OBIEE framework.

• Developed reports using Drill across, Drill down using hierarchies like Geography, Position, product

and also the dashboards based on (Groups, Aggregated Navigation, Time series wizard, Slowly

changing dimension, caching strategy).

• Involved in unit, integration testing and User Training of the generated reports using Analytics.

• Proficient in creating report templates using BI Publisher.

• Experience in BI Publisher with reference to calling templates from one template to another template

and in calling stored procedures in BI Publisher reports.

• Worked using Catalog manager to migrate web catalog between different instances.

• Designed and Developed Financial dashboard like General Ledger, Payables, Receivables.

• Designed and Developed Custom Dashboards.

• Experience in HR analytics and financial analytics.

• Configured iBots using Delivers, Job Manager to deliver Analytics content through mail, phone to

business users based on schedule.

• Prepare monthly reports and represent it to the management.

• Attending priority meetings with the clients and understanding the business needs.

Project 3: Nin Tech

Client :Nin Tech

Environment : OBIEE, OBIA, BI Publisher, Oracle Ebs, Oracle, Informatica, Winscp, Putty.

Description: Nintec Group is the leading ICT & Global Sourcing Group headquartered in the Zoetermeer,

The Netherlands. We specialize in transforming our customer’s business continuously by providing right

insight, deploying the best suited technology and making our customers’ business further simpler, faster &

better. Globally, NINtec has customers in 30 countries across 5 continents through its global subsidiaries with

5 development centers and 15 client serving/sales offices across 14 countries. NINtec Group employs 1400

brilliant team members as on Jan 31, 2012.

Roles and Responsibilities:

• Enhancement and customization of the existing reports as per the user specifications.

• Involved in Creating OBIEE Interactive Dashboards.

• Object and Data level Security Implementation.

• Mock up Design for Demo to Client.

• Enhancement and customization of the existing reports as per the user specifications.

• Involved in creating reports using OBIEE Answers using forced selection prompts, OBIEE XML

editing, common go button for multiple prompts, guided navigation,GO URL and many other

features.

• Created Metadata in OBI Admin tool, Configured Connection Pools, Data Sources, and DSN to suit

the technical environment.

• Defined Primary key - Foreign key relationships, complex joins between dimension tables and Fact

tables in the physical layer and BMM layer.

• Created Business model with logical tables in the Logical Display folders.

• Created Dimension Hierarchies in Business Model layer for Drill down functionality.

• Created presentation layer with catalog folders, to show different views of the business model to

different users and group assigned permissions to the catalog folders.

• Defined static and dynamic repository variables to modify metadata content dynamically as well as

statically so that it can adjust to a changing data environment.

• Created calculated logical columns according to business requirements.

• Designed various reports with Drilldowns, Pivot Tables, Bar charts, and Pie charts, Narrative Views,

Legends and Guided Navigation.

• Extensively worked on Combine Similar Request features in Answers to satisfy critical report

requirements.

• Worked Extensively on OBIEE Answers to create the reports as per the client requirements.

• Filters and Filter’s criteria were created and configured according to the business requirements.

• Maintained Effectiveness in creating the Dashboards by appropriately including guided navigational

links and drilldowns.

• Enforced criteria based navigation to achieve better SLA on Ad hoc queries based on customer

origination and industries.

• Created groups in the repository and added users to the groups and granted privileges explicitly and

through group inheritance.

• Maintained effectiveness in creating the dashboards by appropriately including guided navigational

links and drilldowns. Setup the visibility of dashboards to employees with respect to their

responsibilities.

• Involved in Performance Tuning of reports by identifying the indexes required on the backend

tables and also from the data available in the Cache.

• Experience in HR analytics and financial analytics.

• Worked using Catalog manager to migrate web catalog between different instances.

• Repository Testing and validation before exposing Business Models in the Presentation layer.

• Validated Data with SQL Queries against OLAP, debug data issues.

Project 2: DIS

Client : Diamond Info systems, India

Environment : OBIEE, OBIA, Informatica, power center, Siebel CRM, SQL Server, TOAD.

Description: The Linde Group is a world-leading gases and engineering company with approximately

63,500 employees working in more than 100 countries worldwide. Linde Engineering, a division of the

Linde Group, is a leading world-wide technology partner for plant engineering and construction.

Linde’s global success is built on Linde’s extensive process engineering expertise in the planning,

project development and construction of turnkey industrial plants. With more than 1,000 process

engineering patents and 4,000 completed plant projects, Linde ranks among the leading international

plant contractors.

Roles & Responsibilities:

• Worked closely with Business Analyst in understanding the BI and reporting requirements and created

the business model for generating reports as per the user requirements.

• Worked closely with the data modeler in designing the logical data model in star schema in BMM

Layer.

• Configured and created repository using OBIEE Administration Tool.

• Created and administered the Physical Layer, Business Model and Mapping Layer and Presentation

Layer in Repository using Administration Tool.

• Developed calculated measures and assigned aggregation levels based on dimension hierarchies.

• Managed security privileges for each subject area and dashboards according to the requirements.

• Developed various kinds of request queries using BI Answers and assigned them to specific

Dashboards.

• Configured iBots to deliver BI content to subscribers based on schedule and events.

• Created Security settings in OBIEE Administration Tool to set up groups, access privileges and query

privileges and also managed security for groups in Answers.

• Developed intuitive and user friendly Dashboards by appropriately including guided navigational

links, prompts, and drilldowns.

• Used the Catalog manager and maintained the Oracle BI web catalog to manage Dashboards, Answers.

• Involved in unit testing, integration testing of the reports generated by OBIEE.

• Created Mappings using Mapping Designer to load the data from various sources, using different

transformations like Unconnected and Connected lookups, Router, Aggregator, Joiner, Stored

Procedure and Update Strategy for Daily Load.

• Setup the visibility of dashboards to employees with respect to their responsibilities.

• Created groups in the repository and added users to the groups and granted privileges explicitly and

through group inheritance.

• Performance tuned highly complex reports by creating indexes, aggregate tables, materialized views.

• Worked with Element tool for logging and tracking and fixing bugs in QA Testing.

Project 1: Rubamin

Client: Rubamin

Environment: OBIEE, Informatica, Oracle 10g, Siebel CRM, SQL Developer, SQL*Plus, Windows.

Description: Rubamin’s core business activities comprise manufacturing of Specialty Metal Chemicals,

Metal Intermediates and Mineral Exploration. Rubamin has operations in India, U.A.E. & Democratic

Republic of Congo.Rubamin's competence in Hydro and Pyro-Metallurgy processes, acquired over 25 years,

delivers superior quality products through recycling of metal bearing secondary materials. It is the largest

producer of Zinc Oxide in India with a group turnover of about USD 150 million. The group comprises of

three Strategic Business Units (SBUs) with a strong and motivated workforce of over 1000 employees

supplying quality products that are relevant, reliable, consistent and safe. Its six production units are capable

of producing 30,000 TPA of Zinc Oxide and other Zinc Chemicals, 20,000 TPA Copper and 450 TPA

Molybdenum Compounds.

Roles & Responsibilities:

• Interaction with the end users for the requirements

• Prepared Technical Design Documents (TDD) of the complete implementation of the Business Module

and User Guides for the use of Siebel Analytics.

• Participated in complete life cycle of the project from Project Initiation,

to Development and Maintenance.

• Designed repository, with complex Time Series Calculations, for prior months/ quarters/ years.

• Created Presentation catalogs, and Folders in Presentation Layer, and Performed Global Consistency

Check in OBIEE Administration Tool.

• Involved in performing the Impact Analysis of Migration.

• Built Reports and Dashboards for Business Users, and Set up Usage Tracking database.

• Implemented Dynamic Dashboard Prompts to zoom into different segments of the customers and

Brokers, to achieve performance optimization and easy navigation of reports.

• Enhanced Query performance, by analyzing & modifying SQL Query and Filters, for all the reports

and dashboard prompts, to minimize the delay in Physical Query Execution.

• Enabled OBIEE Delivers using iBots for delivery of reports to business users, by setting up Scheduler

and configuring Job Manager.

• Implemented Comprehensive Security Model, by creating User Roles, Web Groups and setting

up External Table Authentication.

Contact this candidate