SUMMARY

• A seasoned professional with 8 years of experience in full life cycle of business intelligence projects including Analysis, Design, Development, Testing, Deployment, Maintenance / Supports and Reporting using Analytics and OBIEE.
• Extensive experience in gathering and analyzing requirements, Gap Analysis, Scope Definition, Business Process Improvements, Project Tracking, Risk Analysis, and Change Control Management.
• Expertise in providing end to end BI solution by configuring metadata and building Analytics Repository, dimensional modeling design, building business models, generating reports and creating dashboards.
• Experience with OBIEE installation and administration, Dashboards developments, Reporting, and Meta - Data (RPD) Modeling.
• Experience in BI solutions for Financial, Diagnostic, Power & water, Oil & Gas, Aviation, transportation and Banking industries for various business processes.
• Experience in gathering business requirements, documenting the reporting and analysis specifications, designing technical architecture, installing and configuring all components of OBIEE.
• Good understanding in Authentication and Authorization of OBIEE by using LDAP, Database authentication, External Authentication and Single Sign on (SSO).
• Expertise in implementing Security Models for Dashboards, Row level, Object Level, and Role Level.
• Expertise in converting Functional specs to Technical Specs and implementing OBIEE Best practices.
• Expertise in configuring Interactive Dashboards with drill-drown capabilities using global and local filters, Security setup (groups, access/query privileges), metadata objects and web catalog objects (Dashboard, Pages, Folders, Reports).
• Experience in Installation, Configuration, Upgrade, Migration and Administration of OBIEE.
• Experience in Unit Testing, System Testing, Integration Testing and data validation. Experienced in troubleshooting production issues and production support for projects.
• Extensive experience in working with RDBMS like Oracle.
• Experience in creating SQL, PL/SQL, and Stored Procedures/Packages/Triggers/Cursors.
• Solid understanding of Data Warehouse Concepts, ETL, OLAP, OLTP, Star Schema, Data Modeling using Normalization, and Business Process Analysis.
• Experience configuring Interactive Dashboards with drill-down capabilities using global and local Filters.
• Well versed with onshore & offshore implementation and support models.
• Excellent analytical, problem solving, decision-making and presentation skills with ability to co-ordinate activities in a fast paced team environment.
• Possess strong leadership and successful team building capabilities and excellent technical, communication, presentation and customer service skills.
• 6 Sigma certified and Oracle Certified on SQL and PL/SQL.

TECHNICAL SKILLS

BI/Reporting tools: OBIEE, BI Publisher, Siebel Analytics

Data Modeling/ETL/Scheduling Tool: Informatica Power center

Language: C, C++, Java, HTML, VB Script, sql, pl/sql

Database: Oracle, SQL Server, Essbase

Database Tools: SQL*Plus, SQL * Loader, SQL Navigator, TOAD

Change Management Tools: Clear Case, Clear Quest, ALM, QualityCenter, JIRA

Operating Systems: Windows XP/2000/2003/NT, UNIX, LINUX

Oracle EPM/Hyperion: Hyperion Shared Services

Emulation: Putty, Telnet and windows terminal server

Third Party tools/Systems: AventX, Optio, Loftware

PROJECT SUMMARY:

Confidential

Sr. OBIEE Developer

RESPONSIBILITIES:

• Work closely with functional, marketing, sales, finance, and other business groups to identify, analyze business requirements.
• Develop detail technical requirement based on business requirements.
• Install and Configure OBIEE for BI Apps for different subject areas.
• Integrate OBIEE with LDAP for Authentication and configured SSL.
• Involve in several administrative roles including setting up users and roles and permissions, managing catalogs.
• Create several dimensional hierarchies.
• Write several initialization blocks, repository variables, session variables and presentation variables and request variables.
• Install and Configured BI Apps Repositories (Informatica, DAC) for loading data into BI DW.
• Use Stack Chart, Bar Chart, view selectors, Column Selectors, static text, narrative views, guided navigations, and links for several summary and detailed dashboards.
• Provide dynamic cascading prompts as per client’s new requirements on organizational hierarchy.
• Work in End to End construction of the BI model from repository to reports development
• Enable Usage Tracking to monitor the usage and performance of reports.
• Manage/Administered OBIEE web catalog using Catalog Manager
• Configure drill downs for various types of Hierarchies.
• Create new Repository Variables, Session variables and Initialization blocks to configure security, data access and authorization on Repository and Catalog objects.
• Configure the connection pool settings according to the requirements
• Created Answers reports using various analytics views like Table, Pivot tables, Charts, Column Selectors, View Selectors, Narrative, and Static text.
• Created new Dashboards according to best practices by using Columns, Sections and Guided Navigation
• Was involved in Unit, Integration and System testing and performed data validation for the reports generated using Informatica and OBIEE
• 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.
• Managed security privileges for each subject area and dashboards according to user requirements
• Setting up LDAP authentication to enable SingleSign on for Users in Development environment leveraging Analytics Repository.

ENVIRONMENT: Oracle BI Apps 7.9.6, Oracle BI Publisher 10g, OBIEE 10g/11g, Oracle, XML, Procurement and Spend Analytics/ HR Analytics /Sales Analytics, Informatica Power Center 8.6.0/9.0, Data Warehouse Administration Console (DAC), PL/SQL, SQL*Plus, JIRA, ALM, SharePoint, MS Project

Confidential, San Francisco, CA

OBIEE/ODI Developer

RESPONSIBILITIES:

• Created the Repository manager, users, user groups and their access profiles.
• Extracted data from different sources, flat files and loaded into DWH.
• Created complex mappings in Power Center Designer using Expression, Filter, Sequence Generator, Update Strategy, Joiner and Stored procedure transformations.
• Created connected and unconnected Lookup transformations to look up the data from the source and target tables.
• Wrote SQL, PL/SQL, stored procedures for implementing business rules and transformations.
• Used the update strategy to effectively migrate data from source to target.
• Developed and documented Mappings/Transformations, Audit procedures and Informatica sessions.
• Created test cases and completed unit, integration and system tests for Data warehouse.
• Involved in Data Validation using SQL queries.
• Tested the ETL Data Stage jobs and other ETL Processes (Data Warehouse Testing)
• Tested the ETL process for both before data validation and after data validation process.
• Developed and Designed Test Cases based on the Business requirements.
• Validated that design meets requirements and function according to technical and functional specifications.
• Performed all aspects of verification and validation
• Participated in walkthrough and defect report meetings periodically.
• Written SQL Queries to define, Identify and validate the code written for the data movement into the database tables.
• Extensively worked in the performance tuning of the programs, ETL Procedures and processes.
• Worked in Production support team for maintaining the mappings, sessions and workflows to load the data in Data warehouse.

ENVIRONMENT: OBIEE 10.1.3.4.1 (Administration, Answers, Dashboard, BI),Oracle EBS Release 12, Oracle BI applications 7.9.6, DAC (Data warehouse Administration Console),Informatica 8.6, Star Schema Design, SQL Plus, Performance Tuning, Oracle 11g(SQL, PL/SQL),TOAD 9.5, Java Script, HTML, Windows 2003 & Linux Servers and Unix.

Confidential, Jersey City, NJ

OBIEE Developer

RESPONSIBILITIES:

• Understanding the Client requirements, source data, business objectives and key performance indicators.
• Worked with the business users and business analysts to identify and refine business requirements, and lead a team to create the technical architecture necessary to support the requirements.
• Involved in designing and development of metadata repository (RPD file) including building Physical Layer, Business model and presentation layer based on Oracle BI recommended best practices.
• Configure NQSConfig.ini file and setup database tables to implement and administer Usage tracking by direct insert method.
• Design the dimensional data model (Fact & Dimension tables) using Oracle recommended best practices.
• Involved in customizing the user interface to implement hierarchies using Java Script to meet some of the client requirements.
• Designed Security model using Single Sign On (SSO) and external database authentication.
• Organized the user’s workshop session to go over the entire pre-built dashboards, reports. Performed gap analysis and categorized the gaps as medium, high & low effort.
• Enhanced and Modify the ETL code (SDE and SIL Mappings) to cater the new business requirements.
• Implemented additional Dimensional Hierarchies and build metadata around new custom dimension & fact table.
• Implemented and used Multi User Development (MUD) environment for the developers.
• Configured I-Bots to automate the cache seeding and disconnected application.
• Designed the custom ETL process and engaged in writing test scripts to validate ETL data results.
• Developed & Executed the Unit & Integration test cases scripts.

ENVIRONMENT: OBIEE 10.1.3.4.1 , Oracle BI applications 7.9.4, DAC (Data warehouse Administration Console),Informatica 8.1.1,Oracle 11g,UNIX Shell Scripting, Windows 2003 & Linux Servers, SQL DEV, SQL* Loader.

Confidential

Siebel Analytics (OBIEE) Consultant

RESPONSIBILITIES:

• Complete Life Cycle or End-to-End (gathering Business Users Requirements, System Analysis, Design & Data Modeling, Development, Testing) implementation experience of Data Warehouse, Data mart and Business Intelligence using Informatica and OBIEE
• Designed dimension and fact tables for Star Schema and Snowflake Schema to develop the Data warehouse.
• Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star-Schema modeling, Snowflakes modeling, fact and dimension tables modeling of data.
• Designed and Developed the Oracle Business Intelligence Analytics Metadata Repository (.RPD) by importing the required objects (Dimensions, Facts & Aggregates) into Physical Layer, developing multiple Dimensions (Drill-Down Hierarchies) & Logical & Facts / Measures objects in Business Model Layer and creating the Presentation catalogs in Presentation Layer.
• Expertise in Business Model development with Dimensions, Hierarchies, Measures, Partitioning, Aggregation Rules, Time Series, Caching.
• Developed many Reports / Dashboards with different Analytics Views (Drill-Down / Dynamic, Cascading Style Sheets, Pivot Table, Chart, Column Selector, Tabular with global and local Filters).
• Created adhoc reports, reports with variable fields, complex reports, navigational reports, reports with complex calculations and Running totals report.
• Configured & published Delivers / iBots to deliver analytics content based on schedule, automated iBots queries to obtain daily & weekly transactions by Emails.
• Created Time Series measures Year ago, Month Ago, Year-to-date measures using AGO and To Date functions
• Developed Reports / Dashboards with different Analytics Views (Drill-Down / Dynamic, criteria filters, Pivot Table, Chart, Column Selector, Tabular with global and local Filters) using Oracle BI Analytics Web / Oracle BI Presentation Services.
• Used the Catalog manager and maintained the Analytics web catalog to manage Dashboards, Answers
• Implemented Object level security and data level security and Set up Single Sign-On SSO for all the users.
• Security management using the various authentication systems such as LDAP, External Database table using Session Variable features, as well as Dashboard / Report-level security.
• Modified Dynamic Session Variables used for Data Visibility, Configured Security at the repository level, Catalog level & the Siebel Application level
• Involved in Repository Configuration, Troubleshooting, Migration and Server Administration of DEV, QA and PROD environment
• Designed and Developed PL/SQL Procedures and UNIX Shell Scripts
• Involved in writing the Test Cases and Test Case Results to test the Mappings & Reports
• Create Functional (FRS), Technical design doc (SDS), Perform data mapping between reporting requirements and Siebel OLTP (tables/columns) - Facts/measures, Dimension/attributes

ENVIRONMENT: OBIEE 10g, Siebel CRM 8.0,Informatica Power Center 8.6.0, Oracle 10g (SQL, PL/SQL), DAC build 10 (Data warehouse Administration Console), Star Schema Design, SQL Plus, Performance Tuning, TOAD 9.5, Java Script, HTML, Windows 2003 Server SP2, UNIX/LINUX

Confidential, TX

RESPONSIBILITIES:

• Performed many enhancement and new development requests by the end users of GE in order to enhance the output (PO, Invoice, SO, etc..)
• Identified and fixed many Bugs in the code.
• Communication to Onsite coordinators and to the Downstream.
• Knowledge transferred to the new resources.
• Got customer appreciation for fixing the issue in very less time
• Prepared documentation on various subject areas.
• Lead the team in many aspects
• Relocated to Different city to lead the new team over there.
• Worked extensively in upgradationof the Optio Architecture.
• Also found the root causes for the post rollover issues and solved the with in less time.