Alexandra is available for hire
Hire AlexandraAlexandra Lupascu
Verified Expert in Engineering
SQL Developer
Bucharest, Romania
Toptal member since November 24, 2020
Bio
With more than 10 years of experience in database development and numerous 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
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 an automatic inventory update, 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 PostgreSQL database and then into a stream that used a Lambda function to call the BigCommerce API.
- Fixed and built enhancements for a pricing engine application in Node.js.
- Migrated the cloud AWS solution to on-prem for improved stability and lower costs.
Technologies: Amazon RDS, Amazon Kinesis, AWS Database Migration Service (DMS), SQL Server DBA, BigCommerce API, AWS Lambda, Cloud Migration, API Integration, Complex SQL Queries, Node.js, Amazon DynamoDB, Change Data Capture, Debezium, Linux
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, Data Queries, Data Analysis, APIs, API Integration, Looker, Looker Studio, Google Data Studio, ETL Pipelines
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 large-scale data analysis with Metabase.
- Streamlined the data flow for the financial department for more efficient data analysis.
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, Data Queries, BI Reports, BI Reporting, Data Aggregation, Microsoft Excel, Financial Data, Google Analytics, API Integration, Looker Studio, Amazon Athena, Python, Metabase, Git, Amazon S3 (AWS S3), AWS Glue, Rundeck, PySpark, Data Transformation, ETL Pipelines, Databricks, Medallion Architecture
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, Data Queries, 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, Data Queries, Data Aggregation, Financial Data, Google Analytics, Redshift
Business Systems Developer
2025 - 2026
Chilli Pilates Ltd.
- Developed a BigQuery DWH solution meant to reconcile and unify multiple data sources—MindBody API data, database information, and Google Sheet data—to serve as a foundation for the analysis process.
- Developed Looker Dashboards meant to give the management an overview of the business's main KPIs and their yearly/monthly trends.
- Developed an AppSheet application from scratch (back end as well as front end) for internal use - the employees would use it to check their payroll data and submit various forms and requests to the HR team.
Technologies: Google Sheets, Business Intelligence (BI), Looker Studio, Google Apps Script, Data Architecture, Google Workspace
Zoho Expert
2025 - 2026
Sonawaves, LLC.
- Developed a Zoho Books integration with Converge API so that the payments could be done via Converge HPP.
- Built and managed the infrastructure required to use HPP: AWS API Gateway and AWS Lambda.
- Had calls with the Converge team and documented the entire process.
Technologies: Zoho, Zoho CRM, Zoho API, JavaScript, Zoho Books
Zoho CRM Developer
2024 - 2024
Caliber Environmental Construction Services
- Customized and streamlined the CRM system to better handle quotes, service orders, purchases, and invoices.
- Set up process flows between different Zoho CRM modules.
- Transferred data accurately from quotes/estimates to service orders/work orders.
- Handled integration with purchase orders (POs) and invoices.
- Created an end-to-end workflow that ensures smooth operations.
Technologies: Zoho CRM, Zoho API, JavaScript, Zoho One, APIs
AWS DevOps Engineer
2024 - 2024
Freelance Clients
- Developed and maintained the Terraform infra project necessary for the ETL application to work smoothly and independently in an AWS environment.
- Tested and maintained the CI/CD pipelines that deployed the code from GitHub to the Amazon ECS.
- Troubleshoot the CloudWatch error messages and help the team diagnose various issues related to performance.
- Provided recommendations regarding infra and performance requirements while also maintaining the lowest costs.
Technologies: AWS Glue, Amazon Elastic Container Service (ECS), Terraform, Amazon Redshift, CI/CD Pipelines
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
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, Data Queries, Data Aggregation, Scalability, Complex SQL Queries, Git
Zoho Developer
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
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, Data Queries, 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, Transact-SQL (T-SQL), Data Queries, Databases, Data Pipelines, Relational Databases, RDBMS, Data Analysis, SQL Server DBA, Visual Studio
.NET/Angular Web Developer
2019 - 2020
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, Transact-SQL (T-SQL), Data Queries, Data Analysis, BI Reports, BI Reporting, ASP.NET, Visual Studio, Git
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, Transact-SQL (T-SQL), Database Administration (DBA), Data Queries, 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
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, Data Queries, 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, Data Queries, 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, Transact-SQL (T-SQL), Data Queries, 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.
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, PySpark, Node.js
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, AWS Glue, Rundeck, Amazon Elastic Container Service (ECS), Terraform, Zoho One, Google Workspace
Languages
SQL, Stored Procedure, Transact-SQL (T-SQL), SQL DML, C#.NET, Visual Basic 6 (VB6), Excel VBA, Python 3, Python, JavaScript, Google Apps Script
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, Amazon DynamoDB
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, Debezium, Databricks
Other
Reporting, Algorithms, BI Reports, BI Reporting, Data Aggregation, Data Engineering, Database Optimization, Data Queries, 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, Amazon Redshift, CI/CD Pipelines, Data Transformation, Change Data Capture, Zoho Books, ETL Pipelines, Medallion Architecture
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