Responsible for creating and maintaining standards and data stores for OLTP and data warehouse systems. I support RDMS and NOSQL systems. I perform logical and physical design activities. I have built utilities for parsing data from Erwin models. Developed tools for maintaining data dictionaries and supporting Erwin models.

Technical Lead of my client's data warehousing team, developing and supporting an Unemployment Insurance data warehouse. My primary responsibilities are requirements development and management, schema design, identification and analysis of source data, source-target mapping, Business Objects universe design, ETL design, and dimensional modeling. I am the primary go-between for my clients and the technical staff, and I support the clients in daily use of the warehouse as well as system and acceptance testing of new and updated data marts. I design and develop ETL processes using Informatica and PL/SQL on an Oracle 11g database. I design and create universes in Business Objects, and assist the users in understanding the data. I work with the clients to define the user acceptance tests. I am also heavily involved with federal labor reporting, especially the ETA 581 and 227 reports. I use ERwin, Informatica, Business Objects, VB.NET, Oracle 11g, DB2, and PL/SQL.

Work with clients in the health care industry to define their processes and identify relevant data sources to source data for a data warehouse. Verify the integrity and data quality of extract files. Assist clients in resolving issues. Lead weekly data discussions with clients. Cleanse, augment, and load client supplied data into a standard data warehouse schema. Assist in problem resolution as required. Created an anonymized data warehouse for testing and demonstration use. Use Windows XP, Linux, PL/SQL, Oracle 10g, PostgreSQL/Greenplum, Python, Perl, and AWK.

Architect of the data warehousing team, developing and supporting an Unemployment Insurance data warehouse. My primary responsibilities are requirements development and management, schema design, Business Objects universe design, ETL design, and dimensional modeling. I am the primary go-between for my clients and the technical staff, and I support the clients in daily use of the warehouse as well as system and acceptance testing of new and updated data marts. I design and develop ETL processes using Informatica and PL/SQL on an Oracle 10g database. I design and create universes in Business Objects, and assist the users in understanding the data. I work with the clients to define the user acceptance tests. I am leading an effort to define performance metrics for the various sections. I am also heavily involved with federal labor reporting, especially the ETA 581reports. Used ERWin, Informatica, Business Objects, VB.NET, and PL/SQL.

Data modeler for an Unemployment Insurance application developed in VB.NET. Translated requirements into working database schema. Tuned the schema and SQL for performance. Designed and implemented interfaces with legacy systems. Mentored developers on SQL and PL/SQL. Developed data models using ERwin.

Conversion team lead for a multi-year state Unemployment Insurance application project, along with being the Data Architect. Converted data from IDMS and VSAM to Oracle 10g. Developed programs using PL/SQL and VB.NET. Developed data migration utilities. Mentored junior developers. Reviewed code and test results. Designed the conversion architecture. Assisted clients with data validation and cleanup. Developed round-trip data validation processes. Implemented efficient data extracts to support legacy users. Used PL/SQL, Oracle, MS Office, and VB.NET.

Was responsible for the conversion and data cleanup of a case management and collection system. Migrated data from SQL Server 7 and FileMaker Pro into a SQL Server 2000 database. Used T-SQL and VB.NET for development. Performed substantial data cleanup, to include identification and consolidation of duplicate client records and reconstruction of numerous erroneous accounting records.Used SQL Server 2000, Filemaker Pro, T-SQL, and MS Office.

Member of a six person team that developed proprietary extensions for a laboratory information management system. Developed applications that communicated with spectrometers and other assay equipment. We used MS Visual Basic, Oracle 8i, MS Office, and PVCS.

I served on active duty and in the reserves. I started as a Cavalry Scout, and finished as the senior enlisted person in a data processing unit. It was fun, for a long time. I did get the chance to travel around the world, and on the government's nickel!As a Cavalry Scout I performed duties ranging from being a scout through leading a scout section. I served in aviation and armored units; eventually I went on to get my pilot's license. I set the academic score record at Hohenfels BNCOC. Unfortunately I was educated and literate, so I often was dragooned into administrative duties. In Germany I wrote a complete training and administrative package in DBase III that allowed me to perform all administrative and training functions for a 311 man unit; the line companies each had two people taking care of half of the functions that I covered and they only had 42 men each.I really enjoyed my time on active duty. It was great to work with a group that was focused on accomplishing the assigned missions.