Dejan Peshevski，马其顿斯科普里的开发者
Dejan is available for hire
Hire Dejan

Dejan Peshevski

Verified Expert  in Engineering

Software Developer

Location
Skopje, Macedonia
Toptal Member Since
June 18, 2020

Dejan是一位深受全球众多公司信赖的数据库架构师. For over a decade, 他曾在东南欧最大的几家银行做过繁重的工作，后来又去管理一家面向财富500强企业客户的初创公司. Dejan specializes in data modeling, data analysis, 和地理空间，但已经工作了整个堆栈的软件开发, front to back.

Data EngineeringData WarehousingData Warehouse DesignData AnalysisData AnalyticsBack-end DevelopmentAmazon RDSOracleETLData PipelinesDatabase TransactionsSQLT-SQL (Transact-SQL)Visual Basic for Applications (VBA)Crystal Reports

Portfolio

Syngenta
Microsoft Power BI, Amazon Web Services (AWS)， Microsoft, SQL, Enterprise...
BCG
数据工程，亚马逊网络服务(AWS)， Python，亚马逊EC2, Redshift...
(LG) GIIR America (HS Ad)
数据工程，ETL，数据管道，SQL, JavaScript...

Experience

SQL - 20 yearsPL/SQL - 20 yearsJasperReports - 9 yearsPostgreSQL - 9 yearsPostGIS - 9 yearsNode.js - 8 yearsMicrosoft Power BI - 4 yearsOracle FLEXCUBE - 3 years

Availability

Part-time

Preferred Environment

PostgreSQL, Microsoft Power BI

The most amazing...

...我所做的事情是为RingCentral提供DEEP AI系统(由BCG提供).

Work Experience

Power BI SME

2023 - PRESENT
Syngenta
  • 领导实现了20多个嵌入web应用程序的Power BI报告, 包括常规的Power BI报告和分页报告, 参数化并使用直接的本机查询和DAX.
  • 为使用PL/SQL报告查询而优化的新数据仓库建模, denormalization, aggregations, 以及PostgreSQL原生的复合和数组数据结构.
  • 利用PostGIS和Mapbox实现对地理空间数据的报告.
  • 配置数据网关和Power BI GIT回购集成.
Technologies: Microsoft Power BI, Amazon Web Services (AWS)， Microsoft, SQL, Enterprise, Azure, PostgreSQL, PostGIS, DAX, OLAP, Power Query

Lead Data Engineer

2020 - 2023
BCG
  • 实施BCG人工智能客户关系管理系统DEEP AI后端的部分内容.
  • Deployed the product for RingCentral. 实现自定义模块，支持所有类型的营销活动.
  • 领导后端开发、数据库设计、API和ETL.
Technologies: 数据工程，亚马逊网络服务(AWS)， Python，亚马逊EC2, Redshift, Data Quality, Snowflake, Azure, Python API, Data Warehouse Design, Data Warehousing, ETL, Data Pipelines, SQL, Visual Basic for Applications (VBA), PL/pgSQL, PostgreSQL, Microsoft Access, Data Modeling, Business Intelligence (BI), Databases, Architecture, Apache Airflow, Database Modeling, Data Architecture, Data-driven Design, NoSQL, Data Analysis, Data Analytics, Excel Macros, Pandas, Data Visualization, Tableau, Amazon S3 (AWS S3), Database Administration (DBA), Scalability, APIs, Relational Database Services (RDS), Data Management, IT Automation, Amazon RDS, API Integration, Dashboards, Unix Shell Scripting, Excel 365, Data Science, Django, CI/CD Pipelines, Big Data, Data Integration, BI Reporting, Database Transactions, Database Design, Database Structure, Transactions, Microsoft Excel, Back-end Development, Customer Relationship Management (CRM), OLTP, OLAP

Data Engineer

2020 - 2021
(LG) GIIR America (HS Ad)
  • 实现用于跟踪来自不同供应商的营销产品的ML服务，以深入了解供应商活动的有效性.
  • 使服务能够解析这些产品的文本内容，以识别关键元素，如产品类型, discount, gift, merchandise, and conditions that apply.
  • 对这次活动的费用作了估计, 然后将其与估计的销售额进行比较，从而深入了解该活动的有效性.
Technologies: 数据工程，ETL，数据管道，SQL, JavaScript, Visual Basic for Applications (VBA), PL/pgSQL, PostgreSQL, Node.js, JasperReports, BigQuery, Amazon Aurora, Microsoft Access, Data Modeling, Business Intelligence (BI), Databases, Architecture, Database Modeling, Data Architecture, Data-driven Design, NoSQL, Data Analysis, Data Analytics, Excel Macros, Data Visualization, Amazon S3 (AWS S3), Database Administration (DBA), Scalability, APIs, Relational Database Services (RDS), Data Management, IT Automation, Amazon RDS, API Integration, Dashboards, Unix Shell Scripting, Excel 365, Data Build Tool (dbt), Data Science, Google BigQuery, Data Integration, BI Reporting, Database Transactions, Database Design, Database Structure, Transactions, Back-end Development, Google Cloud Platform (GCP), OLAP, Power Query

Power BI/JasperReports Developer

2020 - 2020
Elite OPS
  • 在Power BI和JasperReports中实现了一个报告解决方案. 它最初是一个Power BI项目，后来转变为一个开源报告解决方案, JasperReports.
  • 使用Pentaho Kettle与内部组织数据库和其他第三方数据源集成.
  • 实现了一个使用聚合为报告查询优化的数据仓库, materialized views, and PL/SQL functions.
Technologies: JasperReports, Architecture, PostgreSQL, Pentaho Data Integration (Kettle), OLAP, Power Query

BI Engineer

2020 - 2020
The Restaurant People
  • 使用Power Query创建Power BI报表, DAX, row-level security, 定时刷新数据和导出.
  • 实现了一个为报告查询优化的数据仓库.
  • Implemented a REST API in Node.Js与其他第三方数据源集成, process data, 并为Power BI服务提供数据源端点.
  • 为系统配置和管理创建了一个简单的仪表板.
技术:商业智能(BI), Microsoft Power BI, Microsoft Excel, Business Intelligence Architecture, Restaurant Operations, Reporting, Excel Reporting, Node.. js, OData, OLAP, Power Query, Accounting

软件开发主管|软件架构师|高级软件工程师

2011 - 2017
MI-C3
  • 管理马耳他、马其顿和尼日利亚办事处30多名软件工程师组成的跨职能团队.
  • 创建一个环境，在这个环境中，每个人都可以通过清晰地沟通任务目的和提供持续的代码审查，准确地、按时地完成他们的任务, training, and assistance.
  • Found, hired, 并通过确保每个人都享受与团队在一起的时光来留住大多数团队成员. 利用每一个机会激励每个人对他们所做的事情有更大的梦想.
  • 架构并领导了私人托管协作平台Affectli的早期开发. 已在雪佛龙、纽蒙特和IHS Towers等客户部署.
  • 为哈萨克斯坦石油公司建立了架构，并领导了船队和航运管理系统的开发, a:中国石油天然气集团公司.
  • 创建系统架构，开发TagNGo数据库(TagNGo).com)，这是一种车辆跟踪和车载诊断(OBD)服务.
  • 设计并构建后端基础设施，以实现更简单、更经济的微服务开发. 它是MI-C3开发的所有产品的组成部分.
技术:GeoServer, OpenLayers, PostGIS, Node.js, D3.js, JasperReports, TIBCO, AngularJS, Activiti BPM, Java EE, PostgreSQL, Data Warehouse Design, Data Warehousing, ETL, Data Pipelines, SQL, JavaScript, Visual Basic for Applications (VBA), PL/pgSQL, SAP BusinessObjects (BO), pgRouting, Pentaho, Socket.IO, Java, MongoDB, Amazon Aurora, Spark, Spark SQL, Google Maps API, Express.js, MySQL, Microsoft Access, Data Modeling, Business Intelligence (BI), Databases, Architecture, Server Migration, Database Modeling, Data Architecture, Data-driven Design, NoSQL, Data Analysis, Data Analytics, Excel Macros, Data Visualization, Amazon S3 (AWS S3), Database Administration (DBA), Scalability, APIs, Telemetry, Relational Database Services (RDS), Data Management, IT Automation, Amazon RDS, API Integration, Dashboards, Unix Shell Scripting, Excel 365, Big Data, QGIS, ArcGIS, Spatial Databases, Data Integration, BI Reporting, Database Transactions, Database Design, Database Structure, Transactions, Geospatial Data, Back-end Development, Apache Kafka, RESTful Microservices, OLTP, OLAP

Senior BI/Data Engineer

2008 - 2010
Alpha Bank
  • 通过开发评估银行风险敞口(信贷)的统计模型(基于hmm -隐马尔可夫模型)，支持巴塞尔II监管标准的实施, liquidity, currency, and interest rate risk).
  • 通过开发交叉检查报告来验证新系统的正确配置和操作，支持迁移到Oracle FLEXCUBE.
  • 构建一个模块，该模块根据来自所有系统模块的配置和活动条目独立生成所有会计记录(和其他中间表).
  • 为这个模块做出了贡献——一个根据银行规范制定的银行系统, 完成FLEXCUBE在用户输入后对数据所做的所有工作. 将这些记录与FLEXCUBE的记录进行比较，以检查是否一切就绪.
  • 开发与贷款、存款、资金转移和整体会计相关的报告和ETL.
  • 在建立当地法规要求的项目中实施数据分析, 转换帐目图表和中央银行审计.
  • 完成季度和年度财务报告.
技术:Visual Basic for Applications (VBA), SAP业务对象数据服务(BODS), Oracle FLEXCUBE, Oracle 10g, Oracle, Data Warehouse Design, Data Warehousing, ETL, Data Pipelines, SQL, PL/SQL, Oracle RDBMS, SAP BusinessObjects (BO), Java, Microsoft Access, Data Modeling, Business Intelligence (BI), Databases, Windows, Architecture, Server Migration, Database Modeling, Data Architecture, Data-driven Design, Data Analysis, Data Analytics, Excel Macros, Data Visualization, Database Administration (DBA), Scalability, Relational Database Services (RDS), Data Management, Dashboards, Oracle PL/SQL, PL/SQL Tuning, Unix Shell Scripting, Excel 365, Data Integration, BI Reporting, Database Transactions, Database Design, Database Structure, Transactions, Microsoft Excel, Back-end Development, OLTP, OLAP, Accounting, Financial Risk Management, Finance, Risk Management, Banking & Finance

Operations Supervisor

2003 - 2008
Intralot SA
  • 监督新产品(乐透)的采用, bingo, scratch tickets, and betting) from system operation, training, regulatory and market perspectives.
  • 监督当地客户马其顿彩票公司的技术操作.
  • 开发支持运营的产品，完成涉及ETL的任务, winnings calculation, 在竞争对手的网站上搜索报价, and risk assessment (e.g., Dutch Booking).
  • 执行运营要求和销售/市场分析. Prepared financial reports.
技术:Visual Basic for Applications (VBA), Crystal Reports, Oracle9i, Oracle, Data Warehouse Design, Data Warehousing, ETL, Data Pipelines, SQL, PL/SQL, Oracle RDBMS, SQL Server集成服务(SSIS), Microsoft Access, Data Modeling, Business Intelligence (BI), Databases, Windows, Architecture, Server Migration, Database Modeling, Data Architecture, Data-driven Design, Data Analysis, Data Analytics, Excel Macros, Database Administration (DBA), Scalability, Relational Database Services (RDS), Data Management, Oracle PL/SQL, PL/SQL Tuning, Unix Shell Scripting, Excel 365, Data Integration, BI Reporting, Database Transactions, Database Design, Database Structure, Transactions, Microsoft Excel, Back-end Development, OLAP, Accounting, Risk Management, Banking & Finance

Senior Software Engineer

2001 - 2003
National Bank of Greece
  • 领导开发基于web的贷款申请处理系统(E-loans).nbg.gr).
  • 围绕InTempo工作流引擎构建了一个web服务, for the client side, 仅与服务交换数据的单页面应用程序. 这种设置减少了网络流量，改善了应用程序的响应.
  • 开发了一个JavaScript库，功能类似于今天的Angular/React. 该库为数据绑定的声明性定义和复杂数据结构的表单组件和模板的定义提供了方法.
  • 架构的解决方案被接受为真正简单易用，并在Internet Explorer停止运行时存活了15年.
  • 为运行GLOBUS (Temenos T24前身)的国外子公司开发ETL程序.
  • 将旧的DBASE应用程序迁移到Microsoft平台(Microsoft SQL Server), Visual Basic, and DCOM).
Technologies: BPM, DTS, Database Transactions, SQL, ASP, JavaScript, Visual Basic 6 (VB6), Microsoft SQL Server, Data Warehouse Design, Data Warehousing, ETL, Data Pipelines, T-SQL (Transact-SQL), Visual Basic for Applications (VBA), SQL Server集成服务(SSIS), Microsoft Access, Data Modeling, Business Intelligence (BI), Databases, Windows, Architecture, Server Migration, Database Modeling, Data Architecture, Data-driven Design, Data Analysis, Data Analytics, Database Administration (DBA), Scalability, APIs, Relational Database Services (RDS), Data Management, Oracle PL/SQL, PL/SQL Tuning, Unix Shell Scripting, Data Integration, BI Reporting, Database Design, Database Structure, Transactions, Back-end Development, RESTful Microservices, OLTP, OLAP, Accounting, Finance, Banking & Finance

Software Engineer

2000 - 2001
Artisoft
  • 为ERP系统“ART-AIIS”开发财务、库存、CRM、HR等模块。.
  • 将业务逻辑从现有ColdFusion脚本移植到PL/SQL模块.
  • 运行性能分析并优化耗时查询.
Technologies: Adobe ColdFusion, JavaScript, Crystal Reports, Oracle8i, Oracle, Data Warehouse Design, Data Warehousing, ETL, Data Pipelines, SQL, Visual Basic for Applications (VBA), PL/SQL, Oracle RDBMS, Microsoft Access, Data Modeling, Business Intelligence (BI), Databases, Windows, Architecture, Server Migration, Database Modeling, Data Architecture, Data-driven Design, Data Analysis, Data Analytics, eCommerce, Database Administration (DBA), Scalability, APIs, Relational Database Services (RDS), Oracle PL/SQL, PL/SQL Tuning, Unix Shell Scripting, Data Integration, BI Reporting, Database Transactions, Database Design, Database Structure, Transactions, Back-end Development, RESTful Microservices, OLTP, OLAP, Accounting

Software Engineer

1999 - 2000
Seavus
  • 创建了一个集成了旧的寻呼系统、电子邮件和SMS的消息传递服务. 它被用来将短信从手机发送到传呼机或电子邮件.
  • 构建了一个商业化的浏览器，用于丰富的店内客户体验. 它包含用于交互和通信的定制模块.
  • 开发了一个Internet Explorer插件，用于与非标准代理服务器通信.
Technologies: Microsoft Visual C++, Visual Basic 6 (VB6), SQL, Microsoft Access, Windows, Architecture, eCommerce

Affectli

http://affectli.com
Over the years, 我对建立一个平台充满了热情，这个平台可以让来自不同组织的用户在保持数据隐私的同时进行协作.

现有的电子邮件生态系统提供了一些很棒的功能. A private server, 识别合作方(也来自其他组织), 客户端和服务器的明确分离, i.e.，一个广泛的电子邮件客户端，每个能够连接到多个帐户/电子邮件服务器. It was lacking the user's profiles, sharing of data, communication (message/chat/call), 以及一些日常互动的基本BPMS.

因此，我领导并构建了Affectli平台的早期开发. 我们的每个客户都托管他们的Affectli实例，就像他们托管电子邮件服务器一样. Yet, their users can do much more. 他们共享他们的数据，并在他们的组织或运行Affectli的其他组织中启动或参与业务流程.

核心平台功能可以通过应用程序(客户端和服务器模块)进行扩展。, packages of domain-specific BPMS, data schema, and UI forms/views. 这些应用程序保持了系统的模块化，但也通过第三方开发商为市场生态系统开辟了一条途径.

Analytics Module for an ML Project

我为一家AI初创公司实施了一个数据仓库解决方案，该公司已经通过了POC阶段，正在寻求扩展.

通过使用非规范化模式扩展现有模型，我改进了查询执行时间, aggregations, 以及API中数据的划分和解耦处理. 在相同的成本下，吞吐量提高了3000倍. Effectively, POC阶段占用的资源用于处理30,000 documents, and after the enhancement, 这些相同的资源能够在相同的时间框架内处理1亿个文档，而不需要额外的费用.

Delivering DEEP AI for RingCentral

http://www.bcg.com/beyond-consulting/bcg-gamma/ai-powered-customer-management
我领导了BCG基于AI的CRM解决方案DEEP AI后端模块的开发.

我支持这个项目两年多了, 扩展它的功能，并与客户和产品交付团队密切合作，以收集和记录过程和需求.

我对前端应用程序的数据库模式和用于AI模型的分析数据库进行了建模.

I implemented the functions of:
• Application API
• Back-end processes
•与客户内部数据和服务以及其他第三方系统的集成

Languages

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

Frameworks

AngularJS, Express.js, Spark, Angular, Activiti BPM, ASP, Hadoop, Django

Libraries/APIs

JasperReports, Node.js, D3.. js, p注浆，OpenLayers，谷歌地图API, Pandas, Socket.IO, Python API, ArcGIS

Tools

Crystal Reports, Oracle FLEXCUBE, Microsoft Power BI, Microsoft Access, BigQuery, Microsoft Excel, Power Query, Spark SQL, Apache Airflow, Tableau, Pentaho Data Integration (Kettle), DTS, Microsoft Visual C++, Adobe ColdFusion

Paradigms

ETL, Business Intelligence (BI), Data-driven Design, Spatial Databases, Database Design, OLAP, Data Science

Platforms

Oracle, Windows, Pentaho, Amazon Web Services (AWS), Azure, Apache Kafka, Google Cloud Platform (GCP), Java EE, Amazon EC2, Microsoft

Storage

Data Pipelines, Redshift, Database Transactions, PostgreSQL, PostGIS, PL/SQL, Microsoft SQL Server, MySQL, Oracle RDBMS, GeoServer, Databases, Database Modeling, NoSQL, Database Administration (DBA), Oracle PL/SQL, Data Integration, Database Structure, OLTP, SQL Server Reporting Services (SSRS), SQL Server集成服务(SSIS), Amazon Aurora, MongoDB, Oracle 10g, Oracle9i, Amazon S3 (AWS S3)

Industry Expertise

Accounting, Banking & Finance

Other

Data Engineering, Data Warehousing, Data Warehouse Design, SAP BusinessObjects (BO), Data Modeling, Architecture, Server Migration, Data Architecture, Data Analysis, Data Analytics, Excel Macros, Scalability, APIs, Relational Database Services (RDS), Data Management, Amazon RDS, API Integration, Dashboards, PL/SQL Tuning, Excel 365, BI Reporting, Transactions, Geospatial Data, Back-end Development, RESTful Microservices, DAX, Data Visualization, Google BigQuery, Financial Risk Management, Finance, Risk Management, TypeORM, TIBCO, SAP业务对象数据服务(BODS), BPM, Oracle8i, Big Data, Data Quality, Software Engineering, eCommerce, Telemetry, IT Automation, Unix Shell Scripting, Data Build Tool (dbt), CI/CD Pipelines, QGIS, Enterprise, Business Intelligence Architecture, Restaurant Operations, Reporting, Excel Reporting, OData, Customer Relationship Management (CRM)

1994 - 2000

电气工程、计算机科学或自动化专业本科以上学历

斯科普里圣徒西里尔和梅迪奥大学-斯科普里，马其顿