Deep Gosar

Experience

• 

  Protiviti India Member Firm

  Jan 2022 - Apr 2022

  Data Analyst Intern

  • Transformed and analysed product market data for a major FMCG client using SAS, and reported undervalued regions for market expansion. Effectively communicated the results with clients and stakeholders, resulting in a 10% increased market size• Developed Python Selenium based web scraping solution for a leading logistics company, automating real-time data extraction from supplier websites, resulting in a 40% reduction in procurement time and enhancing supply chain efficiency

• 

  TresVista

  Jul 2022 - Jun 2023

  Data Analyst

  • Developed and implemented data transformation using Excel VBA for the corporate finance team, resulting in the $90000 cost saving for diverse accounting models• Collaborated with stakeholders to build Python based ETL pipelines and designed Tableau dashboards for survey data of 5000 employees. Automated workflow for 100 PPT reports using UiPath and VBA increasing efficiency by 120%• Pioneered the development of Python Spark based data models for Private Equity client’s portfolio analysis and Tableau visualisation. Delivered 80% faster data processing, empowering comprehensive insights into diverse investment instruments within portfolio• Spearheaded the transformation of a shareholding pattern for a publicly listed client using R and Tableau. The interactive visualization unveiled the ownership and debt structure, and investor returns• Created a data pipeline on the AWS to enhance data transformation. Used Athena for reporting financial metrics and KPIs to Tableau to create stakeholder visualisations Show less

• 

  Texas A&M University

  Nov 2023 - May 2024

  Graduate Assistant

  • Created Tableau dashboards showcasing YoY analysis of student trends and statistics related to admissions and program selection using Python, and Excel• Managed prospective student information from the initial contact point through the application, admission, and enrolment process on CRM. Created SQL processes on the database to manage day-to-day operations and communication

• 

  Applied Materials

  May 2024 - Aug 2024

  Data Analytics Engineer

  • Automated $50M+ backlog inventory reporting with VBA/Python, enhancing revenue recognition and aging analysis; proposed Tableau dashboard for real-time inventory analytics • Established row-level Tableau dashboard security, enabling confidential financial access; built capacity management tool for data driven resource forecasting • Created manufacturing-revenue reports for the global supply chain of tools, showcasing components, costing, and revenue generated, using SQL, reducing report generation time by 85% (2 hours) Show less