Jayden LIU
Senior Developer at Agility CIS- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
Topline Score
Bio
Credentials
-
Microsoft Certified: Data Analyst Associate
MicrosoftMar, 2021- Nov, 2024
Experience
-
AgilityCIS
-
New Zealand
-
Information Technology & Services
-
1 - 100 Employee
-
Senior Developer
-
Aug 2021 - Present
-
-
-
Heart Foundation NZ
-
New Zealand
-
Wellness and Fitness Services
-
1 - 100 Employee
-
Data Analyst
-
Jul 2021 - Aug 2021
-
-
-
-
Business Intelligence Analyst | Data Analyst | SQL Developer
-
Sep 2019 - Mar 2021
• 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.
-
-
-
-
IT Consultant
-
Sep 2018 - Apr 2019
-
-
-
-
Business Intelligence Analyst | Data Analyst | Database Developer
-
Mar 2010 - Jan 2018
[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
-
-
-
ChinaEdu Corp.
-
E-learning
-
1 - 100 Employee
-
Data Analyst | Business Analyst | Database Developer
-
Sep 2001 - Feb 2010
-
-
Education
-
Auckland Institute of Studies (AIS)
Postgraduate Diploma, Information Technology -
Tianjin University
Bachelor of Engineering - BE, Computer Engineering