Post Job Free
Sign in

Sales Oracle

Location:
Jacksonville, FL, 32256
Posted:
June 14, 2011

Contact this candidate

Resume:

*

Riz Syed (***.*****@*****.***) – 904-***-****

(OBIEE/Siebel Analytics, Oracle Applications EBS, ETL & BA Lead Consultant)

Summary

Detail oriented highly motivated Business Intelligence individual with 8 years of experience in Oracle Business

Intelligence/Siebel, ETL, Oracle Applications EBS (Finance, Supplychain, Distribution, Sales and

Marketing), Business and Data Analysis all phases of software application development.

Astute strategic understanding of Oracle Business Intelligence Enterprise Edition, Oracle BI Publisher,

Oracle Applications, Oracle BI DAC, Informatica Power Center, Crystal Reports XI/Business Objects

XI, client/server, and Database environments

Full lifecycle OBIEE implementation & Configuration from end to end including Business Users

Requirements, Analysis, Design & Modeling, Development, and Testing of Business Intelligence using

OBIEE

Expert in OBIEE 11g Upgrading OBIEE 10g Installation to OBIEE 11g, Configuration, Reports,

Scorecards, Dashboard and Metadata models

Exclusively worked on OBIEE (Siebel) Administration (Physical, Business Model & Mapping, and

Presentation Layers), Answers, Dashboards, Job Manager, Catalog Manager, BI Publisher,

Marketing and Disconnected Analytics

Worked on Development, Maintenance and Customization of Oracle Applications –Supply Chain

Management (Order Management, Shipping, Order Process Manufacturing), Financials (AP, AR, GL),

Oracle Distributions (INV, PO), Oracle Manufacturing (BOM, WIP)

Experienced in various business flows like Quote to Cash, Procure to Pay, Record to Report, Lead to

Quote, Oracle Inventory Analytics, Spend Analytics and Oracle Supplier Performance

Experienced in analyzing Change Requests and Risk analysis Documents and Involved in

Preparation of Mitigation Plans

Defining various logical subject areas and organization of Presentation Layer metadata; Understanding and

defining key metrics, dimensions, hierarchies and attributes

Extensive experience in providing end to end business intelligence solution by dimensional modeling design,

building business models, configuring metadata, Answers, Delivers / iBots, creating reports / Dashboards,

cache monitor, and building OBIEE Repository using OBIEE (Siebel Analytics)

Experience configuring Interactive Dashboards with drill down capabilities using global and local Filters,

Oracle OBI (Siebel) Security Setup (groups, access / query privileges), Metadata Objects and Web Catalog

Objects (Dashboard, Pages, Folders, Reports).

Experienced in Informatica Data Integration Tools – Repository Manager, Designer, Workflow/Server Manager,

and Workflow Monitor

Expertise in preparing mapping document for gathered requirements and Designing Functional

Specifications document with all the required use cases and traceability matrix.

Expertise in designing solution document for change requests and post production alliance cases

Technical Skills

2

Riz Syed (***.*****@*****.***) – 904-***-****

(OBIEE/Siebel Analytics, Oracle Applications EBS, ETL & BA Lead Consultant)

Oracle BI OBIEE & BI Publisher 11g, 10.1.3.4,, BI Apps 7.9.6/7.9.5, Siebel Analytics Stand

Alone/Integrated Version 7.8.5/7.7.1/7.5.3, Siebel CRM, EAI, EIM, Workflow, Testing

& Siebel Data warehouse Application Console (DAC)

ERP Oracle Applications R12/11i – OM, AP, AR, GL, PO, INV, BOM, Sales

ETL Tools Informatica Power Center 8.1/7.1/6.2/6.1, SQL Loader, Oracle Data

Integrator (ODI) 10.1.3.4.x, 10.1.3.5.x, Oracle Warehouse Builder 10gR2

Database Oracle8.x, 9.x, 10.x/11g, SQL Server 2000 & 2005 and Teradata 4.1

Database tools TOAD, SQL Plus and SQL Developer

Dimensional

Data Modeling Star Schema Modeling, Snow Flake Schema Modeling, FACT and Dimension tables,

Logical and Physical Data Modeling

Languages C, Java, SQL Scripts, PL/SQL, HTML, XML, UNIX Shell Scripts

Operating Systems UNIX, Windows

Professional Experience

20th Century Fox, LA Oct 2010 Tilldate

OBIEE SME

(Sales, Retail/Rental Marketing & Operations)

Project: Japan Global Siebel (Sales & Marketing) Implementing the Oracle Business Intelligence Enterprise

Edition (OBIEE) reporting environment with the goal to phase out the user local tools. This phase includes

providing Analytics feature to Sales, Retail/Rental Marketing and Operation teams (Scheduling & Planning,

Execution & Tracking and Performance Evaluation)

Responsibilities:

• Key player in gathering, analyzing and documenting the Requirements from Japan Sales, Retail,

Rental marketing & Operations business teams

• Prepared the Design Specification documents & Technical design documents based on business

requirements

• Prepared the Japan Business Clock with all the business process involved for Reporting

• Continued relationships with management & Users to Understand the Japan reporting needs to

develop a standard suite of report essential for business continuity at go live to handle expectations of

service, together with work products, timing, and deliverables

• Analyze data components and document Data Strategy to identify Key Metrics for Reporting team

3

Riz Syed (***.*****@*****.***) – 904-***-****

(OBIEE/Siebel Analytics, Oracle Applications EBS, ETL & BA Lead Consultant)

• Responsible for Installing, Configuring and Administration of OBIEE 10.3.3.4 Repository for Physical,

Business Model and Presentation services

• Built the Physical Layer /Business Model and Mapping Layer/ Presentation Layer of a Repository

by using Star Schemas and migrated the existing Web Catalog using SAWMigrate

Utility

Identified the Gaps by analyzing the Data mart Instance and provided alternative solutions

• Identified the Facts, Dimensions, and grain of the Dimensional mode, and referential joins

• Involved in designing different data models for Sales Planning, Rental Master, DVD Master, POS

Actuals etc

• Created Time Series measures Yearago, MonthAgo, Yeartodate measures using AGO and ToDate

functions

• Updated Product(WPR, Local Title, SKU), Customer (Plan to, Ultimate), Promotions (National, Sales

Driven), Forecast (Added new versions for Japan), Estimates, Actual dimentional hierarchies according

to the new functionality

• Involved in designing STAR schema and developed complex Mappings / Mapplets using various

Transformation / Re usable Transformations (Update Strategy, Filter, Router, Expression, Lookup, and

Aggregator) for implementing Dealer/Retailer Data Warehouse.

• Designed and developed Pre and Post session tasks and data extracted from Transaction System into

Staging Area.

• Developed custom SDE and SIL mappings to extract and load the data into Warehouse.

• Involved in setting Report Repository, Server and scheduler Configuration for BI Publisher.

• Configured iBots to deliver Analytics content based on schedule, automated iBot queries to obtain

weekly reports, delivery of reports through email, hand held devices and mobile phones

• Worked with BI Security to define users and groups, set permissions, Group Inheritance,

Authentication Methods, Query Limits, Timing Restrictions, and Filters

• Extensively worked on Answers, Created Reports using different Analytics Views (Pivot Table, Chart,

Column Selector and Table)

• Worked on Performance tuning in BI by implementing Aggregate navigation and cache management.

• Created number of standard, exceprtion & adhoc reports with parameter fields, complex reports

running from stored procedure, sub reports on request from main report, reports from different databases

and reports with complex calculations, Running total report & scorecards

• Designed Executive Dashboards– Release Schedule, Sales Planning, Trade Spend, Shipment

Tracking, POS Weekly, Pos Monthly Etc.to provide Business Critical Analytical view of the Written Sales

for a set of Power Users

• Maintained the Full and Incremental loads through DAC on different environments like Development

and Test environment

• Involved in customizing the user interface as per the client specifications

• Involveved in creation of test scenarios, scripts and validate Integration/Regression test results

4

Riz Syed (***.*****@*****.***) – 904-***-****

(OBIEE/Siebel Analytics, Oracle Applications EBS, ETL & BA Lead Consultant)

• Created and conducted Training Classes to Executives as well the Business end users

Environment: Siebel Sales & Marketing Analytics 7.8.4, Informatica 8.1, Oracle Business Intelligence 11g,

10.1.3.4, Oracle 10g, Oracle BI Publisher 10.1.3.4.0, UNIX

JEA, FL Mar 2010 – Sep 2010

OBIEE SME/Technical Lead

(DOE – Smart Grid, MDM, CDI & Billing)

Project

JEA is Upgrading Meter Data Management (MDM) System to provide the foundation for processing, storing,

and delivering energy information to JEA systems and the consumer energy portal. Leverage the Two Way

Metering upgrade to implement Pre Paid billing services that will assist customers in managing and conserving

energy and enable remote Connect and Disconnect functionality

Responsibilities:

Involved in assisting building detailed project schedule, gathering the requirement, completed the proof of

concept and conducted Joint Application Design sessions with Business Analysts from OLTP and OLAP to

configure and customization of Oracle BI Analytics in all phases of implementing Out of the Box (Vanilla

mappings) prebuilt mappings and Oracle Business Analytics warehouse (OBAW)

Involved in translating the Business Requirements to prepare the Technical design documents for all the

interfaces (DSL, LR, SLS & Billing)

Installed the Oracle BI Applications(Informatica, DAC, OBIEE) on distributed environment and

configured the OOB Oracle Financial Analytics

Involved in Capacity Storage Planning for the To Be MDM Data warehouse system for 7 years of archive

to meet the client requirements

Designed and implemented custom business intelligence solutions (Metadata and Dashboards/Reports)

using the Oracle BI Analytics platform

Developed business models conforming to functional mapping, defined logical and complex joins for the

dimension tables

Key player in Identifying the Data and Granularity, Modeling Facts and Qualifiers, Logical Modeling

and Data Integration, Data Design Modeling Business Metrics, Modeling Dimentiones (Master Data

Management)

Prepared and designed Reports, Dashboards, Scorecards and Data models

Developed the Repository model for all the streams with the necessary logic that involved in creating the

Physical, BMM and the Presentation layer

Created Hierarchies, Variables, and Event poll strategies in the repository

5

Riz Syed (***.*****@*****.***) – 904-***-****

(OBIEE/Siebel Analytics, Oracle Applications EBS, ETL & BA Lead Consultant)

Specified aggregate levels for each source and created Dimension sources for each level of aggregates

Used DAC to manage, configure, customize and monitor ETL process

Worked in a MUDE (Multi user Development Environment) environment for creating projects, groups,

users and provided the required permissions for the developers

Created groups in the repository and added users to the groups and granted privileges explicitly and

through group inheritance

Enhance performance by creating Aggregate tables, Indexes and Managing Cache

Modified some of the existing reports and dashboards, and fixing some of the issues related to

performance, data quality

Used Filters (Global/Local) and provided Customized prompts appropriately to avoid excessive data

showing up Reports

Created Analytics Reports including Charts, Pivot tables and Compound layouts

Implemented both Object and Data level security as part of the project

Customized and developed repository, configured metadata objects (Subject Area, Table, Column) and

Web Catalog Objects (Dashboard, Pages, Folders, Reports)

Conducted BI Update Meetings & BI Interface Weekly Team Meetings Deliverable and project

updates from DWH prospective

Involveved in creation of test scenarios, scripts and validate Integration/Regression test results

Created and conducted Training Classes to Executives as well the Business end users

Environment: OBIEE 10.1.3.4, OWB 10.2.0.4, ODI, DAC, MDM, Billing, Oracle Applications 11i Oracle 10g,

SQL Developer, Mercury Quality Center, MS Suit

Beckman Coulter, CA Aug 2009 – Feb 2010

Sr.OBIEE Report & Dashboard Dev/Lead/ EBS Analyst

(Finance, Commercial Operations, Supplychain & HR)

Project:

Beckman Coulter, Incorporated (BCI) is implementing the Oracle Business Intelligence Enterprise Edition

(OBIEE) reporting environment with the goal to phase out reporting from Business Objects (BO). This phase

include the transition of Global Finance, Supply Chain Management, Sales and Marketing, Human Resources,

and Quality Assurance reporting functionality from BO to OBIEE.

Responsibilities:

Involved in translating the Business Requirements to prepare the Technical design document

Worked on Oracle BI Answers to Create numerous Executive, Detail level Reports, Scorecards &

Dashboards in Finance, Commercial Operations and Supply Chain modules for all the super users

6

Riz Syed (***.*****@*****.***) – 904-***-****

(OBIEE/Siebel Analytics, Oracle Applications EBS, ETL & BA Lead Consultant)

Involved in installation, configuration & Administration of oracle OBIEE and Oracle BI Applications

Created complex reports (On demand, Adhoc Reports, Frequency reports, Summary Reports, Sub

Reports, Drill down, Dynamic, Cross Tab, graphical, aging reports etc).

Developed the Reports in Purchasing transaction analysis, Supplier spend analysis, Procurement and

Spend by Qrt & Location, Corporate Finance, Accounting, Tax, Accounts Receivables/ Payable by

Location, by Product & by Customer, Annual Compensations, Overtime Expenses, Exec Headcount,

Hire List and Supply Chain Functional Area

Modified the Customer and Product hierarchies by assigning custom attributes to various levels in the

hierarchy tree structure

Specified Aggregate levels for each source and created dimension sources for each level of aggregates

Design and develop reports for Top10, KPI and trend analysis

Used Global, Local Filters and Customized prompts to avoid excessive data showing up Reports and to

customize the dashboards as per the requirement

Extensively used Case Statements, Presentation variables and filter conditions for Dynamic Data

population in Reports

Generated Different Trend Reports for Client Services, Customer Scorecard, Revenue, AP/AR/GL

Balance sheets (YTD, QTD & MTD), Controllable Expenses, Contribution Profit, Net Fixed Assets

and Supplier Payment/Performance/Orders

Managed security privileges for each subject area and dashboards according to user requirements and

Setup the visibility of Dashboards to employees with respect to their responsibilities

Configured Physical Layer – Import tables, Create Tables, add/change physical joins/keys

Configured Logical Layer – Create Logical tables/dimensions, columns, Create Logical Joins/keys, Set

levels to support Drill down, Aggregation / Sum over Columns

Configured Presentation Layer – Create Folders/sub folders, Standard Queries for different User

Groups

Managed the privileges of users and folders using Repository Manager and used OBIEE Administration

Console for Admin activities such as starting / stopping server, upgrading the repository etc

OBI Admin tool to configure & create repository (.rpd) and Prepared a Detail Design Document

Configured, Administered and established ODBC connection to pull data from BAW, MS Excel Sheets,

C.S.V. Flat files

Interact with System Engineering team to design Facts, Dimensions and Hierarchies of the business

model. Tested various network points

Used BI Publisher (Formerly XML Publisher) to build custom applications leveraging existing data

sources and infrastructure

Coordinated activities onsite & offshore towards meeting project timelines

7

Riz Syed (***.*****@*****.***) – 904-***-****

(OBIEE/Siebel Analytics, Oracle Applications EBS, ETL & BA Lead Consultant)

Environment: OBIEE 10.1.3.X, BI Publisher, Informatica 8.1, ODI, DAC, BOXI, Oracle Applications 11i

(Financials, Commercial Operations, Supply Chain), Oracle 10g, Excel, MS Access, Quality Center, UNIX

Cisco Systems, CA Mar 2007 – Aug 2009

Sr. OBIEE Lead (Dev & Admin) / Architect/ Oracle Apps Consultant

(Finance, Supply Chain & Manufacturing)

Project:

This project is focused on delivering next generation reporting for Cisco, which involved in replacing their

existing Essbase reporting platform to OBIEE. Also, as a parallel effort worked on a second project to automate

the process of allocating revenues between products and services. In this project, I worked on Data foundational

activities, Report & Dashboard generation and the system is web based (ADF framework). It involves OM,

Shipping, AR and Inventory Interfaces.

OBIEE Responsibilities:

Developed technical solutions to business problems in the OBIEE repository.

Upgraded to the most current version of OBIEE, and performed the regression and functionality testing

necessary for the upgrade

Developed a solution documents for new OBI Subject Areas and Dashboards

Enhanced existing Business Models & created customized Dashboards for Revenue Ratio Reports for US

& CAN, ASIA PAC & EURO Markets

Created repository services and repository contents. Restored the repository contents from the backups

using Admin console

Responsible for creating repository folders and giving access to users

Developed UNIX Shell scripts and Perl Scripts to Migrate data from different legacy systems in databases

Modified a SeeBeyond Workflow Template Siebel EAI workflow templates

Managed the privileges of users and folders using Repository Manager and used OBIEE Administration

Console for Admin activities such as starting / stopping server, upgrading the repository etc

Created target definition in oracle which was the target database

Imported List/Contact details by using Informatica

Implemented measures & dimensions and organized the data into related subject areas

Customized and developed repository, configured metadata objects (Subject Area, Table, Column) and

Web Catalog Objects (Dashboard, Pages, Folders, Reports)

Designed, Developed and Tested various Cisco based Revenue reports like Bookings Report,

Deal Review Report, Analysis History Report, Assignment History Report,

Exclusions Summary/Deal/Line Report, Average Annual Compensation by Geography, by Pay Grade,

Overtime Expenses, Performance & Promotions and Turnover Regional Analysis etc.

Customized Business Mapping Layer, created marketing segmentation criteria for Prospective customers

8

Riz Syed (***.*****@*****.***) – 904-***-****

(OBIEE/Siebel Analytics, Oracle Applications EBS, ETL & BA Lead Consultant)

Implemented and Configured OBIEE Scheduler by generating encrypted password in clustering mode for

both Stage and Production environments.

Installed and configured Oracle BI Publisher and its integration with Oracle BI Presentation services

Involved in Design and Data Modeling using Star schema and new Aggregate

Created Informatica mappings for initial load and daily updates

Involved in troubleshooting the load failure cases and database problems

Involved in Testing Informatica Mappings and Sessions for optimum performance

Setup & Configure Data Warehouse Administration Console (DAC)

Worked on OBIEE releases as needed. Involved in promoting RPD and Web Cat from MUD to Dev, Dev

to Test, Test to Stage and Stage to Prod

Performed environment migrations between the Development, Quality Assurance, and Production

environments

Participated in weekly status meetings with Director of IT and Coordinated activities onsite & offshore

towards meeting project timelines

Created custom education materials and conducted individual, as well as, group training for Users

Global Project – Oracle Apps Financial:

• Analysis of Conceptual design document and understanding Business Requirements & Functional

design documents.

• Documented the process of triggering the pick/pack and shipping process, producing a customer

invoice, and applying the customer’s payment.

• Developed the custom interface program which would take the data from receiving interface tables

and generate and launching the Receiving Transaction Processor program automatically

• Worked extensively in a team on Order import interface & Customer Interface from legacy system to

target system and Involved in Mapping of columns and tables in OM, AR & GL

• Developed the Technical Design Documents and Reports for Retrieval of Deal information,

Global/Local Deal amounts, Order Booking Amounts, Revenue Transfer Amount, Revenue Transfer

Directions, Revenue Recognized Amount at product and Service Level and cross verify the configuration

and set ups

Environment: OBIEE 10.1.3.4, Siebel CRM, EAI, EIM, Workflow, DAC, Informatica 8.1, Oracle

Applications 11i (OM, AR & GL), BI Publisher, Salesforce, Excel, MS Access, BOXI Info View, Quality

Center, Oracle 10g, UNIX, MS VISIO

Stein Mart, Jacksonville, FL Mar 2006 – Feb 2007

9

Riz Syed (***.*****@*****.***) – 904-***-****

(OBIEE/Siebel Analytics, Oracle Applications EBS, ETL & BA Lead Consultant)

Sr. Oracle BI Developer

Project:

This project is based on providing Automation Analytics feature to Sales Team. System is a complete retail

solution, from the origination of the local manual system through automatic retail reporting, approval and

shipping to the servicing divisions. Trending Report by Sales and marketing is going to be a new feature in

Automation.

Upgrade Responsibilities:

Involved in promoting RPD and Web Cat from Dev to Test, Test to Stage and Stage to Prod.

Worked closely with System Architect to automate the migration process on Dev and Test environments.

Created Fact tables

(NACAD_ACTV_ACAD_FACT/NACAD_ACTV_INSTR_FACT/NACAD_ACTV_STDNT_FACT)

using Multiple Logical table sources deriving from base fact and its respective aggregated tables

Created schema in physical layer as per the business requirements and configuration of Logical Layer,

Logical tables, dimensions and columns and established the respective logical joins/keys.

Used Aggregate Tables and specified Aggregate Levels for each source and designed Intelligence

Dashboards and created Global Filters.

Customized the logical tables and columns, defined the Analytics dimensions, aggregations and levels.

Developed the new metadata definitions, new Subject areas in the Repository Physical, Business Model

and Mapping and Presentation Layers of the Repository

Developed various OBIEE Reports for Sales team as well the Order creation team

Worked extensively on Metadata and report development.

Extensively used Administration Tool for customizing and modifying the physical, business and

presentation layers of metadata repository

Worked in Repository Administration tasks like creating Repository, User groups, Users and managing

users by setting up their privileges and profiles

Worked extensively in leveraging Database features in Physical layer, creating opaque views, alias tables

and physical joins to improve the performance.

Performed Pre and post implementation testing of Dashboard, Answers and validating Repository

Environment: OBIEE 10.1.3.3, Informatica 6.2, DAC, Oracle Applications 11i (OM, AP, AR, Shipping,

Inventory), Oracle 10g, SQL Server 2000, Essbase 9.3.1, Informatica 6.2.2

Cisco Systems, CA Jul 2005 – Feb 2006

Sr. Siebel Developer – Functional Analyst

10

Riz Syed (***.*****@*****.***) – 904-***-****

(OBIEE/Siebel Analytics, Oracle Applications EBS, ETL & BA Lead Consultant)

Project:

The project involved identifying user requirements and analyzing the existing data sources. Additional customer

analytics, marketing techniques, and process are done for consistent customer performance through out the

customer life cycle. The team involved in developing and maintaining targeting models. Siebel improves

customer and dealer service levels, increase customer loyalty to the Brand and advance the levels of efficiency

and effectiveness with minimal customization of the package software.

Responsibilities:

• Involved in Creating and Administering the Physical Layer, Business Model & Mapping Layer and

Presentation Layer in a Siebel Analytics repository.

• Created connection pools, physical tables, defined joins and implemented authorizations in the

physical layer of the repository.

• Configured and Created repository using Siebel Analytics Admin tool.

• Developed custom reports/Ad hoc queries using Seibel Answers and assigned them to application

specific dashboards.

• Developed different kinds of Reports (pivots, charts, tabular) using global and local Filters.

• Managed day to day Rpd, Siebel Delivers, Scheduler & iBots.

• Managed security privileges for each subject area and dashboards according to user requirements.

• Created groups in the repository and added users to the groups and granted privileges explicitly and

through group inheritance.

• Involved in Design and Data Modeling using Star schema.

• Designed & assisted Informatica ETL developer to create new Aggregate.

• Created Informatica mappings for initial load and daily updates.

• Developed several mappings to load data from multiple sources to data warehouse.

• Involved in troubleshooting the load failure cases, including database problems.

• Setup & Configure Data Warehouse Administration Console (DAC).

• Configured environments for full ETL and incremental data loads from OLTP onto OLAP data sources

using DAC and Informatica routines.

• Configured and Tested the Informatica connections, source DB connection and target DB

connection in DAC.

• Configured new customized mappings and work flows in DAC for new customized subject area.

Environment: Siebel 7.7 Analytics, Informatica 6.2, Oracle Applications 11i (OM, AP, AR, Shipping,

Inventory), DAC (Data warehouse Administration Console), Oracle 10g, UNIX, Windows XP, TOAD.

United Health Care, MN Mar 2004 Jun 2005

Data Analyst – Siebel Report Analyst

11

Riz Syed (***.*****@*****.***) – 904-***-****

(OBIEE/Siebel Analytics, Oracle Applications EBS, ETL & BA Lead Consultant)

Project:

United Health which provides wide range of Specialty insurance for Personal, Health Insurance, Medical

claims nationwide The Aim of the UCDM project is to build Consumers Data marts, Dashboard and Reports

which will have all the consumers’ data, Claims and Policies data for data Analysis and Reporting purpose.

Responsibilities:

Involved in preparation of Technical design and Unit test plan of various RICE components (R – Reports, I

– Interface, C – Conversions (PL/SQL), E – Extensions) on AP and AR.

Developed a report to show Escalation Invoices created between a given date range.

Development of stored procedures, functions and triggers using PL/SQL

• Providing status reports and team timesheets to the client.

Involved in providing onsite / offshore development and support.

• Involved in user training onsite.

• Used Incident control system for incident control and handling change requests.

Building the schema in physical layer as per the business requirements and configuration of

Logical Layer, Logical tables, dimensions and columns. Established the logical joins/keys.

Used Aggregate Tables and specified Aggregate Levels for each source.

Designed Intelligence Dashboards and created Global Filters.

• Configured charts, views, filters in user interface. Configured Global Filters and Prompts in Siebel

Analytics Web.

Used customized, Dashboard prompts & local prompts on UI.

Involved in Unit and Integration Testing & user training of the generated reports in Siebel

analytics web

Designed Prototype of the project repository and developed reports/dashboards to make it easier

for business users to visualize how reports will look like in Siebel Analytics.

Formatting results, Filtering requests, and Showing results with Pivot, Chart, & Views.

• Involved with the Testing team to resolve, fixing and testing problems found during the Systems

integration test, UAT Phases.

• Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load)

processes using Informatica Power Center.

• Documented user requirements, translated requirements into system solutions and developed

implementation plan and schedule.

Environment: Siebel Analytics 7.8.2, Oracle 9i, Toad, Informatica 7.1, Microsoft Windows XP, UNIX



Contact this candidate