Yogesh Joon Email & Phone Number

India

Gurugram, Haryana, India

- Worked closely with consulting teams & stakeholders to identify requirements, develop solutions, and drive business outcomes; provided strategic insights & acted as a key point of contact for technical support and stakeholder communication- Designed and implemented comprehensive touchless PowerBI dashboards from inception to delivery, focusing on KPIs & required functionalities; worked on optimizing PowerBI dashboards for enhanced performance and user experience- Designed workflows… Show more - Worked closely with consulting teams & stakeholders to identify requirements, develop solutions, and drive business outcomes; provided strategic insights & acted as a key point of contact for technical support and stakeholder communication- Designed and implemented comprehensive touchless PowerBI dashboards from inception to delivery, focusing on KPIs & required functionalities; worked on optimizing PowerBI dashboards for enhanced performance and user experience- Designed workflows and pipelines to efficiently transform data as per stakeholders’ requirements - streamlined data cleaning & manipulation, reducing the manual efforts in reporting process - Created and optimized complex SQL queries and logics, including complex joins and views, to prepare data for visualization purposes- Designed and maintained data loading and transformation pipelines in Azure, enabling scheduled data refreshes to ensure seamless integration and automation of data processes for up-to-date reporting- Authored Python scripts for API data extraction from various financial & business intelligence platforms. Parsed JSON files and loaded clean data into SQL tables, ensuring data integrity and accessibility for processing and analysis- Initiated and developed POCs for integration GenAI, including automation solutions using the GPT-4.0 API, Explored and documented innovative GenAI use cases to enhance business processes and drive digital transformation to derive insights- Managed projects independently and delegated tasks to juniors and fellow teammates and ensured timely delivery of tasks- Worked on EY's internal knowledge sharing products as Data Engineer; Reported the usage of the products through visuals using Power BI, capturing the data through Adobe Analytics for initial level of reporting and then processing data through ADF, Alteryx and SQL Show less

Gurugram, Haryana, India

- Worked in CEO's team in M&A division - Responsible for Secondary research on various cosmetic products and Femtech industry for comparitive analysis; used business intelligence tools such as VCCedge, PrivateCircle and entrakr- Worked on curating an incentives plan for retailers, distributors and wholesalers- Explored various companies of similar domain to explore opportunities of their acquisition

India

- Analysed pitch decks of more than 50 early-stage startups and participated in over 30 pitching sessions of Angel Networks- Responsible for performing tasks of 5 internally incubated and portfolio startups of 4 different domains- Reviewed and broke down a Termsheet into smaller questions and compiled all their probable answers for an AI system- Performed market research on Pitch Deck and Brand Identity services and came up with a suitable pricing set for services- Worked on a… Show more - Analysed pitch decks of more than 50 early-stage startups and participated in over 30 pitching sessions of Angel Networks- Responsible for performing tasks of 5 internally incubated and portfolio startups of 4 different domains- Reviewed and broke down a Termsheet into smaller questions and compiled all their probable answers for an AI system- Performed market research on Pitch Deck and Brand Identity services and came up with a suitable pricing set for services- Worked on a financial model based on a cost sheet for a desert farming startup which got funding of $20 Million at its ideation stage Show less