PROFESSIONAL SKILLS:

Software: MS Visual Studio .NET 2003, 2005 2008, Subversion, Sharepoint MOSS 2007, Visual Basic 6.0, Dotnetnuke Portal, Cold Fusion Studio, MS Visual Interdev 6.0, OLAP/OLTP, MS Office, MS Visual SourceSafe, MS FrontPages, Dreamweaver MX, DTS Packages, Crystal Report 8.0, and Business Objects.

Languages: HTML/DHTML, ASP 3.0, ASP.NET/VB.NET/C 1.1, 2.0, 3.5 4.0, AJAX/JQuery, ADO COM/DCOM DLL, CSS, XML, XSLT, JavaScript, Oracle PL/SQL, Transact SQL, SAS Programming, and VB Script.

Databases: SQL Server 2000/2005/2008, Oracle 8, MS and MS Access.

O/S: MS Server 2000 2003, Window XP, Window 7, and UNIX.

PROFESSIONAL EXPERIENCE:

Confidential

In charge of adding new features for METRO web reports. Rewrite SQL stored procedures to tune up web performance from more than 4 minutes to only 2 seconds. Web page get refreshed automatically every 2 minutes and update summary data report instantly. Utilizing ASP,NET, C , Jquery such as DatePicker, etc .

In charge of updating Metro Taxi Booking Weekly Report. Report gets populated differently according to different accounts. Columns will be added or removed dynamically according to account selected. The data displayed in the ASP.NET gridview can be saved to Excel spreadsheet upon one click of the Save button provided on the web page.

Confidential

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 Houston Chronicle 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, 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

Responsible for developing and maintaining Account Manager, which is the main in-house application developed and utilized by Apple to manage the activities of all the internal account requests. The type of requests included, but not limited to, requesting, updating, terminating, suspending and reactivating new and existing accounts and services such as email, phone, employee badge, SAP, iCloud virtual machines, proxy, etc. The technologies involved are Linux, Core Java, JSP, JBoss, JavaScript, JQuery, Spry, Oracle, HTML, and CSS.

In charge of coding and redeploying the mockup pages, which is the preview version of Account Manager, by utilizing PHP, JavaScript, Spry, HTML, and CSS. This needs to take new design and make it pixel-perfect to reflect the true look of the real version and imitating the data update result by implementing dynamic JavaScript functions.

Participated in integration testing and QAing for Account Manager and report bugs as needed.

Confidential

In charge of implementing DFE module an object-oriented Ajax image gallery carousel by utilizing ImgeFlow and Jquery into ART.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 art print , captiontop for displaying the current number of the centered image which is the focused art 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 art 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 art prints in JSON format in the container. If user select any framed art and click the art 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 art 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

Responsible for supporting and maintaining in-house software applications and web sites such as JobTrack, SRS Seagate Recovery Service web sites, Iomega Data Recovery web sites, Seagate eStore DIY software by AbleCommerce web sites, etc. Utilized Classic ASP, VB 6.0, ASP.NET/C 3.5/C 4.0, VS 2003/2005/2008/2010, SQL Server 2005 2008, HTML 4/5, XML, SOAP, Web Services, and JavaScript. Involved in projects such as upgrading AbleCommerce license, implementing a new Spanish version for Seagate Recovery Service website, and updating Cybersource client API for online Credit Card Processing.

In charge of designing and writing testing plans and schemas for users' test cases, composing detailed description of steps and actions users can do or should perform in order to validate and test the applications' functionalities, design specifications, and other requirements.

Confidential

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

Participated in complex SharePoint MOSS migration process of migration EDS Portals into HPIT's. Responsibilities included, but not limited to, modifying and running batch files written in VB Scripts and Window Scripts , converting EDS Domain Names into HP Domain Names, creating and restoring EDS SharePoint Portals in HP Production Sites, migrating and populating users for each distribution list group, unlocking new sites and sending notification emails, and wrote documentations for migration process. Utilized ASP.NET/C 3.5, VS 2008, SQL Server 2005, MS Office 2007, and SharePoint MOSS 2007.

Confidential

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

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.

In charge of running the monthly data processing at the end of each month to import sales data of previous month into the ScoreBoard system. Wrote stored procedures to automate the steps of running the existing monthly process which is very complicate and lengthy and traditionally run manually.

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.

In charge of creating the quarterly corporate newsletters. Worked closely with business user for UI and visual designs utilizing DHTML, CSS, etc. Assisted in writing and compiling documentations including, but not limited to, short users manuals, business and technical proposals of projects requested by business users, data dictionary, and Excel-based web query.

Confidential

In charge of a very complex and comprehensive in-house MyApp application's maintenance and development ASP 3.0/ASP.NET 1.1/VB.NET VS .NET 2003 , IBuySpy Portal, JavaScript, XML, Visual SourceSafe, Crystal Reports, FCKEditor, Infragistic Web Controls, and SQL Server 2000. This application is mainly being used by project managers to oversee all the internal software and applications installed or to be installed in the corporation environment. Project Managers can use this application to do the following tasks: approve projects online, assign people to certify, integrate, and deploy the approved applications, view the progress of the projects by users and by dates, and search workstations and users that has a particular applications installed, etc. Frequently worked with project managers and technical staff to resolve application bugs and add new features per requests.

Assisted in converting the in-house MyApp application from ASP.NET 1.1/VB.NET/IBuySpy Portal into the latest version of ASP.NET 2.0/VB.NET/DotnetNuke 4.3.2 Portal, utilizing the latest version of Infragistic NetAdvantage 2006 Web Controls, VS .NET 2005, FreeTextBox 3.0 Editor, SQL Server 2000/Sybase, DHTML, and CSS. Created some window application in ASP.NET/C in order to compliment the functionality of directory uploading.

Confidential

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. Once the Exception Group owner login to this site, the program will automatically detect the NT user login id and pull data from the SQL Server and list all the available Exception Groups owned by the user. This program will only allow the user to update the description of the Exception Group selected the other fields are for information display and not for update.