Tableau
Jacqueline Chen
Senior Data Operations Analyst
Summary
Highly self-motivated individual who always demonstrates strong leadership and commitment throughout project life cycles in collaboration with global departments. Passionate analyst exceling in critical thinking and problem solving with rich experience in providing innovative data solutions adhering to ever-changing business needs. Enthusiastic and proactive operator with good communication skills and customer service mindset who builds up professional working relationships with global stakeholders under a big corporate environment.
Overview
8
8
years of professional experience
2019
2019
years of post-secondary education
2
2
Certifications
2
2
Languages
Work History
Senior Data Operations Analyst
ICIS, part of RELX group
12.2021 - Current
- Mastered data engineering infrastructure involving python, docker, gitlab and production database within a week and handled with data engineering team's Jira tickets like modifying functions as own career development plan
- Became a well-known advanced user of PowerBI and completed an innovative supply and demand dashboard lively illustrating capacity, consumption, net trades, plant value of 50+ commodities globally which are widely used during customer calls
- Created two high-quality Tableau dashboards; one is a chemical vessel voyage tracker using live data and another is a macroeconomic stats overview by categories and series above stakeholder's expectation
- Led the improvements of Tableau dashboards with intelligent features of animation and interactive functionalities as the first person in the team
- Professionalized as a data scraping champion and worked with consulting team to tackle customers' queries worth $10k revenue in 10 hours
- Supported energy database decommission project as business key priority
- Successfully delivered a spreadsheet with trade ticks data automatically updated every midnight and a dashboard showing energy price assessments over 100 markets using migrated data in snowflake warehouse, data transformation tool Alteryx and data visualization tool Tableau
- Conducted data quality check scripts involving timeliness, uniqueness of scraped data inhouse by using GitHub and SODA as tools
- Acted as a technical expert for the Data Acquisition team during data contract renewal calls with external parties, recommending comprehensive end-to-end data delivery solutions, including APIs
- Represented senior leadership team as a Cultural Ambassador in the region to enhance employee engagement and promote diversity and inclusion by organizing local huddles and cultural events
Data Operations Analyst
ICIS, part of RELX group
07.2019 - 12.2021
- Developed and maintained the most data scraping programs by successfully constructing reliable robotic process automation via Kofax Kapow Designer tool ensuring accurate, regular and structured data collection inhouse
- Released data projects to over 100 global stakeholders with collaborating on, leading and contributing in every development stage including customer survey carrying out, documentation writing, tutorial video shooting, community constructing, presentations and workshops delivering, trainings and ad-hoc technical supports as needed
- Innovated game-changing data management processes and automation applications through use of Alteryx, Python and Excel Power Query which highly enhances internal editorial and analytics colleagues' experiences in data consumption and further drives working efficiencies
- Designed interactive and informative Tableau dashboards satisfying data visualizing requirements across the organization as a champion from internal Tableau community
- Worked closely with global technology teams and wrote queries to extract large datasets from various systems, e.g
- XML database, Amazon AWS, and SQL database for core analytic or marketing purposes
- Immersed in corporate's digital transformation journey identifying opportunities for workflow optimization as an expert with necessary knowledge in data lake development, data catalogue launch, data governance and data procurement processes
- Initialized Women Connected APAC cultural community advocating career progression and connection with opportunities of networking, panel discussions, and charity work for women aligning with corporate's diversity and inclusiveness vision
Regional Business Intelligence Data Analyst
Shopee Singapore Private Limited
05.2018 - 07.2019
- Responsible for generating and delivering daily report to CEO and other senior managers for the purpose of overseeing general performance of business in 7 regions
- Coordinated with Regional Finance team to determine P&L structure for new business feature and build solid calculation logic for reporting relevant figures by using Apache Spark as big data analyzing tool
- Designed dashboard on Lumos platform tailed to Regional Finance team's need in visualizing data trend and downloading figures for reconciliation purpose at their convenience
- Cooperated with Data Engineer team to complete data migration project by switching data source of data products from Amazon Redshift to Presto database in a timely manner
- Utilized Apache Yarn Hadoop to monitor data pulling jobs and optimized Spark scripts to speed data generation process up with optimization in reducing cluster resource occupied
Regional Business Intelligence Data Analyst Intern
Shopee Singapore Private Limited
08.2017 - 05.2018
- Handled ad-hoc data requests from Brand Partnership team independently with a wide range of objectives such as analyzing sales performance, discovering search popularity and understanding buyer profiles
- Assisted team lead in urgent investor's data request by writing HiveSQL to extract data from database and preparing ready-to-use working files
- Designed data validation tools post BI reports' generation by using Microsoft Excel VBA to ensure data quality and improve working efficiency
- Assisted data engineers in appending missing historical data into data marts by writing complex queries to join 10+ original raw DB tables and get correct figures on an item level
- Invited by team lead to convert to full-time employee after 6-month internship
Information System Intern
Yu & Associates Inc.
06.2016 - 08.2016
- Queried in company's database to extract client's relevant information and summarized to department manager on ad-hoc basis
- Conducted self-learning via watching online tutorials to familiarize with designated commercial software, Joomla framework in a week
- Cooperated with local intern to rebuild company's official website and created searching engine by utilizing professional programming language
Education
Master of Science - Information Systems
Nanyang Technological University
Bachelor of Science - Mathematics and Economics with specialization in Finance, Minor in Computing
Nanyang Technological University
Skills
Data Scraping
Software
Power BI
Postgre SQL, MS SQL
Python
Docker
Github, Gitlab
Kofax Kapow Robotic Process Automation
Excel VBA, Excel Power Query
Jira and Confluence
Alteryx
Spark, Hive, Yarn Hadoop
Amazon Redshift, Amazon AWS
Snowflake
Certification
Alteryx Core Certification
Timeline
Senior Data Operations Analyst
ICIS, part of RELX group
12.2021 - Current
Data Operations Analyst
ICIS, part of RELX group
07.2019 - 12.2021
Regional Business Intelligence Data Analyst
Shopee Singapore Private Limited
05.2018 - 07.2019
Regional Business Intelligence Data Analyst Intern
Shopee Singapore Private Limited
08.2017 - 05.2018
Information System Intern
Yu & Associates Inc.
06.2016 - 08.2016
Bachelor of Science - Mathematics and Economics with specialization in Finance, Minor in Computing
Nanyang Technological University
Master of Science - Information Systems
Nanyang Technological University
Similar Profiles
Robert Hunter IIRobert Hunter II
Legislative Analyst at RELX GroupLegislative Analyst at RELX Group
Durgesh KumarDurgesh Kumar
Credit Controller at Elsevier (Relx Group)Credit Controller at Elsevier (Relx Group)
Julian KuçiJulian Kuçi
Chief Operating Officer (COO) at The Faktory Group - Part of Milan-Based "Prismi Group"Chief Operating Officer (COO) at The Faktory Group - Part of Milan-Based "Prismi Group"
James BurrowsJames Burrows
Senior Data & Operations Analyst at Varda PartnersSenior Data & Operations Analyst at Varda Partners
Santhosh BSanthosh B
Data Operations Engineering Data Senior Analyst at BP PLCData Operations Engineering Data Senior Analyst at BP PLC