Oracle Apps DBA
DHA Lahore
Total years of experience :24 years, 3 Months
DHA Lahore Feb’2010 - Present
Oracle Apps DBA
Implementations in brief:-
· Installed and Configured (Single Node / Dual Node) Enterprise Business Suite R12.1.1
· Upgraded from Enterprise Business Suite R12.1.1 to Enterprise Business Suite R12.1.3
· Cloned Enterprise Business Suite R12.1.3 from Dual Node to Single for Test and Development Server
· Raised SR and implemented specific workaround by applying Patches and Data fixes.
· Involved in Patching and upgrade of Modules recommended By Oracle Support.
· Worked as System Administrator for Rights management, Supplier, Banks, GL periods opening and Closing
· Managed User Responsibilities and Privileges for EBS Modules (GL, AP, AR, CM, FA)
· Resolved Concurrent manager Performance Tuning issues with Gather Schema Stats and SR Support.
· Implemented Disk Backup Schedule on Daily and Weekly basis using Linux Crontab, Tar Utility and RMAN.
· Installed Client Software Net Backup 7.1 for Tape Backup Solution on All DB and Apps Servers
· Implemented Schedule Policy using Net Backup 7.1 by creating daily and weekly Policies.
· Integrated Legacy Payroll, Transport, and Billing Software with EBS R12 with required formats.
· Performed Daily Monitoring and Troubleshooting for smoothly running of all servers.
· Developed Custom Reporting for Fin, HRM, Payroll based on formal analytical expertise.
Oracle Core DBA
Worked as Oracle DBA in following domains as under:-
· Installed and configured 11g DB Servers with Red hat Linux 64bit OS for PMS, GIS, IBM ACM.
· Installed and maintained Oracle Web logic Server and Form/Reports Server
· Disaster Recovery Plan Implementation Best Practices
· Installed and Configured Oracle Golden gate based on Bi directional on Test Machines
· Implemented Backup Schedules for All Database Servers using Recovery Manger (RMAN)
· Configured and Implemented Flashback operations with 3 days retention on Production Servers.
· Implemented RMAN retention policy for Window of 21 days (3 weeks Retention) on 11g Production Servers
· Managing Database Performance & Tuning Best Practices
· Excellent skill in SQL, PL/SQL, Packages, Functions, Jobs & Schedule Jobs Best Practices
· Excellent knowledge of Database Architecture & Resource Management, DG, RAC, ASM.
· Excellent knowledge of Initialization, Parameters, File Location & Server Configuration
· Involved in Data Migration from Legacy to Automation using CSV, SQLldr, Data Pump
Data warehousing and BI Specialist
Worked as BI Specialist in following domains as under:-
· Design data warehouse for PMS and Defence Club Billing
· Import Data from SQL Server to Oracle using 11g Design Center
· Developed Fact Tables and Dimension using Star Schema Pattern.
· Developed BI Reports using BI Publisher and Discoverer Tools
Data Migration Specialist:-
Prepared and implemented of data migration plan based on complex SQL Queries for:-
· Custom ERP Finance System to Oracle EBS R12 (GL, AR, AP)
· Custom ERP PMS to Oracle Custom ERP PMS (SQL Server to Oracle 11g)
· Custom ERP HRMS to EBS R12 (Core HR Module) (SQL Server to EBS HR)
· Custom ERP Water Billing Module to Oracle Custom ERP (SQL Server to Oracle 11g)
· Custom ERP Purchase Management System to Oracle EBS R12 (Supply Chain) under process
· Data Integration expertise:-
Integration of following Custom ERP Modules:-
· Custom ERP Transport to Oracle EBS R12 (AR Module)
· Custom ERP Underground Electricity Charges Billing Module to Oracle EBS R12 (AR Module)
· Custom ERP Payroll System to Oracle EBS R12 (AR Module)
Database: Oracle 11g, EBS R12 (Db Node) SQL Server, MS Excel
OS: Win Xp, RHE-Linux, Win Server 2003/2008
Tools: Toad for SQL Server/Oracle/MySQL, SQLldr, Data pump, Excel, CSV, SQL Queries
Analyzed, designed, developed & implemented following modules:-
Land Information System
Features:
· Based on Land/Allotment/Members/Transfer Entry Forms with Pictures
· File Movement Record keeping
· Building control Record Keeping
· Possession, Site Plan, House completion Entry
· History of Splitting, Amalgamation, Caution, Mortgage, Cancellation & Deletions
· General/Tfr Query Search form for NAB inquiries
· Detail/ Summary Reports
Financial Accounting System (running live from last 9 years)
Features:
· Based on Five levels of COA for AP, GL, CM, FA
· Invoices modules and Integration with Customized applications
· Sub Head Accounting with parties Ledgers
· Journal Vouchers, Bank Payment Vouchers, Integrated BRVs from custom Modules
· Petty Cash Vouchers
· Cheque Book entry and Automated entry of Cheque No in BPV Vouchers
· Specially designed Reports for cheque Printing
· Integrated with all Custom Modules (LIS, Water Billing, Transport)
· Trial Balance, Income Statement, Profit and Loss A/c, Balance Sheet Report
· Special reports for Bank Deposits, Tax Payments and Sub head Suppliers
Human Resource Management System
Features:
· Employees bio-data, Work History with payroll integration
· Award/warnings, trainings, job descriptions, languages features
· Insurance, Documents, contact information, leaves record history
Payroll System
Features:
· Main and sub Dept wise EMP/OFFR complete bio-data
· Salary record based on Government BPS Scales & Stages
· Also includes annual increments/bonus posting for Permanent/ contract scales
· Inter branch Transfer facility
· Employee welfare loan history
· Bank intimation, Salary reports
· DHA Entertainment allowances
· Integrated with Financial Accounting Module in JV and BPV posting
Legal Court Management System
Features:
· Based on advocates and case history wise records and reports
Purchase Management System
Features:
· Based on DHA Purchase Branch business working process
· Case initiation by Min Sheets
· Suppliers, Quotations and Vehicles Data
· Comparison sheets Single and Multiple Supplier Selection option
· Purchase Orders generation
· Bank payment vouchers generation
DHA Water Billing System
Features:
· Phase Sector wise Houses Entry
· Automated entry for Houses from LIS
· Head wise water Billing Codes
· Custom Billing for Transfer of Properties
· Quaterly Billing for All Houses
· Installment Facility
· Surcharge Calculation facility for late payments
· Advanced Search Form
· Detail / Summary Reporting Facility
· Integrated with Financial Accounting System.
Military Transport System
Features:
· All Vehicles entry with Pictures
· Running State of Vehicles
· Repair and maintenance of Vehicles
· Insurance Record of Vehicles
· Advanced Search Forms
· Detail Summary Reports
Ballot Intimation Letter Programs
· Intimation Letters Printing facility for All Ballots
· Mail Merge Facility
· Integrated with LIS for showing remaining installments
SQL Server DBA
· Team lead for SQL Server Database Administration & support
· Designed Schedules for Database Backups, Optimization, Replication and Recovery issues.
· Designed Disaster recovery plan for SQL Server Databases
· Team lead for User Management of all Custom modules
· Designed databases for Custom Land Management, Financial, HRMS, Payroll, Procurement Systems
· Designed integration procedures and sub-routines for Custom ERP systems with Custom Financial System
· Designed and Developed Custom Reporting for Auditors and Higher Management.
· Involved in Data Migration and Data Cleansing process and prepared data formats for DHA Automation System
Tools Database: SQL Server 2000, 2005, 2008
OS: Win Server 2003, Win Xp for Clients
Tools: Visual Studio, Crystal Reports, Active reports/bar, Toad, Excel, VsFlex/Truedb Grid
Senior Support engineer for three systems in vb6 and SQL Server 2000 with Crystal report as under:-
· Finance System
· Payroll System
· Carpet Inventory System (Integrated with Finance System)
Clients: Almalik Carpets Davis Road, Shahid Oriental Carpets Dharampura Lahore
Man of the Month for Jan 2001 as Hardworking and Bonus awarded.
Developed Payroll Management System for Combined Fabrics.
Developed Sale System for IMTEX Germany and Bonus awarded.
Developer & Team Member in Carpet Inventory System for Al Malik Carpets Davis Road Lahore.
Developed a Converter for txt Files from Library of Congress Site to Database Format for Library Management System.
Provide comprehensive support to the Team Developing Financial Management System.
Tools
Vb6, SQL Server 2000, Ms Access 2000, Crystal report 7.0, Internal Data Report
Started my Professional Career as Software Engineer.
· Experienced with competent team and learn how to develop Dynamic Front end Forms & Reports on customer
based requirements.
· Worked as a Team Member in Pharmacy System for Fazal Cardinal Liberty Lahore.
Worked as a Team Member in Inventory System for Model Steel Mills Lahore
OCP Training Complete Technical DBA Training RAC Training Data Guard Workshop Attended Buisiness intelligence Workshop Attended Symentic Net Backup 7.1 Client / Server complete training
Certification Oracle Certified Associate Oracle Id: OC0968371 Skills Oracle Apps Dba 11g, R12 Installation, Red Hat Linux 5, 6
My gross GPA is 3.04 and My major subjects are Software engineering and database administration
I have completed my bachelor of commerce from University of the Punjab Lahore and this higher diploma encouraged me and provided me strong base in Computer science in developing Financial Modules with complete integration with sub modules (including Plot Management , Inventory , Procurement and Billing Systems)
