Ravi Patel Email & Phone Number

Mumbai, Maharashtra, India

• Designed and developed a comprehensive OLTP data warehouse and ETL pipeline using Alteryx and PostgreSQL, processing over 1 million transactions. Reduced data processing time by 25%, significantly enhancing reporting efficiency and enabling real-time insights for faster decision-making• Automated data flow from Alteryx to AWS S3, implementing 10+ data transformations using PySpark and SparkSQL in AWS Glue, increasing data processing speed by 30% and enabling faster insights for more efficient decision-making• Conducted sales analysis to identify top-selling items across categories, accounting for 24% of total revenue, resulting in a 15% increase in sales through optimized product replenishment strategies• Developed and implemented Tableau dashboards to track and optimize delivery performance, reducing lead times from 10 days to 7 days, improving delivery efficiency by 30%, and reducing operational costs by 15%, enhancing overall logistics and operational workflows• Executed team-based ideation to integrate real-time data and implement quality checks, improving data accuracy by 18% and enhancing the speed and reliability of business intelligence reports, leading to more precise and timely decision-making

Mumbai, Maharashtra, India

• Spearheaded the development of an interactive Power BI dashboard that provided detailed insights into a 14% growth in stock prices, enabling data-driven decision-making for the investment team and supporting more strategic, real-time analysis of market trends• Automated data extraction using the Web connector, achieving 98% data accuracy and reducing retrieval time by 42%, significantly enhancing operational efficiency and enabling real-time data analysis for more timely and accurate decision-making• Utilized DAX to create advanced calculations and time intelligence features in Power BI reports, enhancing data exploration and trend analysis capabilities, which informed strategic investment decisions and improved overall data-driven decision-making• Created custom metrics and KPIs to monitor stock performance, enabling precise tracking and reporting of the investment portfolio, which resulted in a 25% increase in user satisfaction through enhanced data visibility and actionable insights• Performed in-depth analysis of weekly and monthly stock prices using SQL, leading to a 12% improvement in the stock portfolio by identifying and capitalizing on key market trends, driving more effective investment strategies

Mumbai, Maharashtra, India

• Elevated user engagement by 20% through the creation of dynamic Tableau visualizations that effectively displayed state-based complaints, enabling the team to derive actionable insights and improve user interaction strategies• Strengthened data integrity by executing comprehensive SQL queries for data cleaning, validation, and manipulation, leading to a 15% reduction in data errors and significantly enhancing the accuracy of business reporting• Formulated KPIs that resulted in a 30% reduction in average response time for complaint management, improving performance tracking, boosting operational productivity, and increasing overall customer satisfaction• Facilitated cross-functional collaboration to streamline complaint management processes, leading to a reduction in response times and improving overall team efficiency and customer satisfaction• Leveraged Excel functions, including PivotTables and Macros, to automate data analysis workflows, streamline performance tracking, and reduce manual reporting time by 30%, ensuring timely and accurate delivery of insights

Mumbai, Maharashtra, India

• Applied Python and R for exploratory data analysis and visualization on a Restaurant Inspection project, analyzing over 10,000 inspection records to identify key trends and improve data-driven decision-making• Preprocessed a Kaggle restaurant inspection dataset by removing outliers and manipulating data, improving data quality by 20% and preparing it for more accurate analysis and visualization• Discovered that 77% of restaurants violated safety norms, with the majority falling into moderate to high-risk categories, providing key insights for targeted safety improvements• Identified business challenges and growth opportunities, and crafted data-driven reports that supported decision-making, leading to a 15% improvement in operational efficiency and a 10% increase in revenue through data-backed strategies.

Master Of Science - Ms, Data Analytics Engineering, 3.43/4

Related Coursework: IE5374 Foundations of Data Analytics IE6600 Computation Visualization and Analytics IE7275 Data Mining in Engineering.

Bachelor Of Technology - Btech, Computer Engineering, 3.07/4

Related Coursework: Data Science and Big Data Analytics Data Warehousing and Mining Database Management System Data Warehousing.