Docstoc

IT EXPERIENCE

Document Sample
IT EXPERIENCE Powered By Docstoc
					Muhammad Yasin
        Seeking an assignment for the position in ERP Applications, where I can provide value addition, utilizing
        my expertise and problem solving & analytical skills
EDUCATION
    a. Matriculation.
    b. Intermediate.
    c. Graduation . Computer Sciences
    d. Post Graduation Computer Sciences
COMPUTER EDUCATION:
O.C.P(Oracle certified professional(Course) developer track / DBA Track).
An institute affiliated with B.Z University Multan and ALCOS(Action Learning Center of Software).
Summary:
       Over Nine years of experience as a Analyst , Software Developer , DBA , ERP Administration in Oracle
Design and development of applications.
IT EXPERIENCE:
        a.    Oracle ERP Implementation ,Training and Administration
        b.    Orion ERP Implementation ,Training and Administration
        c.    Route Pro For Sales and Automation(RP 32)
        d.    Oracle7/8/9i Database, Developer 2000/6i
        e.    Oracle DBA
        f.    Visual BASIC 6
        g.    Citrix Administration
        h.    System and Network Administration
        i.    LAN / WAN
        j.    SUN Solaris
        k.    Windows 2000/2003
Work Experience:
(1)     Period. July 2001 to Upto Now
        Organization:
        Al-Qahtani Group of Companies(PEPSI COLA) Saudia Arabia
        Designation/Position:         Senior ERP Administrator.

        Responsibilities:
1)      Oracle ERP( Implementation , Trainings and Administration ) :
             Oracle Applications Technical Administration, Maintaining database 9i and designing, Applying
             Patches on SUN Solaris.
             Application Administration
             Business study , Administration of Oracle Application and Implementation , Users and Screen access
             and segregation of responsibilities , Troubleshooting Process problems.
             General Ledger: User training, Administration of module, set of Book, Flexi fields and Module
             Administration
             Account Receivables: User training, Administration of module, Transfer to GL , Integration with order
             management setting up Flexi fields , Setup and Module Administration.
             Account Payables: User training, Administration of module, Transfer to GL , Supplier Setup,
             Matching ,setup of Flexi fields and Module Administration.
             Inventory : User training , Administration of module ,Opening and closing the periods ,Transfer to GL
             , Integration with order management/Purchasing , setup of Flexi fields and Module Administration.
             Manufacturing : User training , Administration of module ,BOM , Capacity Planner , Material
             Planner , Quality ,Work in Progress ,Integration with Inventory/order management/GL. All setups ,
             Module Administration.
          Purchasing : User training , Administration of module ,Open / Close Periods , Integration with
          Inventory /order management / GL , Position Hierarchy on all transaction types. All setups and Flexi
          fields along with data collection sheets.
          Cash Management: User training, Administration of module ,Transfer to GL , Cash Clearing and
          Module Administration.
          Order Management : User training , Administration of module ,Customer creation , Transaction
          Creation, Attaching Transaction to customer and Integration with AR Module ,Transfer to GL ,
          Integration with Inventory , Account Receivables , All setups and Flexi fields and Module
          Administration.
          HRMS and Payroll : User training , Administration of module ,Payroll Process definition, HRMS,
          Integration with General Ledger and Transfer to GL.
(2)   Orion ERP (Oralce 8 NT / 9i)
         Developing and updating reports and forms using Developer 4.5/5.0 and Developer 6.0
         Confirmation and generating financial entries for Operation Data.
         Downloading and Uploading branches data.
         Installation, Training and Implementation of Orion software in head office and in branches.
         Generating financial and stock reports for the department’s heads and end users.
         Performing the duties of Data Base Administrator.
         Assisting end users to resolve their queries.
         Developing new forms and updating existing forms according to management requirements
          and facilitating the users.
         Development of various reports from Orion data for management and users.
         As Data Base Administrator, handling and managing Oracle server.
         Maintenance and updating of Inventory, Receivable and Payroll system troubleshooting of
          existing software. Installation and configuration of new hardware.
         Export and backup procedures
         Bringing All the Branches Online using the Satellite, RAS and DSL Connectivity Using
          Citrix Software.
         Administration Of Citrix Server .
         Training all Employees in Branches how to use the online System Using Citrix.
         Migration Of Database from Clipper To Oracle and many other databases to Oracle.
         Managing the Tables for the migration from Other database to Oracle.
         Evaluated Backup & Recovery needs and strategies.
         Database Planning and Designing.
         Implemented many Database projects with great detail, on time and under budget.
         Work closely with the Data Architects to Implement the Database Design, Creating and Configuring
          Database by setting appropriate parameters in init.ora, this Involves decision in logical storage
          structure and forecast of future expansion.
         Installing and upgrading the Oracle server and Application tools.
         Work closely with the Technical team to ensure the adhere to co-operate policies and procedures
          pertaining to the Database.
         Managing physical& logical structures of Database: Creating, Adding, Altering, Dropping,
          Renaming and Relocating of Control files, Data files, Redo log files, Table spaces, Rollback Segments
          and Temporary Segments.
         Space Administration: Performed Capacity Planning Space/Growth Management and Forecasting to
          smooth Operations, Allocate appropriate memory resources to Oracle memory structures (SGA &
          PGA), Monitor the growth of Database to ensure the smooth running of daily activities, and Allocation
          of quotas on table spaces to different users.
          Managing Schema objects: Create, Alter, Dropping Schema Objects such as Tables, Indexes, Views,
           Sequences, Synonyms. Managing Materialized Views and DB links.
          Backup& Recovery: High Availability & Disaster Recovery Provided true 24 x 7 Operational Support
           for Oracle instances these were true mission Critical Databases, Perform LOGICAL and PHYSICAL
           backups, Performed online as well as offline backups, Used utilities such as Export, Import, Recovery
           Manager and Sqlldr.
(3)      Rute PRO (Sales Automation System)

         Implementation: Involve in Overall implementation of SAS integrate all the process
         according to company’s business. User’s training and monitoring application of all
         scenarios as per our requirement.
         Database : Used Oracle 9i Database and integrate it with Oracle ERP

         Networking Experience:
       Setting up networks using Domain and Workgroup. And Monitoring and troubleshooting Server &
        Client environment
       Data communication between branches using Citrix MetaFrame XP
       Configuration of MS 2003 server
       Configuration of MS Exchange 2003
       Administration of Citrix Metaframe Server environment
       Remote monitoring and administration of systems and user queries, trouble-shooting and tutoring remote
        users on system usage.
       Information System security primarily using Antivirus Server.
       Complete Installation of All Windows, software and assembling troubleshooting of Hardware.


      (2) Period. Dec 1998 – To May 2001
          Company/Organization: Al-Barkat     Software Development Center and College of computer
         sciences
         Rahim Yar Khan District (Pakistan).
         Designation/position: Oracle Developer / DBA.
         Job Description.

          Course coordinator of O.C.P(Oracle Certified Professional DBA/Developer Track)
          Coaching Bachelor classes and Intermediate Classes
          Course coordinator of Visual basic6.0
          Programming in Oracle PL ,Forms , Reports Designer.
          Programming in Visual Basic 6.0.
          Software Installation.
          Software Development
          Develop Reports
          Installing and upgrading the Oracle server and Application tools.
          Work closely with the Technical team to ensure the adhere to co-operate policies and procedures
            pertaining to the Database.
          Space Administration: Performed Capacity Planning Space/Growth Management and Forecasting to
            smooth Operations, Allocate appropriate memory resources to Oracle memory structures (SGA &
            PGA), Monitor the growth of Database to ensure the smooth running of daily activities, and Allocation
            of quotas on table spaces to different users.
          Managing Schema objects: Create, Alter, Dropping Schema Objects such as Tables, Indexes, Views,
            Sequences, Synonyms. Managing Materialized Views and DB links. Keep total control over
            PCTFREE and PCTUSED parameter. Keep track of Transaction entry INITRANS and MAXTRANS.
          Backup: Perform PHYSICAL backups, Performed online as well as offline backups, Used utilities
            such as Export, Import, Recovery Manager and Sqlldr, Performed Complete Recovery of Production
           Databases in several scenarios using various techniques including latest flash-back query Performed
           Complete and Incomplete Recovery of Production Databases, Enterprise backup solutions utilizing
           Oracle Recovery Manager (RMAN) in conjunction with Legato Networked.
          Programming in Developer 6.0
          Programming in Visual Basic using SQL server
          Provide the Training of Oracle Development to All technical Staff.
          Software Installation.
               Software Development:-
                      Sales and purchase system of a national company.
                      Material Control System Using Visual Basic and Oracle
                 Environment: Oracle8i Developer 6.0, Windows2000/NT, Visual BASIC, Access, Pentium

   Software Tools:

                      Developer 2000 / Developer 6i                MS Access
                      ORACLE 9i                                    Visual Basic 6.0
                      JAVA/JDeveloper                              Pascal
                      Visual Fox Pro                               Cobol
                      HTML                                         FOX PRO
Specialist in Oracle:
Developer/2000 2.1 (Forms 4.5/5.0/6.0, Reports 2.5/3.0), Developer2000(Sql & Pl/sql ,Program unit , Form I,Form
II ,Reports , Graphics builder). SQL *PLUS, SQL Loader, Server Manager, Enterprise Backup Utility,
Recovery Manager (RMAN), Oracle Enterprise Manager (OEM)


   Personal Information
                 Father’s Name           :              Malik Allah Ditta
                 Date of Birth           :              01/02/1970
                 Martial Status          :              Married
                 Nationality             :              Pakistani

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:14
posted:10/4/2012
language:English
pages:4