SUMMARY:

To obtain a position that allows me to utilize my skills and abilities while providing an opportunity to grow with my employer becoming a valuable asset. I’m looking for a home, not a job.

TECHNICAL SUMMARY:

Oracle APEX: Oracle PL/SQL, Database 9i/10g/11g, Oracle APEX, JavaScript, AJAX, SQL, HTML, jQuery, CSS,, Windows Servers 2008, 2008 R2, 2012 R2, HyperV, VMWare, ETL, XML,MS Access, Excel, Office Automation with ActiveX, VB Script, ASP, MS Visio, MS Project, SharePoint, ADO, Toad, Toad Modeler, PL/SQL Developer, SQL Navigator, MS SQL Server, Lotus Notes

EXPERIENCE:

Confidential

Oracle Database & APEX Development Expert

Responsibilities:

• Performing APEX and PL/SQL maintenance and consulting as needed.
• Developing class materials and plugin maintenance for Oracle APEX.

Confidential, Marietta, GA

Lead Developer - PL/SQL and APEX

Responsibilities:

• I was hired to bring their time management software, TAStK, to beta so it could be marketed to the same industry they provide technical support.
• This task was accomplished on time. Shortly thereafter the company started suffering financial difficulties and I was laid-off.

Confidential, Palo Alto, CA

APEX/PLSQL - Developer

Responsibilities:

• Involved in the design and implementation of various systems which interacted with other University systems such as webAuth and Authority Manager to provide tools for researchers to document their interests and potential conflicts concerning their research.
• Once the data was captured, other APEX application reported on the data for various levels of management.
• Three APEX applications were built, one to capture the data, one to analyze the data and a third to perform administrative functions for the system as a whole.

Technical Environment: Oracle 11.1g, APEX 4.01, VPD, PL/SQL, Views, Types, Packages, Functions, ProceduresCSS, HTML, jQuery, JavaScript, AJAX, PL/SQL, SQL

Confidential, Alpharetta, GA

Oracle/APEX/PLSQL - Analyst/ Developer

Responsibilities:

• Designed various APEX reports for the Circuit Path Design Organization (CPDO national) showing the actual and forecast delivery dates for the various types of transports; DS1, DS1c, DS3c and ENET.
• There was considerable APEX development including customizing templates. Most of the coding and logic was handled through PL/SQL on an Oracle 11g instances.
• Report data came from a combination of 3 or more separate databases including drilling into Granite and Granite Works Confidential the site, circuit, path and equipment levels.
• These reports are used Confidential a national level with high visibility.

Technical Environment: Oracle 11g, PL/SQL, APEX v 4.02/3.2.1, Granite, Granite Works, JavaScript, AJAX, HTML, PL/SQL Developer.

Confidential, Alpharetta, GA

Oracle/APEX/PLSQL - Analyst/ Developer

Responsibilities:

• Determine requirements, interview users group and determine essential requirements. I designed all schema objects in Oracle; tables, indexes, triggers, functions, procedures, packages, sequences, etc.
• Once the schema and related objects were created the data was ETL from Access to Oracle.
• The business logic in MS Access was converted to PL/SQL and either placed in the APEX application or the database itself to be called by APEX.
• The APEX application was designed from the ground up and the various themes and templates were customized to yield the proper end result.

Technical Environment: Oracle 10g, Oracle 11g, PL/SQL, APEX v 3.2.1, JavaScript, AJAX, MS Access, Excel, VBA, HTML, Toad Modeler, PL/SQL Developer, MS Visio.

Confidential, Rome, GA

APEX - PL/SQL Developer

Responsibilities:

• Worked independently with stakeholders to gather requirements, create Functional Design Documents, use cases, process and data flow diagrams and an overall project plan including tasks, duration’s assignments and predecessors.
• Created initial database schemas and corresponding objects (tables, procedures, functions, packages, triggers, jobs, etc. Initially developed in Oracle 10g and later migrated to 11g.
• Designed and created all backed PL/SQL code packages.
• Designed and created web based UI with Oracle APEX and driven by PL/SQL.
• Promoted to Project Manager and Lead Developer to oversee project.

Technical Environment: Oracle 10g, Oracle 11g, PL/SQL, APEX v 3.01, JavaScript, AJAX, MS Access, Excel, VBA, HTML, Toad Modeler, PL/SQL Developer, Toad v 9.5, MS SQL Server 2005, MS Project, MS Visio, SharePoint, XML, webMethods, SQL tuning.

Confidential, Roswell, GA

Sr. Oracle Developer and DBA

Responsibilities:

• My responsibilities included design, implementation and quality control over the data migration (ETL) from a very large Lotus Notes application to a new Java (front-end) and Oracle 10g (back-end) application.
• A PL/SQL package with proc’s and functions controlled the migration and MS Access and Excel were used in various ways for quality control. In addition to ETL responsibilities
• I was tasked with the design of the Oracle schema’s and related objects such as tables, indexes, proc’s, functions, triggers, SQL optimization and tuning which included PL/SQL as required to process the many front-end initiated system tasks.
• ETL of data from Lotus Notes to an Oracle 10g environment using PL/SQL, MS Access and Excel.
• Created custom ETL tools using PL/SQL procedures, functions and a QC environment with MS Access and Excel.
• Oracle 10g schema and object architecture primarily using Toad Modeler, Toad and PL/SQL Developer, SQL tuning.
• Developed and optimized back-end code with PL/SQL packages.
• Established and documented all back-end procedures and practices based on State of Georgia required guidelines.

Technical Environment: Oracle 10g, MS Access, Excel, VBA, toad, Toad Modeler, PL/SQL Developer, PL/SQL, SQL, ETL

Confidential, Norcross, GA

PL/SQL - APEX - MS Access Developer

Responsibilities:

• Gather requirements and design desktop reporting systems using MS Access, VBA, Excel, Office automation and PL/SQL - Oracle 10g.
• Create PL/SQL packages to support high volume OLTP - Oracle 9i/10g.
• Data mart development using multiple materialized views, PL/SQL Oracle 10g.
• Develop a management reporting system with APEX as the front-end and Oracle PL/SQL and 10g database as the back-end from the data mart detailed SQL tuning.

Technical Environment:Oracle 9i/10g, PL/SQL, APEX, Data Mart, UNIX, Materialized Views, PL/SQL Developer, SQL Navigator, SQL, MS Access, Excel, VBA, ActiveX Automation