Hong Zhang

*** **** *** ***.

Green Brook, NJ *8812

(Tel):908-***-****

e-mail:acyq62@r.postjobfree.com

Summary

A Senior developer possessing near 20 years of experience on a variety of platforms in computer IT industry. Expertise including design and development of variety of applications, data analysis, reporting, data management, data profiling and data validation. Experienced with SAS/BASE, SAS/GRAPH, SAS MACRO, R, SQL, C/C++, UNIX shell and JAVA. Worked on large databsets on UNIX and LINUX environment. Also experienced with The database system SQL Server, Oracle and Sybase SQL Anywhere. Obtained a bachelor degree of Applied Mathematics and two master degrees, one in Computer Science and one in Electrical Engineering. Good at playing a lead role in a project team and has good communication skills. Skilled in trouble shooting complex problems. Hard-working and self-motivated.

Technical Skills

Languages: SAS, R, SQL, C/C++, UNIX Shell scripts, AWK, Perl, JAVA Script, JAVA, ASP, HTML, DHTML

Software: SAS V9.4, SAS Server, Powerbuilder, X-Window/Motif, MS Office (Access, Excel, Word, Outlook, Powerpoint).

Database: SQL Server, Oracle 8i, Sybase SQL Anywhere, MS ACESS.

Platform: Windows, UNIX, LINUX.

Experience

Mathematica Policy Research, Princeton NJ 06/2005-Present

System Analyst

Working on multiple Policy Survey/Research projects. Development and debugging of SAS/R programs for statistical analysis reports, data dissemination, series data processing, data cleaning, file merging, edit check, data exchange from SAS to other resources, Ad-hoc requests of data analysis, etc. Worked on complex projects from design, implementation, coding to QA the processes in all of the assignments.

Achievement:

Created Statistical Analysis Reports:

1.Create the complicated statistical reliability reports that calculate the kappa coefficient and intra-class correlation for measuring the agreement of regular coders and standard coders in video coding for survey researchers. The process was automated to generate Kappa and ICC by rater and by variables. These reports were first time created in survey division.

2.Created statistical analysis reports of calculating p-value of t-test and/or chi-square test, count and percentage of categorized feature by study group or response rate for research final reports.

Statistical Analysis Programming: modeling, weighting and propensity score matching.

Data Dissemination

1.Developed a drill down frequencies reports from SAS which dynamically create one-way, two-way or multi-way frequencies with drill down on each data cell to provide project a quick and easy way to investigate the data behind the scene. The paper of drill down report was accepted by 2009 SAS Global Forum and presented at this international conference. The approach and idea was widely used and applied to many situations within and outside the company.

2.Created standard, customized status reports, released reports, coding reports, response rate reports, Quality Check’ reports, progress report breakdown to sub categories and ad-hoc reports.

3.Developed faculty information sheets for a rating survey. The sheets were generated in institution level. Each sheet displays school information, school programs and faculty information. The process get information from different resources and link them together. The process was automated to create more than 200 sheets. The whole information sheet was required to be created in html format and has to be inserted into database in one filed of the table.

Data Exchange between SAS and Other Systems or Resources

1.Dynamically created excel workbook with multiple worksheets in formats/styles from SAS datasets. Automated the creation process for several hundred excel files.

2.Write html code from SAS program to dynamically generate several hundred html files with complex and heavy formats/styles.

3.Dynamically insert 2000 html files into database. One file goes to one data cell.

4.Programmably setup the header, footer of printed page when populating data from SAS to excel sheets; rotate column header 90 degree; repeat column header at each page.

5.Dynamically read multiple excel files with multiple sheets in each. Automated the process to read several hundred files in one process.

6.Created reports, tables and listings in HTML, EXCEL, RTF, PDF and text formats.

7.Read data from SQL server database, access database to SAS and write data from SAS to SQL server database and access database.

8.Collected data from different data source with different formats (excel, access, text), transferred the data into SAS, generalize the data to standard layout, data format, data type.

9.Read survey data from web, telephone interview and data entry software.

Data cleaning and coding for every survey projects. Conducted edit checks, range checks, consistency checks. Extracted some verbatim questions from survey data for coding and updated the original data by using the coded value.

Use SAS/SQL to manipulate data, calculate and create new tables/views.

SAS/MACRO is heavily used in process automation and frequently used functionalities

Project Management

In survey projects, served as a lead from Information Service department. Responsible for coordinating the work cross the IT groups, designing the processes, providing technical inputs to the project, overseeing programming work, solving complicated and challenged technical issues.

ENVIRONMENT: SAS 9.3/ 9.4, BASE SAS, SAS/STAT, SAS/MACRO, SAS/SQL, SAS/ACCESS, R, SAS Server, SQL Server, MS-EXCEL, MS-ACCESS, Windows 7.

Papers, Publications, and Presentations

Zhang, Hong “Migrating from SAS 9.3 to SAS 9.4: SAS communicating with MS Office Products”. Paper was accepted and presented at 2016 SAS Global Forum, Las Vegas, NV, 2016

Zhang, Hong, Ronald Palanca, Mark Beardsley, and Barbara Kolln. “Building Drill-Down Capabilities Dynamically in SAS Output Using Base SAS.” Paper presented at the SAS SUGI Global Forum, Washington, DC, 2009.

Dendrite International, Inc., Morristown NJ 03/2000-07/2002

Senior Programmer/Technical Project Lead

Dendrite is software company concentrated on sales force automation products for pharmaceutical industry.

Responsible for implementation, configuration, integration of Sales Force Automation applications for pharmaceutical companies. Mainly developed business rules and web pages by using C/C++, ASP, DHTML, JAVA script and VB script. The backend development work and performance tuning are done by using PL/SQL on Oracle to support the front work. Centered database is Oracle on UNIX and local database is Sybase on Window NT.

Providing in system customization, on-time and accurate programming for all assigned projects with consistent quality control and quality assurance. Also assists with system maintenance, ensuring that Dendrite's internal systems continue to function properly.

Managed the project through completion which included: preparing the project plan and Implementation design document based on Customer Requirement Document, monitoring team progress against plan, coordinating between team members, assigning the tasks to team members. Provided technical guidance to the projects. Resolved complex problems. Created unit test plan of the system.

Got a 'Quality Recognition Award' in recognition of my extraordinary contributions to the project from Dendrite.

Finished the project on budget and in a shorter time than estimates. Save company one month time.

Finished the most critical and difficulty module of the application in one product development. Without that, product cannot be pilot.

Environment: C/C++, PL/SQL, Oracle8i, SQL Plus, SQL Loader, Sybase SQL Anywhere, JAVA Script, DHTML, ASP, UNIX shell, Windows 2000, Windows NT 5.0.

AT&T, Piscataway NJ 01/1997---02/2000

Software Engineer (Consultant from Horizon Computers, Inc.)

Involved in the forecast project. Performed data analysis by using SAS to generate reports, tables, and graphs submitted to business department for decision making. Extracted data from Oracle database. Used SAS SQL and Macros to automate data processes and report generation.

Involved in Data Service project, which contains Data Bookclose Revenue and Volumn, Data Services Data Mart and Global Venture. We deliver official bookclose revenue and volume results and data service order weekly report

My work includes development for data integrating, data assembly, data auditing and data analysis by using UNIX shell language, AWK programs and ORACLE database.

Involved in BRPP(Business Results and Planning Platform) project which reports business analysis results and provides the information to business or marketing people. Responsibilities include data assembly by using shell scripts and AWK programs, Y2K programming by using C/C++, and web maintenance by using HTML and shell script.

ENVIRONMENT: SAS/BASE, SAS SQL, SAS/MACRO, UNIX K shell, AWK, Oracle, PL/SQL, C/C++, and HTML,Perl.

Laursar Communications, Inc., Dover NJ 03/1996---11/1996

Programmer/Analyst

Responsible for developing of a newly designed software communication system. The system provides information for users through Annex and TV channels from a Resource Server that is a workstation. This system receives the users' call-in from a terminal or a TV with a LCT (Laursar Connection Terminal) which is a hardware box connected with phone line, and sends back the information to the users. The application at the server side performs the following tasks: 1. Retrieve the information and store it in the Oracle server; Format and transfer information to the users. Involved in implementation, debugging and testing the following parts--user authentication, menu system, file interpreter, network communication, data encoding and decoding. The code wss done by C.

Developed a windows application which is to load games from Sega channel and save to PC. My work is design, code, and test. The GUI was developed by PowerBuilder 4.0.

Responsible for the development and maintenance of a GUI forecasting application. Design, coding, debugging and testing. The forecasting package is a client-server application which is based on a proprietary algorithm, using linear/non-linear programming methodologies. The front-end is done in PowerBuilder 5.0 and calculation package is developed in C.

ENVIRONMENT: UNIX, C, PowerBuilder, SQL, Oracle 7.3.2, Pro *C, Windows NT 3.0.

Audio Video Technology, Pte. Ltd., Singapore 08/1993---01/1994

Software Engineer

Implemented, debugged, and maintained the software (enhancement and modification) which is "Highway Emergency Telephone System". The software functionality includes user interface and data communication between control center and telephone system.

ENVIRONMENT: C/C++, DOS.

EDUCATION

MS Computer Science---The City College Of New York/CUNY, 1994-1996

MS Electrical Engineering---Beijing Institute Of Technology, 1986-1989

BS Applied Mathematics---Beijing Institute Of Technology, 1982-1986

Contact this candidate