Philippe Addelia Email & Phone Number

North Las Vegas, NV, US

Honolulu, HI, US

Special projects, AI, data warehouse, ELT/ETL

Kingman, AZ, US

Seattle, WA, US

• Yielded critical insights by building end-to-end solutions involving data pipelines and database design Such as Data Vault 2.0, DBT ETL, Semantic layers, and reporting deliverables.
• Used tools and technologies such as AWS, Airbyte, Fivetran, Airflow, DBT, Snowflake, SSAS, Power BI, and Azure.
• Enabled the creation of a Cloud migration roadmap by conducting strategy assessments, including current state, future state, roadmaps, and other plans.
• Played a key role in project architecture, documentation, development, and implementation.
• Engaged and collaborated closely with customer stakeholders, as well as applications development, OpSec/DevOps, and management teams.

Dallas, Texas, US

• Oversaw projects involving development teams across multiple time zones on complex supply chain projects coordinating the efforts of various partners.
• Assessed projects’ shortcomings and weaknesses, suggested remediation, defined advanced data-integration techniques, and simplified/automated data integrations.
• Reduced time needed to test code and eliminated SDLC errors by creating strategic automation using cloud SaaS and PaaS software/tools.
• Delivered streamlined and robust solutions by building Azure SQL database and data workflows, as well as automating processes via Power Automate, Airflow, and NiFi.

Rancho Cucamonga, California, US

• Mobilized a 6-member team of data engineers and business analysts to minimize interruptions.
• Designed and built a migration of legacy on-prem finance systems to a modern cloud ERP application using data pipelines, Change data capture, Log synchronization, and data APIs.
• Facilitated organizational data strategies by directing high-level strategic and tactical decisions for business intelligence tools and applications, including ERP, CRM, ETL, DWH, and GL.
• Collaborated with other departments to promote Business Process Improvement.
• Enhanced key processes within the Software Development Life Cycle (SDLC).
• Resolved complex technical problems by conducting research and enacting solutions.

Rancho Cucamonga, California, US

• Established a data warehouse and implemented a concept of "data as an asset".
• Built Azure-managed data warehouse to support company-wide data movements/centralization.
• Improved business analysis, data analysis, data quality, and data security by modifying organization behavior policies, standards, principles, governance metrics, and processes.
• Minimized risk/liability and strengthened security by implementing CCPA and GDPR standards using encryption, masking, anonymization, and access control.
• Implemented CI/CD SLDC and separation of duty.

Geneva, CH

• Increased transaction efficiency by developing an ecosystem with ETL in SSIS and Informatica, SSAS Tabular models, Power BI Models, and SQL Server DataMart.
• Implemented data policies and procedures to ensure that the interests and priorities of data stewards, managers, and key users are represented.

Porsel, FR, CH

Develop datamart based on MySQL in a Linux environment, Design and develop dashboards using Pentaho.

Tucson, AZ, US

Design and implement a datamart based on Azure SQL Server Database, Develop dashboards with PowerBI Embedded.

Scottsdale, Arizona, US

• Headed a 4-member team of expert developers and delivered expertise to establish S&M DataMart based on SQL Server, SQL BI, and QlikView BI platform, enhancing performance.
• Created solutions primarily aimed at Sales & Marketing while supporting other organization needs, including Finance, Business Units, Manufacturing, Supply Chain, and Global Quality.
• Accelerated sales growth by launching OLAP Cubes to equip the sales force with key data.
• Yielded actionable insights by tracking performance by establishing dashboards/metrics.
• Enhanced BI visibility and control by integrating data, conducting training for sales experts, delivering periodic reports, and designing scalable self-service solutions.