Oracle Manager

Objective

Technical

Skills

Sadaqat Ali

My aim is to achieve a responsible position in a professional working environment and more over I am looking forward to join a dynamically growing organization where my potential and skills, can be efficiently utilized and rewarded accordingly.

Oracle Database: 12c,11g, 10g

Install and configure Oracle database software, Configuring RMAN to create and manage database backups and recovery, Upgradation, Configuring and Using Oracle Enterprise Manager to manage and administer and tune Database and instance, Create Tablespaces, users and other schema objects i.e. Functions, Procedures, Tables and views etc. Using SQL Loader and Data Pump to import data into the database, execute disaster recovery plans, Diagnose and resolve the various database problems on the basis of database log files, Basic Concepts of RAC Environment, Unix shell, Batch scripts

Oracle Application R12

Installing and Patching Oracle Application R12

Experience is implementation, upgradation, customization of Oracle EBS

Application. This includes system study, design, development, post implementation

maintenance and support of Oracle EBS

Maintenance of Oracle Application R12 using Oracle Application Manager(OAM)

System Administration i.e. User creation, Customized Responsibility Creation,

Customized Menu Creation, Managing Concurrent Requests

Understanding of business flows, underlying technical architecture and table structure

of Oracle EBS

Hands-on experience with Report and Form development

Experience in Oracle PL/SQL Development I.e. Stored Procedures, Packages,

Functions & Triggers

Experience in working on SQL*Loader, SQL* Plus, Oracle Import/Export utilities

Knowledge of Application Object Library (AOL) implementation standards, Software

Development Life Cycle (SDLC)

Create schema objects i.e. Functions, Procedures, Tables and views

Experience in designing, developing, testing, performance tuning and supporting

database applications using Developer Tools (Reports 10g/11g, XML/BI Publisher)

OAF (Oracle Application Framework)

Workflows and Alerts

Personalization and Custom.pll

Uploading through ETL

Dataguard: Oracle 10g

Configuring Primary and Physical Standby Databases

Implementing Real Time logs Shipping to Standby from Primary Database

Implementing logs Apply to Standby

Database Tools: Toad, SQL Developer, Data Pump, SQL Loader, BI Publisher, Jdeveloper

Operating System: Red Hat Enterprise Linux 5, OEL X, Windows Vista, Windows Xp

Programming Languages:

SQL, PL/SQL, Java, C++, VB.net, Asp.net

Academic Qualification

Professional Experience

BS (Hons.) in Computer Sciences

University: Government College University, Lahore, Pakistan(Fall 2005- 2009)

Intermediate in Computer Science

Institution: Federal Government Inter College, Jhelum, Pakistan (2003-2005)

High School Certificate (Science Group)

Institution: Government High School, Sara-i-alamgir, Pakistan (2001-2003)

Wipro Technologies (Jul 2018 to Present)

Technical Consultant Hyperion Admin

I am Technical consultant at Wipro and working on the following project

Global Eagle Entertainment

Install and configure EPM Products (Foundation, Planning, Essbase, Financial

Management (HFM), Financial Close Management (FCM), Data Relationship

Management (DRM), FDMEE/ODI)

Installation and configuration of SOA

Patching and Cloning on Oracle Hyperion

Monitoring and Performance Optimization of EPM System and Essbase Server

Backup and Recovery

Performance Tuning

Applying latest patch set

Integration of Hyperion with EBS

Installation and configuration of OBIEE 12c

User Access Management

Orabits Solutions (Aug 2017 to Jun 2018)

Senior Technical Consultant (Remote Support)

I was Senior Technical consultant at Orabits. My responsibilities were

Upgradation of Oracle EBS R12/Database/Hyperion EPM

Installation of Financial Data Quality Management Enterprise Edition

Performance Monitoring

Backup and Recovery

Uploading the data from non-ERP to Oracle Erp through Procedures/ETL

Patching and Cloning

Beaconhouse School System, Lahore, Pakistan (Oct 2012 – Aug 2017)

Assistant Manager - ERP

Oracle EBS R12

I was the Assistant manager at Beacon house education System. My responsibilities were

Developed customized oracle reports of modules, Oracle Payables, Oracle

Receivables, Oracle Purchasing, Oracle Property Manager and Oracle Fixed

Asset Management

Manage Notification Mailer for Purchase Order and Purchase Requisition.

Form development.

OAF (Oracle Application Framework).

Oracle Alerts.

Data Uploading.

Uploading files through ETL.

Personalization.

Patching on Oracle Application R12.

Taking Backups.

Cloning on Oracle Application R12.

Created and updated SRs on Oracle Support for technical issues resolution.

Server Tasks like Linux installation.

Maintenance Oracle Application R12.

Upgradation of Application and Database.

Oracle Hyperion

Installation of Oracle Hyperion Planning and Essbase on Linux

Installation of Oracle Financial Data Quality Management and ODI on

Windows

Patching and Cloning on Oracle Hyperion

Monitoring and Performance Optimization of EPM System and Essbase Server

Backup and Recovery Developing Business Rules

Developing Data Form

Creating new members of dimensions and assigning security

Developing Reports on Hyperion Web Analysis/Hyperion Financial Reporting

Creating users and groups

Hands on Experience on Shared Services/Workspace/Hyperion Planning/Smart

View

Define Mapping

Installation/Configuration and maintenance of ODI/FDMEE

Integration of Hyperion with Oracle EBS through ERPI/Data Management

Data Uploading using ODI

Write back data from Hyperion to EBS

Upgradation of Hyperion from 11.1.2.2 to 11.1.2.4

Oracle Database

Installation of Oracle Database on linux

Patching & Cloning

Monitoring and Performance Optimization

Backup and Recovery

Creation of Functions, Procedures, Views, Tables, Indexes

PWC Pakistan (July 2011 – Sep-2012 )

Consultant

I was the Assistant Consultant at A.F.Ferguson & Co. and worked on the following projects

Educational Services (Pvt) limited, Lahore, PK (Beaconhouse & The Educators)

Service Industries (Pvt) limited, Lahore

Berger Paint (Pvt) limited, Lahore

Developed customized oracle reports of modules, Oracle Payables, Oracle

Receivables, Oracle Inventory Management, Oracle Purchasing and Oracle

Fixed Asset Management, Oracle Master Scheduling MRP.

Configured Notification Mailer for Purchase Order and Purchase Requisition.

Personalization.

Patching on Oracle Application R12.

Data Uploading.

Uploading files through ETL.

Cloning on Oracle Application R12.

Certification and Trainings

Created and updated SRs on Oracle Support for technical issues resolution.

Server Tasks like Linux installation.

Maintenance Oracle Application R12.

Edentel (Pvt.) Limited, Lahore, Pakistan (Jan 2011 – Mar 2011)

Junior DBA

I have been the part of the technical team at Edentel (Pvt.) Limited during the implementation of Oracle EBS R12 (Financial Module) at Orient Power Group.

Managing and Maintaining Oracle EBS R12 Servers Environment

Backup and Recovery Plans

Diagnosing and Resolving Various Database Related Issues

Shell Scripting to Automate the Maintenance Tasks

Patching Oracle Application

Basic System Administration Tasks Related to Oracle Application

OCA 11g Database

Certification

Oracle Corporation USA

11g DBA

Training

Oranet Training and Solutions, Lahore

Apps DBA

Training

Oranet Training and Solutions, Lahore

Oracle 10g Dataguard

Workshop

Oranet Training and Solutions, Lahore

Oracle 10g RAC

Workshop

Oranet Training and Solutions, Lahore

Contact this candidate