Manager Project
Resume:
G M KRISHNA PRASAD
Email id: ***********@*****.***
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