Alexandra Lupascu, Developer in Bucharest, Romania
Alexandra is available for hire
Hire Alexandra

Alexandra Lupascu

Verified Expert  in Engineering

SQL Developer

Location
Bucharest, Romania
Toptal Member Since
November 24, 2020

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.

Data QueriesData EngineeringAlgorithmsBI ReportsRelational DatabasesSQLDatabase DesignDatabasesRDBMSSQL Server Management Studio (SSMS)Microsoft SQL ServerT-SQL (Transact-SQL)Crystal ReportsMySQLPostgreSQLSQL CLRPleskProxyDomoStored ProcedureZohoClassic ASP

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 yearsData Engineering - 6 yearsWindows App Development - 5 yearsApp Development - 5 yearsC#.NET - 5 yearsMySQL - 3 yearsETL Development - 3 yearsPostgreSQL - 2 years

Availability

Part-time

Preferred Environment

Spyder, MySQL Workbench, SQL Server Management Studio (SSMS), pgAdmin, Visual Studio .NET, DataGrip, PyCharm, Anaconda

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

Data Engineer for Data Pipeline Improvement

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.
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

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 set up and database improvements.
  • Developed data dashboards using Google Data Studio and Looker Studio.
  • Managed and integrated the data using the Google Cloud Platform (GCP).
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

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

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

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

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

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, Data Queries, Data Aggregation, Scalability

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, Data Queries, Agile, Data Analysis, APIs, Scalability, .NET Core, Visual Studio

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), Data Queries, 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), 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

.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), Data Queries, Data Analysis, BI Reports, BI Reporting, ASP.NET, Visual Studio

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

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

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), 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

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 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.

Languages

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

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

Paradigms

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

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

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, Zoho Analytics, 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, Financial Data, Amazon Kinesis, AWS Database Migration Service (DMS), Cloud Migration, Excel 365, Google Cloud Functions, API Integration

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, Ubuntu Linux, Linux, Azure, Google Cloud Platform (GCP), Docker, Kubernetes, Zoho CRM, Anaconda, WordPress, AWS Lambda, Breezy

Libraries/APIs

Xero API, Zoho API, NumPy, Pandas, BigCommerce API, LinkedIn API

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

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