Teradata Performance Specialist Resume
SUMMARY:
Expertise in application development and performance tuning in large scale Teradata environment. Extensive hands-on performance tuning expertise in Teradata, that includes the basics of stat collection, index creation, JI creation, PPI implementation, PI modifications. In addition I have extensive experience in re-designing and optimizing existing sql, applications, and reports to perform well in Teradata. I have lead major re-designs of architecture for existing ETL applications including data models, ETL, and report modifications to perform well within Teradata.
TECHNICAL SKILLS:
- Teradata
- Oracle
- SQL
- ETL
- Data Modeling
- HA architecture
- EDW Architecture.
Confidential
Teradata Performance Specialist
Responsibilities:
- Lead the EDW architecture and standards group.
- Lead the Teradata performance group.
- Analyze and performance tune ETL applications, Microstrategy reports, and user queries. Optimize ETL workflow and development methodologies.
- Mentor ETL developers, data modelers, and end users in SQL and Teradata Architecture.
Confidential
Team Lead ETL Developer
Responsibilities:
- Team Lead for Accounting Data Mart Team on the Confidential project.
- Write ETL code through unix scripts with teradata SQL to load data into Confidential EDW.
- Develop ETL code using a variety of teradata tools such as multiload, fastload, fastexport, bteq, etc...
- Write unix shell and perl scripts to drive the use of the teradata utilities.
- Tune and optimize queries and use best practices when developing new ETL code.
- Work with customers and project managers to gather requirements and business rules for transforming and loading their data.
- Winston Joseph 8/2002 - 1/2003 Software/Database Developer
- Developed an internal purchase ordering, accounting, inside sales, project management system from the ground up.
- Gathered requirements from end-users and business management.
- Created data model.
Confidential
Software Developer
Responsibilities:
- Responsible for the ongoing development and maintenance of the “Cross-Segment Analysis,” “Measure Editor,” “Percentile Profile”, “FTP”, and “Reporting” of the leading Customer Relationship Management software package Teradata CRM.
- Worked with outside vendors and development teams to correct data quality and performance issues that they ran into while using the CRM report module.
- Performance tuned queries and reports from customers.
Confidential
Software Developer
Responsibilities:
- Developed the internal accounting and customer service software using C Basic and Visual Basic language.
- Daily tasks included coding, writing design specifications for software developers, review and analysis of development work performed by peers and software documentation.
