PROFESSIONAL SUMMARY:

• Overall 12 + Years of experience in IT industry and Last 6.5 years in OBIEE - Oracle Business Intelligence Enterprise 10G, 11g - Siebel Analytics, ETL Informatica 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
• Implemented authentication provider in Web logic enterprise manager
• Administering and managing Web logic components for OBIEE repositories and web catalog, User & groups, Application roles and application objects. Trouble shooting web logic server issues and investigation for server logs and diagnostic processes
• Good working experience 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
• Experience in creating ODI scenarios and ODI load plan to implement integration with OBIEE11g Action framework
• Experienced in scheduling OBIEE reports using iBots and cache technology
• 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.
• 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.
• Good experience in managing data loads and configuring DAC with Oracle Business Application. Monitoring mapping loads and Workflow management
• 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, Greensboro NC

OBIA Senior Developer

Responsibilities:

• Responsible for MSP4 release activities for Sales performance metrics, right now from requirement gathering and detail design documentation process
• Organizing team planning sessions and building strong working relationships with cross functional teams
• Document the changes\new requests determined after discussion with Business Users into a Business Requirements Document.
• Translated business questions and requirements into conceptual and UI application models for the Technical Dashboard developers
• Liaising with Business users to develop BI solutions
• Detail understanding of Siebel transaction tables for ETL design, transformation rules, and configuration of DAC for new added columns as per of releases.
• Constant interaction with business stake holders for requirement gathering and analysis
• Detailed level of Unit testing for newly created metrics right from OLAP to OLTP
• Pre-study for OBIEE mobility and suggested implementation design. Implemented Dashboard designer or few mobile users as part of POC
• High level of code review and ascertainment of Unit test cases
• Worked on very tight deadlines and aggressively for completion of the project

Confidential, New Jersey

OBIA Senior Developer

Responsibilities:

• Responsible for design, development and management of daily, weekly and monthly reports, extensively used OBIEE (11.1.1.7) for generating web based audit reports for various executive and management individuals.
• Merge and Migrations - OBIEE Repository and Catalogs as well as BI Publisher reports merge and migrations
• Monitoring - Monitoring the overall OBIEE usage on server and capture the usage spikes etc to improve the performance
• 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.
• Implemented Act as functionality for proxy users
• 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.
• Implemented and configured 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

OBIEE & Informatica consultant/Administrator

Responsibilities:

• Conducted and monitored 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.
• 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.
• Developed BI Publisher reports for Purchase order invoices and used
• 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 for the client team

Environment: Flexcube, OBIEE 10.1.3.4.1, Oracle 9i

Confidential

Siebel Administrator/Architect

Responsibilities:

• Installation and Configuration of Siebel 8.0 & OBIEE 10.1.3.3 on the development servers
• Integrated AIACOM 2.0.1 with Siebel 8.0 with oracle brm.
• Involved in requirement gathering for OBIEE for the Billing and Revenue Management reporting methodology
• Implemented ADSI security adapters on OLTP (Siebel CRM & Oracle BRM) & OLAP (OBIEE) servers
• Conducted administrative activities on the OLTP & OLAP servers right from upgrading of the servers, setting up Single-Sign on, user administration, etc
• Conducted basic hands-on administration for the client team of 3 administrators

Confidential

Siebel senior consultant

Responsibilities:

• The upgrade is targeted to be a “lift and load” approach.
• The deployment must be designed to minimize business impact, both from system availability and core workflow processing perspectives.
• The upgrade should not be viewed as just a core application upgrade. Focus needs to include change management (i.e., communication, ).
• Designs must consider improving system performance (e.g., technical architecture, configuration designs).
• Strict change control guidelines will be required during the freeze period.
• Identified system enhancements will be moved to a “parking lot” list, unless there is clearly no impact to timeline, resource loading or technical complexity / risk.
• Project Management: Organizing necessary infrastructures for network connectivity from the Hartford source to the IDC source and troubleshooting any VMWare issues.
• Involved in migrating Visual SourceSafe to PVCS and configuring the db’s.
• Managing and administering the Client - offshore share points and ensure proper document updation.
• Single point of contact for any technical issues related with offshore project team members.
• Cordial interaction with application, interface, and the Business intelligence team for any requirement analysis.

Confidential

Module lead cum offshore coordinator

Responsibilities:

• Involved in 0701 release in built phase and designing.
• Created ETL mappings for the present requirements.
• Involved in functional requirement documentation.
• Created star scheme involving dimension-modeling concepts.

Confidential

Analytics developer

Responsibilities:

• Customizations and developments on Siebel Analytics rpd at BML and PRL Layers in order to enable report requirements.
• Setting up Dim Hierarchies and related activities for functionalities like Drill Down, Navigation etc.
• Worked on configuring objects for Mobile users (Offline) Real time data.
• Trimmed the rpd & webcat objects for Mobile (Offline) users.
• Helped in assisting to introduce concept of “Bundle” which was mainly for a specified region, which involved new development in rpd.
• Conducted throughout testing using the configured mapping fields for Bundle under various business scenarios.
• Retested several defects and implemented possible fixes.

Confidential

Test lead cum Developer

Responsibilities:

• Involved in creating Test Scripts for Regression Testing and Product testing and performing the same.
• Assisted the team in understanding the reports functionalities and recreated the scripts for the business.
• Worked on defects related to the earlier releases and understood the new requirement functionalities to bug fix after the various tests. Involved in creating web groups and assigning the appropriate users. Involved in checking the mapping between the systems.