SUMMARY:

** ***** ** ******** **** Cycle (Gathering Business Requirements, GAPS Analysis, identifying & analyzing the source/feeder systems, Design & Data Modeling, Development, and Testing) implementation experience of Enterprise Business Intelligence (EBI) using Oracle BI.

Extensive experience in OBIEE Presentation Services including Answers, Interactive Dashboards, Delivers/IBOTS, Cache Management, Scheduler Configuration, BI Publisher

Extensive experience in Informatica including mappings, workflows.

Extensive experience in scheduling jobs, monitoring jobs in DAC.

Experience in Essbase, ODI, and Planning as administrator.

Experience in Informatica Installation in AIX

Good in analyzing, customizing, development, and implementation of OBIEE pre-built Analytics (BI Apps).

Experienced in Global Delivery Model (Onsite/Offshore). Coordinated activities onsite & offshore towards meeting project timelines

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

Integrated BI Publisher with OBIEE to build reports in word, excel and doc format.

Created various templates, reports, and parameters in BI Publisher.

Expertise in creating RTF templates with Photo images.

Expert in designing, development, and implementation of OBIEE pre-built Analytics with Informatica.

Expertise in OBIEE & OBIA Installation to set up the environment for Development/Testing/Production

Experience in OBIEE HA set up

Extensive experience in changing custom style sheets like changing logos, links on main pages etc.

Experience in migration of Essbase applications, planning, ODI artifacts, OBIEE objects across various environments

Experience in Security setup for Essbase, Planning, ODI, OBIEE

Good knowledge on Tableau

Good exposure on Snowflake Data Warehouse

Experience in applying patches

Experience in data loads, backup monitoring

Experience in Installation and configuration of Hyperion Products, OBIEE, ODI

Troubleshooting End user issues like smart view, data mismatch, HFR report related issues, etc.

Experienced in Global Delivery Model (Onsite/Offshore). Coordinated activities onsite & offshore towards meeting project timelines

Expertise in developing Dashboards/Reports using Oracle BI Publisher.

Expert in developing BI Publisher templates using template builder/xslt code, also have knowledge in building templates using excel.

An enthusiastic and project-oriented team player with solid communication and leadership skills and the ability to develop creative solutions for challenging client needs.

Results oriented, self-starter looking for challenges, ability to rapidly learn and apply new technologies and good interpersonal skills.

ACADEMIC ACCOLADES:

Master of Science in Mathematics, Nagarjuna University, AP, India.

TECHNICAL SKILLS:

BI Tools: Siebel Analytics 7.x, OBIEE 11g,

BI Publisher, BI Delivers, OBIEE Dashboards, OBIEE Answers, BI Apps 7.9.x.

Hyperion Product suite like Essbase 11, Planning, HFR

Languages: PL/SQL, HTML, XHTML and XML

Operating Systems: Windows NT, Windows 2000/98/95, LINUX, AIX

Databases used: SQL Server 2005, Oracle 9i/8i/10g, and MS Access

ETL: Informatica Power Center 9.1/8.6.1,8.1/7.5.3/7.1.4,ODI

Dimensional Data Modeling: Start &Snowflake

TRAIINGS:

SQL, PL/SQL – GE, CT.

OBIEE - Building RPD, Answers and Dashboards – GE, CT..

Six Sigma Green Belt – GE, CT.

AWARDS:

Received OBIEE STAR Award from the Client (GE).

EXPERIENCE DETAILS

Department of Transportation(DOT), D.C., USA Oct ’17 to till date

OBIEE & BIP Developer/Admin & Informatica Developer/Admin

Environment: Oracle Business Intelligence (OBI) EE 11.x, OBIEE 12C, BI Publisher 11.x, Oracle 11g, Informatica 9.5.1,DAC 11g.

Projects Undertaken:

Risk assessment and risk management are integral to the hazardous materials transportation safety program. The Office of Hazardous Materials Safety is currently instituting a risk management framework to set and guide priorities to ensure that PHMSA is a risk-based Organization. PHMSA’s risk management framework identifies and defines the main elements of risk management in hazardous materials transformation and is supplemented by specific methods, tools, and guidance documents.

Responsibilities:

Used Informatica Power Center for (ETL) extraction, transformation and loading data from heterogeneous source systems into target database.

Created mappings using Designer and extracted data from various sources, transformed data according to the requirement.

Analyzed relationships of Flat Files and to extract the analyzed systems, met with end users and business units in order to define the requirements

Documented user requirements, translated requirements into system solutions and develop implementation plan and schedule.

Installation and Patching on OBIEE/Informatics/DAC and WebLogic servers.

Developed data Mappings between source systems and warehouse components.

Developed ETL procedures to ensure conformity, compliance with standards and lack of redundancy, translates business rules and functionality requirements into ETL procedures.

Developed and tested all the backend programs, Informatica mappings and update processes.

Created and Monitored Batches and Sessions using Informatica Power Center Server.

Responsible to tune ETL procedures and STAR Schemas to optimize load and query performance.

Extensively worked in the performance tuning of the programs, ETL Procedures and processes

Written documentation to describe program development, logic, coding, testing, changes and corrections.

Created OBIEE

Expert in designing and developing Rpd (repository) using OBIEE Admin tool. Developing all the three layers (Physical, Business Model and Mapping, Presentation) with oracle’s best practices.

Developing Reports/Dashboards using OBIEE front end (OBIEE Presentation Services). Created Reports using different views like table, pivot, narrative, filter, compound etc based on the requirement.

Developed Interactive Dashboards using dashboard prompts, attractive landing pages, with multiple links, Guided navigations, Answer queries, BI Publisher reports. Formatting Reports/Dashboards with attractive colors, wordings, font as per client’s requirement.

Developing highly formatted reports using BI Publisher, developing multiple rtf templates, Used Answer Queries as source, implemented stitching technology in the template to meet client’s requirement.

Provided the solutions for many Business Questions

Involved in Training the Business Users for better utilization of all advanced features of OBIEE Tool.

EXPERIENCE DETAILS

Gilead Services (CTS Contractor) Aug ’17 to Oct ‘17

OBIEE & BIP Developer/Admin & Informatica Developer/Admin

Environment: OBIEE 12C, BI Publisher 11.x, Oracle 12C, Informatica 10

Responsibilities:

KT from customer

RPD migration from one environment to other in 12C.

EXPERIENCE DETAILS

Department of Transportation(DOT), D.C., USA Oct ’16 to Aug ‘17

OBIEE & BIP Developer/Admin & Informatica Developer/Admin

Environment: Oracle Business Intelligence (OBI) EE 11.x, OBIEE 12C, BI Publisher 11.x, Oracle 11g, Informatica 9.5.1,DAC 11g.

Projects Undertaken:

Risk assessment and risk management are integral to the hazardous materials transportation safety program. The Office of Hazardous Materials Safety is currently instituting a risk management framework to set and guide priorities to ensure that PHMSA is a risk-based Organization. PHMSA’s risk management framework identifies and defines the main elements of risk management in hazardous materials transformation and is supplemented by specific methods, tools, and guidance documents.

Responsibilities:

Used Informatica Power Center for (ETL) extraction, transformation and loading data from heterogeneous source systems into target database.

Created mappings using Designer and extracted data from various sources, transformed data according to the requirement.

Analyzed relationships of Flat Files and to extract the analyzed systems, met with end users and business units in order to define the requirements

Documented user requirements, translated requirements into system solutions and develop implementation plan and schedule.

Installation and Patching on OBIEE/Informatics/DAC and WebLogic servers.

Developed data Mappings between source systems and warehouse components.

Developed ETL procedures to ensure conformity, compliance with standards and lack of redundancy, translates business rules and functionality requirements into ETL procedures.

Developed and tested all the backend programs, Informatica mappings and update processes.

Created and Monitored Batches and Sessions using Informatica Power Center Server.

Responsible to tune ETL procedures and STAR Schemas to optimize load and query performance.

Extensively worked in the performance tuning of the programs, ETL Procedures and processes

Written documentation to describe program development, logic, coding, testing, changes and corrections.

Created OBIEE

Expert in designing and developing Rpd (repository) using OBIEE Admin tool. Developing all the three layers (Physical, Business Model and Mapping, Presentation) with oracle’s best practices.

Developing Reports/Dashboards using OBIEE front end (OBIEE Presentation Services). Created Reports using different views like table, pivot, narrative, filter, compound etc based on the requirement.

Developed Interactive Dashboards using dashboard prompts, attractive landing pages, with multiple links, Guided navigations, Answer queries, BI Publisher reports. Formatting Reports/Dashboards with attractive colors, wordings, font as per client’s requirement.

Developing highly formatted reports using BI Publisher, developing multiple rtf templates, Used Answer Queries as source, implemented stitching technology in the template to meet client’s requirement.

Provided the solutions for many Business Questions

Involved in Training the Business Users for better utilization of all advanced features of OBIEE Tool.

EXPERIENCE DETAILS

Wyndham Worldwide, NJ, USA

(CTS Contractor from May 2015 to Dec 2015, CTS Full Time from Dec 2015 to Oct 2016) May ’15 to Oct ‘16

OBIEE/Informatica Manager/Admin & BIP Developer/Admin

Environment: Oracle Business Intelligence (OBI) EE 11.x, OBIEE 12C, BI Publisher 11.x, Oracle 11g,Informatica 9.5.1.

Projects Undertaken:

Primary Responsibility is to manage and Support the entire Wyndham OBIEE environment. To Resolve the Open Incident Tickets by going through the SDLC life cycle. Develop several Projects as part of Data ware house Setup .to Analyze an incident, prioritize that assign to appropriate Team member, Build the Solution, validate with different Test Plans and then Promote that Incident to Production. Designed the Metadata and data warehouse using Informatica for different Applications like clarity Manhattan and other Operational Data Sources. Based on the vast User base at Wyndham.

As part of Accounts Payable project, Developed ETL, Developed RPD, Developed Reports related to vendor Master Details, Payments by method, Cash flow Reports which are being used by Top Management.

Responsibilities:

24*7 support for Wyndham OBIEE Environment

Migrating RPD & reports from 11 to 12C.

Configuring Map Viewer.

Migrated ETL mappings from 8 to 9.

Migrated BIP reports from 11 to 12C.

Created PDF, Excel and RTF templates in BI Publisher.

Created BI publisher reports with the basis of OBI Analysis, SQL queries & Web services.

Scheduled BIP reports to share mounts & emails.

Developing highly formatted reports using BI Publisher, developing multiple rtf templates, Used Answer Queries as source, Implemented stitching technology in the template to meet client’s requirement.

Involved in providing solution for Security Implementation

Installation on OBIEE 12C

Migrated reports, dashboards & BI Publisher reports from 11g to 12C in DEV/QA environments.

Involved in Release Management while promoting the Changes to Prod Monthly or Quarterly

Provided the solutions for many Business Questions

Configured and Implemented Financial Analytics at Wyndham

Involved in Training the Business Users for better utilization of all advanced features of OBIEE Tool

La-Z-Boy, Michigan, USA Jan ’15 to May ’15

OBIEE Development

Environment: Oracle Business Intelligence (OBI) EE 11.x, BI Publisher 11.x, ODI, BI Apps 7.9.x, Oracle 11g, Snowflake Data Warehouse

Projects Undertaken:

Furniture chain known for its signature recliners, plus sofas & more (some with design services).

An out of the box reporting solution with 50% customization as per the client’s requirement. This is used to analyze

Responsibilities:

Working in OBIEE Answers to build various reports like Static Text view, Pivot table view, narrative view etc.

Used View Selectors, column sectors, Filter views, “No Result Views”.

Understanding requirements and customizing the Repository to meet the requirements

Created Physical joins, logical joins and complex joins in physical and BMM Layer

Implemented complex data models in Business and Physical Layer.

Extensively worked with complex reports.

Walgreens, Chicago, USA Apr ’14 to Jan ’15

OBIEE/Informatica/ODI/ESSBASE/Admin & Development

Environment: Oracle Business Intelligence (OBI) EE 11.x, BI Publisher 11.x, ODI, BI Apps 7.9.x, Oracle 11g.

Projects Undertaken:

Walgreens is a famous Retail Drugstore chain in the Unites States. It is the Nation’s Largest Drugstore chain with fiscal 2012 net sales of about $72 billion. It sells Prescription and Nonprescription Drugs, Beauty products and general Merchandise through 8400 Retail outlets across the 50 states of the Unites States. Today, Walgreens is much more than a traditional Drugstore; it is a global pharmacy-led, health and wellbeing enterprise inspired by a humble purpose: To help people Get well, Stay well and Live well.

Research and Development of an Application which basically provides clients an ability of generating reports out of General Ledger (GL) finance data to analyse their business and find out the key areas. This also consists of Out of the Box Reports with a facility of generating Ad Hoc reports.

As part of Finance module developed/supported an application for General Ledger(GL) using Oracle Business Intelligence Enterprise Edition and Oracle BI Publisher. Making use of Oracle pre-built application (BI Applications) as the base and with 70% customization.

Responsibilities:

Experienced in Installation and configuration OBIEE on various servers and System Administration using AIX.

Installation/Configuration/Administration of Oracle Business Intelligence Enterprise Edition

Maintenance of Oracle Business Intelligence Enterprise Edition

Administer ETL and data warehousing applications and tools

Understand the standard of best practices in BI administration environment

Good problem solver and prompt decision maker

Having recent OBIEE testing experience developing test strategies on a data warehouse project.

Migration of applications across environments.

Executing ODI load plans.

Monitoring of jobs related to data loads and backups.

Providing access to new users.

Troubleshoot of production issues like security issues, application issues, smart view report related.

Working with Oracle on SR’s related to any bugs.

Coordination with varies IT teams for server’s maintenance

Validated backend database when doing master data validation.

Good experience in onsite-offshore model.

McKinney & Company, NY, USA Sep ’12 to Mar ‘14

OBIEE & Informatica Admin/Development Lead

Environment: Oracle Business Intelligence (OBI) EE 11.x, BI Publisher 11.x,

9.x, BI Apps 7.9.x, DAC, Oracle 11g, AIX 7.

Projects Undertaken:

HR Reporting: An out of the box reporting solution with 70% customization as per the client’s requirement. This is used to analyze Employee’s Compensation and Personal information.

Responsibilities:

Interacted with business team and vendors to gather Business Requirements as well as to define business and functional specifications.

Build OBIEE environment for DEV/SIT/PROD AIX.

Installed all the components separately by selecting Software Only when installing OBIEE.

Applied latest OBIEE Patches.

Build OBIEE in 2 servers in that second one is Scaled Out.

Done OBIEE HA set up in all the servers.

Build Informatica environment in AIX.

Modified Config files in OBIEE.

Implemented company LOGO instead of default Oracle logo.

Provided user training to make users familiar with new OBIEE 11g environment.

Prepared hardware sizing document.

Designed and Developed new security model for 11g based on the new 11g security setup (roles and policies).

Setting up the Administered Privileges and Security for various users using the LDAP security.

Documented all the different technical and functional aspects of the project.

Performed stakeholder analysis team and weekly status reports to leadership teams

Bank Of America, NJ

Company Name : TCS, Hyderabad, India Jun ’10 Aug ‘12

OBIEE Admin/OBIEE Development Lead

Environment: Oracle Business Intelligence (OBI) EE 10.x, BI Publisher 10.x, Informatica 8.x, BI Apps 7.9.x, DAC, Oracle 11g, Teradata, Exadata, UNIX.

Projects Undertaken:

Human Resources Learning Management and Completion: An out of the box reporting solution with 50% customization as per the client’s requirement. This is used to analyze

Employee’s learning information.

Human Resources Workforce Management: An out of the box solution with 60% customization. This is used to analyze employee’s Talent Planning, Performance Management and Competency data.

Responsibilities:

Participated in multiple end to end implementations which consists of gathering requirements from multiple user groups, analyzing Business Requirements Documents (BRD’s), preparing high level and low level design documents, Development, Support.

Participated in Business Requirement Documents review, HLD, LLD and Data Model Reviews to understand the requirements and to prepare the necessary design documents accurate.

Participated in GAP analysis, Impact Analysis.

Expert in presenting the designs to business and in getting signoffs with some report mockups (without actual developing the reports).

Merging RPD’s and catalog migration.

Supporting Infrastructure team in merging multiple projects from multiple development teams into one development rpd and deploying it into server. Preparing SIT, UAT, Production deployment checklists, testing the environments after each and every deployment.

Implementing MUD (Multi User Development) environment across the whole organization which helps in smooth, easy, fast rpd development.

Expert in designing and developing Rpd (repository) using OBIEE Admin tool. Developing all the three layers (Physical, Business Model and Mapping, Presentation) with oracle’s best practices.

Developing Reports/Dashboards using OBIEE front end (OBIEE Presentation Services). Created Reports using different views like table, pivot, narrative, filter, compound etc based on the requirement.

Developed Interactive Dashboards using dashboard prompts, attractive landing pages, with multiple links, Guided navigations, Answer queries, BI Publisher reports. Formatting Reports/Dashboards with attractive colors, wordings, font as per client’s requirement.

Developing highly formatted reports using BI Publisher, developing multiple rtf templates, Used Answer Queries as source, implemented stitching technology in the template to meet client’s requirement.

Supporting Infrastructure team in merging multiple projects from multiple development teams into one development rpd and deploying it into server. Preparing SIT, UAT, Production deployment checklists, testing the environments after each and every deployment.

Implementing MUD (Multi User Development) environment across the whole organization which helps in smooth, easy, fast rpd development.

Tracking Production Issues, SIT Defects, UAT Defects in Quality Center and Fixing, deploying the changes in all the environments them with very less time.

Participated in Release Management work which consists of raising TFS, Maximo tickets for code deployments in to different environments (SIT, UAT, and Production).

Documenting all the changes and maintaining them in SharePoint sites which help future enhancements.

Leading a team of 3 members (Offshore), Delegating work equally and effectively among team, helps in meeting the deliverables.

Performing Unit testing, providing test cases for the QA team (TCOE).

General Electric, CT July ’07 – June ‘10

Sr OBIEE Developer

Company Name: iGATE,Bangalore,India

Project : Org Hierarchy.

Environment : OBIEE 10.1.3.2, Informatics 7.X, Peoplesoft reports

Description:

In GE Corporate Current Organization Hierarchy is defined for four levels. Now Executives (Users) wants to see the data for further Levels in the current Organization Hierarchy. In the new Hierarchy, Organizations are expanded up to fifteenth level and providing the measures Employee count, Head count, New Hire Count, Promotion Count attached by Supervisor, Band, Gender, Payroll, Diversity, Function, Country and Organization.

OBIEE (Oracle Business Intelligence Enterprise Edition) has used as front end tool to generate dashboards In these reports users can see the Metrics Summary and then can drill down the reports. By looking at these reports GE High Level Managers can analyze the movements within GE and can take the corrective decisions.

Responsibilities:

Created Physical joins, logical joins and complex joins in physical and BMM Layer

Implemented complex data models in Business and Physical Layer.

Extensively worked with complex reports.

Working in OBIEE Answers to build various reports like Static Text view, Pivot table view, narrative view etc.

Used View Selectors, column sectors, Filter views, “No Result Views”.

Prepared test plans and documented test results

Went through UAT (User Acceptance Test). There were data issues as well which were resolved within specified time.

Resolving issues faced in production environment.

Interacting with customer to understand the requirement via email, Same Time (ST), telephone.

Code review, FE review, suggesting the possible solutions for problems, taking part in internal meetings.

Environment : OBIEE 10.1.3.2, Informatics 8.X, Oracle 9x,

Project : Churn.

Description:

GE managers and leaders need to track the movement/churn within their organizations/populations for effective decision-making and also to take corrective actions. The key areas of interest for tracking with movement include Hires, Terminations, Transfers, Promotions/Demotions, Country/Pole Changes, Business Function Change, Assignment Category Change etc. These metrics have to be analyzed across dimensions of Gender, Diversity, Band, and Organization.

Responsibilities:

Understanding requirements and customizing the Repository to meet the requirements

Created Physical joins, logical joins and complex joins in physical and BMM Layer

Implemented complex data models in Business and Physical Layer.

Extensively worked with complex reports.

Documentation of various activities in the project

Created new Dashboard for Churn.

Prepared test plans and documented test results

Understanding the quality process and implementing the same in the project quality assurance.

Environment : OBIEE 10.1.3.2, Informatics 8.X, Peoplesoft reports

Project : GEN 1.

Description:

GE Leaders need up-to-date HR Data to drive decision making, and need the data “at their fingertips” to do so. GE also wanted to establish a single-source of reliable HR dashboards to deliver consistent metrics quickly and have better line-of-sight over the $26 billion spend on Human Capital. The possible critical HR Metrics looking forward by client is like: Headcount, Attrition, Diversity, Compliance, Churn etc. with metrics being added incrementally. Also, GE needs a single consistent metric definition to be used by all of GE businesses. The scope of GEN1 project was Headcount, Attrition and Diversity. The total user base for the project is about 4500 people with 200 of them being High Level Managers.

Responsibilities:

Created Physical joins, logical joins and complex joins in physical and BMM Layer

Created reports using Pivot, Table, Chart views

Extensively worked with complex reports.

Enhancing the subject areas as and when suggested by the business analysis

Customized requests by using different views (Chart, Pivot table etc,)

Contact this candidate