[pic]

acpn3v@r.postjobfree.com

Phone: 905-***-****

Summary of Qualifications

. Master's degree in computer science

. Oracle BI Foundation Certified Specialist having 18 years experience

in Oracle Business Intelligence Enterprise Edition (OBIEE) 11g/10g,

Oracle BI Applications (OBIA) 11.x/7.9.x, Oracle E-Business Suite

(EBS) R12/11i, and Oracle development tools

. Experienced in integrating third party applications with Oracle data

warehouse.

. Led and successfully completed large BI projects implementations and

major upgrades

. Expertise in implementation, customizations and extensions of

Financials, Supply Chain and Order Management, Procurement and Spend

Analytics and HR Analytics

. Extensive experience in data warehouse design, ETL/ELT and OBIEE

repository development and customizations

. Experienced in designing, developing and implementing custom solutions

using OBIEE

. Highly proficient in creating reports, dashboards, KPIs and metrics in

the environment of Oracle Business Intelligence Enterprise Edition

(OBIEE) 11g/10g

. In-depth knowledge of dimensional and data vault modeling

. Played key role in implementation, upgrade and support of financials,

supply chain and procurement modules of Oracle E-Business Suite

. Extensive experience in Oracle E-Business Suite implementation,

upgrade, extensions, customizations, migration, interfacing and

conversion with emphasis to Application Object Library (FND), Trading

Community Architecture (TCA), General Ledger (GL), Payables (AP),

Payments (IBY), Receivable (AR), Purchasing (PO), Inventory (INV),

Order Management (ONT) and Advanced Pricing (QP)

. Vast experience of developing applications using Oracle Developer

Suite 10g/6i and registering with E-Business Suite R12/11i

. Extensive experience in building and registering custom reports with E-

Business Suite 11i/R12 and modifying standard reports utilizing Oracle

Reports as per management and user requirements

. Involved in requirement analysis, technical design, development,

implementation, testing, post-production support, application

customizations and upgrades

Technical Skills

Business Oracle Business Intelligence Enterprise Edition (OBIEE)

Intelligence 11g/10g, Oracle BI Applications 11.x/7.9.x (Financials

Analytics, Supply Chain and Order Management Analytics,

Procurement and Spend Analytics, Projects Analytics, HR

Analytics), Oracle Data Integrator (ODI), Oracle BI

Administration Tool, Data Warehouse Administration Console

(DAC), Informatica PowerCenter 9.x/8.x, Oracle BI/XML

Publisher 10g/5.6.3, Oracle Discoverer 10g/4i, Hyperion

Essbase

Enterprise Oracle E-Business Suite R12/11i: Financials (GL, AP, IBY,

Applications AR, FA, CE), Purchasing (PO), Inventory (INV), Order

Management (ONT), Advanced Pricing (QP), Shipping

Execution (WSH), Warehouse Management System (WMS)

Java IDE & Oracle JDeveloper 12c/11g/10g, Oracle Application Framework

Framework (OAF)

Databases Oracle Database 11g/10g/9i/8i/8.x/7.x

Middleware Oracle Weblogic Server, Application Server 10g/9i,

Enterprise Manager 10g/9i

Languages Java, PL/SQL, XML, SQL, HTML

Development Tools / Oracle Forms 11g/10g/9i/6i/6/5/4.5, Oracle Reports

Environments 11g/10g/9i/6i/6/3.0/2.5, Oracle Workflow, Toad for Oracle

11.0/9.7, Oracle SQL Developer, PL/SQL Developer 6,

SQL*Plus, AllFusion ERwin Data Modeler 4.1, ERwin/ERX

3.5/3.0/1.2, Visio, Microsoft Project

Utilities SQL*Loader, impdp, expdp, Telnet, PuTTY, FileZilla, CoreFTP

Operating Systems Sun Solaris 10/9/8, Red Hat Enterprise Linux 5/4, Windows

Server 2003, IBM AIX

PROFESSIONAL CERTIFICATIONS

Agile Product Development Framework

. Certified ScrumMaster (CSM)

Business Intelligence (OBIEE)

. Oracle BI Foundation Certified Implementation Specialist

Software Development

. Oracle Certified Internet Application Developer

. Oracle Certified Application Developer (OCP)

Database Administration

. Certified Oracle Database Administrator

Work Experience

Oracle Business Intelligence Architect

Kaycan, Denver, CO 6-

October-2014 to Date

Worked on implementation of Oracle Business Intelligence Enterprise Edition

(OBIEE) 11g, Oracle BI Applications (OBIA) and custom BI projects:

. Wrote business requirements documents, functional and technical

specification documents for data warehouse development, ETL/ELT

(Extract, Transform, Load) development, building metadata repository,

and creation of reports and dashboards

. Provided recommendation and worked with team to design technical

architecture of BI platform.

. Configured Financials Analytics, Supply Chain and Order Management

Analytics, Procurement and Spend Analytics, Projects Analytics and HR

Analytics

. Setup Oracle Data Warehouse Administration Console (DAC) and created

execution plans for data load from source systems to business

analytics warehouse

. Customized Oracle BI Applications (Financials, Supply Chain and Order

Management, Procument and Spend, Projects and HR) based on user

requirements

. Created custom data warehouse objects: dimensions, facts, materialized

views, aggregate tables.

. Customized mappings, sessions and workflows using Informatica

PowerCenter to load data from source systems to Oracle data warehouse.

. Extended seeded metadata repository (RPD): physical layer, business

model and mapping layer and presentation layer.

. Developed reports and dashboards using BI Analysis Editor

. Maintained library of model documents, templates and other reusable

knowledge assets.

Environment: Oracle BI Enterprise Edition (OBIEE) 11g, Oracle BI

Application (OBIA) 7.9.6.4/11g (Financials Analytics, Supply Chain and

Order Management Analytics, Procurement and Spend Analytics, HR Analytics,

Projects Analytics), Essbase, Oracle Data Integrator (ODI), Oracle

Warehouse Builder, Data Warehouse Administration Console (DAC), Oracle BI

Administration Tool, Informatica 9.1.0 HF2, Oracle BI Publisher, SQL,

PL/SQL, Oracle WebLogic Server, Oracle Enterprise Manager

Business Intelligence and Data Warehouse Architect

PCL, Edmonton, AB 26-May-

2014 to 01-Oct-2014

Project: Worked on design, development and implementation of end-to-end

business intelligence solutions for SMC (Safety Management Center) and

Resources Management group.

. Documented specifications for business intelligence reports,

dashboards, metrics, KPIs and other outputs.

. Created and reviewed technical design documentation to ensure accurate

design and development of BI solutions.

. Designed logical and physical models of data warehouse for SMC and

Resource Management group: created dimensions, facts and aggregate

tables.

. Created mappings, sessions and workflows using Informatica PowerCenter

to load data from Deltek (a CRM application), SMC (in-house developed

applications) and JD Edwards databases.

. Built metadata repository (RPD): physical layer, business model and

mapping layer and presentation layer.

. Developed reports and dashboards using BI Answers.

. Remained involved in unit and system testing of business intelligence

applications.

Environment: Oracle BI Enterprise Edition (OBIEE) 11g, Oracle BI

Application (OBIA) 7.9.6.4 (Financials Analytics, Supply Chain and Order

Management Analytics, Procurement and Spend Analytics, HR Analytics,

Projects Analytics), Essbase, Oracle Data Integrator (ODI), Data Warehouse

Administration Console (DAC), Oracle Warehouse Builder, Oracle BI

Administration Tool, Informatica 9.1.0 HF2, Oracle BI Publisher, SQL,

PL/SQL, Oracle WebLogic Server, Oracle Enterprise Manager, HP UX, Windows

VMs, Microsoft SQL Server 2008

Lead - Oracle Subject Matter Expert

Oracle Business Intelligence

Alberta Health Services (AHS)

17-Dec-2012 to 23-May-2014

Edmonton, AB

Projects: Worked on e-Accounts project for implementation of Oracle

Business Intelligence Enterprise Edition (OBIEE) 11g, Oracle BI

Applications 7.9.6.4 and in-house developed custom BI applications with

Oracle E-Business Suite R12 as main data source:

. Coordinated with Business Managers to translate business requirements

into coherent business intelligence (BI) reports, dashboards, KPIs and

metrics.

. Developed optimal and scalable business intelligence (BI) applications

to meet customer needs.

. Designed, developed, tested and implemented data warehouse systems for

BI reporting and analysis.

. Wrote ETL programs and processes to extract, transform and load data

from various data sources to data warehouse

. Built enterprise metadata repository

. Developed reports, dashboards, KPIs, metrics and other BI artifacts

. Built complex reports that require special skill to develop where

reporting tools were unable to meet requirements; such as Structured

Query Language (SQL) logic.

. Prepared project plan for implementation of Financials analytics,

Procurement and Spend analytics, Supply Chain and Order Management

analytics, HR analytics and Projects analytics

. Implemented Financials Analytics and created custom reports and

dashboards

. Implemented Supply Chain and Order Management Analytics

. Completed setups and configurations of Procurement and Spend Analytics

. Prepared project plan and worked on extensions and customizations of

Supply Chain and Order Management Analytics

. Identified business needs and determined solution related to BI

problems

. Wrote business requirements documents

. Prepared functional specification, technical design and user training

documents

. Prepared project plan and built custom dashboards for MR Enhancements

to provide unified view of Financials, HR, Procurement and Spend,

Supply Chain and Order Management, Projects and other analytics to a

large number of front line managers

. Worked on prototype of Executive Dashboard to provide Key Performance

Indicators (KPIs) to senior executives

. Created logical designs and star schemas of data warehouse for in-

house developed BI applications

. Assembled subject areas for various analytics and built execution plan

for full and incremental load

. Loaded data into business analytics warehouse using DAC from E-

Business Suite 12.1.3 and PeopleSoft 8.9.

. Delivered presentation to various stakeholders: management, end-users,

IT and BAS departments

. Diagnosed data load issues of Financials, Supply Chain, HR, and

Procurement and Spend Analytics using DAC log and Informatica Workflow

Monitor.

. Resolved data load issues utilizing Data Warehouse Administration

Console (DAC) and Informatica client tools (Designer, Workflow Manager

and Repository Manager)

. Developed several dashboards related to Financials, Supply Chain and

Procurement.

. Identified and fixed bugs in reports and dashboards

. Used PowerCenter Designer to build mappings that extracted data from

various sources and loaded to targets, transforming as necessary.

. Used PowerCenter transformations to cleanse, format, join, aggregate

and route data to the appropriate targets

. Performed error handling/trapping using PowerCenter mappings

. Used PowerCenter Workflow Manager to build and run workflows

. Designed and built complex mappings and workflows based on business

needs.

. Performed advanced troubleshooting using PowerCenter logs and

debugger.

. Customized the Physical, Business Model and Mapping, and Presentation

layers of OBIEE repository.

. Created dimension hierarchies and level-based measures.

. Modeled aggregate tables to speed up processing.

. Modeled partitions and fragments to improve application performance

and usability.

. Used variables to streamline administrative tasks and dynamically

modify metadata content.

. Used time series functions to support historical time comparison

analyses.

. Used bridge tables to resolve many-to-many relationships between

dimension and fact tables.

. Used helper tables to maintain team-based hierarchical relationships

in a dimension table.

. Used implicit fact columns to select fact tables for dimension only

queries.

. Completed a number of Oracle EBS tasks that were required for BI

projects

. Prepared operation manual and status reports for BI software

Environment: Oracle BI Enterprise Edition (OBIEE) 11g/10g, Oracle BI

Application 7.x (Financials Analytics, Supply Chain and Order Management

Analytics, Procurement and Spend Analytics, HR Analytics, Projects

Analytics), Oracle Warehouse Builder, Oracle Data Integrator (ODI), Data

Warehouse Administration Console (DAC), Oracle BI Administration Tool,

Informatica 9.1.0 HF2, Oracle JDeveloper 10g, OAF, Oracle Forms 11g, Oracle

Reports 11g, SQL, PL/SQL, Oracle WebLogic Server, Oracle Enterprise

Manager, Oracle E-Business Suite, Microsoft SQL Server 2005

Oracle BI Developer

KP Building Products Ltd., Milton, ON 17-

May-2010 to 30-Nov-2012

Projects: Worked with onsite and offshore teams for implementation of

Oracle Business Intelligence Enterprise Edition (OBIEE) 11g and Oracle BI

Applications 7.9.6.3.

Extensions, personalization, customizations and upgrade of Oracle E-

Business Suite modules using Oracle Forms, Oracle Reports, Oracle XML

Publisher (BI Publisher), PL/SQL, CUSTOM.pll and Oracle Database objects.

Integration of 3rd party applications with Oracle E-Business Suite:

. Wrote business requirement documents for implementation of various BI

projects

. Provided technical assistance in the use of business intelligence

solutions by translating business requirements into technical

solutions.

. Implemented OBIEE 11g and BI Applications 7.x: Oracle Financials

Analytics, Oracle Supply Chain and Order Management Analytics, Oracle

Procurement and Spend Analytics, Projects Analytics and HR Analytics

. Customized and extended Oracle Business Analytics Warehouse,

Informatica ETLs, OBIEE Repository and Web catalog as per business

needs.

. Prepare functional specification and technical design documents for

custom extensions and in-house developed BI projects

. Created logical and physical designs for custom-built BI software

. Set up security to authenticate users and assign appropriate roles and

privileges.

. Applied cache management techniques to maintain and enhance query

performance.

. Enabled usage tracking to track queries and database usage, and

improve query performance.

. Set up and used multi-user development environment.

. Configured Oracle BI to support multilingual environments.

. Used Administration Tool utilities and wizards to perform

administrative tasks.

. Identified best practices for optimizing end-user query performance

when implementing Oracle BI Enterprise Edition.

. Identified and applied repository design principles and best

practices.

. Demonstrated out-of-the-box and custom-built BI software to various

organizations with Kaycan group.

. Managed Oracle business intelligence using Fusion Middleware Control

and Weblogic Server Administration Console.

. Created and modified Business Intelligence requests using Oracle

Business Intelligence Answers

. Created and modified BI reports, interactive dashboards, KPIs and

metrics

. Used Oracle BI Delivers to configure, schedule, and deliver

personalized alerts to Interactive Dashboards using iBots

. Performed administrative tasks related to the development and

configuration of Interactive Dashboards

. Customized Oracle BI Presentation Services Interface.

. Used Oracle BI Publisher reports based on Answers requests

. Setup, configured and used Oracle BI Publisher Enterprise to developed

all kind high-fidelity reports consisting of tables, graph, charts

etc.

. Created and used rich text format (RTF) templates using BI Publisher

Desktop.

. Employed BI design principles and best practices recommended by Oracle

Corporation

. Post implementation support

. Provided weekly maintenance report to management related BI

applications

. Developed 100+ extensions to Oracle E-Business Suite to augment the

functionality of Oracle E-Business Suite modules

. Wrote MD.050: Application Extensions Functional Design, MD.060:

Database Extensions Design and MD.070: Application Extension Technical

Design for customization and extensions of E-Business Suite

. Developed user interfaces for Oracle E-Business Suite R12 utilizing

Oracle Forms 10g

. Wrote procedures, functions, packages and trigger required to

implement extensions

. Prepared master plan for reports upgrades based on management and

users' requirements

. Remained actively involved in building reports based on Oracle E-

Business Suite database

. Optimized and debugged large number of custom reports using BI

Publisher

. Converted numerous reports from Oracle Reports 6i to XML/BI Publisher

10g

. Developed new reports using XML/BI Publisher for E-Business modules

. Developed a program to extract and transform price lists into tab

delimited text files operating unit-wise, segregated into retail and

wholesale for FileMaker. (E436-v1 & v2)

. Wrote readme for each extension for quality control and migration of

extension to PROD

. Provided management with recommendations on enhancements to existing

functionality and implementation of new functionality in EBS

. Extensively involved in development, testing and implementation of

extensions to Oracle E-Business Suite and integration with various

modules

. Produced documentation related to extensions and developed objects

that adhere to standards set for the E-Business Suite Project.

. Wrote a package for common utilities that can be used across all

modules of E-Business Suite.

. Developed procedure to update AP Expense Report Import Interface

. Created a process and registered as a concurrent program to run in

SQL*Plus environment for mass salesreps updates.

. Updated sales history package by adding minmax_sales_total function

and modified cursors for adding legacy historic sales data.

. Developed XML invoice to generate outbound EDI invoices.

. Built Invoice Print Preview Report for invoice verifications prior to

transmittal in an effort to minimize the number of rejections.

. Wrote a package to update receivables line interface table so that

they will be ignored by the printing programs to avoid the situation

where SHIP_TOs may take the credit twice.

. Created function to avoid problem of pick slip print to wrong branch

when releasing for same user in fast sequence.

. Updated CUSTOM.pll to default the customer po number prefix in the

sales order form for those customer SHIP_TOs where it was required.

. Built Special Price Expiration Report that provides volume rebate by

buying group, customer, item category etc.

. Developed Wholesale Price List Expiration by Item Group

. Create a PL/SQL library that deal with Wholesale Price Lists -

Approval for Price Less than Minimum Price

. Built 'Kaycan - Customer Price List Specials by Item Category' to

allow lines from multiple price lists to be queried with criteria for

item categories and saved in Excel format through XML Publisher. It

was developed for pricing department that often need to do mass

analysis of customer 'specials' and other primary price list lines.

. Developed Wholesale Pricing Specials Extension Process to streamline

the process of renewing specials, including allowing an easier way to

extend Vinyl, Aluminum or 'Other' specials separately.

. Created extension to allow the correct rebate to be returned for each

item, given the appropriate date.

. Created concurrent program to set sub-inventory quantities to zero.

. Developed extension to customize WIP pallet label to allow the

printing of the Pallet Label (skid labels), with information that

cannot be printed through standard Oracle E-Business Suite features.

. Built report using BI Publisher that comprised of intercompany

transactions in any given fiscal month.

. Personalized the standard customer form to incorporate a number of

custom feature including: disallow entry of tax code at customer bill-

to site

. Developed Kaycan - Pick Slip for No-Ship Lines by Request Date that

was meant to be used as a packing document for Industrial Coil orders

where the order is entered at Kaycan Canada head-office and the

manufacturing and shipping will be handled by the legacy system of the

related company Weatherstrong.

. Modified Compensation Credit Process form where users can enter the

compensation credit and price break information, including the

percentage discount that they are entitled to.

. Designed and developed extension that gave the pricing department a

tool to use in order for them to be able to renew compensation credits

without any intervention by IT.

. Developed pick slip document, including a bar code for each pick slip

number, in order to scan shipments using Oracle Warehouse Management

System (WMS).

. Built reports using BI Publisher: Users with a Given Responsibilities

and Customers by Sales Person as per criteria given by the users.

. Updated Sales Order Acknowledge to incorporate new tags in XML output

and modify existing ones.

. Developed extension to generate labels using Zebra printers

. Customized packing slip that incorporated features not included in the

seeded reports.

Environment: Oracle BI Enterprise Edition (OBIEE) 11g/10g, Oracle BI

Application 7.9.6.3; Informatica PowerCenter 9.0.1, Oracle BI

Administration Tool, Data Warehouse Administration Console (DAC), Oracle E-

Business Suite R12/11i: Financials [General Ledger (GL), Payables (AP),

Payments (IBY), Receivables (AR), Assets (FA), Cash Management (CE)],

Purchasing (PO), Inventory (INV), Order Management (ONT), Advanced Pricing

(QP), Shipping Execution (WSH), Warehouse Management (WMS); Oracle

JDeveloper 10g, Oracle Application Framework (OAF), Oracle Forms 10g/6i,

Oracle Reports 10g/6i, Oracle BI/XML Publisher 10g/5.6.x, Oracle Data

Integrator (ODI), Toad 9, HP UX, SQL, PL/SQL, Microsoft SQL Server 2005

Senior Oracle BI/Apps Consultant

Saudi German Hospitals (SGH) Group, Jeddah December 03,

2003 - February 28, 2010

Projects: Worked with an offshore team for implementation of OBIEE (Oracle

Business Intelligence Enterprise Edition) 10g, Oracle BI Applications,

Oracle EBS: Financials (GL, AP, AR, FA, CE), Oracle Purchasing (PO) and

Oracle Inventory (INV) for 5 hospitals, 4 nursing institutes and 18

subsidiaries:

Worked as Senior Apps Technical Consultant in the implementation team of

Oracle Financials (GL, AP, AR, FA, CE), Purchasing (PO) and Inventory (INV)

at Saudi German Hospital, Grand Gold's Gym, Jeddah and Saudi German

Institute for Nursing and Allied Health Sciences (SGNA).

. Implemented Oracle Business Intelligence Enterprise Edition (OBIEE)

10g and Oracle BI Applications

. Configured Financials Analytics, Supply Chain Analytics, and

Procurement and Spend Analytics

. Created and modified BI reports, interactive dashboards, KPIs and

metrics to meet business requirements

. Customized OBIEE repository to implement data security and extend

metadata for customized reports

. Customized Informatica mappings to load flexfields and custom tables

data

. Worked on dimensional ER modeling and data warehouse schemas

. Prepared weekly software maintenance report for chief operating

officer

. As part of onsite Implementation team responsible for Development of

Interfaces & Reports

. Worked on revenue and payroll applications integration with Oracle E-

Business Suite: wrote several packages, procedures, functions to fetch

data from HIS to interface tables, process them and load into

GL_INTERFACE table

. Designed interface database that keeps reference and temporary data

that is to be loaded from HIS to ERP and back from ERP to HIS

. Customized standard Oracle Applications reports based on user and

management requirements

. Built and registered new reports in Oracle Applications that were not

available in the packaged software

. Developed interface between Oracle General Ledger and ATS University

Information System using PL/SQL

. Developed interface between Oracle Applications and Aphelian software

utilizing PL/SQL

. Created users, assigned/modified responsibilities, changed profile

options as needed

. Defined various value sets, executables, concurrent programs, request

set and attached in request group

. Interacted with functional team to resolve all technical issues

reported by end-users

. Supported developers in tuning database and applications for optimal

performance, monitor database growth and provide database capacity

planning for applications expansion.

. Involved in daily maintenance, performance monitoring, analyzing

indexes, tables, schemas, and database as needed, checking

export/imports, space management, SQL tuning, performing ad-hoc SQL

for users

. Provided 24x7 on call technical support resolving high priority

issues.

IVP Program Development and Integration with Oracle Business Analytics

Warehouse

. Prepared software requirements specification (SRS) document in

consultation with users and management.

. Designed the system, made schema, granted privileges & roles, and

created objects

. Developed interfaces to schedule/cancel visits, invite a professor,

. Built modules to make reporting process paper-free.

. Wrote procedures and create materialized views to integrate to the

database with Oracle General Ledger

. Tested the system to explore logical bugs and verify fulfillment of

user requirements.

. Implemented the system in 3-tier environment.

. Developed interface between IVP and Oracle data warehouse

Trauma Software System Development and Integration with Oracle

Business Analytics Warehouse

. Designed and developed Trauma Software System single-handedly to help

run Trauma Campaign

. Created tables, constraints, views, and indexes etc.

. Developed interfaces to enter attendance in trauma meetings, monthly

achievements, referral-focus area relationships etc.

. Wrote various PL/SQL packages, functions, procedures and stored

procedures to implement the business rules uncovered in the database

design.

. Built reports to monitor hospitals growth in trauma-related cases,

select best area manager based on 7 performance factors, hospitals

comparison, alerts/reminders etc.

. Deployed software in 3-tier environment on Oracle Application Server

10g and administered using Oracle Enterprise Manager 10g

. Integrated the software with Oracle data warehouse for BI reporting

Scientific Activities Systems Implementation and Integration with Oracle

Business Analytics Warehouse

. Analyzed and designed the system using Oracle Designer 9i

. Developed forms using Oracle Developer 10g

. Built all graphical and statistical reports for decision making

. Wrote PL/SQL packages, functions and procedures to enforce business

rules and relationship uncovered in the data model.

. Tested the system to make sure the system complies with user

requirements and confers with best international software development

standards

. Implemented the system at multiple locations connected with

centralized database server

. Created interface between application and Oracle business analytics

warehouse

Life Support Training System Implementation and Integration with Oracle

Business Analytics Warehouse

. Actively participated in analysis of the system that automates

Center's Training Financial activities.

. Made logical and physical ERDs of the system.

. Wrote packages, stored procedures and function to handle server-side

computations

. Coded database triggers for enhanced database security and to

effectively implement authorization policy

. Developed front-ends of the system using Forms 10g

. Built nested matrix, form letter and mailing label reports.

. Built interface with Oracle business analytics warehouse for BI

reports

Environment:

Oracle Business Intelligence Enterprise Edition (OBIEE) 10g, Oracle E-

Business Suite R12/11i, Oracle Database 10g, Oracle Developer Suite

10g, Oracle JDeveloper 10g, Oracle Application Framework (OAF), Oracle

XML Publisher, Oracle Application Server 10g, AllFusion Erwin Data

Modeler, Microsoft Project 2000, Sun Solaris 10, SQL, PL/SQL, TOAD 8,

Discoverer 10g, Microsoft SQL Server 2000

Senior Systems Analyst (Oracle BI Discoverer/Oracle E-Business Suite 11i)

IT Dept, Attock Refinery Limited (ARL), Rawalpindi

June 28, 1999 - December 01, 2003

Project: Implementation of Oracle Applications 11i (GL, AP, AR, FA, CE),

Purchasing (PO), Inventory (INV), Oracle Discoverer. Development of in-

house applications that augment E-Business Suite functionality and

integration with Oracle Applications 11i; development of custom reports and

registration with Oracle Applications 11i

Oracle Discoverer 4i Implementation:

. Implemented and administered Oracle Business Intelligence (BI)

Discoverer

. Designed, created, and maintained End User Layer (EUL) for BI

reporting from several applications

. Controlled user access to the EUL

. Customized the EUL

. Optimized query performance using summaries

. Submitted BI software operations report periodically to management

. Developed and customized BI reports, interactive dashboards, KPIs

and metrics as per business needs

Gross Refiners Margin (GRM) Interfacing with Oracle Discoverer

Description: This system has been analyzed and designed using Oracle

Designer 6i.

This application was developed to provide the Chief Executive Officer

and Finance Department with complete and comprehensive information

regarding targets, throughput, production, financial indicators,

sales, expenses, manpower etc. of all sections, departments and

subsidiaries of the Company. The purpose of the software is to

streamline the operations, measure the productivity and to make the

environment paper-free for generation of wellness reports and to

prepare Gross Refiner's Margin (GRM).

. Made process model, DFD, ER-diagram using Oracle Designer

components

Contact this candidate