PROFESSIONAL SUMMARY:

• Over 7.2+ years of extensive experience as a software developer in Teradata based applications.
• Experienced with all Software Development Life Cycle - Design, Development, Testing, Deployment, Maintenance, Support and Enhancement.
• Professional expertise in Teradata
• Professional expertise in Teradata SQL programming, developing scripts, Functions using the Teradata utilities
• Strong skills at analyzing dimensions and fact tables and associated measures.
• Proficient in Teradata Tools and Utilities such as Teradata SQL Assistant, Import/Export.
• Participated in collecting the requirements, analyzing the System Requirements.
• Ability to meet deadlines and handle pressure in coordinating multiple tasks in a work/project environment.
• Experienced in using Explain Plan for Query tuning, collection of statistics and creation of indexes for database access and indexing the required columns.
• Basic experience in Informatica 9.1.0 tool, developing mappings, workflows to pull data from different source
• Extensively used UNIX shell Scripts for automating batch programs.
• Proficient in working with UNIX shell scripts using PUTTY Environment.
• Excellent Interpersonal and communication skills, efficient time management and organization skills, ability to handle multiple tasks and work well in a team environment.
• Fast and self-studying learner of new and required technologies.
• Lead the development team and given the valuable support in each phase of the project
• Possess excellent Interpersonal, Communication and written skills

TECHNICAL SKILLS:

Databases: Teradata V2R6, Teradata 12.0, Teradata 13.0.

Development tools: Teradata SQL Assistant, Import/Export utility

Database Languages: Teradata SQL.

Programming Languages: UNIX Shell Programming, JCL(Job Control Language)

Operating Systems: Windows 95/98/2k/NT/XP, UNIX PLATFORM

ETL Tools: Informatica 9.1.0

Test Management: Hp Quality Center

Work Scheduler tools: TWS(Tivoli work scheduler), CA7 in Mainframe

PROFESSIONAL EXPERIENCE

Confidential, CT.

Teradata Technical Lead

Responsibilities:

• Worked as the Teradata technical leader
• Prepared design document and also performed the Data profiling for data topics.
• Created the ETL Spec for source and target layer
• Participated in Business Requirements walkthrough and make necessary suggestions.
• Worked with business analyst to get the requirements and prepare software specification based on business requirement documents.
• Developed new feed which is the input to the reporting
• Optimized SQL to bring down execution time.
• Ensure deliverable are created as per Quality Management practices followed by the company or as outlined for the project/release

Confidential, CT.

Teradata Technical Lead/ Data Architect

Responsibilities:

• Worked as the Teradata technical leader
• Worked as a Data Architect and performed the Data profiling
• Created the ETL Spec for source and target layer
• Participated in Business Requirements walkthrough and make necessary suggestions.
• Worked with business analyst to get the requirements and prepare software specification based on business requirement documents.
• Developed new feed which is the input to the reporting
• Optimized SQL to bring down execution time.
• Ensure deliverable are created as per Quality Management practices followed by the company or as outlined for the project/release

Environment:Teradata 13.0 (Teradata SQL Assistant), Informatica 9.1.0Tata Consultancy Services

Confidential, Richfield, MN

Teradata Technical Lead

Responsibilities:

• Worked as the Teradata technical leader
• Participated in Business Requirements walkthrough and make necessary suggestions.
• Worked with business analyst to get the requirements and prepare software specification based on business requirement documents.
• Developed and modified packages, functions and stored procedures for data conversions
• Developed various matrix tables for reporting and also for Customized existing reports
• Developed new feed which is the input to the reporting
• Optimized SQL to bring down execution time.
• Ensure deliverable are created as per Quality Management practices followed by the company or as outlined for the project/release
• Worked as the Teradata technical leader
• Participated in Business Requirements walkthrough and make necessary suggestions.
• Worked with business analyst to get the requirements and prepare software specification based on business requirement documents.
• Developed and modified packages, functions and stored procedures for data conversions
• Developed various matrix tables for reporting and also for Customized existing reports
• Developed new feed which is the input to the reporting
• Optimized SQL to bring down execution time.
• Ensure deliverable are created as per Quality Management practices followed by the company or as outlined for the project/release

Environment:Informatica 9.1.0, Teradata 12.0 (Teradata SQL Assistant)

Confidential

Responsibilities:

• Worked as the Teradata technical leader
• Participated in Business Requirements walkthrough and make necessary suggestions.
• Worked with business analyst to get the requirements and prepare software specification based on business requirement documents.
• Developed and modified packages, functions and stored procedures for data conversions
• Developed various matrix tables for reporting and also for Customized existing reports
• Developed new feed which is the input to the reporting
• Optimized SQL to bring down execution time.
• Ensure deliverable are created as per Quality Management practices followed by the company or as outlined for the project/release

Environment: Informatica 9.1.0, Teradata 12.0 (Teradata SQL Assistant)

Confidential

Responsibilities:

• Worked as the Teradata technical leader
• Participated in Business Requirements walkthrough and make necessary suggestions.
• Worked with business analyst to get the requirements and prepare software specification based on business requirement documents.
• Developed and modified packages, functions and stored procedures for data conversions
• Developed various matrix tables for reporting and also for Customized existing reports
• Developed new feed which is the input to the reporting
• Optimized SQL to bring down execution time.
• Ensure deliverable are created as per Quality Management practices followed by the company or as outlined for the project/release

Environment:Informatica 9.1.0, Teradata 12.0 (Teradata SQL Assistant)

Confidential

Teradata Technical Leader and developer

Responsibilities:

• Worked with business analyst to get the requirements and prepare software specification based on business requirement documents
• Involved in System Analysis, Design, Coding, Data Conversion, Development and Implementation.
• Deigned logical and physical model of database for calculating advertisement effectiveness.
• Created tables, indexes and sequence in the schema.
• Exported data from same database and also from another database using database link.
• Created test data for validation of project and mocking of data was done.
• Validated the feasibility and performance of Teradata Components when there was a change in requirements and design changes
• Identified the training needs for the team members and provided the training and assisted them in their technical career growth.
• Worked with business analyst to get the requirements and prepare software specification based on business requirement documents
• Involved in System Analysis, Design, Coding, Data Conversion, Development and Implementation.
• Deigned logical and physical model of database for calculating advertisement effectiveness.
• Created tables, indexes and sequence in the schema.
• Exported data from same database and also from another database using database link.
• Created test data for validation of project and mocking of data was done.
• Ensure deliverable are created as per Quality Management practices followed by the company or as outlined for the project/release

Environment:Mainframe JCL (Job Control Language), Teradata 12.0 (Teradata SQL Assistant)