Candidates About

Dara Tressler

Technical Skills:

Database and Database Utilities:  NCR Teradata RDBMS V2R4.1/V2R5.1/V2R6/V12/v13/v14; Teradata Load Utilities (6.0/7.1/8.0/12.0/13.0): BTEQ, Fastload, Fastexport, Multiload, Tpump;  Teradata SQL Assistant (Queryman); Teradata Performance Monitor (PMON); Teradata Manager; ACCESS 97/2000/2002/2003/2007, SQLServer 7.0/2008, ORACLE 7.x/8.x/9.x/10.x, TUXEDO 6.x,  IDMS, ADS/Online

Operating Systems:  Microsoft Windows 3.1+/95/95/NT/2000/XP/Vista/Windows7, UNIX (various flavors), Sun OS,  X Windows, Motif, VM/ESA, VAX VMS, PC/MSDOS, AIX, NCR VRX, NCR IVAN.

Languages: Windows Scripting Host/VBScript, Microsoft Visual C/C++, PERL 5.8, Microsoft Visual Basic/VBA, , C/C++ (various flavors), Shell script (Korn, csh, tcsh,  bourne), , ADA, , COBOL, PASCAL, PROGRESS, REXX, FORTRAN, Microsoft Visual Basic for Applications, IBM 360/370 Assembler, PROLOG, LISP, PL/I.

Experience:

Data Analyst, Brooksource/Caresource, Dayton, OH, November 2014-April 2015

(Windows 7, Teradata RDBMS V14, SQL Server 2008)

n  Developed and Executed Ad-Hoc queries against the Enterprise Data Warehouse

n  Updated and maintained metadata in the Business Glossary

n  Executed Data Quality queries to assess the health of the Pharmacy Database in the EDW

n  Executed Queries to determine the root cause of data issues in the ETL stream

Senior Data Warehouse Consultant, MBO Partners/APP Consulting, USPS, Raleigh, NC, November 2010-October 2014

(Sun UNIX, Windows XP, Teradata RDBMS V12/13, Teradata Utilities 12.0/13.0 {including Multiload, Fastload, BTEQ, Fastexport},  NCR Teradata SQL Assistant, Korn Shell Script, Awk Script)

n  Developed and Executed Ad-Hoc queries against the Enterprise Data Warehouse

n  Updated and Modified BTEQ, Fastload, Fastexport, and Multiload ETL scripts in support of complex dual active data warehouse applications

n  Created BTEQ scripts to update tables, views, and data

n  Analyzed, designed and coded applications in Korn Shell Script

n  Designed Database Tables, Views, Join Indexes and other Application DBA activities

Senior Data Warehouse Specialist, Kratos, Fairborn, OH, October 2004-August 2010

(Sun UNIX, Windows XP/Vista, Teradata RDBMS V2R5 - V12, Teradata Utilities 8.1-12.0 {including Multiload, Fastload, Fastexport, BTEQ},  NCR Teradata SQL Assistant (Queryman), Teradata Manager (WinDDI), ErWIN, Microsoft Visual C/C++, Korn Shell Script; AWK, MSDOS  Batch); ORACLE 9/10;

n  Developed and Executed complex Ad-Hoc queries against the Enterprise Data Warehouse

n  Analyzed, designed and coded single-threaded applications, Awk, Korn Shell Script, and Perl in Unix

n  Developed and modified ERwin Data Models

n  Analyzed and redesigned SQL to enhance performance as much as 30%

n  Designed Extraction/Transformation/Load (ETL)  in Informatica 7.1/8.1.1

n  Designed databases for many major projects

Senior Programmer Analyst, Speedway SuperAmerica LLC, Dayton, OH, June 1999-September 2004

(NCR Worldmark 4400/5250/4980, IBM NetVista Pentium III PC, Unix System V, Windows 95/98/NT/2000/XP, Teradata RDBMS V2 R5.1, Teradata Utilities 7.1 {including Multiload, Fastload, Fastexport, BTEQ},  NCR Teradata SQL Assistant (Queryman), Teradata Manager (WinDDI), ErWIN, , Microstrategy 6.0/7.0, C/C++, Microsoft Visual C/C++, Windows Scripting Host/VBScript, Visual Basic, Korn Shell Script; AWK, MSDOS  Batch)

n  Teradata Certified Master certification level

n  Developed and Executed complex Ad-Hoc queries against the Enterprise Data Warehouse

n  Analyzed, designed and coded single-threaded and multi-threaded ETL applications in C/C++, VBScript, Awk, Korn Shell Script, and Perl  including Shared Memory queues and scripting in Unix and scripting, static executables/libraries and dynamic link libraries (dll) Windows 95/NT/2000/XP.

n  Analyzed and redesigned code and scripts to reduce runtimes, sometime as much as 1% of original execution time for production programs and eliminated many redundant processes.

n  Developed new code and migrated old code from the Unix Platform to the new Windows 2000 Active Server platform.  Implemented VBScripts to replace the Korn shell scripts and worked with the team to redesign the production system to work in the new environment.

n  Designed and maintained the ErWIN/Modelmart data models for the two Speedway corporate data warehouses.

n  Served as DBA, System Administrator, Data Modeler, Analyst, and Project Lead as needed.

n  Mentored new members of the data warehousing team. Enabled new team members to get up to speed on the current data warehouse and production module rapidly while maintaining the system reliability.

n  Developed scripts utilizing native UNIX and Windows 2000 utilities to automate the manual performance monitoring and reduce the time needed to monitor the daily loads and performance of the production runs.

n  Developed a monitoring database in Access 2000 and Excel 2000 to keep track of the statistics from production runs.

Senior Programmer Analyst, Standard Register,  Dayton, OH, August 1997-June 1999

(RS6000 AIX , AIX C/c++, Oracle 7.x/8.x, TUXEDO 6.0/6.4, SQL*LOADER  & SQL*PLUS, Korn Shell Script; Awk)

n  Programming and Analysis of highly complex C++ classes and ORACLE/TUXEDO software in support of a manufacturing Order Capture and Pricing Software.

n  Software configuration management using PVCS for multi-stage development environment from unit test, integration, user acceptance testing, and Production. This involved maintaining FIVE different application environments concurrently.

n  Development of new TUXEDO Services in C++/TUXEDO/ORACLE (embedded SQL) for existing Servers.

n  Updated and monitored complex TUXEDO bulletin boards in various environments including Production systems. Created significant improvements in the existing build process to reduce the build processing time from 24 hours to 2-4 hours.  Reduced the number of build processes from five to two which simplified the build process.

n  Developed AWK and SQL*PLUS scripts for use by STAR production support team to speed up research and analysis of production problems.

Senior Programmer Analyst, Computer Sciences Corporation, Fairborn, OH, August 1996-August 1997

(HP9000 HPUX 9.0-10.1, DEC Alpha- C, Oracle 7.x PL/SQL, SQL*LOADER & SQL*PLUS, Bourne/C Shell Script; Hewlett Packard Series 3 Pentium- HTML 3.2)

n  Analyzed complex and mutable requirements for the Defense Commissary Information Systems (DCIS) automation which will allow the Defense Commissary Agency (DeCA) to become an independent and self-sustaining organization.  Designed flexible solutions to the Financial Accounting Fund and Inventory Management (FIA) package within DCIS to minimize the impact of changes in requirements in addition to meeting the tight scheduling constraints. Directly interfaced with the customer to clarify and establish requirements. 

n  Developing World Wide Web site for the Innovative Solutions Center of Computer Sciences Corporation.

n  Developed new C programs to perform conversion from raw Print Files on a EBCDIC mainframe into pre-formatted SQL*LOADER ASCII flat files suitable for loading into an ORACLE 7 DBMS on HP9000 for the Defense Logistics Agency JCALS project.

n  Analyzed and Updated existing C/SQL code for input parsing and validation for the Automated Item Manager (AIM) software to decrease execution time. Updated C/SQL database load process to conform to modified input formats. Analyzed and corrected table design for AIM on ORACLE 7.0 database.

Doctoral Student Teaching Assistant, Wright State University,  Fairborn, OH, August 1993-August 1996

(Sun SPARC III, DEC ALPHA, UNIX- GNU g/g++, RPC, C shell script; IBM 386 -Turbo C++ 3.1 Turbo PASCAL 7.0)

n  Developed and graded Laboratory Assignments for Introductory Programming Students and provided support for first three programming courses in both Turbo C/C++ and PASCAL.

n  Developed c++/RPC projects for various graduate level courses including computation analysis, distributed computing, concurrent programming, and compiler design.

Programmer Consultant, Community Mutual Insurance Company,  Cincinnati, OH, November 1992-January 1993

(IBM RS/6000 AIX - C, CL/7, CAI Net)

n  Developed new client-server applications for provider electronic data exchange between IBM mainframe and mini- computers.

n  Mastered the client-server development environment CAI Net and C programming extension CL/7 in less than 1 month enabling the projected completion period of the application to be reduced by two-thirds.

Programmer Analyst, Logicon,  Beavercreek, OH, August 1990-November 1992

(Sun SPARC II - C, Motif/X-Windows, Bourne/C Shell Script, FORTRAN; IBM 4381/9370/9121- COBOL, ADS/O, IDMS,  ISPF, REXX, VM/ESA)

n  Developed, tested, and maintained C /Motif and FORTRAN code for input processing and validation for the Graphical User Interface (GUI) dialogs in X Windows for the B-2 mission planning system. Highest Clearance Received: Top Secret with special access. Designed, updated, and maintained COBOL, IDMS, and ADS/Online code and corresponding documentation to support mainframe database for the B-2 mission planning system.

n  Updated Neural Network Software C code which implemented Artificial Intelligence Software for Radar Emitter Identification for IRAD for Department of Defense.

n  Adapted quickly to a variety of languages, compilers, editors, operating systems, and equipment.  Developed code in a variety of environments including batch and interactive code for IDMS database access and other information systems processes.   Learned to shift seamlessly from one environment to another frequently.

n  Designed code, test procedures, and documentation using structured techniques that conform to the government standards for requirements specification, top level design specification, and detailed design specification, and coding.   Created and updated utilities to increase programmer productivity and contributed an article outlining a set of procedures for software development and integration/testing process.

Programmer Analyst, Retail Control Systems Incorporated, Kettering, OH, August 1989-August 1990

(NCR Tower 450/700 UNIX, Unisys UNIX, IBM RT AIX, IBM 286/386 UNIX/DOS - Progress, C)

n  Designed new code and provided database and software quality assurance for retail inventory applications in Progress and C for a variety of UNIX platforms.

n  Provided technical support both for in-house developers/support personnel and for customers.

Government Related Information:

Highest level clearance (not active): Top Secret Clearance with Special Access Required

Current level clearance (active): Secret

9+ years experience Government Standards and Techniques

Education:

n  M. S. Computer Science, University of Dayton, Grade Point 3.61 on 4.0 scale, awarded Graduate Teaching Assistantship.

n  B. S. Computer Science/Systems Analysis,  University of Dayton, Grade Point 3.67 on 4.0 scale, Cum Laude.

HONORS/ACCOMPLISHMENTS/pUBLICATIONS:

n  Teradata Certified Master (2004)

(Teradata Certified Professional, Implementation Specialist, SQL Specialist, Teradata Certified Application Developer, Teradata Certified Designer, Teradata Certified Administrator)

n  Member, IEEE (December 2000 – Present).

n  Member, American MENSA (March 1996 – Present).

n  Dean’s List (University of Dayton, 1982-1986)

n  Co-authored User’s Guide for Intermax: Balloun, J. L., Oumlil, A. B., and Merenski, D. C., “A User’s Guide to INTERMAX: A Program for Rotation in Orthogonal Factor Analysis.”  University of Dayton, 1986

n  Acknowledged for programming assistance in: Balloun, J.L., and Oumlil, A. B. (1986) “A program for Intermax Rotation and Orthogonal Factor Analysis.” In Behavior Methods, Instruments, and Computers.