Family Health Plan MIS Analyst Interview Questions and Answers

Q1. Tell me about yourself
Ans. 
I am a dedicated and experienced MIS Executive with a strong background in data analysis and reporting.
• Over 5 years of experience in managing and analyzing data for decision-making purposes

• Proficient in using various MIS tools and software such as Excel, SQL, and Tableau

• Strong communication skills to effectively collaborate with cross-functional teams

• Proven track record of improving operational efficiency through data-
Answered by AI
Add your answer
Q2. Can you describe your experience?
Ans. 
I have 5 years of experience in managing MIS reports, data analysis, and system optimization.
• Managed and maintained various MIS reports for tracking key performance indicators

• Conducted data analysis to identify trends and make recommendations for process improvements

• Optimized systems to streamline data collection and reporting processes

• Utilized advanced Excel functions and data visualization tools for reporting

• Collabor...read more
Answered by AI
Add your answer

Q1. What are your salary expectations?
Ans. 
My salary expectations are based on my experience, skills, and the market rate for the position.
• Research the average salary range for MIS Executives in the industry and location

• Consider my experience, skills, and qualifications when determining my salary expectations

• Be open to negotiation based on the overall compensation package offered
Answered by AI
Add your answer
Q2. Why are you looking for a change?
Ans. 
Seeking new challenges and growth opportunities in a dynamic work environment.
• Looking for opportunities to expand skill set and knowledge

• Seeking a more challenging role to further career development

• Interested in working in a more innovative and fast-paced environment
Answered by AI
Add your answer

Q1. Explain Cypress framework in brief
Add your answer

Basic 10 apti question

Basic 5 python question

Basic 5 SQL question

Q1. They asked two python program.
Add your answer

Q1. They asked one SQL question
Add your answer

Q1. Just question based on my resume.
Add your answer

Q1. Tell me about your self?
Add your answer
Q2. What is SQL and diffrent joins in SQL?
Ans. 
SQL is a programming language used for managing and manipulating relational databases. Different joins in SQL include inner join, outer join, left join, and right join.
• SQL is a standard programming language for managing and manipulating relational databases.

• Different types of joins in SQL include inner join, outer join, left join, and right join.

• Inner join returns rows when there is at least one match in both tables.

• Ou...read more
Answered by AI
Add your answer
Q3. How to separate portion before @ and after @ from mail using python?
Ans. 
Use Python to separate portion before and after @ in an email address.
• Use the split() method to separate the email address into two parts based on the @ symbol.

• Access the parts using index 0 for the portion before @ and index 1 for the portion after @.

• Example: email = 'example@email.com'; parts = email.split('@'); before = parts[0]; after = parts[1];
Answered by AI
Add your answer
Q4. What is the rank, Dense Rank and Row Number?
Ans. 
Rank, Dense Rank, and Row Number are functions used in SQL to assign a ranking to rows in a result set.
• Rank function assigns a unique rank to each row based on the specified column values.

• Dense Rank function assigns a unique rank to each row without any gaps.

• Row Number function assigns a sequential integer to each row in the result set.
Answered by AI
Add your answer

Q1. Regularizaion, model improvemnts
Add your answer
Q2. Hyperparameter tuning
Add your answer

Q1. Tell me about yourself
Ans. 
I am a data analyst with a strong background in statistics and data visualization.
• Graduated with a degree in Statistics

• Proficient in programming languages like Python and R

• Experience in analyzing large datasets and creating data visualizations

• Strong problem-solving skills
Answered by AI
Add your answer

Q1. Types of credit management
Ans. 
Types of credit management include credit analysis, credit scoring, credit limit setting, credit monitoring, and credit collection.
• Credit analysis involves assessing the creditworthiness of potential borrowers.

• Credit scoring uses statistical models to predict the likelihood of default by a borrower.

• Credit limit setting determines the maximum amount of credit that can be extended to a borrower.

• Credit monitoring involves...read more
Answered by AI
Add your answer

Questions on investments

Company valuation to submit