Clepsydra.
Online Timesheet.

The State News managers need a more efficient way to track student employees' time. The challenge of making a online timesheet was given to the web team at The State News.

graphic

Summary

Clep•sy•dra.

noun. klep-si-druh
1. An ancient device for measuring time by the regulated flow of water or mercury through a small aperture.

As part of the web team at The State News, I was responsible for programming and co-designing the project.

On the backend side, a in-house php framework, Foundry 6, was used for MVC, and a intensive amount of PHP date and time related functions were used for time calculation and conversion.

On the front side, the application uses Twig as the tempting engine, and utilized MooTool javascript framework for clock, Ajax, and other user friendly interface.

graphic

Employee Panel

The information central of your work life.

The main page of the employee panel give you every single one of your time card in one glance. Hovering the specific card will give you the start and end time of that card. The page accumulates as your work life in the organization increase. All timecard was stored in the database as the format of (id, timestamp_in, timestamp_out, user_id). eg.(5, 1306108680, 1306108680, 2). All calculations was made when the application load using php and javascript.

graphic

Say hi to your co-workers.

Other Users panel giving you the knowledge of who is currently working and how long they have been here for. No more yelling or building searching.

graphic

Administration Panel

All-in-one at a Glance.

The admin panel gives administrator the ultimate power all in one place.

The panel provides two viewing modes:
Under the Observing Mode, person with highlighted name are currently clocked in. Most common total hours are listed in columns after the name.

graphic

New user can be added by start typing in the bottom right "ADD NEW" box. A form will loaded through Ajax attach at the bottom of the table providing all the input for the new profile.

graphic

Under the Editing Mode, after click on employee's name, his or her detail time will be loaded into a table with search options on the bottom right corner through ajax, along with the profile on the left ready for editing. All the time duration was calculated on the fly using the basic timestamp that stored in the mySQL database, which is (id, timestamp_in, timestamp_out, user_id). eg.(5, 1306108680, 1306108680, 2).

graphic

Renewal Body Bootcamp.

Renewal Body Bootcamp is a boutique gym with customer mainly from the city. The new business needed a website to attract potential customers as well as managing a series of specialty classes with specific measurement.

graphic

Highlights: User Friendly Back End.

Class, Measurement, and Client Enrollment Management

Task: The client needed a way to create fitness classes and enroll members to the classes. Each class will have its unique list of measurements. The members that enrolled in the class will be measured before and after the class for the same measurements listed under that class. Each measurement contains name and unit two attributes. These measurements will be displayed in the members Progress panel when they log in.

Click & Edit Updating

From adding new program to changing program content, the client will able to update all information by click and edit. No separate page. No confusion. The detail button after each class will load all information about that class on the same page through AJAX/JSON. All information will be autosaved. No spending 30 minutes filling out huge form and accidentally hit back button.

graphic
graphic

Drag & Drop, Click & Edit Class Measurements List

The client needed a way to manage each class's measurements sequence and attributes that will be showed on the client's progress tab when they login. Each measurement have name, value, and unit attribute. A drag and drop sortable list made changing sequence a piece of cake on her end.

Enrollment & Individual Measurements: Finder Style & Auto Complete

The process is simple and intuitive. The first column contains all existing classes. Selecting the class will display all students that are enrolled in that classes in the second column. Selecting individual student to update their measurements in the third column. Typing the student name in the second column autocomplete box will enroll that student to the class. Autocomplete makes the process much faster. No looking up 5 pages of client names to find that last name.

graphic
graphic

Paypal, IE support, Google Calendar & Map, Word Press Blog, and Others.

Paypal Support

The client is able to setup Paypal for each class through the back end. The client generates the button code on paypal website and then copy & paste into the popup box to save the update.

graphic
graphic

IE Compatibility

IE 7,8, and 9 is fully tested and supported by the site. Html, css, and javascript hacks & tricks was utilized to support some of the animations and html5 elements.

graphic
graphic

Google Calendar & Maps

The site is integrated with google calendar and maps. The client is able to update the content through google's API.

graphic
graphic

Wordpress Blog

The site's blog section is power by Wordpress.

graphic
graphic

Fully Customizable Content

The site's backend is created from scratch and almost every content of the site can be modified through it. The client who had basic computer skill was able to maintain the site all by herself.

graphic
graphic

Michigan State University
Accounting Student Association.

Michigan State University Accounting Student Association is the biggest student organization in the Eli Broad Business College. The student organization need a clean and simple website that represents its professional nature.

rbc image

Summary

Clean. Simple. Professional. Delivered.

The Accounting Student Association is the biggest student organization in the Eli Broad Business College of Michigan State University. With over 150 active members attending around 10 meetings per semester, the organization need a clean, professional looking, and highly functional website. As a member of the executive board, I designed and programed the website from scratch.

As the business nature of the organization, the design was focused on simple, clean, and informative. White space, gradient, and multi-column was used to achieve the goal. The site is powered by LAMP.  960 grid system for CSS was used for clean markup. SQL query such as table joint was used to solve some of the business logic.

After maintaining and communicating about the website for two years, I was very honored to received the Outstanding Member of the Year award. Only one person of the organization is award every year and is presented by the MSU accounting department.

graphic

Clean & Professional Front End

Informative Home Page

The home page is a quick capture of all the latest contents of the site. It keeps the members up to date as well as provides a quick access to individual section with full and older information and documents. The three closest events that are later then the current date is automatically picked and summarized on the left. Viewers can also apply, downloading meeting documents, and R.S.V.P certain events.

graphic

Content Organization and Highlights

The rest of the site categories its content and presents its information in a chronological ordered list for easy navigation. Here are some of the highlights from each section:

graphic
graphic

Events

Under the Events tab, a colored tag is added by the site to separate passed and upcoming events so it maintains the chronological order of the entire semester's events as well as inform the upcoming events. PHP date & time function was used.

graphic
graphic

Pop-up Event R.S.V.P

R.S.V.P events can be registered through a pop-up event on the homepage. The red ticker update the number of people that have signed up in real-time.

graphic
graphic

Officer Biography

E-board members are able to update their own bio on the back end. Positions can be picked through the drop down menu. Once the position is picked, the sequence on the front end will be displayed according to the predefined SQL table through a table joint.

graphic
graphic

Photo

A javascript gallery plugin was used for displaying pictures.

graphic
graphic

Downloads

Presentation and minutes download.

Functional Back End

The backend that gets the work done.

The backend was wrote from scratch with each interface and functionality specifically designed towards each part of the front end. It made creating and updating contents fast and easy with minimum technical knowledge. The broad members can basically modifying every content on the site on their own.

graphic
graphic
graphic

Managing Events

Under the Events tab, a colored tag is added by the site to separate passed and upcoming events so it maintains the chronological order of the entire semester's events as well as inform the upcoming events. PHP date & time function was used.

graphic
graphic

Updating Officer Biography

E-Board members are able to update their own bio on the back end. Positions can be picked through the drop down menu. Once the position is picked, the sequence on the front end will be displayed according to a predefined table through table joint.

graphic
graphic

Uploading file

Presentations and meeting minutes can be upload from the backend. File's icon is added based on the file extension.

Michigan State University
Student Investment Association

Michigan State University Student Investment Association is the biggest student organization in the Finance Department of Eli Broad Business College. The organization needed a website to be the one-stop shop of all the recent updates about the organization. Online payment and member registration & management can also be overseen through the website.

graphic

Highlights

One-stop-shop home page.

Contains all the most recent information of the organization.

graphic

Clean form design.

Prospect members can register online and pay membership due through Paypal. All information were saved into database, which saved all the paper application and the hassles. Relevant information were grouped together for easy input. Drop down and checkbox was utilized as well.

graphic

Awards and the about page.

graphic

Events List

that come with a back end to edit it.

graphic
graphic

Résumé.

Yichao Wang

http://www.yichaowang.com

yichao@yichaowang.com

github.com/yichaowang

Outstanding
Member of the Year
2010-2011

“I am speechless! It is absolutely amazing! You totally exceeded my expectations on getting so much done in a small time frame... Absolutely blown away!!!”

B.A Information
System and Accounting,
Michigan State University (2007-2011)

GPA: Available upon request.
Reference: Available upon request

OBJECTIVE

Front-End Engineer where 4+ years experience of building pixel- perfection UI with responsive/high performance AJAX technology will add value.

SELECT ACCOMPLISHMENTS

  • Utilizing cutting-edge technology designed and developed 6+ online applications/websites from MySQL/PHP framework to jQuery/HTML/CSS and resulted in 100% happy clients.
  • Developed cross-browser website/application for start-up gym that generated over $10,000 online sale during the 3-day opening weekend.
  • Created websites/applications for multiple student organizations which tripled their membership and dues, and greatly improved operating efficiency and communication.

CAREER DRIVER

Taking great passion for enjoyable user experience and understanding of server-side technology to bring irresistible and high performance UI to reality.

TECHNICAL SKILLS

  • Advanced - Expert (#years): OOP JavaScript(3 years), jQuery(3 years), Git/github(3), JSON(2), HTML/CSS(6), HTML5/CSS3(2), Photoshop(5), TextMate(3), Twig-Tempting(2)
  • Intermediate - Advanced (#years): MySQL(4 years), PHP(4 years), Linux(3), CodeIgniter(1), Zend-Framework(2), Cross-Browser Development(2).

EXPERIENCE

About Me.

Life,

I continue to find my greatest pleasure in the work of creating than replicating, thus I code, design, and breath with passion everyday.

"I never did a day's work in my life. It was all fun." - Thomas A. Edison