Richard Huang

(***) *** - ****

ad36sk@r.postjobfree.com

**** ******* ****

Falls Church, VA 22043

EXPERIENCE

Library of Congress - Congressional Research Services (CRS) Senior Information Technology Specialist

March 1985 – December 2011

SAS Project

* Performed qualitative and quantitative statistical analyses using multiple disparate data sets from numerous sources to inform senior decision makers to improve TAP.

* Lead Library’s developer team to build web application from the ground up utilizing Base SAS and Macro.

* Involved in creating an application for the CRS Office of Finance and Administration, vital for its management of travel and training budgets, specification of feature requirements and estimation of level of effort.

* Experienced in cleaning, validating and storing data, creating reports, merging and updating datasets.

* Worked with a set of procedures in SAS/FSP used to perform full-screen, data query, update and entry.

* Worked with SAS/AP catalogs and applications written in SAS Screen Control Language (SCL), an object-oriented programming language used for data access and display.

* Collaborated with user experience designers to ensure intuitive behavior and adherence to the style guide.

* Developed shell script for automation of configuration management.

* Programmed person.scl, a screen control language (SCL) interacted with SAS programming. Programmed SAS code to create organization division’s personal grade, salary, and job title report using SAS statement Array, Retain, Link Headline, Macro &newpage, Macro &endfile.

* Developed and maintained system maintenance documentation.

* Successfully increased portability of existing SAS programs and created new programs using SAS macro variables to improve efficiency and consistency of result.

.NET Oracle and PL/SQL Project

* Worked through experience in data extraction and sorting from Oracle, 9i/Toad application.

* Used a multiple-row SELECT statement in PL/SQL to process many rows and declare and control explicit cursors, which are used in loops, including the cursor FOR loop.

* Implemented .NET project with C# Oracle application over Structured Query Language SQL including Stored Procedure and Function. Java Project

* Wrote Java programs as to process tables/records of the product count in Sybase database using Transact SQL.

* Applied JDBC an utility class to get datasource connection to extract data from Sybase database.

* Worked Java NetBeans IDE (Project Manager, Mounts, Web Modules, CVS Integration, Work Spaces, Debugger) for project.

* Utilized Constructors, Object & Classes, Loop Control, Arrays, Files and I/O, Exceptions, Inheritance, Overriding, Interface, and Packages for coding.

* Worked JSP development project, using NetBeans, CVS (Concurrent Versioning System) and SQLTags core is a generator that builds a JavaBean and a JSP tag for each table.

EDUCATION

The American University, Washington D.C. — M.S. Science in Technology Management, field of Computer System Application

1982

SKILLS

SAS Tools (Real time & Batch, Mainframe)

.NET

C#/Visual Studio/Oracle SQL and PL/SQL (Stored Procedure) Sybase/Transact SQL C Programming

Wang COBOL

IBM Assembler

IBM Operating System/Roscoe mainframe for SAS application project utilized Job Control Language

Java

JSP Development

(using NetBeans, Concurrent Versioning System (CVS) and SQLTags) Sybase Powerbuilder application development software (Sybase Adaptive Server Enterprise database Management system

Unix Operating System, Shell Scripting

Object Oriented Programming

PowerBuilder

Window : w_isis_request (C:\70 lbs\In Div\corewin.pbl) ETL with SAS

Contact this candidate