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.
• 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.
• 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.

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.
• 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.
• 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.