SUMMARY

• I am a senior Oracle PL/SQL, APEX developer and System Architect providing expertise to entities seeking solutions to real world business problems.
• I have twenty two years of experience designing and building database schemas and applications that interface to Oracle databases.

TECHNICAL SKILLS

• Oracle 11g
• 12c installation and administration - DBAOracle PL/SQL developmentAPEX 4.2 and 5.0 development
• install
• and administrationAPEX 5.0 advanced plugin design and developmentOracle Rest Data Services (ORDS) installation and configurationTomcat installation and administration
• CentOs 7 installation and administration
• Oracle Business Intelligence installation
• administration
• and repository development
• Weblogic installation and administration
• Solaris installation and administrationJqueryCSSDHTMLD3.js and C3.js chartingUse Case DevelopmentSystem ArchitectFoxProVB scripting

PROFESSIONAL EXPERIENCE

Oracle Consultant/System Architect

Responsibilities:

• Develop Oracle packages, procedures, tables, triggers, sequences, views, materialized views, database links, automated jobs
• Code analysis and conversion from FoxPro to Oracle
• Create estimates on duration and resource needs for the conversion process
• Develop Reports using APEX 4.2 and 5.0
• Develop custom APEX 5.0 plugins and templates
• Develop custom APEX authentication scheme
• Develop transactional applications using APEX 4.2 and 5.0
• Rapid prototyping with Oracle XE, 11g, 12c and Oracle Application Express 4.0, 5.0
• Identify optional conversion paths and tools
• Create powerpoint presentations for senior management briefings
• Create use cases
• Define a coding standard
• Help management define a strategic plan
• Define and configure Oracle 12c ACL for email and other network resources
• Define and implement the processes for linking ten Oracle instances into a single Oracle instance
• Train Caltrans staff on basic administration of the PL/SQL applications, jobs and materialized views running on Oracle
• Developed custom monitoring tools to verify data integrity
• Mentor junior and senior developers on Oracle PL/SQL, Jquery, D3.js and APEX
• Deployed a Proof of Concept Oracle Business Intelligence reporting server

Tools:SqlDeveloperSQLPlusText Pad 5APEX IDEOracle Virtual BoxWordExcelPowerpointOracle Enterprise ManagerVisio

Senior Software Engineer/Technical Lead/Analysts

Responsibilities:

• System maintenance and enhancement which included defining schema tables, triggers, packages, procedures, functions, sequences, synonyms, DB-links, materialized views, views, data types, Oracle jobs, deployment scripts, and data loaders.
• Code UI solutions in Javascript, C#, ASPX, CSS, HTML, and C++
• Design architectural solutions to meet the Navy’s needs
• Review/capture user interface design from end users
• Document requirements, verify business rules, create use-cases and test plans.
• Perform gap analysis
• Define and document the application architecture
• Estimate effort to complete tasks
• Assign tasks to developers.
• Create process flows, flowcharts, and pseudocode for developers
• Provide mentoring to junior developers
• Define a coding standard and a look and feel for the application
• Define schemas for Oracle.
• Defect tracking and configuration management
• Specific coding tasks I performed included development of interfaces into web services usingC#, Oracle functions, stored procedures, and packages
• Created automated data loaders and define file parsing routines
• Conduct code reviews.
• Testing the application to verify that it meets user expectations and business rules
• Generated PDF reports using Crystal reports

Confidential, The Woodlands, TX

Senior Software Architect

Responsibilities:

• Providing consulting expertise for Oracle and Weblogic
• Defense Information Systems Agency (DISA) -Classified 6/08-12/08
• Providing consulting expertise for Oracle and Weblogic
• Northrop Grumman Linthicum, MD -Classified 1/09 - 11/10
• Providing consulting expertise for Oracle and Weblogic
• Integrated Secure R&D
• Providing Oracle and Oracle WEBLOGIC expertise:
• Developing applications deployed to Weblogic,
• WebLogic Service Bus Configuration
• Oracle PL/SQL development
• Java/JSP development
• J2EE development
• Javascript development
• Provided DBA support
• Developed user interfaces using YUI

Tools:SqlDeveloper,PowerPoint,Word,Eclipse,SQLPlus,Text Pad 5,Net Beans,Tomcat

Confidential, McLean, VA

Senior Software Engineer

Responsibilities:

• Performed all the duties of a Oracle DBA such as creating instances, imports, exports, user administration, crash recovery, tuning and data replication, and upgrades
• Oracle development: creating stored procedures, and packages, functions, triggers, schema design, database links, indexes, synonyms, jobs, views, materialized views, sequences, Sql-Loader control files
• Convert client server COBOL application to CGI web application.
• Built an enterprise system implemented through web services, servlets, and Oracle database links.
• Developed JSP/Java spatial applications hosted on WEBLOGIC
• Developed web based logistical supply tracking applications hosted on WEBLOGIC, Apache and MS-IIs with Oracle as the backend.
• Convert COBOL applications to ASP/JSP web application
• Converted Dbase DBF files to Oracle tables.
• Converted Visual Basic applications to ASP
• Managed Oracle 7, 8, 9,10 development databases
• Create scripts to migrate production data from Oracle 8 to 9
• Develop C++ software for early hand held Intermec devices.
• Migrated Access, Excel, and FoxPro data into an Oracle database
• Create deployment scripts
• Developed user interfaces to run on Weblogic
• Domain analysis
• Use Case development