PROFESSIONAL SUMMARY

• Over 8 years of hands on experience as an OBIEE Technical Consultant in Business Intelligence solutions in Data Warehousing using OBIEE and Informatica ETL tool. Extraction, Transformation and Loading Tool Excellent Analytical and Problem Solving Skills. Proven Experience in Full Life Cycle Implementation of Data warehouses.
• Strong experience in customization and configuration of Oracle Business Intelligence Enterprise Edition OBIEE applications using Oracle Answers, Oracle Dashboards, and also involved in the developing strategies for Extraction, Transformation and Loading ETL mechanism using Informatica Tool.
• Excellent Aptitude in designing Star Schema / Snowflake Schema methodologies using Siebel analytic's Administration tool and Dimensional Modeling.
• Good hands on Experience in OBIEE like creating the RPD and level based measures.
• Hands on experience in configuring parameters of Instanceconfig.xml Nqsconfig.ini
• Knowledge and experience in the areas of Data Warehousing Design Report development.
• Good Experience in Map Builder and Map Viewer.
• Hands on experience in performance tuning of various decision support systems using OBIEE query log query optimization, performance tuning measures formula enhancement and aggregate table creation.
• Hands on experience in automated change management capture using OBIEE/DAC
• Expertise in OBIEE/DAC configuration
• Expert in ETL process using Informatica Power Center Designer, Workflow manager, Workflow monitor, Informatica server and Repository Manager. Experience in Tuning of sources, targets, mappings, transformations and sessions.
• Strong Experience and knowledge in creating Stored Procedure, Packages, Triggers, Cursors using Oracle 11g/10g/9i PL/SQL .
• Data Modeling using Star Schema and Snowflake Schema. Strong in Source to Target data Mapping and CDC Change Data Capture using Slowly Changing Dimension Mapping, incremental aggregation etc. Highly Skilled with the Integration of various data sources like Oracle 10g, DB2, SQL Server, Flat Files.
• Performed Database Design and development using Oracle, DB2 UDB, SQL Server,Teradata.
• Skilled in Tuning of SQL. Good Knowledge and Experience using different types of loads like multi load etc, writing SQL queries, creating tables, views and importing to the Informatica. Experienced in ETL Automation.
• Good experience in dealing with Data Marts like Metrics, Sales, Inventory for updating, loading into the tables in these data marts and their maintenance. Good experience in dealing with complex dimensions like customer Dimension with slowly changing dimension type2 scd type2 for updating and inserting new rows. Also have experience in creating materialized views on those tables, refreshing methods and aggregation of these tables, managing the ODBC connections.
• Experienced in logical and physical data modeling of staging and warehouse environments using the Erwin data modeling tool.
• Designed 3NF and Data Modeling. Worked in Development, Production and Maintenance Support Projects. Skilled in Unit Test, System Integration Test and UAT.

TECHNICAL SKILLS

PROFESSIONAL EXPERIENCE

Confidential

OBIEE Developer

Responsibilities:

• Designed repository based on business requirements, followed design best practices for the RPD and Dashboard designs.
• Worked on the design of logical data model.
• Worked extensively on OBIEE Repository, that includes Physical Layer, Business Model layer and Presentation Layer using OBIEE Administration Tool.
• Created connection pools, imported physical tables and defined joins in the physical layer of the repository.
• Used different filter conditions both in the repository and in front end based on business rules provided by the business users.
• Extensive experience in setting up MUD Environment.
• Created dimension hierarchies, aggregates and keys in the BMM layer.
• Worked on creating repository and session variables such as static and dynamic along with initialization blocks.
• Database performance tuning and creating Indexes and cost based optimization.
• Designed Data modeling by after understand business requirement. Design Dimensional modeling for Datawarehouse.
• Created groups in the repository and added users to the groups and granted privileges explicitly and through group inheritance
• Worked with DBAs to create materialized views and aggregates to improve performance.
• Created reports which are used to analyze the Performance and Response of the Campaigns held by the Marketing Team.
• Involved and understand in Supply chain Analytics
• Involved in setting up the environments for Development, Unit Testing, System Testing and Production for the developers and testing teams.
• Gathered requirements and setting up meetings with Executive level personnel

Environment: OBIEE 11g, Informatica Power Center 9/8.x,Teradata, Oracle 11/10g

Confidential

OBIEE/ETL Lead Developer

Responsibilities:

OBIEE:

• Prepared the HLD High Level Documents and LLD Low Level Documents for the Project Implementations.
• Understanding and translating the business requirement to technical requirements for both the Enterprise Portfolio Reporting, Manager Center Dashboard and eLedger Project in OBIEE 11g.
• Conducted data modeling review sessions for different user groups, participated in requirement sessions to identify requirement feasibility.
• Actively participated in design and analysis sessions to ensure sound team decision-making.
• Provided POC's for the end user to make them understand the capabilities of the OBIEE tool and how their requirements can be satisfied.
• Created and maintained OBIEE Repository .rpd for all the projects I worked upon. Used every feature available to implement business requirements to the fullest extent, without compromising on the Best Practices recommended by Oracle.
• o Designed and developed Business Intelligence reports and dashboards, Enabled Agents in to deliver these reports directly to the users.
• Created the reports using the different views such as Pivot, Tabular, Narrative etc as well as creating dashboards for the same using prompts, guided navigation as per the project needs
• Extensively maintained user's security access for different environments, which involved assigning specific groups/roles to the users based on the business requirements for different instances of the OBIEE platform as well as configuring the permissions for these groups/roles in the OBIEE environment.
• Used 3-way merge on the rpd, to migrate the changes through different environments for different projects on a shared instance.
• Developed performance tuning strategies with business model-level calculations versus Data warehouse level pre-computations aggregations, aggregate navigation, cache management, Oracle materialized views.
• 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.
• Worked in On-Shore/Off-Shore Work environment, with experience in leading a team of three.
• Created RPD which involves developing Schema's, implementing the Business logic by customization, Dimensional Hierarchies, Aggregate Navigation, Level Based Measures, Variables and Initialization Blocks.
• Developed Physical, Logical and Presentation Layers as per the requirements involving complex joins, hierarchies, aggregations, customized logics, folders and subfolders.
• Designed and developed security model to provide Adhoc access to the Users.
• Extensively worked on the views Charts, Tables, Pivot Tables, Column Selectors, View Selectors, Drill through reports .
• Designed and Developed Reports and Dashboards and implemented Managerial Security on the Reports and Dashboards respectively.
• Managed the Web catalog and worked on the 3-way merge on the RPD to migrate the changes across all the environments DEV, SIT, UAT, PROD .

Informatica:

• Analyzed the specifications and involved in identifying the source that data needs to be moved to data mart.
• Involved in analyzing scope of application, defining relationship within between groups of data, star schema, etc.
• Identified and created different source definitions to extract data from input sources like Flat files, SQL Server and load into relational tables like Oracle.
• Enhanced and created various database objects in Data Mart as per changing technical requirements.
• Tuned the mappings to perform better using different logics and worked on 'cache' to provide maximum efficiency and performance.
• Created and scheduled Sessions and Batch Process based on demand, run on time, run only once using workflows.
• Extensively worked in creating Stored Procedures, Packages, Functions, Triggers, Cursors etc.
• Developed mappings/Reusable Objects/Transformation/mapplets by using mapping designer, transformation developer and mapplet designer in Informatica PowerCenter 8.6.1, 9.1.
• Implemented populate slowly changing dimension to maintain current information and history information in warehouse tables.
• Worked on different data sources such as Oracle, Teradata, Flat files etc.
• Created complex mappings in Power Center Designer using Normalizer, Aggregator, Router, Expression, Filter, Sequence Generator, Update Strategy, Union, Lookup, Joiner Transformations.
• Worked with pre and post sessions, and extracted data from Transaction System into Staging Area.
• Working knowledge on DataWareHouse Admin Console DAC to schedule jobs for Fact and Dimension tables.
• Responsible for validated System Integration Testing for the code developed.
• Used HP Quality Center 9.2 ,prepared test case documents , test plans and validated the test cases in HP Quality Center 9.2
• Prepared Technical design documents, High Level Design documents and Low Level Design Documents.
• Written documentation to describe program development, logic, coding, testing, changes and corrections.
• Provided support to develop the entire warehouse architecture and plan the ETL process.
• Implemented concept of concurrent workflows.

Environment: OBIEE 11g, Informatica Power Center 9/8.x,Greenplum, Oracle 11/10g, SQL Server 7, PL/SQL, SQL, UNIX IBM AIX Version 5.

Confidential

Lead OBIEE/ETL Developer

Responsibilities:

• Designed repository based on business requirements, followed design best practices for the RPD and Dashboard designs.
• Worked on the design of logical data model.
• Worked extensively on OBIEE Repository, that includes Physical Layer, Business Model layer and Presentation Layer using OBIEE Administration Tool.
• Created connection pools, imported physical tables and defined joins in the physical layer of the repository.
• Used different filter conditions both in the repository and in front end based on business rules provided by the business users.
• Extensive experience in setting up MUD Environment.
• Created dimension hierarchies, aggregates and keys in the BMM layer.
• Worked on creating repository and session variables such as static and dynamic along with initialization blocks.
• Database performance tuning and creating Indexes and cost based optimization.
• Designed Data modeling by after understand business requirement. Design Dimensional modeling for Datawarehouse.
• Created groups in the repository and added users to the groups and granted privileges explicitly and through group inheritance
• Worked with DBAs to create materialized views and aggregates to improve performance.
• Created reports which are used to analyze the Performance and Response of the Campaigns held by the Marketing Team.
• Involved and understand in Peoplesoft funtional areas like financial and HR modules
• Imported ESSBASE cubes into OBIEE RPD to create Latest Estimates Subject Area.
• Familiarity of ESSBASE cubes for LE data migration and validation through OBIEE Reports.
• Involved in setting up the environments for Development, Unit Testing, System Testing and Production for the developers and testing teams.
• Gathered requirements and setting up meetings with Executive level personnel
• Writing functional as well as technical specs as per the requirement.
• Estimate the level of effort and communicate with Team members and coordinate with other teams like database and quality assurance teams.
• Estimate Impact analysis and follow industry best practices of release management
• Worked on loading data into Out of the box and Customized Fact tables such as Activity, Call Detail, Belief, Contact Permission, and Syndicated Data Fact groups using out of the box and new Informatica Mappings.
• Performed unit testing and system testing of all components of OBIEE Financial Analytics using EBS source.

Environment: OBIEE 11g,Informatica Power Center 8.1.6, Oracle 10g/11g, HP-UX, Windows X Oracle Applications ,Bi apps 7.9.6.2 OBIA ,Peoplesoft

Confidential

Team Lead and Senior OBIEE/ETL Consultant

Responsibilities:

• As a consultant involved in gathering requirements, analyzed functional specifications and created technical documentation also involved in data model design.
• Created Technical specs using Functional specs
• Designed and developed complex ETL process using Informatica mappings load the data from various sources into HR Analytics OBIA summary tables/reporting tables using various transformations like Source Qualifier, Aggregator, Filter, Router, Rank, Joiner, Expression, Sequence Generator, Store Procedure, Lookup, Sorter, and Union.
• Gather Information and Requirements for Financial Analytics OBIA and implemented.
• Configured DAC with tasks that I have created in Informatica.
• Configured FULL Load and Incremental Loads in DAC and used to Monitor them on regular basis.
• Did Export and Import in DAC during migration.
• Involved and designed AR and AP Subject Areas during Financial Analytics OBIA Implementation.
• Involved in HR Analytics and Procurement and Spend of out of the box vanilla implementation and Custom development.
• Involved in Admin tasks like Installing and Configuring and Migrations
• OBIEE Report Development includes RPD development and Dashboards Design
• Used the Multi User Development MUD Environment for Repository three way merge.
• Troubleshooting issues in OBIEE as well as Informatica.
• Implemented HR, Financial and Project analytics
• Worked on Oracle EBS systems.
• Security management for users, groups and web-groups using the various authentication systems Database table, Dashboard / Report-level security .
• Developed many Dashboards / Reports for providing analytical information's using Oracle BI Answers and Dashboards. Created and used Oracle BI Delivers and IBots/Agents extensively.
• Debugged reports and Dashboards visibility with respect to user's responsibility and web groups in an integrated environment.
• Database performance tuning and creating Indexes and cost based optimization.
• Designed Data modeling by after understand business requirement. Design Dimensional modeling for Datawarehouse.
• In Business model mapping Layer we implemented the Dimensional Hierarchy, level based measures, aggregations, security groups and roles using LDAP Authentication, etc.
• Implemented the Caching for speeding up the reports and to improve the performance wise.
• Merging the RPD and Web Catalog Folder with OBI Admin Tool and Catalog Manager.
• Order the Presentation layer with generic naming convention and as per the Global Business Naming Standards to avoid confusion for the users in the future prospective.
• Created the reports and Dashboards as per the requirement.
• We created the global Filters and Time Dimension prompts for all the dashboard pages.
• In Reports we have created the charts, tables, Pivot tables, Narrative view and View/Column selector, etc.
• Involved in understanding and developed reports in Functional Areas like Account receivables AR and Account Payables AP for Financial Analytics, Supply chain and Order Management

Environment: OBIEE 11g,Informatica Power Center 8.1.6, Oracle 10g/11g, HP-UX, Windows X Oracle Applications ,Bi apps 7.9.6.2 OBIA

Confidential

OBIEE/ETL Consultant

Responsibilities:

• Designed repository based on business requirements, followed design best practices for the RPD and Dashboard designs.
• Worked on the design of Logical data model.
• Worked extensively on OBIEE Repository, that includes Physical Layer, Business Model layer and Presentation Layer using OBIEE Administration Tool.
• Worked on configuring the metadata of the Booz Allen along with their own Data Warehouse tables.
• Created connection pools, imported physical tables and defined joins in the physical layer of the repository.
• Used different filter conditions both in the repository and in front end based on business rules provided by the business users.
• Extensive experience in setting up MUD Environment.
• Created BI Server Physical layer metadata necessary to access Essbase cubes for reporting and analysis.
• Created dimension hierarchies, aggregates and keys in the BMM layer.
• Created ragged hierarchies for the organizational structure to enable the drill down feature.
• Worked on creating repository and session variables such as static and dynamic along with initialization blocks.
• Database performance tuning and creating Indexes and cost based optimization.
• Designed Data modeling by after understand business requirement. Design Dimensional modeling for Datawarehouse.
• Created groups in the repository and added users to the groups and granted privileges explicitly and through group inheritance
• Worked with DBAs to create materialized views and aggregates to improve performance.
• Created reports which are used to analyze the Performance and Response of the Campaigns held by the Marketing Team.
• Involved in setting up the environments for Development, Unit Testing, System Testing and Production for the developers and testing teams.
• Worked on loading data into Out of the box and Customized Fact tables such as Activity, Call Detail, Belief, Contact Permission, and Syndicated Data Fact groups using out of the box and new Informatica Mappings.
• Created Complex mappings using Unconnected Lookup, Aggregate and Router transformations for populating target table in efficient manner.
• Performed unit testing and system testing of all components of OBIEE Finance Analytics using EBS source.

Environment: OBIEE 11g,Informatica Power Center 8.1.6, Oracle 10g/11g, HP-UX, Windows XP,Oracle Applications ,Bi apps 7.9.6.2 OBIA

Confidential

OBIEE/ETL Developer

Responsibilities

• Collaborated with Business contacts Business Analysts in the analysis and preparation of OBI data requirements
• Developed ETL processes to populate the Enterprise Product Orders data mart Dimensions and Fact using Informatica.
• Participated in the walkthroughs of the data models, identification of dimensional attributes, Facts and Star Schema to fulfill requirements
• Created dimensions, aggregations and keys using admin tool. Customizing Physical Layer, BMM Layer and Presentation Layer using OBI Administration tool.
• Created presentation layer tables by dragging appropriate BMM layer logical columns.
• Developed Global prompts, Filters, Customized Reports and Dashboards using OBI presentation services.
• Created Users and Groups and managing the object level and data level security.
• Managed the intelligent dashboards by using dashboard, page and report level security.
• Creation of views like Pivot table, Column Selector, Compound layout.
• Identified the granularity level of the data required to be available for analysis.