We provide IT Staff Augmentation Services!

Senior Teradata Programmer Resume

0/5 (Submit Your Rating)

Phoenix, AZ

SUMMARY:

  • Insightful experience of EIGHT years across multiple Software Functions.
  • Adept at software development cycles involving System Study, System Analysis, System Design, Development, Enhancement, Implementation and Support activities.
  • Deft at mapping the customer requirements, custom designing solutions, performance tuning, troubleshooting for software and application problems.
  • Deft at preparing presentation for new business opportunities in the project.
  • Deft at providing Initiative cost estimates for upcoming projects. Deft at performing intricate analysis and handling / manipulating / representing data in massive volumes.
  • Team Player with excellent communication (verbal and written) and interpersonal skills with proven abilities in resolving complex query issues.
  • Strong leader with experience in developers and providing technical suggestions on ETL best practices.
  • Designing and execution of projects. Implementing project plans/change requests within deadlines. Identifying faults in programs and prepare reports on the uses of programs.
  • Preparing analysis and design documents prior to making code changes in programs.
  • Responsible for maintaining, upgrading and setting up production batch Jobs. Adhering to best practices for project support, documentation and coding.
  • Providing post - implementation maintenance support to client for application / software.
  • Extracting / manipulating / representing large volumes of data. Performance tuning of resource consuming queries.
  • Loading/Unloading data from tables using Teradata Utilities.
  • Performing detailed analysis on Teradata Stored Procedures. Adept at troubleshooting for postproduction issues.

TECHNICAL SKILLS:

Languages: COBOL, JCL, SQL.

Database: Teradata.

OS: Windows, OS/390, UNIX.

Tools: TSO/ISPF, FTP, NDM, FILEAID, Changeman, Teradata Utilities (MLOAD, FLOAD, FastExport, BTEQ, TPUMP), Teradata SQL Queryman, Microsoft Office. Teradata Administrator.

PROFESSIONAL EXPERIENCE:

Confidential, Phoenix, AZ

Senior Teradata Programmer

Responsibilities:

  • Analysis of existing Sybase stored procedures and writing design steps to migrate them to Teradata.
  • Writing and testing Teradata stored procedures. Coordinating with offshore team to develop and test the stored procedures. Performance tuning of resource consuming queries in production.
  • Defect tracking using Quality center. Design suggestion on table structures changes, archives, query tunings etc. Educating offshore folks and new joiners for better understanding of requirements and better quality deliverables. Teradata Certified Master V2R5.
  • Teradata Certified V2R5 Master.
  • Appreciation from clients for successfully completing first assignment at onsite with zero defects in a very tight schedule. Appreciation from Program Manager for active involvement and getting new business from clients.
  • Appreciation from Client Application manager for service offered as Subject Matter Expert. Appreciation from Client Application manager for providing accurate estimates for upcoming project initiatives.

Environment: Sybase, Teradata, UNIX.

Confidential, Charlotte, NC

Analyst, Developer

Responsibilities:

  • The main work in this project is loading of user-ready data onto Teradata tables from mainframe files. We get files from different applications with raw data. The data has to be processed and then loaded into tables for the use of business users. Analysis of the Requirement.
  • Preparation of Unit Test Plan and Test Cases. Perform Program Construction/Modification due to Problem Fixes and other Enhancements. Development and Unit Testing of Modules. Design a Production process for extracting the Final Data to the users on an as-needed basis.
  • Used several Teradata Utilities (MLOAD, FLOAD, FastExport, BTEQ, and TPUMP) to load/unload data from tables. Worked extensively in Cobol, JCL and SQL to process data as a part of developments/enhancements.
  • Have got significant exposure to Teradata DB while working in this project. Involvement in process and quality related activities. Educating the offshore team and new joiners for better understanding of the requirements and better quality of deliverables.
  • Coordinating the offshore team in designing and implementing the process of data extraction. Involvement in IQA/EQA activities to ensure high quality deliverables. Involvement in resource evaluation activities with regards to new joiners in the team.
  • Made constant contributions to the knowledge bank at Project level. Involvement in value add activities for the clients. Performance tuning for resource consuming queries. Providing initiative estimate for upcoming new initiatives.

Environment: Mainframes, JCL, COBOL, SQL, Teradata.

Confidential

Tester

Responsibilities:

  • Preparing & reviewing Test Scripts & Test Results. Testing eCommerce applications using JAWS & Window Eyes. Keeping record of Test Results. Logging Defects in TD. Tracking closure of Defects in TD & Defect Register. Reviewing Client Supplied Products.

Environment: Windows XP, Internet explorer 6.0, Jaws 6.0, Windows Eyes 5.0, Test Director 8.0.

We'd love your feedback!