add photo
joseph
joeqzhou456@outlook.com
678-643-3939
Alpharetta, GA 30022
25 years experience W2
0
Recommendations
Average rating
122
Profile views
Summary

  • Extensive knowledge in overall SDLC including requirement gathering, development, testing, debugging, deployment, documentation and production support.
  • In-depth hands-on experience in various IT development projects (Waterfall and Agile) related to Business Analysis, System/Data Analysis, Design and Development for Data Warehousing, Business Intelligence, ETL, PIM/MDM and other applications.
  • Extensive and in-depth experience in using complex SQL queries, database procedures, utilities and analytical tools in various databases such as Teradata, DB2, DB2 LUW, SQL server, Oracle and Informix, etc. Proficient working knowledge of views, Synonyms, Indexes, Joins, Partitioning, etc.
  • Extensive experience in solution-driven Business Analysis including requirement gathering and analysis, enterprise implementation, data mining and analysis, user acceptance testing and project management.
  • Extensive experience in all phases of Quality Assurance Testing: Functional Testing, Integration Testing, Regression Testing, Performance, Acceptance Testing.
  • Proficient knowledge and hands-on experience with analytical reporting using various BI tools such as Tableau and others.
  • Excellent knowledge on design and development of Data Mart /Data Warehousing and Business Intelligence applications using AB Initio, Teradata, DB2, SQL Server, Oracle PL/SQL, Unix KSH Shell scripts and other BI/Data Analytical tools such as MicroStrategy.
  • Strong experience in Data Quality, Source Systems Analysis, Business Rules Validation, Source Target Mapping Design, Performance Tuning and Large Volume Data Loads.
  • Involved in creating and enhancing Technical and Operational Policies and Procedures, adopting best practice guidelines, standards and procedures.
  • Extensive experience with Ab Initio tools like GDE, EME, Pipeline Parallelism and Partition Parallelism, Data Profiler, Continuous Flows and Web Services. Extensive experience in SQL Performance Tuning and Optimization of various applications.
  • Strong knowledge in Teradata and its utilities (BTEQ, FASTLOAD, FASTEXPORT, MULTILOAD, TPump, SQL Assistant). PROFESSIONAL EXPERIENCE HIGHLIGHTS 10/2018
  • present: Principal Consultant, Connec International Provide consulting services for IT development, business/data analysis, data analytics and technical support in various business areas using profound expertise and deep tech background to come up with better, simpler and more effective solutions.

Experience
Education
Master's in Computer Information Systems
University of Memphis
Skills
SQL
2007
4
System Analysis
2007
4
DB2
2012
3
ETL
2012
3
Ab Initio
2005
2
Data Analysis
2007
2
Data Conversion
2005
2
Shell Scripts
2005
2
XML
2005
2
Data Replication
2012
1
Data Warehousing
2012
1
Shipping
2012
1
Teradata
2012
1
Warehouse
2012
1