PROFESSIONAL SUMMARY

• Over 8 years of expertise in all phases of Software Development Life Cycle SDLC and having comprehensive background in End-to-End implementation of Business Intelligence using Oracle Business Intelligence OBIEE /BI Publisher/OBIA.
• Expertise in OLTP/OLAP System Study, Analysis and developing Database Schemas like Star schema, Snowflake schema and Dimensional modeling.
• Installed and configured different versions of OBIEE Informatica.
• Strong experience in developing OBIEE Repository .rpd - three layers Physical Layer, Business Model Presentation Layer .
• Designed and developed the OBIEE Metadata Repository .rpd using OBIEE Server Admin tool by importing the required objects Dimensions, Facts Aggregates with Referential Integrity constraints into Physical Layer using connection pool, developing multiple dimensions Drill-down Hierarchies , Logical Facts Measure objects in Business Model Layer, and creating Presentation Catalog/Subject Areas in Presentation Layer.
• Hands on experience in customizing analysis, filters and charts in OBIEE Analytics.
• Understand the standard of best practices in BI architectural design.
• Built Reports and Dashboards for Business Users, and Set up Usage Tracking database.
• Developed many Reports / Dashboards with different Analytics Views Drill-down / Dynamics, Cascading style sheets, Pivot table, Chart, Compound Layout , Narrative, Column Selector, View Selector, Ticker, Segment, Section, Tabular with local and global filters using OBIEE Analytics.
• Experience in Configuring Interactive Dashboards with Security Setup groups, data access/query privileges , Metadata objects and Web Catalog objects Dashboard, Pages, Folders, Reports .
• Created, modified, and Administered Analytics Intelligence Dashboards with links to web sites HTML text links to documents and embedded content, such as images, text, charts, and tables.
• Implemented Dynamic Dashboard Prompts using Presentation variables to zoom into different segments of the customers and Brokers, to achieve performance optimization and easy navigation of reports.
• Install, Configure and integrate BI Publisher with OBIEE RPD/Presentation layer.
• Proficient with BI Publisher reports using various templates to publish the reports as per user requirements and in bursting and scheduling BI Publisher Reports.
• Experienced in usage of Disconnected Analytics and Strong working experience in using OBI/Siebel Delivers which includes configuring Delivery Devices, creating and configuring iBots, and building Alerts.
• Strong expertise in Implementing MUD Multi User Development Environment.
• Very good in Debugging, Optimizing and Performance Tuning of Oracle BI Dashboards/Reports by designing Query Caching and Data Caching for Performance Gains.
• Involved in the Upgradation of OBIEE 10g to 11g across all business verticals.
• Manage RFCs and change orders.
• Expertize in data modeling skills conceptual, logical and physical model design
• Experience with Operation Data Stores, Enterprise Data Warehouses and Data Marts.
• Strong experience in using different Informatica Designer Components.
• Expertise in developing Informatica Mappings/Mapplets using various Transformations Filter, Expressions, Router, Aggregative, Lookups, Update Strategy and also in creating Workflows.
• Experience in using Data warehouse Administration Console DAC to schedule, run full and Incremental ETL loads, to schedule the Informatica jobs, and to customize Execution Plans.
• Experienced in SQL, PL/SQL, Stored Procedures, Functions, Packages, DB Triggers, and Indexes.
• Experience in customizing out-of-box reports Financial, Procurement and Spend, Supply chain, Sales and Marketing Modules
• Good understanding of Software Development Life Cycle SDLC .
• Expertise in interacting with Business users, Architecting requirements and design documents.
• Team player and self-starter with good communication skills and ability to work independently.

PROFESSIONAL EXPERIENCE

Confidential

Senior OBIEE Developer

Job Responsibilities

• Worked with corresponding area's Subject Matter Experts SME , Stake Holders, Business Analysts and Key Business Users in gathering the Analytics / Reports Requirements.
• Installed and configured complete suite of OBIEE 11.x in test and development environments.
• Designed star schema using KPIs, Fact, Dimensions, Physical, Logical, Alias and Extension tables. Built Business Model and established relationships with Foreign Keys Physical Logical between tables.
• Worked extensively on OBIEE Administration tool and Presentation Services.
• Worked on Oracle BI Applications pre-built DAC and ETL repositories and execution plans.
• Worked on ETL Enhancements by creating custom SQL scripts to make changes to the existing tables in the OLAP database as per the business requirements.
• Involved in designing Mappings, Mapplets and Transformations using the tables from Siebel CRM OLTP System.
• Worked on Informatica Performance tuning methods like various ways of using lookup caches depending on the size of source and lookup tables.
• Involved in Unit testing and Integration testing of all the mappings, workflows, schedules.
• Responsible in designing and introducing new FACT or Dimension Tables to the out of box or custom RPD and decide the granularity of fact tables.
• Created Dimensional Hierarchy, Level based Measures and Aggregate navigation in BMM layer.
• Built Time-Series calculations using AGO and TODATE functions on BMM Business mapping and modeling layer of repository.
• Created dynamic currency selection by use of the Logical Columns.
• Designed Degenerate, Conforming and Non-Conforming dimensions in the BMM layer.
• Created Session variables, Repository variables in RPD and used the same for role based security, object level and dynamic calculations in OBIEE answers.
• Setting up LDAP authentication to enable Single Sign on for Users in Development environment leveraging Analytics Repository.
• Added users and configured security in web logic console of OBIEE 11g.
• Designed and implemented Oracle OLAP cubes for use with OBIEE dashboards.
• Developed different Dashboards/Reports with different views Calculation, Detailed, Pivot, Charts, Column Selector, View Selector, Narrative, Filters, Cross tab using the Presentation services.
• Created Union Reports to get World Wide results as per the Business requirement.
• Customized existing OBIA / out of box reports in Finance and Marketing modules.
• Created Monthly, Quarterly and Yearly reports which gives detailed information on Budget, Actuals and Forecast Revenue and published them on Dashboard.
• Customized Reports look and Feel using Column Formatting, Cross Conditional formatting.
• Used Presentation Variables in OBIEE analytics to save prompt values and use them in reports based on user's requirements.
• Applied Cascading Prompts, Multi-Level Prompts, Page level Prompts, and Action links on Dashboards.
• Extensively used Catalog Manager for Impact Analysis and Global Update of column names using XML search and Replace option as per the business requirement.
• Expertise in creating Segments, Segment Trees and List Formats.
• Implemented Groups and Hierarchy level based security to intelligence dashboards based on role.
• Improved Analytics Response-time by Performance management using optimization efforts such as Implementing the aggregate tables, Partitions Fragments and Cache Management.

• Implemented Multi User Development MUDE for concurrent rpd development.
• Involved in upgrading RPD and web catalog from OBIEE10g to OBIEE11g.
• Monitoring NQS Query and tuning several reports by indexes, hints, EXPLAIN PLAN.
• Created proactive agents iBots and interactive dashboards to alert the marketing team about business changes. Managed day-to-day, Scheduler iBots.
• Seeded server cache using Delivers to improve system performance. Also used iBots to purge server cache using NQCmd utility.
• Performed Unit, Integration, Regression and User Acceptance testing UAT to validate report and mapping functionality.
• Prepare and maintain technical documentation for all new or modified objects.
• Coordinated the OBIEE .rpd and Web Catalog objects deployment from Development environment to QA environment and then to the Production environment.
• Conducted user training to familiarize them to the new reporting environment.

Environment

OBIEE 11.1.1.7,Oracle BI Apps 7.9.6.4, Siebel CRM 8.1.1, MS SQL Server 2008 , Informatica 9.1.1, DAC, SQL Server Management studio , Windows 2003, UNIX.

Confidential

Senior Oracle BI Developer

Job Responsibilities

• Worked closely with Business Analyst, discussed and gathered the Analytics requirements and created the Business Model using Star schemas.
• Get the database connectivity and design the Physical Layer, Business model and Mapping layer and the presentation layer in the repository .rpd .
• Created Views and aliases for complex queries in the physical layer of OBIEE in order to improve the performance of the reports and to implement complex reports.
• Performed Repository Testing and validation before exposing Business Models in the Presentation layer.
• Identified the aggregate levels for measures and created dimension hierarchy sources for each level of aggregates for performance enhancement.
• Implemented Time Comparison and calculation measures in the business model using Time series wizard and modeled slowly changing dimension data.
• Used Filters Global and Local and provided customized prompts to avoid excessive data showing up in the reports.
• Configured Repository and session variables to get dynamic reports and dashboards.
• Involved in the Analysis of the existing system reports and modification of the reports, created new reports based on the user requirements.
• Customized/Created presentation layer catalog folders, to show different views of the business model to different users and assigned group permissions to the catalog folders.
• Setup the visibility of Dashboards to employees with respect to their responsibilities. Administered permissions and privileges for Dashboard visibility and modifications to users based on their groups or responsibilities.
• Copied existing RPDs from Server into the Local machine for testing and tuning of dashboards.
• Customized OBIEE Styles, Skins and Messages according to the client requirements.
• Monitored database performance tuning and implemented the session partitions and made changes to database by re-building the Indexes.
• Used Toad to debug the SQL query to identify duplicate rows in the warehouse tables, and to debug the SQL query issued during report execution.
• Created pixel perfect reports using BI Publisher in Interactive mode by creating data models and data sets and used MS office plug-in for analyzing data.
• Expertise in designing BI Publisher reports using Crystal Reports and SSRS.
• Used Informatica Mapping Designer to create/update mapping using different transformations required to move data into data warehouse.
• Used Informatica Power Center Workflow manager to create sessions, batches to run with the logic embedded in the mappings and Created workflows for full load and incremental loads to be used by DAC.
• Assembled subject areas and created execution plan and accommodated the new Informatica mappings and Added new facts and Dimensions to the OBAW and created new execution plan in DAC for daily load into these tables.
• Merge Repositories two way and three way into master repository from each developer.
• Developed Dashboards for each of metrics by embedding reports and provide intuitive drill downs and links to exploit the full benefit of Analytics in providing summary and detail reports.
• Involved in the preparation of Technical design documents, Source to target S2T document, Review checklist and Technical Specifications.
• Configuring iBots to deliver analytics content based on schedule to obtain weekly reports and sent notification Alerts.
• Coordinating with on-shore and off-shore clients and ensure project delivery on time.
• Involved in Migration, UAT, Go-Live, and Production Support.

Environment

OBIEE 11.1.1.6, Oracle 10g/11g, OBIA 7.9.6.3, Informatica 9.1.1, DAC, TOAD, Oracle e-Business Suite EBS , BI Publisher, Erwin, Windows XP.

Confidential

Sr.OBIEE Consultant

Job Responsibilities

• Worked closely with the business users and developers to make sure that Business Requirements are correctly translated into database schemas and ultimately into the application.
• Responsible for supporting and enhancements of OBIEE.
• Installed and configured complete suite of OBIEE 11.x in test and development environments.
• Mapped different data sources to the Physical Layer and created the Business Model and Mapping Layer design of hierarchies, dimensions, and aggregates .
• Created connection pools, imported physical tables and defined joins in the physical layer of the repository.
• Analysis of existing OLTP system and Identification of required dimensions and facts from the Database.
• Created materialized views and aggregates in the BMM layer to improve performance.
• Implemented security by creating users groups, setting up External Table Authentication, creating Session Variables and Initialization Blocks and associated catalog objects and Web modules with the created groups.
• Designed and Integrated Oracle Essbase cubes for use with OBIEE dashboards.
• Created and customized various Reports and Dashboards for various user groups using complex SQL Filters.
• Designed various reports as per the requirements for user interface design like Drill Down, Pivot, Chart, Break down Reports, Union reports, Narrative and Nested reports in Answers.
• Created Dashboards with local/global Dashboard prompts and Master Detail linking.
• Implemented write back functionality.
• Used Oracle Delivers for sending real-time, personalized alerts via intelligence agents iBots to intelligence dashboards for subscribed users.
• Applied Optimization techniques of the reports such as caching and building summary tables.
• Performed Validation of data in the reports and dashboards using SQL Tuning to improve performance.
• Involved in migrating Discoverer reports to OBIEE.
• Unit, integration and system testing for all components in OBIEE. Test cases have been prepared and documented the results.
• Documented the designs for intuitive understanding and future reference.
• Trained End Users to Build Ad Hoc Reports using OBIEE.

Environment:

OBIEE 11.1.1.3, Oracle 11g ,Discoverer , DAC, Informatica Power Center 8.1.1, MSBI,TOAD , Windows 2003 server, Red Hat Linux.

Confidential

OBIEE Developer

Job Responsibilities

• Analyze the specifications provided by the client, understanding the business.
• Worked closely with Business Analysts and the ETL team.
• Worked extensively on Supply Chain and Demand Data warehouse Schemas/Reports.
• Install, configure, and administer the OBIEE platform.
• Involved in RPD Development, Oracle BI Server, And Oracle BI Answers.
• Involved in Repository Configuration, Troubleshooting, Migration and Server Administration.
• Extracted data from Various ERP Systems like Siebel OLTP database, Oracle E business Suite EBS . And worked on data models, data stage and data mining tools.
• Designed Star schema for fact dimensional tables, created alias for the dimensional tables when necessary.
• Created Opaque views as per the user requirements.
• Specified Dimensional hierarchy, Aggregate levels for the dimensions.
• Implemented Multi User Development MUDE .
• Developed many Reports / Dashboards with different Analytics Views Drill-Down / Dynamic, criteria filters, Pivot Table, Chart, Column Selector, Tabular with global and local Filters using Oracle BI Presentation Services.
• Designed and Configured Interactive Dashboards in Analytics for different groups of users which include like Managers, functional heads, Department Heads.
• Implemented Security by creating roles web groups, checks with External tables and LDAP.
• Managed Security privileges for each Subject area and Dashboards according to user requirements.
• Used the Catalog Manager and maintained the Analytics web catalog to manage dashboards answers.
• Involved in implementation of Pre built OBI Analytics.
• Good hands on experience in using BI Publisher to create reports from BI answers, BI server.
• Setup Usage tracking option to monitor frequently run reports in order to provide caching for the reports and perform database optimization by analyzing query performance.
• Merged and compared two different Repositories using administration tool.
• Installed and set up Informatica environment and responsible for administration and migration of repositories between various environments.
• Trained and worked with the end-users in developing their own ad-hoc reports using OBIEE Answers.

Environment

Oracle Business Intelligence Enterprise Edition OBIEE 10.1.3.4, BI Publisher, Oracle 10g/11g, Informatica, DAC, OBIA, SQL Developer, PL/SQL, People Soft, Windows NT, UNIX.

Confidential

Oracle BI Developer

Job Responsibilities

• Involved in gathering new and existing report business requirements performed GAP Analysis and translated them to technical requirements.
• Identified the Data Sources Relational, Excel etc. , Facts, and Dimension tables in designing the Star Schema.
• Designed and Built OBIEE RPD at 3 layers i.e., Physical Layer connecting Data sources import schema , Business Model / data mapping create Logical tables data source mapping and Presentation Layer level create presentation catalogs. .
• Created logical tables, assigned hierarchy levels, custom aggregation rules, and time series objects in the BMM layer.
• Created Prompts for the report with navigations/Drilldowns.
• Developed different kinds of Reports and Interactive Dashboards with various logical calculations using Pivots, View Selectors, Column Selectors, and with drill-down/Navigation capabilities, charts, tabular using global and local Filters, and Page/Dashboard Prompts.
• Implemented OBIEE security at the data, object and user level security for intelligence dashboards based on Business Requirement.

• Used OBIEE Delivers to automate iBots queries, obtain weekly reports and to send alerts to related managers and secured team members.
• Worked on role-based dashboards in Pharma sales.
• Debugged reports and Dashboards visibility with respect to user's responsibility and web groups in an integrated environment.
• Worked extensively on Oracle BI Publisher and provided the capability to download the reports in the user defined formats.

Environment

OBIEE 10.1.3.4.0, Oracle 10g, BI Publisher ,TOAD, DAC, Informatica 8.1.1, Siebel epharma, Windows 2000, Sun Solaris 64.

Confidential

OBIEE Developer

Job Responsibilities

• Participated in all phases including Requirement Analysis, Client Interaction, Design, Coding, Testing and Documentation.
• Created/Modified Metadata repository .rpd and Configured Metadata objects using OBIEE server Admin Tool.
• Developed the Dimensions and Time Series Objects in the BMM Layer with Security settings in OBIEE Administration Tool to setup groups, access and query privileges.
• Developed many Dashboards/ Reports with different Analytics Views Drill-Down, Pivot, Chart, View Selector and Tabular with global and local filters using the analytics web.
• Configured intelligence dashboards by adding content such as links/images, HTML objects and folders. Implemented dynamic dashboard prompts to zoom in to particular segments of the business in a performance-optimized manner.
• Maintained effectiveness in creating the dashboards by appropriately including guided navigational links and drill downs.
• Implemented and Customized Informatica for OBIA.
• Customized all Financials Analytics subject areas Dashboards and Reports.
• Expertise in creating Capital Market Reports and dashboards.
• Used the Catalog Manager and maintained the Analytics Web Catalog to manage Dashboards, Answers.
• Diagnosed performance problems with OBIEE and recommended solutions to improve reports run time. Performed Tests for the Data integrity and Consistency.

Environment:

OBIEE 10.1.3.2.0, Oracle e-Business suite EBS , OBIA Financial Analytics , BI Publisher, Informatica Power center 8.1.1, DAC, Oracle 9i/10g, SQL Developer, Windows XP Prof, LINUX.

Confidential

Jr. INFORMATICA Developer

Job Responsibilities

• Developed ETL to load data from Microsoft SQL server into the target Oracle database.
• Data warehouse Architecture and Design
• Dimensional Modeling Star Schema- Facts and Dimensions, Type 1 2 SCD, Snowflake
• Developed Informatica Power Center mappings using transformations such as the Source qualifier, Aggregator, Expression, lookup, Filter, Router, Rank, Sequence Generator, and Update Strategy.
• Developed simple complex mappings using Informatica to load dimension fact tables as per STAR Schema techniques.
• Drilldown reports with SQL queries.
• SQL, PL/SQL, scripts for data validation and reconciliation.
• Worked extensively with Oracle Stored Procedures, triggers, View and DDL commands.
• Responsible for the performance tuning of the ETL process at source level, target level, mapping level and session level.
• Used Procedure Transformations to invoke Oracle PL/SQL Procedures.
• Performed error handing using session logs.
• Used Informatica Version Control for checking in all versions of the objects used in creating the mappings, workflows to keep track of the changes in the development, test and production.
• Developed stored procedures using PL/SQL to implement the business logic as well as changing the existing logic.
• Moved the mappings from development environment to test environment.

Environment

Informatica 6.x, 7.x, SQL PLUS, Erwin 4.0, PL/SQL, Windows 2000, UNIX, IBM DB2, MS SQL Server 2000.