Troikaa Pharmaceuticals Senior Business Manager Interview Questions and Answers

Technical + Analytics
I gave my coding test this august 2024, it was purely based on SQL coding
8 question, 3 easy, 3 intermediate and 3 hard.

Q1. Introduction and explain any one of the projects plus what was the analytics you used
Ans. 
Implemented a project to optimize marketing campaigns using predictive analytics
• Developed a predictive model to identify the most effective marketing channels

• Utilized data from past campaigns to train the model

• Used techniques such as regression analysis and decision trees to analyze the data

• Generated insights on customer behavior and preferences to improve campaign targeting
Answered by AI
Add your answer
Q2. SQL coding, shared screen and was asked to find cumulative sum of cost for a table.
Add your answer

Q1. About yourself and your experience
Add your answer

Q1. Financial data for baking companies and other industries
Ans. 
Financial data for baking companies and other industries
• Financial statements like income statement, balance sheet, and cash flow statement are key for analyzing baking companies and other industries

• Key financial ratios like profitability ratios, liquidity ratios, and solvency ratios can provide insights into the financial health of these companies

• Comparing financial data of baking companies with industry benchmarks can...read more
Answered by AI
Add your answer

Q1. What is your strategy for Business Development in Mass Market Area
Ans. 
My strategy for Business Development in Mass Market Area involves identifying key market segments, creating targeted marketing campaigns, and building strong relationships with key stakeholders.
• Conduct market research to identify key market segments and customer needs

• Develop targeted marketing campaigns to reach mass market audience

• Build strong relationships with key stakeholders such as distributors, retailers, and in...read more
Answered by AI
View 1 more answer

Q1. How would you deal with a Hotel Owner who is not interested to work with us anymore
Ans. 
I would try to understand the reasons for their disinterest and address any concerns they may have.
• Initiate a conversation with the Hotel Owner to understand their reasons for not wanting to work with us anymore

• Address any concerns or issues they may have with our services or partnership

• Offer solutions or alternatives to address their concerns and try to salvage the relationship

• If the Hotel Owner is firm in their decis...read more
Answered by AI
Add your answer

Q1. Salary negotiations
Add your answer

It had more sections to solve like aptitude and SQL

They gave a case study to solve and the entire interview was on the case study presentation and work experience related discussion.

Q1. Past experiences and achievements were asked and was told what the co wants from me
Add your answer
Q2. Which clients you have achieved nd signed
Add your answer

Written test, asked to write queries on paper for given questions

Q1. What are the tools and technologies used in your academic projects?
Ans. 
Various tools and technologies were used in academic projects including Microsoft Excel, Python, SQL, Tableau, and R.
• Microsoft Excel was used for data analysis and visualization.

• Python was utilized for data cleaning, manipulation, and statistical analysis.

• SQL was employed for database querying and management.

• Tableau was used for creating interactive data visualizations.

• R was used for statistical computing and graphics.
Answered by AI
Add your answer
Q2. Could you provide details about the projects you worked on and explain your role in them?
Ans. 
I have worked on various projects including system implementation, process improvement, and data analysis.
• Led a team in implementing a new CRM system to streamline customer interactions

• Identified inefficiencies in inventory management process and proposed solutions for improvement

• Conducted data analysis to identify trends and make recommendations for cost savings

• Collaborated with stakeholders to gather requirements and
Answered by AI
Add your answer

About 7-8 people in the JD. Given generic topis fo rdiscussion