SAS Applications Programmer/DBA

505-***-**** Louis Sinoff *******@*******.***

**** ********** **, ***** ****, FL 34286

Qualifications for: Senior SAS Programmer/Manager

Over 20 years of IT experience with a vast skill set encompassing programming, database administration, data architecture, and systems analysis. Masterful SAS Programmer and SAS Admin. Develops innovative methods for achieving goals. Consistently performs above and beyond required job functions. Manages to Critical Path and provides mentoring and coaching.

Professional Synopsis

SAS Administrator

Gainwell Technology 10/2025 to Present

Performed SAS Server and Workstation installs. Automated manually run SAS EG Projects using SQL Server Agent. Handled annual renewals saving $25,000 per year.

SAS Programmer

Westchester University 1/2024 to 1/2025

Back Office SAS Applications programming for data modernization project. School administration migrating from People Soft to Banner. Projects developed and delivered in Enterprise Guide. ETL from Oracle to Postgres done in SAS DI.

SAS Programmer/Admin & DBA

StatInMed 6/2020 to 6/2023

DBA For MS SQL Server maintaining Data Warehouse. Wrote original SAS Program as generalized Data Load driven by Database Metadata. Converted SAS DATA step code to use SQL Joins obtaining a 20 to 1 performance improvement over just SAS Code. Wrote C# utilities. Liaison with IT Provider. Installed SAS under Oracle Linux to benchmark SAS Access to Google Big Query (GBC). I interacted with SAS Institute to resolve apparent SAS Bugs. Tuned SAS for the best throughput for processing very large datasets. Optimized SAS Access to process through ODBC to GBC. Automated movement into and out of GBC using Command Line interface. Wrote GBC SQL to combine Inpatient with Outpatient Visits occurring less than 3 days apart creating a single visit.

Systems Analysis, C# & DBA

LKL Database and Analytics 9//2019 to 6/2020

Migrated a client’s Excel based data management and reporting to SQL Server. Formulas were implemented as Views and Stored Procedures. Reports and graphs were delivered in Excel Spreadsheets generated from C# programs.

SAS Programmer & DBA

Optum – at United Health 9/2014 to 7/2019

SAS Programming to enhance and make performance improvements to decrease processing time for a set of SAS Programs that filter and enhance data for Medicare Claims. Extensive MACRO usage in programs. The last major project was making SAS a large body of SAS Code Windows/UNIX aware and self-modify for each environment. Performing as SQL Server DBA for multiple DB Servers.

SAS Programmer

Physicians Health Plan – Lansing, MI 3/2012 to 6/2014

SAS Programming to automate manual operations required to initiate format and distribute existing SAS Programs. Perform original SAS Programming using SAS EG for reporting and ETL. Using TriZetto FACETS Database.

SAS Platform Administrator

Hope CU – Memphis, TN 2/2012 to 3/2012

Performing SAS EBI migration from 9.2 to 9.3. Migrated SAS Metadata using the SAS Metadata migration tool, Installed and configures SAS EBI Server. Prepared automated installation for SAS Clients.

SAS Programmer

Ergenomics – Minneapolis, MN 3/2011 to 7/2011

Programming for Retail Forecasting built around SAS High Performance Forecasting Server. Converted Weekly Transaction data into Time Series and performed smoothing of Promotions, Lost Sales, Seasonality, and Outliers. SAS Forecast Studio Projects for Forecast and Exceptions were dynamically created. Manually adjusted Exceptions done via SAS Forecast Studio were merged into consolidated forecast. Programming was done through SAS Enterprise Guide.

SAS Programmer

Perceptive Informatics – Billerica, MA 4/2008 to 5/2010

Programming from very sophisticated SAS projects using SAS Enterprise Guide to extract data as a result of Radiological analysis for Clinical Trials from hyper normalized Oracle Database and format it into various client specified formats. Performing sophisticated reporting from the same Oracle database and other sources, primarily DXA .MDB’s stored on file system. Programming requires a great deal of invention and creativity as each project is sophisticated and hand crafted. Design of reporting is for a high level of automation and self customization in order to be able to run as scheduled task. Tools use are SAS 9.2, Enterprise Guide 4.1, SAS Access for Oracle, SAS Access for PC files and SAS/QC for PROC CUSUM

SAS BI Administrator

Upromise – Newton, MA 4/2006 to 4/2008

Managed SAS BI environment consisting of Windows and UNIX Servers supporting SAS Enterprise Guide Clients. Performed server capacity planning, server tuning, and disk management. Work with SAS support to resolve installation and usage issues. Mentored and coached department in best SAS practices to efficiently access multi-million row tables in a data warehouse. Programmatically managed and reported SAS Metadata.

Project management / Systems Analysis / QA

EMC – Hopkinton,, MA 10/2005 to 12/2005

Worked in B2B segment accepting Purchase Orders from resellers utilizing RossettaNet RNF protocols - managed integration of new partners. Preformed GAP analysis and prepared functional specifications for the implementation of enhancements and integration of new partners. Designed and executed test plans simulating orders for DASD utilizing backend ERP - a combination of Oracle 11i and Oracle 11.03 Applications. Wrote VB code to transform XML quotes into 3A4 PIP in VB using DOM methods.

SAS Programmer

NEBS – Groton, MA 5/2005 to 8/2005

Performed all systems analysis, DA, DBA, and programming necessary for creating an integrated marketing database in Oracle which weekly combined data from the 12 brands comprising Deluxe Corp. This involved writing complex SAS code for a system which automated batch processing by detecting the presence of data to be processed and automatically e-mailing the processing status, file utilizations and PDF audit reports and using Trillium to create a Corporate Account Number to tie together customers appearing within multiple brand files.

SAS Programmer

Fortelligent – Boston, MA 4/2003 to 4/2005

Project management of a multifaceted project that ported subsets of customers’ master files to a central location and linked data from multiple diverse sources to create a complex reporting environment. Extensive ETL and automated batch processes. Responsible for requirements, QA, work distribution and significant technical contributions as a Data Architect and DBA. Administered a team performing monthly SAS programming required for transforming large files utilized for telemarketing and direct mail promotions. Trained and mentored junior programmers. Instituted practices to create group ownership of code and shared workflow responsibilities. Implemented SAS Macros to decrease programming efforts and ensure quality. Performed systems analysis and business process reengineering as well as capacity planning to support increasing workload.

SAS Programmer

DxCG – Boston, MA 9/2002 to 11/2002

Interfaced SAS programs to MS SQL server using SAS/Access. Prepared test plans and scripts and DB compare utilities for a .NET-based product development. Provided programming support for legacy products and assisted in developing new products.

Oracle Applications Administrator, DBA UNIX Administrator

Viant – Boston, MA 2/2002 to 7/2002

Managed the transition of Oracle Applications from HP-UX to Solaris and upgraded the release of 11.5.6 of Oracle applications. Performed multiple server configurations, QA, and DR plans.

Manager of Network Resources

HarvardNet – Walthan, MA 9/2000 to 5/2001

Managed staff, budgets, and a multi-domain e-mail, DNS, RADIUS, TACACS, Openview, and CiscoWorks. Utilized NetFlow and SNMP-based tools to perform capacity planning. Created initiatives for e-mail upgrades, DNS upgrades, and quality service management.

Senior Program Manager

Oracle Corporation – Burlington, MA 1/1998 to 9/2000

Performed systems analysis and design of productivity tools for Oracle support analysts. Served as a project manager and utilized a cross-functional team to pilot the Primus Knowledge Management product at Oracle support to provide a more effective use of a problem/solution knowledge base. Imported legacy data utilizing Perl.

SAS Applications Admin /DBA

Law School Admissions Council – Yardley, PA 3/1997 to 1/1998

DBA for Oracle Applications. UNIX Administrator. Utilized Er/Win for logical and physical data modeling. Designed and implemented disaster/recovery plans and evaluated network management and analysis tools. As an applications architect, designed interfaces between Oracle and legacy applications.

QA Manager

General Electric Capital – Malvern, PA 1/1996 to 3/1997

Recruited and managed a team to perform quality assurance and black box regression tests for a billing system. Evaluated case tools and automated test tools.

C Programmer

Premier Data Systems – Malvern, PA 1/1995 to 1/1996

Designed and programmed an interface to enable legacy applications to access an Oracle database by simulating applications existing API. Developed benchmarks to imitate the performance of an Oracle environment.

Oracle Applications Support

Transportation Leasing – Philadelphia, PA 11/1993 to 1/1995

Installed and administered Oracle applications, including AR, RA, AP, and GL. Utilized interface tables to import legacy data into Oracle applications. Composed ProC programs to interface shipping applications to Oracle RA.

SAS Programmer

SmithKline Beecham – King of Prussia, PA 4/1991 to 11/1993

Programmed reports of clinical trial data in SAS for FDA submissions. Created and maintained generic SAS-reporting Macros. Wrote a report viewer in Visual Basic to display post-script files.

Owner

LWS Software – Brynmawr, PA 2/1990 to 4/1991

Wrote PC DOS video poker games in C language featuring an expert system trainer and simulator to teach optimal strategies. Converted games to utilize Windows API. Performed desktop publishing for manual, retail box, media labels and advertisements. Created 4-color pre-press separations for commercial printing.

SAS Programmer

Roher Pharmaceuticals – WillowGrove, PA 3/1989 to 2/1990

Created a menu-driven reporting system for clinical drug trial data in SAS and programmed UI and interfaces in SAS.

Previous Employment

Project Manager General Electric Corporation – King of Prussia, PA 1984 to 1989

Systems Engineer, ITEL and Memorex – King of Prussia, PA 1982 to 1984

Owner, LWS Software – Telford, PA 1981 to 1982

Systems Engineer, DEC and IBM Mainframe Systems Programmer – Blue Bell, PA Prior to 1981

Education

Associate of Science, Computer Science, Mercer County Community College

BS, Computer Science, Villanova University, not graduated

Landmark Education Participation

SELP Head Coach

Course Supervisor

Wisdom

Accomplishments

Created 40 piece near professional classical wind ensemble as 1999 SELP Project (www.crwe.org)

Ran for Massachusetts State Senator in 2004 general election

Contact this candidate