PROFESSIONAL SUMMARY:

• Develop Machine learning algorithm by using Fortran, C++, Java, Visual Basic, VB.net, C#.net and relational data bases, MS SQL, Oracle.
• IT Professional with experience in the architecture, design, and development of Manufacturing Execution System software with manufacturing ERP, real time simulation, and automatic process control using VC++, C#, VB.Net, MS SQL, Sybase, Informix, DB2, and Oracle databases within SDLC, Agile and Waterfall Development methodologies.
• Developed Analytic reports and HMI using Real time process/control data by .NET Framework (ASP.Net, C#.Net, VC++ and VB.Net) (version 1.0 to 4.5), as well as Crystal and Excel VBA report development on complex queries.
• Performed C# Socket programming and application modeling on process simulation and developed and tuned advanced SQL queries on various Databases: MS SQL, Sybase, Informix, DB2 and Oracle.
• Object Oriented Programming design (C#, VB, VC++) using design patterns (dependent injections, Singleton) through SDLC. Legacy software support and development with Fortran, Basic, Turbo Pascal, C++ and C.
• Excellent software trainer and mentor for both Chinese and English spoken skills and experience at different levels with great technical communication skillsets.
• Experience working with other technologies including WCF, Web Services, Java Multi - Threading, NetBeans, Visual Basic, T-SQL/Stored Procedures, Oracle, SSRS/SSIS, XML, IIS, MS SQL Server, WPF, Syncfusion and Fortran.

PROFESSIONAL EXPERIENCE:

Confidential, AL

Sr. Engineer/Process Automation/C++, C#, VB.net Developer

• Developed Complex Advanced SQL Queries to MS SQL to build Views and Analytic Reports by Excel and Crystal Reports using CRM Level 2 manufacturing real time control data. CRM Level 2 HMI support and development.
• Develop C# asp .net applications against Oracle 11.g, MS SQL 2008 using complex SQL ON CRM manufacturing Data.
• Gather business and manufacturing data requirements from data analysts and manufacturing engineers.
• Finish modifying 5 Crystal reports of CRM analytic reports, developed 30 new analytic reports in “Welder Health” to improve the CRM production and Self training of HMI development.

Confidential

Senior (.NET SQL) Developer/Analyst

• Developed Multi Thread Java Web Services for Order Management DB2/Oracle databases, developed MVC/ASP.net pages, used SSIS to migrate Oracle table to MS SQL tables and migrated Oracle Views to MS SQL views.
• Design and Development of Enterprise Application on Sales Purchase Order C#.net analysis Analytic.
• Project and development lead in WCF, database view VBA, C#.net purchase order monitoring projects.
• Develop Affinity to Buy Purchase order back end validation using C# 4.5/MS 2012/WCF, using Agile Methodology
• 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/Oracle 11gi and Query DB2 Data Base for developing Purchase Order Error resolution service. (PL/SQL and Stored Procedures). Develop Purchase Order Error resolution by implementing WCF based service for retrieving data from DB2 and Datacom. C# ASP.net and WPF(SyncFusion) on various relational databases Client-Server Application. Project Lead developer for on shore and off shore development team.
• Development using both Agile and waterfall methodologies.

Confidential

.NET SQL Developer

• Developed advanced SSIS PO RESENT and ASP.NET based PO closure.
• Designed and supported dashboard- a web-enables Confidential 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 (SSIS Oracle 10 G-MSSQL data mining system). Developed .NET PO translation Scheduled Service. Developed outlook adding for automation in PO FTP system.

Confidential, Sparrows Point, MD

Blast Furnace Process Control Engineer/Developer

• Architected, Design, and Lead developer in Developing ado.net/asp.net VB/C#.net - based MES to Iron making operation and reports. Design and Development of Enterprise Application on Manufacturing HMI to MES.
• Supported and develop Siemens VAI Iron making MES using .net technology and MS SQL/Oracle database.
• 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/win 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: facility Shut down

Confidential, Marietta, GA

Energy Management and Monitoring Algorithm Developer

• Developed reports (MS SQL 2005 reporting service). Design and Development of Enterprise Application on Energy optimization algorithms. Developed data mining algorithm from energy bill data using RDBMS, .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.

Confidential

Architect/Manager Consultant

• 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.
• Developed finished Tile distributor ERP System, Architect, Design, lead developer and project managing/Training, documentation. Design and Development of Enterprise Application on the Sales CRM and ERP of Title Sales distributors. Major Achievement: Build a complete ERP for a major tile Distributor using ado.Net interface.
• Front end User Interfaces are in Chinese Characters. Back end MS SQL queries use a mixture of Chinese-English
• The MSQ SQL database server hold data in Chinese characters

Confidential

Technical Consultant

• 100% Mandarin Chinese Spoken Work environment.
• 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.

Confidential, GA

Software Developer

• Lead developer in Developing MES, 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.
• Architect, design, and Develop finished post draw fiber optic manufacturing repairing rate and tracking system by using ASP web paged intranet hosting on IIS 5. Administrated and supported 24/7 on SQL server 2000.

Confidential, GA

Information Technology Consultant

• Worked at Confidential 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.

Confidential

System Process Engineer

• Responsible for development and support of software in Manufacturing ERP Production Material Tracking of Recycled Paper Deinking Mill (Front end: Power Builder 4/5/6 (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.
• Support and modified PowerBuilder/MS SQL 6.5 Material tracking HMI (Icon) Administrated and supported 24/7 on SQL server 6.5 for both MOLE and ICON databases