George Guan
Email ID: **********@*****.***
Cell: 720-***-****
SUMMARY
Experienced Tableau developer, data analyst, strategist, and creative problem solver with a history of building ad-hoc dashboards systems and introducing solutions to systematize data quality assessment. HR recruitment domain experience with a customer base of over 40 clients. Broad knowledge of Tableau and strong experience in ETL, Data Analysis, Data Mining. Comfortable with multitasking and appropriately prioritizing last minute requests.
TECHNICAL AND FUNCTIONAL SKILLS
Visualization Tools: Tableau, R, Stata
Reports Publishing and Sharing tools: Tableau Online, Tableau Server, SSRS server
Reporting Tools: Tableau, SSRS
SQL Languages: MS T-SQL, Postgres SQL, MySQL
Integration Tools: SSIS
Other Language: Python, JavaScript, HTML, D3.js
Microsoft Office Suite: Outlook, Word, Excel
Languages: English, Mandarin
PROFESSIONAL EXPERIENCE:
Careerbuilder Broadbean Technology, CA June.2015 – November.2016
Tableau Developer
Description:
Broadbean develops a clever piece of online recruitment software that helps over 60,000 recruiters globally source candidates from job boards, social networks and other online recruitment channels.
Responsibilities:
Work with the business analysts and director to gather business requirements from clients
Cooperate with ETL developers to build new database environments for reporting purpose
Perform user experience and user interface designs based on users of dashboards
Analyze data to figure out data’s schema, relationships, patterns and quality
Provide visualization support to all teams with Tableau dashboards designed for different purposes such as KPI indicating, Marketing, ETL process auditing and QA
Implement client-designed dashboards, reports and workbooks by using Tableau 9.x
Oversee performance tuning and query optimization for enhanced user experience when creating complex or large queries
Manage Tableau Server and Tableau Online such as automating report updating, setting permissions and testing performance
Support our clients’ use of our database solutions and reporting systems. Provide technical interface and handled customer issues as they relate to special requests.
Help train dashboard users and developers to use and understand tableau.
Develop BI documentations about Dashboard development, testing, and production deployment to Tableau Server/Online
Utilize Tableau JavaScript API to host my visualizations on webpage
Develop tree map by using d3.js to filter tableau dashboards hosted on webpage.
CCS Global Tech, San Diego Jan.2015 – May.2015
Tableau Developer
CCS Global Tech is offering a wider range of Project and Product based solutions to its customers in the areas of Data Warehousing and Business Intelligence.
Responsibilities:
Helped setup Tableau Server and test its performance
Analyzed data to identify known and unknown data relationships and patterns
Developed Tableau dashboards that satisfy customer analytic and intelligence requirements
Deployed dashboards to Tableau Server environments
Supported integration of workbooks into enterprise applications
Designed and implemented data refreshment strategies for dashboards
Bellema Corporate, Denver July.2013 –Nov.2014
Tableau Developer/Data Analyst
A mother and baby products manufacturer serving more than 4 million families.
Responsibilities:
Partnered with the Product Managers to define reporting/analytics roadmap
Used Tableau desktop to develop reports and dashboards
Used Tableau Online to maintain core Tableau reports
Communicated with clients to understand what questions they are interested in and articulate those in the form of report designs and product requirements
Trained internal users on how to use Tableau and assist with report building for more advanced reporting needs
Helped external clients who want to build their own custom reports
EDUCATION
University of Colorado at Denver, Denver, CO Aug. 2012 – May. 2014
Master of Science in Applied Math(Statistics)
University of Colorado at Denver, Denver, CO Aug. 2012 – May. 2014
Master of Arts in Economics