OBJECTIVE:

• Seek a consultant or Full Time role as a DBA, ETL Developer, Data Modeler,Business Analyst or Data Analyst where my and experience can be fully utilized and where I can make a significant contribution to my employer

SUMMARY:

• Over 30 years of IT experience
• Over 15 years of DBA/ETL development experience
• Experience in all phases of system development
• Project Management experience with teams of up to 5 developers
• Database Modeling (conceptual, logical, physical models) using ERWIN (7.3, 8) or PowerDesigner.
• Use of Microsoft Office, including Word, Powerpoint, and Excel to document results and create supporting documents. Macros in Word and Excel (also VBA scripting in Excel)
• Using Informatic to perform simple transforms
• Database management in Teradata
• Experience in DBA functions
• Optimize SQL using explain plans
• Performed ETL using MultiLoad, FastLoad, and TPump for Teradata
• Exported data for loading into different users using FastExport
• Created MultiLoad inmod using C++
• Worked with WinDDI, Queryman, and Teradata Manager
• Wrote stored procedures using Store Procedure Language
• Create and modify metadata
• SQL Server - small projects
• Database management in ORACLE 8, 8i, 9i, 10g
• Experience in DBA functions
• Optimize SQL using explain plans
• Performed ETL using SQL Loader
• Wrote stored procedures, functions, and packages using PL/SQL
• Using RMAN for backup/recovery
• Use 10g and RAC to build more reliable Oracle Database
• Support Oracle Application Server and Oracle Web Server
• System Development in Delphi, Visual Basic, and Synergex DIBOL
• Support Novell Netware, Windows NT, Windows 2000 Advanced Server, and Solaris,
• Maintain Accounting system and programmed enhancements in DIBOL on VAX
• Maintaining software and hardware
• Technical support of users
• Customizing commercial software using macros to develop complete systems
• Analyzing existing manual procedures to produce more efficient streamlined processes
• Develop and deliver presentations for various audiences on or project status

TECHNICAL SKILLS:

Programming Languages: Visual Basic. Visual C++, Delphi, DIBOL, COBOL, C, FORTRAN

Operating Systems: VMS, DOS, Windows 3.1, Windows 95, 98, NT, 2000, Solaris, Unix, Linix

Database: Oracle (8, 8i, 9i,10g), Teradata, Netezza, Access, Paradox, FoxPro

PROFESSIONAL EXPERIENCE:

Confidential, Nashville, TN

Teradata DBA/SQL Server Deployment/Apps Development Sr Specialist

Responsibilities:

• Prepare Best Practice for Teradata
• Subject Matter Expert in Teradata
• Teradata Performance Analysis & Tuning including SQL scripts that show resource usage and poor performing SQL
• Work/Administer Teradata Labs

Confidential, Charlotte, NC

Teradata Developer/Apps System Engineer

Responsibilities:

• Prepare Best Practice
• Subject Matter Expert in Teradata including SQL scripts that show resource usage and poor performing SQL
• Performance Analysis & Tuning
• Data Modeling of existing systems including reverse engineering

Confidential, Rochester, NY

Teradata DBA

Responsibilities:

• Subject Matter Expert in Teradata including SQL scripts that show resource usage and poor performing SQL
• Data Modeling including reverse engineering systems in Oracle and converting data models to Teradata
• UTC Aerospace Charlotte, NCTeradata DBA CDI/IBM
• Performance tuning including SQL scripts that show poor performing SQL
• Documenting Informatica workflows
• Table Compression
• Aggregate Join Index

Confidential, Charlotte, NC

Data Modeler/DBA

Responsibilities:

• Data modeling using PowerDesigner 16.5
• Implementing database changes/scripts in Netezza
• Create/Track issues with database changes with development teams
• Create/maintain system documentation such as High Level Design, Low Level Design, Source to Target

Confidential, Columbus, OH

Teradata DBA

Responsibilities:

• Implementing database changes/scripts in Teradata for UAT and Production environments
• Create/Replace DataMover jobs
• Create/Track issues with database changes with development teams

Confidential, Winston-Salem, NC

Business Analyst

Responsibilities:

• Provide technical support for users adding information to BB&T databases
• Assist in developing database systems
• Create test plans and perform testing to various system upgrades
• Interview stake holders in new systems to determine requirements
• Create reports using SAS
• Create objects in DB2, tables, views

Confidential, Charlotte, NC

Business Analyst/Oracle DBA/Data Modeller

Responsibilities:

• Creating HLD and LLD documents for Wholesale Credit Information Systems being duplicated in a central repository
• Performing data modelling using PowerDesigner (physical models)
• Creating/Updating Oracle Database and Object creation scripts
• Working with Golden Gate team to create near real data replication using log scraping
• Working with Informatica team to load data that cannot be loaded in a near real time manner using text files

Confidential, Charlotte, NC

Teradata DBA / ETL Developer/Data Modeller

Responsibilities:

• Performing data modelling, ETL development, and performance tuning using FastLoad, MultiLoad, and BTEQ scripts in Teradata warehouse
• Perform DBA functions such as Performance tuning, Space requirements (PERM, SPOOL), Rights/Role administration in Teradata warehouse
• Perform Space usage and performance tuning of top 50 resource consuming queries using Performance Data Collection and Reporting (PDCR) in Teradata warehouse
• Using ERWIN to create/maintain models for the Wholesale Risk model (logical and physical models) and other logical/physical models in Teradata warehouse
• Create/modify Unix/Linux scripts to automate loading/transforming data
• Create/modify Unix/Linux scripts to export data from existing data warehouse to downstream data systems
• Perform project management tasks
• Customize databases,tables, and statistics for use with BI systems
• Assist Reporting and BI teams for efficient use of the data warehouse
• Using Informatica to load text files to staging tables and staging tables to target tables
• Enhance performance of queries using Database Query Log (DBQL) and Resource Usage (RESUSAGE) tables/views
• Assist in Netezza proof of concept for converting ECRIS data warehouse from Teradata
• Create and run SQL in Netezza to verify tables and views
• Ran various Netezza utilities to check system status and databases
• Trained in Netezza and ran terst cases in sandbox to evaluate moving Teradata systems to Netezza
• Small projects involving SQL Server