Devansh Patel Email & Phone Number

Successfully organized and executed a comprehensive migration project involving the transition of data processes from archaic sources to Python within Airflow, integrating Snowflake as the data warehouse.Orchestrated complex data workflows focusing on efficiency and scalability.Developed elaborate codebases for data analysis and automation tasks, integrating with APIs and online data sources.Produced dynamic reports and dashboards using Python libraries, facilitating real-time data analysis and decision-making.Collaborated closely with cross-functional teams to align data engineering tasks with business objectives.Provided technical guidance and mentoring to team members, enhancing overall team productivity and knowledge.

Chicago, Illinois, United States

Chicago, Illinois, United States

• Led implementation of streamlined ETL processes and robust Data Warehousing infrastructure achieved a 25% reduction in data reconciliation efforts• Orchestrated seamless integration of business metrics supported by robust warehouse architecture and complex data transformations for successful mergers and acquisitions• Reduced data processing time by 45% by implementing Change Data Capture mechanisms and Slowly Changing Dimensions to a dimensional fact model• Achieved about a 60% reduction on pipeline data flow times through a hierarchical redesign• Spearheaded initiative to reduce tech debt, supplementing future releases & real time triaging• Top Skills – Azure - Data Factory, Databricks, Snowflake, SQL, Python, DBT, Power BI

Ahmedabad

• Developed a highly scalable, modular, full-stack application using Java, Spring suite, Hibernate and Maven from the ground up • Monitored Airflow DAGs and leveraged back-filling to make sure streamlined processing of jobs• Collaborated with the C level suite and key business players to model a Data Warehouse in Snowflake from scratch facilitating data ingestion from 20+ sources and further analytics• Overhauled CI/CD pipelines in Data Factory to achieve 2x better performance and ~20% cost reduction• Analyzed key aspects of business to evaluate factors driving results and developed key point indicators helping improve customer churn by ~8%• Top Skills – Azure, AWS, DynamoDB, Snowflake, Python, Java, SQL, Spring suite, Git, Docker, Power BI

Ahmedabad Area, India

• Collaborated cross-functionally to develop comprehensive system requirement specifications for an internal project over 5 departments.• Designed and developed an internal website consisting of millions of dollars of business and over 100 drugs, using HTML, CSS, JavaScript, jQuery, Spring Suite, MongoDB, Gradle, and Groovy.• Utilized Oracle's Primavera P6 API to extract valuable insights and trends projecting plans spanning over decades. • Orchestrated efficient large-scale software deployments, including rigorous testing and code corrections.

Master Of Business Administration - Mba

Master Of Science - Ms, Computer Science

Coursework Algorithms, NP – Hard/Complete problems; Object Oriented Language Analysis and Design; Distributed Networks; Data Science.

Bachelor'S Degree, Computer Science And Engineering, 8.49

Bachelor'S Degree, Computer Science

Activities and Societies: Engineer at the Tech Society Literary at the LitSoc Delegate at the MUNSoc

Education record