Lead Data Analyst for internal operations providing solutions for process automation, data integration, RPA, and business intelligence and reporting

Data Analyst | 2021 - 2022Participated in a Data Lake, Data Warehousing project as a where I used my subject matter expertise of our source systems to help inform the Data Engineers the shape of our data and the capabilities of our systems. Provided Entity Relationship Diagrams of our source systems to help with the creation of the Data Warehouse.Engaged in creating new workflows using PowerApps and Dataverse to support data collection and integration to better support our reporting capabilities and to increase information management across the company.Headed all reporting integration across multiple data sources to ensure current and agile dashboards to the executive team.Leaded cross departmental reporting requirements balancing multiple stakeholder interests to provide single product to better streamline discussion and decision making between departments.Headed process improvement for all internal departments including recruiting, security, accounting, finance and contracts administration.

Data Analyst | 2021 - 2021Headed new agile reporting using data visualization through Power BIProvided automated reports that enabled stakeholders in HR, Finance, Accounting, and the Executive to make accurate decisionsAutomated reporting using a combination of Odata connections to our ERP database and Dax calculations inside Power Bi, using Power Bi to automatically refresh on a schedule

Project Control Analyst | 2020 - 2021Responsible for all west coast project financials including projection of project costs, subcontractor costs, and reportingIn direct support of all Program Managers to assist in all financial analysis on their projects, ensuring consistency and accuracy throughout all west coast programsJAMIS Prime ERP administrator, responsible for ensuring that JAMIS is working as intended and following up with support if anything has problems, also provides direct assistance to employees when they have trouble with JAMIS. Responsible for the transition to 6.3, 6.4 and 7.0 versions of JAMISUpdated and maintained Excel model, COMPASS, to forecast and track actual and projected costs which included VBA updates and Power Query direct connections to databases, this increased reporting efficiency cutting down on hundreds of hours of bi-weekly workTrained replacement in two months from a predicted training plan of three months Contracts Administrator | 2019 - 2020Responsible for the design, construction, and maintenance of a centralized contracts database with intuitive UI resulting in a more streamlined data collection process and increase quality of life for employeesCoordinated subcontractor RFP process in the procurement of new work. Coordinating and reporting to government on all contractual obligations coordinating multiple prime contracts with many task orders and sub-contractorsAssisted in negotiations of Teaming Agreements, NDAs, Task Orders, on contracts of millions of dollars in fundingCoordinating and reporting to government on all contractual obligations coordinating multiple prime contracts with many task orders and subcontractors

Responsible for creating the Combined Daily Income Report for our four satellite gyms. This required reconciling financial reports and correcting mistakes to ensure accurate reporting. This is a vital step to ensure that all program areas are being funded correctly and also directly supports our general ledger upload. Streamlined workflow and created excel programs to improve data consistency and to save hours of routine work. These programs and workflows allowed me to quickly identify mistakes which led to saving over $50K in revenue. This resulted in me receiving the departmental STAR award.

Managed office, and coordinated the India and US teamsDirected marketing for client outreach, analyzed client data, and managed client accounts, accounts payable, and accounts receivable Headed project to determine an efficient timecard workflow resulting in greater productivity and increased earnings