OBJECTIVE:

Seek a consultant or Full Time role as an IT professional 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,Excel, and Visio to document results and create supporting documents.
• Confidential 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 Confidential 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

COMPUTER 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, Charlotte, NC

Business Analyst / Data Analyst

Responsibilities:

• Develop Teradata Stored Procedures
• Develop Teradata Tables and views
• Perform Data Analysis and Verification
• Create Business and development documents FSD, TDD, Source to Target mappings
• Use Power Designer to redesign and update Erwin models

Confidential, Charlotte, NC

Teradata Developer

Responsibilities:

• Develop Teradata Stored Procedures
• Develop Teradata Tables and views
• Perform Data Analysis and Verification

Confidential, Nashville, TN

Teradata DBA/SQL Server Deployment/Apps Development Sr Specialist

Responsibilities:

• Deploy SQL server scripts to QA/UAT/PreProd for SQL Server 2005 thru 2014
• 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 including
• Creating databases, users, roles, rights
• Creating tables, views, macros
• Use Viewpoint to manage the lab system
• Optimize performance
• Use Teradata load utilities to load tables

Confidential

Teradata Developer/System Engineer

Responsibilities:

• Prepare Best Practice for Teradata users
• Subject Matter Expert in Teradata
• Performance Analysis & Tuning
• Perform Data migration from SQL Server to Teradata

Confidential, Rochester, NY

Teradata DBA

Responsibilities:

• Prepare Best Practices for Teradata development teams
• Object Creation
• Subject Matter Expert in Teradata

Confidential, Charlotte, NC

Teradata DBA

Responsibilities:

• Performance tuning
• Documenting Informatica workflows
• Table Compression
• Aggregate Join Index

Confidential, Charlotte, NC

Data Modeler/DBA

Responsibilities:

• Data Modelling 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 Confidential & Confidential 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 SASp
• Create objects in DB2, tables, views

Confidential, Charlotte, NC

Business Analyst/Oracle DBA/Data Modeler

Responsibilities:

• 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 Modeler

Responsibilities:

• Support Enterprise Credit Risk Information System as needed
• Performing data modelling, ETL development, and performance tuning using FastLoad, MultiLoad, and BTEQ scripts isin 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
• Perform Data Migration from existing data warehouse to new data migration
• 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
• Record/modify Business Rules
• 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

Confidential, Charlotte, NC

Teradata DBA / ETL Developer

Responsibilities:

• Project for Confidential Enterprise Credit Risk Information System
• Data modelling (physical model)
• ETL development using FastLoad, MultilLoad, and BTEQ scripts
• Performance tuning

Confidential, Raleigh, NC

Teradata DBA / ETL Developer

Responsibilities:

• Project for Confidential via Teradata
• Develop ETL programs using Teradata, Basic Teradata Query language(BTEQ), SQL, and MultiLoad (MLOAD)
• Develop scripts for UNIX to run the ETL programs, UNIX scripts that control the processing of BTEQ scripts, including processing lists that control the execution order of the BTEQ scripts and record details of the processing in tables that can be queried to find what executed, when it executed, and any errors encountered problems
• Perform DBA functions such as Space requirements, Performance tuning and User Management
• 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
• Run scripts and programs through test plans to validate results
• Promote scripts and programs through Test, QA, and Production environments

Confidential, Dayton, OH

Database Administrator / Data Management

Responsibilities:

• Develop Teradata database using ERWIN and Rational Rose
• Create logical and physical models and initial database creation SQL scripts
• Teradata DBA for Financial Resource System, both development and production database
• Monitor database space needs, Reallocate space as needed
• Used Veritas and Tape carousel to backup and restore databases and objects
• Optimize SQL using explain plans
• Writing input modification routines for FastLoad and Multiload utilities
• Perform ETL functions using Teradata tools, FastLoad, MultiLoad, TPump to load data in various situationslp
• Writing Stored Procedures in Teradata Stored Procedure Language
• Writing Stored Procedures in Teradata using dynamic SQL
• Writing BTEQ scripts to perform database modifications
• Write and execute test plans for enhancements for Teradata based system
• Maximize performance for SQL using explain plans
• Use Ward-Analytics Visual Edge to tune access to Teradata
• Enhance systems by implementing customer enhancement requests in Teradata based system
• Create and modify metadata with both logical and physical data
• Writing UNIX scripts that controlled execution of Oracle utilities
• Remote DBA consisting of all database functions for over 20 instances of Oracle 8i and 9i databases including: monitoring database script execution performance tuning database refreshes database upgrades user creation using Oracle 8i and 9i backup and recovery using RMAN
• Develop Oracle database using Embarcadero ER/Studio
• Oracle 9i DBA for Automated Business Support System
• Create Oracle objects including tables, views, sequences, and indexes
• Programmed procedures, functions, and packages used by the application
• Programmed procedures to convert from legacy structures and data to new system structures
• Created scripts for SQL Loader loading of converted data into new system
• Monitored system performance
• Worked with architecture team designing disk array for Oracle database
• Use and support Solaris operating system and Windows 2000 Advanced Server