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