Sykesville, Maryland, United States
• Collaborate with stakeholders from Event Coordinating, Fundraising, and Finance teams to clean and analyze data from past and present charity events • Identify opportunities for improvement and offer solutions the maximize efficiency and accuracy • Utilize data analytics tools such as Excel, Tableau, and Salesforce to support business units • Reconcile databases proactively and monitor for data quality issues • Partnered with Finance team to create an automation in Excel to filter data to track multi-year donations across the entire Eastern States region • Used VBA scripting to create a dashboard that reduced processing time by 70%
• Developed a VBA automation that cleans and analyzes data resulting in 3 new progress reports • Applied Excel macros, pivot tables, conditional formatting, and charts and graphs to analyze KPI data • Ad-hoc interpretation of all data models and visualizations • Optimized existing processes by providing technological solutions that eliminate human error • Managed the progress of projects and deliverables in JIRA
• Implemented an automation in Google Scripts that collects nationwide data into a report for Congress • Partnered with non-technical stakeholders to design interactive Word templates for government leases • Performed data analysis of over 3000 leases and interpreted trends and insights • Streamlined existing processes to eliminate redundancies • Documented standard operating procedures for all duties in this role
• Created a dashboard to analyze financial data that fully automated a manual operational workflow • Worked on a diverse team that responded to rapidly changing failures with strict time deadlines • Compiled and presented weekly, monthly, and quarterly reports • Trained the entire team on a new responsibility and continued to serve as a subject matter expert • Ensured all standard operating procedures adhered to compliance standards
• Worked on a specialized team to accurately place over 7000 multi-million dollar trades • Meticulously managed account updates for high-valued clients with millions of dollars in assets • Made recommendations for improvements to existing processes • Facilitated the transition and training of these specialized processes to my new team and role as Cash Management Analyst
• Reviewed reports and ensured correct transmission of paperwork to DMV • Resolved complex issues regarding legal titling of purchased vehicles