Sql Quality Assurance

Bill Grass

**** ******** ***** *****, ** ***** _ 214-***-**** _ *******.*.*****@*****.***

SKILLS SUMMARY

More than ten years of experience providing creative, resourceful and timely solutions with Oracle SQL and PL/SQL for Oracle 8i-12c on Linux, UNIX and Windows.

Strong problem-solving skills in the Oracle database environment and a history of completing difficult tasks both in application development and in data extraction and integration.

Highly skilled in the design, creation, testing and implementation of PL/SQL stored procedures and the use of PL/SQL features such as Dynamic SQL, collections, BULK COLLECT processing, cursors, ref cursor variables, XMLType, exception handling and autonomous transactions.

Adept in the use of Oracle SQL including features such as outer joins, self joins, ANSI join syntax, in-line views, WITH clause(CTEs), set operators, analytic functions, regular expression functions, sub-selects, hierarchical queries, multi-table INSERT and MERGE.

Accomplished in the design, creation and use of Oracle schema and database objects: functions, procedures, packages, triggers, tables, indexes, constraints, partitions, views, materialized views, sequences, synonyms, types, database links, directories, roles and granting privileges.

Very knowledgeable of the Oracle data dictionary and use of metadata.

Productive in the use of Oracle packages UTL_FILE, DBMS_SQL, UTL_HTTP, DBMS_AQ, DBMS_RANDOM, DBMS_ROWID, DBMS_UTILITY and DBMS_OUPUT.

Effective at developing new or modifying existing PL/SQL, and identifying the cause of defects.

Successful in the tuning of database objects, SQL and PL/SQL for performance improvement.

Skilled in the use of SQL*Loader for loading flat files to Oracle tables, and in the use of SQL*Plus to spool data from Oracle tables to flat files.

Productive in the use of Allround Automation PL/SQL Developer and Oracle SQL Developer IDEs and ClearCase and SourceTree for version control.

Proficient in the use of utPLSQL for unit testing of PL/SQL stored procedures.

Strong knowledge of RDBMS features such as ERDs, normalization and referential integrity.

Experienced with transform and load portion of ETL for data warehousing.

Working knowledge of data warehouse modeling using dimension and fact tables with star and snowflake schema.

Proven ability to work from requirements that range from very general to highly specific.

Effective at communicating orally or in writing and at tailoring the technical level of communication depending on if the recipients are peers, management or end-users.

Proven success in both traditional SDLC and Agile development.

Good visualization skills and analytical ability leading to rapid and precise problem solving.

Supportive, dedicated team member willing to provide extra help and disseminate knowledge.

EXPERIENCE

Senior Consultant, Credera (Vantage Force), Addison, Texas February, 2016 - present

Designing, coding, testing and implementing PL/SQL stored procedures for a medical supply chain analytics system.

Creating complex SQL queries and returning the result set via a PL/SQL ref cursor variable.

Creating SQL scripts used in the ETL process for pre-aggregation of data at levels required to improve online query performance.

Creating scripts for deployment of database releases to development, quality assurance, user acceptance and production environments.

Supporting quality assurance testing by defect resolution and assisting in data validation.

PL/SQL Developer III, ETC (TEKsystems), Richardson, Texas July, 2015 – January, 2016

Coded, tested and implemented PL/SQL as part of a large development project for a toll collection system.

Resolved defects in quality assurance testing by determining the cause, and then designing and completing a remedy for the defect.

Cooperated efficiently with other developers when separate tasks required update of the same PL/SQL package, and determined the wider impact of changes to database objects.

Updated design documents as needed to reflect changes or additions to original design that were unforeseen when implementation started.

Created scripts for implementation or modification of Oracle objects such as tables, indexes, views, types, constraints, synonyms and sequences, and loading of seed data.

Senior Oracle Developer, Sagebrush Solutions, Addison, Texas May, 2005 - July, 2015

Designed and maintained health insurance claims data warehouse on Oracle platform.

Loaded client claims data extracts into staging tables using Oracle SQL*Loader.

Transformed data extracts using SQL and PL/SQL to load them into the claims data warehouse.

Designed and maintained claims audit-tracking database on Oracle platform.

Advised developers in the design and tuning of SQL and PL/SQL within their applications.

Instructed and supported end-users in their use of SQL for data mining and reporting.

Created reports for audit staff based on various complex criteria.

Sampled health insurance claims for purposes of statistical audit.

EDUCATION/ CERTIFICATIONS

Bachelor of Science, Computer Science, Louisiana State University.

Oracle Database Certified SQL Expert

Oracle PL/SQL Certified Associate

Contact this candidate