OBJECTIVE:

• Seek a consultant or Full Time role as a DBA, ETL Developer, Data Modeler,Business Analyst, Programmer 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, Rochester, NY

Teradata DBA

Responsibilities:

• Prepare Best Practices
• Creation of Teradata objects
• Subject Matter Expert in Teradata
• Work with Teradata Healthcare Data Model using ERWIN
• Created data models for existing systems using ERWIN

Confidential, Charlotte, NC

Teradata DBA CDI/IBM

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

• Support Enterprise Credit Risk Information System as needed
• 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

Confidential, Raleigh, NC

Teradata DBA / ETL Developer

Responsibilities:

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

• Collect and transfer data from Delphi SAP system to Delphi Global Engineering System using Microsoft Excel and Access Writing macros and VBA procedures to manipulate data

Confidential, Dayton, OH

Teradata DBA / Oracle DBA

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

Confidential, Dayton, OH

Oracle DBA

Responsibilities:

• Develop Oracle database using ERWIN
• Oracle DBA for Oracle Financials and new order entry system
• Apply patches to Oracle Financials as needed
• Perform backups
• Perform performance tuning
• Create tables and tablespaces as needed for the order entry system
• Implemented Master to Master and Updatable Snapshot replication for the order entry system
• Installed, maintained and updated Oracle Application Server, Oracle Web Server, and Oracle Enterprise Manager
• Programmed in PL/SQL for the order entry system
• Created and maintained triggers for all tables including referential integrity
• Created and maintained procedures/functions for detail data included creation of temporary tables on the fly with insert/update/delete triggers
• Maintained packages that managed security rights to tables
• Created/Maintained custom procedures that handles data validation for products
• Load legacy data for order entry system
• Performed SQL performance turning for order entry system
• Programming in Foxpro for DOS and Windows of system enhancements
• Created Database Utilities using Delphi

Confidential, Dayton, OH

Analyst

Responsibilities:

• Redesign Order Entry system and Design Accounting system and Manufacturing Production tracking system
• Programming in Foxpro for DOS and Windows of system enhancements
• Develop new Order Entry system
• Created Database Utilities using Delphi
• Perform Novell Netware management tasks

Confidential, Dayton, OH

Analyst

Responsibilities:

• Assigned to Confidential on trial basis, Primary duty: System Analysis of Order Entry system in Foxpro, Also, performing maintenance and enhancement to existing Foxpro system

Confidential, Dayton, OH

Programmer/Analyst

Responsibilities:

• Develop software systems using Synergex DIBOL and the Synergex Toolkit, These applications allowed the Dibol applications to present more windows features
• Develop software from analysis through deployment on a VAX and Alpha systems
• Excel Spreadsheet and Word customization using macros
• Program EDI system for Orders and Acknowledgements

Confidential, Yellowsprings, OH

Programmer/Analyst

Responsibilities:

• Supervise the entire development cycle from analysis to deployment on a Novell network and a VAX system
• Supervise introduction of Document Management software for use in a company-wide Quality Management System
• Provided Novell Network LAN management
• Performed daily operations and managed/assisted users
• Installed Commercial applications
• Provided VAX/VMS system management
• Performed daily operations and managed users
• Isolate problems and help users with problems
• Created several information tracking systems using Quattro Pro
• Used macros to import, parse, sort data for Production Scheduling, Cost of Quality and Gainsharing systems
• Maintained and modified accounting system written in DIBOL
• Programmed Shop Floor and General Ledger programs on VAX using DCL, DIBOL, BASIC, and PASCAL
• Installed PC hardware and software resulting in over 100 PC Novell LA
• Analyzed and developed Chemist information system in Windows 3.1 environment. Major tools used included Protogen, Borland Pascal 7.0, ObjectWindows and Paradox Engine 3.0
• Analyzed and developed other systems using Borland Paradox for Windows and Paradox for DOS

Confidential, Dayton, OH

Programmer/Analyst

Responsibilities:

• Performed systems management on VAX 11/785
• Analyzed and developed systems using Turbo Pascal 5.5
• Data Reduction Systems for flight tapes of F-15 flight correction software
• Visitor Welcome System using Touch Screen technology
• Feasibility study to determine the appropriate us of ADA in Air Force wide programs