SAS Developer / Analyst Resume Charlotte, NC - Hire IT People

SUMMARY

10+ years of quantitative / analytical experience in SAS / statistical data analysis
SAS certified Predictive / Regression modeler, Base, Advanced and Clinical Trials Programmer
Skilled researcher with hands - on experience on research, SAS programming, data management, data manipulation, data cleansing, deep dive analytics and reporting
Extracted, transformed and loaded (ETL) data to data warehouse (Teradata / Netezza) using SAS
Proficient with all basic and advanced SAS packages, SAS Data Integration (DI) studio, SAS Web Reporting Studio, SAS procedures, SAS stored processes, SAS macros
Performed unit testing / user acceptance testing of SAS programs and reports
Project management, research, mentoring and supervisory experience

TECHNICAL SKILLS

SAS packages: SAS/BASE, SAS/STAT, SAS/GRAPH, SAS/MACRO, SAS/ODS, SAS/ACCESS

SAS procedures: PROC SQL, PROC REPORT, PROC FORMAT, PROC FREQ, PROC MEANS, PROC UNIVARIATE, PROC SUMMARY, PROC CONTENTS, PROC REG, PROC LOGISTICS, PROC TRANSPOSE, PROC GLM, PROC CORR, DATA NULL

Databases/EDW: Teradata, DB2, MS-SQL, Oracle

Automation: Unix Crontab, Autosys JIL setup, Stored processes, Web reporting studio

ETL: SAS Enterprise Guide, Hyperion, Teradata SQL Assistant, Toad for Oracle, DI Studio

Office: Microsoft Word, Excel, Pivot tables, VBA macros, PowerPoint presentations, SAS Add-in

BI Dashboard: Tableau, Excel (Add-on)

FTP: Tectia, WinSCP

Statistical analysis: Trend analysis, time series, visual analytics, regression, predictive modeling, linear model, ANOVA, T-test etc.

PROFESSIONAL EXPERIENCE

SAS Developer / Analyst

Confidential, Charlotte, NC

Responsibilities:

Created and tested Anti-Money Laundering scenarios using SAS that created events and cases for investigators to follow up with FBI to counteract fraud and money laundering activities.
Used several Extraction, Transformation and Loading (ETL), SQL RDBMS and FTP tools (SAS EG 5.1, Teradata SQL Assistant, Toad for Oracle, Toad for MS SQL, MS Excel, UNIX, Tectia).
Dealt with millions to billions of banking customer transaction data under Teradata environments.
Coded SQL statements in Teradata SQL assistant to validate records, load data, extract data and summarize millions of banking transactions
Enhanced the scenarios by tuning and changing the SAS code. Debugged several production related issues using innovative SAS coding techniques.
Tested the SAS scripts under various Teradata environments - Unit Testing / User Acceptance Testing / System Integrated Testing / Testing under Production environment
Deployed the scenarios to the automation tool - Autosys.

Specialist / SAS Programmer

Confidential, Atlanta, GA

Responsibilities:

Analyzed millions of customer service satisfactory survey data obtained from US domestic and international air markets and created graphical, tabular reports and communicated insights
Extensively used Teradata and DB2 table queries in SAS and Hyperion
Developed ETL processes using SASData Integration (DI) studio - developing, automating and testing source to target mapping.
Created trending control charts reporting for flight inoperative items and communicated results via automated emailing to managers and directors in other divisions
Created automated historical, daily, weekly and monthly reliability report for employee unscheduled absences rate and setup automatic emailing to SVP, Directors and Managers
Performed detailed root cause analysis of performance impacts and development of recommended actions to continuously improve operational performance and customer service.
Evaluated market Economy Comfort sales analysis for international markets
Created and automated more than 20 reports using advanced SAS tools such as Cron tabs, Control-M, Stored Processes, DI Studio, Web reporting studio, SAS MS Office Add In.
Developed code with Enterprise Guide (EG) to support ad-hoc requests.
Analyzed close to 200 million records and created series of graphs and tables for market research and communicated results cross-divisionally to Managers
Applied knowledge of Continuous Improvement on several projects

SAS programmer Analyst

Confidential, Atlanta, GA

Responsibilities:

Analyzed Confidential In-Flight Service (IFS) customer satisfactory survey data, ACARS (Aircraft Communication Addressing and Reporting System) data, various other IFS survey data by different markets and entities worldwide.
Successfully created reports from the above analysis using SAS Enterprise Guide 4.3 and Microsoft Excel 2007 on a daily basis.
Performed top 5, top 20, top 100 markets and Flight Attendants with high satisfactory scores
Created Pareto charts for different analysis to graphically summarize and display the relative importance of the promotional data
Automated several SAS reports using advanced SAS CRON jobs

We provide IT Staff Augmentation Services!

Sas Developer / Analyst Resume

Charlotte, NC

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship