PROFILE:

• I am a respected Information Technology professional with the ability implement COTS solutions and improve business processes by conducting meetings, documenting business and functional requirements, designing, and then leading the development of in house frontend and database backend solutions.
• I have acted in these roles on a regular basis: Oracle developer, business analyst, systems analyst, database architect, technical architect, supervisor, manager, advisor, trainer, mentor, radar technician .
• Confidential Tax Advocate Cases, Enterprise Resource Planning (ERP), Nuclear Research, Transportation, Crash Safety, Bridge, Roads and Highways, Linear Referencing, GIS, Asset Management, Grants, Financial, Logistics, Supply, Contracting, Projects, Accountable Equipment Inventory, Shipping, Automated Data Processing Equipment (ADPE), and Project Funding.

SKILL:

• Rest and SOAP Web Services (JAVA)
• ETL
• SOA
• Relational DB Design
• Oracle JSF/ADF
• Warehouse DB Design
• Oracle Service Bus
• ERWIN
• Oracle XMLDB
• ERStudio
• Oracle Reports
• JSP
• Oracle Forms (3, 5, 6i, 9i, 10g, 11g, 12c)
• C
• Oracle Database (7, 8i, 9i, 10g, 11g, 12c)
• Unix (Solaris, FreeBSD, Linux, IBM AIX)
• Oracle Designer
• VMS
• Oracle WebLogic Server (11g, 12c)
• Unix scripting (tcsh, sh, korn, bash)
• Oracle Warehouse Builder
• PDF Forms utilizing Forms Data Format (FDF)
• Oracle Data Integrator
• XML, XSLT
• Oracle App Express
• JAVA
• Oracle Enterprise Manager
• Drupal
• Oracle Primavera SOAP API
• JQuery
• Oracle JDeveloper
• JavaScript
• Oracle SQL Developer
• ASP (VBScript, Visual Basic)
• PL/SQL, SQL
• XQuery
• HTML, CSS
• PL/SQL Web Toolkit
• MySQL
• Aquia Drupal Cloud
• Git, GitHub
• Apache
• Drush
• Google Maps API
• Powershell
• SoapUI
• REST
• Soap
• SQL Plus
• ERP
• MS SQL Server
• PHP

EXPERIENCE:

Confidential

Oracle Developer/Business Analyst/Data Architect

Responsibilities:

• Developed the following objects for the Taxpayer Advocate Management Information System (TAMIS) application: Oracle Database objects, PL/SQL procedures/packages, SQL queries, Oracle Forms, Oracle Reports.
• Created test plans and documented business requirements.
• Acted in a Technical Lead role advising other developers in software installation and configuration including Weblogic installation, signing JAVA Jars with certificates, Oracle database design, and PL/SQL best practices.

Confidential, Cleveland, OH

Oracle Developer/Business Analyst/Data Architect

Responsibilities:

• Developed the following objects for Enterprise Resource Software (ERP) software: Oracle Database objects, PL/SQL procedures/packages, SQL queries, Oracle Forms, Oracle Reports, JAVA card reader interface, and create Excel Spreadsheets (xlsx) from PL/SQL.

Confidential, Albany, NY

Technical Architect/Oracle Developer/Business Analyst/Data Architect

Responsibilities:

• Maintained hundreds of Oracle Forms and Reports on the following systems PIES, SIMS, CHIPS, LPA and wrote database PL/SQL software for RIS, MAMIS, BDIS, and Bridge applications. (SQL, PL/SQL, Oracle Forms, Oracle Database)
• Gathered business rules, architected the data warehouse, and developed the front end for the Post Implementation and Evaluation System (PIES). This application gave the State of New York the ability to study accidents trends on state highways before and after road improvement projects (SQL, PL/SQL, Oracle Forms, Oracle Database, ETL).
• Gathered business rules, re - architected, and developed the Safety Information Management System’s (SIMS) distributed accident data transfer system (ETL) between the State Police, DMV, and DOT. This vastly improved the quality and quantity of accident data received by Confidential (ETL, SQL, PL/SQL, Oracle Database, Integration).
• Member of the NYS ITS-TED Cluster enterprise architecture team with the title of technical architect. Responsible for advising management on Drupal, Service Oriented Architecture (SOA), Oracle Service Bus, SOAP, REST, Oracle WebLogic server, Oracle JDeveloper, Oracle Forms and Reports, Oracle Database architecture and design, learning new technologies and then implementing these technologies as proof of concepts in the enterprise.
• Assigned as technical architect and technical lead on multiple DOT projects. This involved researching and learning new technologies, gathering business requirements, creating architectural diagrams, orchestrating differing IT units to accomplish the overall project goals, developing process flows, identifying gaps in skills and technology, estimating development time for individual tasks, advising project managers on next steps to project success, conducting meetings, writing software, and implementing and training individuals on new technologies.
• Mentored and trained junior, supervisory, and management state staff on everything Oracle.
• Wrote various Oracle database JAVA classes/apps. For example one class acted as a base64 image decoder that parsed xml clob element, base64 decoded the clob element, converted the clob to blob image and verified the blob image as valid gif, jpeg, bmp, png returning the validated image. (JAVA, Oracle Database)
• Wrote multiple database integrations using Materialized Views, Views, DBLinks, and scheduled PL/SQL package batch jobs to translate and move data from one database instance to another. (PL/SQL, Oracle Database, Materialized Views, Views, Integration)
• Wrote multiple PL/SQL database extracts and/or parsed and imported csv, fixed position (flat file), xml files to and from Oracle databases.
• Implemented FTP to/from the Oracle database using PL/SQL UTL TCP package.
• Designed and developed a SOAP PL/SQL web service client interface with database table message queues with XMLTYPE columns to the LATS time keeping system web service located at CMA. The design allowed DOT to report highway maintenance time from the MAMIS database system in near real time directly to LATS alleviating double data entry (SQL, PL/SQL, SOAP, XQuery, XMLTYPE, UTL HTTP PL/SQL package, Oracle Database, Integration).
• Developed a Drupal application module that connected to NY Department of Environmental Conservation (DEC) and NY Open Data web services displaying points of interest across NY state on multiple Google maps (REST, PHP, JQuery, JavaScript, HTML, MySQL, Apache, KML, KMZ, Drupal).
• Developed Oracle Service Bus SOAP to REST integrations between ESRI GIS and Oracle Primavera (SOA, Oracle Service Bus, JDeveloper, JSON, XML, SOAP, REST).
• Instructed a class at DOT on REST and SOAP web services using Oracle JDeveloper supporting DOT’s upcoming transition to Service Oriented Architecture (SOA, JDeveloper, JAVA, Oracle Database).
• Documented and installed Oracle WebLogic server. Instructed other DOT programmers and Oracle Middleware specialists on configuration, maintenance, and usage of WebLogic from a developer’s perspective. Also, installed and configured Oracle Forms and Reports with patches, created and deployed ADF applications, created and deployed JAVA web services, as well Oracle Service Bus integrations. (WebLogic Server)
• Installed and configured an Oracle Webcenter Content (WCM) demo application on the WebLogic Server Unix sandbox. This application demonstrated possible uses of WCM to DOT management.
• Authored a twenty-five page Warehouse Concepts document as a teaching aid comparing in detail the Bill Inmon and Ralph Kimball warehouse design methodologies. The document emphasizes the importance of governance, warehouse architecture, dimensional design, star query optimizer, bus matrix, and conformed dimensions when building an enterprise data warehouse.
• Coded XML data dump file to Federal Highway Administration using the XSD specification to report commercial vehicle accidents across NY State to the FHWA daily. (XSD, XML, SQL, PL/SQL, Integration)
• Designed and coded an Oracle XMLDB application that loaded MS Project XML files from differing IT projects into XMLDB. Wrote XQuery SQL that combined all the project data into one report for management. (SQL, PL/SQL, Oracle Database, XML, XMLTYPE, XQuery, XMLDB)
• Designed, architected, and developed Permits system’s distributed payment reconciliation process between New York State Tax Department and Confidential (SQL, PL/SQL, XML, Oracle Database, Integration).
• Gathered business rules, redesigned, and developed the Local Programs Applications (LPA) distributed reconciliation process between Taxation and Finance and DOT. The redesign gave the Local Programs Unit improved administrative control over the LPA system and ensured requested monies from state municipalities are actually paid (SQL, PL/SQL, XML, Oracle Database, Integration).
• Reverse engineered and documented the CHIPS budget process generating the CHIPS budget valued at over 360 million dollars since 2008. Running the complex CHIPS budget includes editing the code based on changing budgets requirements from the Governor and state legislature. (SQL, PL/SQL, Oracle Database)

Confidential, Niskayuna, NY

Oracle Developer/Business Analyst/Data Architect

Responsibilities:

• As a subcontractor supported nuclear and materials engineers by developing database applications and Oracle Forms frontends that enhanced their ability to perform nuclear reactor design and research.
• These applications utilized periodic table of elements, chart of nuclides, and advanced mathematics. (SQL, PL/SQL, Oracle Forms, Oracle Database)

Confidential, NY

Oracle Developer/Business Analyst/Data Architect

Responsibilities:

• Member of Rome Research Site's Information Technology (IT) Group with an annual budget of 9 million dollars responsible for discerning Rome Research Site’s IT strategic direction.
• Awarded an Innovative Development through Employee Awareness (IDEA) cash award for creating interfacing software between two distinct Air Force computer systems. The IDEA used web technology to reduce a time intensive paper reconciliation process from 1 year to 1 month.
• Developed ASP HTML web forms for the Confidential Program Management System (JIFFY) allowing management and computer scientists from all over the world to manage project funds and report to the United States Congress. (ASP, VBScript, Visual Basic, Oracle Database, SQL, SQL, PL/SQL, OO4O)
• Designed and maintained the databases and application frontends for the Logistics section’s Supply, Shipping, and Maintenance Oracle Forms and Reports Applications. (SQL, SQL, PL/SQL, Oracle Database, Oracle Forms, PL/SQL Web Toolkit)