Resume

Resume Details
A. B.
Location	West Chester, OH
Contact	Click to View Contact
Source	Direct Candidate
Salary	N.A.
Rate	N.A.
Resume

S U M M A R Y 

Has over twenty years of experience in the Information Technology industry. His vast experience includes database design, development, normalization, transformation, and loading for the enterprise data warehouse.  He also has extensive expertise in data modeling using ERWIN.  His other skills include development in traditional and object oriented languages, training, testing, team leadership, and systems administration. He is well versed in ETL (Extract-Transform-Load) methodologies used in data warehousing. Recent experience includes data cleansing activities for the Air Force enterprise migration effort and canonical modeling for Kroger.


T E C H N I C A L    S K I L L S

Languages: Java,  C-C++, Visual Basic, SQL, PERL-ModPERL, VBScript, HTML, XML, Informix-4GL, FORTRAN, UNIX scripts, Windows Scripts, TeraData Fastload-Multiload-bteq scripts, Informatica Workflows 

Software:  Erwin, Eclipse, Microsoft Project, VISIO, Access, Excel, Word, PowerPoint, Prezi, Outlook, Informix SQL, Sybase, Oracle, SQL Server, NCR TeraData V2R5, DB2, Informatica ETL, Altova Mission Kit

Environments:  Unix-Ultrix-Linux, X-Windows, Microsoft Windows

Security Clearance:  Secret





E D U C A T I O N - C E R T I F I C A T I O N


B.S., Computer Science
Olivet Nazarene University

Teradata Certified Master

?

 Work Experience

Employer: KrogerNovember-2011 - Present
Industry: Retail
Project: Data modeling, Canonical Modeling, and XSLT development.
Role: Data Specialist

Projects Overview:  Data Modeling support for warehousing, master data management, and application databases.
 
Contributions:
Relational and Dimensional Data modeling using Erwin.
Canonical Modeling for industry standard and custom models. 
Reverse engineering database structures and augmenting relationships and metadata through introspection and subject area expert interviews.
Logical and Physical Modeling support for transactional and reporting systems.
Provided peer training for Data Modeling best practices and Erwin techniques. Wrote technical manual to support training and employee acquisitions.
Provided support for project management during design, development, testing, and implementation.
Provided input for selection of Enterprise Glossary and Metadata software.
 
Environments:  Erwin Data Modeler v8, Erwin API, Altova XML Spy, Altova Schema Agent, Altova MapForce, Altova Database Spy, Tortoise SVN


 Work Experience

Employer: The Coffing CorporationSeptember-2006 - September-2011
Industry: Data warehousing for the Air Force
Project: Data cleansing, transformation and warehousing efforts.
Role: Project Lead

Projects Overview:  Designed and implemented data normalization, transformation, and loading for the enterprise data warehouse. Data Modeling and Database support for data cleansing efforts.
 
Contributions:
Relational and Dimensional Data modeling using Erwin.
Developed an interface to assist in modeling using the Erwin API. 
Delivered a data model representing the data in third normal form.
Created Informatica worklets and workflows to load data into the warehouse.
Coordinated efforts of Programmers.
Provided support for project management during design, development, testing, and implementation.
Developed a system to create Extract-Transform-Load (ETL) procedures from the information read from the Erwin model.
Supported Oracle, SQL Server, and TeraData databases

Environments: java, Oracle 10g, TeraData V2R5, TeraData BTEQ scripts, Erwin Data Modeler v7, Erwin API, Visual Basic .NET, Perl scripts, Unix k-shell, Informatica 8.1


 Work Experience

Employer: Kronos April-2004 - May-2006 
Industry: Time and Labor Management
Project: Acquisitions team.
Role: Software Engineer

Projects Overview:  Performed customer support for Matrix Systems products and designed and implementation of the interface from Matrix readers to the Kronos Workforce time and labor systems.
 
Contributions:
Handle customer issues.
Wrote and presented formal functional specifications for approval.
Developed a detail design of the Matrix reader interface.
Created a bridge database and procedures for validation of employees and employee input at Matrix readers.
Coordinated efforts of Programmers.
Developed Database structures and procedures that allow data exchange between Oracle and SQL Server.
Developed XML interface procedures using java.
Implemented the interface at customer sites that continue to use Matrix readers with their new Workforce systems.

Environments: java, Oracle 9i, Microsoft SQL Server, Visual Basic


 Work Experience

Employer: Matrix SystemsDecember-2001 - April-2004
Industry: Security Systems and Time Tracking
Project: Standard product release for Physical Security and Time  Attendance system.
Role: Product Development Engineer

Projects Overview:  Matrix Systems has 2 product lines. One controls physical access, the other records time transactions and calculates payroll.
 
Contributions:
Gathered requirements from customers.
Wrote and presented formal functional specifications for approval.
Developed a detail design of new functionality.
Initiated development procedures to enable version control for triggers .tables and stored procedures.
Coordinated efforts of VB Programmers and Database development
Designed data distribution on multiple hosts in an enterprise wide computing environment

Environments: Microsoft SQL Server triggers-stored procedures, Visual Basic .NET


 Work Experience

Employer: Theoris (Formerly Software Synergy Inc.) November-1996 - December-2001 
Industry: Consulting
Contributions:
Executed duties as a programming consultant at many assignments.
Assisted with internal management and coordination efforts of other consultants.

Consulting Assignment (Theoris)

Client: Matrix Systems - 14 months
Industry:  Time and Attendance - software house
Project: Initial release of a new windows based product
Role: Database designer, DBA, Database development, Programmer

Projects Overview:  Assisted in the first major release of the product. The system handles time calculations for hourly and salaried employees. The system also interfaces to other payroll, security, and scheduling systems.

 
Contributions:
Coordinated software development, issue resolution, and sales demonstrations.
Designed database changes to facilitate enhanced system functionality.
Developed database functions, stored procedures, and structures.
Designed and implemented cooperative data exchange with a physical security system.
Designed and implemented a system to log database updates in a permanent, searchable form.
Maintained and enhanced the data collection interface.
Implemented a Visual Source Safe strategy for source code control.

Environments: Windows 2000 Server, SQL Server 2000 , Visual Basic .NET


Consulting Assignment (Theoris)

Client: Matrix Systems - 6 months 
Industry:  Physical Security - software house
Project: Worldwide security system for a major multi-national corporation
Role: Database designer, data modeling, DBA, Database development

Projects Overview:  Assisted in a major release of the physical security system that allows for distributed processing and data storage. The new release is designed to run on multiple regional servers with a central repository for doing ad-hoc reports on historical data.

 
Contributions:
Assisted in the design of flexible user input screens.
Designed database changes to facilitate enhanced system functionality.
Developed database functions, stored procedures, and extended stored procedures.
Designed and implemented replication scheme to distribute data to regional servers.
Designed system for collecting historical events and transferring them to a central database for long-term storage and reporting.

Environments: Windows 2000 Server, SQL Server 2000 , Oracle 8i, Visual Basic, Visual C++


Consulting Assignment (Theoris)

Client: BF Goodrich - 3 months 
Industry: Aerospace
Project: CRM
Role: Development, system integrator

Projects Overview:  Designed and implemented enhancements to the information storage and retrieval system for worldwide customer support.

 
Contributions:
Designed and deployed enhancements to the Customer Relations Management system.
Increased reliability of data that is exchanged with other systems.
Enhanced system usability and improved the user interface.
Added enhanced task tracking, including overdue task notifications.

Environments: Microsoft Outlook, VB Script, SQL-Server 7.0, EC-Knowledge


Consulting Assignment (Theoris)

Client: Thinkronize - 8 months 
Industry: Web Research
Project: Searchable web content repository
Role: Lead Developer

Projects Overview:  Develop a system for web site storage and retrieval. Web content is reviewed for quality and content. The reviews are gathered through a web interface and stored in a SQL database. When the information is cataloged and categorized it is published to a database that is searchable from a web interface. Search criteria can be based on topic, key words, or famous persons. The search engine is available at www.nettrekker.com.

 
Contributions:
Web front-end for data entry function.
Triggers and functions to support data entry and database integrity.
Perl scripts to publish gathered information and pre-compile HTML elements for fast retrieval.
Developed the search engine to retrieve information from the database and return dynamic HTML.

Environments: Linux, Apache Server, Mod-Perl, HTML, XML, Informix-SQL, stored procedures, SQL functions, perl scripts, UNIX make utility, VISIO


Consulting Assignment (Theoris)

Client: BF Goodrich - 9 months 
Industry: Aerospace
Project: CRM
Role: Development, Documentation, Testing, Training, Integration

Projects Overview:  Developed a Trip report system for customer relationship tracking. Outlook based system with worldwide information exchange.

 
Contributions:
Designed and developed Outlook forms and procedures for data entry.
Developed data exchange system for synchronizing customer information with central customer database.
Migrated customer information from an Access database to SQL Server.
Managed project timelines and deliverables using Microsoft project.
Developed training materials and user documentation.

Environments: Windows NT, Outlook Forms, Visual Basic, SQL Server, EC-Knowledge, Access, Microsoft Project


Consulting Assignment (Theoris)



Client: Lexis-Nexis - 10 months 
Industry: Information Warehousing
Project: Y2K Compliance
Role: Team Leader

Projects Overview:  Review and prove that all software was Y2K compliant and would function correctly in 2000. 

 
Contributions:
Developed an Access database to track the 300+ applications.
Directed the efforts of consultants and employees on the team.
Fixed bugs in applications, daemons, and scripts.
Assisted in source code management.
Directed the testing and certification of over 300 applications.

Environments: UNIX, Windows NT, Perl, c-shell, bourne shell, C, C++, SABLIME (source code management system)


Consulting Assignment (Theoris)

Client: Reynolds  Reynolds - 1 month
Industry: Automotive Dealership Software House
Project: Custom Reports
Role: Department Manager

Projects Overview:  Managed customer expectations during company down-sizing.

 
Contributions:
Assigned tasks.
Trained department personnel.
Managed customer expectations.

Environments: Windows, Proprietary report writer.


Consulting Assignment (Theoris)

Client: BF Goodrich - 15 months 
Industry: Aerospace
Project: Data Migration and Modernization
Role: Consultant

Projects Overview:  Upgrade numerous information systems. Web-enable some data. 

 
Contributions:
Migrated data from DataTrieve, Dbase III, Lotus 123, and Access 2.0 to Access 97.
Collected system requirements and developed cost estimates.
Completed system design and documentation.
Data Conversion and system security.
Testing, training, and system documentation.

Environments: Windows NT, Visual Basic, Microsoft Access, Microsoft Front Page


Consulting Assignment (Theoris)

Client: St. Mary*s Children*s Services - 2 months 
Industry: Charity
Project: Contribution and Volunteer tracking system
Role: Database Designer

Projects Overview:  The system was used for tracking donors, volunteers, and contributions during a major fund raising campaign.

 
Contributions:
Gathered system requirements.
Designed Tables and Data Relations.

Environments: Windows 95, Microsoft Access.


Consulting Assignment (Theoris)

Client: Computer Associates - 3 months 
Industry: Network Software House
Project: Port Network Administration software to DEC Alpha
Role: Lead Consultant

Projects Overview:  Network monitoring software enables users to view the status of any machine connected to the network. System backups and scheduled tasks were an integral part of the system. 
 
Contributions:
Migrated software to Dec Alpha platform.
Software tracing and debugging.
Coordination of bug fixes.
System testing.

Environments: DEC Alpha, Digital UNIX, C-C++, sockets, message queues, shared memory, interrupt handlers.


Consulting Assignment (Theoris)


Client: Teleres - 10 months 
Industry: Commercial Real Estate
Project: Organize and consolidate data from various sources and deliver  information through a web interface
Role: Lead Developer

Projects Overview:  Data was purchased from various sources, consolidated and organized for use by developers and other users involved the commercial real-estate industry.

Contributions:
Directed the efforts of two other application developers.
Designed a system of fuzzy logic to match records with a high probability of association.
Automated the process of retrieving information from a UNIX tar tape and processing it on a SQL Server. The compiled information was then transferred to Sybase running on a Sun SPARCserver.
Wrote a series of C programs and scripts that formatted the data from the tapes into a form readable by SQL Server.
Provided management information to the sales and marketing staff.

Environments: Sun OS, Windows NT, tar, sed, awk, csh, C, Visual Basic, SQL Server.



 Work Experience

Employer: Measurex (Now Honeywell) June-1984 - November-1996
Industry: Continuous Manufacturing
Project: Standard product release for production tracking system.
Role: Product Development Engineer

Projects Overview:  The core product contains systems to manage orders, production planning, production optimization, scheduling, product routing, quality, inventory control, order fulfillment, and shipping. The system contains over 700 application modules, and uses over 300 tables to manage information.
 
Contributions:
Gathered requirements from marketing, project management, and customers.
Wrote and presented formal requirements documentation.
Detail design of new functionality, design review, database design, and application development.
Wrote documentation for system procedures and application usage.
Developed training materials for marketing and sales, project management, and technical staff
Designed data distribution on multiple hosts in an enterprise wide computing environment

Environments: Unix, IBM AIX, X-Windows, Motif, Microsoft Windows, VMS, Informix SQL, Data Flow Diagrams, Unix shell scripts, FTP, cron, Visual Basic, HTML 


Industry: Pulp and Paper Manufacturing
Project: Customize Standard product for use by Asia*s largest paper producer
Role: Programming Lead

Projects Overview:  Functionality added to standard product to handle complex scheduling, routing, and manufacturing processes. The system scheduled and tracked product throughout the manufacturing process. Product is sold as paper rolls, large sheet goods, cut-size (copier) paper, and finished consumer goods such as spiral bound note-books with a printed cover.

 
Contributions:
Designed and implemented systems for scheduling production and materials usage .
Gathered system requirements from customer representatives.
Designed distributed database for all scheduling and material handling functions.
Managed programming team with 2 to 6 members


Environments:  IBM AIX, Informix SQL, Data Flow Diagram Objects
<< Back
Resume

Similar Candidates
