Pranav Mehta Email & Phone Number

Vancouver, Bc, Ca

Gurugram, Haryana, India

During my relatively short stint at Viscadia, I was responsible for the following key tasks:- Led a Market Research project for a US-based Pharma Giant, overseeing survey creation, and deployment in US and EU regions, and conducting in-depth data analysis, which resulted in topline numbers that were 15% higher than the forecasted figures.- Created and delivered multiple quantitative workbooks using Excel, tracking KPIs and other performance metrics, and implemented data-driven strategies, enhancing these KPIs by an average of 12%.- Designed and developed dashboards using PowerPoint and other in-house tools, empowering the client's marketing team to make crucial decisions.

Gurugram, Haryana, India

During my time at ZS, I focused on devising tech solutions for our pharmaceutical sector clients' business challenges. Some notable tasks included:- Led the development and execution of comprehensive end-to-end test cases for System Integration Testing (SIT) and User Acceptance Testing (UAT) using client-specific data, ensuring seamless go-live readiness and product implementation.- Engineered and deployed advanced sales forecasting and optimization dashboards, achieving a notable 15% month-over-month (MoM) sales increase across diverse geographical markets and empowering informed decision-making.- Implemented optimized throttling solutions to enhance AWS infrastructure efficiency, reducing client costs by 10% through enhanced utilization of AWS environments for equivalent workloads.- Architected and deployed robust data models for a Fortune 500 Pharma client, enabling intuitive analytics and strategic insights across business operations.- Automated raw data quality control checks via custom queries, minimizing manual intervention and slashing client product update times by 40%.- Developed comprehensive project runbooks for internal and client use, streamlining complex workflows and accelerating the onboarding process for new team members.

South Goa, Goa, India

Pursued a Reduced Thesis under Dr Subhasish Roy.Topic: Amino Acid and Peptide Conjugated Perylene Bisimide-based Supramolecular MaterialsAs a part of my thesis, I validated the stability of amino acid-based perylene bisimide derivative (PBI-Phg) hydrogels in various phosphate buffers at a pH of 7.46. The hydrogels displayed unique semiconducting characteristics and were characterized using FTIR, UV-Vis, Fluorescence Spectroscopy, and X-ray diffraction analysis. My research contributed to a deeper understanding of the potential applications of PBI-Phg hydrogels in material science.

Bengaluru, Karnataka, India

- Developed impactful data visualization dashboards using Power BI and Google Data Studio to elucidate the effects of CSR initiatives for clients.- Managed end-to-end data operations encompassing collection, analysis, and presentation across sectors such as Education, Rural Development, Financial Literacy, and Healthcare.- Engineered interactive data widgets based on ESG frameworks to enrich visualization and deliver actionable insights.- Implemented no-code automation tools like Zapier to optimize workflows and boost operational efficiency.- Secured a full-time extension post-tenure, underscoring contributions and dedication.

Bengaluru, Karnataka, India

$ 12.1M series-B startup specialising in social impact measurement, volunteering and CSR lifecycle management.- Contributed to the volunteer product team, conducting extensive product research, market research, and competitor analysis within the global CSR and sustainability platforms.- Achieved a 15% reduction in L0 support tickets by strategically recommending and implementing help articles and FAQs on pertinent pages.- Designed and executed post-event surveys distributed among participants, providing valuable insights into the impact and significance of volunteering activities.

North Goa, Goa, India

- Provided crucial support to the Accounts department, demonstrating proficiency in executing daily tasks encompassing accounting and Database Management System (DBMS) processes.- Fostered effective collaboration with the Sales and Purchase departments, contributing to a harmonious work environment.- Gained practical insights into the Companies Act 1956 while honing my accounting skills through hands-on experience in this role.

Manesar, Haryana, India

During my PS 1 internship at HMSI Manesar's Press and Weld Department, I gained invaluable hands-on experience in the production of fenders and fuel tanks. Key takeaways from this experience include:- Developed an in-depth understanding of the Press Machine and its multifaceted functions.- Gained exposure to various welding techniques, including Arc Welding and Gas Welding.- Acquired insights into organizational operations and the intricacies of metal selection processes.- Familiarized myself with quality inspection techniques crucial for maintaining product excellence.As part of my responsibilities, I was entrusted with the task of optimizing manufacturing processes. Leveraging my AutoCAD skills, I designed layouts that significantly reduced production time and lowered costs. Additionally, my knowledge of Chemistry allowed me to suggest alternative metal alloys, which were well-received by the team.This internship provided me with a comprehensive understanding of the manufacturing industry and its dynamic intricacies.

South Goa, Goa, India

As a member of the SAE BITS Goa team, I played a vital role in the Suspension Portfolio. Our team's objective was to build an open cockpit, single-seat F1-style car from the ground up. I contributed to designing, analysing, and optimising the Suspension system, working alongside my team to ensure a successful outcome.

North Goa, Goa, India

- During my internship, I gained valuable insights into the paramount importance of ISO certification for organizations.- I actively contributed to conducting 5S Audits at various companies, acquiring hands-on experience and insights into workplace efficiency.- Furthermore, my internship exposed me to the firm's emphasis on Corporate Training, reinforcing my appreciation for the pivotal role of soft skills in fostering career success and personal growth.

South Goa, Goa, India

I embarked on my professional journey with an internship at a leading manufacturing organization, immersing myself in its day-to-day operations.- Gained a holistic view of organizational dynamics, spanning from administrative tasks to intricate production processes.- Enhanced my proficiency in tools such as Microsoft Excel and AutoCAD.- Developed a foundational understanding of the complexities inherent in Optical Fiber manufacturing.

Master'S Degree, Business Analytics

Minor, Finance

Electives: 1. Business Analysis and Valuation 2. Fundamentals of Finance and Accounting 3. Security Analysis and Portfolio Management 4..

Dual Degree Program (B.E.(Hons) + M.Sc), Mechanical Engineering And Chemistry

Activities and Societies: Crew Member of SAE BITS Goa (SUPRA) Team Grade: First Division

Class Xii - Goa State Board, 85%

Activities and Societies: Member of Quizzing Team (2015-16)

Class X - Icse, 94%

Activities and Societies: Sports Prefect (2013-14) | Member of Cricket, Softball and Athletics Team | Quizzing