Greg Jarmiolowski

Contact gary@skillbuilders.com or dave@skillbuilders.com

Summary Of Qualifications

Oracle Application Express developer with more than 17 years experience designing, developing, and managing data-centric applications. Oracle Certified SQL Expert, PL/SQL Developer and Database Administrator. Experienced in both functional and technical areas – requirements gathering and business analysis, contextual and user centered design methodologies, project and budget management, proposal creation.

Technical Skills

Database

Oracle 10g – 21c | SQL | PL/SQL

Internet

Reporting

SQL Analytics | Oracle Business Intelligence (OBIEE)

Professional Experience:

Independent ConsultantWashington, DCJanuary 2006 – November 2006

Database developer specializing in Oracle Application Express (APEX)

JP Morgan Chase – Working with a team from Sumneva, developed a replacement system for the system utilized by underwriting for managing lending authority for individual underwriters. Built web service interfaces via to separate product line applications used for loan closing. The user interface is APEX with EXT-JS and it integrates with several other APEX systems all built on a foundation framework.
Washington State Department of Ecology – Working with a team from Sumneva, developed a replacement system for the water permit office. Created a hotkey shortcut system to make the system keyboard navigable. Developed web services for communicating permit requirements with the public reporting and compliance system. Created an enforcement letter wizard that outputs to Word. Created a contextual flyout menu system for reports giving users quick access to an array of actions for each row.
Barrick Gold Working with Sumneva and other Barrick consultants, developed a KPI reporting system using APEX integrated with Oracle Applications Single Sign On and Enterprise Asset Management. The database pulls work order data and compares statuses over time to produce several KPIs. APEX is used to produce charts with tables for these metrics with drill down capability.
US Department of Health and Human Services – Served as lead developer for a new grant award notification system. Grants are sent in flat files to the operators who load using an APEX front end. The system steps them through the process of correcting errors and assigns each grant to a congressional district. The operators then select the grants they wish to send notices for and the system emails the appropriate Congressional staff.
Florida Department of Health – Worked as sole developer to create a website for defining and administering online surveys. Survey designers can choose from several different predefined metrics or create new ones. Questions can be grouped in grids when they share the same Likert scale. Questions can also include logic that determines if they should be shown or hidden based on other responses, how many choices can be marked, and the required total among a group of numerical responses. This logic is implemented on the survey pages by javascript that registers events and handlers that read the definitions from JSON objects.

Consultant
CASEtech, Inc.Washington, DCNovember 2006 – Present

Working for small Oracle consultancy, helped to manage and build extensions to hosted database service built in APEX. Worked with clients to assess their needs and build custom solutions.

Extensive PL/SQL development including packages, procedures, and functions.
Designed and built a content management system with Application Express (APEX)
Developed prototypes with Application Express (APEX) in support of new system acquisition

Consultant
RS Information SystemsWashington, DCApril 2000 – January 2006

Database and website developer for a fast growing technology services company. Administered a mission critical system that managed a federal agency’s grants to states and territories. Supported the web and database teams in the design, analysis, and development of new systems as well as configuration of database and application servers.

Migrated FoxPro desktop system to new 3-tier architecture with ASP and Oracle.
Created prototypes of new database applications using Oracle Application Express (APEX)
Integrated database systems with Oracle Financials using AP and PO interfaces

Associate Director of Research and Statistical Reporting Services
National Assn of Independent SchoolsWashington, DCAugust 1996 – April 2000

Manager of a data collection and reporting service for the research office of an international non-profit organization for independent schools and their regional, state and local associations. Managed the development of web-based data collection and reporting systems to support survey research, data analysis and benchmarking, and managed production of a semi-annual publication of research data.

Coordinated surveys and upgraded reporting application to meet changing requirements
Ran ad-hoc reporting service assisting member schools with data analysis
Managed data entry contractors and implemented quality assurance measures

Sole developer for an inventory management system and mentor to team of 3 developers who were new to the Apex framework
VOTEC

The inventory management system is a new product for helping counties organize, assemble, track and ship voting equipment for elections. Warehouse floor workers operate the system with a barcode scanner and headset. To create a flexible workflow that is customizable by each client, the scanner input logic was modeled after the architecture of Amazon Alexa skills. The system also supports multi-lingual users with both screen and speech output.

Onsite and offsite mentoring
Santa Clara Valley Water District

Client was a new adopter of Apex needing help bringing their team together around this new technology. Designed reusable components that mimicked Oracle Forms design patterns to accommodate transition for users and developers who were accustomed to Oracle Forms.

Education

Interaction and Information Design, University of Baltimore, Spring 2005
Oracle Developer/2000 Certificate Program, George Mason Univ., June-October 1999
B.A., Psychology, Univ. of Texas at El Paso, 1992 (Presidential Scholarship, 1988-1990)

Presentations/Writings (see sqlprompt.net)

ODTUG 2006, Application Express Panelist
ODTUG APEXposed 2008, Presenter – “APEX_ITEM and Dynamic tabular Forms”
ODTUG Kaleidoscope 2009, Presenter – “APEX_ITEM and Dynamic tabular Forms” And “Refactoring Application Express”
ODTUG APEXposed 2009, Presenter – “APEX_ITEM and Dynamic tabular Forms” and “Apex by Example”