A highly skilled Financial Analyst with expertise in optimizing data processing, data visualization, conducting cost analysis, and streamlining financial reporting. Bachelor’s and Master’s in Finance and Accounting. Extensive experience with a variety of computer applications.
β’ Optimizing macro performance for faster data processing, reducing execution times.
β’ Efficiently managing loaned labor invoices, ensuring accuracy, compliance, and timeliness in payments.
β’ Conduct monthly cost analysis for Warehouse and Quality operations to identify cost drivers, optimize inventory management and reduce operational expenses.
β’ Producing and analyzing weekly and monthly labor reports, offering senior leadership valuable insights into labor tracking, cost allocation, and resource utilization.
β’ Collaborating closely with finance team members to prepare accurate loaned labor invoice reviews to ensure all invoices are accurate and have supporting documentation.
β’ Streamlining and enhancing the usability of daily Excel files by consolidating multiple data sources into a single, user-friendly spreadsheet, reducing data redundancy, and increasing efficiency.
β’ Developing comprehensive financial models in Excel and transform them into interactive dashboards using Power BI, enabling senior leadership teams to gain actionable insights into company performance.
β’ Reviewed and analyzed internal allocations for SG&A departments.
β’ Built and created monthly/quarterly sector forecasts for internal reviews for FP&A.
β’ Analyzed monthly cost of finance, free cash flow and SG&A expenses for budget reviews.
β’ Forecasted monthly G&A department expenses with senior leadership via Hyperion Planning.
β’ Created multiple dashboards via Access and PowerBI for visibility sector performance via backlog orders.
β’ Coordinated and planned with G&A departments to review annual budgets for current and upcoming year.
β’ Reviewed and analyzed over $100 million weekly booked orders, cash, and revenue reports for sector performance.
β’ Created account coding for all internal labor, material, and travel needed for program usage.
β’ Analyzed current and past program financial data and performance monthly with program team.
β’ Prepared and conducted earned value management system (EVMS) reports for weekly EVMS meetings.
β’ Assisted program managers and engineers with proposal efforts on upcoming contracts and contract extensions.
β’ Prepared month-end EVMS reports that outline actual, estimate to complete, and baseline for prior and future months.
β’ Analyzed all internal labor usage reports that are distributed throughout the finance and program teams for labor reviews.
β’ Created, prepared, and analyzed monthly internal and customer variance reports to ensure all variances are explained for internal and customer understanding.
β’ Analyzed contract billing payments with senior management to determine additional cashflow entering the company.
β’ Compiled and analyzed meticulous corporate cards Excel reports to submit to senior management for decision making.
β’ Created and maintained key performance indicator process for executive management to help produce effective business decisions.
β’ Analyzed and communicated with compliance, FP&A, and accounting to ensure expenses were accurately entered into the general ledger.
β’ Delivered and assisted with all Global Business Services financial supporting documentation needed for all government compliance needs.
β’ Developed and maintained a list of COVID-19 PPE items Indirect Procurement procured throughout and after the pandemic for executive team to track.
β’ Assisted and developed annual key performance indicators for all Global Business Services departments for the executive team to use for their monthly metric meetings.