Ryan Zhang Email & Phone Number

Auckland, Nz

Auckland, New Zealand

Programming & Query Language: Python, PLSQL, T-SQL, SnowSQL, JinjaStorage & Database: Azure Blob Storage, Snowflake, Azure Synapse, SQL Server, OracleTransformation & Processing: Azure Data Factory, Azure Databricks, dbt, WhereScape RedOrchestration & Version Control: Azure Pipelines, Git, AirflowData Modelling: Kimball, 3NF, Star/Snowflake schema, Data VaultAs a Data Engineer at Data Engineering Platform team, my responsibilities include:• Build, deploy, test several data pipelines using Azure technologies (Logic Apps, Azure Data Factory, Azure Databricks, Azure Blob Storage) for variety of flat files, which are used for data loading activities to Azure Synapse.• Design, develop and deploy new data models, schemas, and structures to support business requirements in Snowflake using Fivetran, dbt Cloud, Power BI to decomisson existing datawarehouses. • Maintain and enhance several data pipelines using WhereScape Red to ensure data delivered on time to support downstream team`s analytics requests.• Build and Deploy CI/CD pipelines for Snowflake and dbt Cloud using SchemaChange, Azure Pipeline, Azure Repo and Git to implement DataOps.

Auckland, New Zealand

As a BI Developer at NZX - Smartshares, the focus revolves around advancing data infrastructure and analytics capabilities. This role involves designing, building, and maintaining robust data pipelines, data models, and dashboards to empower data-driven decision-making throughout the organization.Key Highlights:- Data Engineering & Operations:Collaborating effectively with a diverse range of stakeholders, including marketing specialists, BI analysts, and customer service specialists, to deeply understand the data engineering needs across the business. Successfully designing, developing, implementing, and maintaining high-quality data pipelines through modern technologies such as Python, SQL, and AWS services (S3, Lambda, Glue, Redshift), adhering to industry best practices.- Data Modeling:Expertise in creating and maintaining intricate data sets and data models that seamlessly align with our business requirements. Transforming complex business needs, particularly in the realm of Financial Services Projects, into high-quality SQL code and data structures that support reporting and data analytics.- Data Reporting:Specialization in developing and maintaining dynamic data dashboards using Power BI, ensuring that they consistently align with evolving business requirements. Designs accurately reflect key performance indicators, providing actionable data-driven solutions for stakeholders.- Infrastructure Enhancement:Collaborating closely with the IT team, business analysts, and consultants to actively identify opportunities for internal process improvements within data engineering and analytics functions. Initiatives include implementing Automation Servers, CI/CD Pipelines, and DataOps procedures, all aimed at enhancing data engineering and analytics architectures and infrastructures.Skills: Python | SQL | Git | Power BI | Excel | AWS Lambda | AWS CloudWatch | Ubuntu | Time-series Analysis | A/B Testing

Christchurch, Canterbury, New Zealand

As the Data Analyst, joined New Zealand's largest telecommunication company, taking responsibility for ad-hoc data development, trusted data development, ML models deployment, and data migration. Key Highlights- Data Engineering & Operations:Expertise in applying Snowpark Python, SQL, and Cronjob to develop and maintain ETL pipelines in Linux environment to migrate large-scale of data from EDW to Snowflake. Also, having hands-on experience to implement CI/CD pipelines to automate the process of deployment in Azure DevOps. - ML Development & MonitoringInvolved in the full lifecycle of scorecards` development in terms of credit risk and fraud. Helped engineers to prepare data sets, features selection and model training. Also, built Power BI dashboards to monitor key evaluation metricsSkills: Python | SAS | SQL | Git | Power BI | Excel | MS Azure DevOps | Snowflake | Azure ML Studio | Decision Tree Models | LSTM Model

Shenzhen, Guangdong, China

Took the responsibilities of 8 Gaming Player Community Apps, I managed a team consisting of 6 engineers,1 data scientist, and 2 UI&UX designers to develop and maintain Apps for global users Highlights: - Maintained and developed 8 gaming player community communication platforms globally that enable users to discover UGC & PGC through the main feeds, internal forums, communities etc.; defined roadmaps & owned end-to-end execution- Increased user active numbers by 1.2M/Month, PGC&UGC impressions by 42M/Month & favourites by 400K/day on iOS, Android & Wechat Mini Programs in total- Drove a team of 16 engineers, 2 designers, 1 data scientist & a user researcher to launch 30+ product features to global users- Defined PGC&UGC ranking strategies for candidate generation, and content selection by closely collaborating with 2 data scientists and 3 frontend/backend engineers to strategically invest in improving PGC&UGC recommendation relevance & quality- Defined roadmaps, specs, 2 A/B tests, and metrics by collaborating with stakeholders from UX, analytics, marketing, and infra teamsSkills: Axure RP | Figma | MS Visio | TAPD | Business Analytics Techniques | Agile Methodology | Project Management Techniques | UX/UI Design | APIs | Product Requirement Document | Python | Hive SQL | Tencent Beacon DataTalk | Bugly | Recommendation Algorithms

Chengdu, Sichuan, China

- Developed and managed end-to-end analytics solutions, including requirements gathering, key metrics establishment, data pipeline building, dashboard creation, and data analysis to enhance operations performance.- Utilized advanced quantitative skills to analyze vast amounts of data and generate impactful insights that influenced the strategy for the PSO team.- Established strong relationships and collaborated with cross-functional partners to support and execute product goals, and shared insights and learnings to create scalable solutions.- Led complex cross-functional data and metrics projects and programs in a matrix organization, covering a range of areas.- Influenced product roadmap, identified long-term trends, and discovered new levers to drive key metrics.Key Skills & Tools:SQL, data visualization (Tableau), object-oriented programming (Python), statistical software (R)Project management, data analysis, problem solving, cross-functional collaborationHypothesis testing, regressions, statistics, scripting language (Python), distributed computing (Hive/Hadoop)