Miamin Systems Inc Interview Questions and Answers

Q1. SQL,bo tools preparation, cloud
Add your answer
Q2. Joins functionindexing
Add your answer
Q3. Windowsfunction store procedure
Ans. 
A Windows function store procedure is a stored procedure that can be executed in response to a Windows event.
• Windows function store procedures are used in SQL Server to execute code in response to Windows events.

• They can be used to automate tasks or trigger actions based on specific conditions.

• Examples include executing a stored procedure when a file is created or deleted, or when a specific event occurs in the Windows
Answered by AI
Add your answer

Q1. Bi cloud sql AWS dashboard
Add your answer

Q1. Python questions, write a SQL query to return employee with the number of leaves in each month, Vlookup, Index Match, Rank, Dense Rank
Add your answer
Q2. Loc and iloc in python
Ans. 
loc and iloc are methods in pandas used for selecting rows and columns by label or integer position.
• loc is used for selecting rows and columns by label

• iloc is used for selecting rows and columns by integer position

• Example: df.loc[0:5, 'column_name']

• Example: df.iloc[0:5, 2]
Answered by AI
Add your answer
Q3. Advantage of Vlookup over-index match
Ans. 
Vlookup is simpler and easier to use, while Index Match is more flexible and efficient.
• Vlookup is easier for beginners to understand and use

• Vlookup is quicker to set up and requires less formula writing

• Index Match is more flexible as it can look up values in any column, not just the first one

• Index Match is more efficient for large datasets as it does not require the entire column to be searched
Answered by AI
Add your answer
Q4. Difference between BRD and FRD
Ans. 
BRD focuses on business requirements while FRD focuses on functional requirements.
• BRD (Business Requirements Document) outlines the business problem that needs to be solved.

• FRD (Functional Requirements Document) details how the system will meet the business requirements.

• BRD is more high-level and focuses on the 'what', while FRD is more detailed and focuses on the 'how'.

• BRD is typically created before FRD in the projec...read more
Answered by AI
Add your answer
Q5. Retail experience and analysis
Ans. 
Retail experience and analysis
• I have over 5 years of experience in retail industry analysis

• Proficient in using data analytics tools to track sales trends and customer behavior

• Implemented strategies based on market research to increase sales and customer satisfaction

• Collaborated with cross-functional teams to optimize inventory management and pricing strategies
Answered by AI
Add your answer

It was a simple group discussion in which we were 10 students the topic was given by the HR itself

Q1. It was a sales job so most of the question were related to the sales and marketing
Add your answer
Q2. Why do you want a sales job if you are from technical
Add your answer
Q3. About the work experiences
Add your answer
Q4. Situation Based Questions
Add your answer
Q5. Some sort of HR questions
Add your answer

It was nice experience. amazing

Q1. Tell me about yourself
Add your answer
Q2. Tell me about your passion
Add your answer

Q1. Tell me what value will you add to the company?
Add your answer

Q1. This is a HR round includes introduction & previous job experience.
Add your answer
Q2. Tell me about yourself
Ans. 
Experienced sales executive with a proven track record in exceeding targets and building strong client relationships.
• 10+ years of experience in sales, with a focus on B2B sales

• Consistently achieved or exceeded sales targets by 20% or more

• Developed and maintained strong relationships with key clients, resulting in repeat business and referrals

• Expertise in consultative selling and solution-based approach

• Proficient in CRM...read more
Answered by AI
Add your answer

In 2nd round they have asked about my previous jobe role & responsibilities with Case study.

Q1. 3rd Round with HRBP with repeated questions.
Add your answer
Q2. Tell me about yourself
Ans. 
Experienced sales executive with a proven track record in exceeding targets and building strong client relationships.
• 10+ years of experience in sales, with a focus on B2B sales

• Consistently achieved or exceeded sales targets by 20% each quarter

• Built and maintained a portfolio of key accounts, resulting in a 30% increase in revenue

• Strong negotiation and communication skills, with the ability to effectively present and cl...read more
Answered by AI
Add your answer

Q1. Please elaborate previous job roles and responsibilities
Ans. 
As a Sales Executive, my previous job roles involved managing client relationships, generating leads, and achieving sales targets.
• Managed a portfolio of clients and built strong relationships with key decision-makers

• Identified and pursued new business opportunities through lead generation and prospecting

• Developed and executed sales strategies to meet or exceed sales targets

• Conducted product presentations and demonstrat...read more
Answered by AI
Add your answer

Q1. This is my 5th round for Sales executive inbound calling profile with repeated questions. Still, No feedback is shared after taking 05 rounds.
Add your answer
Q2. Tell me about yourself.
Ans. 
I am an experienced Sales Executive with a proven track record of exceeding targets and building strong client relationships.
• Over 5 years of experience in sales, with a focus on B2B sales

• Consistently achieved or exceeded sales targets by 20% each quarter

• Developed and maintained relationships with key clients, resulting in a 30% increase in repeat business

• Implemented effective sales strategies, resulting in a 15% increa...read more
Answered by AI
Add your answer

Test time 35 min, based on Python SQL Stats

Q1. Explain ML algorithms
Ans. 
ML algorithms are mathematical models used to identify patterns and make predictions from data.
• ML algorithms can be supervised, unsupervised, or semi-supervised

• Supervised algorithms include linear regression, decision trees, and neural networks

• Unsupervised algorithms include k-means clustering and principal component analysis

• Semi-supervised algorithms combine elements of both supervised and unsupervised learning

• ML algo...read more
Answered by AI
Add your answer
Q2. Explain SQL joins, explain join in a given situation
Ans. 
SQL joins are used to combine data from two or more tables based on a related column.
• Joins are used to retrieve data from multiple tables in a single query.

• Common types of joins are inner join, left join, right join, and full outer join.

• Joining tables can be done using the JOIN keyword and specifying the columns to join on.

• Example: SELECT * FROM table1 JOIN table2 ON table1.column = table2.column;

• Joins can be used to c...read more
Answered by AI
Add your answer

Q1. Explain projects you have worked
Add your answer
Q2. The algorithm used in the project (in my case LSTM)
Ans. 
The algorithm used in the project is LSTM.
• LSTM stands for Long Short-Term Memory and is a type of recurrent neural network.

• It is commonly used for sequential data analysis such as time series forecasting, speech recognition, and natural language processing.

• LSTM networks have the ability to remember long-term dependencies and avoid the vanishing gradient problem.

• They consist of memory cells, input gates, output gates, a...read more
Answered by AI
Add your answer
Q3. Why LSTM? how does it work?
Ans. 
LSTM is a type of recurrent neural network that can handle long-term dependencies.
• LSTM stands for Long Short-Term Memory.

• It uses gates to control the flow of information.

• It can remember information for a longer period of time compared to traditional RNNs.

• It is commonly used in natural language processing and speech recognition tasks.

• LSTM has been shown to be effective in predicting stock prices and weather patterns.
Answered by AI
Add your answer

Simple coding in any programming language

Q1. Technical question and written test
Add your answer

Q1. Manager round for core concepts
Add your answer

Q1. Salary discussion made
Add your answer

It was done on hackerrank the first question was related to array and second was on linked list and last was on sql

Q1. Oops concept stack program SQL basics
Add your answer

Q1. Normal question related to me and job
Add your answer