Michael Ye Email & Phone Number

• Consulting for Client: Boeing (Seattle, WA), Levi’s (San Francisco, CA), Hyundai Capital (Irvine, CA), Bayer Pharma (Whippany, NJ), Syngenta (Greensboro, NC), Moody’s (New York, NY), Sysco (Houston, TX), AT&T (Dallas.
• Designing intuitive data visualizations using Tableau and Power BI. Work with teams for business stakeholders to understand their requirements, implement data visualizations and build dashboards on time.
• Responsible for implementing tableau and Power BI features and functionality and align with Business Intelligence requirements, defining strategy, visual architecture, and implementation plan.
• Make clean data sources with user-defined security and publish on Tableau and Power BI Server with certain site, project and permissions assignment.
• Work on Data engineering and data science solution on Microsoft Azure cloud platform.
• Make data extract with different hierarchies based on the databases from Snowflake, Redshift, SAP Hana and SQL Server and test efficiency for the data loading.

• Designing intuitive data visualizations using Tableau. Work directly with business stakeholders to understand their requirements, implement data visualizations and collaborate with technical data teams.
• Work directly with business units to define and prototype Tableau Application.

Pittsburgh, Pennsylvania, US

• Working as a Tableau Subject Master Expert at PNC.
• Conduct Requirement Gathering sessions with Business partners and Finance leadership to understand the business requirements to build analytics, reports and dashboards.
• Works with business stakeholders to understand, analyze, evaluate business requirements and translate them into functional and non-functional requirements including process flows, assumptions and key decisions.
• Design and Build complex custom reports for end-user scenarios.
• Provide guidance and knowledge transfer to other team members.
• Work with cross-functional teams consisting of domain and technical architects along with Testing/Support teams to deliver the end product.

California, 94086, US

• Working on Enterprise Data Warehouse 3.0 Project for financial department of client Intuitive Surgical through Consulting Company KPI Partners.
• Develop Tableau Reports incorporated with Row-Level Security.
• Working in Agile/Scrum project management system.
• Make clean data sources with user-defined security and publish on Tableau Server with certain site, project and permissions assignment.
• Make data extract with different hierarchies based on the databases from SAP Hana and SQL Server and test efficiency for the data loading.
• Seamless migration of reports from Excel to Tableau with new build of dynamic parameters, filters and actions.

Mumbai, Maharashtra, IN

• Work as a Business Intelligence Analyst and senior data visualization engineer using Tableau for Walmart Headquarters in Bentonville, AR and JC Penney in Dallas, TX.
• Develop various dashboards for different business purposes based on data sources from Hadoop, Pivotal Greenplum databases and Amazon Redshift cloud database.
• Defined best practices for Tableau report development.
• Using Agile/Scrum methodology in project management.
• Work as a Tableau desktop trainer for other groups in TCS Bentonville team.

• Design and develop Tableau visualization solutions.
• Work on generating various dashboards in Tableau server using various data source
• Install upgrade Tableau server and server performance tuning for optimization.
• Administer user, user groups, and scheduled instances for reports in Tableau.
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
• Proof-read all documents and maintain accuracy of information and preparing SOP.

Champaign, IL, US

• Design new compounds using chemical database platform. Build and optimize novel drug models to perform virtual screening of small molecules in big drug database.

• Design and synthesis of advanced functional intermediate compounds for drug discovery research.

Los Angeles, CA, US

• Design of small molecules for anti-cancer drug discovery research and virtual screening of promising compounds in drug database.

• Business reporting using Tableau, Crystal Reports and SSRS.
• Business intelligence analysis and database analysis with MS SQL data tools, data mining and ETL.

La Jolla, CA, US

• Design new drug candidates with drug database program Sybyl, SPSS and SAS.
• Build effective anti-cancer drug models with data mining and data analysis service skills.

Doctor Of Philosophy (Ph.D.), Chemistry

Master'S Degree, Medicinal Chemistry

Bachelor'S Degree, Chemistry