SKILLS

• Teradata Systems/Application DBA. Teradata load utilities including on MVS, LINUX MP-RAS, UNIX, Windows. Teradata SQL tools including Sql Assistant, BTEQ. Teradata Administrator, Teradata Visual Explain, Teradata Workload Manager. Teradata Performance monitoring tools including Teradata Manager, Performance Manager, Priority Scheduler, TASM, Teradata ViewPoint and DBS Control Record and DBQL logging and analysis. Teradata Performance tools on UNIX including Cnsterm, AWS, XWindows on the Database window, including Checktable, Scandisk, Packdisk, Ferret, and Buildtable. Production Teradata DBA, production support and experience in resolving any problems arising from backups, daily and night production runs as well as correcting any processing and creating processing efficiencies utilizing new feature of Teradata RDBMS as they were created and implemented in each of the systems described below.
• Oracle Application DBA supporting GoldenGate replication services, IBM DataStage.

EXPERIENCE:

Confidential

Datawarehouse team. Work with GoldenGate extensively to implement/maintain replication from Oracle/Sql Server source to Test and Production Teradata environments. Involved in performance tuning, capacity planning and supporting application implementations. Working with various teams for project implementation. Design recommendations, query tuning, performance management. Admin Support Sales Oracle Database environments . Support Aster/Hadoop/Teradata environment for extensive analytics for Business Intellingence Organization. Utilizing Data Mover through Teradata Viewpoint V15. Experience in all versions of Teradata TD15 and below.

Confidential

Teradata BI financial database. Implemented Oracle migration to Teradata DEV and UAT environments. Was involved in architecture of BI reporting system. Performance tuning and workload managements for new ETL jobs using DataStage. Functional testing for DataStage from Dev to UAT to Production. Maintenance of all objects in database. Was involved in capacity planning and disaster recovery for BI DataWarehouse.

Confidential

Support Group. Functions included development of new processes and modification of existing processes in the warehouse for daily database activities. Duties included monitoring of production and CRM Teradata boxes actively to ensure the integrity of the databases and throttle any heavy workloads. Worked with TD Manager, Viewpoint, Data Mover, PMON, and all Teradata utilities. Worked with users to develop archival strategies, production processes, performance tuning. Created stored procedures to use in daily activities to create databases, register tables, and movement of space on all Teradata platforms including Production, UAT, Development, CRM box and DR box. Worked with users to help resolve issues with Data Stage interface, Informatica, performance tuning of queries with application developers and BI reports, and daily production processing issues. Processed daily database change requests for all platforms as well.

Confidential

warehouse, ETL and Reporting processing interfacing with Informatica and MicroStrategy. Was responsible for on-call rotation, backups, daily production support, performance tuning, query tuning, upgrades, and implementation of active to active DR system. Actively involved in performance tuning of existing and new processes and queries, capacity planning, backup strategies, production rollouts, Teradata monitoring, system tuning and keeping the overall health of the database in good standing. Upgrade from V2R6.2.2.94 to V.13.0.0.1. Used Data Mover to copy data from one system to another. Upgrade NetVault tom 8.5. Implementation and use of ViewPoint and DataMover as well. Extensive use of NetVault and Cnsterm and AWS.

Confidential

Administrator using DataStage to develop ETL processes for a BI Data Warehouse as well as responsible for other reporting systems in IT for CR Bard. Supported Oracle and Micro Strategy and JDE. Worked with users to determine requirements and needs. Involved in upgrades of software for the warehouse. Use DataStage extensively for ETL development, design and implementation. Administration of DataStage. Upgrade of DataStage Enterprise Edition. Interact with the vendor technical support staff to resolve issues regarding the DataStage environment. Tuning of DataStage processes was exercised extensively.

Confidential

data warehouse. Responsible for capacity planning, performance tuning of existing processes and development of new processes for the retailer. Supported OALP applications as well as transactional processes. Responsible for any database related issues, including problems, software and hardware upgrades. Was involved in designing new processes for the warehouse. Implemented process to move data from one machine to another without using backup restore utilities as version differences prevented this action. Was on a rotating on-call schedule with the rest of the DBA team.

Confidential

upgrade of database software on AIX UNIX servers as well as the UNIX Teradata nodes. Performance tuning and system utilization was tracked and analyzed on a daily basis. Made improvements to existing processes resolving workload utilization problems as well as performance improvements. Implementation and automation of processes to track system utilization daily for future capacity planning and performance improvements. Automated production processes alleviating the need for resources to do this monthly processing.

Confidential

Permanente. Responsibilities include tracking and allocation of space and system utilization, installation and setup of ETL servers with Epic Clarity software. Tracking and analyzing of system performance and resource utilization, performance tuning and backup and recovery strategies implemented. Responsible for user support and setting up the user environment on development and production Teradata databases. Also involved in migration of 82 data marts of various technologies and platforms into one Teradata data warehouse. Use of Teradata archive as well as load utilities and Cnsterm and AWS extensively. Support of user community and assisting users in tuning SQL queries.

Confidential

the telecommunications industry dealing with collections and adjustment. Primary duties include responding to all appropriate help desk issues, production issues, development issues and database environment activities as well. Involved in a Teradata upgrade from V2R4 to V2R5. Extensive use of Cnsterm and AWS. Implemented many efficiencies in present processing utilizing many of the performance enhancements in this upgrade. Also redesigned many present processes creating programming and processing efficiencies. Tracked database utilization daily for capacity planning and performance tuning.

Confidential

scale Teradata data warehouse running on Windows operating system. Worked with various system interfaces to gather requirements for migration and implementation. Duties include be team lead and delegate necessary work for developers. Involved in migration from various Oracle systems to Teradata data warehouse. Performance monitoring and production support were also part of daily tasks. Implement processing efficiencies utilizing new features of V2R5 as well as existing functions of Teradata RDBMS. Net Backup was utilized for backing up of data. Production monitoring was also part of duties. Used DataStage for development of ETL processes.

Confidential

Involved in data warehouse implementation. Functions included project management as well Specialist using OLE-DB in the migration from Oracle to Teradata databases, Teradata Tools and Utilities V7.0 and Teradata RDBMS V2R5 were utilized and implemented. Utilized Index and Statistics Wizard. Utilized new tables in V2R5 in the Database Query Log for system performance management analysis. Analyzed system processes and definitions created processing efficiencies performance tuning on Teradata RDBMS including new efficiencies with V2R5 using DBS Control functionalities. Installed NCR client software on customer pc and network WINDDI, BTEQ, Teradata Manager, Queryman, PMON, and Priority Scheduler . Conducted training classes for personnel involved in data warehouse implementation. Created disaster and recovery plan Net Vault and Net Backup Net Backup was the preferred choice for a backup plan. Traveled to Bethlehem Pa. and trained personnel on using Arcmain utility on MVS for backup purposes. Established different database environments, users, determined space allocations and resources for different activities on the database.

Confidential

Position as a Teradata DB2 COBOL developer. Converted mainframe and DB2 processing to the Teradata Warehouse with performance and programming efficiencies built into the new processes using Teradata RDBMS V2R4.1. Tools and Utilities including Queryman, WINDDDI, and BTEQ, Fastload, Multiload and Fastexport.

Confidential

Position as a Teradata DBA on a large multi-terabyte system. System development, project management as well as the current production environment. Involved in software as well as hardware upgrades performance tuning, tracking, monitoring included . Production monitoring on Teradata machine with MicroStrategy 7.1 and Informatica on front-end interfaces in a Retail Organization. Provided support and worked with MicroStrategy DBA to resolve any resource contention while running queries on the front-end in MicroStrategy many challenges in an ever-changing environment . Worked with ASF2 , Cnsterm and AWS extensively and experience with Net Vault for new implementation. Also involved in a migration from 2 nodes to 20 nodes and from NCR4700 to NCR5150 and V2R4.0 to V2R4.1.2. Created backup efficiencies utilizing cluster dumps instead of archiving tables utilizing the Teradata archive utility Arcmain. Created UNIX scripts for setting alarms. Managed space daily, as this was an ongoing problem until upgrade with additional 18 nodes.

Confidential

Position as NCR Database Administrator and UNIX Systems Administrator for Data Mining Lab. Performed software installations and upgrades on Unix MP-RAS Systems with Teradata Database Installed. Upgraded from V2R3 to V2R4 and then to V2R4.1 in order to enhance analytic processing on the Teradata Database with Teraminer Software on the front-end. Implemented several processes to resolve disaster recovery issues. Extensive use of Cnsterm and AWS. Created mainframe backups, backup schedule and disaster recovery plan to prevent loss of data and data structure. Teradata Database Administration as well as UNIX Systems Administration duties were performed regularly. Created UNIX scripts for scheduling UNIX backups on a weekly basis. Interactions with customers to implement and perform processes enabling the cleansing, loading, and updating of all customer data utilizing the Teradata load utilities as Fastload, Multiload, and Arcmain as well. Responsible in all for the Data Mining Lab's machines and all activities i.e. performance tuning, monitoring and tracking problems and issues arising from the activity of these machines . Assisted in TeraMiner training at various customer locations. Worked with ASF2 extensively as well as scripting on UNIX to create a backup schedule.

Confidential

Functioned as a member of the WINS Warehouse of Information for Network Systems technical support team for Lucent Technologies financial applications. Performed functions of a production project leader, Teradata Systems and Application DBA. Was responsible for upgrades of software new releases of software and hardware with NCR Worldmark machines, including Teradata RDBMS V2R2 to B2R3. Monitoring and improving the performance of seven different machines on numerous platforms with UNIX, Teradata and Oracle databases utilizing Teradata Manager and Teradata Performance Manager. Responsibilities also include UNIX support for the platforms for Lucent Technologies. Was in charge of Teradata backups using MVS and scheduling and providing written procedures for all maintenance on the different platforms including UNIX and Teradata machines. Involved in migration of seven Teradata machines from NCR3600 to NCR4700 and NCR5100.

Confidential

Worked as a consultant as a Teradata DBA at NCR Corporation. Interpreted Logical Data Models to Physical Database Design in Solutions for NCR data warehousing solutions. Functions included project management efforts in concentration of the telecommunications areas. Was also involved in migration of NCR 3600 to NCR Worldmark 5100, EBCDIC to ANSI standards base.

Confidential

Functioned as production support programmer/developer. Support of financial applications using Teradata database with MVS and UNIX. Responsibilities included monitoring and maintaining all processes for the finance group. Development of new processes and migration from AP3600 Teradata machine to AP5100 machine were included. Processes were re-analyzed and re-defined. Was on-call 24 hours per day 7 days a week for production maintenance and monitoring. Extensive use of Cnsterm and AWS. The front-end of the application was developed in PowerBuilder. Maintenance and production fixes were also implemented using the PowerBuilder front-end. Involved in a migration of Teradata V2R1 to V2R2.

Confidential

Held position as a software developer and team leader. Developed applications for AT T and specifically Direct TV using PowerBuilder as the front end with Sybase and Oracle databases. Duties included development implementation and testing of these applications. Some experience with writing CD's and working on the Internet was included.

Confidential

Was employed by Human Resources as an internal consultant on the following assignments in the positions stated below:

Confidential

Member of Finance Group. Responsibilities include Book close Activities for Business Communication Services. Provided support to member of the financial organization, including production reports published and sent to various organizational personnel. Technologies included SAS and Oracle databases. Responsible for the automation of the final checking of book close report numbers through a Lotus Spreadsheet.

Confidential

Functioned as a programmer/analyst/project leader for the Marketing Information Consulting group. Provided support to members of Consumer Communication Services marketing groups, providing data and data analysis, and tracking for many of the promotions as well as supporting the existing programs in C.C.S. Tracking and flagging information that was needed through a Teradata database system, utilizing SQL extensively. Utilized COBOL, SAS, and various utilities as Sync sort, Syncgenr, File-Aid, AFT, and JCL. Attended numerous meetings with clients and acted as an interface with existing systems. Collected data also on an ongoing adhoc basis for various marketing groups within C.C.S. Provided Teradata training and support for all organizational personnel.

Confidential

Held position as a Requirements Analyst for several months in large marketing application that supports the sales force. Project tracks marketing and billing information. Attended various user group meetings, working with user to understand and implement their needs on the system. Held meetings and conveyed information to the various people in the field. Also wrote requirements documents and updated the Design Review Schedule with the Development Group leader on a weekly basis. After this time, a position as programmer was offered to me. My responsibilities included coding, string and unit testing, and documentation, and programs in COBOL, SAS, and COBOL with embedded SQL and SQL utilities.

Confidential

Member of the Outside Plant Group. Responsibilities included overseeing the billing, drafting and computer systems departments. Interfaced with customers to develop a common database, resolve billing issues and drafting developments. Involved in the networking of the LAN, also maintenance and modifications of the existing databases in Alpha 4, implementation of a GTE engineering system, and installation of software for all personnel. Addressed hardware and software networking needs and utilization. Involved in a conversion of the Alpha 4-database to FoxPro.

Confidential

Project manager and DBA for marketing application. Involved in all phases of development, logical and physical design of the database. Responsible for the development, sizing of the database, configuration of hardware, interface agreements, acceptance testing, data validation, implementation of the physical design, string and unit testing. Responsible for performance tuning and testing and optimization of the database. Other quality assurance measurements utilized SAS products for statistical purposes and graphical presentations. Managed 4 developers, created timelines and work plans for each of the team members. Used SQL and COBOL2 programs with embedded SQL. Used numerous Teradata utilities for loading, recovery, restore, update and performance measurements of the database. Also a member of the technical committee, being responsible for inventory, ordering and maintenance of all PC's for the group.

Confidential

Project leader for BRMIS/MRM, a large marketing and revenue tracking application for the AT T sales force. Maintenance of Teradata and IDMS databases for development, unit and system testing and production processing. Involved in system testing, and for a re-write from IDMS to DB2. Responsible for development, testing and support of all releases and maintenance changes to the system as well as user requirement analysis. Was able to implement a yearly cost savings of 500,000. Also created efficiencies in processing and cut production time by 67 .

Confidential

Worked as a consultant for AT T on a right-to-hire basis. Held a programming position for a Teradata/IDMS reporting system mentioned above BRMIS/MRM . Involved in production monitoring, maintenance, and development and re-write of the system.