Thomas Adams Email & Phone Number

Kings Hill, England, United Kingdom

Spearheading the transition of the companies CRM to a new cloud based SAAS system.

Linton, England, United Kingdom

• Worked as a key player for improving the data surrounding the main ERP system within the company.Highlights from my role included:
• Creating and manipulating large datasets 100k plus rows using Power query and Oracle SQL databases
• Developing models to overcome data hurdles across numerous departments
• Producing large scale reporting for key stakeholders
• Learning and understanding how to properly implement an Agile working environment

Snodland, England, United Kingdom

• Within this function, I improved the reporting process when using MS Excel and SAP BusinessObjects, to enhance the creation of both weekly and monthly reports.Highlights from my role included:
• Generated the annual energy budget for a £17m cost center
• Worked on the trial AI leakage detection program, creating a graphing system using a series of nested pivot tables and pivot graphs in Excel, enabling users to investigate data points and highlight the validity of the.
• Reduced run time from five hours to 20 minutes, when creating a VBA script to manipulate a dataset of over 800,000 rows and 30 columns
• Rationalised working processes when designing monthly SAP business objects and Excel reports for three separate business areas, for utilisation by 50+ users
• Data mined, cleansed and analysed 2m+ rows of water consumption data, which facilitated troubleshooting and provided data QA, through using Python and related libraries Pandas, NumPy, Matplotlib and Seaborn

Snodland, England, United Kingdom

• Through my role, I performed data analysis and review of customer records utilising the in-house CRM platform and Excel.Highlights from my role included:
• Worked through over 30 varying data sources containing hundreds of rows of customer data and correlated a plethora of unrelated data sources
• Streamlined data when applying Excel formulas to automate the cleaning of text strings on large amounts of customer data
• Flagged customer water supply points and corresponded data to unique property UPRNs on the online geographical mapping system ArcWeb
• Confidently interacted with customers to validate the GIS location of properties

London, England, United Kingdom

• Undertaking a temporary assignment, I helped Accounts Payable with the transition into an agile working environment, creating supplier-specific records for over 2,000 commercial suppliers.Highlights from my role.
• Simplified documentation when reviewing and eliminating unnecessary data