SUMMARY:

• Self - motivated and easy-going, with more than 26 year professional experience in IT fields.
• Expertise include, but not limited to, web and app development (both front-end and back-end), application programming, ERP and CRM, and database analysis and management.
• Follow modular and OOP coding ethic . I am a quick learner and have good sense in following the latest web technologies.

TECHNICAL SKILLS:

Software: MS Visual Studio, Visual Studio Code, Git & GitHub, XAMPP, Node.js, NPM, Composer, WordPress, Subversion, Postman, MS Office, Dreamweaver MX, and Business Objects.

Languages: ASP.NET / C#, MVC 4 & MVC 5, Web Form & Win Form, LINQ, html 4 & html 5, JavaScript, AJAX / JQuery, Google Bootstrap, CSS, Classic ASP, PHP / Laravel 7, XML,Web API, Transact SQL, Oracle PL/SQL, Stored Procedures, Triggers, and VB Script.

Databases: SQL Server, MySQL, SQL Server Express, LocalDB/MongoDB, Oracle, and MS Access.

O/S: Window 7 ~ 10, MS Server NT, 2000 & 2003, and UNIX / Linux .

PROFESSIONAL EXPERIENCE:

WEB DEVELOPER

Confidential

Responsibilities:

• In charge of updating a wordpress site with memebership integrations. Tested more than 40 membership plugins to finally decided on implementing Paid Memebership Pro Free Version for the client’s official website at no cost at all.
• In charge of developing a PHP / Laravel 7 project for tracking and managing company assets such as camera sets and filming equipment, etc. Please refer to the GitHub Project PHP/Laravel 7 Section #1.
• In charge of coding IOT applications for controlling smart home system such as lighting, air conditioner, electric shades, etc, from pc and mobile devices, starting from scratch. Worked closely with firm engineers and hardware engineers for system and control commands transmission test and software integration. I’ve uploaded two main projects to GitHub, one project was coded using MVC 5 & Entity Frameworks. Another one is a plain Win Form Desktop application. Please refer to the above GitHub Project - ASP.NET C# Section - #2 and #3 respectively. Also include a Front-end RWD UI Design and functions project (please refer to the GitHub Project RWD Section #1) as prerequisite projects prior to starting the above 2 IOT projects.

Confidential, HOUSOTON, TX

WEB DEVELOPER

Responsibilities:

• Responsible for developing and maintaining EDB Portal Management, an in-house MVC web application mainly used by IT Managers and Customer Service Department to manage and verify the subscriptions of Confidential e-accounts. Created new customized right-click JQuery menu function to do the following tasks: verify iPad subscriptions; update iPad instrument id, send reset password email to user, verify iPad receipt, delete instrument id, etc. Will check the user access rights since some functions are limited to admin users only. The technologies involved are ASP,NET 2008, C#, MVC 4, WCF, LINQ, Entity Framework, Windows Azure Cloud, SQL Azure, Stored Procedures, JQuery, JavaScript, jqGrid, JSON, XML, Web Services (both SOAP & RESTful), HTML, and CSS.
• In charge of updating EDB Entitlement App, which is an in-house application mainly used in creating various Web Service calls (include both SOAP and WCF) for verifying and updating user accounts and subscriptions.
• Worked on updating and developing new features for an in-house Windows standalone application named Paywall Web Services Testing Utility. Created various functions to call web services written in EDB Entitlement app such as Get Product Token By either Email or User Id (response is retrieved in JSON format), reset user password, Get Active Subscriptions by either email or Id, Authenticate User Account, and Update User Attributes. In addition, add new functions to call a Rest Web Service and return response just like a Fiddler call. Utilized FiddlerCore library to achieve the same result in .NET.
• In charge of integrating the above Paywall Web Services Testing Utility functions into the EDB Portal Management app for enhancement. Utilized mainly JQuery ContextMenu (for the customized right-click menu functions), jqGrid, Tab functions, SQL Server 2008, MVC 4 and WCF.

Confidential, EMERYVILLE, CA

FRONT-END UI DEVELOPER

Responsibilities:

• In charge of implementing DFE module (an object-oriented Ajax image gallery carousel by utilizing ImgeFlow and Jquery) into Confidential .COM production web site. This is a combination of pure JavaScript/JQuery/AJAX/WebService/JSON, Classic ASP and ASP.NET 3.5/WCF project featuring scrollbar gliding, mouse wheel support, loading bar, image scaling, image size reconsolidation, captions (for displaying prices and Add To Cart links for each individual framed Confidential print), captiontop (for displaying the current number of the centered image which is the focused Confidential print in x/y format), ColorPicker (for displaying a color palette on clicking the color icon on the top right corner and select a color which will change the background color of the DFE module container for user to visualize how the Confidential print will look upon the selected wall color).
• Responsible for implementing Google Analytic Event Tracking feature into the DFE module in order to track down the users' behaviors online and send the web site client event over to the Google Dashboard for managerial report by category and by date.
• Responsible for redesigning the product page according to the new business specifications and requirements. For POD (print-on-demand) items, the price, product description, and DFE module will all be automatically reloaded dynamically accordingly by selecting the different size. Initially the WCF web service will call and load 15 framed Confidential prints (in JSON format) in the container. If user select any framed Confidential and click the Confidential image while this image is centered, then the image link will redirect the user to the new product page which will feature an enlarge image of the selected Confidential print on the top of the web page and reload the DFE module (only 14 JSON image or less will be loaded in the product page). The enlarged image also offers a zoom option to zoom the image up to 900px utilizing Jquery JQZoom and provides capability to magnify only a small part of the enlarged image. Modified and updated the Online Shopping Cart functions such as add cart, edit cart, etc.

Confidential, SAN FRANCISCO, CA

SOFTWARE DEVELOPER

Responsibilities:

• Responsible for supporting and maintaining comprehensive in-house Clinical Trial software applications such as IVR (Interactive Voice Response) applications, Web and Notification Modules, in-house Data Transfer applications and processes. Utilized Classic ASP, VB 6.0, ASP.NET/C# 3.5/VB.NET, VS 2003/2005/2008, SQL Server 2005, HTML 4/5, Ajax/Jquery, XML, and Javascript.
• Responsible for compliance to SDLC, encompassing traditional waterfall model, and adherence to quality FDA requirements for software and documentation under a comprehensive 3-tier architecture. The duties including, but not limited to, adhering to functional requirements in developing and designing Clinical Trial applications and processes, working closely with senior staff for perfecting the clinical trial software products, and supporting testing and validation staff in SDLC completion.
• In charge of creating and making modifications to SQL Server 2005 views, tables, triggers, and stored procedures, for adhering to the Clinical Trials business requirements.
• Responsible for coding C# applications for end-users to access and view data reports online. Those data reports are created dynamically and put in Excel format to enable user download. Users are also allowed to upload Excel spreadsheet to transfer data over online.

Confidential

WEB APPLICATION DEVELOPER, ATSONVILLE, CA

Responsibilities:

• Responsible for maintaining and developing a mobile application named Mobile Maintenance which is written in classic ASP. This application was designed to be deployed to mobile devices so farmers and inventory personnel can do data entry and track down inventory in the field without using a laptop. Also wrote comprehensive TSQL queries and stored procedures as needed.
• In charge of writing a comprehensive Chemical Tracking Maintenance project starting from scratch using VS 2008, ASP.NET / C# 3.5, Subversion, SQL Server 2005, Javascript, AJAX/Jquery and NUnit. Went through the full life cycle (SDLC) of this project including planning, requirements analysis, design, coding, unit testing, acceptance testing, and final implementation by applying Agile methodologies (Mock data method is being used for quick user review and coding turn around). This project uses various cutting edge technologies such as Ajax JQuery (including autocomplete, inline datepicker, validate, client callback, clockpicker, and thickbox), n-tier layered architecture (BO, Data Access and Presentation layers), Master/Content pages; Control tabbing, Web Method, JSON, Interface, and Web Service related javascript. User activities are logged.
• Responsible for QAing various projects by utilizing testing tools such as NUnit and TeamCity. Wrote test cases for applying unit testing on the layer structured projects including, but not limited to, Business Object Layer unit testing, and Data Access Layer unit testing. Also wrote functional test cases for validating application functionalities on the Presentation/User Control Layer.

Confidential, SAN FRANCISCO, CA

DATABASE DEVELOPER/WEB APPLICATION DEVELOPER

Responsibilities:

• Worked closely with ETL and data warehouse designers to begin a new full life cycle of redesigning CrossSell application and define the business logic and ETL data flow for completely migrating the whole ScoreBoard application to SQL Server 2005 ETL/OLAP/OLTP tools including SSIS (Integration Services), SSAS (Analysis Service) and SSRS (Reporting Services). Tasks included, but not limited to tiered Security Technical Specifications, Dimensional Data Cubes building, Application Selection Criteria definition, Data mining and drilling functional flowchart, reversed engineering of data table utilizing Visio and ScoreBoard Admin Tool Technical Specification.
• Responsible for maintaining and enhancing a comprehensive in-house web-based ScoreBoard Reporting application by utilizing ASP 3.0/ASP.NET/VB.NET/C# (both VS .NET 2003 and 2005), JavaScript, XML, ClearCase, and SQL Server 2000. This particular application is mainly being used by high-management business users such as Vice President of Wholesale Solutions Department, Senior Financial Consultants, and Senior Project Managers for data-mining and decision-making purpose. This application is designed for high management to oversee sales performance of cross-sell activities regarding packaged banking products as Home Mortgage, International Foreign Exchange, Direct Deposit, etc. Constantly working on tasks such as fixing application and data bugs and errors, troubleshooting, data upload, modify and write TSQL queries, stored procedures, DTS Packages, and add/remove/update accounting units per users’ requests.
• Assisted in developing and maintaining various projects for the Active Directory - IT Support team such as Data Mapping, Active Directory Data update and maintenance, and redesign and rebuild several existing web sites including Active Directory main site utilizing ASP3.0/Visual Basic/JavaScript/CSS/Oracle/SQL Server 2000/DHTML/CSS.
• In charge of the Exception Group update project utilizing ASP.NET/VB.NET/SQL Server 2000 and .NET Class modules, part of the Exception Group Owner self-maintain website.

Confidential

SR. WEB DEVELOPER

Responsibilities:

• Assisted in developing the online broadband pre-qualification process to enable customers to check for broadband service availability in their address. A simple GUI is provided on the Service Check web page, once customers enter the service type, phone number, address and press submit, the web page will be redirected into an invisible ASP page which will go through several VB Com+ DLLs to find and list all the available broadband services for the particular address including DSL, Cable, T1, etc. Also, the online service check info will be collected and written into the database so that the in-house sales will be able to do follow up sales calls.
• In charge of developing the ARPU (Average Revenue Per Unit) monthly report, a web-based internal online application. In the beginning of each month, a new comprehensive revenue CSV file will be put out and the ARPU application will be run to read the new CSV file, process the file line by line, and generate a new total revenue report in Excel format which will provide the column headings, and lines counted. Grouped subtotals and grand total are calculated dynamically, and a link for online ARPU report in Excel is also provided.

Confidential,Dublin, CA

WEB DEVELOPER

Responsibilities:

• Responsible for developing and maintaining the web applications for a leading on-line mortgage processing company utilizing Classic ASP, Java Script, VB Script, ASP Components, XML, IIS 5.0, MS Visual Interdev 6.0, MS Visual SourceSafe 6.0, and SQL Server 7.0. Assisted in both users’ interface cosmetic enhancement and database backend data processing via Internet including stored procedures and reports.
• Responsible for Business Object 4.0 Upgrade. Worked with the project manager for defining data modeling, business requirements and development methodology. Also created Business Object Reports and maintained the Business Object Universes build over the Oracle Human Resource Management & Payroll Processing Package.
• Worked closely with webmasters in developing and maintaining the Enron intranet by utilizing ASP, VB Script, FrontPage 98, Java Script, IIS 5.0, Access and Oracle 8.

Confidential, New Orleans, LA.

CONSULTANT

Responsibilities:

• Assisted in Account Payable, Project Controls, and MIMCOM (an accounting and inventory control package especially designed for mining companies.) by utilizing Business Object OLAP Reporting tools and Informix Stored Procedures.
• In charge of the Andersen HRIS System (the HR system designed by AC) Cash Balance Module reworking by utilizing Informix 4GL programming language. Modified and maintained the 4GL codes of the whole Cash Balance module including menus, forms, screens, and reports. Also assisted in MetLife Life Insurance Remittance Tape Creation Reports and Transition Reports by using both Informix 4GL and Business Object.
• Participated in reengineering of the SLIMS Project (Sulfur Logistic Interface Management System) - the Freeport Sulfur Redelivery and Sales Information System. Responsible for writing Informix 4GL codes for the nightly batch processing programs which will load the data from flat ASCII data files send by five different terminals into the holding table, process the data, do the error checking routines and reporting. Also in charge of writing the UNIX Korn Shell scripts for running the batch programs. Assisted in creating error reports by using Business Object.

Confidential, Parsippany, NJ

ASSISTANT PROGRAMMER/ SALES ASSISTANT

Responsibilities:

• In charge of coding and maintaining a complex inventory management CRM software targeting small businesses such as importers and wholesalers by utilizing
• Also a ssisted in customer services and w orked closely with end users to identify their needs and customize the package to fit their needs.