Data Analyst Power Bi

Bowen Tan

+1-585-***-**** · ************@*****.*** · Atlanta, GA 30084

SUMMARY

• 5 years of hands-on experience in the fields of Data Science and Data Analytics with great attention to detail

• Skilled in working with large datasets and build data pipelines to ingest data and streamline processes

• Worked extensively in problem solving with data-driven decision making to improve operational processes

• Developed visualization dashboards using Power BI to reduce cost and improve efficiency WORK EXPERIENCE

Cox Automotive Atlanta, GA

Senior Business Intelligence Analyst September 2024 – now

• Proficient in using SQL/Snowflake and Python to extract, transform, and analyze data from various systems, handling large datasets efficiently; designed and developed dashboards supporting all sales segments across Cox Automotive

• Partnered with sales leaders to transform and model large datasets to prepare data and translate complex data into consumable insights, and build visualizations for non-analytical stakeholders including Power BI

• Supported backend improvements to data pipelines and visualizations and managed analytical processes, built new datasets, and validated/improved existing data pipelines using Snowflake and Python UKG Atlanta, GA

Senior Data Analyst September 2023 – August 2024

• Collaborate with cross-functional stakeholders to understand their business needs and formulate end-to-end analysis includes data gathering, data extraction, and data visualization using Python, Azure SQL and Power BI

• Scale data technology stacks by building pipelines to fetch data from API, creating meaningful data transformations, and creating ETL processes to ingest data into data mart

• Develop, automate and maintain visualization reports across multiple sources for both ad-hoc requests and project work to help management gain insights and support business decisions Morgan Stanley Atlanta, GA

Data Analyst May 2022 – May 2023

• Migrated 300+ clients’ data from multiple platforms/sources to shareworks.com (a cloud-based equity plan management solution by Morgan Stanley); applied new migrating criteria to ensure consistency in SQL Developer

• Loaded large data sets using PowerShell, translated bulk data using SQL Server, updated and analyzed stock options, grants, and cap table in SQL Developer, and used JIRA to track progress and to ensure projects delivered on time

• Used Python scripts to run status rule updates post migration for shareworks.com Novelis, Inc Atlanta, GA

Data Analyst Feb 2020 – Mar 2022

• Applied established and created new analytical processes on diverse datasets and make recommendations to grow business; worked cross functions to provide insights and analytical supports when needed

• Developed automated backend data pipelines and designed user-friendly frontend dashboards for business leaders to report process KPIs; analyzed downtime data using Linear Regression and Logistic Regression in Python

• Contributed to design a self-service in-house data science platform’s ETL flows; extracted large data sets using SQL, built OLAP Cube; created Power BI visualization reports to target loss intelligence

• Leveraged data analytics tools to create dashboards, reports, and additional ad-hoc data requests based on business priorities; provided visibility and communication to stakeholders on the projects I was responsible for Ansell Healthcare Iselin, NJ

Data Analyst Intern June – August 2019

• Assisted in the data migration process from Oracle Siebel to Salesforce’s CRM platform; managed several data analysis projects simultaneously

• Updated and analyzed contacts, opportunities, and leads in Salesforce; wrote queries to extract account contact relationship from Salesforce; cleaned and analyzed complex distributor and end-user data in Excel

• Developed sales reports using SQL and generated actionable recommendations and presented insights backed up by data using Tableau to sales team to increase revenue

Gausscode Technology, Inc San Jose, CA

Operations Data Analyst Intern June - August 2017

• Analyzed data related to car ownership in MySQL, applied cross-correlation in Excel to analyze sales trends, and collected historical model parameters using Tableau visualization to support strategy-making process

• Collaborated with cross-functional team to segment customers. Specifically, performed K-means clustering in R to identify consumers into different categories and tailor marketing campaigns to increase revenue

• Led 5-member team in a high-level presentation to key leadership regarding annual sales trends and provided predictions with accompanying recommendations using PowerPoint EDUCATION

Columbia University New York, NY

M.S. in Applied Analytics, GPA: 3.8 December 2019

University of Rochester Rochester, NY

B.A. in Statistics with a Minor in Mathematics, B.S. in Business, GPA: 3.6 May 2018

• Dean’s List

RELEVANT PROJECTS

Ernst & Young Winter 2016

• Successfully managed competing priorities including financial statement analysis, email communication

• Analyzed and prepared financial statements for Chang’an, a leading player in the SOE sector, derived key insights and provided recommendations with regard to operations

• Analyzed Chang’an’s financial data in Excel for the firm’s 2016 Annual Report Sinolink Securities Summer 2016

• Assisted in the underwriting process for a leading Chinese apparel company’s IPO on the Shenzhen Stock Exchange

• Modeled five-year sales forecast by building linear regression model in Python to support company valuation

• Built DCF model in Excel, conducted peer comparison and transaction analysis to derive enterprise value SKILLS

Coding: Python (Pandas, NumPy, Sklearn), R (regression, decisions trees, K-means clustering), PowerShell Machine Learning: Regression, K-means clustering, Classification Analysis: Power BI, Tableau, Salesforce, SAS, JMP, Excel (pivot table, v-lookup) Database: SQL, OLAP Cube, Star Schema

Skills: Agile Scrum, JIRA

Habits: Snowboarding, Scuba Diving, Pilate

Contact this candidate