Shyam Advisory Interview Questions and Answers

Q1. Introduce yourself
Add your answer
Q2. What has been your experience with framework design and implementation?
Add your answer
Q3. What is the tech and languages you are comfortable with? Rate yourself on each.
Add your answer
Q4. What is your experience with finance?
Add your answer
Q5. What is TDD and BDD? What are the differences and which one do you prefer?
Add your answer

Q1. Write a program to find the frequency of word in a sentence
Add your answer
Q2. Write a program to check if the sum of digits of.the given number is a prime number
Add your answer
Q3. Write an SQL query to get the second highest salary in the table
Add your answer
Q4. What is the difference between abstract class and interface? Give a use case for both.
Add your answer
Q5. Explain static and give it's use case.
Add your answer
Q6. Where are objects stored in memory?
Add your answer

Q1. Interview was taken in malad on interface 7 building The relationship officer Vaibhav Panchal . He assigned Interviewer the way he was talking he was not able to speak in english half of the question i was...read more
Add your answer
Q2. His english was poor How you will get the customer count who speak in english? he didn't gave me which table to fetch from ? * question changed get the customer from one table and count from the other ...read more
Add your answer

Q1. Explain your last project and your role in this project
Ans. 
Led a team in implementing a new CRM system for a large retail company
• Managed project timeline and deliverables

• Collaborated with stakeholders to gather requirements

• Provided training and support to end users

• Ensured successful implementation and user adoption

• Improved customer data management and analytics
Answered by AI
Add your answer
Q2. Overall working experience with other companies
Ans. 
I have over 10 years of experience working with various companies in consulting roles.
• Managed client relationships and delivered successful projects on time and within budget

• Led cross-functional teams to drive business growth and improve operational efficiency

• Developed and implemented strategic plans to address client needs and achieve objectives
Answered by AI
Add your answer
Q3. Why choose kafka over MQ ? what challenges you faced during kafka implementation ?
Ans. 
Kafka is chosen for its scalability and fault tolerance compared to MQ.
• Kafka offers higher throughput and lower latency compared to MQ.

• Kafka is horizontally scalable, allowing for easy expansion as data volume grows.

• Kafka provides fault tolerance through replication of data across multiple brokers.

• Challenges faced during Kafka implementation may include setting up proper configurations, ensuring data consistency, and m...read more
Answered by AI
Add your answer
Q4. Monolith to microservice migration journey ? what all decisions needs to be taken and how the entire migration took place.
Ans. 
Monolith to microservice migration involves breaking down a large application into smaller, independent services.
• Evaluate the current monolith architecture and identify the components that can be decoupled into microservices.

• Define the boundaries of each microservice to ensure they are cohesive and loosely coupled.

• Choose the right technology stack for each microservice based on its requirements and scalability needs.

• Im...read more
Answered by AI
Add your answer
Q5. If worked for RestAPI ? what is the use of swagger ? what is the content of Swagger documentation ?
Ans. 
Swagger is a tool used for documenting and testing REST APIs.
• Swagger is used for documenting REST APIs by providing a user-friendly interface to view and interact with API endpoints.

• It allows developers to easily understand the functionality of an API, including available endpoints, request/response formats, and authentication methods.

• Swagger documentation typically includes information such as API endpoints, request p...read more
Answered by AI
Add your answer
Q6. Only this was asked to me , and rejected
Add your answer

Q1. What is Home loan
Ans. 
A home loan is a sum of money borrowed from a financial institution to purchase a home or real estate property.
• Home loans are typically repaid over a set period of time with interest.

• The property being purchased is used as collateral for the loan.

• Home loans can have fixed or variable interest rates.

• Borrowers need to meet certain criteria such as credit score, income, and debt-to-income ratio to qualify for a home loan.
Answered by AI
Add your answer
Q2. Previous company working
Ans. 
I worked at XYZ Corp as a Relationship Manager for 3 years.
• Managed client relationships and provided financial advice

• Developed and implemented strategies to increase client retention

• Collaborated with internal teams to meet client needs

• Organized events and seminars to educate clients on financial products
Answered by AI
Add your answer

Q1. How many year of working experience
Ans. 
I have 5 years of working experience in relationship management.
• I have worked in relationship management for 5 years.

• Experience includes managing client portfolios and providing financial advice.

• Successfully built and maintained relationships with high net worth clients.

• Implemented strategies to increase client retention and satisfaction.

• Attended training sessions and workshops to enhance skills in relationship managem
Answered by AI
Add your answer
Q2. What is Foier
Ans. 
Foier is a term used in finance to refer to a document that provides information about a company's financial status and performance.
• Foier is short for 'Financial Offerings Information and Exchange Report'.

• It includes details such as financial statements, key performance indicators, and market analysis.

• Investors use foiers to make informed decisions about investing in a company.

• Foiers are often required by regulatory bo...read more
Answered by AI
Add your answer

Q1. What is defrent between LTV
Ans. 
LTV stands for Loan to Value ratio, which is a financial term used in lending to assess the risk of a loan compared to the value of the asset being financed.
• LTV is used in the context of loans and mortgages to determine the percentage of the loan amount compared to the appraised value of the asset.

• It helps lenders assess the risk of the loan and determine the amount they are willing to lend based on the value of the co...read more
Answered by AI
Add your answer
Q2. What about know the wonder Home finance
Add your answer

Q1. Were r u staying in bangalore
Ans. 
I am staying in Koramangala, a vibrant neighborhood in Bangalore known for its cafes, restaurants, and shopping options.
• Koramangala is a popular residential area in Bangalore

• Known for its lively atmosphere and variety of dining options

• Close to many IT companies and startup offices

• Has good connectivity to other parts of the city
Answered by AI
Add your answer

Q1. How to sourcing the Coustemer
Ans. 
Customer sourcing involves identifying potential customers and reaching out to them through various channels.
• Utilize social media platforms to connect with potential customers

• Attend networking events and industry conferences to meet new prospects

• Utilize email marketing campaigns to reach out to leads

• Collaborate with marketing teams to generate leads through advertising and promotions
Answered by AI
Add your answer

Q1. Chola finance r u working why r u change the job
Ans. 
I am looking for new challenges and growth opportunities in my career.
• Seeking new challenges and growth opportunities

• Interested in expanding skill set

• Exploring better career prospects
Answered by AI
Add your answer

Q1. What was the technical documents
Add your answer

Q1. What is the approved plan
Ans. 
The approved plan is the official strategy or course of action that has been authorized for implementation.
• The approved plan is typically developed based on goals and objectives set by the organization.

• It may include specific tasks, timelines, and resources needed to achieve the desired outcomes.

• Regular monitoring and evaluation of the approved plan are essential to ensure its effectiveness.

• Examples: A marketing plan a...read more
Answered by AI
Add your answer

Q1. How many business u can do the wonder Home finance
Ans. 
The number of business opportunities with Wonder Home Finance is limitless, depending on market demand and your networking skills.
• The number of business opportunities with Wonder Home Finance can vary based on market conditions and customer needs.

• You can explore various avenues such as mortgage lending, real estate partnerships, financial advisory services, etc.

• Building strong relationships with clients and industry pr...read more
Answered by AI
Add your answer

Q1. What was technical to approved land
Ans. 
Technical approval of land refers to the process of evaluating the land for compliance with technical requirements before it can be approved for development.
• Technical approval involves assessing factors such as soil quality, topography, drainage, and infrastructure availability.

• Engineers and surveyors may be involved in conducting assessments and providing recommendations.

• The goal is to ensure that the land is suitable...read more
Answered by AI
Add your answer

Q1. What are derivatives in finance?
Ans. 
Derivatives in finance are financial instruments whose value is derived from the value of an underlying asset.
• Derivatives can be used for hedging against risk, speculating on price movements, or gaining exposure to assets without owning them.

• Common types of derivatives include options, futures, forwards, and swaps.

• Options give the holder the right, but not the obligation, to buy or sell an asset at a specified price be...read more
Answered by AI
Add your answer
Q2. What are the different types of derivatives?
Ans. 
Derivatives are financial instruments whose value is derived from an underlying asset or group of assets.
• Types of derivatives include options, futures, forwards, and swaps.

• Options give the holder the right, but not the obligation, to buy or sell an asset at a specified price before or on a specified date.

• Futures are contracts to buy or sell an asset at a future date for a price agreed upon today.

• Forwards are similar to...read more
Answered by AI
Add your answer

Q1. What are the details of the stock market and its various products?
Ans. 
The stock market is a platform where investors can buy and sell shares of publicly traded companies.
• Stocks represent ownership in a company and can be bought and sold on stock exchanges like NYSE and NASDAQ.

• Bonds are debt securities issued by companies or governments to raise capital.

• Mutual funds pool money from multiple investors to invest in a diversified portfolio of stocks, bonds, or other securities.

• Options give i...read more
Answered by AI
Add your answer
Q2. Balance sheet,profit &loss account
Add your answer
Q3. Journal entries
Add your answer
Q4. Option in detail, economic crisis,
Add your answer

Here’s a simple framework to approach a case study effectively:


---

Case Study Framework

1. Understand the Problem

Read the case thoroughly and identify the key issue.

Ask clarifying questions if needed (if in a live setting).

Summarize the problem in your own words.



2. Analyze the Situation

SWOT Analysis (Strengths, Weaknesses, Opportunities, Threats)

Identify relevant stakeholders.

Gather data or key insights from the case text.



3. Identify Alternatives

Brainstorm possible solutions to the problem.

Consider multiple approaches (e.g., short-term vs. long-term solutions).



4. Evaluate the Alternatives

Weigh the pros and cons of each solution.

Assess feasibility, costs,

Q1. What are the common performance issues that can occur in a system?
Ans. 
Common performance issues in a system include slow response times, high resource usage, bottlenecks, and crashes.
• Slow response times can be caused by inefficient code, network latency, or overloaded servers.

• High resource usage can lead to system slowdowns and crashes, often caused by memory leaks or inefficient algorithms.

• Bottlenecks occur when a component of the system becomes a limiting factor, such as a database ser...read more
Answered by AI
Add your answer
Q2. What is your experience with software bug fixing?
Ans. 
I have experience in identifying and resolving software bugs through thorough testing and collaboration with developers.
• Identifying bugs by reproducing issues reported by users

• Collaborating with developers to understand root cause of bugs

• Testing bug fixes to ensure they are effective

• Utilizing bug tracking tools like Jira or Bugzilla

• Experience with regression testing to prevent reoccurrence of bugs
Answered by AI
Add your answer

Shortcut Tips for Coding Tests: 1. Master the Basics: Familiarize yourself with arrays, strings, loops, and conditional statements. 2. Learn Patterns: Concentrate on sliding window, two-pointer techniques, recursion, and divide-and-conquer methods. 3. Use Standard Algorithms: Study breadth-first search (BFS), depth-first search (DFS), sorting algorithms, and dynamic programming principles. 4. Understand Data Structures: Practice with stacks, queues, linked lists, and trees. 5. Practice Edge Cases: Consider scenarios involving empty inputs, duplicates, and large datasets. 6. Write Pseudocode: Outline your plan before starting to code. 7. Optimize Early: Always strive for efficiency in your solutions.