Summary:

• Over 7 years of experience in healthcare data analysis, financial analysis with strong emphasis on SAS Programming for Reporting, Modeling, Data analysis, and Data manipulation.
• Expertise in using various SAS report generating procedures like PROC REPORT, PROC FORMAT, PROC GPLOT, PROC COMPARE, PROC EXPORT, PROC SQL, PROC SUMMARY, PROC IMPORT, PROC UNIVARIATE and PROC TRANSPOSE.
• Expertise in Data Import/Export via SAS Data Steps, using SAS Proc Import, SAS /ACCESS, SAS /SQL and SAS /ODS.
• Developed Programs, tested, debugged and documented solutions to system design problems for the clients.
• Generated reports using PROC REPORT, AND PROC TABULATE for customized report writing.
• Thorough Experience in creating SAS datasets and developing SAS Procedures, Macros, and application for data updates, cleaning, and reporting.
• Thorough knowledge in Data Warehousing, Data Mining concepts and risk management analysis to study the data.
• Experienced in using SAS Arrays, creating SQL Views and Indexes.
• Developed, enhanced, maintained, implemented and supported PC/ SAS Applications.
• Advanced knowledge and experience with Linear Regression, Cluster Analysis, Decision Tree Analysis and ANOVA in financial applications.
• Knowledge of Web Intelligence Studio, Customer Intelligence Studio.
• Thorough work knowledge of using ODBC to connect SAS System with relational database management systems to retrieve data and create SAS datasets.
• Developed ad-hoc reports, which contains SAS procedures, macros for the data warehouse project.
• Output SAS data sets to Excel for building pivot table reports.
• Extensive experience in design, development, and administering of SAS procedures and jobs.
• Working experience managing very Large SAS Datasets using heterogeneous databases like Oracle, Teradata, DB2 and SQL Server .
• Excellent understanding of SAS packages- Base SAS , Macros, CONNECT, GRAPH, ACCESS , Proc SQL.
• Involved in software Analysis, Design, Implementation and Production Support and Reporting systems.
• Developed UNIX scripts for batch jobs. Connected and accessed other PC File Formats and SQL Server through ODBC.
• Working on SAS support/development on ETL and other functionality written in BASE SAS .
• Working experience with SAS tools, SAS Enterprise Guide, SAS Enterprise Miner.
• Strong Knowledge in advanced analytics and Text and Data mining Techniques.

TECHNICAL SKILLS

• SAS Skills SAS (Base, ACCESS, STAT, MACROS, ODS, SQL and GRAPH)
• Languages SAS
• Databases Oracle 11g, Teradata, DB2
• Environment SAS 8.x, SAS 9.0, SAS 9.1.3, SAS 9.2, Base SAS, SAS/CONNECT,
• SAS/STAT, SAS/SQL, SAS/ ACCESS, Customer Intelligence Studio,
• SAS EG, SAS IDP, Web report Studio, SAS Warehouse and Win 98/2000/XP, UNIX
• Additional Software MS Office Suite (Word, Excel, PowerPoint)

Professional Experience:

Confidential Smithfield, RI

Sr. SAS Developer

• Designed and developed code with SAS/EG to support ad-hoc requests.
• Automated the standard reporting with SAS BI and Microsoft Add-in.
• Prepared Quarterly reports for Risk Architechture.
• Working with risk data for producing risk rating migrations.
• Identifying Hold Limit Exceptions of the relationships which have exceeded the Hold Limits for their Policy Group and Risk Rating (RR) combination by looking at their PD’s, LGD (Loss Given Default) and TCL (Total Credit Limits).
• Worked on Risk Rating Migration and Hold Limit Exceptions.
• Reporting other Risk Metrics such as EAD and EL (Expected Loss Amount).
• Used SAS IDP for Developing portal pages and portlets and SAS BI Dashboards.
• Used Business Objects to access the data, or pass-thru SQL with SAS , using ODBC and SAS /Access.
• Developed new/modified macros for report generation using SAS / Macros as per business requirement.
• Developed SAS stored Processes and then used in Web Report Studio and SAS IDP.
• Extensively used the SET, UPDATE and MERGE statements for creating, updating and merging various SAS data sets.
• Proficiency in using SAS ODS to create output files in a variety of formats including RTF, HTML and PDF .
• Used Dynamic Data Exchange (DDE) feature of SAS for importing and exporting of data from and into SAS, MS Access and Excel.
• Developing Shell Scripts (Korn) for batch running of SAS programs.
• Proficiently used SAS procedures like PROC SQL to extract data from different relational database management systems.
• Involved in Automation of developed SAS code at a scheduled time.
• Extracting the data from oracle database.
• Created reports in the style format (RTF, PDF and HTML) using SAS/ODS.
• Using various procedures such as PROC FREQ, PROC PRINT, and PROC MEANS, PROC TABULATE, PROC UNIVARIATE, and PROC SQL.

Environment: SAS/BASE, SAS/MACRO, SAS/SQL, SAS/CONNECT, SAS/GRAPH, SAS/ODS, Oracle 11g, SQL Server Management Studio, SAS EG, SAS Web Report Studio

Confidential Los Angeles, CA

SAS Developer

• Expertise in Data Manipulations using SAS data step, procedures such as SAS Format/Informat, Merge, Proc Append, Proc Datasets, Proc Sort, and Proc Transpose.
• Write SAS code to perform data cleaning and quality control. Extract data from DB2 Tables, SAS datasets, Excel.
• Create and implement robust database applications and reporting solutions for the Healthcare Analytics department.
• Building SAS OLAP cubes.
• Analyzed the data and created the reports using SAS Add-in MS Office.
• Extensive knowledge and experience in code optimization & performance tuning using Advanced SAS techniques/ Macros .
• Prepared detailed summaries and reports for the health claims data by writing commands in SAS Data step and various statistical procedures such as PROC SQL, PROCSUMMARY and PROC REPORT.
• Generated graphs using SAS /GRAPH .
• Developed SAS macros to create tables, graphs and listings.
• Store and distribute SAS Enterprise Guide results in different formats such as HTML, Tagsets, PDF, WORD based on the user group requirement with SAS/ODS.
• 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.
• Involved in writing UNIX shell scripts, which are used as a source to run SAS batch programs and generate log files, list files and reports in desired directories by passing parameters.
• Extracting the data from oracle database by using PL/SQL queries.
• Prepare daily, monthly, and ad hoc reports (by PowerPoint, Excel, pivot tables, and pivot charts, etc.).

Environment: SAS EG, Web report Studio, SAS 9.2, SAS/BASE, SAS/MACROS, SAS/ACCESS, SAS/SQL, Oracle 11g, Windows NT 2000, Unix.

SAS Programmer/Analys

• Creation of database objects like Tables, Views, and Synonyms etc. Developed new or modified SAS programs to load data from the source and create study specific datasets, which are used as source datasets for report generating programs.
• Contribute to the continual improvement of the department by developing efficient methods for extracting data from source systems, automating processes, developing neat and accurate end-user reports, and expanding the use of new technologies.
• Write/maintain/update Business Rules code and documentation.
• Prepare summary and listing files in various formats, including Excel and PDF.
• Developed working knowledge of old and new data warehouse architectures and developed report code combining old and new sources in transition.
• Experienced in handling data with data integrity during extraction, manipulation, processing, analysis and storage.
• Comprehensive skills in working with SAS/BASE, SAS EG, SAS EBI, SAS/MACRO, SAS/ACCESS, campaign management etc. in windows environment.
• Moved datasets across platforms.

Environment: SAS 9.1, BASE/SAS, SAS Macro, SAS/ACCESS, SAS/CONNECT, SAS/ODS, SAS/Internet, SAS/SQL, SAS Warehouse, Microsoft Front Page, DB2, Unix, WIN NT

SAS Programmer

• Converted large data from Oracle to SAS data sets by using SQL pass through and Libname facility.
• Wrote queries on the existing Oracle databases server to provide ad-hoc reports using SAS/SQL .
• Extensively used PROC PRINT, PROC REPORT and PROC TABULATE for reporting.
• Submitted SQL Queries and SAS codes in UNIX shell to validate data. Used Crontab and Shell scripting to start SAS process, control jobs, and redirected input and output.
• Worked on various SAS products SAS/BASE, SAS/SQL, SAS/STAT, SAS/ACCESS and SAS/MACROS to develop solutions .
• Produced RTF, MSWORD and HTML formatted files using SAS/ODS to produce reports for presentation and further analysis.
• Understanding the Business Requirement and gathering the requirements from Business users.
• Responsible for targeted list pull and applying the suppressions as per the Business Requirement Document.
• Support end-users, company-wide to resolve database and software issues utilizing remote desktop tools.
• Coordinating the production of monthly, quarterly, and annual performance reports for senior management.
• Used PROC SQL for ad-hoc report programming, to perform the tasks like data manipulation of multiple views in Oracle, creation of the ad hoc reports for marketing research data, preplanning and doing ad hoc joining of multiple Oracle views.
• Pull data from a variety of source files including warehouse data stored on Teradata database.
• Output SAS data sets to Excel for building pivot table reports.
• Create and apply validation rules and processes.
• Experienced in handling data with data integrity during extraction, manipulation, processing, analysis and storage.
• Used SAS PROC SQL Pass through facility to connect to Teradata tables and created SAS Data set using various SQL joins.

Environment: SAS/BASE, SAS/MACROS, SAS/ACCESS, SAS/SQL, Teradata, UNIX.

• Extracted, transformed, and loaded data using SAS.
• Worked on various SAS products SAS/BASE, SAS/SQL, SAS/STAT to analyze large datasets
• Wrote a VBA program in Excel to grab the text files and place the data into Excel.
• Conducted statistical analyses using linear and nonlinear regressions (PROC Reg and PROC NLIN), logistic regression ( PROC Logistic ), and general linear models ( PROC GLM ).
• Extensive use of PROC TRANSPOSE, UNIVARIATE, SUMMARY, MEANS, FREQ, SQL and GPLOT procedures.
• Retrieved the Claims data from flat files, oracle database and converted to SAS data sets for Analysis using SAS/STAT procedures.
• Extracted data from different sources like DB2 and Teradata and text files using SAS /Access, SAS SQL procedures and create SAS data sets.
• Worked on File transfer (FTP) from UNIX server to share drive using FILENAME statement.

Environment: Base SAS, MS SQL, HTML, Windows NT/2000, Oracle.

SAS Programmer

• Used SAS Macros and SAS SQL to query data and results were stored as delimited text.
• Created basic SAS datasets used in a variety of ad hoc requests in our working group.
• Generated graphs using SAS/GRAPH
• Use of base SAS procedures such as PROC FREQ, PROC PRINT, PROC MEANS, PROC TABULATE, PROC UNIVARIATE and PROC REPORT.

Environment: Base SAS, Proc SQL, Windows NT/2000.