Overview:

• Responsible and highly motivated professional with 8 years of Data warehousing, ETL experience and Over 5 years of experience in BI tools OBIEE/ Siebel Analytics/ Hyperion Essbase .
• Expertise in complete SDLC of Analysis, Design, Development, Maintenance and Documentation of various functionalities of Data Warehouses and Data Marts.
• Experience in designing and developing Banking, Financial, Insurance and Pharma Health care.
• Expertise in designing and developing the OBIEE/Siebel Analytics Metadata Repository .rpd using OBIEE/Siebel Analytics Server Admin tool.
• Good Knowledge in Developing OBIEE Reports using 10G/11G.
• Expertise in creating, modifying and administering OBIEE/Siebel Analytics Intelligence Dashboards using OBIEE/Siebel Answers, creating iBots using OBIEE/Siebel Delivers.
• Expertise in configuring Interactive Dashboards with drill-down capabilities using global and local Filters. Expertise in Implementing Object level as well as Data level Security.
• Expertise in Performance tuning of OBIEE/Siebel Analytics by implementing Cache management and Aggregate Navigation techniques. Implementing Database tuning as well.
• Extensive Experience in developing BI Publisher Reports in 10G/11G.
• Extensive experience in customizing .RPD and Web catalog of OOTB Implementation of various OBI Applications like Financial Analytics.
• Expertise in debugging and optimizing the OBIEE/Siebel Analytics Dashboards / Reports and Informatica Mappings / Workflows.
• Well versed with using SQL and PL/SQL for BI Publisher and XML Publisher.
• Expertise in Oracle BI Answers, BI Interactive Dashboards and Oracle BI Server and Oracle BI Publisher, Implemented Best Practices in BI Publisher/XML Publisher.
• Experience in OBIEE/BI Apps OBIA with Sales Analytics, Financial Analytics, Supply Chain Analytics, Procure and Spend Analytics and HR Analytics.
• Extensive experience in installing and setting up OBI Apps, Configuring DAC and Informatica servers.
• Experience in troubleshooting Complex SQL queries and improve data delivery performance
• Extensively used Informatica Power Center 8.1/7.x/6.2.2 for Extract, Transform and Loading of data from multiple data sources to Data Warehouse and creating various mappings, sessions and Workflows.
• Working knowledge on different data sources ranging from flat files, Teradata, Oracle, SQL Server, DB2 databases and Sybase.
• Expertise in Essbase cube analysis, design and maintenance, Essbase database administration upgrades, performance tuning and optimization on Windows environment.
• Worked extensively on different Informatica transformations like Source Qualifier, Expression, Filter, Aggregator, Lookup Strategy, Update Strategy, Sequence generator, joiner transformations, Router etc.
• Expertise in implementing complex business rules by creating re-usable transformations, robust Mappings/Mapplets, Sessions and Workflows and Worklets.
• Good experience with configuring Data Warehouse Administration Console DAC for creating execution plans, metadata management and monitoring the Informatica ETL Process.
• Configured and registered the custom workflows in DAC.
• Excellent communication skills, ability to meet tight deadlines and prioritize tasks.
• Experience on Production support.
• Expertise in writing complex queries and packages.

Technical Proficiencies:

OLAP/BI Tools: OBIEE 11g/10g, Siebel Analytics 7.8.x/7.7.x/7.5.x, Essbase 9.x/7.x/6.x,

OBIEE Publisher 10.1.3.4/11.1.1.5, Hyperion 9.3.1/11.1.3.

ETL Tools: Informatica Power Center 9.1/8.1.1/7.1.2/6.2/6.1/5.1, Power Mart 5.0/4.7.

Tools: Toad 4.0.3, Erwin 4.1.4/3.5.2, MS-Access, MS-Visio.

Methodologies: Ralph Kimball's Star Schema and Snowflake Schema.

RDBMS: MS-SQL Server 2005/2000/7.0/6.5, Oracle 10g9i/8i/7.3.

Languages: PL/SQL, SQL, C, C , Java 1.2, XML.

Operating Systems: Windows XP/2000/NT/98/95, UNIX, MSDOS.

Professional Work Experience:

Confidential

OBIA Developer

Responsibilities:

• Develop fine tuning reports by using view selector, column selector, drill down- drill through analysis, creating master/detail reports, using database, numeric, date and time functions, etc, where ever necessary to increase performance.
• Worked with different stages of handling data viz. requirement gathering, identifying data sources/targets, data modeling, data cleansing, data loading, and building Star schema.
• Configured interactive Dashboards with drill-down, drill across capabilities using Filters and Dashboard Prompts, Siebel Security Setup groups, access privileges , Metadata Objects and Web Catalog Objects Dashboard, Pages, Folders, Reports and guided navigation links.
• Implemented security tasks like creating user groups, users and managing users by setting up their privileges and profiles.
• Developed different Requests, Filters, Views, Charts, Interactive Dashboards with page using OBIEEE Answers and dashboard Prompts.
• Created Logical tables and columns, Dimensional Hierarchies, Level Based Measures, Time series data, and Repository Variables.
• Worked on OBIEE/BI Apps OBIA with Case Management.
• Coordinated in the client installations and integration of OBIEE 11.1.1.6.1, DAC and Informatica 9.1.
• Worked on Design, Development, Implementation, Testing and Maintenance of Oracle Databases, ETL Processes and Database Deliverables.
• Worked on implementing Security at object level and data level using Repository Variables, Initialization Blocks, and Session Variables.
• Created, Enhanced and troubleshoot reports on BI Publisher.
• Worked with Data warehouse Administration Console DAC to schedule and run full and Incremental ETL loads, to schedule the Informatica jobs, and to customize Execution Plans.
• Developed Informatica Mappings/Mapplets using various Transformations Filter, Expressions, Router, Aggregative, Lookups, Update Strategy and also in creating Workflows.
• Worked on writing complex SQL queries, creating different PL/SQL Objects, Fine Tuning the code, and also in using SQL Loader for loading data into Data Warehouse/Data Mart.
• Tuned Performance for the reports by implementing aggregate navigation and cache management.
• Used Informatica Power Center tools for analysis, design, mapping and workflow.
• Develop mappings in Informatica according to functional/application areas to load the data from source
• to target tables.
• Develop various transformations like Source Qualifier, Update Strategy, Lookup transformation,
• Expressions and Sequence Generator for loading the data into target table.
• Created Workflows, Tasks, and database connections using Workflow Manager.
• Develop Mappings and Workflows to generate staging files.
• Develop Mappings and Workflows to load the data into Oracle tables.
• Developed complex Informatica mappings and tuned them for better performance.

Environment: OBIEE 11.1.1.6.1, Oracle BI Apps 7.9.6.3 Case Management , BI Publisher 10.1.3.4.1/

11.1.1.5.0, Informatica Power Center 9.1, Oracle 11g/10g, DAC, TOAD, SQL, Windows XP

Confidential

OBIA Consultant

Responsibilities:

• Interacted with Procurement and Operation/Maintenance business representatives for gathering the OBIEE Reports/ Dashboards requirements and to define business and functional specifications.
• Analyzed and used various data sources- Oracle and Excel and Web services.
• 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.
• Developed BI Consumer reports using OBIEE 11g.
• Added users and configured security in web logic console of OBIEE 11g.
• Define data and technical architectures and technical requirements for the data warehouse.
• Choose or suggest data warehouse technologies such as Data Quality, ETL, BI and DBMS.
• Used Informatica Workflow manager and Workflow Monitor to schedule and monitor session status.
• Developed PL/SQL procedures and functions and used the same in mappings, pre and post sessions.
• Created Dimension hierarchy in Business model layer.
• Created measure with Logical Columns and Physical Columns.
• Successfully installed and configured OBIEE 11g version 11.1.1.6.1.
• Trained in BI Publisher Standalone 11g as well as Integrated with OBIEE 11g, to answer business questions.
• Experience in configuring Security Settings groups, roles, access/query/report privileges and scheduling iBots/Agents for OBIEE 11g..
• Experience with weblogic server and Enterprise manager in OBIEE 11g.
• Re-developing all current Oracle Discoverer Finance and Publishing reports in OBIEE 11g.
• Extensively worked on developing Data model based on STAR schema concept using OBIEE 11g Administration Tool for current and future reporting requirement.
• Migrated current OBIEE 10g repository and web catalog to OBIEE 11g.
• Installed, maintained Production, development, test databases using oracle 8i-9i-10g-11g .
• Implementation and maintenance experience of oracle 10g and 11gR2 11.2.0.1 database and physical standby database, data guard DR before moving to production for reporting application.
• Developed the Incremental ETL Processes like Mappings Mapplets using various Transformations. And workflows with Sessions/Tasks. Executed the workflows with Shell Scripts.
• Responsible for analyzing, designing and developing ETL strategies and processes, writing ETL specifications for developer, ETL and Informatica development, administration and mentoring.
• Develop ETL programs mappings, sessions, workflows via Informatica 9.1.4.
• Saved Resources from a claims tracking process by modeling a Claims data mart to contain aggregated claims. Rolled up claims by coding SQL stored procedures, Informatica ETL and UNIX scripts.
• Implementation and configuration of Oracle Financial Analytics, Oracle HR Analytics, with OBIEE, BI Apps.

Environment: OBIEE 11.1.1.6.1, OBIA, Oracle BI Apps Oracle Financial Analytics, Oracle HR Analytics , Data Modeling ER Win , BI Publisher 10.1.3.4.1 /11.1.1.5.0, Informatica Power Center 9.1, Oracle 11g/10g, DAC, TOAD, SQL, Unix.

Confidential

OBIEE/ OBIA Consultant

Responsibilities:

• Designed Metadata repository Physical layer, Business Model Mapping layer and Presentation Layer in OBIEE 11g/10g.
• Defined the Dimensional Hierarchy and created the Dimensional Levels for each of the dimensions in the BMM layer for Drilldowns
• Defined Connection Pools to the Source Data warehouse tables in the Physical Layer.
• Created Aliases and defined Role-Playing Dimensions.
• Created Repository Groups and Web Groups and assigned users to configure security in OBIEE 11.1.1.5.
• Utilized session variables, repository variables and initialization blocks in the repository building and modification procedures in OBIEE.
• Worked on Dashboard and Page level prompts and Report filters.
• Designed and Upgraded OBIEE BI Apps HR Analytics Financial Analytics from OBIEE 10G to OBIEE 11G.
• Interacted closely with Functional Analysts and Business Users in the client side, and designed the system accordingly.
• Performed the gap analysis, Identified Facts and Dimensions with levels hierarchy and made required changes to the Data Model Physical, Business and Presentation layer .
• Used Action Framework to see the linking of invoice details to Invoice number.
• Developed Parent Child Hierarchies in the repository.
• Used Table and pivot table to display hierarchical columns.
• Worked extensively with OBIEE Administration tool, Presentation services and BI Publisher.
• Customized Meta Data Repository RPD to work with PeopleSoft Financials AP, AR, GL and CAM . Pulled new physical tables to physical layer of RPD, joined them with dimension tables, developed hierarchy and presented them to presentation layer.
• Created Session variable, Repository variable in RPD and used the same for role based security and Dynamic calculation in OBIEE Answers.
• Created Time- Series calculations using AGO and TODATE functions on BMM layer of Repository.
• Created session variables for users to provide row- level data level security and used the session variable in OBIEE Answers to build the query.
• Converted Main Frames Reports to BI Publisher Reports.
• Implemented custom drilldown functionality in BI Publisher 11g to replace the Mainframe reports functionality.
• Developed different Dashboards/Reports with different view Calculation, Detailed, Pivot, Charts, Filters and different intuitive drilldowns, drill-across and drillable charts using the OBIEE Answers.
• b. Performed object-specific tasks like modifying settings using the associated editor, Creating/ assigning an agent.
• a. Perform basic tasks such as creating, deleting, and copying objects and folders.
• Used the Oracle BI Presentation Catalog in order to
• Worked with properties such as changing the ownership of a folder or viewing the creation date of an object.
• Developed Master Detail Report in OBIEE.
• Worked with Cache persistence Wizard to efficiently handle cache
• Created Aggregate Level facts to improve the performance in the reporting needs.
• Used the Totals/Subtotals/Group/Sort features of BI Publisher to make data intense operations happen at the template level.
• Customized various BI Publisher 11G Reports using RTF templates and defined their respective Templates and Data Definitions.
• Monitored incremental and full load of data extraction through Data Warehouse Administration Console DAC and Informatica.
• Supporting Informatica Server and related components within the Oracle BI Package
• Worked on all activities related to the development, implementation, administration and Support of ETL processes for large-scale Data Warehouses using SQL Server SSIS and DTS.
• Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.
• Involved in Upgrading the OBI Apps from 7.9.6.2 to 7.9.6.3 and also involved in setting up of the DAC which has the backup of your DAC client and Server and DAC metadata files.
• Responsible for Unit and System Testing and performed Data Validation for all the reports. Developed SQL queries and PL/ SQL packages from scratch to use as BI Publisher Event Trigger.
• Worked extensively on Oracle BI Publisher and provided the capability to download the high-fidelity reports in the user defined formats PDF, CSV, HTML, EXCEL and XML DATA .
• Scheduled IBots and seeded server cache using Delivers to improve system performance. Scheduled reports to be e-mailed using BI Publisher Scheduler.
• Coordinated the RPD and Web Catalog objects migration from Development environment to QA environment and then to the Production environment using OBIEE Catalog Manager.

Environment: OBIEE 11g/10g, OBIA, Oracle BI Apps HR Analytics Financial Analytics , Data Modeling ER Win , BI Publisher 10.1.3.4.1/11.1.1.5.0, Informatica Power Center 9.1, Oracle 11g/10g, DAC, TOAD, SQL, Windows XP.

Confidential

OBIEE BI Consultant

Responsibilities:

• Interacted with Business Analysts and Users in gathering and analyzing and designing the Business Reports Requirements.
• Performed the gap analysis, Identified Facts and Dimensions with levels hierarchy and made required changes to the Data Marts.
• Involved in designing and developing subject areas in Repository .RPD catering to the OLAP reporting needs of Bank BI Project using OLAP Multi-Dimensional Essbase Cubes.
• Developed various Essbase cubes with excellent balance of dense and sparse dimensions, arranged in an hourglass fashion.
• Developed MaxL scripts, data load rules DLR , Business rules, Calculation scripts and Report scripts for outline in Essbase cube.
• Implemented Complex Logging in SSIS Packages.
• Created SSIS packages and used Analysis Services processing task to update the cube with current data.
• Created SSIS/DTS packages for Finance application that would transfer data among servers and perform other data transformations scheduled the same SSIS packages by creating the corresponding job tasks.
• Implemented the Time Series Wizard YTD, QTD, and MTD for comparing measures in different time Periods.
• Created Repository Static and Dynamic variables. Also created Initialization blocks for Session variables, which are used for authentication and security.
• Created Dimension Hierarchies in the BMM layer to drill down and drill across on various dimensions as per client requirement.
• Implemented OBIEE Security Object Level and Data Level Security in the OBIEE Repository and Answers using Repository Variables, Session Variables and Initialization Blocks.
• Created Security settings in OBIEE Admin Tool to setup groups, access privileges and query privileges. Implemented Object level as well as Date level security.
• Created Catalogs in Presentation layer used for both ad-hoc and Dashboard end users.
• Created OLAP requests in OBIEE/Siebel Answers and multi-level requests drill-downs and guided navigation .
• Created multiple reports reflecting region hierarchy based on roles VP, Director and Account executive.
• Worked on cache purging strategy using Event-polling table. Worked on IBots using OBIEE/Siebel Delivers for caching and delivering the reports to subscribed users.
• Documented the Functional and Technical design documents in MS word and latter converted the Technical design document in to the report Field Mapping Document.
• Performance tuning in OBIEE for star schemas by implementing aggregate navigation, cache management, Materialized Views and Database tuning.
• Used Informatica Power Center tools for analysis, design, mapping and workflow.
• A full cycle development of Supply Chain Analytics was implemented. Involved in indentifying, designing, configuring testing the application.
• Used DAC Data warehouse Administration Console for both incremental and full loads.
• Developed various transformations like Source Qualifier, Update Strategy, Lookup transformation, Expressions and Sequence Generator for loading the data into target table.
• Created Workflows, Tasks, database connections using Workflow Manager
• Worked with Element tool for logging and tracking and fixing bugs in QA Testing.
• Debugged and resolved data matching issues ranging from the base tables to BI dashboard reports.
• Loaded the data to fact and dimension tables from ODS to STG and STG to FCT and DIM.
• Develop Mappings and Workflows to generate staging files.
• Develop Mappings and Workflows to load the data into Oracle tables.
• Developed complex Informatica mappings and tuned them for better performance

Environment: OBIEE 10.1.3.4, BI Publisher XML Publisher , Financial analytics, HR analytics, Procurement, Supply Chain, DAC Data Warehouse Admin Console , Essbase 9.3.1, Informatica 8.1.1, Oracle 10g, windows XP.

Confidential

OBIEE Developer

Responsibilities:

• Coordinated in the client installations and integration of OBIEE 10.1.3.3, DAC and Informatica 7.1.2
• Interacted with business representatives for requirement analysis, and to define business and function/technical specifications.
• Customized OBIEE OOTB metadata repository for AR, AP and GL.
• Develop mappings in Informatica according to functional/application areas to load the data from source to

target tables.

• Created the new columns in existing fact and dimension tables and creating all together the new dimension and fact tables.
• Imported the custom fact and dimension tables and configured it in the 3 layers of the RPD. Implemented Level Based Metrics in the BMM layer. Created Compound facts in the BMM as per the client requirement.
• Written RRD Report requirement document RDD Report development document TDD Technical design document .
• Designed Schema using custom fact, dimensions, physical, logical, Alias and extension tables
• Created Dimension Hierarchies in the business model and mapping Layer to drill down custom Store and product dimensions.
• Implemented conditional formatting using OBI Publisher.
• Customized the out of the box Informatica SDE and SIL mappings to include mappings for new columns created in the existing facts/Dimensions or created new SDE and SIL mappings for new facts/dimensions.
• Created Security settings in OBIEE Admin Tool to setup groups, access privileges and query privileges.
• Performance tuning in OBIEE for custom made star schemas by implementing aggregate navigation and cache management.
• Developed different reports using Siebel Dashboard and Answers like views charts, pivot and narrative, tabular used global and local filters.
• Created the Custom Dashboard for the custom reports and aligned the reports with in the dashboard according to client requirement.
• Tuned Performance for the reports by implementing aggregate navigation and cache management.
• Configured iBots and Delivers to send alerts to subscribed users.
• Ran the test scripts logged the bugs in element tool and fixed the bugs.

Environment: OBIEE 10.1.3.2, General Ledger GL , Account Payables AP , Accounts Receivable AR , OBIEE Publisher 10.1.3.2, EBS, OBI Applications, Informatica 7.1.2, Oracle 10g, SQL, Toad, UNIX.

Confidential

Siebel Analytics Consultant

Responsibilities:

• Gathered information by interacting with clients and end users.
• Involved in full Life Cycle Implementation of OBIEE.
• Upgraded and migrated Siebel repository .rpd database from Siebel Analytics 7.7 to 7.8
• Designed and build Star schemas.
• Configured repository RPD to use the LDAP authentication.
• Define the mapping from various physical databases to Business Layer to create the various subject areas in Presentation Layer.
• Defined dimensions and facts in the subject areas.
• Implemented Siebel security for users and groups in administrator tool.
• Created reports by applying views, filters, calculations and conditional formatting in answers.
• Used BI Publisher for manage and deliver all types of highly formatted documents.
• Applied Optimization techniques and tuned performance of the reports.
• Used DAC Data Warehouse Administration Console Client to manage, configure, customize and monitor ETL process
• Created the source and target instances and various transformations Joiner, Aggregate, Lookup, Filters and Router Transformations in informatica and also created mappings, sessions and workflow to run ETL process using Informatica Power Center
• Experienced in Data warehouse/Data Mart Development Life Cycle and performed ETL procedure to load data from different sources into data- warehouse using Power Center, Repository Manager, Designer, Workflow Manager and Workflow Monitor.
• Participated in the Modeling of several multidimensional Data Marts including surrogate key design and index placement
• Created and scheduled iBots as per the business requirements
• Created reports of using BI Publisher through OBIEE
• Extensively worked on Data Extraction from Databases and flat files by using Informatica
• Designed Intelligent Dashboards for different user groups to view updated KPI's.
• Prepared the ETL Mapping spreadsheet and Fact Dimension Matrix simultaneously prior to performing the ETL process.
• Assist in performance of Gap Analysis related to Data Models and data extracted in ETL's, and map client requirements into Siebel Analytics functionality.
• Provided technical and user documentation and training.

Environment: Oracle Business Intelligence Enterprise Edition, Oracle BI Server, BI Answers, BI Administration, BI Dashboards, BI Scheduler, BI Publisher, DAC, Informatica 6.1, Oracle 10g, , PL/SQL Windows XP Prof.

Confidential

PL/SQL Developer

Responsibilities:

• Worked with a team of IT developers in the Initial Database Design/Data Modeling/Data approval.
• Measured the performance of the shell scripts by getting the expected results
• Writing PL/SQL code using the technical and functional specifications
• Generated SQL and PL/SQL scripts to install create and drop database objects including Tables, Views, Primary Keys, Indexes, Constraints, Sequences and Synonyms
• Involved in writing Packages, Functions, Stored Procedures and Database Triggers
• Created stored procedures, functions, packages, data base triggers and cursors based on requirement
• Developed complex queries to retrieve the data
• Created partitions for performance improvement of queries
• Extensively used Cursors, Ref Cursors and Exceptions in developing Packaged Procedures and Functions.
• Created indexes for faster access of data
• Documented business rules, functional and technical design, test cases and user guides
• Extensively used UTL FILE an oracle built in function to transfer data from the source system to flat files to conversion staging area
• Extensively used bulk collect to fetch large volumes of data from the table
• Created Jobs and stored procedures using Dynamic SQL for refreshing materialized views
• Involved in debugging and error handling
• Involved in creating Index's, passing hints, analyzing the table
• Monitored the database growth on daily basis. Established backup and recovery strategies
• Worked on Database tuning and performance monitoring
• Detected and corrected bugs during system integration and user acceptance testing
• Created UNIX shell scripts for FTP batch jobs, creating SQL reports and email notifications

Environment: Oracle 10g, UNIX shell scripting, TOAD, SQL Plus.