Sunray’s client is one of the world’s leading pharmaceutical companies that engages in the discovery, development, manufacture and sale of a broad and diversified line of health care products. Its product offering includes established pharmaceutical products, nutritional products, diagnostic products, and vascular products. Sunray’s team was part of several joint software development projects. We have mentioned the following 3 implementations that team Sunray accomplished:

Title:  Abbott – Developed a Test Automation Framework for FDA Compliance
( Software Test automation)

(a) Project Purpose – FDA compliance testing, by implementing SoapUI data driven automation framework for testing of XML and RESTstate based medical device webservices. The goal was to validate database writes in MS SQL database by creating a web application using C#, TSQL and .NET to serve as a portal for the test team to input data used by SoapUI automation framework.

Tools and Technologies – XML, C#, MS SQL, TSQL, SoapUI and .NET

Sunray’s Role:

Sunray’s team managed extensive collaboration with clear communication through several tests module developments. By developing automated, modular service submission tool, Sunray was able to transform the efficiency of a key business processes thereby relieving pressure and reducing costs while improving the overall reliability of the automation framework.

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

(Software application development)

(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.

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

(Software application development)

(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.

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

(Software Re-engineering)

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.

Title: Town Sports International – Enterprise management application for a leading Health and sports club spread across US.

(Software Application Development)

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.

Title: ISP Chemicals – Enterprise wide Compliance and reporting management system and application

(Software Application Development)

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.