Joshua Ye

Master's

Operations Research

MIT Lincoln Laboratory

Power BI & SQL Server Analyst - Co-Op Student

- Designed and developed an Executive Vulnerability Report in Power BI, leveraging Data Analysis Expressions (DAX) to deliver dynamic and interactive insights. - Built and maintained Power BI dataflows and semantic models to unify data sources, ensure consistency, and streamline integration processes. - Developed SQL pipelines to facilitate server migrations, merge complex datasets, and create views and stored procedures, improving database performance and query efficiency. - Created detailed visual workflow diagrams in Visio, mapping data retrieval via REST APIs, automating integration with ZappySys SSIS, and optimizing SQL Server processing into Power BI for report generation. - Developed a Python application to extract tabular data from Microsoft Word documents, identify special patterns, detect editorial errors, and convert the data into structured formats, enabling integration with SQL databases and supporting machine learning and advanced analytics initiatives.