Envestnet Asset Management Business System Analyst Interview Questions and Answers

Q1. Write me a query to get the last month's data and it only runs 1st of everymonth
Ans. 
Query to retrieve last month's data on the 1st of every month
• Use the DATEADD function to subtract a month from the current date

• Filter the results to only include data from the 1st of the month

• Example: SELECT * FROM table_name WHERE date_column = DATEADD(month, -1, DATEADD(month, DATEDIFF(month, 0, GETDATE()), 0))
Answered by AI
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

Good,it was a great experience to me

Q1. Amalgamation and absorption differences
Ans. 
Amalgamation and absorption differences
• Amalgamation is a merger of two or more companies into a new entity, while absorption is when one company takes over another and the absorbed company ceases to exist

• In amalgamation, the shareholders of the merging companies become shareholders of the new entity, while in absorption, the shareholders of the absorbed company become shareholders of the absorbing company

• Amalgamation c...read more
Answered by AI
Add your answer
Q2. Private company rules and regulations
Ans. 
Private companies have their own set of rules and regulations that govern their operations.
• Private companies are not subject to the same regulations as public companies.

• They have more flexibility in terms of decision-making and operations.

• However, they still need to comply with laws and regulations related to taxation, employment, and other areas.

• Private companies may also have their own internal policies and procedure...read more
Answered by AI
Add your answer

Q1. What is agile methology?
Ans. 
Agile methodology is a project management approach that emphasizes flexibility, collaboration, and incremental progress.
• Focus on delivering working software in short iterations

• Embrace changing requirements

• Encourage frequent collaboration between team members

• Use feedback to continuously improve the product

• Common frameworks include Scrum and Kanban
Answered by AI
Add your answer
Q2. Write a user story and edge cases
Ans. 
User story for a shopping website
• As a user, I want to be able to add items to my cart

• As a user, I want to be able to view my cart and update quantities

• As a user, I want to be able to proceed to checkout and make a payment
Answered by AI
Add your answer