We provide IT Staff Augmentation Services!

Sas Statistical Analyst Resume

Seattle, WA

SUMMARY

  • Certified SAS Programmer with more than Seven years of experience in Marketing Campaign Analysis, Financial and Risk Analysis
  • Knowledge on SAS efficiency techniques and experience in handling huge volumes of data
  • Experience in Base SAS, SAS Enterprise Guide, Macros, SQL, SAS/STAT, SAS/Access, SAS/GRAPH and SAS/ODS
  • Experience with PROC SQL, writing queries, using Left Join, Right Join, Outer Join and Union.
  • Strong expertise in reporting and summarizing data using PROC REPORT, PROC TABULATE, PROC SUMMARY and PROC FREQ
  • Worked in Data Mining, Statistical environment and extensively used SAS Enterprise Miner for modeling
  • Hands - on experience in Data mining techniques such as Association, Clustering and Decision trees
  • Extensively used Enterprise Miner for Data mining, Predictive modeling and statistical analysis for marketing campaigns
  • Hands-on experience with SAS Model Manager for implementing and tracking of models
  • Strong understanding in various SAS STAT techniques such as ANOVA, Pearson chi-square test, T-Test, Correlation and Regression Analysis
  • Experience in accessing RDBMS databases such as Oracle, Teradata using TOAD and Oracle SQL Developer, Teradata developer, SQL Server and SAS/Access facility
  • Thorough hands-on experience in using ODS to generate different files including RTF, MS Excel, PDFs and HTMLs
  • Extensively worked on SAS views and SAS Indexes to reduce I/O bottlenecks and processing time for large volumes of data
  • Expertise in using SAS/ETS and SAS Forecast Studio for time series forecasting
  • Proficient in using Import and Export procedures to handle data in raw text format, ORACLE and Teradata database management systems
  • Ability to work in fast paced environment with little or no documentation, able to employ new ideas, concepts, methods, and technologies
  • Strong Analytical, Diagnostic skills and ability to work in a fast-paced and Team-oriented environment.
  • Strong interpersonal, organizational communication, customer service & presentation skills.

TECHNICAL SKILLS

SAS TOOLS: SAS/BASE, SAS/STAT, SAS/MACRO, SAS/GRAPH, SAS/ODS, SAS/ACCESS, SAS/Connect, SAS/Enterprise Guide, SAS/ETL

STATISTICAL SOFTWARE: SAS, Matlab, R, SAS Enterprise Miner, EViews, SPSS

DASHBOARD: Tableau

RBDMS: Oracle, Teradata

OPERATING SYSTEMS: Windows, UNIX

PROFESSIONAL EXPERIENCE

Confidential, Seattle, WA

SAS Statistical Analyst

Responsibilities:

  • Developed SAS code for conducting ETL from Teradata, Excel and flat files using SAS/Base procedures and SAS/Access facility
  • Conducted data processing and validations on SAS data sets using edit check programs
  • Involved in statistical analysis using various SAS products SAS/BASE, SAS/SQL, SAS/STAT, SAS/ACCESS and SAS/MACROS etc.
  • Extensively used SAS ETS for building forecasting models for sales in North American market
  • Involved in Data Analysis, Data preparation and Graphical Presentation with extensive use of SAS Base, SAS Macro and SAS Enterprise Guide.
  • Involved in standardizing reporting procedures for graphical and tabular reports and developed macros to produce reports on weekly basis
  • Interacted with business partners on requirement gathering and transformed business requirements in to technical documents for reporting and coding
  • Extensively used statistical procedures and predictive modeling techniques such as ANOVA, Regression Analysis, Trend Analysis, Cluster Analysis and Principle Component Analysis
  • Used SAS Enterprise Miner to build Neural Network, Logistic Regression and Decision Tree models for sales and customer retention programs
  • Modified SAS Enterprise Miner generated code to run in SAS/Base environment, extensively conducted QA to maintain the integrity of the models
  • Conducted QA for macros generated by other programmers using Macro options MLOGIC, SYMBOLGEN, MPRINT, MACROGEN etc.
  • Performed documentation of the SAS Code for the better understanding of the program

Environment: Base SAS, SAS Macros, SAS/Access, SAS/STAT, SAS/GRAPH, SAS/IML, Enterprise Miner, SAS Forecast Studio, Teradata, Excel, Windows, UNIX.

Confidential, Atlanta, GA

SAS Programmer/Analyst

Responsibilities:

  • Involved in marketing campaign-planning along with program managers in order to develop campaigns specification document
  • Participated in brainstorming sessions with the clients and prepared Business Requirements Document
  • Extracted data from the database using SAS/Access, SAS SQL procedures and created SAS data sets
  • Developed SAS programs to create a customer mailing list for Direct Mailing
  • Conducted data analysis, developed reports with extensive use of BASE SAS, macro and SAS reports with the help of default procedures
  • Utilized large customer response and sales data sets to generate graphs using SAS Report and SAS /GRAPH
  • Generated summary statistics using various procedures like PROC FREQ, PROC MEANS
  • Maintained and improved existing SAS reporting programs for marketing campaigns
  • Analyzed response and sale results and prepared monthly summary on campaign performance
  • Developed Data Models for different level of Marketing based on the reports
  • Revised and automated daily, weekly, monthly and quarterly reports to run more efficiently and provide more meaningful information vital to the overall strategies
  • Exported SAS summary results into excel sheet and submitted the data to the marketing team
  • Worked with marketing departments to develop and maintain applications for customer retention analysis, identifying cross-sell opportunities

Environment: SAS/BASE, SAS/MACRO, SAS/ACCESS, SAS/STAT, SAS/ODS, SAS/GRAPH, SAS Enterprise Guide, Enterprise Miner, Excel, Windows, UNIX.

Confidential, CA

SAS Programmer/ Marketing Analyst

Responsibilities:

  • Go through the BRD (Business requirement Document) to understand the requirements and configure codes to read data from designated Teradata tables
  • Designed, developed, implemented and maintained targeted marketing campaigns and analytic programs. Ensured integrity of campaigns and analysis through rigorous attention to detail and validation of data
  • Extracted and processed large quantities of data from the various data marts using SAS/Access, PROC SQL pass through facility and different data steps respectively used to create SAS datasets
  • Implementing various logics, creating various channel specific reports for auditing and verification purposes using SAS/SQL
  • Worked with complex datasets to extract customized reports using PROC SQL, PROC FREQ, PROC SORT, PROC REPORT and PROC MEANS for creating a preferred list of customers as per the given requirements from business analysts
  • Created Macros and used existing company standard macros and developed SAS Programs for Data Cleaning, Validation, and Analysis and Report generation. Tested and debugged existing macros
  • Development of standard SAS macros to be used throughout out the marketing campaigns
  • Developed ad-hoc-reports as per business requirements and created various reports like summary reports, tabular reports using PROC REPORT, PROC TABULATE, statements ODS and PROC TEMPLATE to generate output formats in HTML
  • Professional Debugging, Revision and Testing of all deliverables, including Production Code, to abide by QC Checks, Execution standards and Maintenance requirements
  • Revised and automated daily, weekly, monthly and quarterly reports to run more efficiently and provide more meaningful information vital to the overall strategies

Environment: SAS/Base, SAS/ODS, SAS/Stat, SAS/Access, Enterprise Guide, Teradata, Ultra Edit.

Confidential, TX

SAS Consultant/Analyst

Responsibilities:

  • Used SAS/Access facility to connect to Teradata and used SAS SQL procedures to extract and manipulate data
  • Developed SAS MACRO scripts to check data quality, generate descriptive statistics for modeling and scoring data sets
  • Assisted lead programmer/statistician by creating historical data base for predictive modeling
  • Involved in all stages of model development including model data set generation, model building, validation and tracking performance
  • Maintained logistic regression and decision tree models using SAS/Base and SAS Enterprise Guide.
  • Used SAS/STAT procedures such as Proc Univariate, Proc Means, Proc Surveyselect, Proc Reg and Proc Logistic
  • Used SAS Model Manager to score and track existing models and generate quarterly reports
  • Developed statistical models for loss forecasting, automated the process to enable auto updates for monthly forecasts using SAS Forecast Studio
  • Developed SAS programs to create mail lists for satisfaction survey to eventually estimate their churn likelihood
  • Used SAS Enterprise Guide and Teradata extensively for Ad hoc reporting
  • Modified existing and new SAS jobs that generate reports, and to send them as PDF or HTML attachments or as body of the email
  • Reviewed various documents and source systems schema to improve business understanding and data understanding
  • Acted as liaison between on site management and off shore teams and contributed for completing the project with in timeframe

Environment: SAS/ACCESS, SAS/BASE, SAS/STAT, SAS/GRAPH,Teradata, SAS Forecast Studio, MS OFFICE

Confidential, CA

SAS Programmer/Business Analyst

Responsibilities:

  • Automated ETL-Extraction/Transformation/Loading to create SAS data sets from Excel, flat files and Oracle using SAS/Access, SAS SQL procedures
  • Data processing and validations were done extensively on the SAS datasets using edit check programs
  • Involved in standardizing reporting procedures for graphical and tabular reports
  • Developed SAS programs to create a customer Mailing list for Direct Mailing
  • Acted as liaison between various Survey / Research providers to meet specific data needs and providing quick support in the form of data appends and ad hoc reports
  • Worked with large customer response datasets and generated graphs using SAS Report and SAS /GRAPH
  • Involved in Data Analysis, Data preparation and Graphical Presentation with extensive use of SAS Base, SAS Macro and SAS Enterprise Guide
  • Maintained and enhanced existing SAS reporting programs for marketing campaigns
  • Conducted individual account and household level analysis and conducted significance tests and study response rates for different offers
  • Analyzed response and sale results and write up monthly summary on campaign performance
  • Revised and automated daily, weekly, monthly and quarterly reports to run more efficiently and provide more meaningful information vital to the overall strategies
  • Extensively used SAS Enterprise Miner to perform various marketing analytics like segmentation, clustering and profiling for customer retention
  • Involved in Data mining on customer database using SAS Enterprise Miner
  • Developed ad hoc -reports as per business requirements and created various reports like summary reports, tabular reports
  • Involved in statistical analysis using various SAS products SAS/BASE, SAS/SQL, SAS/STAT, SAS/ACCESS and SAS/MACROS
  • Wrote programs in SAS to generate reports, HTML listings and tables using SAS ODS
  • Automated report procedures using Kron Scripts in Unix Environment.
  • Developed Macros in Shell Scripts for Data Management, Submitting batch jobs

Environment: SAS/BASE, SAS/Macro, SAS/STAT, SAS Enterprise Guide, SAS Enterprise Miner, SAS/CONNECT, SAS/GRAPH, SAS/ACCESS, SAS/ODS, Oracle, PL/SQL, UNIX, MS EXCEL, MS ACCESS

Confidential

SAS Analyst

Responsibilities:

  • Conducting analysis on client consumer databases looking Confidential profitability, transaction behavior, and demographic characteristics.
  • Providing segmentation for database marketing efforts, such as CHAID, cluster analysis, and customer profiling.
  • Responsible for statistical applications support and programming primarily in SAS, supporting Marketing team in ACOE.
  • Generating Regular, Ad-Hoc Reports using SAS Tools and Oracle.
  • Write macros to organize data files to business specifications within standard office applications such as Excel, Access, Word, and PowerPoint.
  • Building Statistical Models and Regression Models using SAS Tools and conducted model performance tracking on regular intervals
  • Developing Acquisition Models based on demographics data, sales data and internal and external data sources.
  • Setting up and scheduling processes using cronjobs in UNIX

Environment: Base SAS, SAS Macros, SAS/Access, SAS/STAT, SAS/ETS, SAS DDE, SAS ODS, VBA for Excel, SAS/GRAPH, ORACLE, TOAD, PL/SQL, SAS Indexes, SAS Views, Excel.

Hire Now