We provide IT Staff Augmentation Services!

Senior Application Engineer Resume

Gaithersburg, MD

Summary:
Ten years experience in leadership and senior technical positions for system design and development. Manager and technical lead for the Startec Oracle billing development team. For the last nine years, professional efforts have been focused on software engineering and development using Oracle PL/SQL, creating and maintaining Oracle forms, and maintaining web-based systems developed using PL/SQL and Oracle HTTP. The most recent experience is with Oracle 9i and 10g using PL/SQL, triggers, stored procedures and packages, database designer, C and Pro-C, using Explain Plan and TkProf to improve performance.

Clearance: SECRET

Education: BS Mathematics

Technical Skills:
Databases: Oracle 10g and earlier versions, Access, Visual FoxPro, MySQL
Software and Tools: Enterprise Architect, Erwin, Rational Rose, Rational ClearCase , Rational ClearQuest, RSA, Oracle Forms (6i, 10), Oracle Reports (6i, 10), TOAD, SQL-Loader, PVCS Version Manager, PVCS Tracker,
Operating systems: Windows XP and earlier versions , AIX, UNIX
Languages: JAVA, JDBC, JSP, JSF, JDeveloper, C, C++, UML, XML, HTML, Visual Basic

Confidential, (September 2010 - October 2010)
Oracle Developer
Added voice aided technology to Oracle Financials System for Savantage Solutions for 508 Compliance.

Confidential, (December 2009 - May 2010)
Oracle Developer

Designed Oracle reports and forms (10g) for moving the Department of Energy (DOE) Funds Distribution System (FDS) from a COBOL-based system to Oracle Forms and Reports system. Used Oracle Analytic functions to gather and group data.

Confidential, (October 2005 - July 2009)
Senior Application Engineer

Worked on a Java Server Faces (JSF) library to provide a base platform for moving DCAPES (Deliberate and Crisis Action Planning & Execution Segments) to a Java-based system. Maintained the DCAPES application for the Air Force using Oracle relational database tools. Administered an Oracle database to support DCAPES system for the United States Air Force. Analyzed incoming database problems reported from production sites and support production DBAs in resolving application and database issues. Instantiated Oracle SQL package tuning and coding. Provided support to the DCAPES' help desk. Performed unit and regression testing for software releases.

Confidential, May 2003 - September 2005
Oracle Developer

Analysed , created the basic design, and developed the Financial Accounting Reporting System (FARS). Improved accuracy and efficiency of systems software and performed upgrades to the Payment Management System (PMS) in support of the Department of Program Management (DPM) of the U.S. Department of Health and Human Services (HHS). PMS is a web-based Oracle system using PL/SQL and Oracle\'s HTTP package for HTML page design.

Confidential, ( May2001 - May 2003),
Software Specialist V

Led group effort to create use cases for Grant Closeout Module (GCM) development. Responsible for updating stored procedures and Oracle forms to reflect new business rules and updating CASE (ERWin) with database changes. Maintained the Payment Management System (PMS) and developed upgrades for the Program Support Center (PSC) of the U.S. Department of Health and Human Services. Maintainedthe Grants Management (GM) and Quick View (QV) programs in support of IMPAC II (Information for Management, Planning, Analysis, and Coordination) project.

Confidential, (1998 - 2001)
Technical Lead and Senior Programmer Analyst

Led and managed the design and documentation of the Billing and Conversion System (BACS II), which was capable of processing
4million records in an hour. BACS II was developed in C and Pro*C using Oracle packages, triggers, and stored procedures on a Unix (AIX) platform. BACS II replaced BACS in order to be able to handle the larger amount of data that needed to be processed.

As technical lead, managed the upgrades and fixes for the Billing and Conversion System (BACS). BACS was processing data for up to 5 million calls/day using an Oracle 8 trigger-based system running on a UNIX box (AIX 4). BACS used stored procedures, Visual Basic and Excel for report production

Primary analyst and programmer responsible for the Data Conversion system (DCS). This system took files, downloaded from the switches, and extracted customer and carrier data that was entered into the database for use by the Billing System. The DCS made use of Unix scripts and various classes to send email pages to our production support staff if switch files were late or damaged.

Confidential, (1996 - 1998)
Senior Programmer Analyst

Lead programmer and analyst for the Confidential, (Finland-United States Investigation of Non-Insulin-Dependent Diabetes Mellitus Genetics) project. Worked directly with the clients on site, providing analysis for a variety of systems in order to accomplish quick adjustments to systems and to meet at their convenience to discuss further enhancements to existing systems. Established systems documentation standards. The FUSION system analyses and groups genotype data used to generate reports for further scientific analysis.

Built a query-by-example application that created SQL queries on the fly, based on data dictionary information. This application pulled data from the NHGRI Grants Management System (GMS) using OLE to work with Excel spreadsheets and providing e-mail capabilities for use by IMPAC II which is the main grants management system for NIH. Created ad-hoc SQL reports as well as many standard SQL-based reports.

Responsible for system design, documentation and implementation of the Radiation Research help-line for the Department of Energy (DOE). Designed the base classes for surveys, using object-oriented techniques, that satisfied the client's requirement for pollsters' being able to step through the survey questions from a script on their screen and ensuring that required fields contain entries. The information collected by this online information collection system was sorted weekly using a set of SQL commands and was then uploaded to the appropriate agency. Met regularly with the DOE staff to analyze the data collection techniques being used.

Lead design analyst and programmer for the Women and Children (W & C) Child and Collateral baseline surveys for SAMHSA (Substance Abuse and Mental Health Services Administration.)

Confidential, (1995 - 1996)
Programmer Analyst

Maintained software and system documentation for Mortgage Dynamic's marketing and analysis system.

Confidential

Programmer

Redesigned the entire brick tracking system process, reducing the average computer processing time from 90 minutes to less than 25 minutes per shift. Initiated design of a point of sale application.

Hire Now