Alexandra Lupascu
Verified Expert in Engineering
SQL Developer
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.
Portfolio
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
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
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.
Data Engineer
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.
Data Engineer
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.
Data Engineer and ETL Developer
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.
Database Developer
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.
Data Analyst
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.
PostgreSQL Expert
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.
PostgreSQL Expert for Calendar Data Structure
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.
Zoho Developer for Digital Marketing Company
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.
Data Engineer for Bug Fixes and Improvements
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.
Database and ETL Developer
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.
SSIS ETL Developer
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.
ASP.NET and C# Developer and Server Administrator
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.
.NET/Angular Web Developer
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.
Data Analyst and MySQL Developer
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.
Database Developer
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.
Senior SQL and Application Developer
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.
Experience
Real Estate Project Management Website
Performance Optimization for a Job Website
https://www.bcjobs.ca/Created and Optimized Reports for a High-volume Database
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
Master's Degree in Computer Science Applied to Economics
Bucharest University of Economic Studies — Faculty of Cybernetics, Statistics, and Informatics - Bucharest, Romania
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, 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
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
Choose your talent
Start your risk-free talent trial
Top talent is in high demand.
Start hiring