SUMMARY

• 10 years and months of Complete Life 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 withBI Publisherintegrated with OBIEE and SQL queries.
• IntegratedBI Publisherwith 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
• Experience in migration of Essbase applications, planning, ODI artifacts, OBIEE objects across various environments
• Experience in Security setup for Essbase, Planning, ODI, OBIEE
• 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.

TECHNICAL SKILLS

BI Tools: Siebel Analytics 7.x, OBIEE 11.1.1.5.0 (11g)/ 10.1.3.4/10.1.3.3 BI Publisher, BI Delivers, OBIEE Dashboards, OBIEE Answers, BI Apps 7.9.x.

Hyperion Product suite: 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

PROFESSIONAL EXPERIENCE

Confidential

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.

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.
• 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

Confidential, NJ

OBIEE Developer/Admin & BIP Developer/Admin

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

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

Confidential, Michigan

OBIEE Development

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

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.

Confidential, Chicago

OBIEE/ODI/ESSBASE/Admin & Development

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

Responsibilities:

• Experienced in Installation and configurationOBIEE on various servers and System Administration usingAIX.
• 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.

Confidential, NY

OBIEE Admin/Development Lead

Environment: Oracle Business Intelligence (OBI) EE 11.x, BI Publisher 11.x9.x, BI Apps 7.9.x, DAC, Oracle 11g, AIX 7.

Responsibilities:

• Interacted with business team and vendors to gatherBusiness Requirementsas 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 theAdministered Privilegesand 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

Confidential, NJ

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.

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).

Confidential, CT

Sr OBIEE Developer

Environment: OBIEE 10.1.3.2, Informatics 7.X

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.

Confidential

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

Confidential

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,)