Displaying items by tag: sql

The United States Customs and Border Protection agency contracted with The Software Revolution, Inc. (TSRI) for a Phase 1 assessment as well as a conversion and modernization of the Customs and Border Protection (CBP) Cargo ACS/Quota (QUOTA) Conversion Pilot code from COBOL/CICS to Java or .Net.

Customer: US Customs and Border Protection Source & Target Language: COBOL/CICS & JCL to Java Lines of Code: 163,700 Duration:  4 Months Services:  Automated Code Transformation, Automated Refactoring, Integration and Testing Support, Internal and External Dependancy Analysis, Transformation Blueprint®, Application "As-Is" Blueprint®, Target Architecture Design

Originally developed by Denmark-based KMD in 2001 as a mainframe software application, the e-Boks system became more difficult and costly to maintain over time. The original platform also lacked the agility to expand to additional countries at scale and was not agile enough to expeditiously react to business changes. TSRI and KMD were able to modernize the e-Boks application from its original IBM PL/1 legacy code in a monolithic architecture to a modern, multi-tier application in a modern computing environment, running .NET, with no impact on the business and end-user experience. As a result, e-Boks has the potential to save more than 50-60 percent per year in operations and maintenance costs.

Customer: KMD and The Government of Denmark Source & Target Language: PL/1 & JCL to C# Lines of Code: 974,201 (781,893 - PL/1 and 192,308 - JCL) Duration:  6 Months Services: Transformation Blueprint®, Automated Code Transformation, Automated Refactoring, Integration and Testing Support

Deutsche Bank's relatively reliable mainframe infrastructure utilized COBOL and JCL languages running DB2 and VSAM flat-file databases for a variety of their key financial applications. The company’s leadership knew they would need to be cloud-enabled with a modern architecture to stay relevant for its customers and ongoing market needs. Following a successful proof of concept against other well-known industry soluitons, TSRI emerged as the best solution (highest quality output and most advanced architecture) for the full modernization effort of Deutsche Bank’s internal KreditManager application. An application which gives the company’s employees all of the tools they need to handle all of the company’s loan, credit and mortgage applications.

Customer: Deutsche Bank Source & Target Language: COBOL & JCL to Java & Python Lines of Code: 397,222 (383,358 - COBOL, 13,864 - JCL) Duration:  12 Months Services: Automated Code Transformation, Automated Refactoring, Integration and Testing Support, SonarQube Quality Refactoring, Code-Specific Adaptation, Database Migration, Transformation Blueprint®, Application "As-Is" Blueprint®

This case study documents technologies, processes, and methods of the timely and 100% automated conversion of a portion of the VHA (Veterans Health Administration) Information Systems and Technology Architecture (VistA) system, written in 2.1 million lines of MUMPS. The modernized module resulted in object-oriented and highly maintainable Java compatible with the J2EE framework. VistA is the core Electronic Healthcare Recordkeeping (EHR) system for the VHA hospital system, which provides EHR record keeping for more than 4.5 million veterans.

Customer: Veterans Health Administration and SAIC Source & Target Language: Mumps to Java Lines of Code: 300,000 Duration:  5 Months Services: Automated Code Transformation, Automated Refactoring, Integration and Testing Support, Engineering Support, Transformation Blueprint®, Application "As-Is" Blueprint®

Using money from the Technology Modernization Fund (TMF) under the Modernizing Government Technology Act disbursed by the General Services Administration (GSA) of the U.S. government, the Department of Housing and Urban Development (HUD) sought to modernize several of its remaining critical systems on a legacy Unisys mainframe written in COBOL with a flat-file DMS-II database.

Customer: Department of Housing and Urban Development and Salient CRGT Source & Target Language: Unisys COBOL to Java Lines of Code: 1.3 Million Duration:  8 Months Services: Automated Code Transformation, Automated Refactoring, Integration and Testing Support, Enginerring Support, Software Maintenance Agreement, Transformation Blueprint®, Application "As-Is" Blueprint®,

A $39 billion clothing retailer with 4,300 stores worldwide sought to modernize its suite of mainframe COBOL supply chain applications. These applications supported the client’s unique business process, which provided them with a major competitive advantage and fueled years of unprecedented growth. Today, the clients business logic was preserved and their services are hosted on Azure with data integration directly through service bus queues and scheduling handled via Logic Apps.

Customer:  Retail Client Source & Target Language: COBOL to C# Lines of Code: 86,000 Duration:  3 months Services: Code Transformation, Automated Refactoring, Testing and Implementation Support, Transformation Blueprint®

Capita, a company based in England and Wales, determined that one of their important software assets called PRISM required modernization, including code transformation, platform migration, and database migration. Capita engaged TSRI, with their proven automated modernization services, to complete this project, which was finished in 3 months.

Customer: Capita Source & Target Language: BASIC to PL/SQL Lines of Code: 660,000 Duration:  3 months Services: Transformation Blueprint®, Automated Code Transformation, Automated Refactoring, Integration and Testing Support

The National Endowments for the Arts (NEA) Grants Management System (GMS), Financial Management System (FMIS), and Automated Panel Bank System (APBS) were unique one-of-a-kind 27-year old legacy systems written in Wang VS COBOL, running on a WANG VS Operating System, and using a WANG VS DMS database. TSRI was engaged to transform these systems into C++ and completed the project successfully in 7 months.

Customer: National Endowments for the Arts Source & Target Language: COBOL to C++ Lines of Code: 656,000 Duration:  5 months Services: Code Transformation, Automated Refactoring, System Integration Support, Testing Support, Transformation Blueprint ®