Senior Financial Analyst

Summary of Qualifications

• Strong Analytical Skills • Budgeting & Forecasting • CPA Candidate

• Accounting Principles, GAAP & SOX • Monthly Financial Close • Reporting & Presentation

• Audit, Internal Quality, Compliance • Risk Management • Merger & Acquisition

• Project Implementation & Upgrade • Project Management • IT & SDLC Methodologies

• Excellent Problem Solving Abilities • Strategy Implementation • Team Collaboration

Experience

LUNDBECK, Deerfield, IL JUNE 2014 – Present

Sr. Financial Analyst, FP&A

Serve as a controller for Alliance Products and a business partner to multiple levels of managers associated with brand planning and local/global Alliance Product projects.

Created and own Alliance Products P&L of $500MM; Standardized monthly and quarterly financial reporting package for senior management to create efficiency and alignment, focusing on variance analysis and commenting on the key drivers/metrics

Improved analysis process of annual budget and mid-term forecasting cycles by developing a more detailed brand promotional budget; partnered with VP of Psychiatry Business Unit and his team to help identify a saving of $120K per year.

Streamlined Alliance Partner invoice approving process, cutting wait time nearly by 75%, through implementing SharePoint

Generated savings of $96K per year by proposing, creating, and implementing financial model for reallocating sales data recharges

Updated weekly and monthly revenue flash reports by incorporating KPI metrics; increased the accuracy of net sales projections by increasing transparency of Gross to Net (G2N) Assumptions

Drive the annual financial plan and budget/forecasting planning process for Alliance Products for revenue, cost, and headcount

Led Process Improvement Team implementation of SAP BPC planning and reporting and upgrade of Corporate Purchasing System

Decreased monthly closing process by a day through consolidating and automating all the cost and sales reports for the Alliance

Served as interim Finance Manager of Alliance Products and Revenue while current manager leave of absence

Recognized by HQ for creating innovative auditing tool which become the standard process for coordinating audit with Deloitte

Prepare ad-hoc analyses, financial modeling, drilldown reports, P&L statements and tasks as requested

GOGO LLC, Itasca, IL July 2013 – June 2014

Financial Project Analyst (Contractor)

Analyzed and maintained the annual budget, managed the monthly scorecard, and tracked and monitored site development pre-construction milestone activities and processes for Network Operations Department

Created and supported strategies to manage and report CAPEX and OPEX for Network Development’s tower portfolio and planned expansion; analyzed drivers of spending and business performance and presented the findings to senior management

Generated savings of $115K per year for NetOps by creating a Benefit-Cost Analysis for the Airborne Service Project

Responsible for generating detailed executive financial summary reports for tower proposals; created business case financial models to make lease vs. buy recommendations

Managed and consolidated newly acquired company for joint reporting

Led implementation for lease database and served as an administrator. Wrote and ran SQL query to extract and sort data and manipulated data. Conducted data conversions, while identifying unresolved data requirements and resolved them with the team

Enforced quality control and compliance conformance to corporate policy (SOX) while implementing Ariba CPS

ZONAH DEVELOPERS, Hyderabad, India December 2010 – June 2013

Financial Analyst, FP&A

Facilitated development of financial plans, including profits, capital spending, standard cost, and cash flow; managed assets, revenue chain, and cash; identified opportunities for reducing working capital

Served as SME for product costing by creating cost component structure and valuation variants

Extensively worked on the activity based costing module, which resulted in 15% increase in overhead cost allocation accuracy

Identified market risks and recommended process improvement which optimized capital allocation

Assisted in overall company’s gross profit by developing and presenting strategic recommendations

Analyzed Cash Flow Reporting tool to track accounts, triggering increase in time efficiency by 10%

Completed full cycle of SAP implementation while maintaining knowledge transfer with cross functional teams including creating the business blueprint and process procedural documentations

Actively analyzed and evaluated KPI’s for commodities and labor market to conduct forecast analysis which decreased costs by 3%

TCF NATIONAL BANK, Glenview, IL November 2008 – June 2010

Branch Manager, Retail Banking

Managed, trained, and directed sales and operational team of 16 employees and instituted cost control systems

Reviewed derivative contracts which required quantitative and qualitative analysis to assess the underlying claim amounts

Designed and implemented Excel templates to prepare daily/monthly account balancing and reconciliation

AMERICAN A1 CHAUFFEURS, Chicago, IL June 2007 – July 2009

Accountant

Created journal and month-end entries and accruals, updated the general ledger and prepared accounts receivable/payable and payroll and escalated inconsistencies and problems to management.

Streamlined processes for creating customer invoices

Assisted in creating financial closing reports and federal and state tax returns

Education

Kellstadt Graduate School of Business - DePaul University

MBA Major: Managerial Information Technology

Strategy, Execution & Valuation (Accounting & Finance) Exp. Graduation – May 2019

DePaul University

Bachelor of Science Major: Finance June 2008

Technical Proficiencies

Proficient in Excel (Advanced), Word (advanced), PowerPoint (advanced), Access (advanced), MS Project (advanced), MS Office (advanced), SAP R/3 4.7, SAP ECC 6.0, SAP BPC Planning, BEx Report, Crystal Reports, Prophix 10, SharePoint, MS Dynamics Navision, Ariba Corporate Purchasing System (CPS), SAP Invoice Management System (IM), Veeva, Cardinal Health SPS, Quickbooks, Hyperion (HFM), SQL Server, OM Viewer, Infopath, Visio, ACL Server, Bloomberg, Siterra, Oracle CRM Sales Prospector, PeopleSoft CRM, Peachtree, CRT Software, Lawson EMS, Workforce, Cognos TM1, ABAP Queries, Advanced Query Tool, and Oracle Financials.

Contact this candidate