SUMMARY:

• 6+ Years’ experience in the IT industry coupled with extensive experience in Data Warehousing Teradata & UNIX Environment for Decision support systems.
• Experience in Data Warehousing applications in Retail, Health, Insurance and Financial domains.
• Over 4 years’ experience in Teradata Database design, Implementation, Maintenance and administration mainly in large scale Data Warehouse environments.
• Hands on Experience in Teradata RDBMS using BTEQ, FASTLOAD, MULTILOAD, TPUMP, FASTEXPORT and TPT TERADATA SQL utilities.
• Excellent Programming experience in Teradata SQL.
• Expertise in Query analyzing and Performance tuning.
• Excellent knowledge in tuning complex Teradata SQL Queries including Joins and Correlated Sub Queries.
• Expertise in using Teradata SQL Assistant, Teradata Viewpoint including Auto Stats, Teradata Manager & Teradata Administrator.
• Knowledge in Teradata Architecture, Informatica & Data Modelling Concepts.
• Knowledge on Big data tools - - Spark, Hive, Zeppelin
• Excellent Communication & Client Management Skills.
• Work Experience in the Onsite-Offshore Model.
• Very good knowledge on SDLC, Quality procedures, Defect Management and Software processes & Standards.

TECHNICAL SKILLS:

Databases: Teradata, DB2

Languages: SQL, Unix Shell Scripting

Tools: Teradata FastExport, Fastload, Mload, Tpump, Teradata SQL assistant, Teradata Manager, Teradata Administrator, Erwin, Netezza, Microstrategy, Teradata Viewpoint

Operating Systems: NCR UNIX, Windows XP, Vista & 7, MS-DOS

Job Scheduling Tools: Cron

Reporting Tools: Microstrategy, Cognos

WORK EXPERIENCE:

Confidential, Richardson, TX

ETL Developer

Responsibilities:

• Develop BTEQ, FLOAD, MLOAD and TPT scripts to retrieve data from other sources.
• Perform Unit testing, System Integration testing on the developed scripts and move them to PROD following the company standards.
• Managed a team of 4 from offshore and held daily meetings to resolve any issues/concerns.
• Performed Impact Analysis in order to make sure that, the new enhancements do not negatively impact the already existing business functionalities, which are needed by the business.
• Performance tunes the Teradata SQL queries and solves the spool space issues.

Technologies: Teradata SQL,, BTEQ, FASTLOAD, MULTILOAD, Teradata Viewpoint, Teradata Heat Map Utility, Erwin, Performance Tuning

Confidential, Atlanta, GA

Teradata Application Developer/DBA

Responsibilities:

• Reviewing and evaluating physical structures for database designing and Modeling.
• Appraising dashboard/adhoc SQLs to bring value to Teradata system.
• Debugging complex SQL and incorporating database requests into application programs.
• Performance tuning and CPU cycle saving for all Teradata applications scripts by adding value to the system
• Worked on various ETL issues and solving them dynamically is critical.
• Replaced regular corn jobs with Autostats Portlet on all the objects through Teradata Viewpoint.
• Installed Teradata Heat Map Utility on node system to reveal most used tables in Teradata Intelligent Memory.
• Re-writing Teradata SQL for various reporting applications.

Technologies: Teradata SQL, PERFORMANCE TUNING, BTEQ, FASTLOAD, MULTILOAD, Teradata Viewpoint, Teradata Heat Map Utility, Erwin.

Confidential, Richmond, VA

Teradata/ETL Lead

Responsibilities:

• Develop BTEQ and FLOAD scripts to retrieve data from other sources into Edward.
• Perform Unit testing, System Integration testing on the developed scripts and move them to PROD following the company standards.
• Also, developed some BTEQs to load reporting tables as per Business reporting requirements.
• Managed a team of 5 from offshore and held daily meetings to resolve any issues/concerns.
• Write Teradata SQL to generate reports as per the business requirements on Edward.
• Retiring Legacy applications in some cases.
• Performance tunes the production Teradata SQL queries and solves the spool space issues.

Technologies: Teradata SQL, BTEQ, FASTLOAD, MULTILOAD, FASTEXPORT, Unix

KLA-Tencor

Technology Analyst

Responsibilities:

• Work closely with the business group to understand requirements & translate the same into technical design & code.
• Analysis, development, testing & support on both database and front end.
• Working on extracts & manipulating data from the Teradata EDW.
• Creating new packages & enhancing existing packages with Teradata SQL & Microsoft SQL Server.
• Performance tuning & optimization of large databases.

Confidential

Technology Analyst

Responsibilities:

• Developed Shell scripts and complex SQL to load data into the data warehouse.
• Enhancements on the applications using Teradata SQL, load utilities such as BTEQ, Fastload, Mload & Legacy Mainframe applications.
• Enhancements on the applications using SQL, Unix & Legacy Mainframe tools.
• Handled the business critical questions and resolved them within the various severity levels set by the business and IT.
• Handled the research-intensive questions by creating Problem management tickets.
• Performed Impact Analysis in order to make sure that, the new enhancements do not negatively impact the already existing business functionalities, which are needed by the business.

Technologies: Teradata SQL, BTEQ, FASTLOAD, MULTILOAD, FASTEXPORT

Confidential

ETL Tester

Responsibilities:

• Review Business Requirements, Business Use Case and functional documents.
• Involved in Writing the Test Cases and Test Plans based on Source to Target Mapping Documents
• Validation of data load in Teradata.
• Validation of Access control restrictions and privileges in Teradata.
• Preparing the Unit test plan and Unit test results documents with test results.

Technologies: Teradata SQL, BTEQ, FASTLOAD, MULTILOAD, FASTEXPORT