Alexandra is available for hire

Alexandra Lupascu

Verified Expert in Engineering

SQL Developer

Bucharest, Romania

Toptal member since November 24, 2020

Bio

With more than 10 years of database development and many enterprise-level projects under her belt, Alexandra can turn raw data into valuable insights. Besides her wealth of experience in database development, Alexandra's enthusiasm for data and natural drive to find solutions to challenging issues related to complex reports, algorithms, query tuning, and more make her a valuable asset.

Portfolio

Western Equipment Ltd

Amazon RDS, Amazon Kinesis, AWS Database Migration Service (DMS)...

Sip & Script Inc

SQL, Databases, RDBMS, Data Pipelines, Data Engineering, BigQuery, MySQL...

Paynovate SA

SQL, Business Intelligence (BI), Data Engineering, Dashboards...

Experience

SQL - 10 years Data Engineering - 6 years Windows App Development - 5 years App Development - 5 years C#.NET - 5 years MySQL - 3 years ETL Development - 3 years PostgreSQL - 2 years

Availability

Part-time

Preferred Environment

Visual Studio .NET, DataGrip, PyCharm, Anaconda, Docker

The most amazing...

...app I've built inputs a collection of vertices and displays a 3D human face. It can obtain realistic models of faces by combining the existing models.

Work Experience

Data Engineer

2023 - PRESENT

Western Equipment Ltd

Implemented a solution for automatic inventory update, a real-time data streaming from an MS SQL database to a BigCommerce store.
Made adequate changes to the SQL Server instance and database to allow data replication into Amazon RDS.
Built two pipelines to stream data from MS SQL into a Postgres database and then into a stream that used a Lambda function for calling the BigCommerce API.

Technologies: Amazon RDS, Amazon Kinesis, AWS Database Migration Service (DMS), SQL Server DBA, BigCommerce API, AWS Lambda, Cloud Migration, API Integration, Complex SQL Queries

Data Engineer

2022 - PRESENT

Sip & Script Inc

Extracted relevant data from WordPress API and WooCommerce API.
Developed Python ETL that extracts data from WordPress and pushes it into BigQuery.
Deployed the solution as a Google Cloud Function and added a Google Cloud Scheduler job that regularly triggers it.
Built Looker Studio dashboards meant to offer insight into activity and sales stats.

Technologies: SQL, Databases, RDBMS, Data Pipelines, Data Engineering, BigQuery, MySQL, WordPress, Google Cloud Platform (GCP), Google BigQuery, Pandas, NumPy, Python 3, Data Integration, Google Cloud, ETL Tools, Data Processing, Relational Databases, JSON, Database, Data Analysis, APIs, API Integration, Looker, Looker Studio, Google Data Studio

Data Engineer

2022 - PRESENT

Paynovate SA

Provided expertise in choosing an appropriate BI tool that would meet the requirements necessary for the company's reports. Worked on the BI setup and database improvements.
Developed data dashboards using Looker Studio and Metabase.
Managed and integrated the data using Google Cloud Platform (GCP).
Developed an ETL tool and DWH solution for a large-scale data analysis with Metabase.

Technologies: SQL, Business Intelligence (BI), Data Engineering, Dashboards, Data Visualization, MySQL, Google Cloud Platform (GCP), Google Data Studio, Data, Looker, Reports, Reporting, Databases, Google Cloud, Relational Databases, RDBMS, MariaDB, Database, BI Reports, BI Reporting, Data Aggregation, Microsoft Excel, Financial Data, Google Analytics, API Integration, Looker Studio, Amazon Athena, Python, Metabase, Git

Data Engineer and ETL Developer

2021 - PRESENT

Toptal Client

Developed, maintained, and deployed Python ETL applications for automatic processes.
Performed process analysis and integration planning with other data sources.
Managed and handled the publishing process from the testing environment to production.

Technologies: Docker, Kubernetes, MariaDB, Python, Python 3, Linux, Windows Subsystem for Linux (WSL), Teradata, Data Warehousing, Cloud Environments, Data, GitHub, Pandas, NumPy, Database Design, Data Architecture, Databases, Database Administration (DBA), Data Integration, ETL Tools, Data Processing, Data Pipelines, Relational Databases, Stored Procedure, RDBMS, JSON, Database, Data Migration, Data Analysis, Data Aggregation, Complex SQL Queries, Git

Database Developer

2019 - PRESENT

Clear Summit Group

Developed reports and summaries necessary for the marketing team, company owners, and decision-makers.
Reverse-engineered existing aggregate reports, found suitable filters, and built proper queries for matching values.
Built Zoho Analytics dashboards for the marketing team to evaluate various ad efficiency. Joined multiple datasets and gathered statistics for a complete insight into the performance indicators.
Fine-tuned dashboard queries for optimal performance, as some of the dashboards had more data than Zoho Analytics could handle.
Built underlying queries and dashboards for comparative analysis reports in AWS QuickSight—joining multiple datasets from various sources to extend the information displayed and allowing filtering based on essential criteria.
Developed parameterized reports requested by clients to assess their performance.
Designed Fivetran pipelines to extract data from Google Analytics and send it to an Amazon Redshift data warehouse.

Technologies: RDBMS, SQL, Stored Procedure, Relational Databases, BI Reporting, BI Reports, Reporting, MySQL, Business Intelligence (BI), Dashboard Design, Dashboards, Zoho, Analytics, Amazon QuickSight, Zoho Analytics, Data Engineering, Cloud Environments, Data-driven Dashboards, Fivetran, ETL, Data, Reports, Data Analysis, Amazon Web Services (AWS), Databases, Database, Data Aggregation, Financial Data, Google Analytics, Redshift

Data Analyst

2023 - 2023

Paynovate

Developed and deployed multiple ETL solutions in Google Cloud Platform, which gathered data from Breezy HR, Bamboo HR, and Wrike APIs and sent it to BigQuery.
Developed Looker dashboards for the HR team to assess efficiency and employee stats.
Developed BigQuery datasets and queries to provide meaningful information for the Looker dashboards.
Evaluated chart feasibility based on data availability in each source.

Technologies: Data Analytics, Business Intelligence (BI), Data Analysis, SQL, Data Visualization, Dashboards, Wrike, LinkedIn API, Excel 365, Looker, Google BigQuery, Google Cloud Platform (GCP), Google Cloud Functions, Breezy, Bamboo, Complex SQL Queries

PostgreSQL Expert

2023 - 2023

Crowd Technologies GmbH

Evaluated and identified problematic queries' efficiency and weak spots.
Fixed issues and applied query optimization techniques.
Evaluated query efficiency after the optimization was done.
Set up a list of best practices so the team can obtain better query response times.

Technologies: PostgreSQL, SQL, Amazon Web Services (AWS), Notion, Complex SQL Queries, Git

PostgreSQL Expert for Calendar Data Structure

2022 - 2022

Cluey Tech

Designed and modeled the database for a tutoring application, scheduling tutor sessions, and planning future availability/unavailability for tutors.
Developed multiple functions that would determine availability for a tutor based on their schedule and booked sessions.
Assessed the performance and made stress tests for large-volume datasets to ensure the database was scalable.
Conducted performance improvements to the existing functions to enhance their efficiency and application response times.
Monitored the correctness of results and developed use cases to demonstrate the accuracy of results.

Technologies: PostgreSQL, Bitbucket, Data Analysis, Database Design, Data Architecture, SQL Performance, Performance Tuning, Query Optimization, Database Architecture, Databases, Algorithms, Database Optimization, Relational Databases, Stored Procedure, Database Modeling, RDBMS, Database, Data Aggregation, Scalability, Complex SQL Queries, Git

Zoho Developer for Digital Marketing Company

2022 - 2022

Paragon Digital LLC

Fixed bugs related to the Zoho Creator client management application.
Completed the processes that synced the records between Zoho Creator and Zoho CRM and vice versa.
Monitored the sync process and ensured everything worked normally.

Technologies: Zoho, Zoho API, Zoho Creator, Zoho CRM

Data Engineer for Bug Fixes and Improvements

2021 - 2022

911 restoration Inc.

Fixed a Ubot Studio automation project used to visit specific websites at certain time intervals.
Developed an automation bot in Python used to visit specific websites at certain time intervals.
Developed an automation bot using Python that would scrape data and send it to Google Sheets.

Technologies: Python, Google Sheets, Azure, Proxy Servers, Windows PowerShell, UBot Studio, Pandas, Data Scraping, Python 3, Databases, Data Integration, ETL Tools, Data Pipelines, APIs, Indexing

Database and ETL Developer

2020 - 2020

Trellis Research

Designed and managed the AWS PostgreSQL database that holds the cases' information.
Developed an application that processes and ingests large volumes of data directly into the database. A key factor in this application is efficiency; the weekly scraped data would be pushed into the database in a matter of minutes.
Constructed Dexi.io pipes for each bot—these pipes would process/aggregate the data coming from the scrapers and then call an API or insert it directly into the database.
Developed a PowerShell script to download archives from AWS S3, unzip them, and then upload the unzipped files back to S3.

Technologies: Data Modeling, Windows PowerShell, Amazon EC2, Data Pipelines, Data Processing, ETL Development, ETL Tools, PostgreSQL, Dexi.io, Data Engineering, Cloud Environments, Amazon RDS, Query Plan, Data, GitHub, Amazon Web Services (AWS), Data Scraping, Database Design, Data Architecture, SQL Performance, Database Architecture, Databases, Database Administration (DBA), Data Integration, Database Optimization, Relational Databases, Stored Procedure, Database Modeling, RDBMS, Database, Agile, Data Analysis, APIs, Scalability, .NET Core, Visual Studio, Complex SQL Queries

SSIS ETL Developer

2019 - 2020

Aptamix Ltd.

Developed and maintained several SSIS packages that sync NetSuite ERP employee and sales data into a Microsoft SQL Server database.
Built and maintained several SSIS packages that would sync employee and sales information from a Xero API to a Microsoft SQL Server database.
Set up SQL agent jobs for the packages mentioned above.

Technologies: SQL Server Agent, Microsoft SQL Server, NetSuite, Xero API, SQL Server Integration Services (SSIS), Data Engineering, T-SQL (Transact-SQL), Database, Databases, Data Pipelines, Relational Databases, RDBMS, Data Analysis, SQL Server DBA, Visual Studio

ASP.NET and C# Developer and Server Administrator

2018 - 2020

Vabroker

Maintained the ASP.NET Web Forms and Classic ASP real estate website through client-requested changes.
Supported and improved the MLS service import console application, making it more flexible and configurable to support MLS service frequent changes.
Set up server parameters and website hosting and moved everything to a new server to reduce costs.

Technologies: Data Modeling, SQL, Monitoring, SQL Server DBA, Microsoft SQL Server, ETL Development, ETL, Windows PowerShell, Windows Server 2016, Classic ASP, SQL Server 2016, IIS 8, Plesk, C#.NET, ASP.NET Web Forms, T-SQL (Transact-SQL), Database Administration (DBA), Database, GitHub, Data Architecture, Database Architecture, Databases, Data Integration, Algorithms, Data Processing, ETL Tools, .NET, Relational Databases, Stored Procedure, Database Modeling, RDBMS, Data Analysis, APIs, SQL Server Profiler, ASP.NET, Visual Studio, API Integration, Real Estate, Git

.NET/Angular Web Developer

2019 - 2019

Brighter Tech Solutions

Developed a C# application that integrates with the current infrastructure that generates PDFs using website automation.
Created and maintained multiple front-end modules in the dental clinics' CRM application using Angular.
Built underlying queries and dashboards using the Domo business intelligence (BI) tool to assess the clinics' performance. The dashboards were related to patient feedback and various marketing campaign results.

Technologies: Business Intelligence (BI), Data Analytics, Analytics, Domo, Angular, ASP.NET Web API, ASP.NET MVC, Data-driven Dashboards, GitHub, Reports, Reporting, Databases, Data Integration, Data Visualization, .NET, Relational Databases, Stored Procedure, RDBMS, JSON, T-SQL (Transact-SQL), Database, Data Analysis, BI Reports, BI Reporting, ASP.NET, Visual Studio, Git

Data Analyst and MySQL Developer

2018 - 2019

Stratact

Created a complex inspiration recommendation algorithm in MySQL, tweaking it to less than 500 milliseconds.
Tracked and fixed bugs using the Jira reporting tool.
Developed the database side of a notifications algorithm.
Imported the user log to BigQuery to see how quickly it can compute user-related statistics.

Technologies: SQL, Stored Procedure, BigQuery, Relational Databases, Algorithms, MySQL Performance Tuning, Google BigQuery, MySQL, Data Engineering, Cloud Environments, Database, Data, Reports, Database Design, Data Architecture, SQL Performance, Performance Tuning, Query Optimization, Databases, Database Optimization, Database Modeling, RDBMS, Agile, Data Analysis, Indexing, Data Aggregation, Scalability, Complex SQL Queries

Database Developer

2017 - 2018

Justly, Inc.

Automated the case processing and ingestion process with VBA macros and configurable ASP.NET Core app.
Remodeled the database structure for improved efficiency and reduced redundancy.
Developed an application that brought the Federal Cases RSS feed information into the database and configured this to run daily.
Fine-tuned queries and reports to decrease waiting times.
Maintained and troubleshot the company's website (Ruby on Rails).
Administered and configured the AWS RDS-hosted database and snapshots.
Migrated the data from third-party SQL Server databases (CNS) to the PostgreSQL database.
Managed the data extraction team while monitoring data scraping results and verifying inputs and outputs.

Technologies: Database Modeling, Data Modeling, SQL, Relational Databases, Indexing, APIs, ETL Implementation & Design, ETL, Query Optimization, Performance Tuning, Analytics, Excel VBA, ASP.NET Core, Amazon EC2, Amazon S3 (AWS S3), PostgreSQL, Data Engineering, Database Administration (DBA), Cloud Environments, Amazon RDS, Database, Query Plan, Data, Reports, Data Science, Amazon Web Services (AWS), Data Scraping, Database Design, Data Architecture, Reporting, SQL Performance, Database Architecture, Databases, Data Integration, Algorithms, Database Optimization, ETL Tools, Data Processing, Data Pipelines, .NET, Stored Procedure, RDBMS, Agile, Data Migration, Data Analysis, Linux, BI Reports, BI Reporting, Data Aggregation, Monitoring, Scalability, .NET Core, Microsoft Excel, Visual Studio, Complex SQL Queries, Git

Senior SQL and Application Developer

2009 - 2017

Romanian Software SRL

Maintained an enterprise-level payroll application (code and SQL Server database) through legal and client-specific changes.
Developed an SQL CLR module to replace the payroll calculation code, which reduced the calculation time by more than 95%, improving the application's scalability.
Helped a support team fix urgent client-side issues through diagnoses and custom scripts.
Maintained a time-and-attendance application built in ASP.NET by adding new features, modules, and third-party integration systems.
Developed ETL-side apps that were integrated with the main database.
Performed data migrations and data duplications between servers.
Developed ETL custom applications in .NET C# for client access control systems, which run daily, get the data from an FTP server and transfer the time attendance data into the database.
Managed production and development servers and performed SQL Server database administration.

Technologies: RDBMS, Data Modeling, SQL, Indexing, Relational Databases, ETL Implementation & Design, Reporting, Crystal Reports, Microsoft SQL Server, Data Integration, ETL, Performance Tuning, Multitenancy, SQL CLR, SQL Server DBA, Database Administration (DBA), SQL Server Profiler, Databases, Database Applications, ASP.NET Web Forms, C#.NET, Visual Basic 6 (VB6), Data Engineering, T-SQL (Transact-SQL), Database, SQL DML, Query Plan, Data, GitHub, Reports, Data Science, Database Design, Data Architecture, SQL Performance, Query Optimization, Database Architecture, Algorithms, Database Optimization, ETL Tools, Data Processing, Data Pipelines, .NET, Stored Procedure, Database Modeling, Agile, Data Migration, Data Analysis, BI Reports, BI Reporting, Data Aggregation, Monitoring, Scalability, Excel VBA, Microsoft Excel, Financial Data, ASP.NET, Visual Studio, Complex SQL Queries, Git

Experience

Real Estate Project Management Website

I designed the MySQL cloud database to hold and report on data from real estate projects and built the ASP.NET Core website to manage it. The website provides login capabilities, and it allows records' import-export for each main entity in the database.

Performance Optimization for a Job Website

https://www.bcjobs.ca/

Bcjobs.ca gets over 200,000 users and over a million page views per month. There were a few key parts of the application where things were starting to get slow, such as the job search board, which took around one minute to load. Tweaking and refactoring queries used in the job search process helped reduce this time to about one second, improving its usability and responsiveness.

Created and Optimized Reports for a High-volume Database

A high-volume database (hundreds of millions of records and growing) importing daily from various sources needs to have data already processed for Tableau reports.

For this project, I have built daily reports that process data for up to a month back, improving them so they would be ready in a matter of minutes and storing the results in a materialized view.

Education

2005 - 2010

Master's Degree in Computer Science Applied to Economics

Bucharest University of Economic Studies — Faculty of Cybernetics, Statistics, and Informatics - Bucharest, Romania

2005 - 2008

Bachelor's Degree in Mathematics and Computer Science

Bucharest University of Economic Studies — Faculty of Cybernetics, Statistics, and Informatics - Bucharest, Romania

Skills

Libraries/APIs

Complex SQL Queries, Xero API, Zoho API, NumPy, Pandas, BigCommerce API, LinkedIn API

Tools

Crystal Reports, MySQL Performance Tuning, Visual Studio .NET, MySQL Workbench, SQL Server Profiler, Query Plan, GitHub, Microsoft Excel, Visual Studio, Plesk, Amazon QuickSight, Domo, Dexi.io, BigQuery, Zoho Creator, Google Sheets, UBot Studio, Bitbucket, DataGrip, PyCharm, Looker, Google Analytics, Notion, Wrike, Bamboo, Amazon Athena, Git

Languages

SQL, Stored Procedure, T-SQL (Transact-SQL), SQL DML, C#.NET, Visual Basic 6 (VB6), Excel VBA, Python 3, Python

Paradigms

Database Design, Windows App Development, App Development, ETL, Business Intelligence (BI), ETL Implementation & Design, Agile

Storage

SQL Server Management Studio (SSMS), PostgreSQL, MySQL, Databases, Microsoft SQL Server, Relational Databases, RDBMS, SQL Performance, Database Architecture, Database Administration (DBA), SQL CLR, Data Integration, MariaDB, Cloud Environments, Amazon S3 (AWS S3), SQL Server 2016, SQL Server Integration Services (SSIS), SQL Server DBA, Google Cloud, Data Pipelines, SQL Server Agent, Database Modeling, JSON, Teradata, Redshift

Frameworks

ASP.NET Web Forms, .NET, ASP.NET, ASP.NET Core, Classic ASP, ASP.NET MVC, ASP.NET Web API, Angular, .NET Core, Windows PowerShell

Platforms

Amazon Web Services (AWS), Windows Server 2016, Oracle, Amazon EC2, Zoho Analytics, Ubuntu Linux, Linux, Azure, Google Cloud Platform (GCP), Docker, Kubernetes, Zoho CRM, Anaconda, WordPress, AWS Lambda, Breezy

Other

Reporting, Algorithms, BI Reports, BI Reporting, Data Aggregation, Data Engineering, Database Optimization, Database, Data, Reports, Database Applications, ETL Development, Scalability, Query Optimization, Performance Tuning, Data Architecture, Dashboards, Dashboard Design, APIs, Data Visualization, Indexing, Data Migration, Data Analysis, ETL Tools, Data Processing, Data Modeling, Amazon RDS, Data Scraping, Real Estate, Statistical Data Analysis, IIS 8, Analytics, Zoho, Performance, Multitenancy, Google BigQuery, Data Analytics, Monitoring, Google Data Studio, NetSuite, Windows Subsystem for Linux (WSL), Data Warehousing, Data-driven Dashboards, Integration Tools, Fivetran, Proxy Servers, StreamSets, Data Science, Financial Data, Amazon Kinesis, AWS Database Migration Service (DMS), Cloud Migration, Excel 365, Google Cloud Functions, API Integration, Looker Studio, Metabase

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.

Share your needs

Discuss your requirements and refine your scope in a call with a Toptal domain expert.

Choose your talent

Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.

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