Mayuresh Deodhar Email & Phone Number

Boston, Ma, Us

San Francisco, California, Us

• Designed ETL data pipelines by parallelizing Databricks job using Airflow to collect, process, and ensure the quality of large-scale healthcare data from various sources, processing over 1500 Practices with a 90% data accuracy rate.• Applied and maintained complex data transformations to mapping scripts based on business logic and requirements.• Implemented data warehousing solutions using Redshift and S3 to store and manage processed data, capable of supporting a broad range of use cases in analytics, real-world evidence, clinical trials, and MIPS reporting.• Utilized Power BI to create interactive dashboards and reports, leveraging analytics to improve patient outcomes and enhance care quality, resulting in a 25% increase in data-driven decision-making• Collaborated with clinical and analytics teams to enhance the quality of ingested data by 35%, leveraging a deep understanding of clinical requirements and KPI metrics.• Ensured compliance with healthcare standards and regulations (e.g., HIPAA, GDPR) and implemented data quality control measures to guarantee data accuracy and integrity throughout the data engineering process.

Boston, Ma, Us

Leveraged Snowflake's powerful SQL capabilities to deliver deep into EHR/EMR data, uncovering crucial insights intoAlzheimer's disease risk factors and underlying mechanisms.•Developed robust ETL pipelines using Python, seamlessly extracting data from Enterprise Data Warehouses (EDWs), transforming it into meaningful metrics, and efficiently loading it into optimized flat file formats.•Fostered strong alliances with researchers and physicians, aligning project goals and objectives, by offering clear, visually appealing summary statistics using Tableau, effectively communicating findings to diverse stakeholders.•Implemented advanced data processing techniques using Python's regular expressions, meticulously validating large datasets and reducing false positives by an impressive 25%, ensuring data integrity and reliability.

Philadelphia, Pennsylvania, Us

• Analyzed KPIs and trends in Tableau and SQL to improve events revenue by evaluating opportunities in the existing events• Developed ETL jobs on Events and product data using SSIS to turn disorganized data feeds into high-quality data assets• Communicated with stakeholders to understand evolving business requirements and effectively managed end to end impact analysis and component changes• Worked with CEO/advisors to ideate, design, and integrate company's client-facing analytics report -- synced in real-time to the company's database, programmatically changing based on an event's chosen features

•Utilized advanced SQL skills to construct complex queries that translated operational metric requirements into functional requirements, ensuring seamless data integration and analysis.•Designed and developed SSIS ETL packages to integrate sales and client data from flat files into SQL Server, creating data marts that facilitated efficient data analysis and reporting.•Enabled the tracking of client and sales information through the implementation of slowly changing dimensions, allowing for comprehensive historical analysis and data visualization.•Leveraged Power BI to automate KPI reporting by deriving insights through dynamic visualizations, providing stakeholders with real-time data-driven insights to inform business decisions.

Master'S Degree, Management Information Systems, General

Bachelor'S Degree, Information Technology