Year 1
Led and supported a financial division project within the Army during the first year
· Revamped Excel financial workbooks into more effective financial models. Increasing productivity by 80% utilizing.
· Created new dashboards, improving the financial director’s ability to track department performance metrics.
· Analyzed and transformed large amounts of data into several Power BI dashboards for different departments.
· Coordinated with staff, auditing documents within compliance with federal regulations.
Year 2
Advanced to support 2 financial divisions at the Pentagon
· Created, improved, and maintained both Tableau and Power BI dashboards.
· Consulted budget manager's execution, administrative tasks monitoring obligations, and actual expenditures such as allotments and unliquidated funds.
· Supported divisions with data analysis and recommended new systems and solutions to improve business processes.
Consultant for Bank of America and EY (Ernst & Young)
· Utilized SQL to retrieve data from a database.
· Generated corrective action plans resolving data corruption and mapping data between programs.
· Proposed changes and data quality recommendations to support the data governance efforts in compliance with the Federal Reserve Business Requirements policies.
· Provided technical expertise in support of analyzing data within Excel.
· Evaluated corrupted data with client loans worth over $1.500,000.