Business Analyst III

Resume of Don Waterfield

Objective: Senior programmer/analyst

Skills:

* I am a team player with the ability to follow through on assignments and meet deadlines.

* I have demonstrated ability to envision alternative solutions to tried and true formulae.

* I have successfully installed Windows NT, Linux, SQL Server, Apache, and peer-to peer networks complete with all cabling.

* I have written programs in RPG II, RPG III, RPG IV, CL, Printer files, QUERY/400, COBOL, PL/1, VB4, VB5, VB6, C, C++, MSSQL, VBA, Access 97, Access 2000 and Access 2005, ASP, VB/ASP.Net, C#, Crystal Reports and sub reports, PHP, MYSQL, Perl, COM, DCOM, TSQL, HTML, DHTML, XML procedures and data, SQL Procedures and Functions, VBScript, JavaScript, CSS and more.

* I have proven capabilities as a software developer on OS/400, Windows, Motorola handheld scanners, and the WWW platforms as well as WWW Web services for support of Internet and Application programs.

* I have authored software for the Agriculture, Telecommunications, Manufacturing, Retail, Railroad, Mortgage, Distribution, Healthcare, Payroll, Accounts Receivable, Online Services, Insurance, Financial, and Fulfillment industries.

* I have practiced project proposals, flow charts, software development life cycle (SDLC), from business analysis, requirements definition, UML generation, and documentation, use cases; to unit testing, acceptance testing, deployment and maintenance as needed.

* I have created Web graphics and icons, website design and Search Engine Optimization (SEO) as needed.

Experience:

Business Analyst III

CPS-Cloverdale

218 Simmons Drive

Cloverdale, Virginia 24077-3129

Dec 2012 - Present

Hired by: Mr. Joe Hoffman in Dec 2004 for Aqumix, Inc.

* The company Agrium, Inc. purchased Aqumix, Inc. in December 2012.

* I am solely responsible for maintenance and/or new product developments needed to keep all facets of the company software going.

* Basic coding involves VB.Net, ASP.Net, C#, Classic ASP, Crystal Reports, XML, SQL Server procedures and functions, Motorola handheld scanner programs internal and external, Web services, SQL procedures, SQL jobs,

* Re-wrote internal and external Motorola scanner applications so they worked currently as well as incorporated changes management wanted in the programs, and upgraded projects internally, both given estimates of over 2 million dollars by outside consulting firms with no cap. This I did myself with help of my manager to debug problems.

* Replacements of COM object in an internal company project involving duplication of XML data.

* System created for email management and global sending.

* System created for fax management and global sending on schedule if requested.

* Complete online sales system created for a company now defunct which included new and used products with search capability.

* Troubleshooting and investigation as needed when problems arise. I reported directly to manager about the cause of any problems that may arise along with immediate solutions.

Senior Programmer Analyst

Aqumix, Inc.

218 Simmons Drive

Cloverdale, Virginia 24077-3129

Dec 2004 - Dec 2012

Hired by: Mr. Joe Hoffman

* I am responsible for new project development, modifications as needed and keeping mission critical components up and running on . Basic coding involves VB.Net, ASP.Net, C#, Classic ASP, Crystal Reports, SQL Server procedures and functions.

* Developed a secure free-standing report web server utilizing Crystal Reports and Adobe PDF documents.

* Wrote a secure email system where contact company lists can be maintained and emailed by category, company, or singly within 'campaigns'.

* Wrote procedures to synchronize database tables between old and new data with embedded email capabilities.

* Wrote a web interfaced secure fax generation system which runs in background and emails user when process is complete.

* Added client defined dynamic 'grouping' to web based historical order review. The client can define their own groups of sub-companies, n-levels deep and view the resulting data on demand.

* Wrote tools to clone, delete, or change a company or user within any company system wide.

* Added the ability for an in-house system user to login as any system user, thereby seeing whatever the outside user sees.

* Updated the in-house menu-ing system.

* Re-wrote the company order system converting it from traditional asp to vb.Net.

* and much more.

Contractor Programmer Analyst

Keane, Inc.,

5115 Bernard Avenue Suite 302

Roanoke, Virginia 24018-4367

Apr 2005 - Dec 2005

Hired by: Mrs. Rephia Mitchell

* I was responsible for conversion of existing AS/400 program services web based services. Basic coding involves RPG III and IV, CL, CL procedures, VB.Net, ASP.Net, Classic ASP, SQL Server procedures. I have helped out screening new hires for Keane in Roanoke for a short time.

* Assisted in interviewing new hires for programming contracts in Roanoke.

Senior Programmer Analyst

Apexalon, LLC

8413 Laurel Fair Cir Ste 100

Tampa, Florida 33610-7394

Apr 2003 - Present

Hired by: Mr. Keith Witt

* I am responsible for new project development and modifications or fixes to existing systems as needed. Basic coding involves RPG IV with ILE.

* I have coded several new programs to accomplish multiple tasks on the AS/400 such as email and reporting.

* Wrote a complete railcar management system to track and keep in repair railcars across the country.

* I have performed numerous modifications to existing software as bugs or modifications arise.

Senior Programmer Analyst

Valtim, Inc.

1095 Venture Drive

Forest, Virginia 24551-2247

Apr 2001 - Feb 2003

Hired by: Mr. Tim Hamilton

* I was responsible for new project development and modifications or fixes to existing systems as needed. Basic coding involves RPG IV and ASNA Visual RPG, Visual Basic 6, COM, DCOM, ASP, VBScript, JavaScript, VBA, Access 97 and 2000, TSQL, and SQL Server procedures on Windows 2000 platform.

* I have maintained several legacy systems through bug control and modifications.

* I have performed numerous import and export of data on SQL Server, Access, and ASNA Visual RPG.

* I wrote a security layer for web users interfacing Visual RPG DLLs, and an AS/400 with an SQL database. This layer draws the graphic tabs on screen according to that specific users security level and company. All aspects of the forms, tabs, menus, and labels were totally dynamic based upon the client and users security setting.

* I have written several demo programs in different platforms for management, illustrating effective migration of data from AS/400 to the PC environment. These projects involved use of VB with COM, DCOM through ASP and SQL Server as well as ActiveX Document Objects and ActiveX Executables.

* I have done all maintenance of for the 2001. I also set up the initial write to the AS/400 for new signups on that site.

* I have written a small VB program to check status of credit card transactions on the AS/400 for customer service representatives.

* I have written a department level interface to the Rita credit card Software. This program allows each department to make charges, and balance their accounts. This program has security embedded within that allows users to charge, department heads to balance, and the designated operator to settle charges for an account.

* I have written a polling agent, which takes live data on the AS/400 and updates an SQL database. The Polling Agent is a VB tray application, which runs on a secure server and calls out to a multiple COM DLLs. This application sends an email to its programmer if it gets shut down, and sends program messages to the appropriate 400 user for specific error messages as well.

* I wrote a complete data sync process to synchronize data between Valtim and its customers on the AS/400.

* I have interfaced with the AS/400 in its secure eCustomer pages. Also, set up the initial user defined SQL search page from ASP to extract AS/400 records there. This project interfaces with the Best Software package.

Programmer Analyst

Comtech Associates

2234 W. Beverly Street

Staunton, Virginia 24401-2903

Mar 1998 - 2010 as needed

Hired by: Mr. Sam Robb

* Basic coding involves RPG II, III and IV ILE, C++, Visual Basic 5 and 6, ASP, and VBA, VBScript, JavaScript, VBA, Access 97 and 2000.

* Worked Y2K on two major projects, (one with 2100 members).

* Wrote several reporting packages in RPG in RLU.

* Produced and maintained the company web sites.

* I have added order entry application to an existing application allowing the client to input order information on AS/400.

* I have added Canadian tax code input to an existing application complete with reporting on AS/400.

* Flowcharted the entire contents of an AS/400 including system background processes and all programs.

* I have added consignment requisition handling to an existing application on AS/400 with date validation against existing tables.

* I have extended an existing application to include input for 10 shipping codes that drilled down 6 data table levels on AS/400.

* I wrote a tariff application to produce tariffs used in shipping across the three NAFTA nations. This package to be sold commercially through Comtech. Microsoft Access and VB used.

* I wrote an application for serial import of raw data from a Brandt Coin Counting machine. The application schedules coin changers maintenance Dates and has full reporting. This package is currently being sold commercially through Comtech. Microsoft Access and VB used.

* PI re-wrote and maintained a Returned Material Entry application, which communicates its level of progress intra-departmentally according to user intervention.

* Debugged and maintain cluster of 17 connected databases in a company environment. These databases share data by import/export to each other and all tie to a master db, which downloads data from an AS/400. This is a rolling database for salesmen forecasting. Microsoft Access and VB used.

* I have debugged and maintained a full MRP system in Access and VB.

* Performed all modifications and additions to the Spero Integrated Flight Management System being sold commercially today. Spero is written entirely in C++.

Programmer

HCMF

2965 Colonnade Drive

Roanoke, Virginia 24018-3557

Jun 1996 - Mar 1998

Hired by: Mr. Boyd Hale

* I have maintained legacy code while writing new applications as needed. Basic coding involved RPG III, GeneXus Visual RPG, Visual Basic 4, Access 97.

* I wrote 401-K Management System complete with worksheets and administrative security. This application was written in Visual Basic and interfaced with an Access database.

* I wrote Accounts Payable for HCMF.

* I wrote half the payroll system including re-creation of a software clock, which tracks employee time down to the minute within each payroll period correcting unlimited overtime calculations for health care workers.

* I encrypted five levels of security into the payroll system.

* Created invisible records called footprints, tracking all transactions by a workstation, time, screen, and transaction type. This system even tracks attempts at evading security without the offenders knowledge.

* I wrote a numeric to English text translation for check writing and complete check writing package including summaries in GenXus Visual RPG.

* I wrote an import tool to take data from a commercial Visual Fox Pro 3.0 package to Visual Basic 4 application for employee data from 27 companies.

* I performed several software installations across the state for a new network installation.

* I performed all backups and installed PTFs on the AS/400.

* I automated import/export of existing 401-k data from AS/400 to Access.

* I recreated 26 Medicare reports with RLU for in-house generation. This allowed them to be generated in house rather than be purchased.

* I performed several program migrations to GeneXus Visual RPG from RPG/400. I wrote additional DLLs in VB to supplement GeneXus lack of functions.

Education:

* BS Computer Science

Kennedy-Western University of Thousand Oaks, California

Jun 1998 - Oct 2000

* Thesis: Intelligent Exception Handling in C++

* Relevant Coursework: Data Structures and Algorithms, Fundamentals of Database Design, Software Development and Technical Mathematics.

Technical Courses:

* Geometry, Accounting I, Accounting II, COBOL I, COBOL II, Visual Basic, English Composition

Virginia Western Community College, Roanoke, Virginia

21 CE Credits, Aug 1995 - May 1997

* Programming in RPG/400

HCMF through Midrange Computing, Roanoke, Virginia

8 CE Credits, Jun 1996 - Jul 1996

* CL Programming for the AS/400

HCMF through Midrange Computing, Roanoke, Virginia

8 CE Credits, Jun 1996 - Jul 1996

Memberships:

* The Software Contractor's Guild (SCG)

* The Association of Shareware Professionals (ASP)

* Christian Webmasters Association (CWEB)

* Organization of Independent Software Vendors (OISV)

* Software Industry Professionals (SIP)

Extra Activities (current):

* Technical Webmaster, The Association of Shareware Professionals (ASP)

* Technical Webmaster, The Roanoke Star-Sentinel Newspaper, Roanoke, Virginia

* Crossword Editor, The Roanoke Star-Sentinel Newspaper, Roanoke, Virginia

* Expert in Computer Science, The Round Table Group

Extra Activities (past):

* Mentor,

* DMOZ Editor for Computers/Artificial_Intelligence/Machine_Learning/Software

* ESL Tutor, Department of Refugee and Immigration, Catholic Diocese of Richmond

* Support Desk, TroopSoup Magazine (12 resellers, 219 websites, Linux on Apache servers)

* Distributed Proofreader, Project Gutenberg

* Technical Webmaster, Roanoke Avenue Baptist Church, Roanoke, Virginia

References:

Mr. Boyd Hale 540-***-****

Mr. Sam Robb 540-***-****

Mr. Tim Hamilton 434-***-****

Mr. Keith Witt 800-***-**** x213

Mrs. Rephia Mitchell 540-***-****

Additional personal references are available upon request.

Thank you very much for your time and attention.

Don Waterfield

February 26th, 2016

* * * * *

Contact this candidate