Adam Le

Adam Le Email and Phone Number

A leader in data, data governance, BI, analytics and technology @ Pernod Ricard
paris, île-de-france, france
Adam Le's Location
Greater Sydney Area, Australia
About Adam Le

Adam Le is a A leader in data, data governance, BI, analytics and technology at Pernod Ricard. Colleagues describe them as "Adam is a very intelligent, diligent and hardworking Database Analyst who is able to quickly analyse problems and apply his up-to-date knowledge of data handling technology. At Elastic Grid, he was tasked with some very challenging projects, including upgrading our SQL servers ensuring the migration didn’t impact our users and also to create a robust scalable structure for our Data Warehouse which was struggling to keep up with the types of Analytical data we wanted to present to users. A great addition to any product team that has complex data to manage that needs someone to quickly grasp the product domain and deliver organised, scalable and performant database solutions." and "Adam is one of the best DBA which I have the pleasure to work with at Elastic Grid. He was tasked with upgrading the company's ageing database infrastructure and improving the overall performance of the company's legacy data warehouse. He was given an incredibly difficult task that many of his predecessors have failed to fulfilled. Many of the previous DBAs were not able to comprehend the difficulty of this role, but Adam was not afraid to take on the challenge and with his immense knowledge and experience, he completed all the tasks successfully. Adam successfully re-configured the MS SQL Server Availability Group ensuring automatic failover of database nodes and also re-designed the data warehouse structure to deliver a three fold improvement in performance. Adam was instrumental in overseeing the upgrade of the database infrastructure, restructuring database storage allocation to help reduce storage costs and was key in re-engineering legacy queries to greatly improve on their performance. Adam also played a critical role in helping the company getting Microsoft Gold Partner accreditation by working tirelessly with other key external parties to ensure the company is in compliance to receive partnership accreditation with Microsoft. Adam is someone the team can always count on to resolve some of the most complex database problems. His calm, humble and professional demeanour makes him an asset to any team."

Adam Le's Current Company Details
Pernod Ricard

Pernod Ricard

View
A leader in data, data governance, BI, analytics and technology
paris, île-de-france, france
Website:
pernod-ricard.com
Employees:
14876
Adam Le Work Experience Details
  • Pernod Ricard
    Head Of Data Analytics
    Pernod Ricard Aug 2024 - Present
    View
  • Aia
    Head Of Data & Governance | Head Of Analytics
    Aia Jan 2022 - Nov 2023
    Syndey
    View
  • Westpac
    Senior Manager Bcm (Reporting&Analytics) | Service Delivery Manager |Infrastructure Services Manager
    Westpac Mar 2018 - Jan 2022
    View
  • Elastic Grid
    Data Architect
    Elastic Grid Aug 2016 - Mar 2018
    - Designed data roadmap, data governance, databases, servers and cloud.- Implemented BI solutions after evaluating tools (MS SRSS, MS SSIS, PowerBI, Tableau, QlikView and Klipfolio).- Redesigned data structure (conceptual, logical, physical). Redesigned tables using Kimball method, setup constraints and ETL processes. - Mapped, cleansed, transformed, integrated, validated and migrated data from different sources using stored procedures, SSIS, MS DQS, triggers and SQL.- Data profiling to define tables structure. Data lineage for data flow.- Extracted data from Google analytics and OLTP database into data warehouse. Created dashboards/reporting from SQL datasets. Used statistics, Klipfolio and Tableau for analysis, trends and insights, and to resolve business requirements. - Analyzed qualitative and quantitative data over time to produce insights and improve campaign executions and sales. Customer segmentation on age and job categories.- Hands on installation, configuration, migration, support and upgrade of SQL, DB2 and MySQL. Migration from on premise servers to AWS cloud and VMs.- Database capacity planning, tuning, backups and DR/high availability.- Implemented data and database security.- Implemented cost saving solutions such as EC2 AWS instance reservation, consolidating disks and licenses. -Conducted Scrum, Sprint and trainings.
  • Ibm / National Australia Bank
    Technical Team Lead
    Ibm / National Australia Bank Oct 2007 - Aug 2016
    • Team Lead for MSSQL Server (Database, SSIS, SSRS, SSAS), MySQL, Oracle, DB2 on Linux, Windows and UNIX.• Managed DBAs/Analyst onshore and offshore. Managed resources for projects, staff, BAU tasks, incidents and on call. Addressed staff issues and kept track of staff workload.• Mentored and skilled up staff. Re-skilled DBAs.• Represented MSSQL Server to management and change management meetings.• Conducted fortnightly meetings for staff.• Stakeholder management and onsite consultation for escalated problems.• Developed specialized proposal and detailed technical evaluations of products and techniques to meet business needs.• Implemented longer term strategies and resolutions on software/hardware problems.• Provided data/database/data warehouse solution designs for our clients like Westpac, Customs, DHA, NAB, Telstra, NSW Transport and IBM.• Designed, reviewed, updated and approved SOWs, HLD, DLD and requests.• Provided ORACLE/DB2/SQL Server/MySQL technical expertise and judgment to define and implement technical solutions to support the needs of the business.• Implemented, configured, tested, supported, maintained, tuned and upgraded all SQL Servers (2000, 2005, 2008, 2012, 2014, 2016, Clustering, Log Shipping, Mirroring, AlwaysOn, DR), DB2 (v5, v8, v9, v10, DB2Blu, HADR, log shipping, flash copy, Replication, DR), ORACLE (10G,11G, Data Guard) and MySQL (5.6) for OLTP, OLAP, data warehouse and master data systems.• Database/Data Warehouse/ETL housekeeping (scripting tasks).• Performed database and server tuning (Memory, IO, database configurations, SQL, disk)• Data migrations and consolidations. Setup tests on migrations and consolidations.• Managed data/databases risks and compliances. • Setup data governance/practices. Quarterly revalidations of data/database systems.• Data modeling using Erwin, Star Schema and relational• Automated data refreshes (ETL) and set up constraints to check data integrity.• Project costing, licensing and management.
  • Suncorp Group
    Senior Database Administrator
    Suncorp Group Aug 2005 - Oct 2007
    Sydney, Australia
    • Provided technical advice on DB2, Oracle and MSSQL Server databases.• Database costing and licensing. • Reviewed and supplied High Level and detailed database designs.• Data/ER modelling.• In charge and supported Oracle Financials.• Implemented, configured, supported, maintained and upgraded all DB2 databases (v7 & v8) on AIX, Solaris, LINUX and Windows.• Scripted database housekeeping jobs e.g. restore, backup, runstats, profiler• Performance tuning on DB2 databases such as SQL tuning, database configuration, instance configuration, data reorganisation, db2expln, db2advis, snapshot, event monitoring. • Set up high availability and disaster recovery (HADR).• Created Stored Procedures and DB2 Replication.• Oracle/MSSQL Server database migration to DB2.• Configured and supported MSSQL Server 2000 and Oracle databases.• Database support for ETL (DataStage), WebSphere.• MSSQL server log shipping.• Tivoli Management System (TSM) setup for databases.
    View
  • Ibm
    Advanced Support Engineer
    Ibm May 2004 - Aug 2005
    Sydney, Australia
    • Provided DB2 expertise to customers around the world and level 1 team.• Reproduced errors for analysis, including installation and configuration of operating systems (AIX, SOLARIS, Windows and LINUX) and DB2 (version 7 and 8).• Traced problems such as operating system traces (eg AIX trace), DB2 traces, client traces and JDBC traces.• Analysed DB2 source codes for defects.• Provided workarounds for problems that are part of the code defects.• Problems resolution.• Conducted trainings.
    View
  • Salmat
    Senior Database Administrator
    Salmat Oct 2002 - May 2004
    Sydney, Australia
    • Maintained, supported, installed and in charge of all DB2 databases, including IBM Content Manager and JDEdwards, on AIX platforms and Windows.• Provided technical database expertise to clients.• Database housekeeping: backups, restores, scripting, reorganisation, updated statistics, problem resolutions, tuning, performance tuning, export/import, created database objects, database permissions, database monitoring, service pack upgrades, TSM setup for databases. • Data integrity and manipulation.• Performance tuning and monitoring (update database configurations, REORG, RUNSTATS, SQL tuning, snapshot and event monitoring).• Supported databases for IBM Content Manager and JDEdwards OneWorld• Supported and maintained MSSQL Server 7.0 databases.• Managed junior staff• Data Modelling.
    View
  • Centrelink
    Data Warehouse Administrator
    Centrelink Feb 2000 - Oct 2002
    • Designed, developed and managed DB2 databases (over 2TB of weekly production data).• Installed, supported and administered DB2 Databases (such as replication, database backup, recovery, table access, table spaces, databases etc.) • Performance tuning and monitoring (event/snapshot monitoring, SQL tuning).• Data modeling on databases using Visio Professional (ER and Star Schema diagrams). • Data Warehouse design and implementation.• System monitoring and improvements (e.g. created and updated scripts to improve system performance using Perl and scripting languages).• Optimised and created SQL codes to extract data.• Created and maintained user interfaces for ETI (Extract Tooling Instrument) using TCL/TK language.• Migration of scripting programs into Java.• Data extraction, transformation and manipulation using ODBC and ETI tools.• Data integrity maintained from the database.• HTML web page development for users to access documents and references.• UNIX administration .
    View

Adam Le Education Details

Frequently Asked Questions about Adam Le

What company does Adam Le work for?

Adam Le works for Pernod Ricard

What is Adam Le's role at the current company?

Adam Le's current role is A leader in data, data governance, BI, analytics and technology.

What schools did Adam Le attend?

Adam Le attended Monash University, Monash University.

Who are Adam Le's colleagues?

Adam Le's colleagues are Ryan Solomon Csw, Css, Cathryn Honor, Anabel Gomez Pinillos, Charlie Willcox, Olivia Sergent, Bex Foley, Ca, 秦立群.

Not the Adam Le you were looking for?

View similar profiles

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.