Sr. Financial Business Analyst Resume
New York, NY
SUMMARY
Financial Professional with extensive experience analyzing and applying data to enhance management reporting and decision - making. Adept at extracting data from various accounting and information systems to perform comprehensive financial, cost, and trend analyses for management reports. Skilled at developing analytical tools and identifying areas of inefficiency and implementing corrective actions to reduce capital spending and minimize risk to support growth and stability.
EXPERTISE IN:
- Financial Planning & Modeling
- Team Leadership & Development
- Process Reengineering/Automation
- P&L Management & Accountability
- Executive & Board Presentations
- Risk Management
- Budgeting, Planning & Forecasting
- Technology Implementation
- Monthly & Quarterly Close
- Variance/Financial Analysis
- Cost Reduction Strategies
- Federal, State & Local Tax Filings
- Consolidated Reporting
- Audit Management & Support
- M&A Due Diligence
TECHNICAL SKILLS:
Experience with general ledger accounting and financial analysis
Exceptional knowledge of financial analysis practices, principles, applications and analysis methods
Knowledge of accounting, financial reporting (US GAAP) and data analysis
Advanced in Excel (Pivot Tables & V Lookups), Power Point, Access, SAP, Khalix, CRM, People Soft, JD Edwards, Hyperion Essbase, Bloomberg, Salesforce, SharePoint, APS, SQL
PROFESSIONAL EXPERIENCE:
Confidential, New York, NY
Sr. Financial Business Analyst
Responsibilities:
- Built more flexibility into stress testing process so that assumptions can be revised, refined or updated with relative ease to adapt to business and market changes, additional behavioral insights and enhanced data feeds
- Worked closely with stakeholders to assess current state, perform gap analysis, and develop requirements for business process, capability and technology infrastructure enhancements to support the creation and management of stress testing scenarios
- Produced annual budgets exceeding $500 million and forecast models on a departmental, business segment and consolidated basis working with functional department heads and senior management
- Gather business requirements from the client for various website content management, and SharePoint projects
- Coordinate with senior leadership, external affairs staff, and component representatives to create & manage company’s website content (for Public & Intranet sites)
- Assist with writing, editing, proofreading, publishing, and tracking the website content
- Developed customanalyticreports for increased effectiveness based on data analysis for project headcounts, seat utilization, work patterns. Was responsible for analysis, reporting and budgeting of headcount
- Extensive data cleansing and analysis, using pivot tables, formulas (v-lookup and others), data validation, conditional formatting, and graph and chart manipulation
- Used Excel pivot tables to manipulate large amounts of data in order to perform data analysis, position involved extensive routine operational reporting, ad-hoc reporting, and data manipulation to produce routine metrics and dashboards for management
- Documented business rules and workflows using Business Process Modeling Notation (BPMN) Version 2.0.
- Created training materials and delivered the training for various different team
- Established periodical presentations to Management Board, demonstrating the groups' major business developments
- Created, analyzed and documented user requirements, procedures, and policies to optimize the use of technology to align with business strategies. Documentation included user processes, customized configurations for core system and third party applications, and application user manuals
- Managed a team of business analysts to provide a client perspective and understanding of IT and Finance projects companywide focused on the enhancement of the firms proprietary operating software
- Provided ongoing training and support for reporting, planning and analysis tools
- Prepared materials for senior management presentations for the Board of Directors and assisted with preparing annual reports, financial statement forecasts and variances
- Compiled data to generate financial statements including cash flow, P&L, and balance sheet for review by management
- Responsible for consolidation and reporting of metrics, KPIs and scorecards to support the CCAR/Capital Planning process
- Experience working on regulatory reporting requirements such as FRY-11, FRY-9C, FRY-14Q & FRY-14A reports
- Trained and supervised co-workers during the monthly FP&A process
- Analyzed operating expenses compared to budget, forecast, and prior month and prepared reporting to functional budget owners and other levels of management
- Managed a team of Sr. Financial Analysts and Financial Analysts and oversaw monthly reporting functions
- Development of regulatory reports using AXIOM
- Developing reports using AXIOM objects i.e. DataSource
- Used Axiom SL data management platform to configure, modify, and support data objects
- Prepared and executed internal reports with Axiom services
- Developed Reports in AXIOM Controller View and mentoring and guiding team members for reports
- Overall responsibility for budgeting, forecasting, ad-hoc analysis, and business plans that ensured conformance with GAAP and company accounting policies
- Responsible for drafting and maintaining process flows for CCAR/Capital Planning activities in partnership with Capital Planning & CCAR Work streams
- Played a crucial role in delivering business and gap analysis, documentation of current & future state workflows, prepared business scope and requirements document, provided end-user training in the OMS system for fixed income traders and IMS operations, prepared test scripts for end user testing, participated in systems testing for downstream impacted systems and coordinated UAT
- Gathered requirements by using interviews, observation, JAD, brainstorming sessions, and document analysis
- Co-authored business requirements document with project teams. Extract, discuss, and refine business requirements from business users and team members
- Collaborated with HR, Corporate Finance, Time Reporting, etc. to develop end-to-end processes for the conversion of a Legacy System to SAP
- Developed and analyzed documentation and processes to support SAP daily operations
- Coordinated and tracked SAP training records for all employees
- Implemented SAP by working with the SAP installation team, with primary responsibility for design and implementation of Costing and Financial modules for the division
- Played instrumental role in setting up accounts for new SAP Financial structure
- Analyzed user problems, including automated and manual business processes and identified, researched, investigated, defined and documented business processes
- Provided business process guidance to development team Perform quality assurance testing and obtain business sign-off Responsible for developing and managing project scope to ensure project solution was delivered to customer on time and within budget
- Analyzed business needs and developed functional requirement specifications Responsible for managing staff activities, client expectations, controlling and monitoring project tasks and schedules
- Managed projects to assure objectives / deliverables are met on time and within budget Ability to resolve conflict and negotiate solutions where necessary
- Coordinated and perform project management training to support the PMO Extensive hands on experience with Requirements, Design, Construction, Testing and Implementation phases of software development
- Responsible for facilitating and recording client discovery sessions Responsible for identifying and managing project scope Exceptional skills identifying and managing functional requirements Developing and validating use cases/user stories Documenting key content deliverables (Requirements & Functional Design Docs, test scripts, UAT sessions and Acceptance Report, Training Materials) Responsible for communicating status to project managers, team members and management Work with technical teams to create and maintain test plans Perform quality assurance (QA) testing and sign-off of assigned software functionality Write business and functional specifications according to functional requests
- Prepared reconciliations of regulatory reports to the general ledger
- Effectively implemented projects by collaborating with line-of-businesses and model risk management
- Coordinated the aggregation and prioritization of system limitations and data issues that arise through the end-to-end process for CCAR regulatory reporting
- Maintained database to support team in tracking and reporting for regulatory purposes
- Supported team with various ad-hoc and ongoing CCAR projects to aid in ensuring all key deliverables are completed in a timely manner
- Responsible for evaluating businesses' operating and financial results, identify trends and provide actual costs variance explanations
- Generated month-end financial reports using SAP and BPC and facilitated account closing procedures each month
- Responsible for monitoring and managing the monthly variance analysis explanations (P&L and Balance Sheet) effectively communicate any significant findings to senior management
- Responsible for reviewing and posting into SAP the preparation of over 500 monthly intercompany journal entry transactions
- Maintained communication with key individuals for SOX/Internal Controls status updates, issues, resolutions, etc.,including but not limited to the Corporate Controller, and the CFO
- Oversaw the coordination and preparation of documents to be filed with the SEC, including Forms 10-Q, 10-K and 8-K
- Developed reports for top management summarizing the business financial position in areas of income, expenses, capital usage and cash flows, and coordinate the preparation of strategic plans, budgets and financial forecast through Power Point
- Prepared financial statements, including Balance Sheet, Cash Flow and P&L statements and prepared detailed variance explanations verses budget and current estimate to relate to upper management
- Made sure all reporting was in compliance with Sarbanes-Oxley guidelines and GAAP
- Provided extensive data and systems analysis in support of all Education Asset Management and Product Information Management functions, which included documenting functional requirements, use cases, data definitions and business rules
- Maintained SharePoint Management directories to facilitate communication with project teams and management, expediting access to critical information
- Lead system integration analysis, requirement analysis, design, testing, and support and debugging activities with key business and technical stakeholders including architects, developers and analysts
- Streamlined process on assigned projects to ensure quality research, development of system design and efforts resulted to endow with more effective solutions
- Created Balance sheet forecasting models / CCAR base on economic variables
- Ensured the accuracy of the month-end closing process, performance calculations and client reporting by designing and implementing control procedures
- Monitored issues, trends, and developments through the review of internal risk management reports, regulatory filings, regulatory surveillance results, regulatory examination reports and work papers
- Developed, supervised, evaluated, monitored and implemented Liquidity, Operational and Enterprise risk assessment procedures, change management practices, internal and external risk monitoring program and controls assessment
- Developed strong relationship with key stakeholders and business partners by addressing issues/concerns in timely manner
- Assisted in identifying and evaluating risk areas across the Liquidity, Operational and Enterprise risk activities
- Reported Liquidity, Operational and Enterprise risk issues to senior management on regular basis
- Detected, assessed, tracked and mitigated risks related to Liquidity, Operational and Enterprise risk
- Analyzed changes in stress testing results and coverage ratios at the Enterprise, Legal Entity and Line of Business levels
- Reviewed and refined liquidity stress testing practices, methodologies, and assumptions with proper documentation and supporting analytics on an ongoing basis
- Produced reports and presentations on Liquidity, Operational and Enterprise risk related incidents, reviews and measures
- Participate in month-end close reviews of various legal entities including the review of original reconciliation work produced by various groups to ensure all balances have been accurately reconciled & appropriately classified under US GAAP
Confidential, Stamford, CT
Senior Financial Business Analyst-Consultant
Responsibilities:
- Determining financial objectives. Designing & implementing systems, policies & procedures to facilitate internal financial control
- Develop management tools to measure and analyze financial and operational information (e.g. financial ratios, key performance indicators, sales forecasting platform, integrated budget model, product pricing, and management reports)
- Maintained, updated the statutory filing procedures, and improved the process
- Created sound financial models, cash flow projections and business case for new business prospects; introduced derivative based opportunity valuation technique to improve decision making
- Developing reports for top management summarizing the business financial position in areas of income, expenses, capital usage and cash flows, and coordinate the preparation of strategic plans, budgets and financial forecast through Power Point
- Monthly reporting for financials, expense allocations and headcount in Excel and Power Point
Confidential, New York, NY
Senior Financial Business Analyst-Consultant
Responsibilities:
- Developed master internal and external Product hierarchy(ies) for Commercial, Consumer and Liquidity Liability portfolio by determining the lowest common denominators or attributes
- Prepared timely and accurate monthly financial reports including expense and staff analysis reports, SEC reports, variance analysis, ad hoc reports, and other financial modeling support (CBAs) to determine the financial impact
- Prepared and or reviewed certain US GAAP and where appropriate, IAS top-side entries relating to certain North America legal and or reporting entities through SAP
Confidential, New York, NY
Senior Financial Business Analyst-Consultant
Responsibilities:
- Prepared financial reporting, ad hoc analysis, and develop budgets and quarterly forecasts in Hyperion
- Developed financial reports for forecasting, trending, and results analysis through Excel, Power Point, Access and Hyperion
- Prepared monthly reports through Excel Pivot Tables and analyzed revenue
- Developed and edited various Power Point presentations for financial reporting
- Collaborated with peers in Finance to perform ad-hoc analysis to explain variances versus Budget, prior forecast and prior months
Confidential, Franklin Lakes, NJ
Senior Financial Business Analyst-Consultant
Responsibilities:
- Prepared PowerPoint presentations for each department for financial reporting and variance analysis
- Generated detailed financial and operational projections (i.e. revenues per region and product, expenses per headcount, expenses per department and project) with Excel, MS Access and Hyperion
- Analyzed and interpreted monthly variances and trends between budgets, actual and prior results in developing projections and forecast in Hyperion
Confidential, New York, NY
Senior Financial Business Analyst-Consultant
Responsibilities:
- Completed migration for all Primary, Reporting and Statutory ledgers from Corporate General ledger to new Capital ledger through SAP
- Ensured the completeness & accuracy of the Notes to Financial Statements as well as supporting schedules and exhibits in Statutory filing
- Posted revenue to the balance sheet through SAP, People Soft and O&A Loads
- Communicated to Business Units and internal firm-wide stakeholders on costs, efficiencies, metrics on a monthly/quarterly basis
- Monthly close activities (accruals, reclassifications, pre-paids, etc.) Variance Analysis Reporting through Power Point
- Made sure all reporting was in compliance with Sarbanes-Oxley guidelines and GAAP
Confidential, New Rochelle
Owner/CFO
Responsibilities:
- Analyzed and explained daily reports, determined reasons for change in Risk and P&L
- Performed ROI analysis for areas of investment and additional ad-hoc financial analysis
- Analyzed trading patterns and behaviors to support the business and helped identify potential fraudulent or unusual trading activity
- Performed and conducted regular audits and analysis of change control requests
- Responsible for developing standard metrics reporting, creating management presentations and automated data models
- Built operational models for forecasting and planning to support strategic decision making
Confidential, Bronx, NY
Financial Business Analyst
Responsibilities:
- Responsible for weekly, monthly, and quarterly reports for both internal and external distribution
- Responsible for developing expense budgets, forecasts and conducting variance analysis
- Provided financial oversight and administered financial aspects of co-development program activities with external partners and internal development team members
- Analyzed invoice auto-match rates to identify performance drivers as well as trends on low match rates
- Provided system support and analysis including spreadsheet and database analysis