Michael Phung Email & Phone Number

Wheat Ridge, CO, US

San Francisco, California, US

Aurora, Colorado, US

Supporting the university mission by driving results from surveys, behavioral data analysis, data analytics and reporting by utilizing analytic tools such as Tableau, SQL and ETL. Support and lead a team of data analysts to help manage projects and reporting requirements across multiple departments and stakeholders. Lead and support team skill growth and.

• work with cross-functional teams to prevent billing errors through validating up-front requirements and data accuracy of incoming requests for installs, renewals and disconnects
• Run frequent audits of the billing system to ensure 100% billing accuracy for customers
• Utilize Microsoft SQL Server, Excel, SSIS and SSRS for reporting, automation, and analysis

• Short term contract position
• Provide support to the Continuous Process Verification program for the commercial product line.
• Retrieval and compilation of in-process physical data and analytical testing results for further analysis and trending
• Manages the archival of documents for the department and interfaces with both company personnel for internal archives and external contractor for external archives
• Preparation of reports and supporting data using mainly MS Excel, and MS Word (Includes document writing, advanced formulas, pivot tables, charts, and creation databases)

New York, NY., US

• Support attorneys by preparing in depth and complex analysis for mediation and litigation based on state and federal employment laws
• Communicate and collaborate with other attorneys and analysts to determine data needs, determine plans of action and next steps for litigation
• Main VB developer on staff. Reviewed and edited current macros and created new macros to automate reporting more efficiently
• Use various tools to create reports and analysis (Formulas, pivot tables, and graphs in Excel, writing VBA to automate reports)

Pittsburgh, PA, US

• Supported Research Analyst group in making sound decisions related to data collection, data analysis, methodologies and design
• Conducted research to collect and assemble data – responsible for running queries and creating and developing requested reports for the client, Bank of America
• Used various tools to create reports and analysis (Formulas and pivot tables in Excel, writing VBA to automate reports, SQL and Sharepoint to pull data and run reports)

Denver, CO, US

• Created complex reports and spreadsheets with MS Excel utilizing complex formulas, pivot tables, and format tools.
• Used multiple databases and related queries for collecting and analyzing attrition data, student surveys and building complex metrics for student services
• Collaborated with project management team on implementation of initiatives
• Developed diverse ways to analyze retention data including forecasting and projecting attrition numbers by month and term, students academically at risk, and drop reason.
• Presented findings to executives and management, as well as participating in process improvements
• Worked with a student population of up to 250 to audit degrees, track performances, and advise/coach at-risk students to improve retention and performance

Master Of Science, Data Analytics

Bachelor Of Arts (B.A.), International Relations And Affairs