SUMMARY

• Over FIVE years of IT experience in Analysis, Design, Development, Testing, Implementation and Support of Data Warehousing and Data Integration Solutions for Retail domain using Teradata Utilities, Ab - Initio, UNIX and Oracle.
• Proficiency in developing SQL with relational databases like Teradata. Strong with relational database design concepts.
• Understand the business rules completely based on High Level document specifications and implements the data transformation methodologies. Independently perform complex troubleshooting, root-cause analysis and solution development.
• Ability to meet deadlines and handle multiple tasks, decisive with strong leadership qualities, flexible in work schedules and possess good communication skills.
• Team player, Motivated, able to grasp things quickly with analytical and problem solving skills.
• Lead the team in all technical activities, issues as Module lead. Comprehensive technical, oral, written and communication skills

TECHNICAL SKILLS

• Teradata
• Oracle
• Paraccel
• SQL Server
• Ab Initio
• Talend

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, GA

Teradata Analyst

Responsibilities:

• Communicating with onsite for requirement and design understanding. Understanding the Customer subject area and the tables.
• Identification of table issues between the databases and rectify them through the DBA.
• Move the data from Teradata staging table to Teradata EDW tables using Teradata BTEQ scripts.
• Verifying that the data are in sync between source and target tables.
• Co-ordinating Unit testing, QA migration and support, defect fixing, deployment setup including implementation plan, QA document, RFC creation and for the above work streams.

Environment: AIX UNIX, EME - 3.1.2.6., Maestro 8.2.1, Oracle Exadata database, Tools: EME (for source code control), HEATS (for code migration), HDDTM and Maestro (for job automation), Oracle SQL Developer, Ab Initio (ETL tool).

Confidential

Teradata Analyst

Responsibilities:

• Communicating with onsite for requirement and design understanding.
• Understanding the Customer subject area and the tables.
• Identification of table issues between the databases and rectify them through the DBA.
• Verifying that the data are in sync between source and target tables.
• Co-ordinating Unit testing, QA migration and support, defect fixing, deployment setup including implementation plan, QA document, RFC creation and for the above work streams.

Environment: AIX UNIX, EME - 3.1.2.6., Maestro 8.2.1, Teradata database. Tools: EME (for source code control), HEATS (for code migration), HDDTM and Maestro (for job automation), Teradata SQL Assistant.

Confidential

Teradata Developer

Responsibilities:

• Communicating with onsite for requirement and design understanding.
• Understanding the Customer subject area and the tables.
• Developments of BTEQ scripts and load the Target tables in PRO-RWRD database.
• Identification of table issues between the databases and rectify them through the DBA.
• Move the data from Teradata staging table to Teradata EDW tables using Teradata BTEQ scripts.
• Verifying that the data are in sync between source and target tables.
• Unit testing, QA migration and support, defect fixing, deployment setup including implementation plan, QA document, RFC creation and for the above work streams.

Environment: AIX UNIX, EME - 3.1.2.6., Maestro 8.2.1, Teradata database. Tools: EME (for source code control), HEATS (for code migration), HDDTM and Maestro (for job automation), Teradata SQL Assistant, Ab Initio (ETL tool).

Confidential

Teradata Developer

Responsibilities:

• Communicating with onsite for requirement and design understanding.
• Understanding the Customer subject area and the tables.
• Development of BTEQ scripts and load the Target tables in PRO-RWRD database.
• Identification of table issues between the databases and rectify them through the DBA.
• Move the data from Teradata staging table to Teradata EDW tables using Teradata BTEQ scripts.
• Verifying that the data are in sync between source and target tables.
• Unit testing, QA migration and support, defect fixing, deployment setup including implementation plan, QA document, RFC creation and for the above work streams.

Environment: AIX UNIX, EME - 2.15.6., Maestro 8.2.1, Teradata database. Tools: EME (for source code control), HEATS (for code migration), HDDTM and Maestro (for job automation), Teradata SQL Assistant.

Confidential

Teradata Developer

Responsibilities:

• Communicating with onsite for requirement and design understanding.
• Understanding the Customer subject area and the tables. Development of BTEQ scripts and load the Target tables in PRO-RWRD database.
• Identification of table issues between the databases and rectify them through the DBA.
• Move the data from Teradata staging table to Teradata EDW tables using Teradata BTEQ scripts
• Verifying that the data are in sync between source and target tables.
• Unit testing, QA migration and support, defect fixing, deployment setup including implementation plan, QA document, RFC creation and for the above work streams.

Environment: AIX UNIX, EME - 2.15.6, Maestro 8.2.1, Teradata database. Tools: EME (for source code control), HEATS (for code migration), HDDTM and Maestro (for job automation), Teradata SQL Assistant.

Confidential

Developer

Responsibilities:

• Communicating with onsite for requirement and design understanding.
• Understanding the Customer subject area and the tables.
• Development of Informix 4GL scripts and change the merchandise components according to requirement.
• Identification of code issues between the source codes and rectify them.
• Development of Informix .sgl and .per scripts for designing the interface according to Client Partner requirements.
• Analyzing source codes and identifying the areas need to be changed for meeting the Client Partner requirements. Unit testing, QA migration and support, defect fixing, deployment setup including implementation plan.

Environment: AIX UNIX, Clearcase. Technology: Informix.

Confidential

Production Support Executive

Responsibilities:

• Communicating with onsite, L0, L1, L2 for provisioning as well as updating issues. Monitoring and fixing different issues during patch loading.
• Remoting to the Client Partner PCs and idientifying the root causes behing Client Partner issues.

Environment: AIX UNIX, Windows. Tools: Matrix Empirum 42, Symantec Anywhere, RDP, HPSM, On Command Centre.