Manthan Gharat

Experience

• 

  Urban Expansion Observatory (UXO) Initiated by NYU-STERN School of Business

  Jun 2019 - Jul 2019

  Web Scraper

  • Automated data extraction and cleaning: Built scripts to gather information from websites, eliminate errors, and organize it for analysis.• Handled website structure changes: Adapted to website updates to ensure data collection continued smoothly.• Created geographic data visualizations: Transformed data into maps to reveal insights that aided client decisions.

• 

  Valectus

  May 2020 - Aug 2020

  Data Specialist

  • Automated COVID-19 Data Analysis: Used Python scripts to collect and analyze COVID-19 data,identifying trends in growth rates across different regions.• Interactive COVID-19 Dashboard: Created a dynamic Tableau dashboard to visualize the collected data. This dashboard aimed to translate complex COVID-19 trends into an easily understandable format for the public.• Predictive Insights from Data: Analyzed the data to assess the severity of the virus in different areas, tracking both infected and recovered populations to inform future predictions. Show less

• 

  Cyris

  Jul 2020 - Aug 2021

  Co-Founder

  Led the development of a highly accurate virtual reality eye test, working closely with experts in programming, design, and ophthalmology.Formed a partnership with a well-respected non-governmental organization to provide virtual reality eye exams to over 200,000 people in areas with limited access to healthcare.Worked together with the other co-founder to determine the company's future goals and strategies.Took part in competitions aimed at raising money to support the company's expansion. Show less

• 

  Pillai College of Engineering

  Feb 2021 - Feb 2021

  Python Instructor

  This intensive 1 day workshop equipped participants with the fundamentals of Python programming and its powerful automation capabilities:Python Fundamentals: Mastered the core syntax, data structures, control flow, and functions, laying the groundwork for automation.Practical Programming: Gained hands-on experience by writing Python scripts, solving problems, and solidifying their understanding. Automation Powerhouse: Explored libraries and techniques for automating various tasks, increasing efficiency and productivity.Real-World Applications: Learned how to automate repetitive processes, manipulate data, and streamline workflows using Python.This workshop attracted over 100 students, creating a vibrant learning environment for those eager to unlock the power of Python for automation Show less

• 

  Capgemini

  Aug 2021 - Aug 2024

  • Production System Optimization: Enhanced and maintained production systems with expertise in Python, SnowSQL, and Oracle.• Streamlined Data Flow: Built ETL pipelines to efficiently load complex data warehouses for batch processing.• Agile Workflow Champion: Implemented Jira's Agile methodologies and leveraged ServiceNow for smooth development and change management.• Ensured Quality Releases: Managed QA and production migration for flawless deployment of enhancements and bug fixes.• Bridged Business & Tech: Collaborated with the onsite team to translate business needs into actionable technical solutions.• Data Issue Analyst: Performed hands-on data analysis and troubleshooting to fix issues and meet critical deadlines.• Technical Solutions Architect: Analyzed data and analytics needs across enterprise applications and designed effective technical solutions.• Minimized Downtime: Resolved critical incidents to maintain business continuity and prevent revenue loss.• Cross-Functional Collaboration Expert: Worked effectively with diverse teams and vendors to ensure seamless deliveries and operations Show less Led the strategic migration of Informatica workloads to AWS cloud, leveraging deep expertise in Python and cloud technologies.Coordinated in developing robust ETL pipelines using Python to replace Informatica workflows,improving scalability, flexibility, and cost-efficiency.Managed and motivated a cross-functional team to ensure a smooth and efficient migration process,coordinating efforts with various stakeholders.Created comprehensive documentation,including migration plans, technical guides, and best practices, to facilitate knowledge transfer and future reference.Continuously analyzed and optimized the migrated systems to enhance performance,reliability, and data quality, while ensuring compliance with industry standards. Show less Designed and Maintained aintained complex ETL pipelines using Informatica PowerCenter.Implemented data cleansing, validation, and transformation logic to ensure data quality and consistency.Production System Optimization: Enhanced and maintained production systems with expertise in Linux Shell scripting, Oracle and Python.Tuned ETL pipelines for optimal performance and efficiency, reducing processing time and resource consumption.Established robust data monitoring mechanisms to identify and address data quality issues proactively.Leveraged Informatica Analytics tools to analyze data and generate insightful reports.Utilized SQL to extract, transform, and analyze data stored in Teradata databases.Demonstrated strong problem-solving abilities to troubleshoot data-related issues and find effective solutions. Show less

  • Associate Consultant

    Oct 2023 - Aug 2024

  • Senior Analyst

    Apr 2023 - Oct 2023

  • Analyst

    Aug 2021 - Apr 2023
• 

  The University of Sheffield

  Sept 2024 - now

  Academic Support Assistant