Carine is available for hire
Hire CarineCarine Maalouf
Verified Expert in Engineering
Data Engineer and Developer
Location
Sydney, New South Wales, Australia
Toptal Member Since
June 18, 2020
Carine is an experienced Microsoft SQL Server developer and administrator with a professional history of working in the computer software industry. She's skilled in C#.Net, WPF, MVC, Web API, requirements analysis, finance with strong interpersonal skills, communication skills, and demonstrated experience in team leading. She has completed a Master's of Computer Engineering degree from Conservatoire National des Arts et Métiers – Paris.
Portfolio
RMSolutions Inc
Azure Data Factory, Azure Logic Apps, Azure SQL, Data Modeling, Microsoft Excel...
Catholic Education Office
Microsoft Power BI, Azure Pipelines, Azure Data Factory, Azure SQL Databases...
Catholic Education Office
Dell Boomi, Microsoft Visual Studio, Microsoft InfoPath, Microsoft...
Experience
Availability
Part-time
Preferred Environment
Windows, Microsoft Visual Studio, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Management Studio (SSMS)
The most amazing...
...thing I've worked on was the migration of the software from Delphi to C#. This migration encapsulates the reengineering from a Client/Server to a SOA Software.
Work Experience
Database Developer
2021 - PRESENT
RMSolutions Inc
- Created a design data model to load customer data from mail, Microsoft Teams, and Sharepoint.
- Developed Azure Data Factory ETL to load data into an Azure SQL Server database.
- Developed Azure Logic apps to listen to Office 365 Outlook.
Technologies: Azure Data Factory, Azure Logic Apps, Azure SQL, Data Modeling, Microsoft Excel, ETL, Data Engineering, SQL, XML, T-SQL (Transact-SQL), Microsoft Power Automate
Data Discovery and Analytics
2015 - PRESENT
Catholic Education Office
- Developed and published a large number of reports using Microsoft Power BI. The data is extracted from different sources, including MS SQL Server, Microsoft Excel, Web API, and Microsoft Sharepoint.
- Developed a student enrollment dashboard using Microsoft Power BI. The data is extracted using a GraphQL query.
- Built a student census dashboard using Microsoft Power BI. The data is extracted using an SQL query.
- Created a data pipeline (Azure Blob Storage) using Azure Data Factory.
Technologies: Microsoft Power BI, Azure Pipelines, Azure Data Factory, Azure SQL Databases, Microsoft Excel, Microsoft Data Transformation Services (now SSIS), ETL, SQL, XML, T-SQL (Transact-SQL)
Database Administrator | Business Applications IT Officer
2015 - PRESENT
Catholic Education Office
- Created multiple database designs by performing needs and requirements analysis, creating a logical model, and then implementing the physical model. Integrated empower and PageUp People, online enrolment, and Maze with the Dell Boomi platform.
- Migrated, developed, and deployed many reports for different service areas and users using SSRS. Created multiple SSIS packages to move data in and out of databases. Wrote numerous PowerShell scripts to automate different DBA tasks.
- Worked on the back end and the development of the eForms using SQL Server and InfoPath hosted on SharePoint. Developed the WCF data services of the SignMe project and the admin portal of the SignMe V2 project using the MVC design pattern.
- Exported data into Microsoft Excel, PDF, and XML and created a Query API using GraphQL.
- Handled administration of the production database of 56 schools and the server hosting the SharePoint Server, ensuring all database servers were backed up and performing test backups.
- Configured SQL Server monitoring utilities. Installed and configured new SQL Servers. Deployed database change scripts. Designed indexes for existing applications, choosing when to add or remove indexes.
- Handled users' complaints about the performance of a particular query, helping developers improve the performance of that query by tweaking it or modifying indexes.
- Advised developers on the most efficient database designs like tables, data types, stored procedures, functions, and more. Used profiler traces.
- Installed different versions of Microsoft SQL Server (2014, 2016, 2017, 2019) as the back end for Lync 2013 Central Management, System Center Configuration Manager (SCCM) server, and Microsoft SharePoint.
Technologies: Dell Boomi, Microsoft Visual Studio, Microsoft InfoPath, Microsoft, Microsoft SQL Server, Database Administration (DBA), Microsoft Excel, SQL, C#.NET, .NET, SQL Server Reporting Services (SSRS), XML, Windows PowerShell, ASP.NET Web API, T-SQL (Transact-SQL)
Boomi Developer
2023 - 2023
HMGoG
- Developed a Boomi integration process for tax service allowing individuals and corporate to submit their tax return and generate the certificate of submission.
- Tracked and fixed bugs in production using Jira as a reporting tool.
- Integrated the tax service with Morph middle office using APIs.
Technologies: SQL, Dell Boomi, APIs
Power BI and Excel Developer
2022 - 2023
Elizabeth Beasley
- Created an Excel template to be used by the teacher to fill the student assessment data.
- Created Power BI datasets, getting the data from Excel files published on Sharepoint. The dataset is automatically refreshed on file change using Power Automate.
- Built a paginated report based on the Power BI dataset used to generate the school report in PDF format using Power Automate.
- Created a Power BI dashboard used by the principal and teacher to analyze student results.
Technologies: Microsoft Power BI, Microsoft Excel, Data Visualization, Microsoft Power Automate
Senior Microsoft BI Developer
2022 - 2022
Struber Systems Pty Ltd
- Created a Power BI dataset, getting data from different sources Acello, Xero, and Excel files published on SharePoint.
- Created a Power BI custom connector to get the data from Accello and Xero using API. The custom connector uses OAUth2 authentication.
- Built a utilization dashboard allowing the business to track scheduled billed vs. actual billed.
- Developed an aged debtor dashboard, bringing together the four companies' aged debtors into one dashboard view for better tracking with the ability to drill down to individual companies. The dashboard shows current bank balances and credit card balances.
- Developed individual client dashboards for tracking metrics from Accelo.
Technologies: Microsoft Power BI, Dashboard Design, Dashboards, User Interface (UI), Microsoft Power Automate
Access Database Designer and Developer
2022 - 2022
SAPA SpA
- Created the database design to manage the component production system.
- Migrated the data from excel to Microsoft SQL Server.
- Created an admin portal to manage providers, customers, components parts, and component history.
Technologies: SQL, Microsoft Excel, Microsoft Power BI, Retool, ASP.NET Core 2, ASP.NET MVC, Microsoft SQL Server
Technical Specialist: Data Integration
2020 - 2021
Catholic Education Office
- Contributed to the integration between the online enrolment system and school administration system using IICS data integration.
- Took responsibility for business analysis and requirements collection. Designed and customized data models for staging database on Microsoft SQL Azure.
- Built the ETL architecture and source-to-target mapping to load data into staging DB. Created mapping documents to outline data flow from sources to targets.
- Extracted the JSON data from the online enrolment system API into a staging area in IICS using the Hierarchy Parser.
- Used various transformations like Filter, Router, Expression, Aggregator, and Lookup to develop robust mappings in the Informatica Cloud mapping designer.
Technologies: Microsoft SQL Server, Informatica ETL, Database Design, SharePoint 2013, Agile, Web API, JSON, Informatica Intelligent Cloud Services (IICS), Microsoft Access, Microsoft Excel, Microsoft Data Transformation Services (now SSIS), ETL, Data Engineering, SQL, C#.NET, .NET, XML, Windows PowerShell, SQL Server Integration Services (SSIS)
ASP.NET and C# Developer
2020 - 2021
Horseracing Professionals Pty Ltd
- Developed a back-end module for a membership platform where members can access tips, download results, subscribe to a new service, and buy subscriptions (monthly and quarterly) to receive tips on horse betting.
- Created an admin portal section to manage members, subscriptions, loyalty credits, promo codes, discounts, and bonuses.
- Integrated the platform with Google Analytics. All transactions (buy and refund) are integrated directly into Google Analytics using Google Analytics API.
Technologies: ASP.NET MVC, ASP.NET Core 2, Azure SQL Databases, Google Analytics API, CSS, JavaScript, HTML5, .NET Core, Google Analytics, Node.js, Microsoft Excel, SQL, C#.NET, .NET, XML, Windows PowerShell, ASP.NET Web API
Senior C# Developer
2006 - 2014
Omega Financial Solution
- Integrated the GAIA product with multiple platforms, including Bloomberg, Reuter, SAS, Murex, and Assurex.
- Designed and implemented the Omega audit system allowing the audit department of our clients to audit the system on multiple levels, including login auditing, database schema auditing, and data auditing.
- Implemented and designed the Omega Reporting System allowing our clients to design and generate their reports using a user-friendly interface.
- Contributed to the design, implementation, and performance tuning of different user interface components used in the migration from Delphi 6.0 to Microsoft .NET using Visual Studio 2010.
- Migrated the Omega Portfolio Management Software from Borland Delphi 6.0 to Microsoft .NET using Visual Studio 2010.
- Developed an Excel add-in extracting data from Web API and refreshed automatically once the data changed.
Technologies: Windows Communication Foundation (WCF), Windows Presentation Foundation (WPF), Microsoft, Microsoft SQL Server, Excel Add-ins, Web API, FIX Protocol, JSON, WCF Web Services, Microsoft Access, Microsoft Excel, Microsoft Data Transformation Services (now SSIS), SQL, C#.NET, .NET, SQL Server Reporting Services (SSRS), XML, Windows PowerShell, SQL Server Integration Services (SSIS), ASP.NET Web API, Bloomberg API
Senior Developer
2002 - 2006
Internet-Facilities Group
- Developed a school management system ASP.NET web application, an ERP distributed solution, and a press article management system using C#.NET and Microsoft SQL Server as back end. An ERP using C#.NET and Microsoft SQL Server as back end.
- Created the Beirut stock exchange data warehouse using Microsoft SQL Server, SSIS, and SSRS. It includes the conception of the data model, data gathering from legacy databases, multidimensional model, and data navigation and report generation.
- Automated the workflow of the Consumer Protection Department of the Ministry of Economy and Trade using C#.NET and Microsoft SQL Server.
Technologies: SQL Server Reporting Services (SSRS), DTS, Microsoft Visual Studio, Microsoft SQL Server, Visual Basic for Applications (VBA), Microsoft Access, Microsoft Excel, Microsoft Data Transformation Services (now SSIS), SQL, C#.NET, .NET, XML
Experience
Omega Audit System
I implemented and designed the Omega audit system, allowing our clients' audit department to audit the system on multiple levels, including login auditing, database schema auditing, and data auditing. The client-side of this application is developed using Visual Studio .NET (C#.NET).
Omega Reporting System
I designed and handled the implementation of the Omega reporting system that allows our clients to create and generate their reports using a user-friendly interface developed using Visual Studio .NET (C#.NET) and Microsoft Reporting Services.
Omega Portfolio Management
I handled the migration of the Omega portfolio management software from Borland Delphi 6.0 to Microsoft .NET using Visual Studio 2010.
This migration encapsulates the reengineering of the software from a client and server application to a service-oriented software offering multiple services distributed using web services.
The reengineering encapsulates the development of multiple frameworks:
•Data Access Framework
•Exception Management Framework
•Security Management Framework
•Resource Management Framework
•Profile Management Framework
The UI is implemented using WPF, and the web services are implemented using WCF. Multiple components were developed in-house to respond to GAIA specifications such as filtered textbox, child window, animated tab control, image button, masked textbox, progress dialog.
The application supports multiple skins depending on the environment. The software is implemented using the MVVM pattern. It uses WPF data binding to connect the user interface to the business logic and validate the data by associating multiple validation rules.
This migration encapsulates the reengineering of the software from a client and server application to a service-oriented software offering multiple services distributed using web services.
The reengineering encapsulates the development of multiple frameworks:
•Data Access Framework
•Exception Management Framework
•Security Management Framework
•Resource Management Framework
•Profile Management Framework
The UI is implemented using WPF, and the web services are implemented using WCF. Multiple components were developed in-house to respond to GAIA specifications such as filtered textbox, child window, animated tab control, image button, masked textbox, progress dialog.
The application supports multiple skins depending on the environment. The software is implemented using the MVVM pattern. It uses WPF data binding to connect the user interface to the business logic and validate the data by associating multiple validation rules.
Enterprise Resource Planning
I handled an ERP (enterprise resource planning) distributed solution. This solution contains several modules:
•Accounting
•Stock management
•Payroll management
•Asset management
•Order management
•Production management
The client-side of this application is developed using Visual Studio .NET (C#.NET). The database engine is developed using Microsoft SQL Server 2000.
•Accounting
•Stock management
•Payroll management
•Asset management
•Order management
•Production management
The client-side of this application is developed using Visual Studio .NET (C#.NET). The database engine is developed using Microsoft SQL Server 2000.
School Management System
I worked on a web application for a school management system. This solution contains several modules:
•Registration and enrollment
•Student demographics and family units
•Daily or class attendance
•Master schedule and course management
•Graduation requirements, transcripts, GPA, honor roll, grades, and report cards
•Custom reporting, labels, graphs, and more
•School-to-home communication
•Discipline monitoring
The client-side of this application is developed using Visual Studio .NET (ASP.NET), and the database engine is Microsoft SQL Server 2000.
•Registration and enrollment
•Student demographics and family units
•Daily or class attendance
•Master schedule and course management
•Graduation requirements, transcripts, GPA, honor roll, grades, and report cards
•Custom reporting, labels, graphs, and more
•School-to-home communication
•Discipline monitoring
The client-side of this application is developed using Visual Studio .NET (ASP.NET), and the database engine is Microsoft SQL Server 2000.
Press Articles Management
I created a press articles management system for L’Orient Le Jour. This system manages articles that are to be sold on the web. The solution consists of two modules:
•The back office to maintain the articles to be sold (PDF or plain text)
•Deployed the front-end on the web where the user can search and buy a chosen article
This application is developed using Visual Studio.NET (ASP.NET), the database engine is Microsoft SQL Server 2000, and the search engine is based on Microsoft SQL server 2000 and full-text search.
•The back office to maintain the articles to be sold (PDF or plain text)
•Deployed the front-end on the web where the user can search and buy a chosen article
This application is developed using Visual Studio.NET (ASP.NET), the database engine is Microsoft SQL Server 2000, and the search engine is based on Microsoft SQL server 2000 and full-text search.
Beirut Stock Exchange Data Warehouse
I developed the Beirut stock exchange data warehouse. This application includes the conception of the data model, data gathering from legacy databases, multidimensional model, and finally, data navigation and report generation.
This application is developed using Visual Studio .NET, C#, and .NET. The database engine is Microsoft SQL Server 2000; the data is imported regularly using a DTS (data transformation service). OLAP cubes are stored using Microsoft SQL Server 2000 Analysis Services. The data navigation component is developed using Microsoft Visual Studio .NET (ASP.NET). The reports are authored, managed, and delivered using Microsoft SQL Server 2000 Reporting Services.
This application is developed using Visual Studio .NET, C#, and .NET. The database engine is Microsoft SQL Server 2000; the data is imported regularly using a DTS (data transformation service). OLAP cubes are stored using Microsoft SQL Server 2000 Analysis Services. The data navigation component is developed using Microsoft Visual Studio .NET (ASP.NET). The reports are authored, managed, and delivered using Microsoft SQL Server 2000 Reporting Services.
Actisuite
I developed an interactive plugin for Microsoft Windows XP Media Center. The client-side of this plugin is based on DHTML, JavaScript, and HyperText components (HTC) communicating with XML web services.
SignMe In
I designed, developed, and deployed WCF data services and the admin portal of the SignMe V2 project using the MVC design pattern.
The client-side of this application was developed using Visual Studio and .NET MVC. The database engine was developed using Microsoft SQL Server 2017.
The client-side of this application was developed using Visual Studio and .NET MVC. The database engine was developed using Microsoft SQL Server 2017.
SOS System
I created an SOS foster care management system. The application is used to save the children and caregivers' data and assign the children to a specific family for a certain period.
This application is developed using Microsoft Access and VBA.
This application is developed using Microsoft Access and VBA.
Skills
Languages
SQL, C#.NET, JavaScript, CSS, HTML5, XML, Visual Basic for Applications (VBA), T-SQL (Transact-SQL)
Frameworks
Windows PowerShell, ASP.NET MVC, Windows Presentation Foundation (WPF), .NET, .NET Core, ASP.NET Web API, ASP.NET Core 2
Libraries/APIs
Bloomberg API, Web API, Google Analytics API, Node.js
Tools
Microsoft Visual Studio, Microsoft Power BI, Microsoft InfoPath, Azure Logic Apps, Google Analytics, Microsoft Access, Microsoft Excel, Informatica ETL, DTS, Retool
Paradigms
Database Design, ETL, Agile, OLAP
Platforms
Windows, Microsoft, SharePoint 2013, Microsoft Power Automate
Storage
SQL Server Management Studio (SSMS), Azure SQL Databases, Microsoft SQL Server, Dell Boomi, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), JSON, Azure SQL, Database Administration (DBA)
Other
Software Engineering, Business, Azure Pipelines, Azure Data Factory, Windows Communication Foundation (WCF), FIX Protocol, WCF Web Services, Data Modeling, Microsoft Data Transformation Services (now SSIS), Excel Add-ins, Informatica Intelligent Cloud Services (IICS), Data Engineering, Software System Architecture Development, DHTML, APIs, Data Visualization, Dashboard Design, Dashboards, User Interface (UI)
Education
2001 - 2005
Master's Degree in Software Engineering
Conservatoire Nationale des Arts et des Métiers (CNAM) - Paris, France
1997 - 2000
Bachelor of Arts Degree in Business Computing
Saint Joseph University - Lebanon
Certifications
MARCH 2019 - PRESENT
Dell Boomi Associate Developer
Dell Boomi
DECEMBER 2016 - PRESENT
Agile Project Management Foundation
APMG
SEPTEMBER 2016 - PRESENT
Microsoft® Certified Solutions Expert - Data Management and Analytics
Microsoft
FEBRUARY 2004 - PRESENT
Microsoft Certified Solution Developer
Microsoft
Collaboration That Works
How to Work with Toptal
Toptal matches you directly with global industry experts from our network in hours—not weeks or months.
1
Share your needs
Discuss your requirements and refine your scope in a call with a Toptal domain expert.
2
Choose your talent
Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.
3
Start your risk-free talent trial
Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.
Top talent is in high demand.
Start hiring