PROFESSIONAL PROFILE

Software engineer with experience in development (full life cycle) for IBM iSeries (AS/400) environment using RPG III/RPG IV/Free/Embedded SQL/CL.

Skills: Strong Business Systems Analysis, Strong problem solving skills, strong software quality assurance skills, analytical thinking, requirements gathering and Programming, Business Intelligence.

Technical skills: RPG400 (III), RPG IV (free), CL (Control Language), SDA, RLU, SQL/400, Manager/400, OS/400, SQL Navigator, Client/Access, Excel.

US Citizen, Bilingual English/Spanish.

PROFESSIONAL EXPERIENCE

Coomeva Healthcare

Systems Analyst/Developer

Cali, Colombia (South America)

May 2014 – September 2016

Responsible for development and maintenance of new functionalities to the health information system.

Actively participated in the project to convert from the existing core to the new core system, performing both functional and technical roles.

Business Analyst, requirements gathering, solutions testing, final users support.

Healthcare Core data reporting, DB2.

Platform: iSeries/AS400.

Languages: RPG III, RPG IV, RPG Free, CLP, SQL-DB2.

Tools: ACOM, GoAnywhere, Object Control, SEU, SDA, RLU. MS-Excel, MS-Access.

Functional and Technical Requirements gathering for new healthcare core implementation project.

Bancoomeva

Bank (Financial Services-Banking)

Systems Analyst/Developer

Cali, Colombia (South America)

July 2012 – April 2014

Responsible for maintenance and providing user support to the bank s core system (iSeries-AS/400).

Business Analyst, requirements gathering, solutions testing, final users support.

Served as liason with third party vendors.

Financial reports and statistics, DB2.

Languages: RPG III, RPG IV, RPG Free, CLP, SQL-DB2.

Tools: ACOM, GoAnywhere, SEU, SDA, RLU, Client/Access.

Coomeva Healthcare

Systems Analyst/Developer

Cali, Colombia (South America)

March 2011 – June 2012

Responsible for development and maintenance of new functionalities to the health information system (iSeries-AS/400).

Business Analyst, requirements gathering, solutions testing, final users support.

Health care core data reporting, DB2.

Platform: iSeries

Languages: RPG III, RPG IV, RPG Free, CLP, SQL-DB2. MS-Excel, MS-Access.

Tools: ACOM, GoAnywhere, Object Control, SEU, SDA, RLU.

CLAI LTDA.

Banking Switch Software.

Systems Analyst/Developer

Cali, Colombia (South America)

July 2010 – February 2011

Responsible for maintenance to the application Autoriza7 (Banking Switch)Debit and Credit card management, Debit and Credit card management, Channels administration.

Platform: iSeries-AS/400

Languages: RPG III, RPG IV, RPG Free, CLP, SQL-DB2.

Tools: Object Control, SEU, SDA, RLU.

Canon Latin America Inc.

Electronics sales Office

Systems Analyst/Developer

Miami, FL (US)

September 2005 – July 2010

Responsible for enhancements (Analysis, Design, Programming, Testing) of the in house application IDEAL (Purchases, Order Control, Pick/Pack, Shipping, Inventory, Debit/Credit), (iSeries-AS/400).

Languages: RPG III, RPG IV, CLP, SQL-DB2.

Tools: SEU, SDA, RLU, DFU.

Business Intelligence tools: Viewpoint (Views, Sequel Tables, Client Tables, Sequel Reports, Client Reports, Scripts, Dashboards & Applications) for Sales and Inventory data.

Business Analyst, requirements gathering, solutions testing, final users support.

Others: X-Analysis, SEQUEL, SEQUEL Web Interface, ESEND.

PC software: Canon Imageware

Land N Sea Distributing Inc.

Boat Parts Sales

AS400 Programmer/Analyst

Pompano Beach, FL (US)

December 2012 – September 2005

Responsible for enhancements (Analysis, Design, Programming, Testing) of the in house distributing application (A/R, Inventory, purchasing, order entries), export/import data, (iSeries-AS/400).

Provided requirements for third party vendors.

Languages: RPG III, RPG IV, CLP, SQL.

Tools: SEU, SDA, RLU, DBU, DFU, Client/Access

Others: Hawkeye, Fastfax.

Business Analyst, requirements gathering, solutions testing, final users support.

SchlumbergerSema.

Mobil Telephone Software Developer

Software Test Engineer

Miami, FL (US)

April 2001 – July 2002

Responsible for functional and regression testing of the Telecom Customer Care and Billing Software solution-BSCS (Business Support and Control System). Online modules developed in Centura (S.O. Windows NT) and batch modules developed in C (S.O. Unix); Oracle DB.

Assure the appropriate implementation for the user requirements before the final delivery for on line and batch modules.

Developed Test Planning Specifications for each customer change request.

Created Test scenarios to confirm the correct software development.

Languages: SQL.

Tools: Mercury Test Director, SQL Navigator/TOAD, CMVC and Rational Clearcase/Clearquest.

Comfandi

Social Services

Programmer/Analyst

Cali, Colombia (South America)

January 1992 – December 2000

Responsible for the full life cycle of the information systems development, (iSeries-AS/400): gathering user requirements, creating data flows, data models, coding, performing maintenance for the existing programs and development of new ones, performing functional and regression testing, creating test cases to assure the correct functionality of the programs using SQL/400 and Query/400.

Responsible for first level support to the users.

Tested, modified and improved existing programs in order to comply with Y2K requirements for the AS/400 applications, using the tool GEAR/2000.

Provided technical support for applications not developed in house.

Responsible for first level support and subsequently for the management of the application INFOMANTE (client/server application developed in Visual Fox, O.S. Novell) which manages requirements for local repairs, parts inventory and purchase orders. Development of the interface between this application and the General Ledger.

Created user guide and technical manual (analysis, design and programming).

Languages: RPG III, RPG IV, CL, RLU, SDA.

Tools: SEU, MANAGER/400 (Interactive Program Generator)

Business Analyst, requirements gathering, solutions testing, final users support.

Applications developed:

Subsidized Housing: an application through which people apply to obtain economic aids to buy a house and manage the payments to the house’s builders. The aids are assigned depending on the socioeconomic status of the homes requesting the aid. It has online and batch modules as well as an extensive statistics module.

Accounts Receivable: This billing system bills companies whose employees have purchased medicines charging them to the company’s account, and subsequently generates a bill which is paid through the Payments module of the system. It interfaces with the General Ledger and has both online and batch processes.

Accounts Payable: This system allows a user to enter information regarding purchases the company has made to the different providers, indicating the status of each payment in order to provide accurate information to the providers. It interacts with the General Ledger and has both online and batch modules.

Comfandi

System Auditing Assistant I, Internship

Cali, Colombia (South America)

June 1991 – December 1991

Responsible for designing and executing Auditing as well as Quality Assurance programs for iSeries-AS/400, S/36 and PC applications and hardware.

Performed quality control for AS/400, S/36 and PC applications.

Audited the correct use of the Personal Computers in the company (software and hardware).

Education

Bachelor of Science, Systems Engineer - 1992

Universidad ICESI, Colombia

Relevant Courses: SQL Server (SSAS-SSIS-SSRS), SOA Fundaments, ACOM-EZeDocs/400, CRYTO COMPLETE, Project Management for Success, Advance SEQUEL, Business Analysis, Understanding the IFS, Canon ImageWare, AS/400 Intensive Course, AS/400 Database Design, AS/400 Tools, Interactive Program Design, CL workshop, Manager/400 (Interactive Programs Generator), RPG IV for RPG III programmers.

REFERENCES AVAILABLE UPON REQUEST

Contact this candidate