Uploaded File
add photo
Charles
charles29020@me.com
504-235-2857
444 Doleman Drive
Spartanburg, SC 29301
Oracle Application Express (APEX) Development Team - Partner Sto
22 years experience W2
0
Recommendations
Average rating
115
Profile views
Summary

Qualifications Certified Expert - Senior Oracle Application Express Developer (APEX) Areas of Expertise * Oracle Database Versions 10g, 11g R2, 12c (APEX) * Oracle XE 10g, 11g (APEX) * Application Express (APEX) Versions 2.0 - 5.0 (current version) * Oracle Development and Administration using tool such as Toad, SQL Developer and PL/SQL Developer * Oracle Database Administration with Enterprise Manager * JavaScript (APEX) * XML, XSL ((APEX and IBM InfoSphere Data Explorer) * Oracle SQL Developer * Oracle SQL Data Modeler * Oracle SQL Loader * Quest Toad * Quest Data Modeler * Allround Automations PLSQL Developer * Unix and Linux: (Sun Solaris, FreeBSD, Linux {Red Hat, CentOS, Ubuntu, Suse} system configuration and administration) * UNIX BASH Shell Scripting * DOS Batch Scripting

Experience
Oracle Application Express (APEX) Development Team - Partner Store
Information Technology
Oct 2015 - present
* Assist in the updates of the Oracle Partner Store user interface templates bringing them inline with modern responsive browsing standards. Assist in the further integration the partner store to allow for optimized ordering of Cloud services as well as hardware/software products for Oracle Partner customers.
Oracle
Remove Skill
Senior Oracle Application Express (APEX) Consultant
Information Technology
Jul 2015 - Aug 2015
Department * Responsible for migration of APEX 3.1 applications to APEX 4.2 in preparation for eventual migration to APEX 5.0. * Made use of Oracle Virtual Box virtual machine (VM) images for testing and training prior to official stand up of APEX 5.0 instance. * Provided introductory training on the use of the APEX 5.0 application workbench. * Advised on possible migration of database infrastructure to the Oracle Database Cloud and Amazon RDS Services.
Workbench Oracle
Remove Skill
Senior Oracle Application Express (APEX) Consultant
Jul 2014 - Jul 2015
Tasks performed included the following: * Assist with configuration and installation of Oracle APEX instances (DEV, TEST, QA, PROD). * Training of development team and creation of an application framework. * Creation of 2 major applications. * Began testing of applications on the APEX 5.0 Early (EA) to validate that the application created on the 4.2 instances could be migrated to 5.0 with minimal effort. * Integrated Single Sign-On into applications created.
Oracle Quality Assurance
Remove Skill
Senior Oracle Application Express (APEX) Developer
Information Technology
Mar 2014 - Jun 2015
Principal responsibilities as APEX developer are directly related to maintenance of existing applications as well as back end optimization of data exposed to customers.
Oracle APEX
Remove Skill
Senior Oracle Lead APEX Developer
Information Technology
Jun 2011 - Feb 2014
Senior PL/SQL Developer Principal responsibilities as lead Application Express (APEX) developer for a Data Warehouse Project for The Federal Election Commission (FEC), a contract being serviced by TFS Group, Inc. The US government mandates that the FEC make election related campaign data be made available for public consumption. The technologies used to accomplish this task are Oracle 11g and Oracle 12c databases, SAP Business Objects, and IBM InfoSphere Data Explorer 8.2.2 servers. The following detail my responsibilities and accomplishments: * Development of a roles based application security framework for The Federal Election Commission (FEC) APEX Enterprise Data Warehouse user interface. * Creation of user interface (UI) screens using APEX and Data Explorer to expose data retrieved from FEC Enterprise Data Warehouse. * Worked to develop and implement an enterprise search engine to allow both public users and internal (FEC staff members) to search FEC content from the internal file stores (file systems) as well as from the Oracle database warehouse. * Setup and configuration of development servers (UNIX/Linux/CentOS) based Oracle 11g database and Velocity (InfoSphere Data Explorer) servers at the TFS Group offices and FEC offices for application development, testing and production environments. * Creation and update maintenance of Data Explorer pages using the Data Explorer Administrative Console. * Creation of searchable indexes based on data sources ranging from network file systems, external websites (federated sources) to Oracle database sources based data generated by SQL queries and raw column data. * Created high availability cluster consisting of 3 DE servers to balance both the crawling processing as well as the processing search requests to end users. * Made use of the Data Explorer API to expose data through web services to allow for standardization of address and name cleansing of large sets of data. Our implementation was driven by PL/SQL code that called upon indexes created on the Data Explorer environment to assist in the cleansing process. * Configured Oracle Virtual Box virtual machines (VM) for deployment testing, "off-line" search collection testing and for maintenance. * Shell scripting for automation of various Linux administrative tasks related to the maintenance of Data Explorer instances. Development tools used include Toad, SQL Developer - Modeler and PLSQL Developer and the subversion source control utility with the TortoiseSVN Repository Browser.
TOAD PL/SQL Oracle 11i Data Warehousing SSIS Scripting WebServices Oracle SQL MS TFS SVN Shell Scripts Applications Security Linux SAP PL/SQL Developer SQL Developer APEX CentOS Application Development
Remove Skill
Information Technology
Mar 2011 - Oct 2012
PS, LLC Senior Oracle Lead APEX - PL/SQL Developer Principle responsibility as lead developer for the Janus Interface (JI) Project for the Food and Drug Administration (FDA), a contract being serviced by Chickasaw Nation Industries PS, LLC. The following detail my responsibilities and accomplishments: * Coding of Janus Interface (JI) application (a clinical trial repository file transfer utility). * Making revisions to JI requirements, design documents and methodology. * Interfacing with FDA study manager and security and network teams in order to coordinate secure transmission of study data from the FDA to the National Cancer Institute (NCI). * Verification of adherence to Health and Human Services (HHS) developmental security standards.
PL/SQL Oracle
Remove Skill
Senior Oracle PL/SQL
Information Technology
Mar 2009 - Mar 2011
- Lead APEX Developer Principle responsibility was the transformation of legacy MS Access database applications and data into Application Express. APEX 3.2.x was upgraded to APEX 4.0.x. The following detail my responsibilities and some of my accomplishments: * Design and coding of a unified application user repository and supporting role based authentication and authorization system framework, writing code to replicate the functionality of the migrated MS Access systems, writing ETL packages to move and normalize data from MS Access into Oracle tables, load attachments into the database using SQL Loader, as well as the coding of various applications for enterprise usage. * Bi-Publisher was used to create custom reports distributed throughout the enterprise in various document formats such as pdf, MS Word and HTML. * Among the many optimizations that were achieved were the consolidation of 14 individual user tables into one user table and several other commonly used tables into a unified set of tables to reduce unnecessary duplication of data. * Normalized data throughout the systems migrated to Oracle. * Utilized db-links to access data maintained in other corporate systems to reduce data duplication. * Mentored and lead team of APEX developers new to APEX development. Tools used include Oracle SQL Loader, subversion with the TortoiseSVN Repository Browser, Oracle SQL Developer, Quest Toad Data Modeler and Allround Automations PL/SQL Developer.
SQL Loader PL/SQL TOAD Oracle ETL PL/SQL Developer SQL SQL Developer SVN Data Modeling Database Design
Remove Skill
Oracle PL/SQL - APEX Developer
Information Technology
Nov 2008 - Feb 2009
Duties included installation and maintenance of Oracle 10g database server and Oracle APEX Application Server. Design and coding of customized application of client utilizing PL/SQL, JavaScript, SQL Loader, SQL Developer, and Toad.
JavaScript Oracle SQL SQL Developer Database Design PL/SQL SQL Loader APEX
Remove Skill
Oracle PL/SQL - APEX Developer
Information Technology
Mar 2008 - Jul 2008
Duties included the design, layout and support of various database applications upon request, testing, debugging, and implementation of these applications for the Paint Shop Quality Control Group (TS30) group. Applications were written with Oracle APEX 3.0 and PL/SQL. Tools utilized during this project included Oracle SQL Loader, Oracle SQL Developer, Quest Toad, Java Script, and AJAX.
Java JavaScript Oracle SQL TOAD SQL Developer Database Design PL/SQL SQL Loader APEX
Remove Skill
Network Administrator - APEX Developer
Information Technology
Nov 2007 - Mar 2008
Duties included management of network servers (Freebsd Samba and Apple iMac) and workstations. Created and maintained an asset list on Oracle XE. Oracle XE was installed and upgraded from Version 2.0 to Version 3.1 on the Red Hat / CentOS Linux platform.
CentOS Linux Oracle Samba Network Administration APEX OpenShift
Remove Skill
Operations Specialist / Jr. Oracle Developer
Information Technology
Jan 2007 - Nov 2007
* Duties included processing DVD Video and Music CD orders and invoices from customers in Canada and the United States. This included importing data from SAP, optimizing that data for order picking, and dumping optimized data using SQL Loader into the Oracle 9i database and processing this optimized data to be picked by automation, manually, and by a combination of the automation and manual collation techniques. * Provided user support for various production applications such as the MARC supply line, warehouse management and distribution software by Red Prairie. * Interface data with various machine controllers so that the optimized order data could be efficiently picked. * Coordinate with the print shop on the printing of the orders. * Generate reports detailing various statistics related to the order processing procedure. * Design and program various reports and procedures using UNIX shell scripting and Oracle PL/SQL. * Administered Sun Solaris UNIX and Oracle 9i Database Test Server. * Build and implement various Linux / CentOS Linux based Oracle 10g Database servers for various testing activities. * Create Oracle APEX (HTML-DB) database reports for various production processes.
Oracle SQL UNIX Database Design PL/SQL Shell Scripts Linux SAP APEX CentOS Continuous Deployment Solaris Scripting
Remove Skill
Server Operations Center Manager
Nov 1999 - Mar 2001
* Duties included design, build, and maintenance of FreeBSD, Unix, Linux, and Windows NT servers running task ranging from web hosting, email hosting, database hosting, and backup server hosting. Also designed, build, and maintenance of FreeBSD based firewalls, intrusion detections systems, and automated data backup and synchronization solutions. * Implemented secure remote access VPN services to Circle Net staff members ranging from network design, to secure client-server connectivity. * Provided engineer level support to customer support technicians handling telephone based technical support to end-users. * As technical lead during off hours, I was responsible for solving internal and customer issues that were escalated by the technical support staff.
Project Management Linux UNIX VPN Database Backups
Remove Skill
Oracle Application Express Software Developer
Information Technology
Nov 1999 - Nov 1999
Oracle Application Express (APEX) - PL/SQL Development Oracle Application Express Software Developer * State of Kansas - Department for Aging and Disability Services *
Oracle SQL PL/SQL
Remove Skill
Oracle Application Express Consultant
Information Technology
Nov 1999 - Nov 1999
* Oracle Application Express Consultant * Worldwide Express * Application Developer * Application development for TFS Group, Inc. (FEC) * Application Express / Data Warehouse * IBM InfoSphere Data Explorer (Vivisimo Velocity Enterprise Search Engine) Integration * Application development for Chickasaw Nation Industries PS, LLC (FDA) * Application Express / Janus Interface Project * Application design and development for General Dynamics Amphibious Systems (US Marine Corps) * Application Express / Expeditionary Fighting Vehicle (EFV)
Oracle Database Design MS Dynamics 365 MS TFS
Remove Skill
Edit Skills
Non-cloudteam Skill
Education
Certifications
Certified Expert
Skills
Oracle
2021
9
APEX
2015
6
Linux
2014
6
SQL Developer
2014
6
PL/SQL
2014
5
PL/SQL Developer
2014
5
SVN
2014
5
CentOS
2014
4
SQL
2014
4
TOAD
2014
4
Application Development
2014
3
Applications Security
2014
3
Database Design
2011
3
MS TFS
2014
3
SAP
2014
3
Shell Scripts
2014
3
SQL Loader
2011
3
Data Modeling
2011
2
Data Warehousing
2014
2
Database Backups
2001
2
ETL
2011
2
Oracle 11i
2014
2
Project Management
2001
2
Scripting
2014
2
SSIS
2014
2
UNIX
2007
2
VPN
2001
2
WebServices
2014
2
JavaScript
2009
1
Network Administration
2008
1
OpenShift
2008
1
Quality Assurance
2015
1
Samba
2008
1
Continuous Deployment
2007
1
DBA
0
1
Java
2008
1
MS Dynamics 365
1999
1
Solaris
2007
1
Workbench
2015
1
XML
0
1
XSL
0
1