SUMMARY

• Overall 13 + Years of experience in IT industry and Last 6.5 years in OBIEE - Oracle Business Intelligence Enterprise 10G, 11g - Siebel Analytics and OBIA
• OBIEE/OBIA consulting in implementation, Technical solution, Project planning, Installation, Configuration & Development experience in OBIEE 10g & OBIEE 11g
• Good knowledge of OBIEE/OBIA Infrastructure and Architecture
• Design & defining architecture on OBIEE and integrating with E-CRM Siebel
• In-depth understanding of RPD configuration, Load balancing & Security model
• Implemented LDAP authentication with OBIEE11g & created customized Security policies and application for new users and groups
• Worked on ETL mappings & designed Logical & physical diagram for data marts
• Customized pre-built mappings for configuration of pre-built analytics OBI-Aps
• Configured OBIA pre-built analytics on Finance, SCM, Procurement & Spend and Manufacturing Analytics
• Extensively used OBIEE Administration Tool for customizing and modifying the physical, business and presentation layers of the metadata repository.
• Well versed in using the security settings in OBIEE Administration Tool to set up Groups, Access Privileges and Query Privileges.
• Experience in Oracle BI Apps that include OBIEE/Siebel Analytics, ETL Tools and DAC in Banking, Financial, Supply Chain, Procurement and Spend and Manufacturing domains.
• Customized and configured OBIEE application using OBIEE Answers, OBIEE iBots, OBIEE Dashboards, BI Publisher and Administration Tool.
• Good understanding of Ralph Kimball approach and experience in Dimensional data modeling, Star schema modeling, Snow-Flake modeling, identification of fact and dimension tables, Normalization, Physical and Logical data modeling.
• Experience in developing Dimensional Hierarchies/Level based Hierarchies/New logical columns/Filters/Variables per business requirements.
• 6 years extensive experience and knowledge in Siebel Design, Upgrading and Development including Business Modeling, Requirements Gathering, Analysis, Configuration, Testing, Administration and Deployment for Siebel Enterprise (Siebel CRM as Front End application).
• Worked on Informatica tool’s Source Analyzer, Target Designer, Transformation Designer, Mapplet Designer and Mapping Designer.
• Experience in managing data loads and configuring DAC with Oracle Business Application. Monitoring mapping loads and Workflow management
• Involved in Business gathering requirement in designing data-marts, technical report specifications and functional requirements
• Experience in Business analysis in Manufacturing & Banking domain on OBIEE/ OBIA
• Presales experience in conducting demos, RPF, RFI on OBIEE and OBI Aps
• POC’s for specific client requirements
• Comparison study of functionalities of OBIEE with other analysis tool for specific gap-analysis requirements
• Coordination with Oracle vendor for user licenses
• OBIEE/OBI Aps solution strategies
• Constant documentation on OBIEE/OBI Aps up gradation
• FTE estimation for Development and support projects

TECHNICAL SKILLS

Operating Systems: Windows 2000/NT/UNIX

Business Intelligence & Publisher tool: Siebel Analytics 7x, OBIEE 10x, OBIEE 11.1.1.7, OBI-Aps 7.9.6, BI-Publisher

ETL/Data warehouse: Informatica 9.1, ODI 11g, DAC 11.1.6.4

CRM tools: Siebel Tools 6.0, 7.5 & Siebel Analytics

Database/SQL: MS SQL Server 2000, Oracle 9.i, Oracle 10g, Oracle 11gPL/SQL, SQL toad & Analyzer

PROFESSIONAL EXPERIENCE

Confidential, New Jersey

OBIEE Senior Developer/Designer

Responsibilities:

• Was responsible for design, development and management of daily, weekly and monthly reports, extensively used OBIEE (11.1.17) for generating web based audit reports for various executive and management individuals.
• Extensively used Oracle Business Intelligence Administration Tool for customizing and modifying the physical, business and presentation layers of the metadata repository.
• Used the Security settings in Oracle Business Intelligence Administration Tool to set up groups, access privileges and query privileges.
• Specified aggregate levels for each source and created dimension sources for each level of aggregates.
• Configured Logical Layer, Created Logical tables/dimensions, columns, Created Logical Joins/keys, Set levels to support Drill-down, Aggregation, Level based hierarchies and Parent-child hierarchies
• Used Filters and provided Customized prompts appropriately to avoid excessive data showing up Reports.
• Managed security privileges for each subject area and dashboards according to user requirements.
• Created iBots and Delivers to send Alert messages to subscribed users.
• Did configurations for OBIEE (Multi User Development MUD, Usage tracking, iBot (scheduling), Security Model using LDAP authentication) and Bi Apps (Roles, responsibilities, security model)
• Developed different kinds of Reports pivots, charts, tabular using global and local Filters.
• Configured and administered existing subject areas and created new subject areas to include new Star Schema information.
• Responsible for designing new fact table for Audit trail transactions.
• Created data warehouse tables and implemented snowflake schema in OBI Administration tool.
• Customization of OOTB reports for Global planning and Costing.
• Work closely with end users to designing reports & dashboards, suggesting better ways of reporting in OBIEE so that required information is visualized by end users.
• Integrated Action Framework for a customized report which involved to invoke a business process, and KPI Scorecard for KPI evaluation
• Developed Reports/Dashboards with different Analytics views (Drill down/ Dynamic, Pivot table, Chart, Column Selector, with global and local filters) using Oracle BI Presentation services. Also worked on Chart and graphs integrated with Map server
• Documented all the configurations and new reports creation and published it to the end users.
• Involved in the preparation of Technical design documents, Source to target (S2T) document, Review checklist, Detail design document and Technical Specifications.
• Created proper documentation to describe program development, logic, coding, testing, changes and corrections.

Environment: APCC, Oracle EBS, Informatica 9.1, Oracle 11g, OBIEE 11g

Confidential, Michigan

Sr. OBIEE Consultant

Responsibilities:

• Involved in business meetings and working closely with the business analysts to gather user requirements, did thorough Data Analysis. Based on the requirements identified the scope of new data, confirming dimensions between new and existing Warehouse tables, Drill Downs and data security and developed the business requirement document.
• Performance ETL tuning, ETL Administrative tasks
• Implemented Snapshot process for persevering history data
• Daily health check on ETL mappings, OBIEE reports and WebLogic administration
• Worked on Informatica Source Analyzer, Warehouse Designer, Mapping Designer & Mapplet, and Transformations. Created Informatica Mappings to build business rules to load data using transformations like Source Qualifier, Aggregator, Sorter, Expression, Joiner, Connected & Unconnected lookups, Filters, Sequence, External Procedure, Router and Update strategy.
• Developed mappings and Mapplets using Informatica Designer to transform and load the data from source database into the target database.
• Developed re-usable transformations, mappings & Mapplets conforming to the business rules.
• Created Custom SDE Adaptors and built new Subject areas and Execution Plans in DAC for new customized subject area.
• Involved in development of Informatica mappings and also in tuning of mappings and workflow management for better performance.
• Developed new dimensions, facts and aggregate tables. Worked on Physical, BMM and Presentation layer of the Oracle Business Intelligence Admin tool to create the physical and business model diagram and the logical hierarchies.
• Created logical tables and defined the complex joins for a business model.
• Created groups in the repository and added users to the groups and granted privileges explicitly and through group inheritance using the Security settings in Oracle Business Intelligence Administration Tool.
• Performed Consistency Check and Global Consistency Check of the Business Model before exposing Business Models in the Presentation Layer considering errors, warnings and best practices.
• Building interactive and selective data reports (pivots, charts, tabular) using concepts such as filters, column selectors, global prompts and extensively used repository and presentation variables.
• Developed custom reports/Ad-hoc queries using OBIEE and assigned them to application specific dashboards
• Used Informatica Mapping Designer to create/update mapping using different transformations required to move data into data warehouse.
• Created workflows for full load and incremental loads to be used by DAC.
• Monitoring Incremental & Full load through DAC.
• Imported tables and mappings into DAC and configured to the respective subject area
• Assembled subject areas and created execution plan & accommodated the new Informatica mappings.
• Designed the implementation of ETL and OBIEE for Procurement & Spend, Supply chain and Finance module

Environment: Oracle EBS, Informatica 9.1, OBIEE 11g, Oracle 11g

Confidential

OBIEE/BI Publisher developer

Responsibilities:

• Onsite lead: Assigning incidental tickets and involved in analyzing the requirement for Releases
• Performed Project Scoping, Project Organization and Management including Business & IT Requirements, Priorities, and Project Execution Plan & Resource Planning.
• Building interactive, selective data reports (pivots, charts, tabular) using concepts such as filters, column selectors, global prompts and extensively used repository and presentation variables.
• Developed custom reports/Ad-hoc queries using OBIEE and assigned them to application specific dashboards
• Actively involved in gathering business requirements and performing GAP analysis.
• Migration of .rpd and web-catalog files
• Modification to the batch files which imports data from the transaction system (Flexcube)
• Used BI Plug with MS Office integration for BI Publisher reporting purpose. Created templates and invoice format for Purchase order and account transaction information
• Modification to the Data template used in BI Publisher to get the right logic
• Build reports on BI Publisher based on SQL queries direct stream
• Build opaque views to the existing schema for new reports in the rpd
• Conducted basic hands-on user/administration training for the client team

Environment: Flexcube, OBIEE 10.1.3.4.1 , Oracle 9i

Confidential

Oracle Business Intelligence

Responsibilities:

• Demonstration of OBI products to the prospective clients
• Technical Design architecture
• Detail design documentation
• ETL Mapping documentation & designing the Logical and Physical Data marts
• Designing the Metadata definition
• Conducting POC (proof of concept)
• Defining the Security authentication & performance strategies
• Estimation for the Implementation cost
• Requirement Analysis and gathering
• Functional documentation
• Initial productive demonstration of OBIEE & OBI-Publisher thru Remote
• Gathered Business requirements by interacting with the business users, defined subject areas for analytical data requirements.
• Developed the project plan for the implementation that identified the schedule, tasks, milestones and requirements
• Developed technical design document for audit review
• Product demonstration and their functionalities
• Requirement gathering for Finance and SCM.
• Show cased sample reports using the inbuilt sample .rpd and webcatalog
• Developed project plan for the implementation that identified the schedule, tasks, milestones and requirements
• Gathered Business requirements by interacting with the business users, defined subject areas for analytical data requirements.
• Developed technical design document for audit review
• Installation of OBI-Aps 7.9.5 and configured with Pre-built mappings in ETL and DAC.
• Executed Initial Full load from JD Edwards (OLTP) to the prebuilt Dashboard/reports
• Integrating data from a wide array of functional areas in HR & Finance, presenting the best tools available to better source high quality applicants, and to reduce employee retention and absence costs.
• Primarily involved in designing the logical modeling for 5 data marts.
• Responsible for the development & deployment of RPD using OBIEE Admin Tool for reporting purpose.
• Responsible for the development of custom reports and dashboards in OBIEE.
• Responsible for customization of built-in ETLs and RPD.
• Responsible for modifying of all the three layers in the OBIEE RPD.
• Excellent understanding of implementing Authentication & data level security in OBIEE.
• Coordinate product management & strategy team for ensure technical feasibility of business requirement document & functional design documents through conference call.
• Involved in the development & customization of Star-Schema data model.
• Coordinating between offshore team members and onsite business analysts.
• Review the SQL queries and Mappings and suggested changes to ensure the optimal performance
• Design the testing strategy to ensure the functionality and performance.