Oracle Supply Chain
Resume:
[pic]
*****.*******@****.***
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