Daniel Adams
Sr. Programmer/Analyst Developer
301-***-**** - zip 21701
**********@****.***
FUNCTIONAL SKILL AREAS
Programmer/Analyst, Systems and Database Design, Web Development, Testing, Data Conversion, Systems Documentation.
SKILLS
Operating Systems:
Windows 10, Linux, Windows 2000, SunOS 5.8, NT, MS-DOS, MVS.
Software Languages:
Java, Typescript, JSP, PrimeFaces JSF, PL/SQL stored procedures, MS Visual Basic and T-SQL, VBA, XSLT, VBScript, HTML, JavaScript, CSS, ASP.NET, Pro*C, C.
Tools:
Angular 8, NodeJS, Bootstrap, Robo3T 1.1, Amazon Web Service (AWS), NetBeans, SQL Developer, Spring MVC, Hibernate JPA, Jaspersoft Studio BI, Cognos, TOAD, WebLogic, SQL*Plus, Tomcat, Oracle Warehouse Builder, Informatica, Ant, subversion, Oracle Forms, eclipse, XMLSpy, Oracle Applications, Oracle Designer, SQL*Loader, Unix shell scripts, MS Excel, ftp, PuTTY, vi, JSON, ClearCase, DevOps practices and development tools and services such as JIRA/Confluence, Version Control (git, svn), and CI/CD pipelines, vue.js.
Database Systems:
MongoDB, Oracle 19c, 12c, 11g,10g, 9i, 8i, ExaData, SQL Server, MySQL, PostgreSQL, MS Access, dbase III, and IBM System 2000.
TECHNICAL EXPERIENCE / GENERAL QUALIFICATIONS
Summary:
Over 20 years of experience in analysis, software design, development, implementation and documentation of computer systems.
All phases of database conversion using relational database management systems for statistical and office automation applications with a concentration in Oracle RDMS for over 20 years and PL/SQL for more than 20 years. Extensive work with numerous databases including MongoDB, MySQL, PostgreSQL and SQL Server and including these tools: Oracle Forms, and PL/SQL and T-SQL stored procedures.
Web-based application development using J2EE, HTML, APEX, JSF, VBScript, JavaScript, VB.NET and ASP.NET.
Client-server application development using PL/SQL and SQL*Plus tools in numerous environments and platforms.
Skills in data warehouses ETL, reports and documentation.
PROFESSIONAL EXPERIENCE
Company:
Softworld (U.S. DoD)
Position:
Java/J2EE/Oracle Developer. 12/2022 - Present.
Job Descriptions:
-Worked on changes to several existing systems.
-Enhanced a DoD Sharepoint web site by refining calculations in a number of reports.
-Created a web page with edit and reporting features using APEX from spreadsheet data.
-Created an Oracle Pre-Insert trigger for data verification.
-Revised the Java code for an API in the JIMS application.
-Resolved a maven build in an AWS EC2 evironment to produce data analytic reports.
-Attained the Security+ CE certification.
-Tools used were Java 11, Sharepoint, Splunk, Zeppelin, Spark.
-APEX 19.2, Oracle 19c.
-The environment: HTML5, Jira and git, Agile SAFe methodology.
-
Company:
Lockheed Martin (U.S. Navy)
Position:
Java/J2EE/Oracle Developer. 10/2021 – 11/2022.
Job Descriptions:
- Involved in work for the rotary wing flight division, converting an Oracle Forms/Reports, Oracle 19c DB helicopter maintenance application to HTML and Node.js changing Oracle Forms screens to HTML and using Typscript, PDFMake and PostgreSQL to change Oracle Reports.
-Converted 2 Oracle views to PostgreSQL and also altered the queries of 3 PL/SQL stored procedures to enchance performance.
-Developed and modified classes for entities in C#.
-Worked on central applications for the Navy Weapons Command.
-Created a date component in vue.js
-Tools used were Java, JSP using eclipse with Tomcat, PostgreSQL and MySQL, Hibernate-5, Workbench 8.0 27 using stored procedures and queries also Visual Studio 2019, .NET 4.5, Angular 8, Nodejs, and TypeScript, Entity Framework, LINQ, vue.js.
-The environment: HTML5, Jira and git, Agile SAFe methodology.
Company:
Insight Global (DEA) – Leidos was Prime
Position:
Java/J2EE/Oracle Developer. 02/2021 – 10/2021.
Job Descriptions:
-Enhanced Java web applications and reports for DEA’s main operations.
-Made enhancements to existing Javascript used for monthly reporting.
-Created and enhanced xml config files.
-Made modifications to a group of Oracle functions.
-Tools used were Java with eclipse, ant, JSF along with Team Foundation Server for version control and Oracle 19c DB with TOAD for stored procedures and queries..
-The environment: SpringFrameWork-5, Tomcat and Glassfish, HTML5, Agile SAFe methodology. Initiated a end to end course-management system with a restful api using Spring Boot with a controller, a data layer, and a service layer.
Company:
Barbaricum Inc. (U.S.Army)
Position:
Java/J2EE Developer. 10/2020 – 02/2021.
Job Descriptions:
-Enhanced Army National Guard Web applications for projects and their requirements.
-Upgraded JSP files by calling Telerik functions for a more responsive UI and similar rendering between a number of applications.
-Updated backend processes to Hibernate-5.
-Tools used: Java, Hibernate-5, Telerik, JSPs, jboss, maven, git, VersionOne.
-The environment: SpringFrameWork-5, HTML5, SAFe methodology.
-Created and enhanced front-end java controllers, JSPs with .tag files using, IntelliJ IDE.
Company:
Agensys Corporation (U.S.Army)
Position:
Angular/Java/J2EE Developer. 02/2020 – 08/2020.
Job Descriptions:
-Enhanced the Real Property area of the Logicole Army Medical Logistics Web application for construction projects and their requirements.
-Created and enhanced front-end HTML components using bootstrap, IntelliJ IDE.
-Used card containers to create web pages checkbox/radio functionality, input text fields, drop-down fields, etc.
-Created and enhanced typescript files for views, services and models.
-Directed screen process flow for Edit, Save and Cancel buttons using ngIf's and method calls in the HTML components.
-Used Robo 3T to make queries and add or insert JSON data to MongoDB.
-Developed and tested back-end Restful APIs - endpoints, servers, and DAOs using Java, Swagger and Chrome debugger.
-Tools used: Angular 8, Nodejs, Java, TypeScript, Robo3T 1.1, jboss, maven, git, Jira.
-The environment: HTML5, Bootstrap, MongoDB 4.2, SAFe methodology.
-
Company:
Zachary Piper (TSA)
Position:
Java /J2EE Developer. 08/2019 – 02/2020.
Job Descriptions:
-Maintain, analyze, and enhance JavaScript and J2EE Spring Controllers, Service Layers, SessionBeans and DAO applications.
-Modifications to front-end UI and Java methods.
-IBM Rational Tools used in the environment: HTML5, RAD, DB2 Data Studio, Java, JavaScript, WebSphere, Jenkins, git, Struts.
-SAFe methodology.
Company:
SkyePoint Decisions (CBP)
Position:
Mid Java/J2EE Backend Developer. 09/2018 – 04/2019.
Job Descriptions:
-Maintain J2EE Spring MVC Maven built applications and analyze Java Restful Web Services to trouble-shoot query issues. Develop automated testing with Selenium and Excel.
-Modifications to front-end UI for services and Oracle Stored Procedures.
-Tools in the Linux environment PuTTY, PL/SQL, SQL*Developer, Eclipse,, Maven, JavaScript, Sonarqube and Selenium.
-WebLogic – used the application server to deploy and run applications to the development and the test environments. Integrated the application with the Oracle database. Used WebLogic to expose and monitor Restful APIs.
Company:
Trillion Technology Solutions/DSFederal Inc. (U.S.Army)
Position:
Java/J2EE Developer. 08/2017 – 08/2018.
Job Descriptions:
-Coordinated with development teams during various SDLC stages.
-Worked on a Amazon Web Service (AWS) EC2 platform with these tools: J2EE using Eclipse, Spring MVC code for web services, Oracle and PostgreSQL databases. The effort was for an enterprise Army system that coordinated web services between numerous installations for equipment tracking. This effort was also a major conversion of the centralized Oracle database Tables, Stored Proceedures, Triggers, Views, etc to a cloud-baseed PostgreSQLdatabase.
-Created several databases on an Exadata Database Service.
-Data Pump – loaded data to an Exadata Cloud database.
-Also used these tools: PuTTY, Javascript, SoapUI in testing web services. Jira for sprints, Fortify, SourceTree with Bitbucket Repository.
-Developed Crystal Reports and Jaspersoft Studio BI 6.3 reports using Oracle 12c imbedded queries, SQL Developer and hands-on Clarity tools to implement input screens and XOG to import data.
-Administered the Oracle database and wrote technical documentation.
-Developed an ASP.NET web application using Visual Studio 2010 and C# for the web forms.
Company:
Global Consulting International (GCI) (U.S.DOE)
Position:
Java/J2EE Developer. 10/2015 – 06/2017.
Job Descriptions:
-Made enhancements and new developments to the CAIS and FIMS systems. Both Dept. of Energy systems are J2EE and Spring MVC web based. Developed screen interfaces with PrimeFaces 6.1 Java Server Faces (JSF) components and extending their features to create custom components by extending the UI Component class and also to create custom converters and custom validators, using the NetBeans IDE 8.2, and the Apache Tomcat 8.5 tools and Maven.
-Scripted various changes and enhancements to the backend Oracle 12c database.
-Designed numerous PL/SQL procedures, functions and triggers.
-Enhanced and created reports using Jaspersoft Studio BI 6.3 and imbedded SQL.
-Wrote a utility using SQL*Plus routines to determine if existing ad hoc queries are still relevant.
Company:
ACGI (Commercial)
Position:
Database Engineer. 04/2015 – 10/2015.
Job Descriptions:
-Enhanced web pages and reports in APEX 4.2.1 and also made code changes using TOAD as the IDE for PL/SQL's 'htp.' commands. Additionally, made query and logic modifications within packages in an Oracle 11g environment.
-Developed and enhanced PL/SQL stored procedures, functions and also triggers which were called from APEX or used within the web-based Association software.
-Used PVCS for version control on a Unix platform setting release tags and verifying file changes for packages. Agile/Scrum environment. Jira.
Company:
Clinical RM Inc. (U.S.Army)
Position:
Sr. Programmer/Analyst Developer. 04/2013 – 03/2015.
Job Descriptions:
-Developed in Oracle Central Designer within an Oracle 11g environment - protocols for projects with studies (clinical trials), workflows, input forms, repeating forms, items, conditional items, repeating sections, rules and code lists. Set up users with their rights and roles. Used WebLogic for a deployment and system monitoring tool with Oracle Central Designer.
- Used InForm in assisting data entry personnel working with clinical data by testing forms, resolving queries, and running standard reports.
-Worked in the SIRS system running in Omnicomm EDM/EDC by making enhancements to protocols, resolving user issues, and generating reports.
-Completed Central Designer, InForm/Cognos, and Omnicomm EDM/EDC Training.
- Used the Cognos product - InForm/Cognos to design data input forms used in Clinical Trials to gather input about subjects participating in the trial.
-Used the Cognos BI tool - Report Studio and Jaspersoft BI 6.3 reports to generate statistical reports from data that was collected in the Clinical Trials.
-Enhanced the 16,000-line Budget Tool/ Chargebacks System written in PL/SQL. Converted the Medical Division Invoicing System from an MS Access/Oracle system to QuickBooks.
Company:
Macro Solutions Inc. (NSA)
Position:
Java Programmer Developer/Jr. DBA. 07/2012 – 04/2013.
Job Descriptions:
-Developed enhancements with J2EE JDK 1.6, eclipse IDE and Oracle 11g in a Linux environment and Selenium testing and hibernate mapping used for writing to the database for the eQip personnel system designed to facilitate the processing of standard investigative forms used when conducting background investigations.
-Generated client stubs using XSDs for a RESTful Web Services that expected an authentication token written in J2EE used to retrieve menu items. Agile/Scrum environment.
-Installed Oracle 11g on a windows 7 platform with OUI and wrote the documentation for the java developers to perform that task on their workstations.
-Installed Oracle 11g on a Linux platform using DBCA.
-Created tablespaces, roles, synonyms and users. Ran grant scripts and altered database objects for specific eQip application needs.
-Used Oracle data pump to load the initial data into the 30 tables for the eQip application and to back up the data after the developers had added a large amount of test data.
-Wrote DDL and DML scripts to customize the eQip application's database for the agency's requirements.
-Wrote database stored procedures in PL/SQL to customize JDBC calls for retrieving specific rows for Selenium tests.
-Worked with the senior DBA to troubleshoot why tables were locking when trying to delete a row. Determined the database needed to be rebooted when the application was rebooted.
-Performed startups and shutdowns of the Oracle databases.
-Worked with the senior DBA in backing up the Linux database.
-Worked with the senior DBA in resolving space issues and moving the Linux database off of the root file system.
-Installed Oracle SQL Developer and mentored java developers in its use to assist in application testing.
-Installed Oracle Data Modeler for analysis of the eQip application schema.
Company:
Vector Planning Services, Inc. (VPSI) (U.S.Army)
Position:
Java/J2EE Developer. 09/ 2011 – 07/2012.
Job Descriptions:
-Developed input screens using xhtml, JSP, JavaScript, ExtJS
-Converted PL/SQL stored procedures and triggers to PL/pgSQL
-Developed a database schema in PostgreSQL and queries using JDBC for the DoD Enterprise Email system using both windows and Linux in a VMware platform.
-Analysis, documentation and enhancements to the Defense Information Systems Agency (DISA) Joint Incident Management System (JIMS) RESTful Web Services which were written in J2EE JDK 1.6, Spring MVC Framework, using Maven and Ant to create builds, Tomcat used as a development test server, eclipse IDE unit tests were performed with SoapUI and PostgreSQL as the backend database, subversion version control and jaxb used to create XML files. The LDAP server is used for authentication and XSDs for XML data files.
Company:
Municipal Securities Rulemaking Board (MSRB). (Commercial)
Position:
Oracle Database Developer. 08/2010 –09/ 2011.
Job Descriptions:
-Developed enhancements to the MSRB billing system and the EMMA web-based system using PL/SQL in Oracle 10g and 11g. Performed tuning of ad hoc queries to increase performance. SQL-Developer. Agile/Scrum environment.
-Worked with C# developers by writing PL/SQL stored procedures which they utilized from the EMMA application to perform queries and data manipulation.
Company:
L-3 Communications/Inmedius. (U.S.Navy)
Position:
Java and Visual Basic Developer. 05/2006 – 08/2010.
Job Descriptions:
-Maintained and added features to the Mobile Field Kit (MFK) application using Java with the eclipse IDE and MySQL database. Written in Java 1.6 and MySQL with Hibernate JPA, the MFK is used by soldiers for gathering and reporting information in the field. Also, maintained and added features and screens to the portal version of the MFK corresponding web application using J2EE JDK 1.6, JSP, JavaScript, ant, Tomcat, ibatis sql maps, subversion version control.
-Developed, designed and maintained VB.NET code revising and creating functionality to existing screens along with new screens and data input processes. Created T-SQL stored procedures in the SQL Server database and XSLT scripts for developing reports and transforming incoming data for the Convoy Planning Tool (CPT) application.
-Developed screens and VBA scripts in MS Access for the De-Confliction application.
-Replaced embedded SQL with PL/SQL Stored Procedures in Oracle, maintained Active Server Pages with VBScript and JavaScript to support the Reserve Component Automation System (RCAS) system.
Company:
C.A.C.I. (U.S.Army)
Position:
Oracle Developer. 2005 – 2006.
Job Descriptions:
-Developed software packages in Oracle 10g using Oracle Forms to create GUI forms along with PL/SQL programming language packages to support web-based architectures for the Congressional Appropriation Life Cycle System (ALICS) system.
-Tuning queries with explain plans, hint indexes, function-based indexes.
-Designed and developed schema components to include tables, views, indexes, constraints, and PL/SQL triggers using ERwin. Analysis to 3rd Normal Form.
-Converted portions of the existing ALICS system to VB.NET.
Company:
Computer Sciences Corporation (IRS)
Position:
Oracle Developer. 2000 – 2005.
Job Descriptions:
-Enhancement, maintenance and troubleshooting programs using Pro*C, C, SQL, PL/SQL, XML, SQL*Loader, Unix shell scripts, Sed and Awk routines in a Sun Solaris environment for the Electronic Fraud Detection System (EFDS)/Data Loads System for the Internal Revenue Service (IRS).
-Data Replication and tuning of processes for: Small Static Tables using Materialized Views and Logs, Distributed SQL, and Database Links. Small Dynamic Tables using update PL/SQL triggers and cron jobs for REFRESH FAST of SNAPSHOT.
-Tuning queries with explain plans, hint indexes, function-based indexes.
-Designed and developed schema components to include tables, views, indexes, constraints, and PL/SQL triggers using ERwin. Analysis to 3rd Normal Form.
-Conversion using Object Oriented Design (OOD) of an existing IRS system using Oracle Warehouse Builder and the Work Flow scheduler and Informatica, applying Extract Transformation and Load (ETL) techniques.
-Developed programs and executables for the U.S. Postal Service using Oracle Applications to web-enable systems using Forms 4.5, PL/SQL stored procedures and functions, SQL*Plus, SQL*Loader, and Unix shell scripts adding functionality to the existing object-oriented web-based general ledger/cash management SAFR system.
Company:
Synectics for Management Decisions, Inc. (HHS)
Position:
Sr. Programmer/Analyst Developer. 1989 – 2000.
Job Descriptions:
-Developed routines for the Dept. of Housing and Urban Development loading and converting data from legacy grants management systems into the Departmental Grants Management System tables using Unix shell scripts, PL/SQL, SQL*Loader, and web-enabled forms using Oracle Designer.
-Developed formatted reports, ad hoc queries, and performed data transformations for the Substance Abuse and Mental Health Services Administration (SAMHSA) using PL/SQL, Forms 4.5 and SQL*Loader, and Unix shell scripts in addition to formatting reports in MS Access. Developed the table and index schema for a data warehouse for the National Center for Education Statistics (NCES), U.S. Department of Education. Used Cognos to develop bar charts, pie charts, line charts, and area charts as statistical graphs showing relationships of facts compared to dimensions like time or location etc., displaying trends for educational data at local, state and national levels.
-Worked on a team for the Administration for Children & Families (ACF) - designed, developed, and implemented the Child Care Block Grant Automated System (CCBGAS). The system was developed in the MVS mainframe environment using SQL*Forms 3.0, Pro*COBOL and SQL*Plus, JCL, TSO.
EDUCATION
Academic:
Certificate in Information Technology/software design, Control Data Institute.
Attended a 5 day training for AWS Developer.
Attended a 5 day training for Agile SAFe methodology.
Certificate Security+ CE
B.A., emphasis in Information Systems / Music, Baldwin-Wallace University.
Professional:
PL/SQL coursework PGCC 2011.
Java Development, PGCC 2009.
Moving to Visual Basic .NET, Skillsoft, 2006.
Data Warehouse Principals, Smartforce, 2004.
Partitioning in Oracle Databases, Smartforce, 2003.
Oracle 9i New Features for Developers, Oracle Education, 2002.
ClearCase Training, IRS Training, 2002.
Oracle Designer Introduction, Oracle Education, 1999.
Advanced Oracle Forms, Oracle Education, 1990.
Relational Database Design, Oracle Education, 1987.
Advanced PL/SQL programming, Oracle Education, 1987.
ADDITIONAL INFORMATION
Notable:
Mr. Adams served as a violinist in the U.S. Army Band for many years in support of high-level government functions.
Security Clearance:
DOD Secret Clearance, DHS CBP Clearance, HHS Public Trust Clearance.