David Pyl
Software Engineer
Maryville,TN
Summary
Forward-thinking Software Engineer with background working effectively in dynamic environments. Fluent in RPGLE,SQL languages used to develop software within multiple industries. Proud team player focused on achieving project objectives with speed and accuracy.
Persistent professional equipped with 25 years of comprehensive experience in multiple industries. Provide strong technical direction across multiple projects. Responsible and articulate individual with strengths in solutions optimization. Respectful self-motivator gifted at finding reliable solutions for software issues. Experienced in IBM i and offering skills in SQL and RPGLE. Accustomed to working with cross-cultural, global teams.
Overview
5
5
years of post-secondary education
26
26
years of professional experience
Work History
Software Engineer
Clayton Homes - Berkshire/Hathaway Company , Inc
Maryville, TN
09.2015 - Current
- SQL stored procedures, web services via WDSL, dynamic/embedded SQL to support Retail business.
- Used Team City, Octo, GIT, Insomnia and Mulesoft for API development.
- Created process to retrieve TIFF images from IBM Content Manager using in-house API's which were put into zip file along with spreadsheet from IFS. This zip file was then SFTP'd to vendor using Alliance FTP Manager.
- Created process utilizing SOAP that retrieved customer information which posted XML messages to end point using Scott Klement's HTTP_post_XML from HTTPAPI. SOAPUI was used for testing.
- Created numerous SQL stored procedures, both native and external, for native and .NET processes to consume. This includes using SQL LIMIT and OFFSET to support paging.
- Provided proof of concept utilizing systools.HTTPPostCLOBVerbose to send JSON object to endpoint. All business units are now using this method for transport.
- Researched and implemented RPGLE programs to construct/deconstruct JSON objects from/into DB2 tables using SQL functions. These programs were then cloned and used Enterprise Wide.
- Collaborated with cross-functional development team members to analyze potential system solutions based on evolving client requirements in order for all business units to share common code base.
Senior Software Engineer
MEDHOST, Inc
Franklin, TN
01.2012 - 09.2015
- Develop medical software for hospitals utilizing RPG, dynamic SQL, and ILE.
- Created process using MQT's to avoid locks to allow users to use sytem while day end processing is running.
- This included triggers on MQT's to record database events which were then interpreted by another program that used trigger buffers and dynamic SQL to apply events to production files.
- This project was specifically designed for providing availability of ADT functions (Admission, Discharge, Transfer) for users while day end is processing.
- This also gives users availability to system even if errors occur during day end.
- Fortune 500 company Community Health Services specifically requested this project (NYSE: CYH).
- Worked closely with other business analysts, development teams and infrastructure specialists to deliver high availability solutions for mission-critical applications.
- Tested troubleshooting methods, devised innovative solutions, and documented resolutions for inclusion in knowledge base for support team use.
IBM I Programmer/Programmer Analyst
Jack Henry & Associates
Monett, MO
01.2007 - 01.2012
- Modified existing software to correct errors, adapt to new hardware and improve performance.
- Performed regression and system-level testing to verify software quality and function prior to release.
- Consulted regularly with internal customers on application development project status, new project proposals and software-related technical issues.
- Documented program development and revisions and accurately maintained historical records.
- Researched, designed and implemented scalable applications for data extraction, analysis, retrieval and indexing.
- Collaborated with developers and performance engineers to enhance support and identify performance bottlenecks.
- Responded to and remedied critical issues that could not be addressed by junior members of team.
- Wrote and implemented IBM i scripts to enhance user experience and integrated scripts.
- Authored code fixes and enhancements for inclusion in future code releases and patches.
- Identified causes of issues within applications and determined which modifications needed to be made.
- Provided dedicated coaching to interns and new employees, which boosted efficiency throughout department.
- Worked in team-driven environments and communicated effectively with all stakeholders.
- Investigated and addressed system issues to enhance usability and improve functionality.
IBM I Senior Programmer/Senior Analyst
Manheim Auctions, Cox Enterprises
Atlanta, GA
01.1999 - 01.2007
- Worked with Lotus Notes programmers to architect green screen application to Notes interface by modularizing existing RPG programs to be utilized by Notes via ODBC and SQL stored procedures, coordinated two contract programmers to make that transition, Met with IBM personnel in Rochester, MN in order to optimize this Notes application, utilized sockets for many applications using IBM application, Modified said IBM C application to add timeout for lost network connection, setup and tweaked Websphere on IBM i and Windows, continued advancing my skills with IBM DB2 SQL, architected and documented future ways of implementing n-tier architecture using RPG, sockets, stored procedures, Java across multiple platforms, Worked with local i IBM i support personnel to optimize IBM i performance, worked closely with DBA to ensure efficient data access and file creation standards were followed, understanding of normalized database techniques.
- Evaluated multiple software solutions during early software architecture plotting and system migration planning stage.
- Authored code fixes and enhancements for inclusion in future code releases and patches.
- Worked closely with clients to establish specifications and system designs.
- Built, tested and deployed scalable, highly available and modular software products.
- Performed regression and system-level testing to verify software quality and function prior to release.
- Led group of 3 engineers in design and development of acquired company-based software solutions.
Senior Programmer/Analyst
Skytel
Jackson, MS
01.1998 - 01.1999
- Maintained custom code and upgrades for Infinium General Ledger module; Web enabled GL custom reports to support online solution for remote users using Lotus Notes along with new application, db2Web, and SQL.
- Completely re-wrote S/400 resident e-mail process that supports MIME attachments in ILE C combined with ILE RPG IV and CL.
- Supported accountant end-users, developed interface to support EDI between Infinium Human Resources module and insurance company, Fox-Everett, who uses proprietary format.
- Worked closely with clients to establish specifications and system designs.
- Researched, designed and implemented scalable applications for data extraction, analysis, retrieval and indexing.
- Authored code fixes and enhancements for inclusion in future code releases and patches.
- Built, tested and deployed scalable, highly available and modular software products.
- Modified existing software to correct errors, adapt to new hardware and improve performance.
- Crafted email notification via Pegasus and cc:Mail application components from IBM i.
- Debugged and modified application software components.
Senior Programmer/Analyst
GG Pulley & Associates, Inc, Jack Henry & Associates
Albuquerque, NM
01.1996 - 10.1998
- Responsibilities - Designed and developed programs for a banking software product (SuperImage) that enables banks/credit unions to process checks.
- Provided on call support.
- Worked with other programmers, customer service representatives and customers.
- Used CL, ILE C, RPG III & IV, pointer intensive programming, Binding directories, activation groups, modules and service programs on a daily basis, Know AFPDS, IPDS & SCS type spool files, Spool file API's, IBM printer resident and soft fonts, Have created type AFPDS spool files using DDS and written ADPDS structures directly to Print Manager.
- Have written programs utilizing FTP in batch.
- Worked with distribution queues and directory entries occasionally along with line, controller and device descriptions.
- Used SDA or SEU to update display files, currently using OS/400 V3R2M0 and V4R2M0.
- Worked with writers/remote writers daily, parsed binary IOCA and TIFF images regularly.
- Updated and created user profiles, Changed subsystem descriptions.
- Worked with job queues/priorities; object locks, DFU and Query/400, Send/receive net files (single members/save files) daily.
- Exposure to IBM 3570 tape drive along with BRMS, Batch/interactive jobs, User hook programs, Designed, wrote and implemented new processes along with about 25% maintenance, Familiar with 1/4", 8mm and reel to reel tape drives, Read hex dumps daily.
- Used WinNT daily, Understanding of registry entries, Used DOS commands daily, network drives, cc:Mail and Lotus SmartSuite.
- Authored code fixes and enhancements for inclusion in future code releases and patches.
- Modified existing software to correct errors, adapt to new hardware and improve performance.
- Performed regression and system-level testing to verify software quality and function prior to release.
Education
Bachelor of Science - Computer Science, Mathematics
University Of Central Arkansas
Conway, AR 08.1990 - 05.1995
Work Availability
monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse
Skills
IBM iChange managementDatabaseProgrammingResearchSQLTroubleshooting
Adopting new technology
JSON
RESTful
Code Reviews
Scrum
Program Testing Software
Build Releases
Software applications
Testing and maintenance
Program testing software
Code reviews
Agile
Operational analysis
Algorithm implementation
DB2
Software development lifecycle expert
Best practices
Troubleshooting
Technical Analysis
Performance Tuning
Client requirements
Software Development
Programming
Technical Support
Development Lifecycles
Customer support
Quote
“Living is worthwhile if one can contribute in some small way to this endless chain of progress.”
Paul Dirac
Timeline
Software Engineer
Clayton Homes - Berkshire/Hathaway Company , Inc
09.2015 - Current
Senior Software Engineer
MEDHOST, Inc
01.2012 - 09.2015
IBM I Programmer/Programmer Analyst
Jack Henry & Associates
01.2007 - 01.2012
IBM I Senior Programmer/Senior Analyst
Manheim Auctions, Cox Enterprises
01.1999 - 01.2007
Senior Programmer/Analyst
Skytel
01.1998 - 01.1999
Senior Programmer/Analyst
GG Pulley & Associates, Inc, Jack Henry & Associates
01.1996 - 10.1998
Bachelor of Science - Computer Science, Mathematics
University Of Central Arkansas
08.1990 - 05.1995