Jaya Bisht

• P>Conducted a Monte Carlo simulation to evaluate the net present value (NPV) of a new drug development project for Moore Pharmaceuticals, considering uncertainties in market size, R&D costs, clinical trial costs, and market growth factors. Key Responsibilities and Achievements:
• Utilized probabilistic distributions (normal, uniform, triangular) to model uncertain parameters.
• Conducted 500 iterations of the simulation to generate a distribution of NPV values.
• Created a histogram to visualize the distribution of NPV.
• Calculated the probability of NPV being below $400,000,000. Tools and Techniques Used:
• Monte Carlo simulation
• Probabilistic distributions
• Data analysis and visualization techniques Outcome:
• Generated insights into the potential financial performance of the new drug development project under various scenarios.
• Provided valuable input for decision-making regarding the allocation of resources and investment in the project.

• FP & A analyst certification (Wall Street Prep)
• Data Analyst with Python (Data Camp)
• Intermediate SQL Certification (Data Camp)
• Others- Pursuing "Google Professional Analytics Certificate" (Coursea)

Panera Breakfast Optimization Project in Excel, Utilized optimization skills to determine the least expensive and most nutritionally balanced breakfast order at Panera, considering dietary preferences and constraints., Data analysis, optimization, decision-making, and problem-solving. Analysis on COVID Casualties Project, Analyzed the number of deaths in the USA against the other variables such as the number of cases, people hospitalized, and people vaccinated during the entire period of Covid-19. Through our analysis, we have concluded that the number of deaths has a positive correlation with the number of people hospitalized for the covid-19 and a negative correlation with the number of people vaccinated against covid-19. Through our analysis, we also concluded that each state was differently impacted from the covid-19 though being in the same geographical region., SAS (Logistic Regression/Descriptive Analysis and Data visualization) Power BI project, Analyzed the Supermarket Sales Data downloaded from Kaggle and built dashboard to present the sales per month, quantity sold by city, COGS in Product line, Gross Income of Product line by month. Simulation Analysis: New Drug Development Decision, Conducted a Monte Carlo simulation to evaluate the net present value (NPV) of a new drug development project for Moore Pharmaceuticals, considering uncertainties in market size, R&D costs, clinical trial costs, and market growth factors., Utilized probabilistic distributions (normal, uniform, triangular) to model uncertain parameters., Conducted 500 iterations of the simulation to generate a distribution of NPV values., Created a histogram to visualize the distribution of NPV., Calculated the probability of NPV being below $400,000,000., Monte Carlo simulation, Probabilistic distributions, Data analysis and visualization techniques, Generated insights into the potential financial performance of the new drug development project under various scenarios., Provided valuable input for decision-making regarding the allocation of resources and investment in the project. Database Management and Analysis Project, Conducted database management and analysis to provide summary insights into parking tickets issued at selected addresses in the DC area., Created three tables (tblTickets, tblSelectAddresses, and tblViolationCodes) in Microsoft Access to organize and manage parking ticket data, address information, and violation code descriptions and fines., Established table relationships to link address IDs, ticket IDs, and violation codes for comprehensive analysis., Generated a table relationship report to document the database structure and relationships., Utilized Access queries to join tables, summarize datasets, and extract relevant information., Developed queries to identify tickets issued for selected addresses, determine unmatched records, and calculate fines for violation codes., Analyzed query results to provide insights on ticket issuance and fine distribution., Produced actionable insights to enhance parking violation management and enforcement strategies., Contributed to informed decision-making by providing comprehensive analysis of parking ticket data.