SUMMARY:

• Sr. OBIEE consultant with 6+ years of experience in BI domain and experience in each step of SDLC from analysis and design to code, testing and implementation. Expert in OBIEE/OBIA repository modelling/customization, report and dashboard development. And equally proficient in Data Warehouse (DW) design and implementation using Informatica PowerCenter and DAC.
• I’m a passionate BI/analytics professional who is able to work effectively with business users to deliver successful BI solutions that satisfy customer needs. I would describe myself as a problem solver, critical thinker and a student. Also I actively contribute in the Oracle community BI space
• Hands on experience in OBIEE 10g, OBIEE 11g, OBIEE 12c, BI APPS 7.9.6.4 and BICS.
• Excellent understanding of OBIEE Architecture.
• Expertise in creating reports, dashboards, agents and visual analyzer projects.
• Expertise in managing the presentation catalog, setting up security and application roles.
• Expertise in OBIEE performance tuning and Oracle SQL tuning.
• Experience in creating Oracle PLSQL procedures and functions.
• Expertise in OBIEE RPD modeling in all three layers (Physical, BMM, and Presentation).
• Experience in setting up multilingual OBIEE analytics’ application.
• Expertise in star schema design, configuring logical dimensions, hierarchies, level measures, aggregate tables, fragmentation etc. in BMM.
• Strong understanding of Data warehouse concepts (Kimball and Inmon approach), ETL, Star Schema, Snowflake, facts & dimensions tables, physical & logical data modeling.
• Expertise in data modelling and developing Data Warehouse using Ralph Kimball approach.
• Expertise in Data Warehouse management using DAC (incremental and full load) and debugging and fixing ETL issues.
• Expertise in developing BI publisher reports.
• Good hands on knowledge with Oracle 11g, MSSQL, cache databases.
• Hands on experience in database partitioning.
• Experience in Hadoop/Hive - OBIEE integration on sandbox environment.
• Basic knowledge of Tableau and Power BI.
• Oracle certified specialist in OBIEE 11g and BICS (Oracle Business Intelligence cloud services).
• Trained and certified in ODI (Oracle Data Integrator) by Oracle.
• A good team player with excellent written and verbal communication skills.
• Excellent client facing experience acquired over the years.
• Ability to learn new technologies and techniques quickly.
• Highly motivated, able to multitask and work with minimum supervision, committed to highest quality of end result.

TECHNICAL SKILLS:

Business Intelligence: OBIEE 10g, OBIEE 11g, OBIEE 12C, BICS,OBIA 7.9.6.4, BI Publisher 10g, BI Publisher 11g, Oracle Data miner, weblogic 10.3.6

DAC: DAC 11g, DAC 10g

ETL Tools: Informatica Power Center 9.1.0, Power Center 8.6, ODI 12c, Data Sync

Siebel Applications: Siebel Call Center 8.1, Siebel Public Sector 8.1, Siebel Open UI

Source Systems: Siebel, Avaya ACD, PIPKINS, flat files

Operating System: Windows, UNIX

Languages: C, C++, Java script, SQL/PLSQL, perl

Database: Oracle 10g, Oracle 11g, SQL Server, Cache DB

PROFESSIONAL EXPERIENCE:

Confidential, Albany, NY

Senior OBIEE Developer

Project Responsibilities:

• Responsible for implementing an end to end analytic solution for New York State of health’s health exchange Call center.
• Gather Data Warehouse, reporting requirements and translate them into technical design documents.
• Design the data model for new data marts in the Data Warehouse and star schema for OBIEE application.
• Customize OOB Informatica mappings for Oracle BI Applications 7.9.6.4 for Siebel contact center analytics and service analytics to suit business requirements.
• Develop new Informatica mappings for integrating new source systems such as Avaya ACD, IVR, PIPKINS WFM to the Data Warehouse.
• Add new data marts to the Data Warehouse to support new reports and dashboards.
• Configure new tasks and setup subject areas and execution plans in DAC.
• Analyze system performance and tune the Warehouse and OBIEE application.
• Troubleshoot and fix ETL issues.
• Create new star schemas, measures, dimensions, hierarchies, level based measures, aggregate tables and ensure consistency in SA’s in OBIEE RPD.
• Set up caching to achieve optimum application performance.
• Enable usage tracking and enhance user experience.
• Setup chained agents to improve agent performance.
• Develop real time dashboards from OLTP data.
• Create reports using direct database request.
• Enable Write back.
• Develop new Reports and Dashboards as per the requirements.
• Develop BI publisher reports and deliver them via FTP.
• Deliver presentations to explain design and solution to business and team.
• Implement object level security using Application Roles.
• Customize the Change Data Capture mechanism to suit the source systems and business needs.
• Implement database partitioning and other performance improvement techniques.
• Support OBIEE application upgrades, installation and configuration.
• Troubleshoot Production issues and outages and coordinate with multiple teams to resolve issues quickly.
• Work with Oracle Support to troubleshoot and fix product issues.
• Mentor new resources in the team.
• Test the reporting application and the Data Warehouse.

Environment: OBIEE 11.1.1.7/ OBIEE 11.1.1.9, Oracle Linux, Oracle DB 11g, Informatica 9.1.0, DAC, OBIA7.9.6.4, SQL Developer, DBVisualizer, SVN, putty, Winscp

Confidential

Senior OBIEE Developer

Project Responsibilities:

• Design and implement call center analytics in Oracle BI cloud (BICS).
• Design rpd using the web based tool, create contact center analytics reports and dashboards.
• Load data using data loader and Data Sync.
• Administer the BICS application which includes taking snapshots, migration, user provisioning etc..

Confidential

Developer

Project Responsibilities:

• Design and development of BI publisher reports and integrate them with Siebel.
• Requirement gathering from business users and translating them to specification document.
• Development of functional and statistical reports.
• Siebel configuration for reports integration.
• Auto attachment of BI publisher reports in Siebel using web service.
• Develop Siebel screens and views for BIP reports.
• Develop rtf templates with customized XSL codes to meet business requirement.
• Develop pixel perfect reports with both pdf and rtf outputs.
• Develop reports using multiple datasets.
• RTF template development using MS word.
• Created materialized views for statistical reports for performance improvement.
• Travel to client location to ensure a smooth go live and provide training as required.
• Documentation of BI publisher reports.
• Administer the BI publisher application.
• Deploy reports across environments.
• Debug and fix report issues.

Environment: BI Publisher 10.3.4.1, SQL, PL/SQL, TOAD, SQL developer, windows server 2010, Siebel 8.1.1

Confidential

Developer

Project Responsibilities:

• Create new Reports and Dashboards.
• Configure OBIEE Scheduler to send reports to end users via email.
• Configure OBIEE Dev and Test Environments to sync with Production Environment.
• Customize out-of-box mappings for Oracle BI Applications 7.9.6 Sales and Service module.
• Customize the DAC containers to configure the ETL to run in both full and incremental loads.
• Customize Informatica mappings to extend dimensions and fact.
• Configure DAC Tasks to add new Informatica mappings created for loading new dimensions and fact tables.
• Modify OBIEE RPD for enhancements and bug fixes.
• Perform RCA for bugs and document the same.
• Perform GAP Analysis before implementing new customization.
• Involve in daily monitoring of ETL and fixing issues with ETL runs.
• Perform full load ETL after every major release.
• Upgrade Informatica Power center from 8.6 to 9.0.1.
• Fix issues related to the OBIEE repository, which include metadata consistency issues, star schema design changes, view alteration, initialization block modification, and user responsibility and group changes.
• Actively engage with client and deliver enhancement and fixes quickly.
• Documentation of OBIEE and warehouse design.

Environment: OBIEE 10g, AIX, Oracle 10g, Informatica 8.6.1/9.0.1, OBIA7.9.6, SQL, TOAD.