Programmer Analyst

John J Clark

** **** ***** *****

North Attleboro, MA 02763

Home: 508-***-****

Cell: 617-***-****

***********@*****.***

PROFESSIONAL SUMMARY

Programmer Analyst accomplished in all phases of software development. Excellent analytical and problem solving skills, effective as an individual contributor or as a team member. Extensive IBM mainframe experience programming in COBOL, PL/I, and CICS. Experienced writing SQL queries against SQL Server, Oracle, and Sybase databases. Self-taught in JavaScript, HTML, and CSS.

SKILLS

SQL, COBOL, CICS, VSAM, PL/I, SQL, JavaScript, HTML, Perl scripting, Unix, Datacom/DB, IMS DB.

Deliverables include statements of work, functional design documents, programming specifications, test plans, and implementation plans.

EXPERIENCE

’47 Brand, Westwood, MA 10/2019 - 3/2020

Programmer analyst employed by ‘47 Brand working on the BlueCherry enterprise resource planning (ERP) system. Responsible for writing SQL queries in response to ad hoc reporting requests from sales, marketing, and production control groups. Wrote queries to update SQL Server tables with costing, apparel, and marketing information. Ran jobs within BlueCherry to add purchase orders, make stock adjustments, and create product style groups. Researched inventory discrepancies between BlueCherry and the individual warehouses weekly. Furloughed because of Covid-19 on 3/27/2020, laid off on 6/25/2020.

Apex Systems, Providence, RI - 4/2017 - 4/2019

Consultant assigned to the Rhode Island Department of Human Services (DHS) performing user acceptance testing on modifications to the eligibility system for health and social welfare benefits (RI Bridges). Wrote SQL queries against Oracle data bases to aid in the testing and to help analyze application issues. Performed quality assurance on SQL queries written by Deloitte to correct data errors in the system.

Northrop Grumman; Providence, RI – 3/2014 – 9/2016

Consultant assigned to the Rhode Island Department of Human Services (DHS), responsible for all file transfers between DHS and clients using Windows 2003 and 2008 servers. Created monthly file transfer schedules and tracked transfer completions and failures. Performed scheduled manual transfers between DHS and financial institutions, government agencies, and end users. Researched and completed all failed transfers. Created and modified scheduled tasks and documentation for new and existing file transfers.

Consultant, Business Analyst, Rhode Island DCYF; Providence, RI — 5/2007 – 7/2008

Developed functional and programming specifications for modifications to the Rhode Island Children’s Information System. Performed testing of programmer changes and corrected production data problems identified by DCYF staff. Analysis, data correction, and testing used SQL queries against Sybase tables, and execution of MicroFocus COBOL programs under UNIX.

Consultant, Programmer Analyst, DentaQuest; Charlestown, MA — 5/2006 – 12/2006

Maintained legacy mainframe applications while they were migrated to PC platforms. Wrote COBOL and EASYTRIEVE data downloads and reports for DentaQuest clients.

Consultant, Programmer Analyst, Fidelity; Boston, MA — 2/2006 – 5/2006

Modified COBOL CICS programs and wrote EASYTRIEVE reporting programs.

Consultant, Programmer Analyst, CVS; Woonsocket, RI — 6/2002 -12/2005

Designed, coded, and implemented the online portion of a Direct Store Delivery (DSD) system for the accounts payable group. DSD allowed CVS vendors to deliver directly to stores instead of distribution centers. Met regularly with the accounts payable group to design the system and produce a functional specification. The online system supported inquiry into vendor invoices, adjustments to prices and quantities, and entry of vendor invoices not captured during deliveries. It consisted of 10 programs and 15 screens written in COBOL using CICS and VSAM.

Tested changes to 150 jobs, procs, and programs modified for the CVS acquisition of the Eckerd stores and 3 Eckerd distribution centers. Developed 11 new jobs to monitor activity at the Eckerd distribution centers, created costing reports, and generated download files for the distribution centers and CVS accounting.

Modified 40 COBOL CICS programs for the expansion of the Universal Product Code (UPC) from 11 to 14 positions.

Overhauled a store physical inventory system. The system received nightly inventory transmissions from two inventory services, edited the transmissions, added them to a holding file, and released store inventory from the holding file to an inventory master file. I rewrote the edit program, redesigned and rewrote the holding file processing, and wrote a new online CICS program to inquire on the holding file and release inventory to the master file.

Consultant, Programmer Analyst, State Street Bank; Westwood, MA — 2/2001 – 4/2002

Designed, coded, and implemented a dividend streaming application for the Scottish Widows Pension fund, a State Street client. British tax laws require breaking down (streaming) dividends into amounts derived from British and non-British securities. The system allowed online entry of dividend information, applying percentages to stream the total dividend, posting to general ledger accounts, and reporting on dividends received. Coded in PL/I with CICS using Datacom/DB tables.

Senior Consultant, Computer Sciences Corporation (CSC); Waltham, MA — 2/1987 -1/ 2001

Programmer analyst for one year on a project team supporting Premier’s WebCat website. The website displayed a catalog of hospital supplies available to member healthcare organizations. The site used Oracle tables with BroadVision to personalize content. Implemented new functionality through regular software builds using JavaScript and HTML.

Team leader at the CSC Y2K Renovation Center for four years. Responsible for leading teams ranging from three to eight consultants over the course of a project, reconciling client program inventories, producing COBOL line count statistics, participating in weekly client conference calls, performing quality assurance, coordinating with CSC internal delivery assurance, packaging all renovated code and reports for delivery, and serving as the daily contact for the client. Coordinated Y2K efforts with other teams making non-Y2K changes on the same code.

The CSC Y2K Renovation Center used software developed by Peritus Corporation to renovate client code on a UNIX platform. There were two renovation approaches, date expansion and logic correction. Date expansion physically expanded date fields on files to carry the century. Logic correction added program code to determine a date’s century based on a cutoff year. I was team lead for a date expansion project for The Hartford Insurance Group lasting six months and processing 500,000 lines of code. I was also team lead for a logic correction project for Aetna U. S. Healthcare lasting one year consisting of a pilot followed by 11 releases totaling 7,000,000 lines of code.

As a check on the Peritus software, wrote Perl and UNIX scripts using pattern matching to identify Y2K problems in COBOL code. The scripts became part of the center’s core methodology, and became the basis for the Millennium Readiness Inspection (MRI) process. MRI projects focused on reporting potential Y2K problems to clients. No date expansion or logic correction took place. Team leader for nine MRI projects, each lasting approximately five weeks.

Assigned at The Boston Company working with mutual fund accountants to prototype three releases of 30 mutual fund reports each. Wrote SQL queries against mainframe DB2 tables to produce interest, dividend, multi-currency, and gain/loss reports.

Assigned at State Street Bank responsible for designing, coding, and implementing a general ledger reporting system for the Ford Motor Company. Worked extensively on modifications to State Street’s Multi-Currency system, using PL/I and CICS to access Datacom/DB tables.

Principal Programmer Analyst, Codex Corporation; Mansfield, MA — 2/1980 – 2/1987

Codex employee responsible for the mainframe invoicing, leasing, accounts receivable, property tax, and revenue reporting systems. I worked closely with the accounting group to maintain and improve the systems. On call for all production problems and was the daily contact for the accounting group.

Codex leased telecommunications equipment to customers and invoiced them monthly. The monthly run time of eight hours caused scheduling problems for the operations group. Redesigned and rewrote the monthly lease invoicing job, reducing the run time from eight to four hours.

Project leader for the VSAM to Datacom/DB conversion of the telecommunications equipment leasing system. Developed the conversion strategy and wrote conversion specs for 150 COBOL programs and 30 batch jobs. Managed six programmers during the project and provided production support after the conversion.

Installed a vendor’s accounts receivables package with online CICS capability to replace an entirely batch A/R system. Developed the implementation approach with the accounting group, wrote conversion programs to create input transactions for the new system from the old system, and coded interface programs to feed the new system from five existing invoicing systems and two lockbox sources.

Replaced a manual property tax system with one written in COBOL using VSAM files with CICS. Equipment sold or leased could be subject to local property taxes at the state, county, school district, water district, or town level. The system tracked equipment in the field, determined taxing jurisdictions based on zip code, allowed online entry of tax rates, calculated taxes, generated invoices, and passed invoicing information to the accounts receivable system.

EDUCATION

Boston College, Chestnut Hill, MA 02167 — B. S. Chemistry

Contact this candidate