Mauro Pitaluga

Project detail

With extensive expertise in Power Query and large-scale data management, I played a pivotal role in the migration of a database containing over 20,000 clients from AS400 to SAP HANA. My focus on data transformation and analysis has enabled me to develop efficient solutions for managing and processing large-scale data, ensuring data integrity and accessibility throughout the process.

Responsibilities and Achievements:

Power Query Development: Create advanced queries to transform and combine data from multiple sources, facilitating data preparation for analysis and reporting.

ETL Process Automation: Implement automated extraction, transformation, and loading (ETL) processes using Power Query, enhancing efficiency and accuracy in data management.

Data Migration Project Management: Lead the migration of large data volumes from legacy systems such as AS400 to modern platforms like SAP HANA, ensuring smooth transitions and data integrity. Successfully migrated a database containing over 20,000 clients, enhancing data accessibility and analysis for the organization.

Efficient Data Integration: Achieve efficient integration of data from diverse sources into a single model using Power Query, facilitating multidimensional analysis and informed decision-making. Improved data quality, through the implementation of data validation and cleansing processes.

Improved Data Quality: Implement data validation and cleansing processes that increased report accuracy, reducing errors and duplications.