Michael C. Email & Phone Number

Hong Kong

Norwell, Massachusetts, United States

• Automated ad-hoc requests for senior directors and executives by using SQL queries, enhancing data accessibility and process efficiency for sales and orders data.• Transformed financial reporting by developing SQL-based live data reports for invoicing, purchase orders, labor hours, overhead costs, over/under billing, and recognized revenue; built an interactive dashboard using Q360 OneDashboard, eliminating manual data processing and providing the finance team with real-time visibility into financial operations.• Developed live data report to compare estimated vs. actual project costs and hours, using SQL to extract and join data from multiple sources, resulting in improved accuracy in financial analysis and more effective project budgeting decisions.• Implemented a SQL history trigger to automatically track changes in gross margin percentage, enhancing oversight over product profitability; alerted the finance team of any variations in real-time to ensure timely decision-making.• Enhanced operational processes for financial planning and business forecasting by developing forecasting worksheets using Microsoft Report Builder and SQL.

Smithfield, Rhode Island, United States

• Tracked alumni events on and off campus by logging events and participants into the Ellucian CRM system.• Ensured the Office of Alumni Engagement maintained accurate contact information by promptly checking and updating records whenever alumni submitted event registration forms, provided new details via email, or contacted the office with changes.• Developed and designed interactive Tableau dashboards to visualize alumni endowment data across various countries and regions, enhancing the team’s ability to identify key insights and make data-driven decisions for targeted engagement strategies.

Bachelor Of Science In Business Administration, Information Systems & Applied Analytics

High School Diploma

Education record