Senior Developer/Analyst

QUALIFICATIONS:

· Skilled programmer in many different applications including Shop Floor Control and Costing

· Experienced developer in RPG, CL and ILE

· IBM Certified AS/400 Developer

· Effective and comfortable working and communicating from the boardroom to the production floor

· Create STORED PROCEDURES on the AS/400 to feed Retail Web Order inquiries.

· Accomplished and talented information technology professional with extensive project management, programming management and consulting experience.

· Skillful staff developer and team builder, with superb analytical skills.

· Broad technical background, which includes process/systems analysis and design for infrastructure technology groups.

· Extensive business knowledge and experience in many industries.

TECHNICAL EXPERIENCE:

Operating Systems: OS/400, CPF, S/36, DOS, WINDOWS

Languages: RPGFREE, RPG/ILE, RPG/400, RPG III, RPG II, COBOL400, COBOL, CL, CLLE, SQL

Utilities: SEU, SDA, RLU, ODBC, DFU, QUERY, FTP

Hardware: AS/400(iSeries), SYS/38, SYS/36, SYS/34, PC

Miscellaneous: MAPICS, Specialty Insurance System, ALDON, Turnover, MKS Implementer, XPOINT, BPCS, PKMS, EZ-Print, Infinium, Lawson, DBU, GENTRAN, Trusted Link(Harbinger), TCP/IP, MS-Excel, MS-Word, MS-Access, MS-Project, Client Access.

APPLICATION EXPERIENCE:

Accounts Payable, Accounts Receivable, Billing/Invoicing, Costing, Fixed Assets General Ledger, Payroll, Electronic Mail, Office Automation, Personnel Management, Purchasing, Order Entry, Inventory Control, Sales Analysis/Reporting, Decision Support Systems, Financial Planning, Project Management, Executive Information Systems, Integrated Systems, Bill of Materials, Material Requirements, Process Control, Production Control, Shop Floor Control, Expert Systems, Imaging, Statistics & Math

INDUSTRY EXPERIENCE:

Agriculture, Political/Non-Profit Organizations, General Banking, Deposits & Accounts, Electronic Funds Transfer, Financial Services, Publishing Circulation/Subscription, Telecommunications, Automotive, Wood/Lumber Industries, Metal Industries, Retail Trade, Point of Sale, Wholesale Trade, Electronic Data Interchange, Construction, General Insurance Agents & Agency Management, Claims Processing, Medical Claims Processing, Policy Handling, Policy Documents Print

PROFESSIONAL EXPERIENCE

Jtech Staffing - Blair LLC, Warren, PA

2/2009 – 6/2009

Programmer/Analyst – QA Tester

· Assist multiple teams with testing of converted data for PKMS.

· Design, develop and implement STORED PROCEDURES for data verification. Meet with end users to get the data/processing needed for each interface.

· Create objects necessary for each procedure to generate the necessary return data for each interface.

· Created RPG procedures to return STATUS of order for web users, ITEM availability and pricing, SHIPPING information.

· Analyze existing interface and create design specifications for new business acquisitions.

· Meet with end users to find out what their true need is for this and future acquisitions.

· Create design specifications document for change to existing interface process for additional functionality needed for new business acquisitions and existing business users.

· Create field to field cross reference file and programming to use the new field to field file for incoming document processing.

· Created RPG procedure to insure that flat file records are in expected format.

· Created RPG procedure to READ the flat (comma delimited) file and create a work file record for entry to production data file.

· Created RPG procedure to READ the work file and generate a record in production using the field cross reference file to set the sequencing of these records for display.

· Develop, test and implement new application interface.

Environment: AS/400, RPG/400, RPG-ILE, RPGFREE, CL, CLLE, QUERY400, SQL

Sapphire Technology - Cardinal Health Inc., Dublin, OH

7/2008 – 2/2009

Senior Analyst/Developer

· Design, develop and implement new FTP process for DEA Daily Sales reporting.

· The process will generate two Accrual Point Alert Reports, one for Retail Independent customers and one for Non-Retail Independent customers, to allow QRA to distinguish one business type from another in order to react appropriately to the information contained in each report.

· Create STORED PROCEDURES on the AS/400 to feed Retail Web Order inquiries.

· Provide current status's and product availability for Web Order Entry. Made future enhancements much easier to accommodate with centralized modular processes. This will save the company time and money by being standardized.

· Design, develop and implement new Over Threshold Email reporting.

· Automated DEA Sales & Suspicious Order reporting. Designed and created BATCH processing to send daily reports. This saved the company 2 man hours a day.

· Assist multiple teams with testing of new procedures for RETAIL WEB ORDER.

· Design, develop and implement STORED PROCEDURES for Network accessibility.

Environment: AS/400, RPG/400, RPG-ILE, RPGFREE, CL, CLLE, QUERY400, SQL

The Fountain Group - LEXMARK, Lexington, KY

5/2008 – 7/2008

Systems Administrator

· Lead for Centralization implementation.

· Create 12 partitions with all resources on production machine.

· Create 3 partitions with all resources on backup machine.

· Hook up and document all communications – ETHERNET, FIBER, INTERNAL/EXTERNAL MODEMS.

Environment: AS/400 9406MMA POWER6

Accuride Corporation AOT, Springfield, OH

9/2007 – 4/2008

Senior Systems Analyst/Developer

· Lead analyst for new ERP/EDI software implementation.

· Lead programmer for Special Shop Operations implementation.

· Create new sub applications from BPCS.

Environment: AS/400, RPG/400, RPG-ILE, RPGFREE, CL, CLLE, QUERY400, SQL

Conn-Selmer, Elkhart, IN

9/2006 – 9/2007

Senior Developer/Analyst

· Lead analyst for new ERP software implementation.

· Lead programmer for Shop Floor implementation.

· Create new reports as needed by departments from MAPICS.

· Design new Excel spreadsheet generation from RPG.

Environment: AS/400, RPG/400, RPG-ILE, RPGFREE, CL, CLLE, QUERY400, SQL, DBU

WorkFlow|One, Norfolk, VA

3/2006 – 9/2006

Senior Developer/Analyst

· Technical Lead for Hawkeye Pathfinder installation and management.

Create new extracting for upload to WEB service.

· Design new dynamic XML generator from file driven base.

Environment: AS/400, RPG/400, RPG-ILE, RPGFREE, CL, CLLE, QUERY400, SQL, DBU

Andre Consulting, Marysville, OH

12/2004 – 3/2006

Senior Programmer Analyst

· Technical Team Lead for upgrade of SIS (Specialty Insurance System) V-2 to V-12.

Create new sequencing for print of paperwork to be used to load trucks.

· Design new PROCEDURES/PROGRAMS to synchronize WEB based Order Entry application with MAPICS on the AS/400 thru production and shipping of product.

· Setup new customer EDI transactions for order processing(830, 862, 856, 810 etc.).

· Develop new reporting for LAWSON for Invoicing and AR.

Environment: AS/400, RPG III, RPG/400, RPG-ILE, CL, CLLE, QUERY400, SQL, DBU, Implementor, Trusted Link

Zoe Staffing, Columbus, OH

9/2004 – 12/2004

Senior Programmer Analyst

· Modification of existing programs to meet Sarbanes – Oxley requirements.

· Modify Security programs to meet Sarbanes - Oxley.

· Design, code and implement new PROCEDURES to return data giving one point of control.

Environment: AS/400, RPG III, RPG-ILE, CL, QUERY400, DBU, MKS

Oxford Consulting, Indianapolis, IN

7/2004 – 9/2004

Senior Programmer Analyst

· Assist client with modification of existing report requests.

· Modify Menu Security programs to meet client's needs.

· Design, code and implement new version of Work Order print for Assembly specifications.

· Assist operations in Operating system upgrade.

Environment: AS/400, RPG III, RPG/400, RPG-ILE, CL, QUERY400, DBU

BitWise, Pittsburgh, PA

3/2003 – 6/2004

Senior Programmer Analyst

· Assist client with multiple report requests.

· Create process to meet the client's needs in the E-Business environment dealing with reports to E-mail and send.

· Design, code and implement processes to correct invalid converted data due to acquisitions.

· Modify Screen and report programs to accommodate changing business environment.

· Mentor Junior programmers in use of ILE and newer programming concepts.

Environment: AS/400, RPG III, RPG/400, RPG-ILE, CL, CLLE, SQL, DBU

Independent Contracting

9/2002 – 2/2003

Consultant

· Worked with multiple clients pertaining to System Performance, Capacity Planning, Operating System Upgrades,

· Application Upgrades, Software Analysis and Year-End processing.

Environment: AS/400, RPG III, RPG/400, RPG-ILE, COBOL, CL, CLLE, SQL

Affiliated Resource Group, Inc.

3/1999 – 9/2002

Consultant

· Extensively modify INFINIUM programs to meet client needs.

· Created process on AS/400 to download and generate Excel spreadsheet

· Design, code and implement process to send outbound documents according to ANSI X-12 standards for EDI system utilizing RPGILE, CLLE, GENTRAN and FTP.

· Automated "Invoice process" to check for necessary documents for Billing;

· Project/Programming lead for multiple Software Application and System conversions.

· Instrumental in helping clients plan, purchase and setup AS/400 for production.

· Plan and implement Operating Systems/Software Application upgrades in MAPIC

Environment: AS/400, RPG III, RPG/400, RPG-ILE, COBOL, CL, CLLE, SQL, MAPICS

LDA Systems, Inc.

11/1996 – 3/1999

Consultant

· Do system and application analysis as it relates to performance and tuning.

· Coded and tested design enhancements to existing sales, cost of sales and perpetual inventory interface system to LAWSON financials applications.

· Converted from SYS/38 to AS/400 - Upgraded from MAPICS to MAPICS/XA.

· Project/Programming lead for multiple Application and System conversions.

· Create documentation for and train personnel in AS/400 computer operations.

· Design, Code, Test and Implement Custom applications:

· Application to Application interfaces

· Network to AS/400 communications

· AS/400 to AS/400 communications

· Custom Reporting

· Remote AS/400 access

Environment: AS/400, RPG III, RPG/400, RPG-ILE, CL, CLLE, COBOL, MAPICS, BPCS, INSURANCE

EDUCATION:

Electronic Computer Programming Institute, Certificate

Contact this candidate