Orlando Gonzales

Simi Valley, CA *****

adldu7@r.postjobfree.com

adldu7@r.postjobfree.com

+1-805-***-****

Experienced software developer and technical designer, demonstrated history of working in computer software industry, with a Bachelor of Science degree in Computer Engineering.

SOFTWARE

Well-versed in the following operating system, development tools and languages:

RPG (free format, embedded-SQL), CLLE, SQL, Query/400, DB2, HawkEye, TurnOver, Aldon CMS, RDi, WDsC, SDP Rational 7, OS/400, Operations Navigator, DBU, IOMS, RLU, SDA, APlus, Content Manager, Implementer (Change Mgt. System), ProView, Jira,

RDi v9.6, IBM i Access Client Solutions, DBeaver v7.3.5

Knowledge of the following:

Python, HTML5, JavaScript, SQL Server, VB6, Atom Editor, MySQLworkbench

HARDWARE

Experience on PC desktop hardware assembly, disassembly, upgrade, and LAN installation.

EXPERIENCE

Advisor Group / Vincent Benjamin (remote work) 12/17/2020 – present Senior iSeries Developer (Full Time)

-Works for the Commission Team of Advisor Group to modify, enhance, write, and design iSeries programs using free-format RPG, embedded-SQL, RPGLE, CLLE, SQL, DL, DML, OPM programs.

-AG is one of the largest networks of independent wealth management firms in US.

-Utilizes tools like Rational Development for iSeries (RDi v9.6) as a tool for editing codes and debug; DBeaver v21.0.1 as universal database manager that interacts with the company’s iSeries databases and tables; IBM i Access Client Solutions as a interace tool which consolidates the most common tasks for using and managing the IBM i; Aldon CMS as the change management system.

Copart, Inc. (remote work) 7/15/2013 – 1/17/2020 RPG/SQL Programmer (Consultant & Full Time)

-Utilized free-format RPG, embedded SQL, RPGIV, RPGIII, CLP, CLLE, service programs, OPM programs, sub-procedures, DBU, WDsc v7, HawkEye, System i Operations Navigator, stored procedures, DB2/400, SQL/400, RDBMS, DDL, DDS, IBM Rational Developer for Power Systems Software v8.5.1, RDi 9.5.

-Working knowledge on agile development methodologies, Atlassian Jira, Zendesk

-Member of the CAS Core team, production support team for the iSeries side to resolve production issues when they arise, worked also on enhancements as needed for the CAS-applications.

-Created new interactive processes (NMVTIS) to send/resend information to the Department of Justice. Created scheduled batch job processes for DOJ Reporting.

-A member of 2 programmer analysts who created Virtual Yard Sales project for CAS.

-Sole Programmer Analyst who made enhancements to the Call For Release process.

-Worked on creating Title forms via PDF for the different states of DMV; special mailing of certificate of title, application for vehicle title, application for an original salvage/scrap title.

-Created a tool to send objects between iSeries environments.

-Maintenance, enhancements to the Buyer and Seller processes

OPN Consulting, Inc. (remote work) 2/1/2013 – 7/1/2013 Technical Lead / Designer (Consultant)

-Utilized VB6 to put together different components to form screens while creating technical designs to create a windows-based payroll system for multiple clients.

-Worked with offshore programmers to code the designs using VB6, lead two programmers and 2 business analysts.

-Performed data analysis, functional and technical designs to form a working windows-based application for a unique system, Swine Performance System. This application will monitor performance of the swine, will also be able to provide projections as to costs and productions.

-Used TeamViewer8 and Skype tools to communicate and conduct meetings with the offshore team.

Station Casinos (Las Vegas NV) 12/14/2010 – 1/21/2013

iSeries Programmer Analyst (Consultant)

-Coded, analyzed, designed, performed modifications and enhancements to the company’s Casino Management Systems.

-Modified the Player Rewards Process, Trip History Process.

-Enhanced the Player Tracking, Marketing processes: Improved the system performance of the pit, slot, and other ratings by creating proper indexes while retrieving data using SQL cursors.

-Created conversion programs to merge properties into one ring (one property)

-Created new service programs, modifies existing service programs where appropriate.

-Enhanced the Comp’s Value Matrix applications.

-Worked with the marketing division to identify and resolve issues in order to have a stable applications and reliable data between marketing databases and the CMS.

-Utilized RPGIV, RPG/400, CLP/CLLE, DDS, DB2/400, and stored procedures to create working objects.

-Tools were used like Operations Navigator, PDM, SEU, Aldon CMS, IBM Rational Developer for Power Systems Software (RDP)

Copart (Fairfield CA) 08/2008 – 08/2009

RPG Programmer (Fulltime)

-Performed analysis and application development for company’s marketing systems. Developed dealer agent maintenance, agent commission reporting for the marketing department

-Performed analysis and enhancements to the company’s processes / jobs for better system performance.

-Created a system to provide company’s and on-behalf of insurance carriers’ vehicle information for NMVTIS reporting as part of requirement mandated by Department of Justice. Converted data into XML documents prior to sending via secured site. Received response-XMLs and converted back to DB2/400 for further analysis, review, and correction of rejected data.

-Utilized RPG/400, RPGLE, CLLE, embedded-SQL, DDS.

-Utilized development tools like Websphere Development Studio for iSeries Client version 7 (WDsC SDP7.0), DBU, iSeries Navigator.

Disney (Burbank CA) 10/2007 – 05/2008

Sr. Programmer Analyst (Consultant)

-Performed programming for creating interface programs from EDI to SAP and vice-versa, using prototyped procedures, modules, and service programs.

-Performed some analysis on the technical specifications designs provided by the project manager prior to coding.

-Programming languages utilized were RPGLE with free-format and embedded-SQL techniques, CLLE/CLP, DDS, SQL/400.

-Tools like Implementer, EZVIEW, DBU, HawkEye were employed.

Carnegie General Insurance Agency (Camarillo CA) 05/2007 – 10/2007

Sr. Programmer Analyst (Fulltime)

-Performed analysis, programming enhancements and modifications to the current Specialty Insurance Systems (SIS).

-Performed programming to import network files to an application called IBM Client Application for iSeries (Content Manager) using new programming technique like prototyped procedures, modules, and service programs.

-Utilized ILE, free-format RPG (RPGIV), CLLE.

-Tools like Websphere Rational, Code Designer, DBU, Aldon CMS, APlus (like Hawkeye) were being used.

Countrywide Home Loans (Simi Valley & Calabasas CA) 10/2002 – 04/2007

Sr. Software Systems Engineer (Fulltime)

-From 2006 to 2007, worked for the Secondary Marketing as a developer. Responsibilities included modifications and/or enhancements of the existing iSeries programs using CLLE/CLP, RPGLE (free and embedded-SQL), and RPG languages. Tools like DBU, HawkEye, WDsC v5.1.2, WDsC version 6 or Rational, Code/400, Code Designer, and TurnOver are used to facilitate analysis, coding, testing, and object promotions.

-In addition, created scripts using SQL Server Management Studio to make sure the data extracted from the iSeries are properly downloaded to the SQL server, as part of the integration testing. Also, performs some ad hocs tasks on the SQL server side.

-From 2002 to 2006, a member of the CSSD-HELOC IT team. The same programming tools were employed, i.e. TurnOver, DBU, etc.

-Technical Lead while working on Payment Processing Rewrite Project (R3). Responsibilities include delegation of workload to the other 3 programmers, integration testing, and implementation, coding using prototyped procedures, modules, and service programs.

-Specifically involved in technical designs, developments, enhancements, modifications of the HELOC IT projects primarily using free-format RPGLE, CLLE, embedded-SQL.

-Developed programs for the Billing and Statement process of HELOC, payment processing rewrite project that involves reversals, recalculations, and reapplications of different transactions of loans.

-Primary developer for Flex-Saver ARM project, Penalty Fee project, Late-Charge Compliance project, etc.

-Primary support for the HELOC Investor Accounting group, Daily Audit, Billing Process. Since these are huge processes, multi-threading technique were employed to these batch jobs in order to improve performance specially month-ends.

Global Technical Resources (Westlake Village CA) 1/2002 – 10/2002

Sr. Software Systems Engineer (Fulltime)

-Worked for Countrywide Home Loans, Simi Valley, CA as a member of the conversion team specifically the V11-Remaining Products for converting loans from Woolwich to GSS. Worked on GSS database administration doing static file maintenance, file changes and creation through TurnOver. Languages like Control Language, RPGLE were employed.

Solution Bank Inc. (remote work) 6/2000 – 1/2002

Programmer Analyst (Fulltime)

-Performed migration of Pliant Corp’s Integrated Dist. System (IDS) and FILMS application into FILMS II, a manufacturing system specializing in converting resins to plastics and zippers.

-Involved in systems analysis, development, enhancement and maintenance of the item master maintenance, order entry process and shop floor control of FILMS II to bridge the functionality gaps between IDS and FILMS.

-Primary programming language and utilities used were RPGLE, CLLE, TurnOver, HawkEye, DBU.

International Business Systems-US (Folsom CA) 3/1999 – 4/2000

Programmer Analyst (Fulltime)

-Developed and enhanced technical designs of ASW interface-to-Vertex tax, Credits/Debits interface-to-Vertex tax.

-Team member who retrofitted PTFs, maintained, modified, and enhanced the company’s product, Application Software-Distribution System (ASW).

-Primary programming language and utilities used were RPGLE, CLLE, Aldon CMS, HawkEye, DBU.

IBM NZ (Auckland, New Zealand) 6/1998 – 2/1999

Analyst Programmer (Consultant)

-Part of the big team of Customer Care and Billing – Integrated Customer Management System (ICMS) – a system for telecommunications companies.

-Fixed program errors, made enhancements and resync as per request by the production support team to other releases to reflect the changes and/or enhancements and promote to the base release.

-Application programming languages used were Control Language (CL), RPG, DDS.

-Tools used were Aldon CMS, Hawkeye.

Mitsubishi Motors Corp. (Cainta Rizal, Philippines) 8/1997 – 5/1998

Programmer II (Fulltime)

-Team player that developed KZ-MMO/Spare Parts Ordering/Shipping System, which include main file inquiry system, account item master maintenance, order receive work file and main file amendment, issuing invoice sheet.

-Worked as assistant supervisor, member of five programmers to develop shipping system of the new model of Mitsubishi car using RPG III and Control Language (CLP).

-Team member who maintained and modified the company’s local parts systems (deliveries, rejections, material losses, and damages), manpower and fuel allocation monitoring systems, production control systems, sales and promotion system, vehicle invoicing systems, accounting and receivable system and car-plan subsystems.

-Greatly involved in the Y2K conversion project.

Information Engineering Workshops (Pasig, Philippines) 6/1996 – 8/1997

Programmer (Fulltime)

-Contributed in system analysis, design, data gathering, unit and system testing, and programming of the insurance system of SEICI.

-Developed bordereaux generation system of sales production, underwriting and losses statistics, cashiering and receivables. Created CL programs for converting files to be uploaded from PC to the AS400.

From 1989 – 1996

-Had vast experience working overseas in Saudi Arabia, Malaysia as Hardware Engineer, doing PC/LAN installation, maintenance and upgrade.

EDUCATION and CERTIFICATION

Bachelor’s Degree, Computer Engineering 1990

MIT, Manila, Philippines

IBM Technical Conference 10/2005

Miami Beach, Florida

Certification, Unix operating system 2001

Folsom Lake College, Folsom, CA

Certification, VB 6 Programming 2001

Folsom Lake College, Folsom, CA

Additional Trainings were provided by Jon Paris and Susan Gantner for RPGLE, CLLE, embedded SQL, tools like WDsC for Countrywide employees.

Contact this candidate