michael summons
location ● Brooklyn, New York
phone ● (703)336-7525
email ● msummons76@gmail.com
website ● MichaelSummons.com
LinkedIn ● linkedin.com/in/michaelsummons
twitter ● twitter.com/msummons76
summary
Professional with 15 years of experience in data analysis and dashboard/reporting development specializing in Tableau, SQL, and Microsoft Excel (VBA)
skillset
- Data Analysis
- Data Visualization
- Extract-Transform-Load (ETL)
- Project Control
- Tableau Desktop
- Tableau Public
- Tableau Server
- Microsoft Office Suite
- Excel VBA
- Excel VLOOKUP
- Excel PIVOT TABLES
- Oracle PL/SQL
- Web Development
- JavaScript
- SharePoint
- HTML
- CSS
- Remote Working (WFH)
- Federal PPBE
- DoD Clearable (TS Previously held)
experience
mitre corporation ● mclean, virginia
sr. business intelligence developer 03/2016−11/2019
Drive convergence in data reporting by exploiting gold source data to develop enterprise-wide analytical tools that effectively and efficiently assess financial health, program delivery, staffing, hiring, and other critical issues in order to assist staff at all levels manage a yearly project spending budget of ~$2 billion
- This automation effort allowed Financial Analysts to perform their work more effectively and efficiently by removing the task of creating and maintaining spending reports
- This effort also provided consistent reporting at all levels of the organization
- Received a Corporate Officer′s Award in recognition of efforts to develop and implement reporting, analysis, and visualization capabilities to better inform decision makers
- These efforts directly contributed to MITRE′s selection to the prestigious InformationWeek Elite 100 list, which recognizes organizations that are the most innovative users of business technology in the country
Create complex queries in SQL to prepare data for visualization tools (Tableau, Cognos)
- This includes any ETL and normalization along with data integration from any Excel or Text (CSV) data sources
Encourage usage of Tableau desktop within the Corporate Finance group by establishing a Tableau User Community of Practice (CoP)
- Establish Governance (License Management / Gold Source Data / Publishing)
- Best Practices
- Information Sharing
- Tableau Help / Resources
- Received a Corporate Catalyst Award for expertise and efforts in assuming responsibility for the management and development of the Tableau work program within the Corporate Finance group
data analyst / project control 06/2004−02/2016
Perform business operations services across division and portfolio owned work to include knowledge sharing of corporate policies, procedures, business tools, and best practices to assist in both program control and project management
- Ensure projects are budgeted, funded, staffed, and executing according to Federal Project Planning, Budgeting, and Execution (PPBE) guidelines throughout the project lifecycle
- Create automated reporting in Excel, automated using a combination of VBA and pivot tables (Expenditure / FTE Delivery tracking)
- Perform regular analytical analysis (predictive and corrective analysis) to identify tasks that are under/overdelivering against project scope along with recommendations to bring projects back within scope
- Conduct quarterly financial reviews with Project Leads, Task Leads, and Directors to discuss program delivery status and identify projects requiring corrective actions
education
university of phoenix 2012
bachelor of science ● information technology
shawnee state university 2000
associate of applied science ● management information systems
Recognition
tableau public ● 2020 featured author