SUMMARY:

• 10+ years of experience in gathering Business Requirements, assessing & developing Business Intelligence Program strategies, and designing and implementing Business Intelligence information & analytical solutions.
• Experience in designing and developing end - to-end BI solutions according to standard OLAP methodologies using Siebel Analytics/Oracle Business Intelligence (OBIEE).
• Worked Extensively on Oracle BI Administration Tool, Presentation Services, Answers, & Interactive Dashboards and Security Implementation.
• 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 Interactive Business Intelligence Dashboards using Oracle Business Intelligence 10.x. as well as 11g
• Experience in Oracle Data Integrator with expertise in building data extraction routines for Data Warehousing and Code tuning.
• Capable of processing large sets of structured, semi-structured and unstructured data and supporting systems application architecture with Pentaho.
• Using the data Integration tool Pentaho and ODI for designing ETL jobs in the process of building Data warehouses and Data Marts.
• Experience in Dimensional Data Modeling using Star Schema, Snow-Flake Schema, Fact and Dimensional Tables.
• Experience in Security Setup at both Object and Data levels, which involved creation of users/groups, LDAP authentication setup and configuration of Multiuser Development Environment (MUD).
• Expertise in building Metadata Model (rpd), building Physical layer, Business Model and Mapping layer, Presentation layer using Oracle BI Administration tool along with development of dynamic and interactive Dashboards, Answers and IBots.
• Background in administration and implementation of BI Apps including Financials, Procurement and Spend, Supply Chain and Order Management, and HR.
• Good experience in implementing best coding standards like creating Alias, LTS, LT, Aggregate tables, Cache management.
• Participated in migration of Oracle BI metadata and configuration from BI 11.1.1.7 to Oracle OBIEE 12C release.
• Work experience in using all types of variables like repository, session, presentation and request variables
• Familiar in PL/SQL Procedures, Packages, Functions, Triggers and other objects
• Worked with end users/customers to understand business requirements, recommended technical solutions and documented functional requirements.

TECHNICAL SKILLS:

Data Model: Erwin, SQL developer, Toad, MYSQL Work beach

Oracle Apps: Oracle E-Business suite R12/11i OM, GL, AP, AR, AOL.

Databases / ETL: Oracle 11g, SQL Server 2008, Informatica, ODI 11g/12C, BICS, Essbase, Pentaho Data Integrator (Big Data) and Teradata.

Reporting Tool: OBIEE (11g / 12C), OBIA 11.1.1.8, BI Publisher, BO, OKA 8.6.2, Pentaho Report Designer

Enterprise Architecture: Pentaho BI and Zachman Frameworks

Operating Systems: Windows XP, Windows 7, UNIX

Programming Languages: PL/SQL, Shell Scripting.

PROFESSIONAL EXPERIENCE:

Confidential, Omaha, NE

OBIEE / DH Architect

Responsibilities:

• Involved in the initial requirement gathering for the reports and also understanding client expectations to meet their business.
• As part of the architecture team involved in Code review of the development work done by all the development teams.
• Responsible for formulating the OBIEE development standards, best practices and guidelines
• Part of the SME team which helps the development teams to overcome any technical difficulties pertaining to OBIEE.
• Involved design and development of repository (RPD) (creating/Modifying objects in Physical, Business and Presentation layer) and the process of repository migration.
• Designed ODI Projects, Packages and Interfaces to extract the data from Oracle EBS R12 database load to Oracle Business Analytics Data Warehouse OBAW.
• Creating and customizing ODI interfaces, mapping, joins, filters lookups to implement business rules.
• Setting up LDAP authentication to enable Single Sign on for Users in Production environment leveraging Analytics Repository.
• Administered Permissions and Privileges for dashboard visibility and modifications to Users based on their groups or responsibilities.
• Fix the ETL load issues because of the data or ETL mappings.
• Execute Incremental test loads
• Developed ETL process using Pentaho PDI to extract the data from Oracle Cloud Unstructured Big Data and Vista and populated it in to our BI Cerebro Data mart.
• Responsible for implementing Object level security for the various users who would be using the BI system.
• Responsible for Metadata Administration, managed Data models and reverse engineering.
• Administered Permissions and Privileges for dashboard visibility and modifications to Users based on their groups or responsibilities.
• Used Knowledge modules to achieve client requirements such as connecting to specific technology, extracting data from it, transforming the data and integrating it.
• Worked closely with Users, Developers and Administrators to resolve ongoing Production Problems by reviewing design changes made to production systems and made corresponding changes to Repository
• Performed extensive data analysis using source data and UI to understand the data, to assist data modeler in designing the databases, to identify bad data, to help Business in improving and redefining the requirements.
• Customized Dashboard pages like Overview, Budget vs. Actual, Asset usage, Financial Structure, Liquidity, GL Balance, Cash Flow and Balance Sheet in General Ledger GL .
• Performed stakeholder analysis team and weekly status reports to leadership teams
• Participated in designing, coordination and execution of User Acceptance Testing (UAT) with QA, BA and selected business users

Confidential, St. Louis, MO

Sr. BI / DW Architect

Responsibilities:

• Interacted with Business Users and Business Analysts for gathering new business requirements and also understand the current requirements, performed GAP Analysis, and Data Analysis.
• Created Program Summary Reports analysis template, OBIEE- BI Answers reports analysis and requirement gathering templates, analyzed Obligation report outputs of Financials Module and came up with the Mapping document in order to show the Confidential IT Team End to End Implementation Approach for the Conversion. The main objective of this exercise was to understand the Existing Hyperion reports and code logic from the data files and check whether the same reports can be developed in OBIEE- BI Answers or not
• Configured Oracle BI Applications Configuration Manager and Oracle Data Integrator, Oracle BI Applications Functional Setup Manager.
• Involved in POC for OBIEE and SAP integration for the client to implement the reporting in OBIEE.
• Involved in Design and Development of custom business intelligence solution (Metadata and Dashboards/Reports) using OBIEE 11g.
• Coordinated and worked with different teams like SAP BW, DBA, testing team, functional team and end users
• Use the best practices of business intelligence to design the analytical solutions.
• Used various cache management techniques for performance tuning including configuring, defining cache parameters, cache persistence time, cache seeding and purging, and event polling.
• Converted Hyperion BQY reports into OBIEE BI Publisher reports
• Integrated BI Publisher with OBIEE to build reports in word, excel and doc format.
• Created various templates, reports, and prompts in BI Publisher.
• Customized Out Of Box Dashboard pages like Sourcing Trends, Total Spend Overview, Exceptions, Purchase Requisitions, Purchase Orders and Employee Expenses in Supply Chain Analytics.
• Schedule reports and bursting as per the requirement in BI Publisher and represented them in OBIEE dashboards
• Creating a Master Detail Report in BI Publisher with Consistent Look and Feel Using Sub templates
• Setup Multi User Development Environment (MUDE) in OBIEE.
• Involved in Knowledge transfer to Confidential IT Developer on various issues and product maintenance.
• Assisted ETL team to configured and setup ODI, master repository, work repository, Project, Models, sources, targets, packages, Knowledge Modules, Interfaces, Scenarios, filters, condition, metadata .
• Responsible for creating additional Users and maintaining Visibility Privileges using OBIEE Administration on Repository side as well as front end to display of OBIEE reports based on business user needs.
• Involved in unit testing, Security and integration testing of the reports generated by OBIEE

Confidential

OBIA Consultant / Data Warehouse

Responsibilities:

• Gathered and analyzed requirements from the business users and translated the business requirements into conceptual and detailed technical design.
• Involved in Planning project developing and documenting technical specifications(TSD) from business requirements.
• From a single dimension for RPD development, level based measures.
• Worked with DBA and SQL developers to create jobs and schedules to build materialized views.
• Created new logical columns layers physical, business and presentation layers.
• Customized OBIA ETL mappings and table extensions to design the Star Schema and populate the Data warehouse based on business requirements.
• Worked on PeopleSoft Security by creating and testing user roles and permission list.
• Configured OBIA application to integrate with the PS source system.
• Provided reports in Financials by gathering business requirements from Business users.
• Worked on different subject areas of AP, AR and GL to create Reports and Dashboards according to the business requirements Customized OBIEE repository by adding custom columns and tables using BI administration tool for Service Analytics tables like W ACTIVITY F, W AGREE F, W AGREEITEM F, W QUOTE D, tables in Service Analytics (Oracle CRM).
• Implemented User access, authentication and authorization as well as configuring LDAP Server to provide OBIEE users.
• Implement security for OBIA, as well as user security authentication using LDAP server directory.
• Worked on OBIEE 11.1.1.7 Repository, customized the RPD (Customer and prebuilt) with the requirements of the End User to Designed and developed the three layers.
• Identified data sources and worked on corresponding mappings and logical joins and Configured tables, columns between business and presentation layers.
• Used Informatica 9.5.1.0 ETL to load data from Flat Files, Oracle Databases, and COBOL files to the Data Warehouse, Data Warehouse testing, partitioning, error handling, ETC

Confidential, Long Island, NY

OBIEE Developer

Responsibilities:

• Designed architectural frameworks for OBIEE11.1.1.6 and BI applications to meet business needs.
• Resolved technical issues with Project Management, clients, vendors, and other contractors.
• Involved in co-coordinating onsite-offshore teams in various life cycles of the projects
• Validated technical design created by developers against functional specifications.
• Involved in designing the PL/SQL procedures for getting the data from all systems to Data Warehousing system. The data was standardized to store various Business Units information in tables.
• Assisted in integrating OBIEE application with Oracle RDBMS database.
• Implemented User access, authentication and authorization following best practices in the Repository.
• Experience in optimizing query performance, session performance and fine tuning the mappings for optimum performance
• Worked on Repository (.rpd), customized the RPD with the requirements of the End User. Designed and Developed the three layers (Physical, BMM, Presentation)
• Implemented Dimensional hierarchies, Level based measures, Fragmentation content, Aggregation, Complex joins in rpd, Configured Repository and Session variables and Initialization block for Dynamic, Customized, Prebuilt reports.
• Worked on administration of OBIEE Cache management, Security Management for Users, groups and web groups using the various authentication system such as LDAP Authentication using Session variable as well as Dash board / Report level Security.
• Developed test cases and performed Unit Testing and Integration Testing of the Repository and Web Catalogs

Confidential, VA

OBIEE Developer

Responsibilities:

• Gathered requirements from the client for GAP analysis, translated them into technical design documents and worked with team members in making recommendations to close the GAP.
• Created Requirements Traceability Matrix and Mapping Document to trace requirements in BI implementation.
• Identified the facts and dimensions and designed the relevant dim and fact tables.
• Worked using Catalog Manager to migrate Web Catalog from Instance to Instances.
• Designed Star schema for fact dimensional tables and created alias for the dimension and fact tables when necessary.
• Developed metadata repository using OBIEE Administration tool in Physical, Business Model and Mapping, and Presentation Layer
• Ensure availability and security of the analytic data and system
• Worked on the testing and validating the Repository in OBIEE.
• Designed and developed various Interactive Dashboards and reports with drilldowns, guided navigation, filters, and prompts.
• Used various cache management techniques for performance tuning including configuring, defining cache parameters, cache persistence time, cache seeding and purging, and event polling.
• Experience in Performance tuning at the Database and Report level by creating aggregate tables.
• Performed Installation and upgrade discovery of Oracle 10.1.3g to Oracle 11g Enterprise Edition, as well as Migrated Analytic RPD and web catalog from one environment to another.
• Managed the onshore and offshore deliverables and maintained a highly organized and streamlined environment.