SUMMARY

• Over 8 years of IT experience in Data Warehousing, Business Intelligence and Analytics, Data and Systems Analysis, Project Coordination across various domains.
• Over 6 years of experience in Dashboard and Reports design, Development, Tuning and Leading Developmental Effort for various Business Intelligence Applications using OBIEE+.
• Extensive knowledge in configuring Interactive Dashboards with drill - down capabilities, Security Setup (groups/access privileges), Metadata, Web Catalog Objects (Folders, Dashboard, Pages and Reports).
• Expert in configuring and managing OBI Server, Oracle BI Answers and Dashboards; iBots, Publisher, OBIEE plug-ins, BI Publisher and configuration of Analytics Metadata objects.
• Expertise in development of Reports / Dashboards with different Analytics Views (HTML/Dynamic, CSS, Pivot Table, Chart, Column Selector, Tabular with global and local Filters) using Siebel Analytics Web.
• Knowledge in dealing with various OBIEE functionalities like Dashboard prompts, views, aggregates, global filters, scheduling, contextual/guided navigation, conditional formatting of reports to satisfy the end users.
• Hands on Experience developing with BI Development in Physical, Business Model and Presentation Layers. Expertise with BMM development - Dimensions, Hierarchies, Measures, Aggregation Rules, Time Series, Cache Management.
• Sound understanding of various aspects of ETL Development in various platforms like Informatica/Data Stage
• Experience with Conceptual, Logical and Physical Data Modeling. Experience creating and maintaining Data Dictionaries/Metadata Repositories.
• Excellent Business Analysis Skills. Expertise creating High Level Requirements Document, Technical Specifications Document. Experience creating and managing Requirements Traceability Matrix.
• Experience gathering requirements from both Business and Technical Users. Experience writing use cases and test cases.
• Experience in Oracle BI Apps that include OBIEE/Siebel Analytics, ETL Tools and DAC in HR, Sales & Marketing domains.
• Experience with SQL tuning, writing complex SQL queries, triggers and stored procedures. Hands on exposure in the RDBMS development with Oracle 9/10/11.Involved in Unit Testing, Integration Testing and User Acceptance Testing.
• Well acquainted with Software Development Life Cycle. Excellent team player with problem-solving and trouble-shooting capabilities.
• Excellent written and spoken communication skills

TECHNICAL SKILLS

BI Tools: OBIEE 11g, OBIEE 10.1.3.4/3.3/3.2 , Siebel Analytics 7.5/7.7/7.8

Data Warehousing: Informatica Power Center 8.1.1/8.0, Workflow Manager, Workflow Monitor, Power Mart

Languages: SQL, PL/SQL, UNIX Shell

DB Tools: Erwin, Toad, Oracle Applications/ EBS, SQL Plus

Databases: MS SQL Server 2008/2005, Oracle 10g/9i, MS Access, Teradata, DB2, UDB

Environment: Win Server 2008/2005,Win NT, Win XP, Unix, LINUX

ERP Systems: EBS R12.1.13

PROFESSIONAL EXPERIENCE

Confidential, TX

OBIEE Architect /Developer

Responsibilities:

• Worked with Business Users and Stake Holders for Requirement Gathering.
• Responsible for formulating the OBIEE development standards, best practices and guidelines
• Lead the complete life-cycle management for the issues in Production and implementation of the project
• Code review of the development work done by all the development teams.
• Managed and monitored the work items delegated to team members to ensure timely deliverables.
• Created OBIEE Server architecture design for Development, Test and Production environments.
• Defined security matrix for OBIEE data and object level security.
• Documented the technical specifications for reporting requirements.
• Modelling Dashboards and Design Strategy for representation in various views such graphical presentation, pivot table and view selector.
• Involved in installing OBIEE 12c and upgrading code from 11g to 12c.
• Coordinate project activities across various stakeholders and project sponsors.

Environment: OBIEE 11.1.1.9 and OBIEE 12c, ODI, Oracle 11g, JDE, WinCVS 2.0, WinSCP 5.2, Windows XP and UNIX.

Confidential, TX

Lead OBIEE Consultant

Responsibilities:

• Lead the efforts of documenting the training material for BI End User Trainings and provided user trainings
• Lead the complete life-cycle management for the issues in Production and implementation of the project
• Lead the Daily status calls for Production Support.
• Managed and monitored the work items delegated to team members to ensure timely deliverables.
• Created OBIEE Server architecture diagrams for Development, Test and Production environments.
• Defined and developed the User roles and Privileges Matrix for Production environment.
• Documented the environment details and access information for various BI servers
• Worked on Oracle Managed Cloud Services for the OBIEE Implementation
• Participated in Code Review during the implementation and support activities.
• Worked with business users for gathering requirements during production support.
• Provided after hours and weekend support for the BI before and after Go-Live
• Worked with OMCS for troubleshooting, Performance monitoring and tuning
• Worked with End users to understand their need and provided solutions. Conducted meetings with end users to demonstrate OBIEE functionality.
• Developed the reports for the new change requests using BI Answers.
• Implemented EBS to BI single sign-on to access BI reports from EBS.
• Worked to resolve DAC failures while running the data loads to the data warehouse.
• Worked with Financial, HR, Projects and Procurement/Spend Analytics reporting.
• Performed automated migration of RPD, Catalog, Informatica and DAC Code using Kintana and WinCVS.
• Implemented Usage Tracking for monitoring and auditing purposes

Environment: OBIEE 11.1.1.6.12 , OBIA 7.9.6.3, Informatica 9.0.1, DAC 10.1.3.4.1 , Oracle 11g, Oracle EBS R12, WinCVS 2.0, WinSCP 5.2, HPQC ALM Quality Center, Windows XP and UNIX.

Confidential, PA

Lead OBIEE Developer

Responsibilities:

• Created Repository and OBIEE reports for Enrollment, Claims, Customer Service and Routes
• Worked on the OBIEE Dashboards and reports based on the requirements and specifications given by Business analysts.
• Involved in Business Model Design and development for Enterprise Data Warehouse.
• Importing Data from various sources like SQL DB, Text Files, Excel Files and other flat files.
• Designed Star schema for fact & dimensional tables and created alias for the dimensional tables when necessary.
• Defined the Foreign keys and Complex joins between various Dimension and Fact Tables at BMM layer.
• Installed and Configured OBIEE 11.1.1.5 on Win Server 2008 and configured for SQL Server 2008 as Data Warehouse
• Integrated Windows Active Directory authentication LDAP with OBIEE including the security levels at group level.
• Modeled the Logical Layer based on the Business requirements in the Business Mapping and Modeling Layer and Developed the necessary Star Schemas.
• Implemented the OBIEE upgrade process from OBIEE 10.1.3.4 to OBIEE 11g for better support for real time decisions
• Developed a Roadmap for the Client Dashboard and work with Client Partner to deploy a beta dashboard
• Created Aggregates, Hierarchies, Calculation wizard in the Logical Layer.
• Worked for performance tuning by finding out the bottlenecks in Reports
• Involved in Migration in Development, Testing and Production environment. Provided End User Training and documentation for DWH-BI Project.
• Developed security matrix for dashboards/Answers users based on Individual responsibilities and LDAP Authentication type.
• Customized/Created presentation layer catalog folders, to show different views of the business model to different users and assigned group permissions to the catalog folders.
• Worked with BI Office plug-in to export analysis to Excel format.
• Implemented Usage Tracking for better administration and auditing purposes.
• Worked with BI Publisher 11g for document composition and delivery.

Environment: OBIEE 10g, OBIEE 11g, XHTML, OBIEE+, Windows Server 2008, Informatica 8.6.1, Weblogic Server, CSS, JavaScript, PL/SQL

Confidential, NJ

Sr. OBIEE Developer

Responsibilities:

• Installing and Configuring OBIEE 10.1.3.4. Including the security levels at group level.
• Worked on the OBIEE Dashboards and reports based on the requirements and specifications given by Business analysts.
• Implemented Physical Meta Data from Various Data sources into the Physical Layer by defining the connection pool settings
• Designed Star schema for fact & dimensional tables and created alias for the dimensional tables when necessary.
• Defined the Foreign keys and Complex joins between various Dimension and Fact Tables at BMM layer.
• Modeled the Logical Layer based on the Business requirements in the Business Mapping and Modeling Layer and Developed the necessary Star Schemas.
• Worked with HTML, CSS and JavaScript to customize the dashboard look and feel.
• Worked on various Oracle Business Intelligence application modules (BI Apps).
• Created Aggregates, Hierarchies, Calculation wizard in the Logical Layer.
• Worked on the Time Series Wizard and implemented time comparison measures.
• Extensively worked on global filters for use in exercising dashboard wide control over requests that are embedded into a dashboard page.
• Created complex reports by using Set operations and direct database request.
• Worked on the Time Series Wizard and implemented time comparison measures.
• Used Column Filter Prompts and provided Dashboard Prompts appropriately to avoid excessive data showing up Reports. Customized reports with CSS, JavaScript as needed.
• Worked for performance tuning by finding out the bottlenecks in Reports.
• Involved in Migration in Development, Testing and Production environment
• Involved in Unit/Integration testing and documentation.
• Developed security matrix for dashboards/Answers users based on Individual responsibilities and LDAP Authentication type.
• Customized/Created presentation layer catalog folders, to show different views of the business model to different users and assigned group permissions to the catalog folders.
• Worked with BI Office plug-in to export analysis to Excel format.

Environment: OBIEE 10g, XHTML, Oracle BI Applications, OBIEE+, Windows Server 2008, Informatica 7.1, BI Apps, Siebel Analytics 7.8, OC4J Server, CSS, JavaScript, PL/SQL

Confidential, Edison, NJ

OBIEE Developer

Responsibilities:

• Designed, implemented and Customized Metadata and Dashboards/Reports using the Oracle BI Analytics platform (OBIEE+).
• Imported Schema from Data warehouse and created OBIEE. Designed Dimensional Hierarchies, Aggregate Navigation as per requirements.
• Implemented Dashboards and reports using Level Based Measures, Security Management
• Implemented OBIEE delivers, created Proactive agents and configured Interactive dashboards to alert the Business users as per the requirements.
• Created various custom requirements for BI apps for GL, HR, and AP etc.
• Worked on security for users and groups based on the individual and group responsibilities.
• Worked on Analytics Web Catalog to set up groups, access privileges and query privileges.
• Designed templates and created reports using BI Publisher. Developed dimensional hierarchies based on the business requirement of an attribute.
• Worked on Aggregates, Hierarchies, Calculation wizard in the Logical Layer.
• Used and configured iBots alerts for reports to be delivered by email.
• Created custom Ad-hoc queries using Seibel Answers and assigned them to dashboards and reports
• Maintaining the Full and Incremental loads through DAC on different environments like Development and Test environment.
• Involved in extracting data from Transaction System (OLTP) into Staging Area and Identifying Facts and Dimensions tables.
• Worked in Performance Tuning at sources, targets and sessions performance of data load and queries.
• Used Analytics Web Catalog to set up groups, access privileges and query privileges.
• Designing mapping templates to specify high level approach. Designed and developed UNIX scripts for creating, dropping tables used for scheduling the jobs.
• Designed and Developed PL/SQL Procedures and UNIX Shell Scripts, Data Import/Export and Conversions. Created Test Cases and Test Scripts. Involved in Unit testing and documentation.

Environment: OBIEE 10.1.3.2, Siebel Analytics 7.8.5, Informatica Power Center 7.1, Erwin, Oracle 10g, Oracle R12 TOAD, DAC, MS SQL Server 2005, UNIX, Oracle SQL, BI Publisher, LINUX, Oracle Apps

Confidential, VA

OBIEE Developer

Responsibilities:

• Involved in Migration of Analytics Application in Dev, Test and UAT Environments.
• Defined Connection pool settings and imported the Physical Meta Data from Various Data marts into the Physical Layer for Call Center Subject Area.
• Worked on Aggregates, Hierarchies, Calculation wizard in the Logical Layer.
• Created Simple and Complex joins in various OBIEE Layers in addition to defined the Primary, Foreign keys. Worked on the Time Series Wizard and implemented time comparison measures.
• Used Column Filter Prompts and provided Dashboard Prompts appropriately to avoid excessive data showing up Reports.
• Managed security privileges for each subject areas and dashboards according to user requirements.
• Customized/Created presentation layer catalog folders, to show different views of the business model to different users and assigned group permissions to the catalog folders.
• Created various narrative views, pivot views, chart views of the data returned by the request.
• Embedded content such as links/images and HTML objects to create Intelligence dashboards.
• Implemented drill-down, guided navigation and Dashboard prompts in making interactive and effective dashboards and reports
• Used the Catalog manager and maintained the Analytics web catalog to manage Dashboards, Answers.

Environment: OBIEE 10.1.3.2, Siebel Call Center, Siebel Tools, DB2, Informatica 7.1, PeopleSoft, Oracle 9i, Windows 2k

Confidential, FL

Siebel Analytics Developer

Responsibilities:

• Involved in migration and upgrading from Siebel Analytics to OBIEE. Extensively used upgrade tools in the process.
• Worked with Informatica for transformation and mapping in ETL process.
• Designed and developed project document templates based on SDLC methodology.
• Designed and developed all Use Cases.
• Helped the testing team documenting the system requirements and testing system development
• Designed and implemented basic SQL queries for QA testing and report / data validation.
• Set up definitions and process for test phases including Product test, integration test, system test and user acceptance test (UAT).
• As necessary, assisted with the process of identifying and recommending vendors and assisted with the vendor relationships.
• Biweekly status reporting with other team project managers involved in this project.

Environment: Siebel Analytics, OBIEE 10.*, Informatica 7.1.4, Oracle 9i (SQL, PL/SQL), UNIX, Windows XP