Data Warehouse

Experience

Boeing

Teradata Sr. DBA (Teradata Technology): 7/2011 - Present

Serve as contact for Teradata performance using Viewpoint, DBQL and Teradata utilities. Developed physical data models and consults in development of conceptual data models. Designed, developed, implement, modified, backup/recovery and maintain physical relational databases using Linux and MVS OS/390 (Mainframe). Update the DBS using Lunix and maintain backups using Net Vault/Tara. Instrumental in implementation of ITL methodology throughout the Boeing DBA organization. Investigate and resolved operational problems nature using Teradata, Data Labs, TASM, PDCR, CPPT, Studio, Viewpoint and SQL ASST. Assist application DBA’s when they cannot figure out how to correct an issue. Consult with applications that involve Informatica/Data Stage and Cognos queries and find a way to deploy that will reduce cost and be more efficient. Set up environments using Data Labs and recommend DBMSs and delivery platforms, participates in database product and tool evaluations, procurement, and testing. Developed tools and processes to support the database administration (DBA) function. Utilize ClearCase and ClearQuest for Change management. Run system hardness testing using Linux/MVS and SQL Asst. Utilized Teradata’s capacity planning tool using CPPT to project Space requirements for application and plan hardware expansions/replacement (11 systems). Current version TD14.10/15.00 Viewpoint 15 and 15.10. My focus is customer satisfaction and repeatable processes using ITL Methodology and Six Sigma.

TIAA_CREF 02/10-07/2011

Teradata Sr. DBA serves as the focal point for all day to day production issues and enhancements in the Data warehouse. Production system is a 10 node with a (2) 5 node Prod systems and 4 node Dev/Test systems (UT/IUT/IFT). My tasks include but are not limited to: Trouble shooting performance problems, Adjusting current TASM settings for Production, Establish Backup and recovery Jobs. Develop process and procedures that work both with Dev, Test and Production users/customers. This does create a successful data warehouse. Currently on V2R6.2 and moving to Version 13 Linux (SUSE). Currently work with all Teradata tools like TD Manger, PMON, TSET, UNIX, and Atanasoft and BAR. Reduce the space used through eliminating and consolidation of objects. We work as a team not as individuals for better communication and brainstorming sessions. My focus is customer satisfaction and repeatable processes using ITL Methodology and Six Sigma.

Verizon Business 11/08-02/10

Teradata Sr. Lead DBA serves as the focal point for all day to day production issues and enhancements in the VzB Data warehouse. Production system is a 40 node with a (2) 4 node test systems and 4 node Dev system. My tasks include but are not limited to: Trouble shooting performance problems, setting up TASM for Production, Backup and recovery. Develop process and procedures that support a successful data warehouse. Currently using Version 12. Currently work with all Teradata tools like TD Manger, PMON, TSET, UNIX, Atanasoft and BAR (Net Backup). SOX compliance in every change we make using Clear Quest/Clear Case (IBM) tool. Report to management and forecast project completions. Accomplished reducing the space used through eliminating and consolidation of tables / views. We work as a team not as individuals for better communication and brainstorming sessions. My focus is customer satisfaction and repeatable processes using ITL Methodology and Six Sigma.

Overstock.com Teradata DBA : 4/08 –10/08

Proficient in Teradata tools including Teradata SQL ASST, Teradata Manager, TSET, and TASM and BAR (Net Vault/Net Backup). Understand Data Warehouse Metadata concepts, tools, and repositories. Currently working with Linux (SUSE/Teradata V12). Responsible for physical database design, implementation, and support on specific database technologies; designs and implements back-up, recovery, archiving and conversion strategies. Create database objects for tables, users, roles, profiles, grants, etc. Design and monitor alerts, database parameters, and performance metrics. Add columns, build indexes, and analyze indexes. Organize and manage patches and releases. Performs capacity and scalability planning. Identify innovative, cost effective ways to implement and support physical databases technologies. Perform administrative functions related to database support and project activities. Establish activity/project timelines. Instrumental in implementation of ITL methodology throughout the DBA organization.

Safeway Production Support –Teradata Lead DBA : 9/06 -3/08

Teradata DBA and contact for specific production databases and all applications for the Safeway Data Warehouse. Ensure that all SOX / Change Management processes are complied with. Designed, developed, implement, modified backup/recovery and maintain physical relational databases using Teradata, SQL Server and Oracle. Recommend RBMS’s and delivery platforms. Consistently implements decisions or initiates action within a reasonable time. Follow and adhere to ITL methodology throughout the organization. Work with Cognos to ensure user queries are efficient and trouble shoot issues with Cognos. Prioritize tasks according to impact upon system. Engage in mutual problem solving by brainstorming alternative positions or approaches and evaluating them openly and fairly. Always seeks a win-win solution through a give-and-take process. Accepted responsibility for outcomes (positive or negative) of one's work; admits mistakes and refocuses efforts when appropriate. Skill and ability to: collect, organize, synthesize, and analyze data; summarize findings; develop conclusions and recommendations from appropriate data sources with clients, customers and/or suppliers.

Boeing Enterprise People Data Warehouse (EPDW) Teradata Sr. DBA (DSS): 9/99 -9/06

Serve as contact for questions regarding specific Peoplesoft databases and applications for the EPDW Decision Support Systems organization. Developed physical data models and consults in development of conceptual data models. Designed, developed, implement, modified, backup/recovery and maintain physical relational databases using JCL and MVS OS/390 (Mainframe). Instrumental in implementation of ITL methodology throughout the Boeing DBA organization. Setup database to be used with Cognos and mange an issues that arise. Investigate and resolved operational problems nature using Teradata, SQL Server and Erwin. Recommends DBMSs and delivery platforms; participates in database product and tool evaluations, procurement, and testing; and developed tools and processes to support the database administration (DBA) function. Utilize ClearCase and ClearQuest for Change management.

DCAC/MRM Data Architect / Data Warehouse Team (DSS): 6/96 – 9/99

Utilizing strong analytical, communication skills and contributing as a team member to the completion of the (ODS) Operational Data Store and (DW) Data Warehouse). Designs, codes, compile, and test programs (regression) of a moderately complex nature using Teradata and Oracle Designer 2000 database. Prepared program specifications for the DW and ODS as required. Conducts design review and structured walk-through presentations. Prepare program documentation in compliance with established departmental standards. Investigate, analyzes, and resolves application problems. Represent DSS at Change Board and PDM design reviews. And act as the SQA (Software Quality Assurance) representative for the Decision Support Systems organization.

DCAC/MRM PDM/CAPP/ERP (Metaphase/CIMLINC/BAAN) Sr. Business Analyst : 4/95 – 6/96

Analyzed and designs, using common software development processes, computing applications addressing business requirements. Develops, programs, maintains, and integrates computing applications, including

Boeing developed and commercial off-the-shelf software using UNIX and SQL. Conducts design review and structured walk-through presentations. Prepare program documentation in compliance with established departmental standards. Investigate, analyzes, and resolves application problems. Interfaces with application users, other programmers and analysts, application architects, systems analysts, and other technical and support personnel in functional areas requiring knowledge and proficiency in business processes.

DCAC/MRM PDM/CAPP/ERP Root Cause Application Consultation: 10/94 – 4/95

Acts as Sr. focal for production application and support of customer processes. Contributed to the effective use and operation of specific applications and guides planning and implementation of system enhancements. Researched and gathers requirements for system enhancements. Functioned as liaison between customer and internal information technology organizations to ensure that requirements are implemented. Developed methods and software to support changing data requirements. Developed reports and queries based on customer requirements. Demonstrated knowledge of database concepts required for specific applications. Prepared application documentation in compliance with established departmental standards. Develops, conducts, and Monitors application test plans. Investigates, analyzes, and resolves moderately complex application questions and problems. Communicated with department management and functional users on requirements, activities, and status.

DCAC/MRM SME, (PDM/CAPP/ERP) Phase 3 and TBS Implementation Team Lead : 11/93 – 4/94

Manage and implement processes relevant to the success of Phase 3 and TBS (Taylor Business Stream) implementation. Represent the Fabrication Division in business meetings and telecoms. Make business decisions in the best interest of the Fabrication Division that pertain to Phase 3 and TBS. Manage implement aspects that pertain to the Phase 3 cutover planning process. Provide team assistance to other Manufacturing Engineering organizations when expertise is needed (Subject Matter Expert). Developed metrics and publications to convey information to all Fabrication Division MBU's.

DCAC/MRM (PDM/CAPP/ERP) Data Accuracy Review Team (D.A.R.T.) 3/93 – 11/93

Independently plan, develop and implement a company-wide structured audit and analysis system to be used for multiple processes such as product bill of material, routing, inventory, scheduling, and process flow and capacity values to ensure compliance with DCAC/MRM, BAAN and Lean Manufacturing initiatives. Oversee implementation of company wide operational controls to measure DCAC/MRM, BAAN and lean system requirements, provide trend analysis, identify areas of potential improvement, and present status to executive and program management, customers, and regulatory agencies. Develop plans, processes and procedures for using and maintaining the audit and analysis system (ERP); evaluate system process and technological advances and implementation of system revision. Provided manufacturing and

DCAC/MRM, BAAN, PDM, ERP and Lean system expertise, guidance, and training to individuals and cross functional organizations

Lead Liaison Manufacturing Engineering (Frederickson Skin & Spar): 9/92 – 9/93

Lead groups in the development of new processes and procedures through teaming environments. Coordinating tooling and production/personal work loads with affected cross-functional, customer -supplier organizations and maintain surveillance of all production to identify high cost using Lean methodology and Six Sigma principles. Implement action to reduce cost, improve safety, quality, and to improve schedule compliance performance. The specific areas that I was responsible for were: milling, forming, penetrent inspection, anodize, shotpeen, paint and sub assembly (channel vent). Also trained other manufacturing engineers with data base management, application of specific software (DCAC/MRM, PDM/CAPP/ERP) as well as other technical support. Streamlined cutter repair process by setting up a CQI team and coordinating between Auburn and Frederickson.

LeadManufacturing Engineering (737X program): 9/92 – 9/93

Worked on the 737x program in Renton, WA. My responsibilities included provide schedules (CDS) for part deliveries, educate other planners in the use of CATIA, OLP, MRLS, ORIS, Rejection tags, and other M.E. functions. Leaned out manufacturing process and improved through put using AIW’s. Worked with the shop, tooling, and engineering to guarantee success of our process. Leading Edge Vendor support Hamble, England.

Manufacturing Engineering (777 program): 11/89 – 9/92

Worked with graphite composite structure, fiberglass and titanium parts for the main torque box skin panels on the 777 vertical /horizontal stabilizer program at Frederickson. Provided tooling with CATIA models to indicate areas of interference or concern. Worked as a Liaison Tool designer for the 777 Empennage program. Responsible for the Passenger Entry, Small Cargo, and Large Cargo doors. Lead a Design as Built team for the Cargo Doors. Representative for the SPC/HVC team. Worked together with Japanese vendors to accomplished primary objectives.

Education:

BSME Summit University, New Orleans, La.

Teradata Teradata SQL, Teradata Basics, Data Administration, Teradata Utilities, V15.00 Upgrades, PDCR, CPPT, Data labs, DataMover, TASM, Viewpoint 15.10

Erwin Erwin Data Modeling

Apollo Root Cause Analysis

APICS JIT Just in time

MP Master Planning

AMES Master Planning

Material Requirement Planning

Inventory Management

Capacity Requirements Planning

Production Activity Control

FAA Airframe/Powerplant License

Awards Special Recognition from the DSS Data Warehouse PPI Implantation

Special Recognition from the DSS Data Warehouse Outstanding Performance

Special Recognition for Vendor support 737 Next Generation

Special Recognition for Outstanding Performance 777

Personal: Board member Teradata User’s Group

US Navy USS Enterprise / VFA125

Patriot Guard Member

Committee Chairman Boy Scouts of America

Merit Badge Counselor Boy Scouts of America

Eagle Scout Boy Scouts of America

Contact this candidate