Objective

A senior level consulting position utilizing Tableau, Business Intelligence, Data Analytics, and Development. Tableau Public Profile: https://public.tableau.com/profile/nancy#!/

Tableau Development, Prep, Alteryx, Tabcmd

Python, Pandas, Jupiter, Java (basic), GIT

Business Intelligence Analysis and Design

MS: Excel ( advanced level), PowerPoint, word

Enterprise Reporting, Analytics, Documentation

Integrated Analytics & Automated Dashboard

JavaScript, React (basic), PHP (basic), HTML, CSS

Knowledge of Financial Accounting, Investment, Stocks, etc.

ServiceNow, Workday, LogicGate, Obiee(basic)

AWS, Cloud Data Warehouse, Redshift

Advanced SQL, Presto/ Hive, Teradata, Oracle, SQL Server

Knowledge of SAS, R

User Stories, Project Management, Agile, Jira

Best Practices, Metadata, Governance

Data Integration, Aggregation, KPI’s

Data Warehouse, Dimensional Modeling

Trouble shooting, performance tuning

SSIS, SharePoint

Health Care Claims workflow, Epic Clarity, Clarity Star Schema, Clarity tables

Experience

Sr. Tableau developer/ Data Analyst

Glead Sciences, Inc., Foster City, CA USA (6/2021 – 10/31/2021)

Developing a large sets of Tableau dashboards in the areas of Library Information System of Medical Affairs and Tickets Usage in Sparc System in operation.

Created Python script to organized, cleaned and combined data, and extracted data from ServiceNow for Tableau dashboards data feed

Created scripts with Python, Pandas from scratch to identify new, updated and deleted records of data sets by comparing current month data to previous month data, and insert the newly identified records into Salesforce system.

Worked as technical consultant to provide technical support for stakeholders.

Worked with stakeholders to define requirements for projects.

Sr. Tableau developer/BI Consultant/Data Analyst

ImageryAI, Redwood City, CA USA (2/2020 – June, 2021)

Working with Program managers and cooperating with stakeholders at all levels to analyze and define business requirements. Translated discussions into user stories, tasks, and developed visualizations to meet objectives. Recommended, documented, and implemented best practices for stakeholders.

Developing tableau dashboards with advanced features in the areas of Data Governance, QBR/MBR Executive level dashboards, Internet Portal Services, Cyber information security, Consumer Forecast, Sales, Risks Ticketing Management with predictive analysis, Marketing, Phishing Campaign, etc.

Working experience in writing SQL queries and Python scripts to pull and automate data from different sources such as JIRA, My SQL, AWS data warehouse, CSV,etc., and manipulate, organize and generate new data sets to feed Tableau dashboards.

Working experience in creating tables with Star Schema data modeling in AWS and ETL pipelines with Python, then pull data from AWS to feed data in Tableau dashboards.

Working experience in writing Python scripts to build Tableau Data Extract Files by importing Tableau Data Extract API.

Working experience in using Tabcmd as admin tool to manage resources in Tableau server such as publishing, downloading, adding users in groups, etc.

Converted manual processes to fully automated workflows to deliver accurate and timely data for Tableau dashboard.

Working experience in manipulating, organizing data to process large data sets in Excel and generated new data set with Python.

Sr.Tableau Developer/ BI Consultant/Data Analyst

CWTarget, San Diego, CA (8/2019 to 2/2020)

Worked as Tableau consultant to cooperate with stakeholders at all levels to analyze and define business requirements.

Completed proof of concepts, developed dashboards and automated solutions for various areas in the areas of

Cyber information security, Cloud Security, Cloud Migration, social media, customer experience, Corporate Finance, etc.

Designed and implemented ETL Glue jobs on AWS with Extract from RedShift, Transformation and Load to S3 bucket.

Wrote python scripts or SQL to pull and automate data from different sources such as JIRA, AWS data warehouse, ServiceNow, CSV, Excel, My SQL, etc.

Manipulated, organized, and consolidated data with Python to feed data for Tableau dashboard.

Experienced in using advanced calculations such as LOD, table calculation, etc. and join or blend is used in different situation in Tableau dashboard development.

Recommended, documented, and implemented best practices for stakeholders.

Sr. Tableau developer / Business Intelligence analysis

Facebook, Inc., Menlo Park, CA USA (6/2018 to 8/2019) (via Disys, Inc.)

Worked with business stakeholders to discuss/define business requirements, metrics for complex analysis of data centers infrastructure data in different areas such as Growth Marketing, Energy Schedule, Strategic Planning, quality issues, etc. Translated discussions into user stories, tasks, and developed visualizations to meet objectives.

Developed various kinds of Tableau visualized dashboards using Tableau Desktop (above 2018.1 version) and presented insights to Executives.

Working experience in creating ETL pipelines by using Data Swarm tool, python, SQL.

Experience in exporting Tableau dashboards images and creating beautiful newsletters in PowerPoint and provided insights from Tableau dashboards to executives.

Address performance issues and improved responsiveness for existing dashboards;

Experience in pulling large data sets from Hive or Presto by writing very complex, advanced SQL queries to feed Tableau dashboards.

Experience in writing Tableau complex calculation, LOD, dynamic filters, parameters, mapping, etc. in dashboard development.

Analyzed, transformed, organized data, constructed SQL queries, and produced analytics and data sources needed to meet use cases and integrate data seamlessly.

Working experience in building CRUD form with Javascript, React, PHP for business stakeholders.

Experience in managing multiple intensive tasks under pressure and finishing the tasks by deadline.

Sr. Tableau Consultant/BI Consultant

Randstad Technologies, LLC, San Francisco, CA, USA (2/2018 –6/2018)

Assigned to work in AAA, Walnut Creek, CA USA as Tableau consultant to develop insights using Big Data and Tableau; Supported conversion of legacy environment to Cloudera Hadoop/Hive data lake

Analyzed and transformed data, constructed SQL queries, and produced analytics and data sources needed to meet use cases and integrate data seamlessly.

Designed and developed standard Finance, Marketing and Sales operation dashboards and scorecards by Tableau

Wrote about 2000 lines complex SQL to create data sets from Oracle data warehouse to feed data for Tableau dashboards

Working experience in extracting, organizing data from different data sources by Python.

Experience in performing data mapping, blending workflow using Alteryx,

Experience in discussing and communicating with stakeholders to define business requirements and business metrics for different products.

Tableau Developer

Client: Apple, Inc. Sunnyvale, CA, USA (8/2017 – 10/2017)

The scope of the project in Apple was to create Dashboards by Tableau to analyze and monitor different database systems and dynamic data ETL daily performance as well as analysis signups, churn_ups in iTunes products as well as payment type use in different countries worldwide.

Created Tableau dashboards in the areas of global customer’s behaviors such as purchase, retention rate, etc. by analyzing and defining business requirements.

The Tableau dashboards advanced features such as LOD, Geo Mapping, sheet selector, show/hide function, parameters, logic calculated fields, etc. are used to provide dynamically daily, weekly, quarterly, monthly and yearly reports based on users’ needs.

Wrote complex SQL to pull needed data from Teradata data warehouse to feed Tableau dashboards.

Tableau Developer

Client: Wells Fargo & Company, San Francisco, CA, USA 5/2017 – 7/25/2017

The scope of the project in Wells Fargo was to complete re-engineering projects that involved converting from a manual, Excel-based reporting system to fully automated processes using SAS, Teradata, Oracle, SQL, Unix, Tableau

Experience in database design and build, SQL and stored procedures, SAS programming, job scheduling, data aggregations/analytics

Developed Tableau dashboards by converting existing excel-based reports to Tableau in the area of threshold reports, Express Send Fraud Transaction Cases, Incoming/Closed Fraud Investigations, False Positives Report,, Customer unauthorized transactions, etc.

Tableau Developer/BI Consultant

Robert Half Technology, San Francisco, CA, USA ( 1/2017---5/2017)

Assigned as Tableau/BI Consultant to work in Delta Dental Plans Association, San Francisco, CA

Worked closely with our project managers to analyze and design monthly enrollments KPI, marketing survey Dashboards based on different Delta dental plan or groups in the areas such as B2B, B2C with Tableau.

Experience in providing in creating ETL packages by extracting data from Oracle database with SQL and extracting, organizing data from the company’s web portal by using Python.

Business Data Analyst/Tableau developer

Kaiser Permanente, Oakland, CA, USA (3/2016 --- 11/2016)

Tableau Project Responsibilities:

Defined business requirements for the Tableau Dashboards in the categories of Claims Inventory Operation, Network Service Issues, work order, Revenue Cycle Executives Dashboard, etc..

Responsible for designing and developing tableau dashboards with advanced visualizations and features and publish Tableau workbooks and dashboards into Tableau server as well as embedded and integrated some Tableau dashboards into Share Point portal.

Working experience in creating Tableau dashboards using Analytics features in Tableau such as Box Plot, Trend Line, Forecast, etc. to analyze business metrics pattern

Experience in preparing data workflow by joining or blending, transforming data from different data sources by using Alteryx.

Clarity Experience:

Run and maintain monthly reports in the areas of Finance, Insurance, Claims, Information about Doctors and Patients, Doctor’s performance, etc.

Familiar with EPIC Clarity’s system star schema as well as its relationship among tables.

Familiar with tables and know how to pull needed data with SQL from different tables like Clarity Ser (for doctor info), Clarity_EPP (for Insurance_ID, Name, Company, etc.)

Working experiences in pulling data with SQL to join tables from EPIC Clarity under Teradata platform and feed data in reports in Tableau or Crystal.

Passed Epic training courses in the Organization.

Other Responsibilities:

Generated adhoc reports based on requirements from Claims CDW, and SQL Server database.

Experience in using Excel pivots, charts, vLookup, concatenate and logic function to create daily complicated claim inventory report.

Working experience in using Power Query in Excel to get data and creating statistical modeling as well as using VBA to automate some work.

Business Intelligence Consultant/Reporting Analyst/ Data Analyst/System Analyst

E-Business Consulting LLC, San Bruno, CA, USA (1/2011---1/2016)

E-Business Consulting is a consulting company which provides technology service to its clients. Worked as business intelligence consultant, reporting analyst, ETL developer, etc. and had experiences in developing a variety of solutions for clients in different industry settings.

Main Job Duties:

Collected requirements and created analytics, supported end users to deliver high quality reporting solutions for clients.

Developed complex SQL scripts and queries to extract, cleanse, and combine data from a variety of sources and platforms including Oracle and SQL Server;

Working experience in creating ETL packages to automate business data loading into data warehouse or relational database with SSIS and T-SQL.

Designed and created dashboards by Tableau in the areas of supply chain, Purchase Order, Finance, Sales, etc.

BI developer/ Reporting Analyst

Honsea Chemistry Co., Guangzhou, China (2/2006-12/2010)

Responsible for extracting, loading and validation of the company’s manufacturing products data by SSIS or T-SQL.

Generated business reports by SSRS and Crystal reports based on business requirements

Implemented new ETL to improve performance, scalability, consistency, and data accuracy

Prepared various statistical data analysis reports by Excel for corporate clients

Database developer/admin

Mercury Interactive, Mountain View, CA (5/2003 – 12/2005)

Involved in database design, ER modeling, and database tuning.

Worked as DBA role including backup, recovery and replication.

Assisted in administering BroadVision applications on production with 90K users.

Generated business reports from databases by SQL.

Wrote detailed technical specifications for large ETL projects including instructions for databases, tables, stored procedures, data typing and naming, indexing, documentation

Web/Database developer

Excite, Redwood City, CA (1/2000-7/2002)

Assisted in creating and maintaining E-commerce web site by using HTML

Performed analysis and presented results using SQL, MS Access, Excel and Visual Basic Scripts.

EDUCATION

Master of Science in Management Information System

Clarkson University, Potsdam, NY, USA Jan. 2000

B.A. English Literature and Language, Xiangtan University. China

LANGUAGES English, Chinese

Contact this candidate