Hilda Michelle McKoy
Laurel
Summary
Dynamic Business Analyst with a proven track record at Constellation Inc, excelling in budget forecasting and financial reporting. Adept at enhancing internal controls and driving process improvements, I leverage strong analytical skills and effective communication to deliver actionable insights that support strategic decision-making and optimize resource allocation.
Overview
24
24
years of professional experience
Work History
Business Analyst
Constellation Inc
Reston
07.2024 - Current
- Work with program and project managers to develop the organization’s spend plans, affordability, and cost analysis
- Keep accurate records of available funds and planned / actual utilization.
- Review and analyze financial authorizations, acquisition records, financial history, financial activity and financial status.
- Prepare Excel spreadsheets to provide accurate portrayals of financial status and utilization for multiple component offices and programs.
- Respond to program and agency reporting requirements, including annual business case submissions and monthly updates.
- Support audit readiness and regulatory reporting for DHS and external agencies.
- Support meetings with key client teams and groups, providing insights, reporting out on analyses, and making relevant recommendations on program activities and direction.
- Document findings, decisions, and actions from meetings.
- Affordability study and findings presentation
Lead Financial Management Specialist
US Department of Transportation
Washington
03.2021 - 03.2023
- Performed work associated with various phased of planning, formulation, justification, presentation execution, analysis and review of the multi-year Chief Information Office Working Capital Fund (WCF) budget.
- Verified and updated operational plans to capture the changing in organization financial needs.
- Worked with program and project managers to develop the organization’s spend plans, affordability, and cost analysis.
- Updated Financial System with obligations, costs, revenue and interfund transactions with the Office of Financial Management’s guidelines for each budget formulation and operation plan iteration.
- Reviewed and analyzed financial authorizations, acquisition records, financial history, financial activity and financial status.
- Prepared monthly revenue and Cost Estimates. Keep accurate records of available funds.
- Reviews Work Order in preparation for the development for each quarterly OPPLAN.
- Wrote and edited budget justifications and narratives.
- Prepared PowerPoint presentations to communicate financial program status, planned milestones and outstanding issues for multiple programs to internal and external stakeholders.
- Forecasted long‐range program costs, obligations, and revenue for the multi‐year OCIO WCF budget.
- Reviewed the current budget baselines based on customer service consumption, customer revenue, cost models, and IT systems reports, for accuracy, reasonableness, and continued relevance.
- Served as the financial point of contact for the agency Enterprise Infrastructure Solutions transition.
- Maintained meeting minutes and findings for further reference and actions.
- Developed and maintained system user guides and standard operating procedures (SOPs).
Program Manager/Senior Business Management Analyst
Integrated Finance and Accounting Solutions (IFAS)
Woodbridge
11.2016 - 03.2021
- Served as Customer Liaison for customer financial questions and problems.
- Planned, organized and directed team workload.
- Primary interface between program offices and IT/Telecommunication Coordinators for each Operating Administration (OA).
- Interfaced with Contracting Officer Representative (COR) regarding pricing and related billing and budget issues.
- Respond to program and agency reporting requirements, including annual business case submissions and monthly updates.
- Liaison with ITSS, RMO and IT Customers to analyze workorders, cost estimates and inconsistencies in customer billing.
- Assisted in billing projects to ensure and maintain internal controls, accuracy of data and adherence to methodologies.
- Evaluated overall budget and spending variances and made recommendations to Senior Management.
- Received, reviewed and reconciled contract invoices against obligations.
- Created, reviewed and validated Estimates to Complete (ETC) forecasts for vendors.
- Reviewed procurement packages to include IGCEs, as required.
- Assisted the COR in managing and administering contract(s) recommending contract modification, change orders or task orders as required.
- Monitored budget execution to ensure funds are obligated in a timely fashion and according to the regulations of a CR (Continuing Resolution) when applicable.
- Provided data analysis and presentations as needed in Excel Spreadsheets, PowerPoint and Word.
Functional Analyst
U.S. Department of Veterans Affairs
05.2016 - 11.2016
- Analyzed business processes and internal controls to identify risks.
- Used a risk-based approach to determine when to test key controls.
- Determined the validity of the controls through addressing the relevancy of the assertion and/or the program risk.
- Conducted gap analyses and identify recommendations to help clients improve internal controls, accounting procedures, and ensure compliance with government accounting policies and procedures.
- Developed Enterprise Risk Management Plans, in accordance with OMB Circular A-123.
- Prepared findings and recommendations for corrective action through improvements to business practices, policies, and procedures.
- Developed corrective action plans (CAPs) to address significant or material.
- Tested compliance against published policies and procedures; review internal control systems and frameworks to assess reliability, effectiveness and audit readiness.
- Performed quarterly travel and purchase card process reviews and make recommendations to improve process and compliance.
- Prepared presentations and briefings, and actively participate in client meetings and day-to-day interactions using Excel graphs and tables, PowerPoint presentations.
Senior Financial Analyst
SOA Financial
Lanham
08.2015 - 04.2016
- Monitored operating spending versus appropriate budget.
- Developed spreadsheets to monitor key drivers using pivot tables, conditioning functions, scenario analysis.
- Conducted monthly team meetings to review budgets and coordinate department spending activities.
- Created and regularly updated supplier inventory and profile including key information related to the supplier relationship (CRM).
- Utilized tools like SWOT analysis to compare suppliers.
- Processed invoices for billing.
- Reviewed and approved purchase orders for supplies, equipment and contractual services.
- Recorded accruals and projected monthly spending.
- Provided reports to management for financial planning including PowerPoint presentations with charts and graphs.
- Developed narrative justification to support funding request and reprogramming.
- Initiated work teams to resolve issues and produce work process improvement.
- Assisted the CFO in the development, execution and monitoring of the short and long-term work plan.
- Managed and evaluated the progress of the unit toward meeting goals and makes adjustments in objectives, work plans, schedules and commitments of resources.
Director of Finance and Human Resources
Peterson Institute for International Economics
Washington
08.2008 - 03.2014
- Responsible for analysing and initiating modifications to the annual operating budget and maintained accurate records of all modifications to various programs and individual grants budgets.
- Managed million investment portfolios.
- Provided oversight and management of all financial functions of the company, reporting to the president and deputy director.
- Supervised staff performing daily accounting functions; monthly, quarterly, and annual closing of the general ledger; preparation of budget to actual financial reports.
- Prepared Semi-annual internal financial statement to auditors required by bond covenant.
- Coordinated preparation for and execution of annual company audit and financial statements using Generally Accepted Auditing Standards (GAAS).
- Supervised fiscal reporting, contract reviews, and agreement renewals with government agencies, private foundations, and corporations to ensure accuracy and compliance with funding guidelines.
Senior Accountant
Peterson Institute for International Economics
Washington
01.2002 - 08.2008
Education
Master Business Administration - Financial Management and Information Systems
University of Maryland University College
Adelphi, MD12-2016
B.S. - Accounting
Fayetteville State University
Fayetteville, NC05-1994
Skills
- Microsoft Office
- Budget forecasting
- Spend planning
- Financial reporting
- Risk assessment
- Process improvement
- Excel
- MS Word
- PowerPoint
- Publisher
- Microsoft Teams
- SharePoint
- PRISM
- Delphi ESC
- AWS Billing Portal
- Power BI
- Effective communication
- Problem solving
- Attention to detail
- Team collaboration
- Decision making
- Decision-making
- Clear communication
- Staff management
Business Applications
- Microsoft Office (Excel, MS Word, PowerPoint, Publisher, Microsoft Teams, SharePoint)
- PRISM
- Delphi ESC
- AWS Billing Portal
- Power BI
Timeline
Business Analyst
Constellation Inc
07.2024 - Current
Lead Financial Management Specialist
US Department of Transportation
03.2021 - 03.2023
Program Manager/Senior Business Management Analyst
Integrated Finance and Accounting Solutions (IFAS)
11.2016 - 03.2021
Functional Analyst
U.S. Department of Veterans Affairs
05.2016 - 11.2016
Senior Financial Analyst
SOA Financial
08.2015 - 04.2016
Director of Finance and Human Resources
Peterson Institute for International Economics
08.2008 - 03.2014
Senior Accountant
Peterson Institute for International Economics
01.2002 - 08.2008
Master Business Administration - Financial Management and Information Systems
University of Maryland University College
B.S. - Accounting
Fayetteville State University
Similar Profiles
Kaytone MCDUFFUS-MENDEZKaytone MCDUFFUS-MENDEZ
Kitchen Porter at ConstellationKitchen Porter at Constellation
Kaeden LippKaeden Lipp
Intern - Rapid Response at Constellation EnergyIntern - Rapid Response at Constellation Energy
CHRISTOPHER RAY THOMSENCHRISTOPHER RAY THOMSEN
Nuclear Security Lead at Constellation Nuclear Security LLCNuclear Security Lead at Constellation Nuclear Security LLC
MICHAEL THODEMICHAEL THODE
Sales Consultant at FreshPoint Mid-AtlanticSales Consultant at FreshPoint Mid-Atlantic
Zyon JohnsonZyon Johnson
Classified Inventory Control Technician / Library Technician at Chenega Corporation - Naval Surface Warfare CenterClassified Inventory Control Technician / Library Technician at Chenega Corporation - Naval Surface Warfare Center