ESMARK GUTIERREZ DUBLIN
Ul. Prusa 1/14
Wroclaw Poland, 50-319
(--
A highly motivated team player with recommendable work ethics, has more than 18 years’
experience with RPG programming and whose adaptability and communication has gained him jobs
in the Philippines, Singapore and Poland.
SKILLS
Six Sigma - Green Belt
Project Management
S36 / RPG400 / RPG ILE / RPG Free format / SQL
Systems Analysis and Design / Relational Analysis and Design
Knowledge and experienced in MQ, Java J2EE, Lotus Domino, Visual Basic, Web Sphere, MS
Access, HTML, QLIKVIEW, xPAGES, LoutsScipt, JavaScript, COMPLEO, XML, RDi, Turnover, Aldon
EMPLOYMENT HISTORY
IT Kontrakt
Gwiazdzista- Wroclaw, Poland
VOLVO IT
AS400 Developer/Administrator
September 2015 – Present
Project Team
The task involves data gathering, analysis, program development, enhancement and implementation
from the in-house application GDS (Global Dealer System) running AS400 and Java.
Responsibilities included:
Program development and enhancement
(Involves RPG free-format, RPG ILE, CLLE, SQL, Stored Procedures, Triggers, XML, JAVA and
RDI)
Provide technical specifications based on the business requirement
Conduct unit testing
Provide systems analysis and design in accordance to Systems Development Life Cycle
(SDLC) methodology
Prepare and submit documentation prior to implementation
Monitor and oversee implementation
Provide regular updates to team leads and trainings to end users
Production Support
The task involves issue handling and resolution in a timely manner .
Responsibilities included:
Analyze production issues
Identify possible cause and provide resolution
Raise change request and assign to business analyst
.
YKK Holding Asia Pte Ltd
#08-02/04 Gateway East
152 Beach Road, 189721 Singapore
Sr. IT Support Engineer
October 2013 – August 2015
Production Support
The task involves analysis, program development and enhancement on affected systems running in
AS400.
.
Responsibilities included:
Handle production issues
Discuss issues with the IS/IT manager and users
Perform data gathering for the timely resolution of issues
Perform program modification and/or enhancements using RPG ILE, RPG free format, SQL,
SQLRPGLE
Conduct and manage unit/system/integration testing
Submit documentation prior to implementation
Handle and oversee implementation
Conduct Compleo printing support for the production label printing
Provide regular updates to management and trainings to end users
Project Team
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 and do the setup for 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. System was developed combination of S36 and RPG/ILE.
.
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 and training to end users
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
Oce Business Solutions
4/F PCCI Bldg McKinley Hill,
Fort Bonifacio Taguig
Philippines
Sr. Analyst/Programmer
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 and training to end users
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
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
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
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
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
Junior Trainee
November 2000 – April 2002
PERSONAL PARTICULARS
Education
Age
Birth Date
Nationality
Gender
Marital Status
Residence
Bachelor of Science in Computer Science
Notre Dame of Dadiangas University
March 2002
37 Years
01 October 1981
Filipino
Males
Married
Wroclaw Poland
