Jayden Liu Email & Phone Number

New Zealand

Auckland, New Zealand

Auckland, New Zealand

Auckland, New Zealand

• Relationship management and contract management.• Plan making and optimization of business processes.• Interpreted business requirements and turned large and complex datasets into insightful information.• Designed, developed and implemented innovative data integration solutions across the organization.• Developed detailed ETL routines, documentation, scripts and specifications according to user requirements.• Performed ETL and SQL tuning to ensure optimum data warehouse performance.• Resolved data ambiguities and anomalies by performing data analysis.• Developed models, specifications and procedures for data warehouse usage in collaboration with user’s goals.• Engaged deeply in data investigation in both cloud and on-premises databases.• Designed and implemented dashboard and reports, supporting dozens of report users.• Tech: Power Designer, DbSchema, SQL Server, Oracle, ETL, SSIS.

Auckland, New Zealand

Beijing, China

[Responsibilities]• Communicated with internal and external stakeholders in BI projects.• Contract management, project planning and workload prioritizing.• Facilitate and co-ordinate activities between different vendors and business units to ensure that all requirements are available on time• Engaged closely with clients from various large-scale enterprises from financial sector, media and retail industries, within 10-20-member tech teams, analyzing business requirements.• Connected multiple data sources. Extracted, cleansed, manipulated data and created data models.• Performed in-depth data validation on data from various suppliers.• Merged data with existing datasets, researched data and provided solutions for data discrepancies.• Analyzed, designed statistics and visualizations after reaching an inter-team agreement, and developing ad-hoc reports. The number of report varied from up to 10 to more than 100, based on different clients.• Adapted quickly to new business environments.• Provided tutorials and technology designing documents.• Tech: SQL Server, ETL, SSIS, SSAS, SSRS, Oracle, PL/SQL, Informatica, Power Designer, ERWin, Teradata, Perl

Beijing City, China

Postgraduate Diploma, Information Technology, A

Bachelor Of Engineering - Be, Computer Engineering