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

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 teh regulatory process and detailed understanding of teh 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 teh intended and most efficient use of teh 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 teh 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 halp improve teh efficiency of teh 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 teh data feeds into teh 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 teh 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 teh existing datasets for teh improvement of teh 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 teh form of listing, HTML, RTF and PDF formats using SAS ODS.

Environment: 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 teh analysis teams and teh 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 teh targeted business strategies.
• Created reports using SAS Enterprise Guide for summarizing portfolio experience, including information about teh current business environment, portfolio trends, expected portfolio losses and teh forecast assumptions.
• Developed new SAS programs to generate new reports in HTML, RTF and txt format.
• Facilitated teh automation process for teh 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 teh changing values.
• Used SAS ODS, SAS Graph, and procedures Proc Tabulate, Proc means to create ad hoc reports and graphs as per teh requirements of teh 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 teh 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 teh 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 teh missing values.
• Created teh customized reports based on total costs and sales based on different advertisements.
• Analyzed teh 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 teh report generation process.
• Delivered Ad - Hoc Reports to teh customers based on teh 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 teh counts and missing values present in teh same.
• Extensive usage of ODS statement for creating RTF, HTML and Excel files.
• Automated report generation in teh UNIX System for teh efficiency during Production and in teh Production Environment.
• Created Batch Process in teh UNIX Environment for teh SAS System.
• Extensively communicated with teh Business Analyst, Systems Analyst, Data Modeler and Testing team during teh execution of teh 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 theirin.
• Studied store behavior at a high level to gather information and generate reports regarding selling patterns, traffic volumes, geographic divides and seasonal swings.
• Spearheaded teh requirement gathering, development and testing phases of teh YMR Project.
• Used SAS/Access and SQL Assistant to interface with teh 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 teh enterprise with self sufficient access to consistent, accurate data and teh 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 teh 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 teh 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 teh 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 teh SQL queries to analyze teh 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 teh project and for making business decisions
• Documented methodology, data reports and model results and communicated with teh Project Team / Manager to share teh noledge
• 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 teh ETL's Extraction and Loading Phase by analysing teh 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 teh 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