SUMMARY

• Over 7 years of experience in healthcare data analysis, financial analysis with strong emphasis onSASProgramming for Reporting, Modeling, Data analysis, and Data manipulation.
• Expertise in using variousSASreport 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 viaSASData Steps, usingSASProc Import, SAS/ACCESS, SAS/SQL andSAS/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/SASApplications.
• 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 connectSASSystem with relational database management systems to retrieve data and createSASdatasets.
• Developed ad - hoc reports, which containsSASprocedures, macros for the data warehouse project.
• Output SAS data sets to Excel for building pivot table reports.
• Extensive experience in design, development, and administering ofSASprocedures and jobs.
• Working experience managing very LargeSASDatasets using heterogeneous databases like Oracle, Teradata, DB2 and SQL Server.
• Excellent understanding ofSASpackages- BaseSAS, 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 onSASsupport/development on ETL and other functionality written in BASESAS.
• 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/CONNECTSAS/STAT, SAS/SQL, SAS/ ACCESS, Customer Intelligence StudioSAS 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

Responsibilities:

• 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 withSAS, using ODBC andSAS/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 variousSASdata sets.
• Proficiency in usingSASODS 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 developedSAScode 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

Responsibilities:

• Expertise in Data Manipulations usingSASdata step, procedures such asSASFormat/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 SAStechniques/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 usingSAS/GRAPH.
• Developed SASmacros 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.

Confidential, Irving, TX

SAS Programmer/Analys

Responsibilities:

• 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

Confidential, New York, NY

SAS Programmer

Responsibilities:

• 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.
• UsedSASPROC SQL Pass through facility to connect to Teradata tables and createdSASData set using various SQL joins.

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

Confidential, San Antonio, TX

SAS Programmer/Analyst

Responsibilities:

• Successfully used SAS/STAT to perform analysis of variance, multivariate analysis of variance, and repeated analysis of variance.
• Developed SAS macros to create tables, graphs and listings.
• Developed SAS macros for data cleaning and Reporting.
• Creating SAS dataset from tables in Database using SAS/Access. Retrieved the Sales data from flat files, oracle database and converted to SAS data sets for Analysis using SAS/STAT procedures.
• Maintained the daily error log for cleaning the data.
• Generated graphs using SAS/GRAPH and the SAS Graphics Editor.
• Used PROC REPORT to generate reports.
• Analyzed response results using Pivot Tables, VLOOKUP, and HLOOKUP features of Excel.
• Utilized Microsoft Excel and SQL to create adhoc reports.
• Prolifically generated SQL queries for the reports.
• Proficient in handling Program files, Log files, Listing files and Data sets.
• Creation of Data Sets on the Remote Server.
• Run reporting programs and download the results into EXCEL and build pivot tables.
• Created Transport files in .xpt format and submitted to the testing team.
• Employed advanced statistical analysis including linear and logistic regression, cluster, and ANOVA.

Environment: Base SAS, SAS EG, SAS/ACCESS, SAS/CONNECT, SAS/STAT, SAS BI Enterprise Server, SAS/Graph, SAS/SQL, SAS/ODS, SAS Macros, MVS, JCL, Oracle 9, MS Excel

Confidential

SAS Programmer

Responsibilities:

• 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 usingSAS/Access,SAS SQL procedures and createSASdata 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.

Confidential

SAS Programmer

Responsibilities:

• 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.