SUMMARY

• Over 10+ years of experience in IT, with proficiency as Teradata/Informatica Developer/Analyst and strong expertise in Data Analyst, Mapping document, SQL queries, Teradata utilities and ETL logics.
• Analysed business requirements, transformed data, and mapped source data using the Teradata Financial Services Logical Data Model tool, from the source system to the Teradata Physical Data Model.
• Expertise in creating databases, users, tables, triggers, macros, views, stored procedures, functions, Packages, joins and hash indexes in Teradata database.
• Extensively worked with Teradata utilities like BTEQ, Fast Export, Fast Load, Multi Load to export and load data to/from different source systems including flat files.
• Hands on experience using query tools like TOAD, SQL Developer, PLSQL developer, Teradata SQL Assistant and Query man.
• Expertise in writing large/complex queries using SQL.
• Proficient in performance analysis, monitoring and SQL query tuning using EXPLAIN PLAN, Collect Statistics, Hints and SQL Trace both in Teradata as well as Oracle.
• Excellent experience in ETL Tools like Informatica and on implementing Slowly Changing Dimensions (SCD).
• Good knowledge in Unix Shell scripting.
• Excellent Experience with different indexes (PI, SI, JI, AJIs, PPI (MLPPI, SLPPI)) and Collect Statistics.
• In - depth hands on experience in database, ETL/ELT design and development and should have excellent data analysis skills
• Well versed with all stages of Software Development Life Cycle (SDLC) i.e. Requirement(s) gathering & analyzing, Design/redesign, Implementation and Testing.
• Good knowledge on Agile Methodology and the scrum process.
• Very good in Fast learning, Analytical thinking, decision making and problem solving skills.
• Proficient in preparing high/low level documents like design and functional specifications.
• Actively involved in Quality Processes and release management activities - To establish, monitor and streamline quality processes in the project.
• Very good in Analytical thinking, decision making and problem solving skills.
• Involved in review meetings with Project Managers, Developers and Business Associates for Project

TECHNICAL SKILLS

Operating Systems: UNIX, Windows NT/ 2000/ XP and Linux, Hadoop

Languages: COBOL, JCL, SQL, PL/SQL, Teradata Macros

Utilities: BTEQ, MLOAD, FASTLOAD, FAST EXPORT, Shell scripting

RDBMS: MS SQL Server, Teradata R14/15

Testing Tools: QTP, Quality Center

Tools: Teradata SQL Assistant, Informatica

Schedule: Autosys, CA7

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, NC

Sr. Teradata Developer

Responsibilities:

• Analyzed business requirements, transformed data, and mapped source data using the Teradata Financial Services Logical Data Model tool, from the source system to the Teradata Physical Data Model.
• Responsible for designing ETL strategy for both Initial and Incremental loads.
• Worked on collecting the data from pre-paid and post-paid source systems of sprint Services.
• Loaded data into Teradata using DataStage, FastLoad, BTEQ, Fast Export, MultiLoad, and Korn shell scripts.
• Troubleshoot and created automatic script/SQL generators
• Analyzing the specifications and identifying the source data that needs to be moved to data warehouse.
• Involved in extracting, cleansing and transforming of the data
• Responsible for writing PL/SQL procedures and functions to load the data marts
• Involved in tuning of SQL queries for better performance. Worked on database connections, SQL joins views and aggregate conditions.
• Data Quality Analysis to determine cleansing requirements.
• Involved in the performance tuning of Informatica mappings/sessions for large data files by increasing block size, data cache size, and commit interval.
• Created mappings with different transformations, mapping parameters and variables
• Worked with the QA team to research on the issues they raised.
• Responsible for documentation of projects
• Worked on preparing a table of summarization and aggregation of the fact data

Environment: Teradata R14/R15, Teradata SQL Assistant, Outlook, MLOAD, TPUMP, FAST LOAD, FAST EXPORT

Confidential, Concord, CA

Teradata ETL Developer

Responsibilities:

• Involved in Complete Software Development Lifecycle Experience (SDLC) from Business Analysis to Development, Testing, Deployment and Documentation.
• Used Teradata utilities fastload, multiload, tpump to load data
• Wrote BTEQ scripts to transform data
• Wrote Fastexport scripts to export data
• Wrote, tested and implemented Teradata Fastload, Multiload and Bteq scripts, DML and DDL.
• Constructed Korn shell driver routines (write, test and implement UNIX scripts)
• Wrote views based on user and/or reporting requirements.
• Wrote Teradata Macros and used various Teradata analytic functions.
• Involved in migration projects to migrate data from data warehouses on Oracle/DB2 and migrated those to Teradata.
• Performance tuned and optimized various complex SQL queries.
• Wrote many UNIX scripts.
• Good knowledge on Teradata Manager, TDWM, PMON, DBQL, SQL assistant and BTEQ.
• Gathered system design requirements, design and write system specifications.
• Excellent knowledge on ETL tools such as Informatica, SAP BODS to load data to Teradata by making various connections to load and extract data to and from Teradata efficiently.
• Agile team interaction.
• Worked on data warehouses with sizes from 30-50 Terabytes.
• Coordinated with the business analysts and developers to discuss issues in interpreting the requirements

Environment: Teradata, Teradata SQL Assistant, SQL, Outlook, Putty, MLOAD, TPUMP, FAST LOAD

Confidential

Teradata Developer

Responsibilities:

• Participated in meetings with Users, Business analysts in understanding the business requirements and analyzed use cases to develop detailed Test Plan
• Agile team interaction.
• Involved in Complete Software Development Lifecycle Experience (SDLC) from Business Analysis to Development, Testing, Deployment and Documentation.
• Used Teradata utilities fastload, multiload, tpump to load data
• Wrote BTEQ scripts to transform data
• Wrote Fastexport scripts to export data
• Wrote, tested and implemented Teradata Fastload, Multiload and Bteq scripts, DML and DDL.
• Constructed Korn shell driver routines (write, test and implement UNIX scripts)
• Wrote views based on user and/or reporting requirements.
• Wrote Teradata Macros and used various Teradata analytic functions.
• Involved in migration projects to migrate data from data warehouses on Oracle/DB2 and migrated those to Teradata.
• Performance tuned and optimized various complex SQL queries.
• Wrote many UNIX scripts.
• Good knowledge on Teradata Manager, TDWM, PMON, DBQL, SQL assistant and BTEQ.
• Gathered system design requirements, design and write system specifications.
• Excellent knowledge on ETL tools such as Informatica, SAP BODS to load data to Teradata by making various connections to load and extract data to and from Teradata efficiently.
• Agile team interaction.
• Worked on data warehouses with sizes from 30-50 Terabytes.
• Coordinated with the business analysts and developers to discuss issues in interpreting the requirements
• Extensively used SQL Analyzer and wrote complex SQL Queries using joins, sub queries and correlated sub queries

Environment: Teradata, Teradata SQL Assistant, SQL, Outlook, Putty, MLOAD, TPUMP, FAST LOAD

Confidential

SQL Developer

Responsibilities:

• Analyzed Business Requirements Documentand Functional Specification document to develop detailed Test Plan and Test Cases.
• Involved in Complete Software Development Lifecycle Experience (SDLC) from Business Analysis to Development, Testing, Deployment and Documentation.
• Used Teradata utilities fastload, multiload, tpump to load data
• Wrote BTEQ scripts to transform data
• Wrote Fastexport scripts to export data.
• Worked on Oracle PL SQL to create stored procedures, packages and various functions.
• Wrote, tested and implemented Teradata Fastload, Multiload and Bteq scripts, DML and DDL.
• Constructed Korn shell driver routines (write, test and implement UNIX scripts)
• Wrote views based on user and/or reporting requirements.
• Wrote Teradata Macros and used various Teradata analytic functions.
• Involved in migration projects to migrate data from data warehouses on Oracle/DB2 and migrated those to Teradata.
• Performance tuned and optimized various complex SQL queries.
• Wrote many UNIX scripts.
• Good knowledge on Teradata Manager, TDWM, PMON, DBQL, SQL assistant and BTEQ.
• Gathered system design requirements, design and write system specifications.
• Excellent knowledge on ETL tools such as Informatica, SAP BODS to load data to Teradata by making various connections to load and extract data to and from Teradata efficiently.
• Agile team interaction.

Environment: Teradata, Teradata SQL Assistant, SQL, Outlook, Putty, MLOAD, TPUMP, FAST LOAD

Confidential

Mainframe / Teradata Developer

Responsibilities:

• Coordinate with the front end team working on Oracle Forms to provide with the necessary stored procedures and packages and the necessary insight into the data.
• Extensively involved in creating PL/SQL objects i.e. Procedures, Functions, and Packages.
• Involved in performance tuning the existing objects.
• Extracting thousands of data from the database for data analysis.
• Extracting and moving data from Mainframe.
• Helped the QA team in QC’ing the data and to develop test scripts for the validation of the process. Also performed unit testing and system testing.
• Monitoring and scheduling jobs.
• Documentation of all modules for user level and system level maintenance.
• Leading the junior developers in doing their tasks.
• Worked in a CMMI level 3 coding standards.

Environment: Mainframe Z/OS, UNIX, SQL, PL/SQL, SQL Developer