Greg Nicol Email & Phone Number

Glasgow, Gb

Surrey, England, United Kingdom

• Data Centre Exit Programme - migrate specialist applications from data centre to AWS AppStream• Terraform, Powershell, Active Directory, Okta• Cost optimizations• Bulk data migration & reconciliation• AWS services incl. AppStream, AppStream ImageBuilder, VPC, EC2, S3, RDS, CloudWatch, CloudTrail, etc.

Oxfordshire, England, United Kingdom

* Containerized & migrated Springboot micro services from AWS ASGs to Fargate ECS* Migrated Jenkins CI/CD to CircleCI* Deployed AWS Security Reference Architecture accounts & Control Tower* General SRE including scalability & DR strategy & implementation* AWS services incl. VPC, ASG, ALB, EC2, S3, SES, SQS, Athena, Cognito, DynamoDB, ElasticSearch, RDS, ECS, ImageBuilder, CodePipeline, Lambda, CloudWatch, CloudTrail, Config, GuardDuty, etc.

London, England, United Kingdom

• Retrofit IaC for existing AWS deployments using Docker, Terraform & Ansible

Oxford, United Kingdom

• Design & implement all AWS infrastructure & CI/CD for 3 greenfield projects with AWS, Terraform & Ansible• Migrated various CI/CD and build processes from Teamcity to Gitlab Pipelines• AWS Accounts migration using AWS Organisations, Control Tower, IAM, SecurityHub, GuardDutyAutomated deployment of pre-sales environments using Bash, Terraform & Ansible• 3rd line pre-sales support• Created & maintained quality control & test AWS accounts for outsourced componentsImplemented cost reductions with AWS reserved instances• Prototype AWS infrastructure & CI/CD for Kubernetes big data analytics platform

Remote

* Strategic Warehouse Modelling, Analysis & Design * Prototyping & Requirements

Malta

* Agile methodology - planning, prioritising, retrospectives * Team lead functions – Reviews, objectives, leave, support rota * Projects, BAU & Support * Co-ordination, workflows, standards, approvals

Malta

* Migrated data warehouse from MySQL to PostgreSQL * Completely new clusters, across all environments * Improved high availability, DR, security, support options * Moved all ETL to Talend Data Integration * Implemented ETL processes, scheduling, monitoring, performance metrics * Change management and version control * Modelling & design, partitioning, normalisation * Access controls

Gauteng

• OLAP Architecture & data cleanup• Performance tuned OLTP db stored procedures• SSIS Migration from DTS to parallel workloads and atomic rerun-ability• Introduced TFS source control, Visual Studio projects, SSDT repeatable builds• SSRS Report maintenance• Supported overnight process and BizTalk integration• Support superuser queries and data investigations• DBA Duties - Releases, indexes, replication, backups, DR, test environments

London, United Kingdom

• Database team lead for Renewable Heat Incentive – Northern Ireland project• Pilot Agile development project for the organisation• Resource allocations, code reviews, release management• Introduced TFS repeatable builds, unit tests & test populations, VS projects• T4 generated CRUD stored procedures

Saffron Walden, United Kingdom

• SQL & C# developer on an OLTP mobile banking product• Fully Agile environment, with scrums, sprints, velocity, burn downs, etc.• Extensive SQL Server 2008 stored procedures, some T4 generated• Database indexing strategy & implementation including filegroups, de-normalising and partitioning• Performance tuning through query optimisation, DMV monitoring, benchmarking• Creating & maintaining automated SQL unit tests and test populations• LINQ, C#, debugging & extending WCF SOA in Visual Studio 2010• Visual Studio 2010, TFS and continuous integration in an Agile environment

Great Plains Automation Using Excel.

Database developer on M-Pesa mobile phone banking.SQL Server 2005, TFS Continuous Integration and source control.

IT Team lead on a new tactical project automating WRA calculations for year end.SQL Server 2005, MS Access, Perl, Autosys, Mercury Quality Centre

Developed & supported a tactical reconciliation to assist the UAT process of the strategic WRA reporting solution.SQL Server 2000, MS Access, DTS, Excel, Test Director

Supported and enhanced an EITF application. Investigated user queries, managed book of work enhancements, releases & supported surrounding work streams with test environmentsSQL Server 2000, VB6, ASP, DTS

Redesigned Summit to Swerve reconciliation system to accommodate additional interest rate derivative products.Sybase, Control M, Perl, Clearcase, C++, make, Summit

Led a small team through full development lifecycle to implement management of service level agreements with regulatory reporting data providers.Sybase, ColdFusion, VB, PowerBuilder

Developer on various Financial Control applications and projects centred around the European equities trade and positions data warehouse.Sybase, PowerBuilder, ColdFusion

Team developer maintaining & enhancing trading desk software for use in the energy and derivative markets.PowerBuilder, C & Visual C++

Consulted on site with customers to specify, develop and bespoke applications to integrate with the DP Umbrella & CBR Express Suite.PowerBuilder on win16 & win32, OLE & DDE integration, Sybase, SQL Server

Ndip, It, Information Technology

Now Rand Afrikaans University

Education record