SUMMARY:

• 13+ years of Business Intelligence experience using OBIEE (7.x/10g/11g/12c) as RPD architect and front - end report developer
• 13+ years of experience in data warehousing and dimensional modeling, including 6 years of experience in OBIEE Application package configuration and customization
• 13+ years of total experience in BI project full lifecycle including business requirements analyses, application design, data modeling, data profiling, data cleansing, and testing

TECHNICAL SKILLS:

Oracle Reporting: OBIEE 11.1.1.7.0 , 11.1.1.6.0 , 11.1.1.5.0 , 10.1.3.4, OTBI, Siebel Analytics 7.8.2/7.7.1/7.5.3 , DAC 7.8/10/11

ETL Tools: Informatica PowerCenter 9/7/6.2/5.1, PowerMart 6.2/5.1, ODI 12.2.1

OBI Apps: Financials, Supply Chain, Order Management, Sales

OBI Apps Versions: 7.9.6.4, 7.9.6.2

Database: Oracle 12c/11g/10g/9.x/8.x Teradata 14.1,SQL Server

Languages: Java, C, PL/SQL, HTML, Java Scripts, XML, UNIX Shell ScriptsOperating Systems HP-UX, Sun-Solaris, Unix, Windows NT/2K3/2K/XP

Others: Visual Studio 2013, Crystal Reports 2013, Tableau 10.3

EXPERIENCE:

Confidential, CA

Business Intelligence Lead Developer

Environment: OBIEE 12c/11g, Oracle 12c, Crystal Reports 2013

Responsibilities:

• Conduct business requirements gathering sessions with business team and lead business users for reporting and analysis requirements..
• Built Mapping Documents from source to target and documented complex calculations for reporting requirements.
• Worked on Testing OBIEE reports to ensure they met business requirements
• Analyze data of RBG reports to derive business insights to improve user experience.
• Delivered BI projects using scrum model and time boxed weekly sprints
• Design the data model necessary to implement the reporting and analysis requirements.
• Create/Modify Metadata repository suiting to data requirements by using Oracle BI Server Admin tool.
• Extensively Built Reports, Dashboards and prompts using latest features of OBIEE 12c
• Worked on enhancements of the existing Tableau workbooks, created new calculated columns, updated existing derived calculation logic, update the existing Groups, Sets in Tableau.
• Identified Reporting Performance issues and provided new design solutions.
• Involved in the integration testing and unit testing the data. Identified bugs during the testing phase and fixed them.
• Configured and developed OBIEE Rpd using MUD environment
• Built Financial reports from Hyperion Cubes and blended it with oracle data in OBIEE.
• Worked on Migrating reports from Crystal Enterprise to Oracle BI Publisher
• Built SQL scripts for Data Models in BI Publisher reports
• Defined static and dynamic repository variables, session variables for users to enhance data level security.
• Built Star Schema in OBIEE Repository, Created multiple Subject areas and Worked Extensively on OBIEE Answers to build reports.

Confidential, AZ

ORACLE BI Lead Developer/Architect

Environment: OBIEE 12c/11g, Oracle 12c, Teradata 14.1, Teradata SQL Assistant 15.1, Crystal Reports 2013, Visual Studio 2013, IBM Infosphere DataStage 8.7

Responsibilities:

• Conduct business requirements gathering sessions with business team and lead business users for reporting and analysis requirements.
• Created Business Requirement Documents and Technical Design Documents.
• Managed Sprint Backlog, Stories and tasks using VersionOne and Delivered BI projects using scrum model and time boxed 2 week sprints
• Worked on merging data between Albertsons and Safeway in order to be compatible with in house data.
• This initiative was to upgrade OBIEE from 11.1.1.7.1 4 .2.1.0.0
• Fixed defects arising from upgrade of OBIEE from 11g to 12c
• Modeled OBIEE rpd using TeraData as source Database
• Design the data model necessary to implement the reporting and analysis requirements.
• Create/Modify Metadata repository suiting to data requirements by using Oracle BI Server Admin tool.
• Extensively Built Reports, Dashboards and prompts using latest features of OBIEE 12c
• Identified Reporting Performance issues and provided new design solutions.
• Implemented complex business logic requirements in OBIEE using presentation variables
• Used OBIEE MUD (Multi User Development process) to manage changes in OBIEE Rpd
• Created and scheduled OBIEE Agents based on conditions to Deliver Daily Sales reports to Executives
• Administered security privileges and permissions for each subject area and dashboards according to customer requirements.
• Involved in the integration testing and unit testing the data. Identified bugs during the testing phase and fixed them.
• Designed and Built Materialized Views in Oracle database and used them as aggregate tables.
• Improved OBIEE report performance by adding necessary ORACLE hints
• Designed and implemented Database scripts (DDL, DML, and PL/SQL).
• Developed SQL*Loader jobs to process data from files into LDR tables, based on Zero percent data loss footprint.
• Diagnosed and fixed data load issues in IBM DataStage and fixed defective jobs
• Worked as Rotating Scrum Master and conducted various scrum events

Confidential, IL

ORACLE BI Architect

Environment: OBIEE 11g, OBI Apps 7.9.6.4, OBI Apps Procurement and Spend, Informatica 9, Oracle 11g, DAC 11g

Responsibilities:

• Built Custom Rpd for client based on requirements
• Modified DAC plans and ETL mappings related to OBI Apps 7.9.6.4
• Created Business Requirement Documents and Technical Design Documents.
• Trained client tem members to get up to speed with Oracle BI Apps 7.9.6.4

Confidential, TN

ORACLE BI Architect

Environment: OBIEE 11g, OBI Apps 7.9.6.4, OBI Apps Financials, OBI Apps Procurement and Spend, Informatica 9, Oracle 11g, DAC 11g, PeopleSoft 9.2

Responsibilities:

• Conduct business requirements gathering sessions with business team and lead business users for reporting and analysis requirements.
• Worked on building sample OTBI using Oracle Fusion Applications
• Led offshore team of developers for ETL and report development and testing.
• Created Business Requirement Documents and Technical Design Documents.
• Design the data model necessary to implement the reporting and analysis requirements.
• Installed OBIEE 11.11.1.7, Informatica 9.1, DAC 11g and BIApps 7.96.4 on Linux Environment and fixed installation challenges.
• Customized BIApps 7.9.6.4 ETL Mappings, Rpd and Reports to suit business needs.
• Customized DAC Execution plans to suit business needs
• Deployed OBIEE 11g Mapviewer and built Map based reports for Real Estate Management
• Create/Modify Metadata repository suiting to data requirements by using Oracle BI Server Admin tool.
• Migrated ETL Mappings, DAC objects, rpd and reports to different environments.
• Set up and Monitored Execution Plans using DAC and Informatica
• Extensively Built Reports, Dashboards and prompts using latest features of obieee 11.1.1.7.1
• Worked on installing and configuring Mapviewer 11.1.1.7.1 and Map based report development.
• Identified Reporting Performance issues and provided new design solutions.
• Defined Primary key-Foreign key relationships, complex joins bridge tables between dimension tables and Fact tables in the physical layer..
• Administered security privileges and permissions for each subject area and dashboards according to customer requirements.
• Involved in the integration testing and unit testing the data. Identified bugs during the testing phase and fixed them.
• Tested and Validated the Repository before making it available for queries.
• Defined static and dynamic repository variables to modify metadata content dynamically to adjust to a changing data environment and session variables for users to enhance data level security.
• Worked extensively on obiee 11.1.7.1 Presentation Catalog
• Worked Extensively on OBIEE Answers to create the reports as per the client requirements.
• Created and modified the request, modified the result layout and added filters to them according to the need of end-users.
• Created SDE and SIL mappings to extract data from the transactional system and flat files and subsequently load them into the warehouse tables via staging tables.
• Created workflows for the Initial load and refresh load.
• Advised client on best practice for Oracle BI Web and Repository.

Confidential, NC

ORACLE BI Architect

Environment: OBIEE 11g, OBI Apps 7.9.6.2, Informatica 9, Oracle 10g, DAC 10g

Responsibilities:

• Conduct business requirements gathering sessions with business team and lead business users for reporting and analysis requirementsand create Business Requirement Documents and Technical Design Documents.
• Design the data model necessary to implement the reporting and analysis requirements.
• Led major upgrade of OBIEE from 10.1.3.4 to 11.1.1.7.0 and created plans for rollout.
• Performed in-place upgrade and out of place upgrade of OBIEE 11g on Windows 2008 R2
• Create/Modify Metadata repository suiting to data requirements by using Oracle BI Server Admin tool.
• Created connection pools, physical tables,Defined Primary key-Foreign key relationships, complex joins,Administered security privileges and permissions for each subject area and dashboards according to customer requirements.
• Built Aggregate tables and fragmented fact tables for efficient query performance.
• Involved in the integration testing and unit testing the data. Identified bugs during the testing phase and fixed them.
• Defined static and dynamic repository variables to modify metadata content dynamically to adjust to a changing data environment and session variables for users to enhance data level security.
• Created presentation layer catalog folders and set up security based on roles.
• Involved in end user using answers
• Worked Extensively on OBIEE Answers to create the reports as per the client requirements.
• Created and modified the request, modified the result layout and added filters to them according to the need of end-users.
• Configured and implemented the Oracle BI MUD Environment and Deployed Oracle BI Scheduler Server.
• Implemented Cache Mechanism in Oracle BI by UNIX Script (Invoke by CA Scheduler)
• Created SDE and SIL mappings to extract data from the transactional system and flat files and subsequently load them into the warehouse tables via staging tables.
• Defined the refresh extraction and load logic and Created workflows for the Initial load and refresh load.
• Built mappings to populate the aggregate tables.
• Set up and Monitored Execution Plans using DAC and Informatica and supported production environment

Confidential, CA

ORACLE BI Lead Developer

Environment: Oracle BI EE 10gR3, Oracle 9i

Responsibilities:

• Developed Dashboards using global prompts, Union based Reports, Pivot Tables/Charts and View Selectors.
• Worked on Oracle BI Administration Tool for data modeling, modifying existing rpd design, adding cross hierarchical drill downs and new dimensions to existing star schemas.
• Resolved Report performance issues by using Fragmentation in OBIEE
• Worked on bug fixing related to rpd and report design.

Confidential, TX

ORACLE BI Lead Developer

Environment: Oracle BI EE 10gR3, Oracle 9i

Responsibilities:

• Developed different kinds of Reports (pivots, charts, tabular) and used global and local Filters.
• Extensively used Oracle BI Administration Tool for data modeling, creating the physical, business and presentation layers of metadata repository based on the Hyperion Business Model.
• Developed Rpd Calculations for Engineering and Sales Subject Areas by Converting Java script Code to OBIEE expressions.

Confidential, CA

Siebel Data Warehouse Lead Developer

Environment: Siebel eSales 7.0, Siebel Analytics 7.8, DAC, Oracle 9i, Informatica 6.2, HP-UX, Rational Clear Case

Responsibilities:

• Worked as a lead for the Siebel Analytics Development/Support Team for eSales Integrated Analytics application.
• Experienced in resolving Critical Production Issues within the SLA.
• Extensively worked on developing Analytics reports for eSales Analytics which Includes Opportunity Pipeline and Forecasting Dashboards and reports.
• Developed different kinds of Reports (pivots, charts, tabular) and used global and local Filters.
• Extensively used Siebel Analytics Administration Tool for data modeling, customizing and modifying the physical, business and presentation layers of metadata repository.
• Developed calculated measures and assigned aggregation levels.
• Created dimension hierarchies and assigned levels.
• Worked on complex security model to grant visibility to different levels in the hierarchy.
• Responsible for Analytics RPD, Web catalog, Informatica and DAC repository Migrations to Production.
• Hands on experience in Creating Informatica SDE, SIL Mappings and running workflows.
• Worked on troubleshooting Daily Production ETL’s using Informatica and DAC.
• Experience in creating custom ETL mappings with Siebel CRM and spreadsheet source data.
• Developed ETL mappings for creating daily snapshots of Sales Revenue for reporting.
• Extensive experience in creating DAC ETL Task definitions and the Siebel change capture process with respect to DAC.
• Worked on Deleted Capture and Auxiliary Change capture ETL mappings using Informatica and DAC.
• Worked on troubleshooting Security and Data Visibility related issues.
• Conducted knowledge transfer sessions for offshore Development Team.
• Coordinated with SIEBEL support to resolve outstanding production support issues.

Confidential, OH

Siebel Data Warehouse Analyst

Environment: Siebel eConsumer 6.0, Siebel Analytics 7.5/7.7, Oracle 9i, Informatica 6.2

Responsibilities:

• Lead for the NA Siebel Transactional Analytics Team for Service Operations for Consumer Product Group and RSS business units.
• Captured business requirements, worked on gap analysis and prepared Functional and Technical mapping documents and identified Facts and Dimensions for various reporting requirements
• Configured the Siebel Analytics Reports, dash boards,Created iBots to alert Merchandising Supervisors team about Past Due Activities.
• Managed security privileges for each subject area and dashboards according to user requirements.
• Worked extensively on Analytics report performance issues by tuning OLAP databases and cache seeding.
• Developed usage tracking Schemas, Reports and Dashboards for business analysis.
• Performed Analytics RPD and Webcatalog Migrations to Production,user administration and Security.
• Worked on Analytics (7.5 to 7.7) and Informatica (5.1 to 6.2) upgrade and subsequent testing.
• Hands on experience in Creating Informatica SDE, SIL Mappings and running workflows,ETL Tuning for increasing data volume.
• Worked on Incremental Aggregation for improving ETL load performance.
• Involved in Disaster Recovery Drill Testing to recover Data warehouse Applications in Production environments.
• Co-coordinated with SIEBEL support to resolve outstanding production support issues