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 and OBIA
• OBIEE/OBIA consulting in implementation, Technical solution, Project planning, Installation, Configuration & Development experience in OBIEE 10g & OBIEE 11g
• Good noledge 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 teh physical, business and presentation layers of teh metadata repository.
• Well versed in using teh 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.
• 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 noledge 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.me, Oracle 10g, Oracle 11g, PL/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 teh physical, business and presentation layers of teh metadata repository.
• Used teh 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 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 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 teh configurations and new reports creation and published it to teh end users.
• Involved in teh 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

Sr. OBIEE Consultant

Responsibilities:

• Involved in business meetings and working closely with teh business analysts to gather user requirements, did thorough Data Analysis. Based on teh requirements identified teh scope of new data, confirming dimensions between new and existing Warehouse tables, Drill Downs and data security and developed teh 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 teh data from source database into teh target database.
• Developed re-usable transformations, mappings & Mapplets conforming to teh 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 teh Oracle Business Intelligence Admin tool to create teh physical and business model diagram and teh logical hierarchies.
• Created logical tables and defined teh complex joins for a business model.
• Created groups in teh repository and added users to teh groups and granted privileges explicitly and through group inheritance using teh Security settings in Oracle Business Intelligence Administration Tool.
• Performed Consistency Check and Global Consistency Check of teh Business Model before exposing Business Models in teh 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 teh respective subject area
• Assembled subject areas and created execution plan & accommodated teh new Informatica mappings.
• Designed teh 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 teh 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 teh batch files which imports data from teh 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 teh Data template used in BI Publisher to get teh right logic
• Build reports on BI Publisher based on SQL queries direct stream
• Build opaque views to teh existing schema for new reports in teh rpd
• Conducted basic hands-on user/administration for teh client team

Environment: Flexcube, OBIEE 10.1.3.4.1, Oracle 9i

Confidential

OBIEE/BI Publisher developer

Responsibilities:

• Demonstration of OBI products to teh prospective clients
• Technical Design architecture
• Detail design documentation
• ETL Mapping documentation & designing teh Logical and Physical Data marts
• Designing teh Metadata definition
• Conducting POC (proof of concept)
• Defining teh Security authentication & performance strategies
• Estimation for teh 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 with teh business users, defined subject areas for analytical data requirements.
• Developed teh project plan for teh implementation dat identified teh schedule, tasks, milestones and requirements
• Developed technical design document for audit review

Confidential

OBIEE/BI Publisher developer

Responsibilities:

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

Confidential

OBIEE/BI Publisher developer

Responsibilities:

• Teh upgrade is targeted to be a “lift and load” approach.
• Teh deployment must be designed to minimize business impact, both from system availability and core workflow processing perspectives.
• Teh upgrade should not be viewed as just a core application upgrade. Focus needs to include change management (me.e., communication, ).
• Designs must consider improving system performance (e.g., technical architecture, configuration designs).
• Strict change control guidelines will be required during teh 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 teh Hartford source to teh IDC source and troubleshooting any VMWare issues.
• Involved in migrating Visual SourceSafe to PVCS and configuring teh db’s.
• Managing and administering teh 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 teh Business intelligence team for any requirement analysis.

Confidential

OBIEE/BI Publisher developer

Responsibilities:

• Involved in assisting and gathering teh required information for Performance Testing.
• Dialing teh Daily calls and discuss about teh daily Test Status with teh Onsite Counterpart.
• Involved in Performance script Validation, Recording, and Debugging. Involved in Load and Stress Test.
• Performance Defect tracking by using Test Director 8.0 and Excel sheet.
• Preparation of Daily Status Report.
• Enter teh Global Delivery Dashboard sheet as per week.
• Designed an existing Interfa