SUMMARY:

• Over 10+ years of experience in Teradata, with proficiency as Teradata ETL developer on multi - platforms for top Enterprise Data Warehouses(RBC, Bell, Loblaw s, LCBO, McCain, Amazon, Unilever, Confidential ) Highly seasoned and experienced ETL Developer with exceptional skills in Teradata and DataStage application on mainframe platforms
• Adept at troubleshooting and ensuring quality control at every stage of management process.
• Extensively worked with Teradata utilities like BTEQ, Fast Export, Fast Load, Multi Load to export and load data to/from different source systems(Mainframe, Oracle, Linux)
• Excellent experience in ETL Tools like Datastage 8.5, 8.1, 7.5 on 1st and 2nd line ETL production Support for BELL and RBC
• Well versed with all stages of Software Development Life Cycle (SDLC) i.e. Impact analyze, Requirement(s) gathering & analyzing, Design/redesign, Implementation and Testing.
• Very good in Analytical thinking, decision making and problem solving skills.

PROFESSIONAL EXPERIENCE:

Teradata DBA

Confidential

Responsibilities:

• Redesigned convension Oracle E-business suite R12 financial reports PL/SQL AP GL CM to Teradata drilldown reports for General accounting.
• Enhacement Teradata stored procedures to auto validation and investigation ETL data quality and performance issue on Teradata production system
• Created Test plan and test cases against data Quality issue on ERP migration to Teradata project
• Documentation ETL Backfill business requirement and updated production manual
• Validation test result after code changes using Pandas with Python

Confidential ETL developer

Confidential

Responsibilities:

• Training, & Technical Consulting on AWS solution architect associate, Red shift, Kinesis JAVA, HDFS, Map Reduce, HBase, Aster big data platforms, Python

Confidential Teradata ETL Production Support

Confidential

Responsibilities:

• Working for production incident manage team on investigate on bank critical data ETL process with Mainframe, JCL, DataStage and Teradata platforms.
• Re-engineering production system application and ETL process base on jobs log and source data and related incident info.
• Analyzing JCL code and ETL process flow and Teradata SQL from operation manual(OM) and existing environment ( mainframe DataStage Teradata ) to find root cause
• Test lead and creating test scenarios, setup and modify JCL and DataStage for running against the test environment
• Finding root cause, providing tests analyze report and providing enhancement solution on mainframe and DataStage.
• JCL and DataStage production code change, IST and deploy to product according to bank standard change management

Environment: Teradata SQL Assistant, SQL, JCL, ISPF, Endeavor, File-aid, HP SM9, Putty, Teradata utilizes (MLOAD, TPUMP, FAST LOAD, FAST EXPORT), IBM DataStage, Linux, XML

Confidential

Teradata ETL Developer

Responsibilities:

• Designed and developed migration various external database data to the Teradata platform for financial retail and telecommunication companies in Canada and US
• Created ETL design document and production support instruction
• ETL impact analyzed and created ETL new job schedule with DBQL/zeke
• Created JCL for table full/partial copy with Teradata new product Data Mover
• Created mapping doc from SAP to Teradata
• Created mapping doc for replacing legacy processes from Carleton Passport(old COBOL) to DataStage
• Gathered metadata from mainframe and imported to Linux DataStage server
• Developed shell scripts that call Teradata utilities to load data to Teradata on Linux
• Developed DDL( tables, views) and DML with Teradata Administrator for Oracle PL/SQL convert to Teradata SQL
• Leading test from creating test plan, test data, debugging test issue to test report
• Troubleshooting ETL production system on Oracle PL/SQL and Teradata SQL Unix
• Debugged and fixed Teradata macros, stored procedures, ResUsage, Index type with Teradata Explain
• Teradata performance tuning and coordination with offshore team for code enhancement
• Converted test queries and views form SQL server to Teradata for POC
• Enhancement and test DataStage ETL jobs .

Environment: Teradata Design strategies, Teradata SQL Assistant, Teradata Grid, Teradata Data Mover, SQL, JCL, ISPF, Endeavor, Zeke, Putty, MLOAD, TPUMP, FAST LOAD, FAST EXPORT, DataStage, Linux, Oracle PL/SQL, SAP, SQL Server

Confidential

Teradata ETL Developer

Responsibilities:

• Created JCL to call UCMD and Teradata utility for ETL from mainframe to Teradata
• Debugged and fixed DataStage server and parallel jobs with DataStage designer
• Programming for Backfill FUF(Financial Unit File)
• Created production implementation’s instruction for operator

Environment: Teradata SQL Assistant, SQL, JCL, ISPF, Endeavor, MLOAD, TPUMP, FAST LOAD, FAST EXPORT, DataStage, Linux. Unix Shell Script

Confidential

Teradata ETL Production Support

Responsibilities:

• Perform day-to-day monitoring of Bell enterprise data warehouse 6000+ DataStage ETL jobs on production processing using Tivoli and DataStage director
• Diagnosed, Compiled, Rerun, extracted source files, analyzed abend job and stream with DataStage designer and UNIX shell script.
• Fixing duplicated rows, missing data on Teradata SQL
• Diagnosed and isolated data issue from JCL job, output, restored history data set and log with ISPF
• Investigated all kinds of data quality issues for Bell Canada on billing system thought Remedy

Environment: Teradata SQL Assistant, SQL, Putty, MLOAD, TPUMP, FAST LOAD, FAST EXPORT, Remedy, Tivoli, Unix Shell Script, mainframe, Cobol