Senior Business Analyst Resume Profile
GA
Summary:
- Over 12 years' experience in Financial Management in Accounting and Financial Planning Analysis FP A .
- Project Management experience with project tracking, budget estimates, and analysis to ensure alignment of project scope. In addition to daily to weekly status reports displayed in Excel, PowerPoint, and Dashboards.
- Data Warehouse experience for analysis, maintenance and reporting in SQL, Access, and Business Objects.
- Developed, implemented and maintained annual budget, sales by project, business unit, and cost centers. This included monthly and annual forecasting, in addition to variance analysis reports. Leadership role in financial analysis, planning for business units and month-end process.
- Execution of the Sarbanes Oxley Section 404 at MCI acquired by Verizon . Assisted with the SOX implementation, in addition to the design of controls, documentation, testing, using corrective actions, and reporting results to management.
- Over 5 years' experience as a functional user of Hyperion Essbase, and Oracle Hyperion Enterprise.
- Led a Process Improvement team of 5 to reduce operating expense by 25 .
- Established a new planning model and management reporting system to improve availability and accuracy of the financial data, triggering a 40 increase in accuracy.
- Exceptional oral and written communication skills, self-starter, quick learner, and the ability to perform effectively within deadlines in a fast pace environment.
TECHNICAL SKILLS:
Business Object database BOXi , Microsoft Access, and SQL for the creating, updating, modifying and retrieving data. Proficient in Microsoft Windows 2003, 2007 2010 in Excel Pivot Tables, v-look ups, and financial models , Word, PowerPoint, and Visio. Skilled in Hyperion Budget/Planning application, SharePoint, Sales force, and Close App. Knowledgeable in working in Accounting Software systems such as Oracle 10 11i, SAP, JD Edwards, Microsoft Dynamic NAV and PeopleSoft.
PROFESSIONAL EXPERIENCE:
FINANCIAL BUSINESS ANALYST
Confidential
- Manage the financial analysis for the Division of Child Support Services, Division of Family and Child Services, and the Division of Aging Services in the Information Technology Division.
- Ongoing monitoring and auditing of spend reporting data and processes for compliance and adhere to policies and processes.
- Forecasting monthly and quarterly expenditures for the Operational Technology Information division.
SENIOR FINANCIAL BUSINESS ANALYST Confidential
- Forecasted the long term incentives and global markets in Argentina, Belize, Chile, Mexico, and Peru.
- Provided insight for projects such as payroll, bonus calculations, base compensation, stock option, and the executive compensation section for the 10-K filing.
- Developed a set of analytical resources, meaningful reporting, and methodologies to enhance decision-making. In addition to updating dashboard and scorecards.
- Automated reports utilizing Microsoft Excel and Microsoft Access for Consolidating the Markets.
- Maintained the accuracy and confidentiality of global operations work and database.
SENIOR FINANCIAL ANALYST, FP A Confidential
- Collaboration with the CFO and VP of Finance to develop financial strategic business plan for revenue, sales, margin, direct expense, headcount to incorporate into the forecast/budget model.
- Prepared management reports and commentary for presenting to management. The reports included a comparison of actual versus plan results and various performance metrics to the annual budget, and forecasting. Performed ad-hoc financial analysis to facilitate strategic and tactical decision-making.
- Performed financial analysis and reports for the sales organization and cost centers.
- Developed a Sales model to help manage the different sales channel for the Product Line Division.
PROGRAM FINANCIAL ANALYST Confidential
- Lead Business Analyst communicating the project scope and direction to management and team.
- Recorded, tracked and reconciled GSA schedules related procurement fees.
- Planned and direct workflow to ensure timely processing and payment of vendor invoices. In addition to consulting or resolving in the issues with the vendors.
- SQL data ad-hoc reporting to analyze day-to-day business need.
- Prepared monthly cost reports identifying procurement trends, and projection of cash flow.
- Ensured federal spending was aligned within project scope and Federal Acquisition Regulation FAR .
- Measured results against plans vs. actual and tracked the status of government approval of funding.
- Assisted with the analysis of the supply chain and quality data, including but not limited to purchase orders, invoices, material rejection, pricing, change management request, and Build of Material BOD .
FINANCIAL BUSINESS ANALYST Confidential
- Responsibilities included calculating and presenting the CAP Modification for the Making Homes Affordable Program MHA to the Department of Treasury.
- Daily utilization of Microsoft Excel for day-to-day business and financial reporting and analysis.
- SQL and Business Objects data updates and retrieval to analyze and report loan products by servicer.
- Assisted with reviewing, testing, and validating external customer servicers' loan information by comparing with the information that was in the HAMP IR2 system for validation.
- Responsible for processing and validating request related to suspension of disbursements.
- Demonstrated a strong use of technical and business skills.
- Managed dashboard for the different MHA loan products disbursed for servicer funding.
- Assisted with automation of critical processes to ensure efficiency, accuracy and data quality.
SENIOR FINANCIAL ANALYST Confidential
- Managed the Confidential division. Providing the overall direction and leadership for the design, implementation, and management of the financial forecast and budget processes.
- Delegated as the key finance person for the IT, legal affairs, sales and marketing group.
- Served as the primary interface to assist with cost control, monthly management reporting of actual results versus plan, revenue and expense forecasting.
- Responsible for flash report, providing clear and concise variance explanations as well as ongoing assessment of permanent versus timing impact of periodic variances.
- Performed Revenue Recognition based on SOX requirements SOP 97-2, and the EITF Issue 00-21.
- Assisted with identifying opportunities for sales, margin growth, product pricing and cost reduction benefits.
- Assisted in the contract review and negotiation process by analyzing terms that could be 'red flagged'.
FINANCIAL ANALYST Confidential
- Managed and coordinated ongoing financial communication to management by providing financial sales metrics analysis e.g., revenue performance, profit margin analysis of sales productivity, rate/volume/mix of the different revenue streams and provided explanations to variances .
- Developed financial analysis for different sales business units with what if scenarios and forecasting.
- Provided quantitative analysis such as comparative, seasonal variation, actuals vs. plan for different product levels web, wireless, long distance, video, and etc.
FINANCIAL BUSINESS ANALYST
Confidential
- The responsibilities included documenting processes, testing, and corrective actions and reporting results to management.
- Process improvement implementation by surveying existing controls and analyzing the business needs to help identify risk in order to provide effective solutions.
- Provided training to process owners to ensure full and complete understanding of their responsibilities related to key controls.
- Testing data in Access, Excel, Hyperion Essbase, and MCI's accounting software SAP.
- Isolated system problems and coordinated with IT for resolution.
- Department process improvement by identifying challenges and opportunities by using analysis to make strategic or tactical recommendations.
- Assisted with internal and external audits.
TEAM LEAD/SENIOR ACCOUNTANT / FINANCIAL ANALYST
Confidential
- Supervised a team of five, duties included reviewed staff bank and sub ledger reconciliations, payroll, accounts payable and fixed assets.
- Special Project of improving operational efficiency of finance systems by 10 through implementation of streamlined data management procedures.
- Reported financial results on a monthly basis to upper management.
- Responsible for reporting budget versus actual analysis during operational review meetings.
- Ensured accuracy of the general ledger, month-end close activities including journal entries, adjustments, accruals, account reconciliations, cash reconciliation and expense reports.
