Points for interview
Self-introduction whole
Excel information
Accounts whole information
Present role information
Resume whole information
[Link]
My name is Sweta Tripathi. I am from Gorakhpur, Uttar Pradesh, but currently residing in Lucknow.
I hold an MBA in Finance from the University of Lucknow and a Bachelor's degree in [Link] Retail
Management and IT from Jesus and Mary College, Delhi University. In addition to my academics, I
have completed certifications in Google Data Analytics, Excel, and Power BI, which have helped me
develop skills in data analysis, SQL, and dashboard creation. I am proficient in preparing cleaned
datasets, analyzing data, and creating dashboards to generate insights that support data-driven
decision-making.
During my postgraduation, I interned at the Outlook Group as a Business Analyst Intern, where I
gained experience in sales target achievement, data cleaning, visualization, and interpretation.
Currently, I am working as a Financial Analyst at Silverskills pvt ltd. My primary responsibility involves
analyzing financial statements and preparing cashflows by using the borrower provided documents
and guidelines.
On a personal note, I come from a family of six, including my parents, two elder sisters, and an elder
brother.
[Link] your role at silverskills?
I work as a Financial Analyst at Silverskills Pvt. Ltd. in the Commercial Re-Rating team. basically here,
I assess financial risk factors, and other borrowers provided documents, and evaluate key metrics like
Loan-to-Value (LTV) and Debt Service Coverage Ratio (DSCR). Additionally, I utilize Excel to streamline
financial data, perform variance analysis, and generate insights that support decision-making."
[Link] You’re a Good Fit):
"With my background in finance and data analysis, I am confident that I can add value to your team.
I am particularly excited about this opportunity because it aligns with my interest in financial
analytics and leveraging data for strategic decision-making."
4. Why do you want to leave your current job?
*"I appreciate the experience I’ve gained at Silverskills, where I have developed strong financial
analysis skills. However, I am now looking for a role that offers greater opportunities for career
growth, skill enhancement, and exposure to a broader range of financial analysis and data-driven
decision-making.
5. Why did you choose a career in finance?
I choose a career in finance because I enjoy working with numbers, analyzing data, and making
strategic decisions. Finance plays a crucial role in business growth, and I find it exciting to interpret
financial data to drive informed decisions. My MBA in Finance and hands-on experience in financial
analysis, Excel, SQL, and Power BI have strengthened my passion for this field. I look forward to
leveraging my skills to contribute effectively in a data-driven financial role."
5. are you ready to relocate to hyderabad answer it in a positive way
"Yes, I am open to relocating to Hyderabad. I see this as a great opportunity to work in a dynamic
environment and grow professionally. I am excited about the role and the chance to contribute to
the team
6. : How do you conduct variance analysis and trend analysis? Can you give an example of insights
you derived from this?
A:
Variance analysis involves comparing actual financial data against budgeted or forecasted figures to
identify discrepancies. Trend analysis helps track financial performance over time.
For example – when we perform cash flow analysis that time we took last 3 years data for
consideration at that time while performing it when we saw that any item whether it is income side
or expense side is show substantial difference that time we conduct variance analysis to find out the
reason behind that and if talking about trend analysis so while performing cash flow trend analysis is
the main part like upward downward and fluctuate trend on the basis of these trends we follow the
guidelines.
7. : What financial metrics do you use to assess the profitability of a project or company?
A:
I use key financial metrics such as:
Net Present Value (NPV) and Internal Rate of Return (IRR) for project evaluation.
Gross Profit Margin and EBITDA Margin to measure profitability.
Debt-to-Equity Ratio and Current Ratio for financial stability.
Return on Assets (ROA) and Return on Equity (ROE) to assess efficiency.
8. Internship (Outlook Group - Business Analyst Intern)
Q: What was the biggest challenge you faced when cleaning and analyzing survey data?
A:
The biggest challenge was dealing with incomplete and inconsistent responses in a dataset of
~11,000 participants. To solve this, I:
Used Excel functions like IFERROR, TRIM, and SUBSTITUTE to clean the data.
Removed duplicate and inconsistent entries using filters and conditional formatting. And fix
the datatype issues of the attributes.
[Link] you explain a trend or pattern you identified that impacted business decision-making?
A:
During my analysis, I noticed that a significant portion of customers preferred digital over print
subscriptions. I also created visualizations to highlight this trend.
10.Q: Can you walk us through your car inventory management project? How did you apply SQL for
exploratory data analysis?
A:
In this project, I analyzed car inventory data using SQL to:
Identify non-moving stock using LEFT JOIN queries.
Find seasonal demand trends using GROUP BY and ORDER BY statements.
Optimize inventory by forecasting demand patterns with statistical methods.
The insights helped in reducing inventory holding costs and improving turnover rates
11. Q: How would you manage an assigned budget and reconcile expenses to the ledger?
A:
I would:
Track actual expenses against budgeted figures in real time.
Use variance analysis to identify overspending or underspending.
12. what is forecasting?
In finance forecasting is the process of predicting a company's future financial performance which
helps in financial planning and decision-making
13. What techniques do you use for forecasting and budget planning?
A:
I use a combination of:
Historical data analysis to identify trends.
14. what is scenario analysis ?
Scenario analysis is a method for predicting future outcomes by considering different possible
scenarios.
15. Tell us about a time when you had to work under a tight deadline. How did you manage it?
I want to share a short story on my experience. Last year in mid of June we had a very tight
guidelines from the client but the tragical part was that two of our team members was not available
because of some emergence . to manage this we the remaining team divide our tasks into two part
one are of critical and 2nd is of easy ones. Firstly we completed critical tasks and then work on the
easiest ones . for handling this situation we as team even received appreciation from our manager.
15. Describe a situation where you had to present financial insights to a non-finance audience.
A:
While working on a sales performance dashboard at Outlook Group, I had to present findings to the
marketing team. To ensure clarity:
I used simple graphs instead of complex financial statements.
Focused on key takeaways rather than technical details.
Explained financial trends in layman’s terms to help them adjust marketing strategies
accordingly.