TECHNICAL EXPERTISE

• Programming and applications development, specializing in the use of Base SAS (Data Step, Macro Facility, Base Procedures, Output Delivery System).
• Development of relational database applications using SAS/SQL to extract and manipulate information from Oracle, Sybase, and DB2.
• Development of SAS programs in SAS Enterprise Guide 4.2.
• Development of SAS applications under UNIX and Windows XP.
• Working knowledge of data warehousing and business intelligence.

EDUCATION

• B.S. Economics.
• Graduate coursework in Econometrics.

PROFESSIONAL EXPERIENCE

Confidential, Washington D.C., Consultant, 2010
Developed a series of programs (in Base SAS under Windows) to support monthly valuation of the non-performing loan portfolio. SAS programs carried out monthly ETL processing as follows. Data was extracted from flat files representing multiple input streams of prices at the loan level. Subsequent to extraction, transformationincluded data aggregation across loan attributes, computation of UPB-weighted average prices, ranking of property state by UPB, and match-merging of results as summarized across multiple sources of input data. Subsequent to transformation, monthly aggregate data was loaded to a permanent repository in SAS. Subsequent to data load, SAS programs performed additional tasks that included data transposition and export to Excel to enable time trend analysis of model and dealer prices across a variety of loan characteristics (such as unpaid principal balance, loan-to-value ratio, months delinquent, property state, and modification type).

Confidential, Rockville, MD, Consultant, 2008-2009
Used Base SAS (Version 9.1.3) and SAS Enterprise Guide running on a UNIX server to develop a series of programs for the provision of statistical profiles of financial and operational risk for member firms within industry segment. SAS programs performed quarterly ETL processing as follows. Source data was extracted from numerous tables and schema comprising an enterprise Oracle database. Subsequent to extraction, data transformation included numerous table joins to correctly relate member firms, quarterly SEC filing events, and detailed financial information contained within those filings (income, assets, liabilities, net capital, and reserves). Computations included financial risk measures, relative risk scores based on percentiles, and overall rank based on risk. Results were loaded to a permanent repository in SAS. Subsequent to data load, results were exported from SAS to Excel for distribution to end users and were utilized in the planning process to target member firms for onsite audits and examinations.

Confidential, Washington D.C., Consultant, 2006-2007
Experience in Web development and production environments providing programming support with regard to monthly ETL and reporting processes that were run to track resources, obligations, and expenditures related to the Deepwater acquisition and modernization program. Such processes utilized Base SAS (Version 9.1), SAS Output Delivery System (ODS), and SAS Connect to generate HTML documents and multi-dimensional cubes that were uploaded from a database server to a delivery portal on the Web server. Performed upgrades to existing production programs so as to extract and manipulate detail and summary financial information from relational tables representing transactions and accounts in an enterprise Oracle database. Developed a series of programs to perform retrospective ETL processing as follows. For each of four categories of readiness (surface, aviation, people, and positions), data was extracted from a series of monthly, archived text files, verified, and loaded to a historical repository in SAS that was the basis for readiness reporting on the Web server.

Confidential, Bethesda, MD, Consultant, 2005-2006
Used Base SAS (Version 9.1) on a Windows XP platform to carry out tasks that included both ad hoc programming and the new development of production reports in support of the business areas of risk management, finance, and trading. Specific accomplishments included the development of programs to generate flagship risk reports that are run daily to measure compliance in the areas of securities portfolio size, age, and exposure to market risk factors. End-user reports were developed in SAS, exported to MS Excel, and formatted using Dynamic Data Exchange (DDE). Also worked with existing source code to acquire knowledge of ETL and reporting processes in SAS so as to modify, maintain, and improve those processes

Confidential, McLean, VA, Consultant, 2004
Performed a comprehensive review of existing source code in a series of Base SAS programs comprising a monthly process used to track and report on inventory activity related to REO properties. Prepared detailed technical documentation of the current process to be used as a basis for determining requirements in the rewrite and upgrade of that process.

Confidential, Dulles, VA, Consultant, 2003
Used Base SAS and SAS SQL (Version 8) on a Unix platform to rewrite a series of programs that comprised an e-commerce daily production system for the processing of online merchandising transactions, revenue, and costs (associated with orders submitted, cancelled, shipped, and returned). The programs were rewritten to improve system performance through conversion from SYBASE stored procedures to SAS. Also performed unit testing and quality control on the new system. System output in the form of database tables (SYBASE) serve as the basis for financial analysis, projections, and reporting related to AOL online shopping.

Confidential, Washington D.C., Consultant, 2002
Used Base SAS (Version 8) on a Windows XP platform to create programs for the import of health care cost data from survey responses stored in Excel. For each of two cost surveys, multiple SAS Macro programs were created and executed for each survey respondent to undergo processing from Excel to SAS across provider cost data, provider benefits data, site-specific cost data, and regional cost data (programs utilized Import and Export procedures as well as DDE). In addition to the program software, deliverables included SAS data files, hardcopy test prints, and a series of hardcopy exception reports. In addition, provided SAS programming to support the statistical analysis of total wages and hours reported by staff category in each of several health care cost surveys.

Confidential, Washington D.C., Consultant, 2001
Used Base SAS (Version 8) on a Windows NT platform to create, verify, analyze, and report on tax data for the support of revenue estimation and economic research. The tax data were from a variety of sources including: weighted samples of individual, corporate, and exempt-organization tax returns; sale of capital assets data (SOCA); the individual return match file (including forms W2 and 1099);and estate tax returns of decedents that were part of a 1040 panel. Deliverables included SAS data files and verification prints that resulted from the development of programs to read large tax data files in ASCII format that consisted of millions of records and multiple tax forms spanning several compact discs. Provided a series of detailed, customized, hard-copy reports that resulted from the development of source code to process W-2 forms in payee/payer groups; merge individual tax returns to W-2 forms by primary, secondary, and dependent social security numbers; and update existing W-2 forms to incorporate amendments. Performed ad-hoc programming to satisfy ongoing requests.

Confidential, Columbia, MD, Consultant, 2000
Used Base SAS (Version 8) in a Windows NT environment to enhance and augment existing source code for the analysis of charge and cost data by hospital, service line, specialty, and physician.

Confidential, Washington D.C., Consultant, 1998-1999
Performed SAS programming in a client-server environment under UNIX. For example, used Base SAS to develop a quarterly application for the pre-processing of input data to the Retained Mortgage-Backed Securities Cash-Flow Module. Pre-processing entailed data verification, aggregation, merging, exception and validation reporting, and the derivation of variables according to written specification. The pre-processing utilized raw data from the Portfolio Investment Tracking System (PITS) and Bond-Buyer fixed, ARM, quartile, and weighted averages files pertaining to securities issued by Fannie Mae, Freddie Mac, and Ginnie Mae.

Confidential, Dulles, VA, Consultant, 1997-1998
Developed and delivered a series of business applications (using Base SAS and SAS Macro in a client/server environment under UNIX) to support the analysis of online usage patterns of AOL customers, based on a monthly five-percent sample of the click-stream data (200 million observations). These applications generated a series of data files and management information reports to include the Channel Concentration reports, the PATHING reports, the Holiday Blitz reports, the Partner Demographic reports, and the Quarterly Usage reports. For example, the simplest of these reports, Channel Concentration, displayed the distribution of accounts across sessions-started for each of twenty channels in several different time periods.

Confidential, McLean, VA, Consultant, 1995-1996
Provided analysis and programming services (using Base SAS under MVS) to support business processes in the areas of Servicer Performance Management, Electronic Default Reporting, and Control and Management Reporting.

Confidential, McLean, VA, Consultant, 1994-1995
Developed and delivered (using Base SAS under Windows) a revenue-reporting system to generate, on a monthly basis, a series of corporate SAS data files and hardcopy custom-reports. The reports displayed monthly and year-to-date revenue for the current and prior years, including year-over-year comparative statistics. Revenue was reported by sales territory, sales rep, product line, and the top one-hundred customer accounts within sales division.

Confidential, Rockville, MD, Consultant, 1994
Developed and delivered healthcare-quality-assurance software (using Base SAS under MVS) with the functionality of providing the computation and reporting of statistical measures of healthcare quality, based on specifications of the NCQA(also known as HEDIS). For a given health plan, the software functioned to identify the eligible and recipient patients for a series of medical services, both preventive and treatment-related. The software then computed and reported rates of recipients to eligible patients at the provider-level, regional-level, and plan-level. The input data consisted of claims-level records for outpatients, hospital-episode records for inpatients, and health plan membership information for all patients.

Confidential, Arlington, VA, Consultant, 1992-1993
Designed, developed, and delivered (using Base SAS and SAS/Graph under MVS) an advance-bookings trend analysis system to run daily in an IBM mainframe production environment. The system functionality included : 1) processing an online report (transmitted daily from the reservation system) containing current-day bookings by flight date 2) updating a corporate data file with information on daily bookings by flight date for each of 35 days prior to the date 3) producing a daily report showing current and prior-year levels of advance bookings by flight date for each of 35 days prior to the date, including year-over-year comparative statistics 4) computing 7-day moving averages of advance-bookings by reservation date over a 6-month time period and 5) producing a series of daily graphs showing the moving averages, with each graph being defined by the number of days-in-advance a reservation was made.

Developed a SAS business application to process raw ticket data and boarding data to produce an audit report comparing levels of ticketed to onboard passengers by flight departure date, flight number, and fare class.

Developed a series of relational database applications (using SAS SQL and the SAS Access interface to DB2) that were migrated and run monthly in an IBM mainframe production environment. These applications processed a variety of detail and summary DB2 tables to generate corporate data in the form of both DB2 summary tables and hardcopy custom-reports. For example, one of the reports displayed the top O&D markets (within traffic region and route system for each carrier type) ranked by revenue in the current month, including, for each market, its respective rank in each of the preceding three months (a rolling four-month trend). Another report tracked agency revenue and market share by sales territory and district. The applications were developed for end-users in Market Planning, Pricing, and Sales.

Confidential, Washington D.C., Consultant, 1991-1992
Provided programming support (using Base SAS under MVS) in the area of financial management information systems. Responsible for the development, testing, and migration of source code to effect monthly enhancements and/or corrections to a single-family mortgage acquisitions data file residing in an IBM mainframe production environment. Developed methods and source code to enable existing monthly report programs to be run in a production environment. Developed SAS programs to satisfy ongoing requests for reporting using single-family mortgage acquisitions data at the loan, pool, contract, and seller levels.

Confidential, McLean, VA, Consultant, 1990-1991
Designed, developed, and delivered (using Base SAS under MVS) a customer-profiling system with the functionality of: 1) enabling online users to tailor a profile of the customer base using client and account characteristics (such as: division, region, program, product, activity, installation date, and total revenue) 2) processing the profile criteria to generate the subset as specified 3) computing cancellation and churn rates for that subset in a given month, based on both units(accounts) and revenue 4) displaying both the user-requested profile and the resulting summary statistics in hardcopy report format. Also developed programs to produce revenue-retention reports and activity- management reports, based on client, account, and revenue data. These applications were developed to support end-users in Corporate Customer Service.


Confidential, Washington D.C., Senior Programmer, 1988-1990
Provided programming support of a corporate contract for the evaluation of postsecondary education financing in the United States. Responsible for the development of SAS programs under MVS with an emphasis on tabular report generation using a series of survey data files. Data files used are the: National Post-Secondary Student Aid Study; Student Loan Recipient Survey; October Current Population Survey; and Integrated Post-Secondary Education Data System. (Client: Department of Education, Office of Planning, Budget, and Evaluation)

Confidential, Vienna, VA, Business Analyst, 1987-1988
Used SAS to design and develop a management information system for the on-line entry, storage, and reporting of waiver text pertaining to master and purchase contracts. Analyzed and wrote requirements for an automated financial system used to track data on commitments. Used data at the loan, delivery, contract, and seller levels to develop financial reports.

Confidential, Washington, D.C., Programmer/Analyst, 1985-1987
Responsible for developing mainframe computer programs using Base SAS under MVS to support the analysis of health care quality and economic policy issues related to the Prospective Payment System under Medicare. Experience featured processing the ten million-record PATBILL file using the SAS Point Option and providing the programming for numerous statistical and quantitative analyses, the results of which were displayed in tabular report format or downloaded as an analysis file. Wrote detailed program documentation and a portion of the proposal that resulted in the contract award. Work environment emphasized quick turnaround and direct accountability to client. Data files included: the 10.5 million record PATBILL file, the 2 million record MEDPAR file, the Annual Hospital Survey, the Hospital-Specific Provider File, the Medicare Cost Report, and the Area Resource File. (Client: Prospective Payment Assessment Commission)

Confidential, Washington, D.C., Staff Analyst, 1984-1985
Responsible for providing programming services to support the analysis of economic issues related to the merger and acquisition of large transportation companies. Clients included CSX, Norfolk Southern, and Union Pacific. Data files varied in size and structure to include the Census Bureau\'s 1.5 million record Commodity Transportation Survey.

Confidential, Washington D.C., Research Associate, 1978-1982
Analyst for a large computer-simulation model designed to estimate participation and payment levels for federal medical care, food and nutrition, and cash assistance programs. Provided technical input and control parameters, specified test cases, debugged the model logic, specified computer model enhancement, validated output results, and produced detailed documentation. Researched and wrote project reports and proposals, often requiring interpretation of detailed data. Tabulated large-scale census survey databases using SAS in a time-sharing environment.