Embedded Files
DEREK R. ESTERLINE
Newark OH 43055
daesterlines@gmail.com
Application Development and Support Experience
I have over 25 years of application development and support experience. The development environments I have used include Java J2EE, Oracle Application Express (APEX), Perl. PowerShell, PowerBuilder, SQL, Oracle PL/SQL, C, FoxPro and Microsoft Access. I have also assisted with architecture and infrastructure decisions and modifications for custom and vendor applications, and have provided 24/7 support for these applications.
Work Experience
Software Engineering
8/2012 to present - JP Morgan Chase, 1111 Polaris Parkway, Columbus, OH. 43240
• Created new and modified various complex Perl and PowerShell scripts that support the Bridger Insight XG vendor application.
• Assisted with moving applications to new servers. When I started in 2012, the application was on 3 servers and only processed thousands of records per month. It is now on 54 servers and processes billions of records per month.
• Wrote complex SQL queries for reporting, ad-hoc support and analysis.
• Assisted with creating, support and diagnosing of issues with sFTP connections.
• Provided 24/7 production support for the vendor application as well as all in-house custom code/applications created to support Bridger Insight XG.
Application Developer/Analyst
5/2000 to 8/2012 – JP Morgan Chase, 1111 Polaris Parkway, Columbus, OH. 43240
• Implemented complex business applications using PowerBuilder, PL/SQL, Oracle Application Express, and Java J2EE.
• After working on the project for two years I was promoted within the group to a lead position over the other programmers.
• Assisted with writing a reporting application implemented on our Intranet written in Java J2EE utilizing the Struts framework
• Our team successfully implemented a complex commercial loan compliance application with over 2000 users and many complex screens that is still in production today.
• Along with development tasks I also did production support for several applications utilizing diverse technologies, requirements gathering, and documentation, working with users on testing, and working with other groups in the firm for support and implementation.
MIS Manager
12/1996 to 4/2000 - Community Health Plan of Ohio, 1915 Tamarack Rd., Newark, OH. 43055
• One year of managing MIS department of ten people while keeping up with programming duties.
• Three years of PowerBuilder programming.
• Three years of SQL programming.
• Developed and implemented several programs automating business processes including a program that allows the finance department to easily generate profit/loss reports.
Senior Programmer/Analyst
9/ 1994 to 11/1996 - Sun Television & Appliances, 6600 Port Rd., Groveport OH 43125
• Wrote low level drivers in C to interface the NCR 7052 cash register peripherals, such as the magnetic stripe reader, the printer and the customer display to interface with FoxPro POS.
• Wrote and maintained an interface between the POS and the bank for credit verification in C language.
• Converted POS written in FoxBase to FoxPro. Also heavily modified and helped distribute this program.
• Assisted in programming and implementing new Point Of Service software written in Clarion for Windows.
Computer Consultant
9/ 1991 - 9/ 1994 - Centratech Service, Inc., 951-A Buckeye Ave., Newark OH 43055
• Participated in the design and implementation of an aluminum manufacturing data acquisition system for Ormet corporation. The platforms used were DOS and OS/2 version 2.1. The languages used were FoxPro and C.
• Installed and maintained Novell and Lantastic networks for several companies.
• Wrote many smaller applications for various companies to help streamline business processes.
• Diagnosed and repaired PCs with software and hardware problems for several companies.
Programmer/Analyst
8/1988 - 3/1991 - Fermi National Accelerator Laboratory, P.O. Box 500, Batavia IL 60510
• Programmed for silicon strip detector research and development using C, Pascal and Fortran.
• Local system manager for a Sun SPARCstation 1+ which handled over twenty users.
JP Morgan Chase Accomplishments
I developed custom software in PowerBuilder, PL/SQL, Oracle Application Express (APEX) and Java J2EE while employed for JP Morgan Chase. After two years I was promoted to the lead position over the other three programmers on our team. Along with development tasks I also did production support for several applications utilizing diverse technologies, requirements gathering and documentation, working with users on testing, and working with other groups in the firm for implementation and support. I have also assisted with architecture and infrastructure decisions and modifications for custom and vendor applications, and have provided 24/7 support for these applications. I also created new and heavily modified various complex Perl and PowerShell scripts that support the Bridger Insight XG vendor application that uses MS/SQL database and wrote complex SQL queries to create reports and support users. When I was first hired to support the BridgerInsight XG application in 2012, there were only three servers and only thousands of records processed per month. I assisted with two tech refreshes of the servers and helped architect the infrastructure scale up, so now the application has over 54 servers and processes billions of records per month.
Community Health Plan of Ohio Accomplishments
I developed custom software in PowerBuilder and SQL while employed for Community Health Plan of Ohio. One such program combined many fairly complex queries and formulated one summary report based on the results of these queries. The parameters of these queries were all easily changeable and maintainable by the end user. Also was given authority to prioritize and delegate projects, gave evaluations, administered disciplinary action and assisted in the hiring process for the MIS staff of ten people.
Sun Television and Appliances Accomplishments
I made several modifications to the POS program which is written in Foxpro, namely C routines that allowed the FoxPro code to interface with the printer, magnetic stripe reader, and the customer display on the 7052 cash register. I wrote in C and FoxPro the interface between the POS and the bank for credit verification. I also helped to rewrite and implement the Point of Sale application in Clarion for Windows.
Centratech Service, Inc. Accomplishments
I was a Computer consultant for multiple companies while employed for Centratech Service Inc. Services included writing custom software, PC repair, and installation, and maintenance of PC networks. Custom software was written in both C and/or FoxPro. Platforms used were DOS, Windows, and OS/2. Networks handled were LANtastic 4.1, 5.0 and 6.0, and Novell 3.11, 3.12.
Fermi National Accelerator Laboratory Accomplishments
I participated in the design, development, and implementation of state of the art high-speed data acquisitions systems for high-energy physics experiments. This work involved the development of Graphical User Interfaces, embedded processor microcode, VMEbus interfaces, and Remote Procedure Calls. The programming languages that were utilized include: C, Pascal, and FORTRAN. I was also the local system manager for a Sun SPARCstation 1+ which handled over twenty users.
Education
1988 Associates Degree in Science; Elgin Community College, Elgin IL
August 1988 through June 1990 Electrical Engineering Curriculum, including courses in C and
FORTRAN; University of Illinois at Chicago, Chicago IL
October 2010 Oracle Application Express: Developing Web Applications
February 2009 ProTech Advanced Java Programming
May 2007 Java 2 Programming for SDK 1.4 Part 6 Utility Classes
April 2007 Java 2 Programming for SDK 1.4 Part 5 Threads and Error Handling
April 2007 Java 2 Programming for SDK 1.4 Part 4 Language Features
March 2007 Java 2 Programming for SDK 1.4 Part 3 Object-Oriented Concepts
January 2007 Java 2 Programming for SDK 1.4 Part 2 Language Fundamentals 2
January 2007 Java 2 Programming for SDK 1.4 Part 1 Language Fundamentals
March 2003 J2EE Programming with WSAD Version 5
July 2000 Introduction to Oracle: SQL and PL/SQL
May 2000 Migrating to OO Programming with Java Technology
April 1999 Assertiveness Skills for Managers and Supervisors
June 1997 Enabling Web Applications with Java & Databases
March 1997 Supporting Microsoft Internet Information Server 2.0
January 1997 Exploiting Data Window Technology in PowerBuilder
January 1997 Mastering Data Windows in PowerBuilder
January 1997 Managing Performance in PowerBuilder
December 1996 Fast Track to PowerBuilder
August 1995 Windows Application Development for Clarion Users
Academic Achievements
Elgin Community College
Member of Elgin Honors Society. (‘A’ average required)
Streamwood High School
Graduated top 10% of class; Member of National Honors Society, recipient of the City of Elgin Trustee’s Scholarship as well as the Illinois State Scholarship.
Google Sites
Report abuse