PROFESSIONAL SUMMARY:

• 10+ years of IT experience. Over 8+ years of strong experience in System Analysis, Design, Development, Testing in the fields of Databases/Datawarehousing processes utilizing Data warehouse and client server technologies, in Analyzing / building Teradata EDW using Teradata ETL utilities with Informatica or Datastage.
• Extensive Work experience in Teradata 13.10/12/ V2R6/V2R5 (Teradata SQL Assistant, BTEQ, Fast Load, MultiLoad, TPump, FExport, Visual Explain).
• Extensively worked in Development of ETL Process Flows, Mappings(informatica),Graphs(Datastage) and writing BTEQ scripts in loading data by utilizing Teradata utilities Fastloads/Mloads, FastExport in to Teradata EDW.
• Extensively used transformations in Informatica Power mart/ Power Center & Datastage ETL Environments to move data from multiple sources into target area, mostly EDW as Teradata.
• Worked on Informatica IDQ in performing Quality steps and Informatica IDR for Source/target and bidirectional data transfer/sync.
• Proficient in Teradata SQL coding, using Teradata BTEQ utility, Working Knowledge on Teradata \ Parallel Transport utility/TPUMP. (TPT) coding.
• Involved in Data Migration between Teradata, SAP, MS SQL server and Oracle.
• Experienced in performance tuning of sources, Informatica mappings, Graphs, target systems.
• Working knowledge in relational databases (RDBMS), data modeling and in building Data Warehouse, Data Marts using Star Schema and Snowflake Schema.
• Worked extensively on Data mappings from various source systems on to target systems involving Teradata as EDW
• Sound Knowledge of SQL and Data warehousing Concepts.
• Have extensively involved in the development of new programs and enhancements for the existing programs/Subject areas.
• Have strong handling experience of Production support failure jobs
• Strong experience in Teradata database Performance Tuning and extensive experience in SQL Loader Imports/Exports.
• Strong exposure in data quality identification, remediation and data conversion Requirements.
• Extensive experience in coding using SQL,PL/SQL Procedures/Functions, Triggers and Packages in Oracle and Teradata
• Consolidate data from various departments into the data warehouse by identify the Common data and solve the discrepancy on data values and created various data marts.
• Good knowledge of OLAP/MOLAP reporting tools like Cognos, Crystal Reports, Business Objects - Supervisor, Designer and Web Intelligence for building Enterprise reports.
• Excellent working knowledge of Unix Shell Scripting and automation of ETL processes using Crontab/Espx, Autosys, Control-M on multiple platforms such as Windows NT/2000/XP, Linux/UNIX.
• Exposure to Oracle Business Intelligence Suite (OBIEE).
• Extensively performed Unit testing, Performance, System, Integration and user testing in various Multiple SMB projects.
• Good problem solving skills, quick learner, effective individual, team player, excellent communication presentation skills, the ability to integrate information from multiple sources to execute effectively and Efficiently in a dynamic environment and pursue a proactive approach to problem solving.

TECHNICAL SKILLS:

Data Warehousing: Teradata 13.10/V12/V2R9/V2R6, Informatica power centre/Power mart 9.5/9.0/7.1/6. x, Data stage 8.1/8.0.1

Business Intelligence: Cognos 6.0 (Impromptu, PowerPlay, Transformer), Crystal Reports, Business Objects 6.0/5.x (Designer, Supervisor, Reporter & WEBI).

Data Modeling: Erwin 4.1/3.5.5, Star-Schema Modeling, Snowflakes Modeling, FACT & Dimensions

Databases: Oracle10g,9i/8i/8.0/7.x,MSAccess7.0,Teradata 13.10/12, V2R6/V2R5/V2R4

Programming: SQL, PL/SQL, UNIX Shell Scripts.

Operating Systems: Windows 8/XP/95/98/NT/2000, Unix/Linux.

PROFESSIONAL EXPERIENCE:

Confidential, West Chester, Pennsylvania

Systems Analyst /Teradata ETL Consultant with Informatica

Responsibilities:

• Understanding the leadership team needs and the Data management Reboot Teams requirements in estimating the work scope by application and target system.
• Analyze the ETL Processes/Scripts/joins involved by application towards estimating the work scope.
• Involved in designing the process flow for extracting the data across various interacting systems.
• Creating the mapping documents from the current Entity/attribute model to New table/column for Migration.
• Worked with the Consumers/Business owners to implement this objective towards getting the signoffs per target system
• Proposed & written the alternate scripts on Oracle Database for source of truth Systems.
• Written several Teradata BTEQ scripts on an ongoing basis to implement the business logic for SOT as Teradata.
• Develop the required Informatica mappings in combination with Teradata towards invoking Required Teradata loaders(MLOAD/FASTLOAD) & TPT Connectors and BTEQ Scripts Separately.
• Proposed & written the queries for the Teradata NDW model as alternate Source of truth for Few applications and suggested Indexes by tables/columns per application.
• Rewrite the Queries for approved Target Systems towards implementing using Shared Teradata PII view.
• Schedule the meetings and Get the Signoffs from Each Individual system of truth POC teams.
• Migrated list of consumers identified towards Signoff.

Environment: Teradata 14, Oracle 12g, UC4 Scheduler, DEFA Frame Work, Unix/Linux, Informatica 9.5.x

Confidential, Irving,Texas

Teradata SME & ETL Consultant

Responsibilities:

• Understanding the business needs and the requirements and Estimating the work scope.
• Preparing the Functional/technical Design Document for the process flow for extracting/modifying the data across various interacting systems.
• Involved in preparing Technical Specifications by understanding Functional specs.
• Worked with the users/Customers.

Environment: Teradata 14, Oracle,Unix/linux, SSIS/SSRS, Informatica 9.x.

Confidential, Hoffmann Estates, Illinois

Lead Teradata DW ETL Consultant with Informatica/SSIS

Responsibilities:

• Understanding the business needs and the requirements and implement the same for the existing and new data flows.
• Preparing the Functional/technical Design Document for the process flow for extracting/modifying the data across various interacting systems.
• Involved in preparing Technical Specifications by understanding Functional specs.
• Documented data conversion, integration, load and verification specifications.
• Handling loading of data from several flat files sources to Staging using Teradata MLOAD, FLOAD/BTEQ Utilities.
• Handling Teradata BTEQ scripts on an ongoing basis to implement the business logic.
• Worked on exporting data to flat files using Teradata F-EXPORT.
• Understanding the business needs and the requirements and implement the same for the existing and new data flows.
• Data Quality Analysis to determine cleansing requirements.
• Extensively Worked on loading of data from several flat files sources to Staging using Teradata MLOAD, FLOAD Utilities.
• Written several Teradata BTEQ scripts on an ongoing basis to implement the business logic.
• Worked on exporting data to flat files using Teradata F-EXPORT.
• Modify/remove the Datastage graphs/Informatica Mappings in the existing POS flow in to datawarehouse.
• Worked on Informatica IDR(Informatica Data Replication) in reflecting/handling Source/Target transaction tables.
• Query optimization (explain plans, collect statistics, Primary and Secondary indexes)
• Build tables, views, UPI, NUPI, USI and NUSI.
• Worked with DBA’s for transition from Development to Testing and Testing to Production.
• Worked with the users/Customers and testing teams to implement the business logic/semantic layers as expected.
• Worked exclusively with the Teradata SQL Assistant to interface with the Teradata.
• Creation of Fastload and Mload scripts in loading data, according to the requirements
• Done Unit Testing for the mappings developed according to the specifications.
• To get involved in issue logging/tracking, risk identifying/maintaining exercise with the Team/Tech lead as required.
• Involved in modification of Developed Unix Shell scripts in Automation of ETL Teradata processes.

Environment: Teradata 14, Oracle 12g,Control-M Enterprise Manager, Unix/linux, SSIS/SSRS, Informatica 9.5.x, Informatica IDQ/IDR

Confidential, Woonsocket. Rhode island

Sr.Teradata Datawarehouse ETL Consultant

Responsibilities:

• Understanding the business needs and the requirements and implement the same for the existing and new data flows, in rel to HL7
• Involved in designing the process flow for extracting the data across various interacting systems.
• Worked on loading data(HL7) from EDW and Supporting Subject areas using Informatica/SSIS
• Worked on loading of data from flat files/Table sources to Staging using Teradata MLOAD, FLOAD Utilities.
• Worked exclusively with the Teradata SQL Assistant to interface with the Teradata.
• Written several Teradata BTEQ scripts on an ongoing basis to implement the business logic.
• Worked on exporting data to flat files using Teradata F-EXPORT.
• Query optimization (explain plans, collect statistics, Primary and Secondary indexes)
• Build tables, views, UPI, NUPI, USI and NUSI.
• Worked with DBA’s for transition from Development to Testing and Testing to Production.
• Worked with the users/Customers and testing teams to implement the business logic as expected.
• Creation of Fastload and Mload scripts in loading data, according to the requirements
• Modified the Teradata SQl to meet the changing standards.
• Worked Extensively on BTEQ Scripts in Teradata SQL Assistant.
• Modifying the BTEQ Scripts according to the requirements given by Business team.
• Monitoring of jobs (Daily, Monthly, Weekly) and Re-run failed jobs.
• Done Unit Testing for the mappings/ETL codes developed according to the specifications.
• Done the required Informatica Push Down optimization feature towards Teradata and worked on Informatica IDR for required tables replication.
• To get involved in issue logging/tracking, risk identifying/maintaining exercise with the Team/Tech lead as required.
• Involved in modification of Developed Unix Shell scripts in Automation of ETL Teradata processes.

Environment: Teradata 14, Oracle 12g, Unix/linux, Informatica 9.5 .0,Informatica IDR

Confidential, Richmond, VA

Sr. Datawarehouse Developer/ Systems Analyst/ Advisor

Responsibilities:

• Understanding the business needs and the requirements and implement the same for the existing and new data flows.
• Involved in preparing Technical Specifications by understanding Functional specs.
• Documented data conversion, integration, load and verification specifications based on HL7 messaging standards
• Worked/Lead the development effort of Informatica mappings, and Subsequent Teradata BTEQ scripts in implementing/transitioning the data to Teradata EDW Claim subject area tables.
• Extensively Worked on loading of data from several flat files sources to Staging using Teradata MLOAD, FLOAD Utilities.
• Written several Teradata BTEQ scripts on an ongoing basis to implement the business logic.
• Worked on exporting data to flat files using Teradata F-EXPORT.
• Query optimization (explain plans, collect statistics, Primary and Secondary indexes)
• Worked with DBA’s for transition from Development to Testing and Testing to Production.
• Worked with the users/Customers and testing teams to implement the business logic as expected.
• Worked exclusively with the Teradata SQL Assistant to interface with the Teradata.
• Creation of Fastload and Mload scripts in loading data, according to the requirements
• Modified the Teradata SQL to meet the changing standards.
• Worked Extensively on BTEQ Scripts and Teradata SQL Assistant.
• Modifying the BTEQ Scripts according to the requirements given by Business team.
• Done Unit Testing for the Informatica mappings developed according to the specifications.
• To get involved in issue logging/tracking, risk identifying/maintaining exercise with the Team/Tech lead as required.
• Involved in modification of Developed Unix Shell scripts in Automation of ETL Teradata processes.
• Involved in Production Support by performing Normal Loads, Bulk Loads, Initial Loads, Incremental Loads, Daily loads and Monthly loads on an ongoing basis.

Environment: Teradata V2R12, Oracle 10.1.0, SQL Server 2008, Unix, Informatica 9.x .,Informatica IDR

Confidential, Dublin, OH

Sr. Teradata/ Datawarehouse ETL Developer

Responsibilities:

• Involved and scheduled meetings with User, Business Analysts and Technical Analyst Towards attaining/ complete business requirements
• Understanding the business needs and the requirements and implement the same for the existing and new data flows.
• Documented data conversion, integration, load and verification specifications.
• Worked on loading of data from several flat files sources to Staging using Teradata MLOAD, FLOAD Utilities.
• Worked on pulling SAP MQ XML sources data for further processing Via DATASTAGE ETL tool
• Written Teradata BTEQ scripts on an ongoing basis to implement the business logic.
• Worked on exporting data to flat files using Teradata F-EXPORT.
• Query optimization (explain plans, collect statistics, Primary and Secondary indexes)
• Monitoring of near real time and all warehouse Jobs, on a Weekly on call, Rotation basis. Re-run failed jobs/Escalate if necessary.
• Done Unit Testing for the Graphs/Teradata ETL scripts developed according to the specifications.
• To get involved in issue logging/tracking, risk identifying/maintaining exercise with the Team/Tech lead as required.
• Involved in modification of Developed Unix Shell scripts in Automation of ETL Teradata processes.
• Involved in Production Support by performing Normal Loads, Bulk Loads, Initial Loads, Incremental Loads, Daily loads on an ongoing basis

Environment: Teradata 13.10, Oracle 10.1.0, Unix, DataStage 8.1, Sap-BW, SAP-MQ, Microstrategy 9.0

Confidential, Tampa, FL

Sr. Teradata/Informatica/Datastage/Datawarehouse ETL developer

Responsibilities:

• Understanding the business needs and the requirements and implement the same for the existing and new data flows.
• Involved in preparing Technical Specifications by understanding Functional specs.
• Data Quality Analysis to determine cleansing requirements.
• Involved in designing the process flow for extracting the data across various interacting systems.
• Documented data conversion, integration, load and verification specifications.
• Extensively Worked on loading of data from several flat files sources to Staging using Teradata MLOAD, FLOAD Utilities.
• Written several Teradata BTEQ scripts on an ongoing basis to implement the business logic.
• Worked on exporting data to flat files using Teradata F-EXPORT.
• Query optimization (explain plans, collect statistics, Primary and Secondary indexes)
• Build tables, views, UPI, NUPI, USI and NUSI.
• Worked with DBA’s for transition from Development to Testing and Testing to Production.
• Worked with the users/Customers and testing teams to implement the business logic as expected.
• Worked exclusively with the Teradata SQL Assistant to interface with the Teradata.
• Creation of Fastload and Mload scripts in loading data, according to the requirements
• Modified the Teradata SQl to meet the changing standards.
• Worked Extensively on BTEQ Scripts in Teradata SQL Assistant.
• Modifying the BTEQ Scripts according to the requirements given by Business team.
• Monitoring of jobs (Daily, Monthly, Weekly) and Re-run failed jobs.
• Done Unit Testing for the mappings developed according to the specifications.
• To get involved in issue logging/tracking, risk identifying/maintaining exercise with the Team/Tech lead as required.
• Involved in modification of Developed Unix Shell scripts in Automation of ETL Teradata processes.
• Involved in Production Support by performing Normal Loads, Bulk Loads, Initial Loads, Incremental Loads, Daily loads and Monthly loads on an ongoing basis.

Environment: Teradata V2R12, Oracle 10.1.0, SQL Server 2005, Unix, Informatica 8.6.1/9.x, DataStage 8.1

Confidential, Akron, OH

Teradata/ Datawarehouse ETL Consultant

Responsibilities:

• Involved and scheduled meetings with User, Business Analysts and Technical Analyst Towards attaining/ complete business requirements
• Extensively used ETL Procedures to load data from SAP database (NA, Europe), fixed width and delimited Flat files.
• Worked on loading of data from several flat files sources to Staging using Teradata MLOAD, FLOAD.
• Transferred data between heterogeneous sources using OLELOAD.
• Worked on loading data from EDW and Supporting Subject areas using Informatica.
• Worked on exporting data to flat files using Teradata FEXPORT.
• Query optimization (explain plans, collect statistics, Primary and Secondary indexes)
• Build tables, views, UPI, NUPI, USI and NUSI.
• Analyzing technical Design Specs and Do modifications on the Existed Coding
• Converting the Table data from DB2 region to Teradata regional area using Fastload and Multiload Utilities.
• In archiving we will just put our data from tables into tapes only.
• In monthly role we will put our data from table into tapes and deleting from the tables.
• Updating the Job Doc's and relavant documents(Helping the DBA teams)
• Worked with DBA’s for transition from Development to Testing and Testing to Production.
• Worked with the users and testing teams to implement the business logic as expected.
• Written several Teradata BTEQ scripts to implement the business logic.
• Worked exclusively with the Teradata SQL Assistant to interface with the Teradata.
• Getting data to end user groups using VBA macros and Implemented Pivot tables.
• Implemented VBA object model for data manipulation and data calculation
• Documented data conversion, integration, load and verification specifications.
• Extensively worked on ETL environments of Informatica.
• Involved in edition of Fastload, OLEload and Mload scripts in loading data, according to the requirements.
• Involved in writing BTEQ scripts in Teradata and running them by writing korn shell scripts in HP UNIX environment.
• Involved in Migrating the existing Data on to new version from Teradata V2R6.
• Performance tuning of the existing programs, ETL procedures, mappings and processes.
• Problem analysis and Issue resolution
• To get involved in issue logging/tracking, risk identifying/maintaining exercise with the team lead as required.

Environment: Teradata V2R6/V2R5, Informatica 8.5.1, HP-UNIX 8000/9000, TOAD 8.1.5, Oracle 10g, Teradata V2R5, ERWIN4.3, Autosys, Cognos 8.0, mainframe JCL, Visualstudio.

Confidential, WestPoint, PA

Teradata ETL Developer

Responsibilities:

• Collaborated closely with client managers, architects, DBA’s and business users.
• Developing the Adhoc queries using Teradata SQL Assistant.
• Created tables as required by the users for most frequently used data and written Scripts for those tables
• Involved in performance tuning of the Existing SQL queries and the reports.
• Supporting from the Central Office of the Mobility division.
• Helping in maintenance work related to reports.

Environment: Teradata V2R4, Informatica.7.x, Business Objects 5.1, Crystal Reports, WinNT4.0.

Confidential, Cincinnati OH

Teradata/Datawarehouse Developer

Responsibilities:

• Analyzed the existing Teradata applications for complexity and Enhancement.
• Participated in Joint Analysis Design with user community and Business users.
• Enhanced several existing Mainframe ETL JCL job streams for a large Teradata EDW to in corporate several new data elements.
• Updated numerous BTEQ/SQL scripts, making appropriate DDL changes and completed unit and system test.
• Developed new Control cards, JCL and PROC library members for data export, data loading and E-mail notification processes.
• Created tables, access views and update views in the development database for unit and system test.
• Developed FastExport, FastLoad and Multi Load scripts to simulate the environment in development database.
• Performed unit and system test for the modified code and loaded shadow data marts for testing prior to production implementation.
• Prepared low level design documentation for implementing new data elements to EDW.
• Re-formatted several thousands lines of code according to SBC coding standards.

Environment: Teradata V2R4, SQL, BTEQ/BTEQWin, FastLoad, MultiLoad, FastExport, Visual Explain, Teradata SQL assistant 6.1, JCL, Informatica, Mainframe JCL, Windows XP/2000.

Confidential, TX

Datawarehouse ETL Developer

Responsibilities:

• Worked on loading of data from several flat files sources using Teradata MLOAD & FLOAD.
• Transfer of large volumes of data using Teradata Fast Load, Multi Load, T-Pump
• Query optimization (explain plans, collect statistics, Primary and Secondary indexes)
• Involved in physical and logical design of the applications.
• Transferred data between development and production environment using ARCMAIN.
• Worked on exporting data to flat files using Teradata FEXPORT.
• Rewrote the existing financial applications.
• Optimized database queries and applications.
• Build tables, UPI, NUPI, USI, NUSI, macros and stored procedures.
• Written several Teradata BTEQ scripts to implement the business logic.
• Written COBOL and DB2 Programs.
• Worked exclusively with the Teradata Queryman to interface with the Teradata.

Environment: NCR Teradata V2R4, COBOL, DB2, JCL, Teradata SQL, Oracle.