Technologies .NET, OLE, COM, MTS/COM+, ADO, ODBC, ActiveX controls
Databases SQL Server (2008 R2/2010/2014), SQL Server Business Intelligence Development Studio (SSIS, SSRS, SSAS), SQL Server Data Tools (SSDT).
Operating Systems Windows (2000, XP, Window 7, Window 10)
Applications: Intuitive ERP system, Sales Force with Force.com
11/2009 to Current
Senior Database Administrator and ASP.NET DeveloperD4D Technologies － Richardson, TX
As a Database developer and Database Admin, provide support/enhancement for Intutive, a commercial manufacturing ERP software system and SQL Server 2008/2012/2014 backend.
Created complex triggers, stored procedures, DTS/SSIS packages, jobs, and notifications in SQL Server.
Create customized reports using SQL Server Reporting Services SSRS.
Migrated SQL Server 2000 databases to SQL Server 2008/2012.
This included converting database, Packages, jobs using SSIS.
Performing database monitoring and tuning using System Monitor, Performance Monitor and Tuning Advisor.
Performing Database backup/restore.
In order to keep the production database always available.
I design/developed the SQL Server back plan.
Participated the virtual server set up and testing, migrated the SQL Server and Intuitive app to the new virtual server.
In order to simplifies the AP process, I designed and developing the EDI process that integrated our ERP system with Wells Fargo Payment Manager, I worked with finance group gathering requirement, design and developed the Process that automatically generated the output payment records along with customer's address in the format provide by Wells Fargo to their system, this eliminated the manual process of print out each check and send it to the customers, also provides us all the advantages of using credit card for payment.
As Database/ASP.NET developer, designed and implemented various intranet Web Form applications using Visual Studio 2010 with SQL Server 2008/2012/2014 backend for internal users:
Product Traveler (ASP.NET/Visual Studio 2010/SQL Server 2008): Converted a paper based system used to track the manufacture and return of products to a web based application.
This application made the process completely paper less; provides a secure storage of history associated with products; Gives ability to analyze/search/report/print the history/status of any given item.
RMA Mill Data Collection (ASP.NET /Visual Studio 2010/SQL Server 2008): Gathered requirements, designed and developed an internal ASP.Net web application with SQL Server backend for collecting/analyzing and reporting of RMA data.
Internal Electronic Complaint System (ASP.NET/ Visual studio 2010/SQL Server 2008): Converted a paper based system to a automate system that essentially tracks the complaint process from start (in Customer Support) to finish (in Quality), and, allows user to keep a concise history of all complaints-including resolution measures.
And, it helps satisfy our quality system requirement for complaint handling, I was the one solely responsible from requirement definition, functional design specification, system design, coding and testing, this process saved company about 50,000 dollars in off-the-shelf software and customization costs.
Created a smart Material requisition form for Manufacturing (Excel/ SQL Server 2012): By using data link and various Excel techniques.
This Form completely automates the manual process of finding the part in a BOM, and type in all the subcomponents' information.
10/2005 to 12/2008
DeveloperWizeTrade Group － Plano, TX
Maintain and enhance various VB 6 client/server/N-Tier trading applications.
Convert existing VB6 applications to C# .NET applications.
Developed a Windows Service in C# that downloaded the holdings of all iShares (www.iShares.com) Equity Funds as CSV files; consolidated this data in an xml file which was uploaded to a remote server via FTP for consumption by various WizeTrade applications.
Member of a team responsible for converting existing VB6 applications to .NET in C# and their subsequent support.
Developed C# custom controls for the display/selection of time zone; reporting of system information.
Maintained and enhanced the following VB6 client/server/N-Tier applications with SQL Server backend: WizeTrade FOREX, WizeTrade COMMODITIES, WizeTrade OPTIONS and WizeTrade STOCKS.
Solely responsible for the Chinese localization/internationalization of WizeTrade FOREX, a VB6 application.
Responsibilities included requirements gathering, design and implementation of the localization/internationalization, testing and coordinating the effort with the translation team.
01/2004 to 10/2005
Senior Program AnalystCitigroup － Irving, TX
Responsible for developing and maintaining a N-Tier Delinquency Administration application using Visual Basic, ADO, Microsoft Access, SQL Server 2000 and Excel.
Designed and implemented a Delinquency Administration application using VBA, ADO, and Microsoft Access for CitiCapital's Dallas Call Center.
Developed the Mid-Ticket Reporting System using VBA and Microsoft Access for CitiCapital's LMG department.
Generated various reports for Delinquency Management Administration department using VBA, Access and Excel.
06/2000 to 12/2003
Program AnalystUICI － Dallas, TX
Design/implement and maintain Visual Basic 6 based N-Tier medical insurance applications using VB 6/COM/COM+/ADO/ODBC/SQL Server 2000 in Windows NT/2000 environment.
Responsible for requirements gathering/designing/implementing a new in-house application "Provider Data Mart" (PDM), which allowed users to manipulate (search, insert, edit, and delete) Claim/Provider/Network Schedule/Translation data.
Developed application framework, user interface, business layer and data access layer components in VB 6, utilizing COM/COM+, ODBC and ADO.
Member of a team responsible for rewriting an in-house Two-tier application (Premium Finance) to an N-Tier object oriented application.
Responsible for enhancing several in-house applications (Insight Bid & Policy, Maintenance, Customer Service and Reports) by adding new tables, forms, components and fixing existing bugs in these applications.
Designed and developed numerous VB 6 MTS components.
Developed database schemas including tables, views, relations, indexes and constraints.
Wrote SQL Server stored procedures.
Interacted with users to design feasible business solutions.
Based on requirements, produced detailed design documents along with estimates for individual assignments.
On a rotational basis, provided support to clients for business applications.
Effectively communicated with users, answered technical questions and resolved urgent requests.
Generated unit and integration test plans, demonstrating understanding of the required results.
Conducted and coordinated unit and integration testing.
Assisted the Project Lead by providing technical leadership and expertise.
Identified and communicated issues or risks with project deliverables.
Recommended possible solutions to project issues and problems.
Mentored junior developers providing them technical and process guidance.
Developed coding standards and procedures.
Reviewed and provided input on development standards, tools and best practices.
Developed middle tier components in VB 6 for Xfactory, a Manufacturing Execution System.
This software allowed companies to seamlessly integrate plant floor data collection systems with the Enterprise Resource Planning (ERP) systems, providing a complete Enterprise Product System (EPS) solution.
Designed and developed middle tier components, which manipulate data through OLE DB and ADO using VB6 and MTS.
Created SQL Server Stored procedures for middle tier components.
Developed and maintained ActiveX components using VB 6 in Windows NT environment and SQL Server.
08/1998 to 01/1999
Software EngineerNEC America Inc － Irving, TX
Responsible for developing ActiveX components in Visual Basic 5 for MatWorX 2000, a telecommunication application used for provisioning PBXs.
Gathered requirement specifications and designed components using Rumbaugh methodology.
Developed components in Visual Basic 5 using a wide variety of Microsoft and 3rd.
Party ActiveX controls.
02/1996 to 03/1997
Software AnalystIntergraph Corporation － Huntsville, AL
Responsible for complete life cycle of an object oriented user interface component developed in Visual Basic called "Queries" for GeoMedia, Intergraph's next generation Geographical Information System (GIS) application.
Used Rumbaugh methodology for object oriented design.
Implemented the component using OLE Automation in Visual Basic, which allowed the user to create new queries, edit existing queries and label/display the results of queries against various databases.
Performed integration/system testing by writing and executing Microsoft Visual Test scripts.
MS: Computer ScienceUniversity of Alabama － HuntsvilleComputer Science
MS: Civil EngineeringUniversity of WarwickUnited KingdomCivil Engineering
.NET, ASP.Net, Microsoft .NET, C# .NET, ActiveX, ADO, AP, automate, Automation, backup, Business Intelligence, business solutions, C, C++, Call Center, Chinese, client/server, COM, COM+, COMMODITIES, concise, Configuration Management, credit, clients, Customer Service, Customer Support, data collection, DTS, DBA, Databases, Database, DCOM, designing, edit, EDI, Equity, ERP, Enterprise Resource Planning, xml, Finance, FOREX, Forms, FTP, functional, Funds, GIS, insurance, Intergraph, Java script, leadership, Manufacturing Execution System, Access, Microsoft Access, C#, Excel, SQL Server 2000, Visual Basic 5, Windows, Window, Window 7, 2000, Windows (2000, Windows NT, Mill, MTS, Enterprise, Network, next, object oriented, object oriented design, ODBC, OLE, Operating Systems, DB, developer, PDM, coding, Project Lead, Quality, reporting, requirement, requirements gathering, Sales, scripts, Visual Source Safe, specification, SQL, SQL Server, system design, tables, telecommunication, Translation, type, user interface, Visual Basic, VB 6, VBA, Visual Basic 6, VB, VB6, Visual Studio