Denis Saatciu

Managed the design of a DW in Azure SQL for a healthcare company in the US.

Main Tasks and Responsibilities
• Developed a layer of views that selected data from CSV files.
• Built ETL procedures to get data from views and insert data in tables stored as parquet files.
• Used Azure Data Factory pipelines to run the ETL procedure and Azure Synapse Serverless.

The system manages the registration of trucks and batteries rented to different clients. Led the design of a DW and development of all ETL procedures

Measure data were transmitted automatically by the devices. The old system used Master Data Services to manage the data, which concluded in a not consistent database.

As part of the project, I redesigned the database model, implemented it in Azure SQL, and built the migration procedures from the old system to the new migration procedures, which required data cleansing and data gap-filling.

Managed the design of a Grant Management and Accounting System for a local NGO.

The system was developed using an in-house BPMN platform and included the application, grant, and payments registration.

Planned the budget and accounting systems, built all of the system's logic, and designed all the processes and workflow.

I also developed all calculation procedures in SQL and designed the reporting system using XML and XLT.

Designed a system to register budget planning and execution for municipalities. The system registered municipalities reports for incomes and expenses for budgetary programs.

I designed a model to register all products and indicators used to evaluate the municipality's performance. The systems used allowed reporting on several periods for every financial year.

I used an in-house BPMN platform to design and develop the system. Built all SQL stored procedures for the calculation and created them to generate new reports from existing ones.

Developed a reporting system using SQL functions that produce data in XML and designed reports using XML/XLT.

Designed a system for management of a Non-performing loan portfolio for a FI.

I was the business analyst for the product and designer of product mockups. I built the calculation procedures in SQL and acted as the project's PM in a team of four developers

Designed a permanent control system for a second level bank.

I was the business analyst and designer of product mockups, and I built the calculation procedures in SQL and the generation of the scheduled controls.

Acted as the project's PM in a team of four developers.

I designed a DW that accommodates data from different sources like Albanian cadaster and data entry from field visits for parcels affected by the Trans Atlantic pipeline. The DW was synchronized with the central DW with data from all countries involved by the Tropical Agriculture Platform (TAP).

I designed a system that used data from the DW and built a generic design for the generation of over 40,000 contracts developed in PHP.

I designed a factoring system for a financial institution. Part of the business analyzes teams to model factoring types used by the institution and product mockups designs.

I built the calculation procedures in SQL and acted as the project's PM.

I developed a system in PHP to scan booklets used for meteorological data for the period 1990 to 2010 in Albania.

Main Tasks and Responsibilities
• Building a database to accommodate the data.
• Creation of a system to register data based on scanned photos.
• Development of SQL procedures to convert data in time series.
• Development of SQL procedures that used statistics theory to mark suspicious data or correct wrong data.

The institution used local software for loans management and implemented Oracle EBS as the ERP.

I designed a DW in Oracle ad built the ETL to get the data from both sources. Used Oracle BI to create all reports for the institution.

Implemented SN-Sphere, a product created to analyze transactions, and built a model to convert table data to a tree model.

Used by the government to analyze banking and notary transactions.

Main Tasks and Responsibilities
• Installation and configurations of Oracle DB servers.
• Installation and configurations of Windows Server 2003.
• Installation and configurations of application software SN-Sphere
• Analysis and development of a database schema.
• Analysis and development of a reporting system.
• Data cleansing and migration from legacy systems.
• Troubleshooting problems related to infrastructure technology and application software.
• User training on the anti-money laundering application software (SN-Sphere).

Implemented an E-Business Suite ERP for the Albanian State Police in the finance, logistic, and HR department.

Main Tasks and Responsibilities
• Installation and customizing of Oracle applications servers and Oracle DB servers.
• Consultation in implementing the inventory and logistics modules of Oracle EBS.
• Troubleshooting of databases and Integrated Analytics Systems (IAS).
• Data migration from legacy systems.
• User pieces of training on Oracle EBS logistics module and Oracle technology.

A system used by the Ministry of Integration to register all actions and activities needed to improve Albania's legislation based on EU best practices.

Main Tasks and Responsibilities
• Database analyzing and building using Microsoft SQL Server.
• Application analysis and building with PHP.
• Reporting system analysis and building with Crystal Report and Arcana Report Commander.