Woman typing at a laptop

Core competence:
Software engineering, OLAP, Databases, Oracle, MySQL, Big Data analysis



Our expertise

National Technical University "Kharkiv Polytechnic Institute"(NTU "KhPI") has concluded an agreement on cooperation with the Istanbul Technical University. Our group (SQL BI Developer on the basis of the Faculty of Computer Science in the Technopark of NTU "KhPI") develops software for analytics. We work in different technologies and subject areas: e-commerce, trading and financial systems, personnel systems, access control systems, etc. Specialists are highly qualified and have extensive experience in analytical data processing - creating a data warehouse for analytics, using Excel tools (OLAP), POWER BI, QLIKVIEW for data processing, optimization of samples and data representations, data presentation for creating multiple reports in an analytical designer. Various forms of cooperation: from the turnkey project to the creation of dedicated teams of specialists and the development of individual components.

Our services

  • Creation of analytical data storage.
  • Creation of an analytical reporting designer.
  • Optimization of work procedures.
  • Porting the database.
  • Audit existing CRM.

We can arrange remote execution of software development work independently or jointly with IT enterprises as a subcontractor.

The work will be performed by professional software developers with extensive experience and a lot of successful projects in the field of databases, accounting software and management systems, developments for computer networks and the Internet, search engines for WEB, email, multimedia and other.

One of the key areas of activity is the provision of services in the field of implementation of BI solutions.

We offer you the analysis of business processes and their description, the analysis of automation of business processes in CRM and the web system, the analysis of workflow for existing units and their tasks. Creation of analytical reporting (report designer for users)

Formation Consulting

  • Marketing automation.
  • Analysts.
  • Management and financial reporting.
  • Creating a schedule for loading a technician and scheduling tasks.
  • Database structure analysis.
  • CRM performance analysis.
  • Query optimization.
  • Index Optimization.
  • Performance Optimization.
  • Streamlining procedures.
  • Create Report Designer.
  • We have experience in the development of distribution, trading, manufacturing, consulting, banking and medical systems.
  • We have development experience in Sale Force.

COMPETENCE AND TECHNOLOGY

Data warehouse: SSIS,SSRS,SQL Profiler Reporting Tools :Excel, Fastreport,Server Reporting Sevices 2008,2012

Other Tools: MS Office, Visio, MS Excel, MS-Project 2000, Sale Force, Dynamic CRM

MSSQL ,Oracle, MySQL - DB WEB - php , Desktop - VB(VBA,VB.Net),Delphi , BI,POWER BI-technology

Specialists are highly qualified and have extensive experience in the development, implementation and maintenance of software products.

We work in various technologies and subject areas: electronic commerce, trading and financial systems, personnel systems, access control systems, etc. Most of our specialists have experience in developing Desktop and Web applications for 10-15 years.

BENEFITS OF COLLABORATION

High qualifications and extensive experience of developers, responsibility for the result; scalability and flexibility of project teams depending on the complexity of the project; Product quality and competitive prices.

Various forms of cooperation: from the “turnkey” project to the creation of dedicated teams of specialists and the development of individual components.

Based on our experience, we are ready to add tools to Sale Force to dispatch equipment loading and graphing, a report designer for the manager, automate the described business processes and get a system for marketing and analytics according to customer requirements.

BENEFITS OF COLLABORATION

METHODS, STANDARDS AND TOOLS

EXPERIENCE

SQL Server BI Developer (SSIS/SSRS)

Database Design, Programming, Development and Implementation Client-Server Applications & Database systems using MSSQL , Oracle, PostgreSQL

Installing, Upgrading and Configuring of Server and Databases.

Сreating and using Stored Procedures, Views, User Defined Functions.

Сreating Sub-Queries and Joins for complex queries involving multiple tables Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), Data Transformation Services (DTS).

Developed user defined financial reports to provide on demand financial data analysis using SSRS

Performed data conversions from flat files into a normalized database structure

Developed numerous ad- hoc reports using SSRS for day to day financial reporting.

Written and executed complex T-SQL queries using SQL Server Management Studio for back end data validation testing.

Worked on SSIS and DTS Packages, DTS Import/Export for transferring data from Heterogeneous Database (Text format data) to SQL Server.

Data migration (import & export BCP) from Text to SQL Server.

Created interactive reports with SSRS, using the report parameters, query parameters, Filters and Expressions.

Project cost - the total cost of the stages. Works are funded in stages. The cost of each stage is estimated by the performer and agreed with the customer. Each stage is financed in a specific schedule agreed with the customer. The financing schedule should exclude cash gaps, which are one of the risks of the project.

Also we are integrating with Turkish Technopark, and working on an analytics system. We are open to coopetation with different countries all over the world!

OUR CASES

AND LASTLY

  • FIRMS India

    A platform to promote Interdisciplinary Research in Science Technology and Management. Under this banner we are planning to organize International seminars, workshops and summer schools regularly in India and abroad as per need of our team and demands from universities and companies

    Learn more
  • Data Science

    The world is reshaping according to the latest technological trends and one of the major such trends in the modern era is Data Science. This is one of the most important domains in every sector of the industrial revolution since the last decade.

    Learn more