SUMMARY:

• Over 7 yrs of experience in Business Intelligence Applications using Siebel Analytics / Oracle Business Intelligence OBIEE and ETL using Informatica PowerCenter
• Oracle Certified OBIEE/OBIA 11G Implementation Specialist
• Experience in Installation and Configuration of OBIEE, Informatica and DAC
• Expertise in integrating OBIEE with Peoplesoft, Siebel, EBS and Essbase
• Expertise in Java Script, HTML and XML
• Highly competent in Analysis, Design Development phases
• Highly competent in Warehouse design, OBIEE Repository, Delivers, Answers and Dashboards
• Hands on experience in the development of all areas of OBIEE Repository
• Expertise in Hyperion integration and reports development from Hyperion data cubes
• Experience in Integrating GIS systems like Google Maps and Custom Business Specific Maps with OBIEE
• Good domain knowledge experience in Business Intelligence Data Warehousing in Corporate level Applications
• Expertise in ETL using Informatica to facilitate Extraction Transformation and data Load from OLTP systems to OLAP systems.
• Experience in translating user requirements into functional, technical and system specifications, managing clients/ vendors/ partners relationships, ensuring service delivery and tracking requests for system enhancements, improvements from end-users /customers.
• Expertise in Oracle DAC installation and configuration, Tasks creation, synchronization, and execution Vanilla Mappings and Custom Mappings .
• Expertise and hands on experience in Siebel CRM Oracle CRM On Demand Analytics Development
• Experience in Oracle BI Publisher Report Development Template Building, Creating Data sets, XML generation from IO Created, Sub Templates, Parameterization, Scheduling, Translations, Graphical Reports etc.
• Experience in creating entity relational dimensional relational data models with Dr. Ralph Kimball Methodology i.e., Star schema and Snowflake schema.
• 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 OBIEE Repository
• Good analytical problem solving skills.
• 3 years of experience Project Manager/ Onsite Coordinator Role
• Client facing, Requirement gathering and Documentation experience
• Managed Offshore team of up to 13 resources

Technical Skills:

Professional Experience

Confidential

Role: OBIEE Lead

Project Responsibilities:

• Responsible for end to end delivery of OBIEE/OBIA-Informatica suite of products for the Case Management Solution
• Interaction with Client to Prepare Technical and Functional Specifications
• Architect and design technical solutions for the Client requirements
• Drive and Lead an Onsite-Offshore team and deliver results
• Work with functional and Technical resources to bridge gap
• Installation and configuration of OBIA Case Management Analytics 7.9.6.3 with Informatica 9.1 in Linux
• Set up a subject Area for users to create Adhoc Analysis reports
• Set up complex security model with IDM Authentication and Siebel Group Authorization
• OBIEE- Siebel Integration and Set up SSO Single Sign On with Siebel Case Management Analytics
• Design and Development of 6 OBIEE Dashboards with more than 30 reports with complex requirements including Drill downs, Navigations, Pivots, Graphs, Reports combining Subject Areas etc
• RPD development on Physical, BMM and Presentation layers for the reports
• Design the Star and Snowflake schemas from scratch for custom reports not available out of the box from Oracle
• Modify the existing Oracle DW schema according to transactional System changes
• Administration tasks including migrations and deployments, MUD and Integrations
• New Informatica mappings and workflows for custom built tables in Siebel and Portal to move data to OBIEE Data Warehouse
• Modify existing mappings in Informatica
• Configure and Monitor DAC and ensure ETL runs successfully
• Configure Full and Incremental ETL
• Provide Demos to client and get sign off on Reports
• Provide Training for client and other users

Confidential

Role: OBIEE Lead Administrator

Responsibilities:

• Install OBIEE 11.1.1.7.1 and integrate with Peoplesoft Financials Application
• Implement scale out and load balancing of BI Servers
• Perform all Admin tasks including setting up MUD, Migrations, Integrations etc
• Manage the offshore team of 12 BI and Data warehousing developers and 1 project manager
• Technical Lead for offshore team
• Architect and Implement complex security model including users from portal database, Active Directoy and native users
• Design and customization of Hyperion DW Schema bringing together multiple sources
• Modification of Hyperion DW schema to match Design principles and improving performance
• Design the existing OBIEE Repository to include the new star schemas form Hyperion DW
• Design and Manage the development of 11 new dashboards with more than 35 reports from Hyperion DW in line with the business requirements
• Customization of Prebuilt ETL Mappings Development of custom Mappings
• Performance Tuning of ETL mappings to reduce the Full and Incremental Load Time
• Implement object level and position based data level security
• Customization of Prebuilt OBIA repository according to Client Requirements.
• Customization of Reports and Dashboards Development of custom reports.
• Testing and Documentation

Environment: OBIA 7.9.5.1, Hyperion Essbase, AIX 5.3, Oracle 11g, Informatica 9.1, BI Apps 7.9.6.1, SQL, PL/SQL, TOAD

Confidential

Role: OBIEE Tech Lead Onsite Coordinator

Responsibilities:

• Responsible for end to end OBIEE implementation from Onsite
• Work with client to Gather Requirements, Analyze them and make Technical design documentation by constant meetings with business users
• Break down functional requirements to Technical blocks
• Manage and Deliver in a complex Onsite- Offshore Development Model
• Upgrade existing OBIEE 10G to 11G version
• Perform sizing of BI 11G Environment based on traffic and data size.
• GIS integration strategy to integrate Google Maps and Other Custom Maps in OBIEE Dashboards
• Modify OBIEE Repository to include sources like Hyperion and MSSQL
• Design and Implement new customizations in OBIA Repository.
• Upgrade of Informatica Mapping from Informatica 8.6 to 9.1
• Design and develop reusable maplets to reduce the development work to a large extend.
• Take care of OBIEE and Informatica upgrade issues
• Create new Informatica Workflows to populate the DW, co-ordinate with OLTP/Enterprise DW team for data mapping
• Performance Optimization for the ETL process
• Design new Reports, Ibots and Dashboards.
• Migrated of Catalog and RPD
• Implement LDAP security in OBIEE.

Environment: OBIEE 10.1.3.4.1 and 11.1.1.3, HP-UX, ODI, Oracle Database 10G, SQL, PL/SQL, TOAD.

Confidential

Role: BI Developer

Project Responsibilities:

• Configured out-of-box mappings for Oracle BI Applications 7.9.6 Sales and Service module.
• Worked with the business users in understanding the business and suggest suitable
• Created new Reports and Dashboards as per the requirement from End Users.
• Configure LDAP Security
• Followed best practices in BI Development and Migration
• Integrate Oracle BI Publisher and OBIEE with Siebel
• Developed BI Publisher report Templates
• Set up all environments to Development, UAT and Production
• Customized DAC containers to configure the Full and Incremental ETL
• Implemented the Change Data Capture mechanism in DAC for incremental changes
• Customize Informatica mappings to include new dimensions and fact tables.
• Managed the offshore deliverables
• Maintained a highly organized and streamlined environment.

Environment: OBIEE 10g/11g, Siebel, BI Publisher 10.1.3.4.2, Windows Server 2003, Oracle 10g, Informatica 8.6.1, OBIA7.9.6, SQL, PL/SQL, TOAD.