SUMMARY

Professional Financial Analyst who has significant experience with public and private corporate reporting needs. Adept at departmental and corporate budgeting utilizing a variety of financial spreadsheet programs and developing methods for reporting data to executive team. Specializes in analyzing dynamic financial data and developing financial reports. Possess organizational skills needed to successfully complete assignments, and an interest in contributing toward meeting a company's business goals.

TECHNICAL SKILLS:

• MS Office 2003/2007
• SAP FICO (Basic knowledge). Strong Microsoft word
• Excel
• PowerPoint
• HTML
• Visual Basics
• Informatica 9.x Windows
• PL/SQL
• COBOL
• Oracle
• DB2
• Cognos BI
• Big data
• Tableau
• Accounting
• Financial Statements
• Money Laundering
• GAAP Principles
• Basel Accord
• Credit write - ups and Banking Facilities. Debt Financing
• Budget balancing
• Capital Management
• Portfolio management.

PROFESSIONAL EXPERIENCE:

Confidential, PA

Sr. Financial Analyst

Responsibilities:

• Reviewing and developing new financial models for timely preparation of financial reports, budgeting, and forecasting
• Performing monthly financial analysis and modifying procedures as necessary
• Worked with IT, and sales and marketing department for installing financial reporting systems and tools
• Preparing capital budgets and maintaining competitive statistics and data
• Analyzing business performance, setting target, and forecasting future growth
• Providing financial support to clients reviewing their projects
• Provided research and analysis used in conducting monthly departmental P&L review meetings and reviewed preliminary monthly P&L statements.
• Point person for preparing property annual budget, including compiling initial proposed budget, distributing budgeting tools to, and submitting summary reports.
• Developed new financial planning techniques.
• Designed visualizations and dashboards using Microsoft Excel pivot tables and data validation tools for management. 
• Played Cross functional role, involving Business, Third Party Contractors, HR, Talent Acquisition, Event Management, Procurement, Accounting & finance team. Setting up a robust operating & governance mechanism between FPA & all other teams
•  Finalizing financial statements and Report writing for Core & Value add investment funds and various separate account clients. 
• Calculating Net Asset value for investment funds. 
• Analyzing past years data, to arrive at run rates for various expenses by month. Identified potential locations for acquisition and expansion using cluster analyses. 
• Implemented process improvement, developed Standard Operating Procedures, and worked with cross functional teams to improve efficiency and save enormous time and cost.
• Cross train employees on all SAP related functions associated with the SAP database.
• Set Up Liquidity Management, Activated SAP Business Objects BI, Installed Template for Cash Flow Analysis, Generated Planning View, and Activated BPC for Planning.
• Good knowledge to configure and execute the migration to Simple Finance in SAP with/without New GL
• Revenue Recognition, financial statement analysis for accounting purposes. Used V lookups, pivot tables, and formulas in excel for reconciliation 
• Provided reports to management to display an accurate detail on where the company stands 
• Presented to Project Managers MTD and YTD financial figures of the company. 

Confidential, Boston, MA

Financial Analyst 

Responsibilities:

• I assisted Relationship Managers in assessment of lending proposition and help them calculating the financial ratios through Moody’s Risk Analyst (MRA). My work role involves analysis of Audited Financial Statements (10K, 10Q, 8K and Internal Prepared), generating Reports through MRA tool and writing justification based on the coverage ratios.
• Consolidated and analyze monthly results and budgets. Create and deliver presentations, providing recommendations on short- and long-range ROI. 
• Running a highly efficient Credit Function, this includes preparation of Credit Applications (through the CARM software) and Financial Statement Spreading.
• Analyzing customer's financial statements (B/S, P/L and Cash Flow) via Company Watch and writing feedback in the customer's credit Application.
• Assisting Relationship Manager in approving the Credit Application and preparing detailed structure of various banking facilities and products.
• Drawing funds, charging fees, interest rate and calculating loan repayment for a given facility as per the request of relationship manager.
• Monitoring customers account for possible Money Laundering situation. Preparing legal Facility Letters for the facilities available to the customer.
• Analysis of Clients Financials of different business groups. Ex: Retail, lending, Technology, Media, Manufacturing etc.
• Detailed study of Audited Financials which includes 10K, 10Q, 8K and company prepared financials.
• Calculating financial ratios like Debt Service Coverage Ratio (DSCR), Leverage ratio, Free Cash Flow etc.
• Generating Reports through Moody’s Risk Analyst (MRA) tool.
• Analyze credit data and financial statements to determine the degree of risk involved in extending credit or lending money.
• Communicating with Relationship Manager over the phone to discuss about the rating of the client.
• Assigning an Internal Rating to the client and writing a justification (write up) based on the MRA report and other factors.
• Conducting meeting and Trainings for team members to improve process knowledge.

Confidential

Financial Analyst

Responsibilities:

• Implementation financial reporting and computer system reflexes for newly acquired franchise to report accounting in compliance with GAAP. 
• Track and provide budget phasing updates and variance commentary monthly, using B&F and Hyperion, to the CFO
• Prepared budget vs actuals report for business partners to identify and analyze variances. 
• Closely work with the Director of FP&A in preparation of monthly analyses that provide accurate, timely, and meaningful financial information on actual performance. 
• Review and summarize balance sheet issues to include, but not limited to Unbilled Media, Accrued Revenue, WIP account, Advanced Payments, and CapEx tracking 
• Performed credit analysis to identify, analyze, and manage risk factors on a portfolio of 200+ accounts 
• Updates payroll records by entering changes in exemptions, and deductions. 
• Calculate net pay with deductions and taxes for late corrections or changes, late dock and various types of overpayment. Reconcile and track established Receivables through the collection process. 
• Performed additional tasks and special projects as assigned by supervisor or project management senior leadership.
• Supported 10Q, 10K and annual reporting processes including scheduling and annual report footnote preparation.
• Created chart of accounts for implementation of new SAP general ledger module.
• Analyzed accounts and established enterprise-wide standardization.
• Recorded, interpreted, and reported financial information in support of general business operations and long-range strategic planning functions.
• Part of a small team responsible for complete audit of corporate annual statement prior to filing it each year.
• Developed revenue and expense trends for each department to be used in budgeting.
• Responsible for tracking all expenses and creating monthly report for executives.
• Helped to create computer model that forecasted revenue needs for payroll and other important functions.
• Developed several custom reporting methods that kept management updated on cash flow status.
• Responsible for working with database engineers to maintain accuracy of financial information delivered by company computer network.
• Good working knowledge of SAP Simple Finance On Premise Business edition (SFIN 2.0) involving SAP Accounting, SAP Cash Management and SAP Integrated Business Planning for Finance.