Ashar Hussain

Ashar Hussain Mob:- Sr. Oracle Technical Consultant(DBA) SUMMARY Join Sapphire in 2010 as oracle DBA .Currently on support as Oracle APPS DBA in AL-Abbas Sugar Mill Ltd for Oracle EBS Financials and Oracle HRMS and Oracle database since 2009. Implemented and supported Oracle EBS database (Financials and supply chain) in STEVTA. EXPERIENCE Sapphire Consulting Services Sr.Oracle Technical Consultant (DBA) Karachi Aug-2010 - present Installation,Administration and Maintainace of Oracle EBS applications and Databases. Built development, test and production instances of Oracle EBS and provide it to ERP team and client users. Configuring and Implementing Backup Procedures for Oracle databases (RMAN,Dataguard). Oracle EBS instances patching and cloning. Provide support to ERP team for any issues. Upgrade database from 10g to 11g. Upgrade application from 12.0.4 to 12.1.3. Installing,Administration and Maintainace of PeopleSoft Application. Build development, test and production instances of PeopleSoft . Apply Bundle patches of PeopleSoft application. Apply People tool patch in PeopleSoft. ________________________________________________________________________________________________ Li & Fung Pakistan (Pvt.) Ltd, Karachi Karachi Jan-2007 to Aug-2010 Operation Support Assistant - IT Supervise the maintenance and all operations of the server room. Monitor network, server and workstation health and utilization by identifying potential systemic and/or hardware issues and their timely rectification. Maintain a virus and infection free network using company’s Head Office recommended anti-virus, anti-SPAM and anti-spyware software. Manage all first level helpdesk software and hardware issues. Keep track of equipment warranties, timely maintenance of all hardware, software and internet based assets. PROJECTS/IMPLEMENTATION Al-Abbas Sugar Mill KARACHI Oracle APPS DBA (Oracle Financials , Supply Chain Modules) Sapphire Consulting Services (Pvt.) Ltd.  Monitor Oracle EBS database and apps activites.Applied patches(Financials and HRMS),done cloning, Taking and restoring RMAN backups, maintained Oracle dataguard.Provided Development and Test Instances.Activated Oracle HRMS module. Performance Tuning.  Registering and attaching RDF reports in Oracle EBS (Financials and HRMS).Created DB link for HR report. Enable Audit Trail in database and EBS application. Providing support to functional Consultants. _______________________________________________________________________________________ STEVTA Karachi Oracle DBA (Oracle Financials ,Supply Chain Modules and HRMS Modules)  Installation of OS,Oracle EBS on PROD,Development and Test servers.Implemented RMAN backups. Done patching and cloning. Provided support to Functional Consultants. (Also provided support to other clients ( HUMTV, Tameer Bank) IIL KARACHI Oracle APPS DBA (Oracle Financials , Supply Chain Modules)  Monitor Oracle EBS database and apps activites.Applied patches(Financials and HRMS),done cloning, Taking and restoring RMAN backups, maintained Oracle dataguard.Provided Development and Test Instances.Activated Oracle HRMS module. Performance Tuning. Registering and attaching RDF reports in Oracle EBS (Financials and HRMS).Created DB link for HR report. Enable Audit Trail in database and EBS application. Providing support to functional Consultants. Sindh Maddarsatul Islam University Karachi Oracle DBA (PeopleSoft))  Installation of database and application of Peoplesoft people tools 8.54 on demo and system servers.  Run additional datamover scripts  Configuring application server and weblogic server.  Setting Up the PeopleSoft Pure Internet.  Compile cobol on both demo and system application servers.  Handling core issue of database.  Configuring and Implementing Backup Procedures for Oracle databases (RMAN).  Supporting users to provide the need of accessing peoplesoft application.  Working on peoplesoft security administration. TECHNICAL SKILLS       Application Software: Oracle EBS Release 11i and R12. Databases: Oracle Database 9i,10g,11g and 12c. Database Software: ADI,TOAD,PL/SQL,Oracle workflow Builder, Oracle iSetup. Operating Systems: Windows Server 2003 and 2008,Red Hat Linux 4 and 5. Programming Languages: SQL Scripting languages: Linux Shell scripting. EDUCATION  BCS (Usman University) Sapphire Consulting Services (Pvt.) Ltd.