Oracle PL/SQL Developer

Christian Gardner

Address: ***** **** ****** ******, ********, Arizona 85338

Phone: 623-***-****

Email: ***************@*****.***

Database Developer

Software Development Life Cycle ~ Project Planning and Management ~ Business Analysis ~ Requirement Gathering

Strategic Planning ~ Database Design and Administration ~ Vendor and Client Relations ~ Systems Infrastructure

Qualifications Profile

Results-driven, performance-focused, and innovative professional with broad-based experience in system and database development,

coupled with proven expertise in system automation, performance tuning, user interface design, and data integration. Highly

effective leader and project developer with proven track record of success in implementing high-quality technical solutions and

large-scale applications that drove and increased organizations productivity and efficiency, while delivering positive results in

various business functions. Equipped with excellent leadership aptitudes in performing multiple responsibilities and adeptness in

debugging and troubleshooting activities in fast-paced and demanding work environments.

Professional Experience

Safeguard Properties, LLC - Brooklyn Heights, OH

Oracle Database Developer APEX Administrator and Developer – Information Technology 2012–Present

Work under the supervision of director of infrastructure services

Administer the development of commercial grade web applications through Oracle APEX and JavaScript

Conceptualize and deploy well-designed, user-friendly, and professional-looking user interfaces and Apex applications

Render hands-on support in establishing and implementing development initiatives, while supporting the Web Development Solutions

(WDS) Team to manage the development, testing and deployment of Oracle backend applications

Coordinate with multiple Development and Infrastructure IT teams throughout the Agile software development projects by designing

Safeguard internal and client-focused web applications through combined APEX and JavaScript libraries

Manage all facets of Apex database development environment, which involve necessary planning, design, installation, and management

Received appointment to support the Accounting Department in enhancing their invoice reconciliation process through migration of

the process from Microsoft Access and Excel into Oracle with an APEX frontend

Career Highlights:

Showed exemplary performance by consistently attaining and surpassing internal and external customer expectations

Drove efforts in improving efficiency by completing the following projects::

Bank of America Invoice Reconciliation process-minimized daily processing time by 75%; reduced year variance balances from millions

to zero; permitted manual closeout and accurate processing of work orders within the Accounting Department; deployed a fully

automated file watch process for inbound and outbound fees, invoices, and return files; and oversaw 30,000 transactions per week,

while developing three data marts, rejections and variance.

Corporate Compliance Vendor Disputes process-enabled Safeguard to deal with 1,000 vendor and contractors disputes per week; avoided

unintentionally processing disputes; allowed reconciliation and editing of vendor disputes; and delivered effective batch process

email notifications to vendors.

Quality Assurance (QA) Contractor review process-introduced process that assigned 250,000 completed work orders per week to an

offshore team; and produced and submitted completed reviews results to vendor and contractors.

Quality Control (QC) High Risk process-permitted Safeguard to analyze contractor work amounting to approximately 1,500 transactions

per week.

Quality Assurance (QA) Employee Review process-initiated an automated process that enabled Safeguard managers to evaluate completed

works from employees.

Quality Assurance (QA) Loss Analysis process-allowed Safeguard to authorize and deny claims from clients, such as Quicken, JPMC,

BOA, CITI; and improved system capacity in processing 7,000 transactions per week.

Wells Fargo - Tempe, AZ

Database Developer 2012

Provided effectual assistance to the Wells Fargo Wholesale Production Support Team

Brought on board to review and performance tune their oracle process

Created codes and reduced running time from hours to minutes

JPMorgan Chase - Phoenix, AZ

Database Developer Lead Database Developer 2008–2012

Obtained recruitment in a contracted capacity, in charge of supporting Intranet Collection Automation Tool (ICAT) Development Team

Coordinated with clients to gather requirements to modify ICAT processes in accordance with high-level business rules

Thoroughly assessed unit test cases for the completion and approved code for deployment

Handled the preparation and submission of work statements using the work request management (WRM)system

Created functional requirements documentation, while assisting developers in preparing technical design documents in alignment with

client requirements

Spearheaded a team in the ongoing development and maintenance of a 10 terabyte ICAT database used by more than 7,000 collectors,

supervisors, and management teams from different lines of business, such as Chase Home Finance Washington Mutual, and EMC Mortgage

Designed and implemented a deployment, back out, and validation plans to support the Release Management Team, while delivering user

acceptance testing (UAT) instructions for Testing Team

Made use of Oracle 11g as primary database and Toad v9.1 in developing and debugging PL/SQL stored procedures

Career Highlights:

Successfully minimized the ICAT development and maintenance time by 50% within nine months by improving 90% of processes through

the consolidation of two sets of code into a single code written in dynamic SQL

Devised Extract, Transform and Load (ETL) process which enhanced ICAT performance and stability by eliminating the need of repeated

data retrieval which instigated frequent process failures due high volume of data requests

Earned fast track promotion to lead database developer within six months

Arizona Department of Revenue - Phoenix, AZ

Apollo Group - Tempe, AZ

Database Developer 2007–2008

Developed and implemented database solutions to fulfill client-specific requirements

Strategically utilized Oracle9i, Oracle10g, and Toad v9 in designing and deploying customized database solutions

Executed job scheduling with DMBS scheduler

Career Highlights:

Produced automated daily and monthly general ledger close processes for Department of Revenue which involved converting a legacy

COBOL programs into PL/SQL stored procedures

Led the successful upgrade of legacy system and application of solution-oriented architecture (SOA) that combined SQL server and

Oracle 10g databases using stored procedures

Earlier Positions Held:

Acxiom Corp. - Phoenix, AZ

Lead Database Developer Development Database Administrator

Database Developer

Database Administrator Financial Systems Developer

Computer Graphics - Phoenix AZ

Financial Systems Developer

Other Experience

Tiernay Turbines-Mechanical Engineering - Phoenix, AZ

Electrical and Mechanical Technician

United States Department of Defense - Edgewood Arsenal, MD

Technician

United States Army - Aberdeen Proving Grounds, MD

Staff Sergeant Shop Forman for Small Arms, Tank Turret and Fire Control repair

Small Arms Instructor for the US Army and Marines

Education

Associate of Arts in Automotive Engineering - Harford Community College, Bel Air, MD

Coursework in Computer Information Systems - Glendale Community College, Glendale, AZ

Professional Development

Oracle 8 Certified Professional (OCP) Oracle 8i Certified Database Administrator (DBA)

Advanced Oracle Application Express (APEX) Training Intermediate Oracle Application Express (APEX) Training

Oracle Application Express Workshop I Ed 2 Oracle Application Express Workshop II Ed 2

Technical Acumen

Computer Languages

PL/SQL, SQL*Plus, SQL, Java, C#, UNIX/Shell Scripts, AWK, Perl, 3570 Assembly

Databases

Oracle (12c, 11g, 10g and 8i) Microsoft SQL Server 2008, Microsoft Access

Software and Platforms

Toad, ORACLE (Forms, Developer), Business Objects, Citrix, Cognos, Oracle APEX [4.2, 5.1], IBM 3570, J2EE, Microsoft Office Suite

Operating Systems

Microsoft Windows [7,8,10], UNIX, MVS

Contact this candidate