Sample Template Example of Beautiful Excellent Professional Curriculum Vitae / Resume / CV Format with Career Objective, Job Description, Skills & Work Experience for Freshers & Experienced in Word / Doc / Pdf Free Download
Download Resume Format
Oracle SQL and PL/SQL Certified Professional
U.S.
Citizen
Summary
|
·
I
have 16 years experience in OBIEE / ETL
Informatica / ODI / OWB / OBIEE+ /
Siebel Analytics / BI Applications / EPM / Data Warehousing / ETL
architect, technical expert, technical lead and project management, involving
full lifecycle software implementation projects.
·
Architect
Leadership capability for OBIEE, OBIEE+, EPM / BI Applications Financials,
Supply Chain, Order Management & Fulfillment, Human Resources, Sales,
Service & Contact Center, Marketing / report / dashboard, Datawarehouse,
ETL Informatica / ODI / OWB, OLAP, BI Publisher / Discoverer, Hyperion,
Essbase, Oracle Fusion Middleware (SOA/WebLogic), change capture GoldenGate
for large and small projects.
|
||
PROFESSIONAL EXPERIENCE
From 1994 to Present: Sr.
BI/DW Developer / Architect / Administrator
|
|||
OBIEE
Data Warehoue, ETL tools Informatica / ODI / OWB / OBIEE / OBIEE+ / Siebel Analytics / BI
Application Financials, Supply Chain, Order Management
& Fulfillment, Human Resources, Sales, Service & Contact Center,
Marketing / EPM / report /
dashboard, OLAP, BI Publisher / Discoverer, Hyperion, Essbase
|
·
Working as Data Warehouse / ETL Expert / Developer
/ Architect Administrator for ETL tools Informatica / Oracle Data Integrator
(ODI) / Oracle Warehouse Builder (OWB), Data warehouse data modeling, logical
and physical architecture, ETL architecture and configuration, metadata,
repository for Oracle Business Analytics Warehouse (OBAW) / BI Applications
Financials, Supply Chain, Order Management & Fulfillment, Human
Resources, Sales, Service & Contact Center, Marketing.
·
Hands-on Expert in ETL Informatica Designer /
Informatica Workflow Manager / Building SDE and SIL Mappings / Mapplet / Data
Warehouse Administration Console (DAC) / Customizing, Configuring, Populating
the Oracle Business Analytics Warehouse / Change Capture Process / Adding
Columns to an Existing Dimension Table / Adding a New Dimension in OBAW /
Capturing and Applying Deletes / Building Auxiliary Change Capture / Managing
the OBAW Performance, change capture GoldenGate.
·
Create, Deploy and Execute ETL processes.
·
Install, configure, manage, administration the
Oracle Business Analytics Warehouse (OBAW) components.
·
Use Data Warehouse Administration Console (DAC) to
Run ETL routines and populate the Oracle Business Analytics Warehouse.
·
Customize and extend the Oracle Business Analytics
Warehouse (OBAW).
·
Configure the ETL process to improve performance.
·
Extract: Working with extract data from flat files
and relational database.
·
Transform: Create source-to-target ETL mappings to
cleanse and match-merge, deploy and execute ETL mappings.
·
Load: Schedule, Manage, Troubleshooting,
Performance-tuning Data Warehouse / ETL Loading processes.
·
Recommended implementation methodology and best
practices.
·
ETL tools and OBI EE integration
·
Working as OBIEE Expert / OBIEE Developer / OBIEE
Architect / OBIEE Administrator / Business analyst / Data modeler / Database
designer / Data warehouse analyst / Technical consultant / Technical business
analyst for BI Applications Financials, Supply Chain, Order Management &
Fulfillment, Human Resources, Sales, Service & Contact Center, Marketing.
·
Hands-on Expert in Oracle BI Enterprise Edition
Architecture, Build the Physical, Business Model and Mapping, and
Presentation layers of a repository, Set up query logging for testing and
debugging, Working with Oracle BI Answers to run queries to test and validate
a repository, Filtering Requests in Oracle Business Intelligence Answers,
Building Views and Charts in Requests, Gauge View, Pivot Table, Creating
Oracle Business Intelligence Interactive Dashboards, Configuring Oracle
Business Intelligence Interactive Dashboards, Working / Integrating Oracle BI
with Microsoft Office.
·
Add multiple sources to business model objects,
Build simple and calculated measures for a fact table, Create dimension
hierarchies and level-based measures, Model aggregate tables to speed up
processing, Model partitions and fragments to improve application performance
and usability, Working with variables to streamline administrative tasks and
dynamically modify metadata content, Working with time series functions to
support historical time comparison analyses, Working with bridge tables to
resolve many-to-many relationships between dimension and fact tables, Working
with helper tables to maintain team-based hierarchical relationships in a
dimension table, Configure Oracle BI to support multilingual environments,
Working with implicit fact columns to select fact tables for dimension-only
queries, Create a repository using a multidimensional data source, Set up
security to authenticate users and assign appropriate permissions and
privileges.
·
Working with cache management techniques to
maintain and enhance query performance, Working with usage tracking to track
queries and database usage, and improve query performance, Set up and use a
multi-user development environment, Working with Administration Tool
utilities and wizards to perform administrative tasks, Working with
write-back, iBot, Advise customer on best practices for Oracle BI Enterprise
Edition and repository design principles.
·
Creating BI Publisher Reports Based on Oracle Database, Creating RTF Templates Using BI
Publisher Desktop, Creating BI Publisher Reports with Parameters, List of Values
(LOVs), and Hyperlinks, Working with PDF and eText Templates, Oracle BI
Publisher Server Administration, Scheduling Reports and Analyzing Data,
Translating Reports, Creating Reports by Defining XML Data Templates,
Integration Oracle BI Publisher with OBIEE and BI Discoverer, Creating BI
Publisher Reports Based on Various Data Sources. Working with Oracle
Discoverer Destop, Discoverer Plus Analyze Relational / OLAP Data and
Discoverer Admin.
·
Worked as Siebel Analytics Server Architect /
Siebel Analytics Data Warehouse Developer / Siebel Analytics Application
Developer, Build the Physical, Business Model and Mapping, and Presentation
layers of a Siebel Analytics repository, Test and validate a repository, Add
measures to a Fact table, Build dimensional hierarchies and level-based
measures, Working with partitions, fragments, and aggregates to enhance
Analytics Server performance, Model time series data and slowly changing
dimensions, Implement Analytics security to restrict access to sensitive
data, Manage Analytics cache, recommended implementation methodology, Working
with dependency tracking, Configure implicit fact columns, Configure bridge
and helper tables, Working with row-wise initialization blocks, Set up a
Siebel Analytics multi-user development environment, Administer the Scheduler
Server and tables, Working with Localization Siebel Analytics deployment to
support globalization, Working with performance tuning using caching, usage
tracking, Cluster Siebel Analytics Servers.
·
Workig with Replication options for Siebel
Analytics Web catalogs, Siebel Analytics and Siebel Relationship Management
Warehouse, Install Siebel Relationship Management Warehouse components, Build
Siebel Extract, Transform, and Load (ETL) routines, Working with Siebel Data Warehouse
Application Console (DAC) to run ETL routines to populate the Siebel
Relationship Management Warehouse, Configure the ETL process to improve
performance, Customize the Siebel Relationship Management Warehouse, Working
with change capture process, Capture and apply deletes to the SRMW, Build
auxiliary change capture, Build slowly changing dimensions, Working with
command line to access the DAC server, Populate a custom set of date
dimension values, Customize the ETL process to selectively refresh the SRMW,
Migrate ETL mappings and workflows, Migrate Informatica repository, Migrate
DAC repository, Working with Siebel Analytics Bridge applications,
Configuring the SRMW.
·
Create and modify Analytics requests using Siebel
Answers, Create and modify Intelligence Dashboards, Create guided navigation
links within Intelligence Dashboards, Working with Siebel Delivers to
configure, schedule, and deliver personalized alerts to Intelligence
Dashboards through intelligence agents (iBots), Perform administration tasks
related to the development and configuration of Intelligence Dashboards,
Customize the Siebel Analytics Web user interface, Integrate Intelligence
Dashboards into Siebel eBusiness Applications, Create and modify requests in
Siebel Answers, Filter requests in Siebel Answers, Format results in Siebel
Answers, Create and modify views in Siebel Answers, Working with pivot table
views, gauge views, Create and modify Intelligence Dashboards, Customize the
Siebel Analytics Web user interface, Administer Siebel Analytics Web,
Administer the Siebel Analytics Web Catalog.
·
Working with OBIEE+ Suite, Oracle BI Server,
Hyperion Foundation Services, Hyperion BI Tools, BI Disconnected Analytics,
BI Office Plug-in, BI Interactive Dashboard, Briefing Books, Smart View, Smart
Space, Financial Reporting, SQR Production Reporting, Interactive Reporting,
Web Analysis, Financial Performance Management Applications, Essbase.
|
||
SOA/WebLogic, Web
Serivces, BPEL, ESB Integration
|
·
Working as SOA/WebLogic Architect / Integrator /
Designer, SOA Integration with Oracle Data Integrator (ODI), Web services,
Configure data services, Generate, deploy, and test data services, Install
and use public Web services, Execute Web services, Invoke a public Web
service using the OdiInvokeWebService tool, Process a Web service response,
Design BPEL / Enterprise Service Bus (ESB) processes.
|
||
CAPABILITIES |
|||
Methods & Techniques
|
·
BI / EPM / Data Warehouse / ETL Implementation
·
Project Management
·
Process Reengineering
·
Quality Control Management
|
·
Software Development Lifecycle
·
Project Control and Reporting
·
Resource Management
·
Configuration Management
|
|
Applications
|
·
BI Applications / Siebel Analytics
·
Business Intelligence OBIEE
·
Hyperion EPM
|
·
Oracle EBS
·
Siebel
·
PeopleSoft
·
JD Edwards
|
|
TRAINING |
|||
Training
|
·
Oracle OBIEE
·
Siebel Analytics
·
OBIEE+, Hyperion EPM, Essbase
|
·
Discoverer / BI Publisher
·
ETL Informatica / ODI / OWB
·
Change Capture GoldenGate
·
Oracle SOA/WebLogic
|
|
Education
|
·
BS Computer Science, 1994
|
||
Languages
|
·
English
|
||
Download Resume Format
0 comments:
Post a Comment