60Months of experience reverse-engineering legacy databases (specifically MS Access), including analyzing existing tables, relationships, queries, forms, macros, and VBA modules to identify structural anomalies, and writing complex SQL queries (including multi-table joins, subqueries, and analytical functions) to perform data validation, data profiling, and backend troubleshooting. Proven expertise utilizing advanced systems modeling methodologies—including Unified Modeling Language (UML), Data Flow Diagrams (DFDs), and entity-relationship modeling—to conduct comprehensive As-Is/To-Be system state evaluations, perform technical gap analyses, and architect scalable, high-performance system workflows and technical specifications.