Providing affirmative action program (AAP) development, implementation, auditing, and training.

• Audited and revised a client’s financial model for forecasting cash flows and created a financial model for future company use • Created an integrated inventory tracking and planning system and a vehicle maintenance system • Created a Power BI dashboard, a user input model and key performance indicator reports for a driver training and transportation company

• Audited Fortune 500 companies for compliance with US labor laws, analyzed compensation data, personnel staffing records and Affirmative Action Plans• Conducted on-site reviews and interviewed Fortune 500 management and employees to audit compliance with labor laws • Audited large datasets for statistically significant disparities regarding employment decisions, missing data, and signs that data had been manually altered• Created databases by extracting data from unstructured datasets and generating databases for analysis• Improved databases by merging, cleaning, and analyzing large amounts of data using Power Query, VBA, and advanced Excel formulas• Created refreshable customized reports using Power Query and VBA for distribution and use of employees region-wide, decreasing manual tasks and increasing productivity• Drafted reports of investigative analyses and findings and gave oral presentations of the same • Negotiated and monitored data submissions and deadlines with opposing counsel• Trained employees from the entire region on advanced Microsoft Excel functionality, custom VBA macros which significantly reduced manual data management in Excel• Learned MS Excel programming language (VBA) and wrote macros to automate report creation• Learned MS Power Query and created a variety of queries to improve work processes

• Audited our program’s expenditures, locating and correcting overspending • Built a database to track expenditures and reconcile the University’s accounting records with the program’s expenses• Implemented budget by managing expenditures, and accounts payable and receivable• Managed compliance with government regulations and reporting requirements• Supervised employees, tutored students and planned activities

• Solicited and informed prospective clients of current loan rates and products through cold-calling and online leads• Managed underwriting documentation through final loan approval and closing

Provided mortgage closing services in Spanish and English, including explanation of the legal documents and notarization of signatures