Petru Vizitiu
Gulf Shores
Summary
Experienced MS BI Developer and Data Engineer with over 8 years of expertise in Database Design Development, ETL Implementation, and support of OLAP/OLTP/Data warehouse systems. Skilled in Reporting and Presentation through BI applications, with a solid understanding of data visualization tools, data migration practices, and database architecture. Recognized as a solution-oriented professional, I excel in collaborating within diverse teams and adapting swiftly to new roles, consistently delivering impactful results. My broad industry experience spans across sales, service, finance, and healthcare sectors, underscoring my versatile skill set and adaptability to various enterprise environments.
Overview
10
10
years of professional experience
Work History
Cloud Data Engineer
Mizuho Bank
08.2019 - Current
- During my tenure at Mizuho Bank as a Cloud Data Engineer, I spearheaded transformative initiatives aimed at modernizing our data infrastructure
- Central to my role was the meticulous creation and modeling of data warehouses, a task that demanded a deep understanding of our organization's evolving data needs and the intricacies of cloud platforms
- Leveraging my expertise in data engineering, I led the migration efforts from on-premises SQL Server systems to cloud-based solutions, meticulously ensuring data integrity and system stability throughout the transition process
- Collaborating closely with cross-functional stakeholders, I actively participated in comprehensive data modeling discussions
- These sessions were not just about technical considerations; they were strategic forums where we dissected business objectives and aligned them with our data architecture
- By translating technical complexities into actionable insights, I played a pivotal role in driving informed decision-making processes across the organization
- Developed and automated ETL pipelines using Python, ensuring seamless data extraction, transformation, and integration into Azure-based data warehouses
- Designed and implemented custom data validation and cleaning scripts using Python to improve data accuracy and ensure consistency across reporting systems
- Directed the migration initiative from on-premises SQL infrastructure to the Azure environment, with Snowflake serving as the principal tool in orchestrating the transition
- Identified slow running query and optimization of stored procedures and tested applications for performance, data integrity as a part of transition to new cloud environment
- Assumed responsibility for ensuring the highest level of data accuracy and consistency across the data warehouse
- Conducted rigorous data quality checks and implemented corrective actions to address any discrepancies, resulting in improved data reliability for business stakeholders
- Identified the dimension, fact tables and participated in designing the Data Warehouse to meet the business requirements
- Wrote numerous Stored Procedures and Functions for better performance and flexibility
- Skillfully re-engineered multiple intricate stored procedures, meticulously rewriting them for seamless integration into the Snowflake environment while maintaining business standards and ensuring data migration integrity
- Oversaw creating, scheduling, utilizing, and promoting jobs in both Dev and Prod environments using Tidal orchestration tool
- Formatted/Generated Data to support SAP Business Objects Interface for Users to access data from Data Warehouse
- Assisted the Project Manager in leading cross-functional project teams, playing a crucial role in implementing effective data conversion strategies and ensuring seamless communication among team members
- Extensive experience with Microsoft Azure ecosystem such as: Power Bi Service, ADF2, Azure SQL Server, Azure SQL IaaS/SaaS/PaaS, Azure SQL DW, Azure Blob
- Configured Azure platform for data pipelines, ADF, Azure blob storage and data lakes
Senior BI Developer
Nestle Waters
03.2017 - 08.2019
- As a Senior BI developer, I collaborated closely with cross-functional teams, such as business analysts and project managers, to understand client requirements and translate them into technical specifications
- I also participated in the development lifecycle, including coding, testing, debugging, and deployment, to ensure the successful delivery of high-quality solutions
- Additionally, I actively engaged in troubleshooting and resolving any issues or bugs that arose during the development process
- This required a strong attention to detail and problem-solving mindset to ensure the smooth functioning of BI applications
- Working as a Senior BI developer provided me with invaluable experience in leveraging the power of BI modern technologies to drive business growth and enhance customer relationships
- It allowed me to continuously expand my knowledge and stay updated with the latest advancements in the field
- Extensive experience with Microsoft Azure ecosystem such as: Power Bi Service, ADF2, Azure SQL Server, Azure SQL IaaS/SaaS/PaaS, Azure SQL DW, Azure Blob
- Configured Azure platform for data pipelines, ADF, Azure blob storage and data lakes, and built workflows to automate data flow using ADF
- Generated sophisticated Stored Procedures, Tables, Triggers, SQL Joins, Views and other statements to maintain referential integrity and implement complex business logic
- Demonstrated expertise in creating multiple data migration pipelines using Azure Data Factory V2 (ADF2), ensuring smooth and efficient data movement across various platforms and systems
- Actively participated in creating the Relational Database design and architecture
- Involved in Performance Tuning of the Stored Procedures, User Defined Functions, and long running queries
- Created Partition Tables based upon Partition Functions and Partition Schemas
- Created Azure Data Factory ADF pipelines, utilized Copy Data, Data Flow, triggers, integration runtimes, linked servers, Azure Key Vaults, Databricks Notebooks with Python and Scala SQL, ADF datasets, ADF ARM templates
- Created PowerBI, SSRS, Tableau and Domo reports based on the format specified in the design document
- Utilized SSIS and extract transform loading (ETL) tool of SQL Server to populate data from different data sources, making packages for various data loading tasks for application; Enhancing existing ETLs and creating some new ETL procedures
- Expanded SSIS functionality by designing custom SSIS elements for SharePoint
- Using SSIS, extracted and loaded SharePoint Lists and Surveys Data into SQL Server Database
- Deployed SSIS packages via package Bids Deployment, installation wizard, Management Studio Import for automatization of data processes
- Generated various Power BI reports sourcing from SSAS's Multidimensional OLAP and Tabular model with DAX
- Supervised performance tuning of SQL queries and stored procedures using Index Tuning Wizard and SQL Profiler
- Worked extensively on system analysis, design, development, testing and implementation of projects
- Data Automation Using SSIS to automate data processes for input of information
- Configured SSIS packages with XML configuration file, Registry entry, Parent package variable and SQL Server table
- Implemented various tasks and transformations for data cleansing and performance enhancement of SSIS packages
- Beyond technical expertise, I actively engaged with business stakeholders to thoroughly understand their requirements and challenges
- By closely collaborating with them, I delivered tailor-made ETL and Reporting solutions that precisely addressed their needs
- This consultative approach strengthened the relationship between IT and business teams, fostering a data-driven culture within the organization
BI Developer
TD Bank
01.2015 - 03.2017
- Configuring tuning and optimizing T- SQL
- Responsible for performing basic developer task like creating, altering, and updating tables
- Developed simple stored procedures, queries, views, joins and indexes by using T-SQL
- Normalized the tables and maintained Integrity by using Primary and Foreign Keys
- Designed and developed various SSIS packages (ETL) to extract and transform data and involved in Scheduling SSIS Packages
- Designed Data Source and Data Source Views, configuring OLAP Cubes (Star and Snowflake Schema) using SSAS
- Developed SSIS packages to extract, transform, and load data from Oracle and SQL Server databases into the Data Warehouse
- Generated reports, including multidimensional objects, utilizing SSRS and created Parameterized, CrossTab, Drill- down, and Summary reports
- Implemented indexes to expedite data retrieval from the database, enhancing overall performance
- Developed Stored Procedures and Functions to optimize performance and enhance flexibility
- Scheduled SQL Server jobs to automate the periodic loading of data using SQL Server Agent
- Collaborated with users during various testing phases, ensuring seamless integration and functionality
- Managed the deployment of SSIS packages across different environments (Dev, Test, and Prod) using Deployment Utility
- Proficient in transforming data from DB2 to SQL Server
- Executed Extract Transform and Load (ETL) processes to populate target tables and build required data marts
- Engaged in Dimensional Data Modeling and Cube partitioning within SSAS
- Implemented enhancements in database and data warehousing concepts, including KPI and Actions creation using SSAS
- Developed numerous Power BI reports using Power BI Desktop and Power BI Service, covering diverse domains such as Logistics Performance, Profit Analysis, Sales Reports, Provider Scorecards, and Cost Comparisons
- Utilized DAX expressions in Power Pivot to address specific business requirements
- Provided support to the team in resolving SQL Reporting Services and T-SQL related issues, demonstrating proficiency in report creation
Education
Computer Science -
Academy of Economic Studies of Moldova
01.2013
Skills
- Cloud & Databases: Azure, Snowflake, SQL Server, Azure Data Factory, Data Lakes, Azure Blob Storage
- ETL & Data Pipelines: Fivetran, HVR, SSIS, Python, Databricks, Airflow
- Programming & Scripting: Python (Pandas, NumPy), SQL (T-SQL, PL/SQL), CI/CD (GitHub Actions, DevOps)
- Data Modeling & Warehousing: Star/Snowflake Schema, Data Marts, OLAP, Dimensional Modeling
- BI & Reporting: Power BI, SSRS, Tableau
- Big Data & Optimization: Performance Tuning, Query Optimization, Indexing, Partitioning
Languages
English
Full Professional
Russian
Full Professional
Romanian
Native or Bilingual
Timeline
Cloud Data Engineer
Mizuho Bank
08.2019 - Current
Senior BI Developer
Nestle Waters
03.2017 - 08.2019
BI Developer
TD Bank
01.2015 - 03.2017
Computer Science -
Academy of Economic Studies of Moldova
Similar Profiles
Harry XueHarry Xue
Relationship Manager at Mizuho BankRelationship Manager at Mizuho Bank
CHRISTOPHER LEE-CHUECHRISTOPHER LEE-CHUE
Vice President at Mizuho BankVice President at Mizuho Bank
KRISTELLE LOUISKRISTELLE LOUIS
Administrative Assistant - Reception at MIZUHO BANKAdministrative Assistant - Reception at MIZUHO BANK