Data Analyst Security Clearance

Mikhail (Misha) Litvinov

College Park, MD ***** 917-***-**** *******.***********@*****.***

Current Security Clearance:

Public Trust lvl4: DHS

Public Trust lvl2: DOJ

SUMMARY

Experienced data analyst and senior consultant with over 5 years of experience supporting government programs. Skilled in reporting, process improvement, and data extraction, with expertise in VBA programming in Excel, SQL, and data visualization tools such as Tableau. Proven track record of improving reporting capabilities, developing financial models, and analyzing data to support strategic decisions. Seeking to leverage my expertise in data management and reporting as a Reporting Consultant on a long-term government contract.

EXPERIENCE

Data Analyst

Inalab Consulting 01/2024 - Present

Led financial reporting efforts for the Office of Data Analytics at ICE, including the preparation of key financial reports such as Status of Funds, Gains and Losses, and Overtime Reports.

Improved reporting capabilities by developing and maintaining dynamic dashboards using Tableau, enhancing decision-making for financial management.

Utilized Python and VBA programming to automate and optimize data extraction and reporting processes, improving efficiency and accuracy.

Played a pivotal role in quality control and the development of job aids and guides to standardize reporting processes across the team.

Senior Consultant

Guidehouse 10/2020 - 06/2023

Managed the reporting function for ICE, developing financial reports and forecasts using Oracle Database and the BASS platform to support federal budget planning.

Designed and delivered Excel-based financial models and reports to track budget performance and reprogramming.

Wrote SQL queries to extract and manipulate financial data, providing actionable insights to support strategic decision-making.

Led the development of position management and attrition models to optimize budget and resource allocation across government programs.

Data Analyst

Avanza 08/2016 - 10/2020

Supported the Business Management Office (BMO) at ICE by creating regression models and financial reports using Oracle Database and Tableau, improving budget oversight.

Developed a segmentation model to forecast time to fill positions, directly informing financial planning and workforce management.

Wrote SQL queries to pull and aggregate data from various sources, ensuring accurate and timely reporting of financial performance.

Data Analyst

Capital One 12/2014 - 01/2016

Managed and analyzed monthly financial reports using Excel and SQL, providing insights into financial performance to support budgeting and financial analysis efforts.

Created pivot tables and automated reports in Excel, significantly improving report generation time and accuracy.

Data Analyst Consultant

William P Ciofi Engineering 02/2014 - 04/2014

Developed multivariate regression models for a U.S. Army task order, providing insights to support financial decision-making and resource allocation.

Data Analyst (Contractor)

ReNewJerseyStronger 07/2013 - 12/2013

Managed financial data for over 4,000 applicants, performing statistical analysis to predict program success and inform financial decisions.

EDUCATION

Master of Science in Mathematics 12/2012

Wilkes University, Wilkes-Barre, PA

Relevant coursework: Probability and Statistics, Statistical Methodology, Combinatorics and Graph Theory, Abstract Algebra

Bachelor of Science in Mathematics, Concentration in Statistics 12/2010

Bloomsburg University, Bloomsburg, PA

Relevant coursework: Probability and Statistics, Design and Analysis of Experiments, Linear Regression, Statistical Programming

SKILLS & ABILITIES

Programming & Software: VBA, SQL, Microsoft Excel (Advanced), Tableau, Oracle Database (BASS platform), SPSS, SAS, R

Key Competencies: Data Analysis, Budget Reporting, Regression Modeling, Process Improvement, Financial Forecasting, SQL Query Writing, Data Extraction

Security Clearance: Eligible for Public Trust clearance

Languages: Russian (Fluent)

Additional Skills: Strong written and oral communication, attention to detail, ability to manage multiple tasks under tight deadlines

PERSONAL INTERESTS

Competitive Runner: Completed 2 half-marathons and a full marathon

Contact this candidate