Supply Chain System Analyst

Tamer Guler, ******.*****@*****.***

+1-407-***-**** (whatsApp)

+1-786-***-**** mobile phone

Education

Diploma in Sc ience, The Marmara College of Istanbul, Turkey (9/1981)

Business Administration in Finance, York University (USA) (6/2017)

Technical Experience

System / Platform : IBM-iSeries-AS400

Qualifications : iSeries programming. RPG (II / III / ILE / 400 / FREE), CL, CLP, CLLE, RPG/SQL, DB2, DDM, Journaling, QRY400, SEU, SDA, RLU, DFU, DBU, PFE, S/FTP, IFS, XML Tag, DEBUG metod Batch/Interactive, Job Scheduler (WRKJOBSCDE), GoAnyWhere, Barcode400, Turnover-Hawkeye .

Microsoft ( Word, Excel, MS Projects )

Methodologies

SDLC : Software Development Life Cycle

ITIL Management : Strategy-Design-Transition-Operation-Continual Service -Improvement

SIX SIGMA : DMAIC ( For improving existing business processes )

Design-Measure-Analyze-Improve-Control

DMADV ( To create new processes and new products or services )

Design-Measure-Analyze-Design-Verify

My Experiences :

SCM (Supply Chain Management), /

ERP (Enterprise resource planning ),

SOP (Sales Order Processing),

BPCS (Business Planning and Control System),

WM (Warehouse Management),

BRMS (Backup Recovery Management),

CRM (Customer Relation Management),

SRM (Supplier relationship management)

MRP-MAPICS (Material Planing)

Other SKILLS :

Test code and fixes to ensure quality

Develope conversion and system implementation plans

Develope programming code for existing software enhancements

Troubleshoot and debug existing code

Implement newly created code and fixes into existing software

Keep internal users informed of all enhancements, troubleshooting and fixes

Professional Experience

One-Bilisim AS400-Consulting (Istanbul- Turkey) Client - (Remote-Onsite)

( Anatolian/Middle-East insurance Company) Aug.2021 – Present

Developing by RPG programming relevant insurance subjects. Development / Applications for Database security Control. On-call support for production live errors. Developing Process control mappoing for performance and secure. creation of Applications processing time control reports for developers.

Existing Program Maintenance / Program Modifications / New Designing programs for performance / Custom Design Programming for specific insurance firm. MIS (Management Info.System for Accounting / Finance.

By the way I am leading for offshore team during the projects. For QA team custom design Process control tools

Platform:

IBM iSeries/AS400: RPG III, RPG IV, RPGILE, RPG FREE, CLLE, SQL, DB2, QRY400, RLU, DFU, DBU

TCS_TATA Consulting (New Jersey-USA) Client (Western Union) Mar.2018 – Aug.2021

AS400 Applications Developer / Settlement Production support / System Analyst

Application Developer / Program Maintenance / Program Modifications / New Design of programs. - Accounting, Money Transfer Custom Design of Western Union, GDPR program Developing

Platform:

IBM iSeries/AS400: RPG III, RPG IV, RPGILE, RPG FREE, CLLE, SQL, DB2, QRY400, RLU, DFU, DBU

Gencallar Textile, Turkey (Remote and Onsite) Oct.2017 – Feb.2018

AS400 Applications Developer / Project Manager

Application Developing / Maintenance / Modification / Design of programs iseries.

I was giving night time support since Oct.2012 till to Feb.2018

1.ERP, Retail Management,

2.E_books and Data migration, Application Developer, maintenance of programs related to the Textile Industry

3.Financial and Manufacturing applications for: Product Costing, Accounts Payable, Accounts Receivable, Billing, General Ledger, Cash Management, Fixed Assets, Payroll, Business Modeling, Data Mining, Distribution, Manufacturing, Forecasting, Master Scheduling, Material Requirements, Planning, Capacity Planning, Distribution Resource Planning and Time Management, Supply Chain Management.

4.Perform custom database design for order automation procedures in order to streamline vendor’s supply schedules and sales order distribution.

5.E-mail notification programming, trigger programs, sub-files, designed physical, logical, join, display files.

Platform:

IBM iSeries/AS400: RPG III, RPG IV, RPGILE, RPG FREE, CLLE, SQL, DB2, QRY400, RLU, DFU, DBU

NBC Universal, Orlando, FL-USA Jun.2016 – Nov.2017

AS400 Developer / Application System Analyst (Consultant)

Project Details : Retail Supply Chain Support,

Application Developer, Maintenance/Modification/Design of programs regarding Retail Supply Chain.

Iseries Test Environment

Platform:

IBM iSeries : RPG III, RPG IV, RPGILE, RPG FREE, CLLE, SQL, DB2, QRY400, SDA, RLU, DFU, Turnover – Hawkeye, GoAnyWhere, Barcode400

Bank of America, Dallas, TX -USA Dec.2015 – May.2016

AS400 / ISeries Developer (Consultant)

Insurance Application, Mortgage and Finance

Project Details : Security Monitoring & Logging System

Application Developer, maintenance/modification/Design of programs regarding Bank Applications. Utilized SDLC, Agile, Turnover, Hawkeye,

Successfully Completed as Below

BOFA_BAC (Bank of America Corp.) Experience

Insurance and Mortgage, HELOC operation

Iseries Test Environment Q/A

Service Member Civil Relief Act. (SCRA). Enterprise Awareness Training

Information Protection

Financial Crimes and Compliance Training

Enterprise Privacy and CBDM- Global Technology and Operation

Platform:

IBM iSeries : RPG III, RPG IV, RPGILE, RPG FREE, CLLE, SQL, DB2, QRY400, SDA, RLU, DFU, Turnover –

Hawkeye

W IPRO Tech.Service Client (HEWLETT-PACKARD, Houston, TX-USA ) Jun.2013 – Nov.2015

AS400 / ISeries Developer (Consultant)

Supply Chain Management, Order Entry System, VISTA application programs ERROR handling, correction (A set of RPG programs)

Number of unique errors found in programs: 100: analyzed 47 programs, completed code change and program testing.

Platform:

IBM iSeries: RPGIV, RPGILE, RPG FREE, CLLE, SQL, QRY400, RLU, PFE, Turnover.

Gencaller Textile(Cloting Company-Department Store, Turkey (Onsite) Apr.2007 – May.2013

AS400 Applications Developer / Project Manager

Application Developing / Maintenance / Modification / Design of programs iseries.

1.ERP, Retail Management,

2.E_books and Data migration, Application Developer, maintenance of programs related to the Textile Industry

Financial and Manufacturing applications for:

Product Costing, Accounts Payable, Accounts Receivable, Billing, General Ledger, Cash Management,FixedAssets, Payroll, Business Modeling, Data Mining, Distribution, Manufacturing, Forecasting, Master Scheduling, Material Requirements, Planning, Capacity Planning, Distribution Resource Planning and Time Management, Supply Chain Management, Perform Custom database design for order automation procedures in order to streamline vendor’s supply schedules and sales order distribution. E-mail notification programming, Trigger programs, Sub-Files, Designed Physical, Logical, Join, Display Files.

Platform:

IBM iSeries/AS400: RPG III, RPG IV, RPGILE, RPG FREE, CLLE, SQL, DB2, QRY400, RLU, DFU, DBU

Yon Software Service, Istanbul, Turkey Jun.2005 – Mar.2007

AS400 Applications Developer / Programmer

Project Manager and developer, maintenance of programs for Financial and Manufacturing applications as required by the Software Service Company. Utilized SDLC, ITIL Management, Six Sigma.

Platform:

IBM iSeries : RPGII, RPGIII, RPGILE, RPG FREE, CLLE, SQL, DB2, QRY400, RLU, DFU, DBU

CAGBIL SOFTWARE SERVICE, Istanbul, Turkey Jan.2004 – May.2005

AS400 Applications Developer, Programmer

Project Manager and developer, maintenance of programs for Financial and Manufacturing applications as required by the Software Service Company.

Platform:

IBM iSeries: RPGII, RPGIII, RPGILE, RPG FREE, CLLE, SQL, DB2, QRY400, RLU, DFU.

SETA MUSIC MEDIA LTD., Istanbul, Turkey Jun.1996 – Dec 2003

Applications Developer, Project Management and program development, maintenance of programs for

Financial and Manufacturing applications:

Retail Management :

1.Sales order departmental integration,

2.Sales Forecasting, Warehouse Management Applications,

3.Production, Process Control,

4.Waste Reduction, Accounting, Cash Management,

5.Customer Relations Management,

6.Supplier Relations Management.

7.Financial Reports

Platform:

IBM iSeries : Migrated application programs and data from Systems 34 to S/36, later on to S/38, AS/400,

IBM iSeries RPGII, RPGIII, RPGILE, RPG FREE, CL, CLLE, SQL, DB2, QRY400, RLU, DFU, DBU

GOODYEAR TIRE AND RUBBER COMP., Turkey & USA Feb.1988 – May.1996

AS400 - Operation Manager /Program Developer / Analyst

Project Management and program development of interactive and batch programs, maintenance of programs fo

- Financial and Manufacturing applications (MAPICS / ERP / MRP)

- Warehouse Management Systems (WMS)

- Sales order processing system, production control, process control, sales forecasting, sales analysis,

promotion distributor’s deals,

- Payroll,

- Accounting System

- integration of Goodyear’s global accounting systems for Foreign Country books.

- Distribution Control Management (DCM)

- Adjustment system

- Financial Report

- Management Information Sysyem (MIS)

Platform:

IBM iSeries : Migrated application programs and data from Systems 34 to S/36, later on to S/38, AS/400,

RPG II, RPGIII, RPGILE, RPG FREE, CL, CLLE, SQL, DB2, QRY400, RLU, DFU

Contact this candidate