Project Data

LEENA SAMUEL

Summary

*+ years of experience in Business Requirements Gathering, GAP Analysis,

Data Modeling, Development, Testing, Implementations and Documentations of

Data Warehouse / Data Marts deployments and Business Intelligence

solutions.

Expertise in complete lifecycle implementation of Data Warehouse / Datamart

with Star and Snow flake models using Ralph Kimball and Bill Inmon

Methodology.

Extensive Business Intelligence experience using Oracle BIEE 10.1.3.x,

Siebel Analytics 7.x and Informatica 7.x/6.x.

Very strong experience in developing Siebel Analytics Repository (.rpd) at

three layers (Physical Layer, Business Model & Presentation Layer), Time

Series Objects, Interactive Dashboards with drill-down capabilities using

page and dashboard prompts, Siebel Security Setup (groups, object and data

level), LDAP, External Tables, configured Analytics Metadata objects

(Subject Area, Table, Column), Web Catalog Objects (Dashboard, Pages,

Folders, Reports) and scheduling iBots.

Involved in developing Informatica Mappings / Mapplets using various

Transformations (Filter, Expressions, Router, Aggregative, Lookups, Update

Strategy, ) for Extraction, Transformation and Loading of data from

Multiple Sources to Data Warehouse and creating Workflows Informatica

Designer and Workflow Manager.

Expertise in Performance Tuning Analytic Dashboards / Reports and Data

Warehouse database.

Solid foundation in Oracle PL/SQL Procedures, Packages, Functions, Triggers

and other objects.

Experience in working with various operating systems like IBM AIX, HP UNIX,

Solaris, and Windows.

Proficient at interviewing stakeholders and end users, and in translating

users' statements of needed system behavior and functionality into Business

and Functional Requirements.

Worked with Business Analysts/partners/Users to identify information needs

and business requirements for reports and finalizing Requirement

Specifications, Design Specifications, Traceability Matrixes, Risk

Analysis, Integration testing.

Business Analysis experience with excellent communication & interpersonal

skills and broad understanding of business operations and requirements.

Ability to work in a team environment and desire to learn new tools and

technologies. Always willing to work in challenging and cross platform

environments.

Excellent interpersonal and communication skills, and experienced in

working with senior level managers and developers across multiple

disciplines

Education

BE(IT) in Engineering, India

Post Grad Diploma in HR Management

Technical Skills

OBIEE, Siebel Analytics 7.x (Admin, Web, Answers, Dashboards), Scheduler,

BI Pulblisher

Informatica 6.x/7.x (PowerCenter / PowerMart & PowerConnect)

Oracle 8i/9i/10g, MS-SQL

SQL*Plus 8.x/9.x, PL/SQL 8.x/9.x

C, C++, Java, JavaScript, HTML, XHTML, XML, PVCs, Kintana, Quality center

Windows NT/2000, Sun Solaris, IBM AIX, HP Unix

Activision Publishing, CA Oct'08 - Till

Date

Sr. OBIEE Consultant /BI Analyst

Activision (ATVI) is an American video game developer and one of the

largest third party video game publishers in the world.

The goal of this project was to implement Business Intelligence Solutions

to measure Pay for performance, trends, corporate contribution,

effectiveness, top performers, employee retention, employee expense trend,

demographics and deliver flexible business solutions for various HR

scorecards.

With the project Activision advanced from legacy reporting systems to suit

the business needs and improve decision making process and employee

satisfaction. The project involved implementation and customizing the

reports to suit the business need.

Responsibilities:

Participated in gathering and analyzing the Business Requirements in

collaboration with the HR Analyst, Subject Matter Experts (SMEs) and Users

Prepared the Business requirement document and detail Design documents

within a team of data modeling and BI experts.

Perform GAP Analysis for Customization and Enhancements

Co ordinated with all stake holders to define the Key Performance

Indicators(KPI's) for various HR score boards

Responsible Data Validation and co ordination with transition team for

deployment

Performed Performance Tuning of Dashboards/Reports by aggregate

navigation, cache management, Oracle materialized views and making changes

to reports itself.

Created comprehensive and easy-to-understand Documentation of the complete

implementation of HR Business modules (Reports, Dashboards, Security, star

schema).

Worked closely with Business Users to enhance reports performance through

changed control management.

Developed Interactive Dashboards (3) using Reports (23) relating to the HR

Domain with different Views (Drill-Down, guided navigation, Pivot Table,

Chart, Column Selector, dashboard and page prompts) using Oracle

Presentation Services.

Involved with development of Initial and Incremental ETL process with the

ETL Team for enhancements to Facts/Dimensions.

Configured and calculated various measures in the Business Model Layer of

the RPD

Created drill-down reports, graphs, chart views, pivot table views and

other reporting features.

Also worked and Developed the Oracle BIEE Metadata repository (.rpd) model

for the HR Domain that involved creating Physical, BMM layers with

aggregates, dimensions, hierarchies & time series functions, Presentation

layer with catalogs & folders using Oracle BI Administration tool.

Extensively used Toad for ORACLE in order to debug and track down errors

and also execute SQL code and also to check the cost/load on the database.

Maintained the versioning of all the reports and the documentation for the

reports using PVCS.

Worked extensively with QA team to review test cases and collaborated bug

fixes with developers.

Environment: OBIEE 10.1.3.x, Oracle 10g, Informatica PowerCenter 7.x,

Oracle Apps, Microsoft Windows 2003

Motorola, FL Aug

'07 - Oct'08

Sr. Siebel Analytics Consultant

Motorola is a global communication leader providing digital cellular

services to millions of customers across the globe. The goal of this

project was to implement and deliver Business Intelligence Solutions to

measure company performance for all Motorola failed products. This project

dealt with reports and metrics in support of the failure analysis process

from the Oracle Platform which also includes the legacy data and other data

sources. Key reports include Summary reports, Operational reports, Cycle

time reports, trending reports, pre-alerts, CND,case closure metrics,

weekly and monthly FA operational reports, cycle time reporting for various

FA Process workflow states.

Responsibilities:

Performed GAP Analysis for user requirements

Collaborated with Business contacts & Business SME in the analysis and

preparation of BI data requirements

Participated in the walk through of the data models, identification of

dimensional attributes, Facts and Star Schema to fulfill requirements.

Identified the granularity level of the data required to be available for

analysis.

Interacted with business representatives for gathering the Reports /

Dashboards requirements and to define business and functional

specifications.

Performed Data Warehouse analysis and identified the required Facts,

Dimensions, Levels / Hierarchies of Dimensions.

Worked extensively in creating Proof of Concept (POC) and mock-ups with

Oracle test data sources

Developed the Siebel Analytics Metadata Repository (.rpd) using Siebel

Analytics Administration tool by importing the required objects (Dimensions

and Facts) into Physical Layer using connection pool, developing multiple

Dimensions (Drill-Down Hierarchies) & Logical & Facts / Measures in

Business Model Layer, and creating the Presentation catalogs in

Presentation Layer.

Developed many Procurement and Maintenance Time Series objects for

comparing the usage variations between the quarters.

Designed and developed the many Performance Measurement Dashboards/Reports

that are Dynamic & Interactive with intuitive drilldowns, drill-across &

flash-based drillable charts (bar-charts, pie-charts, radars, and bubble-

charts), Capabilities split reports for summary & details information, and

local & global filters and cache monitor using Siebel Analytical Web.

Security management for users, groups and web-groups using the various

authentication systems (Database table, Session Variable features,

Dashboard / Report-level security)

Bench-marked performance tuning strategies with business model-level

calculations versus database level pre-computations and aggregations

Developed many Reports / Dashboards with different Analytics Views (Drill-

Down, Pivot Table, Chart, Column Selector, Page and Dashboard Prompts)

using Siebel Analytics Web.

Configured, scheduled and maintained iBot queries to obtain daily and

weekly reports.

Implemented External table security by creating users & web groups.

Involved in developing the Incremental ETL process i.e., Mappings &

Mapplets using various Transformations and Workflows with Sessions / Tasks.

Developed many PL/SQL procedure & functions and used the same in mappings,

pre and post session commands.

Performance Tuning of Dashboards/Reports and made changes to database by

implementing the materialized views, partitions and re-building of indexes.

Performed Unit, Integration, and Regression testing to validate report and

mapping functionality.

Worked closely with Users, Developers and DBA's to resolve ongoing

Production Problems by reviewing design changes made to production systems

and made corresponding changes to Siebel Analytics Repository.

Environment: Siebel Analytics 7.x, Informatica PowerCenter 7.1, Oracle

9i/10g, HP UNIX

Empire Today, North Lake IL Jan '05-

Jun '07

Sr. Siebel Analytics / Informatica Consultant

Empire Today is leading provider of installed Home Furnishings and Home

Improvements in the U.S. and Canada. The Process Improvement project

provides Empire Payroll and Administration with Siebel Analytics reports

regarding their installers, employees and sales representatives.

Responsibilities:

Worked with functional and technical project leads, marketing, sales,

finance, 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.

Worked extensively on Siebel applications (Siebel Answers, Delivers, and

Dashboards).

Created Dashboards by embedding reports and providing intuitive drilldowns

and links to exploit the full benefit of Analytics.

Involved in design and development of repository (Creating / Modifying

objects in Physical, Business and Presentation layer) and the process of

repository migration.

Implemented data and object level security with the help of the Siebel

Administration tool.

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 7.x/6.x, Oracle 9i, Sun

Solaris, Windows 2003

IIM- Ahmedabad, India Oct '03

- Dec '04

Research Analyst

Worked on the first phase of a research project called "Performance

forecasting", which dealt with the awesome combination of HR analytics and

the cutting edge IT technology. This project aimed at forecasting the

performance of a group of tribal students who were given a period of

extensive training so as to get recruited in the various sectors of either

a BPO or a retail sector. Their performance during this period combined

with their inherent skills set would prove to be the main criteria in

recruitment to the BPO and retail industries. This project was also

analyzed to be extended to the second phase to the determine the future

performance of the corresponding students who have been recruited in the

BPO and retail firms over a period of time of either 3 or 6 months. This

project used the core data mining concepts which helped to determine

clusters of information which proved beneficial in understanding the skill

sets of the individuals.

Conducted market research, identified and established contacts with key

potential customers and partners.

Co-ordinated and led a diverse team of different professionals so as to

steer the project in the right direction.

Collaborated closely with customers to gather, interpret, and articulate

requirements, define scope, and set deliverables.

Collaborated closely with technical team to design applications, create use

cases, QA test, implement, integrate, and reinforce the research.

Created training materials and conducted classroom based test sessions for

external customers for determining their skill set required for the

research study.

Experienced in tracing business requirements to system requirements to

ensure customer needs and goals are met.

Used Xlminer in this study to determine the clusters along with their

corresponding requirement specifications.

Environment: Data Mining, Xlceius, Xlminer Oracle 9i, IBM AIX, Windows XP &

2000

National Institute of Design, INDIA

Jul '02 - Sep '03

Oracle Developer

Security Management System

Security Application has been designed for the purpose of storing and

maintaining records of various visitors who visit the organization on day-

to-day basis.

Responsibilities:

Created Standard Business Processes and Standard Scorecards using Process

Automation Engine.

Created Stored Procedures & Functions and called the same from the customer

setup and processes screens.

Debugged Stored Procedures and Functions.

Wrote Shell scripts and SQL*Loader scripts called from the processes.

Involved in documentation of the modifications and intended functionality

of the interfaces

Performed Unit and Integration testing.

Provided Post Production Support.

Environment: Oracle 8i/9i, Windows NT & 2000

Contact this candidate