Sql Data

Summary of Qualifications

Results-driven and seasoned IT professional with an extensive background designing, developing and maintaining robust, reliable database systems to power efficient business operations in the Energy, Aerospace, Pharmaceutical and Banking industries.

Oracle Certified Professional committed to continued learning to stay abreast of new technology.

PL/SQL expert with considerable experience with complicated queries and dynamic SQL development.

Experienced educator skilled at teaching middle school students as well as IT professionals.

Excellent multi-lingual communicator (English, Italian, Portuguese, Spanish and French) willing to travel and take on new challenges.

Technical Skills

Oracle 11g

SQL

PL/SQL

SQL*LOADER

Toad

SQL Developer

SQL*PLUS

MS Word

MS Excel

MS PowerPoint

MS Access

MS Publisher

UNIX

AS/400

RPG/400

Query/400

VB

REXX

HTML

XML

C++

Agile

Professional Experience

Truven Health Analytics, (remote) May 2016 – Aug 2016

Duties include:

Create Oracle PL/SQL procedures to extract Medicare and Medicaid data to send to CMS (Centers for Medicare and Medicaid Services) for the state of Idaho using PL/SQL, TOAD and dynamic SQL. Created VB formulas in Excel to build SQL statements from raw data in order to insert data into database tables.

Waste Management, Houston, Texas May 2015 – May 2016

Duties included:

Created Oracle PL/SQL packages to provide new functionality to existing object-oriented software to be able to retrieve and update system parameter and site features which is currently being done manually

Created a menu utility using native SQL*Plus code for DBA’s to run release scripts in order to mitigate human error

Analyzed tables to see how best to partition them

Wrote code and data structures to remove use of UDT’s (user-defined types) from tables

McKesson Specialty Health, The Woodlands, Texas October 2013 – March 2015

Technical Lead/PL-SQL Developer

Duties included:

Create Oracle stored procedures and packages to provide data for new data requirements involving performance issues/tuning and making recommendations on where to add indexes as to enhance retrieval performance while not negatively impacting updates using PL/SQL. TOAD and dynamic SQL.

Project management and tracking was done with Agile

Create pseudo XML code to map data elements required for CCDA (Consolidated Clinical Document Architecture) transmission using MS-EXCEL and CCDA Implementation Guide

Design and create tables to hold patient, provider, medication and other related data for use in CCDA creation.

Create PL/SQL stored procedures to load HL7 formatted files

Convert MS SQL-Server T-SQL code to Oracle PL/SQL code for Financial Data Warehouse upgrade

Create SQL*Loader code to extract and load data, ETL, from client flat files into database tables

Created Excel formulas to take flat files and create INSERT statements to do ETL of client data into the database

Create mapping mechanism to cross reference ICD9 codes to multiple ICD10 codes using concatenation

Create stored procedures to use cross-reference tables in order to match free text to standard text in order to find proper codes

UTMB, Galveston, Texas April 2009 – October 2013

Senior Applications Systems Analyst

Support of the Correctional Managed Care applications for UTMB

Duties included:

Rewrite existing PL/SQL procedures to increase performance, streamline code and to incorporate new Oracle features such as cursors within cursors and bitmap indexes

Analyze current data model and make recommendations to enhance data integrity

Analyze database to find data anomalies such as duplicate and/or invalid data and develop code and constraints to resolve the anomalies.

Create and modify CMC reports using Hyperion and Crystal Reports

Modify existing PL/SQL procedures to be able to report on combinations of diagnoses and diseases

Syntex, Houston, Texas August 2008 – April 2009

Senior Consultant

Report creation and maintenance through the IMPACT application. Work involves creation of views, and functions in both Oracle and SQL-Server databases. Software used is Oracle, SQL Server, PL/SQL, T-SQL, MS Excel. Duties included:

Configuration of custom reports

Building and maintaining report templates

Create procedures to move data to and from Oracle and SQL-Server

ExxonMobil, Houston, Texas July 2007 – July 2008

Senior Consultant

Support of the Energy Components application. Work involves writing PL/SQL scripts, functions and procedures used in the Reporting module of the Energy Components application and writing custom reports for ExxonMobil on contract with Pantheon Corporation. Software used is Crystal Reports, PL/SQL, SQL*Plus, Toad, MS Excel. Duties included:

Find, analyze and fix query performance problems

Create, replace and rewrite 10g database objects to realize decreases in runtimes such as replacing views with parametric procedures

Produce reports using Crystal Reports

TietoEnator, Houston, Texas July 2006 – June 2007

Senior Consultant

Support of the Energy Components application. Work involves writing PL/SQL scripts, functions and procedures used in the Reporting module of the Energy Components application and writing custom reports for the Shell Altamira project that is currently implementing Energy Components. Software used is iReport, PL/SQL, PL/SQL Developer, SQL*Plus, Toad MS Excel. Duties included:

Produce iReport SQL statements to incorporate business rules and data into reports

Produce Oracle packages to calculate contract price based on number of business day in a month

Produce Oracle packages to translate a decimal number into Spanish text

EOG RESOURCES Houston, Texas December 2005 – July 2006

Oracle Developer

Work involves writing Oracle PL/SQL scripts used to maintain databases in support of EOG’s financial accounting department using Oracle Designer, PL/SQL, TOAD, MS Excel and MS Access and MS Visual Source Safe. Duties included:

Development of Oracle stored procedures to feed Java front end with dynamic cursors

Writing scripts to load data from DB2 to Oracle

Writing scripts to ensure data integrity of tables holding over hundred million rows of data

Aquillix Consulting, Somerville, New Jersey July 2005-September 2005

Consultant

Consolidated G/L data from multiple sources and systems into Excel Spreadsheets to then load into Oracle Financials for Dendrite Corporation

Used VB Macros to run consolidation algorithms to consolidate, balance and load G/L data for monthly close.

ChevronTexaco October 1990 – July 2002

Database Developer – IT, Corporate & Legal Departments – Houston, Texas July 1998 – July 2002

Analyzed and incorporated constantly changing user requirements for Gas Marketing and Legal applications by developing, testing and integrating PL/SQL, SQL*Plus and PowerBuilder code on Windows NT and UNIX. Maintained and replicated the corporate-wide Y2K applications inventory management database to ensure compliance.

Systems Analyst – IT, Finance & Warehouse Departments – Cabinda, Angola August 1996 – June 1998

Utilized AS/4000, RPG/400, Query/400, Rumba, Windows NT, MS Access and MS Excel to produce and manage inventory and financial systems. Performed incremental and complete system back-ups, supervised four personnel, resolved system failures and provided code updates.

Delivered comprehensive training to Portuguese-speaking warehouse employees in writing spreadsheets and queries.

Ensured secure data transfer by implementing EDI and non-EDI solutions to handle various functions in the procurement department.

Developed Excel macros to convert spreadsheet data into purchase orders and created computer programs to restructure accounts.

Database Administrator, Natural Gas Business Unit – Houston, Texas December 1994 – July 1996;

Maintained database performance and integrity by resolving user errors, conducting daily back-ups, approving changes, generating status reports and assisting with coding and specification writing. Restored Oracle 7.3 database using UNIX, Windows NT, SQL*Plus and PL/SQL.

Facilitated training on Normal Forms, which allowed designers to spend less time on data modeling through better understanding of entity relationships.

Improved system performance by coaching designers to recognize when to build indexed and when de-normalization would result in less I/O.

Database Developer, Natural Gas Business Unit – Houston, Texas October 1990 – November 1994

Converted a legacy gas marketing system into a relational database model for enhanced security and data availability. Created scripts to develop database objects such as indexes and constraints. Used SQR, EASEL, C++ and SQL to produce gas marketing applications.

Increased operational efficiency and lowered costs by providing timely access to data, eliminating duplicate data and streamlining various work processes such as the preparation of government reports.

Conducted brown-bag sessions to educate team members on Normal Forms and C programming language.

Education and Specialized Training

University of Houston – Houston, Texas

Bachelor of Science Degree in Computer Science / May, 1989 / 3.0 GPA

Certifications:

Oracle 9i Certified Professional Database Administrator

Texas Examination of Educator Standards (TExES/ExCET) Math Grades 4-8

GRE

Contact this candidate