MUHAMMAD WASEEM HAROON Flat No. 102, Al-Zaroni Building, Naif Road, Deira, Dubai, P.O Box 119971, U.A.E. Email : [email protected], [email protected], [email protected] Tel No.: +971-4-2724891, Mobile No.: +971-50-1613646

SUMMARY Oracle Certified Professional with over six years of professional experience in Database Administration, System / Business Analysis, Database Designing, Data Modeling & Software Development. Development of systems for problems and opportunities. Defining requirements for improving and replacing systems. Evaluating alternative solutions for feasibility. Selecting hardware and software products. Designing system interface, flow and procedures. Performing interviews and other data gathering. Documenting and analyzing current system operations. Educating end users on new system. Designing and testing system prototype. Designing Relational database structures and Client Server Applications. Designing user interfaces (input, outputs and dialogues) to computer system. Designing system security and control. Writing, Testing and integrating modules. Developing and Customization of Software using RDBMS and 4GL's Tools.  CAREER OBJECTIVE Computer Science is ever changing field that required adequate knowledge and dedication. I intend to further explore the new horizons of information technology and develop my skills in the field of computer sciences. To be a most valuable System Analyst / Senior Application Developer / Database Administrator for a progressive organization, therefore I can prove my worth through smart works, in order to accomplish company’s business objectives.  PROFESSIONAL SKILLS •   SQL, PL/SQL, Oracle Developer 2000 6i, Java, Oracle Discoverer, FoxPro. •   Oracle 8/8i/9i/10g Database Administration, Performance Tuning, Backup Recovery & Network Administration under Linux/Windows Environment. •   System / Business Analysis, Database Designing, Application Development. •   Microsoft Windows Server Administration. •   Microsoft ISA Server Administration. •   Microsoft Active Directory Administration. •   MDaemon Email Server Administration.  EXPERIENCE  ORGANIZATION  DESIGNATION  FROM  TO  Emirates Airline [Dubai,U.A.E]  Oracle Consultant (Sr.Developer/DBA)  Apr - 2007  Present  Lucky Tex [Karachi, Pakistan]  Senior Developer / DBA (Team Leader / ERP Team Member)  Sep - 2003  Apr - 2007  The Halari Memon General Jamat [Karachi, Pakistan]  Oracle Programmer / DBA  Mar - 2003  Aug - 2003  Toyobo Garments Industries [Karachi, Pakistan]  Junior Programmer  Oct  - 2002  Feb - 2003  Strong Base Computer Institute [Karachi, Pakistan]  Teacher / Lecturer [Oracle Developer / Database Administration]  Jan  - 2002  Sep - 2002  EDUCATION FROM TO  DEGREE / CERTIFICATE  EXAM CONDUCTED BY DIVISION 1999 2001  Bachelor of Computer Science – BCS  Petroman Training Institute, Karachi. 1st 1996 1998  Higher Secondary Certificate Examination  Board of Intermediate Education, Karachi. 2nd 1994 1996  Secondary School Certificate Examination  Board of Secondary Education, Karachi. 1st  TECHNICAL EDUCATION Successfully Completed ORACLE® CERTIFIED PROFESSIONAL Program as an ORACLE 8i DATABASE ADMINISTRATOR, Conducted by ORACLE® CORPORATION,,. Successfully Completed One Year DIPLOMA IN ORACLE® DBA & DEVELOPER (Forms6i, Reports6i, Graphics6i) Track, Conducted by AMTEL CENTRE OF APPLIED TECHNOLOGIES in affiliated with COMiNFO VERGINIA USA.  DEVELOPED PROJECTS - HIGHLIGHTS  COMPANY NAME:   LUCKY TEX - www.luckytexonline.com  DURATION:                 September/2003 – April/2007  DESIGNATION:         Senior Developer / DBA (Team Leader & ERP Team Member)  DEPARTMENT:          Information Technology  REPORT TO:                 G.M - I.T  ENVIRONMENT:       Oracle 9i Database on Red Hat Linux AS4, Oracle Developer 2000 6i, Oracle Discoverer, FoxPro2.6. ERP/OTHER MODULES DESCRIPTION Manufacturing Module As Team Leader, Successfully Analyzed, Designed & Developed Textile Manufacturing Module. The Module is consists on Individual Sub-Modules and all the Sub-Modules are Integrated with each other.     Yarn Module Warping & Sizing Module Beam Storage Module     Sarning/Drawing-In Weaving Module Connectivity to LDS     Grey Folding Module Fabric Inspection Reports Production Planning Finance/Accounts Module As Team Leader, Successfully Analyzed, Designed, Developed & Implemented Finance/Accounts Module in targeted time. All other ERP-Modules are Integrated with this Module. The Module is Consists on 3 Sub-Modules. ACCOUNTS MAJOR FROMS MAJOR REPORTS Chart of Accounts (5 Levels) Cask & Bank In-Flow / Out-Flow Statement Cost Centers Cash Flow Statement Opening Balances General Ledger Cash & Bank Vouchers Trial Balance (Summarized & Detail) Journal Vouchers Balance Sheet / Schedule Contra Vouchers Profit & Loss Statement / Schedule Cheque Printing & Re-Printing Options   BANK STATEMENT Collected Cheques Information Bank Reconciliation Statement. Presented Cheques information   Cleared Deposits Information   Pending Receipt & Payment Advices.   FIXED ASSETS MODULE Defining Fixed Assets & their Types. Fixed Assets Ledger Report. Fixed Assets Openings. Depreciation Expenses Report. Fixed Assets Acquisitions. Depreciation Computation Statement. Fixed Assets Disposals/Deletions. Fixed Assets Schedule. Monthly Depreciation Process. Floor Activity Module Designed, Developed & Implemented FLOOR ACTIVITY MODULE, which consists on Singeing, Desizing, Bleaching, Equalizing, Ager, Calendering, Printing, Finishing & other Activities on Grey. The System is generating efficient Reports of Activities, Chemical Consumption, Production, Cost Comparison Summary/Detail, Expenses Summary and other Reports.   Local Intranet IIS (Admin Site) Developed LOCAL INTRANET (Admin Site) on Oracle, Created Stored Procedures and Functions to be called by ASP also Oversaw the web designing and development. The website consists on Management Area and Local Users Area. Management Area consists on MIS Secure Reports and Local Users Area consists on Entertainment, Birthday of Employee, Forex Rates, Karachi Stock Exchange Rates, Printing Priority List, Dyeing Priority List, Departmental Uploads, Board Members, Board Decisions, Man of the Quarter, Employees Reports Like Employees Association, Employees Job Descriptions, Employees Attendance Habits, Top 25 & Least 25 Late Comers, Leave Balances Report and other Reports.   Integration of Time Management System with Payroll/HRMS Hand Punch Attendance Machine Designed, Developed & Implemented a Bridge between TIME MANAGEMENT SYSTEM (FOXPRO) and PAYROLL/HRMS (Oracle) using Oracle Forms Built-in Packages to completely automize the Monthly Salary Process. Barcode Reader Machine – PROMAG TR515E Designed, Developed & Implemented Barcode Designing Software on Oracle Forms to Print Daily Wages Employees Identity Cards for their daily attendances. Developed & Designed Database Structure for the Direct Retrieval of Data From Machine to Oracle. From the Technology Advancements I have Connected the Barcode Machine directly with Oracle Database Server. Computer Information Module Designed, Developed Computer Information Module for Hardware Technicians. The System is Generating Reports of Computer Hardware (Detail/Summary), Computer Stickers, Service due Dates, Administrator & Local Users Password, Department & Section wise Reports, Software Installed in Computer, Switches Information, Switches Hierarchy, Folder Accessing Rights, Printer & Cartridges Information & other Reports. Inventory Management Successfully Analyzed, Designed & Developed INVENTORY MANAGEMENT Software which Consists on Sales Invoices, Purchases Memo, Value Adjustments, Value Additions/Deductions, Ledger Reports & different Inventory Stock Reports, The System is integrated with General Ledger System & Generating Efficient Reports. ISA Monitoring Software Designed, Developed & Implemented Oracle Based Microsoft ISA Server Logging Software. The purpose of this software is to generate efficient oracle based reports of internet accessing. Task Management System Using this module a manager can electronically assign tasks to his assistant & assistant can further assign it to others/sub-ordinates and can track completed, pending,& futured tasks also can generate monthly performance reports on the basis of daily data updation/feeding Online Applroval System Approvals like Leave Application, Loan Application, MIS Reports Uploading Request, Yarn Requirement, Yarn Receiving, Yarn Inspection etc. can be electronically maintained by this Application. Loom Data System (INZ Technologies) Served Implementation and post implementation technical and functional support for LDS. Trained applications users to ensure the correct and proper use of business systems. User Authentication Module Designed & Developed USER AUTHENTICATION MODULE. The purpose of this Module is to secure the Applications. This Module is completely integrated with all other Modules. Others Successfully Configured Standby Database Server / Data Guard. Successfully Implemented Security Policies on Oracle Database Server using Oracle Built-In Package UTL_FILE for the Sake of Safety.  Created Job Applications Data Bank Software for Human Resource Department. Created Administration Department Related Forms & Reports. Created MIS Secured Reporting Software for Finance & Audit Department. Created Reports for Many Modules like Export/Finish Folding, Grey Folding, Payroll/HRMS, Order Tracking, Telephone Data and others. Created Auto-Emailing (HTML+Oracle) Procedures for many Modules using Database Package. Created Database triggers in many modules for data security. Installed, Managed & Implemented Microsoft Active Directory, Microsoft ISA Server, Mdaemon Email Server and many other packages. Successfully Implemented Wireless Connectivity using Wireless Routers & LANS. Worked closely with the Database Developers to ensure adherence of the database guidelines, Standards and procedures and generated system test plans. Prepared user manuals and technical support manuals. Worked closely with the Database Administrator for proper backup and recovery plans. Optimized SQL queries for better performance.  COMPANY NAME:   THE HALARI MEMON GENERAL JAMAT  DURATION:                March/2003 – August/2003  DESIGNATION:        Oracle Programmer / DBA  REPORT TO:                Manager  ENVIRONMENT:      Oracle 8/8i Database on Windows 2000 Server, Oracle Developer 2000.   MODULES DESCRIPTION  School & College Information System To maintain a registration of students and teachers, to maintain a timetable of individual class, which teacher is responsible for which period if he/she is available or not, fee control system and many more.   Census Information System Complete census system of the Halari Memon General Jamat. This system controls the information of the registration of the new birth, death information of the person, total no. of members in one family, owner of the family, occupation of the registered members, if he/she is studying or not, own business or employee, salary package of the registered members, etc.    COMPANY NAME:   TOYOBO GARMENTS INDUSTRIES  DURATION:                October/2002 – February/2003  DESIGNATION:        Junior Programmer  REPORT TO:               Team Leader  ENVIRONMENT:     Oracle 7/8 Database on Windows 2000 Pro, Oracle Developer 2000, FoxPro2.6. MODULES DESCRIPTION  Resposibilities •   To Assist Team Leader. •   To Create Tables, Views, Cursors, Packages, Procedures, Functions & Triggers. •   To develop new Applications. •   To Modification in Existing Developed Applications. •   End Users Training Sessions. •   Client Side Support.  TEACHING   EXPEREINCE YEAR DECSRIPTION Jan/2002 - Sep/2002 ORACLE® DBA & DEVELOPER (Forms 6i, Reports 6i and Graphics 6i) in STRONG BASE COMPUTER INSTITUTE/AMTEL CENTRE OF APPLIED TECHNOLOGIES.  RESEARCH  &   DEVELOPMENT Successfully Implemented & Configured Emailing Services with attachment using Oracle9i SMTP Package also By using Microsoft Outlook Express OLE. Successfully Developed the Spell Checker in Oracle Forms using Oracle Tables, Thesaurus & Dictionaries also By using Microsoft Word 2000 OLE. Successfully Implemented Shock Wave Flash Object on Oracle Forms OCX Object. Successfully Implemented & Developed Microsoft Excel Converter (it Converts the Oracle Reports into MS EXCEL). Successfully Implemented Job Scheduling Package of Oracle 9i. Successfully Created a Procedure for Auto Mobile SMS From Oracle Database Server 9i. Successfully Created a Procedure for Auto Downloading of Web Page Source into Oracle Tables. Successfully Created a Procedure for Extracting Non-Oracle Data into Oracle Database. Successfully Implemented Urdu Language on Oracle Forms using Database 9i UNICODE. Successfully Developed the Resolution Changer on Oracle Forms. Successfully Implemented Oracle Heterogeneous Services. Successfully Developed Barcode Designer on Oracle Forms. Successfully Executed Operating System Commands/Shell Scripts From Client Using Oracle Based Java Procedures. Successfully Configured Oracle Data Guard / Standby Database Server. Successfully Configured / Implemented Gnokii on Linux Using Nokia 6030 to Send SMS From Oracle to Mobile Device. Successfully Configured Send Mail, Samba Server, NFS Server, VNC Server, Auto Schedules on Linux.  PROFESSIONAL   AFFILIATION YEAR DECSRIPTION 2002 - Till Date Member as OCP with ORACLE® APPS WORLD & ORACLE® TECHNOLOGY NETWORK. 2001 – Till Date Active member of sites like: http://forums.oracle.com ,http://asktom.oracle.com ,http://www.orafaq.com ,http://www.tek-tips.com ,http://www.erpstuff.com  EXPERIENCE   WITH   DATABASES Oracle® 7.x/8.x/8i/9i(Release 1 & 2) Oracle® 10g Microsoft® Access  EXPERIENCE  WITH   SYSTEM   SOFTWARE Microsoft® Windows NT/2000 Advance Server/XP Enterprise Linux AS4  EXPERIENCE  WITH   PROGRAMMING   TOOLS Oracle® SQL & PL/SQL Oracle® Form Builder 6i Oracle® Report Builder 6i Oracle® Graphics Builder 6i Oracle Enterprise Manager SQL Tool PL/SQL Developer ERWIN 3.x  EXPERIENCE   WITH   APPLICATION   SOFTWARE   &   PACKAGES Microsoft® ISA SERVER 2000 MDaemon Email Server Microsoft® Office 2000/XP Microsoft® Visual Source Save Microsoft® Visio ERWIN 3.x Corel Draw Adobe® Photoshop  PRESENTATIONS   TRAINING   RELATED Designed, Developed, Conducted & Organized Presentations / Trainings for LUCKY TEX on various Topics Like AUTOMIZATION OF LUCKY TEX, VIRUS CONTROLLING, VISION TO GROW etc.  PERSONAL   INFORMATION  Date of Birth  January 11th, 1981  Marital Status  Single  Domicile  Karachi (Central)  Country of Origin  Pakistan  National ID  42101-5996464-9  Passport No.  AA6854641

Muhammad Waseem Haroon, Oracle Certified Professional, Waseem Haroon, WaseemHaroon, Database Administrator, Oracle Developer, Software Developer, Software Engineer, Oracle Programmer, Oracle DBA, Oracle Application Developer, OCP, Application Engineer, System Analyst, Analyst Programmer, OCP8i, OCP-DBA(8i), OCP-8i, OCP(8i), BCS, BCS+OCP, OCP+DBA, OCP DBA BCS Pakistan, OCP DBA BCS Karachi, OCP DBA Pakistan, Oracle Developer Pakistan, Programmer Pakistan, System Analyst Pakistan, [email protected],[email protected], [email protected], Pakistan, Karachi, Lucky Tex, The Halari Memon General Jamat, Finance, Financial, Financial Module, Manufacturing, Floor Activity, Yarn Inventory Module, Weaving, Grey Folding, Developer Pakistan, Developer Karachi, Developer DBA, Pakistan DBA, Karachi DBA, OCP Karachi, OCP Pakistan, Lucky Tex Information Technology Department, Mobile SMS, Send Message From Oracle To Mobile Device, Oracle SMS, Barcode, SMS From Oracle, Oracle Linux, Oracle Database Linux, Standby Server, Linux, ISA Server Logging, Gnokii, sendsms, Gnokii sendsms, Oracle Flash, Flash on Oracle Forms, swf on Oracle Forms, Download Web page in Oracle, Excel to Oracle, Oracle Heterogeneous Services, Oracle Data Guard, Nokia 6030, Gnokii Nokia, Excel Converter, Oracle Resolution Changer, Oracle Email, Email From Oracle, Email From Oracle Forms, Database Programmer, Database Developer, DBA/Developer, DBA / Oracle Developer, Top Oracle Developer Pakistan, Top Oracle DBA Pakistan, Oracle DBA's, Pakistan's DBA, DBA's Pakistan, M.Waseem Haroon, M.WaseemHaroon, M Waseem Haroon, Ora Certified, AskTom, Oracle Technology Network, Orafaq, ERP-Stuff, ERP Stuff, Certified Oracle DBA Developer, Oracle 7, Oracle 8, Oracle 8i, Oracle 9i, Oracle 10g, Oracle Application Server, Oracle Discoverer, Oracle Forms, Oracle Reports, Oracle Graphics, Oracle Developer 2000, Oracle Developer 6i, Oracle D2K, Database Consultant, Database Consultant Pakistan, Integration of Time Management System with Payroll/HRMS, Inventory, ISA Monitoring Software, OLE.