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.