Senior Oracle Database Developer

*

John J. Huang

Address: ***** ****** **** *******, *********, MD 20850

Phone: 240-***-**** Email: ****.*****.****@*****.*** Citizenship: United States Citizen Clearance: Public Trust / Eligible for High-Level Federal Clearance PROFESSIONAL SUMMARY

Dynamic IT professional with over 20 years of diverse experience in Information Technology, specializing in system architecture, system analysis, database design, data modelling, Object Oriented programming, database management, and performance optimization across various operating systems, including Windows, OpenVMS, UNIX, and Linux. Strong background in financial management systems and data integration.

• Web Portal and Database Development: Proficient in Oracle jDeveloper/ADF (11g/12c/19c), Forms/Reports

(6i/9i/10g/11g/12c/19c), SQL, PL/SQL, APEX 24, JSON with Apex REST Webservice, Java, JavaScript, JSP, JSF, HTML, CSS, XML/SOAP, PHP, MySQL, JMS, Pro*C/C++ (OCILIB), Unix Shell Scripts, and Python.

• Data Integration & Performance Optimization: Extensive experience in SQL*Loader, developing Oracle Stored Procedures, Functions, Packages, Triggers, and Materialized Views. Skilled in Data Modeling Design, performance tuning (Oracle Explained Plan, AWR, ASH, and ADDM reports) and ETL processes to enhance data flow and system efficiency.

• Administration & Installation: Strong background in installing and configuring Oracle Database (19c/21c), jDeveloper 19c, SQL Developer, Oracle REST Data Services 24.3, and Visual Studio 22 on Windows platforms.

• Additional Technologies: TOAD, SVN, PVCS, Visual Basic, MS SQL Server, MS Power BI, Data Warehousing, JCL, and FOCUS.

• Project Leadership: Successfully led full lifecycle project implementations at NIST, including analysis, functional and technical design, implementation, testing, user training, and documentation. Adept at collaborating with cross-functional teams to ensure project goals are met. WORK EXPERIENCE

Senior Oracle PL/SQL, APEX Developer

JA International, Inc., Rockville, MD December 2024 – December 2025 Environmental Protection Agency (EPA), Washington D.C. Designed and developed enterprise data collection, validation, and reporting applications supporting multiple national water infrastructure surveys, including the Drinking Water Infrastructure Needs Survey and Assessment, Clean Water Needs Survey and Assessment, and American Indian and Alaska Native Village Drinking Water Infrastructure Needs Survey and Assessment, using Oracle PL/SQL, XML DB, Oracle APEX 24, HTML, JavaScript, jQuery, CSS, Oracle Database 19c, Oracle Internet Directory (OID), Oracle Single Sign-On (SSO), Excel

(VLOOKUP, Macros, Data Validation), AWS Cloud RDS and Jira.

• Developed Oracle APEX applications to support survey data collection, validation, reporting, and analytics.

• Developed dynamic reports by passing dynamic SQL or user-selected tables/columns, and enabled email delivery of PDF and Excel report attachments.

• Designed XML Schema Definition (XSD) structures and developed PL/SQL packages to generate, parse, load, and validate XML data from Excel source files.

• Developed PL/SQL packages to extract, validate, and load data from multi-sheet Excel workbooks into Oracle database tables.

• Implemented Excel upload and download functionality with comprehensive validation of column names, formats, and values, including robust error handling and data integrity checks.

• Created drill-down forms, reports, and analytical dashboards to facilitate data review, analysis, and reporting. 2

Senior Oracle PL/SQL, APEX, Forms/Reports & Java Developer JA International, Inc., Rockville, MD May 2016 – July 2024 CBS Solution Center, Department of Commerce (DOC), Gaithersburg, MD

• DATA Act System: Developed the DATA Act Broker System to standardize data formatting and facilitate reporting agencies’ data submissions. Leveraged Java, Oracle APEX, PL/SQL Packages, Package/Scheduler/Chain, and External Tables to provide normalized DATA Act files (A, B, and C) for submission to the Treasury. Developed dynamic reports, and Interactive Reports & Forms in Oracle Apex.

• Voucher Interface: Designed and maintained the Voucher interface between the Commerce Business System

(CBS) Core Financial System (CFS) and the GSA’s E-Gov Travel Service (ETS2) using Java, Oracle PL/SQL, XML DB, Oracle Internet Directory (OID), Oracle Single Sign-On (SSO) and Oracle Database (11g/12c/19c).

• Core Financial System (CFS): Developed and supported the Commerce Business System’s CFS utilizing Oracle Forms/Reports (11g/12c/19c), PL/SQL, Oracle Internet Directory (OID), Oracle Single Sign-On (SSO), Java, Unix Shell Scripts, and advanced database features like External/Nested Tables, Pipelined and Parallel Table Functions, and Bulk Collection. Delivered diagnosis, design solutions, and technical assessments for issues raised by NIST, NOAA, and the Census Bureau.

• Oracle Forms/Reports Migration: Actively participated in the migration of Oracle Forms/Reports from 11g to 12c and from 12c to 19c, ensuring smooth transitions and minimal disruptions.

• Business Process Re-engineering Documentation: Contributed to the CBS Business Process Re-engineering Design documentation, helping streamline operations and improve system efficiency. Senior Oracle ADF, Java & PL/SQL Developer

JA International, Inc., Rockville, MD August 2015 – March 2016 Federal Emergency Management Agency (FEMA), Department of Homeland Security, Washington D.C Procurement Financial Interface (PFI) Development:

• Interface Development: Developed the Procurement Financial Interface (PFI) to connect FEMA’s Financial Management System (IFMIS) with Service-Oriented Architecture (SOA) Financial Services (SFS). This interface records commitments, cancellations, and obligations related to critical acquisition actions using technologies such as SOAP, XML, WSDL, SSL, JIRA and UTL_HTTP, along with Oracle PL/SQL and Unix Shell scripts.

• Data Processing and Formatting: Implemented business rules to process data from the Procurement Information System for Management (PRISM). Formatted and transmitted data to SFS as XML messages, while efficiently receiving, parsing, and saving XML data from SFS into the Oracle Database (11g).

• JMS Response Listener: Developed a PFI Listener that monitors the Oracle JMS Response Queue for incoming messages. This component parses XML responses and updates the PFI database accordingly, ensuring seamless data integration and accuracy.

Oracle ADF, Java, Web Application Developer

JA International, Inc., Rockville, MD December 2013 – August 2015

• Comprehensive Retail Application: Developed a robust retail application for supermarket stores in Argentina, encompassing Inventory Control, Order Control, Payment, and Administration Systems. Utilized Oracle jDeveloper 12c (ADF), Oracle Database 12c, PL/SQL, Java, JavaScript, CSS, JAX-WS/SOAP/XML, JSP, JSF, Hibernate, Struts, and HTML to deliver an integrated solution.

• B2B E-Commerce Platform: Created a B2B platform enabling wholesalers and supermarket stores to manage daily online orders efficiently. Leveraged Java, JavaScript, jQuery, PHP, CSS, HTML, and MySQL in a J2EE architecture. Provided administration support for the MySQL database and email server, ensuring seamless operation and user experience.

• System Architecture & Security: Delivered system architecture planning and enhancements focused on security, performance, and longevity. Made hardware/software and networking solutions to optimize system reliability. 3

Oracle ADF, PL/SQL, Forms, Java, C++ Developer

JA International, Inc., Rockville, MD September 2009 – November 2013 Census Bureau, Suitland, MD

System Architecture and Oracle Support Services for Economic Programming Division (EPD), Micro Analytical Branch

• Flag Analysis System (Oracle ADF 11g):

Converted the SAS report system into an Oracle jDeveloper 11g / ADF Faces application, utilizing Oracle WebLogic Server, ADF Business Components, Dynamic Tables, Java, JavaScript, JSF, Oracle Internet Directory (OID), Oracle Single Sign-On (SSO) and PL/SQL procedures to replicate SAS functionality.

Designed interactive screens and provided multiple report formats, assisting clients in finalizing front-end designs. Implemented a daily batch process in PL/SQL stored packages and utilized TOAD and Subversion for development.

• EconDD/Recon (Oracle ADF 11g):

Transformed a Visual Basic 6 application into an Oracle ADF 11g application. Developed JSF pages using Oracle ADF Dynamic Table technology, creating Dynamic View Objects to minimize code inconsistencies due to version changes.

Enhanced integration with the 2012 EconDD and Recon systems by employing dynamic SQL statements for data retrieval and filtering, as well as implementing page breakdown capabilities to manage large data sets effectively.

• Commodity Flow Survey (CFS) (Oracle Forms 11g):

Collaborated with the Census Bureau and the Bureau of Transportation Statistics on the CFS, conducted every five years. Implemented new requirements for the CFS Interactive System, including layout and functional changes, as well as modifications to database triggers.

Analyzed and resolved front-end and back-end issues, including stored procedure optimization, and provided enhancements for User Access Privilege Management.

• 2012 and 2017 Architecture Proof of Concept (POC):

Participated in the Prove of Concept project, delivering technical support using Java, JavaScript, JSF/JSP, EJB/JPA, Spring Framework, JBOSS, and Oracle jDeveloper 11g to build prototypes.

• Foreign Direct Investment (FDI) Redesign:

Redesigned and implemented the FDI application in Oracle Forms 11g, facilitating investments by foreign companies into local production and operations.

• C++/Pro*C++ Application Development:

Developed C++/Pro*C++ applications based on significant design changes for 2012, including Pre-Edit Conversion, Model Record Selection, and Model Record Imputation modules. Oracle Forms & PL/SQL Developer

JA International, Inc., Rockville, MD March 2008 – August 2009 National Institute of Standards & Technology (NIST), Gaithersburg, MD Oracle Support Services for Core Financial System (CBS):

• Project Overview: Provided Oracle support services for the Business System Division operating the Core Financial System (CBS) through a secure portal, co-sponsored by NIST, the International Trade Administration (ITA), and the Department of Commerce Business Systems.

• Secure Architecture Development: Collaborated with the Integrated Analytical Team to define and implement a secure architecture for the CBS portal. Analyzed, designed, and developed the ITA CBS Implementation system, facilitating the import of daily overseas financial transactions from the Department of State (DoS) into CBS via Oracle Portal.

• Technical Implementation:

Developed the portal using Oracle Developer Suite 10g (Forms/Reports) and OC4J. Employed SQL*Loader and UNIX Shell scripts for efficient data exchange and bulk data loading.

Tuned SQL queries, optimized indexes, and configured Oracle SGA to enhance report performance for ITA, leveraging LDAP OID for improved security and efficiency. 4

• Risk Mitigation and Testing: Conducted thorough risk assessments and regression testing to ensure system stability and compliance with CMMI Level 3 standards, delivering secure and reliable solutions.

• Oracle Forms/Reports Migration: Actively participated in the migration of Oracle Forms/Reports from 9i to 10g, ensuring a smooth transition and minimizing disruptions. Oracle PL/SQL, Forms/Reports Developer

JA International, Inc., Rockville, MD January 2006 – January 2008 Veterans Benefits Administration (VBA), Department of Veterans Affairs, Rockville, MD Development and Support of VBA VETSNET Financial & Accounting System (FAS):

• System Development: Developed and supported the Multi-Tier Financial & Accounting System (FAS) and Compensation and Pension/Awards applications using Unix Shell Scripts, PL/SQL, and Oracle Reports 9i. Utilized tools like Serena Dimensions CM 10.1.1, Rational ClearQuest, and Rational Rose for project management.

• Architecture Implementation: Implemented C++/RWTools with TUXEDO Transaction System Architecture for the middle tier, effectively managing business rules. Handled front-end requests through Visual Basic/Access, while interfacing with the Oracle PL/SQL for query/result manipulation via stored procedures on SUN/Solaris.

• Customer and Team Collaboration: Engaged with customers and team members in St. Petersburg, FL, to review functional requirements, develop technical design documentation, and conduct integration testing. Used Rational Rose/UML for design specification updates and ClearQuest for defect management, along with Dimensions CM for source code and requirements access.

• Database Administration Support: Supported database administration activities in a UNIX development environment, including installation and validation of applications, tables, views, triggers, stored procedures, and application code. Managed daily and monthly batch job scheduling using UNIX Shell scripts and cron jobs. Oracle Forms & PL/SQL Developer

JA International, Inc., Rockville, MD July 2004 – January 2006 Oceanic and Atmospheric Administration (NOAA), Department of Commerce, Gaithersburg, MD Data Warehouse Applications Development and Maintenance:

• Data Warehouse Project Development: Developed and supported a Data Warehouse project utilizing Oracle 9iAS Discoverer, Forms/Reports 6i, Oracle Web Application Server, and Unix Shell Scripts. Created and maintained Data Warehouse reports in Oracle9iAS Discoverer, refreshed PL/SQL stored routines, and implemented materialized views and indexes.

• Report Development: Designed and developed a variety of reports related to Budget, Accounts Receivable, Accounts Payable, Expense, Labor, Personal Property, Reimbursement, Cost, and the Core Financial System

(CFS) using Oracle Forms/Reports 6i.

• Oracle Migration: Contributed to the migration of Oracle Forms/Reports from 6i to 9i. National Institute of Standards & Technology (NIST), Department of Commerce, Gaithersburg, MD Group Leader / System Analyst, Oracle PL/SQL, Forms/Reports, E-Business Suite Developer Core Financial System (CFS) for the Implementation Center, DOC, Gaithersburg, MD JA International, Inc., Rockville, MD March 2001 – December 2003 Expert Choice, Inc., Gaithersburg, MD October 1999 – February 2001 International Technology, Inc., Gaithersburg, MD April 1997 – September 1999

• Upgraded Oracle Financial Applications to Oracle E-Business Suite Financial Management (Fixed Assets) Version 11i and converted customized Oracle Forms, Reports, Alerts, PL/SQL procedures and Unix shell scripts.

• Responsible for deploying, customizing, maintaining, and supporting the Property Management Systems using Oracle E-Business Suite, Oracle Financial Applications, Oracle 7/8 RDBMS, Oracle Alerts, Oracle Web Server, HTML, Oracle Forms 4.5/5.0/6.0, Reports 2.5/3.0/6.0, Business Objects, SQL*Loader, and Smart DB on UNIX and Windows 95/NT.

• Participated in the CFS Oracle Forms/Reports migration from 3.0 to 4.5, 4.5 to 5.0 and 5.0 to 6i. Developed CAMS/CBS (Commerce Business System) related interfaces at NIST 5

• Developed Web-based NIST Bank Card Auto Loading System, Bankcard Invoices Load System, Automatic Cardholder Load System, Vendor Lookup System, Customer Lookup Interface, CSTARS Interface, Payroll Detail Report (GUI & Character Modes), GUI File Upload Interface, Resources Scheduler, Security Information System, User Account Management System, and User Account Password Expiration Notification System in Java/JavaScript, FTP Control, Oracle Web Application Server, Developer/2000, Forms/Reports 6i, Oracle Job, SQL*Loader, and PL/SQL stored procedures.

• Developed the Automatic Payment System in Oracle Forms 3.0, Forms 6i, and FTP process in UNIX Shell scripts and TCL script.

• Conducted life-cycle design of the web-based Automated Cost Center Title File Initial Markup (CCTF) project using Oracle Forms 6i, Reports 6i, Navigator menu, and SQL*Loader.

• Developed intranet-based PO Scanned Images Management System using Java/JavaScript, Oracle Web Server, HTML, PL/SQL, Oracle Forms 6.0, and Oracle Designer/2000.

• Developed NFC Time and Attendance File Transmission System under UNIX environment using Oracle PL/SQL, and SQL*Loader.

• Converted and developed Reports of CFS using Oracle Designer/2000, Developer/2000 (Forms 4.5, Reports 2.5), Oracle Forms 3.0, and SQL*Report on UNIX, VMS, and MS Windows 95/NT. Senior Systems Analyst & Programmer (Prior Career History)

• Federal Deposit Insurance Corporation (FDIC) (Aug 1996 – Jul 1999): Converted the agency's Separation Incentive Tracking System from Forms 3.0 to 4.5. Developed Supplemental Income and Child Care payment applications using MS SQL Server and Visual Basic 5.

• U.S. Environmental Protection Agency (EPA) / Office of Mobile Sources (Jan 1993 – Jul 1996): Designed the Certification and Fuel Economy Information System (CFEIS) using Oracle 7, Forms 4.5, Reports 2.5, PL/SQL, Pro*C, and UNIX.

• Federal Aviation Administration (FAA) / Volpe Transportation Center (1993 – 1996): Re-engineered the Aeronautical Information Subsystem (AIS) and US Notices to Airmen System (USNS) utilizing Oracle Case 5.1 and Designer/2000 for data modeling, and PL/SQL, Pro*C, Forms 4.0/4.5, and Reports 2.5.

• NASA Headquarters (1993 – 1996): Managed the conversion of central financial applications

(Reimbursable 506, Direct 506, Cost/Operating Plans) from MS-DOS to secure client/server environments using Visual Basic, C/C++, and SQL Server. Led data migrations from INGRES to Microsoft SQL Server.

• USDA Federal Crop Insurance Corporation (FCIC) (Jan 1992 – Dec 1992): Orchestrated historical data analysis mapping hierarchical FOCUS databases into new relational Oracle schemas using MVS/ESA, JCL, TSO/ISPF and CASE tools Application Development Workbench (ADW).

• University of Maryland / Office of Institutional Research (Jan 1991 – Jan 1992): Provided programming support for complex academic research projects utilizing IMAGE/HP network databases, QUIZ, and SUPRTOOL engines.

EDUCATION/ CERTIFICATE/AWARD

• M.S. in Computer Science – University of Maryland, Baltimore County (UMBC), MD 1992 Thesis Focus: Encoding Algorithms and Memory Capacity Analysis for Bidirectional Associative Memories (Artificial Intelligence – Neural Networks)

• B.S. in Mathematics – National Cheng Kung University Tainan, Taiwan 1986

• Certificate of Appreciation – DOC, FDIC, NIST.

• Distributed Development on the World Wide Web, Johns Hopkins University, May 1997

• Data Communication and Network System, Johns Hopkins University, Dec. 1996

Contact this candidate