• Researched, designed, wrote and installed custom WinForms application to help manage customer licensing information.• Modeled new database and tables for support of application.• Interface with 3rd party vendor via web api to keep disparate systems in sync.• Provide continuing support and enhancements as needed.

• Control Db2 database object creation and design (where needed).• Provide guidance to developer and end-users on SQL techniques to ensure correct usage and improve efficiency.• Generate and analyze query access paths to ensure consistent performance.• Write custom tools to automate common tasks, whether on mainframe (Rexx) or shell scripting in other environments (Bash, Powershell, etc.). For example, heavily automated entirety of Db2 Disaster Recovery process.

• Helped write and primarily maintain web-based customer support system to track member inquiries. Application written with Java's EJB technology.• Created internal web application using Java Struts technology to automate time-intensive user input task. Was responsible for design, coding and implementation.• Wrote multitude of queries/reports for end users. Worked with users to refine requirements and develop report criteria. Generated processes for delivering report results via user-desired means (e.g. email, print, spreadsheet).• Frequently tasked with database table loads of externally generated data. Requirements sometimes dictating table design in addition to the load. Used available and necessary tools to complete task (Perl, DFSORT, COBOL, SQL manipulation etc.). For instance, wrote custom Perl script to formatmainframe flat file into database-loadable format for improved usability.• Rewrote many legacy COBOL reporting programs in SQL, often resulting in significantly improved runtimes.• Designed and implemented a number of purge processes for existent databases. Processes required fundamental understanding of underlying table structures and their logical and physical designs.• Developing internal web application to utilize Lucene search api to make use of text-based knowledge base.• Utilized strong written and verbal communication skills in co-worker and user interactions.