Data Analyst
CurrentπΉπ¬ππππ΅ππΌπππππ§π°πΈππ΅ Design and develop functional, user-friendly reports by writing efficient SQL queries and utilizing data from SharePoint lists, locally stored flat files, or data retrieved using API calls ensuring reports are both aesthetically pleasing and aligned with stakeholder requirements.π’ Collaborate closely with coworkers from various departments on joint projects, providing technical assistance and delivering necessary data and documents to support their initiatives and ensure project success.π΅ Spearheaded custom SQL Server solutions to rebuild and maintain large datasets locally, significantly improving data accessibility and performance for end-users by transforming otherwise fragmented and slow external data into efficient, locally stored tables.π’ Solve unconventional data requests by designing custom, formula-driven workflows in Excel, reducing turnaround time and enabling non-technical users to interact with complex datasets seamlessly.π΅ Develop customized VBA tools for special requests, such as to automate the transformation of financial data exports into state-mandated report templates, streamlining the process while maintaining accuracy and compliance with submission requirements.π’ Modified and maintained complex reports integrating data from two incompatible EHR systems during a major software transition, ensuring accuracy and compliance with state-mandated reporting requirements despite significant technical challenges.π΅ Played a role in two major software migrations, ensuring smooth transitions of critical data to new platforms by identifying potential challenges, validating migrated data, and providing ongoing support to maintain data integrity and continuity across systems.
