Dean Hill Email & Phone Number

• Responsible for the migration of historical client data from IPSOS’ SQL Server environment to RetailNext’s GCP.• Design, develop and maintain a two-way synchronisation process of client data between IPSOS’ SQL Server and RetailNext’s GCP, allowing the business to complete other aspects of the client migration without interrupting our service to those clients. .• The migration and synchronization were achieved through a skilled use of SQL, Python and PowerShell programming, ETL design,… Show more • Responsible for the migration of historical client data from IPSOS’ SQL Server environment to RetailNext’s GCP.• Design, develop and maintain a two-way synchronisation process of client data between IPSOS’ SQL Server and RetailNext’s GCP, allowing the business to complete other aspects of the client migration without interrupting our service to those clients. .• The migration and synchronization were achieved through a skilled use of SQL, Python and PowerShell programming, ETL design, and cross-team collaboration. Show less

• Database Administrator for 300+ MS SQL databases and cubes across several servers. This was in a hosted (Rackspace) environment.• Database and Cube design and development.• SQL programming and Stored Procedure development.• Optimisation and performance tuning• SSIS and SSAS development.• ETL process design and development.• Data quality and integrity management.• Management/mentoring/training of a small team of support execs.• Commissioning software development… Show more • Database Administrator for 300+ MS SQL databases and cubes across several servers. This was in a hosted (Rackspace) environment.• Database and Cube design and development.• SQL programming and Stored Procedure development.• Optimisation and performance tuning• SSIS and SSAS development.• ETL process design and development.• Data quality and integrity management.• Management/mentoring/training of a small team of support execs.• Commissioning software development from 3rd party suppliers.• Acting as SQL mentor / advisor to data analysts.• Managing server o/s upgrades and SQL upgrades.• Managed multiple server consolidation projects that reduced the infrastructure cost to the business.• Made many system and process improvements that reduced the workload for my team and for others.• Implemented measures to ensure the sustainability of business solutions. Show less

Witney, Uk

• Monitor the delivery of software ensuring that it is produced to the required company standards.• Accountability for the success of the bi-weekly software update to clients.• Ensuring that expectations regarding software releases are properly managed.• Advising colleagues and clients on system requirements and customisation options.• Acting as lead, 2nd-line, support for all client and business queries regarding our applications.• Planning and prioritisation of work for… Show more • Monitor the delivery of software ensuring that it is produced to the required company standards.• Accountability for the success of the bi-weekly software update to clients.• Ensuring that expectations regarding software releases are properly managed.• Advising colleagues and clients on system requirements and customisation options.• Acting as lead, 2nd-line, support for all client and business queries regarding our applications.• Planning and prioritisation of work for development and QA teams, balancing the needs of both the business and clients.• Participated in formal reviews, team meetings, one-to-one meetings and appraisals.• Leading my team through all development life-cycle stages.• Acting as an escalation point for client issues.• Created a learning culture within my team and promoted it across R&D.• Implemented measures to ensure sustainability of the software.• Developed a configurable application to automate the validation and migration of client data.• Improved the quality of work delivered by my team.• Worked to introduce Scrum and Agile to my team and promoted it across R&D. Show less

• Scheduling work for my team.• Holding and chairing meetings with clients.• As a technical expert, advising and mentoring my team on development best practices.• As a SQL/data expert, advising and mentoring my team on best practices for data migration.• Ensure that projects are delivered on time, to budget and without problems.• Liaising with third party providers.• Production of budget and management reports.• Analysing client requirements and… Show more • Scheduling work for my team.• Holding and chairing meetings with clients.• As a technical expert, advising and mentoring my team on development best practices.• As a SQL/data expert, advising and mentoring my team on best practices for data migration.• Ensure that projects are delivered on time, to budget and without problems.• Liaising with third party providers.• Production of budget and management reports.• Analysing client requirements and issues.• Producing functional and technical specifications.• Estimating work required from client’s change requests.• Demonstrating software to clients and colleagues.• Created a development Standards group.• Championed the development of an Internationalised version of our Web offering.• Promoted the idea of client funded development to the Sales team. Show less

• Holding and chairing meetings with clients.• Analysing client requirements and issues.• Producing functional and technical specifications.• Develop bespoke and standard client-server solutions for both the Web and desktop PC • Demonstrating software to clients and colleagues.• Carrying out data migrations.• Promoted the idea of using Excel for client data onboarding. • Made a successful transition from Delphi to Java/JSP as part of the Payroll development team.

• Development of a client-server work scheduling system using Delphi and SQL Server.• Database administration for both production and MI systems.• Database design to support the work of the Database-marketing manager.• Produced an innovative pattern matching application, using SQL server, for use in “bursting” addresses, which had a success rate of over 95%. • Responsible for the establishment of software development standards.