Kiril Sardjoski Email & Phone Number

Macedonia (Fyrom)

Skopje

Skopski, North Macedonia

Transfer of data stored in files in various formats and delimiters from different mobile network operators provided to an Azure storage to Snowflake. During this creation of data pipes for the purpose of creating fact tables that will deliver visual representation through Looker, I created custom made logic for all the different formats and standards of the mno’s. Initially data streams were used for accessing the delta changes of the new data that was arriving on a regular basis. The content of the streams was validated through SQL scripts and stored in the Snowflake database.• Migrated data from SQL server to Snowflake• Server file storage maintenance• ETL development using Microsoft Azure tools like Data Factory

Skopski, North Macedonia

Web Application of a telecommunications client wished to migrate all its desktop applications to the web. There was a change in business logic during the migration as well, so all the new business rules were considered and implemented accordingly. As a member of the data team, I worked with the backend developers on all the applications that were being migrated and had the responsibility to know the state of the database and the structure of the ERD model. The goal was to have all the changes in the Oracle database in GitLab for all of the environments (local, dev, test, prod).• Migrating existing Pentaho Kettle ETL packages to Oracle Data Integrator environment where the order of the Hadoop files had to be clearly defined• Creating new Oracle Data Integrator packages for migrating the old data, adding the new table structure like new columns and new triggers• Database design of three different projects that ultimately had to be unified• CI/CD for all the changes to all the different applications and their foreign keys• Stored Procedures to implement demanding calculations that could not be done in the application itself• Script versioning of all the project’s changesIoT The volume of data grows and grows, and I have started working with Big Data and real-life streaming processes. The data of the telecommunication company was ingested every 5 minutes, but these time windows made calculation difficult which resulted the company losing money. We introduced Apache Airflow as a service and did the calculations for the business logic in python scripts. Streaming of the data using a combination of no standardized products like Oracle and Apache AirFlow.• Redis streaming for buffering the incoming data stream from the Hadoop cluster• Python scripting for a Hoop for Airflow to connect to an Oracle database• Stress testing the solution with bulk loads of data

Bologna, Italy

An application to read the health status of various production machine in factories and measure their last and next check, fluid status, operational percentage. This data was compared to older model of the machines that are still operational and decisions were made regarding their cost of running and maintenance. The application itself was a combination of SQL stored procedures and DHTML for the application interface.• Application design and connectivity to the client’s local database• Stored Procedures customization for different business cases, different logic, and implementation of workflows

Amsterdam, Netherlands

Research into the customer satisfaction feedback and analyzing the data for different client and their target group for sales. The data had to be geographically separated to the results can be more localized. The Tableau reporting project offered a lot of optimizations for the layout of the reports.• Connections to different client’s data warehouses• Design various customer satisfaction reports• Dimension granulation of the calendar in the reports

Vevey, Switzerland

ETL Acquiring data from different libraries and comparing them with the ongoing process of the student's thesis for a organization of universities. The libraries data have a defined and prespecified structure which is contained under the structure in the XML itself. The result was the state of each student’s current progress with their research thesis. The ETL packages were done in SSIS and scheduled for execution in Microsoft SQL Server.• Parse XML and pivot its data for a more useful representation using T-SQL build in functions• Map destinations of the source data to its destination location with Microsoft SSIS packages• Schedule the execution

Birkirkara, Malta

Datawarehouse Reporting system for a telecommunication company to replace the existing reports that queried the Production server. Because of a bottleneck on the production application server and the slow response from the reports, a new parallel system was designed to represent only the valuable data to the end-user.• Designing and defining list of Pentaho Kettle packages that will serve as an ETL process to load the Datawarehouse• Design and propose a complete Datawarehouse facts and dimensions solution for reporting purposes in PostgreSQL• Data preparation and clearing all unnecessary data produced by the software application

Antwerp, Belgium

Responsible for coding SSIS processes to import data into the Data Warehouse from Excel and OLEDB sources for a logistics company. Designing ETL data flows using SSIS, creating mappings to extract data from SQL Server and data migration and transformation from Oracle/Access/Excel sheets using SQL Server SSIS. Building cubes and dimensions with different architectures and data sources for Business Intelligence. Experience in creating Ad hoc reports and reports with complex formulas and to query the database for Business Intelligence. Development of chart, graph, linked, dashboard, scorecards, report on SSAS cube, drill-down and cascading reports. The whole environment for the solution was with Microsoft Business Intelligence tools.• Collection of a list of production SQL Server databases spread across the entire world and their centralization• Order of queued procedure and packages• Data filtration and validation• Error handling and changing of Microsoft SSIS ETL packages logic to adapt to the resolution of the defined error• Performance Tuning of bottlenecks in scripts, views, and packages• Reporting solution and customization with Qlikview

Skopje, Macedonia

OLAP Cubes Combining two separate pharmaceutical projects into one reporting server which combines and relates the products and the clients of the material and financial solution. Both values from these two solutions are considered to have a clear idea about the standing and delivery of the products and by the salespersons. The combination of data was cross references in to Microsoft SSAS OLAP Cubes for analytical reporting purposes.• Execution of a set of Microsoft SSIS ETL packages and analysis of possible error during the workflow• Unification of the materials and finance databases and calculated reporting• SSAS OLAP Measures which calculate inputted data across one and another • KPI calculations• Reporting solution with Microsoft Excel Pivot Tables

Nantes Area, France

Master studies and relevant research in a collaboration between five universities and its colleagues. Theoretical knowledge of the background of every Data Science knowledge representation and modelling. Various assignments and small projects for every semester research. The projects were very theoretical and there was no use of modern proprietary software.• Defining and training data models• Research and implementation of predictive analytics

Rome Area, Italy

Creating and administering an Oracle environment for a telecommunication company with configuration of all proprietary applications for deployment of an application that will offer catalogue services and reporting usage of traffic to the Italian national post company. Configuring the hosts and their security was essential and had to be tested on different operating systems. Availability of many Oracle products was mandatory, and their inner functionality was a bigger challenge than initially proposed. The whole foundation for the eBusiness solution was my task where we used the Oracle products and their proprietary application to manage the project.• Oracle propriety software installation products• Connecting all the product through their ports and privileges• Installation and configuration of Oracle eBusiness Suite• Plugins for localized usage and market• Made sure the Oracle DB, SOA and WebLogic were synchronized and working smooth

Skopje, Macedonia

The government has a gross salary concept is made of and net salary and the contributions for the state. The employer has submitted the report for his company, which includes workers and their salary. I receive the data and examine its correctness. As an institution specified for the pension contribution, I then take the contribution from the salary, and run it through other procedures and applications that divide the pension contribution to part for the state and part for the private pension fund. The solution was a combination of an Oracle database, filesystem with Public and Private keys encryption, Web services for data synchronisation.• SQL scripting for analysis of data anomalies• Contribution validation of every employee and employer in the country• Data calculations and validity matching with five different government institutions• Cross checking different combinations of tax and invalidity exemptions for different people

Skopje, Macedonia

Complete web solution for a: hostel company, hospital institution and tango organization. These websites are developed according to their company’s specification and in their code are implemented some additional classes, modules, and plug-ins to increase the functionality. All the websites are Search Engine Optimized with its meta tags, robots, and sitemap. Added are additional security applications against proxy manipulation. Placing the solution on a remote hosting service required additional configuration of its parameters and a maintenance program. The products were done using the Joomla framework with a combination MySQL database managed through phpMyAdmin with a local XAMPP server. The deployment was done based on the client’s hosting solution.• Complete web solution custom tailored to the client’s needs• Server and infrastructure foundation• Design and development of the website• Multiple addons and plugins depending on the needs of the client

Master'S Degree, Data Mining

http://www.em-dmkm.eu/

Web Applications For E-Goverment

www.jica.go.jp/english

Bachelor'S Degree, Computer Science

www.eurm.edu.mk