Pratik Patil Email & Phone Number

Mumbai, Mh, In

Mumbai, Maharashtra, India

𝐒𝐨𝐟𝐭 𝐒𝐤𝐢𝐥𝐥𝐬 • Requirements Elicitation from stakeholders • Connecting with Cross-Functional Teams to achieve Report or Data delivery • Stakeholders meetings𝐎𝐃𝐈 (𝐎𝐫𝐚𝐜𝐥𝐞 𝐃𝐚𝐭𝐚 𝐈𝐧𝐭𝐞𝐠𝐫𝐚𝐭𝐨𝐫) • Developed ETL flows using Multiple Sources and making Dynamic Mappings using Variables & Packages • Developed ETL flows using various transformations to extract Data from various Sources and loading transformed clean Data into a Data Warehouse (ODS – Operational Data Store)𝐄𝐱𝐩𝐥𝐨𝐫𝐚𝐭𝐨𝐫𝐲 𝐃𝐚𝐭𝐚 𝐀𝐧𝐚𝐥𝐲𝐬𝐢𝐬 (𝐒𝐐𝐋 / 𝐏𝐋𝐒𝐐𝐋) • Data Cleaning using Oracle SQL for understanding business trends, improvement areas • Developing SQL and PLSQL Scripts for daily data refresh which can be presented over OBIEE for understanding Daily, Monthly, and Yearly Business𝐎𝐁𝐈𝐄𝐄 (𝐎𝐫𝐚𝐜𝐥𝐞 𝐁𝐮𝐬𝐢𝐧𝐞𝐬𝐬 𝐈𝐧𝐭𝐞𝐥𝐥𝐢𝐠𝐞𝐧𝐜𝐞 𝐄𝐧𝐭𝐞𝐫𝐩𝐫𝐢𝐬𝐞 𝐄𝐝𝐢𝐭𝐢𝐨𝐧) • Data Reporting using Dashboards and Reports • Developed dynamic Reports that allow users to fetch/retrieve data as per preferred parameters/condition𝐃𝐕 𝐓𝐨𝐨𝐥 (𝐎𝐫𝐚𝐜𝐥𝐞 𝐃𝐚𝐭𝐚 𝐕𝐢𝐬𝐮𝐚𝐥𝐢𝐳𝐚𝐭𝐢𝐨𝐧 𝐓𝐨𝐨𝐥) • Developing Data Models which can be used to create DV Reports which give users access to explore insights from the Data • Queried SQL and PLSQL Scripts and Scheduling for a daily refresh so up-to-date accurate Data can be visualized over Graphs and Tabular formats 𝐄𝐱𝐜𝐞𝐥 • Data Analysis on small churn of Data Excel Pivots • Developed Excel Dashboards for visualizing Data to understand the Data accurately and effectively𝐏𝐲𝐭𝐡𝐨𝐧 • Undergoing Statistical Data Analysis to identify trends, patterns, and insights from the Data using Jupyter Notebook • Data visualization to analyze and understand data more effectively in Jupyter Notebook𝐎𝐫𝐚𝐜𝐥𝐞 𝐋𝐢𝐧𝐮𝐱 • Handling Cron Jobs for Application Services Restart • Developed and scheduled Crontab for Application log-clearing • Handling Application Server Errors and Patching

Jaipur, Rajasthan, India

𝐒𝐀𝐒 𝐃𝐚𝐭𝐚 𝐈𝐧𝐭𝐞𝐠𝐫𝐚𝐭𝐢𝐨𝐧 𝐒𝐭𝐮𝐝𝐢𝐨 • Understanding Data requirements to cater to the correct ETL flows with Stakeholders and the Internal Team • Develop ETL flows and EDA for Rajasthan State Government Health Assurance (RSHAA Scheme from Rajasthan Government) from Oracle Database to MySQL Database which later will be used as a Source Data for ML Models

Mumbai, Maharashtra, India

𝐎𝐃𝐈 (𝐎𝐫𝐚𝐜𝐥𝐞 𝐃𝐚𝐭𝐚 𝐈𝐧𝐭𝐞𝐠𝐫𝐚𝐭𝐨𝐫) • Develop ELT flows to extract and load data from the Source Databases to the Data Warehouse (ODS – Operational Data Store) which can be later transformed/tailored into meaningful information as per the requirements𝐎𝐫𝐚𝐜𝐥𝐞 𝐒𝐐𝐋 • Queried using Oracle SQL for undergoing EDA (Exploratory Data Analysis) • Providing data as per stakeholder's requirements which helps them to analyze particular business trends and improvement approaches as per the data𝐎𝐫𝐚𝐜𝐥𝐞 𝐋𝐢𝐧𝐮𝐱 • Handling Reports Application and IBOT (Automated Email Delivery Agent Application) tasks

Mumbai, Maharashtra, India

𝐏𝐲𝐭𝐡𝐨𝐧 • Conduct Web Scraping to gather Data for coaching, including fields of study and interview questions, using the Python Scraping Package. • EDA on Data report and visualization for insights𝐄𝐱𝐜𝐞𝐥 • Data Pivoting to model Data as per the requirement of the team • Develop Excel visualization for dashboarding