Mohammad Khalil Email & Phone Number

Albany, New York, United States

Project Management Team Member (Audit Projects) Managed Microsoft SQL Server, resolving database issues and developing tables, views, functions, and stored procedures to support audit requirements. Conducted complex data analyses using SQL for audit, operational, and investigative purposes, identifying trends and anomalies to enhance audit outcomes. Collaborated with tax audit teams to audit tax refunds, uncovering inconsistencies and fraud through detailed analysis and reporting. Produced daily, weekly, and monthly audit reports using Excel and Tableau, trained non-technical staff in SQL queries, and authored work papers based on audit findings. Internal Control Committee Member (State Database and Tableau Access):Conducted thorough analysis of employee access lists for state databases and Tableau, identifying unauthorized access and ensuring compliance with security protocols. Implemented corrective actions to revoke permissions, documented findings in detailed work papers, and utilized auditing tools and database management systems effectively.

United States

• Learned about open data and how to manipulate, analyze, and map open data.• Utilized tools and programs such as Microsoft Excel, Google Sheets, Slack, Google Drive, QGIS and collaborated on project-based teamwork with fellow CUNY Service Corps members, MBPO and BetaNYC staff.• Worked with external partners, North Brooklyn Parks Alliance and Jen Gutierrez Council District 34’s office to map civic structures in a project developed by BetaNYC in collaboration with these partners. • Conducted data analyses and created data visualizations in order to identify and communicate relevant trends and important patterns.• Presented a conclusive data story that details what was needed in the project, what was found, important patterns or observations, and the benefits of their projects to both our partners and to the wider NYC community.