Nicolas Dol

As the lead of a team of 8 developers, I collaborate closely with the Product Manager. I craft the product’s roadmap, conceptualize technical solutions for the complex business challenges, and refine user stories with well-defined acceptance criteria. I oversee and implement the features using DBT on Databricks. Following user needs, I transformed the project from an ML-centric paradigm to a BI-centric one, ensuring maximized data value and reuse, while developing new features adhering to best practices (unit testing, CI/CD, documentation) and managing technical debt. Key achievements : - Agile Delivery: Leveraging DBT capabilities, made very fast deliveries to finetune the product for users’ needs. - Strategic Leadership: Helmed a project with a budgetary outlay of €1 million, guaranteeing optimal outcomes and value. - Pioneering Data Architecture: Conceived and deployed a Kimball Data Warehouse from inception, ensuring a reliable data source for the organization. - Operational Optimization: Realized a 70% plummet in infrastructure expenses and process time by setting up incremental loading. - Knowledge Sharing: Promoted interactive sessions, seeding knowledge across diverse projects.

As a developer in the Data Center of Excellence, I took on major roles in a Spark-based database project focusing on change data capture, as well as a financial data integration initiative. Key achievements • CDC Development: Created a tool interfacing with Oracle, Kafka and SQL Server, directing data to Delta storage. • Financial Integration: Played a key role in a financial data integration project. • Tech Collaboration: Engaged with various Tech Leads, discussing and presenting development and architectural choices.

Anchoring the transversal Data unit at the headquarters, I synergized with the Head of Data, setting the trajectory for modernizing the company's Data Warehouse. My role was pivotal in curating and showcasing POCs, the conclusions from which decisively influenced the architectural choices. Key achievements • Infrastructure Audit: Undertook a wide audit of existing systems, curating an actionable architecture roadmap for the future. • Synapse Analysis POC: Set up a POC that evaluated the potential of transitioning from the traditional SQL Server systems to the advanced Synapse Analytics framework. • Data Processes Monitoring: Creation of a Data Mart optimized for Azure Data Factory Logs, facilitating global analysis in Power BI • Tech Viability Assessment: Supervised a benchmarking for Snowflake, assessing its integration potential within the evolving architecture.

In the primary Data team, my role involved transitioning legacy on-premises architectures to utilize Azure capabilities. I pinpointed areas of technical debt and collaborated with Tech Leads to derive solutions. Key achievements • Data Warehouse Creation: Designed and developed a hybrid Data Warehouse integrating on-premises and cloud sources, complemented by a structured star model in Power BI Premium. • Process Enhancement: Reworked an Azure Data Factory process, marking a 90% cost reduction and halving execution time. • Function Development: Crafted Azure Durable Functions in C#. • Alerting Mechanism: Instituted automated Microsoft Teams notifications for ETL disruptions geared towards both users and developers. • CI/CD Deployment: Implemented continuous integration and delivery processes across Database, ADF, and Power BI platforms. • Team Training: Organized and led instructional sessions for the existing team.

Within the Data Center of Excellence, I focused on developing Python toolkits aimed at achieving a consistent approach to Python development across Pernod Ricard. Key achievements • Python Standards: Formulated a catalog of Python best practices intended for worldwide adoption. • Project Consistency: Launched a foundational cookiecutter project, ensuring uniform: o CI/CD pipelines o Unit testing methodologies o Folder hierarchies o Auto-generated documentation • Deployment Refinement: Enhanced the deployment mechanism for Python modules across an array of Databricks workspaces.

In the Data Center of Excellence team, I delved into innovative architecture exploration, emphasizing Power BI Premium-based solutions. This was with a vision to elevate model refresh efficacy and diminish the maintenance overheads of the current systems. Key achievements • Model Enhancement: Introduced Power BI composite models, significantly curbing code redundancy and refresh time • Refresh Optimization: Refined models to support incremental refreshes, reducing refresh durations by a factor of five. • Automated Handling: Employed Powershell scripting for dataset refreshes, streamlining error management and reporting.

As a dedicated Microsoft Certified Trainer, I helmed intensive one-week training modules, preparing aspirants for the Microsoft Azure Administrator Exam. Exam topics • Manage Azure identities and governance • Implement and manage storage • Deploy and manage Azure compute resources • Configure and manage virtual networks • Monitor and maintain Azure resources

As the key technical liaison for the build teams, I uphold the quality standards of developers' output. My role encompasses making architectural decisions, validating developers' time estimates, and ensuring the smooth progression of development tasks. Key achievements • Code Review Protocols: Initiated and implemented code review practices within the team, complemented by a referential of development best practices • Architectural Oversight: Defined and tailored the overarching architecture of projects. • Support Framework: Structured and systematized the support mechanisms available to developers.

As the key technical liaison for the build teams, I uphold the quality standards of developers' output. My role encompasses making architectural decisions, validating developers' time estimates, and ensuring the smooth progression of development tasks. Key achievements • Code Review Protocols: Initiated and implemented code review practices within the team, complemented by a referential of development best practices • Architectural Oversight: Defined and tailored the overarching architecture of projects. • Support Framework: Structured and systematized the support mechanisms available to developers.

As an integral member of Datatorii's management— a consultancy specializing in Microsoft Data technologies— I ensure that consultants possess the requisite skills to cater to client demands. When needed, I devise bespoke training modules before embarking on missions. Additionally, I conduct tech surveillance and introduce clients to emerging technological solutions. Key achievements • Git Training: Devised a comprehensive training module focused on the effective use of Git. • Real-Time with Power BI POC: Demonstrated the real-time capabilities of Power BI through a Proof of Concept. • Custom Visualization: Engineered a Power BI Custom Visual.

In the Data Center of Excellence team, I focus on staying up to date with new Azure offerings, ensuring seamless integration within our expansive Data Platform. Furthermore, I oversee the drafting of guidelines and templates, facilitating the global deployment of these novel technologies. Key achievements • Power BI REST API Development: Designed a custom REST API Backend, tailored to send requests to a tabular model hosted on either Azure Analysis Service or Power BI Premium. • Power BI CI/CD: Set up a continuous deployment system for Power BI Premium using Visual Studio. • Deployment Processes: Formulated procedures to deploy Logic Apps, Data Factories, and Databricks notebooks. • Python Toolbox: Developed a Python Toolbox module, providing a streamlined interface between Python scripts and storage systems (Azure Datalake Gen2/S3, SQL Server/Snowflake). This module is used by all development teams of Pernod Ricard’s Headquarters.

In the wake of a successful Synapse Analytics POC validation, I played a pivotal role in rolling out multiple environments, ensuring a clear distinction between developers and end-users. This deployment came equipped with an exhaustive toolkit tailored for code historization, streamlined deployment, and meticulous monitoring. Key achievements • Team Training: Spearheaded the training initiatives, educating the team on Git and its associated tools. • Pipeline Development: Conceived and instituted CI/CD pipelines complemented by a refined deployment procedure.

In the capacity of a BI Data Developer, I undertook end-to-end ETL implementations, encompassing everything from rudimentary data extraction to the visualizations in a Power BI report. Notably, the data sources spanned both cloud and on-premises locations. Key achievements • ETL Mastery: Efficiently orchestrated full ETL processes, integrating data from diverse sources for comprehensive Power BI reporting.