System Integration & Implementation
Trilogy provides system integration and implementation support services for large-scale enterprise system modernization efforts.
Our support includes the full spectrum of the Software Development Lifecycle (SDLC) for federal legacy and modern custom systems and COTS/GOTS solutions. We provide interface development, data conversion, application development, system architecture support, and more. We focus on providing deep technical subject matter expertise coupled with in-depth domain knowledge of our client’s environment to provide flexible, feasible solutions.
Skill Areas
- Legacy System Modernization &
Sunsetting - User Interface Design & Development
- Full Software Development Lifecycle
(SDLC) Support
Related Work:
-
Department of Veterans Affairs Office of Benefits Automation (OBA) Claims Modernization Support
Learn More -
VHA Office of Healthcare Technology Management (HTM) TeleCritical Care (TeleCC) Support Services
Learn More -
Financial Management Business Transformation (FMBT) Interface Development, Data Cleanse, and Data Conversion (ID&C)
Learn More -
My HealtheVet Program Management and Training Support
Learn More -
VHA Office of Integrated Veteran Care (IVC) Innovation and Technology (I&T) Support Services
Learn More -
Office of Information and Technology (OI&T) Enterprise Data Management Support Services (EDMSS)
Learn More -
Department of Agriculture (USDA) Financial Management Modernization Initiative (FMMI)
Learn More -
Office of Enterprise Integration (OEI) System Integration and Business Architecture
Learn More -
VBA Compensation Services (CS) Public Policy Program Support Services
Learn More -
VBA Compensation Services (CS) Operations Program Support Services
Learn More -
VHA Office of the Chief Financial Officer (OCFO) Modernization
Learn More -
VHA Office of Healthcare Transformation (OHT) Keep Improving with Innovation (KIWI) Legislation and Healthcare Education, Research and Public Health
Learn More -
VHA Human Resource (HR) Modernization & Transformation
Learn More -
Veterans Experience Office (VEO) Enterprise Business Support Services (EBSS)
Learn More -
VBA Education Service (EDU) GI Bill Outcome Measures Support Services
Learn More -
VBA Strategic Program Management Office (SPMO), Statistical Analysis Support Services
Learn More -
VA Financial Management Business Transformation (FMBT) System Integration (SI) Support
Learn More -
VA Grant Per Diem (GPD) and Supportive Services for Veteran Families (SSVF) Financial and Operational Grantee Audits
Learn More
Department of Veterans Affairs Office of Benefits Automation (OBA) Claims Modernization Support
The Office of Automated Benefits Delivery is a vital part of the VBA’s digital transformation strategy, which leverages automation to enhance efficiency and provide digital services that improve business capabilities and processes. Within this framework, the Office of Benefits Automation (OBA) aims to create innovative solutions that automate and streamline the processing of VA Benefits, thereby enabling VBA decision-makers to deliver quality, equitable, and timely benefits to Veterans and their families. OBA staff collaborate on a diverse portfolio of projects, varying in size and complexity, focused on automating labor-intensive processes through the use of automation, artificial intelligence (AI), and rules-based processing.
Trilogy provides comprehensive project and program management services, adhering to PMI’s PMBOK Guide and SEI CMMI standards. Trilogy provides professional support in program management, business analysis, strategic planning, project lifecycle and budget analysis, SharePoint configuration, stakeholder management, Microsoft Power App development, and document management. Additionally, Trilogy offers expert recommendations and implementation services to enhance program management practices, processes, and standards, supporting the delivery of automation projects.
Trilogy’s comprehensive project and program management services enhance efficiency and streamline operations. Our expertise in strategic planning, business analysis, and budget management optimizes resource allocation and financial oversight, leading to improved project delivery. Rigorous risk management and insightful reporting ensure projects stay on track, reducing delays and mitigating potential issues.
VHA Office of Healthcare Technology Management (HTM) TeleCritical Care (TeleCC) Support Services
Overview
As trusted advisors with expertise in the national TeleCC solution, Trilogy plays a leading role in creating, centralizing, and communicating guidance to field-level Biomedical Engineering personnel, managing the technological and contractual elements of the TeleCC lifecycle, developing technical requirements, and managing projects at each stage of development from site preparation to implementation, maintenance, and technology refreshes. Our team helps VHA HTM ensure the preservation of medical technology inventory data integrity and prepares technical document standards to transform systems.
Approach
Through technical implementation and sustainment guides, strategic technological development, and exceptional project management, our team has provided multi-faceted support for HTM throughout the TeleCC lifecycle.
Results
The technical implementation and sustainment guides that Trilogy developed have streamlined installs and provided the necessary guidance for maintenance management throughout VHA. Our team also increased the effectiveness and efficiency of TeleCC technology deployments by developing a dedicated SharePoint site to support the field vis-à-vis system implementation (in-room and mobile), equipment sustainment (e.g., Philips eCareManager, Audio/Video endpoints, interfaces), schedules (e.g., Go-live, expansion, and equipment refresh), training and education videos, FAQs, and more.
Financial Management Business Transformation (FMBT) Interface Development, Data Cleanse, and Data Conversion (ID&C)
Overview
Trilogy supports the VA Financial Management Business Transformation (FMBT) program which is focused on modernizing the VA’s Financial Management systems and implementing an integrated solution called Integrated Financial and Acquisitions Management System (iFAMS), a custom implementation of Momentum Financials. All existing integration points will have their functionality either subsumed by iFAMS capabilities or will transition to integrate with iFAMS via web service API and/or data file extracts and transfers.
Approach
Through state-of-the-art, customized processes, Trilogy’s team of data experts swiftly extracted, transformed, and integrated legacy data into the new system. The legacy FMS data was extracted, transformed, and loaded to iFAMS through a series of SQL, PL/SQL, and Java based routines executed through Jenkins pipelines, utilizing a custom library of Groovy scripts. The pre-conversion data cleanse activities utilized Power BI reports and Alteryx ETL routines for transformation accuracy and corrective actions. Trilogy’s Agile and DevOps frameworks excel at delivering Continuous Integration and Continuous Deployment (CI/CD) solutions, allowing frequent assessments of the state of the software and converted data.
Results
As a result of Trilogy’s support, the FMBT program has successfully converted six separate data conversion waves into iFAMS. These waves include the NCA, VBA, and Staff Offices components of the overall VA landscape. Trilogy has increased overall capabilities for the ID&C program and streamlined overall technical operations into an efficient Agile Development workshop. Increased efficiencies continue to yield successful, on-time deployments in iFAMS.
My HealtheVet Program Management and Training Support
Overview
Trilogy provides full-range program and project management, analytics, research, requirements management, and training support to the Veteran’s Health Administration (VHA) Office of Connected Care (OCC) Veterans/Consumers Health Informatics (V/CHIO) program office, the business unit that owns the My HealtheVet website. With over 4.7M users, MHV was designed for Veterans, active-duty Service members, and their dependents and caregivers, to provide a web‐based Personal Health Record (PHR) to self‐monitor care, access health records on‐demand, make informed health care decisions, and securely communicate with VA care teams.
Approach
Trilogy provides a wide array of research, reporting, and administrative support to MHV. We facilitate approximately 17 meetings per week and provide strategic planning white papers and best practice research reports for OCC and executive leadership. Trilogy provides agile development and requirements management support from initial concept to training and implementation following DevSecOps and Incremental Planning ceremonies. Our team developed and continues to maintain a PowerBI dashboard that aggregates data from multiple VA repositories into a comprehensive graphical display. The team also creates and delivers training sessions twice a month to VA staff nationwide and supports EHRM initiatives relative to the Patient Portal, working directly with sites preparing to go live and continuing post-launch to document any issues.
Results
Trilogy delivers over 24 training sessions per year and maintains over 20 job aids, including micro-videos. Trilogy helped redesign the entire agile (DevSecOps) development process, including the aggregation and review of business needs, and the development of those prioritized needs into Epics and User Stories. Trilogy research and reporting led to strategic decisions about the future of VA’s patient portal, utilizing Oracle/Cerner and MHV APIs on VA.gov to provide a seamless user experience instead of disparate portals for Oracle/Cerner and MHV. Trilogy Analytics support eliminated many manual VA processes by providing automated machine learning and intelligence, saving an estimated 80+ hours a month.
VHA Office of Integrated Veteran Care (IVC) Innovation and Technology (I&T) Support Services
Overview
Trilogy provides program and project management, communications, change management, business process re-engineering, data analytics (e.g., PowerBI), IT solutions (SharePoint and Salesforce), and VA Healthcare Systems understanding support for the VHA’s Office of Integrated Veteran Care (IVC), Innovation and Technology (I&T) division. The objective of this contract is to help the I&T division integrate internal processes and standards to support the efficient deployment of innovative processes and technical solutions for the VHA and IVC.
Approach
Trilogy employs industry best practices based on PMI’s PMBOK to manage various large and complex I&T division functional and technical projects. This also encompasses various IT solutions to identify, collect, and manage requirements, risks, resourcing, and communications. We also use agile concepts and practices to help the I&T deploy specific IT solutions (e.g., SharePoint and Salesforce) throughout the VA and IVC domains.
Results
Trilogy helped the I&T division develop and streamline internal processes and set specific communication standards resulting in clearer internal/external communications, reduction of work product rework, and clearer access to key information on designated I&T project and portfolio SharePoint sites. Our team also helped redesign the I&T division and subordinate portfolio SharePoint sites that provided standard and consistent design, cleaner viewing of key information, and a better understanding of the products and services the I&T division supports and provides. Furthermore, our team of experienced certified PMPs helped the I&T division deploy a national IT solution on-time and receive a FedHealthIT Innovation award for helping improve Veterans access to care. Trilogy also developed and deployed multiple PowerBI dashboards that help IVC and I&T leadership see real time trends related to Veteran patient care at the national and local VISN levels.
Office of Information and Technology (OI&T) Enterprise Data Management Support Services (EDMSS)
Overview
Trilogy has supported the Data Governance Council (DGC) as part of the EDMSS project in two essential task areas: Authoritative Data Source (ADS) Analysis and Data Quality Analysis. These analyses have addressed four key questions: where the data is coming from, what the data means, what the Authoritative Data Source (ADS) is, and how well the data in the ADS can be trusted. Trilogy resources developed the adopted methodology to answer these questions, played a vital role in DCG’s communication workstream, and also provided subject matter expertise in the pilot of the ADS Data Management Implementation Plan.
Approach
Trilogy’s experienced team of data analysts developed methodologies to be applied to DGC-approved subject areas which involved identification of systems and underlying data stores, verification and remediation of any gaps in the metadata of identified systems in the VA Enterprise Architecture Repository (VEAR), scoring for component completeness, data stewardship and monitoring, developing dashboards to communicate ADS Data Quality metrics to all Data Governance and ADS Stakeholders, and developing conceptual, logical, system interface, and physical data models for identified systems.
Results
The methodologies developed by Trilogy, combined with its expertise and data metrics communication support, have made a lasting impact on the ongoing quality of data analysis by DGC and already seen use on several high-priority VA initiatives including FMBT and Vet360.
Department of Agriculture (USDA) Financial Management Modernization Initiative (FMMI)
Overview
Trilogy supported the implementation of SAP, Federal Financial Management Initiative (FMMI), at the U.S. Department of Agriculture (USDA) by providing multiple subject matter experts for the data migration from multiple instances of CGI Federal’s Federal Financial System (FFS) and multiple subsidiary systems. Trilogy’s expertise was essential to the design and development of end-to-end conversion processes, the execution of those processes in numerous testing, QA, and production environments, supporting system and user acceptance testing, and coordinating production cutover activities. Trilogy team members were called on to provide its data migration expertise to drive the critical path data conversion task to completion through each of its four deployments to 28 USDA agencies.
Approach
Trilogy Federal was integral in refining the overall data migration strategy to ensure accuracy and completeness of migrated data. This included identifying innovative alternatives to planned conversions that proved to be roadblocks to successful migration and on-time delivery, designing and developing end-to-end conversion processes extracting and transforming data from CGI Federal’s Federal Financial System (FFS) and other subsidiary systems and loading selected data to FMMI, developing and maintaining the master data crosswalk utility. Trilogy Federal was frequently relied upon to brief USDA leadership on data migration status and issues and played a key role in successful high-volume cutovers.
Results
Trilogy played a lead role in executing this large-scale data conversion initiative in a multiple-deployment/multiple-agency environment and achieved on-time go-lives for each deployment and 100 percent of FFS balances by Fund, Budget Year, and GL Account reconciled to FMMI to the penny for all 28 agencies migrated to FMMI.
Office of Enterprise Integration (OEI) System Integration and Business Architecture
Overview
Trilogy Federal has lead efforts for OEI to implement a Business Architecture (BA) with the short-term goal of supporting VA’s Modernization Effort, as well as the long-term goal of maturing VA’s Strategic Operating Model (SOM), which includes developing Business Architecture framework, content, and supporting analytics that will inform planning, programming, budgeting, and execution decision making processes. The architecture content areas developed and integrated into the BA include Strategic, Business, Programs/Budgets, IT Portfolio Investments and Systems, Risk, Performance, Statutory and Regulatory Requirements, Organizational, Process, and Resources.
Approach
Trilogy’s development of this Business Architecture has included developing a VA-wide Concept of Operations for Business Architecture and associated governance, developing logical, conceptual and physical data models for the Business Architecture, implementing the Business Architecture physical model, and developing analytics for SOM decision making processes that pull from the Business Architecture physical model. Trilogy has facilitated workshops with stakeholders from across VA to develop and refine an enterprise Business Reference Model that reflects the activities performed by all Administrations and staff offices. We also worked with stakeholders across the department to integrate enterprise content into the VA BA, including performance, risk, audit findings, organizations, budget programs, strategic priorities, billets, IT systems, and IT investments. Trilogy created architectural views and related data analytics that directly support resource prioritizations for OEI’s Mission Requirement and Mission Gap development during VA’s annual planning prioritization process, PA&E’s annual programming process, OI&Ts IT Enterprise Roadmap, and ITRM’s IT budget formulation and Multi-Year Planning processes for IT investments.
Results
The Business Architecture developed by Trilogy successfully provides analytics that enable VA to fully achieve the strategic goals and objectives defined in VA’s current and future strategic plans, including analytics associated with planning priorities, material and non-material programming requirements, and IT material requirements for Capital Planning and Investment Control (CPIC) that lead to streamlined technical solutions and elimination of redundant functions and processes that lead to more efficient and effective delivery of benefits and services to Veterans.
VBA Compensation Services (CS) Public Policy Program Support Services
Overview
Trilogy supported Compensation Service critical programs and projects, responsible for assessing Veterans’ recognition of the effects of disabilities incurred or aggravated during active military service. Trilogy’s project management and strategic planning experts have helped CS Public Policy sector develop rules, policies, regulations, requirements and conduct field training and advisory reviews to ensure timely and accurate execution of the benefit program. Specifically, our team has provided support to the Office of the Director, Policy, Procedures and Interagency MilPay, Military Exposures Team, and Veteran Affairs Schedule for Rating Disabilities (VASRD) PMO Staffs.
Approach
Trilogy’s VBA CS PMO applied tailored project management and strategic planning best practices to manage and facilitate program and project initiation, planning, executing, modifying, and sustaining business documentation and updates for VBA trainings, policies, and regulations. Products include standardized project documentation for ongoing programs and projects, implementation assistance with development of agency-wide policies and guidance, and management of internal and external correspondence and actions.
Results
Trilogy’s support resulted in the successful implementation of two public laws: the Blue Water Navy Veterans Act 2019 and the Honoring our PACT Act 2022. Across its portfolio, Trilogy standardized project documentation and performance metric reporting, ensuring effective implementation of these landmark initiatives.
VBA Compensation Services (CS) Operations Program Support Services
Overview
Trilogy supported Compensation Service (CS) critical programs and projects, responsible for assessing Veterans’ recognition of the effects of disabilities incurred or aggravated during active military service. Trilogy has helped CS Operations staff provide VA employees with the software, systems, training, and quality assurance resources needed to be successful in the field and fulfill the VA mission of serving Veterans and their dependents. Specifically, our team has provided support to the Training, Quality Assurance, and Systems Support & Operational Review divisions.
Approach
Trilogy’s team of skilled process improvement, project management, instructional design experts applied proven best practices in each area of support to implement systems, training, and quality updates. Products include facilitation and development of project management artifacts, dashboards, and high-level briefing materials to support quality management, systems updates, CS Infrastructure, training curriculum management, Warrior Training Advancement Course (WARTAC), as well as operational functions of large-scale implementations such as the Promise to Address Comprehensive Toxics (PACT) Act and the Blue Water Navy (BWN) Veterans Act.
Results
Trilogy support resulted in successful and efficient migration to SharePoint Online, operational readiness for BWN and PACT Act implementations, as well as multiple VBA-wide process improvement and automation efforts.
VHA Office of the Chief Financial Officer (OCFO) Modernization
Overview
Trilogy has supported VHA OCFO since 2020 by assisting with project management, streamlining VHA’s central office, and other support needs while assisting with the complex tasks of modernizing its electronic health records and transforming its financial management system and supply chain.
Approach
Our team has used an approach incorporating business process reengineering (BPR), accounting classification structure (ACS), data cleansing and conversion, communications, organizational change management (OCM), project management, as well as supply chain systems analysis to provide comprehensive support in VHA OCFO’s financial system implementation. We have also assisted with VHA’s GAO High Risk List (GAO HRL) efforts, audit preparation, training, and financial policy review and utilized our technological and operational expertise to organize its processes and allow for easy reporting for management.
Results
As a result of Trilogy’s support, VHA has been able to continue its analysis and planning for its financial system implementation with the needed staff and support for an effort of this magnitude. Additionally, our team has helped VHA improve in its GAO HRL areas of concern and maintain its clean audit opinion.
VHA Office of Healthcare Transformation (OHT) Keep Improving with Innovation (KIWI) Legislation and Healthcare Education, Research and Public Health
Overview
Trilogy has worked alongside OHT and other VA and VHA stakeholders such as the Office of Patient Care Services (PCS), the Caregiver Support Program (CSP), and the Veterans Benefits Administration (VBA) to execute an integrated project team (IPT) to study the feasibility of a dozen proposed solutions to expand Veterans and Servicemembers’ eligibility for the Program of Comprehensive Assistance for Family Caregivers (PCAFC).
Approach
Each proposed solution was examined through a structured feasibility and advisability methodology including legal and regulatory, financial, technological, and operational elements. This effort included data collection from structured qualitative discussions, development of Requirements Traceability Matrices (RTMs), and data analysis across different functional process areas, which all culminated in an executive report, implementation roadmap, stakeholder engagement plan, a bevy of communications and change management products, as well as various briefings for the Under Secretary of health (USH) and the White House Domestic Policy Council.
Results
As a result of Trilogy’s support, CSP, PCAFC, and VA have data-driven, practical opportunities for improvement most likely to increase Veterans and Servicemembers’ eligibility.
VHA Human Resource (HR) Modernization & Transformation
Overview
Trilogy manages a high performing, fully functional PMO team to help Workforce Management and Consulting (WMC) implement the most significant transformation in the history of the Veterans Health Administration. HR functions and resources are being reorganized into shared services to improve customer service and enable VHA’s more than 360,000 employees to deliver care and services to nine million Veterans. This monumental HR Modernization process encompasses a series of current and to-be-defined initiatives including policy changes, process improvement, IT systems enhancement, and change management communications. Trilogy’s expert team enables an agile response to the complex, competing, and ever-evolving needs of the transformation process.
Approach
We work with WMC staff and other stakeholders to quickly understand the scope of projects needing our support and where those projects are in the project management lifecycle. We work closely with project teams to build trust with our VA stakeholders through the adoption of new standards, practices, and tools, grounded in Project Management Book of Knowledge and Prosci best practices.
Results
Trilogy successfully supported 26 different WMC projects in a year, including developing a high-performing integrated team, deploying best practices, innovating business operations, and helping WMC improve customer service to support the goal of hiring 52,000 new employees in FY 2023.
Veterans Experience Office (VEO) Enterprise Business Support Services (EBSS)
Overview
Trilogy has provided business support services to assist VEO’s Customer Information Services (CIS) Division enhance enterprise customer data management capabilities and customer-facing solution management. This includes enterprise data quality practices, business rules, data governance, and data steward practices. Trilogy also provides data architecture support, enterprise contact center and digital experience data management support (mapping/ETL/testing) as well as analytics, reporting, and insights from contact center and digital data sources (CRM, Telephony, KM, Chat, VA.gov, Vsignals).
Approach
Trilogy’s experienced data quality team used Data Governance Council (DGC) guidance to perform data quality analyses across various systems within the VA (VADIR, ADR. CorpDB, VA Profile, VA MPI) and reported on the origins of and solutions to data anomalies. Trilogy has provided ongoing data quality monitoring reports and metrics to provide accurate data, data audit reports, exception queue reports, Data Quality Process training support, and recommendations for automated or intelligent tools to eliminate manual reviews/disposition of records.
Results
Trilogy’s analysis and business integration services have assisted CIS with the design, configuration, and OI&T delivery of a future state architecture, enabling CIS capabilities and coordination with various offices both within and outside the VA.
VBA Education Service (EDU) GI Bill Outcome Measures Support Services
Overview
The federal government allocates over $10 billion a year to provide education benefits for service members and Veterans. This project studies the outcome measures of the VBA Education Service (EDU), which invests annually to support these benefit programs. Our team assists EDU in selecting the required data, assessing the data quality, merging, analyzing, curating, and loading the data into a ‘clean’ repository to generate metrics that help EDU assess VA return on investment (ROI).
Approach
In order to meet the challenges of this complex and impactful project, Trilogy has deployed a full spectrum of analytic services and tools. This includes conducting institutional research, analyzing existing data sources to identify target ROI data and any related data quality issues, developing methods to ensure these issues are remediated prior to loading, loading curated data into the ROI repository, creating analytic algorithms to analyze the ROI data, and providing detailed reporting of our findings. This has led to our deployment of DataOps for data integration and analytical output velocity without sacrificing quality, automating existing pipelines (API/RPA) for data calls/retrievals (using VS Code/Microsoft SQL Management Studio/Oracle SQL Developer) and utilizing GitHub for code configuration management, and performing offline development in open-source environments (such as Python and R Studio) for analytical scripts and advanced modeling (ML) for tasks such as parsing manually entered data that has been incorrectly entered to synthesize and align the data points for analytical reporting. Our team has also created procedures for the operation of the ETL and database, published an Operations Manual, and created a Configuration Tool Manual.
Outcomes
The tools and procedures Trilogy has developed give VA EDU complete transparency into the operational details of GI Bill Outcome Measures program while also providing clear and comprehensive decision-making support to advance the program. This support enables data-driven improvements to policies and claims procedures surrounding GI Bill benefits as well as develop targeted federal approaches for Veterans, service members, and their families to see the greatest value of their GI Bill benefits.
VBA Strategic Program Management Office (SPMO), Statistical Analysis Support Services
Overview
Trilogy has supported both VBA’s Strategic Program Management Office (SPMO) and Office of Strategic Support Initiatives (OSSI) since their inception to develop the strategy, infrastructure, employee engagement, knowledge, and operational framework to effectively deliver project management and customer experience solutions throughout VBA.
Approach
Trilogy has worked alongside SPMO and OSSI to define their strategic outlook and implement priority initiatives, including developing communities of practice, data models, reporting frameworks, and training strategy and design for project management and customer experience. Trilogy also designed and developed comprehensive SharePoint-driven knowledge management solutions and organizational processes to standardize operations across both organizations.
Results
As a result of Trilogy’s support, SPMO and OSSI have seen increased effectiveness and efficiency in their support of several VBA priority initiatives. Employees now have more effective tools and training to help VA staff deliver essential, earned benefits to the Veterans they serve.
VA Financial Management Business Transformation (FMBT) System Integration (SI) Support
Overview
Trilogy operates as a system integrator for VA’s Financial Management and Business Transformation (FMBT) initiative, which is an effort to modernize VA’s financial and acquisition management systems with transformative business processes and capabilities that enable VA to meet financial management legislation objectives and directives.
Approach
Trilogy is supporting the VA migration to the Momentum cloud solution, configured for VA as Integrated Financial and Acquisition Management System (iFAMS). In this migration, Trilogy is supporting VA in leveraging the SAFe Agile model to deploy the new solution. As a result, VA has gained increased operational efficiency, productivity, agility, and flexibility from the new modern Enterprise Resource Planning (ERP) cloud solution. The new solution has also provided additional security, storage, and scalability for VA users.
Results
As a result of Trilogy’s support in the transition to a modern ERP cloud solution, VA administrations have already begun to see an increase in transparency, accuracy, timeliness, and reliability of financial information across several departments. Trilogy’s support has been acknowledged and greatly appreciated by VA in support of their transition from the legacy Financial Management System (FMS).
VA Grant Per Diem (GPD) and Supportive Services for Veteran Families (SSVF) Financial and Operational Grantee Audits
Overview
Both the SSVF and GPD offer communities and VA medical facilities ways to assist homeless Veterans with housing and services. Program designs are diverse, ranging from transitional housing projects and apartment-style transitional housing to service centers offering outreach and supportive services. Trilogy Federal provides critical support for both initiatives by performing financial and operational fitness audit (FOFA) reviews in coordination with the Office of Business Oversight (OBO) for over 75 grantee locations, ensuring that they’re run responsibly and sustainably for the program duration. Trilogy also identifies inconsistencies, develops robust risk assessment tools, and identifies areas of improvement to allow for more efficient financial management of each site.
Approach
Using proven and comprehensive project management procedures, Trilogy works through each FOFA methodically, from kickoff and trainings to onsite evaluations to follow-through on recommended action plans. Each step of the process is conducted with a goal of exceptional service and measurable results.
Results
To date, Trilogy has performed over 200 financial and operational fitness audits across the continental United States and assisted grantee locations in understanding and implementing report information to best serve Veterans, their families, and their communities.
Financial Management Business Transformation (FMBT) Interface Development, Data Cleanse, and Data Conversion (ID&C)
Overview
Trilogy supports the VA Financial Management Business Transformation (FMBT) program which is focused on modernizing the VA’s Financial Management systems and implementing an integrated solution called Integrated Financial and Acquisitions Management System (iFAMS), a custom implementation of Momentum Financials. All existing integration points will have their functionality either subsumed by iFAMS capabilities or will transition to integrate with iFAMS via web service API and/or data file extracts and transfers.
Approach
Through state-of-the-art, customized processes, Trilogy’s team of data experts swiftly extracted, transformed, and integrated legacy data into the new system. The legacy FMS data was extracted, transformed, and loaded to iFAMS through a series of SQL, PL/SQL, and Java based routines executed through Jenkins pipelines, utilizing a custom library of Groovy scripts. The pre-conversion data cleanse activities utilized Power BI reports and Alteryx ETL routines for transformation accuracy and corrective actions. Trilogy’s Agile and DevOps frameworks excel at delivering Continuous Integration and Continuous Deployment (CI/CD) solutions, allowing frequent assessments of the state of the software and converted data.
Results
As a result of Trilogy’s support, the FMBT program has successfully converted six separate data conversion waves into iFAMS. These waves include the NCA, VBA, and Staff Offices components of the overall VA landscape. Trilogy has increased overall capabilities for the ID&C program and streamlined overall technical operations into an efficient Agile Development workshop. Increased efficiencies continue to yield successful, on-time deployments in iFAMS.