SUMMARY

• Over 8 years of IT experience which includes analysis, design, development, implementation, deployment and maintenance of Business Intelligence, Data Warehouses and Data Mining applications.
• 6+ years of experience on Siebel Analytics 7.7.1,7.8.5/OBIEE 10.1.x, 11.1.1.5,11.1.1.6, BI App version - 7.9.6.3 In designing Dashboards (Oracle/Siebel), Answers (Oracle/Siebel), and Analytics/Oracle Administration Tool i.e. Analytics rpd.
• Having 2+ years of experience in ETL methodology using Informatica Power Center/Mart.
• Proficient in Installing and configuring Siebel Analytics/OBIEE, Oracle BI Apps (DAC) and Informatica.
• Expertise in providing end-to-end business intelligence solution by configuring metadata & building Analytics Repository, dimensional modeling design, building business models, generating reports, and creating Inter-active Business Intelligence Dashboards using Siebel Analytics/ Oracle Business Intelligence (OBIEE).
• Experience in Upgrading Rpd, Web Catalogs from OBIEE 10g to OBIEE 11g using upgrade assistant utility(Oracle Fusion Middleware Upgrade Wizard).
• Experience in working with new web console and Enterprise Manager of OBIEE 11g.
• Sound knowledge of database architecture for OLTP and OLAP applications, Data Analysis, ETL processes in developing data marts and Enterprise Data Warehouse.
• Experience in converting and using Oracle pre-build rpd’s (Financial, Supply Chain and Order Management, Marketing Analytics, etc.) according to business requirements.
• Expertise in 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.
• Experience in implementing new features in OBIEE 11g such as Sliding Bars, Moving Columns dynamically on the dashboard.
• Experience in Dimensional Data Modeling using Star Schema, Snow-Flake Schema, Fact and Dimensional Tables.
• Experience in Extraction, Transformation and Loading of data from Multiple Sources to Data Warehouse and creating Workflows, various Tasks and scheduling them using Informatica Power Centre (Designer and Workflow Manager).
• Expert in Performance tuning of Oracle BI / Siebel Analytics Repository, Analytics Dashboards/Reports, Informatica Mappings/Mapplets and Oracle programs.
• Strong working experience in using OBI/Siebel Delivers which includes configuring Delivery Devices, creating and configuring iBots, and building Alerts.
• Expertise in Merging repositories and Implementing MUD (Multi User Development) Environment.
• Experience on assigning Data security & UI level security to the users using OBIEE repository objects & external data base.
• Worked extensively in developing Informatica mappings and mapplets to build key interfaces using transformations (Source Qualifier, Joiner, Update Strategy, Lookup, Rank, Expressions, and Aggregator) for loading the data into data warehouse.

TECHNICAL SKILLS

BI Tools/Analytics: OBIEE 11.1.1.6.0 , 11.1.1.5/10.1.3. x, BI App version - 7.9.6.3, Siebel Analytics 8.x, 7.x (Administration, Interactive Dashboards, Disconnected Analytics, Briefing Books, BI Delivers, Web Catalog Administrator Analytics Server Administration)

Database: Oracle R12.1.3, 11g /10g/9i/8i/7.x, SQL Server 2005/2000, MS Access

ETL Tools: Informatica Power Center server v9.0.1 Hot Fix? 2,8.6/8.1/7.x/6.x Power Mart 6.2/5.1, Oracle Data Integrator (ODI)

Data Modeling Tools: Erwin, Star Schema, Snowflake Schema, Tables, Physical and Logical

Languages: SQL, PL/SQL, C, Java 1.3/1.4/1.5/1.6 , HTML, XML

Oracle Tools/Utilities: SQL*Loader, Oracle Designer, SQL Developer, TOAD, SQL Navigator, JDeveloper, Oracle Developer 2000

Scripting Languages: JavaScript, VBScript and UNIX shell script

Operating System: Windows Vista, Win 95/98/2000/XP/7, Win NT 4.0, Linux, UNIX

Scheduling Tools: DAC 10.1.3.4.1 (Data warehouse Administration Console)

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, NC

Sr. BI Developer

Responsibilities:

• Worked with business users to understand business requirements and translate to appropriate technical solutions.
• Used the Administration Tool to configure the physical, logical and presentation layers of the RPD.
• Configured the RPD by creating level-based and time series measures, dimensions and their hierarchies, aggregates and variables that provided business analysts the ability to easily slice and dice data in Answers.
• Created pervasive and interactive dashboards with scorecards, year over year analysis, distribution void and business trending reports using bins, guided navigation links, conditional formatting and variety of views. This allowed the sales team to spend more time selling than creating reports and managers reconciling reports.
• Analyzed and validated the business model in Oracle BI Administration Tool by performing consistency check, validating logical source tables, logical columns, and also validating repository level calculations done in the business model layer
• Performed Presentation Services Administration tasks like managing privileges, managing groups and users, and managing interactive dashboards and sessions.
• Developed Month Ago, Year Ago Measures for Comparison of Sales and Used Time Series Functions and To Date Functions Extensively.
• Responsible for migrating the web catalog and RPD from DEV, UAT and Training, Production environments.
• Tuned OBIEE Reports and designed Query Caching and Data Caching for Performance Gains.
• Developed many Ad-hoc and standard Reports / Dashboards with different Analytics Views (Drill-Down / Dynamic, Cascading Style Sheets, Pivot Table, Chart, Column Selector, Tabular with global and local Filters).
• Configured iBots using delivers to seed server cache and send requests to dashboards as Alerts.
• Involved in user trainings on the generated reports for this project.

Environment: Oracle Business Intelligence Enterprise Edition (OBIEE) 10.1.3.4.1 , Linux, UNIX, Oracle 11g/10g, Windows 7, Apex 4.0.2, SQL, PL/SQL and TOAD.

Confidential -Durham, NC

Oracle BI Developer

Responsibilities:

• Involved in Requirement gathering from business users and translated them into technical specifications.
• Worked with data architects to translate business requirements into technical specifications and logical & physical data models.
• Imported Dimensions and Facts into OBIEE Repository and built Physical Layer, Business Model and Mapping Layer, and Presentation Layer using Oracle Admin Tool.
• Created Hierarchies, Aggregations and Levels using admin tool in the Business Model and Mapping Layer.
• Developed custom reports/Ad-hoc queries using Oracle BI Answers and assigned them to application specific dashboard.
• Developed many Reports/Dashboards with different Analytics Views (Drill-Down & Drill-Across, Pivot Table, Gauge, Graph, Chart, View Selector, and Column Selector, with global & local Filters using Oracle BI Web.
• Used Filters (global and local) and provided customized Prompts to avoid excessive data showing up in the reports.
• Configured Intelligence dashboards by including embedded content such as links/images & HTML objects.
• Upgraded Rpd, Web Catalogs from OBIEE 10.1.3.4.1 to OBIEE 11.1.1.6 using upgrade assistant utility (Oracle Fusion Middleware Upgrade Wizard).
• Utilized HP Quality Center tool for tracking issues which are raised by users post OBIEE 11g upgrade process and fixed them priority wise.
• Created Application Roles in Oracle Enterprise Manager 11g and set the permissions on dashboard pages using the application roles.
• Created pivot table requests allowing managers to analyze the business in different perspectives.
• Involved in performance tuning by setting Cache, limiting the number of initialization blocks, limiting select table types, pushing the calculation to the database.
• Provided end-user training and documentation and second-line support to power users to develop dashboards, reporting metrics and reports.

Environment: Oracle Business Intelligence Enterprise Edition (OBIEE) 11.1.1.6/ 10.1.3.4.1 , Linux, UNIX, Oracle 11g/10g, SQL, PL/SQL and TOAD.

Confidential -San Francisco, CA

Sr. BI Consultant

Responsibilities:

• Gathered user requirements to build reports.
• Modified Pre-built OBI Applications dashboards, Answers, Repository for Sales, Finance.
• Developed Analytics Metadata Repository (.rpd) using OBIEE by importing the required objects with integrity constraints into Physical Layer using connection pool, developed multiple Dimensions (Drill-Down Hierarchies), Logical objects in Business Model Layer, and created the Presentation catalogs in Presentation Layer.
• Designed and Tested Reports in theDashboardsfor theOracle Financial Analyticsmodules likeGL, AP, ARand created the Adhoc report according to the client needs.
• Developed many Reports with different Analytics Views (Drill-Down / Dynamic, Cascading Style Sheets, Pivot Table, Chart, Column Selector, Tabular with global and local Filters) using OBIEE.
• Customized Reports look and Feel using Column Formatting, Conditional formatting.
• Merged the changes to the original repository using the merge repository and import from repository features.
• Extensively used presentation variables to develop reports with complex logics.
• Designed and developed transformations, mappings and sessions in Informatica to load target database.
• Developed Custom SDE and SIL mappings to populate the data using different types of transformations.
• Developed Custom SDE and SIL mappings for Helper tables using the lookup transformation.
• Developed custom mappings to identify duplicate records for source data coming from flat files.
• Customized the Financial informatica mappings.
• Developed custom ETL mapping to control check on the GL code combinations and failing the execution plan for the data does not match.
• Configured DAC - Data warehouse Access control for running of ETL jobs
• Configured DAC on SOLARIS machine.
• Used DAC to schedule and run the Full and Incremental ETL loads and to schedule the Informatica jobs.
• Created catalog groups and set permissions for items in the presentation catalog and privileges and rights to users and groups.
• Implemented comprehensive security functionality by creating users & web groups.
• Enhanced performance by requesting Aggregate tables, Indexes and managing Cache after Benchmarking performance tuning strategies with business model-level calculations versus database level pre-computations and aggregations.
• Worked on performance tuning for the data load through DAC.
• Maintenance and support the OBIEE/Informatica/DAC for the production environment.
• Developed the mapping document to build the data ware house to match the user requirement.

Environment: Oracle Business Intelligence Enterprise Edition (OBIEE) 11.1.1.5.0 , BI App version - 7.9.6.3, BI Publisher 11g, Informatica Power Center server v9.0.1 Hot Fix? 2, DAC 10.1.3.4.1 (Data warehouse Administration Console), Windows 7, Linux, UNIX, Shell Scripting, Oracle R12.1.3,11g/10g, SQL, PL/SQL, and TOAD.

Confidential -Upper Marlboro, MD

Sr. OBIEE Consultant

Responsibilities:

• Worked closely with Business Analysts in understanding the Analytics requirements and created Business Models for generating Reports as per the requirements.
• Worked on Oracle BI EE Administration tool for customizing the Physical layer, Business layer, Presentation layer and modifying it according to the business requirements.
• Worked extensively onOBIEEAnswers and Dashboards to build the reports as per the client requirements.
• Experience inOracleDataIntegration Suite (OracleDataIntegrator(ODI) to Extract Load and Transform (E-L-T) for high performance and faster responsiveness.
• Configured Interactive Dashboard with drill-down capabilities using global and local Filters, Metadata Objects and Web Catalog Objects.
• Performed the detailed design of Reports / Dashboards and performed Gap Analysis between existing reports and new requirements.
• Developed custom reports/Ad-hoc queries using Oracle Answers and assigned them to application specific dashboards.
• Applied Cascading Prompts and Multi Level Prompts on Dashboards.
• Used Filters and provided Customized prompts appropriately to avoid excessive data showing up reports.
• Used view selector, column selector, is prompted, drill down- drill through analysis, creating master/detail reports, using database, numeric, date and time functions, etc., where ever necessary to increase performance.
• Created Session & Repository Variables to achieve desired functionality.
• Customized Reports look and Feel using Column Formatting, Conditional formatting.
• Configured and Scheduled BI Publisher scheduler for report bursting to File and email locations and used advanced reporting features such as Online Analyzer, Excel Analyzer and report security options.
• Build test cases and tested the Reports/Dashboards by comparing the SQL Output on the Data warehouse to the values in the Reports/Dashboards, documented the test results.

Environment: Oracle Business Intelligence Enterprise Edition (OBIEE) 10.1.3.4, BI Publisher, Windows XP, UNIX, Shell Scripting, Oracle 11g/10g, SQL, PL/SQL, and TOAD.

Confidential -Brea, CA

Sr. Report Developer

Responsibilities:

• Gathered requirements of the various work streams by meeting with the business user and base lining the details.
• Worked with data architects to translate business requirements into technical specifications and logical & physical data models.
• Created Repositories by building Physical Layer, Business Model and Mapping Layer, and Presentation Layer using OBIEE Admin Tool.
• Created Dimensional Hierarchies, Aggregations and Levels using admin tool in the Business Model and Mapping Layer.
• Used Filters (global and local) and provided customized Prompts to avoid excessive data showing up in the reports.
• Created pivot table requests allowing managers to analyze the business in different perspectives.
• 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.
• Created proactive agents iBots and interactive Dashboards to alert the Marketing team about business changes. Managed day-to-day rpd, Scheduler & iBots.
• Utilized Oracle Delivers for sending real-time, personalized alerts via intelligence agents (iBots) to subscribed users.
• Involved in performance tuning by enabling the cache to improve the query performance.
• Involved in preparing/executing Test scripts, establishing Test Data, and recording defects.
• Coordinated the OBIEE .rpd and Web Catalog objects migration from development environment to QA environment and then to the Production environment.
• Performed a POC on OBIEE 11g including installation on a sandbox Deployed folder which holds metadata using web logic console and generated Metadata Dictionary to the deployed folder.
• Created user and groups using web logic Administration Console.
• Created Roles and policies using web logic Enterprise Manager.

Environment: Oracle Business Intelligence Enterprise Edition (OBIEE) 10.1.3.4/11.1.1.3 , Oracle Delivers, BI Publisher, Windows XP, UNIX/LINUX, Shell Scripting, Oracle 11g/10g, SQL, PL/SQL, and TOAD 6.3/7.0.

Confidential -Morrisville, NC

Sr. OBIEE Consultant

Responsibilities:

• Worked closely with the business users to identify various KPI's and designed solutions to enhance business decision-making.
• Participated in complete life cycle of the project from project initiation, to development, to production support and maintenance.
• Created and Administered the Physical Layer, Business Model and Mapping Layer and Presentation Layer in Analytics Repository (.rpd) using Oracle BI Administration Tool.
• Created Dimensional Hierarchies, Aggregations and Levels using admin tool in the Business Model and Mapping Layer.
• Modified presentation layer dimensions and attributes to match user requirements.
• Developed custom reports/Ad-hoc queries using Oracle BI Answers and assigned them to application specific dashboard.
• Configured Intelligence dashboards by including embedded content such as links/images & HTML objects.
• Utilized Oracle Delivers for sending real-time, personalized alerts via intelligence agents (iBots) to subscribed users.
• Used the Security settings in Oracle BI Admin Tool to set up SSO, users, groups, access privileges and query privileges.
• Configured Informatica connections source DB connection and target DB connection in DAC.
• Used DAC to schedule and run the full incremental ETL loads and to schedule the informatica jobs in Oracle Business Analytic Warehouse.
• Developed Informatica mappings and mapplets to build key interfaces using transformations (Source Qualifier, Joiner, Update Strategy, Lookup, Rank, Expressions, and Aggregator) for loading the data from Oracle EBS source into data warehouse.
• Configured and Scheduled BI Publisher scheduler for report bursting to File and email locations and used advanced reporting features such as Online Analyzer, Excel Analyzer and report security options.
• Built custom analyze scripts for DAC to reduce the time for table analysis.
• Coordinated the OBIEE .rpd and Web Catalog objects migration from development environment to QA environment and then to the Production environment.
• Provided end-user training and documentation and second-line support to power users to develop dashboards, reporting metrics and reports.

Environment: Oracle Business Intelligence Enterprise Edition (OBIEE) 10.1.3.4, Informatica Power Center 8.1, Data Warehouse Administration Console (DAC), Oracle Delivers, BI Publisher, Windows XP, UNIX/LINUX, Oracle 11g/10g, SQL, PL/SQL, and TOAD 6.3/7.0.

Confidential -St Louis, MO

OBIEE Developer

Responsibilities:

• Worked on Oracle BI EE Administration tool for customizing the Physical layer, Business layer, Presentation layer and modifying it according to the business requirements.
• To create Connection pools, import physical tables and define joins in the Physical Layer.
• Developed and customized some of the existing Dimensions (Drill-Down Hierarchies) & Logical objects in Business Model Layer, and creating the Presentation catalogs in Presentation Layer.
• Created Global/Local Prompts, Narrative Views, Filters, Charts, Pivot Tables, Compound layouts to design the dashboards.
• Created Security settings in Oracle Administration Tool to set up groups, access privileges and query privileges and also managed security for groups in BI Answers.
• Developed Dashboards for each of metrics by embedding reports and providing intuitive drill-downs and links to exploit the full benefit of Analytics in providing summary and detail reports.
• Used OBIEE Delivers to automate iBot queries, obtain weekly reports and to send alerts to related managers and secured team members.
• Enhance performance of Reports/Dashboards by implementing the Aggregate tables, Table execution path by making use of hints, Creation/Re-building of Indices and Cache Management.
• Involved in developing the Incremental ETL process (Mappings & Mapplets) using various Transformation and Workflows with Sessions/Tasks, executed workflows through shell scripts using pmcmd.
• Created & saved several BI Publisher reports by selecting an Answers request as Data Source.
• Created comprehensive and easy-to-understand Documentation of the complete implementation of the Customer Sales Business modules (Reports, Dashboards, Security and Star schema.
• Build test cases and tested the Reports/Dashboards by comparing the SQL Output on the Data warehouse to the values in the Reports/Dashboards, documented the test results.

Environment: Oracle Business Intelligence Enterprise Edition (OBIEE) 10.1.3.2, Informatica Power Center 7.8.4, Oracle BI Publisher, Oracle Delivers, Windows XP, UNIX/LINUX Oracle10g, SQL, PL/SQL, and TOAD 6.3/7.0.

Confidential - Flint, MI

Siebel Analytics/Oracle BI Consultant

Responsibilities:

• Creating complex joins/keys, setting levels to support Drill-down, Aggregation/Sum over columns.
• Developed many Reports/Dashboards with different Analytics Views (Drill-Down & Drill-Across, Pivot Table, Chart, View Selector, and Column Selector, with global & local Filters using Oracle BI/Siebel Analytics Web.
• Extensively used Repository Variables, Session Variables and Initialization Blocks for Configuring the Data and user Security.
• Developed Accounting and Collection Time Series Object (Oracle BI Time-Series Functions) for comparing the Billings, Collections and Adjustments.
• Created Users, Groups and giving the permissions in Siebel Analytics Administration Tool and verifying the Permissions of the users in Siebel Analytics web.
• Tuned Reports and designed Query Caching and Data Caching for Performance Gains.
• Developed many complex Informatica mappings and mapplets to build key interfaces using reusable transformations (Source Qualifier, Lookup, etc.) for loading data into Data Warehouse.
• Peer review of code, testing, monitoring NQSQuery and tuning reports.
• Involved in building and migrating the metadata across DEV/ST environments.
• Used Informatica Power Center to develop ETL mappings, transformations, and to load data.
• Enforced Row Level Security for Managers to View the Reports pertaining to their Region.
• Used Informatica transformations like Normalizer, Expression, Filter, Aggregator, Update Strategy, Lookup, Joiner, etc. extensively to create complex mappings and mapplets.
• Performed Tuning of Dashboards/Reports by aggregate navigation, and cache management.
• Involved in preparing/executing Test scripts, establishing Test Data, and recording defects.

Environment: Siebel Analytics 7.8.2/ Oracle Business Intelligence 7.8.4, Informatica Power Center 7.7.1, Data Warehouse Administration Console (DAC), XML Publisher, Delivers, Windows XP, UNIX/Linux, Shell Scripting, Oracle 11g/10g, SQL, PL/SQL, and TOAD 6.3/7.0.

Confidential -Hartford, CT

Siebel Analytics Consultant

Responsibilities:

• Designed and Developed the Analytics repository (Physical Layer, Business Model and Mapping Layer and Presentation Layer).
• Developed many Reports / Dashboards with different Analytics Views (Pivot Table, Chart, Tabular, etc.) for performing the Marketing Trend analysis using Siebel Analytics Web.
• Developed Dimensional Hierarchies for Drill Down, Level Based Measures and Time Series Functions based on the Requirements.
• Designed & Added Customized Mappings to schedule the loads to run on weekly basis.
• Defined static and dynamic repository variables to modify metadata content dynamically to adjust to a changing data environment.
• Implemented dynamic dashboard prompts to zoom into particular segments of the business.
• Developed complex mappings by extensively using the Informatica transformations and flagging the records using the update strategy for populating the desired SCD tables.
• Used Workflow manager and Workflow monitor for Workflow, sessions and database connection management and workflow monitoring.
• Created Delivers and interactive Dashboards to alert the Marketing team about business changes. Managed day-to-day rpd, Scheduler & Delivers.
• Enhance performance of Reports/Dashboards by implementing the Aggregate tables, and Cache Management.
• Created & saved several XML Publisher reports by selecting an Answers request as Data Source.
• Managed Security privileges for each subject area & dashboards according to user requirements.
• Performed Pre/Post implementation testing of Dashboard, Answers and validating Repository.

Environment: Siebel Analytics 7.1.3, XML Publisher, Delivers, Windows XP, UNIX/LINUX, Oracle10g, SQL, PL/SQL.