Financial Analyst Reporting

SUMAN GUGULOTHU

Financial Analyst

United States•201-***-****) •**********@*****.*** • www.linkedin.com/in/sumangugulothu PROFESSIONAL SUMMARY

• 5 years of expertise in Financial Analyst, specializing in preparing comprehensive budget/Forecast planning and financial models.

• Proficient in financial reporting and data reviews, providing monthly reports and insights on customer P&L performance to drive strategic decision-making and optimize cost management.

• Experienced in discerning intricate accounting challenges, conducting thorough research to devise effective solutions, executing these solutions, and articulating findings to management.

• Prepared monthly and quarterly presentations for executive leadership, the board of directors, and external stakeholders, ensuring clear and data-driven insights for strategic decision-making

• Skilled in crafting dashboards on SAP S/4 Hana SAC enriched with visually compelling graphics, offering interactive drilldowns, drop-down menus, and parameterization for enhanced user engagement and data exploration.

• Analyze current and historical financial trends/impact in all areas of revenue, expenses, capital expenditures and potential tactical acquisitions.

WORK EXPERIENCE

IKEA Apr 2024 – Current

Financial Analyst

• Developing an engaging and comprehensive supply chain process visibility tool by leveraging advanced Excel and SAP S/4HANA SAC Analytics Cloud to create an interactive dashboard.

• Prepare comprehensive annual budget planning periodic forecast for the fiscal year (FY), ensuring alignment with company goals and objectives.

• Provide planning and analytical assistance to senior management, contributing to the formulation of long-term plans, annual budgets, and rolling forecasts, which improved alignment with actual results

• Oversee all accounting duties, including FP&A, pull the month-end close process and distribute forecast allocation by channel wise with respective periods.

• Prepare monthly, quarterly, and annual financial reports, highlighting key metrics and trends. Present findings to senior management and other stakeholders in a clear and concise manner.

• Develop and maintain financial models in Anaplan for business decision-making, capital expenditures, forecast future, financial trends, and investment strategies.

• conduct detailed financial analysis, including variance analysis, profitability assessments, and cost control initiatives. Provide actionable insights to improve financial performance.

• Implementing Power BI automation to streamline and expedite financial reporting processes. Engineered automated dashboards that consolidated diverse financial data sources, reducing reporting turnaround time.

• Work closely with the Operations team to keep track of Capex spending related to market expansion KPIs. leading while implementing cost-saving measures.

• Analyze monthly financial statements to calculate monthly actual to budget variances, Year to Date (YTD) actual to Prior Year (PY) variances.

• Work cross-departmentally with Accounts Payable, Accounting and business units to ensure all month-end activity is properly Johnson & Johnson Aug 2017 - May 2021

Financial Analyst- FP&A

• Designed and executed advanced reporting solutions, including monthly performance reports with budget variance causals, through Excel and Tableau, collaborating to automate tailored department-specific reports.

• Created a comprehensive Key Performance Indicator (KPI) report for the business utilizing MS Excel, PowerPoint, and Tableau.

• Prophix creates dynamic and insightful financial dashboards, enabling comprehensive data visualization and analysis. Developed interactive reports that provided stakeholders with real-time insights into key financial metrics, facilitating data-driven decision-making.

• Managed and supervised the process of evaluating financial performance, providing recommendations to the Executive Team that impact on the future of the Organization.

• Implemented an innovative business strategy resulting in a significant decrease in operating costs, concurrently boosting profit margins.

• Championed improvements to financial forecasting and budgeting procedures, achieving a noteworthy 12% enhancement in budget precision. Conducted comprehensive scenario analysis to refine financial plans and pinpoint potential risk areas.

• Designed and executed complex financial models, forecasts, and budgets, furnished senior management with vital insights for informed decision-making, achieving key performance indicators, and conducted comprehensive assessments of accounting methods and financial statement presentations to ensure GAAP compliance.

• Analyze monthly financial statements to calculate monthly actual to budget variances, Year to Date (YTD) actual to Prior Year (PY) budget variances, YTD actual to PY budget variances.

• Evaluated competitive pricing strategies for new businesses by analyzing cost drivers and performance metric assumptions.

Real Madrid C.F, Madrid, Spain, On-site Apr 2023 – June 2023 Business Analyst Internship

• Spearheaded the development of the Play On-Virtually (P.O.V) technology project using Python and R, revolutionizing player assessment metrics and enhancing performance analysis.

• Integrated BePro software with SQL databases, enabling efficient match reviews and leveraging precision video techniques to optimize player clip selections; resulting in a 25% reduction in time spent on manual review processes.

• Utilized Power BI for advanced statistical analysis, enhance team strategy and boosting player performance metrics by 20%.

• Implemented Tableau and Python to execute a strategic SWOT analysis, leveraging modern sports analytics advancements; identified new player acquisition opportunities resulting in a 15% increase in team performance metrics.

• Streamlined reporting processes to enhance data accuracy and timely distribution, enabling more efficient decision- making for football strategies

EDUCATION

Stevens Institute of Technology, GPA: 3.5/4. Hoboken, NJ Master of Science in Business Intelligence & Analytics Sep 2022– Dec- 2023 Escuela Universitaria Real Madrid Universidad Europe, GPA 4/4 Madrid, Spain Master of Science in Sports Technologies and Digital Analytics May 2022–Jun2023 Osmania University, 8.7/10 Hyderabad

Bachelor of Accounting and Finance July 2013– Dec 2016 TECHNICAL SKILLS

Software: SAP S/4 HANA, Power BI, Tableau, Prophix, MSOffice (Word, PowerPoint, Excel),Power BI, Lookups, MySQL. Financial Skills: Financial/ Statistical Modeling, Budgeting and Forecasting, Month-End Closes, Financial Analytics, Corporate Finance, Fixed Income, Financial Research, Resource, Management, Budget Planning and Forecast allocation Methodologies: Data Modeling, Data Reporting, Cash Flow Modeling, Matplotlib, Data Mining, Risk Management, Financial Modeling, Data Visualization, Project Management.

Soft Skills: Communication, Diligence, Professionalism, Analytical Reasoning, Problem-Solving, Leadership, Multi- Tasking PROJECTS & RESEARCH EXPERIENCE

Stevens Institute of Technology. Hoboken, NJ

Analysis of Flight Delays in the Aviation Industry Oct 2022 –Dec 2022

• Conducted exploratory data analysis on reasons behind flight delays, utilizing Python with pandas, NumPy, and sklearn.

• Analyzed datasets of flight delays across different states in the US, drawing insights into airline improvements.

• Applied linear regression models, achieving an 89% prediction accuracy for non-delayed flights. Escuela Universidad Real Madrid Universidad Europea. Madrid, Spain (Remote) Technological transformation in major league soccer (MLS). Feb 2023 – Mar 2023

• Utilized advanced analytics to evaluate VAR technology in MLS, emphasizing real-time data for decision- making.

• We leveraged Sports Science and analytics with wearable tech, achieving a 30% reduction in player injuries.

• MLS’s strategic shift to Apple TV and potential revenue streams from the NFT market with the Sorareplatform.

Contact this candidate