Contract Developer

Consolidating, cleaning, deduplicating legacy source data with a view to populating a new ERP system.

Rewriting existing views, stored procedures, and functions from an on-premises host to incorporate in a few hundred SSRS reports to point at a new Azure SQL database.

I introduced Azure DevOps, Agile sprints and scrums and the use of Git for version control and to break down large projects into smaller, manageable chunks and to be overt in project planning, management, and progress reporting. Database development, performance tuning, ETL work - all using the MS stack (SSSIS, SSAS, SSRS), Power BI, SQL Server 2019, Visual Studio, Git, SSDT, SSMS, MS Office 365, Teams.

Modelling, designing, populating, and reporting against a new data warehouse.

Collaborating with internal stakeholders and a development team to cleanse, deduplicate and map source data from multiple OLTP databases into a new dimensional data warehouse. Used Gitlab, Visual Studio, T-SQL, SSIS, SSRS, Power BI.

Key achievements: Building a data warehouse from scratch in 3 months.

Database development on the Diamond data warehouse project. Participating in daily Agile scrums. Designing new and improving existing data warehouse data loads from XML source files from PEGA app.

Key achievements: Updating SSIS routines to improve speed of daily loads from initial 19 hours to 90 minutes

Database development on a GDPR project. Stakeholder management of internal customers. Maintaining data under GDPR legislation right across all aspects of Assurant's business (for example, to purge data over a specified retention date, to restrict access to data on a stakeholder's request) and to maintain an audit of those processes.

Key achievements: Hitting the go live date regarding GDPR deadlines

Data warehouse development. Extracting Webtrends analytics through a REST API. Covering for DBA when absent.

Key achievements: Developing the data warehouse to include sales pipeline data

• Facilitating the migration of employee data from two existing Oracle databases to a new Fusion HR and payroll system when RBS created a new bank
• Analysing existing systems, mapping data to new SQL 2012 databases and creating data extracts to import into the new system
• Generating globally unique identifier and lookup tables to support the data import, using multiple data sources including databases, flat files and spreadsheets
• Leading the reconciliation between systems and between multiple testing and live environments, and porting historic data
• Generating a mail merge system to enable employees to elect benefits under the new payroll system and to ensure their existing data was correct
• Using SSIS to manage multiple dependencies in source data and the need for data validation, transformation, control and error trapping

Key achievements:

• Designing a primary SSIS package to control around 400 smaller SSIS packages to handle the extract, transform and load process, which was completed in 20 minutes
• Creating multiple databases and around 300 stored procedures
• Managing all activities to keep the project on track for completion within a strict deadline imposed by financial regulators

Successfully completing a short-term contract to migrate five databases from SQL 2008 to SQL 2012 using SSIS, functions and stored procedures

• Implementing SQL 2008 for ad hoc object creation, troubleshooting and administration
• Creating and populating a dimensional data warehouse schema using SSIS, OLAP cubes using SSAS and SQL Server Reporting Services reports using SSRS

Key achievements: Tackling complaints received from the Financial Conduct Authority regarding the misuse of customer data by amalgamating marketing data from 10 companies into one database, thereby enabling calls to be regulated in line with contractual agreements

• Designing a new data warehouse solution for roll-out across 25 companies, to overcome problems with inaccuracies and inefficiencies in the existing solution and also to enable use of Cognos for reporting
• Creating a proof of concept using SSIS reusable code and building quality assurance into the process
• Developing a data model in ER Studio, with 120 scripts to create the new database schema, which were used as a basis for SSIS packages
• Working effectively and flexibly both from home and from national and international offices

Key achievements: Creating an end-to-end model of the new business data warehouse

• Configuring two SQL 2005 Servers on site for the Universities Superannuation Scheme, collaborating with internal and external development teams to support a Microsoft Office SharePoint installation
• Liaising remotely with the management at Citigroup to analyse the current server farm and recommend changes to performance, design and security, writing code for monitoring and reporting, redesigning legacy processes to archive and purge unnecessary data, prepare for an upgrade to SQL Server 2005 and cover UAT roll-outs