Professional Summary

• Experienced manufacturing/business data Software Architect and developer with core skills in developing Software using (2003/2005/2010)VB.Net, C#, VB6, C, Power Builder 6.0/9.0, ASP.Net and Sybase, Oracle and MS SQL 2000/2005 and extensive experience in developing windows based (Winform)software and recent web based (asp.Net) in financial, manufacturing for full software development life cycle.
• Architecting and building Manufacturing Execution System with detaileddevelopment of manufacturing ERP, real time simulation, and automatic process control using C# or VB.Net and MS SQL or Oracle database.
• Specializes in developing .net based Algorithms using numerical methods and statistics analysis such as SPC

Technical Summary

• .net WCF,WPF and MS Office automation.
• 2005/2008/2010 Visual Basic.Net/Visual Studio.Net; Visual Basic 4, 5, & 6.
• T-SQL/Stored Procedures on Oracle 9i and 2000/2005/2008 MS SQL Databases; MS SSIS and Reporting Service and legacy Crystal reports and .Net based crystal report.
• XML programming with .Net.
• Multithread Object Oriented Methodology in Software Design Using VB.Net/C#/C++, ADO.Net 2.0.
• Develop Enterprise Resource Planning Software Using C#, VB.Net, C++, ASP.Net/MS 2000.
• MS SQL Server 6.5/7.0/2000/2005
• Visual Studio.net and .net software technical training and documentation

Professional Experience

Confdiential, (Octobers 2011 to Present)

Senior .NET SQL Developer/Analyst

• Develop Purchase order Error resolution service using WCF/C# and Object Oriented .net programming
• Redesigning logistic receiving algorithm from receiving operation concept to Purchase order Entry
• Develop MS SQL 2008R2 for warehousing Purchase order Error resolution data.
• Develop ADO.net to Query DB2 Data Base for developing Purchase order Error resolution service.
• Develop Purchase order Error resolution by implementing WCF based service for retrieving data from DB2 and Datacom

Confdiential, GA (February 2011 to June 2011)
.NET SQL Developer-- Contract

• Developed advanced SSIS PO RESENT and ASP.NET based PO closure.
• Designed and supported dashboard- a web-enables UPS financial application using 3.5 and 4.0 version of VS.NET, MS SQL 2005, and Oracle 10 G.
• Designed, supported, and updated MS SQL database SSRS system and tables, SQL stored procedures and indices for new developed and existing programs.
• Developed MS SQL 2005 database based on MS SSIS Oracle 10 G-MSSQL data mining system.
• Developed .NET PO translation Scheduled Service.
• Developed SSIS in data table purging.
• Developed outlook adding for automation in PO FTP system.

Confdiential, GA (November 2010 to January 2011)
.Net Developer - Contract

• .Net developer/project engineer for second line defense project.

Confdiential,Corning, NY(October 2010 to November 2010)
.Net Developer - Contract

• Worked in the Catalytic Convertor Filling Material Plant as a.Net Developer for MES on parmark system.
• Used VB.NET, Windows Service, and MS SQL 2008.

Confdiential,Sparrows Point, MD (August 2008 to August 2010)
Blast Furnace Process Control Engineer/Developer - Permanent

• Support and develop Siemens VAI Iron making MES using .net technology and MS SQL/Oracle database
• Architected and Developed ado.net and VB/C#.net–base MES to Iron making operation and reports
• Supported data acquisition from Ethernet base Allen-Bradley PLC.
• Developed carbon footprint of Blast Furnace by extracting data from Oracle to MS SQL.
• ASP.Net/C#.Net web form to display data.
• Developed .Net executable files to be used by Power Builder.
• Developed C# base—Oracle Database engineering utility software for the support.
• Supported and programed Opto 22 PLC and Blast Furnace Level 2 Process Control.
• Configured Windows 2003 based IIS.
• Supported Blast Furnace Manufacturing Oracle database.
• Developed and Supported Level 2 Human Machine Interface (Power Builder).
• Supported manufacturing reports—Microsoft VBA. Reason for Leaving: Shut down facility

Confdiential,Marietta, GA (August 2006 to August 2008)
Energy Management and Monitoring Algorithm Developer

• Developed reports using MS SQL 2005 reporting service.
• Developed data mining algorithm from energy bill data using RDBMS and .Net technologies.
• Developed real time software in Energy Bill Management with concentration in customer site energy/area rates.
• Energy optimization using smart client simulation with multithreads advanced parallel processing.
• Major Achievement: Build an Energy Simulation system for Energy management configuration using OO.
• Rate analysis using numerical methods and .Net platform and ADO.Net data model.
• Developed multithread distributed SMART CLIENT System using C# and VB.Net.
• Energy Bill Rationalization and weather normalization software calculation algorithm design.
• Building EMS Control Extend Dynamic Simulation.

Environment: C#, VB.Net, ASP.Net, VB6.0/Access, MS SQL, DTS. C#/ADO.Net was used in establishing objects and methods for data connection and order entry was coded on the basis of OLEDB connection and datasets to MS SQL 2000. DTS of MS SQL2000 was used for data migration and cleaning

Confdiential,Taipei, Taiwan (September 2005 to July 2006)
Consultant

• Architect Consultant and development lead of ERP software for Entire company operation in Sales, purchasing, product return, inventory and logistic/supply chain operation. Taking all roles of project manager, software developer, Database administrator, technical training, network set up, software installation, and system tester.
• Major Achievement: Build a complete ERP for a major tile Distributor using ado.Net interface.

Environment: C#, VB.Net, ASP.Net, VB6.0/Access, MS SQL, DTS, C#/ADO.Net was used in establishing objects and methods for data connection and order entry was coded on the basis of OLEDB connection and datasets to MS SQL 2000, DTS of MS SQL2000 was used for data migration and cleaning

Confdiential,Taiwan (March 2003 to March 2004)
Technical Consultant

• Technical Consultant of numerous technology transfer committee.
• Developed projects in intellectual property using information technology software skill.
• Developed knowledge based service in technology transfer pre-packaging.
• Technical Consulting In NSC Technology Transfer Projects.
• Used ASP/VB Script/VB6/VB.Net MS SQL 2000 collect intellectual property data, perform data analysis, data mining for evaluating the effectiveness of technology transfer.

Confdiential,GA (January 1999 to February 2002)
Software Developer - Permanent

• Developed Data mining algorithms for Fiber treatment improvement. Application of Visual Basic/Access, Active Server page, and extensive Stored procedures, Microsoft SQL servers/Sybase Adaptive Server for Post Draw engineering data analysis study by using data mining and knowledge discovery methods. Tracked and calculated different fibers’ yields, break rate, and defect rates. Supported and developing different fibers manufacturing technologies. Teach internet base PL/SQL Oracle course.
• Developed Data Mining and Extracting Applications (DMEA) using Visual Basic 6.0 /ACCESS 2000/ Active X/COM/Stored Procedures. Built Rewind R & D Data Warehouse (RRDDW) of historic machine operating/fiber quality data for decision making and fiber operation trouble shooting using MS SQL 2000 DTS(Data Transformation Service) and Sybase 11.9.2 adaptive server.
• Developed On-Line Data Analysis Processing (OLDAP) application and reports using Visual Basic 6.0, Active Server Pages (VB Script and Java script)/WEB IIS, MS Access 2000/ VB.Net/ASP.Net on NT OS and Windows 2000.
• Data Model design using RDBMS- Sybase SQL 11.9.2, MS SQL 6.5,2000, Oracle 8.0, and Access 97/2000.
• Converted windows application to web/ASP/IIS based application.
• Enhanced the windows based application and ASP/Web based application by using Stored procedures on MS SQL 2000 and Sybase SQL adaptive 11.9.2.
• Administrated Weekly production report development and analysis.
• MS SQL Data base administration, support, backup/recovery and tuning.
• Developed software testing, training, support, and documentation.
• Engineered application of process problem solving by trend and critical factor resulting from DMEA, RRDDW, and OLDAP.
• Completed the project in D.P.O.E. (software for Lucent-Bellsouth power engineering project configuration) by using client-server technology with VB 6.0 as front end and Informix as back end database server. This is an order management system between Lucent Power engineering and Bell South. SQL was a major script. Crystal report 7.0 and VBA was the reporting tool. Worked on middleware, MQSI formatter, and project. This middleware is the data formatter between the legacy system and SAP. It is a GUI front-end application with backend in relational database. UNIX application on SUN is the primary environment. Used MS project for project management control.
• Several VB/Access applications have been modified and supported. Used PVCS engine based source code control tool called VSCC (Lucent Version Source Code Control) and numerous times in using Install Shield for software installation. MS SQL Data base administration, support, backup/recovery and tuning.
• Support and documentation of developed software. Use FTP in UNIX/Windows development. Program FTP in VB application. VBA on MS Word for order specification confirmation sheet.

Confdiential, GA (June 1998 to January 1999)
Information Technology Consultant

• Worked at ISB department of ODOT in MS SQL bridge database conversion and cleaning.
• Used VB 5 and 6, PB 5 and 6, and Web Page tools to generate bridge inspection and inventory reports. MS Access has been used as front-end report tools for reporting bridge information in SQL Server.
• Use Visual Source Safe for version and source code control. MS SQL Data base administration, support, backup/recovery and tuning

Confdiential, (June 1997 to May 1998)
System Process Engineer

• Responsible for the development and support of software in Production Material Tracking of Recycled Paper Deinking Mill by using Power Builder 4, 5, 6 as front-end (ICON) and SQL server 6.5 as backend database.
• Developed and supported Mill information system (MOLE) by using Visual Basic/Access as frond-end application and SQL server as back-end database server.
• Administrated and supported 24/7 on SQL server 6.5 for both MOLE and ICON databases
• Performed BCP to populate SQL database.
• MS SQL Data base administration, support, backup/recovery and tuning.
• Created the scheduled task on SQL server with the creation of batch files.
• Wrote the stored procedure to be used in Power Builder based software.
• Created the database device and dump device for backup and restoring the Database.
• Created data window using multiple tables in database editing SQL-Production Report by dates modified the window for broker selection or one recycled paper specific broker.
• Used embedded SQL for the creation of new products.

Education

Ph.D., Chemical Engineering