224-***-**** • email@example.com
Senior SAS programmer and Business Data Analyst with over 15 years’ progressive experience leading software development teams.
Technically sophisticated SAS engineering professional with a solid history of effective development, integration, and testing of SAS application software. Broad knowledge and success in creating SAS solutions to increase company profit and efficiency. Skilled trainer and project leader, able to direct multiple tasks effectively and readily master innovated software and tools. Strong ability to analyze data and make intelligent business decisions and guide the direction of the company.
SAS • UNIX • Analytical Databases • Statistical Programs • Oracle
SQL • Visual Basic • Mainframe • MIS
SAS, COBOL, NATURAL, Access, Visual Basic, HTML, ASP, Oracle, Statistica, Perl/SCL
JCL, SQL, DB2, Excel, Word, Powerpoint, Sharepoint, XML, Spotfire
PC/Server, AS400/Mainframe, UNIX
Functions, Formats, Reports, Micros, Procedures, XML, ETL
Base SAS, SAS/STAT, SAS/GRAPH, SAS/CONNECT, SAS/ACCESS, EG/BI
SDLC, UTC, UAT, ADAM, SDTM, CDISC
SAS Consultant Marketing Analyst (December 2014 – December 2017)
Abbvie, Mettawa, IL Abbot Park, IL
PC SAS, SQL, EXCEL, UNIX SAS, Oracle, PowerPoint, Spotfire, PERL/SCL
Develop and maintain all SAS applications for the Marketing and IT departments utilizing PC SAS and UNIX SAS. Provide technical guidance and assistance in software design, programming, and testing. Analyze clinical data to make suggestions to the Sales Reps on marketing interactions with doctors and update regional tv ads for the following year.
Increased company’s analytics efficiency by creating an internal, analytical database.
Reduced IT support ticket time through assisting with the responding and resolution of system user tickets.
Established as the subject matter expert on all company SAS utilities.
SAS Consultant Programmer Analyst (December 2012 - March 2014)
HSBC, Mettawa, IL
PC SAS, Mainframe SAS, SQL, JCL, ETL, CLIST, EXCEL, VBA, TSO/ISPF
Streamlined the month end close out programs for data collection and analysis using PC SAS and Mainframe SAS. Developed, implemented, and maintained SAS application software.
Revitalized month end processes resulting in a decrease in time and resources through SAS automation.
Increased system resource efficiency by converting projects from mainframe to client-server based environment, allowing the use of Oracle, Teradata, and SAS Dataset analytic reporting tools.
Statistician Programmer Analyst (January 2002 - December 2011)
GlaxoSmithKline, Zebulon, NC
PC SAS, ETL, HTML/ASP, DB2, SQL, Access, EXCEL, VBA, Oracle/Toad, XML, SharePoint
Created statistical programs and clinical analytical reports from the LIMS system data for submission to the FDA using PC SAS and SAS HTML/ASP. Fulfilled unexpected department requests for analysis with adhoc analytical reports for Product Owners.
Delivered SQL database to stored data for over one million clinical records.
Enhanced statistical report retrieval for FDA submissions to decrease requests by statistical teams.
Spearheaded three-member team to deliver an online intranet system that provides for LIMS/SAP system statistical report retrieval.
SAS Consultant Programmer Analyst (May 2000 - May 2001)
IBM/Qualex, Durham, NC
Mainframe SAS, SQL, JCL, ETL, TSO/ISPF
Enhanced department efficiency through the creation of adhoc analytical reports, used in company portfolio analysis.
Maintained sales and marketing programs and reports for production.
Programmer Analyst (December 1992 - November 1999)
Household Financial Corporation, Prospect Hts, IL
Mainframe SAS, SQL, Mainframe COBOL, PC SAS, ETL, JCL, TSO/ISPF, CLIST
Programmed, instituted, and maintained Credit Risk Department SAS Database using Mainframe SAS, COBOL and PC SAS. Created adhoc analytical reports while acting as department troubleshooting manager. Facilitated mainframe and SAS training for new MIS programmers. Fulfilled analytical requests on company portfolio signifying risk, revenue and delinquency.
Lessened organizational outsourcing fees by $250,000 by negotiating a specialized programming niche that automated production reports.
Minimized CPU usage through efficient programming code used to automate hundreds of analytic reports.
Facilitated finance company merger through the conversion of data from multiple platforms into consolidated analytical reports.
MIS Programmer, Household Retail Sevices, Inc.
EDUCATION & CREDENTIALS
B.A, Computer Science/Mathematics
Blackburn College, Carlinville, IL
Nominee for the United States MCM competition in Mathematical Modeling.
Received outstanding achievement award due to command of programming language and report efficiency.