SUMMARY

• 17 years experience with Data warehousing Architecture and Development. Heavy Teradata, Oracle, DB2 & SQL server 2005 Applications design, Development, database administration and Support Experience in a Data warehouse Environment.
• Over 13 years experience with Teradata Application development ), Teradata Architecture and Teradata administration on V2R6 & V2R12.
• 9 years experience in leading and managing medium to large projects.
• 7 Years experience with logical, physical, and dimensional data modeling
• 7 years of experience with Teradata performance.
• 9 years experience in UNIX shell scripting & administration.
• Over 5 yrs experience with Informatica, AbInitio & Datastage.
• 3 Years experience using Teradata Macros & stored procedures.
• Over 3 years experience in Teradata administration.
• Over 2 years experience in Oracle administration.
• 2 years of extensive experience in using the Data Warehousing tool Data Stage 7.x/6.x/5.x/4.x (Manager, Designer, Director and Administrator).
• 8 Years experience in automating processes.
• Over 6 years on Oracle (9i, 8i, 8.x, 7.x), on both OLTP and OLAP environments for high volume database instance.
• Skilled in large - scale multi terabyte initial database load and on going update techniques, backup and recovery requirements, SQL, etc.
• 10 years with IBM MVS mainframe environment using JCL, TSO, ISPF, IBM utilities and DB2.
• Excellent communication and interpersonal skills and adept in working with team’s offsite.

PROFESSIONAL EXPERIENCE

Confidential, Oklahoma

Teradata DBA/ Development Team Lead / Data warehouse architect

Environment: TeradataV2R12, Bteq, Fload, mload, fexp, TPT, t-pumpOracle, Business Objects, Erwin, MainframeWindows 2003, Queryman, and Toad.

Responsibilities:

• Monitor and maintain a production Teradata Database environment, including runtime optimization, capacity management and planning.
• Maintain user tables and permissions, security, configuration, scheduling and execution of maintenance utilities.
• Database recovery and restart as well as data and referential integrity of the database.
• Design, develop and test processes for loading initial data into a data warehouse.
• Data source analysis, ETL design and Translate data movement requirements into ETL specifications
• Lead on technology and consulting methodology issues throughout all phases of the project.
• Design and normalize the data model, transform logical data model and physical data design.
• Configuration management of application software to data models, and maintains and publishes project business rules and dictionary.
• Provide technical leadership on business projects (define, structure, plan, and coordinate work).
• Support QA during testing and oversee production implementations.
• Provide estimates for technical solutions, Design and tune systems for speed and performance.
• Prepare Application enhancement Design Documents.
• Train / mentor other employees.
• Proactively analyze databases for worst performing SQL and coordinate with developers/analysts to tune application code.
• Provide code tuning guidelines to development & project teams and coordinate the resolution of performance issues as needed.

Confidential - Overland Park, KS

Teradata DBA/Lead developer / Data warehouse architect

Environment: Teradata V2R6/V2R12, Bteq, Fload, mload, fexp, TPT, t-pumpOracle, DB2, Informatica, Micro Strategy, Erwin, UNIX, PerlMainframe, Windows, Queryman, and Toad.

Responsibilities:

• Data source analysis, ETL design and Translate data movement requirements into ETL specifications
• Perform application development, enhancement, and maintenance support for ETL application code for services ranging from simple to extremely complex.
• Design, development and continual improvement of test scripts. Implementation of test plans for all program changes.
• Provide technical leadership on business projects (define, structure, plan, and coordinate work).
• Design, develop and test process for validation and conditioning data prior to loading into the DW
• Design, develop and test processes for loading initial data into a data warehouse.
• Support QA during testing and oversee production implementations.
• Design, develop and test process for loading cyclical data into a data warehouse.
• Prepare Quality Control metrics on a weekly basis, Weekly migrations and checks.
• Participate in performance, unit testing and system testing.
• Provide estimates for technical solutions, Design and tune systems for speed and performance.
• Data modeling (Physical & Logical), Technical Lead role on software development projects with responsibility for overall delivery of software components and data interface.
• Prepare Application enhancement Design Documents.
• Train / mentor other employees.
• Write scripts using Unix Shell to maintain the Teradata environment.
• Proactively analyze databases for worst performing SQL and coordinate with developers/analysts to tune application code.
• Provide code tuning guidelines to development & project teams and coordinate the resolution of performance issues as needed.

Confidential, MO

Application Architect/ Team Lead.

Environment: Ascential DataStage, DB2, Oracle, Evoke (Data Profiling), Korn Shell Scripting, Erwin, Java, ESP, AQT, Toad, and Oracle.

Responsibilities:

• Worked with clients to prepare requirements and reviewed requirements documentation. Worked with Data Modelers to create Logical & physical Data models.
• Created Data Mapping documents for development teams and Prepared Application Design Documents.
• Provided technical leadership on business projects (define, structure, plan, and coordinate work). Supported QA during testing and oversee production implementations.
• Provide estimates for technical solutions, Design and tune systems for speed and performance. Create Unit & system test plans, Train / mentor other employees.
• Create and executed Project plans. Maintained allocation of resources to projects.
• Worked with clients to create User acceptance test plans
• Created Data Validation plans for testers, Created, maintained database and application requirements.
• Supported Mainframe and Midrange applications; Worked on ESP schedulers to schedule the midrange & mainframe jobs.
• Written scripts using Unix Shell Scripting to create Traffic cops; Performed Data loads into DB2 using ETLs.
• Created Korn Shell scripts to execute the DB2 Scripts in Production.
• Created DB2 Tables, Views and Indexes according to the requirements.
• Loaded data into DB2 tables using DB2 Bulkload and other utilities.
• Fine-tuned SQL Queries for performance by changing the indexes and determining the columns to collect statistics on.
• Restructured several jobs to make the job stream to run in parallel so that the Daily process finished in the night.
• Fine tuning of SQL to optimize the spool space usage and CPU usage of the system.
• Involved in Runtime optimization, capacity management and planning, security, configuration, scheduling, and execution of maintenance utilities.
• Involved in creation of Macros to automate some of the processes and generation of reports.

Confidential, KS

Lead Developer/ Application Architect

Environment: TERADATA V2R6/V2R12, Bteq, Fload,mload, fexp, TPTt-pump, UNIX, JCL, MVS, COBOL, DB2, AbinitioDataStage, Microstrategy, CNTL-M, Autosys, Erwin, Oracle.

Responsibilities:

• Data source analysis, ETL design and Translate data movement requirements into ETL specifications
• Perform application development, enhancement, and maintenance support for ETL application code for services ranging from simple to extremely complex.
• Design, development and continual improvement of test scripts. Implementation of test plans for all program changes.
• Provide technical leadership on business projects (define, structure, plan, and coordinate work).
• Design, develop and test process for validation and conditioning data prior to loading into the DW
• Written Cobol Programs to accumulate data into Flow Control BuffersWhich was then loaded into the Staging area.
• Created Teradata Tables, Views and Indexes according to the requirements.
• Loaded data into Teradata tables using MLOAD and FASTLOAD Utilities
• Implemented Data recovery strategies using Teradata ARCMAIN
• Fine-tuned SQL Queries for performance by changing the indexes and determining the columns to collect statistics on.
• Restructured several jobs to make the Customer job stream to run in parallel so that the Daily customer process fit into a 9 hour window.
• Fine tuning of SQL to optimize the spool space usage and CPU usage of the system.
• Developed jobs for periodical archives of various tables.
• Restructured several jobs to make the Customer job stream to run in parallel so that the Daily customer process fit into a 9-hour window.
• Involved in Runtime optimization, capacity management and planning, security, configuration, scheduling, and execution of maintenance utilities.
• Involved in using Teradata Manager to monitor and manage Teradata RDBMS resource utilization, and create alert policies for monitoring database space, average disk use.
• Involved in creation of Macros to automate some of the processes and generation of reports.

Confidential, KS

Application Sr. Developer

Environment: TERADATA, Abinitio, UNIX(Korn) Shell Scripting, JCL, MVS

Responsibilities:

• Involved in the Requirements Analysis and responsible for creating Technical specifications from functional specifications.
• Performed Dimensional Data Modeling, Logical Data Modeling (LMD) and Physical Data Modeling (PMD).
• Worked on loading of data from several flat files sources using Teradata MLOAD & FLOAD.
• Transfer of large volumes of data using Teradata, FastLoad, MultiLoad, and T-Pump
• Written Teradata macros and Stored Procedures.
• Written Shell scripts to productionalize the SQL Code.
• Written Cobol Programs to extract the data from DB2.
• Written scripts to extract the data from Oracle and load into Teradata.
• Designed and Administered Teradata Scripts, Tables, Indices and Database Objects.
• Involved in Teradata Archive and recovery.
• Worked on exporting data using Teradata FEXPORT.
• Performance monitoring and tuning of Teradata applications
• Written several Teradata BTEQ scripts to implement the business logic.
• Hands on with Teradata Queryman to interface with the Teradata.
• Created Teradata Tables, Views, Indexes according to the requirement
• Performance monitoring and tuning of Teradata applications.
• Optimizing database objects and streamlining applications.

Confidential, KS

BI Developer

Environment: Teradata, MVS, JCL, COBOL, VSAM, DB2, CICS, File-Aid, FTP

Responsibilities:

• Involved in the Requirements Analysis and responsible for creating Technical specifications from functional specifications.
• Worked on loading of data from several flat files in to VSAM files.
• Written COBOL, File-Aid, FTP and NDM scripts.
• Written Shell scripts to transfer the files to midrange platforms.
• Written Cobol Programs to extract the data from DB2.
• Written scripts to extract the data from Oracle and load into VSAM files.
• Performance monitoring and tuning of long running jobs on VSAM.
• Hands on with Xpediter to fix production issues.
• Created VSAM flies, and Indexes according to the requirement