SUMMARY

• 8+ years of Complete Software development Life cycle (SDLC) (gathering Business Users Requirements, System Analysis, Design & Data Modeling, Development, Testing) implementation experience of Data Warehouse, Data Mart and Business Intelligence using Siebel Analytics/ OBIEE.
• Experience in identifying & analyzing the source/feeder systems, identifying GAPS and providing appropriate solutions.
• Very strong in OBIEE/Siebel Analytics Admin Tool, Analytics Web, Presentation Services, Delivers and Publisher.
• Expertise in developing Oracle BI/Siebel Analytics Repository consisting of three layers (Physical Layer, Business Model & Presentation Layer Good in validating the BI reports/dashboards by preparing the Test Plans & Cases.).
• Expertise in providing end - to-end business intelligence solution by dimensional modeling design, building business models, configuring metadata, Answers, Delivers/iBots, creating Interactive Dashboards with drill-down and drill-across capabilities, Security (groups, access/query privileges), Web Catalog Objects (Dashboard, Pages, Folders, Reports), cache monitor, Job Manager, Catalog Manager and building Repository consisting of three layers (Physical Layer, Business Model & Presentation Layer) using Oracle BIEE/Siebel Analytics.
• Expertise in creating Calculation Measures and Dimensions, using Initialization Blocks and Variables (Session and Repository), creating aggregate tables, adding multiple sources, executing direct Database requests, Implementing Siebel Security Setup (groups, object and data level), LDAP, External Tables, Single sign on etc.
• Experience serving industrial segments like Sales, Marketing, Finance and Service in business related to implementation of ERP and BI Solutions.
• Expertise in fine tuning reports by using view selector, column selector and prompts, where ever necessary to increase performance.
• Expertise in debugging and optimizing the Oracle BI/Siebel Analytics Dashboards/Reports and Informatica Mappings/Workflows
• Expertise in enhancing performance of Reports / Dashboards by implementing the Aggregate tables, Materialized Views, Table execution path by making use of hints, Creation / Re-building of Indexes and managing Cache etc.
• Involved in implementing prebuilt solutions in converting data from ERP systems like Siebel CRM into Oracle provided data warehouse(OLAP-BAW)
• Extensive experience in developing Informatica Mappings/Mapplets using various Transformations for Extraction, Transformation and Loading of data from Multiple Sources to Data Warehouse and creating Workflows with Worklets & Tasks and scheduling using both Workflow Manager and Unix Shell scripts.
• Performance tuning of Oracle BIEE/Siebel Analytics Repository, Analytics Dashboards/Reports, Informatica Mappings/Mapplets and Oracle programs.
• Working Knowledge of Disconnected Analytics and BI Publisher.
• Good in validating the BI reports/dashboards by preparing the Test Plans & Cases.
• ImplementedUsage trackingto analyze and tune the query performance.
• Upgrade and Deployment experience from Siebel Analytics 7.x to Oracle BI 10.1.3.x
• Very strong in Oracle PL/SQL programs, Procedures, Packages, Functions, Triggers and other objects.
• Excellent communication skills and experience working with business users and leads/managers with strong analytical & problem solving skills and a quick learner of new technologies and concepts.

TECHNICAL SKILLS

BI Tools: Oracle BIA 7.9.x, OBI EE 10.1.3.x, Siebel Analytics 7.8/7.7/7.5, BI Publisher 10.1.3.x

CRM: Siebel 7.x/8.x, Siebel Tools

ERP: Oracle e-Business Suite 11i (HR, GL, AP, AR, SCM)

ETL Tools: Informatica 8.x/7.x/6.x, DAC 7.9.5/7.7

Database: Oracle 11g/10g/9i/8i, DB2, Teradata, MS-SQL Server 2000/05, MS-Access

Dev Languages: SQL, PL/SQL, Java, Perl, Korn Shell Scripting, Visual Basic, XML, HTML, DHTM

OS: IBM-AIX, HP-UX, Windows XP/2000/NT, Sun Solaris, RHEL, MS-DOS

PROFESSIONAL EXPERIENCE

Confidential, NY

Sr. OBIEE Developer

Responsibilities:

• Participated in gathering and analyzing the Business Requirements in collaboration with the Sales, Marketing and Finance Subject Matter Experts (SMEs), Business Analysts and Users.
• Developed and customized the Oracle BIEE Metadata repository (.rpd) model by creating connection pools, physical / Alias Tables, defined joins and implemented authorizations in the physical layer, aggregates, dimensions, hierarchies & time series functions in the BMM Layer, catalogs & folders in Presentation Layer using Oracle BI Administration tool.
• Identified the aggregate levels for measures and created dimension hierarchy sources for each level of aggregates for performance enhancement.
• Developed and customized executive level dashboards and reports in various views such as Pivot Table, Charts, View Selectors, Column Selectors, catering to provide insight into the Sales / Marketing / Financial data.
• Created different types of Reports (Drilldown, Aggregation, Levels) to meet business requirements. Generated various Analytics Reports like Formulary Report, Union Report and Direct Sales Report using global and local filters.
• Implemented security by creating users & web groups, setting up External Table Authentication, creating Session Variables and Initialization Blocks and associating catalog objects and Web modules with the created groups.
• Utilized Oracle Delivers for sending real-time, personalized alerts via intelligence agents (iBots) to subscribed users.
• Performed Performance Tuning of Dashboards / Reports by aggregate navigation, cache management, Oracle materialized views and making changes to reports.
• Integrated OBIEE Presentation Layer with BI Publisher and provided the capability to download the reports in the user defined formats.
• Worked on Multi-User Environment (MUDE) by merging and importing multiple projects.
• Created comprehensive and easy-to-understand Documentation of the complete implementation of the Customer Sales Business modules (Reports, Dashboards, Security and Star schema).
• Worked extensively on BI Answers & BI Publisher to create the reports as per the business requirements
• Implemented Usage tracking reports which read statistics from the usage tracking database. These reports helped identify performance bottlenecks for further tuning.
• Configured iBots to deliver Analytics content based on schedule, automated iBot queries to obtain weekly reports.
• Worked with Catalog Manager tool.
• Created the OBIEE environment for Development, QA and Production environment.
• Participated in complete life cycle of the project from project initiation, to development, to production support and maintenance.
• Identified complex bugs in production and resolved them.

Environment: Oracle Business Intelligence (OBI) EE 10.1.3.x, BI Publisher, Oracle 10g, Linux, TOAD

Confidential, MA

OBIEE Consultant

Responsibilities:

• Participated in requirements gathering of the various work streams by meeting with the business user and base lining the details.
• Requirement analysis, Designed and implemented custom business intelligence solutions (Metadata and Dashboards/Reports) using the Siebel / Oracle Business Intelligence (OBI) Analytics platform.
• Performed the detailed design of Reports / Dashboards, Analytical Data Model (Metadata / .rpd) and performed Fit/Gap Analysis between existing Sales, Call center reports and new requirements.
• Developed the repository model for the different work streams with the necessary logic that involved creating the Physical, BMM and the Presentation layer, customized the existing model and Created hierarchies, variables, and event poll strategies in the repository.
• Developed and customized OTB reports and new Reports, cosmetic changes to Dashboards with different subject matter Views (Drill-Down / Dynamic, Pivot Table, Chart, Column Selector, Tabular with global and local Filters) using Siebel Analytics Web / Oracle Business Intelligence (OBI) Presentation Services for the various work streams and sales force.
• Enhance performance of Reports / Dashboards by implementing the Aggregate tables, Materialized Views, Table execution path by making use of hints, Creation / Re-building of Indexes and managing Cache etc.
• Created Week Ago and Month Ago and Year Ago Fact Measures and Dimension attributes.
• Created and customized reports with different views - Table, Pivot Table, Charts, Column Selector, etc using Answers
• Performed upgrades from Siebel Analytics 7.8.x to OBIEE 10.1.3.x.
• Managed Security privileges for each Subject area and Dashboards according to user requirements.
• Configured and automated iBots to deliver Analytics content.
• Customized OTB mappings for Financial Analytics, Procurement and Spend Analytics.
• Prepared the Test Plans and Test cases for validating the reports/dashboards.
• Written many SQL statements for validating the reports and used the same in Test documents.
• Created new mapping for extension and bridge tables that were not supported in OTB.
• Created the OBIEE environment for Development, QA and Production environment.
• Participated in complete life cycle of the project from project initiation, to development, to production support and maintenance.
• Identified complex bugs in production and resolved them.

Environment: Oracle Business Intelligence (OBI) EE 10.1.3.x, OBI Publisher, Oracle 10g, Linux, TOAD

Confidential, WI

OBIEE Consultant

Responsibilities:

• Interacted with the business users to gather reporting requirements to provide focus on Inside Sales and Call Center groups mainly focusing on Service Requests and Sales Analytics.
• Worked extensively with Physical Layer, Business Layer and Presentation Layer to customize the existing business models and also developed new models.
• Customized the Sales Branding dashboard by adding in new products and Finish Sales Trend Dashboards.
• Developed new Dashboards and Reports in addition to existing OTB, for users through Siebel Analytics Web.
• Added the functionality of customer segmentation by providing different dashboard prompts and page prompts and which new RPD models also supported.
• Performed mapping gap analysis between existing OTB mappings and already existing tables to support the new requirements.
• Developed complex new Informatica ETL process and Mappings & Mapplets using various Transformations (Update Strategy, Filter, Router, Expression, Stored Procedure, Lookup, and Aggregator) and Workflows with Sessions / Tasks.
• Worked with Informatica Power Center tools -Source Analyzer, Data warehousing designer, Mapping Designer & Mapplet, Transformations, Work Flow Manager (Task Developer, Worklets, and Work Flow Designer) and Work Flow Monitor.
• Created custom Mappings, Mapplets to load the new tables and the new information into the warehouse
• Customized the OUT of the box ETL mappings for Financial Analytics, Order Management and Fulfillment Analytics.

Environment: OBIEE 10g, Oracle 9i, Informatica 7.1.3, Windows XP

Confidential, WI

OBIEE Developer

Responsibilities:

• Gathered and documented Business Process Requirements from Business Users.
• Analyzed and recommended enhancements to Metadata Reporting in all 3 layers (Physical, Business and Presentation) for Sales Analytics, Financial Analytics and Order Management and Supply Chain Analytics by modifying the existing OTB models and creating new models to support the business.
• Modeled pertinent data in Star Schema forms thereby avoiding the inconsistencies and performance issues with Snowflake schema.
• Worked extensively on Business and Presentation layers for Revenue and Service Requests stars.
• Customized and developed repository, configured metadata objects (Subject Area, Table, Column) and Web Catalog Objects (Dashboard, Pages, Folders, Reports) by adding in extended columns or customizations to Siebel systems.
• Enhanced existing Business Models & customizations to existing OTB Year over Year Analysis and Regional Analysis and also created new Dashboards for revenue ratio reports for providing visibility in North America and Asia Pacific regions.
• Involved in migration of OBIEE from 7.8 to 10g..
• Configured iBots to deliver analytics content based on schedule, automated iBots queries to obtain weekly reports & sent notifications Alerts to Managers.
• Implemented Security by creating roles & web groups, which included Authentication to LDAP, which was SSO for Siebel and Analytics environment, and Authorization to external table where roles and responsibilities were stored.
• Configured existing dashboards, metadata objects and report level security to set up position based functional dashboard access.
• Modified the mappings to customize OTB mappings to in corporate new columns in Dimension and Facts tables.

Environment: OBIEE 10g, Siebel analytics 7.7, Oracle 9i

Confidential

Database Developer

Responsibilities:

• Worked as a technical support for a team that involved technical & quality reviews of program codes and PL/SQL blocks for optimization and maintaining standards & guidelines
• Developed Database Triggers in order to enforce complicated business logic and integrity constraints, and to enhance data security at database level
• Developed Custom forms to view edit the data in custom interface tables and event handling tables using Template forms.
• Completed database architecture including developing stored procedures and functions in order to create Shortcuts to frequently repeated tasks
• Promoted the new code to production through unit and system testing.

Environment: Windows NT Client/Server, Oracle 8i, Developer 2000 (Rel. 2), SQL*Plus, SQL, PL/SQL.