Post Job Free

Resume

Sign in

Technology Drive Sql Developer

Location:
Beltsville, MD
Posted:
December 14, 2021

Contact this candidate

Resume:

Paul S. Marchetti

**** ****** **** *****

Beltsville, MD 20705

301-***-****

adpngg@r.postjobfree.com

Interests

Java Technologies & Frameworks;

Java/J2EE Enterprise Applications;

Software engineering; Analysis, design and modeling of systems for information management/processing; Simulation, data modeling, and network applications.

Relevant Skills

Software Development - 20 years

Object Oriented Design - 15 years

Integration & test - 10 years

Unix/Linux - 15+ years

Win32 System - 8 years.

C/C++ - 15+ years

Java – 10 years

Perl - 5 years

Oracle Database - 9 years

Network Data Transfer

Near real-time simulation & modeling

Win32 GUI development

Java Swing GUI development

Java Messaging Service(JMS)

Apache Struts 2 & SpringMVC Frameworks

RESTful Web Services in Spring Boot Framework

Employment History

2021-present

Senior Software Engineer Consultant - Internal Revenue Service US Treasury Department.

M9Solutions

3033 Wilson Blvd, Suite 480

Arlington, VA 22201

IRS CADE2(Customer Accounting Data Engine) – DDS(Data Delivery Services) Project

2019 – 2021

Senior Software Engineer Consultant – Internal Revenue Service US Treasury Department.

Consummate Computer Consultants Systems LLC.

4075 Wilson Blvd.

Arlington, VA 22203

Trinity Technology Partners Inc.

7501 Greenway Center Drive

Greenbelt, MD 20770

CTRS(Collection Time Recording System).

Full stack Java Web application implementation involving refactoring and enhancement of data retrieval, display and editing capabilities.

CICD(Continuous Integration Continuous Deployment) in the Rational CLM(Collaborative Life Cycle Management) environment, including RTC(Rational Team Concert).

New and refactored Oracle database queries for data access leading to search and display of retrieved data.

Enhancements to View Data, Edit Data, Data Status, Setup, User Accounts and Data Locking Status web pages. Database access management based upon user roles assigned to specific government users.

Formal report generation to generate spreadsheet or tables presenting data in an organized manner which includes user-generated and Administration Reports generation.

Audit Logging of system events involving data access, display and processing of Inventory, Hours, Revenue Office and other data types. Event recording to the database for future access and analysis

was based on the associated ActionCategory for a given event.

Enhancement of legacy and new GUI development for enhanced functionality. Full use of JSP, JavaScript

and jQuery technologies.

Implemented dynamic Report Name Generator using core descriptors from the CTRS report type enumeration.

Created the AppScan Validator using Regex expression matching as enumerated validation constants for differing potential types of intrusion.

Set up a Global Exception Handler to put up a web page each time an exception is thrown, reporting the

exception class and other details such as date, name, appversion.

Implementation of Section 508 compliance elements per customer request.

2015 – 2018

Senior Software Engineer short term consultant – various projects

Project work involved legacy web applications in Spring, Spring MVC, Spring Boot environments;

Eclipse IDE; Maven builds and dependency management. iBATIS and Hibernate persistence; Oracle 10/11 databases;

Database management tools such as TOAD, SQL Developer.

Project Task Orders involved changes to underlying Java/J2EE code at the Controller level in order to affect change, optimize, or implement new features to front end data management & display per customer requirements.

Projects:

Pyramid Consulting.

DAON Trusted Identity Services/TSA. Developed new Web Service in Spring Boot environment for

database access involving the Background Check Vetting process. Implemented both Crud Repository

and custom JPA queries, including automated testing with Junit. Entity, Controller, Service, Data Repositories and Test capabilities were created.

NewGen Technologies.

TSA/DHS TIM(Technical Infrastructure Modernization) startup on software for vetting

individuals requesting entry into the USA based on data base information from multiple

government and law enforcement sources.

GDIT Health Solutions.

CMS(Centers for Medicare and Medicaid Services) – Modifications to legacy

web applications involving I&A(Identity and Access Management) for service

providers.

NTT Data.

DOJ Automated Docket System migration to Entellitrak(MicroPact) Framework.

Experis.

USPS Container Dispatch – implementation of new web service capabilities.

Detailed design document generation. JAX2B code generation from XML Schema.

2014

Senior Software Engineer

G3 Systems

NIMH IRTMB Software Development

6001 Executive Boulevard

Rockville, MD 20852

OCRPL – Office of Constituency Relations and Public Liaison web application.

Java front end development, defects management & enhancements to functionality in an

application used to manage a major national outreach program of professional organizations

throughout the US.

Apache Struts 2; JBoss Unix application server; Oracle 11; Toad for Oracle SQL Tuning & Database Development Tool. Eclipse; SVN; HP Quality Center.

Java code modifications affecting data retrieval and front-end display; Data retrieval and filtering; Changes to Struts 2 tags to iterate over data collections, display filtered data to the user, and implement links which allow the user to edit contact information, create, view and edit Progress Reports relating to Outreach Partner efforts on a quarterly basis; Save changes to edited profiles and send email notifications of change to the user. Modifications to JavaScript files to implement overlay messages upon upload and saving of data; web page redirection in case of error or logout; Application build with Ant and deployment to Unix JBoss external server.

2012-2013

Senior Software Engineer

Engility

1320 Braddock Place

Alexandria, VA 22314

VBMS - Veterans Benefit Management System – Java back/front-end repair of

software defects and code refactoring; Win32 platform on secure VPN network;

Veteran Claim Processing System involving information exchange by way of

Claim Development Letter document generation and archiving of evidentiary

documents pertaining to a veteran’s claim.

Agile Software Development; Continuous Integration(Jenkins); SpringSourceToolSuite – SpringMVC;

RTC(Rational Team Concert); Maven; Eclipse; IntelliJ; Oracle SQL Developer;

Database & Java technologies; Weblogic Server; JavaScript; jQuery; JSP; JMockit;

Cobertura;

Java front-end defect management by modification of JSP files to affect proper presentation of

table data; management of links associated to document retrieval; Support of the MVC paradigm

through Java code modifications to Controller entities in order to optimize, select and filter data

and update the data model, all in order to affect front-end display. Changes to a Liquibase database

by change sets introduced in a continuous integration environment in order to Update database tables

consistent with changes in the Controller data model. Other changes as necessary to Java and JSP files

to address defects ranging from trivial displays of text and Tool Tips to non-trivial reformatting of data

and significant enhancements to functionality.

2012

Senior Software Engineer

Boeing Kestrel (consultant under Edge Professional Services)

131 National Business Parkway

Annapolis Junction, MD 20701

Data feed development on the Linux platform employing Ruby, XML and XSLT technologies.

Involved capture of Internet data, using Kestrel tools, filtering and content archiving in searchable/retrievable form.

2011

Senior Software Engineer

L3 STRATIS

2720 Technology Drive

Annapolis Junction, MD 20701

Information Assurance – pending ongoing clearance process;

Online training for C# and .NET framework technologies for near future use.

2007 – 2010

Software Engineer SR

L3 Communications

Air Force Research Laboratory

Mesa, Arizona 85212-6061

Near real-time simulation environments for pilot training. IEEE Standard Application Protocols under

Distributed Interactive Simulation (DIS STD). Network Data Transfer over simulation networks; Extended

capabilities in MS Visual Studio and MS Access database; C/C++ and Visual Basic implementations.

PDU (Protocol Data Unit) development for exchange of network messages between simulation application environments and for data transfer over simulation networks.

Win32 environment GUI development pertaining to aircraft exercise simulation/display in near real-time.

Java Messaging Service (JMS) for passing data Topic Messages between legacy C and Java applications.

2006

Software Engineer SR (contract with CPI)

General Dynamics

8201 E McDowell Road

Scottsdale, Arizona 85257

MUOS Project employing Ericsson WCDMA UMTS technology.

Involved directly in the team efforts in detailed design phase, under the RoseRT model,

leading to modifications of base design, C++ and Java implementation, and testing using CADE tools.

1997 - 2005

Software Engineer SR;

Lockheed Martin Integrated Systems & Solutions

P.O. Box 85

Litchfield Park, Arizona 85340

Significant proficiency with the following tools over more than nine years:

C++; Standard Template Library; Perl; Java; Have significant involvement with web page development using HTML, Cold Fusion, Perl scripting, and Java/JSP.

Involved in application of Object Oriented Analysis and Design (OOAD) principles to the

full development cycle including analysis, design, implementation, and testing of software in the

UNIX environment under Configuration Management using ClearCase tools. Experience with Rational

Rose, UML, RUP, Design Patterns, SEI CMMI level 5 process.

Extensive experience in the maintenance, analysis, and SPARR (Software Problem Analysis

and Resolution Report) process on complex software systems, including the implementation of upgrades and major enhancements to functionality, which involves processing and distribution of new products to the end user. Processing of satellite imagery data end-to-end.

Participated in a team effort to write FORTRAN 90 vector processing software for SAR (Synthetic Aperture Radar) data using multiple parallel processing on the Crays, and to unit test and regression test such code.

Database(Oracle & Sybase) transactions(SQL) and maintenance/enhancement of classified web page for product imagery data.

Implemented the simulation of data stream processing involving multiple threads for concurrent input paths, followed by threaded input to hardware devices capable of DMA transfer of raw data into the system front-end; and finally to the archiving of raw input data. In this case, real time capture, transfer and archiving of raw satellite data is accurately simulated. Java HMI implementation as front end to

such simulation tools using Java Swing.

Maintained and enhanced a file management system to monitor incoming files, set links, extract metadata, set permissions, and update database tables with metadata. Perl scripts were written to manage aging of files and database information in a systematic way.

Related work includes the integration of specialized algorithms for post processing in order to generate enhanced products for the end user; image registration for target recognition; simulation of a broadcast server interface; and a high speed file transfer simulator for large files.

1992 - 1995

Manager – Instrumentation Facility – NMR Spectroscopy;

University of Arizona

Tucson, Arizona 85721

Management role involved in all aspects of Shared Instrumentation Facility management. Provided researchers with access to advanced instrumentation, research collaboration and training. Work included user training, collaborative research, electronic maintenance, calibration, and new applications development. Was also primarily responsible for acquisition of new hardware and software and system administration of front-end Unix instrument-controllers/workstations for design and implementation of experiments involving radio frequency spectroscopic analysis of materials through digital data acquisition /processing. Developed embedded C code for the pulse programmers on several commercial instruments for NMR spectroscopy. Supervised one professional and numerous student employees during that time period.

1989 - 1992

Research Fellow-chemistry: NMR Spectroscopy;

Colorado State University

Fort Collins, Colorado 80523

Engaged in basic research in solid state chemistry and chemistry of materials, utilizing Solid State NMR (Nuclear Magnetic Resonance) Spectroscopy as the primary tool. Laboratory digital data acquisition and

processing employing pulsed Fourier Transform methods. Numerical computation in FORTRAN and C was carried out in order to simulate, from basic principles, the behavior of multiple spin systems in solid materials and surfaces. Findings were published in the peer reviewed literature as appropriate.

Educational Background

BS Chemistry & Biochemistry

PhD Biophysical Chemistry

University of Pittsburgh



Contact this candidate