Jessica Claire
Montgomery Street, San Francisco, CA 94105
Home: (555) 432-1000 - Cell: - - -

Highly experienced, results-driven advanced SAS certified software developer. Able to work independently supporting applications, from concept through development to deployment with operational and maintenance support. Optimization of solutions using advanced features such as hash objects, Perl Regular Expressions and scheduled tasks.

  • SAS Foundation
  • SAS/Access
  • SAS/AF
  • SAS/Connect
  • SAS/Graph
  • SQL
  • HTML
  • Perl Regular Expressions
  • Self-starter
  • Analytical
  • Base SAS Certified
  • Advanced SAS Certified -
  • SAS Blog - - variety of code snippets
2009 to 01/2016
SAS Solutions Architect Cleveland Clinic Chippewa Lake, OH,
  • Provided on-site SAS support to the Actuarial and Accounting divisions of the USDA's Risk Management Agency
  • Created DEV/TEST/PROD SAS application servers to handle remote requests using SAS's integrated object model
  • Handled requests across Windows servers saving approximately $250,000 in UNIX licensing fees
  • Created a dashboard of key performance indicators using SAS/Graph
  • Used the ODS tagsets.tableeditor to create a multi-tabbed report containing filtered columns, graphs and maps
  • Created a custom SAS/AF GUI based application that uses SAS/Access to seamlessly query SQL Server data and SAS component language to export data to Excel using object references
  • Revised the premium calculator to run the book of business in 20 minutes versus 3 days by utilizing 26 data driven dynamic SAS hash objects
  • Wrote a point and click interface to generate a program header template that writes RDBMS connection strings and SAS/Connect data transfer service (upload / download) code
  • Created a custom help file containing approximately 2,700 topics with most entries about SAS and SQL Server
  • Wrote publicly posted organic report that reduced time to produce from 2 weeks to 20 minutes via a scheduled task
  • Augmented over 80 queries using Perl regular expressions to parse stored SQL code and dynamically rewrite queries using SAS catalog entries reducing task time from 30 to 5 minutes
  • Wrote over 150 custom SAS macros to shared autocall library
  • Created scheduled tasks to monitor the availability of the SAS object spawner to improve server reliability
  • Administered SAS server metadata administration using the SAS management console
  • Developed a SAS/AF based interface containing over 60 controls to dynamically generate state/county level maps
  • Created hyperlinked PDF reports containing tables, maps and graphs used to support congressional testimony
01/2006 to 2009
Systems Analyst III Nana Regional Corporation Hampton, VA,
  • Responsible for the weekly import and conversion of all retail, indirect and service/repair locations into a unified XML file that drove the content on the Sprint Store Locater web site and ancillary sites
  • Designed, developed and maintained a custom Visual FoxPro (VFP) application used to read SAS data sets and create Excel pivot tables that exceeded the 64K row limitation
  • Rewrote the maximize report reducing the weekly run time from 10 hours to 15 minutes by exploiting advanced SAS features
  • Created a custom Windows service to handle the processing of direct replacement handset program data from a Windows server to a UNIX server
  • Designed, developed and maintained of an internal web site that was completely data driven using HTML, CSS and JavaScript
  • Designed, developed and maintained of a program that hit against several multi hundred million Teradata row tables
  • Led the conversion of over 2TB of SAS data sets and files from an AIX to a Sun operating system

03/2004 to 01/2006
Marketing Information Manager Amentum Tallassee, AL,
  • Created a custom application using VFP classes to connect desktop PCs to SAS on UNIX using the integrated object model
  • Created an intuitive GUI to directly push large (800K+ rows) SAS data sets directly into Excel PivotTables used for churn decomposition analysis
  • Created a custom interactive digital dashboard showing key performance indicators of demographic marketing activity
  • Created an interactive county level map of the United States that integrates Census Bureau demographics with Sprint subscriber statistics
09/2002 to 03/2004
Software Developer Time Warner Cable Cda, ID,
  • Created a web enabled, N-Tier application using VFP, SQL Server and XML for use in the bankruptcy industry
  • Created the Chapter 7 bankruptcy filing forms
  • Devised a data driven system auditor process that runs as scheduled service to identify and report on data anomalies
02/1997 to 09/2002
Systems Analyst Leidos Indianapolis, IN,
  • Designed a custom VFP based class utilizing Excel's pivot cache object and external data sources to create pivot table reports that store up to 500,000 rows of data
  • Replaced 200 reports with 4, reduced turnaround time from 36 hours to 20 minutes, eliminated 5 positions and created a much more flexible and powerful reporting solution
  • Created a web interface to handle queries that are returned via e-mail as an Excel attachment
  • Responsible for the analysis of telecom return data and for creating a LEC feed billing system to handle in excess of 300,000 messages per week using VFP
  • Responsible for maintaining and enhancing a large VFP and SQL Server 2000 application
05/1996 to 01/1997
Network Engineer III City Of Hollywood, Fl Hollywood, FL,
  • Designed, developed and maintained of the International circuit forecast model
  • The model used determined the number of voice and data lines needed by country, carrier, gateway, signaling type and route
  • Accountable for the support of a NT server and a group of 45 users running NT 4.0 workstation
02/1995 to 05/1996
Project Analyst Sprint City, STATE,
  • Supported 60 users on a 20 GB Banyan LAN and wrote all the custom developed software
  • Wrote the message ready billing (MRB) operations reporting system
  • Designed and developed the pay-per-call system for compensating the 500,000+ private payphone owners in the US, saving Sprint over $825,000 annually versus using the Cincinnati Bell proposal used by AT&T and MCI
02/1992 to 02/1995
Senior Systems Analyst Sprint City, STATE,
  • Worked independently managing several tasks and providing technical support to end users
  • Involved in all phases of system development including gathering requirements, design, coding, testing, documentation, training, implementation and maintenance of summarized billing data using FoxPro 2.5
  • Created the basic structure (forms, reports and import routines) for the Activity Based Management model while on a six week loan assignment to the IS Finance group
  • Developed custom forms and SQL generated reports summarizing Package Ready Billing operational activity reducing production time from 5 days to 15 minutes
Expected in
MBA: Quantitative Analysis
University of Missouri - Kansas City, MO
Quantitative Analysis
Expected in
BS: Finance; Investments Option
Missouri State University - Springfield, MO
Finance; Investments Option

AIX, Billing, Business and Technical Requirement Gathering, CSS, Data Transfer, Documentation, End User Training, Excel, HTML, Outlook, SQL Server, Windows, Oracle, Perl Regular Expressions, SAS, SAS Component Language, SQL, SQL Server, Sun, SVG, Teradata, UNIX, VBA, Visual FoxPro, Windows server, XML

By clicking Customize This Resume, you agree to our Terms of Use and Privacy Policy


Resumes, and other information uploaded or provided by the user, are considered User Content governed by our Terms & Conditions. As such, it is not owned by us, and it is the user who retains ownership over such content.

How this resume score
could be improved?

Many factors go into creating a strong resume. Here are a few tweaks that could improve the score of this resume:


resume Strength

  • Length

Resume Overview

School Attended

  • University of Missouri
  • Missouri State University

Job Titles Held:

  • SAS Solutions Architect
  • Systems Analyst III
  • Marketing Information Manager
  • Software Developer
  • Systems Analyst
  • Network Engineer III
  • Project Analyst
  • Senior Systems Analyst


  • MBA
  • BS

By clicking Customize This Resume, you agree to our Terms of Use and Privacy Policy

*As seen in: