David Haines

CL / CLLE / RPG ILE / RPG IV / RPGLE / SQLRPGLE / RPG Free Format / SQL Functions / Stored Procedures

DB2 / DDS / DDL

• Created new, and modified existing, software systems to enhance performance and add new features
• Created and maintained screens and programs that used the data collected from the screens and files to create a variety of reports for internal and external clients involved with the insurance industry
• Troubleshot production defects across client loan platforms.
• Updated application logic for policy and billing changes.
• Documented technical procedures for internal support staff.
• Tested software releases before deployment to production.
• Debugged existing code base to identify potential problems or areas of improvement.
• Tested developed applications for functionality, performance and scalability.
• Collaborated with other developers to resolve issues related to application development process.
• Identified, debugged, and fixed system bottlenecks and problems.
• Developed and maintained comprehensive application documentation for future reference and upgrades.
• Conducted thorough testing and debugging to ensure optimal application performance.
• Participated in code reviews to maintain high-quality software development standards.
• Analyzed code and corrected errors to optimize output.
• Improved and corrected existing software and system applications.
• Recommended improvements to facilitate team and project workflow.
• Developed requirements for system modifications and new system installations.
• Resolved customer issues by establishing workarounds and solutions to debug and create defect fixes.

CL / CLLE / RPG ILE / RPG IV / RPGLE / SQLRPGLE / RPG Free Format / SQL Functions / Stored Procedures

DB2 / DDS / DDL

• Worked on the EFT (Electronic Funds Transfer) team creating and maintaining banking software for individual credit unions as well as worked on core software used by all credit unions
• Currently working on the Custom Forms team creating and maintaining custom screens and programs for specific credit unions. Then using the data collected from the screens and the files to print a variety of completed forms used by that credit union
• Developed credit union software features for CU*Answers core processing systems.
• Maintained application code supporting member account and transaction workflows.
• Tested program changes before release to production environments.
• Resolved software defects using source control and debugging tools.
• Updated program logic to support business rule changes.
• Documented code changes, procedures, and technical specifications.
• Collaborated with analysts and support teams on system issues.
• Coded, tested and debugged programs in accordance with established standards.
• Modified existing database structures to improve system performance.
• Executed scripts to communicate with back-end servers and provide real-time updates.
• Contributed to the development of technical documentation and user guides.
• Debugged and resolved software bugs, improving system performance and stability.
• Resolved customer issues by establishing workarounds and solutions to debug and create defect fixes.
• Analyzed code and corrected errors to optimize output.
• Improved and corrected existing software and system applications.
• Worked closely with systems analysts, engineers and programmers to understand limitations, develop capabilities and resolve software problems.
• Modified existing software to correct errors, adapt to newly implemented hardware or upgrade interfaces.

CL / CLLE / RPG ILE / RPG IV / RPGLE / SQLRPGLE / RPG Free Format / SQL Functions / Stored Procedures

DB2 / DDS / DDL

• Created new RPG programs / Modified existing RPG code to support business needs

CL / CLLE / RPG ILE / RPG IV / RPGLE / SQLRPGLE / RPG Free Format / SQL Function / Stored Procedures

DB2 / DDS / DDL

• Modified existing software systems to enhance performance and add new features.
• Worked in team environment to produce high-quality programs and applications for Dental Insurance industry.
• Participated in team meetings and provided input on deadlines, designs and enhancements.
• Documented technical specifications and project testing methods for future reference and other assignments.

CL / CLLE / RPG ILE / RPG IV / RPGLE / SQLRPGLE / RPG Free Format / SQL Function / Stored Procedures
DB2 / DDS / DDL

• Improved overall order processes by working with team members and end users to find workable solutions.
• participated in an on-call support capacity during business and non-business hours
• helped to create and maintain support documents to standardize error responses
• helped to automate nightly processes resulting in reduction, or elimination, of user error.
• Worked closely with team members to deliver project requirements, develop solutions and meet deadlines.
• Enhanced and maintained the Order Entry & Maintenance processes resulting in Increased speed, efficiency and effectiveness resulting in saving thousands of work hours yearly.

- including, but not limited to: auto posting of orders, auto maintenance of orders and automating pieces of trip creation process thus allowing orders to come into the AS400 and not

• Supported cross-functional teams during development of new furniture programs.
• Created technical documents, user manuals, and training materials for new systems.
• have any human interaction until being loaded onto a truck.
• Developed and maintained software for routing trucks and scheduling trips resulting in saving thousands of work hours yearly.
• - Developed and maintained interfacing between the AS400 and different 3rd party packages such as HighJump, Descartes, Rimms, Blue Jay
• Completed a new Return Authorizations system project resulting in savings for the company - many hundreds of work hours (allowing users to do in seconds what previously had taken days), many thousands of dollars by eliminating the need to hire additional personnel to keep up with demand.
• Worked closely with team members and end-users to adapt existing applications to handle business operations in China and Vietnam.
• Collaborated with the Operations team to provide end users with application failure support.
• Provided technical support to internal customers in resolving complex issues.
• Conducted detailed testing of software products prior to release.
• Developed and maintained software applications to meet customer needs.
• Resolved production application problems by troubleshooting code or data structures in a timely manner.
• Collaborated with cross-functional teams including product owners, designers, QA testers, operations personnel.
• Documented requirements based on client feedback and project specifications.
• Created and offered additional materials to enhance training.
• Obtained and organized manuals, guides and visual materials for development and training purposes.
• Worked collaboratively across departments and with various stakeholders to deliver comprehensive, effective training sessions.

CL / RPG III / SQL Function / Stored Procedures
DB2 / DDS

• Monitored the AS400 for run-time errors, determine cause, fix issue immediately (if possible), get the AS400 running again as quickly as possible.
• Printed letters, invoices, miscellaneous documents as requested.
• Created / maintained RPG/CL/DDS code to support business.