Vincenzo Petrucci

Expertise: Multi-Platform DB Administration (Linux/Windows), Cloud Migration, High Availability Core Skills 🔹 Linux (RHEL8) & Windows Server 2023 Management • Automated deployment, patching, and configuration management via Ansible. • VMWare virtualization: VM provisioning, performance tuning, and lifecycle management. • Bash/PowerShell scripting for administrative tasks and monitoring. 🔹 Database Administration • MongoDB v6 on RHEL8: Sharded clusters, replica sets, performance tuning, and aggregation pipelines. • Microsoft SQL Server (2016–2019): AlwaysOn, SSIS/SSRS, and T-SQL optimization. • Oracle (18c/19c): RAC, ASM, Exadata Cloud@Customer, and RMAN backups. • PostgreSQL: Streaming replication, partitioning, and pgBackRest. • MariaDB: High-performance OLTP configurations, query optimization, Galera Cluster for HA, and data validation frameworks for critical systems. 🔹 Cloud & High Availability • Azure migrations (IaaS/PaaS), Oracle RAC on AWS. • Disaster recovery planning (Veeam, RMAN, SQL native backups). 🔹 Security & Compliance • Cross-platform access control (RBAC, LDAP integration). • OS/DB hardening (RHEL STIG, Windows GPO, CIS benchmarks). Key Projects • SAP-to-Strategic Billing Migration (Oracle DB, ETL pipelines). • Azure Cloud Consolidation: Lift-and-shift of on-prem databases. • MongoDB Optimization for OneTab’s high-traffic IoT application.

Expertise: Cloud Migrations (Azure/AWS), Database Optimization, ETL/Data Integration Core Skills 🔹 Cloud & Data Migration • Azure & AWS database migrations (on-prem to cloud). • SAP HANA data warehouse integration. • ETL pipelines (Azure Data Factory, SSIS, Data Lake). 🔹 Database Administration • Microsoft SQL Server (2016–2019): HA/DR, T-SQL tuning, SSAS/SSRS. • MongoDB: Deployment, scaling, and performance optimization. • Database security: Access control, encryption, compliance. 🔹 High Availability & Disaster Recovery • 24/7 operations: Incident management, backup strategies, minimal downtime. • Cloud-based HA: AlwaysOn, failover clusters, replication. 🔹 Data Solutions Development • ETL/OLAP: SSIS, SSAS, data modeling. • Trading platform integration (CXL). • SharePoint/.NET intranet applications. Key Projects • Multi-Cloud Data Migration (Azure + AWS). • SAP HANA Integration for enterprise data warehousing. • CXL Trading Platform data pipeline optimization. • ETL Modernization: Azure Data Lake + Data Factory implementation.

Expertise: Cross-Platform Database Management, ETL, CRM Integration Core Skills 🔹 Database Administration & Maintenance • Oracle 12c: Performance tuning, patching, and storage management. • SQL Server (2012–2016): AlwaysOn HA/DR, T-SQL optimization. • Cloud Migration: Lift-and-shift to Azure and AWS. 🔹 Data Integration & ETL • CRM Integration: MS Dynamics ↔ SAP data pipelines. • ETL Development: SSIS packages for SAP/CRM/web DB synchronization. • SAP ↔ Application DB integration (Swisscaution case study). 🔹 Operational Excellence • High Availability: AlwaysOn, backup/restore strategies. • Incident Management: 24/7 database outage resolution. • Security: Access controls, auditing, compliance. Key Projects • MS Dynamics CRM Data Integration: Unified customer data across SAP/legacy systems. • SAP-to-Web DB Sync: Automated Swisscaution’s data flows. • Cloud Migration: Oracle/SQL Server workloads to Azure/AWS.

Expertise: Oracle/SQL Server/MongoDB Administration, High Availability, ETL, Data Migration Core Skills 🔹 Database Administration & Optimization • Oracle 11g/12c: Dataguard implementation, PL/SQL tuning, security hardening. • SQL Server (2008–2014): HA/DR, performance tuning, security patching. • MongoDB: Deployment, backup/restore, and scalability. • Linux shell scripting for automation and maintenance. 🔹 High Availability & Data Integrity • Disaster Recovery: Backup strategies, storage management, failover solutions. • Data Quality: Validation, migration, and ETL (SSIS) for data warehouses. 🔹 Project Leadership & Stakeholder Collaboration • Requirement Analysis: Technical/business specs drafting, KPI tracking. • Process Automation: Partnered with devs to reduce errors/costs (e.g., workflow automation). Key Projects • Market Access Map (MacMAP): Global trade policy database (Oracle/SQL Server). • Trade Help Desk: Scalable MongoDB backend for www.helpmetrade.org. • EU-Med TIFM Portal: SharePoint/.NET intranet with ETL integrations.

Expertise: ETL Development, Data Warehousing, Dashboard Implementation Core Skills 🔹 ETL & Data Warehousing • Designed and implemented ETL pipelines for SQL Server data warehouses. • Executed data migration strategies for seamless system integration. 🔹 Business Intelligence & Reporting • Developed interactive dashboards and reports using Tableau and Clickview. • Created data visualizations to support decision-making for cargo logistics. 🔹 Database Design & Architecture • Structured database schemas for airport cargo operations (flights, customs duties, product transport). • Ensured data integrity and optimized query performance. 🔹 Project Leadership & Stakeholder Collaboration • Gathered business requirements and translated them into functional specifications. • Actively contributed to focus groups and steering committees for project alignment. • Monitored project timelines and deliverables to ensure on-target execution. Key Projects • Cargo Landing: Streamlined engagement data collection for cargo operations. • Cargo Airports: Developed a Custom Duty Items Program to optimize logistics workflows.

Database Specialist // Technical Business Analyst Expertise: Financial Data Warehousing, ETL Development, Business Intelligence Core Skills 🔹 Data Architecture & BI Development • Designed and implemented data warehouse architecture for financial asset management. • Developed ETL pipelines for data migration and BI integration (SAS Business Intelligence Suite). 🔹 Financial Data Analysis & Reporting • Conducted data extraction and analysis to support financial reporting and decision-making. • Performed gap analysis to ensure regulatory and business compliance. 🔹 Stakeholder & Project Management • Acted as a liaison between technical teams and stakeholders, providing timely updates on issue resolution. • Supported all business database functional components, ensuring seamless operations. Key Project • Asset Management Financial BI Platform: o Led the design and implementation of a scalable data warehouse for financial analytics. o Streamlined ETL processes to enhance data accuracy and reporting efficiency.

Expertise: Financial Data Warehousing, OBIEE/Oracle, Data Quality Assurance Core Skills 🔹 BI Platform Development • Designed OLAP/OLTP databases using OBIEE/Oracle for financial consolidation. • Developed data quality assurance systems to ensure reporting accuracy. 🔹 Financial Reporting & Analysis • Created interactive web-based reports to visualize ROI and support business decisions. • Conducted data analysis to drive actionable insights for accounting/debt management. 🔹 Project Leadership & Compliance • Drafted business/technical specs and UAT test cases for system validation. • Coordinated cross-functional teams (IT + business analysts) to align solutions with SOPs. Key Project • Accounting & Debts Consolidation BI Platform: o Built end-to-end OBIEE/Oracle solution for financial data aggregation. o Streamlined reporting processes, enhancing data-driven decision-making.

Business Intelligence Consultant // Data Specialist Expertise: CRM/ERP Systems, Data Warehousing, Campaign Analytics Core Skills 🔹 Enterprise Data Solutions • Designed centralized databases and ETL processes (Oracle/MS technologies) • Developed Enterprise Data Warehouses merging disparate data sources • Built customer-facing reports with custom data marts for payment tracking 🔹 CRM & Campaign Management • Created Automatic Campaign Management system with churn KPIs • Established predictive analytics for customer behavior trends • Enhanced CRM data structures (marts/cubes) for decision-making 🔹 Leadership & Implementation • Managed offshore team (3 members) ensuring quality deliverables • Documented business/technical specs and trained end-users • Collaborated with stakeholders on invoicing/inventory systems Key Projects • CRM/ERP Dashboard Development: Unified reporting for customer care • Campaign Management System: Oracle-based solution with KPI tracking • Inventory/Invoicing Databases: Streamlined asset and payment tracking