Dejan P.

Dejan P.

Software Developer

Skopje, Macedonia
Hire Dejan P. Hire Dejan P. Hire Dejan P.

About Me

Dejan is a database architect trusted by numerous corporations worldwide. For over a decade, he did the heavy lifting at the largest banks in Southeastern Europe and then moved on to managing a startup serving clients from the Fortune 500 companies. Dejan specializes in data modeling, data analysis and geospatial but has worked the whole stack of software development, front to back.

Data Warehouse Design Data Warehousing Oracle ETL Data pipelines SQL T-SQL (Transact-SQL) Visual Basic for Applications (VBA) Crystal Reports PL/SQL Microsoft SQL Server Microsoft Access PL/pgSQL PostgreSQL PostGis

Work history

BCG - Gamma
Lead Data Engineer
2020 - Present (5 years)
Remote
  • Implemented the back-end for an AI-driven marketing product, DEEP.AI, by BCG.

  • Deployed the product for RingCentral. Implemented custom modules to support all types of marketing activities.

  • Led the back-end development, database design, API, and ETL.

Data EngineeringAmazon Web Services (AWS) PythonAmazon EC2 RedshiftData Quality SnowflakeAzure Python API Data Warehouse DesignData Warehousing ETLData pipelinesSQLVisual Basic for Applications (VBA) PL/pgSQLPostgreSQLMicrosoft AccessData ModelingBusiness Intelligence (BI) DatabasesArchitecture Apache Airflow Database Modeling Data ArchitectureData-driven Design noSQLData AnalysisData Analytics Excel Macros PandasData VisualizationTableauAmazon S3 (AWS S3) Database Administration (DBA) Scalability APIsRelational Database Services (RDS) Data ManagementIT Automation Amazon RDSAPI IntegrationDashboards Unix Shell Scripting Excel 365 Data ScienceDjangoCI/CD Pipelines Big DataData IntegrationBI Reporting Database Transactions Database DesignDatabase Structure Transactions Microsoft ExcelBack-end Development
(LG) GIIR America (HS Ad)
Data Engineer
2020 - 2021 (1 year)
Remote
  • Implemented an ML service for tracking marketing offerings from different vendors to give an insight into how effective the vendor campaigns were.

  • Enabled the service to parse the text content of these offerings to identify the key elements like the type of offer, discount, gift, merchandise, and conditions that apply.

  • Made an estimate of the cost of the campaign, which was then compared to the estimated sales and thus gave an insight into how the effectiveness of the campaign.

Data EngineeringETLData pipelinesSQLJavaScriptVisual Basic for Applications (VBA) PL/pgSQLPostgreSQLNode.jsJasperReports BigQuery Amazon AuroraMicrosoft AccessData ModelingBusiness Intelligence (BI) DatabasesArchitecture Database Modeling Data ArchitectureData-driven Design noSQLData AnalysisData Analytics Excel Macros Data VisualizationAmazon S3 (AWS S3) Database Administration (DBA) Scalability APIsRelational Database Services (RDS) Data ManagementIT Automation Amazon RDSAPI IntegrationDashboards Unix Shell Scripting Excel 365 Data Build Tool (dbt) Data ScienceGoogle BigQuery Data IntegrationBI Reporting Database Transactions Database DesignDatabase Structure Transactions Back-end Development
MI-C3
Head of Software Development | Software Architect | Senior Software Engineer
2011 - 2017 (6 years)
Remote
  • Managed cross-functional teams of 30+ software engineers in Malta, Macedonia, and Nigeria offices.

  • Created an environment where everyone could complete their assignments accurately and on time by clearly communicating the task purpose and providing continuous code reviews, training, and assistance.

  • Found, hired, and retained most of the team members by ensuring everyone enjoyed their time with the team. Used every opportunity to inspire everyone to dream big about what they do.

  • Architected and led the early development of a privately hosted collaboration platform, Affectli. Deployed at clients like Chevron and Newmont, and IHS Towers.

  • Built the architecture and led the development of a fleet and shipping management system for Petro Kazakhstan, a CPNC: China National Petroleum Company.

  • Created the system architecture and developed the database of TagNGo (Tagngo.com), a vehicle tracking and onboard diagnostics (OBD) service.

  • Designed and built a back-end infrastructure for simpler and cost-effective microservice development. It is an integral part of all the products developed at MI-C3.

GeoserverOpenLayersPostGisNode.jsd3.jsJasperReports TIBCO AngularJS Activiti BPM Java EEPostgreSQLData Warehouse DesignData Warehousing ETLData pipelinesSQLJavaScriptVisual Basic for Applications (VBA) PL/pgSQLSAP BusinessObjects (BO) PentahoSocket.ioJavaMongoDBAmazon AuroraSparkSpark SQLGoogle Maps API Express.js MySQLMicrosoft AccessData ModelingBusiness Intelligence (BI) DatabasesArchitecture Server Migration Database Modeling Data ArchitectureData-driven Design noSQLData AnalysisData Analytics Excel Macros Data VisualizationAmazon S3 (AWS S3) Database Administration (DBA) Scalability APIsTelemetry Relational Database Services (RDS) Data ManagementIT Automation Amazon RDSAPI IntegrationDashboards Unix Shell Scripting Excel 365 Big DataQGISArcGISSpatial Databases Data IntegrationBI Reporting Database Transactions Database DesignDatabase Structure Transactions Geospatial Data Back-end Development Apache Kafka
Alpha Bank
Senior BI/Data Engineer
2008 - 2010 (2 years)
Remote
  • Supported the implementation of the Basel II regulatory standards by developing statistical models (based on HMM—hidden Markov model) assessing the bank's risk exposure (credit, liquidity, currency, and interest rate risk).

  • Supported the migration to Oracle FLEXCUBE by developing crosscheck reporting to validate the proper configuration and operation of the new system.

  • Built a module that independently generated all the accounting records (and other intermediary tables) based on the configuration and the activity entries originating from all the system modules.

  • This module was a banking system made according to the bank's specifications. It did all the work FLEXCUBE does to the data after the user's input. These records were later compared against the FLEXCUBE ones to check if everything was in place.

  • Developed reporting and ETL related to loans, deposits, funds transfer, and overall accounting.

  • Implemented data analyses in projects that established the local regulatory requirements, converting charts of accounts and central bank audits.

  • Performed quarterly and annual financial reporting, MIS.

Visual Basic for Applications (VBA) SAP BusinessObjects Data Service (BODS) Oracle 10gOracleData Warehouse DesignData Warehousing ETLData pipelinesSQLPL/SQLOracle RDBMS SAP BusinessObjects (BO) Microsoft Data Transformation Services (now SSIS) JavaMicrosoft AccessData ModelingBusiness Intelligence (BI) DatabasesWindows Architecture Server Migration Database Modeling Data ArchitectureData-driven Design Data AnalysisData Analytics Excel Macros Data VisualizationDatabase Administration (DBA) Scalability Relational Database Services (RDS) Data ManagementDashboards Oracle PL/SQLPL/SQL Tuning Unix Shell Scripting Excel 365 Data IntegrationBI Reporting Database Transactions Database DesignDatabase Structure Transactions Microsoft ExcelBack-end Development
Intralot SA
Operations Supervisor
2003 - 2008 (5 years)
Remote
  • Oversaw the adoption of new products (lotto, bingo, scratch tickets, and betting) from system operation, training, regulatory and market perspectives.

  • Supervised the technical operations for a local customer, Lottery of Macedonia.

  • Developed products supporting the operations and did tasks involving ETL, winnings calculation, crawling the competition's websites for offers, and risk assessment (e.g., Dutch Booking).

  • Performed operational requirements and sales/market analyses. Prepared financial reports.

Visual Basic for Applications (VBA) Crystal ReportsOracle9i OracleData Warehouse DesignData Warehousing ETLData pipelinesSQLPL/SQLOracle RDBMS Microsoft Data Transformation Services (now SSIS) SQL Server Integration Services (SSIS) Microsoft AccessData ModelingBusiness Intelligence (BI) DatabasesWindows Architecture Server Migration Database Modeling Data ArchitectureData-driven Design Data AnalysisData Analytics Excel Macros Database Administration (DBA) Scalability Relational Database Services (RDS) Data ManagementOracle PL/SQLPL/SQL Tuning Unix Shell Scripting Excel 365 Data IntegrationBI Reporting Database Transactions Database DesignDatabase Structure Transactions Microsoft ExcelBack-end Development
National Bank of Greece
Senior Software Engineer
2001 - 2003 (2 years)
Remote
  • Led the development of a web-based loan application processing system (E-loans.nbg.gr).

  • Built a web service around the InTempo workflow engine and, for the client side, a single-page application that exchanged only data with the service. This set up reduced the network traffic and improved the app's response.

  • Developed a JavaScript library with functionalities similar to today's Angular/React. The library provided the means for the declarative definition of the data bindings and the definition of form components and templates for complex data structures.

  • Architected the solution that was accepted as genuinely simple to use and survived in operation for 15 more years when Internet Explorer was discontinued.

  • Developed ETL procedures for the foreign subsidiaries running GLOBUS (Temenos T24 predecessor).

  • Migrated older DBASE applications to the Microsoft platform (Microsoft SQL Server, Visual Basic, and DCOM).

BPM DTS Database Transactions SQLASPJavaScriptVisual Basic 6 (VB6) Microsoft SQL Server Data Warehouse DesignData Warehousing ETLData pipelinesT-SQL (Transact-SQL) Visual Basic for Applications (VBA) Microsoft Data Transformation Services (now SSIS) SQL Server Integration Services (SSIS) Microsoft AccessData ModelingBusiness Intelligence (BI) DatabasesWindows Architecture Server Migration Database Modeling Data ArchitectureData-driven Design Data AnalysisData Analytics Database Administration (DBA) Scalability APIsRelational Database Services (RDS) Data ManagementOracle PL/SQLPL/SQL Tuning Unix Shell Scripting Data IntegrationBI Reporting Database DesignDatabase Structure Transactions Back-end Development
Artisoft
Software Engineer
2000 - 2001 (1 year)
Remote
  • Developed financial, inventory, CRM, HR, and other modules for an ERP system, "ART-AIIS".

  • Ported the business logic from an existing ColdFusion script to PL/SQL modules.

  • Ran a performance analysis and optimized time-consuming queries.

Adobe ColdFusion JavaScriptCrystal ReportsOracle8i OracleData Warehouse DesignData Warehousing ETLData pipelinesSQLVisual Basic for Applications (VBA) PL/SQLOracle RDBMS Microsoft AccessData ModelingBusiness Intelligence (BI) DatabasesWindows Architecture Server Migration Database Modeling Data ArchitectureData-driven Design Data AnalysisData Analytics eCommerce Database Administration (DBA) Scalability APIsRelational Database Services (RDS) Oracle PL/SQLPL/SQL Tuning Unix Shell Scripting Data IntegrationBI Reporting Database Transactions Database DesignDatabase Structure Transactions Back-end Development
Seavus
Software Engineer
1999 - 2000 (1 year)
Remote
  • Created a messaging service that integrated the old paging system, email, and SMS. It was used to route SMS messages from a mobile phone to pagers or email.

  • Built a commercialized browser that was used for a rich in-store customer experience. It contained customized modules for interaction and communication.

  • Developed an Internet Explorer add-on for communication with a non-standard proxy server.

Microsoft Visual C++ Visual Basic 6 (VB6) SQLMicrosoft AccessWindows Architecture eCommerce

Portfolio

Affectli

Over the years, I grew a passion for building a platform that enables users from different organizations to collaborate while keeping their data private.The existing email ecosystem offers some great features. A private server, identification of the collaborating party (also from other organizations), a clear separation of the client and the server, i.e., a wide array of email clients, each able to connect to multiple accounts/email servers. It was lacking the user's profiles, sharing of data, communication (message/chat/call), and some basic BPMS for everyday interactions.As a result, I led and architected the early development of the Affectli platform. Each of our customers hosts their Affectli instance just as they would an email server. Yet, their users can do much more. They share their data and start or participate in business processes within their organization or other organizations running Affectli.The core platform functionalities can be extended through apps (client and server modules), packages of domain-specific BPMS, data schema, and UI forms/views. The apps keep the system modularized but also made a pathway for a marketplace ecosystem through third-party developers.

Analytics Module for an ML Project

I set up a data warehouse, including a denormalized schema, aggregations, and data partitioning.The query execution times were improved dramatically, i.e., the same servers (CPU and memory) that used to support 30,000 documents now invested 100 million.The existing API included an entry point for submitting documents directly processed/analyzed here. I implemented a data pipeline by de-coupling the processing steps into separate tasks. The implementation improved API response times with more straightforward, faster, and queued requests to the ML (Python) module.

Power BI Project

I designed a data warehouse for reporting, implemented a REST API in Node.js to integrate with other third-party data sources, process data, and provide data-source endpoints for the PowerBI service. I also implemented a simple dashboard for system configuration and administration.Within Power BI, I implemented the following:• Reports and dashboards• Data transformations using Power Query for modeling the report's data source• DAX expressions in the report's UI • Row-level security limiting data scope for different user roles• Scheduling refreshing data and export of reportsI also modeled data to support the fast query execution needed for the dashboards (materialized views, aggregation, and so on).

BI Project

I designed the data warehouse used for reporting, integrated with internal organization databases and other third-party data sources using Pentaho Kettle.I then implemented reports and interactive dashboards in JasperReports. Lastly, I implemented aggregations, materialized views, and PL/SQL functions in the data warehouse used in integrations and fast query execution for reporting.

Education

Education
Diploma (Bachelor of Science Degree) in Electrical Engineering, Computer Science, and Automation
Saints Cyril and Methodius University of Skopje
1994 - 2000 (6 years)