TECHNICAL SKILLS:

HARDWARE / SOFTWARE: Teradata, Oracle, SQL, LINUX, UNIX and UNIX ADMIN, AIX, MP - RAS OS/VS JCL, DB2, IDMS, COBOL, COBOL II, PLI and SAS, PowerBuilder, Sybase, Oracle, NCR DBC1012, 2800,3600, 5300, 5500, 5650, 6700, 6750 technology for data warehousing development. Familiarity with schema and subschema, database allocation and design, computer functions and analysis, Teradata Database administration, implementation, performance tuning, capacity planning. Hardware includes NCR3600, NCR4700, NCR5100, NCR5100, NCR4300, NCR5150, 5550, 5650, 6750, 2800, 2550, MVS E, Amdahl, and MP-RAS SYSTEMS, various versions and releases, UNIX SYSTEM V/LINUX, MVS operating systems, WINDOWS, Windows NT, Windows 7 and various PC hardware and software components. Teradata Releases ranging from V2R1 through 13.10, 1 .01 and 15.10. Informatica, MicroStrategy, DataStage, ASF2, BakBone, NetVault, NetBackup, Cnsterm, xwindows, and AWS, GoldenGate Replication services, Epic Clarity.

SKILLS: Teradata Systems and Application DBA. Teradata load utilities mload, fastload, tpt, arcmain, running on platforms 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, PDCR setup and maintenance. Teradata Performance tools on UNIX including Cnsterm, AWS, XWindows on the Database window, including Vprocmanager, 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. Additional skills include Oracle Application DBA supporting GoldenGate replication services, IBM DataStage., 'C', Kshell, Cshell, Business Objects, MicroStrategy, Informatica, COGNOS, Erwin, DataStage, Powerbuilder. SAS, COBOL, COBOL V5,PL1, Sybase, DB2(BMC utilities), VSAM, CICS, JCL, TWS, CA11, FILE MANAGER, TSO, release management tools, Dump Reading, Transmission protocols (NDM,FTP), ticketing systems (REMEDY), Endeavor SCM System, JIRA ticketing system, IBM utilities, Microsoft Office Products

PROFESSIONAL EXPERIENCE:

Confidential, Jacksonville, Fla

Member of the Teradata DBA Operational 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, DR, Analytical Teradata boxes actively to ensure the integrity of the databases and throttle any heavy workloads. Worked with TD Manager, Viewpoint, Data Mover and all Teradata utilities. Worked with users to develop archival strategies, production processes, performance tuning. Created macros and stored procedures to automate the quarterly archive processes. Scheduling done through CA7 and Autosys. Worked with users to help resolve issues with 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. Assigned, worked on and completed all Nexus, and JIRA tickets. Also worked in Remedy System for any changes to the production environments, including all requirements to get the changes approved and implemented.

Confidential,El Segundo, Ca.

Member of the DBA team for Teradata BI Data Warehouse team

• Worked with GoldenGate extensively to implement/maintain replication from Oracle/Sql Server source to Development, 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 environments for extensive analytics for Business Intellingence Organization. Utilizing Data Mover through Teradata Viewpoint V15. Experience in all versions of Teradata TD15.10 and below. . Involved in Integration of existing EDW(Teradata) data, OLTP systems (Oracle), 3rd Party vendor data in our Hadoop environment to provide analytic needs for SAS, Cognos and Qlikview

Confidential, Seal Beach,Ca

Teradata DBA for BI team.

• Implementation of Teradata BI financial database. Implemented Oracle migration to Teradata environments. Was involved in architecture of BI reporting system. Performance tuning and workload managements for new ETL jobs using Data Stage. 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 Data Warehouse.

Confidential, Jacksonville, Fla.

Member of the Teradata DBA Operational 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, Los Angeles, Ca.

Teradata DBA supporting the data warehouse

• 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 to 8.5. Implementation and use of ViewPoint and DataMover as well. Extensive use of NetVault and Cnsterm and AWS.

Confidential, New Providence, NJ

ETL architect, designer and developer and administrator

Responsibilities:

• Using DataStage to develop ETL processes for a BI Data Warehouse as well as responsible for other reporting systems in IT for Confidential . 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. Also worked with MicroStrategy team to develop reports when needed.