Hi There! I’m Linda Li
Data Engineer on Teradata ETL and DBA for multi-platforms( Mainframe, Oracle,SQL Server,DataStage, Linux )
Welcome and thanks for visiting my site! I invite you to take a moment and look around. To learn more about my background, experience, skills and how we could potentially work together, simply contact me.
Bio
Data Engineer
I am Teradata 12 certified professional as Teradata DBA/Teradata ETL Professional Service Consultant/Mainframe developer/DataStage developer at large financial institute, retailer, manufacture and telecommunications Teradata customers since 2006.
I have gained 8+ yrs experience in a variety of technologies including Mainframe, Teradata Performance tuning/SQL, Oracle PL/SQL, Sybase, DataStage, Linux, and Hadoop. I understand and adheres to Enterprise Data warehouse(EDW) SDLC standards and best practices.
My Experience
Background & Expertise
Teradata DBA
Canada Bread via Teradata DBA Management Serverics ( US )
May 2017 - Mar 2018
Working with big data team to migration Oracle PL/SQL and Teradata SQL to AWS/Impala
Closely with the Financial manager to investigation Oracle EBS Financials - (General Ledger, Payables, Receivables, Purchase invoices…) data quality issue in Teradata and Big data
Enhancement Teradata stored procedures to auto validation and fixed code bugs on production
Developed Linux scripts and DDL/DML to load 15 million financial data with Teradata Utilities
Documented Financial Drilldown/TMA technical specification and production code enhancement release doc.
Physical database implementations, PPI, skew analysis, join methods, and data access paths and capacity calculation
Creation and maintenance of various database objects like tables, views for BI users
Hadoop Developer
Skyhigh Network System, Toronto, Canada
Oct 2014 - Feb 2017
Training, & Technical Consulting
• Developed training slides on Data Warehouse ETL application on Mainframe and DataStage
• Knowledge on JAVA, HDFS, Map Reduce, HBase, Hive, Pig, Oozie, Sqoop, AWS
• Knowledge on Jupyter, TensorFlow and Sagemaker
• Knowledge on Teradata Viewpoint, Teradata Expaling Tools, Aster data analytic platform.
Teradata Consultant
Royal Bank of Canada via Teradata ( Canada )
November 2013 - October 2014
Working for production incident management team on investigate bank critical ETL process with Mainframe JCL, DataStage, and Teradata platforms.
Re-engineering production failed 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 enhancement solution on mainframe DataStage and Linux
JCL and DataStage code enhancement, IST and deployed to product according to bank standard change management
Teradata ETL Professional Service Consultant
Teradata ( Canada )
April 2008 - Oct 2012
Designed and developed migration various external database and data sources to Teradata platform for financial retail and telecommunication companies in Canada and US
Created ETL design document and production support instruction
Impact analyzed and created ETL new job schedule with DBQL/zeke
Pioneer project that Teradata new product( Data Mover) application on Created JCL for table full/partial copy with
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 calling Teradata utilities to load data to Teradata on Linux
Developed DDL( tables, views) and DML for Oracle PL/SQL convertion 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
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 .
ETL Consultant
Royal Bank of Canada
Sept 2007 - Jan 2008
Created JCL to call UCMD and Teradata utility for ETL from mainframe to Teradata
Debugged and fixed DataStage jobs with DataStage designer
Backfill FUF(Financial Unit File) on mainframe/Datastage/Teradata
Created production implementation instructions
ETL Production Support
CGI, Halifax, NS, Canada
Dec 2006 - Apr 2007
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 and fixed all kinds of data quality issues for Bell Canada billing system thought Remedy
Demand Chain Management(TDCM) System migration from Oracle to Teradata @Retailer
LoyaltyOne Promotions Effectiveness @Retailer
Carleton Passport (COBOL) migration by Datastage @Bank
Data Mover Implementation@ Bank
Production Support for Oracle PL/SQL to Teradata SQL migration @Retail@Telecom
What I’ve Done
Bank Critical Job Failed Cases Reproduced Investigation and Fixing
File Characters Scrubbing on Mainframe and DataStage Server
Mapping Carleton Passport(Old Cobol) Replaced by DataStage on Linux
Developed JCL code on Teradata new product ( Data Mover ) implemented on mainframe
Developed Linux scripts to call Teradata Utility for ETL
Test Lead on RBC EDW Mainframe jobs coded for Disaster Recovery and Dual Load
Key member on Inter-bank payment and settlement system SDLC on ES/9000
For more examples of my work, don’t hesitate to reach out.
Education and Training
Hadoop, AWS, Teradata, ASIC/VLSI design, , Mainframe ES/9000, AIX/6000,Electronic Engineering
My education has not only provided the foundation for the rest of my experiences but has also made me a lifelong learner who is eager to gain more skills and knowledge. Take a look at my academics below.
Carleton University
September 2001 - Apr 2003
University of Electronic Science and Technology of China
1986 -1989
University of Electronic Science and Technology of China
1980 -1984
Teradata 12,13,14 ( ETL Utilities, Performance Tuning)
Mainframe Developer ( ISPF, JCL, Endevo,File-Aid )
DataStage 7.5,8.1,8.5 Programmer
Linux Shell Scripts
Oracle EBS R12
AWS
What I Do
No matter the role or project, I’m confident in the skill set I bring to the table. Take a look below to learn more about my specific abilities, and feel free to get in touch if you’d like to learn more.
Mandarine Fluency
"Do not go where the path may lead. Instead, go where there is no path and leave a trail"