OBIEE Developer

PROFESSIONAL SUMMARY

• 8 years of experience in gathering Business Requirements, Analysis, Design, Development, Testing and Documentation of various functionalities of Data Warehouse / Data Marts and Business Intelligence.
• Extensive Data warehouse development experience using OBIEE/ Siebel Analytics, BI APPS, Informatica , Oracle Data Integrator ODI , BI Publisher, Oracle 10g/11g, SQL/PLSQL
• Hands on experience in the Data Modeling, Meta Data Development, BIAPPS Implementations and Testing of OBIEE/BIAPPS Functionalities.
• Experience in Complete life cycle of Business Intelligence with Star and Snow flake Schema Methodologies.
• Experience in developing OBIEE Repository at 3 layers Physical, Business model mapping and Presentation Layers , Interactive Dashboards and drill down capabilities using global and Filters and Security Setups.
• Experience in monitoring Informatica mappings/Mapplets using various Transformations for various issues.
• Involved in monitoring DAC Data warehouse Application Console to provide run time meta data validation checks.
• Enabled Usage Tracking to monitor the usage and performance of reports
• Managed/Administered OBIEE web catalog using Catalog Manager
• Extraction, Transformation and Loading of data from multiple sources of data warehouses and creating workflows with work lets tasks and scheduling using workflow manager.
• Experience in creating SQL, PL/SQL, Stored Procedures/Packages/Triggers/Cursors and UNIX Shell scripts.
• Experience in Informatica DAC Tool for Customizing Data warehouses and Creating Task and Task Groups in it.
• Experience in providing end-to-end business intelligence solution by dimensional modeling design, developing and configuring OBIEE Repository RPD , Interactive Dashboards, OBIEE Answers, security implementation, Analytics Metadata objects, Web Catalog Objects Dashboard, Pages, Folders, Reports and scheduling iBots.
• Adopt Knowledge in Query Performance Tuning and Database Tuning.
• Migrated Repository and Web Catalog from one environment to another environment.
• Experience in creating and using Initialization blocks, Dynamic, Static, and Session Variables.
• Experience in XML/BI Publisher, which includes working on report development objects like data templates and RTFs.
• Analytical problem solver and critical thinker, innovative and creative, cooperative, results oriented, on-going learner, hands-on, self-motivated, multi-task oriented.
• Extensively worked on BI Answers, BI Dashboards, BI Deliver, BI Server and BI Publisher.
• Experience in Creating Dimensional Hierarchies, Level Based Measures and Time series Functions.
• Expert in database performance tuning by Partitions, Materialized views in query rewriting, creating indexes, re-building indexes and SQL Tracing.
• Experience in PL/SQL Procedures. Triggers and T-SQL Procedures, Packages and other objects.
• Extensive Experience in SQL Server 2008, 2005, 2000.
• Expertise in developing Custom Reports.
• Excellent interpersonal and communication skills, detail oriented, organized and highly motivated.

TECHNICAL SKILLS

• Languages: C, C , C , SQL, PL/SQL, HTML, XML.
• BI Tools: OBIEE 11.1.1.x, OBIEE 10.1.3.4.0.
• ETL Tools: Informatica Power Center.
• RDBMS: Oracle, SQL Server, DB2 UDB, MS Access.
• Operating Systems: Windows server 2003/2008, 2000/98, UNIX.

PROFESSIONAL EXPERIENCE

Confidential

Sr. OBIEE Consultant /Lead

Responsibilities:

• Requirement Gathering for OBIEE Reports.
• Provide estimation of the efforts and Time required for the development of OBIEE Reports.
• Developed Physical, Business Model Mapping and Presentation Layer using Oracle BI Server Administration Tool by following standard OBIEE practices.
• Designed the Star Schema for different subject areas and build hierarchies, level-based measures, Aggregate level and Alias tables.
• Implementation of Object level security for the Dashboards and OBIEE reports.
• Extensive use of Image prompts, Action Links, Go-Url functionality for the development of Interactive Dashboards and Business Intelligence reports
• Migration of Security components, custom image prompts, style and skins from OBIEE 11.1.1.5.0 to OBIEE 11.1.1.6.8.
• Performed Data Validation by executing Unit Test cases for Business Intelligence Reports.
• Created multiple Dimensions Drill-Down Hierarchies Fact objects in Business Model Layer, and created the Presentation catalogs in Presentation Layer.
• Modified Presentation Layer to add presentation tables and columns to meet the business user needs.
• Created materialized views and aggregates to improve performance.
• Customized reporting with OBIEE Answers and integrated them into the Dashboards.
• Documented and maintained ELT specifications and processes.
• Provided assistance in creating data management standards and procedures.
• Worked on UNIX platform for security reasons.
• Designed DW tables, scripts, ETL maps.
• Migrated the Web Catalog, Mappings and ETL Transformation from Test to Production Environments.
• Customized the Business Analytic Warehouse by adding and modifying the Dimension and Fact Tables for the Custom requirement.
• Fine Tuned the Customized Workforce Profile Subject Area by editing the Custom Dimensions and Hierarchies at the Report, RPD Database level.
• Migration to OBIEE 11.1.1.6 which includes Application Development Framework ADF .
• Managed security privileges for each subject area and dashboards according to user requirements as per Business Intelligence requirements.
• Setting up External table authentication to enable Single Sign on SSO for Users in Development environment leveraging Analytics Repository.

Environment: OBIEE 11.1.1.5 11.1.1.6.8,ODI 11.1.1.x and Oracle DB 11g.

Confidential

Sr. OBIEE Developer/Admin

Responsibilities:

• Provided support in the Development, UAT and Production environments in OBI Apps 7.9.6.0 in HR Analytics.
• Performed DAC related activities which include monitoring and support for HR Analytics Module.
• Resolving Ticket raised by Business Users and Consultants which include change request in OBIEE and DAC.
• Identified various defects in the Reports while Executing the Test Cases and providing the solution for the same.
• Develop BI Publisher reports and configured the Bursting and Scheduling for the same.
• Created Filters and providing customized prompts appropriately to avoid excessive data showing up on reports.
• Worked extensively on various Cache Management techniques to increase the performance of the both Real-Time and Non Real-Time reports.
• Worked in Repository Configuration, Troubleshooting, Migration and Server Administration.
• Trained End Users and Pilot Users about OBIEE Tools like Answers, Dashboards and BIP reports.
• Run execution and working with Operator if there is error occurred in ODI.
• Worked on Technologies like Oracle Data Integrator 10g/11g and OBIEE 10g.
• Built Logical Tables, Complex Joins, Dimensions, Hierarchies Aggregation for Measures.
• Few reports were built on Unix platform as per the reqirements.
• Modeling activities involving building star schema as per the business requirements like configuration of Logical Layer, Logical tables, dimensions and columns. Established the logical joins/keys required to support drill-down aggregation.
• Generates, deploys and manages the code required to implement those processes across the various source and target systems in ODI.
• Configured Siebel Analytics Repository like implementation of physical data model as per requirements, importing the tables and having the physical joins/keys required and changed the physical joins/key on the existing tables.
• Configured presentation layer used by different user groups and also established the various standard queries, in order to support the presentation layer.
• Created dimension hierarchies and assigned levels and custom aggregation rules for each level.
• Involved and developed various steps to improve the performance of the queries used in the reports by having the aggregate tables.
• Identified the granularity level of the data required to be available for analysis.

Environment: OBIEE 10.1.3.4.0, BI Publisher 10.1.3.4.0 , ODI 11.1.1.3 and SQl Server 2008.

Confidential

OBIEE Admin / Developer

Responsibilities:

• Effectively interacted with the end users for requirement gathering and defined requirement specifications document by access and retrieval of financial and personnel data from one single source.
• Worked extensively on OBIEE Answers and Dashboards to create the reports as per the client requirements.
• Involved in developing the testing documents like Estimates, Test Strategy, Test Plan, Use cases, Test cases, Test Scenarios and Test Data according to Requirements Specifications. Experience in preparing Test Execution Report.
• Identified Created Facts, Dimensions, and Hierarchies of the business model.
• Worked extensively in upgrade from 10g to 11g.
• Developed Segment Value Detail, Work Order Detail and OGA Repositories RPD by importing metadata into Physical Layer, applied Business rules in the Business Modeling and Mapping layer and created customized user views in the Presentation layer.
• Met with end-user groups and minimized system detailed business requirements.
• Mapping the Requirement analysis done by BA to the various source systems.
• Source to Target mappings implementing the business logic.
• Created various process flows.
• Validation of the Reports in the Upgraded Environment of OBIEE 11.1.1.5.0 from Siebel Analytics 7.8.6.0 .
• Good Knowledge in functional testing which involves, writing Functional Test Scripts and validating Upgraded reports with the Siebel Application.
• Performed all phases of end-to-end testing which includes Functional Testing, Regression Testing, and Smoke Testing of the application.
• Identified various bugs and defects in the upgraded Reports while Testing and provided inputs in debugging it.
• Executed all forms of testing in the Development, Testing, UAT and PROD environments.
• Handling the change requests.
• Issue resolution if any because of source change or business rule change. Performed Unit testing of code as required by test plan.
• Created templates for presenting results and Analytics and modified the OBIEE dashboard using cascading style sheets.
• Involved in Reconciliation proves while testing loaded data with user reports.
• Developed different kinds of reports pivots, charts, tabular using global and local filters.

Environment: OBIEE 10.1.3.4.2, OBIEE 11.1.1.5.x, SQL Server 2008, DAC 10.1.3.4.0, Informatica Power Center 8 x, Windows 2008 Server, Windows XP.

Confidential

Role: OBIEE Developer

Responsibilities:

• Identified the Gap's by analyzing the data mart instance and provided alternative solutions as well as recommended changes to database.
• Built OBIEE Repositories at three layers i.e Physical layer, Business model Layer and Presentation layer.
• Created Drill down Hierarchies and implemented Business Logics and Facts.
• Created Pivot Tables and Charts and manipulated initialization blocks for report analysis.
• Worked on OBIEE answers to build Dashboards with drill down capabilities.
• Designed and developed the ETL Mappings for the source systems data extractions, data transformations, data staging, movement and aggregation.
• Integrated Informatica servers with DAC and customized the data warehouses and configured filter settings in it.
• Created measures and level Based measures in Business Model
• Created logical Tables and logical columns, Physical Columns.
• Created measure with Logical Columns and Physical Columns.
• Created Dimension hierarchy in Business model layer.
• Created tasks and task groups and subject areas in DAC for Informatica servers.
• Upgrade, comparing and merging of DAC repositories in DAC.
• Created BI Publishers in OBIEE Repositories.
• Created Aggregation tables in OBIEE and Created Job Scheduling for Aggregation Tables.
• Created Objects into repository by merging and importing into OBIEE Repositories.
• Implemented Slowly Changing Dimensions Type I and II in different mappings as per requirements.
• Used Informatica workflow manager and workflow monitor to schedule and monitor session's status.

Environment: OBIEE, OBIEE Publisher, Informatica Power Center 8.1.1, Oracle 10g, DAC, PL/SQL, T-SQL.

Confidential

Role: OBIEE Developer

Responsibilities:

• Identified Facts and Dimensions levels/ Hierarchies of Dimensional model.
• Customized and developed RPD Physical, Business model and Presentation Layer , configured metadata objects and Web Catalog Objects.
• Developed many reports/dashboards Analytic views Pivot Tables, Charts, Column Selector, and View Selector .
• Created measures and level Based measures in Business Model
• Created logical Tables and logical columns, Physical Columns.
• Created measure with Logical Columns and Physical Columns.
• Created Dimension hierarchy in Business model layer.
• Developed PL/SQL procedures and functions and used the same in mappings, pre and post sessions.
• Performance tuning of Dashboard/Reports and made changes to database by implementing materialized views and partitions, rebuilding of indexes.
• Performed Unit, Integration and Regression testing to validate report and mapping functionality.
• Working closely with users/developers and administrators to resolve the production problems by reviewing design changes.
• Installed and configured the OBIEE on servers and dealt with the installation issues.
• Designed and Developed OBI Repository at three layers i.e., Physical Layer connecting to Data Warehouse imported objects with joins , Business Model / data mapping create Logical tables, Drill-Down Hierarchies complex joins and Presentation Layer level create presentation catalogs , create presentation folders, test and validate the model.
• Responsible for creating custom columns in the BMM layer to calculate the percentage changes in the sales using inbuilt functions and expressions.
• Identified Facts, Dimensions Hierarchies of the Business Model.
• Developed Time Series object for comparing between the annual and quarter sales.
• Implemented the variables in the repository to import them in the presentation layer.
• Actively resolved all the issues in the development process to satisfy the client's best requirements.

Environment: OBIEE 10.1.3.2, SQL Server 2008, Windows 2008 Server, Windows XP, Windows 7.

Confidential

Role: Oracle Developer

Services ranging from systems analysis to programming and onsite services. Expertise in building applications for the financial services and manufacturing areas. Ability to adhere to methodology for time / cost estimation, documentation, programming standards, template structures, change control etc. Building high-value corporate information systems that would markedly improve the competitiveness of our clients.

Delivering quality solutions in a cost-effective manner so as to transfer value to our clients, on-time, on-budget and comprehensively. A wide top management that is technically and functionally sound.

Responsibilities:

• SDLC using SSAD Methodologies of the application including the study, design, Development, implementation and maintenance.
• Developing PL/SQL Procedures.
• Responsible for the Layout Design of the forms and reports.
• Analyzed the Query performance and designed the loading process schedules.
• Involved in the Front-end Design using Forms 4.5 and Reports.
• Developed PL/SQL Packages, Procedures and Functions accordance with Business
• Requirements for loading data into database tables.
• Developed stored procedures to extract the data from different sources and load it into data warehouse.
• Analyzing the data needs for the customized reports. Mapping the data requirements developing
• Stored Procedures, Functions and Triggers.
• Involved in uploading of the data from flat files into Databases and validated the data with PL/SQL procedures.
• Maintaining daily batch cycle and providing 24 hour production support.
• Preparation of the Test Cases and involvement in Unit Testing and System Integration Testing.
• Developed automated scripts to schedule the load of flat files on daily, weekly and monthly basis.
• Responsible for performing code reviews.
• Interaction and coordination with various application teams for resolving issues, patch movements.
• Performed SQL tuning using Explain Plan, Hints and indexes.
• Involved in tuning of SQL queries by using Quest SQL optimizer and manually by Explain plan.
• Partitioned tables and indexes for better performance of application.
• Involved in importing the production data to lower environments for testing purpose.
• Involved in handling the changes in compiling scripts according to the database changes.
• Conducted PL/SQL training session for co-workers to educate about the latest PL/SQL features, PL/SQL performance tuning.

Environment: Developer/2000 Oracle Windows XP, Oracle 11g/10g and 9i, MS SQL SERVER 2005, PL/SQL, PL/SQL Developer.

Confidential

Role: Oracle Developer

Responsibilities:

• Design, code, and maintain the Oracle systems based on established standards.
• Understand project requirements and develop design specifications.
• Perform initial design reviews and recommend improvements.
• Write clear codes and prepare coding documentations.
• Provide technical assistance to other Developers as needed.
• Analyze and troubleshoot system issues in a timely manner.
• Database security by authenticating users, using logon triggers.
• Created materialized view on remote database and automated scheduler of refreshing of materialized view.
• Developed user defined functions based on requirements.
• Developed back end interfaces using PL/SQL Stored Packages, Procedures, Functions, Collections and Triggers.
• Created PL/SQL procedures and packages.
• Extensive query optimization and performance tuning.
• Created the integrity constraints and Database Triggers for the data validations.
• Used PL/SQL Tables and Records in payment generation process.
• Written Test Plans and Involved in unit testing.

Environment: Oracle 11g/10g, SQL Plus, PL/SQL, SQL Developer and Windows XP