Donald Smith

*** ************ **** #*** *: 502-***-****

Louisville, Kentucky, 40207 E: ad2yj8@r.postjobfree.com

PROFESSIONAL SUMMARY

Systems Analyst/Programmer with more than 40+ years of experience in the design, development and implementation of quality business solutions for Fortune 1000 Corporations. Candidate is proficient in a wide variety of technology skills, expert problem solver, and adept at learning new processes and systems.

Highlighted skills include:

Analytical Thinking

Able to work across teams on multiple tasks

Creative Thinking

Excellent troubleshooting and problem solving ability

Determined to succeed.

TECHNOLOGY SUMMARY

PHP

MySQL

Enterprise COBOL IV

CICS

Razor-SQL

Microfocus COBOL

z/OS and OS.390 JCL

JES3

IDMS/DML

DB2 SQL and DB2

VSAM

IDMS-ADS/Online (ADS)

Easytrieve Connect

Visual Basic 6 & VB.net

MQ Series

Websphere -

MS Access -

SQR Reporter

Viasoft

Expediter

Intertest

CA Librarian

Panvalet

Endevor

Peregrin Service Center

Platnum

SPUFI

MS-SQL Server

ODBC

Oracle ODBC

CA DATACOM DB

CA Service Center

-

HTML/CSSL

XML

Crystal Reports

CA Clarity / NIKU / PMIS

HL7

ORACLE SQL Developer

SQLBASE

Microsoft Visio

PowerPoint, Word, Excel

SharePoint

C#

IMS/DB/DC

IMS/DLI

C++

PROFESSIONAL EXPERIENCE

Various Part time Projects 07/2014 – Present

Developed and maintained websites for small business owners. Repaired and installed Aps on Network based PC for small business stores.

Volunteered and worked part–time as an Usher and a Security Guard for Local Area Theatres, Sporting Events and Concerts.

Worked on short Task won through FreeLancer.com doing business as Uzrfriendly Services Ltd..

NewAge Technologies as a Business Analyst for: 01/2020 to 01/2021

One Year Contract with Diesel Injection service, Jasper Engines

2410 Allmond Avenue

Louisville, KY

Maintained Web sites that do specific business function. Performed data analysis using DB2 on an AS400 for business reporting and to define requirements for Sales support. Developed specification to create applications on a web server using PHP, DB2, and MySQL as its developmental platform. Developed an Automatic Invoicing System. Developed an Inventory Counting and Tracking system. Modified a web based application to maintain a list of customers that participated in a special program, to have the ability to maintain the list through the web app.

Registered Insurance Sales Agent: 03/2014 – 12/2019

Completed Training and State required Test to Qualify for Insurance Sale Agent License in March of 2014.

Went on to represent AFLAC where I helped Companies offer AFLAC policies as an employee benefit.

SAIC/TEKSystems

US Department of Defense Division of ARMY Human Resource Command 09/2012 – 03/25/2014

Consultant – IT Specialist Mainframe Developer

Fort Knox KY.

Developed and maintained CICS and Batch Application programs using COBOL, CICS, and CA DataCom DB (an SQL like database management system) to satisfy user request for modernized and more secured information source.

Developed successful procedures from analyzing requirements documentation and transforming them into program code.

Developed a procedure to send email notifications to various departments to indicate successful or erroneous end of batch processing.

Changed and tested batch procedures that were operated by developers into independently run procedures that are operated on a CA7 schedule without any Developer intervention.

TEKSystems

Commonwealth Of Kentucky COT 4/2010 – 02/1012

Consultant – Analyst

Frankfort, KY.

Researched and solved various issues that interupted a successful days production processing cycle.

Designed the conversion of “Vehicle License Information Verification” application from a procedure that utilizes IMS/DB to retrieving the same information from web services supplied from Clearing House services.

Created Business Days date routine using a holiday schedule that was downloaded from the Federal Reserve Bank’s web site using a Javascript retrieval application to load onto a DB/2 table.

Developed procedure to capture and store unlimited motor carrier license service remarks using IMS/DBDC application platform.

Modified Motor Carrier Tax forms to reflect new regulatory standards.

Designed and developed solution to add textual comments to Accounts Receivable records.

Designed process to purge inactive License Master records that had been stagnant over a period of time.

Analyzed, and wrote the specifications to reverse engineer the current procedures and methods used to create, administer, and tax the Commonwealth’s part in the IFTA license process.

Created Documentation to execute IT Payroll Accounts Allocation procedure that was developed using the CA Clarity PMS software.

Developed validation reports, and debugged existing SQL reports and processes using ORACLE SQL Developer.

Developed a Checklist Procedure list for capturing payroll input transactions from Clarity time sheets. The procedure was developed in SharePoint using the Structured List feature.

Donald Smith Page 2

HUMANA INC., Louisville, KY 7/2007 – 4/2010

Applications Technology Consultant

Develop and validate data quality test scripts.

Create scripts to load data tables and service data.

Learned the use of C# as a programming language.

Learned the use of UML patterns to express detail level specifications.

Participated in Agile development Strategy and Scrum meetings.

Met with Users, Business analyst, and other IT professionals to develop and publish applications requirements to various business problems.

Analyzed Requirements, Use Cases, and other materials provided by the business experts to create a network of data provider classes that gathered data from all available sources for the web based User Interface inquiry page.

Developed VB.net (web) and COBOL (mainframe) programs to fit new business requirements.

Developed and Maintained Visual Basic programs (VB level 6) to keep a classic ASP Inquiry application Compliant with current business and regulatory rules.

Modified current mainframe COBOL programs to adapt a standard method to stay in synch with the EDS Metavance claims system.

Created Humana's first mainframe CICS web service program.

Mentored other associates in the creation of CICS web services.

Mentored other associates in the use of mainframe debugging and performance enhancement services.

Developed reporting application to monitor CICS failures.

Developed a standard migration path to convert programs to latest version of COBOL.

IDR INC., Atlanta, GA 1/2007 – 4/2007

Consultant in role as Programmer Analyst

Designed and developed program for a Healthcare Claims Processing agency that contracted to individual States to collect and pay their Medicare / Medicaid claims.

CIBER INC., Memphis, TN 6/2005 – 12/2006

Consultant in role as Senior Programmer Analyst 2005 – 2006

Designed, developed, tested and installed application programs in a batch environment as well as in a CICS transactional environment to aid in increasing efficient client recordkeeping by Customer Service Representatives.

Developed the use of DB2 Stored Procedure programs to access legacy CICS programs from a Web Service thus enabling a front end user interface to access various data stored in Legacy Databases.

Maintained version control of Pitney Bowse's Finalist application.

Learned and used the “ChangeMan” Change Management System, a software versioning tool, and “Peregrine Service Center” for change and service request control.

Worked with the Pitney Bowes’ Group1 software to maintain the service release installations.

Consultant in role as Quality Testing Analyst and Automation Engineer 2005

Created and executed Test Scripts to verify quality and correctness of Package tracking Application. These scripts test data as it communicated across several platforms until it was registered on the Electronic Data Warehouse.

Performed data mining and analysis to create basis for creating testing scenarios.

Created and maintained a document using dynamic SQL that compared the application database and the reporting database. The use of this document saved many hours of development time by ensuring that the information entered at the POS flowed through the system until it reached the final data repository.

Donald Smith Page 3

UZR-FRIENDLY SOFTWARE, Memphis,TN. 6/1994 –1/2007

Self employed in Consulting Services

Developed Web-Server applications using Visual Basic.net and SQL Server2003 to administer and track member and Trader activity for an investment club.

Developed workstation application in Visual Basic and Microsoft Access that interfaced with an ORACLE database to track and report on the level of service provided by a hospital’s nursing staff.

Developed a Knowledge Testing application using Visual Basic and Microsoft Access that is used by educators and companies to evaluate subject knowledge and experience level.

Partnered with On-Site Computer Repair to perform computer repair and software installation consulting.

SBS TECHNOLOGY, Dallas, TX 12/1996 – 3/2003

Consultant in role as Lead Applications Analyst

Provided support and developed enhancements on a Mainframe Training and Regulatory Compliancy Tracking System utilizing Ads/Online, COBOL, IDMS, Visual Basic and FTP.

Designed and implemented an application using COBOL, CICS, Visual Basic and Microsoft Access to extract Federal Payroll Tax information from a Client/Server Payroll Tax Processing System, interfaced with Corporate Payroll, Corporate Treasure, Financial, and Legal departments as well as transmitted information to the company’s bank and to the US Treasury Department.

Designed and implemented a Client/Server application written in Visual Basic and Microsoft Access to track and report pledges that employees made to the Corporate United Way program.

Developed a PC application to extract data from a corporate database to monitor training requirements for utility workers.

Provided technical support to apply maintenance upgrades to a Client/Server based payroll tax accounting system.

Managed a Project charged with bringing the Training and Compliancy Tracking system up to current maintenance level and converting it to Year 2000 standards.

CIBER INC. (SCB Computer Technology), Memphis, TN 7/1995 – 12/1996

Consultant to Operations and Financial Subsidiary of International Paper

Performed support and maintenance of an Order Entry and Order Fulfillment application that operated on a mainframe using COBOL, CICS, and IMS.

Developed a Raw Materials analysis application to help forecast materials depletion and reorder thresholds.

Lead a team to add benefit deductions process to a Client/Server based Payroll Package.

TSR COMPUTER ASSOCIATES, Hauppauge, NY 3/1994 – 5/1995

Consultant to ADP Proxy Services

Programmer Analyst

Developed projects to prepare Sales Analysis reports.

Designed, developed and implemented a Product Production Status Tracking Application to monitor progress of product package development through its various stages.

Programmer Analyst, Estee Lauder

Modified a Product Costing System to use one central formula to uniformly cost of all similar products sold in different countries.

Developed programs to convert an Order Entry and Order Fulfillment system from a VSAM-like system to use DB2 Database system. Participated in a project to convert all systems to use a new account number scheme.

Donald Smith Page 4

SCB COMPUTER ASSOCIATES, Memphis, TN 7/1991 – 3/1994

Consultant as Systems Analyst, International Paper

Converted the core Order Entry, Order Fulfillment, Inventory, Invoicing, Shipping and Sales History systems from using an IAM database system to utilizing IDMS/DMB and CICS concepts.

Provided customer support and applications maintenance on IDMS/CICS based Invoicing and Sales History system.

Performed projects to add new product lines and new paper mills to Invoicing, Sales History and Shipping systems.

Added new product lines, new paper mills, and new warehouses to Invoicing, Sales History and Shipping systems.

Various Consulting Positions Prior to 7/1991

Performed maintenance and support on Order Entry system for a Major Pharmaceuticals manufacturer.

Developed Bond analysis and statistics research engine for a major Investment firm.

Lead development team to develop a loan tracking system for a major bank to monitor loans granted to developing nations.

Developed an application that monitored the daily activity of retirement investments via extracting updates from the DB2 journal.

Evaluated technical deficiencies of company’s consulting staff and developed class schedules that trained the staff members in the deficient skill.

Conducted seminars, standup sessions and adult education training to update the skill level of company personnel.

Developed on-line Claims re-process procedure to adjudicate and pay claims that were suspended due to some qualification failure.

Lead team of programmers and analyst to convert all applications processing from DOS-VSE to OS-VS2 operating systems.

Developed a system to track various trades through the Back-office process.

Donald Smith Page 5

EDUCATION

1967 CUNY – Queens College, Flushing, NY

Aeronautics and Concepts of Flight Engineering Precepts, English

1968 Howard Institute of Technology, New York, NY

Certificate training program (COBOL programming, Assembler programming, IBM Systems concepts and operations, Programming theory and concepts, Database design)

1968-1969 New York Institute of Finance, New York, NY

Certificate program – Securities Industry Back Office Processing and Procedures

1970 Sperry Rand Education Center, New York, NY

Training Program – RPG programming for the Univac 9200 series

1972 IBM Regional Educational Center, New York, NY

Training Program – VSAM Concepts and Programming, OS VS1 Concepts and IBM Systems Operations

1997 Southwest Tennessee Community College, Memphis, TN

Training Course – C and C++ Programming Concepts

Contact this candidate