PROFESSIONAL SUMMARY:

• Around 8 years of experience as a Sr. SAS Programmer/Analyst involved in, Financial Analysis,HealthCare, Retail, Mortgage and Banking sectors.
• Expert in using PROC SQL, PROC Report, PROC Freq, PROC Summary, PROC Access, PROC Means, PROC TRANSPOSE, PROC Tabulate, PROC GPLOT, PROC Chart, PROC Datasets, PROC Format, PROC Import and PROC Export.
• Hands on Experienced in BASE SAS, SAS/STAT, SAS/MACROS, SAS/GRAPH, SAS/SQL, and SAS/ODS, SAS/ACCESS, SAS/Graph.
• Proficient in Macro Facility, SAS Procedures, SAS formats, SAS functions, SAS statements, SAS Informats, Merging SAS Data sets, preparing data, producing reports, storing and managing data in SAS.
• Extensive experience in SAS Financial Management (FM),Campaign Management (CM), SAS, SAS Management Console, Enterprise Guide (EG 4.0),
• Expertise in Marketing Strategy development, financial models, projections, Basel II Compliance, DSS Decision Support Systems and documentation, Risk Analysis, Correlation and Regression including Multiple regression, Logistic Regression, Multivariate Analysis, Projections, Time series Analysis, Factor Analysis and Forecasting.
• Extensively worked on SAS views and SAS Indexes to reduce I/O bottlenecks and processing time for large volumes of data.
• Strong understanding in various Economic/Econometric and statistical concepts such as ANOVA, Correlation, Regression Analysis and Multivariate Analysis.
• Experience in design and developing of SAS programs to analyze and generate Files, Tables, Listings, Graphs, Validations, Documentation.
• Knowledge in using SAS/ACCESS to Export, Transfer and Load (ETL) data from ERP packages.
• Knowledge in data warehousing and business intelligence concepts, design principles
• Experience in RDBMS development including SQL, PL/SQL languages.
• Proficient in using Import and Export procedures to handle data in raw data files ORACLE, DB2, TERADATA and SYBASE database management systems.
• Quick learner with ability to understand job requirements employs new ideas, concepts, methods, and technologies.
• Strong analytical, diagnostic skills and ability to work in a fast - paced and team- oriented environment.

TECHNICAL SKILLS:

SAS Tools: SAS 9.1/9.2, SAS/BASE, SAS/ACCESS SAS/GRAPH, SAS/STAT, SAS/SQL, SAS/ODS.

SAS Procedures: Proc Print, Means, Univariate, Report, Summary, Tabulate, Freq Sort, Format, Copy, Compare, Gplot, Transpose.

Languages: SAS/SQL, SPSS, R

Office tools: MS office 2003/2007/2010, Word, Excel and PowerPoint.

Operating Systems: Windows XP/2000/98 and Mackintosh systems

PROFESSIONAL EXPERIENCE:

Confidential, MA

Sr.SAS Programmer/Analyst

Responsibilities:

• Development and analysis of dataset specifications and SAS based utilities, Data capture, design review and input into data standards.
• Modified existing SAS programs and created new programs using SAS macro variables to improve ease and speed of modification as well as consistency of results.
• Extensively used different SAS/STAT procedures like PROC Means, PROC Summary, PROC Freq, PROC Univariate, etc.
• Was involved in generating customized reports using SAS procedures such as Proc tabulate and Proc Report.
• Has a strong understanding of the regulatory process and detailed understanding of the analysis and reporting process and implications on programming
• Ensure analysis data and programming code meet regulatory and company standards and are consistently structured to permit efficient programming and reporting
• Ability to perform advanced level activities using application based reporting environments (including high complexity dataset creation and study specific macros) as per the intended and most efficient use of the application
• Implementation of Credit Risk Analysis reporting system based on credit Scores and data management principles, mainly including joining data set, indexing, data aggregation, record selection, sub-setting, multiple records per case, creation and modification of views.
• Developing and designing SAS Programs/ Macros to analyze financial data. Statistical analysis files, tables, listings, and graphs.
• Generate SAS reports, creating RTF, PDF, HTML listings, tables and reports using SAS ODS for ad-hoc report generation.
• Analyzed and interpreted numerical data from various sources organized and summarized data for analysis.
• Presented numerical information in various formats. Created SAS customized reports using the DATA NULL technique.

  Environment: SAS/BASE 9.3, SAS/STAT, BI, SAS/SQL, SAS/GRAPH, SAS/MACRO, SAS/EG, SAS/ODS, SAS/ACCESS and MS Access Database

Confidential, Las Vegas NV

Sr.SAS Consultant/Analytics

Responsibilities:

• Identify, analyze and bring to management's attention significant trends that affect business strategy and program objectives.
• Attended various seminar presentations on Medicaid Fraud such as finding duplicate claims, service after death, multiple service providers etc.
• Used SAS/ACCESS to read datasets from Teradata, Flat files, also read and write other PC File formats.
• Created scripts in UNIX to help improve the efficiency of the application.
• Generated SAS/MACROS and stored procedures for reusability and to minimize data processing.
• Extensively used SQL statement functionalities for analysis of large datasets and for data manipulation.
• Monitored and managed the data feeds into the data warehouse as well as extraction transformation and loading.
• Assist in developing predictive models to evaluate potential clients.
• Created permanent formatted SAS data sets for present and future analysis.
• Develop management reports and assist in presenting important issues to management.
• Work independently in the development, testing, implementation and maintenance of systems of moderate - to-large size and complexity.
• Support management through detailed analysis of production results, compared and contrasted with external healthcare trends.
• Extensive worked on detecting, describing and verifying defects, bug tracking and modifying the existing datasets for the improvement of the existing system.
• Performed Data Cleansing by analyzing and eliminating duplicate and inaccurate data using PROC FREQ, PROC COMP, PROC UNIVARIATE, and SAS/MACROS.
• Generated high quality reports in the form of listing, HTML, RTF and PDF formats using SAS ODS.

Environement: SAS BASE, SAS/MACROS, SAS/ODS, SAS/STAT, SAS/GRAPH, SAS/ACCESS, SAS/SQL, Teradata, SAS Enterprise Guide, SAS Enterprise Miner, MS Office, Windows XP

Confidential, IA

Sr.SAS/SQL Reporting Analyst

Responsibilities:

• Worked with the analysis teams and the risk management teams and supported them by providing variables based on their requirements.
• Developed SAS BI Dashboards which are used to monitor key performance indicators.
• Made transaction data broadly accessible to program teams and worked towards implementing the targeted business strategies.
• Created reports using SAS Enterprise Guide for summarizing portfolio experience, including information about the current business environment, portfolio trends, expected portfolio losses and the forecast assumptions.
• Developed new SAS programs to generate new reports in HTML, RTF and txt format.
• Facilitated the automation process for the Delinquency Report - This report was required to run on a monthly basis and was required to show 13 months of data.
• Automated many standard and ad hoc reports generation and also involved in creating New Scorecards and Reporting the changing values.
• Used SAS ODS, SAS Graph, and procedures Proc Tabulate, Proc means to create ad hoc reports and graphs as per the requirements of the users.
• Developed statistical reports with Charts, Bar Charts, Box plots, Line plots using PROC GPLOT, PROC GCHART.
• Used Proc Template to produce customized report in spreadsheet with footnotes, titles, and pages numbers, eliminating user's work to customize the report.
• Created monthly, quarterly, and annual performance reports for senior management using SAS/EG and PC SAS.
• Developed, validated, updated and documented reporting system.
• Worked closely with other finance group, campaign team and senior management.
• Extensive use of Proc freq, Proc Report, and Proc Tabulate for reporting purposes.
• Participation in strategic initiatives, which includes leading, organizing, and facilitating initiatives and/or meeting from a risk perspective.

Environment: SAS v9.1.3, SAS/BASE, SAS/GRAPH, SAS/SQL, SAS/MACROS, SAS/EG, Oracle, DB2, SAS/ACCESS, Excel.

Confidential, Hartford CT

SAS Programmer/ Analyst

Responsibilities:

• Involved in Requirement Gathering and conducting a JAD session with project team member for accuracy of reporting.
• Documented the requirement and generated Process Flow Diagrams for Reporting according to different mapping specification.
• Created various SUMMARY REPORTS and GRAPHS based on different data retrieved from Call Center and Web for various Analyses.
• Extensively used various statistical Procedures like PROC UNIVARIATE, PROC FREQ, PROC MEANS to understand data quality, produce reports and handle the missing values.
• Created the customized reports based on total costs and sales based on different advertisements.
• Analyzed the data of advertised contents based on people response and created reports based on their demographic information.
• Worked on SAS ETL taken from Flat Files with piped delimiter and converted them to SAS Datasets.
• Extensively used PROC TABULATE, PROC REPORT, PROC GCHART, PROC GPLOT, SAS/GRAPH, PROC SUMMARY and PROC GMAP during the report generation process.
• Delivered Ad - Hoc Reports to the customers based on the fly requirements.
• Extensively used PROC SQL to create Report Datasets and converted PROC SQL Queries into SAS Code to produce respective SAS Datasets.
• Analyzed Mid-Volume, Sub-Sets and Full-Volume data by using PROC FREQ to compare the counts and missing values present in the same.
• Extensive usage of ODS statement for creating RTF, HTML and Excel files.
• Automated report generation in the UNIX System for the efficiency during Production and in the Production Environment.
• Created Batch Process in the UNIX Environment for the SAS System.
• Extensively communicated with the Business Analyst, Systems Analyst, Data Modeler and Testing team during the execution of the project and had semi team meetings for various clarifications.
• Provided insights on effectively running of marketing campaigns including direct mail, email, mobile and other digital channels.
• Documented all programs and procedures to ensure an accurate historical record of work completed on assigned project.

Environment: Base SAS, Macros, SAS Connect, SAS/Access, UNIX, Enterprise Guide, SAS Management Console, SAS/Stored Process, SAS CI Studio.

Confidential, San Francisco, CA

SAS Analyst

Responsibilities:

• Conducted thorough analysis on historical data to generate seasonality of demand index profiles.
• Analyzed past data to generate granular price elasticity of demand values and associated reports to aid business decisions regarding promotions and investment therein.
• Studied store behavior at a high level to gather information and generate reports regarding selling patterns, traffic volumes, geographic divides and seasonal swings.
• Spearheaded the requirement gathering, development and testing phases of the YMR Project.
• Used SAS/Access and SQL Assistant to interface with the database server for data extracts.
• Performed extraction, transformation and loading from / to large Teradata tables.
• Optimized, automated and productionalized daily / weekly / monthly scripts for increased efficiency and intelligence.
• Performed statistical data analysis, generated reports and graphs using SAS/Base, SAS/Macros, SAS/SQL, SAS/Access and SAS/Graph.
• Generated web based reports via Web Report Studio to enable users and decision makers across the enterprise with self sufficient access to consistent, accurate data and the predictive power of SAS analytics.
• Used %sysfunc and other macro functions of SAS/MACRO to execute I/O operations and write reusable code.
• Generated output using SAS/ODS in CSV, XLS, DOC, PDF and HTML formats.
• Performed extensive regression and statistical data analysis using Proc REG, Proc GLM, Proc ANOVA.
• Transacted with various formats of data; flat files, CSV, XLS, ASCII; to create and mai1ntain large datasets.
• Implemented Set, Merge and SAS/SQL to perform suppressions and exclusions on the data.
• Developed reporting procedures using PROC REPORT, PROC TABULATE and DATA NULL .

Environment: Windows XP, SAS/BASE, SAS/MACRO, SAS/ACCESS, SAS/SQL, SAS/STAT, SAS/GRAPH, SAS/CONNECT, SAS/ODS, SAS/SQL, SAS/Enterprise Guide, SAS Web Studio, SAS OLAP Cube, SAS EBI, HTML, Teradata

Confidential, Dallas, TX

SAS Developer

Responsibilities:

• Used SAS/BASE, Macros to develop dynamic SAS programs to extract, validate data for Statistical analysis.
• Extensively used SAS procedures like means, frequency and other statistical calculations for Data validation.
• Developed SAS programs using Base SAS for tabulation counts, correlations and check for dispersion for normality using PROC Means, PROC Tabulate and PROC Univariate.
• Used Proc Dbload, Proc SQL, Proc import, Proc export statements to load SAS data sets from and to DB2 and Oracle 11i.
• Acquired raw data from Oracle and DB2 tables and loaded the data into SAS datasets Used Macro routines to convert different types of source file (Excel, Word, and Text) to produce SAS reports and graphs.
• Extracted data from the database using SAS/Access, SAS SQL procedures and create SAS data sets.
• Used Business Objects tool to create reports using Data Warehouse data, accessing, formatting and delivering data.
• Used Oracle Toad to extract data from oracle tables and write the SQL queries to analyze the data.
• Used SAS/Access to ORACLE feature for large data extractions.
• Used SAS/BASE to extract data from FALCON, TRAX, DART and EQUATOR database.
• Develop SQL queries using SQL Server to extract data from EQUATOR database by writing SQL queries.
• Build a EUC as per Business Requirement using Microsoft Access VBA

Environment: Windows XP, SAS/BASE, SAS/MACRO, SAS/ACCESS, SAS/SQL, SAS/CONNECT, SAS/ODS, SAS BI, SQL, PL/SQL, UNIX, HTML, MS Excel, MS Access, Oracle 11i, Business Objects, Oracle Toad, SQL Server, FALCON, TRAX, DART, EQUATOR.

Confidential, NY

SAS Programmer

Responsibilities:

• Involved in interacting with Business Analysts for requirement gathering, analysis, documentation and also to discuss primary model requirements for the project and for making business decisions
• Documented methodology, data reports and model results and communicated with the Project Team / Manager to share the knowledge
• Developed complex SAS Macros to simplify SAS code and effectively reduce coding time
• Imported Data from relational database into SAS files per detailed specifications
• Imported data using LIBNAME and PROC SQL Pass - Thru facility to reduce processing time
• Created automated DI jobs in SAS DI studio to generate data from different sources. Used almost all data transformations in DI Studio
• Performed complex statistical analysis using PROC MEANS, PROC FREQ
• Extensively performed Data Cleansing during the ETL's Extraction and Loading Phase by analysing the raw data and writing SAS Program and creating complex reusable Macros
• Carried out data extraction and data manipulation using PROC SQL, PROC SORT, PROC REPORT to create preferred customer list as per business requirements
• Extensively used SAS procedures such as PRINT, REPORT, TABULATE, FREQ, MEANS, SUMMARY, TRANSPOSE and Data Null for producing ad-hoc and customized reports and external files
• Wrote SAS programs in Windows platform
• Generated Dashboard using EXCEL
• Created reports in the style format (RTF, PDF and HTML) using ODS statements and PROC TEMPLATE
• Performed data analysis, statistical analysis, generated reports, listings and graphs using SAS tools e.g. SAS/Graph, SAS/SQL, SAS/Connect and SAS/Access

Environment: SAS/BASE, SAS/MACRO, SAS/ODS, SAS/ETL, SAS/SQL, SAS/ACCESS, SAS/CONNECT, SAS Enterprise Guide, SAS/DI Studio, MS-SQL Server, UNIX, MS- Excel, MS-Access and Windows

Confidential

Jr.SAS Programmer

Responsibilities:

• Extensively used SAS Data Step functions and descriptive statistical Procedures to process large amounts of customer response and sales data
• Used PROC SQL LIBNAME and PROC SQL Pass - through methods to access data on Oracle database
• Created customer mailing lists for Direct Mailing and Telemarketing using PROC Forms
• Extensively used PROC Import and PROC Export procedures for importing and exporting PC files and Microsoft office files such as Excel Spreadsheet, Access Tables
• Maintained and enhanced existing SAS Reporting programs using PROC Tabulate, PROC Report, PROC Print, ODS RTF, and ODS PDF for marketing campaigns
• Used SAS enterprise Guide to run statistical tests like ANOVA, Chi-square etc.
• Created Ad hoc reports for marketing managers using SAS Enterprise Guide

Environment: Windows XP, SAS Enterprise Guide, Base SAS, SAS Macros, SAS/Access, SQL