SAS Programmer Resume Profile

SUMMARY

Over 7 years of Professional Experience in SAS Programming, Administration, ETL, Data Mining, Report Writing, and Web Development in the Financial, Auto and Consulting Industries.
Extensive experience with the SAS programming language and SAS tools such as Base SAS, SAS Macros, SAS/SQL, SAS/GRAPH, SAS/CONNECT, SAS Enterprise Guide, SAS OLAP Cube Studio, SAS Web Report Studio, SAS Information Delivery Portal, SAS Information Map Studio, SAS Management Console.
Seasoned experience with popular BI Tools such as Tableau, Hyperion, Aginity for Netezza, TOAD, MySQL, SQL Plus, SQL Server, Microsoft Office
High-level experience in accessing data warehouse structures such as Oracle, Netezza, Teradata, Access for data extraction and analysis
Proficient in operating systems like Windows UNIX/LINUX
Excellent understanding of high-level business concepts, problem-solving, decision making, strong team working capabilities, flexible to work in fast paced work environment under strict time limits.

WORK EXPERIENCE

Confidential

SAS Consultant Contractor

Develop executive-level dashboards and reports for TFS Collections Risk Department
Use SAS OLAP Cube Studio to create OLAPs, hierarchies, run-time metrics, n-way aggregations
Perform t-tests, linear regressions, and logistic regressions on key collection and risk metrics
Use SAS Enterprise Guide to create graphs, cascading prompts, and deploy stored processes
Performing version upgrades of SAS tools and software for eligible end-users
Perform root cause analysis on SAS Platform and related software issues
Educate SAS users on SAS best practices including password encryption and memory usage
Create analyst-level dashboards and pivot tables using Tableau and Hyperion BI
Develop SAS Metadata API that register and publish reports for SAS IDP and Web Report Studio

Confidential

SAS BI Analyst Contractor

Develop SAS programs and macros for reporting and analytical purposes
Use SAS coding techniques including Hash Object, Proc SQL, and date logic to create dynamic reporting processes used for monthly analysis
Integrate UNIX and SAS using the X command and Systask function for submitting programs and reporting processes
Write Teradata SQL queries to pull data from SAS data warehouse
Create pivot tables and reports from SAS data output in Microsoft Excel and SQL Server
Upgrade data processing by adding sophisticated business logic and quality coding to improve the efficiency of company resources

Confidential

SAS BI Developer Contractor

Develop Web-scraping code in SAS to collect publicly available data and load into MySQL tables
Write parsing routines, data-cleansing, and data quality SAS macros in order to transform and load the data into a highly structured SAS Datamart
Create linear regression charts and graph changes in moving averages via SAS Enterprise Guide
Create statistical procedures to analyze data using Procs: Means, Freq, and Summary
Develop enhanced multi-sheet Excel and PDF-based reports using SAS ODS and DDE technology

Confidential

SAS Programmer Contractor

Develop SAS programs and macros for ETL processes in a UNIX environment
Create web-based reports using the SAS ODS facility and SAS graph
Write SQL queries to load Oracle data and text files into SAS data warehouse
Setup database connections, profiles, and other SAS services in SAS Management Console
Automate tedious processes in UNIX environment with korn-shell and Perl scripts

COMPUTER SKILLS

Languages: SAS, SQL, Korn Shell, Perl, XML, HTML
Software: SAS 9.3, SAS Enterprise Guide, SAS MC, SAS OCS, Aginity, SQL Server
Data Reporting Tools: Tableau, SSRS, SAS IDP, SAS WRS, Hyperion, Microsoft Office
Databases: Oracle, MySQL, Access, Sybase, Netezza, Teradata
Macromedia: Front Page, Dreamweaver
O/S: Windows Server, UNIX: HP, Solaris, Linux