SAS BI Analyst Resume Profile

SUMMARY

Over 7 years of Professional Experience in SAS Programming, ETL, Data Mining, Report Writing, and Web Development in the Financial, Auto and Consulting Industries.

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
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, Microsoft Office, Tableau
Databases: Oracle, MySQL, Access, Sybase, Netezza, Teradata
Macromedia: Front Page, Dreamweaver
O/S: Windows Server, UNIX: HP, Solaris, Linux

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship