Gary Susswein

**** *. ******* **** **. – Pompano Beach, FL. 33069

Email: adzkcz@r.postjobfree.com - 954-***-****

SUMMARY:

Throughout my career have found ways to improve reporting efficiencies by converting manual steps to automated processes or created/modified code to reduce run times from hours to minutes,

Highly experienced in Information Technology as a, SAS / SQL Programmer, Programmer Analyst and Database Administrator. Developed Excel Pivot Tables and Access Databases for various business applications and provided training to end-users.

Created Power Point Presentations and Videos.

Created Microsoft Forms from Office365 with output to Excel and Google Sheets.

Familiar with SAS Statistical functions.

Self-tutorials with Tableau.

CERTIFICATIONS:

Base Programmer SAS 9

PROFESSIONAL EXPERIENCE:

High Bridge Consulting

Partner Company: Perficient Inc. (SAS Consultant) 12/2021 – present

Team Lead managing 9 SAS Consultants for Global Banking Remediation Project

Using SAS EG to write and run SAS code to validate files

Providing technical assistance and training to team.

Tracking performance and updating tracking spreadsheets

Leading daily team standup meetings

Reviewing individual completed remediations and advising revisions

Reviewing SAS code verifying it meets business requirements.

Validating data using Proc Freq and Proc Contents

Perform data cleansing with Where and If in Data Steps to filter data

Use Proc Compare or Text Compare Tools to compare files for data discrepancies (UltraCompare, Beyond Compare, Notes++, Winmerge)

Ability to explain data in non-technical terms

Broward County School Board

Sheridan Technical High School 04/18 – 12/2021

Used SAS and SQL to pull raw data and filter and validate data.

Developed 2 Microsoft Access Databases, Loaner ID’s and Tardy Times.

Created Access queries to count totals and export Excel files.

Excel Pivot Tables used to create Summary reports.

Created Microsoft Forms and shared with organization using QR Codes and Hyperlinks.

Created Power Point Presentations, Slide Shows and Videos.

FreddieMac 11/16 – 08/17

(Agency Insight Global) – McLean, VA.

Single Family Condo Operations

SAS Programmer

Developed SAS data sets and reporting on historical and current mortgages related to single family financed condominium projects using SAS EG on Unix.

Connected to Oracle for initial (ETL) data extraction.

Scheduled SAS EG Projects and Processes using Scheduler in SAS EG.

Created macro variables using Let statements, Call Symput and Proc SQL into:.

Created macros as part of code development.

Used X commands to move / copy files and set permissions.

Created Prompts in SAS EG for user input data entry.

Created Include statements to retrieve SAS code.

Updated Master data sets with Transaction data sets.

Create Indexes and Write and Alter Protection on Master data sets.

Imported excel files into SAS and exported SAS files to Excel.

Verify data columns using Proc Freq and check SAS logs for Warnings, Errors and Uninitialized variables.

Developed Issues Log with Microsoft Access to track issues.

Used Proc Summary to roll up data for reporting.

Used Proc Compare to identify differences in SAS datasets

Walt Disney World 12/15 – 9/16

(Agency Inteletech Global) – Celebration, FL.

Relationship & Mkt CTR

SAS / Teradata SQL Programmer

Modify SAS and Teradata SQL scripts and SAS Macros for DVC(Disney Vacation Club) campaigns

Troubleshoot SAS code via SAS Logs

Run code using SAS EG / Teradata SQL Assistant and Putty

Update Suppression Tables and SEED Tables

Develop code using UltraEdit

Compare files using UltraCompare

UltimateSoftware – Weston, FL. 12/12 – 9/15

Customer Interface Specialist

Troubleshoot customer SQLscripts on Cloud via Citrix utilizing SQL 2008R2.

Modify SQL scripts to customer specs.

Create scheduled jobs on SQL.

Troubleshoot Scheduled Jobs in SQL using Job Activity Monitor.

Troubleshoot file issues in SQL using PAC (Process Automation Center).

Provide feedback to Account Managers and clients.

Use SalesForce application to track and resolve cases.

Experience with Health files (834/835 format), 401k files, HAS/FSA files.

Experience with files for stock and fund trades containing CUSIP ID.

Retrieve and view reports from Informatica.

Self-starter and highly motivated to provide excellent customer service.

Strong verbal and written communication skills; able to communicate. effectively by phone and email.

Team player, offers assistance to other team members and accepts. feedback from team members and manager.

Highly organized, detail oriented and accurate.

Capital One – Richmond, VA. 08/12 – 11/12

SAS Contractor – Agency: Collabera

Develop SAS code on SAS Enterprise Guide Unix platform to create History and Target Tables for Model predictions and validation.

Trainer for customized SAS Classes.

Agile environment

Office Depot – Boca Raton, FL 03/12 – 06/12

SAS Contractor – Agency: Insight Global

Review and modify existing SAS code to run efficiently.

Run and test code on SAS 4.3 Enterprise Guide from Teradata DB,

Assisted with UAT testing in converting from SAS 9.1 to SAS 9.2.

Co-ordinate tasks between programmers and Marketing Team

WellCare – Tampa, FL. 10/11 - 03/12

Sr. SAS Programmer

Develop adhoc reports and maintain scheduled production reports using XWin32 for Unix SAS and Proc SQL from Medicare and Medicaid Oracle databases that were millions of records

Provide output files in Excel, Text, or SAS datasets.

Signature Consultants (IT Agency) – Charlotte, NC. 06/11 – 09/11

SAS Programmer/Analyst for Wells Fargo

Develop and maintain Mortgage Foreclosure Campaign Marketing reporting using Unix SAS, PC SAS, Teradata, and Proc SQL,

Import Test Cell Grids and Seed List for campaigns. Use Proc Freq on Test Cells and Laser Copy Code to verify counts.

Follow file spec instructions and mail file layout for each campaign.

Perform Self Audits for mailing lists and suppression files.

Review SAS Logs for errors, warnings and uninitialized variables.

Save SAS Logs and SAS Lists for independent auditors.

Transfer mail files and suppression files via DTS.

Software Specialists (IT Agency) – Columbia, SC. 02/11 – 05/11

Sr. SAS Programmer/Analyst for Blue Cross & BlueShield of South Carolina

Develop and maintain Medicare standard and ad-hoc reporting using Unix SAS, PC SAS, and Proc SQL,

Extract data from DB2 Tables, SAS datasets, Excel.

Format reports using ODS and Proc Report. Create SAS datasets and Excel files.

Validate data using Proc Compare, Proc Freq.

Signature Consultants (IT Agency) – Charlotte, NC. 09/10 – 1/11

Sr. SAS Programmer/Analyst for Bank of America

Develop reports using PC SAS, Enterprise Guide, Proc SQL.

Collabra (IT Agency) – Charlotte, NC 12/9 – 08/10

Sr. SAS Programmer/Analyst for Wachovia (A Wells Fargo Company)

Developed and maintained reports (adhoc, monthly, weekly, daily) and analysis using PC SAS on UNIX and Teradata from TSYS and FDR credit card transaction databases that have millions of records.

Ran and maintained AML reports.

Used SAS Arrays for dates and dollars.

Developed advanced excel spreadsheets for credit card transaction data..

Developed advanced Excel graphs utilizing macros, indexes and offset functions for multi-month and multi-year data. AML and Credit Risk reporting.

Gave presentation on Transforming Multiple Results into One Result using

Binary Expansion theory at the Charlotte SAS Users Group Spring Meeting May 13, 2010.

Researched data in SAS datasets using SAS Proc Freq and SAS Proc Contents.

Developed reports to analyze FICO, Bankruptcy, and Triad Scores.

Played a major role in converting reports from TSYS databases to First Data (FDR) databases.

Automated SAS jobs utilizing Windows Task Scheduler.

American Express – Fort Lauderdale, FL 1998 – 2009

Programmer/Analyst

Experience with credit card Dispute Inventory Control. Tracking open/closed cases across Product lines and Industries.

Used SAS Arrays and Hash Tables to categorize the different credit card products and to initialize counts.

Created and ran Fraud reports from Fraud flat files.

Extracted data from very large databases from Triumph System (hundreds of million records, some record lengths exceeding 15,000 bytes.).

Experience with both Mainframe SAS (MVS/TSO, JCL), PC SAS and SQL Development.

Exported SAS data to Excel, Access and Text files using Proc Export.

Summarized SAS data using Proc Means, Proc Summary, Proc Univariate.

Familiar with Import function to bring data into SAS from Excel and Text files.

Familiar with Excel, Excel Pivot Tables, MS Word and PowerPoint.

Designed SQL Databases, Tables. Stored Procedures, and automated reporting using SQL Job Manager.

Defined data mappings for SAS Data, flat files, and SQL/Access Tables.

Acted as Business Analyst to gather reporting requirements from different departments within the organization.

Developed numerous Access Database Applications for the business, as needed using Access Queries, Macros, Reports and Tables.

Developed MIS reporting from Triumph and Legacy Databases utilizing a

combination of JCL, SAS, Access and SQL. Automated MIS reporting process

with Windows Task Scheduler, SQL, SAS and Access and Autoexec bat routines.

Created SAS Transport files.

Perform file transfers between mainframe and PC using XCOM and FTP.

Developed and presented numerous SAS, Access, and Excel Pivot Table classes to American Express employees.

First Union - Miami, FL. 8/97 - 12/97

SAS Developer

Created SAS code to automate reporting process for the Collection and Recovery department in the bank's credit card division.

Created reports which management used to analyze delinquency-cycles, roll-rates, balances, and account activity.

Federal Express Corporate Office - Memphis, TN 4/97 - 7/97

SAS Contractor

Converted FOCUS code to SAS code reporting on Service centers and driver delivery Metrics using Proc Summary, ProcTranspose and Proc Report.

IMT – Pompano Beach, FL 9/96 - 4/97

Database Programmer

Automated the manual coding process with Access for the fulfillment house specializing in the Travel and Cruise industry.

Developed Access Tables, Queries, Macros and Reports to analyze marketing campaign data.

Computer Express, Ft. Lauderdale, FL 6/95 - 8/95

SAS Programmer

Source Coding for Pharmaceutical Research Company, designing reports and analysis on new medications.

EDUCATION:

Florida Atlantic University

B.A. Corporate Management

Lincoln Technical Institute

A. A. Specialized Electronic Technology

AWARDS:

2002 Great Performer with American Express

Numerous Quality Employee of the Month Awards at American Express

WOW and REAL Awards with American Express

Numerous PFP Awards – Performance for Perfection – Ultimate Software

Numerous PFP Awards - Passion for Perfection at Ultimate Software

COURSEWORK:

SQL 2781A – Designing Microsoft SQL Server 2005, Server Side Solutions

SQL 2782A – Designing Microsoft SQL Server 2005 Databases

SQL 2071B – Querying Microsoft SQL Server 2000 with Transact-SQL

SQL 2779 - Maintaining Microsoft SQL Server 2005 Database

SQL 2780 - Implementing Microsoft SQL Server 2005 Database

SQL 2791A – Implementing Maintaining Microsoft SQL 2005 Analysis Services

Contact this candidate