Dejan Peshevski, Software Developer in Skopje, Macedonia
Dejan Peshevski

Software Developer in Skopje, Macedonia

Member since June 18, 2020
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.
Dejan is now available for hire

Portfolio

  • MI-C3
    GeoServer, OpenLayers, PostGIS, Node.js, D3.js, JasperReports, TIBCO...
  • Alpha Bank
    Visual Basic for Applications (VBA), SAP BusinessObjects Data Service (BODS)...
  • Intralot SA
    Visual Basic for Applications (VBA), ETL, Crystal Reports, Oracle9i

Experience

Location

Skopje, Macedonia

Availability

Part-time

Preferred Environment

PostgreSQL

The most amazing...

...piece of work I've done was building a privately hosted collaboration platform aiming to simplify interactions between organizations.

Employment

  • Head of Software Development | Software Architect | Senior Software Engineer

    2011 - 2017
    MI-C3
    • Managed several 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. Among clients like Chevron and Newmont, IHS Towers uses Affectli to collaboratively manage their assets with third parties also running their own instances of Affectli. Oversaw the development of a custom module provisioned by IHS, an app supporting their specific day-to-day operations.
    • Built the architecture and led the development of a fleet and shipping management system for Petro Kazakhstan, a CPNC: China National Petroleum Company. The system supports the management of shipping and receiving products by railway, pipeline, and trucks. Provides fleet management, maintenance, and tracking and generates shipping documentation and reporting (orders, shipments, waybills, acts, analytical reports).
    • Created the system architecture and developed the database of TagNGo (Tagngo.com), a vehicle tracking and an on-board diagnostics (OBD) service featuring data sharing and views of tracking history, personal safety, driving performance assessment and analytics.
    • Designed and built a back-end infrastructure for a simpler and cost-effective microservice development. It is an integral part of all the products developed at MI-C3. It does not use an ORM so they do not need Java or PHP developers for most of their back end. Instead, much of the work is done by repurposing database developers already doing business intelligence tasks.
    Technologies: GeoServer, OpenLayers, PostGIS, Node.js, D3.js, JasperReports, TIBCO, AngularJS, Activiti BPM, Java EE, PostgreSQL
  • Senior BI/Data Engineer

    2008 - 2010
    Alpha Bank
    • 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 modules of the system. Basically, it was a banking system made according to the bank’s specifications. It was doing 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 is 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 chart of accounts, and central bank audits.
    • Performed quarterly and annual financial reporting, MIS.
    Technologies: Visual Basic for Applications (VBA), SAP BusinessObjects Data Service (BODS), Oracle FLEXCUBE, Oracle 10g
  • Operations Supervisor

    2003 - 2008
    Intralot SA
    • Oversaw the adoption of the 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 did risk assessment (e.g., Dutch Booking).
    • Performed operational requirements and sales/market analyses.
    • Prepared financial reports.
    Technologies: Visual Basic for Applications (VBA), ETL, Crystal Reports, Oracle9i
  • Senior Software Engineer

    2001 - 2003
    National Bank of Greece
    • Served as the technical lead behind the 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 setup 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. Other team members implemented the project requirements as they would in an Excel formula (e.g., some field’s value would be defined to be calculated as an expression based on other fields’ values or in another case validate its value, again, based on some expression). The solution was accepted as genuinely simple to use and survived in operation for 15 more years.
    • Developed ETL procedures for the foreign subsidiaries running GLOBUS (Temenos T24 predecessor).
    • Migrated older DBASE applications to Microsoft platform (Microsoft SQL Server, Visual Basic, and DCOM).
    Technologies: BPM, ETL, DTS, Database Transactions, SQL, ASP, JavaScript, Visual Basic 6 (VB6), Microsoft SQL Server
  • Software Engineer

    2000 - 2001
    Artisoft
    • Developed financial, inventory, CRM, HR, and other modules for an ERP system "ART-AIIS".
    • Ported the business logic from an existing ColdFusion scripts to PL/SQL modules.
    • Optimized time-consuming queries.
    Technologies: Adobe ColdFusion, JavaScript, Crystal Reports, Oracle8i
  • Software Engineer

    1999 - 2000
    Seavus
    • Created a messaging service which integrated the old paging system, email, and SMS. It was used to route SMS messages sent from a mobile phone to pagers or to 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.
    Technologies: Microsoft Visual C++, Visual Basic 6 (VB6)

Experience

  • 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. What it was lacking was 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 would an email server. Yet, their users can do much more. They share their data and start or participate in business processes within their own organization or at other organizations also running Affectli.

    The core platform functionalities can be extended through Affectli apps (client and/or server modules), packages of domain-specific BPMS, data schema, and UI forms/views. The apps are keeping the system modularized, but they also make a pathway for a marketplace ecosystem through third-party developers.

  • Analytics Module for an ML Project

    I set up a data warehouse which included a denormalized schema, aggregations, and data partitioning.

    The query execution times were improved dramatically, i.e., the same servers (CPU and memory) which used to support 30,000 documents now supported 100 million documents.

    The existing API included an entry point for submitting documents that were directly processed/analyzed here. I implemented a data-pipeline by de-coupling the processing steps into separate tasks. With simpler, faster, and queued requests to the ML (Python) module, the implementation improved the API response times.

  • Power BI Project (via Toptal)

    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:
    • 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 reports

    I also modeled data to support fast query execution needed for the dashboards (materialized views, aggregation, and so on).

  • BI Project (via Toptal)

    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 datawarehouse used in integrations and fast query execution for reporting.

Skills

  • Languages

    SQL, PL/pgSQL, JavaScript, Transact-SQL, Visual Basic for Applications (VBA), Snowflake, Python, Visual Basic 6 (VB6), Java
  • Frameworks

    AngularJS, Express.js, Spark, Angular, Activiti BPM, ASP
  • Libraries/APIs

    JasperReports, Node.js, D3.js, pgRouting, OpenLayers, Google Maps API, Socket.IO
  • Tools

    Crystal Reports, Oracle FLEXCUBE, Microsoft Power BI, Microsoft Access, BigQuery, Spark SQL, Pentaho Data Integration (Kettle), DTS, Microsoft Visual C++, Adobe ColdFusion
  • Paradigms

    ETL
  • Platforms

    Oracle, Pentaho, Amazon Web Services (AWS), Java EE
  • Storage

    Data Pipelines, Redshift, PostgreSQL, PostGIS, PL/SQL, Microsoft SQL Server, MySQL, Oracle RDBMS, GeoServer, SQL Server Integration Services (SSIS), Amazon Aurora, MongoDB, Oracle 10g, Oracle9i, Database Transactions
  • Other

    Data Engineering, Data Warehousing, Data Warehouse Design, SAP BusinessObjects (BO), Microsoft Data Transformation Services (now SSIS), TypeORM, TIBCO, SAP BusinessObjects Data Service (BODS), BPM, Oracle8i

Education

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

To view more profiles

Join Toptal
Share it with others