Summary
Overview
Work History
Education
Skills
Timeline
Generic

Royston Dowden

Delan,FL

Summary

Driven Database Developer with over 10 years of proven success designing and implementing database solutions. Analytical and skilled in understanding business problems to develop systems that improve functionality. Talented at working effectively in collaborative and self-motivated environments.

Overview

18
18
years of professional experience

Work History

Database Developer

BNY Mellon
05.2006 - 01.2023
  • Developing and Maintained relational data models, tables, views, functions, grants, triggers, stored procedures, indexes, and other database components
  • Query troubleshooting, stored procedure optimization, identified Blocking sessions in backend, complex joins etc
  • Developed Power BI MIS reporting and dashboards
  • Developed and maintained ETL projects with data sourced from MQ, SFTP, Email, Json, XML and proprietary client formats
  • Collaborate with cross-functional teams to identify and solve complex software problems
  • Debugged and resolved issues involving performance and integration with external systems
  • Collaborate with other teams and stakeholders using agile methodology to ensure quality code, timely delivery and stakeholder satisfaction
  • Delivered complex business requirements without any issues by leveraging strong troubleshooting skills and extensive oversight.
  • Designed data models for complex analysis needs.
  • Collaborated with system architects, design analysts and others to understand business and industry requirements.
  • Developed and delivered business information solutions.
  • Modified databases to meet needs and goals determined during planning process.
  • Coordinated with project management on database development timelines.
  • Designed, developed, and maintained projects in C# and VB applications using .NET Framework


IT Consultant

Apex Systems
06.2005 - 05.2006
  • Contributed to the stabilization of MS Access platform after exodus of original team
  • Contributed MS SQL database object development to help optimize core application performance
  • Contributed VB development to upgrade progress reporting in core application

Education

BS - Computer Science, Mathematics

Kean University
Jersey, New

MIS - Computer Science

Amer. Intercontinental University

Skills

  • Database Development
  • MS SQL Server
  • T-SQL
  • SQL Server Integration Services (SSIS)
  • SQL Server Reporting Services (SSRS)
  • Performance Issue Diagnosis
  • Extraction Transformation and Loading (ETL)
  • Python
  • C#, Visual Studio
  • Agile Methodology
  • Application Development

Timeline

Database Developer

BNY Mellon
05.2006 - 01.2023

IT Consultant

Apex Systems
06.2005 - 05.2006

BS - Computer Science, Mathematics

Kean University

MIS - Computer Science

Amer. Intercontinental University
Royston Dowden