Professional Experience:

Sept. 2010 To April 2011 Confidential

Update cost accounting system of a tool manufacturer using RPG IV subfiles and embedded SQL. Created month end reports for the work in progress system using print files. Updated the month end accounting process to SQL statements for speed and accuracy. RPG IV, CLLE, SQL, Subfiles, prnt files, RDA, SDA, SEU, DBU.

March 2007 To Sept. 2009 Confidential
1500 Liberty Ridge Drive, Suite 100
Wayne, Pa. 19087

Senior Programmer Analyst
Convert the I Series DB2 database to I Series SQL database. Converted physical files to SQL tables, converted the old physical files to logical files retaining the old physical file name avoiding the necessity of recompiling the legacy programs. Tested the systems affected by the change in database and where necessary modified the RPGIV, RPG Free and CL programs to function with the new SQL schema. Modified the old logical file to access the new tables. Coded triggers, stored procedures, views, functions, tables and other database oriented items as needed. Performance tuning using the I Series Navigator SQL performance monitor system. Maintained and modified the data file transfer from outside sources and data transfers for Cognos using I Series SQL. Created automated programs in RPG using Townsend/Alliance software product to encrypt and FTP data to various business partners. Created the SQL server 2005 database for the Pyxis Blackberry mobile software package. Designed and coded application for smart phone’s usingthe Pyxis Mobile application platform. These applications were used by our 200 + outside sales associates. RPGIV, RPG Free, CL, embedded SQL in RPG/ILE, DSPF, PRTF, Hawkeye, Aldon, DBU, RDA, SQL, Navigator, Navigator SQL performance tool, schema’s, scripts, tables, views, triggers, aliases, indexes, joins, stored procedures, functions, and constraints.

October 2000 March 2007 Confidential
180 Rittenhouse Circle
Bristol, Pa 19007

JD Edwards Senior Programmer Analyst
Perform the technical analysis, design, program construction, testing, implementation, and all phases of systems development and maintenance related to the JD Edwards financial package.
Responsible for all technical activities from development to the installation of customized module, reports and program adaptation to the JDE system. Performed JDE system upgrades when new releases were announced. Created conversion programs to modify data when companies were acquired. Modified the JDE RPG programs from DB2 to I Series SQL to accommodate the concurrent use with the JDE ERP system. Created the necessary conversion programs to facilitate the conversion of the JDE financial package to SAP. Designed the JDE interface with the ACS software to allow purchase order matching with the JDE accounts payable system. Participate in work sessions with the business community in an effort to establish the scope of a project request. Responsible for creating project plans including the establishment and estimation of development tasks. Provide management with project time analysis and updates on project progress. Use Test Director to track system defects and that program modification are in compliance with Sarbane-Oxley. Promote objects through the Aldon change management software. The specific areas of support are GL, AP, AR, fixed assets, data feeds, system upgrades, and purchasing. SVR, Dream Writers, processing options, vocabulary overrides, UDC, Menus, HS, data dictionary, 1099s, sleeper, embedded SQL in RPG/ILE, DSPF, subfiles, PRTF, message subfiles, CL, SQL, RDA, DBU, Hawkeye, FASTR, and UDC tables. Aldon change management administrator.

May 1999 To Sept. 2000 Confidential
437 Pennsylvania Ave.
Fort Washington, Pa. 19034

Senior Programmer Analyst
Support all aspects of a food distribution software package. This includes accounting, sales, distribution, purchasing, forecasting, and personnel. Monitor customer’s software performance using multiple operating environments. Tested the feasibility of JAVA as an alternative development environment.

May 1997 To April 1999 Confidential
055 Westlakes Dr.
Berwyn, Pa. 19312

Senior Programmer Analyst
Designed, programmed, and implemented the AS400 environment for the corporate credit evaluation system. This system employed the use of a middleware product called MQ Series. The MQ Series allowed the AS400 and the RS6000 to interact via messages that were converted by the communication product. Designed a temporary test system on the RS6000 to allow the initial installation test of the MQ Series product. All AS400 programs were written in RPG ILE with the exception of the receiving trigger monitor on the AS400 system for parallel testing with the production AS400. Retrofitted the current order entry process to accept the new credit software. Analyzed and redesigned antiquated processes with the intent of future new development. Technical member of the change control committee reviewing the designs of the programming staff.

Sept. 1990 To May 1997 Confidential
Whiteland Business Park
812 Springdale Dr.
Exton, Pa. 19341

Senior Programmer Analyst
Performed the analysis and design of the monthly and weekly sales reporting system that created reports for both in house and sales force uses. The system also downloads the information to the network server enabling users to import the information into lotus, Excel or Paradox. Designed and coded sales persons’ compensation package and the system for periodic realignment of their territories. Created batch and interactive skeleton programs for the development teams using embedded SQL in the RPG programs. The interactive skeleton was designed using both field and screen sensitive help windows using the OS/400 U. I.M. to design panel and dialogs for the applications. Managed the project development teams that designed and coded the AS400 interfaces for both the Lucas Bear inventory/demand management system, this system feeds the stock level projections to the DATA 3 manufacturing software, and the Electronic Territory Management System (Dendrite Territory Management Software), both projects were completed before their scheduled delivery date. Member of the analysis and installation team for the JD Edwards accounting software. Designed and coded the sales interface with the JD Edwards accounting system. Evaluation, testing and validation of software products, to purchase for both the AS400 and PC use. Use of format data as an alternative to query sorts and query manager as an alternative to an RPG program. Member of the team involved with the database designed and software selection for the client server applications using an IBM AS400 30S-client server. Trained users and designed client server applications with the Cognos Powerplay products of Reporter, Explorer, and Impromptu. Designed a PC based weekly sales forecasting system using Access and Visual Basic as the user interface. Designed a sales territory realignment reporting system using interactive CL programs with OS/400 U.I.M. throughout all the screens and used the IBM Query Manager to create dynamic SQL queries and reports. Created the new interactive skeleton program in RPG IV. This skeleton program employs the new AS400 Integrated Language Environment using embedded SQL, dynamic and static binding, modules, service programs, binding directories, field and screen sensitive help, and pointers to process list. Created new sales allocation system using both ILE/RPG and ILE/C called procedures and functions. Member of the OOA team using Shlaer/Mellor Notation for the design and modeling of the sales and marketing system. The tools used for the analysis were Meta Design and Easy Case.

Educational Background:

Bachelor of Arts Degree, Computer Science and Accounting

Received training in C++, Access, Visual Basic, Power Builder, Pascal Modula 2, Fortran, PL 1, Cobol, Basic, CICS/VS, OOM, OOA, JAVA, systems database design , Oracle SQL, PL/SQL.