SUMMARY

• SAS Programmer with 6 years of experience in design, development and implementation of analytical solutions and data analysis with profound expertise in banking/finance, retail and energy related industries.
• Solid understanding and proficient use of various procedures like PROC SQL, PROC SUMMARY, PROC REPORT, PROC FREQ, PROC MEANS, PROC CONTENTS, PROC DATASET, PROC APPEND, PROC REG, PROC IMPORT, PROC EXPORT, PROC PRINT, PROC SORT.
• Experience in using SAS to import/export data to external file formats like flat, Excel, XML files.
• Thorough knowledge in SAS Programming, using Base SAS, Macro Facility, PROC SQL, SAS Procedures, SAS Functions, SAS Formats, and ODS facility in data scrubbing, manipulation, and preparation to produce summary datasets and reports. Hands - on experience using analytical software like SAS Enterprise Miner 12.1, SAS Enterprise Guide 5.1, SAS/JMP, Base SAS 9.2, SAS/Macros, SAS/SQL, SAS/STAT, SAS/GRAPH, SAS/ETS and SAS/ODS, SPSS, SQL etc.
• Worked extensively on SAS Procedures and Data Step Programming to develop the process flow applications from Data Acquisition to Data Exploitation/Reporting.
• Expert in modeling techniques like regression, decision trees, neural networks, clustering, market basket analysis etc.
• Excellent Knowledge of statistical analysis like ANOVA, multivariate analysis, T-tests, Chi-Square tests, Correlation etc.
• Experience in writing ad-hoc queries to service ad-hoc report requests.
• Thorough knowledge on Database Programming Languages such as SQL, PL/SQL.
• CRISP-DM in data mining. Software Development Life Cycle (SDLC) and Agile methodologies in system development (SCRUM)
• Expertise in translating functional requirements to technical specification, develop modular program code and documentation.

TECHNICAL SKILLS

SAS Programming Tools: SAS Enterprise Guide 5.1,SAS Enterprise Miner 12.1, SAS Sentimental Analysis, SAS Forecast Studio, SAS/BASE, SAS/STATSAS/SQL, SAS/ODS, SAS/GRAPH, IBM CognosIBM SPSS Modeler, Tableau, JMP, Microstrategy.

Databases: Oracle 11g, MySQL Server, MS Access

Technologies: SAS Programing, SQL, C, C++, JAVA, PL/SQL, PHP

Web Application Tools: HTML, CSS, JavaScript

Others: SAP, MS Office, MS Visio, MS Word, MS Excel, MS PowerPoint, MS Outlook, Use Case Modeling, Agile (SCRUM) tools

PROFESSIONAL EXPERIENCE

Confidential, Richmond, VA

Senior SAS Programmer Analyst

Responsibilities:

• Developed applications for measuring financial performance of newly acquired accounts: Forecast vs. Actual and developed SAS programs for generating reports on key financials, income statements, and balance sheet.
• Extracted data from different sources like Oracle and Teradata and text files using SAS/Access, SAS SQL Procedures and created SAS datasets.
• Used SAS Procedures like PROC FREQ, PROC MEANS, PROC SORT, PROC PRINT,PROC TABULATE AND PROC REPORT in order to understand and prepare the data.
• Developed and designed SAS programs/macros to analyze financial data and to create files, tables, listings, and graphs. Developed ad-hoc reports as per business requirements and created various reports like summary reports, tabular reports.
• Developed SAS programs for statistical analysis and data displays working with various SAS products SAS/BASE, SAS/SQL, SAS/STAT and SAS/MACROS etc. to develop solutions.
• Wrote programs in SAS generate reports, creating RTF, HTML listings, tables and reports using SAS ODS for ad-hoc report generation.
• Used Enterprise Miner to model and conduct predictive analytics like regression, decision trees, neural networks, Ensemble, cluster analysis etc. for household level analysis
• Various models like decision trees, neural network, CHAID decision tree and Logistic regression have been built for analysis using SAS and IBM SPSS modeler.
• Performed logistic regression, neural networks and decision trees using SAS and IBM SPSS Modeler to provide recommendations
• Generated descriptive analysis using Tableau.
• Created various dashboards for better understanding of the models results using visualization tools like IBM SPSS modeler and Tableau.

Environment: SAS Enterprise Miner, SAS Enterprise Guide, IBM Cognos, IBM SPSS Modeler, Tableau, MS Excel.

Confidential, Oklahoma City, OK

SAS Consultant

Responsibilities:

• Used PROC SQL to extract data and wrote SQL queries efficiently.
• Extracted data from MS Access, Excel and Oracle to generate reports.
• Accessed multiple databases usingSASand provided ongoing reporting that supported information-based decision making, measured the execution of various strategies and identified opportunities for improving existing processes.
• Responsible for analyzing experimental data, investigate relationships in contingency tables.
• Responsible for evaluating market research data and organizing observations.
• Used BaseSASandSAS/Macro Procedures to create tabular reports.
• Wrote numerousSASStored processes.
• Developed SAS programs for statistical analyses and data displays.
• Used Procedures such as PROC REGRESION, PROC FREQ, PROC FORMAT, PROC MEANS, PROC SORT, PROC PRINT, PROC TABULATE and PROC REPORT.
• Developed various reports like summary reports, tabular reports, excel reports etc., as per business requirements and created.
• Developed, tested and maintained daily/monthly/quarterly report packages illustrating progress towards the strategic objectives.
• Documented policies and Procedures required for supporting system enhancements.

Environment: SAS Enterprise Guide, SAS Macro,SAS/SQL,SAS/Graph,SQL, MS Excel, Oracle Interval

Confidential, Miami, FL

SAS Analyst/Developer

Responsibilities:

• Built customer segmentation and profiling based on purchase history and predicted customer behavior by preparing the data set by filtering, sorting and imputing the missing values to the data set.
• Performed descriptive and predictive analysis to understand the overall trend patterns of transactional data of the company.
• Built customer segmentation and profiling based on purchase history.
• Grouped customers based on their purchase history and monetary contribution to the company by performing RFM (Recency, Frequency and Monetary) Analysis to determine the most profitable customer.
• Predictive modeling techniques such as decision trees, Gini tree, Entropy tree, forward regression, stepwise regression and auto neural network have been used to build various models for analysis.
• Based on the results of descriptive and predictive analysis the best model has been chosen that generated the highest net revenue.
• Based on the best performing model, scored the given data on it to predict the revenue for the company.
• Provided updates to the senior team members on the analysis of different testing cycles.
• Coordinated and mentored other SAS programmers, technical assistance and trouble shooting and attending project team meetings

Environment: SAS Enterprise Miner, SAS Enterprise Guide, MS Excel, SQL, IBM Cognos, IBM SPSS Modeler, Tableau.

Confidential

SAS Programmer

Responsibilities:

• Extensively used SAS Data Step functions and descriptive statistical Procedures to process large amounts of customer response and sales data.
• Extensively used PROC Import and PROC Export Procedures for importing and exporting PC files and Microsoft office files such as Excel Spreadsheet, Access Tables.
• Worked on various SAS products SAS/BASE, SAS/SQL, SAS/STAT, SAS/ACCESS and SAS/MACROS to develop solutions.
• Assisted in the design and development of SAS programs required to administer compensation agreements.
• Ability to independently research both internal and external questions and provide input and suggestions for system sustainability, programming, new processes, etc.
• Ensured sufficient documentation is available (and provided) to support audits including current/historical documentation of programming and system changes and additions to support the program.
• Served as data custodian and point of contact for operational data warehouse issues.
• Developed new/modified macros for report generation using SAS / Macros as per business requirements.
• Designed and created SAS datasets from various sources like Excel datasheets, flat files and Oracle, created reports and files from existing SAS datasets.
• Communicated with various personnel in the forecasting group and the statistical group for various requirement gathering and analysis of the data.
• Involved in Documentation, presentation, data reports and model results to the team/manager.
• Independently performed analyses of issues, participated in development of potential solutions, and made recommendations to ensure accurate and timely resolution.

Environment: SAS Enterprise Guide, Base SAS, SAS Macros, SAS/Access, Oracle, SQL, SAS/SQL, MS Excel