Information Systems Data Analyst

https://www.linkedin.com/in/melvinchow*

Melvin Chow

Fremont, CA 94539

***********@*****.***, 510-***-****

EDUCATION

Santa Clara University, Leavey School of Business Santa Clara, CA Master of Science in Information Systems (MSIS) June 2018

GPA: 3.3/4.0

Relevant Coursework: Business Intelligence & Data Warehousing, Big Data Modeling & Analytics, Database Management Systems

University of California, Berkeley Extension Berkeley, CA Post-Baccalaureate Certificate in Information Systems & Management July 2014

GPA: 3.8/4.0

University of California, Irvine, Paul Merage School of Business Irvine, CA Bachelor of Arts in Business Economics July 2013

ACADEMIC PROJECTS

Organizational Experiment – Telecommuting: Designed an experiment measuring impact of telecommuting on motivation, productivity and stress levels of engineering team to assess whether allowance of telecommuting would benefit the company.

KPIs defined through interviews with each team member; changes in metrics over time would be tracked Information System for Food Truck Association: Enabled network of food trucks to manage customer orders, forecast sales and identify customer preferences; coordinated the maintenance and deployment schedule of trucks through development of web portal

Outlined process flow with development of use case definitions, Gantt chart, data flow diagrams, UI templates

Designed database schema – data dictionary, UML / DML model; Enumerated queries to be executed against the database by each user type

Business metric reports generated to allow user to assess business performance Comparing Working Conditions, Quality of Life: Cleaned, organized and compared datasets relating working and living conditions between USA states to determine if the data validates media hype and high demand for living in such states

Identified the most critically needed business requirements from stakeholders to draft a requirements statement that benefits as many users as possible

Perform ETL processes on raw CSV data files: Clean tables, load into database, display in dashboards / visualizations EXPERIENCE

Astreya Mountain View, CA

Support Technician / IT Coordinator (Client: Google) 2015-2016

Coordinated the completion of 40+ user acceptance testing projects to streamline the flow of 3000+ assets within inventories

Developed 10+ documentation procedures for troubleshooting processes and the sorting of database records to consolidate problem solving information from multiple sources, increasing the efficiency of training, project completion and report delivery

Spearheaded the configuration of 6 Linux workstations, enabling team of 8 technicians to complete projects with increased levels of complexity

TECHNICAL SKILLS

Programming Languages: C, Python, SQL, Bash, Java

Operating Systems: Unix (14.10 and later), Windows (7, 8, 10), Chrome OS, Mac OSX (El Capitan) Tools & Platforms: MySQL Workbench, Github, Google Drive, Microsoft Office, Eclipse, Alteryx, Tableau, Apache Spark ADDITIONAL INFORMATION

Interests: Automotive industry and motorsports, aerospace and drones, photography, video games and virtual reality, consumer electronics, big data technologies

Spoken Languages: Fluent in Cantonese, conversational in Mandarin

Contact this candidate