Power Bi Risk Management

Joy Christo Gonamanda, MS

513-***-**** • **********.**@*****.***

SUMMARY

Finance professional with a Master’s in Finance, skilled in analysis, budgeting, and automation. Proficient in Excel, Power BI, Tableau, and Python to optimize reporting and decision-making. Experienced in modeling, forecasting, and risk management to drive project performance CORE KNOWLEDGE AND TECHNICAL SKILLS

Microsoft Office Excel Power BI Tableau Tableau Prep Builder Python Jupyter Notebook Google Colab

SQL Financial Modeling Data Analysis Forecasting Budgeting Cash Flow Analysis Financial Reporting

Risk Management FP&A Project Financial Tracking Dashboard Development Investment Analysis ROI Analysis Business Strategy Accounting Corporate Finance Mergers & Acquisitions Due Diligence Valuation Techniques Financial Planning & Analysis Process Automation Stakeholder Communication Collaboration

Written and Verbal communication skills Problem-solving skills Organizational skills Analytical thinking PROFESSIONAL EXPERIENCE

Financial Analyst

Bytewave Technovations Jun 2024 –Present

• Financial Analysis: Analyzed 30+ financial statements and supported financial forecasting, contributing to an 8% improvement in forecast accuracy by identifying key trends and potential variances

• Valuation Analysis: Facilitated performing comparable companies and precedent transaction analyses using advanced Excel functions to streamline data analysis and reporting

• Financial Modeling: Collaborated with team to create Excel models for cost-tracking and identifying cost reduction opportunities. Analyze financial data, including DCF and LBO models, to provide insights and inform decision-making

Graduate Financial Assistant

Carl H. Lindner College of Business Jan 2023 – Dec 2023

• Budget Optimization: Managed and optimized a $2M+ budget for academic programs, experiential learning initiatives, and financial technology resources in the University of Cincinnati’s finance department, ensuring efficient allocation and utilization of funds

• Financial Performance Tracking: Developed KPIs to monitor budget effectiveness and program performance, contributing to an 8% improvement in financial oversight and academic outcomes

• Process Efficiency: Leveraged tools like ChatGPT to streamline system configuration, documentation, and reporting, reducing administrative workload by 20% and improving the accuracy of financial tracking Investigation Specialist II (Financial Operations Specialist) Amazon Jan 2021 - Dec 2022

• Financial Analysis: Conducted in-depth analysis of 1,000+ FBA merchant transactions, improving compliance by 15% for 50+ stakeholders

• Process Automation: Designed a financial tool for the 'Magnolia' project, automating financial statement analysis and reducing processing time by 30 hours per month

• Project Management: Managed timelines and resources for the 'Magnolia' project, delivering 5 key milestones on schedule. Led a team of 12, addressing challenges and ensuring objectives were met within budget

• Financial Impact: Delivered $1.5 million in savings within one year through effective investigations and risk mitigation

• Dashboard Development: Created automated dashboards using several tools to track KPIs and generate actionable insights, improving cross-departmental transparency and reporting accuracy

• Data Analysis: Utilized advanced Excel functions (e.g., VLOOKUPs, HLOOKUPs, and Macros) to analyze large datasets, driving improvements in forecasting and financial oversight Wealth Management (Intern)

Bajaj Capital Dec 2019 – Dec 2020

• Portfolio Management: Analyzed client portfolios, improving investment returns by 8% on average, and supporting Treasury monetization strategies

• Client Investment Strategies: Assisted in developing personalized investment strategies for high-net worth clients, resulting in a 15% increase in portfolio performance over six months

• Risk Assessment: Conducted detailed risk assessments to balance portfolio volatility and returns, ensuring alignment with client financial goals and risk tolerance EDUCATION

Master’s in finance - University of Cincinnati, Carl H. Lindner College of Business Jan 2023 – Apr 2024 Bachelor of Commerce (International Finance) - Loyola Academy, Osmania University Sep 2020 JOB SIMULATION

Investment Banking

JP Morgan Chase Aug 2024

• Developed a DCF model to evaluate acquisition targets, Performed financial modeling and valuation analysis on hypothetical M&A transactions

• Analyzed industry trends and company performance to make strategic recommendations

• Created pitch books and presentations for potential clients, simulating real-world investment banking tasks Investment Banking

Bank of America Aug 2024

• Conducted SWOT analysis and created a sensitivity analysis to adjust for changing market conditions, focusing on ERP data and pricing models

• Constructed a DCF model to calculate the implied equity and share value of the acquisition target

• Completed a sensitivity analysis to illustrate how the target’s valuation would change as variables change

• Created a company profile summarizing all key information about the target ACADEMIC PROJECTS

Financial Analysis of Chemed Corporation

• Scope: Conducted a thorough evaluation of cash flow trends using DCF and CCA modeling, identifying over 10 growth opportunities and improving strategic decision-making by 15%

• Methodology: Applied 50+ data points to improve proficiency in valuation analysis and support key business activities

• Outcomes: Specified actionable insights, aligning project outcomes with business priorities, and enhancing executive buy-in by 20%

LEADERSHIP

• Project Magnolia: Managed cross-functional teams to implement automation tools, improving reporting and compliance functions by 20%. Focused on cash flow management, budgeting, and tax optimization strategies

• Quality Auditor (Amazon): Elevated quality control processes by 11%, enhancing compliance in financial documentation

• Discipline Head, Student Council: Led initiatives that advanced operational efficiencies, including implementing a feedback system for course adjustments CERTIFICATIONS

• Bloomberg Market Concepts

• AI in FinTech

• Corporate Financial Statement Analysis

• Certified Financial Modeling & Valuation

Analyst (NASBA)

• Advanced Microsoft Office

• Tableau (NASBA)

• Power BI for Data Analysts by Microsoft

• Investment Analysis and Portfolio

Management

Contact this candidate