NARISH K

acb7gh@r.postjobfree.com

203-***-****

Summary

• Senior SAS Programmer/Analyst with over 6 years of experience in design, development, implementations,

testing, support, maintenance & upgrades of SAS Applications in Healthcare and Pharmaceutical industries.

Experience includes SAS tools - Base/SAS, SAS/Macros, SAS/SQL, and SAS/ODS, SAS/ACCESS, SAS/ETL

and SAS/GRAPH. Experience includes programming of data validation tools using PL/SQL. Experience

includes working with PROC SQL to extract data from Oracle database, load data into database, print

sophisticated reports and Lists, Graphs.

• Responsible for production updates (monthly, quarterly and semiannual) by processing client’s eligibility and

claims data from different carriers.

• Proficient in Crystal Reports, Microsoft SQL Server, Oracle Database and Info View scheduling

• Expertise in transforming data imported from disparate data sources into analysis data structures, using SAS

functions, options, ODS, array processing, macro facility, and storing and managing data in SAS data files.

• Experience in developing SAS Procedures, Macros, Application’s for data extraction, transformation, data

cleaning, reporting and involved in preparing documentation.

• Worked with the marketing team and analyzed marketing data using SAS tools to generate reports, tables,

listings and graphs. Experience in BASE SAS (Including SAS SQL, SAS ODS).

• Excellent command in producing reports employing various SAS procedures like Proc Print, Proc Report, Proc

Tabulate, Proc Mean, Proc Univariate, Proc Transpose, Proc Rank, Proc SQL, Proc Access and Data _NULL_ .

• Experience in producing RTF, PDF, HTML and MS Excel formatted files using SAS ODS facility.

• Experience in cleaning and resolving data issues as well as merging data from different sources into a single

integrated dataset.

• Develop end-to-end reporting based on business requirements using SAS views from Oracle database tables

using SAS/ACCESS and writing SAS programs using BASE SAS and SAS MACROS to create SAS reports.

• Utilized SAS PROC SQL Pass through facility for data extraction, location and retrieval from the Oracle

database.

• Write, maintain, and support SAS Programs in SAS Base and Enterprise Guide. Extensive experience in Data

collection, Design, Analysis and Reports.

• Good knowledge on HIPPA (Health care Insurance Portability Act), PHI (Protected Health Information) and

CMS (centre for Medicaid and Medicare services) other concepts in Health care.

• Motivate supportive, cooperative and a quick-learner. Strong communication skills and ability to work well in a

team. Exceptional ability in problem solving, data analysis, complex reports generation with macro and data

transfer between different environments.

• Exceptional problem solving skills for delivering useful and prudent solutions. A quick learner with an eye for

detail and excellent analytical and quantitative skills. Excellent written and communication skills with ability to

work under pressure in a highly visible role and good team player.

Technical Skills

SAS Tools: SAS/BASE, SAS/GRAPH, SAS/MACROS, SAS/ODS, SAS/REPORTS, SAS/ACCESS,

SAS/STAT, SAS/AF, SAS v 9.1/8.2.

SAS Procs: Print, Means, Univariate, Correlation, Regression, SQL, Tabulate, Freq, Sort, Summary, Format,

Import, Export, Transpose, Compare, Life Test, and Gplot.

EPIC Tools: Clarity data dictionary, Record Viewer, Hyperspace, Reporting Workbench,

Tools: SSIS, SSAS, SSRS, Business ObjectsInfoView, Informatica, Cognos

Database: SQL, Microsoft SQL Server, Oracle, MS Access

Programming Languages: C, C++, SQL,PL/SQL,VB Script, Visual Basic, Informatica,Visual Studio, dot net,

SAS

Other: MS Office

PROFESSIONAL EXPERIENCE

Well care Health Plans, Tampa FL Feb 2013 –

Current

SAS Programmer Analyst Sr.

Well care Health Plans is one of the leading Insurance companies across most major segments of the US health care

system. Its one of the fastest growing health information companies and the only organization in our industry with

the information, technology and consulting expertise to solve the most significant challenges in health and human

services.

• Create complex SAS algorithms to identify opportunity for overpayment of claims.

• Provide analytical and technical support for member/eligibility and claims data

• Develop end-to-end reporting based on business requirements using SAS views from Oracle database

tables using SAS/ACCESS and writing SAS programs using BASE SAS and SAS MACROS to create

SAS reports.

• Utilized SAS PROC SQL Pass through facility for data extraction, location and retrieval from the Oracle

database.

• Used SAS procedures (FREQ, SUMMARY), SAS functions and user defined macros to test the accuracy

and validity of data.

• Responsible for production updates (monthly, quarterly and semiannual) by processing client’s eligibility

and claims data from different carriers.

• Solve complex issues and implement solutions to enhance productivity, improve quality and customer

satisfaction

• Obtain and maintains familiarity with COB policies and procedures.

• Generated output files in text format, CSV, HTML & PDF format using SAS ODS.

• worked in producing reports employing various SAS procedures like Proc Print, Proc Report, Proc

Tabulate, Proc Mean, Proc Univariate, Proc Transpose, Proc Rank, Proc SQL, Proc Access and Data

_NULL_ .

• worked in producing RTF, PDF, HTML and MS Excel formatted files using SAS ODS facility.

• worked in cleaning and resolving data issues as well as merging data from different sources into a single

integrated dataset.

• Conduct or facilitate root cause analysis on all in-scope incidents and recommend a corrective action

plan.

• Work with team to achieve timely resolution of all production issues.

• Conduct code review and testing of final results to ensure the work delivered by the team is of high

quality standards.

• Work with business to prioritize production issue resolution.

• Work with the Business Analyst in process improvement initiatives as directed by the business.

• Provide accurate and timely estimates for tasks.

• Provide support and leadership in critical production support issue resolution.

Environment: UNIX, SAS V9.0, SAS V9.2, SAS/BASE, SAS/STAT, SAS/MACROS, SAS/ODS, PL/SQL,

ORACLE 10g

United Health Care Jan 2012 – Feb 2013

SAS Programmer Sr.

United Health Care is one of the leaders across most major segments of the US health care system. Its one of

the fastest growing health information companies and the only organization in our industry with the information,

technology and consulting expertise to solve the most significant challenges in health and human services.

• Create complex SAS algorithms to identify opportunity for overpayment of claims.

• Provide analytical and technical support for member/eligibility and claims data

• Develop end-to-end reporting based on business requirements using SAS views from Oracle database

tables using SAS/ACCESS and writing SAS programs using BASE SAS and SAS MACROS to create

SAS reports.

• Utilized SAS PROC SQL Pass through facility for data extraction, location and retrieval from the Oracle

database.

• Used SAS procedures (FREQ, SUMMARY), SAS functions and user defined macros to test the accuracy

and validity of data.

• Solve complex issues and implement solutions to enhance productivity, improve quality and customer

satisfaction

• Obtain and maintains familiarity with COB policies and procedures .

• Generated output files in text format, CSV,HTML & PDF format using SAS ODS.

• Conduct or facilitate root cause analysis on all in-scope incidents and recommend a corrective action

plan.

• Work with team to achieve timely resolution of all production issues.

• Conduct code review and testing of final results to ensure the work delivered by the team is of high

quality standards.

• Work with business to prioritize production issue resolution.

• Work with the Business Analyst in process improvement initiatives as directed by the business.

• Provide accurate and timely estimates for tasks.

• Provide support and leadership in critical production support issue resolution.

Environment: UNIX, SAS V9.1, SAS/BASE, SAS/STAT, SAS/MACROS, SAS/ODS, PL/SQL, ORACLE 10g

Blue Cross Blue Shield, MA Nov 10 – Dec 2011

SAS Programmer

BCBS-MA is one of the leading health care information, reporting and consulting firms in the industry. The Data

Services Organization receives these data feeds and process them through well defined steps before the data is loaded

for the employer's to analyze. This process includes transforming data source specific data file formats to a BCBS

Standard format and is also subjected to Data quality processes following standard protocols.

• Responsible for production updates (monthly, quarterly and semiannual) by processing client’s

eligibility and claims data from different carriers through the ETL to Data warehouse.

• Responsible for quick Debugging and resolving production issues on the Eligibility, Claims,

Inpatient, Outpatient, Long Term Care and Pharmacy (Rx) etc datasets up on request.

• Developed ad-hoc reports in production environment up on special request using SAS

PROCEDURES like PROC PRINT, PROC FREQ, PROC UNIVARIATE, PROC SUMMARY, PROC

REPORT and PROC MEANS.

• Created SAS INDEX’S by importing workable crosswalk data into SAS from various data types and

formats like metadata, MS Excel and MS Access files, delimited text files, and comma separated values

(CSV) files.

• Utilized SAS PROC SQL Pass through facility for data extraction, location and retrieval from the

Oracle database.

• Generated output files in text format, HTML & PDF format using SAS ODS.

• Create Edit Checks to verify the accuracy of the data.

• Independently perform data investigations. (investigate code; utilize reporting environment, special

requests, program mods.

• Lead investigations into standard ETL and BCBS claim process methodologies.

• Participate in UAT testing and maintenance of new products/methodologies.

• Identify risks and report impact to teams in a timely manner.

• Identify possible solutions for complex data issues/limitations, and work on improvement of data

quality.

Environment: UNIX, SAS/BASE, SAS/STAT, SAS/MACROS, SAS/ODS, PL/SQL, ORACLE 9i

Assurant Health, WI Aug 2009-Nov 10

SAS Programmer

Assurant Health is part of Assurant, a premier provider of specialized insurance products and related services in

North America and selected international markets. Assurant Health Inc. is headquartered in Wisconsin and offers a

wide range of health insurance products. This project involved data extraction, cleaning and transformation.

Customer segmentation was done to understand the pattern of claim trends and pricing .

• Worked on writing, editing, validating and debugging code in BASE SAS and MACROS.

• Extensively used PROC REPORT for detailed reports.

• Sources extracted from and dumped in to the oracle tables later extracted into the ODS (Operational Data

Store) Used DATA _ NULL_ to produce outputs for reports.

• Assisted seniors and follow programmers in validation, edit checks and data review listings.

• Used SAS /ACCESS to gather data from RDBMS like ORACLE.

• Worked in multidisciplinary teams closely with statisticians, medical writers and data managers.

• Developed SAS macros for data cleaning and Reporting and to support routing processing.

• Assisted in checking and quality assurance of all programming code and datasets.

• Programming of data listings using SAS tools. Programming of data validation tools using PL/SQL.

• Create and extract Oracle tables from SAS and within Oracle by using SAS/Access, SAS/SQL, and

DBLOAD.

• Writing analysis plans including specifications for tables listings. Taking raw data and creating datasets.

• Data preparation, summarization and exploration using SAS/EM.

• SAS was used for pre-processing data, data analysis, generating reports, and statistical analyses for

marketing and financial decisions.

• Creating permanent formatted SAS data sets and developed reports using PROC REPORT, PROC

TABULATE and DATA_NULL_ for analysis. Wrote Edit check programs and listings of data.

• Ran weekly and monthly reports using SAS.

Environment: SAS/BASE, SAS/ACCESS, SAS/SQL, MS Project, UNIX and Windows NT/2000, Crystal Reports

Aurobindo Pharmaceuticals,India Oct 2008 – Aug 2009

SAS Programmer

• Worked on writing, editing, validating and debugging code in BASE SAS and MACROS.

• Sources extracted from and dumped in to the oracle tables later extracted into the ODS (Operational Data

Store) Used DATA _ NULL_ to produce outputs for reports.

• Assisted seniors and follow programmers in validation, edit checks and data review listings.

• Worked in multidisciplinary teams closely with statisticians, medical writers and data managers.

• Compiled raw data and created datasets for all programs.

• Developed SAS macros for data cleaning and Reporting and to support routing processing.

• Assisted in checking and quality assurance of all programming code and datasets.

• Programming of data listings using SAS tools. Programming of data validation tools using PL/SQL.

• Writing analysis plans including specifications for tables listings. Taking raw data and creating datasets.

• Creating permanent formatted SAS data sets and developed reports using PROC REPORT, PROC

TABULATE and DATA_NULL_ for analysis. Wrote Edit check programs and listings of data.

Environment: SAS/BASE, SAS/ACCESS, SAS/SQL, MS Project, UNIX and Windows NT/2000, Crystal Reports

Contact this candidate