PROFESSIONAL SUMMARY:

• Overall 13 + 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 wif E-CRM Siebel
• In-depth understanding of RPD configuration, Load balancing & Security model
• Implemented LDAP authentication wif 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 wif 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 dat 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 wif 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 wif other analysis tool for specific gap-analysis requirements
• Coordination wif 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 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.
• 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 wif end users to designing reports & dashboards, suggesting better ways of reporting in OBIEE so dat 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 wif different Analytics views (Drill down/ Dynamic, Pivot table, Chart, Column Selector, wif global and local filters) using Oracle BI Presentation services. Also worked on Chart and graphs integrated wif 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, USA

OBIEE & Informatica consultant/Administrator

Responsibilities:

• Conducted and monitored business meetings and working closely wif 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 wif 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

OBIEE/BI Publisher developer

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

Confidential

OBIEE/BI Publisher developer

Responsibilities:

• Initial productive demonstration of OBIEE & OBI-Publisher thru Remote
• Gatheird Business requirements by interacting wif the business users, defined subject areas for analytical data requirements.
• Developed the project plan for the implementation dat identified the schedule, tasks, milestones and requirements
• Developed technical design document for audit review

Confidential

OBIEE/BI Publisher developer

Responsibilities:

• 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 dat identified the schedule, tasks, milestones and requirements
• Gatheird Business requirements by interacting wif 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 wif Pre-built mappings in ETL and DAC.
• Executed Initial Full load from JD Edwards (OLTP) to the prebuilt Dashboard/reports

Confidential

OBIEE/BI Publisher lead

Responsibilities:

• 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.

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 wif Siebel 8.0 wif 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 their 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 wif offshore project team members.
• Cordial interaction wif 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.