SUMMARY:

• Over 8+ years of work experience in the IT, acquiring both technical and functional skills and 5 years’ experience in Business Intelligence projects that span the fulllife cycle implementation ofOracleBusinessIntelligence(Siebel Analytics),InformaticaandData Warehousing.
• Experience working with OBIEE 10.1.3.x/Siebel Analytics/OBI Applications 7.9.6.3 in development of metadata repository using OBIEE Administration tool, Intelligent Dashboards, Answers, Delivers, iBotsand Oracle BI Publisher
• Experience working with various domains like Supply chain Module, Financial, Marketing and OrderManagement Analytics.
• Experience configuring Interactive Dashboards with drill - down capabilities using global and local Filters, OBI/Siebel Security Setup (groups, access/query privileges), Metadata objects and Web Catalog Objects (Dashboard, Pages, Folders, Reports).
• Experience in creating aggregate tables, table partitions, indexes and cache management.
• Extensive experience in Security Setup at both Object and Data levels, LDAP authenticationsetup and configuration of Multiuser Development Environment (MUDE).
• Expertise in design and development of Oracle BI Metadata Repository (.rpd) using OBI/Siebel Analytics Server Admin Tool Repository at all the three layers (Physical Layer, Business Model and Mapping Layer & Presentation Layer).
• Experienced in Full Systems Development Life-Cycle Implementation of Various Oracle/ETL /OBIEE Projects.
• Configure the BI Publisher scheduler to schedule reports and view the saved data.
• Experience in OBIEE features (i.e. Cache, Usage tracking, Dimensional hierarchy, Aggregate navigation, Variables/Initialization Blocks configuration etc.), converting Snow-Flake Schema to Star Schema, Dim Hierarchies, Dim Extensions, Physical & Logical Data Modeling
• Experience in utilizing ETL tools for data loads, database integration/conversions, including SQL Server Integration Services (SSIS), Data Transformation Services (DTS).
• Experience with Report Builder which is fully integrated with SQL Server Reporting Services (SSRS) and delivers ad hoc reporting support.
• Experience in Data Warehouse Modeling with SQL Server Analysis Service (SSAS).
• Good experience and understanding of database design, relational integrity constraints, OLAP, OLTP, Cubes and normalizations.
• Expertise in Scripting T-SQL Queries, Complex Stored Procedures, and User defined functions and Indexes.
• Experience in Creating SSIS Packages to automate the Import and Export Wizard of data to and from SQL Server 2005.
• Experience in enhancing and deploying the SSIS Packages from development server to production server, creating SSIS packages.
• Expert in building various DTS packages with ActiveX scripting for transferred data modifications and migrated various DTS 2000 packages to SSIS packages.
• Knowledge of developing ETL routines to integrate data from disparate data sources including relational databases, flat files, office documents, OLE DB Source, Excel Spreadsheets.
• Thorough Knowledge of various SSIS Objects such as Dataflow Components, Control Flow Elements, Connection Managers, Runtime Events, Log Providers etc.
• Strong Experience in Creating, Configuring, Deploying and Testing SSIS Packages.
• Expertise in Debugging, Error logging, Error Handling and Production support for SSIS.
• Experience in Performance Tuning in SSIS.
• Good understanding and designing of Star and Snow Flake data models Schema used in relational, dimensional and multidimensional data modeling.
• Performed Unit testing, System Integration Testing and Load testing based on the test scripts provided.
• Extensively worked with design of multidimensional models like Star and Snowflake schemas in the OBIEE repository Administration tool.
• Good at understanding businessrequirementsand translating them intodata warehousedimensional modeling.
• Hands on experience in writing Oracle PL/SQL Stored Procedures, Table Partitions, triggers, Materialized Views, SQL queries, Fine tuning the code.
• Experience working with various databases Oracle 8i/9i/10g, DB2, MS Access 97/2000 and have good SQL, PL/SQL querying skills using SQL Loader, TOAD.
• Expertise in analyzing businessissuesand providing possible reportingsolutionsto end users.
• Expertise in providing end-to-end user trainingandsupportand provided detaildocumentation.
• Enthusiastic and motivating team player, with ability to perform individually. Excellent communication and interpersonal skills.

TECHNICAL SKILLS:

OBIEE/OBIA: -Administration, Installation, Reports development, Repository (RPD) development, BI Publisher, data warehouse development (10g, 11g & Siebel Analytics 7.x) BIApps7.9.6.1, 7.9.6.3, 7.9.6.4

ETL: Informatica 6/7/8/9,OWB, DAC

Operating Systems: Windows Family, Linux, MS-DOS,UNIX(HP,Sun Solaris)

Programming Languages: SQL, PL/SQL, XML, Java,C,C++

Scripting: JavaScript,eScript,VB Script,Shell Script

RDBMS: Oracle 11g/10g/9i/8i, MS Access, SQL Server 7.x, 2000

Data Migration: SQL Loader, MS DTS, Service Now, PPM (Project and Portfolio Management Center)

Defect Tracking: HPALM,Bug zilla

PROFESSIONAL EXPERIENCE:

Confidential, Jefferson City, MO

OBIEE Sr. Developer/Admin

Responsibilities:

• Effectively interacted with the end users for requirement gathering and defined requirement specifications document
• Installed, Configured and developed BI Apps Financials, Supply Chain, Procurement and Spend, HR modules.
• Worked extensively with Physical Layer, Business Layer and Presentation Layer.
• Created numerous executive level reports. 'Dashboards' were generated to provide insight into the financial data.
• Designed Schema/Diagrams using Fact, Dimensions, Physical, Logical, Alias and Extension tables.
• Created different types of Customized Reports Drilldown, Aggregation to meet client requirements.
• Built Business model and established relationships & Foreign Keys Physical & Logical between tables.
• Created business reports using BI Answers as per requirements.
• Generated various Analytics Reports using global and local filters.
• Identified the aggregate levels for each source and created dimension sources for each level of aggregates.
• Added users and configured security in web logic console of OBIEE 11g.
• Managed security privileges for each subject area and dashboards according to user requirements
• Setting up LDAP authentication to enable Single Sign on for Users in Development environment leveraging Analytics Repository.
• Used Informatica Mapping Designer to create/update mapping using different transformations required to move data into data warehouse.
• 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.
• Monitoring Incremental & Full load through DAC.
• Trained End Users and Pilot Users about OBIEE Tools.
• Responsible for installing, configuring, developing, support and maintenance of the BI APPS.

Environment: OBIEE 11g, BI Apps 7.9.6.3, Web Logic Server, Informatica 9.0.1, Oracle 11.2.0.2, SQL, PL/SQL, DAC 7.8.4, TOAD, SQL* Plus, Unix, Windows XP.

Confidential, Glendale, CA

OBIEE Consultant

Responsibilities:

• Involved in Perform analysis, Development, Configuration, Customization, Validation and Deployment for OBIEE
• Developed OBIEE Repository as per user requirements and available information in Data Warehouse.
• Involved in Installation and configuration of Oracle BI on Windows.
• Analyzed and validated the business model in OBIEE Administration Tool by performing consistency check, validating logical source tables, logical columns, and also validating repository level calculations done in the business model layer.
• Different levels of Security set-up for the entities of the application (on both Repository file and Web catalog file).
• Developed Interactive Dashboards and Reports relating to Customer Feedback Analytics, with different Analytic Views (Guided Navigation, Pivot Table, Chart, View Selector, Column Selector, Filters, and Dashboard Prompts) using Presentation Services.
• Created dimension hierarchies, aggregates and keys in the BMM layer.
• Worked closely with data modelers on Erwin tool for dimensional modeling (Star schema).
• Integrated BI Publisher with OBIEE. Created Templates such as Employee Account Attendance Detail, Reports such as Turn Over/Period/Department, and Prompts such as Customer Name in BI Publisher.
• Schedule reports and bursting as per the requirement in BI Publisher and represented them in OBIEE dashboards.
• Responsible for formulating the OBIEE development standards, best practices and guidelines
• Implemented Guided Navigation to let users see only relevant reports based on different business scenarios.
• Implemented Automatic cache clearing for every 6 hrs by running a java script through Ibots.
• Analyzed data accuracy/integrity and identify necessary actions to enhance accuracy/integrity of data
• Expertise in fine tuning reports by using View Selector, Column Selector, is prompted, where ever necessary to increase performance
• Created different types of variables at RPD level and implemented initialization blocks for that.
• Design and build reports, data interfaces from BRD, data marts from information and data models and develop, test Oracle BI & Informatica DW applications, including star schema data structures and extraction, transformation and load (ETL) processes.
• Administered 11g environment using WebLogic server
• Involved in developing the Deployment Strategy for Deployment of Source Code between the Various Repositories (Dev., QA and Prod).
• Implemented Object Level Security for the objects like Dashboards, Reports, and Data Level Security for Region and Product dimensions using Session Variables.
• Used java script to customize the dashboard look and feel.
• OBIEE meta-data development. Configure repository on all the three layers (Physical Layer, Business Logic, Mapping Layer and Presentation Layer).
• Data Model Design and Documentation (Facts and Dimensions, Business Users & Security Permissions, Stars with Hierarchies, Business Model Names for Source Columns, Reports and Dashboard Layouts).
• OBIEE meta-data development. Configured repository on all the three layers (Physical Layer, Business Logic and Mapping Layer and Presentation Layer).
• Involved in migration for OBIEE components into various test, UAT and production environments.

Environment: OBIEE 11.1.1.5/6, Tableau 7.0/8.0, BI Publisher, Informatica 8.6, DAC, Oracle 10g, Pl/SQL

Confidential, Rochester, MN

OBIEE Developer

Responsibilities:

• Created Various BI Publisher Reports on top of BI Answers and aligned them on various Dashboards as per the requirement.
• Created guided navigation links within Interactive Dashboards.
• Used Oracle Business Intelligence Delivers to configure, schedule, and deliver personalized alerts to Interactive Dashboards by using iBots.
• Performed administrative tasks related to the development and configuration of Interactive Dashboards.
• Customized the Oracle Business Intelligence Presentation Services interface.
• Interacted with Client Services Management business representatives for gathering the Reports / Dashboards requirements and to define business and functional specifications.
• Worked on MS Office Plug-in.
• Data Model Design and Documentation (Facts and Dimensions, Business Users & Security Permissions, Stars with Hierarchies, Business Model Names for Source Columns, Reports and Dashboard Layouts).
• OBIEE meta-data development. Configure repository on all the three layers (Physical Layer, Business Logic and Mapping Layer and Presentation Layer).
• Designed the Security management for users, groups and web-groups using the various authentication systems Database and Database table authentication using Session Variable features, as well as Dashboard / Report-level security. Created iBots and Delivers to send Alert messages to subscribed users.
• Administered 11g environment using WebLogic like RPD deployments and creating the custom users and groups in the WebLogic console and em.
• 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
• Used DAC (Data Warehouse Administration Console) Client to manage, configure, customize and monitor ETL process
• Worked on Different levels of Security set-up for the entities of the application (on both Repository file and Web catalog file).
• Developed and Debugged Interactive Dashboards and Reports relating to Customer Feedback Analytics, with different Analytic Views (Guided Navigation, Pivot Table, Chart, View Selector, Column Selector, Filters, and Dashboard Prompts) using Presentation Services.
• Implemented Object Level Security for the objects like Dashboards and Reports, and Data Level Security for Region and Product dimensions, using Session Variables.
• Developed Performance Tuning Strategies, for optimized performance, by implementing Aggregate Navigation, Cache Management, re-organizing data, and making some changes to Reports.
• Developed and Integration Testing, and User Acceptance Testing (UAT), to validate reports, and played an active role in product rollouts.
• Created comprehensive and easy-to-understand Oracle Answers & Dashboards User Guide, and provided intensive Training to business users and Implemented Usage Tracking Reports.

Environment: OBIEE 10.1.3.4.1, OBIEE 11g, Tableau 6.0, BI Publisher, Informatica 8.6, DAC, Oracle 10g.

Confidential, Rockville, MD

OBIEE Sr. Consultant

Responsibilities:

• Effectively interacted with the end users for requirement gathering and defined requirement specifications document by access and retrieval of financial and personnel data from one single source.
• Identified & Created Facts, Dimensions, and Hierarchies of the business model.
• Developed Segment Value Detail, Work Order Detail and OGA Repositories (RPD) by importing metadata into Physical Layer, applied Business rules in the Business Modeling and Mapping layer and created customized user views in the Presentation layer.
• Created Catalog Groups and set permissions for items in the presentation catalog and privileges and rights to users and groups.
• Designed and Tested Reports in the Dashboards for the Oracle Financial Analytics modules like GL, AP, AR and created the Ad-hoc report according to the client needs.
• Configured Interactive Dashboard with drill-down capabilities using global and local Filters, Metadata Objects and Web Catalog Objects.
• Applied Cascading Prompts and Multi Level Prompts on Dashboards.
• Identified issues, performance bottlenecks, and optimized the Business Intelligence Dashboards and Reports.
• Developed different kinds of reports (pivots, charts, tabular) using global and local Filters.
• Wrote Custom SQL Codes for the reports.
• Applied Optimization Techniques for the better performance of the reports.
• Involved in Monitoring and Scheduling different process flows using Oracle Work Flow Manager.
• Used external tables to Transform and Load data from Flat files into target tables.
• Used Debugger to validate Mappings by creating break points to analyze and monitor Data flow.
• Involved in troubleshooting the load failure cases, including database problems.
• Implemented Security by authenticating against the LDAP and external table.
• Trained End Users and Pilot Users about OBIEE Tools.

Environment: OBIEE 10.1.3.3, Oracle BI Applications 7.9.4(Financial analytics, HR analytics), Informatica 8, DAC, Oracle 10g, Oracle EBS, SQL Developer, SQL*Plus, Windows-XP

Confidential, Bay Area, CA

OBIEE Developer

Responsibilities:

• Interacted with corresponding area's Subject Matter Experts (SME), Stake Holders, Business Analysts and Key Business Users in gathering the Analytics / Reports Requirements.
• Created detailed Functional Specifications Documents, including data samples key project assumptions, report samples, data flows, and data models.
• Estimate and provide project time line on the deliverables and co-ordinate the project Coordinated activities onsite & offshore towards meeting project timelines.
• Developed Metadata repository (.rpd) that consists of Physical, BMM and Presentation layer, Security, test and validate the business model & repository level calculations using Oracle BI Administration tool.
• Developed and debugged many Dashboards / Reports using different Analytics Views (Pivot Table, Chart, View Selector and Column Selector), Dynamic / Interactive Dashboards with drill-down capabilities, guided navigation, charts, tabular using global and local Filters.
• Created the user accounts, granting the access/privileges.
• Improved Analytics Response-time by Performance management using optimization efforts such as implementing the aggregate tables and reports changes.
• Developed/Bench-Marked performance tuning strategies with business model-level calculations versus Data warehouse level pre-computations and aggregations.
• Performed the Reconciliation Process (Oracle BI Reports output with Java based Reports).
• 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.
• Involved in implementing the initial phase of prepackaged HR Analytics with the core HR data.
• Made presentations to the management and end users during various phases of Software Development Life Cycle (SDLC).

Environment: OBIEE 10.1.3.4,Oracle Applications R12, XML/BI Publisher 5.6.3, SQL*PLUS, SQL*Loader, TOAD.

Confidential

Siebel Analytics Technical Consultant

Responsibilities:

• Upgraded and migrated Siebel Analytics repository (.rpd) database from Siebel Analytics7.8.2 to Siebel Analytics 7.8.4
• Created and modify Business Intelligence requests using Oracle Business Intelligence Answers.
• Created and modify Interactive Dashboards.
• Created guided navigation links within Interactive Dashboards.
• Used Oracle Business Intelligence Delivers to configure, schedule, and deliver personalized alerts to Interactive Dashboards by using iBots.
• Performed administrative tasks related to the development and configuration of Interactive Dashboards.
• Customized the Oracle Business Intelligence Presentation Services interface.
• Interacted with Client Services Management business representatives for gathering the Reports / Dashboards requirements and to define business and functional specifications.
• Worked on MS Office Plug-in.
• Data Model Design and Documentation (Facts and Dimensions, Business Users & Security Permissions, Stars with Hierarchies, Business Model Names for Source Columns, Reports and Dashboard Layouts).
• OBIEE meta-data development. Configure repository on all the three layers (Physical Layer, Business Logic and Mapping Layer and Presentation Layer).
• Configured LDAP / Single Sign-on / in OBIEE.
• Set up Usage tracking and Scheduler in OBIEE.
• Worked on Different levels of Security set-up for the entities of the application (on both Repository file and Web catalog file).
• Developed and Debugged Interactive Dashboards and Reports relating to Customer Feedback Analytics, with different Analytic Views (Guided Navigation, Pivot Table, Chart, View Selector, Column Selector, Filters, and Dashboard Prompts) using Presentation Services.
• Implemented Object Level Security for the objects like Dashboards and Reports, and Data Level Security for Region and Product dimensions, using Session Variables.
• Developed Performance Tuning Strategies, for optimized performance, by implementing Aggregate Navigation, Cache Management, re-organizing data, and making some changes to Reports.
• Developed and Integration Testing, and User Acceptance Testing (UAT), to validate reports, and played an active role in product rollouts.
• Created comprehensive and easy-to-understand Oracle Answers & Dashboards User Guide, and provided intensive Training to business users and Implemented Usage Tracking Reports.

Environment: OBIEE 10.1.3.2(Siebel Analytics Applications), Siebel Analytics 7.7.4, Informatica 7.x BI Publisher, Toad, Oracle 9i, Windows XP.