SKILLS HIGHLIGHT:

Oracle Products: 12c R1, 11g R2, E - Business Suite - HR, 9iDS Designer, JDeveloper 10G, Forms 10g App Server, Forms 10, Reports 10, Fusion Middleware for Reports, Workflow Builder, Policy Manager, Advanced Security (VPDB), 9iAS Portal, 9iAS Discoverer Plus and Discoverer EUL Administration, Enterprise Manager, Oracle Label Security, SQL*Plus, Oracle ODI

Operating Systems: Windows, Linux, Solaris

Languages: PL/SQL, SQL, UNIX Shell Scripting

Databases: Oracle 8i - 12c RAC

Web Products: Oracle HTP Web HTTP

Management/Leadership Skills: Technical Lead, Lead Developer, Team Lead, Snr Developer

Life Cycle Expertise: Agile development and full Lifecycle Development Skills Requirements Analysis, Design, Development, Maintenance, Enhancement and Testing.

Specialty Skills: Technical - Custom Development, Applications Development and Implementation, Data Migration, Extraction, Transformation, and Loading (ETL), Batch Processing, Oracle 11g Advanced PL/SQL Programming, Server-Side development (3-tier), Java End-to-End Solutions (2-tier), Advanced T-SQL Programming.

Other Products: FileZilla, PuTTY, CVS, PEGA PRPC, Compuware Vantage 10, HP Quality Center, Rational ClearCase/ClearQuest, MS SharePoint Portal, MS SQL Server Enterprise Manager, MS SQL Server Query Analyzer, TOAD, Premiere Version Control System (PVCS), CodeCenter, Sybase ASE 11.5, Precise, Solaris 2.8 Basic Security Module (Audit), MS Office, PLSQL Developer, TestDirector, Subversion, Tectia SSH, HP Fortify, VersionOne, Benthic, Notepad++

WORK EXPERIENCE:

Sr SW Engineer

Confidential

Responsibilities:

• Member of LM Data Quality Information Management Team for F35 Joint Strike Fighter, duties include creating Java - based application tools and enhance maintain existing tools and database objects.
• Acted as tool team DBA and DB design leader.
• Writes Oracle PL/SQL and SQL software for entire back-end system functionality.
• Wrote data access objects that are called by and return ref cursors to Java clients. reates and maintains Virtual Private Database scripts to add policies to data storage objects.
• Maintained database links. Writes advanced scripts to load new database objects using Mil-STD1388 data stores.

Oracle Developer

Confidential

Responsibilities:

• Duties include participating in daily agile scrums. Develop PLSQL applications on Kanban teams.
• Oracle 12c developer responsible for PLSQL processing ETL on VLDB, post Informatica and Java processes.
• Tools included TOAD, VersionOne, PuTTY and ALM. Writes DDL, DML and PLSQL programming logic to enhance and maintain high volume mail transactions stored in partitioned tables.
• Conducted code peer reviews and knowledge transfer and coaching to junior developers and testers.
• Oracle 12c r2.1 Very large database development and production environment
• Created date range partitioned - list subpartitioned tables to support new functionality
• Accomplish PLSQL DML and API to API transactions using collections and BULK operations
• Created PLSQL batch processes w/TOAD used to ingest staged data into final tables
• Designed new configuration table data to represent holiday date representations, allowing for DevOps changes during real-time online operations.
• Highly skilled and experienced in SDLC across methodologies. Often asked to participate in initial requirements review with business analysts and architects.
• Used Dynamic SQL as needed to allow for flexible development approaches to complex data handling situations
• Created data management change request consisting of create table including partitioned local indexes, alter table to add new columns scripts on regular reoccurring basis

Oracle R12 EBS Application Developer

Confidential

Responsibilities:

• Rejoined company after 8 years to help clear large backlog of business process owner (BPO) requirements. In first year completed 20 complex change requests logged in Starteam. Instantly became a go-to technical resource for project managers and functional leads who requested in-depth technical analysis of future Oracle EBS Application enhancements to the Airforce’s HRMS System of record - Confidential .
• Primary responsibilities: Full SDLC Oracle PLSQL development, Oracle Reports creation and enhancement; Oracle Forms maintenance; Creating and modifying ETL objects including packages, procedures, tables, and triggers and materialized views.
• Occasionally write Unix execution scripts. Uses ALM Quality Center, PL SQL Developer, PuTTY, Starteam, to name a few.
• Created PLSQL, descriptive flex-field software changes to support USAF-wide retirement plan changes
• Created Application Server PLSQL code changes to call back-end PLSQL programs that updated complex special duty classifications without user interaction.
• Created numerous updates to AF Guard, Reserve component business rules in PLSQL APIs to support the total force mandates.
• Participated in all facets of waterfall development in full SDLC environment
• Created LDT scripts to run on application server to populate EBS metadata foundation tables

Svc Info Developer

Confidential

Responsibilities:

• Instrumental in Confidential being rewarded a contract renewal after returning to DFAS Cleveland to work on HP Confidential contract up for renewal.
• Hit the ground running quickly fixing 8 software change request (SCR) issues in the first 3 months.
• One issue required tuning an ETL process that ran 5 - 9 hours.
• Tuned long running process that had join on a very large partitioned tables reducing runtime to less than 5 minutes.
• Rewrote PL/SQL development solutions written using Oracle 8 and 9i to Oracle 11g technology.
• Work included creating report extracts after receiving financial files, creating and modifying ETL objects including packages, procedures, tables, and triggers and materialized views.
• Used and maintained custom job queue functionality and wrote numerous Unix execution scripts.
• Used Eclipse Subversion version control and configuration management software.

Sr Software Engineer

Confidential

Responsibilities:

• Primary responsibilities include design, development, enhance and maintaining Oracle 11g PL/SQL Pub Administration and Data Receipt software code used by original equipment manufacturing (OEM) catalog publishing development teams.
• Works with Oracle Data Integrator (ODI) for ETL.
• Works with Python, Unix, TOAD, JIRA, Accurev as part of SDLC.
• Lead effort to create PostgreSQL Based EPC system.
• Completed analysis, rough order of magnitude and approach documents approved by management.

Confidential

Sr PL/SQL Programmer Analyst

Responsibilities:

• Member of Sterling’s Oracle RPAS development team in early stage implementation of RDF and AIP functionality.
• Responsible for creating over 50 complex extracts for custom built interface engine using advanced PL/SQL development techniques and Unix scripting.
• Created API for generating extracts via the interface engine.
• Created 10 materialized views, the first in Sterling’s database.
• Created PL/SQL package to archive, refresh and purge materialized views.
• Works with offshore Veltio company personnel from Greece.
• Works in Oracle 11g database environment.
• Does Unix shell scripting.
• Creates detailed unit test plans.
• Meets daily with Director of IT Application Services to provide feedback and report on project status.
• Responsible for application development on Business Enterprise Information Service, Defense Cash Accounting System ( Confidential ) application. Uses Oracle 11g, PLSQL/SQL and Oracle Reports to create new functionality and enhance existing operations. Uses tools TOAD, SSH Tectia and Eclipse CVS.

Confidential

Senior Programmer Analyst

Responsibilities:

• Specializes in and extensively uses knowledge of Oracle 11gR2 in multi-node RAC DBMS on VLDB (14TB) to provide 24 hours support to operations personnel when on-call.
• Wrote Unix shell scripts to multi-thread batches. Wrote PLSQL APIs to call from application server using SQL*Loader to stage data then load into main system.
• Member new project development team -- promotion forecasting (PF), wrote numerous PLSQL packages and procedures to interface SEYC G.O.L.D PF modules into DG IT application.
• Highly skilled in all aspects of SDLC. Adapts quickly to changing requirements, highly efficient.
• Skilled in use of parallel server development and tuning. Used tech spec documents from design team to code, test and implement often making performance related design suggestions that were adopted by design team. Uses DBMS Scheduler to run extracts and data loads in less time.
• Wrote numerous DDL scripts to create normal and partitioned tables, DB triggers and indexes.
• Extensively uses SQL, PLSQL, Unix Korn Shell languages.
• Tools used every day include TOAD, PuTTY, FileZilla, Opcon, and CVS.

Confidential

System Developer

Responsibilities:

• Responsible for application development on Business Enterprise Information Service, Defense Departmental Reporting System ( Confidential ) application.
• Uses Oracle 11g, PLSQL/SQL, JavaScript, AJAX and Oracle Reports to create new functionality and enhance existing operations in the budgetary reporting organization.
• Developed Confidential application functionality to reconcile Office of Management & Budget (OMB) max edits for abnormal balances with SF133 revised reports.
• This new functionality required designing and coding tables, views, constraints, indexes and pl/sql packages.
• Additionally, designed and coded from scratch new front-end screens using Oracle Application Server pl/sql web toolkit especially htp package.
• Created journal report JavaServer Pages using Oracle Report Builder. Participates in daily coding, testing and designing of software for quarterly SDLC releases. Uses PL SQL Developer, PVCS and CMIS daily.

Execution Owner

Confidential

Responsibilities:

• Responsible for RxHome and Atlas integration software scalability issues post-merger such as nightly batch processes, data lifecycle management and database partitioning.
• Worked directly with CuraScripts architects to document enterprise data warehouse data mapping between Confidential and Confidential reporting systems.

Performance Team Lead and

Confidential, Memphis, TN

Responsibilities:

• Responsible for new projects, maintenance and performance tuning of existing software for Pharmacy Benefits Management - Order Fulfillment, RCM and CSR application RxHome.
• Architects development, develops requirements, writes technical specifications, creates project plans, works with business analysts to create business and functional requirement documents, manages team’s development work, and reviews software for standards, works with quality assurance and release management teams.
• Uses Rational ClearCase and ClearQuest.
• Manages back port issues related to code dependencies in software releases.
• Works with large software development team on-site in Tennessee and near-shore in Mexico.
• Wrote and released RCM and therapy reporting development projects individually and lead the completion of five large projects through therapy management and performance teams at Accredo.
• Designed and led development of compliance business rules application that established Medicaid payer and therapy protocol related rules compliance.
• Performed dual roles as technical team lead on capital projects and team lead on production support performance & tuning team while reporting directly to Directors of SW Development and Enterprise Support.
• Capital project production release accomplishments include:
• Confidential Therapy Management System (ATMS), Pharmacy-Billing Limits Protocols Engine, MedeFinance (aka MedeAnalytics) RCM Data Mining App, Nurse Scheduler and ATMS-Fast-Quick-Entry(FQE) Merge.
• Performance & Tuning team production release accomplishments include:
• Lead Oracle 10g Upgrade from release 9208 to 10205.
• Data Retention Management project that reduced database size by 1.3 terabytes using partitioning and Oracle10g data pump.
• Disaster Recovery project.
• Released over 100 significant performance related fixes in 18 month period ranging from table handler design changes to correcting contention issues to bind variable implementation fixes that reduced SQL cache memory allocation.
• Established performance review process that elevated reviews to quality assurance (QA) level status by adding HP Quality Center defect documentation to reviews.

Task Lead

Confidential, TX

Responsibilities:

• Task Leader of 17 member software development team at the Confidential Texas as part of the Electronic Systems Center/ 554 ELSG/PNMA.
• Maintained Oracle Human Resource Application as part of the Confidential application.
• Provided full lifecycle support for Confidential including design and development of systems solutions based on requirements from the AF Personnel Operating Agency (AFPOA). Knowledgeable in all facets of Oracle Applications Suite including Flexfields, Concurrent Programs, Responsibility, menu and function creation.
• Member of the Confidential 11i migration team tasked with identifying Oracle 10.7 to 11i problems and providing solutions that would mitigate them.
• Worked 11i conversion issues such as forms and reports conversion, HR Foundation Table changes, and utilization of Oracle 10g technology to increase system performance.
• Provided Confidential to Defense Integrated Military Human Resources (DIMHRS) development support working with CellExchange developers and testers to create interfaces as part of the Virtual Personnel Service Center’s Force Development Toolkit (FDTK).

Confidential

Systems Engineer

Responsibilities:

• Created SQL Server 2000 T-SQL stored procedures as lead database developer for Confidential Iraq - C3 Information Management Division (C3/IMD).
• Built T-SQL stored procedures called by C#.Net and VB.Net web pages used for report creation in support of the Joint Operations Center’s Battle Update Assessment.
• Designed and wrote VB.NET web-based advanced search tool using dynamic SQL for use by all echelon levels to query the FusionNet (FN) application database from anywhere in the world. The FN Search Tool became the centerpiece of C3/IMD report creation allowing users to build complex queries of the FusionNet database.
• Wrote triggers, built load scripts and managed database operations for C3/IMDs FusionNet report generation department.
• Maintained C3/IMDs presence on the Confidential Iraq portal working with MS Windows SharePoint to accomplish and manage web links.
• Wrote numerous stored procedures that provided trend analysis of FusionNet data.
• Worked closely with web developers to create web-based graphs of trend data.
• Managed Sharepoint Portal web pages used by C3/IMD.