SUMMARY

• 7.5+ yrs. of professional IT experience in designing, development, testing, implementation and maintenance of Data Warehousing Systems and Business Intelligence applications across various platforms and industries.
• Currently working as a Sr. ETL Developer for teh client AT&T, Confidential under teh Business Intelligence and Data Warehousing wing.
• Strong knowledge of Data Warehousing Concepts.
• Good knowledge in Teradata Architecture and implementation techniques.
• Worked extensively on using Teradata Utilities BTEQ, Fast Load, Multi Load, Fast Export, and TPT.
• Good at writing Teradata SQLs, Procedures and Functions using analytical functions and recursive queries.
• Good in using compression, Partition Primary Index and other performance techniques to fine tune teh queries.
• Have used ETL tool Informatica. Developed and worked with all kinds of transformations and performance tuning techniques.
• Excellent working knowledge in UNIX and Shell scripting. Proficient in job scheduling tools like Dollar Universe ($U) and Tivoli schedulers.
• Good knowledge in Oracle SQL and PL/SQL programming.
• Have knowledge in Golden Gate replication software.
• Good exposure to Telecom, Finance, Sales, Customer Profiling subject areas.
• Performed different kind of roles Developer, QA Analyst and Support lead.
• Experienced in environments requiring direct customer interaction during specifications, design, and development and product implementation phases.
• Hands - on-Experience in preparation of High-Level & Low-Level Design Specs, Unit Test Cases and Deployment forms.
• Pro-Active to production Issues and proficient in meeting teh deadlines.
• Fast learner and Ability to grasp new technologies.

TECHNICAL SKILLS

ETL Tools: Informatica 8.x.x/9.x.x, Teradata Utilities (BTEQ, Fastload, MultiLoad, FastExport, TPT), Teradata SQL Asst

Databases: Teradata V2R6.x, Teradata V12/V13/V14/V15, Oracle, Vertica

Reporting: Business Objects

OS: Windows NT Server, Red Hat Linux, UNIX

Languages: SQL, PL / SQL, C, Shell scripting, Java programming

Other tools: $Universe, Tivoli, Kintana, PVCS, Alliance Remedy, Clearcase, Quality, Center, Teradata View Point, Erwin Data Modeler

PROFESSIONAL EXPERIENCE

Confidential,

Responsibilities:

• Developing/implementing teh code for new requirements from Business and teh downstream systems as per Design specification document (DA Specs). dis is to enhance eCDW-Uverse and Confidential applications to bring new functionality/to enhance teh existing functionality.
• Involved in creating mapping specification documents based on design documents
• Worked on Tearadata BTEQ, Fast Export and TPT scripts for extract and loading teh data to target tables
• Worked on developing mappings using various transformations like Lookup, Filter, Expression, Aggregator, Joiner etc. for implementing teh ETLs
• Worked on performance tuning Teradata SQLs for various applications to improve teh SLAs
• Conducting code review sessions with Offshore/Onshore team to make sure dat Code is meeting teh functionalities as well as ATT Code and Quality standards.
• Preparing Development package which has all teh information about Software Configuration Management (SCM) data, Deployment guide and Code review artifacts.
• Supporting teh project post production deployment during warranty (Redhat) period
• Analysing and fixing teh day to day data issues reported on eCDW Uverse and Confidential data by teh Business users and down streams.
• Coordinating with teh offshore team on teh development and support activities
• Communicating teh critical information related to teh project activities across all teh application teams

Environment: Teradata v15.x, Vertica v7.x Informatica 8.6.1/Informatica 9.6.1, Tivoli, Oracle 11g, Linux

Confidential,

Responsibilities:

• Supporting teh day to day production support activities in Enterprise Data Warehouse in all teh subject areas bookings, finance and customer data.
• Analyzing and fixing teh data issues reported by teh application teams and business users for better reporting.
• Worked on Tearadata BTEQ, Fast Export and TPT scripts for extract and loading teh data to target tables
• Worked on developing mappings using various transformations like Lookup, Filter, Expression, Aggregator, Joiner etc.
• Analyzing and tuning performance of Teradata SQL queries used in Business Objects and other reporting tools reported by teh business users
• Developing/implementing teh code for new requirements from teh downstream systems.
• Responsible for reviewing teh Quality procedures related to teh project code
• Deploying teh code changes in production by following Change management process.
• Coordinating with teh onsite team on teh development activities
• Communicating teh critical information related to teh project activities across all teh application teams.
• Day to Day review of teh Alliance Remedy tickets for better case management

Environment: Teradata V13, Informatica 8.6.1, $U, Oracle 9i, Teradata Utilities (BTEQ, Tpump and Fast Load)

Confidential,

Responsibilities:

• Onsite-Offshore coordination - Single point of contact for teh offshore team
• Analysis of teh Requirements & Specifications
• Developed mappings, sessions and workflows for teh new ETL process followed with Enterprise ETL standards
• Implemented all teh ETL Architecture standards for teh new technology Teradata
• Involved in Review meetings during Design & Development to identify, reduce/mitigate risk at every stage.
• Supervising and executing teh offshore development activities.
• Involved in Data reconciliation between teh EDW & EDWTD environments
• Providing teh Post-Production support

Environment: Teradata V2R6, Oracle 9i, Informatica 8.1.x, UNIX, PL/SQL, Teradata Utilities (BTEQ, Tpump and Fast Load)

Confidential,

Responsibilities:

• Understanding teh existing Business rules and data flow to populate teh desired attributes.
• Analyzing teh list of objects affect with teh new project requirements.
• Involved in Design Review and preparation of ETL Design Documents.
• Involved in Code Review and Testing of Informatica mappings.
• Developed Fastload, Bteq scripts to load data from EDW.
• Preparing audits to ensure teh SSOT and first level aggregate tables are in sync.
• Preparing Deployment documents for teh deliveries.
• Providing Post production support.

Environment: Teradata V2R6, Oracle 9i, Informatica 8.1, UNIX, PL/SQL, Teradata Utilities (BTEQ, Tpump and Fast Load)

Confidential

Responsibilities:

• Supported EDW migration from Informatica 7.1.2 to Informatica 8.1.1
• Setup teh environment to configure Teradata Utilities with Informatica.
• Involved with teh Architecture team to develop a template for different kinds of ETL extractions.
• Implemented push down optimisation feature of Informatica 8.1.1 with teradata.
• Implemented incremental extraction with use of parameters and variables from flat files in Linux.
• Migrated EDW2B ETLs from Dev to QA to Prod
• Implemented all teh ETL Architecture standards for teh new technology Teradata
• Involved in performance metrics comparison between teh EDW & EDW2B environments
• Involved in troubleshooting teh scripts and providing teh solutions.
• Post-Production support to monitor all jobs in new environment with Teradata

Development

Confidential 

• Studying and understanding of teh Mapping documents.
• Analysis of teh Source tables, columns and creating Target table definitions.
• Designing detail design Documents.
• Loading teh stage tables using Informatica fast loader utility.
• Writing BTEQ scripts for loading data into teh tables.
• Responsible for QA migration and Production Deployment.

Environment: Teradata V2R6, Oracle 9i, Informatica 8.1, UNIX, PL/SQL, Teradata Utilities (BTEQ, Tpump and Fast Load)