TECHNICAL SKILLS

• General Software:
• Lotus 1-2-3, Word Perfect 11, Quattro Pro , Crystal Reports 6.0, Microsoft Office 2007, Microsoft Outlook, Client Access Express, Netsoft Transfer, Adobe Acrobat, Lotus Notes 6.5, Quick View Plus, Internet Explorer 8.0, Netscape Navigator, Paint Shop Pro, Turnover, Aldon Change Management, Protracker, Visio, RFFlow, Ipass Connect, Cisco Systems VPN, dBase IV, Microsoft Lync, Citrix GoToMeeting, Microsoft Online Services
• Operating Systems:
• Novell Netware 3.12 , Windows 3.1, 95, 98, 2000, XP, Vista, 7 , MS DOS, OS400 V7R1M0, Unix
• Programming Languages:
• RPG II, III, 400, IV, ILE, Free, Binding, Embedded SQL Visual Basic 6, Control Language, HTML, SQL, Oracle, Open Query File, System 36 Procedures, NetData, Java training only , XML, Cobol
• AS/400 Interface Tools/Software:
• Synquest Manufacturing, Golden, Golden32, FTP, Innovis Software for EDI, Cognos, Unix/Oracle 9i, ODBC Open Database Connectivity , Citrix, Kronos, IBM Websphere Studio Client for I-Series, IBM Content Manager for I-Series including IBM OnDemand32, Lansa Development, Symtrax Compleo Explorer 3.6.10, GoAnywhere, Linoma Surveyor, VisualAge RPG, Websphere Development Studio for iSeries, Microsoft Visual Studio 2010
• Manufacturing Software:
• JD Edwards World One World Dream Writer, Data Dictionary , BPCS, Logpro, McKosker, ProfitKey International, Software Plus, Forms X-Press, Dancik Software, Butler Curless Software
• Hospital/Health Care Software:
• Lawson 7.2, McKesson HBOC, First Coast, Eclypsis Transition Systems Inc.
• 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, Aldon Life Cycle Management 7.5

PROFESSIONAL EXPERIENCE

Confidential

Lead IT Tech

• Programmer/Analyst performing maintenance and providing support using the RPG programming language.
• Worked as Tech Lead on Debit Card Project
• Modify RPG programs, RPG Embedded SQL, SQL, CL programming and approval.
• 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

• Programmer/Analyst performing maintenance and providing support using the RPG programming language.
• Working on problem tasks as assigned by IT Manager relating to Human Resource and Payroll information.
• Modify RPG 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.
• 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

Confidential

Senior i-Series Programmer/Analyst

• Programmer/Analyst doing maintenance and new development using the RPG programming language for BPCS environment.
• 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 that would show Sales Order Detail and Order Line Detail.
• Created Monthly/Yearly Average Sales Program
• Worked on several different RPG 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

Confidential

Contract Programmer/Analyst

• Contract Programmer doing maintenance and new development using the RPG programming language
• 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

Confidential

Contract Programmer/Analyst

• Part of a three-person development team in charge of creating and maintaining Lawson HR/PR interface programs.
• JPS had recently gone through an upgrade of Lawson Software from version 7 to version 9. They needed someone to come in and help build reports and perform maintenance on existing programs. They also needed someone who knew Lawson to create new interface programs to convert data from other software packages to Lawson format. The reason for this was because JPS had recently been purchased by another company and now they want to consolidate all of the information into one database.
• Created a Market Segment Inquiry by Monthly Detail report. This was added on to an existing program which allowed the user to press a function key which showed an additional screen with more detail.
• Created a Maintenance program to allow a user to maintain a Budget Information File.
• Created a Product Code/Budget Maintenance program.
• Made changes to Open Enrollment programs to allow the entry of Weave Orders, added lines to Contract Instructions Display File and fixed a problem with an Array Index Error.
• Made a change to a Sales Inquiry program which allowed the user to view Budget Information.
• Added a new portion to an existing Shipments-Not-Invoiced program which now loads a Sales Detail File with Product Codes.
• Worked on the creation of an Employee Benefits file which is sent to Blue Cross Blue Shield.
• Worked on making changes to a Fidelity Contribution File load program which did not include information from all employees from every plant because of the new structure of the company.
• Added a Y/N prompt to keep users from clearing a transportation file by mistake.
• Created a 'Sales vs. Returns' report program by Monthly and Yearly totals.
• All coding was done using Free-Form RPG, Embedded SQL and RPGIV.

Environment: Windows XP, Microsoft Outlook, AS/400 I5 Model 525, Lawson 9 Software, Advantis Shawware for AP/Purchasing/Supply, GBA for Fixed Assets, SmartFTP, Symtrax Compleo Explorer

Confidential

Application Software Specialist

• Part of a two-man development team in charge of creating and maintaining the Butler Curless full suite of business software. Butler Curless Software included everything from financial to manufacturing modules.
• IT manager received phone calls that were requests for new development, modifications or fixes to the existing software suite.
• Turnover was used for tracking events and for programmers to record problem resolution and time tracking for new development and checking out existing programs.
• The programmer had to have the ability to work fast and under pressure solving problems with a wide variety of program types. This included RPG ILE, /free, CL and embedded SQL.
• While employed with Butler Curless, I worked extensively applying technologies enabling customers to receive faxed document confirmations from Order Entry and Invoicing using some IBM supplied commands such as SNDFAX and SBMFAX. Also applied to these processes, were e-mails sent to customers using commands such as CPYTOSTMF and CPYTOPCD. Once the spool file was copied, java programs created by other programmers were used to actually send the documents.
• Extensively involved in User Acceptance Testing UAT .
• Worked with other developers to resolve technical issues and investigate software problems.

Environment: Windows XP, Microsoft Outlook, AS/400, Butler Curless Software

Confidential

Programmer/Analyst

• Add additional fields to existing programs and screens. Create maintenance programs for new files and create reports for the new information.
• All of the changes and additions were done for the revenue portion of data that was used in JD Edwards ERP.
• The Revenue information came from an in-house software that was interfaced with JD Edwards. I had to make sure that the data could be converted and stored in JD Edwards files.
• Managed Job Scheduling for Batch programs on the AS/400.
• This was a contract position that lasted one month.

Environment: Windows XP, Microsoft Outlook, AS/400, JD Edwards World Software

Confidential

Systems Analyst

• Part of a maintenance team called Maintenance Task Force MTF . Dancik Software received several calls every day with various software problems. Our mission was to analyze the problem and resolve the issue as soon as possible using various techniques for this home-grown ERP system.
• Business System Specialists received the phone calls, evaluated the problem and fixed them when possible. If the problem could not be resolved then the event was sent to the Maintenance Task Force for resolution.
• To resolve the problem, we used Telnet to get to the Client's AS/400 and using SQL or Debug
• we would determine what the problem was and fix it. With System 36 programs we could only
• analyze by going through the program manually or by sight.
• Turnover was used for tracking these events and for MTF to record the resolution to the problem.
• The programmer had to have the ability to work fast and under pressure solving problems with
• a wide variety of program types. This included System 36 programs and procedures to RPG ILE, Binding
• Modules, NetData, Embedded SQL and HTML.
• Developed all programs and files according to SDLC Systems Development Life Cycle
• Several programs were created using RPG bound modules with Binding Directories.
• Extensively involved in User Acceptance Testing UAT .
• Worked with other developers to resolve technical issues and investigate software problems.

Environment: Windows XP, Lotus Notes, AS/400, Dancik Software

Confidential

Lawson HCM Programmer

• At PFG I was involved in creating programs around the Lawson 7.0 software creating interfaces between Lawson and Kronos. We created several interfaces between Lawson data and data being received/sent to all of the company's food distribution centers. I Also worked closely with H/R representatives to analyze and fix problems within Payroll, A/P, A/R, and G/L modules of Lawson.
• Gathered requirements and analyzed business and system functional needs.
• Developed process flow diagrams in Visio and RFFlow based on functional requirements.
• Interacted with various process and business owners of the applications.
• Developed all programs, files according to SDLC Systems Development Life Cycle .
• Extensively involved in User Acceptance Testing UAT .
• Worked with other developers to resolve technical issues and investigate software problems.
• Experimented developing RPG programs with Visual Lansa and Visual RPG
• Sarbanes-Oxley compliancy was used in all aspects of SDLC.

Environment: Windows XP, Microsoft Outlook, AS/400, Kronos, Lawson, Visual Lansa

Confidential

Programmer/Analyst

• I was involved in a project to improve the existing Supply Chain Management SCM System to a more automated and user friendly environment. This system incorporated an AS/400 sending and receiving data to and from an Oracle database on a Unix Platform.
• Responsible for Supply Chain Data Management using Oracle on UNIX and AS/400 JD Edwards databases for two years managing data flow to and from both systems.
• Used Visual Basic 6 to create new features for existing modules within Synquest Manufacturing.
• Maintained an existing Java program which was created on the AS/400 and Unix systems that sent information automatically to and from the Unix system when the RPG Trigger programs processed new information.
• Created new programs to print data reports for both AS/400 and Oracle databases using SQL Query/400, RPG IV and ILE.
• Created new RPG and RPG File Trigger programs and a new database to send information to UNIX database for processing.
• Created SQL Views and Scripts to extract information from the Unix system for Statistical Analysis, which allowed me to determine errors in data return to AS/400.
• Used EDI software, Cognos Impromptu and Cognos Upfront, to develop custom reports as required from JD Edwards data files.
• Used JD Edwards World and One World to enter Purchase Order and Work Order information to create test transactions for EDI documents.
• Assisted AS/400 Administrator frequently due to high request demands from users. My prior experience with setting up user profiles, output queues, printer problem solving, and job schedule maintenance, allowed the AS/400 Administrator to have more time to perform more technical tasks for the company.
• Participated in the creation of AS/400 nightly CL program jobs to run in the AS/400 Robot Scheduler.
• Assisted the project manager in determining the project scope and accordingly prepared the project plan.
• Helped develop the Functional Specifications Document FSD for each project.
• Interacted with other departments to make business decisions.
• Used Microsoft Visio for process flow diagrams.
• Helped with conversion of old Cobol programs to the new RPG IV programming language.

Environment: Windows 2000, Oracle 9i, SQL Plus 9.0, Oracle application server, AS/400, JD Edwards ERP

Confidential

Programmer/Analyst

• One of the major projects that I worked on was to create a database warehouse in which all information from Lawson, McKesson HBOC and other Health Care Packages could be converted and stored for data analysis.
• Responsible for creating new programs and maintaining existing programs as needed using RPG III, RPG 400, RPG IV and Crystal Reports.
• Create and maintain databases using Lotus Notes.
• Worked in all areas of hospital knowledge base including Human Resources and Payroll using Lawson Software.
• Worked with Admissions and patient critical information using data within McKesson HBOC software.
• Since there were only three programmers in the organization, AS/400 Database Administration and Maintenance was a part of daily routines.
• Worked on major project creating an interface between the McKesson HBOC database and
• Transition Systems software for database warehousing. This system is now being used for
• reporting and analytical purposes.

Environment: Windows 98, Lotus Notes, AS/400

Confidential

Programmer/Analyst

• A large project I was involved in was changing an existing software application from RPG II to RPG IV and ILE to make the product current and to prepare for the year 2000.
• Created new programs and maintained existing programs as needed on five AS/400s using RPG IV.
• Created new queries for custom reports when needed.
• Installed software on new PC's when necessary such as Microsoft Office.
• Assisted in the installation of four new AS/400s working closely with IBM Consultant.
• Created and Implemented new designs for Accounts Payable, Payroll Checks, and 1099 Tax
• Forms using Forms X-Press.
• Maintained four different types of Software on the AS/400 which include McKosker, ProfitKey,
• Forms X-Press, and Software Plus.
• Successfully recreated an existing software package called Projects to make the RPG code
• observable and Year 2000 compliant.
• Assisted in maintaining AS/400 jobs, power up and down, and backup schedules to ensure daily and nightly reports ran without error.
• Provided prompt response and effective solutions to customers for programming problems, pc problems, or user profile problems.
• Assisted in the daily maintenance of menus for AS/400 and ProfitKey Financials

Environment: Windows 95, Microsoft Outlook , AS/400

Confidential

Instructed students on use of specific programs. Maintained existing programs, and developed new programs as needed using RPG II and RPG/400.

Confidential

Worked in various types of businesses in the states of Maine and Georgia.