David Hensel Email & Phone Number

San Diego, Ca, Usa

Performance Management Practice(Performance and Workload Management COE)Served as a senior team member of the Performance Management Practice, originally the Performance and Workload Management COE, developing and delivering consulting services, intellectual property and engagement deliverables for account teams and customers pertaining to the group’s organizational mandate for On-Premise Enterprise and Appliance Systems as well as Enterprise Cloud Systems on Amazon Web Services (AWS) and Microsoft Azure.Performance Data Collection:Performance Optimization:Workload Management:Capacity Planning:Database Administration and Management:Training and Mentoring:Customer specific consulting requirements:

Data Warehousing Solutions ConsultingExpress Scripts – Minneapolis, Minnesota – (October 2007 – January 2008)Served as a Teradata Technical Lead and Project Coordinator assisting the Teradata project team.Cisco System – San Jose, California – (April 2007 – June 2007)Served as a Teradata Technical Lead assisting the Teradata project team.The Hershey Company – Hershey, Pennsylvania – (January 2007 – March 2007)Served as a Teradata Technical Lead and Teradata Database Architect assisting the Teradata project team.Citi Cards – Deerfield, Illinois and Jacksonville, Florida – (March 2006 – December 2006)Served as a Senior Teradata Database Administrator responsible for Teradata Database Infrastructure, PhysicalDesign, and SQL Performance Optimization Specialist assisting the Teradata project team.Express Scripts – St. Louis, Missouri – (October 2005 – March 2006)Served as a Teradata Data Integration Architect responsible for Teradata Database Infrastructure, Physical Design,and SQL Performance Optimization Specialist assisting the Teradata project team.BlueCross BlueShield of North Carolina – (November 2004 – May 2005)Served as a Teradata DBA Advisor, Mentor, Training Instructor, and System Maintenance and Automation Facilitator.RDBMS Migrations from DB2 to Teradata:Teradata Enterprise Data Warehousing Consulting:Teradata Infrastructure Support:Teradata Database Administration:Teradata Workload Management:Performance Optimizations:Training and Mentoring:

North Carolina, United States

Data Warehousing Solutions Consulting

North Carolina, United States

Database AdministrationResponsible for Teradata Database Administration group task assignments for project support and senior level consulting.Provided proactive Teradata database analysis for capacity and workload planning, infrastructure design, implementation and maintenance.Served as the Lead Teradata Database Administrator since the introduction of Teradata to Lowe’s.Responsible for overseeing 3 major Teradata upgrades and 2 major Teradata migrations.Served as the Teradata database performance tuning specialist and physical design subject matter expert.Assisted with the performance evaluation of the testing results and the implementation of TDCM/Teradata Demand Chain Management for Seasonal Profiling.Responsible for the analysis of the mixed application workloads for developing the appropriate Priority Scheduler Facility resource partitioning, allocation group and performance group weightings, settings and modification scheduling.Coordinated the design, development, implementation, execution, and results collection evaluation of Teradata application benchmarks and stress tests for a very large hardware upgrade from a coexistent system of 48 - 5250 Nodes and 8 - 5380 Nodes with 18+ Terabytes of usable disk space to a system of 36 - 5380 Nodes with 38+ Terabytes of usable disk space then followed by an upgrade of an additional 12 - 5250 Nodes to return to a coexistent system with 45+ Terabytes of usable disk space.Additional accomplishments include Teradata V2R5 upgrade planning, new feature analysis and application support as well as training and mentoring of Project Managers, Sr. Developers, Teradata Junior Database Analysts and Database Administrators.

North Wilkesboro, North Carolina, United States

Database AdministrationResponsible for Teradata Database Administration, design, performance tuning, workload analysis and application support for information warehouse decision support using MicroStrategy, data mining using KD1/Net Perceptions and customer relationship management (CRM) using CERES/Teradata CRM.Designed, developed and implemented automated processes for system maintenance including historical collections of ResUsage, AmpUsage and Access Log information for workload analysis and reporting.Teradata Security Administration duties including the design and implementation of an automated process for creation and maintenance of logon ids, the setup of permanent database level access rights and the design and automation of a temporary object level authorizations process.Advised the information warehouse development team of ‘best practices’ for the design and implementation of complex ETL architecture.Responsible for optimizing space management for Production, Pre-Production and Test Teradata systems.Coordinated the design and implementation of the Teradata database infrastructure for the first Production site implementation of the CERES/Teradata CRM tool for campaign management.Specific accomplishments include Teradata hardware and software upgrade analysis, capacity planning and coordination for a complete Production system migration of the enterprise data warehouse.

North Wilkesboro, North Carolina, United States

Database AnalysisTeradata database implementation of physical database design, backup, recovery, maintenance and support as well as system workload analysis and capacity planning.Specific accomplishments include the initial evaluation, the planning, design and implementation of the infrastructure for the Teradata database environment in preparation for conversion/replacement of an existing DB2 information warehouse.DB2 database administration, application development analysis, implementation of physical database design, backup, recovery, maintenance and support.Assisted application development with process design, analysis and implementation using IBM and BMC Utilities for Loading and Unloading of DB2 Table data. Specific accomplishments include the consolidation of multiple Tablespaces into a single Large Tablespace for the information warehouse in DB2 version 5.

North Wilkesboro, North Carolina, United States

Application Programming and AnalysisCOBOL, CICS application development for the financial area of Systems Development.Design, development and implementation of batch and on-line applications in financials.Modification support and maintenance of the American Software International’s accounts receivable system (DB2 version).Additional project support for various other areas of System Development.Specific accomplishments include conversion of various CICS programs from APPC to TCP/IP for store communications with the host mainframe.

Charlotte, North Carolina, United States

Database AdministrationDB2 database administration, analysis, maintenance and support.Develop backup and recovery procedures for the DB2 based AMS Advantage 2000 financial system.Assist with SQL tuning and process procedures for the application development staff.On the job self-training to obtain the desired knowledge and experience to become proficient in DB2 database administration.

North Wilkesboro, North Carolina, United States

Application Programming and AnalysisCOBOL, CICS application development for the financial area of Systems Development.Design, development and implementation of batch and on-line applications in financials.Modification support and maintenance of the American Software International’s accounts receivable system (DB2 version).Additional project support for various other areas of System Development.Specific accomplishments include DB2 database and applications design, development and implementation of the accounts receivable customer statements and collection system reporting.

Gastonia, North Carolina, United States

Applications Programming and Project ManagementServed as the application development project leader and specialist for the sales and marketing division of information systems.Responsible for the design, development and scheduling of batch and online applications in sales and marketing, finance, catalog services and engineering analysis.Provided additional application development for manufacturing, production planning and inventory control.Specific accomplishments include DB2 database and applications design, development and implementation of the customer sales rebate invoicing system.

Gastonia, North Carolina, United States

Application Programming and AnalysisResponsible for research and development in new areas of information engineering, data access and applications development.Specific accomplishments include DB2 database and applications design, development and implementation of the financial budgeting system.

Gastonia, North Carolina, United States

Application Programming and AnalysisResponsible for gathering user requirements for design, development and implementation of batch and online applications.Specific accomplishments include IMS database and applications design, development and implementation of the catalog services branded catalog printing system.

Gastonia, North Carolina, United States

Application Programming and AnalysisProvided COBOL, COBOL/CICS application development from provided task specific design and process specifications.Specific accomplishments include the conversion of the online catalog services product management system from CSP to COBOL/CICS.

Business Technology

Aas Business Computer Programming, Computer Science, Mathmatics

Computer Science

Mathematics And Computer Science