Summary

• Sam has over 8 years of experience in IT involving gathering Business Requirements, GAP Analysis, Data Modeling Design, Development, Testing, Implementations and Documentation of various functionalities of Data Warehouse / Data Marts.
• Nearly 5 years of experience in OBIEE (Siebel Analytics) Architecture and Reporting.
• Proven skills in complete lifecycle of Design, Analysis, Development, and Implementation of Business Intelligence with Star and Snow flake Schemas using Kimball and Inmon Methodology using OBIEE, Siebel Analytics 7.x and Informatica 7.x/6.x
• Experienced in Data Analysis, Identification of dimensions, Facts, Measures and Hierarchies
• Extensive experience in providing end-to-end BI solution by dimensional modeling design, Logical/Physical models, building/configuring RPD, Answers, Delivers / iBots, creating reports / Dashboards, Cache management, and setting up Security using LDAP Authentication and Basic RPD Authentication
• Experience configuring Interactive Dashboards with drill-down and drill through capabilities using global and local Filters, OBIEE Security Setup (groups, access / query privileges), Metadata Objects and Web Catalog Objects (Dashboard, Pages, Folders, Reports)
• Very strong 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 & various Tasks and scheduling them using both Workflow Manager
• Good at database Performance Tuning of Data Warehouses by implementing the materialized views, bitmapped indexes and partitions
• Very strong in writing, testing and implementation of the triggers, stored procedures, functions, packages at database level using Oracle PL/SQL
• Proficient in working on production and development environment in different RDBMS (in Oracle 8i/9i, SQL Server) and strong troubleshooting skills
• Extensive experience in business process reconciliation, design, configuration, testing, quality analysis and production support
• Excellent interpersonal and communication skills, and is experienced in working with senior level managers and developers across multiple disciplines.

Education

M.S in engineering

TECHNICAL SKILLS:

Reporting Tools: OBIEE 10.1.3.4.1/Siebel Analytics 7.x, Presentation Services/Siebel Analytics Web, Siebel Answers, Dashboards, i-BOTs

Data warehouse Tool: Informatica Power Center/Power Mart 8.1/8.6.0/ODI/SAP7.10 BW/MM,SAP, SAP BO, SQL*Loader

Relational Databases: Oracle 8i/9i/10g/11g ,My SQL, IBM DB2, SAP

Testing Tools: HP Quick Test Professional

Database Languages: SQL, PL/SQL, UNIX

Operating Systems: Windows XP/2000/NT, UNIX, Linux

Functional Areas: Sales, Finance, Marketing

Subject Area: Opportunity, Quote, Booking, Forecast and Goal, Invoice, Backlog, Shipment, Revenue

Professional Experience :

Confidential, MA March11 to Till Date
Sr. OBIEE Developer
The Case Management Analytics solution will enhance decision-making process regarding Operation Enhancements. The system will allow Customer Relation Management Team to perform data analysis and track the solutions provided to subscribers.
Responsibilities:

• Interacted with business representatives for gathering the Reports / Dashboards requirements and to define business and functional specifications
• Designed and developed the OBIEE Metadata Repository (.rpd) using OBIEE Server Admin tool by importing the required objects (Dimensions and Facts) with integrity constraints into Physical Layer using connection pool, developing multiple Dimensions (Drill-Down Hierarchies) & Logical & Facts / Measures objects in Business Model Layer, and creating the Presentation catalogs in Presentation Layer
• Connected data sources for Customer to Financial Management in OBIEE
• Developed the repository in OBIEE designing the physical layer, building the business model and mapping for the repository and finally the presentation layer with deployment
• Developed many Operation Solutions Time Series objects for comparing the usage variations between the quarters
• Developed many Reports / Dashboards with different Analytics Views (Drill-Down / Dynamic, Cascading Style Sheets, Pivot Table, Chart, View/Column Selector, Tabular with global and local Filters) using Presentation Services
• Configured iBots to deliver content based reports on schedule, automated iBot queries to obtain daily and weekly reports
• Designed prototype screens and integrated with existing platform using APEX
• Implemented security by creating roles & web groups, checks with LDAP Authentication
• Involved in developing Initial and Incremental ETL process i.e., Mappings & Mapplets using various Transformations and Workflows with Sessions / Tasks. Executed the workflows through shell scripts using pmcmd
• Developed many PL/SQL procedure & functions and used the same in mappings, pre and post sessions
• Performance Tuning of Dashboards/Reports and made changes to database by implementing the materialized views, partitions, re-building of indexes, overwriting the sql execution path by making use of hints etc.,
• Performed Unit, Integration, and Regression testing to validate report and mapping functionality
• Worked closely with Users, Developers and Administrators to resolve ongoing Production Problems by reviewing design changes made to production systems and made corresponding changes to the OBIEE Repository.

Environment: OBIEE 10.1.3, Informatica 7.1, ODI ,Oracle 11g, SQL, PL/SQL, TOAD, APEX

Confidential,Atlanta, GA Sep 09 to Feb 2011
OBIEE Application Architecture Consultant

The goal of this project is to implement a data mart as a single repository for Enterprise wide data and enhance business processes to capture sales, marketing, and finance data to enable reporting. The DM is a consolidation of different sales reporting systems and provides Multidimensional Reporting of Opportunity, Quote, Order Bookings, and Forecast and Goal, Invoice, Backlog, and Shipment data for the Sales, Marketing, and Finance Organization. The Reports were developed to cater the needs of all levels of organization, from Executives & VPs (Analytical) to Sales Representatives (Operational).

Responsibilities

• Gathering, Analyzing and identifying the Gap of Business Reports Requirements.
• Analyze data model and requirements from an Application Architecture Repository and Framework standpoint.
• Responsible for creating a prototype of the application, create the Functional Requirements Document (FRD), and demo the prototype to the end users for sign off
• Identified Facts and Dimensions (with levels & hierarchy) and developed OBIEE Repository (RPD) at 3 layers i.e., Physical Layer (connecting Data sources & import schema), Business Model / data mapping (create Logical tables & data source mapping) and Presentation Layer level (create presentation catalogs), create presentation folders, test and validate the model.
• Created repository, session variables, and initialization blocks for security and dynamic time periods.
• After creating and deploying the repositories, created analysis in OBIEE
• Set Aggregate Navigation for all aggregate fact tables in the BMM layer.
• Developed many Analytical and Operational reports using different Analytics Views (Pivot Table, Chart, Column Selector, and Narrative View), Dynamic / Interactive Dashboards with drill-down and drill through capabilities, charts, tabular using global and local Filters. Extensively used Siebel Delivers and iBots.
• Implemented Security by creating roles, web groups, and external tables.
• Coordinated the Analytics RPD and Web Catalog objects migration from Dev environment to QA environment and to the Production environment.
• Developed the Initial and Incremental / Delta ETL process i.e., Mappings & Mapplets using various Transformations for new objects.
• Performed Unit, Integration and Regression testing to validate reports and mappings.
• Involved in developing the Incremental ETL process i.e., Mappings & Mapplets using various Transformations and Workflows with Sessions / Tasks. Executed the workflows through shell scripts using pmcmd.
• Worked closely with Users, Developers and Administrators to resolve ongoing Production Problems by reviewing design changes made to production systems and made corresponding changes to Siebel Analytics Repository.
• Developed ETLs for Data Extraction, Data Mapping and Data Conversion using Informatica Power Center 7.1.
• Extensively worked in fine-tuning of Informatica Mappings.
• Used different application development tools like TOAD (Oracle)
• Created mappings using different Transformations like Source Qualifier, filter, Router, Aggregator, Lookup, Expression, Sequence Generator, and Update Strategy to store the data in target table.

Environment: OBIEE 10.1.3, Informatica 7.1, Oracle 10g, SQL, PL/SQL, TOAD
Functional Area: Sales and Marketing, and Finance, APEX

Confidential,MI Nov 07 to Aug &lsquo09
OBIEE Consultant
Competitive Marketplace Insight enables more effective decisions that drive profitable market share growth through simple, accurate, timely access to marketplace intelligence data for all levels and functions at whirlpool and for our trade customers.

Responsibilities:

• Involved in translating business requirements into logical business dimensional model
• Performed GAP Analysis between the &lsquoAS-IS process and &lsquoTO-BE process
• Involved in converting business requirements into Functional Specifications and Technical Specifications
• Responsible for creating a prototype
• Mapping of data sources using OBIEE Admin tool to create repository
• Installation of Siebel Servers and Web Servers
• worked in implementing SSO using Siebel
• Experience with Server and component monitoring etc
• Worked on development of OBIEE RPD to Physical, Business Model and Mapping and Presentation Layer, configured metadata objects (Subject Area, Table, Column) and Web Catalog Objects (Dashboard, Pages, Folders, Reports)
• Created Drill Down Hierarchies and implemented Level Based Measures, Cache Management, and Performance Tuning using Aggregate tables in OBIEE Business Model Layer
• Created Session and Repository Variables and Initialization Blocks for desired functionality
• Created Groups/Users and set up Security using LDAP Authentication
• Created Pivot Tables, Pie charts, Column/Bar Charts, View Selectors, Narrative Views, and Column Selectors in OBIEE environment.
• Migrate and Deploy of RPD and Webcat in Development, Test, and Production Servers
• Worked on Siebel Answers to build Interactive Dashboards with drill-down capabilities, Dashboard/Page Prompts
• Created i-BOTs using OBIEE Delivers and scheduled daily and weekly reports
• Responsible for RPD and Webcat back up process.
• Designed and developed the ETL Mappings for the source systems (Relational, Flat Files, and Excel) data extractions, data transformations, data staging, movement and aggregation
• Performed data manipulations using various Informatica Transformations like Joiner, Expression, Lookup, Aggregate, Filter, and Update Strategy
• Extensively worked on performance tuning of Informatica mappings
• Involved in Migration, UAT, Go-Live, and Production Support

Environment: OBIEE, Informatica PowerCenter 7.x, Oracle 9i/10g, LINUX
Functional Area: Marketing

Confidential,Northlake, IL Sep 06 to Oct &lsquo07
Informatica Siebel Analytics Consultant
Empire Today is Americas largest home improvement and furnishing company. The Process Improvement project provides Empire Payroll and Administration with Siebel Analytics/OBIEE reports regarding their installers and sales representatives.

Responsibilities:

• Worked with functional and technical project leads, marketing, sales, finance and administration, and other business groups to identify, analyze, and document Business requirements.
• Identified and worked with various application areas in identifying, analyzing, and documenting various information sources solutions to meet the business requirements. Related data sources were derived from Siebel CRM as well as numerous enterprise applications, retail and supply chain systems.
• Installation of OBIEE on Development, Stage, and Production Servers
• Worked extensively on Siebel Analytics applications (Siebel Answers, Delivers, and Dashboards).
• Ability to perform Server and component tuning, optimization
• Created Dashboards by embedding reports and providing intuitive drilldowns and links to exploit the full benefit of Analytics.
• Created various reports using Column Selector, View Selector, Pivot View, Chart View, and Guided Navigation
• Involved in design and development of repository (Creating / Modifying objects in Physical, Business and Presentation layer) and the process of repository migration.
• Migration and Deployment of OBIEE in Development and Production Servers
• Used ETL processes to accommodate changes in source systems and new requirements.
• Development of many complex Informatica mappings and mapplets to build key interfaces using transformations and reusable transformation units (Update Strategy, Filter, Router, Expression, Lookup, Aggregator) for loading data into Data Warehouse.
• Used Workflow Manager for Creating, Validating, Testing and running the sequential and concurrent Sessions and scheduled them to run at specified time with required frequency. Used Workflow Monitor to monitor the performance of the Jobs.
• Created and maintained metadata and ETL documentation that support business rules and detailed source to target data mappings.

Environment: Siebel Analytics 7.x, Informatica PowerCenter 6.x, Oracle 9i, UNIX
Functional Area: Finance

Confidential,India Nov 05 - Aug&lsquo06
Siebel Analytics Developer
Revenue Accounting Management (RAM)
The Revenue Accounting Management project provides Customer Receipts Analytics solution to Pelco to enhance decision-making process, perform Data analysis and tracking with respective to their products and customers. This Siebel Analytics reports should include data from both Siebel and Non Siebel sources

Responsibilities

• Involved in gathering and analyzing the user requirements in coordination with Business.
• Identified Facts, Dimensions, and grain of the Dimensional modeling.
• Identified the source tables, source columns, and referential joins.
• Built Siebel Analytics Repository at 3 layers i.e., Physical Layer (connecting to Data sources and import schema), Business Model / data mapping (create Logical tables and data source mapping) and Presentation Layer level (create presentation catalogs)
• Created Business Facts and Dimensions and defined Logical relation between them in BMM layer
• Created Drill Down Hierarchies and implemented Business Logics for Facts.
• Analyzed and validated the business model in Siebel Administration Tool by performing consistency check, validating logical source tables (LTS), logical columns, and also validating repository level calculations done in the business model layer.
• Imported Physical Tables and Defined Relations in Physical Layer in Siebel Analytics
• Created Reports using different Analytics Views (Pivot Table, Chart, Table)
• Customized Reports look and Feel using Column Formatting, Conditional formatting.
• Created Pivot Tables and manipulated Init Blocks for report analysis
• Configured out-of-the box as well as custom Analytics/Dashboard reports using Siebel Answers
• Implementing report Level Business Logic using Function editor.
• Performed Unit testing, Integration testing, and Regression testing to validate report and mapping functionality.
• Created mappings with PL/SQL procedures and functions to implement business rules while loading data
• Performed performance tuning by optimizing Target, Source, Mapping and Session
• Improved SQL query performance using TKPROF and EXPLAIN PLAN
• Involved in migration of mappings / workflows from Development to Testing and to production

Environment: Siebel Analytics 7.x, Informatica PowerCenter 6.2, Oracle 9i, UNIX

Confidential, Santacruz, Mumbai, India Jul &lsquo04 to Sep 05
Informatica ETL developer
Performed requirement analysis, Designed a comprehensive export and import costing application. The Application keeps track of inventory information, sales analysis and delivery Details, Developed using Developer 2000 with Oracle 7.3 database in windows95 using VBX controls.

Responsibilities:

• Documented user requirements, translated requirements into system solutions and developed implementation plan and schedule.
• Identified the granularity level of the data available for analysis
• Extensively used transformations like Lookup, Aggregate, Joiner, Filter, Sequence Generator, and Expression to create complex mappings.
• Created mappings to load aggregate tables in the data warehouse.
• Customized workflows, worklets, and tasks using Workflow Designer.
• Used Workflow Manager/ Workflow Monitor to develop, validate and run sequential and concurrent batches and sessions.
• Created email tasks in workflows to send post session and suspension emails as per user requirements.
• Translate business requirements to design the ER model using ERWIN tool.

Environment: Informatica Power Center 5.1, Oracle 8i, PL/SQL, Windows NT