Summary:

Experienced healthcare Business Data Analyst and health economist with expertise in data visualization, statistical
analysis, and health services research. Demonstrated ability to translate complex data into clear insights that improve
patient care and inform policy decisions.

Project Experience:
Experienced in analyzing data pertaining to different backgrounds such as Healthcare. Analyzed statistical significance
through AB testing. Experienced in broad range of technologies, including business process tools such as Microsoft
Project, POWER BI,Tableau, OBIEE,SAS, MS Excel, MS Access, MS Visio, technical assessment tools. Good
knowledge and working experience with reporting tools like Tableau, POWER BI, SSIS, SSRS, SSAS. Created data
dictionaries, models, requirements and workflows to execute Data Governance process.

SKILLS:
Skills and Software Proficiencies:
 Data Analysis, Research, Statistical Operations, Economic modelling,
 Excellent knowledge of Cost-effectiveness, Budget Impact, and Cost benefit analysis.
 Clinical Trials and Protocols.
 HIPAA Release of Information Specialist.
 Quality Assurance and Business Data Analyst role excellent knowledge.
 Workable experience of Real time research acquired during Capstone project
 Release of Information Specialist, Billing, Quality Control, Research, Medical terminologies, and conditions.
 FDA Regulations for drug development and medical devices, Global Health
 Systems, Ethics, Economic evaluations, and Policy Changes Impact Analysis as per FDA for drug development and
medical devices.
 Microsoft Excel, Pivot tables, charts, and Statistical analysis.
 SPSS, Tree Age Pro, VMware Horizon
 EMR systems like Epic, Meditech.
 Microsoft Office Applications: (MS Word, MS Excel & MS PowerPoint).
 Data visualization:Python, Power BI, Excel

RELEVANT WORK EXPERIENCE:

 Conducted independent statistical analysis, descriptive analysis, and hypothesis testing and logistic regression.
 Converted metric insight reports to tableau reports.
 Established problem lifecycle management processes via help desk tools including call-centers, incident/problem
ticketing system, dispatching, time tracking, and client interaction.
 Design, configuration and implementation of Saas contracts Technology lifecycle management solution.
 Demonstrated proficiency in using specialized MDH tools or platforms to streamline the harmonization process.
 Designed and implemented data profiling and data quality improvement solution to analyze, match, cleanse, and
consolidate data before loading into data warehouse.
 Build data pipelines in airflow in GCP for ETL related jobs using different airflow operators.
 Document all data mapping and transformation processes in the Functional Design documents based on the business
requirements.
 Configured laboratory Information management systems, such as Labvantage SOL [Link] validation
master plans and validating LIMS implementations
 Created business intelligence reports and dashboards utilizing Power Blimplementing complex hierarchical row level
security.
 Documented processes by creating SOPs and flow charts.
 Involved in System Analysis, Design, Development and Testing.
 Provide SQL queries to extract data from the Legacy System on alerted accounts and customers information to feed
into the Portfolio Analyzer system.
 Creating users, groups, projects, Data connections, settings as a tableau administrator.
 Assisted in development of data formatting and cleaning criteria from various data sources.
 Delivered all key documentation for the above including Business Case, BRD, FRD, Use cases, Business
Rules, Process flows.
 Data management including database cleansing, merging and appending. Evaluate data integrity, conduct basic,
intermediate and advanced statisticalanalysis (R).
 Generated, wrote and run SQL script to implement the DB changes including table update, addition or update of
indexes, creation of views and store procedures.
 HEDIS and Medicare codes development for coding, testing and debugging and reporting design.
 Generated database reports, presentation and documentation of analytical methods.
 Performed ad hoc analysis of data sources for all external and internal customers.
 Worked with Data Warehouse team in developing Dimensional Model and analyzing the ER-Diagrams
 Coordinated with clients for management of data mining and recovery projects.
 Performed SQL Backup and Restore tasks on Various SQL Servers.
 TLM (Technology Lifecycle Management) Consultant with full cycle implementation and extensive experience in
analysis, design, development, customization and Implementation of TLM (Technology Lifecycle Management)
solutions.
 Extensively performed Data Collection and Data Conversions while transforming data using custom SQL Scripting as
well as ETL applications from Relational Solutions.
 Experience in GCP Dataproc, GCS, Cloud functions, BigQuery.
 Experience on Confidential Platform In LIMS-LabVantage V6 and V8 & Sapphire/LabWare V6 that includes
Support, Implementation. Configuration and maintainence of master data elements in both Production and Pre-
Production (Dry run/Sandbox) for nearly 15 sites globally for the client.
 Developed White Paper on Power BI for POCS to share concise information to the client.
 Primary Support and Development role for ServiceNow ITSM application and database
 Participated in refinement and technical documentation of database reporting requirements.

Newtech Dental Laboratories, Lansdale, PA April 2018 - December2020

 Formulated procedures for data extraction, transformation, and integration of health care data using Python
 Review existing IT processes in ServiceNow to identify areas of improvement and enhancement.
 Testing for processing of Medicaid Claims.
 Involved in writing use cases for UAT testing and writing validation scripts using SQL.
 Implemented and configured MDH software to automate data matching, linking, and quality checks.
 Performed Data profiling, Validation and Integration.
 Wrote the SQL queries on data staging tables and data warehouse tables to validate the data results.
 Conducted JAD sessions, user interviews, and detailed research requirement meetings to capture the re -
quirements and prepare BRD.
 Pharmacy Claims were analyzed to detect fraud via data mining practices employed by sas programming. I was
entrusted with the responsibility of understanding the business requirements, analyzing the code and the output
(reports) to detect the conditions used to validatefraud.
 Experience in moving data between GCP and Azure using Azure Data Factory.
 Worked particularly on UMS, handling data for lab and also processing, tracking, storing and reporting various
analytical data and records, I worked both on static data and dynamic data.
 Gathered and documented requirements for integration between TradeStone Technology Lifecycle Management
(TLM) solution and legacy system.
 Created SOPs for the maintenance and daily loading and auditing of the Broker database.
 Participating in HEDIS performance reporting and intervention analysis.
 Supported data warehouse projects with logical and physical data modeling in Oracle environment and assured
accurate delivery of DDL to the development teams.
 Identifying specific HEDIS measures for relevance and impact on quality goals for patients and practices alike.
 Performed Data Analysis and Data validation by writing complex SQL queries using TOAD against the ORACLE
database.
 Conducted Gap Analysis to demonstrate that UMS System remains in a validated state in its life cycle.
 Analyze high-purity peroxides via ICP-MS, ICP-OES, IC, GCMS, HPLC and TOC in a QC environment
 Conducted assessment to ensure data quality and completeness with validation techniques.
 Assisted in designing and development of health-related analytical products for overall enterprise.
 Effectively used data blending feature in tableau.
 Created Source to target Data mapping document of input/output attributes with the proper transformations which
would help for the easy development of SSIS bridge.
 Responsible for complete analysis of in process samples, final products. raw materials and stability samples in
accordance with USP NF. FDA, EPA OSHA Regulations; by using HPLC GC. UV-VIS, IR,TLC, Karl Fischer Titration and
LOD procedures.
 Conducted training sessions and workshops for end-users to promote understanding and compliance with MDH
processes.
 Define best practices for tableau report development.
 Responsible for calibrating the instruments which include HPLC, UV-Visible Spectrophotometer. Dissolution
Apparatus and other commonly used instruments such as pH meter, Friability tester etc
 Provided assistance for quantitative data analysis with health care, biometric and survey data.
 Designed and developed continuous outcomes reporting for multiple intervention programs.
 Coordinated with technical teams for research and evaluation of healthcare and operational problems.
 Participated in critical review and revision of existing systems for updates and enhancements.
 Supported technical teams for development and execution of supplemental analytical tools and methods.

Clarivate, Philadelphia, PA Mar 2016 – Mar 2018

Description: Assisted in planning and designing Data processes; also in formulating Data to improve and support
business activities. Assisted in Data analyzing and documenting client's business requirements and processes,
communicated these requirements to Healthcare personnel by constructing basic conceptual data and process models,
including data dictionaries and volume estimates.

Responsibilities:

 Utilized machine learning techniques for predictions & forecasting based on the Sales data.
 Executed overall data aggregation/alignment & process improvement reporting within the sales dept.
 Monitored and maintained high levels of data analytic quality, accuracy, and process consistency.
 Assisted sales management in data modeling.
 Analyzed statistical significance through AB testing.
 Performed data profiling in the source systems that are required for Dual Medicare Medicaid Data mart.
 Worked extensively on the T-SQL environment to run out the queries and explore the Databases.
 Ensured the data integrity by checking for duplication, completeness, accuracy and validity.
 Gathered and documented business BRD, FRD from both formal and informal sessions and validated the
needs of the business stakeholders.
 Employed data mining processes via SAS programming to detect fraud and assist with better health care data
management practices to avoid the same.
 Created Source to target Data mapping document of input/output attributes with the proper transformations which
would help for the easy development of Informatica code.
 Implemented continuous improvement initiatives to enhance MDH processes over time.
 Designing automated dashboards and data visualization to extract relevant and targeting market insights. Data
classification using Python.
 Experience developing solutions for the Technology Lifecycle Management (TLM) system including X-Author for
Word/Excel, development of clause libraries and contract templates.
 Application of various machine learning algorithms and statistical modeling - decision tree, logistic regression
to identify key features. Created classifications in Data dictionaries as per the information provided by exter-
nal sources
 SAS programming to perform ETL operations, load tables into database and pulling claims based on the business
criteria.
 Retrieved and analyzed data by writing complex ad-hoc SQL queries across large scale dataset. Managed data
migration over different platforms.
 Structured business problems and gathered/documented business requirements for developing analytical solutions.
Communicated analysis results with senior managers.
 Created forecasting model for sales prediction and performed statistical analysis to deliver actionable insights to Sales
team.
 Performed tests on import programs, analyze results, and modify programs.

EDUCATION & CERTIFICATION:

 Master of Science in Health Economics and Clinical Outcomes Research (HECOR) from XavierUniversity,
Cincinnati, Ohio. (Graduated in December 2021).
 Acquired skills Clinical epidemiology, Biostatistics, Clinical Trials, Research and Data base management.
 Bachelor of Dental Science. From Post Graduate Institute of Dental Sciences, Rohtak, India.
 AHIOS CRIS Certified.