• Documented ETL mappings by reviewing multiple Excel documents and leveraging Structured Thinking/Gap Analysis to gather requirements, meeting internal, and external stakeholders. • Coordinated meetings to develop technical specifications and data migration load documentation while serving as the primary point of contact for the database team.• Implemented a change control system to document the historical context of changes made by developers, including those who requested the change, who approved it, and the criteria for its necessity. • Collaborated with a cross-functional team to create a comprehensive runbook for operations and a how-to guide for developers to perform basic tasks, ensuring the efficient execution of critical business processes.• Demonstrated strong communication skills and ability to manage complex projects with multiple stakeholders, resulting in successful project completion and increased efficiency within the organization.

Display solid technical foundation of SQL Server Business Intelligence stack, including rigorous technical training on foundations of SQL Server, SSIS, SSRS, and ETL concepts.• Developed 3 SSIS packages with error handling and various data transformation tools, including conditional split, merge, multicast, data conversion, and script components utilizing C#, to import and export data from multiple data formats such as XML, Excel, flat files, JSON, and OLE DB files using the ETL process.• Designed and developed the logical design and physical build of a Data Warehouse for a Mortgage Lending project, including identifying KPI's and utilizing agile methodologies throughout the Software Development Life Cycle.• Demonstrated expertise in T-SQL, including developing multipart SQL queries composed of sub-queries, utilizing Data Definition Language and Data Manipulation Language, creating functions, indexes for query optimization, joins, triggers, variables, temporary tables, table variables, and views to accomplish various database objectives.• Utilized Visio to design and develop 6 complex interactive dashboard reports using SSRS, including sub-reports, drilldowns, drill-throughs, and parameters, while identifying KPI's by making sense of raw data