Data Warehouse/Database Architect and Developer

Talented Database Architect with skills in design, development, data conversion and migration (ETL), reporting, and data warehousing. Experience with both Commercial and Open Source tools. Extensive SQL and PL/SQL coding background. Strengths include both relational database design and data warehouse / data mart skills. I also have heavy knowledge of health care data.
Expertise includes:

• Business Skills: Business Analysis, Data Modeling, Database Analysis and Design, Database Development, Data Conversion and Migration, Reporting, Data Warehousing, Project Leadership, Consulting
• Industries: Health Care, Government, IT Consulting
• Methodologies: Oracle CASE Method, Entity-Relationship (ERD) Modeling, UML Data Modeling, Star queries, Use Cases,
• Software: IBM / Cognos (Transformer, Impromptu, PowerPlay and Decision Stream); Pentaho Open Source BI Suite (Pentaho Data Integration (kettle), Pentaho Report Designer); Oracle (Designer, Forms and Reports, SQL*Loader, SQL*Plus); Informatica; ERwin Modeling Tool, Crystal Reports; SQR Reports; DBMS;
• Misc. Software: Microsoft Office (Excel, Word, PowerPoint), Opalis Robot (automating tool), GE Centricity (formerly IDX).
• Programming Languages: SQL, PL/SQL, Familiarity with X-12 formats
• Databases: Oracle; SQL Server, PostgreSQL (database Triggers, Packages, Procedures and Functions).
• Platforms: Unix, Windows, Linux

Confidential - Sr. Business Intelligence, Data and Reporting Engineer (Oct 2009-Current)

• Implemented a reporting solution using the Open Source Pentaho Business Intelligence Suite.
• Developed the ETL to move data from the in-house custom-grown application to the reporting suite using Pentaho Data Integration. Wrote Source to Target Documentation.
• Worked with the users on issues of data quality.
• Modeled the existing applications and the new Data Warehouse. Also, modeled changes to the application.
• Completed some DBA work on the PostgreSQL database.

Confidential- Data Architect (June 2008-May 2009)

• Developed a data warehouse / data mart that will be used to report on the old mainframe data, once the current processing is moved to Oracle Federal Financials. The data consists of 3 separate mainframe programs, which needed to be tied together into one data warehouse.
• Reviewed an existing SQL Server / Cold Fusion reporting system to incorporate these transformations into the new data warehouse.
• Created the data model for both the data warehouse and the data mart using ERwin as a modeling tool.
• Created a metadata dictionary with definitions of all the existing data elements.
• Used Informatica to read in the mainframe data files in order to query the data.
• Teamed up with the mainframe users to correct any data errors in the original records.
• Obtained a Federal Security Clearance.

Confidential - Systems Analyst (Nov. 2003-June 2008)

• Sole data architect responsible for the design and maintenance of the data warehouse and financial reporting system.
• Responsible for adding new data to the extraction set, modifying the table structure on the underlying SQL Server database, creating the necessary joins, and modifying the queries used to build the cubes, including the roll-up queries.
• Created all drill-through reports using the Cognos set of OLAP tools (Impromptu, Transformer and PowerPlay).
• Fully automated the weekly data warehouse updates using Opalis Robot software and .bat files.
• Responsible for updating and maintaining the GE Centricity Healthcare System (formerly IDX), which is used for claims processing. This included updating all dictionaries, modifying claim forms, and creating TES edits.
• Responsible for creating DBMS reports within GE Centricity.
• Responsible for programming all claims changes into IDX Claims Generator (CFG).

Confidential- Oracle Developer / Analyst (July 2002-Nov. 2003)

• Used Oracle Designer to complete 100% generation of a set of forms and reports for an environmental application.
• Wrote Database packages, functions, procedures, and triggers, as necessary, using SQL and PL/SQL.

Confidential- Associate Manager, Oracle Design and Development (March 2001-Nov. 2001)

• Managed an Oracle development team that was responsible for migrating PowerBuilder applications into Oracle.
• Wrote the documentation and trained the PowerBuilder developers in Oracle.
• Developed department standards for using Oracle Designer and designed the necessary templates and libraries to make this possible.

Confidential- Consultant / Systems Engineer (June 2000-March 2001)

• Employed as a consultant at a client site on the data migration team.
• Developed generic templates to be used to extract, transform and load (ETL) data from the customer's existing systems into the client's Oracle database.
• Wrote routines using either PL/SQL or SQL*Loader, depending on the existing system.

Confidential- Oracle Developer / Analyst (April 1999-June 2000)

• Worked as an Oracle Developer using Oracle Forms and Reports.
• Acted as the team leader in the rework of the commissions' area of the application.
• Worked on the multi-currency team where we prepared the application to accept multi-currencies for transactions.

Confidential- Principal Consultant (Oct. 1997-April 1999)

• Employed as a consultant on several different projects, both internal and external.
• Developed a referencing dictionary to serve as a repository for data elements identified as having potential Y2K problems. This program was implemented in a commercial release of an internal Oracle product.
• Used the internal Designer 2000 repository for many of the reports in the above application.
• Performed as the team leader on a Y2K project for Oracle\'s Global Sales Tracking System. The team was responsible for rewriting existing reports and making sure they were Y2K compliant. The project was finished on time and under budget.
• Employed as the project manager at a client site where we completed the development of an internal application using Oracle Forms 4.5 and Oracle Reports 2.5. My duties included acting as the liaison between the client and Oracle Corporation.

Confidential- Database Specialist / Oracle DBA (Sept. 1995-Oct. 1997)

• Hired as the first IT staff member by Preferred Emergency Physicians (PEP) which later became Infinity Healthcare. Managed database administration, implementation of new applications, maintenance of existing Oracle applications; and system back-ups.
• As an Oracle DBA I was responsible for database design, table/index/key creation, installing software updates and patches, and backup and recovery.
• Wrote database triggers, procedures and functions.
• Designed and developed a complete medical billing system using Oracle Forms, SQR Report Writer and PL/SQL, that is still in use today. This included the initial analysis, development, implementation, data transfer, training and documentation. This application was written to handle all charge entry, claims processing, and collections, including refunds.
• Wrote the scripts to handle the conversion and migration.
• Completed both the technical documentation and the user instructions for this application.

B.A., Health Care Administration
A.A.S., Computer Information Systems
Java and UML

Professional Development Courses:

Data Mart Suite Implementation; Database Design for Data Warehouses (Star Queries); Data Warehousing Fundamentals; Oracle iDS Designer: Forms Generation; Implementing System Analysis and Design Using CASE Tools; CASE Design and Analysis; Relational Database Design; GUI Database Design; PL/SQL For Developers; Database Administration; Oracle Architecture; Decision Stream for Data Warehousing; Informatica Power Center; Talend Open Integration Suite; Pentaho Open Source BI Suite Boot camp;