AS400 Programmer Analyst

LILIA MARTINEZ

Evanston, IL

acy9y1@r.postjobfree.com

SUMMARY

Accomplished professional with analytical, organizational and technical backgrounds in Data Processing. Ability

to multi-task along with being adaptable and open to emerging technologies and challenges.

Looking for an AS400/iSeries Programmer Analyst position within the Chicago area.

TECHNICAL BACKGROUND

Servers: AS400/iSERIES/IBM i, JAVA WEB SERVER, MICROSOFT CONTENT, INTEGRATOR, RJS.

Software: RDi 9.1 TUTORIAL, MS OFFICE, SDA, DFU, DBU, SEU, PDM, QUERY/400, SQL,

MS .NET FRAMEWORK, MS SQL SERVER 2008

Languages: RPG/400, RPG III/IV, RPG FREE, ILE, CL, DDS, SUBFILES, SQLRPG, IBM-SQL, JAVA.

EDUCATION and TRAINING

AS400 Programmer Certificate, Computer Systems Institute, Skokie, Illinois

Dot Net Developer Certificate, Computer Systems Institute, Skokie, Illinois

Software: INFINIUM, LANSA, BPCS (AS/SET), IBS (ASW), INTELEC, Implementer, ALDON CMS, Turnover,

Hawkeye, Robot Scheduler.

Northwestern University – University College: Object Oriented and C++ classes

Java Programmer Course, TechSkills, Chicago, Illinois

B.S., International Business and Management, Gonzaga University, Spokane, Washington

EXPERIENCE

STANDARD PARKING PLUS, Chicago, Illinois 2016- 2016

AS400 Developer - consultant

Supported accounts payable data migration from the Oracle platform into IBM i environment. Projects include:

Built ACH Wells Fargo vendor payments interface in RPG FREE.

Modified reporting to email csv files instead of spooled files using embedded and interactive SQL.

Converted query programs into sqlrpgle format.

Utilized tools: FTP Alliance software, Turnover, IFS, Infinium/Infor ERP.

CEANNATE CORP., Rolling Meadows, Illinois 2014- 2016

ISeries Software Developer

Worked for the Financial Management Systems division (FMS). Key RPG FREE Format projects included:

Redesigned Compromise interface for both the Department of Education and the Private sector.

Built functionality to systematically assign new business accounts to collectors.

Automated Non-Sufficient funds process for all Private sector clients into the INTELEC payment process.

Created Department of Education Security Token Re-Certification process.

Used FTP as a Change Management Tool.

AMERICAN HOTEL REGISTER CO., Vernon Hills, Illinois 2007 –2014

Sr. Systems Analyst (2013 – 2014)

Gathered information and requirements from a wide range of audiences such as: developers, systems architects, administrators, business end users, and external clients to provide additional support for the Supply Chain, Logistics, Marketing and Sales across different business platforms for a hotel distribution company.

Sr. AS400 Programmer Analyst (2007 - 2012)

Rebuilt the sales reporting based on new data standards.

Developed the Sales Representative customer assignments functionality.

Built data repository for daily pricing changes and provided future pricing reporting.

Leveraged Integrator’s interactive function across user base.

Supported the IBS/ASW ERP Financial and Distribution modules.

AFFIRMATIVE INSURANCE SERVICES, Chicago, Illinois 2003 – 2007

Programmer Analyst

Worked with the Policy Management homegrown ERP AS400 system. Key RPG IV ILE assignments:

Integrated the new business mod with Affirmative’s first credit –based product rollout. Created various ad hoc production reports to allow users to select diverse criteria to run by state, agent type, date range, pay type, store and commissions among others.

Prepared Billing Fee Analysis and Agent Aging for the Accounting department.

Resolved Policy Life Cycle work orders for new business, endorsements, renewals, and cancels interfaces.

Maintained system for the Insurance Industry compliance and reporting to state agencies.

Used Binding directories, Service programs and Stored procedures tools.

CHRISTY WEBBER LANDSCAPES, Chicago, Illinois 2002 - 2002

Business Systems Analyst

Analyzed business practices and existing hardware and software. Solicited and recommended a fully integrated software package for maximum benefit and expanded business capabilities.

NEWARK ELECTRONICS, Chicago, Illinois 2001 - 2002

Programmer Analyst

Worked for the financial group specializing in cash applications and treasury functions. Major RPG IV projects included:

Converted the in-house manual credit card processing into the automated BPCS ERP cash application process. This resulted in significant reduction of man hours and time required to post payments to accounts.

Gathered requirements from International banks and in-house users to create EDI specifications, design and code the automation of Canadian and Mexican lockboxes.

Assisted in a variety of lengthy production support issues such as: Fix Assets Period End Processing and Year End Roll and Clear, AP Payments Terms, GL Fiscal Years Archiving and Credit Limits Reduction.

Provided daily user production assistance for the Cash application department.

ROHM AND HAAS (MORTON INTERNATIONAL), Chicago, Illinois 1997 - 2000

Programmer Analyst (2000)

Additional responsibilities as project leader to organize and delegate projects due to limited staffing resources.

Applications Programmer (1997 - 1999)

Utilized the complete Software Development Life-Cycle (SDLC): gathering requirements, analyzing, designing, coding, testing and implementing on-line and batch custom programs in RPG III. Used DB2, PDM, SEU, SDA, DDS, RLU, DBU, Query/400, SUBFILES, FTP, CL and ALDON CMS tools.

Modified and maintained the INFINIUM ERP human resources and payroll applications. Assignments included:

Customized Y2K compliant interface programs for benefit providers.

Provided user training and prepared user procedure manuals.

Resolved day-to-day production problems and user issues.

Contact this candidate