Offering

• BS in Computer Information Technology.


• Advanced level of experience with the SAS System using Base Procedures, FREQ, TABULATE, MEANS, UNIVARIATE, Index Processing, Graph, Perl Regular Expressions, Macros, Data Step, DDE, SQL, RANK, EXPAND, UPLOAD/DOWNLOAD, IMPORT/EXPORT, Access to Oracle, Teradata, Netezza, DB2 and PC files, Output Delivery System(ODS), SCL, SAS/IntrNet, Customer Relationship Management, Campaign Management, Data Validation, Data Cleansing, Data Mining, Extracting internal/external data, using formats and informats including cleaning and validation, Reporting, Web development with SAS and custom programs generating HTML.


• Experienced at real-time/on-line capturing and analyzing system metrics in SAS. Written programs for the following: Load file and directory information, Load user access timing, Load and analyze Web logs, Load and analyze SAS logs including the capture of timing output. Several UNIX specific programs including 'du', 'df', 'last', 'who', 'finger', and 'ps'


• Working experience in the use of FTP, UNIX scripting and automating processes, Perl, CuteFTP, TextPad, Winzip, CSE HTML Validator, Web Browsers, Excel, Word, Access, JavaScript, VB Script, Visual Basic.


• Using custom ETL practices we will bring together your in-house and third party data sources into a useable manageable data warehouse


• Exchange data with Excel spreadsheets to provide real time updating for pivot tables, charts, and graphs


• Clean and build data in support of model development


• Create applications that build modeling sensitive variables


• Provide a high level look at a data source by providing summary and unique values reporting for all variables


• Develop programs using macro processing capabilities that allow for modifying execution logic


• Create reports using ODS for presentation quality


• Interface Email with reporting for web deployable display


• Develop applications to your specifications using the full complement of the SAS System procedures and data step processing capabilities


• Develop applications that access and update your third party databases


• Mentoring for your developing staff


• Build real time and static web pages for your reporting needs


• Audit and update your existing code with an eye towards efficiency

Experience History

Company
Location
Dates

Project Accomplishments

Blue Cross Blue Shield
(Boston, MA)
December 2011 - Present

Making modifications to existing programs to update them for business rules changes. Accessing the Netezza database appliance via SAS to generate multiple reports. Using Perl Regular Expressions to facilitate masking selected diagnosis code from sensitive reports.

Wells Fargo Home Mortgage
(Minneapolis, MN)
April 2010 - September 2011

Developed analytical datasets for registering in SAS business intelligence cubes. Developed datasets for general user access via online web links. Developed application based on tracking mortgage servicing data on a daily change basis. Mentor other team members to build greater knowledge in the SAS community within Wells Fargo Home Mortgage. Developed ad-hoc reports and research anomalies in data delivery. Developed DDE programs to create and update Dashboard Reporting for Management. Combine multiple formats into a SAS dataset for analysis(ETL). Created daily datasets of new workout loans and decisions made. Limited Business Objects development with loan based data. Used SAS Add-In for Excel for analysis and validation. Built cubes with loan data summaries for general viewing. Created management dashboard using summaries and detail coding for automatically creating data panels.

Texas Education Agency
(Austin, TX)
February 2011 - May 2011

Extract and clean data from excel spreadsheets to cross match name and address information from SAT and ACT testing agencies. Create reports with matched student information from each of the two agencies.

SunTrust Mortgage
(Richmond, VA)
February 2008 - March 2010

Support the forecasting/modeling effort by extracting and combining data from various data sources. Review and re-write existing code for efficiency. Implemented lookup tables to speed up processing. Utilized SURVEYSELECT and RANUNI for random data selection and analysis. Perform data validation and cleansing while developing analysis datasets. Develop model scoring code for historical and current data that generates tabbed Excel spreadsheets using ExcelXP Tagsets, Import/Export, DDE, and direct Libname access. Create charts and graphs of variables of interest for management review. Developed an automated validation process to create unique occurrence table for each dataset and aligned old and new data side by side. Created web based reports in support of model development. Setup UNIX directory structure and transferred existing SAS programs and datasets from Windows to UNIX making appropriate program changes. Created web based application using Apache as a proof of concept for future web development. Developing multi-platform processes to utilize both Windows and UNIX servers.

Nestle Purina
(St. Louis, MO)
January 2007 - January 2008

Member of a team that converted SAS programs and datasets to integrate with SAP. The conversion included deleting, adding and changing the formats of selected variables. Data validation and cleansing was done during the ETL process. Heavy use of macros, SQL, and base SAS programming. Utilized indexes and table lookups to speed up processing. Used simple Excel tagsets to create spreadsheets. Additional development work was performed to create a monitoring and validating process for promotional sales. Developed an automated conversion and validation process to assist in making formatting and data changes.

Railroad Retirement Board
(Chicago, IL)
May 2007 - August 2007 (Remote part time)

Made modifications to PC and Mainframe SAS programs that were being transferred from IDMS to DB2. Changed Mainframe SCL programs that generated HTML output.

Wells Fargo Home Mortgage
(Des Moines, IA)
July 2006 - December 2006 (Full time)
January 2007 - March 2007
(Remote part time)

Worked on the financial data mining and data-modeling project. Created datasets in support of developing Basel II compliant models. Utilized ETL and Sub-Setting datasets for generation of reports and graphs. SAS procedures used include SQL, GPLOT, GCHART, FREQ, SUMMARY, SURVEYSELECT, DOWNLOAD/UPLOAD, IMPORT/EXPORT and FORMAT. Performed data cleansing during loading and validation.

Boeing Shared Services Group
(Oak Ridge, TN)
August 2005 - June 2006

Participated in the planning and successfully executed a migration from an IBM/VM CMS system to MS/Windows Server. Used VM directory output as meta-data input to SAS code that automated the transfer of over 425 User ID's with more than 52000 files. Included were 170+ users with over 4800 SAS datasets that were CPORTed, FTPed and CIMPORTed. Modifications were made to all programs for the new environment. High profile applications were then modified to provide output in a web based form.

Wells Fargo Home Mortgage
(Des Moines, IA)
April 2004 - November 2005

Financial data mining and data-modeling project developing Basel II compliant models. The Risk Management Project Team focused on developing "Probability of Default", "Repurchase Exposure", and "Loss Given Default" models to assist in identifying loan profiles that might fit into these categories. My responsibility included extracting, transforming, and loading datasets with basic modeling variables for each loan segment type and generating initial discovery reports and graphs. In addition I added several model specific variables based on requests from the modeling team. SAS procedures used included SQL, TABULATE, MEANS, FREQ, GRAPH, DOWNLOAD, UPLOAD, UNIVARIATE, RANK, EXPAND and FORMAT. Economy.com data was downloaded as CSV files and transformed into FORMATS for Housing Price Indices, Historic Interest Rates, and various loan types and lengths. LGD development required several excel worksheets to be loaded into SAS datasets for conversion into Formats or Lookup tables. SAS datasets were created with indexes for fast processing of unique keyed items.

Eckerd College
(St. Petersburg, FL)
February 2004 - February 2004

This was a data recovery and reformat project. An Associate Professor at Eckerd College contacted me with an urgent plea to assist him in recovering some data that was only available in a Word document. The data had been loaded into SAS datasets and reports were generated. The data was recovered from the reports in the Word document. In addition the data needed to be formatted for import into SPSS. This was accomplished by exporting the data to an Excel spreadsheet.

Hewlett-Packard
(Houston, TX)
January 2004 - February 2004

As a member of the Enterprise System Group, I developed an Oracle and SAS Data Architecture for Data Mining Projects. Data were extracted using SQL from Oracle and MS SQL Server. Some data were received in Excel spreadsheets and imported into SAS. Using SAS Enterprise Miner and Clementine, a Warranty Fraud Detection System was implemented. Service Providers are periodically analyzed for any activities that might appear to be suspicious. With SAS and/or Clementine further statistical analysis is performed to determine if an audit should be scheduled with the suspect provider.

Zale Corporation
(Irving, TX)
June 2003 - November 2003

As a member of the Database Marketing team I provided SAS Consulting and Development services. Included in my responsibilities was the creation of various CRM Reports and extracting data for Model studies. Reports developed included Campaign Management, Customer Retention and Cross-Sell/Up-Sell. The Reports were developed from Oracle tables, using SQL and Data Step programs to extract data from an Epiphany CRM system on UNIX servers. Extracted data were reduced and output to Excel via DDE. Macros and Scripting were used to automate and schedule the jobs for various execution times. Model data was created using SQL to access a UNIX Oracle Data Mart. Over 250 million records were mined for demographic and life style information used for Modeling. Web based reports were created by accessing Excel spreadsheet data and creating custom HTML, JavaScript and PERL.

Entergy Resources
(Houston, TX)
August 2002 - February 2003

Was a member of Forecasting programming team that developed a suite of SAS applications for energy load time series forecasts. Determine the individual cost items associated with delivering energy by combing tariff filings. Build tariff dataset for ad-hoc and production jobs. Interfaced to Oracle database from SAS through PROC SQL and pass thru to retrieve and update forecasting results. Used SAS/Connect to remote submit jobs. Wrote SAS programs to estimate the service delivery costs of providing electricity. Wrote and maintained an application that allocated estimated new customers across billing cycles. Excel spreadsheets were created with the resultant data. Support the marketing group as Entergy gears up to compete in the deregulated energy market in Texas.

Williams Energy
(Tulsa, OK)
November 2001 - June 2002

Support the Reporting functions that surround the Risk Management processing. Created, modified, or enhanced three functional areas of assessing the Value at Risk or "VaR". Developed a Web based application using SAS, HTML and JavaScript that is an interactive method for users to do "what if" Risk Analysis processing with current holdings. Provide SAS/SCL programming support for Value at Risk Reporting System. Modify and enhance Risk Analysis GUI and programs to allow for multiple model runs. Create HTML mockups for new Credit VaR Reporting. Used JavaScript and PERL for dynamic data filtering, uploading and downloading.

Guidance Research
(Alpharetta, GA)
July 2001 - November 2001

Provided the programming, validation, and aggregation for Direct Marketing models including Customer Segmentation Analysis, Cross Sell Modeling, and Loyalty/Retention Modeling. In addition to complex Data Step processing several SAS procedures were used including, FORMAT, FREQ, SUMMARY, and TRANSPOSE.

Just For The Kids
(Austin, TX)
June 2001 - October 2001

A non-profit organization that is loading student test scores into a statistical model. The analysis will compare similar schools based on selected demographic data. My tasks were to review and remodel some of their programs to make them more efficient. Additional responsibilities included the analysis of newly loaded datasets. Several SAS procedures were used including, FORMAT, FREQ, TABULATE, SUMMARY and TRANSPOSE. HTML output was created via ODS for the statisticians to review.

Motorola
(Austin, TX)
October 2000 - May 2001

Reviewed SAS programs from different departments and combined their processing into an automated operation. Data maintained on VMS systems are downloaded to UNIX systems and combined into SAS datasets. Wrote utility programs to allow UNIX directories to be viewed on the web. Enabled automated Email messages from processing programs that allow IT personnel to track execution progress.

FedEx
(Memphis, TN)
August 2000 - September 2000

Using SAS and SAS web software developed a fuel cost monitoring system. Cleaned up and streamlined several SAS programs that were generating HTML. Added several reporting options and supporting programs to existing menus.

SAS Institute
(Dallas, TX)
April 2000 - July 2000

Worked with SAS Development team to create a SAS/Oracle based Data Warehouse application for Sprint. Was member of QA team that reviewed programs for standards adherence and maintainability. Performed unit testing of Data Step and SCL programs. Wrote Oracle SQL scripts to extract data from warehouse to facilitate content validation. Used base SAS procedures FREQ, TABULATE, and MEANS to validate current results with expected results.

Eli Lilly & Company
(Indianapolis, IN)
October 1999 - April 2000

Worked with Regulatory IT team to create a SAS/Oracle/Intranet based application for Pharmacovigilence research. The SAS based application extracts Adverse Event information from Clinical Trial data. It then creates early warning drug symptoms tracking and frequency analysis. The Intranet Web access allows various selection criteria as well as comparison with FDA data.

Tennessee Valley Authority
(Norris, TN)
August 1999 - October 1999

Web enabled existing applications. Using Visual Basic along with MapObjects and Internet Map Server software from ESRI, existing applications were re-engineered to run from the Web.

CellularONE
(Greenbelt, MD)
November 1998 - July 1999

Provide SAS programming support and mentoring for a new staff. Offer assistance in system design and implementation issues. Convert programs from reading legacy flat files to accept input from SAS datasets. Develop extract processes to move data from a Mainframe environment to Unix and Windows NT.

Tonn & Associates
(Austin, TX)
April 1998 - October 1998

Provided forensic data mining in litigation support for the Oklahoma vs. The Tobacco Industry case. State Medicare records for 1993 were loaded into SAS datasets. Several SAS load and analytical procedures were written. An emphasis was made to provide the output via the World Wide Web. Macros available from SAS Institute were utilized along with custom code, to publish the results of reports with embedded HTML.

Tonn & Associates
(Austin, TX)
March 1997 - January 1998

Provided forensic data mining in litigation support for the Texas vs. The Tobacco Industry case. Several different sources of financial, demographic, and medical data were loaded into SAS datasets for analysis. Those included NMES-1, NMES-2, MEPS, and BRFSS, Several SAS load programs analytical procedures were written.

VRC Corporation
(Alexandria, VA)
May 1995 - April 1998

Provide Analytical and SAS programming support for "JCALS" , A Joint Services test to evaluate the ability of a networked system of Computers to effectively operate in support of the requirement to Acquire, Manage, Update, Publish, Warehouse and Distribute documentation electronically. Member of a team that is taking leading edge steps to utilize Operating System generated data (Automated Data) for performance evaluation. Instrumental in discovering the availability of Automated Data. Devised methodology to capture and transfer collected data for evaluation purposes. Wrote several SAS programs to load the collected raw data into databases. Wrote several SAS procedures to analyze the data to produce meaningful results.

Coleman Research Corp
(Fort Bragg, NC/Fort Knox, TN)
August 1994 - May 1995

Provide Analytical and SAS programming support for the CTASC-II IOTE, a U. S. Army test to evaluate the ability of a networked system of Mini-computers , Workstations, Desktop PC's, and Laptop PC's to effectively operate in the support of Army Supply Requirements. Used macros and base SAS procedures with data step programming to provide analytical reports. Provided the first glimpse into using Operating System and Application generated audit data for performance evaluation.

Provide SAS programming support for the A2ATD, a U. S. Army test to evaluate the effectiveness of using simulators to simulate tanks in an overall operational environment. Used macros and base SAS procedures and SAS/GRAPH to produce comparative results.

Chevron Petroleum
(Houston, TX)
June 1994 - July 1994

Create specifications for the development of an Arcinfo and an Arcview application that supports Exploration activities. Used SAS to prepare spatial data from sixteen different sources form merging into the Arcview system. Implement the design using Arcinfo AML's and creating Arcview "views" for casual user browsing and evaluation of prospective exploration opportunities.

Coleman Research Corp
(Fort Hood, TX)
October 1993 - May 1994

Provide Analytical SAS programming support for the M1A2 IOTE to the United States Army Operational Test and Evaluation Command. Extensive Data Step programming with base SAS procedures and SAS/Graph to analyze and graphically display communications and navigational improvements to M1A2 tanks. Used Macros to help develop programs with multiple purposes. Assist Junior and Mid-level programmers with SAS related questions and problems.

Shell Oil
(Houston, TX)
April 1993 - July 1993

Provided maintenance programming services for System 2000 using Cobol and running on IBM/CMS to extract information from existing databases to export to another system. Performed maintenance programming for several System 2000/Cobol database access programs. Wrote and modified REXX Exec's to incorporate new features added during maintenance programming.

Mobil Oil
(Houston, TX)
March 1985 - April 1993

Wrote SAS programs and SAS/GRAPH procedures on Workstations and PC's to load and perform competitive analysis on worldwide petroleum licensing, field production, company participation and well production history information.

Participated in the design and development of Worldwide GIS database using Arcinfo on Sun Sparc Workstations. Extensive use of AML's in application development including displaying menus and the creation of reports. Converted data in digital and flat file format from various vendor and in-house formats into Arcinfo coverages. Used ARCEDIT to make coverages "production ready". Provide liaison between Mobil and ESRI (Vendor of Arcinfo). Installed and created several GIS applications using Arcview on Sun Sparc Workstations. Provided user support for Arcview on PC's and Sun Sparc Workstations.

Provide limited system administration function on Sun Sparc Workstations. Maintaining Unix Operating System and Application software. Kernel generation for adding/deleting features. Monitor machines in a network environment to insure active status.

Maintain and support Worldwide GIS (Petroconsultants) Wells, Fields, Concessions and Operator data using Arc/Info on Sun Workstations and on IBM Mainframes running MVS/TSO using Model 204 User Language.

Designed and implemented a Project tracking system using Model 204 User Language on IBM running MVS/TSO, that tracks information related to exploration ventures. Assisted in the redesign and conversion of Petroleum related databases from System 2000 on Cyber computers to Model 204 on IBM Mainframes running MVS/TSO. Designed and implemented a system for the use of Petroleum related data files on the Cyber computer using System 2000 and FORTRAN. Provided user support for in-house usage of System 2000 on Cyber computers. Designed and implemented a System 2000 database tracking well location data received from Tobin and IOSA.

Houston Light and Power
(Houston, TX)
August 1985

Analyzed client complaint of excessive amounts of execution time for System 2000 functions running on an IBM Mainframe in an MVS/TSO environment. Recommended, then implemented changes necessary to bring performance to an acceptable level.

Pecten International
(Houston, TX)
March 1984 - April 1987

Designed and implemented a series of System 2000 databases that contained Petroconsultants Well, Field, Concessions, and Operator data on an IBM Mainframes running VM/CMS using FORTRAN, ISPF and the System 2000 Report Writer.

Designed and implemented a System 2000 database containing petroleum licensing data with financial and operational petroleum information on an IBM Mainframe running VM/CMS using Cobol, Fortran, ISPF and the System 2000 Report Writer.

Petroconsultants, Inc.
(Houston, TX/Geneva Switzerland)
November 1982

Consulted with client and vendor of timeshare database access products regarding the benefits of making client data available via vendors dial-up computer network.

Shell Oil
(Houston, TX)
September 1982 - April 1987

Designed and implemented a System 2000 database containing historical well information on an IBM Mainframe running VM/CMS using FORTRAN, ISPF and the System 2000 Report Writer. Participated in the development of a System 2000 database on an IBM Mainframe running VM/CMS, to contain a unified schema of all exploration and production activities. My portion of the schema was oriented towards the handling of Reservoir Engineering data. Implementation was made using Cobol, Fortran and ISPF.

Tennessee Valley Authority
(Muscle Shoals, AL)
August 1982

Participated in the development of an ISPF interface for System 2000 databases running on an IBM Mainframe in an MVS/TSO environment. Interface allowed for data entry and reporting for a system that monitored hazardous material generation/storage/disposal.

Shell Oil
(Houston, TX)
December 1980 - July 1982

Participated in the evaluation of System 2000 vs Adabas on IBM Mainframes running VM/CMS. Wrote benchmark ad-hoc queries, report writer and COBOL host language programs for both System 2000 and Adabas.

Designed and implemented a System 2000 database containing Petroleum Information Systems Well History data on an IBM Mainframe running VM/CMS using FORTRAN and ISPF.

Church's Chicken
(San Antonio, TX)
November 1980

Performed an audit of System 2000/COBOL programs and Report Writer programs to evaluate their effectiveness. Changes were recommended to client to improve productivity.

General Telephone and Electronics
(Tampa, FL/Stamford, CN)
December 1979

With System 2000 as the DBMS, I consulted in the design of an equipment storage database and assisted in the creation of programs to allow the re-use of the equipment.

Tennessee Valley Authority
(Muscle Shoals, AL)
November 1979 - September 1980

Redesigned and implemented a System 2000/COBOL database running on an IBM Mainframe in an MVS/TSO environment. The database was used in the monitoring of the radiation exposure of personnel working in Nuclear power plants. COBOL and the System 2000 Report Writer were used to generate some required Government reports.

Designed and implemented a System 2000/COBOL database running on an IBM Mainframe in an MVS/TSO environment. The database was used in the monitoring of the quality of air and water within the area of power generating plants. Several System 2000 Report Writer programs were written for reporting purposes.

Gulf Oil
(Harmerville, PA)
October 1979 - November 1979

Consulted in the design of and implementation of a System 2000 database running on a Univac 1108. Seismic data was loaded using System 2000/FORTRAN. An application was developed to allow users to selectively generate maps.

Tennessee Valley Authority
(Muscle Shoals, AL)
August 1979 - October 1979

Advise client personnel on design tradeoffs, review client designs, direct programming effort for implementing client designed databases.

Associated Milk Producers, Inc.
(San Antonio, TX)
July 1979

Consulted in the design of several System 2000 databases running on an IBM Mainframe under the DOS environment. The databases were used in controlling the collection, manufacturing, and distribution of milk products.

Petroleos Mexicanos
(Mexico DF)
January 1979 - June 1979

Participated in the design of a production monitoring system. Consulted in the design of a transportation and sales distribution system. The PEMEX databases were implemented using System 2000/FORTRAN running on Cyber computers.

MRI Systems
(Austin, TX)
February 1975 - December 1978

Provided "hot-line" support for users of System 2000. Installed System 2000 on Control Data (Cyber) and Univac (Unisys) systems. Wrote quality assurance and installation verification programs for System 2000 using its Natural Language and Report Writer features and also using COBOL, FORTRAN, and PL/1 host language interfaces. Provided technical marketing support for System 2000 in Mexico. Supported initial MRI entry into Mexican market. Provided technical marketing support to the MRI representative company Software Internacional.

Operating Environments

Hardware

Software

Languages

• Personal Computers

• Windows 2000/XP
• Linux

• Mainframes

• MVS/TSO
• VM/CMS
• VMS

• UNIX Workstations

• Sun
• HP
• IBM
• Dec

• SAS V6 - V9

• Base
• Graph
• Macros
• SCL
• SQL
• Data Step
• DDE
• Formats
• SAS/IntrNet

• ESRI Products

• ArcInfo
• Arcview

• Utility Software

• CuteFTP
• CSE HTML Validator
• TextPad
• ExamDiff

• Microsoft Products

• Internet Explorer
• Excel
• Word
• Outlook
• Powerpoint

• Databases

• Oracle
• System 2000
• MS Sequel Server
• Access

• HTML
• Perl
• SQL
• JavaScript
• Windows Scripting
• Web CGI
• Visual Basic
• Fortran
• Cobol