SUMMARY

• Solutions - focused, team oriented SAS Professional with 7 years of experience directing program development and data warehousing, validation and test analysis, and consultancy operations in highly-competitive market environments.
• Expert in developing decision support solutions for different kinds of projects that included reporting and business analysis using SAS 9.1.3 and SAS 9.2 for business areas such as Insurance, Banking, Auto and Health Industries.
• Strong experience in SAS/BASE, SAS/MACRO, SAS/CONNECT, SAS/ODS, SAS/GRAPH, SAS/SQL, SAS/ACCESS in WINDOWS and UNIX environments.
• Extensive experience in writing UNIX SAS and PC SAS code.
• Worked extensively on SAS Procedures and Data Step Programming to develop the process flow applications from Data Acquisition to Data Exploitation/Reporting.
• Through experience in data extraction and sorting from various databases like Oracle, DB2, TERADATA and MS Access using PL/SQL and SQL.
• Modified existing/creating new SAS programs by developing SAS Macros to improve ease, speed as well as improving consistency results.
• Advanced skills in data cleaning and manipulation using PROC MEANS, PROC UNIVARITE, PROC APPEND, PROC SORT, PROC TRANSPOSE and PROC RANK.
• Proficiency in importing different types of external files (Excel, CSV, txt, etc.) into SAS library and exporting SAS data sets as external files using Import/Export Wizard, PROC IMPORT, PROC EXPORT, and SAS DATA steps.
• Skilled in writing automated SAS tasks and conversion of SAS datasets into various file types (including HTML, Excel, PDF, Word, XML) as well as converting various file types to SAS datasets.
• Strong experience in using SAS/ACCESS (LIBNAME, Pass-Through) to extract large volume data from databases including Oracle, SQL Server, DB2 and Teradata.
• Very good command in generating customized reports by using Data NULL, PROC CHART, PROC DATASETS, PROC FORMAT, PROC PLOT, PROC PRINT, PROC REPORT, PROC TRANSPOSE, PROC TABULATE
• Extensive exposure on every steps of entire project life cycle including data collection, query, modifying and analysis, summary of findings, communicating strategic insight and presentation of results and documentation of the processes.
• A highly motivated, organized team player with excellent analytical and communication skills.

TECHNICAL SKILLS

SAS Programming Tools: BASE/SAS, SAS/STAT, SAS/MACRO, SAS/GRAPH, SAS/ODS, SAS/AF, SAS/ACCESS SAS/SQL, SAS/Connect, SAS/Enterprise Guide, SAS/ETL, SAS Enterprise Miner.

Programming Languages: SQL, PL/SQL, C, C#, Visual Basic, .Net

Databases: Oracle, Teradata, MySQL, MS-Access, DB2, SQL Server

Operating Systems: Windows 7, UNIX, Linux

PROFESSIONAL EXPERIENCE

SAS Programmer

Confidential, LA

RESPONSIBILITIES:

• Performed ETL-Extraction/Transformation/Loading, Data Analysis, Data migration, Data preparation, Graphical Presentation, Statistical Analysis, Reporting, Validation and Documentation.
• Implemented Credit Risk Analysis reporting system based on credit Scores and data management principles, such as joining data set, indexing, data aggregation, record selection, sub-setting, multiple records per case, creation and modification of views, accessing multiple database.
• Developed application 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
• Developing and designing SAS Programs/ Macros to analyze financial data. Statistical analysis files, tables, listings, and graphs. ETL / Extract data from warehouse /databases and created SAS statistical analysis reports.
• Developed adhoc-reports as per business requirements and created various reports like summary reports, tabular reports.
• Used procedures like PROC FREQ, PROC MEANS, PROC SORT, PROC PRINT, PROC TABULATE AND PROC REPORT
• Developed SAS programs for statistical analysis and data displays working with various SAS products SAS/BASE, SAS/SQL, SAS/STAT, SAS/ACCESS and SAS/MACROS etc to develop solutions.
• Responsible for maintenance and enhancements work in reporting system using SAS/Base, SAS/SQL, SAS/Stat, SAS/Graph.
• Wrote programs in SAS generate reports, creating RTF, HTML listings, tables and reports using SAS ODS for ad-hoc report generation.
• Used SAS, SAS Macros, Oracle, Procedures like SQL, FREQ, UNIVARIATE, SUMMARY, MEANS, TRANSPOSE, ARRAYS, Tabulate, and SORT to extract data, prepare integrated data base and its analysis.
• Designed and created SAS datasets from various sources like Excel datasheets, flat files and Oracle, creating reports and files from existing SAS datasets.

Environment: UNIX, SAS v 9.1, SAS/BASE, SAS/AF, SAS/ODS, SAS/ACCESS, SAS/CONNECT, SAS /STAT, SAS/SQL, PROCEDURES, SQL, Excel, DB2, HTML.

SAS Programmer

Confidential, Richardson, TX

Responsibilities:

• Performed data analysis, statistical analysis, generated reports, listings and graphs using SAS tools - SAS BASE, SAS/MACROS, SAS/GRAPH, SAS/SQL, SAS/CONNECT, SAS/ACCESS
• Responsible for locating appropriate databases for projects and performing relevant analysis
• Processed data collection to ensure proper quality of data
• Maintained the daily error log for cleaning the data
• Developed SAS Macros for data cleaning, reporting and to support routing processing
• 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
• Generated graphs using SAS/GRAPH and SAS Graphics Editor. Used PROC REPORT to generate reports
• Prolifically generated SQL queries for the reports
• Successfully identified problems within the data, produced derived data sets, tables, listings and figures, which analyzed the data to facilitate correction

Environment: SAS 8, SAS/SQL, SAS/BASE, SAS/MACROS, SAS/GRAPH, Linux, Windows

SAS Reporting Analyst

Confidential, Detroit, MI

RESPONSIBILITIES:

• Developed ad-hoc reports for reward programs and marketing campaigns (OAR) as per business requirements and created various reports like summary and tabular reports.
• Created SAS datasets from raw data files (Excel, CSV, Delimited) using PROC IMPORT whenever required.
• Coordinated and worked with GM financial to generate tables, listings, and graphs using SAS/Base, SAS/Macros, SAS/Graph, and SAS/SQL, as per the Statistical Analysis Plan (SAP).
• Created adverse events (AE) reports in a graphical form using SAS/Base, SAS/Macros, and SAS/Graph facilities.
• Analyzed promotions run by GM and post analysis.
• Cleaned existing data and converted them into useful SAS Datasets, merged datasets and created reports based on requirements.
• Quick Lane dealer reports on competitive parts being sold in comparison to GM or Motor craft parts
• Designed macros to produce descriptive statistics in attractive tables using PROC UNIVARIATE and PROC TABULATE.
• 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
• Produced attractive block charts, horizontal and vertical charts, and scatter plots using PROC GCHART and PROC GPLOT.
• Analysis of Customer View Point Survey for loyalty reports of consumer towards dealer and marketing campaigns
• Extracted data from different sources like Teradata, Excel files and text files using SAS/Access, SAS SQL procedures and Proc import functions.
• Generated HTML, PDF and RTF reports using SAS Output Delivery System (ODS).

Environment: SAS 8.0 Windows Environment, SAS/ BASE, SAS/MACROS, SAS/SQL, SAS/GRAPH, SAS/STAT, SAS/ACCESS, MS Excel, Oracle 8i.

SAS Programmer/ Analyst

Confidential, Louisville, KY

RESPONSIBILITIES:

• Extracted event defining information from the Medicare data warehouse (Oracle), using SAS/ACCESS and created SAS data sets.
• Summarizing those events by geography to measure health care usage rates in its various branches
• Extensively used SAS procedures like means, frequency and other statistical calculations for Data validation
• Stratification of patients into standard and high risk categories through monthly predictive analysis of claims data to help identify patients who are likely to experience a significant health care need within the ensuing 12 to 18 months, which gave the nurse care coordinators a head start in working with those individuals
• Generation of reports that depict tracking of the company’s expenditure with the last year, population profile contributing the expenditure and others
• Prepared flowcharts indicating the input data sets, sorting and merging techniques and wrote SAS code accordingly.
• Run reporting programs and downloaded the results into EXCEL.
• Carried out profiling analysis for customer data. Used PROC TABULATE and PROC REPORT. Standardized those reporting programs into macros.
• Created Reports using analysis output and export them to the web to enable the customers to have access through Internet.
• Moved data set across platforms.

Environment: Windows2000, SAS8.0, SAS/SQL, SAS/Macros, SAS/STAT, SAS/ACCESS, SAS/GRAPH, PROC REPORT, MS EXCEL and ORACLE

Programmer

Confidential

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, Oracle, SQL.