TECHNICAL SKILLS

Software: Crystal Reports 6.0, Microsoft Office Full Suite, Adobe Acrobat, Paint Shop Pro, Visio, RFFlow, AxisPoint CCMS, FIS(SunGard) Macess, Visual Studio 2008/2010/2012

Operating Systems: Windows 10, OS/400 V7R3M0, Unix, SQL Server 2012/2008 R2/2005 SSIS SSRS

Programming Languages: RPG (II, III, IV, ILE, Free, Embedded SQL) Visual Basic 6, Control Language, HTML, SQL, Oracle 9i, Open Query File, System 36 Procedures

Technical Software: Synquest Manufacturing (Golden, Golden32), FTP, Innovis Software for EDI, Cognos, ODBC (Open Database Connectivity), IBM Websphere Studio Client for I - Series, IBM Content Manager for I-Series including IBM OnDemand32, Symtrax Compleo Explorer 3.6.10, GoAnywhere, Websphere Development Studio for iSeries, Microsoft Visual Studio 2010, RDi with ARCAD

Manufacturing Software: JD Edwards World 7.0, BPCS, Logpro (WMS), McKosker, Software Plus, Dancik ERP Software

Health Care Software: Lawson 7.2, McKesson HBOC, Eclypsis 

AS/400 Tools: DBU (Data Base Utility), DFU (Data File Utility), SEU (Source Entry Utility), SDA (Screen Design Aid), PDM (Programming Development Manager), SQL (Structured Query Language), Query/400, RLU (Report Layout Utility), IFS (Integrated File System), RPG Alive, Hawkeye, Sequel ViewPoint, Turnover

PROFESSIONAL EXPERIENCE

Confidential

RPG ILE Programmer/Analyst

Responsibilities:

• Worked with senior management, internal and external cutomers to create Interactive RPG and SQLRPG programs for file Maintenance.
• Created RPG programs to work with sending PDF reports to the IFS.
• Worked with all team members on tasks that were backlogged and listed in Jira software.
• Worked on converting RPG to RPG LE using RDi and ARCAD

Environment: Windows 10, Microsoft Outlook, Microsoft Teams, iSeries 7.3, Microsoft Office, ARCAD Change Management, IFS

Confidential

RPG ILE Programmer/Analyst

Responsibilities:

• Confidential Parts specializes in store/warehouse sales and distribution of car parts. I worked with Senior Programmers to learn the business and help with trouble shooting tickets and debugging and fixing problems with programs.
• Much of the work consisted in the receiving and sending of EDI documents from several warehouses and vendors associated with Confidential Parts.
• I created a program which allowed a user to Display, Add, or Delete records from a Lines Exclusion File using all RPG/Free.
• I documented different process flows such as Order Receiving and Order Sending to and from JMO which was our software company that kept track of all transactions such as shipping, receiving, invoices, Sales Orders etc. This was documented using Google Diagrams.

Environment: Windows 10, Microsoft Outlook, iSeries 7.2, Microsoft Office 2013, In-house Change Management, FTP, IFS

Confidential

RPG ILE Programmer/Analyst

Responsibilities:

• Responsible for assisting in the analysis of an existing AR and Billing database. The database and all RPG programs will be retrofitted, and all programs modernized to most current ILE RPG code available.
• Analysis for data was performed using IBM Rational Developer for I. Some new RPG code was also done using the same software.
• Worked with users for requirements gathering
• Researched fact finding, searching data and trying to find best ways to implement a new project as needed throughout the entire SDLC process

Environment: Windows 10, Microsoft Outlook, iSeries 7.2, Microsoft Office 2013, Aldon Change Management

Confidential

RPG/SQL Developer

Responsibilities:

• Responsible for Enhance and support FIS Macess, AxisPoint CCMS applications used to maintain workflow and process claims in Healthcare system.
• Create and maintain member security in Macess, CCMS.
• Wrote various SSRS custom reports for Macess and CCMS.
• Worked on trouble-shooting various application problems on the i-Series using Sequel Data Warehouse.
• Helped prepare the i-Series for decommissioning.
• Worked on all the phases of iteration in the Agile methodology.
• Worked with users for requirements gathering
• Researched fact finding, searching data and trying to find best ways to implement a new project as needed throughout the entire SDLC process

Environment: Windows 7, Microsoft Outlook, iSeries, Microsoft Office 2013, TFS

Confidential i-Series Programmer/Analyst

Responsibilities:

• Analyze current needs of the customers’ BPCS ERP system to prepare for new Barcode Software.
• Lead three man team of Programmers, determining current functions of Cobol programs to prepare to mirror current programs that run interactively and change them to run in Batch.
• Give estimated time and cost for each deliverable module for the customer.
• Currently waiting on Trinity to receive sign off on their new Barcode Software and Hardware.
• Worked with users for requirements gathering
• Researched fact finding, searching data and trying to find best ways to implement a new project as needed throughout the entire SDLC process

Environment: Windows 7, Microsoft Outlook, iSeries (Remote), Microsoft Office 2013, Cisco AnyConnect

Confidential i-Series Programmer/Analyst

Responsibilities:

• Debug manufacturing programs using RPG DEBUG.
• Converted RPT (RPG) programs to RPG ILE with modules.
• Translated Swedish language, in the Program Source documentation to English.
• Worked on finding out why the Actual Ship Date was not matching the Actual Due Date in the Master Shipping Number Maintenance Screen.

Environment: Windows 7, Microsoft Outlook, iSeries, Microsoft Office 2013

Confidential

IT Security Data Programmer/Analyst

Responsibilities:

• Worked as Security Programmer/Analyst with the RPG Programming Language
• Created a program to determine access privileges for ODBC access to 27 other iSeries machines using RPG /free, Embedded SQL, CL and SQL.
• Used Qshell for searching IFS System Log Files for specific information.
• Created a program which would download System Log Files from the IFS, extract certain pieces of information from the files for reporting purposes.
• Created a subfile program to allow a user to enter specific criteria and generate a report based on extracted data that was derived from the IFS Extraction File. These were created with modules performing separate tasks with RPG ILE.
• Communicated with management, creating and completing documentation through the complete SDLC process.

Environment: Windows 7, Microsoft Outlook, iSeries, Sharepoint, Turnover, Microsoft Office 2013

Confidential

Application Support Analyst

Responsibilities:

• Worked as Lawson Application Support Analyst with many different financial modules.
• Create and verify Accounts Payable, Accounts Receivable, and Benefit reports with RPG or SQL and verify the information in Lawson AP, AR, and Benefit screens.
• Identified any RPG or CL program issues which were centered around Lawson Payroll programs or screens. Programming issues were analyzed using the iSeries Debug tool.
• Used Salesforce to keep track of Change Requests, Problem Tickets and Projects
• Used SQL extensively in CL programs for reporting purposes.
• Communicated with management, creating and completing documentation through the complete SDLC process.

Environment: Windows 7, Lawson 9, Microsoft Outlook, iSeries, Sharepoint, Turnover, Microsoft Office

Confidential

Lead IT Tech

Responsibilities:

• Worked as Tech Lead on Debit Card Project, developing new cards with a security chip.
• Modify RPG ILE programs and modules, RPG Embedded SQL, AS/400 SQL, and CL programming.
• Worked as a Junior IT Tech Lead in charge of a five-person team located in India.
• Worked extensively with management, creating and completing documentation through the complete SDLC process.

Environment: Windows XP, Microsoft Outlook, iSeries, Sharepoint, Turnover, Microsoft Office

Confidential

Contract Programmer/Analyst

Responsibilities:

• Working on problem tasks as assigned by IT Manager relating to Human Resource and Payroll information.
• Modify RPG and RPG ILE programs, RPG Embedded SQL and SQL Scripts with Websphere Development Studio
• RPG Source Code is taken through a Life Cycle Management process using Aldon Change Management
• Worked on several projects using GoAnywhere, XML and Surveyor for Report Creation and Management.
• XML was what ran behind the scenes of the GoAnywhere software. Many times we had to change some of the code to include or remove comments and have batch processes run at different intervals.
• Programs that generate report spooled files use GoAnywhere to place the reports on the iSeries IFS. The software is then used to put the reports on a specific local or remote network drive and folder. It is also used for data retrieval from external sources and creating SQL Scripts.
• Worked on Month End Reporting for Financial/Payroll departments.
• I had been given permission to try and learn VB .NET and Microsoft SQL Server on my own for the purpose of possibly becoming a full-time employee.
• Worked extensively with users on all aspects of projects and tasks.

Environment: Windows XP, Microsoft Outlook, iSeries, Surveyor, GoAnywhere, Turnover

Confidential

Senior i-Series Programmer/Analyst

Responsibilities:

• Worked on large Backorder project. One request of the project was to create a program to determine dates when inventory would be Available-To-Promise.
• Modified a program to call other Subfile programs in an ILE module fashion that would show Sales Order Detail and Order Line Detail.
• Created Monthly/Yearly Average Sales Program
• Worked on several different RPG ILE and Embedded SQL programs for reporting purposes.
• Worked extensively with users on all aspects of projects and tasks for all Manufacturing, Planning and Control Systems.

Environment: Windows XP, Microsoft Outlook, AS/400, BPCS

Confidential

Contract Programmer/Analyst

Responsibilities:

• Work with managers and other programmers to learn about HITS communication with DATIP (Digital Analog Transfer Internet Protocol) programming.
• Modified a program to include a new command which would enable a cable card and a DVR cable box to communicate.
• Worked on several different RPG programs involving Digital Telecommunications.
• Worked on creating views and scripts using Sequel Viewpoint for various reports
• Turnover was used for checking in programs and promoting them into production.
• @Task was used for communicating work issues and assignments to employees. Clik is a part of @Task which allows employees to communicate the progress of what is being worked on.

Environment: Windows XP, Microsoft Outlook, AS/400(I5)model 525, Turnover, @Task(Clik), HITS(Digital Communication)