PL/SQL Software Engineer Resume Wilmington, DE - Hire IT People

SUMMARY:

Fast paced Oracle database programmer with fifteen years’ Oracle IT experience. Accomplished and proven professional with focus on application design and process/system development. Demonstrated success in organizational operating efficiency and effectiveness through identifying steps to complete work. Dedication to quality, customer value, continuous improvement, teamwork and cooperation. Emphasis on collaborative development via agile delivery methods that ensures rapid deployment and code quality. Strong communicator within communication channels to technical and non - technical staff. Able to work independently or as part of a team.
Relationship Building and Maintenance | Root Cause Analysis | Process Improvement | User and Client Management | Defect Reduction | Design and Unit Test for Proof of Concept | SOC 2 Controls | Secure Coding Practices | Communication & Collaboration | Listening skills | Agile SDLC
Mission Statement: To serve customers with the highest level of integrity, satisfaction and quality, bringing solutions that improve business operations and reduce total operating expense through continuous improvement.
Database Professional with Oracle’s RDBMS
Solid experience creating Procedures, Functions, Packages, Triggers, Views etc...
Use of Analytic Functions, Bulk Processing, Collections, and Dynamic SQL
Linux/Unix shell scripter with emphasis on korn and bash shell variants (vi editor, awk, sed, file processing, scheduling)
Use of Agile methods and tools to team deliver in development iterations
Code management and versioning with CA Harvest Software Change Manager, SharePoint to collaborate and synchronize productivity, and Rational Team Concert to iterate through sprints
Oracle Explain Plan, Oracle SQL Trace, SQL*Loader, SQL*Plus, Oracle 8i, 9i, 10g, 11g and 12c
Ensure that the final release/install package, applications and system changes have met all quality control, user acceptance and business validation criteria.
Data modeling by developing the logical model, developing the relational model, and generating DDL
Performance tuning and monitoring with Oracle’s SQL Trace and TKPROF, optimizer hints, use of explain plans and SQL Tuning Advisor
Use of IDE (integrated development environment) coding tools to develop and enhance applications.

PROFESSIONAL EXPERIENCE:

Confidential - Wilmington, DE

PL/SQL Software Engineer

Responsibilities:

Example of Performance Improvement: The Test Copy PL/SQL Program was much too slow and impeding business. It copies client/group/product data from one DB environment to a test environment for the purpose of client setup and testing. Through analysis, Oracle trace and timing utilities, it was determined the process could be redesigned to run in all instances at once; the major bottleneck was reading the Oracle system constraints table.
Example of Continuous Improvement: The M360 Automated Process is responsible for transmitting any adds, updates or deletes for Medicare Advantage groups, sending an outbound file to a vendor. The process is a scheduled job run via a Linux shell script that executes an Oracle PL/SQL package. The problem experienced was the trailer record frequently had the file’s PL/SQL computed line count wrong and the file rejected by the vendor.
Example of Client Conversion: Converted Blue Cross Blue Shield of Minnesota to the HMHS platform. Conversion of clients, groups, products, reporting, claims, etc. to the HMHS platform. Validating converted data fits the HMHS operating model. Inserted converted data, code table and rule table data to platform via table mass update.
Example of: Beginning in Summer 2016, onboarded Thryve Digital employees, the new Indian division of HMHS located in Chennai, Tamil Nadu, India. Trained in strategy and technology (shell scripting). I also trained in the tool sets used for change management and revision control, code testing and code walk through, build management tools, and tools for documenting the system as required by SOC 2 trust services criteria.
Agile Projects: Emphasis on iteration, Product oriented delivery, transparency, owner involvement. Follow the main principle of satisfy the customer, frequent delivery, teamwork, constant iteration pace (velocity), and excel at quality. Time estimates per sprint task (story points), Work the sprint backlog to yield deliverables.
Ongoing Data Modeling: to identify relationship types (identifying, non-identifying, many to many), relationship optionality, and relationship cardinality for the business rules that apply between entities. Identified key attributes to uniquely identify a row and maintain quality and integrity. Represent the data and structure of the data. Use business requirements and analyze how entities are related to determine relationships. Apply normalization to reduce redundancy and increase integrity and dependability in the relational model.

We provide IT Staff Augmentation Services!

Pl/sql Software Engineer Resume

Wilmington, DE

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship