Zack Guo

Zack is a Delivery Consultant in Deloitte Consulting A&C. He is experience in ETL architecture design, stored procedure development, report design and procedure performance tuning.

5+ years of custom ETL experience with SS&C's Algorithmics and Moody's RiskAuthority.

1+ year of SAP DWC ETL construction expericence in manufacturing and food industries.

1+ year of IFRS17 related data report development experience.

Delivery Consultant
Taipei, TW

0938967603
[email protected]

Skills

C++, Matlab, Python, PL SQL, PostgreSQL, MS SQL, ETL stored procedure, Shell Script, Crystal Reports, Datastage, Pentaho,Trinity, SAP Data Service, SSIS, SS&C's Algorithmics, Moody's RiskAuthority

Experience

Deloitte, Delivery Consultant, Nov 2021~

Omniwaresoft, Senior Data Engineer, Jun 2021~Oct 2021

Mirle, Data Software Engineer, Sep 2016 ~ May 2021

Responsibilities

Deloitte:

ETL process/architecture planning

Business rule verification

Stored procedure development and imported into Moody's RiskAuthority

Stored procedure performance tuning

SSIS ETL development

SAP Data Service ETL development

SAP Data Service ETL performance tuning

Trinity ETL development

Omniwaresoft:

Stored Procedure performance tuning

Adjust Stored Procedure according to customer's questions

Mirle:

ETL process/architecture planning
Stored procedure development and import into SS&C Algorithmics/Moody's RiskAuthority
Undertake the development of the underlying Stored Procedure of the SS&C Algorithmics/Moody's RiskAuthority calculation output development report
Crystal Report report development
Adapt Crystal Reports logic to customer's questions
Modify stored procedures based on questions raised by customers
Adapt IBM Datastage capabilities to customer issues

Education

National Hsinchu Univesity of Education，2014/09 - 2016/08

Master's degree, Institute of Applied Mathematics

National Hsinchu University of Education，2010/09 - 2014/06

National Hsinchu University of Education, Department of Applied Mathematics