Mark Luo

Fremont, CA

adt3pa@r.postjobfree.com 408-***-****

Highlights of Recent Work Experience

** + years of experience working on MySQL DBA and Strong experience in installing, configuring and maintaining MySQL and Amazon RDS on Linux and Windows environments.

Extensive Amazon RDS experience including migration, design and implant RDS database system for large enterprise system.

Strong passion for MySQL DBA tasks and troubleshooting and resolving issues

Install, configure, and upgrade Oracle and MySQL databases and software on Linux.

Exceptional SQL/T-SQL coder, skills and experience of writing complex SQL query, debuging and performance tuning.

Optimize MySQL reporting query and writing new query reports for Ultimatepoker.com.

Deployed MySQL Enterprise monitor on Solaris zone environment for VISA online gaming payment system, Playspan.

Developed MySQL/java/PHP/ applications for a table reservation system for 360 panorama user interface application, Krpano.

Designed and developed custom ETL system to extract SEC text report file into MySQL database for text analysis using Perl and PHP for Stanford law school.

Architected database schema, developed Apple’s chat Agent reporting architecture, call agent time management reporting system include ETL script for data migration in less than 4 month.

Migrating Transera Inc.’s existing reporting system from crystal reports to custom PHP/MySQL system include ETL script for data migration.

Work Experiences

Green Tech Financial Group Fremont, CA

MySQL DBA Dec 2015—Present

Designed developed Database of the stock trading website

Developed the php/Drupal website

Install, upgrade, optimize, troubleshoot, perform root cause analysis on, and maintain MySQL Servers

Architected the IT Architecture for hosting including network connectivity, mysql database security, and access control.

Stock data API development, like alpaca API for real time stock pricing data.

Planning company Database/IT Strategy

Designed, setup high available database system/web service for operation like customers CRM, employee database control, security, etc.

Architected the IT Architecture for company including network connectivity, mysql database cluster, security, and access control.

Production T-SQL development, performance tuning.

Acesse Marketing Redwood City, CA

Senior MySQL DBA Aug 2014—Sept 2015

Upgraded over 100 Amazon RDS MySQL instances which handle millions of real money transactions per day in less than 1 week period for security patches.

Debugging production T-SQL performance issues and bugs.

Created SQL program for MySQL data table pruning.

Architected, migrating RDS MySQL database into new, more secure environment.

Design, create, and implementing RDS QA, Staging environment.

Perform large production database table archiving which size over 2 TB.

Ultimatepoker.com Oakland, CA

MySQL DBA May 2013—Aug 2013

Optimized MySQL reporting query and writing new query reports with T-SQL/SQL.

Created partitioning for rapid growing MySQL database tables.

Designed new schema for V 2 of the ultimatepoker software.

Troubleshoot database operating issues during production.

Setup MySQL backup plan for production system.

Built the ultimatepoker software package and troubleshoot for newly created reports.

Planned the MySQL master-master replication environment.

VISA, Inc Foster City, CA

MySQL Performance tuning/Migration Consultant May 2012—April 2013

Deployed MySQL Enterprise monitor on Solaris zone environment for VISA online gaming payment system, Playspan.

Mapped over 400 MySQL servers on the VISA Playspan environment in 3 different data centers .

Resolved production performance issues for MySQL database.

Participated the migration of Playspan into VISA's own data center, give recommendation for server design and configuration etc.

Setup MySQL backup for playspan production system.

Wrote shell/SQL/T-SQL script for collecting MySQL meta data for VISA security auditing.

Planned the MySQL cluster deployment for VISA/Playspan environment.

SK Telecomm Sunnyvale, CA

MySQL/PHP Developer Oct 2011—Feb 2012

Developed PHP/MySQL applications for a table reservation system for 360 panorama user interface application, Krpano.

Manage SVN java code for the panorama package .

Built and deploy the java code from China offshore team in local server.

Deployed joomla, drupal prototype for krpano applications.

Setup Ajax Demo for offshore development team.

Developed database/MySQL automatic backup/restore scripts, sharding plan, and frame work for database patching and version control.

Stanford Law school Stanford, CA

MySQL/PHP Developer Oct 2010—Jul 2011

Designed and developed custom ETL system to extract SEC text report file into MySQL database for text analysis using Perl and PHP. Single table sized imported/loaded to MySQL over 1 TB.

Wrote complex SQL/T-SQL query using regular expression to search extract text file in MySQL database.

Built the system using MySQL, PHP 5, to display extracted reports from MySQL database .

Extract SEC text report file data points with Python.

Developed drupal site from scratch for law school student three strike project from scratch using drupal.

Gap Inc. San Bruno, CA

MySQL/PHP Consultant Apr 2010—Jun 2010

Developed Gap Inc. Construction Operations division's internal reporting system.

Designed, built the reporting system with scalable flexibility for future expansion.

Built the system using MySQL, PHP 5, JQuery, T-SQL Json, Ajax, PHP pear. The reporting system dynamically generate metric list for report, automatically schedule running of the report, email automatically to groups.

Transera Inc. Cupertino, CA

MySQL/PHP Developer Sept 2008—Sept 2009

Developed Transera’s daily automatic CSV reports generation for clients like Office Depot, Logitech, AIMCO, etc.

Wrote SQL scripts to monitor data warehouse data loading process to find out data loading issues.

Developed custom in house monthly billing system using PHP 5/MySQL in Agile development environment.

Fixed MySQL database issues like performance glitch arise during Transera’s ISP migration.

In charge of the existing in house custom crystal report system for modification, change of data source for ISP migration, creating new crystal reports, etc.

Performed Database administration/DBA tasks on MySQL with InnoDB, MyISAM.

Apple Inc Cupertino, CA

Database Developer May 2008—Sept 2008

Developed Apple call/chat agents’ time management system and automating online agent chat reporting system using MySQL database and PHP

Wrote MySQL stored procedures with dynamic SQL to calculate agent login time and compare the login time with standard schedule to calculate agents time utilization rate, writing ETL code to extract data from oracle DB to MySQL.

Loaded agents’ chat logs excel and XML files to MySQL 6.0 database, and writing PHP code to display comprehensive agent chat reports for Apple.

Automating ETL process for the XML chat transcripts/log file download and loading process from Apple’s online chat vendor, liveperson.com.

Investigating and developing the automation process using RSS live feed process for the XML files.

Perform Database administration/DBA tasks on MySQL with InnoDB.

Project Goth/Mig33 Burlingame, CA

Database, LAMP Developer Jul 2007—Apr 2008

Debugged, re-designed, and improve ProjectGoth/Mig33’s Management Information System built on MySQL/JSP.

Setup the Development lab environment in Burlingame location for Mig33 using Redhat Centos 4.5 Linux, MySQL 5.0 and VMWare.

First stage design of the new data warehouse for data analysis, for all the data from chat room, and other data sources using star schema.

Investigate/Research Kickfire.com MySQL storage engine for Data ware housing.

Cleanup, import, and analysis online chat room log data to SQL server 2000, 2005.

Design/Adding/Debugging features of the in house MIS system using tools like JSP, Java, JSP, Eclipse, MySQL, etc.

Setup/Configure Drupal in the Dev lab, added PHP modules/Themes for the Mig33.com public website.

Writing complex T-SQL query for reporting, Linux Shell scripts for data migration and ETL process.

Provide design/improvement for the existing database schema.

Perform Database administration tasks/DBA on MySQL with InnoDB, MyISAM, like backup, restore, master/slave replication, etc.

Integrate Mig33 mobile application with facebook using the facebook connect PHP API.

Developing facebook connect application using the ZEND PHP frame work.

Otismed Hayward, CA

SQL Sever Database/ASP Developer Mar 2007—Jul 2007

Fixed and re-designed Otismed.com’s online database system with MS SQL server 2000, 2005 and classical ASP, T-SQL.

Added new features to the database system like online ordering parts, reporting, real time MRI image file uploading monitoring.

Re-designed and programmed the java image file/MRI file uploading module for the database.

Fixed many errors in the database, like customer, surgeon profile management, ordering system, inventory management system, etc.

Designed and developed the integration of online database with accounting software, peach tree, and FedEx shipping tracking system.

Architeced and programmed a simplified billing system.

Wrote store procedure to generate patient data sheet for MRI image processing software package.

Implemented the SSL/HTTPS protocol, security certificate for the online ordering, data uploading process.

Created a backup system for the online database.

Life masters South San Francisco, CA

SQL Sever Database Developer Aug 2006—Feb 2007

Designed and developed medical claims, pharmacy claims, member eligibility, and provider data processing/analyzing system for LifeMasters Inc’s new client, FORD Motor Company. Ford is very satisfied with the system and signed the contract with LifeMasters Inc as the result.

Wrote script/algorithm to data-mining disease information for FORD members from claims information.

Launched the new ETL process for LifeMasters, Inc

Wrote T-SQL store procedure to stream line ETL process, data loading process, DTS, data quality control, etc.

Helping the day to day process on claims and billing for LifeMasters, Inc’s major clients such as FL CMS, OK MHS, Atena, etc.

Programmed a simplified billing system for FL CMS (Government Medical Data system).

Performed DBA tasks on different cases.

Comcast San Ramon, CA

SQL server Database consultant Oct 2005 – Jul 2006

Designed and developed a web based Commission tool for Comcast sales force. The Commission tool greatly out perform the existing tool in speed, features, and functionalities.

Database Designer, Senior Database programmer, Tech Lead on a new online sales force commission management system. Perform DBA task for the database design and created.

Programmed store procedure to connect legacy system to new online, IIS and SQL server based sales force management system

Wrote T-SQL store procedure, triggers to calculate commission payment by different commission plan of different teams, like direct sales, sweep sales, and service center sales. With sales quota or with out sales quota, and also capable to set sales quota by individual sales person.

Designed and programmed a simplified HR profile management system what connected to the sales commission tool.

Architected a system which is expendable, scalable to Comcast nation wide corporate structure. The tool is flexible to deploy to different Comcast service areas.

Designed and build ASP web tool rich on chart, and data mining user interfaces.

Created and managed several development databases, acting as DBA for the development environment.

Support users/Comcast employee in early staged of the launch of the software tool, fix bugs and add new improvement on the software tool upon the request of the users, keep good communication and relationship with the users.

BISYS/Tri-Cities Brokerage San Francisco, CA

SQL Database Developer Aug 2005- Oct 2005

As one of the two member team to design and develop a browser based Residential Construction Risk Assessment system with ASP, CSS, SQL Server 2000 in two months. The project saved BISYS/Tri-Cities Brokerage from a major lose of the time and money due to the early unsuccessful venture.

Design, implement SQL server 2000 database for the system. Perform DBA and development task for the database.

Extensive use of T-SQL programming and stored procedures to interactive with the database, and ASP to perform the calculation of the risk assessment modeling, etc.

Using ASP and SQL server programming to produce a final assessment report which are rich with dynamic graphics and charts.

Design the front end/presentation layer of user interface, and integrate the front end/presentation layer with and Admin system smoothly.

Convert MS Access database to SQL server data for testing and redesign database structure and display of the website input form.

Bioinformatics.org Boston, MA

MySQL Developer Jun 1999-Present

PHP, Linux, Apache, MySQL, PostGreSQL

Participating the design and implement of the open source bioinformatics portal;

Setup Apache, PHP, MySQL on Linux, and PostGreSQL database and database conversion/migration from MySQL to PostGreSQL. Include MySQL database DBA and tuning duties.

Developing postnuke application with PostGreSQL instead of MySQL

Setup and configure, programming PostNuke on Redhat 9.0 Linux on PHP.

Setup and configure, customize drupal for content management system .

Design and developed a online member email database system using PHP, and MySQL database, with search, update, grouping structure, and other Database feature, specialize on object oriented programming.

Openevents.com Milpitas, CA

Developer/DBA/Founder Jun 2001-Present

Design and Developed an event searching/management portal website with ASP, ASP.NET, VB.NET, CSS, XML, SQL Server 2000, Visual Interdev. The portal is still state of art as of now, and out perform most current event portal in performance, cost, and functionalities.

Design, implement, and turning database for the entire website backend. Perform DBA task for the MS SQL server database.

Extensive use of T-SQL programming and stored procedures, created Microsoft Reporting Services, etc.

Feature of the website include zip code and distance search function of events, registration, event management system, sales force management system with ASP.NET.

Building a shopping cart with WML/ASP.

Building COM+ with VB.NET to setup automatic email system.

Using Visual Interdev/Visual studio as development environment to develop form and presentation layer during the whole project development period.

Building credit card payment system with paypal gateway/interface.

Developing the automation process using RSS live feed process for the event XML files.

US internetworking. Milpitas, CA

BroadVision Consultant Jan 2000-May 2001

Environment: HP-3000 UNIX, BroadVision 4.1, SQL Server 7.0, WinNT 4.0, Netscape 3.62, Solaris, Oracle 8.

Writing Custom cookie implementation for Luggage center Phase IB

Debugging BV Luggage center Phase IB database/DCC errors.

Trouble Shooting and wrote a login/redirect scripts for Home depot Ecommerce site (Online Store).

Wrote C-shell script for automation for HPshoppingvillage.com.

Installing/configuring BV 4.1 for HPShopping Center Phase II.

Rebuild, reconfigure BV 4.0 for Samsung Phase II and trouble shoot the configuration problems.

BV Boot Camp Training-AppDev 1, AppDev 2, System, Administration, Performance Tuning, Design Center.

Trouble shooting and solved gForce and Rockysoft NT server crash due to backup software.

Building a web based order forecast system for inventory forecast using JavaScript, ASP, and IBM DB2.

US Interactive. Brentwood, CA

Lead Database Designer/ASP Programmer/DBA Jul 1999-Dec 1999

Building the new, dynamic version of US Interactive corporate website with JavaScript, ASP, and SQL server 7.

Design and building the backend tool for the website administration, Duties include design SQL database, programming using ASP, DHTML, and JavaScript to access the database and generate dynamic HTML pages, and design a process to enable update, edit, and preview function of the website administration.

Investigate the feasibility of Vignette tool for website administration.

Daewoo Motor America, Inc. Compton, CA

Webmaster Jul 1998-Jun 1999

Setup/install/configure SQL server, maintain and perform SQL DBA tasks for live websever and development server

Guiding the structure design of the website, especially the ecommerce part of the website. Interface between web development team and different department of the company for smooth development of the website. Setup web server hardware and software for the website.

Provide programming methods for the web development team on key website feature (store locator, etc.). Writing MS SQL server T-SQL for the new website.

Developing a break through method for car buyer to apply credit and loan online. Develop a program to collect website SQL server data automatically to a text file and send to fulfillment house.

Daily maintenance of the website operation. Website update and improvement. Help developing a web parts-ordering system using Power Builder

Tempest Micro System Walnut, CA

Lead Web Programmer Mar 1996-Jun 1998

Environment: Win95, personal web server, IIS4.0

Design and program a website for the company for online sales.

Technical support for website and computer system by telephone. Trouble shooting for the computer system manufactured

Configure and install Shopping Cart (Cart32) on company website

Secure IIS 3.0 web server for credit card transaction by install Certificate Authority with SSL protocol, Setup secure credit card transaction with cybercast.

Building website using from page, HTML, Perl, and CGI, Microsoft Active Server Page.

Install Cisco Pix Firewall on the network

Design the structure of the website, writing HTML code, prepare graphic file with PhotoShop 4.0, implementing, and maintain the website.

Create Access database for RMA process.

Use Perl to write a search script for WebPages.

EDUCATION and TRAINING

Tennessee Technological University. Cookeville, TN. M.S.

oZhangjiang College. Zhangjiang, China. B.S.

oQuick Start Technology,

SQL server 2000 administration training,

Programming a Microsoft SQL server 2000 Database, etc.

oUCI Extension. Java Programming with JDBC

oUCLA. Bleeding-Edge Java

Professional Organizations

IEEE Computer Society Bioinformatics Conference organize committee

Cluster world super computing conference program committee

World internet center member

IEEE Life Science Society Committee Member

Contact this candidate