David Lehner-Smith Email & Phone Number

Minneapolis, Mn, Us

Basking Ridge, New Jersey, Us

Contract Programmer Analyst role - Initial client; Wells Fargo.Designed, coded and tested Cobol and CICS programs, using DB2 and VSAM, to support the successful resolution of development projects for the Disbursements department. Provided both maintenance and new development design and coding. Wrote detailed design and testing documentation. Created all necessary JCL for development, testing and production.

Minneapolis, Mn, Us

REDcard Issuance• Processed, tested and supported Statements and Letters mainframe application, enabling printable files for guest correspondence produced by FIS / CSF document design software.• Created detailed Payment Card Industry (PCI) Audit reports and mitigation plans for 2 online applications, guaranteeing corporate compliance with industry security standards. • Reorganized and cleaned up file access security for 9 mainframe applications, leading department effort, creating improved access entitlements and documentation for simplified onboarding.• Provided production support, on rotating basis, for over 40 mainframe and online applications, successfully mitigating routine and high-severity issues. • Managed testing for Windows 7 to Windows 10 migration for 11 online applications, ensuring continued functionality after upgrade.• Collaborated with team, migrating online java application from WAS to Tomcat server for Statements and Letters online application (SLA).

Minneapolis, Mn, Us

Testing Center of Excellence (TCoE) • Participated in adopting and incorporating agile principals and incorporating into testing practices, researching articles and creating TGTWiki and Word reference documents, augmenting transition TCoE to agile/scrum methodology.• Led testing for pilot of Next Generation Intranet Pilot (NGI) upgrade to Target’s internal home page portal including initial pilot implementation and version upgrades and enhancements, ensuring smooth transition to new SharePoint-based site.• Spearheaded Pharmacy Accurate Inventory (PAI) Program for Finance department as Test Lead, incorporating new inventory procedures into Finance applications.• Directed Purchasing Accounting and Construction MANagement (PACMAN) Server Migration project, testing migration of JD Edwards application, used for Non-Retail Purchasing, Accounting and Construction Management, to upgraded server and operating system.

Minneapolis, Mn, Us

Corporate Finance • Acted as Engineer and Test Lead for light development and all testing for Finance changes in Domestic Transportation Management Program, implementing suite of new processes and systems to support $100B+ growth optimizing domestic freight routing.• Led Sunsetting Documentation for Automated Vendor Income application, inventorying all host and online elements.• Created Sunsetting Strategy Document detailing procedural steps in process used as template for many subsequent applications retirement operations.• Designed Fixed Assets database and Load processes for Host DB2 tables, enabling housing current and historic reporting data for Fixed Assets system, creating all design documents and leading construction, testing, implementation and turnover, executing on time and under budget. • Delivered design documentation for Import Claims product and extensive application changes for Global Target Organization project, reducing corporate import taxes.

Minneapolis, Mn, Us

Point of Sale (POS) • Programmed Line Item Detail (LID) Receipt processing application on mainframe, producing faster, more reliable receipt tracking and purchase returns.• Utilized nines’-complement algorithm, designing Check Fraud report for Assets Protection that processed millions of checks, finding sequential MICRs from small geographical area.• Designed, coded, tested and implemented changes to Target Red Card Rewards applications on Tandem system, enabling 10% rewards to be issued for Target CheckCard usage.

Clients: Target Corporation, Point-of-Sale and Accounts Payable Departments (COBOL, CICS, JCL, VSAM, DB2, EDI); Ameriprise, (COBOL, CICS, JCL, Pacbase, Easytrieve Plus, MIS/OL to CICS conversion)

Computer Programming Certificate, Computer Programming

Bachelor Of Arts (B.A.), Music Education