Scott McGrath An experienced programmer and network administrator with over 20 years of application development expertise. A motivated self-starter with diverse skills ranging from web development to marketing and sales. A skilled instructor in Web Development. Languages & Software: RPG/IV(ILE), CL, Query400, SDA, RLU, SEU, PDM, HTML, Java 2, Java Script, VbScript, ASP, JQuery, Flash 5.0, Flash MX, Adobe Photoshop, MS Excel, MS Word, MS Power Point, MS Access, Symtrax Compleo/Mapform, MS Small Business Server Administration, Avaya IP Office, SQL Server 2005, Symtrax Compleo and Mapform, php, mySQL Hardware/Operating Systems: AS/400, Windows 98, Windows XP, Windows NT, Microsoft Server 2003,Windows Vista, Unix, DOS Business Applications Order Processing, Billing, Purchasing, Inventory Control, A/R, A/P, Human Resources, Payroll, Marketing, Sales Analysis, Invoicing, Order Entry, Data Management, Pricing, Financial Forecasting, Marketing. Website References www.myshoeconnection.com, www.beavercontracting.com, www.grannycop.com WORK HISTORY My Shoe Connection, LLC 10/11 - Present Maintain website using ASP, JQuery, HTML, CSS with a mySql database. Upload product images and data pertaining to those products. Maintain facebook and twitter interaction. Created product upload for google merchant center. Created programs to create inventory uploads to amazon and sears. Designed this website from the ground and continue to make changes as necessary. Communicate with customers and maintain professional and courteous attitude. Created a content management system which includes inventory management and sales analysis. Created order management system to maintain unshipped and unconfirmed orders while also maintaining unpaid orders. This system also includes the ability to upload shipping information to sears through the use of XML, ajax, jquery and classic asp. Most recent change to this site was converting this site to use media queries in the CSS and present the site differently based on screen size of the visitor making it mobile friendly. Compass Health Care 10/11 - 9/13 Worked as a part time consultant remotely with occasional visits to the office. Helped create websites using php, mysql, html, css and jquery. Created forms using html and css with jquery validation. Created email templates using html. Some of the sites I worked on several sites including http://www.non-24.com/, http://www.carbaglu.net/, http://www.4ventavis.com/ I was given edits and modifications in either a spreadsheet or text and was required to give an estimate of time. I was always on time or earlier than the deadline. Modis 4/11 - 10/11 Hourly consultant Created web pages using RPGLE on an IBM I-Series which included css and javascript. Created and modified jquery scripts to create effects such as sliding content and form validation. Also used php and asp to create templates as well as css and html. Modified some programs that were using ajax and jquery to load web pages from a SQLServer database. Created tables in MySQL and created web forms which wrote to those tables using php, sql, and jquery. Independent Web Developer 6/09 - 4/11 Created and designed websites for My Shoe Connection and My Dress Connection using classic asp, CSS, photoshop, HTML, XML, and javascript with access and mySQL databases. Created mirror sites for AAFES which required adhering to AAFES standards and creating an XML shopping cart which is transferred to AAFES using HTTP requests. Also receive HTTP XML requests to receive order detail and purchase order acknowledgements. Created a custom CMS portal to maintain product, inventory, customer orders, etc. Maintain website with constantly changing inventory and product. Add new features and social networking aspects as they become popular or available. Maintain blogs for fashion trends and celebrity fashions used to promote product on both company websites. Maintain facebook fan pages and twitter account used to promote websites. Manage incoming orders, confirm orders with manufacturers as well as customers. Follow up with customers and vendors to make sure shipments are going out according to schedule. Created and maintain several other sites referenced above. Mon Cheri Bridals, LLC IT Manager AS/400 Application Programming 11/06 - 6/09 Created several programs in RPGLe and CL which integrated an online order process into the current system. Generated several ad-hoc reports using QRY400. Web Development - Redesigned the retailer portal to add several ways to market additional products to visitors. Added an online order entry feature to ease the burden on the phone system and allow customers more access to inventory. Created ability to send mass email marketing campaigns as well as ways to save prospects and leads and gather information about these prospects. I created several web applications to improve communication between sales reps, internal employees, retail customers and consumers. Created an SEO and SEM plan along with the marketing department. Languages used were asp, html, javascript, xml and flash. Also used photoshop CS4 for image and template creation. Network Administration - responsibilities included network administration for Microsoft Small Business Network 2003, antivirus, security and maintenance on both the client desktops as well as the server. Created new applications to reduce cost of preprinted forms by creating custom forms and printing as needed using Compleo. I was also responsible for the VOIP system (Avaya), adding new phones, moving extensions and maintaining the external directory. I modified our phone system to include promotional messages in our greeting as well as when a customer is waiting to speak to a customer service representative. CBA Information Solutions 08/05 - 11/06 - Programmer/Analyst AS/400, Web Developer Developed and modified applications for the AS/400 using RPGILE and CL. Created RPGLE programs which interacted with the user using a web interface such as Internet Explorer. Created programs which created XML documents as well as email documents with embedded HTML. Using HTML and java script on the client side and RPGLE on the server side, I created applications that allowed a user to view, update and add records to existing AS/400 files. I created several applications which fed an excel spreadsheet to the AS/400 as a tab-delimited file and parsed that file into usable data on the AS/400. Created an application which read through an excel spreadsheet and used the data on that spreadsheet to search through our customer database for possible matches. Modified existing AS/400 applications including display files, subfiles, CL programs and RPGLE programs. Corsemax Inc 07/04 - 02/05 - Programmer/Analyst AS/400, Web Developer Developed and modified applications for the AS/400 using RPGILE and CL. Created several maintenance programs for existing files as well creating new files and programs to maintain them. Created programs using CL to gain knowledge of system information used in a total system migration. Individually responsible for migrating data from an AS/400 in Mexico to an AS/400 in the U.S. I also created several reports using MS Access with samples provided by the client in Mexico. These reports used data from the AS/400 and were the data was accessed using an ODBC connection as well as VBA to control and manipulate the SQL used to generate the reports. L&N Sales and Marketing 10/00 - 05/04 - Programmer/Analyst AS/400, Web Developer Developed applications for the AS/400 using RPGILE and CL. Modified existing applications that are part of APPCON’s software package. This included adding and modifiying display files or adding additional functionality to the existing applications. Developed several applications on the intranet to be used by the Sales and Accounting departments which will enable them to track credits taken and allowed as well as sales analysis tools. These applications are written using HTML, ASP, VbScript, and JavaScript. It includes multiple pages and connections to a SQL database with write, update, and edit of records in the tables. Designed the database to be used by these application. Amerisource 4/00 - 10/00- Programmer/Analyst AS/400 Developed and designed as well as installed new system to create outgoing 852 (Product Activity Data) documents. This system gave the user more control and allowed easier access to adding and deleting vendors from the system. Developed, designed and installed incoming 810 (Invoice) system that allowed the user to print, display, and edit invoices interactively. Created new system for outgoing 810 (Invoices) where the user could easily add new vendors to the system as well run invoices by vendor or invoice date. Added new fields to various user files used in EDI maps and added logic to programs to populate these fields. Created new utility for the IT department that would allow us to send spooled files onto the PC via client access by entering a command on the AS/400. Created system to transfer and translate text files from the PC to the AS/400 using client access. RCG Information Technology Inc. 8/99 to 4/00 - Programmer/Analyst AS/400 (Independent Consultant) De Lage Landen Vendor Maintenance Initiative - My role in this project was to create applications as well as modify existing applications. I modified the existing Vendor Inquiry application to expand the search criteria by adding additional fields to the initial prompt screen and adding a toggle view of information. I added fields to the Vendor Maintenance Application by using fields in files that were previously unused. I expanded a field size in one of the Vendor Files that affected many of the Vendor Applications. The current vendor review system scored vendors based on their payment history and other variables. The users did not understand the scoring system. I had to document how these tests were performed as well as understand how and when these tests were performed. I modified the Vendor Review Inquiry application to give a more specific and detailed view of the test results. I converted the program to ILE RPG. I rewrote the testing application using ILE RPG and gave the user an interface to allow the user to specify which tests to run and when to run them as well as specify which vendors and the type of output(printed or queued). Lines of Business - The system did not have the ability to report on receivables by something called a "Line of Business". 11 A/R programs had to be modified to write to a file whenever a record was written to a summary file. The new file contained lease and account level information which could be used to link back to the line of business and thus report by the line of business. There were some programs which already wrote to the detail file. I had to verify that these programs were writing records for each GL account in the detail whenever a records was written to A/R file. I had to create a subroutine which would be generic enough to be used in all remaining programs whenever a write to the A/R file occurred. I/S Computer Services 9/97 to 8/99 - Independent Contractor (Programmer, Analyst AS/400, Web Developer) Crown, Cork, and Seal Using ILE RPG and CL I modified the pallet ticket print process to change a lot identifier code based on certain changes in work schedule which included working with a PC based barcode labeling system.(Loftware). Made many modifications to production reports. Created a system to allow users access to records which were previously locked by the software. Modified programs that were locking users out of records. Rewrote a system that would allow users to download label formats created using Loftware on the AS/400 using Client Access. The system would integrate these format files into a database file, which would then be used by existing programs to print labels as needed. ARCO Chemical Company Designed and implemented web pages for Arco’s Electronic Commerce web site . Pages included detailed information on Arco’s EDI initiative, EDI tutorial, and an EDI Survey for prospective trading partners as well as the Trading Partner Agreement, which includes detailed map information for trading partners. I created a CGI written in ILE RPG to process information received from the survey and store that data in a database file. I created a program to analyze the records in the database file and create an HTML document displaying the statistics from the analysis using ILE RPG as the CGI and RPG IV to create the HTML document interactively. Documents I have worked with include: 810, 820, 824, 831, 850, 855, 856, 830, 997. Implemented document 838(Parent I.D.) with trading partner. Created programs to interface with current software which would extract new customers entered into the system and prepare them for transmission via EDI to the trading partner. Upon receipt of the 838 the records would be implemented into a data warehouse file. Added new trading partners as well as defined data maps and user file definitions to Premenos. Created report to scan 997's(Functional Acknowledgements) received from trading partners for errors. Created reports to check mailbox file against control files which ensures that all necessary documents are generated by their respective systems. The systems include P.O.’s, invoices, shipping plans, and advanced shipping notices. L & N Sales and Marketing 7/95 to 9/97 - Programmer/Analyst (AS/400) Designed, created, and implemented an inventory transfer system which interfaced with the current software system. Created Adhoc reports for sales analysis, inventory analysis, and productivity analysis using QUERY400, RPG, and CL. Made many modifications to applications, which were originally written on a System 36 in RPG2 and OCL. Made modifications to both physical files and system 36 files. Created an interface with T.L. Ashford Label printing software that creates bar-code labels using the current order detail file. Created programs to report various information concerning A/R and A/P to the CFO. Installed numerous PCs and P.C. software including Microsoft Office, Andrew Elite 5250 emulation software as well as installed emulation boards to PCs. Using Elite ETU, I downloaded files from P.C. to AS/400 and vise versa. Trained users on AS/400 applications as well as P.C. applications. Assisted users whenever needed. Assist M.I.S. Director in program design and overall system maintenance. Installed ETU and MSI Laboratories' Pagerlink on the AS/400. Responsible for Maintaining System security that includes adding user profiles. Set up EDI customers using Premenos. Created majority of programs for major AS/400 software conversion. Programs included inventory master file, order header and detail files, customer promotions files, and inventory costing files. Assisted in overall design and implementation of P.C. network which included installing and configuring network cards along with installing and configuring "Client Access 400" software. Performed maintenance and repairs on P.C.'s when necessary which included hardware replacements as well as software tuning. Simkar Lighting and Fixture Inc. 10/94 to 7/95 - Programmer/Analyst (AS/400) Created an interactive Sales analysis which required background programs which ran on a monthly, weekly, or daily basis, based on user parameters. The background programs would keep files used exclusively for the sales analysis program updated. The interactive program was highly subfile and window oriented including window subfiles. Converted some high level queries into RPG400 programs and using a job schedule entry, scheduled them to run automatically when needed. Created and modified both batch and interactive programs. All programs were interfaced with current software. Trained and assisted users whenever needed. ARMS Inc. 7/93 to 10/94 - Full Time Consultant 10/94 7/95 - Part time consultant Designed and created an Interactive Dispatch System for Conrail Mercury (A.K.A Conrail Direct) The system involved updating and creating records as well as deleting records from 10 files at the same time. The system used subfiles, windows, and window subfiles as well as inquiry programs. Interacted with McCormick and Associates during program design and creation. Created reports and on line inquiries as needed. Assisted in System38 to AS/400 conversion. Stayed on as part time employee after leaving for a position closer to home so that I could finish the current project. Citone Institute 5/02 - 12/02- Part Time Instructor Instructed classes ranging from 4 to 20 students in the subjects of Java and Web Development Including Flash 5.0. Developed lesson plans as well as quizzes and exams. Used overhead projector, practice exercises and lecture during lessons CHI Institute 1/01 to 1/02 - Part Time Instructor Instructed classes ranging from 4 to 20 students in the subjects of Java, Web Development, and MS Access. Developed lesson plans as well as quizzes and exams. Used overhead projector, practice exercises and lecture during lessons. CLC Technical Institute 9/00 - 1/01- Part Time Instructor Instructed classes ranging from 4 to 20 students in the subjects of Java and Web Development. Developed lesson plans as well as quizzes and exams. Used overhead projector, practice exercises and lecture during lessons. . EDUCATION Bucks County Community College Unix - Introduction to Unix Accounting, Intro. to Computer Science Vytag Advantage(A.K.A. Info Source Corp.) Java and web development. AS/400 - RPG, CL, QRY400, SQL400, SDA, RLU