A multi-tier metadata driven solution based on event-based model for data mapping and validation for In-vitro medical diagnostic device

(b) Project Purpose – A B2B SaaS web solution of in vitro diagnostics medical devices by incorporating Incremental event and metadata driven business intelligence, data warehousing, and reporting solution. This was a multi-tier solution that included several windows communication foundation (WCF)-services, used as a framework for building service-oriented applications. The data were sent as asynchronous messages from one service endpoint to another while a service endpoint was a continuously available service hosted in an application.

Tools and Technologies – Microsoft AppFabric 1.1, Microsoft Windows Workflow Foundation and WCF services, Microsoft SQL Server 2012/2008R2 using LINQ and DbContext. Front-tier was implemented as ASP.NET MVC with jQuery with data from different tiers. All parts of the solution were tested using Ninject dependency injection and Moq in TDD.

Sunray’s Role :

Sunray’s team was responsible for software development on .NET/SOA/SQL Architect/Developer and as Business Intelligence Architect/Developer. Sunray’s team coordinated and collaborated with the client to set up structured processes, providing for course correction with new product ideas incorporated during the development process.

Sunray’s team implemented a SDLC of multi-tier metadata driven solution based on event-based model and chain of responsibility design patterns for managing metadata, data mapping, data validation and business rules. The implementation also included master data management and data governance of in vitro diagnostics medical devices.

A global complaint registration system (GCRS) providing a global register of product and devise

(c) Project Purpose – The goal of this project was for the modernization various manufacturing execution system environments including the introduction of the first J2EE application server to the integration of AEM servers for manufacturing batch record data capturing. The implementation also involved developing the global complaint registration system (GCRS) providing a global register of product and devise complaints.  Enterprise Application Framework provided a configurable and re-usable tool sets for rapid development of applications based on the J2EE technology. Compendia-l Tracking System created to document and manage tasks associated to Compendia-l modifications. The MES v4.1 was a packaged upgrade to migrate the hardware and Software.

Tools and Technologies – Adobe LiveCycle 7.x, Form Manager, LiveCycle Designer 8.1, Adobe Reader 8.1, Acrobat Professional 8.0, Work Flow Designer 7.22 XML, XSD, XPATH, JDBC, Oracle 10g, Adobe JavaScript, PL/SQL, Java 1.5.10, Web logic, My SQL, Jboss, Flex 2.0, MXML, Action Script, JavaScript, J2EE, Java/JSP/JDBC, ORACLE, Web Logic, PL/SQL.

Sunray’s Role :

Sunray put together a skilled team of experienced business analysts, Tech lead, Adobe certified Developers and QAs for implementing this project. Structured processes were set up, with ability for course correction with collaboration with SMEs of manufacturing processes and new methodologies were incorporated during the development process. Project management tools were extensively used for managing tasks, dependencies and processes for clear and transparent updates to all stakeholders.

Integration of disparate legacy systems by re-engineering and creating a new enterprise management system.

Project Purpose : A security systems company that also provides efficient energy solutions, and integrated infrastructure solutions for industries consulted with Sunray to reengineer and improve their existing legacy applications for performance, scalability and easier maintenance. The goal was to reengineer the applications to facilitate auditing and reporting of security system performance tools, Document and assess all security applications to balance security requirements with ISO standards, assess Risk Framework, Safety, Mobility, and Economic needs of the enterprise.

Tools and Technologies : The reengineering effort was to use the existing client tools as much as possible and these tools consisted of Amazon Redshift Database, OBIEE, 12c, SQL DEVELOPER
Oracle Database 10g, 11g, PL/SQL, Focal Point, TOAD, etc. Used WMS (workforce management system) Module / Dashboards for project management purposes across several discreet workgroups. The client toolset also included Oracle Application Server 10g, Oracle Fusion MiddleWare 11g, Weblogic 10.3.6, Oracle Portal 11.1.1, Oracle Identity Management, OID/SSO 10.4.3, OID 11.1.2, Oracle Access Manager (OAM) 11.1.x and Oracle OEM 10g Grid Control/12c, Tomcat 6 and 7, jBoss 5 and 6, java 7, Business Objects 4.1, and Informatica 9.1/9.6, Jira 6.0.8.

Sunray’s Role :

By paying close attention to the common expectations, requirements and behaviors of the client’s user base and prioritizing functionality and user interface design accordingly, Sunray’s team ensured that the uptake of the reengineering effort was rapid and widespread.  The business analysts held several sessions gathering requirements, which were followed by collaborating with the client constantly to together develop an schematic design and specification with blueprints of all the key elements arranged which visually communicated team Sunray’s proposed integration solution.

The plan was to integrate all existing systems while developing a completely new environment and also implementing improvements to existing systems. The end result was that the client had an enterprise management system that mad their day-to-day operations significantly easier considering there were so many layers of applications.  Sunray’s team got a very complimentary feedback from the client for the way Sunray managed the jobs and communicated with them.

Enterprise management application for a leading Health and sports club spread across US.

Project Purpose : A health club company owns and operates a network of sports clubs in major cities across the northeastern US corridor. The goal was to develop an enterprise wide application to be used by the clubs’ staff to manage members information, alerts, member enrollment, point of sale, club schedules management, guest management, trainer & staff work-shift manager, along with interfaces with various hardware like bar code scanner, and credit card reader integration.

Tools and Technologies : The application was developed using Java, with Spring J2EE framework with Hibernate ORM (object relational mapping) framework on the Linux platform. JBoss enterprise wide application and integration middleware was used with the Oracle database layer through JDBC. The data communication to the client layer was via XML over HTTP messaging architecture. AJAX client side layer was used with Apache POI.

Sunray’s Role :

Sunray put together an excellent team of proven individuals consisting of experienced business analysts, technical lead, certified developers, database administrator and quality control/analysts that were key to the successful development and implementation of the application. These individuals were well experienced with appropriate domain knowledge. A Project Information Tool, a project management tool that was developed in-house was used to manage tasks, budget and schedule processes to manage communications across all the project stakeholders.

Enterprise wide Compliance and reporting management system and application

Project Purpose : Sunray’s client was a manufacturer of specialty chemicals and industrial inorganic chemicals offers active ingredients, adhesives, analytical services, composite products, dosimetry systems, excipients, and lubricants for the agricultural, biorefining, chemical processing, and other markets. The project was to design and develop an enterprise wide software application to maintain and manage the processes in chemical safety, compliance, inventory management, and reporting solutions. The application would be used to simplify OSHA and other compliance and reporting, identify hazards and standardize chemical safety procedures, track inventory in real-time across the entire enterprise.

Tools and Technologies : The application was developed using C#,ASP.NET, JQuery, MVC and Oracle database. Web Services for data load process were initiated from .NET web applications as well as Python scripts. Used SQL loader utility to load data into oracle table and created Materialized View to use it in application.

Sunray’s Role :

Sunray assembled a team of multi disciplinary Developers, Business Analysts, Designers and Scrum masters that provided the base for a successful co-operation and project execution. Sunray’s team managed extensive collaboration with clear communication over a time period of 24 months with several release cycles and module developments. Sunray provided vision for the future complexity in the development, and helped setting up a scalable architecture with customer maintainable technology.

Health club management project

Sunray’s Consulting and Project Solutions teams have developed and delivered end-to-end software project solutions to several of its clients over the years. Sunray’s IT Project Solutions Services focus on successfully delivering quality solutions with efficiency and flexibility. This has been possible with Sunray’s deep understanding of industry domains and through Sunray’s highly skilled consultants who have expert knowledge in diverse technologies. Sunray’s goal is to help clients meet their business objectives and maximize their return on investment in software by developing and executing a solid implementation plan.

The following Case Study summaries illustrate the ways in which Sunray’s Project Solutions team has helped its clients, who come from a wide variety of companies and industries, to achieve and satisfy their need for software and technology that makes their companies highly competitive and positioned for growth. Please contact us for further details on any of the following case study briefs:

The Solution: The application had a secure infrastructure with scalable architecture and a simple user interface. The architecture and the design of the application facilitated EFT processing, and was developed to meet PCI compliance standards while providing vast functionality, support and security. Some of the functionalities included:

a. Ability to analyze heuristic data on population segments based on age and other demographical considerations.
b. For the application to work as a desktop version too, in addition to being a web-based version, thus enabling some of the club locations to implement the plan.
c. The financial analytics tool that could report financial data such as revenue projections for a given location, membership growth, training budgets, equipment budget forecasting etc.
d. To have the Electronic fund transfer (EFT) capabilities so as to provide the client with increased and predictable cash flow while significantly reducing their overhead. This service made the automatic payment plan available to the club members.
e. Ability to enable and support List and Data acquisition, data processing and personalization of management functions, printing in offsets and digital formats, lettershop and mailing services, etc.

The situation: One of Sunray’s clients, who are in health/sports club business approached Sunray to develop and deploy a system software application that’d help them to implement their plan of a bold nationwide expansion and sweeping rejuvenation of existing facilities. This application would enable the client to:

  • Communicate news about its new and renovated facilities to local residents in each club area, on a schedule that coincided with each club’s opening
  • Quickly reach and attract consumers who would be good candidates for health club memberships
  • Tailor communications to highlight the unique features of each location
    Track in-home mail delivery
  • Manage the whole program efficiently, cost-effectively, and accurately

The Result:  The client experienced significantly increased response rates and significant membership growth in both new and existing markets.  With the help of the application’s ability to generate report based on the data analytics, the client could expand its marketing efforts and implement loyalty programs for its members and have more effective sale and promotional events.