Prathamesh Parab Email & Phone Number

Hyderabad, Telangana, India

Worked on the migration of data from on-premises SQL server to cloud database using (Azure Synapse Analytics (DW) and Azure SQL DB.Worked with Azure BLOB and Data Lake Storage for landing data into Azure SQL-Synapse(DW), To build Data-warehouse solution.Design and developed ETL frameworks using Azure Data Factory and Azure Databricks.Developed and maintained end-to-end data solutions on the Azure platform, enabling data- driven decision-making for healthcare providers and improving patient outcomes.Designed and implemented scalable data models for healthcare data using Azure SQL-Data Warehouse, ensuring optimal performance and data integrity.Developed ETL pipelines using Azure Data Factory to extract, transform ,and load data from various sources, including electronic health records (EHR) systems and medical claims data.Implemented data quality checks and automated data cleansing processes to improve data accuracy and reliability.Collaborated with cross-functional teams to identify business requirements, gather data needs, and deliver solutions that aligned with organizational goals.

Pune, Maharashtra, India

Analyze upcoming and current end user specification to enhance clinical operations.Design clinical and management reports.Review, extract, gather and evaluate patient/subject data such as medical, monetary andcoding records (e.g. insurance processing, clinical operations, and patient behavior) to extracttrends and business insights.Cleaning and transforming massive data into useful and insightful to specific teams.Create interactive dashboards and reports for teams within the organization.Evaluate reports for validity and create report archives.Data analysis with MS access and Google Spreadsheet SQL, Tableau.Write data definition language or data manipulation language SQL commands.Collects, cleans, transforms and validates data as a process for arriving at conclusions.Presents data in the form of charts, graphs and tables for immediate reference.Performs audit on all data for the purpose of business development resolution.Qualifies all collected data before categorizing as useful information.Presents analyses of all data to concerned officers, managers and departments.Coordinates with all key or authorized people with the distribution of data analysis.Coordinates with technical analysts and fundamental analysts before publishing client reports.Monitors and organizes all client invoices for the purpose of accurate and timely billing procedures.Maintains and updates all data archives.Conducts periodic internal audits.Use statistical methods to analyze data and generate useful business reports.Collaborate with peers and other people inside and outside the business.

Pune, Maharashtra, India

Job Role: Safety Data AnalystProduced monthly reports using advanced Excel spreadsheet functions.Designing database schema, create tables to store data, and perform data manipulation.Built Tableau dashboard to visualize core business KPIs (e.g. Patient Safety), saving 10 hours perweek of manual reporting workUtilized excel functionality to gather, compile and analyze data from pivot tables and createdgraphs/charts. Provided analysis on any claims data discrepancies in reports or dashboards.Responsible for the analysis, data validation, and submission of AdHoc reports on an annual basis.Researched, compiled, analyzed, and reported various operational claims data from multiplesources.Performed detailed analysis on key trends and findings; summarized and presented findings tomanagers.Perform analyses of patient characteristics that are associated with particular health outcomes orfuture use.Creating and executing queries utilizing various data sources to provide business information.

Master In Science, Quantitative Biology,Life Science, Statistics, 8.8 Cgpa

Bachelor Of Science - Bs, Quantitative Biology, First Class

Data Analytics (Data Science), Data Science

Data Associate / Data Science Skills: Python Programming Language SQL / Mysql MS Excel R Programming Language Hadoop environment Apache.