SUMMARY:

• 7+ years of experience in Financial Planning and AnalysisStrong financial modeling and MS Excel Skills (VBA, SQL, Macros, PowerPivot)
• In - depth knowledge of financial reporting, data review, preparing budget planning and forecasting
• Advanced knowledge of system development methodology and project management

TECHNICAL SKILLS:

• MS Office
• MAC OS
• SAP
• JD Edwards
• MS Access (VBA, SQL)
• MS SharePoint
• Tableau
• Adaptive Planning
• COGNOS

PROFESSIONAL EXPERIENCE:

Confidential, New York, NY

Sr. Financial Analyst

Responsibilities:

• Primary responsible for financial analysis of Portfolios and monitoring financial performance.
• General Financial Analysis and Planning
• Building and maintaining detailed financial models (e.g. performance curves, financial projections, books etc.)
• Presenting Monthly Financial Book to Senior Management
• Managing and submitting daily Borrowing Base Certificate
• Completing structured financing of lease portfolios aggregating $90 million to major financial institutions
• Analyzing and tracking lease delinquency, cash flow, portfolio forecast and covenants
• Implementing short - and long - term cash flow models for debt portfolios and submitting performance report to major lenders and private investors.
• Generating and presenting Servicer Reports for Lenders on monthly basis using MS Excel/MS Access
• Monitoring the performance of individual portfolio to identify, document, and quantify operating issues, delinquencies and credit risks and preparing annual and quarterly reports for each portfolio
• Reviewing and preparing monthly reports, financial statements, tracking models, annual budgets, and other deliverables
• Ad- hoc financial and non-financial requests and special project
• Managing and mentoring Junior Financial Analysts

Confidential, New York, NY

Sr. Financial Analyst

Responsibilities:

• The role is focused on financial analysis, financial reporting, budgeting, forecasting and strategic planning. Responsible of developing report of approximately ten most actionable metrics for use by Executives on a monthly basis.
• Leading development of dashboard reporting for various lines of business in order to deliver only valuable, pertinent information. Collaborating with data warehouse and other finance teams to revise methodologies and improve consistency of results.
• Developed KPI Report for the Business in MS Excel, Power Point and Tableau
• Performed financial modeling including forecast and budgeting
• Created financial template for Zero Based Budget in MS Excel using macros and power pivot
• Analyzed Sales, Revenue and Expenses on weekly and monthly basis
• Worked with confidential information (headcounts and payroll)
• Analyzed staffing (Full time vs. Consultants)
• Created templates in excel for each Dept to measure and track financial information on daily/weekly/monthly basis
• Analyzed, reviewing and providing quantitative assessments on financial data for each Department
• Managed and supervised the process of evaluating financial performance, providing recommendations to Executive Team which impact the future of the Organization
• Managed various financial projects for Senior Managers

Confidential, New York City, NY

Financial Analyst

Responsibilities:

• Projected financial impact on revenue based on renegotiated managed care contracts
• Lead the monthly business review process to analyze the current strengths, weaknesses, and challenges
• Designed customized Access database daily, monthly and quarterly reports for all levels of management through VBA class modules
• Developed operating budgets in coordination with Managers for Sites and Depts. using MS Excel
• Developed and created financial modules in MS Excel for Corporate use

Confidential, New York City, NY

Finance Manager

Responsibilities:

• This project was managing financial data transition process from QuickBooks to SAP (Implemented/tested SAP system)
• Lead special financial analyses in support for systems integration
• Managed monthly Financial and Sales reports for 5 US Retail Stores
• IT Support in day - to-day activities in transition from QuickBooks to SAP system.
• Supervised the Finance Department, ensuring optimal performance
• Monitored costs and expenses, budget preparations and financial analyses using Cognos
• Prepared regular reports and statements for Management (budgeting, forecasting and planning)

Confidential, New York, NY

Project Coordinator/Data Analyst

Responsibilities:

• The role was coordinating projects for Global Loss Prevention Group and extensively working with Managers on internal financial, IT and HR related projects.
• Developed system to track sales team performance for producers and heads of regional offices so that all revenue may be captured and applied correctly
• Proactively coordinated projects acting as central point of contact from project initiation to project completion for various Confidential Units
• Developed internal database from scratch to track projects using SQL Server and Access
• Developed internal automated reports in MS Excel (SQL, Macros)
• Supervised various IT and Business projects and deadlines for Top Management (using internal databases, MS Excel, Access, SharePoint and SAP)