Financial Analyst Resume Profile
SUMMARY
Over 15 years of professional consulting experience in the federal government, financial services, and education industries. Skilled in the areas of change management, organizational development, strategic planning/analysis, business process re-engineering, project management, functional requirements gathering/analysis and quality assurance. Successful initiatives include Financial and Human Resources ERP implementations, web development and product development projects. Proven ability to identify and implement business process improvements and system automation to increase quality, efficiency and productivity. Successful in balancing multiple projects with competing priorities using creative, innovative thinking and operating in both a strategic and tactical level.
TECHNICAL EXPERIENCE
- Microsoft Excel
- Microsoft Access
- Microsoft Word
- Microsoft Project
- Microsoft Power Point
- Requisite Pro
- PVCS Tracker
- PVCS Version Manager
- JIRA
- ClearQuest
- Test Director Quality Center
- Erwin
- Oracle Designer
INDUSTRY EXPERIENCE
- Requirements Definition
- Systems Analysis Design
- Systems Development
- Quality Assurance QA
- Systems Training and Documentation
- Configuration Management
- Project Management
- Project Estimating Risk Mgt
- Change Management
- Financial Reporting
- Revenue Analysis
- Budget/Variance Analysis
PROFESSIONAL EXPERIENCE
Business System Analyst
Confidential
- Providing functional expertise to Corporate Systems and Program Management departments across various COTS and custom development and implementation projects
- Managing development and implementation of enhancements to PeopleSoft 9.1 Financials and Human Capital Management HCM leveraging new system functionality to streamlines business processes to increase efficiency and productivity of users
- Led requirements definition and QA of PeopleSoft 8.8 Financials and HCM upgrade to 9.1 that introduced additional system functionality to be leveraged by Finance and HR Departments to improve operations
- Led requirements definition and QA of PeopleSoft 8.8 Financials and HCM implementation that introduced system automation to improve data quality and streamlined business processes that improved efficiency
- Developed Request for Proposal for implementation services for PeopleSoft 8.8 Financials and HCM
- Developed Cost Benefit Analysis of COTS vendors for ERP Financials and HR system
- Developed functional requirements for ERP Financials and HR system
- Developed As-is and To-be Business Process models for ERP Financials and HR system
- Led implementation of SAP's Budgeting, Planning and Consolidation system including integration with PeopleSoft 8.8 Financials
- Led QA of mba.com website redesign that included the implementation of Identity Management System
- Developed functional requirements for Identity Management System to track and manage users of GMAC's websites, mba.com and gmac.com
- Developed Request for Proposal for design services for gmac.com website redesign
- Developed detailed systems requirements for gmac.com website redesign
- Led system and user acceptance testing of gmac.com redesign
Business System Analyst
Confidential
- Nuclear Regulatory Commission
- Gathered data through document review and interviews with stakeholders to identify deficiencies and opportunities for improvement for core business processes
- Developed recommendations to streamline the processes and gain process efficiencies
- Department of Treasury
- Led the analysis phase of the system development lifecycle to gather functional and technical requirements for the collections system
- Led and executed the testing of several enhancement releases of the collections system
- Provided functional and technical knowledge of the collections system to the Operations Maintenance technical team
- Department of State
- Gathered data through document review and interviews with stakeholders for development of the As-is model
- Analyzed the existing processes and data gathered from the stakeholder interviews to identify deficiencies and opportunities for improvement for development of the To-be model
- Developed As-is and To-be process models for key business processes
- Developed list of recommendations to streamline and rationalize these processes
- Developed action plan to implement recommendations
- Pension Benefit Guaranty Corporation
- Managed a team of 5 developers
- Managed all aspects of the development lifecycle including requirements gathering and analysis, system design, coding, testing, integration, documentation, configuration management, and change management of system enhancements
- Managed the deployment of systems enhancements using PVCS Tracker, PVCS Version Manager, and Peregrine Service Center
- Developed an analysis of vendor software demonstration strengths and weaknesses
- Developed a System Model for revenue system including a Data Flow Diagram, Logical Data Model, Data Dictionary, and CRUD Matrix
- Developed As-is and To-be Business Process models
- Developed detailed functional design for revenue system
- Department of Justice
- Prepared a comprehensive evaluation of the Commercial-Off-The-Shelf COTS solution for a Debt Collection System through an evaluation of system functional and technical requirements
- He prepared a comprehensive evaluation of the Commercial-Off-The-Shelf COTS solution for the Debt Collection System through an evaluation of the DOJ Comprehensive Requirements Definition CRD requirements
- He evaluated the COTS alternative against the core requirements, as well as considered how well this solution meets all requirements identified in the DOJ CRD.
Business System Analyst
Confidential
- Provided Program Management support for an IT program including budget cost, acquisition management, and project management control
- Managed and maintained the Program Management database that tracks budgets, contractor burn rates and projections against the approved budget, and program financial figures
- Developed monthly financial reports, quarterly program status reports, and any ad hoc budget/financial reports requested
Business System Analyst
Confidential
- Analyzed business rules, workflow and processes for the Thrift Savings Plan TSP system
- Defined TSP system requirements
- Completed Gap Analysis between TSP system requirements and the commercial-off-the-shelf package
- Developed a Project Management Database to support a Capability Maturity Model Software Process Improvement project including requirements definition, analysis design, coding, and testing of the database
- Managed maintain PM Database including creating queries reports required by the SPI project ad hoc reports defined by the SPI Project Manager and Senior Management
- Facilitated weekly SPI Project Management meetings
- Provided Senior Management with monthly Project Status, Project Control Reporting, and Project Estimation Risk Management reports
- Created queries to integrate PMO Database and accounting software
- Defined client reporting requirements resulting report definitions
- Developed monthly financial and status reports based on client requirements
- Developed PMO Database documentation and training materials
- Provided conversion system analysis and design
Financial Analyst
Confidential
- Completed functional analysis of financial system in advance of a data conversion
- Analyzed functional problems related to a system data conversion and successfully resolved the problems
- Prepared monthly financial reports and reviewed with upper management
- Prepared and analyzed weekly and monthly revenue forecast data versus actual
- Tracked and analyzed revenue against unbilled accounts receivable on current revenue generating projects, then made end of month revenue adjustments based on the analysis
- Developed pricing models in support of proposals
- Developed project budgets and forecasts for potential contracts
- Managed billing and contract modules in cost accounting system that included contract set-up, billing and contract modifications, and revenue reports
- Created queries to extract key financial figures, analyzed results and reported results to upper management
- Trained and supported Staff Accountants with general accounting principles and issues
Financial Analyst
Confidential
- Analyzed monthly revenue figures, prepared revenue and profit analysis for Chief Financial Officer
- Analyzed monthly revenue figures and performed monthly variance analysis of forecast data versus actual
- Managed billing and contract modules in cost accounting system that includes contract set-up, billing and contract modifications, and revenue reports
- Developed implemented fixed asset inventory and tracking systems
- Prepared month end accrual entries
- Prepared and managed contract billings and supporting schedules
Staff Accountant
Confidential
- Assisted Senior Financial Analyst in preparing monthly financial statements and Profit and Loss reports
- Prepared and maintained monthly project revenue reports
- Managed and maintained cost accounting system and databases
- Developed financial model to track and analyze general ledger accounts
- Prepared and managed client billings and supporting schedules
Sports Production Intern
Confidential
- Charted game film sporting events including National Basketball Association playoffs and World Cup 1994
- Edited game film with executive producers to appear on nightly news
- Assisted sportscasters in field work assignments including Washington Redskins' scrimmage
