Lead Software Engineer (sas) Resume
Johns Creek, GA
COMPUTING EXPERTISE:
Software & DBMS: SAS V9.4 (Macros, Secure/Encrypt, Connect, ODBC, Access, OR, Graph, Tabulate, Cluster, STAT, Integration Technologies), SDLC, CyberArk, GIT, SPUFI, JIRA, Confluence; Google Cloud Platform (GCP), Oracle, Teradata, DB2, SQLSVR.
Operating Systems: IBM OS/ESA/MVS/XA/SPF, Windows, OS/2, LINUX, UNIX Solaris/AIX.
PROFESSIONAL EXPERIENCE:
Lead Software Engineer (SAS)
Confidential, Johns Creek, GA
Responsibilities:
- Engineered a robust SAS Data Science decision model to run on 6 virtual servers using SAS Integration Technologies.
- Develop SAS apps from scratch - extract, transform with SAS and load onto Teradata, Oracle, & SQLSVR databases.
- Taking the role of the SAS System Administrator to maintain and service 6 SAS servers (Metadata, Midtier, Compute).
- Writing SAS codes to convert massive Teradata views and tables in Cyber Vault to Google Cloud for Big Query.
SAS Software Consultant
Confidential, Oakland, CA
Responsibilities:
- Developed SAS codes to extract data from Oracle databases with Confidential Payment System for marketing reports.
- Partnered with data scientists to create ETL systems to support APR increase/decrease decision models.
- Orchestrated a national DNP (Do Not Call / Do Not Promote) data depot to comply with federal regulations.
SAS Software Consultant
Confidential, Atlanta, GA
Responsibilities:
- Created “Churn” campaign mailing lists from Oracle using strategic marketing criteria from data science models.
- Converted production MS-SQL and Oracle SQL codes into SAS for code upgrade and performance enhancement.
SAS Software Consultant
Confidential, Charlotte, NC
Responsibilities:
- Converted XL Macros into SAS codes and MS Access databases of VISA Credit Card data for insertion into SAS datamarts.
- Performed data conversion of checking, savings and HELOC account data required by the Confidential -First Union merger.
SAS Software Consultant
Confidential, Charlotte, NC
Responsibilities:
- Composed ad-hoc ETL programs in SAS to run on multiple platforms consisting of UNIX, Teradata, Linux, MVS, & PC.
- Developed Pass-Thru SQL codes to access mammoth databases in Teradata, DB2 and SAS data repository.
- Built data mining mathematical models in Credit and Debit Card business using SAS/STAT and SAS Macros.
Data Architect, Analytics
Confidential, Atlanta, GA
Responsibilities:
- Designed and built a SAS app for the company flagship web-based guided selling tool.
- Used JAVA to extract and convert e-CRM consumer research data in XML and Oracle for data mining.
Data Scientist, Operations Research Analyst, Decision Support Analyst, Data Analyst.
Confidential
Responsibilities:
- Wrote SAS codes to provide forecasts of beverage sales, surveys of consumer behavior, and random samples of data.
- Joined massive SAS datasets with DB2 tables with billions of rows of telecommunication traffic.
- Coached a team of SAS programmers responsible for Managed Healthcare (HMO, PPO) decision support reporting.
- Constructed a Linear Programming (LP Transportation) model to purchase coal efficiently and save $98 millions yearly.