Autumn Zhang
Senior Business Intelligence Analyst at Universal Beijing Resort- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
-
English Professional working proficiency
-
Cantonese Native or bilingual proficiency
-
Mandarin Native or bilingual proficiency
-
French Elementary proficiency
Topline Score
Bio
Credentials
-
Data Science with Python
SimplilearnMay, 2020- Nov, 2024
Experience
-
Universal Beijing Resort
-
China
-
Entertainment Providers
-
400 - 500 Employee
-
Senior Business Intelligence Analyst
-
Jul 2023 - Present
As a consultant, responsible for report delivery in Merchandise and Finance models based on Enterprise Data Warehouse. • Analyze business logic from current complex code, and generate ER diagram together with data lineage document. • Enhance existing SSIS logic and SSAS model to fulfill business analyzing requirements. • Develop on-demand reports according to user requirements with Power BI/Report Builder. As a consultant, responsible for report delivery in Merchandise and Finance models based on Enterprise Data Warehouse. • Analyze business logic from current complex code, and generate ER diagram together with data lineage document. • Enhance existing SSIS logic and SSAS model to fulfill business analyzing requirements. • Develop on-demand reports according to user requirements with Power BI/Report Builder.
-
-
-
-
Business Data Analyst
-
Aug 2022 - Jun 2023
As a consultant, responsible for self-service workspace development and operation in Magellan project (based on Azure Synapse), followed by TCO (Total Cost of Ownership) report enhancement with Power BI (based on Hadoop), then transferred to Business Analysis role to streamline business process within SSG (Solutions & Services Group) Upsell domain and support enterprise data governance project. As a consultant, responsible for self-service workspace development and operation in Magellan project (based on Azure Synapse), followed by TCO (Total Cost of Ownership) report enhancement with Power BI (based on Hadoop), then transferred to Business Analysis role to streamline business process within SSG (Solutions & Services Group) Upsell domain and support enterprise data governance project.
-
-
-
-
Homemaker/Part-time Job
-
Jan 2020 - Jul 2022
• Homemaker to take care of the parent who was seriously ill until she passed away. • Financial investment knowledge study, short-term trades for Hong Kong & US stocks and options, as well as long-term trades in A-share market. • Online course study of data science and big data. • Online course study of Azure Synapse, ADF and associated services. • Power BI report/dashboard assignments remotely. • Homemaker to take care of the parent who was seriously ill until she passed away. • Financial investment knowledge study, short-term trades for Hong Kong & US stocks and options, as well as long-term trades in A-share market. • Online course study of data science and big data. • Online course study of Azure Synapse, ADF and associated services. • Power BI report/dashboard assignments remotely.
-
-
-
Morgan Stanley Services Canada Holding Corp
-
1 - 100 Employee
-
Business Intelligence Specialist
-
Jun 2017 - Dec 2019
Responsible for regulator reporting development and support, this project submits Morgan Stanley firm wise data that is compliant with Volcker rule to US regulators on monthly basis. As an individual developer in US time zone, maintain and develop reports built with Business Objects/Tableau, it includes ETL process via SQL/kdb/Shell/Perl from DB2 and GreenPlum. As a data analyst, help business to extract certain data from data warehouses and find patterns in the large amount of data. As a coordinator and collaborator, organize regular meetings between L1 and L2 teams, take meeting notes and follow up on the actions. Collaborate with senior business management to clarify requirements and manage to fulfill it by cooperation with multiple upstream source systems. Show less
-
-
-
Lenovo
-
China
-
IT Services and IT Consulting
-
700 & Above Employee
-
Advisory Engineer
-
Nov 2012 - Nov 2016
As a senior technical analyst, follow ITIL process to handle BI related incidents, changes and problems. As a project manager, collect and sort out user requirements, analyze latest BI tools and work out the solutions for business based on best return on investment, make the detailed design and manage the outsourcing resource on demand to deliver qualified outcome, also involve in the development to solve tough problems when necessary. As a coordinator, communicate and collaborate with other teams to get cross-function issues resolved. Show less
-
-
-
Mars
-
United States
-
Manufacturing
-
700 & Above Employee
-
Business Intelligence Analyst
-
Sep 2010 - Nov 2012
Incident Manager, Release Manager and change management. As a senior technical analyst to support business regarding BI system problems on a daily basis. In the meantime, manage the outsourcing team to deliver the qualified outcome according to SLA measurement, and redefine the process to improve the service quality. Involve in the release related activities to complete regular change slots, such as planning, making checkpoints, quality assurance of UAT, cut over arrangement. Incident Manager, Release Manager and change management. As a senior technical analyst to support business regarding BI system problems on a daily basis. In the meantime, manage the outsourcing team to deliver the qualified outcome according to SLA measurement, and redefine the process to improve the service quality. Involve in the release related activities to complete regular change slots, such as planning, making checkpoints, quality assurance of UAT, cut over arrangement.
-
-
-
Accenture
-
Ireland
-
Business Consulting and Services
-
700 & Above Employee
-
Team Leader
-
Jul 2006 - Aug 2010
As a team lead serving the Prudential Assurance Company (Hong Kong) for application maintenance and enhancement work. Main responsibilities: team management and client management, user requirement analysis, design, code review and test, problem solving, new joiners' training. Business area: general insurance and employee benefit, life insurance based on direct marketing and telephone marketing. As a team lead serving the Prudential Assurance Company (Hong Kong) for application maintenance and enhancement work. Main responsibilities: team management and client management, user requirement analysis, design, code review and test, problem solving, new joiners' training. Business area: general insurance and employee benefit, life insurance based on direct marketing and telephone marketing.
-
-
-
Talent Information Solutions Ltd.
-
Guangzhou, Guangdong, China
-
Senior Software Engineer
-
Feb 2003 - Jun 2006
Be familiar with development life cycle and banking system development rules as well as grasping of banking business flow. Requirements analysis, module design and development; customer support and management. Good requirements collection and summary skills; Excellent SQL programming (Oracle, Sybase, Informix) and PowerBuilder skills to make reports; DBA ability to migrate mass data from distributed databases and upgrade database version; Strong C, Pro*c, Shell programming skills on Unix platform for interbank message of SWIFT(MT103,MT202,etc) and ISO8583. Show less
-
-
-
Sinobest Information Technology Ltd.
-
Guangzhou, Guangdong, China
-
Software Engineer
-
Jul 2001 - Jan 2003
Module design and development; Customer support. Use PowerBuilder, SQL and Java to develop MIS for Public Security Bureau of Guangdong Province. Module design and development; Customer support. Use PowerBuilder, SQL and Java to develop MIS for Public Security Bureau of Guangdong Province.
-
-
Education
-
1997 - 2001
Harbin University of Science and Technology
Bachelor’s Degree, Computer Science And Technology
Community
