Jay Patil
Cincinnati
Summary
Results-driven analytics professional with 7+ years in healthcare and inventory management. Expertise in building dashboards, optimizing ETL workflows, and translating complex data into actionable insights using SQL, Python, Power BI, and Excel. Focused on leveraging data science and business intelligence to enhance decision-making and drive operational efficiency.
Overview
6
6
years of professional experience
Work History
AI Support Analyst
MEA Platform Pvt. Ltd.
02.2022 - 07.2023
- Reduced manual reporting workload by 70% through full ETL automation and dashboard integration.
- Designed and automated ETL pipelines using SQL Server and Python to integrate multi-source data into centralized models.
- Optimized stored procedures, queries, and indexing, improving data refresh and dashboard load times by 40%.
- Developed Power BI dashboards for executive insights, incorporating Row-Level Security.
- Partnered with product and engineering teams to improve reporting accuracy and enhance system scalability.
- Established data quality frameworks and maintained documentation for version control and governance.
Data Analyst
Fedora Healthcare Pvt. Ltd.
02.2021 - 01.2022
- Created and optimized SQL scripts and stored procedures for KPI tracking, regulatory reporting, and business analysis, enabling informed decision-making.
- Developed and maintained ETL dataflows to transform healthcare data into clean, analysis-ready SQL structures, enhancing data usability for analysis.
- Conducted data validation and reconciliation to ensure accuracy across clinical and operational datasets, supporting reliable reporting and analysis.
- Improved ETL efficiency by 35% and migrated legacy Excel reports to Power BI and SQL-based automation.
- Supported database schema design and performance optimization for improved data accessibility.
- Partnered with business users to translate data requirements into automated reporting solutions.
Data Analysis Intern
Rubixe
05.2021 - 10.2021
- Created interactive Power BI dashboards to effectively visualize KPIs and business trends.
- Developed ETL workflows and SQL-based data transformation scripts to enhance client analytics projects.
- Supported data cleaning, validation, and documentation to ensure accuracy in ongoing analytics pipelines.
Inventory Analyst
Caretronics Systems
09.2017 - 02.2020
- Automated weekly and monthly inventory reports using SQL and Excel, cutting manual effort by 30%.
- Monitored data integrity and implemented exception checks, reducing stock discrepancy rates by 20%.
- Analyzed inventory trends to inform purchasing and demand planning decisions, optimizing stock levels.
- Managed Excel and SQL databases tracking inventory, procurement, and supplier metrics across multiple facilities.
- Developed ETL scripts for efficient data extraction, transformation, and loading from ERP systems into SQL Server, streamlining data processes.
- Delivered a standardized data pipeline improving cross-departmental data consistency and visibility.
Education
Master of Science - Data Analytics
Saint Louis University
St. Louis, MO05-2024
Bachelor of Science - Mechanical Engineering
Gujarat Technological University
08-2020
Skills
- Data Integration Techniques
- ETL Pipelines
- Data Quality Management
- SQL
- MySQL
- MS SQL Server
- Python
- Data Modeling
- Query Optimization
- Power BI
- Tableau
- Data Storytelling
- Natural Language Understanding
- Stakeholder Communication
Projects
- Enterprise BI Solution, Designed and deployed interactive Power BI dashboards integrating real-time market data with automated reporting., Enabled leadership to track KPIs with improved transparency, supporting cost reduction initiatives by 15%., Enhanced decision-making efficiency through drill-down analytics and actionable visualizations., Designed an end-to-end ETL process using SQL and Power Query to integrate live market and sales data.
- Stock Market Analysis Dashboard, Developed a Power BI solution combining real-time market feeds with technical indicators., Incorporated forecasting models to support investment decision-making., Created dynamic dashboards for traders to visualize trends and assess market movements., Created an ETL pipeline to extract, transform, and load procurement data into a centralized SQL database.
- Coffee Chain Analysis, Conducted end-to-end analysis of sales and profitability drivers using Python (Pandas, Matplotlib, Seaborn)., Identified high-performing products, seasonal trends, and key revenue opportunities., Delivered visual insights to optimize pricing, product mix, and regional sales strategies., Built ETL workflows using Python (Pandas) to clean and merge multi-source retail data.
- Prompt Engineering for AI Models, Designed optimized prompts for diverse natural language processing (NLP) applications., Increased GPT model output precision for targeted business use cases by 40%., Streamlined AI workflows by reducing manual tuning and improving consistency in results.
- Procurement KPI Analysis, Built a Power BI dashboard with advanced visuals to monitor procurement KPIs and compliance., Applied Python-based analysis to identify cost-saving opportunities and inefficiencies., Streamlined AI workflows by reducing manual tuning and improving consistency in results., Developed ETL pipelines integrating real-time stock data via APIs into SQL Server.
- University Suitability Model, Built a machine learning model with feature engineering and exploratory data analysis (EDA)., Recommended universities tailored to student academic profiles with 87% prediction accuracy., Delivered data-driven insights that simplified the decision-making process for applicants.
Extracurricular Activities
Volunteer, Sahajayoga Meditation, Since 2008, I have volunteered with Sahaja Yoga, helping individuals practice meditation to achieve inner balance and well-being. I guide participants in integrating thoughtless awareness into their daily routines to reduce stress and improve focus. Through these sessions, I support emotional balance, clarity, and personal growth. Team Captain, Urmi School, From 2014 to 2016, I served as the captain of the Urmi School basketball team, leading the team in inter-school competitions. I coordinated practice sessions, motivated teammates, and fostered strong teamwork on and off the court. Under my leadership, the team built discipline, collaboration, and a winning spirit.
Languages
English
Native/ Bilingual
Japanese
Elementary
Hindi
Native/ Bilingual
Timeline
AI Support Analyst
MEA Platform Pvt. Ltd.
02.2022 - 07.2023
Data Analysis Intern
Rubixe
05.2021 - 10.2021
Data Analyst
Fedora Healthcare Pvt. Ltd.
02.2021 - 01.2022
Inventory Analyst
Caretronics Systems
09.2017 - 02.2020
Master of Science - Data Analytics
Saint Louis University
Bachelor of Science - Mechanical Engineering
Gujarat Technological University