SUMMARY

• More than ten years of expereince analyzing business needs of clients, developing effective and efficient solutions and ensuring client deliverables within committed deadlines
• Eight years of expereince in large Teradata database systems - in development, staging and production for various warehouse systems utilizing Teradata 13/12/V2R5, Data Load/Unload utilities like BTEQ, FastLoad, MultiLoad, Tpump, FastExport and Teradata administrative utilities like Archive/Restore, OLAP, OLTP, ETL using Informatica Power Center.
• Proficient in Teradata V12/V13 database design (conceptual and physical), Query optimization, Performance Tuning, Query remediations, fixing long running SQLs in Production, Workload settings through TWM and system performance analysis using DBA Tools like PMON and Viewpoint.
• Extensive knowledge of Teradata utilities, Teradata Viewpoint tool for production platforms monitoring, awareness of TASM workload settings.
• Strong hands on experience using Teradata utilities/Teradata SQL (FastExport, MultiLoad (MLOAD), FASTLOAD, TPUMP, BTEQ and Teradata SQL Assistant).
• Extensive experience with managing and leading various complex data warehousing applications and installations, integrations, upgrades, maintenances of ETL.
• Over seven years of banking and financial services industry experience developing strategies for ETL (Extraction, Transformation and Loading) mechanism in complex, high volume data Warehousing projects).
• Experience in integration of various data sources.
• Involved in test data set up and data quality testing and unit testing and Integration Testing using HP Quality Center Test Management tool.
• Experience in supporting large databases, troubleshooting problems, and supporting jobs running in production for failure resolution with tracking failure reasons. Provided best resolution in timely manner in L3 support role (as part of maintenance activities)
• Handled help desk tickets from bank users and used their feedback in meeting business requirements through detailed analysis.
• Comprehensive experience with Stored Procedures and Macros.
• Experience in all phases of SDLC like system analysis, application design, development, testing and implementation of data warehouse projects.

TECHNICAL SKILLS

Teradata Tools: Teradata Load and Unload Utilities - BTEQ, TPUMP, Fast Load, Multiload, FastExport, TPT, Teradata SQL Assistant, Teradata Datamover, Teradata Viewpoint for Monitoring Loads on Teradata

ETL and Scheduling Tools: Informatica Power Center 9.1, Autosys, CA7, NDM/FTP, Changeman, IBM File Manager, HP Quality Center Test Management Tool

Languages: UNIX Shell Scripting, Mainframe JCL, COBOL and REXX

Data Modelling /Methodologies: ETL, OLAP, Complete Software Development Cycle (DMAIC Phases), Erwin 4x Data Modeler

Operating Systems: IBM Mainframe Z/OS, Windows, UNIX

PROFESSIONAL EXPERIENCE

Sr ETL Teradata SQL Developer

Confidential, Jacksonville, FL

Responsibilities:

• Involved in all phases of SDLC from requirements, design, development, testing, training and rollout to the field user and support for the production environment.
• Wrote Teradata SQL, BTEQ, MLoad, OLELoad, FastLoad, and FastExport scripts in Unix and build Unix shell script to perform ETL interfaces BTEQ, FastLoad or FastExport for various business users implementations in production.
• Created ER diagrams using Erwin tool and share analysis with Architects and DBA for data model and its implementations
• Performed data analysis activities (data quality and integration analysis,business validation).
• Analyzed, designed and documented requirements for the data migration projects between numerous source Legacy/Oracle application feeds and the new Teradata platform.
• Performance tuning of the large running SQLs of various applications using DBQL tables and DB related log tables before implementing the code in Prod. In addition to L3 support (DEV) role - supporting jobs running in production for failure resolutions with tracking failure reasons and provided the best resolutions in timely manner.
• Analyzed the root causes for failed batch jobs and their permanent fixes.
• Provided L3 support for the Teradata ETL jobs for daily, monthly and weekly schedules for the banks various applications.
• Interacted with different teams for locating failure of jobs running in production systems and provided solutions, restarting the jobs and made sure the jobs were completed in the specified window time.
• Participated in reducing workload efforts on production platforms, warehouse support and maintenance activities.
• Comprehensive experience on Teradata restore activity from tapes utilizing Teradata ARCMAIN utility and Macros.
• Participated in various activities using Teradata Datamover (DM) Tool. Reviewed the requirements from users to move data from one platform to other platforms, datamover job schedules through CA autosys scheduler, fixed the blocking issues due to data mover jobs, avoiding regular errors with the DM jobs, archived monitoring, system utilization saving efforts like rescheduling archives to batch window.
• Extensively worked under the UNIX environment using shell scripts as part of data movement support activities.
• Provided support to meet the SLAs of various applications and downstream user requirements.
• Handled help desk tickets from the bank’s users and their interactions in meeting business requirements through a detailed analysis.
• Interacted with the bank’s Teradata Engineers, DBAs and global support centres for problem analysis and troubleshooting for multiple production platforms (uutage handling policies and procedures).
• Participated in SLA negotiations for different applications and interaction with downstream partners to meet the business requirements.
• Analyzed the data distribution and reviewed the index choices for objects in different applications.Tuned the Teradata SQL statements using explain, analyzedthe data distribution among AMPs and index usage, collected statistics and definition of indexes.
• Excellent experience using system logs like resource usage logs, DBQL logs, etc (resusage, acclogtbl, DBQL tables, event log, usage of DBC tables for different support activities.
• Exclusive usage of Teradata viewpoint toos for monitoring the bank’s production platforms.

Environment: Informatica Power Center 9.1, Teradata SQL, Teradata Load & Unload Utilities (BTEQ, MLOAD, TPUMP, FASTEXP etc), Teradata Viewpoint, Teradata Datamover Tool, Unix Shell scripting, Autosys Scheduling Tool, Mainframes (JCL, CA7 Scheduling Tool and all IBM Utilities in Z/OS Mainframes).

Teradata ETL Developer

Confidential

Responsibilities:

• Involved in understanding the requirements of the end users/business analysts and developed strategies for the ETL processes.
• Provided maintainance and enhancement for the bank’s EDW applications in the Teradata environment.
• Used BTEQ and SQL assistant (query man) front-end tools to issue SQL commands matching the business requirements to Teradata RDBMS.
• Mapped the data from various sources to staging to the target Teradata database and the ETL processes for complete project lifecycle and involved in analysis, high level design and low level design documentation.
• Involved in the test data set up and data quality testing, unit testing and integration testing using the HP quality center test management tool.
• Documentation of SIT/UAT testing scripts, specifications and other processes associated in the integrated testing environment.
• Used SQL to query the databases and do as much crunching as possible in Teradata, using very complicated SQL.
• Developed (BTEQ, MLOAD, FASTLOAD, TPUMP and FASTEXPORT) scripts for loading and unloading purposes.
• Involved in directing to migrating the data from different data barns to Teradata and in mapping the data from source to staging to target the data bases.
• Involved In the physical design and creation of the technical design document.
• Involved in the code reviews and fixed problems during the code review.
• Responsible for creating the databases, profiles, Roles, Tables, Views, Indexes (primary, secondary, partitioned etc.), Triggers, and Macros in different phases and different segments of the project and responsible for database space for present and future considerations and assigned and revoked the space on the analysis basis.
• Migrated data with the help of Teradata FastExport, Insert/ Select and flat files from one system to another (from production environment to lower environment) and interacted with the users on various data quality checks and validations.
• Usage of the ETL tools for raw data staging environments, especially created for the BOA’s data warehouse. ‘The W’ to generate the create and insert scripts for a particular system.
• Query analysis using explain for unnecessary product joins, confidence factors, join type and order in which the tables are joined.
• Excellent understanding of the database Skew, PPI, Join Methods, Join Strategies, Join Indexes including Sparse, Aggregate and Hsh.
• Used extensively derived tables, volatile tables and GTT tables in many of the ETL scripts.

Environment: Teradata SQL, Teradata Load & Unload Utilities (BTEQ, MLOAD, TPUMP, FASTEXP etc), HP Quality Center for Testing Activities, Mainframes (JCL, CA7 Scheduling Tool and all IBM Utilities in Z/OS Mainframes).