Gregory Sigaud
Verified Expert in Engineering
Database Developer
Rickmansworth, United Kingdom
Toptal member since June 7, 2021
Gregory is a skilled business intelligence professional with expertise in building data warehousing and BI solutions, from inception through to architecture, design, and delivery. He built a company data catalog, transformed virtual queue data into a track-and-trace data mart, and wrangled online ordering, ePoS, collection, and payments into a cohesive data mart. He is known for his extensive data engineering experience across data management and modeling, DB architecture, and visualization.
Portfolio
Experience
Availability
Preferred Environment
Windows, Slack, Jira, Confluence, MacOS, GitHub, Visual Studio Code (VS Code), Amazon Web Services (AWS), Tableau, Microsoft SQL Server
The most amazing...
...project I architected was Nando's back-end databases used to run the restaurant (e.g., stock, purchase order, invoice approval) and its reporting platform.
Work Experience
Data and Insights Manager
Nando's UK & IRE
- Managed the delivery of a cloud-based data lake platform and data warehouse.
- Built the company data catalog (on Confluence), documenting every set, from ingested raw data to refined data marts.
- Transformed virtual queue data (JSON time-series-like) into a track-and-trace data mart, allowing the company to stay compliant.
- Wrangled online ordering, till and ePoS, collection, delivery, loyalty and payments external datasets into a cohesive 'customer 360 view' data mart.
- Produced a sales analysis data mart from the ePoS data, enabling granular data analysis and built a dashboard to reconcile the data with our financial system.
System and Database Architect
Nando's UK & IRE
- Defined and led the DBMS strategy, including the delivery of the business intelligence program.
- Collaborated with a data warehouse architect to develop a gross profit and menu sales analysis data mart. I delivered the solution to the business and provided source systems expertise.
- Designed and developed the database integration with the new HR system across all existing applications (timekeeping, wages, and employee master data) for Midland HR.
System Analyst
i3Q Systems, Ltd.
- Designed, built, and maintained a wide range of in-house ERP web-based applications used by Nando's restaurants.
- Transformed a purchase order capture application into a multi-supplier EDI-integrated PO system. It was a key solution which enabled Nando's to outsource its supply chain and open new restaurants across the entire UK and Ireland.
- Designed an integrated stock system from scratch. The solution was the bedrock for capturing menu sales mix and managing recipes. It facilitated the adoption of standard stock management processes across the business.
- Led the delivery of a SharePoint intranet to replace the outdated intranet solution, coupled with the introduction of document management and the adoption of K2 as a business process management platform.
- Architected, built, and maintained a workflow-based invoice approval system. The solution enabled the purchase ledger team to retain its small size during Nando's explosive expansion (x4), increasing payment accuracy and turnaround.
Lead Software Developer
Nando's UK & IRE
- Designed, developed, deployed, and supported bespoke web applications.
- Expanded the end-of-day application to capture new data from the EPOS system.
- Developed a telecommunications billing solution, facilitating cost allocation and fraud detection.
Senior Developer
Transputec Computers, Plc.
- Designed, developed, deployed, and supported bespoke applications for customers across a wide range of industries.
- Oversaw various business management areas such as contact, sales and lead, asset and fund, maintenance and repairs, workflow and process, and corporate intranet and extranet web applications.
- Served as the right-hand man of the development team manager. Mentored other developers.
Experience
Granular EPoS Sales Analysis
Off-premises Operations Reporting
Track and Trace Reporting
Education
Master's Degree in International Marketing
University of Strathclyde - Glasgow, UK
Higher National Diploma in Accounting and Business Management
University of Paul Sabatier Toulouse III - Toulouse, France
Higher National Diploma in Mechanical Engineering
University of Paul Sabatier Toulouse III - Toulouse, France
Skills
Tools
Tableau, Jira, Confluence, K2 Blackpearl, Microsoft Power BI, Apache Airflow, GitHub, Slack
Languages
SQL, Python, Active Server Pages (ASP), Visual Basic 6 (VB6), HTML
Paradigms
Database Design
Storage
Database Architecture, Microsoft SQL Server, Amazon S3 (AWS S3), Redshift, PostgreSQL, SQL Server Reporting Services (SSRS), Apache Hive, SQL Server DBA
Frameworks
Presto
Platforms
Linux, Windows, MacOS, Visual Studio Code (VS Code), Amazon Web Services (AWS), SharePoint
Other
Data Modeling, Team Management, Data Warehousing, Solution Architecture, Big Data Architecture, Data Engineering, Staffware
How to Work with Toptal
Toptal matches you directly with global industry experts from our network in hours—not weeks or months.
Share your needs
Choose your talent
Start your risk-free talent trial
Top talent is in high demand.
Start hiring