Aditya D. Email & Phone Number

United States

Virginia, United States

- Analyzed data files, data layouts and data dictionaries from providers of health care (Hospitals) administrative data (eligibility, account/plan, medical claims, pharmacy claims), as well from CMS the claims data, to understand data structure and operating rules for transforming to common data format - Conducted in-depth interviews with data providers (client or payer staff) to ensure comprehensive understanding of data operating logic and data provided - Authored data mapping and transformation requirements based on understanding of operating rules - Produced detailed data quality profiles from client health care administrative data to validate structure, content and overall data quality; present findings to internal stakeholders for signoff and/or escalate critical data issues as neces-sary - Served as a subject matter expert in primary data domain relative to client’s data and transformation rules; back up analysis in other data domains as workloads and priorities required. - Executed test cases to validate source data has been accurately mapped, transformed and loaded to common format and later being loaded into the EDW - Held meetings every week with the development team to track the progress on the outstanding defects and issues, logged them in QC and tracked them to closure. - Alert project managers to potential risks and issues of importance. - Analyzed large data sets consisting of millions of records Expertise in handling Analysis of the data and Missing data imputation using LOCF/BOCF/WOCF. - Worked on Transactional claim submissions and provide periodic update Reports. - This project involves redesigning a member facing web application to manage health care insurance policies. The member portal allows users to view their policy information and manage their claims and coverages. - Performed feasibility analysis, scope projects, prioritize deliverables, recommend alternative solutions and project strategies, and engage in negotiations.

Falls Church, Virginia

Indianapolis, Indiana, United States

- Analyzing Diabetic Patients from INDIANA state for Drug Profiling - Used SQL and ‘R’ Language to analyze the data and do profiling of the drugs using Bipartite Graph. - Analyzing HCUP NIS Data for patients diagnosed with Parkinson Disease, its economic impact - Deployed a virtual machine on the server to work on the huge dataset, Analysis using SQL and SAS. - Interoperability between two systems SureScripts and Open MRS (EHR System). - Transfer path from CDA HL7 standard document to Surescript Pharmacy system. Using XSL Transformation and create a generic XSL FO for a patient information leaflet. - Used Stanford NLP Parser in comparing New York’s restaurant inspection rating data and Yelp’s Customer Review using the score obtained from review’s Sentimental analysis.

Bloomington, Indiana Area

Hyderabad, Telangana, India

- Worked with researchers to create analytic files using administrative health care data. - Maintained complex and reusable Macros and extensively used existing macros and developed SAS Programs. - Created different types of summery tables and listings tables using PROC MEANS, PROC TABULATE, PROC REPORT. - SAS Utility/Macro creation for global use, involved in Coding analyzing, Report generation and testing programs using SAS/Base, SAS/Macro, SAS/STAT and SAS/SQL to the Client requirements. - Extensively used Data _Null_ and SAS procedures such as Print, Report, Tabulate, Freq, Means, Summary and Transpose for producing ad-hoc and customized reports and external files. - 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. - Generated Tables, Graphs and Listings for inclusion in Clinical study reports and regulatory submission. - Validated most of the SDTM domains as per CDISC standards by using specifications. - Create, execute, maintain, and validate programs that generate listings, tables and figures using SAS programming, macros, SAS/GRAPH and SAS/STAT. - Perform secondary research to identify potential suppliers in the market and to analyze the latest trends of our incumbents. - Make recommendations with regard to the storing of relevant benchmarks, reference data, and metadata needed for state of the art Data Quality Analytics program. - Communicated very well throughout the team for implementation and changes of codes - Maintained proper work instructions of various processes and updated as and when required.Environment: SAS, SQL, Teradata, MS Office, Databases, PUTTY, SAS/BASE, SAS/SQL, SAS/ACCESS, SAS/GRAPH, SAS/ODS, ORACLE, Windows, Excel, SQL

Asia

- Startup Business- Coordinated clinical requirements and ground scenarios to technical requirements to build an android application.- Review local Laws and create policies for the operations team.- Design and Implement a customer outreach program to increase the customer base.- Designing discount programs and implementation of the same through mobile application.- Coordinated operations with delivery teams.- Negotiated contracts with local pharmacies for the supply of medications.

Masters, Health Informatics

Doctor Of Pharmacy (Pharmd), Medicinal And Pharmaceutical Sciences

Activities and Societies: Research and developmentOnline certificate for fundamentals in clinical trails learning program from HarvardX.

Doctor Of Pharmacy (Pharm.D), Pharmacy