SUMMARY

• Around 7 years of IT Industry experience in Database development, Data Warehousing and Business Intelligence using Oracle Business Intelligence (OBIEE)/Siebel Analytics, Oracle Databases and Oracle Reports, Informatica Power Centre 8.1.1.
• 3 Years of Experience in Full Systems Development Life - Cycle Implementation of various Oracle/ETL (Informatica) /OBIEE/Siebel Analytics Projects.
• Experienced in Implementing Oracle Business Intelligence Analytics OBIA (Procurement and Spend Analytics, HR).
• 3 months of experience in OBIEE 11g installation, Configuring Repository, Create/Manage Dashboards, Reports/Answers and building Physical, Business Model and Presentation Layer.
• 2 Years of Data Warehousing( ETL) experience using Informatica Power Center 8.1.1/7.1 and client tools like Mapping Designer, Workflow Manager, Workflow Monitor and Repository Manager.
• Experience in Dimensional Data modeling, Star Join Schema/Snowflake modeling, FACT & Dimensions tables, Physical & logical data modeling.
• Proficient in installation and configuration of OBIEE on Windows environment.
• Expertise in OBIEE 10.1.3.2/10.1.3.3/10.1.3.4 and in Configuring Repository, Create/Manage Dashboards, Reports/Answers and building Physical, Business Model and Presentation Layer.
• Experience using Configuration File Management and Release Management using PVCS Configuration Management Tool.
• Proficient in implementing Database Caching and Report caching techniques in order to improve query response time as well as optimize the system.
• Expertise in implementing various transformations using Designer Tool of Informatica Power Centre 8.1.1.
• Proficient in Merging/ Importing Objects from Different Repositories using Oracle BI Admin Tool.
• Experience in Creating Dimensional Hierarchies, Level Based Measures and Time series Functions depending upon the need for Business Reports using the OBIEE/ Siebel Admin tool.
• Expertise in Creating Filters, Global Prompts in Dashboards, Presentation Variables, and Narrative Views to filter the data and represent data in the more informative ways.
• Proficient in creating a BI Publisher Report Based on Oracle BI Answers Request..
• Created Initialization Blocks and Variables using Administration Tool in OBIEE to streamline administrative task and modify metadata content dynamically.
• Experience in creating Dynamic Repository variables in order to establish specific detail oriented report.
• Proficient in executing Direct Database Request in OBIEE.
• Expertise in Scheduler setup and iBot Configurations for delivering reports using Oracle BI Delivers component of OBIEE.
• Involved in Securing and refreshing data in workbooks, worksheets, slides, in Excel and PowerPoint and also applying conditional formatting in Excel.
• Expertise in Migrating reports from Oracle Reports 10g to OBIEE environment.
• Expertise working with SQL Tools likes SQL Developer and TOAD.
• Experience in SQL Querying, writing Stored Procedures using PL/SQL, Functions, Triggers, and Indexes for OLTP Systems.

TECHNICAL SKILLS:

Operating Systems: Windows XP, Vista, UNIX

Databases: Oracle 9i/10g, MS Access 2007, Microsoft Sequel Server 2005/2008, MY SQL

Languages: PL/SQL, SQL, C, C++,Cobol

Web Technologies: HTML, XML, JavaScript, ASP.NET

Tools and Utilities: TOAD, SQL*NAVIGATOR, UTL FILE, ODBC, PLSQL DEVELOPER, Forms Builder, Reports Builder, Schema Builder, Procedure Builder, Graphics Builder, Import & Export utility

Reporting Tools: Oracle Developer Suite 10g ( Oracle Reports)Oracle Business Intelligence Enterprise Edition Versions: 11g, (10.1.3.2/10.1.3.3/10.1.3.4 ), Oracle Business Intelligence Analytics 7.9.5 ( HR, Procurement and spend analytics, Service Analytics), Oracle BI Publisher

Domain Knowledge: Child Support, Health Care, Procurement, Finance, Banking, Sales, Services

ETL Tools: Informatica Power Center 8.1.1

PROFESSIONAL EXPERIENCE:

Confidential, Lake Forest, CA

Sr. OBIEE Technical Lead

Responsibilities:

• Prepared the Design Specification Document based on functional requirements and also involved in the preparation of Technical Design Documents.
• Worked with the ETL team to design the Star Schema and populate the Data warehouse.
• Customized the prebuilt Service Analytics Metadata.
• Involved in performance tuning of the Facts, creating indexes.
• Assigned tasks to the offshore team and reviewed them.
• Built the Physical Layer /Business Model and Mapping Layer/ Presentation Layer of a Repository by using Star Schemas.
• Involved in creating Dashboards for the reports also using Guided Navigation and Links.
• Involved in Performance Tuning of reports by identifying the indexes required on the backend tables and also from the data available in the Cache.
• Modified Dynamic Session Variables.
• Designed Interactive Dashboards and created dashboard prompts with multiple selections.
• Installed and Configured the BI Office Client.
• Generated compound views and advanced features such as editing prompts, inserting funnel and gauge views in the BI Answers Request.
• Designed reports using Column Selector and View Selectors.

Environment: OBIEE 11.1.1.6.2, Oracle 11g, SQL Developer, BI Publisher.

Confidential, San Deigo, CA

Sr. OBIEE Technical Lead

Responsibilities:

• Prepared the Design Specification Document based on functional requirements and also involved in the preparation of Technical Design Documents.
• Worked with the ETL team to design the Star Schema and populate the Data warehouse.
• Customized the prebuilt Service Analytics Metadata.
• Involved in performance tuning of the Facts, creating indexes.
• Assigned tasks to the offshore team and reviewed them.
• Involved in identifying and implementing multiple date or timestamp dimensions, degenerate dimensions, role-playing dimensions, status dimensions, audit dimensions and junk dimensions to design the Schema.
• Built the Physical Layer /Business Model and Mapping Layer/ Presentation Layer of a Repository by using Star Schemas.
• Involved in creating Dashboards for the reports also using Guided Navigation and Links.
• Involved in Performance Tuning of reports by identifying the indexes required on the backend tables and also from the data available in the Cache.
• Modified Dynamic Session Variables used for Data Visibility, Configured Security at the repository level, Catalog level & the OBIEE Application level.
• Designed Interactive Dashboards and created dashboard prompts with multiple selections.
• Installed and Configured the BI Office Client.
• Generated compound views and advanced features such as editing prompts, inserting funnel and gauge views in the BI Answers Request.
• Designed reports using Column Selector and View Selectors.

Environment: Oracle 10g, 11g, SQL Developer, Toad, BI Publisher.

Confidential, Baltimore, MD

OBIEE Technical Lead

Responsibilities:

• Gathered business requirements & functional specifications and worked on the design of HR Analytics.
• Prepared the Design Specification Document based on functional requirements and also involved in the preparation of Technical Design Documents.
• Worked with the ETL team to design the Star Schema and populate the Data warehouse.
• Scheduled and Monitored ETL runs using DAC
• Customized the pre built HR analytics.
• Worked extensively on HR analytics subject areas Recruiting, Payroll and Human Resource.
• Upgraded the existing reports from OBIEE 10.1.3.4 to OBIEE 11g.
• Involved in testing the Reports, Dashboards and IBOTS after Upgrade.
• Modified the Report layouts in BI Publisher 11g.
• Involved in identifying and implementing causal dimensions, multiple date or timestamp dimensions, degenerate dimensions, role-playing dimensions, status dimensions, audit dimensions and junk dimensions to design the Schema.
• Built the Physical Layer /Business Model and Mapping Layer/ Presentation Layer of a Repository by using Star Schemas.
• Added Aggregate measures using Aggregate Persistence Wizard.
• Configured Business Intelligence Delivers.
• Involved in creating Dashboards for the reports also using Guided Navigation and Links.
• Involved in Performance Tuning of reports by identifying the indexes required on the backend tables and also from the data available in the Cache.
• Modified Dynamic Session Variables used for Data Visibility, Configured Security at the repository level, Catalog level & the OBIEE Application level.
• Configured Ibots to run reports at scheduled time for Cache Seeding to Improve Query Performance using Caching.
• Designed Interactive Dashboards and created dashboard prompts with multiple selections.
• Integrated reports created in Oracle BI Publisher with Oracle Business Intelligence Enterprise Edition.
• Created BI Publisher Reports based on the BI Answers request for the same.
• Installed and Configured the BI Office Client.
• Generated compound views and advanced features such as editing prompts, inserting funnel and gauge views in the BI Answers Request.
• Secured and refreshed data in workbooks, worksheets, slides, or presentations in Excel and PowerPoint.
• Applied Excel-specific formatting to BI data: data formats, fonts, and conditional formats that are retained when refreshed BI data.
• Created complex queries using Database triggers, functions and packages (PL/SQL) to support complex calculations and generated the report output in Oracle BI Publisher (stand-alone) using SQL Developer and Oracle Database 10g.

Environment: OBIEE 11g, Oracle Business Intelligence Analytics 7.9.5, People Soft, Oracle Database 10g, SQL Developer, BI Publisher.

Confidential, Weston, MA

OBIEE Developer

Responsibilities:

• Involved with the Data Architects to design and implement STAR Schema- identifying dimensions, facts and measures for sales specific data.
• Worked with team members to design and develop End-to-end ETL Informatica based mappings and batches.
• Created complex mappings using transformations like update strategy, expression, aggregator, filter, lookup and procedure to extract data, transform and load it into the warehouse.
• Created reusable transformations, Mapplet in the designer using transformation developer and Mapplet designer tools.
• Extracted data from different sources like, Oracle, Flat files, Xml & loaded into Operational Data Source.
• Extensively used SQL and PL/SQL Procedures and Worked in Windows environment.
• Tested the mappings generated by analyzing the data flow, evaluating transformations and fixing the bugs so that they conform to the business needs.
• Extensively worked in the performance tuning of ETL mappings and sessions.
• Coordinated in the Client Installations of OBIEE, OBI Applications.
• Interacted with business representatives for requirement analysis, and to define business and function/technical specifications.
• Customized OBIEE OOTB Metadata Repository for Order Management and Order Fulfillment.
• 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.
• 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.
• Created Security settings in OBIEE Admin Tool to setup groups, access privileges and query privileges. Implemented Object level as well as Date level security.
• Performance tuning in OBIEE for custom made star schema’s 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.
• Configured iBots and Delivers to send alerts to subscribed users.

Environment: Oracle Reports 10g, OBIEE 10.1.3.3/ 10.1.3.4, Oracle Business Intelligence Analytics 7.9.5, BI Publisher, SQL Developer, MS SQL Server 2005, Microsoft Office 2007, Informatica Power Centre 8.1.1, ERWin.

Hanover Insurance, Worcester, MA

Siebel Analytics/ Reports Developer

Responsibilities:

• Involved in designing STAR schema with the data modelers based on the business requirements gathering using ERWin tool.
• Worked with the Informatica Administrator to establish repositories based on MS SQL Server Database and Oracle database 10g.
• Installed & configured Oracle Business Intelligence Infrastructure (OBIEE 10.1.3.2), Oracle BI apps 7.9.4, Oracle Analytics Data Warehouse, Informatica 7.1.4 & DAC on Windows 2003 and Linux servers.
• Created mappings involving Expression, Filter, Sequence Generator, Look up, Update Strategy, Router, Sorter, Joiner and Source Qualifier Transformations.
• Developed mappings to load data into slowing changing dimensions.
• Created reusable transformations, Mapplet in the designer using transformation developer and Mapplet designer tools.
• Involved in creating sessions and workflows and using the Informatica debugger to debug when the mappings which are executed and are not producing expected results.
• Developed Look up Transformations to access data from tables, which are not the source for the mapping and also used unconnected mapping to improve performance.
• Created Repository, Folders, Users, and user privileges using Repository Manager.
• Maintained warehouse metadata to control the Informatica Metadata Repository using Repository Manager.
• Involved in Requirements Gathering and the GAP analysis.
• Worked with clients to understand business requirements and translated those business rules into ad-hoc queries and reports using OBIEE/Siebel Analytics 7.7.
• Partnered with the data modeler’s in establishing logical data model (Star Schema) for the Project.
• Developed the Siebel repository/metadata (Physical Layer, Business Model and Mapping Layer and Presentation Layer) and created the subject area where reporting and analysis are centered around using the Siebel Analytics Administration tool.
• Developed Calculated Measures and dimension hierarchies in the Business Model and Mapping Layer
• Defined dynamic repository variables to modify metadata content dynamically to adjust to a changing data environment.
• Configured Web Catalog Objects (Dashboards, Pages, Folders and Reports).
• Developed, modified and tested complex queries, programs and stored procedures to support ad-hoc reporting using SQL and PL-SQL in order to publish the required report output.
• Implemented different views of report i.e. Pivot table, Titles, Graph, Filters etc.
• Created Users, Groups and giving the permissions in Siebel Administration Tool and verified the permissions of the users in the Siebel domain.
• Performed Pre and post implementation testing of Dashboard, Answers and validating Repositories.
• Created Dashboards, Answers Request spanned upon 4 different repositories.
• Developed user guides for the end users. User guide contained some screenshots of high level report and also provides instructions in accessing them and making necessary changes.

Environment: Siebel Analytics 7.7, Oracle Database, Informatica Power Centre 7.1, TOAD, Microsoft Office.

Confidential, Durham, NC

Siebel Analytics/ Reports Developer

Responsibilities:

• Participated in User Meetings to understand the requirements.
• Worked closely with the data modeler in creating logical data model (Star Schema).
• Built the Siebel Analytics repository/metadata (Physical Layer, Business Model and Mapping Layer and Presentation Layer) and created the subject area where reporting and analysis are centered around.
• Developed Calculated Measures and dimension hierarchies in the Business Model and Mapping Layer
• Configured Web Catalog Objects (Dashboards, Pages, Folders, Reports)
• Generated different kinds of reports using Siebel Answers and assigning them to application specific dashboards.
• Worked on Siebel Answers to build Interactive Dashboards with drill-down capabilities based on organization’s and product’s hierarchies
• Implemented different views of report i.e. Pivot table, Titles, Graph, Filters etc.
• Generated Dashboards to provide insight into Sales Analytics, Activity Analytics.
• Created Users, Groups and giving the permissions in Siebel Analytics Administration Tool and verifying the Permissions of the users in Siebel Analytics web.
• Assisted in creation of pivot table requests allowing manager’s to analyze the business/data from different perspectives.
• Performed Pre and post implementation testing of Dashboard, Answers and validating Repository.
• Developed user guides for the end users. User guide contained some screenshots of high level reports and also provides instructions in accessing them.
• Also participated in developing ETL design using Informatica, used Transformations like Aggregator, Joiner, Update, Filter, Lookup, Sorter.

Environment: Siebel Analytics 7.8.5, Informatica 7.1.2 (Power Center Designer, Workflow Manager, Workflow Monitor), Siebel DAC, SQL Server 2000/2005, Windows

Confidential

ETL Developer

Responsibilities:

• Analyzed the requirements, functional specifications and identified the source data to be moved to the Data Warehouse
• Project involved collecting the data from different sources like Flat files, SQL Server and Oracle
• Analyzed the Sources and Targets and designed mappings and Transformations
• Extensively used Lookup, Aggregator, Expression, Update Strategy, Stored Procedure, Filter and Router transformations
• Involved in GAP Analysis identifying the missing/orphaned columns based on the end user requirements
• Created, scheduled and monitored the sessions and batches using Workflow Manager
• The Work done by the Sales Personnel was measured by the Task definition and Reported Task, this involved the amount of time the personnel was productive which included the Login and Log out time
• Interacted with Business Users to create Subject Areas, Folders/Sub-Folders
• Involved in Reconciliation Process while testing loaded data with user reports.

Environment: Windows 2000/2003, SQL-Server 2000, Query Analyzer, Oracle 8.0, Erwin, Informatica Power Center 6.2