Our certified professionals have extensive experience implementing large, complex public sector programs; helping clients solve their most pressing financial and business management challenges, and implementing proven leading-edge technology solutions that enable them to operate more efficiently while minimizing risks and costs. Our associates are certified in their respective areas of expertise – Certified Public Accountants (CPAs), Certified Government Financial Managers (CGFMs), and Project Management Professionals (PMPs). They have demonstrated their expertise in implementing large Enterprise Resource Planning systems (ERPs) – including Oracle Financials, PeopleSoft, and custom enterprise-wide Information Technology (IT) solutions.
Our Proven Success
Our professionals have led or supported successful enterprise-wide technology and program management solutions for a variety of government clients.
- HUD New Core Financial System
U.S. Department of Housing & Urban Development (HUD) New Core Financial System
New Core Interface Solution (NCIS)
2ndWave designed and developed NCIS as part of HUD’s New Core migration project to move the agency from HUD’s core financial and key administrative system – HUDCAPS, HUD Central Accounting and Program System – to the Department of Treasury’s ARC Shared Service Financial Management solution. This large program represents the first adoption by a Cabinet-level Department of a financial shared services solution.
2ndWave designed and developed the software following HUD’s PPM v2.0 methodology. As part of integrating HUDCAPS to ARC’s Oracle Federal Financials solution, we developed all of the financial crosswalks and coordinated budgetary and proprietary transactions from HUD feeder systems to the core financial management system. The solution was delivered in releases, all on time and within budget, culminating with HUD’s go-live to ARC’s system in October 2015. We continue to support the solution through operation and maintenance as we prepare for new releases.
Enterprise Data Warehouse
2ndWave is also responsible for designing the New Core Enterprise Data Warehouse (NCEDW), which will replace an existing data warehouse and will be designed to work with the new ARC/Oracle solution and the new HUD accounting code string that the ARC/Oracle solution will support. NCEDW will provide financial and managerial reports throughout the department in a modernized environment that supports pre-defined, ad-hoc, and scheduled reports. The NCEDW will also be designed to provide drill-down querying capabilities, and eventually will provide the capability for data analytics and dashboards using HUD’s financial, managerial, and accounting data.
Development Application Processing (DAP) System
2ndWave provides operations and maintenance to support to this Multi-family Housing system that provides pre-endorsement information for underwriting new financing instruments. The system supports HUD users in regional offices across the country and at headquarters as well as lenders. Our consultants support day-to-day operations with trouble-shooting and customer data support. We are currently working to modernize the system from its current obsolete PowerBuilder and Sybase architecture to a modern, cloud-based J2EE platform using an Agile-based approach.
- GNMA Financial Accounting System and Loan Level Accounting
GNMA Financial Accounting System (GFAS) & Loan Level Accounting (LLA)
PeopleSoft core accounting systems support and requirements analysis
2ndWave Consultants provide Operations and Maintenance Support to GNMA’s PeopleSoft-based core accounting system. GFAS supports the financial functions required to process payments and receipts, track financial events, and provide for government financial management and reporting per OMB and GAO requirements.
2ndWave Consultants are using the HUD PPM 2.0 methodology to lead requirements definition, evaluate alternatives, and develop solution recommendations for implementation of the Commitment Control Module, a major ongoing enhancement to GFAS. This enhancement will improve GNMA’s budget execution process, ongoing management of budgetary transactions, and both high-level and program-level budgetary reporting. Our Team provides accounting and financial expertise and PeopleSoft systems integration consulting to assist GNMA with tracking and reporting of budgetary supplemental data.
2ndWave consultants are also providing maintenance support for the current production system, working with end-users to streamline their work processes, and providing enhancements to the current PeopleSoft solution. 2ndWave consultants are also responsible for ensuring that the proper controls are designed and integrated into the system and its related operational processes.
- General Services Administration (GSA) OM&RS
GSA Occupancy and Rent Management System (OM&RS) Requirements
2ndWave captured detailed functional requirements for OM&RS. OM&RS, when deployed, will eliminate the need for the six legacy systems supporting GSA’s $10 Billion of rent and services income for its properties. To deliver this project successfully, the team had to quickly understand, analyze and define functional requirements based on each of the legacy system along with complexities of integrations. The most complex functionality was contained in Appraisal Data Management System (ADS), which managed building valuations conducted through Fair Market Value (FMV) appraisals and Return On Investment (ROI) valuations. Our team had to quickly analyze valuation methods, financial modeling techniques, data dependencies, and business processes. The most critical integration point was with Real Estate Across the United States (REXUS), which is GSA’s application managing the PBS building inventory. The 2ndWave team successfully delivered the requirements on time and within budget.
- OPM Trust Funds Benefits Assessment
Office of Personnel Management (OPM) Trust Funds Benefits Systems Assessment
Assessment and analysis of alternatives for business process and technology solutions to support OPM’s nearly $1 trillion in trust fund assets.
OPM operates three (3) civilian employee earned benefits programs: retirement, health benefits, and life insurance. The retirement program consists of the Civil Service Retirement System (CSRS) and the Federal Employees’ Retirement System (FERS). The health benefits program provides medical protection to federal employees, retirees, and family members as well as former employees and former spouses. Similarly, the life insurance program provides group term life insurance coverage for those members. These benefit programs are supported by four trust funds that incur obligations and make payments to cover the financial commitments.
2ndWave’s professionals served as Subject Matter Experts (SMEs) to provide an assessment of trust funds and benefits systems business processes to determine the alternatives that are available to meet OPM’s desire to further modernize its trust funds operations. Tasks included a Viability Study, Analysis of Alternatives and Systems Requirements, and Development of Recommendations, including legislative, regulatory, and policy changes.
2ndWave’s Subject Matter Experts (SMEs) provided government financial and accounting expertise and systems integration experience
Our consultants served as part of the team who performed a broad range of activities to support the modernization of the trust fund business processes and systems. The team completed ten tasks and deliverables:
- Viability Study – Reviewed the broad range of modernization alternatives available, and narrowed the list of options to the top three alternatives. The Viability Study included a market survey of large trust funds and their technology support approaches.
- Functional & Technical Requirements – Reviewed, validated, and updated the baseline requirements for trust fund processing.
- As-Is Process Models – Reviewed, validated, and updated the baseline process models for trust fund processing.
- System Architecture – Created a systems architecture diagram to document the systems, data flows, and information exchanges to and from trust fund systems.
- Gap-Fit Analysis – Developed a “To-Be” state based on the requirements and stated OPM priorities, and assessed the gaps between the “To-Be” and “As-Is” environments.
- Concept of Operations – Developed a CONOPS to describe the high-level operational view of the system from a user’s perspective.
- Analysis of Alternatives – Analyzed the modernization alternatives using an extensive list of criteria.
- Acquisition Strategy – Provided a framework for the development of an acquisition plan and statement of work (SOW) to support the modernization effort.
- Business Process and Operational Recommendations – Identified process improvement opportunities.
- Implementation Plan and Approach – Described a framework and guidelines for a detailed implementation plan for the final solution.
- Change Management and Acceptance Plan – Provided a strategy for managing the changes associated with the modernization.
These project deliverables and the overall assessment results provided a solid basis for OPM’s execution of this significant modernization effort.
- MWAA Information Technology Governance Strategy
Metro Washington Airports Authority (MWAA) Information Technology Governance Strategy
Assessment and Recommendations for Board of Directors governance and use of IT as a strategic asset in high-performing organizations
The Board of Directors (Board) of the Metropolitan Washington Airports Authority (MWAA) requested that the Office of Audit develop and present a White Paper on information technology governance and the Board’s role in overall IT governance in large, complex organizations. 2ndWave provided analysis and functional subject matter expertise in information technology, strategic planning, governance, and industry best practices.
The White Paper addressed how IT governance policies and processes can best address major information technology challenges including:
- Aligning IT with business goals
- Developing IT plans that support corporate business objectives
- Implementing new enterprise technologies (e.g., radio frequency identification, enterprise resource planning systems)
- Controlling IT costs and increasing efficiencies, and
- Ensuring data security and integrity.
The paper also addressed the role of the Board of Directors in setting policy and allocating resources for functions critical to effective information and technology management:
- Capital planning and investment management
- Enterprise architecture
- Information security
- Information technology/information resource management (IT/IRM)
- MWAA Oracle Financials FIRST Program
Metro Washington Airports Authority (MWAA) Oracle Financials FIRST Program
Oracle Enterprise Business Solutions Systems Integration Support
The Metropolitan Washington Airports Authority (MWAA) sought a systems integrator to provide an Enterprise Resource Planning (ERP) solution to enable and integrate the functionality specified in the eight (8) To-Be business process lifecycles. 2ndWave consultants were part of a team responsible for providing both a complete, high quality ERP software solution and all ERP system integration services specified in the RFP including:
- Provide and integrate scalable Commercial-Off-the-Shelf (COTS) software package(s) to fulfill the Authority’s functional and technical requirements
- Procure and configure the core application software of the ERP system
- Leverage the resulting ERP system to provide business intelligence and reporting tools that take the Authority to the next level of business efficiency
- Install an Enterprise Application Integration (EAI) middleware infrastructure to support and lay the foundation for integration with Authority legacy systems.
Subject Matter Expertise
2ndWave provided functional Subject Matter Experts (SMEs) as part of the implementation team. Our consultants worked with MWAA client personnel to validate the requirements (developed by another contractor), and then elaborate and expand on those requirements through the use of several techniques, such as group interview/discussion sessions and conference room pilots. 2ndWave consultants also participated in testing the solution and training the end-users.
The initial solution went live in July 2011.
2ndWave is now providing a broad range of support to this Oracle EBS financial systems environment:
- Integration with multiple feeder systems/subsidiary systems for revenue management and related functions
- Providing support for the overall financial systems operations
- Assisting in the review of business processes, policies/procedures, and other related activities beyond just the technical solution
- Researching and developing options for future functionality, including upgrade paths, best-of-breed COTS package integration
- Responding to end-user support requirements by performing hands-on, side-by-side operational support within the finance offices
- Developing and executing classroom and one-on-one training
- Leveraging Oracle Business Intelligence Enterprise Edition (OBIEE) to provide reporting and data analysis.
- Veterans Affairs Financial Management Systems Implementation
Department of Veterans Affairs Financial Management Systems Implementation
Governmentwide Treasury Account Symbol Adjusted Trial Balance System (GTAS)
2ndWave professionals provided functional and technical support services for the Department of the Treasury’s Financial Management Systems’ (FMS) implementation of the Governmentwide Treasury Account Symbol (GTAS) Adjusted Trial Balance System for the Department of Veterans Affairs.
Treasury enacted the GTAS Adjusted Trial Balance System, a web-based system implemented for use in a Governmentwide reporting setting to replace and merge the functionality of four separate reporting systems (FACTS I, FACTS II, IFCS, IRAS). Consolidation of these systems will facilitate data consistency checks, save the government significant maintenance costs, and save VA substantial reporting costs. The VA will submit proprietary and budgetary data simultaneously in one simple submission. This will save the users time, will provide more consistent and complete financial data, and will allow for better analytical reporting. Edits will check data across both budgetary and proprietary reporting.
2ndWave provided subject matter expertise and advisory support services that enable VA to understand, perform, report, and monitor all existing requirements of GTAS.
We developed and executed the templates, tools, and processes used in the development, documentation, testing, evaluating, reporting and remediation phases, and compliance with laws and regulations. The consulting team is helping the VA meet the GTAS requirements including: developing the data needed for submission, uploading the files in production, reviewing and researching failed data validations and accounting edits, reconciling VA GTAS bulk file attributes to Treasury GTAS bulk file attributes, identifying and performing a root cause analysis, and making recommendations for remediation.
2ndWave’s role was to provide functional Subject Matter Experts (SMEs) as part of the implementation team. Our consultants were responsible for working with MWAA client personnel to validate the requirements (developed by another contractor), and then elaborate and expand on those requirements through the use of several techniques, such as group interview/discussion sessions and conference room pilots. 2ndWave consultants also participated in testing the solution and training the end-users.
- Veterans Affairs (VA) A-123 Internatl Controls
Department of Veterans Affairs
A-123 Internal Controls
2ndWave supported the VA’s ICS in performing an A-123 internal controls review over financial reporting between the VA CFO and the Veterans Affair Medical Center (VAMC). The project provided reasonable assurance on the implementation and the effectiveness of internal controls and evaluated the compliance levels in the VA agencies based on VA internal control polices. Internal control deficiencies were identified before they impacted VA financial statements. We performed this testing based on sampling from the evidence request list provided over the specified period.
The control and corroboration process included the following activities:
- After performing document reviews, we shared preliminary results with the team lead and the staff from ICS and confirmed with them the exceptions by double checking the language of process narratives and polices.
- Exceptions or deficiency were shared with process owners to understand root causes and determine possible resolutions.
- For controls missing the requested documentation, we questioned the process owner or department chief about the existence of control activities.
- We corroborated the oral evidence by observing that the process owner described control activities that are actually being performed.
- We investigated any changes to the control processes on sites and documented and accepted permissible deviations.
- We informed process owner(s) where the weakness of the control was and explained the reason for the weakness.
- At the end of the process, we developed a summary of experiences at each site and developed a list of deviations and recommended improvements to ensure more consistency and better results.
- Other Government Agencies
Additional Government Agency Experience
Enterprise-wide Systems Implementation and Program Management Success
Prior to our roles at 2ndWaveLLC, our Program Management team (in their experience with the Big 4 consulting firms) have led and/or provided significant technical and SME support to large, complex ERP (both financial and HR/payroll) implementations for a variety of government agencies. Those technology and program management solutions include:
- Department of Education’s Central Automated Processing System (EDCAPS)
- Department of Education’s Grants Administration and Payroll System (GAPS)
- Department of Education’s Oracle Financials Implementation
- Department of Education’s Migrant Student Information Exchange (MSIX)
- Department of Transportation’s Delphi Oracle Financials Implementation
- Department of Labor e-Payroll migration (PeopleSoft / National Finance Center)