Siebel Analytics
Resume:
Summary
· Over * years of experience in Business Intelligence and Transactional applications, Design and Implementation of Data Warehouse/Data Mart, Gathering Business User Requirements, System Analysis, Design and Data Modeling
· Expertise in complete lifecycle Implementation of Business Intelligence with Star and Snow flake Schemas using Ralph Kimball and Bill Inmon Methodology
· Extensive BI and Data warehousing experience using Siebel Analytics 7.x/OBIEE and Informatica 8.1/7.x/6.x
· Very strong experience in developing OBIEE Repository (.rpd) at three layers (Physical Layer, Business Model & Presentation Layer), Time Series Objects, Interactive Dashboards with drill-down capabilities using global & local Filters, Security Setup (groups, access / query/report privileges), configured Analytics Metadata objects (Subject Area, Table, Column), Web Catalog Objects (Dashboard, Pages, Folders, Reports) and scheduling iBots .
· Experience in creating Metadata Objects and Web Catalog Objects (Dashboards, Pages, and Reports) using OBIEE Admin Tool and Siebel Analytics Web.
· 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 & Tasks and scheduling using both Workflow Manager and Unix Shell scripts (using pmcmd)
· Expertise in database Performance Tuning by implementing Parallel Execution, Partitions, materialized views with query rewriting, creating appropriate indexes, usage of hints, re-building indexes and also used the Explain Plan and SQL Tracing
· Very strong in PL/SQL Procedures, Packages, Functions, Triggers and other objects
· Experience in working with different operating systems like HP UNIX, Solaris, IBM AIX, MAC OS and WindowsNT/2000
· Well-developed organizational and communication skills, with strength in inter-personal relationships
· Self-starter, result-oriented team player with an ability to manage multiple tasks simultaneously
· Proven strong analytical and logical skills with ability to follow project standards and procedures as per client specifications
Education
· MS in Computer Science
Technical Skills
Analytics : OBIEE, Siebel Analytics 7.x, RPD, Dashboards, Delivers
(iBots)
ETL : Informatica 8.1/7.x/6.x/5.x (PowerCenter & PowerMart)
RDBMS : Oracle 8.x/8i/9i/10g
Language : SQL*PLUS 8.x/9.x, PL/SQL 8.x/9.x, C, C++, VHDL
: Shell & Perl Programming
OS : Linux/UNIX, Windows 95/98/NT/2000, Sun Solaris
Data Mining Tools : SAS, R
Alltel Communications, AR Feb ’07 – Till Date
OBIEE/ Siebel Analytics Lead
Service Point Maintenance (SPM)
Alltel provides wireless, local telephone, long-distance, Internet and high-speed data services to residential and business customers in 26 states. Alltel required a complete solutions package data mart for its Billing Department to analyze and report the consumer revenue trends.
Responsibilities:
¨ As a OBIEE Lead was involved in translating functional requirements into technical requirements.
¨ Assisted in building detailed project schedule.
¨ Interacted with Procurement and Operation / Maintenance business representatives for gathering the OBIEE Reports / Dashboards requirements and to define business and functional specifications
¨ Analyzed and used various data sources – Oracle, Excel, and Web Services
¨ Identified Facts, Dimensions, Levels / Hierarchies of Dimensional Modeling
¨ Customized and developed RPD (Physical, BMM and Presentation Layer), configured metadata objects and Web Catalog Objects
¨ Developed many Reports / Dashboards with different Analytics Views (Drill-Down / Dynamic, Cascading Style Sheets, Pivot Table, Chart, Column Selector, Tabular with global and local Filters) using Siebel Analytics Web.
¨ Configured OBIEE iBots to deliver Analytics content based on schedule, automated iBot queries to obtain daily and weekly reports.
¨ Implemented security by creating roles & web groups, checks with External tables and LDAP, and Object Level Security.
¨ 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.
¨ 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 Siebel Analytics Repository.
Environment: OBIEE, Informatica Power Center 8.1.1, Oracle 9i/10g
Marathon Oil Corporation, TX Dec ’05 – Jan ’07
Sr. Informatica / Siebel Analytics Lead
The CRM project provides sales and order Analytics solution to marathon oil to enhance decision-making process regarding their products and customers. The system will allow users to perform data analysis and track their products and customer details.
Responsibilities:
· Involved in meeting with business representatives for requirement analysis and to define business and functional specifications.
· Identified the GAP’s by analyzing the Datamart instance and provided alternative solutions as well recommended changes to database
· 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 Drill Down Hierarchies and implemented Business Logics for Facts.
· Created Pivot Tables and manipulated Initialization Blocks for report analysis
· Worked on Siebel Answers to build Interactive Dashboards with drill-down capabilities.
· Implemented dynamic dashboard prompts to zoom into particular segments of the business in a performance-optimized manner.
· Created templates for presenting results and Analytics and modified the Siebel Dashboard using cascading style sheets.
· Designed and developed the ETL Mappings for the source systems 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.
· Involved in Production Support, UAT and sign-off from the users.
Environment: Siebel Analytics 7.x, Informatica PowerCenter 6.2, Oracle 9i/10g, Sun Solaris.
Texas Utilities (TXU), TX Dec ’04 – Nov’05
Sr. Siebel Analytics Consultant
The Customer Services (CS) Analytics solution will enhance decision-making process regarding Operations/Services Enhancements of TXU personals. The system will allow Customer Relation Management Team to perform data analysis and track the solutions provided to subscribers (around 2.2 millions) as well used to report to Texas Public Utilities Commission (TPUC).
Responsibilities:
· Interacted with Case Services Management business representatives for gathering the Reports / Dashboards requirements and to define business and functional specifications.
· Identified the GAP’s by analyzing the CS Datamart instance and provided alternative solutions as well recommended changes to database.
· Designed and developed the Siebel Analytics Metadata Repository (.rpd) using Siebel Analytics Server Admin tool by importing the required objects (Dimensions, Facts & Aggregates) 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.
· Developed many Case Solutions Time Series objects for comparing the various case types’ service requests between the quarters.
· Developed many Reports / Dashboards with different Analytics Views (Drill-Down / Dynamic, Cascading Style Sheets, Pivot Table, Chart, Column Selector, Tabular with global and local Filters) using Siebel Analytics Web.
· Configured iBots to deliver Analytics content based on schedule, automated iBot queries to obtain daily and weekly reports.
· Worked with Disconnected Analytics used by mobile web clients, ran the Synchronization process in Disconnected, and SQL Anywhere.
· Implemented Basic Security and External table Authentication security mechanisms
· Debugged reports and Dashboards visibility with respect to user’s responsibility and web groups in an integrated environment.
· Performance Tuning of Dashboards/Reports and made recommendations for 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 of various Dashboards / Reports and Repository.
· Life-cycle support for migration efforts from Development to Integration Test to Production Analytics.
· 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.
· Performing the benchmark for up gradation process from Siebel Analytics to Oracle Business Intelligence.
Environment: Siebel Analytics 7.x, Informatica PowerCenter 6.x/7.x, Oracle 9i/10g
Toyota Inc, CA Aug ’03 – Nov ’04
Sr. Informatica Consultant
Dealer Data Warehouse contains sales information about Toyota product line of business around 1200 products across 7,000 dealers with past three years of data. The system is used to identify sales patterns and trends based on seasonal promotions. The architecture involved ODS and Data Warehouse involving a total size of 2+ Terabyte of data.
Responsibilities:
· Involved in Full project life cycle implementation of Dealer Data Warehouse.
· Participated in designing STAR schema and developed complex Mappings / Mapplets using various Transformation / Re-usable Transformations (Update Strategy, Filter, Router, Expression, Stored Procedure, Lookup, and Aggregator) for implementing Dealer Data Warehouse.
· Created and used views to simplify the mappings and make them easier to maintain.
· Wrote PL/SQL procedures for the complex Informatica mappings to improve the Warehouse loading.
· Responsible to tune ETL procedures and mappings to optimize load and query Performance.
· Designed and developed Pre and Post session tasks and data extracted from Transaction System into Staging Area.
· Extensively worked in Oracle SQL, PL/SQL, Query performance tuning, Created DDL scripts, Created database objects like Tables, Indexes, Synonyms, and Sequences.
· Created temporary tables and indexes for loading and updating data.
Environment: Informatica PowerCenter 5.1/6.2, Oracle 8i/9i, Windows 2000, Sun Solaris
Tracfone, FL Mar ’02 – Aug ’03
Informatica Consultant
Involved in the design and development of a data warehouse for the Reporting System to analyze the expenses incurred on Legal Services based on different regions / divisions etc. and as well as to support different applications for the purpose of calculating number for Market and Credit Risk.
Responsibilities:
· Participated in all phases including Requirement Analysis, Client Interaction, Design, Coding, Testing and Documentation
· Developed complex mappings using Expressions, Aggregators, Filters, Lookup, Stored Procedure transformation, Joiner, Normalize, Router, and Sorter transformation logic to generate consolidated data needed for EDW
· Used Informatica Server Manager for creating and running Sessions and Batches, preview data from source and target databases and monitor server
· Developed Shell Scripts (Korn &Bourne) to run batch jobs
· Used Shortcuts to reuse objects across folders without creating multiple objects in the repository
· Optimized Query Performance, Session Performance and Reliability
· Wrote PL/SQL Stored Procedures to check the status of the target database before moving records into it
· Extracted huge volumes of data from legacy systems and uploaded into Oracle using SQL*Loader and PL/SQL
· Identification of various Data Sources for Development Environment.
· Designed and Developed Oracle PL/SQL and Shell Scripts, Data Import/Export, Data Conversions and Data Cleansing
Environment: Informatica PowerCenter 5.0, Oracle 8i, IBM AIX
Delphi Auto Systems, MI Sep’00 – Apr’02
Informatica Consultant
· Sales and Production Datamart had been implemented for better business analysis and intelligence. Responsibilities included understanding the feeder systems and ETL process using Oracle and Informatica ETL tool.
· Responsibilities:
· Developed many mappings / mapplets using various transformations for extract and loading the sales data.
· Created sessions and batches for executing the mappings. Scheduled the batches through crontab using pmcmd.
· Involved in the performance using of sessions and database.
· Provided support to report developers in developing the reports.
Environment: Informatica Power Center 5.1, Oracle 8i, PL/SQL, Sun Solaris
Contact this candidate