Camil Serban

Senior SQL / Data Engineer with 20+ years of experience in database development, data integration, ETL/ELT, data warehousing, reporting, and enterprise production environments. Strong expertise in Microsoft SQL Server and PostgreSQL, including advanced SQL/T-SQL development, stored procedures, functions, views, triggers, CTEs, dynamic SQL, database design, data modelling, indexing, execution plan analysis, query optimization, and performance tuning. Extensive experience designing, developing, and supporting end-to-end ETL/ELT and data integration solutions using SSIS and SQL-based processes for large-scale databases and business-critical systems.

Hands-on experience with Python and PySpark for data extraction, transformation, and validation, including complex nested JSON processing using Apache Spark and DataFrames.

Experience with modern data engineering and cloud technologies, including Databricks, Snowflake, dbt, AWS RDS, and Matillion, as well as Azure DevOps and GitLab. Familiar with Apache Airflow, backed by extensive experience in ETL workflow design, scheduling, dependency management, monitoring, troubleshooting, and production support. Working knowledge of Hadoop, Hive, and Impala, with transferable SQL and ETL skills applicable to distributed data processing and Big Data environments.

Recently designed and developed a national-level web reporting application using Node.js, Express, and PostgreSQL for centralized operational, statistical, and management reporting.

SQL / ETL Developer | Data & Reporting Solutions - Gpi Group - Iaşi, Romania

(2026-04 - 2026-08)

• Designed and developed a national-level web reporting application for centralized operational, statistical, and management reporting.
• Developed the application using Node.js / Express and PostgreSQL, with a strong focus on database-driven architecture and high-performance SQL reporting.
• Designed and implemented complex PostgreSQL / PL/pgSQL functions, queries, views, data models, and reporting logic supporting multiple business areas and reporting requirements.
• Designed dynamic filtering and parameter-driven reporting mechanisms for reusable SQL-based reports.
• Optimized complex queries and database functions for large datasets, focusing on execution performance, indexing, scalability, and production stability.
• Designed reporting and data-access architecture supporting enterprise production databases and reporting workloads.
• Developed ETL/data integration and validation processes to ensure data consistency and reporting accuracy.
• Implemented role-based access, reporting configuration, data validation, and operational monitoring capabilities.
• Worked directly with business stakeholders and domain experts to translate operational and national reporting requirements into technical solutions.
• Supported testing, troubleshooting, production readiness, deployment, technical documentation, and continuous application improvement.

Reporting & Power BI Support - Toyota Motor Europe - Iaşi, Romania

(2025-09 - 2026-03)

Supported enterprise data engineering and reporting workflows in a complex, international environment, ensuring data quality, consistency, and integrity across interconnected systems.

• Designed, optimized, and troubleshot Microsoft SQL Server queries, views, stored procedures, and SQL Agent jobs, with a strong focus on performance, stability, and data accuracy.
• Performed SQL performance analysis and optimization, including query refactoring, indexing recommendations, and execution plan analysis.
• Provided 3rd-level application and data support, performing incident analysis, root-cause investigation, and resolution of data inconsistencies, refresh failures, and performance issues.
• Built, maintained, and supported SSRS reports and Power BI semantic models, including dataset validation, refresh monitoring, and performance tuning.
• Supported enterprise reporting pipelines involving SQL Server, SSAS, SSRS, SSIS, CDC, Power BI, Power BI Report Server, and Snowflake.
• Worked with Snowflake and dbt for SQL-based data transformation, modelling, and reporting workflows.
• Used PowerShell scripting to automate and standardize operational activities, including ETL executions, post-run validation, monitoring of SQL Agent jobs and services, data quality checks, and automation of recurring reporting and support tasks across environments.
• Worked with SQL Server Change Data Capture (CDC) to track data changes and implement incremental ETL processes using SSIS.
• Worked with QTool for reporting validation, Tabular Editor, DAX, KPI analysis, and investigation of data discrepancies across reporting layers and source systems, including cube performance and processing time optimization.
• Worked with structured delivery processes and tooling (Azure DevOps, GitLab, Jira) for requirements tracking, release coordination, and issue follow-up.
• Produced technical documentation and operational guidelines to support knowledge transfer and long-term maintainability.

SQL / ETL & Data Engineer - rinf.tech - Iaşi, Romania

(2024-10 - 2025-07)

Led ETL and data integration initiatives at ING Hub International, orchestrating data workflows and ensuring data quality in a cloud-enabled data warehouse.

• Built and maintained complex SQL Server queries and automated database processes across development, test, acceptance, and production environments.
• Utilized PySpark to extract, parse, and transform data from large and complex nested JSON files, supporting scalable Big Data pipelines and distributed data processing.
• Leveraged Python for parsing, transformation, validation, and ingestion of JSON datasets.
• Worked with Apache Spark concepts and technologies including PySpark, Spark architecture, RDDs, DataFrames, Datasets, and distributed processing.
• Worked with cloud-based data platforms including Snowflake and AWS RDS, as well as Matillion for building and orchestrating ETL pipelines.
• Developed C# solutions for process automation and data workflow management.
• Designed and executed validation and verification routines to ensure data integrity throughout automated processes.
• Worked with structured data from multiple sources including TXT, XLS, CSV, and JSON.
• Collaborated with business stakeholders to gather requirements and translate business needs into technical data solutions.

Experienced SQL Developer - TotalSoft - Iaşi, Romania

(2022-09 - 2024-09)

SQL Development

• Designed and maintained database structures (tables, constraints, indexes, views, functions) to support data extraction, transformation, and reporting in Microsoft SQL Server environments.
• Developed and optimized complex T-SQL queries, including dynamic SQL, to ensure high-performance data access and manipulation.
• Created and refined stored procedures and reporting logic, enhancing both performance and system stability.
• Defined and implemented database administration strategies, including robust backup and restore plans to ensure data availability and integrity.
• Collaborated with DBAs to monitor performance, tune queries, and ensure seamless integration with enterprise applications.
• Installed and configured SQL Server instances and Reporting Services (SSRS) environments tailored to client and project requirements.
• Improved existing report logic and structure using Visual Studio (SQL Server Data Tools - SSDT), significantly reducing report generation time.
• Installed, configured, and maintained custom business applications, aligning with client needs and performance expectations.
• Participated in all phases of project delivery: from requirements gathering and analysis to go-live and post-deployment support.
• Took a lead role in defining project scope, estimating workload, and planning accurate timelines.
• Led a key initiative for an international client (Italy), developing an automated import process from .txt files and integrating it into the application workflow.
• Developed and automated over 20 daily ETL workflows using SSIS, loading structured data from .txt, .csv, and .xml files into SQL Server, which significantly improved financial reporting accuracy and reduced processing time.

SQL Developer/Technical Consultant - Info World - Iasi

(2002-10 - 2022-08)

Blood Bank and Transfusion Software Implementation

• Led end-to-end implementation of software systems for hospitals and national blood services, ensuring smooth deployment and optimization. Provided both online and offline technical support to maintain stability and performance.
• Designed and developed a full-scale desktop application in Visual FoxPro 9.0, covering backend logic and UI, used in healthcare institutions for donor and transfusion management. Built custom business modules and reporting solutions using Visual FoxPro, T-SQL, Visual Studio, SSRS, and SSIS, tailored to operational requirements.
• Managed Windows-based network and domain servers, ensuring reliable and secure environments. Delivered live demos in pre-sales efforts and advised clients on software selection, implementation, and optimization strategies.
• Installed and configured SQL Server Reporting Services (SSRS) to establish scalable reporting platforms. Developed over 300 custom donor and operational reports using Report Builder 3.0 and SSDT, significantly improving access to critical data.
• Optimized queries and report logic, reducing generation time by over 40%.
• Automated delivery through SSRS subscriptions to streamline information flow.
• Built interactive dashboards integrating multiple data sources and designed SSIS workflows for scheduled ETL processes supporting data consistency and reporting accuracy.

Head of Laboratory of Psychology - University "Petre Andrei" - Iaşi, Romania

(2001-03 - 2002-09)

• Worked as an Assistant Professor.
• Led efforts in the modernization of the Applied Psychology and Media Center, ensuring up-to-date practices and technologies.
• Actively participated in activities of an accredited institution, contributing to its academic and professional development.
• Managed responsibilities as a Network Administrator, ensuring efficient and secure operation of IT systems.

Professor of Psychology - Cultural Foundation "Dimitrie Cantemir"

(2000-09 - 2002-09)

• Delivered engaging and informative lessons, contributing to the academic and personal development of students.
• Managed and maintained the institution's network infrastructure, ensuring smooth and secure operations as a Network Administrator.
• Actively engaged in the activities and programs of an accredited institution, supporting its educational mission and objectives.

Assistant Psychologist - SC Management Design - Iaşi, Romania

(1998-02 - 2000-08)

• Conducted psychological testing for driver's licenses and high-risk occupations, helping ensure individual safety and suitability for safety-critical roles.
• Participated in recruitment, selection, and employee evaluation, applying psychological methods to assess candidates and their suitability for various roles.
• Conducted psychosocial climate studies and surveys and analyzed customer satisfaction to improve organizational culture and performance.
• Analyzed and statistically processed data to provide actionable insights for decision-making and process improvement.

Trainer - Extreme Training (2017 - 2017)

Training - systemic family psychotherapy and couple - School Training System (2012 - 2016)

Master - communication, creativity and psychosocial skills in organizations - University "Petre Andrei", Iasi (2005 - 2007)

University Degree - Psychology, Specialization Psychology and Social Work - University "Petre Andrei" Iasi (1996 - 2000)