Dylan Rose Email & Phone Number

Washington Dc-Baltimore Area

• Translated business requirements into dimensional designs, converting analytic business requirements into designs that facilitate data analysis. Created data standards, mappings, load strategies, and history tracking solutions. Developed functional data models to improve the consistency and reconcilability of financial and risk data, particularly for regulatory reporting purposes.• Collected and transformed business requirements into detailed technical specifications for implementing new features and enhancing existing business functionality in a production environment.• Utilized advanced SQL skills to conduct data quality analysis, including Count Validation, Dimensional Analysis, Statistical Analysis, and Data Quality Validation during data migration. Extensively utilized SQL queries on Staging, Data Warehouse, and Data Mart.• Developed a data governance strategy by establishing a Steering Committee and defining roles and responsibilities of stakeholders.• Constructed complex SQL database objects, such as Stored Procedures, User-Defined Functions, Triggers, Indexes, Tables, Views, and SQL joins, to implement business rules. Optimized SQL queries by analyzing Execution Plans and using SQL Profiler, Defragmentation, and Index tuning techniques to enhance database performance and data retrieval speed.

Bishkek, Kyrgyzstan

• Interacted with stakeholders, such as clients, users, and subject matter experts, to understand their needs and gather requirements for a project or system.• Analyzed the gathered requirements, identified gaps, and documented them in a clear and concise manner. Created functional and technical specifications, process flows, use cases, and other relevant documentation to communicate requirements to stakeholders and development teams.• Supported organizational change by identifying and assessing the impact of proposed changes, defining change management strategies, and assisting in the implementation of new processes or systems.• Analyzed existing business processes and systems to identify areas for improvement. Worked with stakeholders to streamline processes, optimize efficiency, and suggest solutions that align with business goals.• Acted as a liaison between different stakeholders, including business users, developers, testers, and project managers. Facilitated communication, manage expectations, and ensure that all stakeholders are aligned on project objectives.• Based on the gathered requirements, collaborated with technical teams to design appropriate solutions. Provided input on system architecture, user interface design, data models, and integration points.