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.

SKILLS:

Database Systems: Windows 10, Linux, Windows 2000, SunOS 5.8, NT, MS - DOS, MVS.Angular 8, NodeJS, Bootstrap, Robo3T 1.1, AWS, NetBeans, SQL Developer, Spring MVC, Jaspersoft Studio BI, TOAD, WebLogic, SQL*Plus, Tomcat, Oracle Warehouse Builder, Ant, subversion, Oracle Forms, eclipse, XMLSpy, Oracle Applications, Oracle Designer, SQL*Loader, Unix shell scripts, MS Excel, ftp, PuTTY, vi, git, JSON, ClearCase.MongoDB, Oracle 12c, 11g,10g, 9i, 8i, SQL Server, MySQL, PostgreSQL, MS Access, dbase III, and IBM System 2000.

Operating Systems: Programmer/Analyst, Systems and Database Design, Web Development, Testing, Data Conversion, Systems Documentation.

Software Languages: Java, Typescript, PrimeFaces JSF, PL/SQL stored procedures, MS Visual Basic and T-SQL, VBA, XSLT, Java, JSP, VBScript, HTML, JavaScript, CSS, ASP.NET, Pro*C, C.

PROFESSIONAL EXPERIENCE:

Confidential

Java/J2EE Developer

Tools: used: Java, Hibernate-5, Telerik, JSPs, jboss, maven, git, VersionOne.

The environment: SpringFrameWork-5, HTML5, SAFe methodology.

Responsibilities:

• Created and enhanced front-end java controllers, JSPs with .tag files using, IntelliJ IDE.
• 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.

Confidential

Java /J2EE Developer

Responsibilities:

• 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

Confidential

Mid Java/J2EE Backend Developer

Responsibilities:

• 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.

Confidential

Java/J2EE Developer

Responsibilities:

• Coordinated with development teams during various SDLC stages.
• Worked on EC2 AWS servers with these tools: J2EE, Spring MVC code with Eclipse for web services, Oracle and PostgreSQL databases, PuTTY, Javascript, SoapUI in testing web services. Also used these tools: 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.
• Administered the Oracle database and wrote technical documentation.
• Developed an ASP.NET web application using Visual Studio 2010 and C# for the web forms.

Confidential

Java/J2EE Developer

Responsibilities:

• Made enhancements and new developments to the CAIS and FIMS systems.
• Both Confidential 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.

Confidential

Database Engineer

Responsibilities:

• 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.

Confidential

Sr. Programmer/Analyst Developer

Responsibilities:

• 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.
• 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.

Confidential

Java Programmer Developer/Jr. DBA

Responsibilities:

• 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.

Confidential

Java/J2EE Developer

Responsibilities:

• 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.

Confidential

Oracle Database Developer

Responsibilities:

• Developed enhancements to the Confidential 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.

Confidential

Java and Visual Basic Developer

Responsibilities:

• 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, 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.

Confidential

Oracle Developer

Responsibilities:

• 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.

Confidential

Oracle Developer

Responsibilities:

• 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, 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.