Prem Patel Email & Phone Number

Ahmedabad, Gujarat, India

• Developed 50+ ETL pipelines for McDonald's, integrating operational data from multiple external databases and APIs
• Enhanced data processing efficiency of the Sales module by converting Talend code to Python, reducing runtime by 308%
• Optimized jobs performance by streamlining SELECT, using MERGE SQL, and simplifying joins, reducing processing overhead
• Automated financial data ingestion using Python scripts, securely loading it into the warehouse and restricting user access
• Minimized unnecessary intermediaries through revamping the workflows and consolidating flat files into a systematized API
• Analyzed production failures to implement corrective measures, significantly lowering downtime & boosting productivity

Ahmedabad, Gujarat, India

Thane, Maharashtra, India

• Created Tableau dashboards to track and analyze KPIs of hospital departments' datasets to identify trends and patterns
• Streamlined BI report generation using Python, saving at least 10 operational hours weekly and improving decision-making
• Performed data profiling for collecting descriptive statistics, detecting data anomalies, and identifying dependencies
• Optimized SQL stored procedures through code re writes, cutting execution time by 33% and increasing efficiency

• Preprocessed Life Expectancy dataset and used pre-built machine learning algorithms to predict life expectancy of people living in a country based on various factors, and deployed it using IBM Cloud services

Master'S Degree, Information Systems

Key Courses: • Data Processing and Analysis in Python • Database Management Systems • Project Management • Digital Transformation in.

Bachelor Of Engineering - Be, Information Technology, Gpa : 3.8/4.0

Key Courses: • Software Engineering • Cloud Computing & Services • Data Structures & Algorithms • Python Programming • Advance Internet.

Associate Of Science - As