Ashwini Kulkarni
E-mail: actbot@r.postjobfree.com
Mobile: 423-***-****
OVERVIEW
* ***** ** ********* ********** in SAS programming on different platforms - Windows and UNIX, also having worked in updating, data extraction, transformation and loading to data warehouse, data analysis, updating, testing and data validation.
Experience working with Healthcare claims data (HCPCS, CPT-4 codes and knowledge of drug databases).
Experience in Data analysis and Reporting in health care domain.
Experience in analyzing needs and trends accurately.
Ability to work with diverse groups and to recommend changes that are cost effective.
Ability to produce SAS programs “from scratch”, efficiently complete Ad Hoc requests.
Efficiency in utilizing SAS techniques to minimize processing time and space required while handling large amounts of data from different sources.
Experience in SAS/BASE, SAS/MACRO, and SAS/ODS, SAS/SQL, SAS/STAT, SAS/GRAPH, SAS/ACCESS, and SAS/CONNECT in UNIX and Windows environments.
Strong ability to write SQL queries using PROC SQL and SAS ENTERPRISE GUIDE for reporting and analytical tasks.
Experience in utilizing SAS Procedures, Macros, and other SAS applications for data extraction, data cleansing, data loading and reporting. Involved in the data analysis, DB creation, applying database constraints and make ready to load onto database.
Involved in coding and pulling data from various oracle tables using Unions and Joins.
Customize the variables to user-defined formats using PROC FORMAT in printing reports.
Expertise in using various SAS report generating procedures like PROC REPORT, PROC SQL, PROC FREQ, PROC MEANS, PROC TABULATE, PROC TRANSPOSE and PROC PRINT.
Experience in performing ad hoc queries for various application and reports on a daily/weekly or monthly basis.
WORK EXPERIENCE
Data Analyst/SAS Programmer
General Dynamics Information Technology, Des Moines, Iowa
May 2014 - Present
Analyzing and Reporting of mortality measure for acute myocardial infarction (AMI) and heart failure (HF) and for pneumonia (PN).
Co-coordinating with Centers of Medicare and Medicaid Services (CMS) to annually calculate the mortality measure based on Medicare enrollment data, Part A and B claims and administrative data for public reporting.
Developed Analytical and statistical models to predict and quantify business metrics.
Unit testing the created SAS code/s with associated control data to determine whether they are fit for use. Generating custom Reports using SAS/SQL against multiple data sources.
Developed an automation technique for scheduling SAS jobs using advanced SAS Macro code.
Reduce programming time by developing reusable SAS programs which incorporate data step views and DATA steps that write SAS programs
Perform effective benchmarking by using the appropriate SAS System options and interpreting the resulting resource utilization statistics.
Determine the resources used by the SORT procedure and avoid unnecessary sorts by using appropriate indexes, data set options, BY statement options, and the CLASS statement.
Also used SAS Statistical procedures like PROC REPORT, PROC TABULATE, PROC FREQ, PROC MEANS and Data steps, LIBNAME and SQL PASSTHRU facility to accomplish the tasks.
Conducting Data Sanitization to ensure that data is accurately generated and reported. Verifying accuracy of data using descriptive statistics like Quartile/s, mean, Standard Deviation, Central tendency and Dispersion in base SAS 9.3 or/and Enterprise guide 4.3.
Technologies Used: SAS/SAS Enterprise Guide, SQL, Tectia, Microsoft Products like Excel, Access.
SAS Programmer
General Motors Research Center, Detroit and India Locations Dec 2010 to Dec 2013
Responsibilities:
Gathered requirements, programmed, quality checked(QA), and maintained SAS programs, SQL code, Oracle databases and schemas, and other infrastructure in fulfillment of healthcare project to generate medical performances outcomes measure.
Analyzed the change in Parts required for the future Model years as requested by the Design Release Engineers and document Control using Product Life Cycle Management.
Relied heavily on Proc SQL to read, manipulate, analyze, Summarize (or aggregate) and process through multiple billions of records of sales and billing data from Oracle databases within windows environment.
Programmed SAS code to transform structure of raw data into a specific form the tool required.
Implemented user-friendly functionality and operation, incorporated internal QA checks, validation checks and other tracking mechanisms to ensure quality of information and timely deliverables.
Developed work plans, statistical analysis plans, specifications and methodologies for calculating performance quality measure results for special projects.
Performed data analysis and presented reports to internal clients.
Gathered data from internal clients and produced graphs by using SAS Graphs for different measures for different physician offices and different physicians.
Environment: SAS Base, SAS/CONNECT, SAS Macros, SAS/ACCESS, Oracle, Windows, MS Office, HTML, SAS Enterprise Guide, SAS/Graph, MS/Access.
TECHNICAL SKILLS
SAS Tools: SAS/Base, SAS/SQL, SAS/Macro, SAS/Stat, SAS/Connect, SAS/ODS, SAS/ACCESS SAS/ACCESS, SAS/ETL, SAS/Graph, SAS EG
Programming Languages: SQL, Python
Big Data Tools: R, Google Analytics, JMP
Operating Systems: UNIX, Mainframe, MS Windows
Database: MS-Access, Oracle, SQL server
Methodologies: Agile and Waterfall
Other Technologies: Microsoft Office (Word, Excel, PowerPoint, Outlook), HTML
EDUCATION
BVB College of Engineering and Technology, BS in Industrial and Engineering, India, 2010
Iowa State University, MS in Engineering Management, United States, 2015