Post Job Free

Resume

Sign in

Sql Server, C#

Location:
Apex, NC
Salary:
80k
Posted:
July 26, 2023

Contact this candidate

Resume:

YELONG (ROBIN) CUI

*** ******* ***** **. ***/Fax: 919-***-****

Cary, NC 27519 Email: adyi8b@r.postjobfree.com

OBJECTIVE:

Data Analysis, Database/SQL developer, ERP system maintenance and customization, C#, .Net developer.

COMPUTER SKILL:

Operating System: MS-DOS, Windows, UNIX

Graphic User Interface: C#, VB.NET, ASP, Crystal Report, PowerBuilder, Power BI

Programming Language: C/C#,, JavaScript, HTML, XML

Database System: SQL Server, Oracle, DB2, My SQL, MS Access

EXPERIENCES:

Self-Learning 5/2023 – Present.

R, Python, MS Azure.

Senior Developer: 7/2012 – 5/2023, Loparex, LLC. Cary, NC

Gather business requirements, business flows, designing system or solution. Perform analysis on business problems, determine source and develop options.

Developed lots of SQL functions, stored procedures, views, triggers, jobs for SQL server and DB2. Done some DBA duties on SQL server. Developed lots of decision support and data analysis/statistics reports by Crystal report, SSRS, SSAS, Power BI on Databases (SQL server, DB2, Oracle, Progress); and integrate data from different system by SSIS (ETL), C# and Power BI. Implemented data modeling and data warehouse.

Developed Window service and applications (EDI, ACH, SOC, ShopFloor) by using C# that integrates with the company's ERP system (EPICOR), MES, QDMS. A key role for new ERP system (EPICOR) implementation.

Developed lot of BAQs, dashboards, BPMs, Epicor customization by using C#, progress 4g language.

Join SAP implementation team, manage role and users, EDI and IDOC.

Senior programmer and analyst: 1/2005 – 7/2012, AKG of north America, Inc. NC

Good understanding of the ERP System (Infor VISUAL system), Developed and maintained lot of applications to customize the ERP system that works greatly for the company no matter how the interior and exterior environment changed.

SQL Server develop expert:

Developed lots of Triggers, Stored Procedures, SQL server Jobs, Functions; and Queries, Views, Tables, Index, ETL/SSIS (SQL Server integration Service). Developed lots of decision support and data analysis/statistics reports by Crystal Report, SQL Server Report Service. Implemented data modeling and data warehouse.

Seven years of progressive experience in full lifecycle development within a Client/Server computing environment. Responsible for analysis, design, development, testing, configuration, deployment of manufacturer business software system such as EDI (electric data interchange), Data Trans/Flowing, Pricing system by SQL server, C#. VB, VB.net.

Software Engineer 9/1999 – 5/2004 ECtel, Inc. Clarksburg, MD

A key role develops then maintains and makes enhancement on ViewPoint System --- near real-time data presentation for data communication. Four years of progressive experience for development tools for this system include: PowerBuilder 5.0 to Powerbuilder8.0, Visual C++ 6.0, Pro* C, S-Designer 5.0, ODBC Lib and Net view, Oracle7.3 -- Oracle 8i, and PL/SQL. Developed lots of store procedure, functions, package, and dynamic query.

Six years of progressive experience in full, lifecycle development within a Client/Server computing environment. Responsible for analysis, design, development, testing, configuration, deployment and production support of the Communication Quality Service Software System. The tools used included Oracle 7.3, Oracle8i, VB, .Net VB, C#, ASP.Net, under Data-Centric networks environment running Windows NT 4.0, Window 2000.

Responsible for all the software package, products deployment by using InstallShield 5.0 to 6.2, Wise Installation5.0 to 7.0, and Package Utility.

System Engineer 11/1997-8/1999 Micro Solution! Inc. Landover, MD

Implemented and maintained the National Childhood Professional Recognition Application System which used the Front-end interface built by VB through ODBC to access the Back end (Oracle database). This system includes Candidate Service, Credentials Awarded, the Finance System (update invoice, debit and credit accounting including account receivable and payable for individual and organization)

Designed and developed a Mentor Mentee Program Application System with VB through all system life cycle, including analysis, design, coding, testing and implementation. This system provides keyword match and keyword search nationally.

Designed and developed company's web page with HTML and JavaScript on the client-side, ASP and VBScript on the server-side.

Modified Digital Imaging Watermark Import Utility to move image documents from Keyfile Digital Imaging System under the OS/2 environment to the Watermark System with SQL Server 6.5 under Windows NT 4.0 environment by using OLE Automation and system re-configuration.

Developed including mail label, letter, application form, financial analysis and data statistics with Crystal Report version 6.0/8.5 over 100 reports.

Research Assistant 09/1995-09/1997

Computer Science Department, Southeastern University, Washington, D.C.

Designed and developed a Bank Customer Management System using C++ through entire system life cycle, including analysis, design, coding, testing and implementation.

Designed and developed a Student Registration System in C by using Data Structure and Circling Two-way Link List with pointers.

EDUCATION:

SOUTHEASTERN UNIVERSITY Washington D.C.

M.S. in Computer Science, September 1997 GPA: 3.9

Honor: Dean's List, Honored Student (Magna cum laude)

YANGZHOU UNIVERSITY Yangzhou, P.R.China

M.S. in Biophysics, July 1990 GPA: 3.8

SOUTHWESTERN UNIVERSITY Chongqing, P.R.China

B.S. in Horticultural Science, July 1987 GPA: 3.7



Contact this candidate