KONTAKT

Case study

See all

Design challenge:

Bespoke Application integrating operational data of a government agency.

Project Scope:

Design of optimal data structure, application development and implementation.

Technologies:

MS SQL Server, C#, ASP.NET, MVC, WebAPI, Entity Framework, Angular 2.0

Result:

Successful testing & release of application modules to customer site meeting the quality criteria and specification.

Design challenge:

Automated product price management - current market conditions requires robust, sophisticated technology solutions to obtain and react to maintain margin.

Project Scope:

Architect consultation, design, development & testing of the application platform, services and tools for valuations. Responsibility of the end to end software development lifecycle.

Technologies:

.NET\C#, WebApi, AngularJS, Javascript/TypeScript, PL/SQL and T-SQL (Oracle, MSSQL), Git.

Result:

Growth in sales by development of price management tools.

Design challenge:

Unification of analytical services and analytical products for conducted projects.

Project Scope:

Coordination and unification of selected projects with regard to their mutual integration, unification and re-use at different levels (data, business logic, user's interface, principles and procedures, business processes). Including documentation unification and simplification.

Technologies:

Enterprise Architect, UML, MS Office

Result:

Quicker and more precise implementation of projects, and improved knowledge management.

Design challenge:

Banknotes most often used to pay for services were withdrawn from circulation overnight on one of the greatest markets of our Client. In one day the Client's revenues decreased by an order of magnitude. The Client's dominating position on the market was threatened.

Project Scope:

An analysis of available options of web payments that would fill the gap after the withdrawn cash. Renegotiation of contracts with global of online payments and establishment of cooperation with local partners in this regard. Integration of the Client's systems with new online payment systems.

Technologies:

JIRA, Enterprise Architect, Confluence, Visio

Result:

Maintenance of the dominant position on the market. Uninterrupted service provision process. Preparation of IT systems for similar situations in other places in the world.

Design challenge:

Effective provision of services on one of the largest markets of the Client requires extensive planning of events in which from several to several thousand people take part. The planning includes the availability of specialists, equipment, auxiliary personnel and exact planning of the location, and is made ca. 50 times a year. Information about locations is confidential and is disclosed to the public at the last moment, to minimise the risk of terrorist attacks.

Scope of works of DCG:

Re-engineering of business processes associated with planning. Expansion of the existing systems with functions allowing accurate planning with limited data. Implementation of a system for handling business rules defining the scope and the moment of disclosure of more detailed information about planned events.

Technologies:

JIRA, Enterprise Architect, Confluence, Visio

Result:

Optimisation of the planning process by reducing the time needed to conduct the planning. Optimisation of the cost of providing the service by selection of physical locations, human resources and equipment according to the key - from the cheapest to the most expensive. Support of the process ensuring safety of participants of events by a limited communication concerning a physical location.

Design challenge:

Our Client, looking for the method for reducing operating costs, has planned a global standardisation of business processes. The Client operates in 100+ countries, and the standardised processes correspond to USD 1B +revenue annually. The unification of processes could not exclude their adaptation to local cultural factors, or legal or geographical conditions.

Project Scope:

An AS-IS analysis of business processes, and modelling of TO-BE processes. Identification of stages of processes that must be adapted to the local conditions of a particular country. Implementation of the system of business process management (BPM) consisting in a number of dedicated modules whose configuration enables to configure particular stages and parameters of the process.

Technologies:

JIRA, Enterprise Architect, Confluence, Visio

Result:

Switching the organisation to process thinking. Improvement of the transparency of processes and tasks performed by particular employees. Possibility of measuring key parameters of processes and use of real data for further optimisation.

Design challenge:

Improvement of processes and a system supporting management of an art collection.

Project Scope:

Mapping of processes, documentation of requirements, optimisation of processes, an audit, a market study, a project tender and consulting related to tailoring of IT solutions.

Technologies:

Not applicable.

Result:

Intensified safety of the managed collection, increase in the transparency of processes and responsibility of a team, the conducted project tender.

Design challenge:

Manual processing of the majority of business processes and data dispersed in various sources, lack of consistent reporting and monitoring mechanisms, need for improving business processes.

Scope of works of DCG:

A business analysis, analysis and optimisation of business processes (Six Sigma, Lean Management), initialisation and execution of a project improving the process.

Technologies:

BPMS, BI, MS Sharepoint.

Result:

Automation of business processes, improvement of planning, execution, monitoring, control and reporting processes.

Design challenge:

Maintenance of a set of applications used for exchanging financial messages between banks.

Scope of works of DCG:

Implementation of new versions, participation in migration of the infrastructure between centres of data processing, assistance in projects changing the infrastructure of the communication systems, solving problems with the operation of the application.

Technologies:

Unix

Result:

Active and continuous support.

Design challenge:

Ensuring continuity of operation of the IT system to protect the EU boundaries insofar as hardware and system are concerned.

Scope of works of DCG:

Supervision, detection of failures, removal of failures, care over the full cycle of operation of dedicated software, management of accounts, support for the 30 remaining interchanges in the EU countries and beyond its borders, update of systems.

Technologies:

Linux, OpenLDAP, FireFox, SSH, Apache web serwer, Apache Directory Studio, XRDP, JBoss, Proxmox, KVM, Zimbra, Open Meeting / Collaboration.

Result:

A functioning system, quick removal of failures.

Design challenge:

Implementation of a trading system.

Scope of works of DCG:

Planning of an IT infrastructure in accordance with the best practices.

Technologies:

Linux/Windows/KDB/Oracle/Java

Result:

A trading system functioning on the world's biggest stock exchange.

Design challenge:

Unification and refinement of the architecture of web applications to meet requirements of clients – ease in implementation of changes in many applications at the same time, testability and scalability.

Scope of works of DCG:

Ensuring quality of many front-end applications, configuration of builds and deployments related to front-end applications, trainings of co-workers related to writing a testable JS code and implementation of basic knowledge about UX and Accessibility.

Technologies:

AngularJS, TypeScript, Webpack, NPM, Yarn, Git, Bootstrap, .NET core, Karma, Jasmine, Node.js

Result:

Improvement of quality and ensuring similar look&feel of web applications. Care for expanding knowledge related to the front-end among all members of developer teams.

Design challenge:

Transformation of ideas arising from business into clear reporting solutions that will allow its users to obtain access to necessary information easier and quicker.

Scope of works of DCG:

Works in modern tabular environment and works on tabular models as support for business in obtaining valuable conclusions from received data.

Technologies:

SSAS Tabular, SQL, Oracle, SQL Server, Tableau, MS Power BI, Informatica Powercenter

Result:

Shortening of time of presentation of data and improvement in their legibility.

Design challenge:

Work in a team dealing with Big Data solutions related to improvement in the field of services in the field of management of client accounts and reporting.

Scope of works of DCG:

Cooperation with Analysts aimed at consolidation of processes, creation of new solutions and optimisation of existing processes.

Technologies:

Spark, Hadoop, Sqoop, Oozie, Pig, Hive, Impala, Kafka, MongoDB, Cassandra, HBase, Scala, Java, Tomcat, Jetty, Weblogic, Maven, Git, Stash/Bitbucket, Jira, Confluence, RedHat, Linux

Result:

Enhancement of the architecture by integration of services.

Design challenge:

Development of API (middleware), which enables the registration process to be automated for a test. API is used by a web application, data from it flow to educational centre management systems. These systems are 'almost identical' for each country, but some operations require modifications specific for a given location. Additionally, this is not a clean integrative stateless API. Registration starts a long-term process with events initiated by candidates (e.g. online payment), as well as automatically (e.g. text messages reminding about the test time). Both the long-term process and automatic operations may change – their versions appear, which, however, should not affect already registered persons and their processes.

Scope of works of DCG:

Making of a system based on BizTalk Server, development of a programming definition of processes. Preparation of procedures, changes in definitions of processes and their versioning. Post-implementation support, continuous development of a product, preparation of new definitions of processes.

Technologies:

BizTalk Server 2013 R2, Azure Relay, MS SQL Server, .NET\C#, REST, JSON

Result:

High, measurable savings related to reduction of work expenditure required for registration of candidates for courses (entering data, searching for available dates, recording of dates of consultations with lecturers in the training centre management system). Ease in expanding the implementation in further countries, possibility of adjusting the process for a country, development of elements of automation of candidate handling (date reminders).

Design challenge:

Streamlining deployment on more than 50 servers. Switch from manual deployment to fully automated.

Scope of works of DCG:

Implementation of a fully automated CI/CD pipeline. Each piece of code which will reach the repository is compiled, and then automatically tested (unit, integration and e2e testing) by a build server (TeamCity). If tests are passes successfully a package is created, which then passes the whole route though different environments. From the human point of view, the entire process comes down to pressing a proper button.

Technologies:

TeamCity, Octopus Deployment

Result:

Shortened time of deployment (in some cases below 5 minutes), as a result of which we reduced the system unavailability. Additionally, as a result of using the same package in various environments and multiple testing, we have managed to reduce wrong configuration errors.

Design challenge:

Supervision over design, management and improvement of various data warehouses.

Scope of works of DCG:

Construction and modification of ETL processes, browsing changes made by other team members, and presentation of recommendations concerning the strategy and the architecture of a data warehouse.

Technologies:

SQL, Oracle, Informatica Powercenter

Result:

Implementation of technical and functional solutions improving data warehouse supplying processes. Provision of appropriate scalability for further roll-outs.

Design challenge:

Assignment and transfer of a database application using more efficient servers and processes.

Scope of works of DCG:

Analysis, design, implementation, testing, documentation, implementation and maintenance.

Technologies:

SQL, PL/SQL, Informatica PC, Oracle Exadata

Result:

Simplification of the database architecture and increase in efficiency.

Design challenge:

Design and implementation of a database part of a B2B sales application.

Scope of works of DCG:

Analysis, design, implementation, testing, implementation and maintenance.

Technologies:

SQL, Informatica PC, MS SQL Server.

Result:

Growth in sales by development of price management tools.

Design challenge:

Development of a web application based on JavaScript with simultaneous replacement of existing functions developed in MS Silverlight.

Scope of works of DCG:

Analysis of needs and development of requirements. Designing GUI based on technical, business and user's requirements and needs. Designing the usability of an application. Implementation of graphic GUI mock-ups and prototypes. Implementation and development of GUI.

Technologies:

JavaScript, HTML5, CSS3, MS Silverlight, Angular JS, ArcGIS

Result:

Transformation of functions into more up-to-date technologies, opening the way for further development along with changing business requirements.

Design challenge:

A growing number of notifications from internal users, causing tickets to be handled in a period exceeding internally adopted SLA.

Scope of works of DCG:

Administration of Windows and Linux systems; diagnosis of activated processes, administration of network, telephone diagnosis and assessment of failures, handling notifications in accordance with ITIL, development of the user's manual and documentation. All the works are performed in the English-speaking environment.

Technologies:

Windows (Server & Client), Active Directory, Linux, MS Office, SQL, T-SQL

Result:

Improvement in timely handling of reported failures.

Design challenge:

Development of a policy and procedures for systems related to safety of the network.

Scope of works of DCG:

Optimisation of current configurations and procedures, delivery of information and amendments. Cooperation with a security department and external suppliers of solutions. Development of documentation.

Technologies:

Checkpoint (VSS, VSX, URL), Fortinet (FortiManager, FortiAnalyzer, UTM), VPN, CISCO, Orion (NPM, NCM), Infoblox, VISIO

Result:

Adjustment and optimisation of firewalls. Elimination of unused rules and removal of outdated processes.

Design challenge:

Creation of safe exchange of information between the client's branches and the Internet.

Scope of works of DCG:

Maintenance and development of the client's network environment. Analysis and processing of configuration changes. Responding to events.

Technologies:

Cisco ASA Firewalls, Catalyst switches, ISR routers, Secunet SINA, routing, switching, DMVPN, IPSEC

Result:

Possibility for protected data transmission in the network environment accredited for processing classified information.

Design challenge:

Relocation of headquarters of the corporation in Poland.

Scope of works of DCG:

Conducting the relocation of the headquarters with regard to transferring a few hundred employees to new headquarters.

Technologies:

Windows stations, telephony, network, Wifi

Result:

Project implementation as required by business.

Design challenge:

Compliance with legal requirements of local financial supervision authorities in several African countries, in the scope of processing of financial data.

Scope of works of DCG:

Preparation and implementation of solutions for the presented problem, so that it is accepted and positively checked by competent governmental bodies with regard to technical and legal requirements concerning data processing.

Technologies:

Linux/SQL

Result:

Audits of implemented solutions successfully conducted by local financial supervision authorities.

Design challenge:

Relocation of the headquarters of the corporation in one of African countries.

Scope of works of DCG:

Conducting the relocation of the headquarters with regard to transferring employees and a local data processing centre.

Technologies:

Data centre migration, network, Wifi, Windows stations, telephony

Result:

Project implementation as required by business

Design challenge:

Renewal of IBM p-series hardware infrastructure resulting from terminating the support for the supplier

Scope of works of DCG:

Migration of a few hundred applications working on IBM p-series systems to a new platform.

Technologies:

IBM p-series

Result:

Project implementation in accordance with Roadmap for modernisation of p-series systems. Improvement in security of systems.

Design challenge:

Migration of critical business applications to a new platform, as part of reduction in the number of products in the data processing centre, and optimisation of costs.

Scope of works of DCG:

Migration of critical applications working on Solaris to the Linux platform.

Technologies:

Solaris, Linux

Result:

Reduction in the number of Solaris systems from a data processing centre, and reduction in costs of maintenance of systems.

Design challenge:

Separation of Shared Service Center from a part of business. Separation of ITIL data and processes based on Remedy.

Scope of works of DCG:

Planning, implementation, monitoring and execution of the project. Development and management of the project budget. Conduct and management of virtual project teams. Delivery of reports and documentation on the status of the project and its progress.

Technologies:

PRINCE2, PMP, ITIL, Remedy, MS Project, MS Outlook

Result:

Conferred tasks successfully completed according to declared budgets and dates.

Design challenge:

Identification and implementation of necessary changes in the existing systems, processes and the organisation in order to deliver a new business model. The new generation of CB (computer based) examinations will be delivered digitally and will replace PB (paper based) tests with the use of the existing system which will be accordingly adapted.

Scope of works of DCG:

Comprehensive management of the project of implementation of changes in many systems on the basis of a completed analysis: online registration and the payment system, as well as a system managing the results of examinations.

Technologies:

NET\C#, WebApi, AngularJS, Javascript/TypeScript, PL/SQL and T-SQL (Oracle, MSSQL)

Result:

An answer to challenges on the market of examinations requiring implementation of new technologies and migration of the process to electronic tools.

Design challenge:

Increase in the possibilities for the video conference environment (from 300 to 1,000 video conferences at the same time).

Scope of works of DCG:

Planning and implementation of extension of the infrastructure for the video conference system, as well as testing and implementation of the system.

Technologies:

MS Skype, Pexip

Result:

The project is being implemented (planned completion at the end of 2017).

Design challenge:

Standardisation of the domain environment.

Scope of works of DCG:

Migration of all structures from an old domain to a new one and shutdown of an old domain. Migration of all structures from MS SCCM 2007 to MS SCCM 2012.

Technologies:

MS Active Directory, MS SCCM

Result:

The project was successfully completed.

Design challenge:

Preparation of additional functions and development of the existing ones for systems of monitoring the risk related to rates, the market risk and the liquidity risk.

Scope of works of DCG:

Implementation, development, maintenance, optimisation of systems. Cooperation with Treasury Department and Market Risk Department. Development of a technical documentation.

Technologies:

SAS Base, SAS DI, SAS Management Console, Oracle.

Result:

Development of bank systems.

Design challenge:

Development a key technological platform related to short-term loans.

Scope of works of DCG:

Work on modernisation of the architecture of solutions, adjustment and implementation of the platform and other components of the system.

Technologies:

Java 8, Spring (Boot, Data JPA, Security, MVC), Hibernate, JUnit, Git, Bitbucket, IntelliJ/Eclipse, MySQL, SQL, JIRA, Confluence, Maven, Docker, jUnit, Mockito, Cucumber, XML, JSON

Result:

Launching a new platform in a new country and launching a new brand in the next location.

Design challenge:

Designing systems abstaining automatic trade in bonds depending on dynamic business rules.

Scope of works of DCG:

Design, development and maintenance of heterogeneous back-end systems supporting automatic bond market mechanisms. Integration with internal systems. Development of documentation.

Technologies:

Java 8, Scala, Play, JavaRx, Redis, KDB, Oracle, EMS, Apache Kafka, Spring, SpringBoot, Spring Integration, SBT, Maven, Gradle, Git

Result:

Implementation of new business models relating to automatic trade in bonds. Standardisation of management systems withholding automatic trade in bonds for various markets.

Design challenge:

Conversion of the current version of one of client's application in Silverlight to HTML5, without changes, seamless for end users.

Scope of works of DCG:

Design and implementation of a testing plan and test scenarios, as well as reporting results within the development team.

Technologies:

MS Silverlight, HTML5, MS Visual Studio, Telerik Test Studio

Result:

Ensuring maintenance of functions, so that a new version can be deployed without the need for an additional training of end users. Verification of the consistency of the application with subsequent versions of web browsers.

Design challenge:

Sharepoint web sites development: existing infrastructure and recommendations of development direction; integration with other client's systems.

SCOPE OF WORK OF DCG:

Projects management based on Sharepoint web sites. Development and automation of proceses implemented on Sharepoint by creation and implementation of Sharepoint features.Integration with other client's systems by WCF; Sharepoint Integration with Windows domain by importing users data. Infrastucture performance monitoring. VMWare infrastructure performance monitoring.

TECHNOLOGIES:

Sharepoint 2007/2013, .NET\C#, Microsoft WCF, Sharepoint Designer, Sharepoint application pages, workflows, jobs, MS SQL 2008, customizowane typy pól sharepoint, custom actions and conditions dla Sharepoint Designer, VMWare Vsphere 5.5

RESULT:

Automation of proceses related to data processing in the area of corporate clients service delivery.

Design challenge:

Assurance of continous work of systems on the hardware and system layer.

SCOPE OF WORKS OF DCG:

Supervision, breakdown detection, breakdown clerance, client's infrastructure keeping.

TECHNOLOGIES:

CISCO Routers/Switches, Cisco ASA, IPS, Chekcpoint, VPN.

RESULT:

Working systems, smooth breakdowns clearance.

Design challenge:

Possibility of extending the range of a mobile application into subsequent countries on the Asian market. An application dedicated for Android devices connected with the API service in the course of all data transmissions. A dedicated testing team examined whether the range extension, and at the same time, a substantial increase in the number of users, will not result in the application's failure, and thereby in cutting off the access for the present users.

Scope of works of DCG:

Preparation of the plan of efficiency tests, selection of methods and tools. Tests of the application in an environment with parameters similar to the production environment. Preparation of a report and presentation of conclusions resulting from tests.

Technologies:

NET\C#, Javascript/TypeScript, PL/SQL and T-SQL (Oracle, MSSQL), Git, JMeter.

Result:

Approval of possibilities to extend the range without the need for greater changes with regard to development, as a result of which the application could be implemented in subsequent countries immediately after completion of tests, therefore the number of users significantly increased.

Design challenge:

Regression tests performed in the process of preparation for large integration of many applications based on a common database, shared by all tested applications. One of challenges was to connect a number of teams involved in testing particular applications, considering the fact that each of these teams had its seat a different location, as well as in a different time zone.

Scope of works of DCG:

Automatic tests, as well as functional and integration tests for all described applications. Coordination of works of teams. Reporting and responding to emerging incidents.

Technologies:

.NET\C#, Protractor, Selenium, Javascript/TypeScript, PL/SQL and T-SQL (Oracle, MSSQL), Git.

Result:

The result were several weeks of tests that provided high quality solutions and resulted in implementation of many applications cooperating with one another in the production environment.

Design challenge:

The change of technology and tools used to create automatic test for an application related to registration to examinations in English. It was caused by a change of an approach to development of the application, as well as plans of complete reconstruction of the application.

Scope of works of DCG:

Based on practices applied in other projects of the company, a testing team created from scratch the configuration of tests and automatic tests verifying main functions of the application. All of this was connected to continuous integration systems (Team City).

Technologies:

.NET\C#, Protractor, Selenium, Javascript/TypeScript, PL/SQL and T-SQL (Oracle, MSSQL), Git, Team City.

Result:

The entire process made it possible to develop a new solution for testing applications in TypeScript. It resulted in the fact that these tests were more reliable and written in a language used also by developers, which additionally enabled them to provide direct support during development of tests and their maintenance.

Design challenge:

Possibility of dynamic management of offered prices of products. The present market requires solid and sophisticated technological solutions to obtain and react to the changing situation.

Scope of works of DCG:

Testing the system, design and development of a testing framework. Care over the full cycle of software testing. Participation in design and consulting related to testing of applications.

Technologies:

.NET\C#, Selenium Webdriver, Specflow, Xunit, Jenkins

Result:

Complex testing of applications.