SUMMARY

• Over 7 years of experience in SAS programming and analysis with Financial, Banking, and Health Insurance industries.
• Over 7+ years of Professional Experience in Software development in different environments and platforms including Data Warehousing and Client - Server.
• Experience working in SAS Business Intelligence (BI) platform with Enterprise Guide, Stored Process, Information Map Studio, Microsoft Add-In, Dashboards, Olap Cubes and Web Report Studio.
• Proficient in SAS v6.12/v 8.2/9.1.3/9.2/9.3, SAS/Base, SAS/Macros, SAS/Connect, SAS/SQL and SAS/ODS.
• Sound experience in generating reports using ODS formats like HTML, PDF, RTF,CSV,XML etc.
• Extensive experience in working with Healthcare claims (Medical, Pharmacy) using CPT codes, NDC codes etc.
• Experience in working with SAS on different platforms like Unix (AIX, HP/UX, SunOS), and Windows 9x/2K/NT/XP/7/8.
• Have good command in debugging errors, trouble shooting the problems occurred in coding and programming.
• Strong experience in SAS/Base, SAS/Graph, SAS/Stat, SAS/Connect, SAS/Access, SAS/ODS, SAS/SQL, SAS/Macro, SAS/Enterprise Guide, SAS/Share, SAS Enterprise BI Server, and SAS Management Console.
• Experience in the BI Suite in SAS including SAS Enterprise guide, SAS Olap Cube Studio, SAS Web Report Studio, SAS Data Integration Studio and Information Map Studio.
• Used Data Integration Studio to collaborate data from various sources, created and submitted jobs, registered data with metadata, conducted ETL process and reviewed job statistics.
• Have strong experience on working with Data which includes various Healthcare claims and details of members.
• Extensive experience of analyzing Healthcare claims data.
• Created and AutomatedDaily, weekly, monthly, Early Warning service reports, Profitability analysis reportsfor Products like Pay day loans, Installment loans, and Mobiloans.
• Have good command in acquisition modeling, validation, statistical consultant, and providing helpful recommendations in maximizing profits.
• 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.
• Exposure on every step of entire software development life cycle (SDLC) including data collection, query, modifying and analysis, coding statistical models, summarizing the findings, and presenting the results.
• Experience with SAS management console for scheduling daily and monthly job runs for creating reports.
• Extensively used SAS procedures such as freq, report, tabulate, sort, print, transpose, summary and means for producing customized reports and external files.
• Experience in data manipulation procedures such as formats/informats, merge, proc data sets, proc sort, proc transpose and proc rank.
• Good command in importing and exporting complex internal data to and from Microsoft Excel and Microsoft Access using Proc Import and Proc Export.
• Proficient in different Databases like Oracle, SQL Server, DB2 and Teradata.
• Experience with database manipulation (ETL) and SQL programming and reporting.
• Ability to work efficiently in both independent and team environments, worked with Project Managers, Team Members / Associates, Statisticians, Business Analysts.
• Strong Problem Analysis & Resolution skills and ability to work in Multi-Platform Environments like Windows and Unix.
• Excellent written and verbal communication skills.
• Resourceful, able to find solutions when faced with challenges.

PROFESSIONAL EXPERIENCE

SAS Tools: Base SAS 9.3/9.2/9.1.3 /8.2/8.1, SAS/STAT, SAS Macros, SAS/SQL, SAS ODS, SAS Graph, SAS Enterprise, SAS Business Intelligence (BI) platform and SAS Profitability Module

Reporting Tools: Base SAS versions 9/8/6, SAS Enterprise, SAS Graph, MS Excel, SAS BI Platform, SAS Olap Cube Studio, SAS Web Report Studio, MS Visio, MS-PowerPoint.

RDBMS: MS Access, Microsoft SQL Server, MySQL, Oracle, Teradata and Db2.

Languages: SAS, SQL, HTML, and PL/SQL.

Operating System: Windows 95/98/XP/Vista/Win 7, Unix, MAC OS, and DOS.

Batch Server: Unix, Putty, SSH, and SAS scripting.

Web Server: MS-FrontPage, HTML, Linux, and Apache Server.

PROFESSIONAL EXPERIENCE

Confidential, Jersey City, NJ

Sr. SAS Programmer / Analyst

Responsibilities:

• Developed Credit policies for Underwriting and Fraud processes based on Customer data analytics.
• Created and automated reports for Daily, weekly, monthly, Early Warning service reports, and Profitability analysis reports for Products like Pay day loans, Installment loans, Mobiloans using SAS Enterprise guide and MS SQL Server.
• Involved in customer strategies by grouping them into good or bad customers and high risk or low risk profile customers.
• Maintained performance reports, creation of reports for online and batch application of various server and Involved in preparing executive Dashboards for senior level management.
• Portfolio management, Credit Risk Analytics, Portfolio tracking and reporting, creating and maintaining Credit Policies, Managing Marketing Campaigns, testing out new champion and challenger strategies, understanding 3rd party data etc.
• Developed and use metrics and reports to proactively identify issues impacting Fraud Team operations.
• Used SAS, SAS/Macros, Procedures like SQL, Freq, Univariate, Summary, Means, Transpose, Arrays, Tabulate, and Sort to extract data, prepare integrated data base and its analysis.
• Created new financial tables and manipulated customer data by using various joins and merges and then appended the data (Proc append) from the existing source tables containing millions of records.
• Created analytics for the mortgage division by developing a home price repeat sales index to support property valuation.
• Extensive used SAS/Access Pass through facility for finance and mortgage data extraction.
• Worked with Statisticians and Modelers in building new Risk score model, Credit Model and Fraud Model.
• Created financial mortgage data sets using Data steps, and Data Null .
• Extracted data sets from server using Proc Import and created datasets in SAS libraries. Coding SAS programs with the use of SAS/Base and SAS/Macros for ad- hoc jobs.
• Validating and profiling the variables using SAS Base / Macros using proc freq, proc means, proc format and proc Univariate.
• Daily generate consolidated reports and alerts using SAS.
• Developed programs to create daily HTML reports using ODS and CSV reports using Proc Export.

Environment: Base SAS 9.3, SAS/Macros, SAS/Access, SAS/Connect, Oracle, SAS/SQL, SAS/Enterprise Guide, Unix Crontab, SQL Server, and SAS/Perl Scripting.

Confidential, Madison, WI

Sr. SAS Analyst / Developer

Responsibilities:

• Responsible for Business analysis and requirements gathering.
• Extracted raw data from an Oracle database and used SAS/Access to read it and run statistical analysis using SAS/Stat.
• Worked with SAS and Proc SQL to extract marketing demographics from a Teradata data warehouse for model testing.
• Worked on creation of reports for business users using SAS web report studio, developed real time SAS BI for business users using SAS Model Manager.
• Developed and used scripts to schedule SAS Jobs.
• Performed advanced querying using SAS Enterprise Guide, calculating computed columns, using filter, manipulate and prepare data for Reporting, Graphing, and Summarization, statistical analysis, finally generating SAS datasets.
• Developed, modified and generated Monthly Business Review (MBR) reports and Quarterly Business Review (QBR) reports summarizing business activity using Proc Univariate, Proc Copy, Proc Transpose, Proc Report, Proc Tabulate and Proc Summary.
• Created new financial tables and manipulated customer data by using various joins and merges and then appended the data (Proc append) from the existing source tables containing millions of records.
• Worked on generating ad hoc reports, tables and graphs for presentations and data modeling using SAS Web Report Studio.
• Importing all Reports from web report studio, Stored Process, BI Dashboard and Information Map to Information Delivery Portal.
• Developed loss prediction model using Enterprise miner modeling solutions and SAS procedures.
• Created and delivered reports and presentations with key findings and recommendations.
• Provided technical support on SAS programming related to data manipulation and analysis.
• Wrote macros, developed concise SAS scripting and used SQL to concatenate and join datasets from different database management systems using indexes and loops
• Exported SAS Reports to the Excel Sheet by using ODS/Tagsets/Excel XP to get the output in multisheets.

Environment: SAS 9.2/ 9.3, SAS/Connect, SAS Macros, SAS/Access, Oracle 10g, MS Office, HTML, SAS Enterprise Guide, SAS Enterprise Miner, SQL, Unix, Windows and Teradata.

Confidential, Madison, WI

SAS Developer / Analyst

Responsibilities:

• Responsible for creating reports based on Claims data for various diseases.
• Integrates all transaction data from multiple data sources used by Actuarial into a single repository.
• Implemented and executes monthly incremental updates to the data environment.
• Interacts with IT and finance and executes data validation tie-out reports.
• Responsible for Maintaining and executing Claim triangle execution.
• Good experience in developing regulatory reports by doing analysis on the health care claims data.
• Implement fully automated data flow into Actuarial front end (Excel) Models using SAS process.
• Validated the entire data process using SAS and BI tools.
• Maintains and administers all Actuarial process controls using SAS Management Console.
• Maintain all relevant analytical reference data tables (Procedure codes (CPT), ICD9 codes, MS DRG codes).
• Assists other Actuarial Analysts in designing actuarial data flow.
• Designed & Developed Mini Data mart for Actuarial Team using latest technologies like SAS etc.
• Designed and maintained the Provider Dimension and their Systems.
• Developed Decision Tree Analysis using SAS Enterprise Miner.
• Developed distinct OLAP Cubes from SAS Dataset and generated results into the excel sheets.
• Handle with around 150 Millions of Records.
• Tested whole process (Unit, UAT, Integration, and Regression).
• Worked with Oracle and SQL Server Databases.
• Created Design Documents with easiest way of understanding.

Environment: SAS/Base, SAS/BI,SAS OLAP Cubes, Db2, SQL server, SAS/Stat, SAS/Macro, SAS/Graph, SAS/Access, SAS/ODS, SAS/Connect, SAS Enterprise Guide, SAS Enterprise Miner, Unix, SQL, MS Access, Excel, and Windows.

Confidential, Charlotte, NC

SAS Programmer/Analyst

Responsibilities:

• Extraction of data from Oracle, created into datasets. Performing data validation, transforming data from RDBMS oracle to SAS datasets.
• Was responsible for gathering requirements and performing business analysis.
• Transformations using Base SAS Procedures and Functions.
• Responsible for the cleaning, reformatting, analysis and loading the data into the database.
• 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.
• Produced RTF, MS Word and HTML formatted files using SAS/ODS to produce reports for presentation and further analysis.
• Developed SAS Macros for reduction of program length and for faster execution.
• Combined and grouped datasets using concatenation and merging.
• Creating permanent formatted SAS data sets and developed reports using Proc Report, Proc Tabulate and DATA NULL for analysis.
• Extensively used various Base SAS procedures like Proc SQL, Proc Summary, Proc Format, Proc Print, Proc sort etc. for reporting purposes. Used SAS procedures for Importing and Exporting data to MS-Excel.

Environment: SAS/ Base, SAS/ Macros, SAS/ Stat. SAS/SQL, SAS/ ODS, Oracle, SAS/ Graph, SAS Enterprise Guide, MS office, Windows and Unix.

Confidential, West Des Moines, IA

SAS Programmer / Analyst

Responsibilities:

• Analyzed the claims data, future trends and summarized results to generate meaningful recommendations for management.
• Extracted, transformed, and loaded data using SAS/ Access.
• Involved in analysis, development, testing, implementation, and provided technical support to business needs using SAS in Unix environment.
• Ensured the validity and accuracy of the analyzed data.
• Involved in variety of tasks including data extraction, manipulation, Analysis using Claims Data.
• Created Information Maps to feed Web Report Studio which generated reports.
• Responsible for using SAS BI and Microsoft Add-in to automate the standard reporting.
• Created Stored Processes that would generate ad hoc reports based on parameters passed.
• Used SAS/Enterprise Guide to design and develop code to support ad hoc requests.
• Coordinated with the other teams to deliver the data to the clients on time.
• Extensively used Proc Print, Proc Report and Proc Tabulate for reporting.
• Used SAS/ODS to produce RTF and HTML reports.
• Submitted SAS/SQL queries in Unix shell to validate data.
• Presented process flow diagrams in MS Visio.
• Raised queries on the existing Oracle and SQL Server databases to provide ad-hoc reports using SAS/SQL.
• Involved in the development of different datasets according to the user specifications for various applications.
• Analyzed the data, future trends and summarized results to generate meaningful recommendations to management.
• Written macros to develop a concise and reusable code.

Environment: SAS/Base, SAS/Macros, SAS/SQL, SAS/Stat, SAS/Graph, SAS/Connect, SAS/Access, MS-Excel, SAS/ODS, Oracle, SAS Enterprise Guide, SAS Add-In to MS Office, SAS Information Map Studio, SAS Stored Process, SAS Web Report Studio, Unix, and Windows NT

Confidential, Boston, MA

SAS Programmer

Responsibilities:

• Participated in business requirement walk through, design walk through and analyzed Business requirements.
• Extraction of data from Oracle, created into datasets. Performing data validation, transforming data from RDBMS oracle to SAS datasets.
• Done Enhancements for the existing business reports like incorporating new business variables.
• Developed, modified, and generated Monthly Business Review (MBR) reports summarizing business activity.
• Worked closely with data modeling team and management like Marketing managers, Campaign managers, financial managers etc, to analyze customer related data, generate custom reports, tables and listings.
• Worked extensively in sorting, merging, concatenating and Dynamic Formatting as optimized technique for SAS data sets.
• Cleaning of data using SAS Procedures like Proc Freq /Proc Univariate.
• Extensively used various Base SAS procedures like Proc SQL, Proc Summary, Proc Format, Proc Print, Proc sort etc for reporting purposes. Used SAS procedures for Importing and Exporting data to MS Excel.
• Transformations using Base SAS Procedures and Functions.
• Extensively used ETL to load data from DB2, SQL server, Oracle, Flat files and XML as sources to Oracle Data warehouse as target.
• Extensively involved in designing and developing of Star Schema Model for Data Store.

Environment: SAS/Base, SAS/Macros, SAS/Access, SAS/Connect, SAS/Stat, SAS/Graph, SAS/SQL, SAS/ODS, SAS/ETL, DB2, SQL,IBM AIX 5.3, Unix, Shell Scripting, WINSQL, Ultra editor, Oracle, DB2, SQL Server 2000, SunOS 5.8, and Windows XP.