CYNTHIA L. WILBUR
Summary
· IT Professional with 5 years working as a Developer.
· Skilled in TERADATA SQL, ANSI SQL, Stored Procedures, Macros, TERADATA V2R4.1 & V2R5.1.
· Experienced administering large-scale TERADATA (V2R4.1 & V2R5.1) database using TERADATA ASSISTANT, TERADATA ADMINISTRATOR, BTEQ, QUERYMAN, FASTLOAD, MULTILOAD, WINDDI.
· Experienced in Data Warehousing concepts including Datamart and Data Mining using Dimension Modeling (Star Schema Design) and Third Normal Form.
· Experienced in developing UNIX Shell Scripting, BTEQ, FASTLOAD, TPUMP, FASTEXPORT, and MULTILOAD scripts for data migration and for Scheduler Utilities.


Technical Skills
Software: TERADATA SQL ASSISTANT, TERADATA ADMINISTRATOR, QUERYMAN, BTEQ, MULTILOAD, FASTLOAD, FASTEXPORT,TPUMP, ERWIN, OUTMOD, INMOD
Languages: UNIX SHELL SCRIPTING, HTML, VB (VISUAL BASIC), JAVA, APPLETS, AND JAVABEANS, ORACLE, VB SCRIPT, C,ASP
Databases: TERADATA, DB2, ORACLE, ACCESS 97, SQL SERVER
Platforms: UNIX, WINDOWS 95/98/NT/XP/2000, SAP/R3, MVS, VM
Networking: FTP, TELNET, HUMMINGBIRD, VPN
Tools: REFLECTION FOR UNIX, WORDPERFECT, REMEDY, EXCHANGE, EXCEL, OUTLOOK, POWERPOINT, PROJECT, WORD, ULTRA EDIT, TERADATA SQL ASSISTANT, WINDDI, TERADATA ADMINISTRATOR, ADOBE, LOTUS NOTES, VISIO 2000, COLD FUSION, CONNECT DIRECT, FRONTPAGE 98, ORACLE’S WEB DEVELOPER SUITE
Experience Highlights

TERADATA DEVELOPER, Toys R Us for DSC, Wayne, NJ, NB: March 2005 – Present.

· Extract data using FASTEXPORT
· Support UNIX batch cycle using KORN shell scripting.
· Use BTEQ to transform data in existing TERADATA tables.

TERADATA DEVELOPER, OAO Technologies, Moncton, NB: April 2000 – March 2005.

· Design and develop ETL mappings using TERADATA UTILITIES.
· Assist DBAs by creating physical database structures from logical models generating DDL from Erwin.
· Use BTEQ to transform data in existing TERADATA tables.
· Code MULTILOAD, TPUMP and FASTLOAD scripts for use in conversion table load processes.
· Code MULTILOAD scripts to load data files using Teradata.
· Develop FASTEXPORT and OUTMOD scripts to create files for MULTILOAD to other tables.
· Extract data using FASTEXPORT and OUTMOD.
· Code TERADATA Macros and compare all AMP performance to one-AMP PROC processing.
· Identify specific bugs in TERADATA V2R5 source code and relate findings to TERADATA DBA.
· Expertise in Troubleshooting TERADATA system failures.
· Support UNIX batch cycle using KORN shell scripting.
· Develop UNIX Shell Scripts to perform load tasks with complex TERADATA SQL
· Participated in the development of large-scale projects for AT&T using the IBM SDF methodology including design analysis, software design, software construction and development, project documentation and unit test cases
· Mentored new arrivals for application development using TERADATA, UNIX and MVS.
· Provided Estimates for Potential new business.
· Acted as a technical lead to lead software design, perform design/documentation review and mentored other developers.



DATAWAREHOUSE MAINTENANCE COORDINATOR, OAO Technologies, Moncton, NB: March 2004 – March 2005.

· Administered the IBM/AT&T Maintenance Process including analysis, development, project documentation, test cases, reporting software maintenance and job assignments.
· Interfaced directly with Client to provide a high quality of customer satisfaction.
· Provide initial problem troubleshooting and resolution for various maintenance requests.


TERADATA SYSTEM TESTER, OAO Technologies, Moncton, NB: April 2000 – 2003.

· Participated in the testing of large-scale projects for AT&T using the IBM SDF methodology including software testing, project documentation and system and integration test cases.

ACCESS ADMINISTRATION, Imperial Oil, Moncton, NB : Mar 00 – May 00

· Granted access rights to clients on various operating systems such as UNIX, Windows 95/98/NT/XP/2000, SAP/R3, MVS, VM.

CUSTOMER SERVICE REPRESENTATIVE, Royal Bank Financial Group, Moncton, NB: Nov 95 - Jul 99


CUSTOM BROKER, KN Custom Brokers, Toronto, ON: Sep 87 - Jul 94


Education
Teradata Customer Education. – TERADATA CERTIFIED PROFESSIONAL.
Teradata Customer Education. – TERADATA CERTIFIED SQL SPECIALIST.
Information Technology Institute- DIPLOMA IN APPLIED INFORMATION TECHNOLOGY.
OAO Technologies. - QUERYMAN/TERADATA/COBOL/SQL/C/UNIX.
Canadian Society of Custom Brokers – CSCB DIPLOMA.
Imperial Oil. - UNIX, SAP/R3, MVS, VM.