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.
Highlights
SAS Foundation
SAS/Access
SAS/AF
SAS/Connect
SAS/Graph
SQL
HTML
Perl Regular Expressions
Self-starter
Analytical
Accomplishments
Base SAS Certified
Advanced SAS Certified - http://bit.ly/1lis5uC
SAS Blog - http://KanSASCode.blogspot.com - variety of code snippets
Experience
2009 to 01/2016
SAS Solutions ArchitectCleveland 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 IIINana 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 ManagerAmentum – 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 DeveloperTime 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 AnalystLeidos – 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 IIICity 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 AnalystSprint – 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 AnalystSprint – 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
Education
Expected in
MBA: Quantitative Analysis University of Missouri - Kansas City, MO GPA: Quantitative Analysis
Expected in
BS: Finance; Investments Option Missouri State University - Springfield, MO GPA: Finance; Investments Option
Skills
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
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:
