SUMMARY

• He is Senior SAS Programmer/Analyst with over 20 years of experience in data processing, database design/build, and documentation as a SAS developer/analyst using SAS Advance Data Step Manipulation, Advanced Macros, Indexing, SAS DDE, PROC SQL, SAS Grid Manager, SAS Parallel Processing, SAS EG, SAS Connect, DB2, JCL, TSO/MVS, ISPF, UNIX, Oracle, Teradata, Frame Entry, Graphs, Reports, and SMC.
• Extensive experience performing data extraction, transforms, and load (ETL) on SAS Datasets, SAS Data Warehouse, Teradata Warehouse, flat files, Oracle Database, processing, analysis, and reporting as well as version control.
• Worked with extremely large databases with more than 600M - plus records and multiple input formats.
• He has excellent interpersonal communication skills with the ability to work within a team environment or independently. Most recent acquired development skills include: SAS DDE, SAS Grid Processing, SubVersion, SAS 9.4 Upgrade, SAS Platform move from UNIX Solaris to UNIX Linux.

PROFESSIONAL EXPERIENCE

Confidential, Boston, MA

Senior SAS Programmer / Analyst

Responsibilities:

• Lead Developer on the CCAR SAT Balance Walk Engine:
• Inherited the CCAR SAT BWE/AWE/LWE Forecasting code from Oliver Wyman (OW).
• Executed code during 2016 Execution Cycles after CCAR2016.
• Worked 70 hour weeks to execute and monitor all CCAR2016 cycle processing.
• Participated in all CCAR2016 and subsequent yearly cycle processing status meetings.
• Converted all three CCAR SAT Engines from executed in SAS EG to UNIX batch executions.
• Converted all hardcoded SAS macro paths and values to using a parameter CSV file.
• Revised all three SAT Engines to use a more proficient Driver program using UNIX SYSPARM.
• Revised the loadBalanceWalkData SAS module to use SQL parallel processing for contributor data.
• Performed all 2016 BWE code upgrades and revisions.
• Revised the SAT Engines to write all outputs to an output UNIX folder external to the framework.
• Revised BWE output folder structure for simultaneous BWE executions (all entities/scenarios.)
• Added parameter and code options to allow BWE SBNA and SCUSA to execute in parallel.
• Revised the BWE to consume all input data from Oracle RFO Database.
• Added two additional SQL Balance Roll Summarized outputs to the BWE process.
• Revised the BWE to update RFO Metadata Material View (MV) and load BWO into RFO MV.
• Currently performing CCAR2017 code requirement changes, and revising GIT Master Repository.
• CCAR 2017 Technical Documentation:
• Revised 8 of the 11 CCAR 2016 Technical Documents for CCAR2017.
• Created an Excel Spreadsheet listing all BWE Macros in execute sequence for all portfolios.
• Assisted team members with completing their CCAR2017 technical documention.
• Daily Team BWE Coder Overviews
• Setup and performed daily overviews on how the SAS Engines work with new team members.
• Performed SAT Forecasting Execution Overview instructions for Larry Davis’ team.
• Currently performing SAS coding overviews for team members.
• Weekly Status Meetings:
• Provide Dan Costelloe with weekly CCAR executions and project status for his meeting with Jonathan Watson.

Environment: Windows Server, UNIX (Solaris and Linux)

Confidential, Arlington, VA

Senior SAS Programmer / Analyst

Responsibilities:

• Project Lead on SAS 9.3 to SAS 9.4 Migration.
• Worked closely with all Credit Risk Team Leads on SAS Parallel Test Scripts.
• Converted all UNIX CRON jobs to be executed my Control- Confidential .
• Wrote SAS programs to migrate all SAS Libraries to SAS 9.4 Version.
• Wrote SAS programs to verify all 52K+ files were moved successfully, with correct file permissions.
• Created Shell Scripts to perform file listings between Unix Solaris and Unix Linux Servers.
• Created Shell Scripts as SAS wrappers to execute and control SAS outputs.
• Setup Subversion Production Branch.
• Setup iTRACK, Crucible, Remedy Change Control, and iShare systems for Subversion code promote from Development Trunk to Production Branch.
• Coordinated on-site Subversion Training for Credit Risk Department.
• Prepared Subversion Change Management presentation for Credit Risk SVP.
• SAS SME on E*Trade PII Data Implementation Project.
• Developed SAS PII Proposal on how to protect PII data within UNIX environment.
• Wrote SAS program to scan entire UNIX Solaris Server to identify all PII Data.
• Currently attending monthly SAS PII Implementation meetings.
• Project Leader on getting Offshore Credit Risk team members Wise Terminals.
• Worked closely with E*Trade System Engineering Department with Offshore teams equipment requirements.
• Worked through the Infrastructure Bandwidth issues with Offshore team and System Engineering.
• Provided Credit Risk Management with Offshore Team’s requirements for ordering Wise Terminals.

Environment: Windows Server, UNIX (Solaris and Linux)

Confidential

Senior SAS Programmer / Analyst

Responsibilities:

• Completed first project: Wrote a 1,000 page document describing all AFS System SAS code. The AFS System is being converted from SAS to the SQL Server Database. The SQL Server Database programmers needed someone to document the current SAS system and all SAS code in plain English so that they can duplicate the SAS code and process in their SQL Server SQL Language.
• Completed second project: Converted the monthly MS Excel Investor Report in SAS code. Automated the process to automatically read in each source file upon availability. Converted all MS Excel cell calculations into approximately 176 Macros Variables. Converted the Existing Excel Investor Report into an Excel Investor Report template, in which I used SAS DDE to place each SAS Macro Variable into the correct Investor Report’s template cell. Also modified SAS code to recognize Confidential & Confidential Corporate Holidays during the Investor Report submission process.
• Completed third project: Worked closely with Risk Analysis Modelers to create a comprehensive AML Fraud Customer Profile. Created a base SAS data set with all of Confidential & Confidential Individual and Business customers. Merged this base file against seven other source files to obtain additional supplemental data. Created an ETL process to handle all data anomalies and data scrubbing. Also created several Process Flows.
• Performed several Brown Bag classes on SAS Macros, Proc SQL and SAS Efficiency Techniques.

Environment: Windows Server, UNIX