Edison Zhu
验证专家 in Engineering
Azure BI开发人员
Edison是Azure BI开发人员, 数据工程师, and data architect with 18 years of BI and 数据工程师ing experience across industries. 由MCSE Azure云平台认证支持, 他使用Azure数据工厂(ADF)提供高质量的BI解决方案。, Python, Azure的功能, Azure SQL数据库, Azure突触, Power BI, Databricks, 分析服务, 和SQL Server. Edison also excels at 维度建模, performance turning large 数据仓库s, and .. NET和Angular开发.
Portfolio
Experience
Availability
首选的环境
Azure PaaS, SQL Server BI, Windows 10, Visual Studio, Python 3, Microsoft Power BI, Azure数据工厂, Azure的功能, Tableau Desktop Pro, 谷歌BigQuery
最神奇的...
...enterprise projects I've delivered end-to-end helped businesses make data-driven decisions and make business operations more efficient.
工作经验
高级Azure BI,数据工程师,Power BI, Tableau, BigQuery, Python开发人员
Woolworths
- 设计并开发在线销售仪表盘, 店面操作仪表盘, 点对点交付仪表板, 以及使用Microsoft Power BI的产品可用性仪表板, Azure突触, Azure分析服务, and DAX.
- Delivered the Data Factory ETL pipelines to dynamically copy data into Azure Blob Storage and load the dimension and fact tables.
- 数据仓库的设计与开发, 分析服务立方体, ETL process, 维度建模.
- Migrated the seven existing fulfillment web reports of Woolworths' online sales to SSRS reports using Azure突触 and SSRS.
- 创建Azure函数,用Python处理XML消息, Azure服务总线, Cosmos DB, 和Azure存储队列.
- Developed point-to-point delivery and Online KPI Tableau dashboards using GCP BigQuery and Tableau.
- Built a data ingestion pipeline with Python to integrate Google Sheet's data into GCP BigQuery and Storage Buckets.
- 创建了Azure功能来自动创建IotHub和流分析.
- 更改了功率查询,将特性添加到Power BI报表中.
数据库和全栈开发人员
航空工业公司. Ltd
- Reverse-engineered the existing Microsoft Access, including the tables, queries, and forms. 将所有表从Microsoft Access迁移到Azure SQL数据库.
- 使用Angular 16开发web应用的前端.
- 使用c#构建REST API; .. NET Core和Azure SQL数据库.
Azure数据工程师
敏锐的商业洞察力
- 交付一个零售快消品行业数据集成项目.
- 建立一个ADF管道, Azure函数, 和c# Web API来集成数据,包括发票, sales, customer, product, 和支付——来自SAP IDoc XML, SFTP, 和API到Azure SQL数据库.
- Developed a Blob-triggered Azure函数 for multiple clients to transform XML data—包括XSD验证和XSLT转换—generating an output file and sending it to the client by API.
- 设计了将Excel和CSV文件导入集成数据库的管道, 转换Excel数据以解开数据枢轴, 并使用ADF数据流将数据导出到客户端.
Azure数据工程师 & 数据架构师
心大星的解决方案
- 设计并开发ETL, 数据仓库, cube, 有报道称,一家领先的保健品公司发起了电子邮件活动. 这种自动化为客户节省了大量的时间.
- 提供实时大数据分析架构, 其中包括实时大数据物联网, 机器学习, 以及领先娱乐公司的高级分析平台.
- 使用Python为客户端开发文本分类, Keras, 字嵌入, NLP, Word2vec, GloVe, 深度学习, and CNN.
- 使用Azure砖制作了一个电影推荐的概念验证, 机器学习, 协同过滤, 实时数据摄取, Azure事件中心, Spark MLlib, and Python.
- 创建了一个数据集成管道来摄取SAP IDoc XML数据(包括发票), sales, customer, product, 和支付-使用ADF进入集成数据库, Azure SQL数据库, 和Azure Blob存储.
- Built a Blob-triggered Azure函数 for multiple clients to transform XML data—包括XSD验证和XSLT转换—generating an output file and sending it to the client by API.
高级Azure BI开发人员
沃尔沃斯集团
- 设计并构建了一个维度建模数据仓库, 表格立方体, 以及使用Azure数据仓库的在线销售的Power BI仪表板, Azure分析服务多维数据集, and Power BI.
- 带表分区的性能调优的大容量数据, 多维数据集的分区, polybase, 和散列分布在Azure数据仓库.
- 使用Azure Automation帐户、运行簿和webhook自动化多维数据集过程.
高级SQL BI顾问
Agile BI
- Delivered high-quality BI solutions and projects for clients on BI visualization and reports, 数据仓库, SSAS表格模型立方体, DAX/MDX, SQL Server, Microsoft BI, and Power BI.
- Modeled, designed, and developed independently a sales cube using a SSAS表格模型立方体 and DAX for a large wholesale/retail company.
- Delivered an advanced benchmark BI system and advanced SSRS reports for a leading accounting firm using SSRS, MDX, SSAS, an OLAP cube, 和SQL Server.
高级SQL BI开发人员
澳洲房屋贷款
- 独立设计和开发一个新的数据仓库, cube, ETL, and some reports for analyzing mortgage and non-mortgage sales data (including home loan, 保险及其他财务资料).
- 为财务部设计开发GL多维数据集.
- 对大容量BI数据仓库进行了优化和性能调优.
SQL BI开发人员
Hyundai
- 使用SSRS (Reporting Service 2008)为财务开发了几个报告, marketing, 销售部门.
- Oversaw and was in charge of ETL development and developed an SSIS package to extract data from an ERP system and transformed and processed the data using SQL Server 2008.
- Worked with an analysis programmer and other developer to realize the system based on InfoPath, 微软Web服务, Workflow, 和SQL Server 2008.
Microsoft BI Developer
Pactera
- Worked onsite at Microsoft and contributed to the development and support of five BI applications based on SQL Server, 报告服务, SSAS (cube), SSIS, ETL, 数据仓库开发, 尺寸造型设计, 图式设计.
- Developed reports using SSRS and implemented ETL through programming store procedures and SSIS package.
- Constructed the ETL with an SSIS package—slowly changing dimensions with store procedures, aggregation, 处理立方体, and so on.
Experience
澳大利亚领先超市|电商DWH和Dashboard
Blackmores |数字电子邮件活动和分析
Intersport |零售库存ETL和仪表板
澳大利亚旅游局|数据仓库和仪表盘
The solution provided instant insights to staff—from analysts to C-suite executives—and eliminated the immense amount of resources and time spent on manual reporting and data extraction.
慈善公司|文本分析仪表板
The project aimed to quickly identify important answers from a large number of survey responses every year to uncover the issues in the business and identify opportunities to improve services.
星空集团|实时大数据架构
该平台是为支持下一代分析而构建的, 包括处理结构和非结构化数据, 实时数据摄取, analytics, 还有机器学习.
德勤|汽车行业基准BI系统
Moreover, I tackled the challenging performance issue caused by previous design by reverse engineering and reinventing the "engine." The solution enabled extensive reports to be rolled out to the end users and has since been recognized and applauded by the CIO and partners.
澳大利亚住房贷款|抵押贷款销售DWH和报告
SaaS电子商务网站平台
收益欧博体育app下载公司|数据集成
Additionally, 我创建了blob触发的Azure函数来转换XML数据, 包括XSD验证和XSLT转换, 通过API生成和发送输出文件给客户端. I also designed the pipeline to ingest Excel and CSV files into the integration database, transforming and unpivoting the Excel data and exporting them to clients using ADF data flows.
Python IoT项目
•接收、验证和处理来自物联网设备的XML消息.
•从Cosmos数据库中读写数据.
•将消息推送到Azure存储队列.
•由Cosmos DB feed和Azure存储队列更改触发.
Skills
Languages
SQL, HTML,存储过程,t - sql (transact - sql), c#.NET, Python 3, Python, XML, Batch, JavaScript, Visual Basic for Applications (VBA), C#, XSLT, XSD, Snowflake, Excel VBA
Tools
SQL Server BI, Microsoft Power BI, Microsoft Access, Microsoft Excel, Excel 2010, Azure逻辑应用, Tableau, BigQuery, Azure应用服务, GitHub, Jira, Apache气流, Azure机器学习, Tableau Desktop Pro, Power Query, 谷歌分析, Looker, Spark SQL
Paradigms
维度建模, 商业智能(BI), 数据库设计, ETL, OLAP, REST, Azure DevOps, 数据科学
Platforms
Azure, Databricks, Azure的功能, 谷歌云平台(GCP), Azure事件中心, Apache Kafka, Firebase
Storage
SQL Server集成服务(SSIS), SQL Server报表服务(SSRS), Azure SQL, Microsoft SQL Server, SQL Server分析服务(SSAS), 关系数据库, Databases, 数据管道, OLTP, 数据集成, 数据库集成, 数据库建模, 数据库迁移, 数据库生命周期管理, SQL存储过程, Azure Blobs, Azure SQL数据库, 数据湖设计, Data Lakes, 数据库体系结构, Azure Queue, SQL Server 2016, PostgreSQL, Redshift, Azure Cosmos数据库, 数据库管理(DBA), SQL Server DBA, NoSQL, MySQL, PL/SQL, Amazon S3 (AWS S3)
Other
Azure数据工厂, 数据建模, 数据仓库设计, 工程数据, 数据仓库, 数据迁移, API连接器, ETL Tools, 数据分析, Data, 云平台, ELT, BI Reporting, SSRS Reports, 最小可行产品(MVP), 整合, Azure SQL数据仓库(SQL DW), Reporting, 数据清理, 数据质量分析, ETL管道, Cloud, 实体关系, 性能调优, 数据提取, Azure突触, Azure分析服务, APIs, Dashboards, DAX, 数据可视化, 数据分析, Webhooks, 云迁移, eCommerce, Financials, Big Data, Azure砖, 数据管理, Data Feeds, Delta Lake, Architecture, Azure流分析, GloVe, 自然语言处理(NLP), 数据架构, 谷歌BigQuery, 机器学习, Azure数据湖, GPT, 生成预训练变压器(GPT), SAP IDoc, Web Scraping, 数据抓取, 科学数据分析, Excel Macros, Macros, SAP, Google Data Studio
Frameworks
角,火花, .NET, .. NET Core, Angular Material, ASP.. NET Web API, Apache Spark, Hadoop
库/ api
ODBC, Pandas, Azure认知服务,Azure API管理,Salesforce API, Stripe
行业专业知识
Marketing
Education
计算机科学学士学位
石家庄铁岛大学-中国河北
认证
神经网络和深度学习
Coursera
MCSE:云平台和基础设施- 2017认证
Microsoft