SUMMARY

• Highly skilled and experienced Software Developer with solid experience in designing and creating cutting edge business applications. Well versed in programming languages providing hands - on technical programming expertise involving all stages of systems development life-cycles (SDLC) methodology. Successful history of maintaining enterprise-wide software, implementing modules, and a proven track record in problem solving with strong attention to detail.
• Highly proficient communicator effective at managing relationships between users and development team for on-time project delivery.

TECHNICAL SKILLS

Primary Skills: RPG IV/Free-Format, RPG ILE, COBOL, DB2/400, Sub files, CLP/CLLE, SQL/400 & Embedded SQL, SQL Stored Procedures, Database Triggers

Secondary Skills: MS ACCESS, SOAP Web Services

Applications/Tools: JD Edwards World, Rational Developer for i (RDi), IBM i Access Client Solutions (ACS), System i Navigator, SEU, SDA, RLU, DBU, Query/400, OPNQRYF, FTP, IFS, SoapUI, HAWKEYE, ALDON, IMPLEMENTER

OS/Platforms: IBM AS/400, MS Windows

PROFESSIONAL EXPERIENCE

Confidential, Mansfield, MA

AS 400 Programmer Analyst

Responsibilities:

• I was part of a team of consultants to implement major changes intended for migration of in-house AS/400 Partner Applications from JDE E1 to SAP ERP software .
• The tasks and duties involved were to modify existing RPG ILE programs with Embedded SQL, SQL tables, indexes and views within the said AS/400 applications and generating SQL Scripts for data conversion.

Confidential, Merrimack, NH

AS 400 Sr ERP Applications Developer

Responsibilities:

• Analyzed, designed and developed Free-Format RPG ILE programs, modules, procedures, service programs and SOAP Web Services to meet user requirements for various JD Edwards World in-house programs such as Freight Calculator, Inventory Reporting, Ship Notification, Pick Slip Labels, Data downloads/uploads from/to spreadsheets.

Confidential, Framingham, MA

AS 400 Programmer Analyst

Responsibilities:

• Developed Warranty modules for in-house Order Entry system using Free-Format RPG ILE procedures, service programs, and binding directories.

Confidential, Contoocook, NH

AS 400 Programmer Analyst

Responsibilities:

• Developed programs/modules for various in-house DMS Applications within an Agile/Scrum environment using advanced coding techniques such as Free-Format RPG ILE procedures, embedded SQL, service programs, service programs and binding directories.

Confidential, Mansfield, MA

AS/400 Programmer Analyst

Responsibilities:

• Served as a team member to modify existing RPG ILE programs within the in-house AS/400 Partner Applications in order to implement major changes intended for JD Edwards Enterprise One (E1) process.
• Modified existing MS Access 2007 databases to map the AS/400 linked tables to JD Edwards Enterprise One (E1) tables, along with designing new desktop applications in the areas of data collection and presentation using SQL queries and stored procedures.

Confidential, Boston, MA

AS 400 Senior Programmer Analyst

Responsibilities:

• Provided internal technical support and customized reports for use with Trade Notification Fax, Stale Price Reporting, and BondEdge Data Extract software using RPG ILE and SQL tools.

Confidential, Framingham, MA

AS/400 Programmer Analyst

Responsibilities:

• Implemented various changes intended for coupons, discounts, easy rebates and other sales promotions for in-house Pricing module and Easy Rebate module, using RPG ILE, and SQL queries .
• Analyzed and modified Manhattan Associates’ RPG IV (ILE) based PKMS Warehouse Management System in order to upgrade from V0R1 to V4R1.
• Developed RPG IV (ILE) based modules to make system changes to the back end systems to send redeemed coupons as a negative sale to Merchandise Division.

Confidential, Passaic, NJ

Programmer Analyst

Responsibilities:

• Analyzed and modified ACS Flooring System to integrate laminate and hardwood flooring into the existing carpet flooring application.
• Duties involved coding, testing and implementing programs using BABY/36 PC based RPG II development tool running under Windows NT.

Confidential, Boston, MA

AS/400 Programmer Analyst- Contract

Responsibilities:

• Increased productivity by designing RPG IV (ILE) based Vendor Data Feed and Index Constituents applications on the AS/400 for Common Data/ Data Resource Management. Trained, mentored, and motivated other team members in the use of embedded SQL and stored procedures.
• Implemented Fund Monitoring and Regulatory Reporting applications for Compliance systems using embedded SQL and ILE procedures. Devised adhoc SQL reports & data extracts, creating MS-Excel downloads for production support.

Confidential, Minneapolis, MN

Delphi Software Developer

Responsibilities:

• Assisted in migrating from Novell Database Server to AS/400 Database Server.
• Duties varied from round-the-clock AS/400 system support to converting the existing DOS Paradox based Order Entry application to Y2K compliant Delphi based application on the AS/400.

Confidential, Boston, MA

AS 400 Programmer Analyst

Responsibilities:

• Analyzed and modified RPG IV (ILE) based applications to maintain and enhance Duties involved coding ILE modules to re-engineer old OPM programs, production of adhoc SQL reports & data extracts, testing and implementing software modules, and production support for the AS/400 Common Data environment.

Confidential, Rochester, MN

AS 400 Database Support Specialist

Responsibilities:

• Determined and solved AS/400 database problems reported by worldwide IBM users.
• Hands-on technical expertise included: RPG/400, COBOL/400, CL/400, DB2/400, Query/400, OPNQRYF, SQL/400, Query Manager, Referential Constraints, Triggers, Journaling and Commitment Control, Optimizing Access Paths, DDM, Save and Restore Basics.

Confidential

Systems Support Analyst

Responsibilities:

• As a Senior Programmer in Applications Engineering group, I was involved mainly in developing RPG III and RPG/400 programs for MACPAC (Manufacturing software, written in RPG III to run on System/38 and later on AS/400) and daily Systems Support of MACPAC modules from fixing code defects to usage problems.
• Worked on Lease and Hire Purchase Portfolio Administration and Control software (written in COBOL to run on AS/400) coding, testing and implementing COBOL programs and provided support to assist in the resolution of logged production issues with the Service Center Help Desk.

Confidential

Systems and Programming Consultant

Responsibilities:

• Worked with the Customer Support Team at a number of client sites installing STACS (System 36 Accounting System), writing bespoke code and modifying programs on System/36.
• Also provided assistance to the clients on issues regarding daily operations

Confidential

Application Programmer

Responsibilities:

• Amended existing business System 36 modules such as Order Processing and Invoicing, Stock Management and Purchasing; wrote bespoke code and tested systems.
• Trained the junior staff on RPG II and System 36.