Alex Greenwood
Profile
I'm a Senior Database Specialist with expertise in Powershell, REST API integration, and Data Engineering. Using these skills, I have led teams in developing large-scale BI systems that are accurate, reliable and a pleasure to use. I work for a highly respected research data & analytics company and understand the value of high-quality data and reporting. I can automate anything with an API - saving time, money and effort.
Experience
YouGov Plc - a global public opinion and data company
London, UK
Business Intelligence Architect
Aug 2012 - Present
- Business Process Automation Lead Developer
- Line Management of BI Developers
- Designed and Built 4TB Data Warehouse with OLAP cube semantic model
- Feature Engineering for anti-fraud predictive model
- Dimensional modeling
- Audit and Finance Reporting
- Data Engineering
- REST API Integration
- Powershell
- SQL
- Azure
- ETL
- REST
- OLAP
- Oauth2
- PostgreSQL
- Snowflake
Senior Database Administrator
Aug 2007 - Jul 2012
- MS SQL Server Administration (Tsql , Linked servers, Agent, Backups, Security)
- MS SQL Server Builds (2012,2016,2019,2022)
- Part of team that built and migrated multi rack datacenter from Berlin to London
- Data Center Storage Management (Pure, Nimble, Dell, NetApp)
- Data Center Virtualization Management (VMware)
- Desgined and built Datacenter monitoring solution (check_mk)
- VM Image Backups (Veeam)
- Active Directory SysAdmin (on premise to Azure hybrid)
- Out of hours on call support
- SQL
- ETL
- ODBC
- Windows
- Linux
- Storage
- Redshift
Telme.com/Farebase Ltd
London, UK
Database Administrator
Jan 1999 - Jul 2007
- Batch file scripting
- Database performance tuning
- Writing T-SQL Views and Stored procedures
- Transaction Fee Reporting (airline booking engine)
- Exchange Server Admin
- Hostmaster
- SQL
- DNS
- Ecommerce
- Excel
- +44 7971 785 888
- alexrgreenwood@hotmail.com
- yougov.co.uk
- github.com/alexrgreenwood
- London, UK
Skills
-
-
Programming
- Powershell (Advanced)
- SQL (Advanced)
- REST APIs
- Python
-
Things I can automate
- Data delivery pipelines
- User OnBoarding
- Data syncing
- Slack Apps
- Backups
-
Cloud API's I've used
- Microsoft Entra ID
- Microsoft Intune
- Sage People
- Netsuite
- Greenhouse (HR)
- Smart Recruiters (HR)
- Zoom
- Slack
- Absorb LMS
- AWS
-
Developer Tools
- Git
- Docker
- VScode
- Jira + Confluence
Languages
-
EnglishNative
-
GermanFluent