ALI ERSU

SOFTWARE DEVELOPER

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 PROFICIENCIES

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, SoapUI

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

OS/Platforms: IBM iSeries (AS/400), MS Windows

PROFESSIONAL EXPERIENCE

Staples, Framingham, MA (01/22 – 08/23)

IBM iSeries (AS/400) Programmer Analyst- Contract

Analyzed client’s E3 Advanced Replenishment software and documented applications of E3 interact with WMS as part of ‘Migrate JDA E3 (Blue Yonder) to a new vendor’ project. It involved using APLUS and/or X-Analysis as well as writing SQL Scripts to identify relationship for E3 files and E3 programs interacting with Warehouse Management System.

Sally Beauty, Dallas, TX (09/21 – 12/21)

IBM iSeries (AS/400) Programmer Analyst- Contract

Joined a team of IBM consultants to work on the object de-scoping project as part of ‘Modernization Readiness at Sally Beauty’. The project involved writing library-level and object-level cleanup RPG ILE Programs and/or SQL Scripts for unused objects from the application system, uploading user provided spreadsheet data into IBM iSeries, testing scripts in simulation mode to validate that the appropriate objects are handled and run on the production LPAR to make the required changes.

Medtronic, Mansfield, MA (10/18 – 01/20)

IBM iSeries (AS/400) Programmer Analyst- Contract

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.

Connection, Merrimack, NH (10/15 – 09/18)

IBM iSeries (AS/400) Sr ERP Applications Developer- Fulltime

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.

Staples, Framingham, MA (04/15 – 09/15)

IBM iSeries (AS/400) Programmer Analyst- Contract

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

YBP Library Services, Contoocook, NH (02/14 – 07/14)

IBM iSeries (AS/400) Programmer Analyst- Contract

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.

Covidien, Mansfield, MA (01/07 – 06/13)

IBM iSeries (AS/400) Programmer Analyst- Contract

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.

MS Access Developer- Contract

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.

Standish Mellon, Boston, MA (12/05 – 11/06)

IBM iSeries (AS/400) Senior Programmer Analyst- Fulltime

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.

Staples, Framingham, MA (12/03 – 11/05)

IBM iSeries (AS/400) Programmer Analyst- Contract

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.

American Carpet South, Passaic, NJ (04/03 – 11/03)

Programmer Analyst- Contract

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.

Fidelity Investments, Boston, MA (12/99 – 03/03)

IBM iSeries (AS/400) Programmer Analyst- Contract

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.

Access Information Systems, Minneapolis, MN (04/99 – 11/99)

Delphi Software Developer- Contract

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.

Fidelity Investments, Boston, MA (07/98 – 03/99)

IBM AS/400 Programmer Analyst- Contract

Analyzed and modified RPG IV (ILE) based applications to maintain and enhance FMR Co Reference Data systems.

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.

Keane Inc., Rochester, MN (07/96 – 06/98)

IBM AS/400 Database Support Specialist at IBM Rochester, MN- Fulltime

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.

EDUCATION

School of Advanced Vocational Studies, Computer Programming - Bogazici University, Istanbul, Turkey.

COURSEWORK

X-Analysis Advisor Training, Boston, MA

JD Edwards EnterpriseOne (9.2) Basic Developer, Merrimack, NH

Developing ASP.NET MVC 4 Web Applications, Nashua, NH

Introduction to Web Development with Visual Studio 2010, Nashua, NH

Programming in C#, Nashua, NH

Programming in HTML5 with JavaScript and CSS3, Nashua, NH

Understanding the Securities Industry, Boston, MA

Moving from RPG/400 to RPG IV, Rochester, MN

DB2 for AS/400 SQL Programming Workshop, Rochester, MN

REFERENCES

Available upon request.

Contact this candidate