MICHAEL GORDON
Arlington,VA
Summary
Seasoned, goal-focused professional offering over 15 years' experience of problem-solving, critical thinking and advanced technical skills with data science, analytical and adaptable nature.
Overview
12
12
years of professional experience
Work History
Data Scientist
Novetta, LLC
McLean, VA
08.2021 - 12.2021
- Worked closely with Engineer Architects, Software Developers, and Data Scientist to create ingestion and visualization techniques that aid in understanding data
- Maintained awareness of state of art machine learning and techniques, methods and platforms, including commercial and open source
- Tested solutions on AWS using services such as EC2, S3, and Elastic Search
- Utilized various clustering techniques in Elastic Search to identify status of capabilities, requirements and contract cost
- Identified procedural areas of improvement by analyzing customer data to help ingest data and build data visualizations
- Built data flow and templates in Apache Nifi to ingest large amounts of data to be stored in Amazon Web Service (AWS) S3 buckets and converted to JSON, CSV, or SQL output files
- Developed approaches to cross-correlate data sources utilizing JSON code to research, query, transform and ensure data is consistent among data-sets and builds models and visualizations
- Served as data steward and liaison by identifying and documenting requirements, defining and refining performance objectives, metrics, data sources and analytics
- Assisted team with data gathering efforts, comprehensive data studies, and initiatives in order to develop information models, data forecasts, advanced and predictive analytics visualizations based on generally accepted statistical methods
- Created dashboards utilizing Lens, Canvas, and Workspaces within Kibana console which display time series, heat maps and various analytical visualizations.
- Provided comprehensive analysis and recommend solutions to address complex business problems and issues using data from internal and external sources and applied advanced analytical methods to assess factors impacting growth and profitability across product and service offerings
Resource Manager / Budget Analyst IV
Perspecta, Inc
McLean, VA
09.2019 - 07.2021
- Developed, reviewed, updated and maintained complex budget artifacts utilizing business intelligence tools and provide detailed analysis and recommendations regarding budgetary actions
- Evaluated procurement needs and projected expenditures
- Recommend financial solutions to Chief of Staffs and Senior Leadership based on detailed financial analysis
- Extract data queried from COGNOS, BASIS, and other ERP systems to create and maintain financial models
- Monitored and reported budgetary discrepancies to Senior Management to maximize reporting efficiency, apply performance measures, and finalized spending plans
- Planned and directed review, analysis, and formulation of policies and procedures for budget execution of organizational segments
- Represented front office in budget-related meetings with internal stakeholders at all levels of organizational segment and other outside entities
- Prepared recommendations on budget execution policy and developed analyses of impact on program offices and identify assets, shortfalls, cost trends and other crucial variances
- Developed budget and funding plans which allocated appropriate funds to activities based on analysis of budget estimates, management resource needs, and historical expenditures
- Analyzed and evaluated continual changes in program plans and funding and their effect on financial and budget program milestones
- Led budget development of or revision to Spend Plans exercise regarding budget execution activities applicable to all program offices
- Accomplishment(s):
- Identified cost saving initiatives of over $10 million in unliquidated and undelivered obligations for monthly and quarterly accrual analysis.
Senior Associate
Guidehouse, LLP
Washington, DC
07.2019 - 09.2019
- Provided support and assisted Office of Secretary of Defense (OSD) and Office of Under Secretary of Defense (OUSD) optimize audit readiness and audit remediation support
- Worked independently to develop crosswalk of internal controls mapped directly to major cloud service solutions SSAE/ SOC-1 reports
- Demonstrated knowledge of GAO FISCAM, OMB A_123, NIST 800-53 and SSAE/SOC-1 including how internal controls relate to financial statement audit
- Exercised oversight of subordinate command internal audit programs
- Coordinated audit remediation effort and developed corrective action plans
- Prepared cyclic status reports to OSD and OUSD
- Assisted with development and execution of annual audit plan.
Principal Accounting Consultant / Financial Specialist
Department of Defense
Washington, DC
01.2018 - 05.2019
- Provided support to Financial Improvement and Audit Readiness (FIAR) within Department of Defense (DoD); Prepared status reports on Notices of Finding and Recommendations (NFRs) and Corrective Action Plans (CAPs)
- Served as Senior Financial Specialist responsible for providing technical and procedural information, assistance, and guidance of Civilian Pay and operational programs
- Reviewed, analyzed, and evaluated actions to ensure compliance with GAO, OMB and DoD policies and proposes methods and best practices to increase efficiency and productivity
- Completed daily status of funds functions like budget line item tracking, payroll and wage allocations, budgeting, and all types of obligations and funding reconciliations
- Regularly prepared technical writings and editing of organizational policy and standard operating procedures in regard to audit readiness
- Performed quality control examinations of operations, procedures, and internal controls to prevent and detect deficiencies in operation of functional systems
- Provided instructions to peers and subordinates on areas of technical writing and editing dealing with internal audit
- Executed financial assurance audits and implemented new control points and metrics to support business changes
- Furnished requested financial data and reports to auditors, regulators and investors and prepared analysis to support risk management
- Developed queries and performed analysis to optimize business intelligence
- Created plans and communicated deadlines to ensure projects were completed on time
- Identified issues, analyzed information and provided solutions to problems
Senior Financial / Budget Analyst
Mary Washington Healthcare Center
Fredericksburg, VA
07.2017 - 01.2018
- Prepared operating budgets for over 150 medical facilities and three (3) major hospitals
- Assured integrity of financial and statistical data by reviewing general ledger entries, reports, schedules, worksheets, reconciliation and or other analysis
- Developed, implemented, and maintained program reporting tools for financial reporting of complex activities and management decisions
- Supported P&L management by monitoring and analyzing business operations
- Performed ad-hoc reporting and operational research and analysis in order to ensure financial viability
- Analyzed and queried financial data using Oracle Database, MySQL and MS Access to identify trends and performance metrics for communication to management
- Provided expert analytical, financial, accounting, and compliance support to department leadership while developing variable-sensitive business models and management tools
- Proactively identified opportunities and recommended options for increasing financial margins while preserving MWHC standards and minimizing financial risk
- Interpreted and implemented accounting rules, fiscal compliance, policies and regulations.
Business Intelligence Developer
Didlake, Inc
Manassas, VA
06.2015 - 02.2017
- Served as SME responsible for Enterprise Reporting and Analytics while providing oversight of reporting data used to generate reports summarizes business, financial, and economic data
- Directed consistency and standardization through end-to-end reporting solutions within organization while identifying and implementing opportunities to improve reporting efficiency
- Aggregated data to compile, organize and design financial analysis solutions, analyzed metadata to identify inefficiencies and opportunities to control expenses
- Provided technical support to other departments while serving as liaison for reporting, dashboards, and financial systems
- Provided assistance with annual audit and trend analysis
- Developed standard operating procedures for business intelligence tools, ad-hoc reports, dashboards, financial systems, and new software implement
- Developed and maintained business intelligence tools, dashboards and visualization systems utilizing OLAP connections, Power BI and PowerPivot which spearheaded consistency and standardization
- Accomplishment(s):
- Spearheaded special project that refined process and implemented new purchasing system which interfaced with accounting software
- Trained and transitioned functions to Purchasing and Quality Control group
- Discovered $750K error in financial reporting and irregularities with accounting system.
- Designed customized data collection models for specific visualization tasks
Senior Financial Analyst
Blue Cross Blue Shield
Durham, NC
07.2013 - 02.2015
- Coordinated and assisted with preparation of complex budgets for lines of business or departments based on actual performance, prior year budget figures, estimated revenue, expense reports and other factors
- Collaborated with Business Consultants to provide analytics of memberships, staffing, and trends across multiple regions and markets
- Enhanced revenue recognition modeling by line of business, incorporated quantitative figures for operations and supplied 24-month rolling forecasts
- Automated complex models to streamline processes and reduce turnaround from 30-45 days to less than 10 days
- Prepared Tableau visualizations with trend lines, moving averages or linear regression for Business Consultants to be used during presentations and calculate performance metrics
- Prepared complex financial plans, financial forecasts, profitability impacts, competitive analysis, and various reports to improve tracking of profitability
- Prepared complex financial and business related analysis and research in areas related to financial and expense performance, rate of return, and depreciation
- Responsible for complex monthly variance analysis at any business, segment, or consolidated company level and providing ongoing support to various lines of business as needed
- Accomplishment(s):
- Awarded cash bonus, multiple PROPS from various departments, and received salary increases.
Senior Financial / Budget Analyst
United States Federal Government
Washington, DC
03.2009 - 06.2013
- Populated SQL database tables with air traffic data and performed calculations that supported Finance and Performance Metrics group
- Prepared web scripts to post performance reports to Federal Aviation Administration website
- Developed trend analysis and complex Excel models with PowerPivot and data connections
- Validated key performance indicator (KPI) reports for accuracy
- Implemented Business Objects Web Intelligence to automate reporting of airline activities and staffing which was produced manually in MS Excel
- Queried, manipulated and joined large data sets utilizing SQL and MS Access tables and databases to develop comprehensive results for analysis and reporting
- Reviewed and interpreted laws, policies, and regulations pertinent to financial management to establish impact on budget and operations
- Responsible for formulation, development, and execution of budgets, financial plans, and multi-years programs required to properly fund and meet resource requirements at Peace Corps
- Provided budget management expertise, technical advice and guidance and leadership by performing broad and extensive range of budget management exercises
- Formulated, established and implemented budget management policies, instructions and procedures on all matters relating to programming, cost, funding, forecasting and status of funds
- Prepared financial status reports and execution briefs on various complex budgeting issues and present and explain execution and spend plan deviations to senior leadership team
- Accomplishment(s):
- Met monthly and quarterly budget goals, +/- 5% of target for two division budgets exceeding $60M
- Demonstrated self-starter abilities which resulted in cost savings initiative which enabled government to reduce contractor positions and saved over $200K
- Spearheaded implementation of new Business Objects Web Intelligence software system.
Education
Bachelor of Science - Business Administration
Morgan State University
Baltimore, MDMaster of Arts - Administrative Management
University System of Maryland, Bowie State University
Bowie, MDAssociates of Applied Science - undefined
Northern Virginia Community College
12.2022
Skills
Security Skills: intermediate user of intrusion-detection, Erecting firewalls, IDS/IPS, DLP, SIEM, vulnerability-scanning, Secure Web Gateway (SWG), OSI Model, TCP/IP Utilities, proxy appliances, malware and antivirus tools Tools include Wireshark, Nessus, NMap, Metasploit, Wireless Modems/Routers
Systems & Business Analytics Skills: Experience working in mixed Windows/Linux, Elastic Search and Kibana (ELK Stack), Apache Nifi, JIRA, Confluence, SQL, AWS Cloud Computing, PowerPivot, Power BI, Data Mining, Database Management, and virtualized servers
Software Development & Programming Skills: Knowledge of Python, Java, JSON, MySQL and MS SQL Server Tools include Anaconda, SPYDER, Jupyter, PyCharm, JGRASP, Notepad
Accounting & Budgeting: Data analytics and visualization, performance metrics, variance reporting, preparing budgets, evaluating capital projects, GAAP understanding, fiscal law understanding, trend forecasting, report writing ERP systems including Oracle Database, COGNOS, MS Access, Hyperion, Business Object Web Intelligence, & Advanced Excel
Additional Information
- Security Clearance , PROVIDED UPON REQUEST
Timeline
Data Scientist
Novetta, LLC
08.2021 - 12.2021
Resource Manager / Budget Analyst IV
Perspecta, Inc
09.2019 - 07.2021
Senior Associate
Guidehouse, LLP
07.2019 - 09.2019
Principal Accounting Consultant / Financial Specialist
Department of Defense
01.2018 - 05.2019
Senior Financial / Budget Analyst
Mary Washington Healthcare Center
07.2017 - 01.2018
Business Intelligence Developer
Didlake, Inc
06.2015 - 02.2017
Senior Financial Analyst
Blue Cross Blue Shield
07.2013 - 02.2015
Senior Financial / Budget Analyst
United States Federal Government
03.2009 - 06.2013
Bachelor of Science - Business Administration
Morgan State University
Master of Arts - Administrative Management
University System of Maryland, Bowie State University
Associates of Applied Science - undefined
Northern Virginia Community College