SUMMARY

• Over 7+ years of experience in analysis, design, development, testing in SAS(V 6.0/8.2/9.1/9.2/9.3 )
• Hands on experience with analysis ofClaims Data, Membership Data,Provider Pharmacy and Lab datain healthcare industries.
• Technical lead experience in various implementations and process improvements in health care client’s data integration.
• Experience in the Banking sector performing analysis of marketing campaigns.
• Experienced with affinity card marketing campaigns and cross sell campaigns.
• Extensive experience in SAS/BASE, SAS/GRAPH, SAS/STAT, SAS/ACCESS, SAS/CONNECT, SAS/EG and SAS BI Tools such as SAS Enterprise Guide, SAS Management Console, SAS Stored Processes Web Application, SAS Information Map Studio, SAS Web Report Studio, SAS Information Delivery Portal, SAS BI Dashboards, SAS Content Server, SAS Application Servers.
• Good command on configuration of SAS Business Intelligence platform including Metadata server oriented architecture and IOM server management on windows platform and network configuration required for the installation of SAS BI tools at Enterprise level.
• Experienced in extracting data from various databases like Oracle, SQL server, DB2 etc. using SQL Pass through Facility.
• Generated high quality reports in the form of listing, HTML, RTF and PDF formats using SAS ODS.
• Developed ETL processes in SAS for different database platforms.
• Expertise in using SAS ODS to create HTML, RTF and PDF for creating customized and adhoc reports.
• Experienced in creating, storing reusable Macro modules as well as invoking stored macros.
• Extensive experiences of editing and debugging procedures for data cleansing, correction, transformation and program validation.
• Worked on statistical analysis, reporting, ad - hoc analyses/reports.
• Excellent analytical, inter-personal & communication skills with experience in interacting with clients, multiple user groups and managing development teams. Ability to work in a fast paced environment and under deadlines.

TECHNICAL SKILLS

Operating Systems: Windows NT/XP/2000/2003

SAS Tools: SAS/Base, SAS/Macro, SAS/Stat, SAS/ACCESS, SAS/ETL, SAS /Graph, SAS/OLAP Server, SAS IntrNet, SAS BI platform, SAS EG, SAS EBI, SAS add-in MO, SAS WRS.

Business Intelligence: SAS Management Console, SAS Enterprise Guide, OLAP Cube Studio, SAS

Application s/w Packages: MS Office, Microsoft Visio, MS Project

SAS Procedures: sort, transpose, copy, summary, report, means, freq, tabulate, print, univariate, reg, corr, test, export, import, cport, comport, glm, mixed, graph, gplot, sql, anova, format, template, contents, format, catalog, datasets, download, dbload, append, life test, compares

PROFESSIONAL EXPERIENCE

Confidential, West Hartford, CT

Sr. SAS Analyst (Technical Lead)

Responsibilities:

• Integrated health care data from multiple carriers (Aetna, Cigna, BCBS, horizon, UHC) and built data warehouse for different clients (CVSC, Quantum) to meet industry standards by using various SAS and SQL techniques
• Lead onshore implementations and off shore production team for most of the clients.
• Extensively performedData Cleansing, data aggregation, Data Scrubbingduring the ETL's Extraction and Loading Phase by analyzing the raw data and writingSASandSQLqueries and creating complexreusable Macros.
• Assisted in designing and development of health care data warehouses & analytical products for overall enterprise.
• Provided assistance for quantitative data analysis with health care, biometric and survey data.
• Coordinated with technical teams for research and evaluation of healthcare and operational problems
• Involved in development of data integration services and processes to ensure that data quality meet the requirements of customers and company business goals and objectives
• Integration of disparate healthcare data in various forms into comprehensive SAS-based warehouses for analysis
• Developed extensive data quality control check processes at every stage of building warehouse using SAS Macros and SAS Freq to ensure the quality in delivery advanced statistics-based testing and validation techniques
• Analyzed multi-dimensional data to accurately assess and demonstrate key insights into key trends and opportunities
• Involved in prioritization of requirements, client communication, planning in identifying operational process flow
• Used procedures like PROC REPORT, PROC TABULATE, PROC MEANS, PROCFREQ, PROC CONTENTS and PROC DATASETS to generate different reports and run metrics on different data sets.
• Support advanced statistical analyses including opportunity assessments, clinical and financial risk tracking, trend identification exercises
• Provides data interpretation of findings to both the internal executive team as well as client representatives using clear and concise methods
• Involved in automation and streamlining production process by Cisco Tidal Enterprise scheduler
• Establish, evolve, and reinforce the existing data process and infrastructure, constantly improve performance, and accurately measures success of internal data initiatives

Environment: SAS 9.3, Base SAS, SAS Macros, SQL, SAS Enterprise Guide 5.1, SAS Add-In for Microsoft Office, SAS Web Report Studio SAS Information Delivery Portal, SAS Enterprise BI Server, SAS Management Console 9.2, Microsoft SQL Server Management Studio, Cisco Tidal, Windows.

Confidential, Southfield, MI

SAS BI Analyst/Developer

Responsibilities:

• Developed complex programming to extract and manipulate data.
• Created reports that provide the insightful analysis to business to optimize the high volume decisions.
• Used Proc SQL Lib name and PROC SQL Pass-through methods to access data on Oracle database.
• Validate and test all code for accuracy and efficiency and moved it into Production.
• Used procedures like PROC REPORT, PROC TABULATE, PROC MEANS, PROCFREQ, PROC CONTENTS and PROC DATASETS to generate different reports and run metrics on different data sets.
• Conducted Ad Hoc analysis to support business strategy
• Developed SAS programs based on the draft spec document
• Delivered reports via portal using BI tools like SAS Web Report Studio, SAS Information Delivery Portal and Stored Process Web Application
• 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
• Wrote different joins and merges to create reports based upon the requirements given.
• Written time and resource efficient code using PROC SQL.
• Analyzed the transformed data using SAS BI tools such as SAS Enterprise Guide 4.2, and SAS Add-in for Microsoft Office.

Environment: SAS 9.3/9.2, Base SAS, SAS Macros, SQL, SAS Enterprise Guide 5.1/4.3, SAS Add-In for Microsoft Office, SAS Stored Processes Web Application, SAS Web Report Studio SAS Information Delivery Portal, SAS Enterprise BI Server, SAS Management Console 9.2,, Windows.

Confidential, Columbus, OH

SAS BI Application Developer

Responsibilities:

• Accessed data from the databases using the SQL pass through facility and developed the reports that meet business requirements.
• Written and modified SAS code to create reports and increase runtime performance of the code.
• Extensively developed stored processes using SAS Enterprise Guide 4.3.
• Created complex reports using stored processes through SAS Enterprise Guide.
• Delivered reports via portal using BI tools like SAS Web Report Studio, SAS Information Delivery Portal and Stored Process Web Application.
• Written SAS code and modified the existing scripts to transform data using data step.
• Used different statistical procedures like PROC SUMMARY, PROC TABULATE, PROC MEANS and PROCFREQ for analysis and report creation.
• Written SAS MACROS for the code to reduce its length and increase its reusability.
• Used PROC SQL procedure, connected to different databases via pass through facility to execute SQL queries using the databases.
• Used PROC EXPORT, PROC IMPORT, PROC TRANSPOSE, PROC PRINT and PROC CONTENTS for SAS Reporting.
• Created reports for Microsoft Office using SAS Add-in for Microsoft Office.

Environment: SAS 9.2, Base SAS, SAS Macros, SQL, SAS Enterprise Guide 4.3, SAS Add-In for Microsoft Office, SAS Stored Processes Web Application, SAS Web Report Studio SAS Information Delivery Portal, SAS Enterprise BI Server, SAS Data Integration Studio 4.2, SAS Management Console 9.2,UNIX, Windows.

Confidential, Dayton, OH

SAS BI Application Developer

Responsibilities:

• As a member of team handled all aspects of the configuration, development, and implementation of the clients SAS Enterprise Business Intelligence environment.
• Used SAS Management Console 9.2 for importing tables (by creating server, schema, and library) from the Oracle Warehouse and worked on various Plug-ins of Management Console.
• Used SAS Data Integration Studio 4.2, extracted old format data and transformed them to the current version datasets.
• Designed Information Maps using Information Map Studio 4.2 by joining tables without using SQL queries and used those maps in the Web Report Studio for creating customized reports.
• Analyzed the transformed data using SAS BI tools such as SAS Enterprise Guide 4.2, and SAS Add-in for Microsoft Office.
• Developed new Stored Processes consisting of modified SAS programs using SAS Enterprise Guide 4.2.
• Extensively written SAS Macros within the SAS code for creating prompts to be used in stored process.
• Created sophisticated reports of the processed data using SAS Web Report Studio, SAS Information Delivery Portal, and Stored Process Web Application.
• Created Dashboards using SAS BI Dashboard 4.2 for the users to monitor key performances of enterprise.
• Tested SAS code in both Unit Testing and Integrated Testing scenarios.
• Strong interpersonal and leadership skills including monitoring the SAS BI platform security.
• Actively participated in Production support and provided solutions to end users.

Environment: SAS 9.1.3/9.2, Base SAS, SAS Macros, SQL, SAS Enterprise Guide 4.2, SAS Add-In for Microsoft Office, SAS Stored Processes Web Application, SAS Web Report Studio, SAS Information Map Studio 4.2, SAS Information Delivery Portal, SAS Enterprise BI Server, SAS Data Integration Studio 4.2, SAS Management Console 9.2, SAS BI Dashboards 4.2

Confidential

Software Analyst

Responsibilities:

• Extensively used SAS Data Step functions and descriptive statistical Procedures to process large amounts of customer response and sales data.
• 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.
• Created Ad hoc reports for marketing managers using SAS Enterprise Guide.
• Used Proc SQL Lib name and PROC SQL Pass-through methods to access data on Oracle database.

Environment: Windows XP, SAS Enterprise Guide, Base SAS, SAS Macros, SAS/Access, Oracle, SQL.