Sales Oracle
Resume:
Riz Syed (abhcly@r.postjobfree.com) – 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 (abhcly@r.postjobfree.com) – 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 (abhcly@r.postjobfree.com) – 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 (abhcly@r.postjobfree.com) – 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 (abhcly@r.postjobfree.com) – 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 (abhcly@r.postjobfree.com) – 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 (abhcly@r.postjobfree.com) – 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 (abhcly@r.postjobfree.com) – 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 (abhcly@r.postjobfree.com) – 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 (abhcly@r.postjobfree.com) – 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 (abhcly@r.postjobfree.com) – 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