Omkar Ovhal

Developed and maintained data pipelines using Snowflake, consolidating data from multiple sources to enable efficient extraction, transformation, and loading (ETL) processes, improving data accessibility for enhanced reporting and analytics. Optimized Snowflake database performance by fine-tuning SQL queries and stored procedures used in data quality checks, reducing data processing time by 30% and improving overall data quality and reliability. Built Analytical Ready Datasets (ARDs) leveraging referral and shipment sales data for a leading pharmaceutical client, generating insights that influenced 20% growth in sales performance. Collaborated with cross-functional teams to refine various KPIs, expanding categories by 15%, increasing accuracy and efficiency. Integrated payer information, covered lives, and TRx sales data from multiple sources (MMIT, IQVIA, SHA, Precision) to create unified, consistent payer-level insights across analytics and reporting platforms.

Underwent rigorous training in AWS, specializing in various services such as Amazon EC2, Amazon Redshift, Amazon RDS, and AWS Glue. I applied this knowledge in designing and implementing robust AWS solutions for my clients. My responsibilities included deploying and managing Amazon EC2 instances and optimizing data warehousing with Amazon Redshift. I played a key role in leveraging AWS Glue for efficient data extraction, transformation, and loading (ETL) processes, contributing to enhanced data integration.

Engineered a 10X performance boost for the Quality Control Reporting Tool (QCRT), optimizing speed and efficiency through collaborative cross-team efforts. Introduced an intuitive color coding system, enhancing data visualization and accessibility within the QCRT. Developed and integrated an advanced filtering feature, elevating user experience by enabling dynamic data manipulation. Diagnosed and resolved errors, showcasing strong problem-solving skills, while actively participating in agile methodologies and cross-functional collaboration.

Courses: Data Structures, Algorithms, Artificial Intelligence, Machine Learning, Cloud Computing, Networking, OS, Databases