Mrunal Sane • MBA • Finance • 2024 • Pune
Miss Mrunal Sane • 22
mrunalsane40@gmail.com
• I aim to develop expertise in financial analysis and strategy, driving business growth and achieving financial excellence.
⁃ Why I Qualify to Work For You ⁃
As an aspiring finance professional, I bring practical skills to your team. Here’s why:
① Bachelor of Commerce
ⓐ Foundational Knowledge: Provides a comprehensive understanding of commerce, including finance, accounting, and business principles.
ⓑ Core Competencies: Strengthens your ability to apply fundamental business concepts in practical scenarios.
② MBA in Finance
ⓐ Comprehensive Knowledge: Provides a solid foundation in finance principles, making you capable of supporting various financial tasks.
ⓑ Efficient Task Execution: Ability to follow instructions and perform tasks like financial analysis, budgeting, and forecasting with accuracy.
ⓒ Adaptability: Equipped to adapt to financial regulations and changes, supporting dynamic financial environments.
③ Advanced Excel Skills
ⓐ Data Handling: Expertise in Excel functions like Pivot Tables, VLOOKUP, and advanced formulas enables effective data analysis and reporting.
ⓑ Automation and Efficiency: Skills in macros, VBA, and Power Query streamline processes and improve efficiency.
ⓒ Insightful Reporting: Proficient in creating dashboards and visualizations for clear and compelling data presentation.
④ Tally GST Proficiency
ⓐ Compliance and Accuracy: Ability to manage GST compliance, perform accurate calculations, and create compliant invoices ensures adherence to regulations.
ⓑ Detailed Reporting: Generates comprehensive GST reports for effective tax management.
⑤ TCSion-Accounting Fundamental Course
ⓐ Practical Application: Solid understanding of accounting principles, bookkeeping, and financial statements enhances your capability in financial management.
ⓑ Standards Knowledge: Familiarity with accounting standards ensures accurate and compliant financial practices.
⑥ Internship with Nirmal Bang Securities Private Limited
ⓐ Real-World Experience: Hands-on experience with stock market analysis, mutual fund evaluation, and investment strategies.
ⓑ Client Management: Experience in client interaction and project management showcases your ability to handle professional relationships and project execution.
ⓒ Analytical Skills: Proficiency in interpreting financial data and creating performance reports demonstrates strong analytical abilities.
INDEX
• CV SUMMARY
• EDUCATION
• PROFESSIONAL & SOCIAL PROFILES
• QUALIFICATIONS & SKILLS
• ADDITIONAL CERTIFICATIONS
• FINANCIAL ANALYSIS & MANAGEMENT SKILLS
• FINANCIAL ANALYSIS – SOLVED CASE STUDIES
• GROWTH OPPORTUNITIES: ANALYSIS SOLVED CASE STUDIES
• SOFT SKILLS
• WORKPLACE TECHNOLOGY PROFICIENCY
• [Specific case study or opinion demonstrating my unique value and potential contributions to this specific company]
CV SUMMARY
• Experience: Fresher
• Role: Finance Analyst
• MBA Finance
• Bachelor of Commerce
• Certification in Tally GST & Advanced Excel
• English, Marathi & Hindi
✕ Relocation Willingness
✕ Night-shift Willingness
✓ Weekend Work Willingness
✓ Travel Willingness
✓ Cross-Departmental Work
✓ Remote Work Flexibility
EDUCATION
Masters in Business Administration [2024]
Pune University
• Finance
Bachelors f Commerce [2022]
Amravati University
• Accounts • Costing • Economics • International Years
PROFESSIONAL & SOCIAL PROFILES
🌐 Curriculum Vitae & Academics
🌐 LinkedIn
🌐 Medium
🌐 Twitter
🌐 Instagram
🌐 Facebook
PERSONAL STUFF
🌐 G-Drive Dump
🌐 My YouTube List
🌐 Passion Projects
🌐 Tech Essays
🌐 Future Prediction
QUALIFICATIONS & SKILLS
① MBA IN FINANCE
My MBA provides me with a solid understanding of finance principles. I can follow instructions from senior team members and complete tasks efficiently. I can perform the following tasks:
ⓐ Supporting Financial Analysis and Reporting
ⓑ Assisting with Budget Preparation
ⓒ Contributing to Financial Planning
ⓓ Helping with Investment Analysis
ⓔ Assisting in Risk Management
ⓕ Supporting Financial Audits
ⓖ Using Financial Data Analysis Tools
ⓗ Enhancing Financial Strategies
ⓘ Participating in Financial Forecasting
ⓙ Building Financial Models
ⓚ Driving Cost Optimization Efforts
ⓛ Adapting to Financial Regulations and Changes
② ADVANCED EXCEL
I am fluent in the following key Excel skills:
ⓐ Pivot Tables:
Expertise in summarizing and analyzing large datasets efficiently with pivot tables.
ⓑ VLOOKUP / XLOOKUP:
Proficient in using VLOOKUP and XLOOKUP functions for dynamic data searches and retrieval.
ⓒ INDEX and MATCH:
Skilled in employing INDEX and MATCH functions for flexible and accurate data lookup.
ⓓ Conditional Formatting:
Adept at applying conditional formatting to highlight data trends and important metrics.
ⓔ Macros and VBA:
Experienced in automating tasks and processes through macros and custom VBA coding.
ⓕ Power Query:
Proficient in using Power Query for advanced data import, transformation, and cleaning.
ⓖ Power Pivot:
Capable of creating complex data models and calculations using Power Pivot and DAX.
ⓗ Data Validation:
Skilled in implementing data validation techniques to maintain data integrity and accuracy.
ⓘ Advanced Formulas:
Experienced with advanced formulas, including SUMIFS, COUNTIFS, OFFSET, and array formulas for sophisticated data analysis.
ⓙ Dashboard Creation:
Competent in designing interactive and visually compelling dashboards to effectively present data insights.
③ TALLY GST
With specialized training in Tally GST, I can manage GST compliance efficiently. My strengths include precise GST calculations, creating compliant invoices, and generating detailed reports, ensuring effective tax management and adherence to regulations.
ⓐ GST Compliance Management: Expertise in using Tally software for managing GST (Goods and Services Tax) compliance.
ⓑ GST Calculations: Proficient in performing accurate GST calculations within Tally.
ⓒ Invoicing: Skilled in creating and managing GST-compliant invoices using Tally.
ⓓ Reporting: Experienced in generating detailed GST reports for effective tax management and compliance.
④ TCSion-ACCOUNTING FUNDAMENTAL COURSE
Specialized training from the TCSion Accounting Fundamental Course enhances my Commerce background in accounting principles and practices. This course has helped me understand the practical application of key principles such as bookkeeping, financial statement preparation, and accounting standards, ensuring accurate and effective financial management.
ⓐ Accounting Principles: Solid understanding of fundamental accounting principles and practices.
ⓑ Bookkeeping: Proficient in maintaining accurate financial records and bookkeeping.
ⓒ Financial Statements: Skilled in preparing and analyzing financial statements.
ⓓ Accounting Standards: Knowledgeable about accounting standards and their application in financial management.
⑤ INTERSHIP: NIRMAL BANG SECURITIES PVT LTD
Project profile: Management trainee
Project Title: Mutual Fund Performance Analysis
ⓐ Stock Market Analysis: Ability to analyze stock market trends and data.
ⓑ Mutual Fund Evaluation: Skills in assessing mutual fund performance and investment strategies.
ⓒ Financial Data Interpretation: Proficiency in interpreting financial metrics and performance indicators.
ⓓ Client Interaction: Experience in managing and communicating with clients.
ⓔ Interpersonal Communication: Enhanced ability to build and maintain professional relationships.
ⓕ Project Management: Skills in planning, executing, and presenting projects.
ⓖ Investment Analysis: Capability to evaluate and recommend investment opportunities.
ⓗ Reporting: Proficiency in creating detailed performance reports and analyses.
ADDITIONAL CERTIFICATIONS
• Mahindra Pride Classroom ,Naandi Foundation (2022-2023)
• TCS Youth Employment Programme – Employability Skills Development
• TCSion-Career Edge- Young Professional Course
• MS-CIT
FINANCIAL ANALYSIS & MANAGEMENT SKILLS
Below are some business management frameworks and case studies that I have studied and solved. These are intended to highlight my knowledge and understanding of real-life business management challenges and their remedies.
1. Financial Statement Analysis: Ratio Analysis:
ⓐ Includes liquidity ratios, profitability ratios, and solvency ratios.
ⓑ Trend Analysis: Analyzing financial statements over multiple periods to identify trends.
2. Valuation Techniques
ⓐ Discounted Cash Flow (DCF): Estimating the value of an investment based on its expected future cash flows.
ⓑ Comparable Company Analysis (Comps): Valuing a company based on valuation multiples of similar companies.
ⓒ Precedent Transactions: Analyzing past transactions to estimate the value of a company.
3. Risk Management Framework:
ⓐ Value at Risk (VaR): Measuring the potential loss in value of a portfolio over a defined period for a given confidence interval.
ⓑ Stress Testing: Assessing the impact of extreme market conditions on financial portfolios.
4. Portfolio Management: Modern Portfolio Theory (MPT):
ⓐ Optimizing the risk-return profile of a portfolio through diversification.
ⓑ Capital Asset Pricing Model (CAPM): Estimating the expected return on an asset based on its risk relative to the market.
5. Capital Budgeting Techniques:
ⓐ Net Present Value (NPV): Evaluating the profitability of an investment by calculating the present value of cash flows.
ⓑ Internal Rate of Return (IRR): Determining the discount rate that makes the NPV of an investment zero.
6. Corporate Finance Models:
ⓐ Modigliani-Miller Theorem: Analyzing the impact of capital structure on a company’s value.
ⓑ Dividend Discount Model (DDM): Valuing a company based on the present value of its expected future dividends.
7. Financial Planning and Forecasting:
ⓐ Budgeting: Preparing detailed financial plans and forecasts for operational and strategic planning.
ⓑ Scenario Analysis: Evaluating different future scenarios to assess their impact on financial performance.
8. Economic and Market Analysis:
ⓐ Economic Indicators: Understanding the impact of macroeconomic factors such as GDP, inflation, and unemployment on financial markets.
ⓑ Market Efficiency: Analyzing how information is reflected in asset prices and market behavior.
9. Mergers and Acquisitions (M&A):
ⓐ Due Diligence: Evaluating the financial and operational aspects of a company before an acquisition.
ⓑ Synergy Analysis: Assessing potential benefits from combining companies, such as cost savings or revenue enhancements.
10. Financial Risk Management:
ⓐ Hedging Strategies: Using financial instruments to mitigate risks related to interest rates, currencies, and commodities.
ⓑ Credit Risk Analysis: Assessing the likelihood of default by borrowers or counter parties.
Familiarity with these frameworks and analyses equips finance professionals to make informed decisions, manage risks, and drive strategic financial planning.
FINANCIAL ANALYSIS – SOLVED CASE STUDIES
1. Financial Performance Analysis
🌐 Starbucks
Focus: Analyze Starbucks’ financial performance using ratio analysis, trend analysis, and bench-marking against industry peers.
2. Valuation Techniques
🌐 Tesla
Focus: Use DCF, Comparable Company Analysis, and Precedent Transactions to value Tesla and assess its market position.
3. Risk Management Strategies
🌐 Goldman Sachs
Focus: Examine Goldman Sachs’ risk management practices, including VaR, stress testing, and hedging strategies, and their effectiveness in mitigating financial risks.
4. Capital Budgeting Decisions
🌐 Apple
Focus: Evaluate Apple’s capital budgeting decisions for major projects, including NPV, IRR, and sensitivity analysis of new product investments.
5. Mergers and Acquisitions
🌐Amazon
Focus: Analyze a recent M&A deal involving Amazon, such as its acquisition of Whole Foods, including due diligence, synergy analysis, and post-merger integration.
6. Portfolio Management
🌐 Vanguard
Focus: Assess Vanguard’s portfolio management strategies using Modern Portfolio Theory, CAPM, and performance evaluation metrics.
7. Economic Impact Analysis
🌐 Johnson & Johnson
Focus: Analyze how macroeconomic factors, such as inflation and GDP growth, impact Johnson & Johnson’s financial performance and strategy.
8. Corporate Finance Decisions
🌐 Microsoft
Focus: Examine Microsoft’s corporate finance decisions, including capital structure, dividend policies, and shareholder value creation.
9. Financial Planning and Forecasting
🌐 Procter & Gamble
Focus: Analyze Procter & Gamble’s financial planning and forecasting processes, including budgeting, scenario analysis, and long-term financial strategy.
10. Investment Analysis
🌐 Berkshire Hathaway
Focus: Evaluate Berkshire Hathaway’s investment strategies, including asset allocation, investment selection criteria, and performance evaluation.
GROWTH OPPORTUNITIES: ANALYSIS SOLVED CASE STUDIES
🌐 Uber Technologies
Focus: Analyze Uber’s strategy for identifying and capitalizing on investment opportunities in new markets and technologies, such as autonomous vehicles and international expansion.
2. Conducting Market Analysis
🌐 Netflix
Focus: Examine Netflix’s approach to conducting market analysis for content creation and global expansion, including competitor analysis, consumer behavior, and market trends.
3. Developing Growth Strategies
🌐 Adobe Systems
Focus: Evaluate Adobe’s growth strategies, particularly its transition to a subscription-based model and cloud services, and assess the effectiveness of these strategies in driving revenue growth.
4. Opportunity Identification in Emerging Markets
🌐 Coca-Cola
Focus: Analyze Coca-Cola’s strategy for identifying and leveraging opportunities in emerging markets, including market entry strategies, local partnerships, and product adaptations.
5. Conducting Financial Due Diligence
🌐 IBM
Focus: Review IBM’s due diligence process in evaluating potential acquisitions, including financial assessments, strategic fit, and risk evaluation.
6. Developing Strategic Financial Plans
🌐 Walmart
Focus: Assess Walmart’s strategic financial planning, including long-term investment strategies, cost management, and capital allocation decisions to sustain growth and competitiveness.
7. Opportunity Analysis in Fintech
🌐 Square Inc.
Focus: Examine Square’s identification and exploitation of opportunities in the fintech sector, including innovations in payment processing and expansion into new financial services.
8. Market Analysis for New Product Launch
🌐 Samsung Electronics
Focus: Analyze Samsung’s market analysis for launching a new product line, including consumer research, market segmentation, and competitive positioning.
9. Growth Strategy for Digital Transformation
🌐 General Electric
Focus: Evaluate General Electric’s growth strategy related to digital transformation and industrial IoT, including strategic investments and partnerships to drive innovation.
10. Strategic Investment Decisions
🌐 Intel Corporation
Focus: Investigate Intel’s strategic investment decisions in research and development, including the allocation of resources and impact on technological advancements and market position.
CASE STUDIES: NOTED OBSERVATIONS & ANALYSIS DURING INTERNSHIPS
I have developed the following case studies based on the insights I gained during my internship. These frameworks will help streamline financial analysis, optimize resource allocation, and enhance decision-making, ensuring that the company maximizes profitability and maintains financial stability. By focusing on key areas like cost efficiency, risk management, and performance tracking, they enable a systematic approach to achieving business growth and sustainability.
🌐F.I.N.A.N.C.E. Framework (Financial Insight, Navigation, and Analysis for Cost Efficiency)
The F.I.N.A.N.C.E. Framework enables finance professionals to systematically gather and analyze financial data, optimize resource allocation, and enhance cost efficiency, ensuring sound financial decision-making.
🌐C.A.P.I.T.A.L. Framework (Cost Analysis, Profitability Insight, and Tactical Allocation Learning)
The C.A.P.I.T.A.L. Framework focuses on cost analysis and profitability, helping finance analysts manage accounts, develop tactical budgets, and strategically allocate resources to maximize financial returns.
🌐B.A.L.A.N.C.E. Framework (Budgeting, Analysis, and Leveraging Assets for Net Capital Efficiency)
The B.A.L.A.N.C.E. Framework guides the preparation of budgets, analysis of financial statements, and management of assets, ensuring net capital efficiency and overall financial stability.
🌐P.R.O.F.I.T. Framework (Performance Review, Optimization, and Financial Investment Tracking)
The P.R.O.F.I.T. Framework emphasizes the continuous review of financial performance, optimization of processes, and effective tracking of investments, supporting informed financial planning and risk management.
🌐A.S.S.E.T. Framework (Analysis, Strategy, Spending Efficiency, and Tracking)
The A.S.S.E.T. Framework prioritizes thorough financial analysis, strategic planning, and efficient spending, while leveraging Excel for modeling and tracking, to drive informed financial decision-making and sustain business growth.
SOFT SKILLS
I have developed a range of personal skills that contribute to my contribution and value in the workplace. Details:
①. Communication Skills: I can convey information clearly and engage in productive conversations, while also being an active listener.
②. Problem-Solving Abilities: I am skilled at identifying issues, analyzing solutions, and implementing effective strategies to overcome challenges.
③. Adaptability: I adjust to new situations and handle changes with flexibility.
④. Time Management: I am adept at prioritizing tasks, managing deadlines efficiently, and balancing multiple responsibilities.
⑤. Team Collaboration: I work well with others, contributing to team goals and supporting colleagues to achieve common objectives.
⑥. Initiative: I bridge the gap between front-line operations and leadership by providing regular, data-driven updates.
⑦. Attention to Detail: I pay close attention to the finer aspects of work, ensuring accuracy and high-quality outcomes.
⑧. Dependability: I am reliable, consistent, and trustworthy, consistently completing tasks as expected and on time.
⑨. Emotional Intelligence: I manage my own emotions effectively, empathize with others, and foster positive work relationships.
⑩. Continuous Learning: I am committed to personal and professional growth, staying updated with industry trends and acquiring new skills.
⑪. No Assumptions: I prefer to voice my doubts and confusions rather than relying on assumptions. This approach ensures a clear and accurate understanding of the situation.
WORKPLACE TECHNOLOGY PROFICIENCY
The Following Technology Skills Ensure My Seamless Integration as a New Hire:
① Microsoft Office Suite
② Google Workspace Suite
③ Document Management Systems
④ Cloud Storage Services [Google Drive etc]
⑤ Notion
⑦ CRM
⑥ Streak CRM within Gmail.
⑨ Email Clients
⑩ Email Management
⑪ Slack
⑫ Virtual Communication
⑬Task Automation Tools
⑭ AI Tool [ChatGPT, Gemini & Perplexity]
⑮ Canva
⑯ Coda
I would be glad to present and prove my CV in a personal interview. If you have any additional questions, please feel free to email me.
—
Mrunal Sane.