Data Sas

Kishore K

Phone: 929-***-****

Email: **************@*****.***

(Current Location, Frisco TX)

EXECUTIVE SUMMARY:

7+ years of experience as a SAS programmer in Health Care Data Analysis, Pharmaceutical and Financial Analysis.

Strong experience in Macro programming with DB2, SAS/BASE, SAS/MACRO, SAS/CONNECT, SAS/ODS, SAS/GRAPH, SAS/SQL, SAS/STAT, SAS/ACCESS in WINDOWS, ORACLE and Teradata databases and UNIX environments.

Experience working in SAS Business Intelligence (BI) platform with Enterprise Guide, Stored Process, Information Map Studio, Microsoft Add-In, Dashboards, OLAP Cubes, DI Studio and Web Report Studio.

Developed various Unix Shell Scripts to manipulate data files, set-up environment variables, custom FTP utility, file archiving.

Extensive SAS programming experience in Design, Development, Implementations, Testing, Support, Maintenance & Upgrade or Promote and Migration of SAS Application.

Gained strong mapping knowledge in submission of data in CDISC SDTM format, based on CDISC SDTM Implementation guide.

Involved in creation and validation of datasets according of CDISC SDTM standards following specifications document.

Exceptional ability in problem solving, data analysis, complex reports generation with macro and data transfer between different environments.

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.

Worked in updating, data extraction, transformation and loading to data warehouse, data analysis, updating, testing, trending, mapping analysis and business driven data validation.

Review accounts for potential fraud, Assist customers to verify potential fraud activity, Balance risk factors with customer delight, Process fraud claims to report fraudulent activity.

Interface with Sales, Accounting, Merchant Support, and Customer Support teams to help

understand, resolve and (internally) communicate fraud or potential fraud issues, Support transaction monitoring, chargeback monitoring, and fraud analyst.

Extensively worked with Health care claims (Medical, Pharmacy) using CPT codes, ICD-9, NDC codes etc.,

Responsible for Programming in SAS using Base SAS, Macro Facility, Proc SQL, SAS Procedures, SAS Functions, SAS Formats, and ODS facility in data scrubbing, manipulation, and preparation to produce summary datasets and reports.

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

Experience in Microsoft Office tools like MS Access, MS Word, MS PowerPoint, and MS Excel etc.

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

Extensive experience in preparation of reports, tables, listings and graphs in HTML, PDF and RTF formats using Output Delivery System.

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

Strong Project coordination including strategic planning, trend analysis, forecasting, variance analysis, database management.

Write, maintain, and support SAS Programs in SAS Base and Enterprise Guide.

Extensively worked with PROC SQL to extract data from Oracle database, load data into database, print sophisticated reports and Lists, Graphs etc.

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

Extensive experience in Data collection, Design, Analysis and Reports.

Very good team player with excellent communication, analytical and problem solving skills.

TECHNICAL SKILLS:

SAS Tools: SAS/BASE, SAS/GRAPH, SAS/MACROS, SAS/ODS, SAS/REPORTS, SAS/ACCESS, SAS/STAT, SAS/EG, SAS v 9.3/8.2.

SAS Procs: Print, Means, Univariate, Correlation, Regression, SQL, Tabulate, Freq, Sort, Summary, Format, Import, Export, Transpose, Compare, Life Test, and Gplot.

Languages: SQL, PL/SQL, C, VBA, HTML, XML, VB Script, VB6.

Database: Oracle 10g, Teradata, Netezza, SQL Server 2000, MS Access.

Operating Systems: Windows XP/NT/2000/98, MS DOS, UNIX.

Others: Java, MSOffice (Word, Outlook), SPSS.

PROFESSIONAL EXPERIENCE:

Client: Optum - UHG, CT June16 – July17

Role: SAS Data Analyst

Optum Health is part of the family of companies that make UnitedHealth Group one of the leaders across most major segments of the US health care system. HCII data warehouse provides reporting and analysis services on health care cost and utilization trends, and investigation of the health and productivity of employer's workforce through the web-based tool, Parallax i®. All the employers' data (Enrollment, Claims, Non-Claims data) can be integrated and merged in a data warehouse to support reporting and analytic.

Responsibilities:

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.

Worked extensively with Health care data (hospital, lab and physician), which includes various claims, membership details and demographics of the members.

Developed dashboards in Tableau Desktop and published them on to Tableau Server that allowed end users to understand the data with the usage of quick filters for on demand healthcare information.

Created Data Connections, published on Tableau Server for usage with Operational/Monitoring Dashboards.

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.

Developed and reviewed custom SQL queries with use of joins clauses (inner, left, right, full) in Tableau desktop to validate and reconcile data.

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.

Created complex and reusable Macros and extensively used existing macros and developed SAS Programs for Data Cleaning, Validation, Analysis and Report generation. Tested and debugged existing macros.

Developing repetitive loops for retrieving array variables for joining of datasets for ad-hoc reporting

Create Edit Checks to verify the accuracy of the data.

Developed Tableau workbooks to perform year over year, quarter over quarter, YTD, QTD and MTD type of analysis.

Created reports based on the claims Medical and Pharmacy pulled using CPT, ICD-9 and NDC codes for various Diseases.

Attended various seminar presentations on Medicaid fraud such as finding duplicate claims, service after death, multiple service providers etc.

Involved in writing code using Base SAS & SAS/Macros to clean and validate data from oracle tables.

Involved in developing various fraud algorithms and validated existing algorithms against specification.

Independently perform data investigations. (Investigate code; utilize reporting environment, special requests, program mods, etc.).

SAS Enterprise Guide was used to convert existing SAS programs to SAS stored processes using dynamic prompts and produced packaging and streaming outputs as required.

Extensively used company standard macros, generating graphs, listings, PDF and RTF files using various Base SAS Procedures.

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

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

Coordinate new data development which includes the creation of new structure to meet business requirements or streamline existing processes to reduce overhead on the existing warehouse with ETL Development team.

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

Improvement of data quality.

Environment: UNIX, Windows NT, SAS 9.3, Oracle, DB2, SQL, PL/SQL, SAS/BASE, SAS/ MACROS, SAS/Enterprise guide, SAS/ACCESS, SAS/STAT, SAS/GRAPH, MS-Access.

Abbott Laboratories - Waukegan, IL Jan16 – Jun16

Role: SAS Programmer

Responsibilities:

Extracted data from Oracle database (warehouse).

Worked on therapeutic areas like Anti Psychotics, Dermatology, Oncology.

Programming to Support Phase II, III, IV trials.

Reviewed Protocols, Case Report Forms, and Statistical Analysis Plans for Clinical trials.

Worked with Data Managers for ensuring the Data Integrity and performed Data Cleaning, Data Validation according to the requirement of Clinical and Data Management Department (DMD).

Transferred data between databases using import/export facility in SAS.

Annotated SDTM CRF.

Gained strong mapping knowledge in submission of data in CDISC SDTM format, based on CDISC SDTM Implementation guide.

Involved in creation and validation of datasets according of CDISC SDTM standards following specifications document.

Worked on OPEN CIDISC validate and resolving those errors.

Created Programming specifications document for creating analysis datasets for both safety and efficacy.

Developed SDTM and ADAM datasets for Safety and Efficacy data.

Involved in validation of derived datasets and other coded programs using PROC COMPARE.

Developed SAS programs for safety and efficacy tables, listings and figures.

Customize the outputs by using different PROC REPORT options and ODS.

Tabulations, Graphics and Listings from various data.

Testing a series of SAS programs to generate PDF, HTML and RTF using SAS.

Generated Patient profiles.

Performed quality checks on the existing table, listing and figures, Tested and debugged SAS programs against data.

Using SAS (BASE, Macros, PROC REPORT, PROC SQL).

Generated programs in MACROS to generate graphs, listings, quality tables for Clinical study reports and regulatory submissions.

Sound knowledge of using BASE SAS functions like (ROUND, SCAN, TRIM, LENGTH, PUT, INPUT, DATE, MAX, MIN, MEAN, and STD).

Supported E-submission by generating SAS XPORT files and other appropriate deliverables and documentation for regulatory submissions CDISC standards.

Deliver datasets and TLF's within timelines to client.

Performed quality assurance Procedures of other programmer's work, cross-validation of SAS programs, and debug complex programming code by using DATA step.

Generated edit check listings to help clean the data (Data cleaning and verification) on a regular basis of data refresh.

Did Pre-database lock and post data base lock QA.

Served as primary SAS programmer and collaborate with statistician in analyzing initial data sets and generating tables, listings and figures (TLFs) for Clinical trials.

Assisted the coordinator in developing standard programming guidelines and deadlines for different projects.

Converted Excel tables and flat (text) files into SAS datasets for Ad-Hoc analysis.

Data analysis, reports using SAS procedures and SAS/Macros.

Developing SAS Stored Processes that can be easily used by end users using SAS Add-in for Microsoft Office and other SAS BI clients from SAS Information Delivery Portal.

Environment: UNIX, Windows NT, SAS 9.3, Oracle, DB2, SQL, PL/SQL, SAS/BASE, SAS/ MACROS, SAS/Enterprise guide, SAS/ACCESS, SAS/STAT, SAS/GRAPH, MS-Access.

Axis Bank ltd, Bangalore, India Jan13 - Aug14

Role : SAS Developer

The project I involved deals with accessing different type of data sources, maintaining and analyzing records. It included various tasks in credit risk and operational risk analysis. SAS and analytic techniques were applied in data management, reporting, and consumer regression modeling to get the desired results.

Responsibilities:

Involved in analysis, development, testing, implementation, and provided technical support to business needs using SAS in Unix environment

Created macro program to create Macro variables to pull data from oracle and SQL server for monthly daily data extracting.

Performed daily weekly and monthly campaigns as per the deliverable schedules.

Creating waterfall reports and analyzing data and creating ad-hoc's on deliverables.

Advanced analytics and reports created based on the criteria provided.

Extracted data from different sources like Oracle and text files using SAS/Access, SAS SQL procedures and created SAS datasets.

Performed approvals for peer audit reviews on reports by analyzing data.

Developed SAS Macro programs to create ad-hoc reports.

Developed application for measuring financial performance of newly acquired accounts such as Forecast vs. Actual and developed SAS programs for generating reports on key financials, Income Statements and Balance Sheets.

Converted the financial data retrieved from vendors into SAS readable format and executed the datasets to produce necessary financial reports using SAS/STAT procedures such as PROC FREQ, PROC REPORT.

Importing all Reports from web report studio, Stored Process, BI Dashboard and Information Map to Information Delivery Portal.

Extensively used the SET, UPDATE and MERGE statements for creating, updating and merging various SAS data sets.

Used SAS Proc SQL pass through facility to connect to Oracle tables and created SAS datasets using various SQL joins such as left join, right join, inner join and full join.

Used SAS Macros and SAS SQL to query data and to obtain results which were generally stored as delimited text.

Developing repetitive loops for retrieving array variables for joining of datasets for ad-hoc reporting.

Worked with complex datasets to extract customized reports using PROC SQL, PROC FREQ, PROC SORT, PROC REPORT, PROC MEANS for creating a preferred list of customers as per the given requirements from business analysts.

Created reports in the style format (RTF, PDF and HTML) using ODS statements and PROC TEMPLATE. Used DBLOAD procedure to load data into the database effectively prepared and published various performance reports and presentations.

Revised and automated daily, weekly, monthly and quarterly reports to run more efficiently and provide more meaningful information vital to the overall strategies.

Environment: SAS 9.3, (BASE, MACROS, CONNECT, SQL, GRAPH) Oracle, MS Excel, and Windows.

Syndicate Finance, Mumbai, India Jun10 - Dec12

Role : SAS Developer

Syndicate Finance is an India based Finance company in which I Assisted the marketing Department as a SAS Data analyst in carrying out Business marketing campaigns.

Responsibilities:

Modifying incoming data using SAS code by reformatting, importing, sorting, merging and restructuring.

Maintaining the large datasets, combining data from various sources in varying formats to create SAS datasets and/or ASCII files.

Accessing the client data using SAS from relational database like SQL server.

Created complex and reusable macros and extensively used existing macros and developed SAS programs for data cleaning, validation, analysis and report generation.

Created high level SQL data Tables using Proc SQL for Dashboard reporting.

Conducted analyses - linear/ logistic regression, segmentation/cluster analysis, factor analysis, and database/ data mining to identify significant differences in relationships among sources of retail data information.

Evaluated actual purchases, market shares, distribution, pricing, merchandising and promotional activities.

Creating management decision support models and reports that derive to help in Decision making.

Handled Automation projects as required by the client and performance tune.

Analysis of various business related reports and Dashboard Management.

Creation of trends on various parameters cluster wise, zone wise and Region wise for comparative Analysis.

Producing external files and reports employing various SAS procedures like Proc Print, proc contents, Proc Report, Proc Summary, Proc Freq, Proc sort & Proc SQL.

Generating Ad-hoc reports as per the business requirement.

Executing weekly deliverables using existing code.

Environment: SAS 9.2, Base SAS, SAS/SQL, SAS/MACROS, SAS/ACCESS, SAS/ODS, MS EXCEL, MS ACCESS and

WINDOWS.

ICICI Bank, India Aug08 – May10

Role: SAS Programmer/Analyst

Responsibilities:

Worked extensively to generate SAS data sets, statistical reports, monthly reports, listings, safety reports for cross-functional.

Extensively used SAS Data Step functions and descriptive statistical Procedures to process large amounts of customer response and sales data.

Used PROC SQL LIBNAME and PROC SQL Pass-through methods to access data on Oracle database.

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.

Used SAS enterprise Guide to run statistical tests like ANOVA, Chi-square etc.

Created Ad hoc reports for marketing managers using SAS Enterprise Guide.

Environment: SAS/Base, SAS/Macro, SAS/SQL, SAS/Stat, SAS/Graph, SAS/Access, SAS/ODS, MS Office, MS Access, SAS Enterprise Guide.

CERTIFICATIONS:

SAS Certified Base Programmer for SAS 9

EDUCATION:

Masters of Science in Computer Science.

Contact this candidate