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• Collaborated with clients and delivery teams to understand business requirements and align data processing with strategies

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.

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