SUMMARY:

• 7+ years of professional experience as a SAS programmer in Financial and Healthcare domains.
• Over 7 years of experience as a Senior SAS Programmer and data analysis using Base SAS, SAS Enterprise Miner, SAS Enterprise Guide.
• Experience in extracting data and creating SAS datasets from various sources like Oracle database, Access database, Excel and flat files using import techniques.
• Experience in developing SAS codes using SAS Enterprise Guide and SQL queries in SAS for creating stored processes using the dynamic prompts containing both packaging and streaming output, and prepared reports using ODS.
• Extensively worked with Health care claims (Medical, Pharmacy) using CPT codes, ICD - 9, NDC codes etc.,
• Experienced in performing analysis of the given data of Claims, trends and summarizing the results to management.
• Experience in extraction, manipulation, and Analysis of data using claims data.
• Strong experience in SAS/Base, SAS/Graph, SAS/Stat, SAS/Connect, SAS/Access, SAS/ODS, SAS/SQL, SAS/Macro, SAS/Enterprise Guide.
• Experience working with huge datasets with observations ranging in millions.
• Experience in working with various RDBMS tools like Oracle, MS Access, Teradata, DB2 and SQL Server.
• Experience in Data Manipulation techniques including combining and merging SAS datasets
• Expertise in reporting skills and generated reports using Proc Means, Proc Summary, Proc Tabulate, Proc Report
• Experience in SAS Functions, Options and Arrays.
• Extensively used SAS procedures such as freq, report, tabulate, sort, print, transpose, summary and means for producing customized reports and external files.
• Experience in producing RTF, PDF, HTML and MS Excel formatted files usingSASODS facility.
• Involved in validation of tables, listings and datasets using procedures like Proc Compare.
• Experience in using modeling techniques like Proc GLM and Proc REG.
• Excellent communication, analytical and problem solving skills with good organization skills

TECHNICAL SKILLS:

Statistical Packages: SAS 9.1, 9.2, 9.3

SAS Tools: Base SAS, SAS/Macro, SAS/Connect, SAS/SQL, SAS/STAT, SAS/BI, SAS/Graph, SAS/IntrNet, SAS/ODS, SAS/Access, SAS Enterprise Guide, Enterprise Miner.

SAS Coding Techniques: SAS/Base, SAS/Macros, SAS/Graph, SAS/SQL, SAS/Stat, SAS/Access

Operating Systems: Windows 98/2000, Windows XP, and Unix

Databases: Oracle, SQL Server, MS Access and Teradata

SAS Procs: Print, Means, Univariate, Append, Reg, GLM, SQL, Report, Freq, Sort, Summary, Tabulate, Format, Import, Export, Transpose, Compare, Gplot and Gchart.

Office Tools: MS Word, MS Excel, and MS PowerPoint

PROFESSIONAL EXPERIENCE

Confidential, Wilmington, DE

Sr. SAS Programmer / Analyst

Roles & Responsibilities

• Worked in multiple mock testing environments to recode strategies that use SAS programming and tested the working status of recoded strategies
• Involved in writing code using SAS/Base, SAS/Macros to recreate the working logic of current production strategies
• Leveraged different tools like Unix to run SAS programs and exported sample datasets to Excel to understand outputs by putting data into Pivot Tables
• Used dataset combining techniques like Joins, Set and Merge statements
• MIS Report development included using data step programming and procs like Proc Report, Proc Summary, Proc Means. ODS techniques were used with Proc Export in generating reports in Excel format
• Worked with a large Line of Business team in communicating the recoding status and reporting results
• Collaborated with Line of Business and fixed coding issues arising out of testing of the Strategies
• Raise defects on Quality Center and communicate with the development teams in fixing the defects and follow-up with Line of Business on the status of defects

Environment: SAS/Base 9.3, SAS/Macros, SAS/SQL, SAS/ODS, SAS Enterprise Guide, Unix, and Microsoft Excel.

Confidential, NYC, NY

Sr. SAS programmer / Analyst

Roles & Responsibilities

• Developed Weekly, Monthly, Quarterly, Semi-Annual reports and dashboards for senior management’s regular review of portfolio performance
• Used data step programming and advanced SAS programming techniques like SAS/SQL and SAS/Macros, in increasing efficiency and automation ability of the reports
• Confidential ’s 7 million customer database is an Enterprise Data Warehouse built on Teradata system and SAS Enterprise Guide was used for connecting and retrieving huge load of data
• Unix was also used in running huge SAS codes in the backend
• Used Proc TTEST in the Stratification code to make the Test and Control populations statistically similar. This code involved rank ordering Test population and overlaying the cutoffs on the Control Population
• Leveraged Procs like Proc Tabulate, Proc Report, Proc Summary, Proc Freq, and Proc Means for report outputs. Created graphs using SAS/Graph based upon the analyzed data
• Imported flat text files from different teams using data step programming and used Oracle database to retrieve Customer Service data to merge with transactional data at portfolio level
• Developed HTML versions of the report using ODS HTML for uploading to the SharePoint website

Environment: SAS/Base 9.3, SAS/SQL, SAS/Macros, SAS/Graph, SAS/ODS, Teradata, SAS Enterprise Guide, Unix, Microsoft Excel, HTML and Mainframe.

Confidential, Bloomfield, CT

Sr. SAS programmer/ Analyst

Roles & Responsibilities

• Reviewed the Business Requirement Documents and the Functional Specification.
• Developed and created SAS Macros to access and analyze data.
• Worked extensively with Healthcare data (hospital, lab and physician), which includes various claims, membership details and demographics of the members.
• Experience in analyzing the claims data, future trends and summarized results to generate recommendations for management.
• Responsible for creation of new / modified SAS programs by analyzing the Health care claims data and created study specific datasets which are used as source datasets for report generating programs.
• Creating excel pivot table reports using cycle time data. These reports consist of benefit level data, claims level data. These reports are very useful to get a greater insight into the further plan design.
• Successfully converted all the codes to handle both ICD9 and ICD10 diagnosis codes.
• Wrote programs in SAS to generate reports, created RTF, HTML listings, tables and reports using SAS/ODS for Ad-Hoc report generation.
• Developed claims reporting system to retrieve client records and create SAS Proc tabulate tables, Proc Freq, Proc Means, and Proc Report and created Reports based on the claims data.
• Created permanent formatted SAS data sets and developed reports using Proc Report, Proc Tabulate and used Data Null for analysis.
• Developed SQL Pass through Queries to fetch complex data from different tables from remote databases.
• Developed and modified existing tables, views, stored procedures, functions, triggers and cursors.
• Created reports in Excel spreadsheets which are capable of doing automatic calculations.
• Developed routine SAS macros to create tables, graphs and listings.
• Extensively used the Set, Update and Merge statements for creating, updating and merging various SAS datasets.
• Participated in user requirement discussions and data quality assessment.
• Created JIL files to schedule SAS jobs in Unix environment.
• Created flat files for third party vendors, Used the SAS Macro facility to produce weekly and monthly reports.
• Used SAS Proc SQL to extract data from different relational database management (Teradata) systems, used SQL Assistant to analyze and query from the Teradata Database.

Environment: SAS/Base, SAS/ Macros, SAS/SQL, SAS/ETL, SAS/Graph, SAS Enterprise Guide, SAS/ODS, SAS/Stat, MS Access, Windows, SQL server, MS office, Unix and Teradata.

Confidential, Chattanooga, TN

SAS Developer / Analyst

Roles & Responsibilities:

• Responsible for analyzing the Healthcare claims data, future trends and summarized results to generate meaningful recommendations for management.
• Responsible for performing variety of tasks including data extraction, manipulation, Analysis using claims data.
• Experience in working with Healthcare data which includes various claims, and details of the members.
• Responsible for reviewing Business Process and develop process flow diagrams.
• Responsible for developing online reporting system on Claims to pull client records and create SAS Proc tabulate tables, Proc Freq, Proc Means, and Proc Report.
• Responsible for extraction of data from oracle database using SQL pass- through facility. Documented all the programs developed for future reference.
• Created complex and reusable Macros and used existing macros for Data Cleansing, Validation analysis and Report generation.
• Responsible for sourcing and analyzing of data from a various sources like SAS data sets, MS Access, MS Excel, CSV, XML, and flat files etc.
• Dealt with Teradata Asset Datamart from which data is pulled and did necessary modifications as per the requirement and finally loaded into the respective tables.
• Coded, Modified and automated existing SAS programs to automate process, improve efficiency. Extensively used various SAS ODS techniques to generate complex reports.
• Performed quality control checks on peer developed programs to ensure that the correct source data is used, correct code and logic are used.
• Was responsible for gathering and assimilating data from Oracle, SQL Server and reporting requirements from business
• Creating SAS dataset from tables in Database using SAS/Access. Retrieved the data from flat files, oracle database and converted to SAS data sets for Analysis using SAS/Stat procedures.
• Coding SAS programs with the use of Base SAS and SAS/Macros for ad hoc jobs. Created many Perl, CGI reports and Extracted, loaded Teradata tables using SAS/ETL. Strong experience on Teradata/ SQL Pass thru facility.
• Maintenance of large data sets, combining data from various sources in varying formats to create SAS data sets and/or ASCII files by using Set and Merge, Sort, and Update, Formats, Functions and conditional statements for generating Reports.
• Prepared new Datasets from raw data files using Import Techniques modified existing datasets.
• Used Enterprise Guide (EG) for creating, editing and submitting SAS code for stored processes to Application server, for running queries against DB2 to bring the data into the SAS environment.
• Involved in scheduling the existing reports using Unix.
• Wrote Shell scripts for running batch files performed validation on transported data and reports.
• Extensively researched for cause of errors in code and modified code according to requirements.

Environment: SAS/Base 9, SAS/Macros, SAS/Enterprise Guide, SAS/ODS, SAS/Stat, MS Office, MS Access, Windows, SQL Server, Perl, Unix and Teradata.

Confidential

SAS Programmer/ Fraud Analyst

Roles & Responsibilities:

• Trend data to investigate fraud and abuse in the online transactions space like wire transfers and bill pay
• Used SAS programming techniques like DATA steps and Proc SQL to summarize data and design fraud rules for catching fraud transactions pro-actively
• Developed ~25 fraud rules that trigger potential fraud transactions along with other team members
• SAS programming and Pivot tables in Microsoft excel was extensively used in analyzing and visualizing data, that in turn would assist in framing rules
• Mainframe was used to look up accounts that were a victim of fraud to understand the nature of vulnerable accounts
• Basic decision trees were built to segment data and analyze patterns in fraud transactions
• Developed strategies and presented to senior management for approvals
• Monthly and Quarterly Reports were developed using SAS programming and MS Excel for the senior management to understand the Fraud loss amounts incurred in the online banking space
• Summaries on Reports were built using Proc Univariate, Proc Means, and Proc Summary etc.

Environment: SAS/Base, SAS/Macros, SAS/SQL, PC SAS, Microsoft Excel, Mainframe and Unix.