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.
• 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.
• 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%.
• 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.

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.
• 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.
• 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.
• 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.
• 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.

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.
• 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.

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.

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 and.