AS400 Programmer
Resume:
ESMARK GUTIERREZ DUBLIN
Wroclaw Poland, 50-319
********@*****.***
OBJECTIVE
Secure a challenging position where I can utilize my skills in program development, analysis and project management to support in the improvement of Information Technology in your company.
SKILLS
Six Sigma - Green Belt
Project Management
RPG400 / RPG ILE / S36 / SQL
Systems Analysis and Design / Relational Analysis and Design
Knowledge in Java J2EE, Lotus Domino, Visual Basic, Web Sphere, MS Access, HTML, QLIKVIEW, xPAGES, LoutsScipt, JavaScript, COMPLEO, XML, RDi, Turnover
EMPLOYMENT HISTORY
IT Kontrakt
Gwiazdzista 66
54-314 Wroclaw, Poland
VOLVO IT
AS400 Developer/Adminstrator
September 2015 – Present
Project Team
The task involves analysis, program creation, creation of technical specifications and enhancement from the in house application GDS(Global Dealer System).
Responsibilities included:
• Responsible for creating/amending programs (Interfaces from other platform, RPGLE, CLLE, SQL, Stored Procedures, Triggers, XML and JAVA)
• Conducted unit testing.
• Provided systems analysis and design in accordance to Systems Development Life Cycle (SDLC) methodology
• Program creation and modification/enhancement based on the requirements document
• Submitted appropriate documents prior to implementation
• Handled implementation
• Provided updates on a regular basis
YKK Holding Asia Pte Ltd
#08-02/04 Gateway East
152 Beach Road,189721 Singapore
IT Support Engineer
October 2013 – August 2015
.
Production Support
The task involves analysis, program creation and enhancement on the affected systems.
.
Responsibilities included:
• Handled production issues
• Discussed issues with the IS/IT manager and users
• Performed program modification and/or enhancements
• Conducted unit/system/integration testing
• Submitted appropriate documents prior to implementation
• Handled implementation
• Compleo printing support for the production label printing
• Provided updates on a regular basis
• Written in AS400 (RPGLE/CLLE/RPGIII/SQLRPG,SQLRPGLE)
ITEM Inquiry
Created an Inquiry Program in Lotus Notes using xPages. Reused existing RPG program in AS400 to generate the output in Lotus Notes. Created lotusscript in lotus domino to call the RPG program and displayed the returned values in lotus domino.
OR Delay
It is created on a Business Intelligent tool QLIKVIEW. Reporting through all companies for the delays on the production from actual delivery to estimated delivery time.
LeadTime
This is a revision from existing report which is using an excel file in generating the reports. Created using QLIKVIEW to enhance and more robust. Data used is from AS400 DB2 data model and extracted to QLIKVIEW dashboard.
Excel File Report in RPGLE
Created excel reports using Apache POI API. I setup the java libraries in AS400 to run the java API(POI).
Incorporate on the RPGLE program to create the desired excel report. The output of the report goes to the
IFS created folder directory.
Pan Asia Pte Ltd
Shenton House #22-01,
3 Shenton Way 068805 Singapore
IT Consultant - Team Lead
Client: Michelin Asia-Pacific Pte Ltd – Projects / Production Support
May 2011 – October 2013
In-House Development
The Projects involve requirements analysis, systems analysis and design, program development, testing and implementation.
.
Responsibilities include:
• Provides systems analysis and design in accordance to Systems Development Life Cycle (SDLC)
methodology
• Discusses with the project manager proposed solutions to the findings gathered during requirements analysis
• Discuss schedules, estimate of effort and deliverables to the IS/IT manager
• Assign and monitor programming tasks of programmers.
• Organize and schedule tasks of programmers based on defined deadlines.
• Program creation and modification/enhancement based on the requirements document
• Provides test data for system testing and/or user acceptance testing.
• Performs unit/system/integration testing
• Submits system documentation prior to implementation
• Handles implementation
• Provides daily status report to the IS/IT Manager
• Written in AS400 (RPGLE/CLLE/RPGII)
Production Support
The task involves analysis, program creation and enhancement on the affected systems.
.
Responsibilities included:
• Handled production issues
• Discussed issues with the IS/IT manager and users
• Performed program modification and/or enhancements
• Conducted unit/system/integration testing
• Submitted appropriate documents prior to implementation
• Handled implementation
• Provided updates on a regular basis
• Written in AS400 (RPGLE/CLLE/RPGII/S36)
Oce Business Solutions
4/F PCCI Bldg McKinley Hill,
Fort Bonifacio Taguig Philippines
Senior Analyst/Programmer - Team Lead May 2010 – May 2011
Core Responsibilities included:
• Provided systems analysis and design in accordance to Systems Development Life Cycle (SDLC) methodology
• Discussed with the project manager proposed solutions to the findings gathered during requirements analysis
• Discussed schedules, estimate of effort and deliverables to the project manager
• Organized and scheduled tasks of programmers based on defined deadlines
• Assigned and monitored programming tasks of programmers
• Provided test data for system testing and/or user acceptance testing
• Provided daily updates on the project status
Fleet Account
The Project involves systems analysis and design, program creation, testing and implementation. The program enables the user to generate projected income and leasing expenses.
.
Responsibilities included:
• Handled program creation based on the requirements document
• Conducted unit/system testing
• Provided user support during the parallel run and user acceptance testing
• Submitted appropriate documents prior to implementation
• Provided support during system implementation
• Conducted user support
• Conducted training to users/business analysts on the system
• Written in AS400 (free format SQLRPGLE, CL, Reports are generated thru Excel)
Capital Lease
The Project involves systems analysis and design, program creation, testing and implementation. The program enables the user to monitor lease income per region per state and to provide information needed by the lease management.
.
Responsibilities included:
• Handled program creation based on the requirements document
• Conducted unit/system/integration testing
• Provided user support during the user acceptance testing
• Submitted appropriate documents prior to implementation
• Provided support during system implementation
• Provided user support
• Conducted training to users/business analysts on the system
• Written in AS400 (free format SQLRPGLE, CL, Reports are generated thru Excel)
Production Support
Responsibilities included:
• Handled production issues raised by the users and/or business analysts
• Provided support to the Infinium System
• Performed system maintenance
• Provided appropriate documents prior to implementation
• Provided support during implementation
• Ensured that the system is running accurately and efficiently
• Written in AS400(free format SQLRPGLE, CL, Reports are generated thru Excel)
Kforce Global Solutions, Inc
4/F SM Cyberone Bldg.
Sen Gil Puyat Ave., Makati City
Client: Amkor Technology Philippines Senior Analyst/Programmer
November 2007 – May 2010
SAP Project
The Project involves parallel testing from the legacy system to SAP.
Responsibilities included:
• Conducted integration testing
• Handled issues arising from the testing.
• Analyzed test cases to validate system integrity.
• Reconciled output data generated from AS400 vs CS2 (web based system).
SAP MESA Project
The Project involves data analysis, program enhancement and production support.
Responsibilities included:
• Handled production issue logs
• Conducted data analysis from SAP to CSS
• Handled program enhancement to address data integrity
• Handled program fixes based on user requests
CSS – CS2 Project
The Project involves data analysis and program enhancement.
Responsibilities included:
• Handled code translation from AS400 platform to web architecture
• Conducted migration testing and data analysis
• Handled production issues based on the customer related logs
• Handled data reconciliation from AS400 DDM files
Production Support
Responsibilities included:
• Handled production issues raised by the users and/or business analysts
• Provided appropriate documents prior to implementation
• Provided support during implementation
• Ensured that the system is running accurately and efficiently
DOLE Philippines Incorporated
Cannery Site, Polomolok, South Cotabato Team Lead - Senior Analyst/Programmer May 2004 - November 2007
Core Responsibilities included:
• Provided systems analysis and design in accordance to Systems Development Life Cycle (SDLC)
methodology
• Discussed with the IT Director proposed solutions to the findings gathered during requirements analysis
• Discussed schedules, estimate of effort and deliverables to the IT Director
• Organized and scheduled tasks of programmers based on defined deadlines
• Assigned and monitored programming tasks of programmers
• Provided test data for system testing and/or user acceptance testing
• Provided daily updates on the project status
HR/Payroll System
The Project involves systems analysis and design, program development, testing and implementation. The project helps to reduce system utilization of AS400 server.
Responsibilities included:
• Handled web based support on a day-to-day basis
• Performed program enhancement based on user requirements
• Conducted systems analysis and design
• Performed java application maintenance using eclipse tool running in tomcat server
• Handled websphere application server deployment
Lotus Domino/Lotus Notes
Responsibilities included:
• Performed a Team Lead role for the Lotus Notes application projects
• Created a link between Lotus Notes and AS400 in real time
• Enhanced the manual routing process of paper documents to Lotus Notes
DOLE Worldwide I2 Project
Responsibilities included:
• Performed debugging and testing for any data issues encountered
• Provided Demand, Factory and Supply Chain Planner mappings
• Enhanced processes of each mapping using SQL commands
Agricultural Systems
Responsibilities included:
• Performed a Team Lead role to conduct user support
• Conducted program enhancement based on user requirements
• Conducted program fixes
DOLE Philippines Incorporated
Cannery Site, Polomolok, South Cotabato
System Operator
March 2003 – May 2004
Responsibilities included:
• Provided day-to-day backup of AS400 data and PC servers
• Performed 1st level of support to troubleshoot hardware for AS400 and PC servers
• Performed 1st level of support to users
• Handled security storage of the daily backup tapes
• Handled monitoring of the AS400 and PC servers utilization
• Performed program development to enhance system monitoring
IT & CPI
Cannery Site, Polomolok, South Cotabato
System Operator
April 2002 – March 2003
IT & CPI
Cannery Site, Polomolok, South Cotabato
Junior Trainee
November 2000 – April 2002
PERSONAL PARTICULARS
Education Bachelor of Science in Computer Science
Notre Dame of Dadiangas University
March 2002
Age 34 Years
Birth Date 01 October 1981
Nationality Filipino Gender Male Marital Status Married Residence Poland
Reference Glenroy Campbell
Director, IBM I Programming & Operations
Canon Business Process Services, Inc.
+001 917-***-****
Contact this candidate