Ciprian Z.

Business Intelligence Developer

Romania

Trusted member since 2024

6 years of experience

With international experience in the USA, France, and Romania, Ciprian brings a global perspective to his work. One of his key achievements is leading the development of EMW, an internal application for Thales, designed for engineering professionals. From project initiation to completion, Ciprian played a critical role in building and delivering this impactful solution.

Main expertise

Microsoft Power BI5 years

Data Engineering5 years

SQL6 years

T-SQL6 years

21+

Experience4

Business Intelligence Developer

Thales•

Aerospace and Defense

Sep 2021 · 4y 6m

Participated in creating database objects such as tables, constraints, indexes, views, indexed views, and cursors to support existing applications.
Demonstrated strong proficiency in SQL and T-SQL scripting languages.
Gained experience in building SSAS cubes and dimensions using various architectures and data sources for business intelligence, and wrote MDX scripts.
Managed user groups and security within the Business Objects platform.
Implemented ETL strategies by creating packages using SSIS to extract data from DB2, SQL Server, Excel files, other databases, and flat file sources.
Utilized Reporting Services, Power BI (dashboard reports), Crystal Reports, and SSRS with MS SQL Server, and supported services using MDX in Analysis Services.
Applied solid knowledge of data warehousing methodologies, including star schema and snowflake concepts.
Explored data through various visualizations in Power BI, and demonstrated strategic expertise in experimental design, data collection, analysis, and visualization.
Troubleshot, resolved, and escalated data-related issues, and validated data to improve data quality.
Demonstrated excellent analytical, communication, and interpersonal skills.
Applied strong investigative and troubleshooting abilities.

MySQL

HTML

CSS

jQuery

30+

Business Intelligence Developer

EXE Software (New York, USA)•

Information Technology (IT) and Services

Jul 2020 - Sep 2021 · 1y 2m

Populated data warehouses through ETL processes.
Cleaned and standardized data, merging it from multiple data stores.
Automated administrative tasks to improve efficiency.
Utilized recursive CTEs, CTEs, temporary tables, and effective DDL/DML triggers for efficient data manipulation and consistency.
Wrote T-SQL queries, dynamic queries, sub-queries, and complex joins to generate stored procedures, triggers, user-defined functions, views, and cursors.
Applied skills in error and event handling using precedence constraints, breakpoints, checkpoints, and logging.
Gained experience with SSIS tools such as the Import and Export Wizard, Package Installation, and SSIS Package Designer.
Used Microsoft Visual C# in the script component of SSIS.
Created configuration files to deploy SSIS packages across various environments.
Collaborated with the report manager to deploy reports in all environments.
Utilized global variables, expressions, and functions in SSRS reports, and handled sub-reports effectively. -Installed and configured Reporting Services and assigned user permissions at various levels in SSRS.
Demonstrated strong knowledge of Microsoft BI tools (SSRS, SSAS) and other reporting tools such as Power BI.
Managed multiple tasks efficiently, showing initiative and adaptability.
Applied analytical, communication, critical thinking, and SQL development skills.

MySQL

CSS

MSSQL

SQL

13+

SQL Developer

TotalSoft•

Information Technology (IT) and Services

Nov 2019 - Jul 2020 · 8m

Worked as part of an implementation team and established strong working relationships with business consultants, human resources specialists, and management.
Created T-SQL objects and scripts to maintain data integrity across all databases.
Evaluated large and complex data sets.
Maintained databases using stored procedures, functions, cursors, and triggers.
Established techniques for raw data exchanges and built and maintained SSRS reports and ETL packages.
Assisted clients in utilizing implemented software solutions.
Provided both pre-go-live and post-go-live support during the system transition.
Created mechanisms for importing and exporting data to and from databases.
Analyzed and troubleshot SQL statements, application code, and database object models.
Performed performance tuning for ETL jobs to optimize execution.
Reviewed, discussed, and met agreed project timelines while providing feedback to project managers.
Worked in an Agile environment and effectively tracked and resolved bugs.
Demonstrated adaptability by quickly learning and taking on expanded responsibilities, including implementing new procedures and improving existing ones.

MySQL

CSS

MSSQL

SQL

Internship Software Developer

TotalSoft•

Information Technology (IT) and Services

Aug 2019 - Nov 2019 · 3m

Created a Windows Forms Application.
Developed both the back-end and front-end of a website based on given specifications.
Applied object-oriented programming (OOP) concepts in designing and developing the application.
Contributed to projects in an office environment alongside other graduate students and served on short-term project teams.
Gained experience in bug fixing and troubleshooting issues.
Developed code for functional user stories using Agile methodology.
Debugged and modified software components to improve functionality and performance.
Demonstrated the ability to quickly learn and comprehend new concepts and technologies.
Assisted in fostering a positive engineering and team culture.
Created technical documentation to support development efforts.
Communicated ideas, issues, project status, and outcomes effectively with team members and trainers.
Received an introduction to Business Intelligence tools, including Tableau.
Worked with Kendo UI, HTML5, CSS, AJAX, HTTPS, jQuery, web services, and database connections.