Consolidating, cleaning, deduplicating legacy source data with a view to populating a new ERP system.
Working on a "Proof of Concept" project to advise on update of existing data into a new data warehouse using Azure.
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.
Working on a new data warehouse and BI / MI Reporting, SQL coding new and amending existing stored procedures, other db objects, ETL using SSSIS, SSRS, Power BI, SQL Server 2016, Visual Studio 2019/2022, TFS, SSDT, SSMS, MS Office 365, Teams, Solarwinds.
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.
Aldermore Bank is moving their data warehouse application from an internal datacentre to one provided by a third party.
Using GitHub, Visual Studio 2019, SQL Server 2019, SSIS, SSRS, Power BI.
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 a warehouse upgrade. Working with internal stakeholders and consultants to migrate source mainframe data through OLTP databases into an SAP software environment.
Key achievements: Improving daily data load into the data warehouse from over 90 down to just 7 minutes.
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 Brexit project. Collaborating with internal customers to establish likely Business Requirements based on limited knowledge of impending legislation changes. Providing data handling and reporting under potential new legislation across FGH's business for them to comply with changing import and export regulation between UK and EU.
Key achievements: Working with other developers to provide data to be consumed through Teradata and API's to a tight deadline and within budget
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
Database performance troubleshooting. Stakeholder management of customer on and off site. Introducing changes to database performance, monitoring and maintenance.
Key achievements: Troubleshooting and correcting database performance problems at a client site in a reduced timescale
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
Key achievements: Migrating large numbers of Fact tables to Dimension tables thus de-duplicating data and saving space
Key achievements:
Maximising the use of SQL 2012 to develop and maintain databases for marketing analysis
Key achievements: Introducing Agile approaches to project management
Successfully completing a short-term contract to migrate five databases from SQL 2008 to SQL 2012 using SSIS, functions and stored procedures
Key achievements: Enabling users to forecast future vehicle valuations online and understand the calculations involved
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
Optimising SQL 2008 Business Intelligence during the roll-out of Microsoft Dynamics AX
Key achievements: Facilitating the production of business intelligence reports by liaising with Business Analysts and BI teams to create new objects and structures
Key achievements: Creating an end-to-end model of the new business data warehouse
Entdecken Sie andere Experten mit ähnlichen Qualifikationen und Erfahrungen.