Svenska
Dansk
Dutch
Deutsch
Français
Norsk
Suomi
Ciprian Z.
Business Intelligence Developer
Ciprian is an experienced Business Intelligence Developer with over five years of expertise in the IT industry. His career spans a wide range of industries, including HR, Sales, Finance, Aerospace, Defense, Security, and Digital Transformation, where he has made significant contributions.
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 BI 3 years
- Data Engineering 4 years
- SQL 4 years
Other skills
- HTML / CSS 2 years
- HTML 2 years
- CSS 2 years
Selected experience
Employment
Business Intelligence Developer
Thales - 4 years
- 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.
Business Intelligence Developer
EXE Software (New York, USA) - 1 year 2 months
- 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.
Technologies:
- Technologies:
Microsoft Power BI
- Data Engineering
SQL
T-SQL
SSAS
C#
ETL
Scrum
Agile
Jira
SSIS
Azure
Azure Data Factory
SQL Developer
TotalSoft - 8 months
- 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.
Technologies:
- Technologies:
- Data Engineering
-
SQL
-
T-SQL
-
ETL
Tableau
-
Scrum
-
Agile
-
Jira
Internship Software Developer
TotalSoft - 3 months
- 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.
Technologies:
- Technologies:
Ajax
-
C#
-
Tableau
- HTML / CSS
HTML
CSS
jQuery
Visual Studio
ASP.NET
Education
BSc.Computer Science
Universitatea Româno-Americană din București · 2015 - 2018
Find your next developer within days, not months
In a short 25-minute call, we would like to:
- Understand your development needs
- Explain our process to match you with qualified, vetted developers from our network
- You are presented the right candidates 2 days in average after we talk