Manager System

Mark Guirguis Farag Elkomos

*th Square **** – Sheraton Héliopolis

Mobile: 002***-*******

E-mail: mark .*******@*****.***

About Me:

A Senior Software Engineer/Team Leader with a proven track record of over 9 years of progressive

experience within the information technology/Retail& supply chain Industry, with specific expertise in IT

Support, Software Development, ERP implementation, Business Process Re-engineering, IT Project

Management, and Professional Services. Result oriented and business driven maximizing profitability by

delivering exceptional product quality and service, prudent in people management, technology and processes.

Outstanding ability to Manage Software Systems aligned with business goals and technology strategies, leading

technical team to achieve projects goals and exceed customer expectations.

Experience:

Dec 2009 until Present Applications Manager (Outsourced to GlaxoSmithKline)

Responsibilities:

Jupiter 2000

Managing and Supporting daily business activities of different Computer

Systems among them:

1. Payroll

2. Time & Attendance

3. Sales Analysis

4. Forecasting Application

5. Engineering Application

Vendor lead and back filling the IT manager.

Projects:

Analysis, Design, and Implementing an Electronic Pay Slip

Implementing a New Access Control System

Implementing a new Sales Analysis Module

Technologies & Tools Used:

IBM AS/400, DB2, SQL Server, Oracle DB, SSIS, C#

Associate Consultant

Jul-2008 till Nov 2009

Projects:

ITWorx

Extending Database fields and customized all displays, reports, and programs to

use the new sizes.

Review and fix all problems resulting from unneeded lock state of the different

DB files.

Technologies & Tools Used:

Microsoft Visual Studio 2005,IBM AS/400, VB.Net,ASP.Net, HTML, SQL Server

2005

Responsibilities:

Modification and support for Standish Mellon Application (Asset Management

Application).

Full system maintenance: study and investigate bugs and problems

Coding, Design, and Implementation of the new requirements

Testing all new modifications done by the other team members

Dec-2007 till May-2008 Development Team Leader

Projects:

Al Sadhan Trading Co.

Analysis, Design and Implementation of a hot Interface between JDA MMS

(KSA)

system and an in-house Financial Application. Creating the GL voucher

automatically as result of any warehouse or sales transactions and post them to

the financial application.

Migration of the JDA MMS application from old to new server

Documentation of the Different business processes of the JDA MMS system.

Training the key users on the different JDA MMS functions.

Technologies & Tools Used :

Oracle 9i, Toad, Microsoft Access 2003, Oracle Connection Manager, MS Project,

SQL, IBM AS/400

Responsibilities:

Understanding the business drivers behind Al Sadhan mission and leading a team

of Developers to realize these drivers in working software .

JDA System Management

AS/400 System Administration/ Operation

Senior Application Developer

Nov 2005 till Dec 2007

Projects:

Al Sadhan Trading Co.

Design, Developing, and implementation of an automatic store order systems.

(KSA)

Collecting the orders through PDT/PDA machines and use the collected data to

generate auto transfers between the warehouse and the different stores.

Contributing in the Upgrade of the JDA system from version 2003.7.1 to version

2005.1.0 (all in home modifications, and full system QA)

Implementation and testing of the Expiry Date Control System

Remodeling of the automatic stock take process through the PDA/PDT machines

to send updated items list and use the appropriate cost while uploading

Technologies & Tools Used:

IBM AS/400, FTP, PDA’s client access, DB2/400, SQL

Responsibilities:

Modification and reporting on the JDA MMS system

JDA System Management

AS/400 System Administration/ Operation

Jan 2004 till Nov 2005 Application Developer/ AS400 Trainer

Projects:

Jupiter2000 (IBM Partner)

Generating a report framework on the JDA system ( Merchandising System. at

Al-Sadhan Trading Co. KSA) as an outsource consultant.

Developing an interface between IBM Payroll System and PeopleSoft HRMS.

(Glaxo Smith Kline)

System Migration from AS400 system Version 2 Release 3 to system Version 5

Release 3 and configuring the new system (Chloride Co.)

Managing and reporting on Chloride application (in house application developed

by Jupiter 2000).

System Migration from AS400 system Version 2 Release 3 to system Version 5

Release 3 and configuring the new system (Chloride Co.)

Managing and reporting on Chloride application (in house application developed

by Jupiter 2000). [supporting around 30 users]

Technologies & Tools Used:

IBM AS/400, Java, JSP, HTML, IBM Websphere, JRUN, DB2, SQL

Responsibilities:

Supporting Chloride application

Teaching AS400 courses (in Egypt, Jordan, and KSA)

Jun-2003 till Dec-2003 Trainee

Training in the Egyptian Graduates Project (EGP) to be AS/400 Applicati on Developer

Jupiter2000

track

(IBM Authorized Education

Center)

Mar-2002 till Feb-2003 Technical Support

Responsibilities:

Psychological Affair Center

PC Desktop support.

(Armed Forced)

Automation of Psychological tests

Aug-2001 till Nov-2001 Trainee Developer

Project:

Chemical Industries

Automation of the warehouse system. (Using Visual C++ and Access database)

Development

(CID)

Education & Qualification:

B.Sc. of Engineering

University Degree

Ain Shams University

University

Electrical Engineering. Computers & Systems Department (Computer)

Major

June 2001

Graduation Year

Good

Graduation Grade

Design data Encryption Processor.

Graduation Project Aim

Using FPGA technology and VHDL language

Excellent

Graduation Project Grade

Training & Certifications:

1. Attending JDA Developing course at JDA offices in London, UK

2. IBM Certified Specialist – AS/400 RPG IV Programmer on 25/1/2004.

3. CIW Internet Skills Certification on 29/1/2004.

4. IBM Certified Specialist – DB2 UDB V6/V7 Fundamentals on 10/3/2004.

5. IBM Certified Trainee.

6. Alliance Française (French certificate)

Skills:

Business Core:

Inventory

Retail

Supply Chain

Software Core:

Java Programming Fundamentals

OO Analysis and Design using C++ and Visual C++

JSP and Java Script.

IBM Websphere Fundamental

VB.Net and C#

HTML & ASP.Net

AS400 Core:

AS/400 System Operation/Administration.

AS/400 Control Language Programming.

DB2/400 Coding & Implementation.

Accessing the AS/400 Application Using SQL.

RPG IV Programming.

AS/400 System Operation/Administration.

Database Core:

Microsoft Access.

Microsoft SQL Server

Database Design and Implementation using IBM DB2 UDB.

Oracle DB.

Other Cores:

Very Good Knowledge of PC Operating System (Microsoft DOS, Microsoft Wind ows 98 / Millennium / 2000 Family

/ XP Professional).

Using Microsoft Office applications (Word, Excel, and Power Point) .

Networking

Language Skills:

Arabic: Native Language

English: Very Good

French: Very Good

Personal Attributes:

Hard worker

Self-motivated

Self-confident

Quick learner

Good Training capabilities

Team Leading

Deep Analytical skills

Work under pressure

Able to work individually or as part of a team

Personal Data:

1/7/1979

Date of Birth

Egyptian

Nationality

Male

Gender

Married

Marital Status

Completed

Military Status

Hold a driving license

References available upon request

Contact this candidate