Francisco Ortiz, Acda, Ffm-Am, Dod Ccma Email & Phone Number

Alexandria, Virginia

Have participated in different audit engagements at the DoDIG, which include attestations, performance, and financial audits.2020: worked in three projects: OPM Agreed-Upon Procedures (AUPs) for Reviewing the FY 2020 Civilian Payroll Withholding Data and Enrollment Information, DoD Agency-Wide Basic Financial Statements for Fiscal Years September 30, 2020.

Alexandria, Virginia

In charge of updating the IDEA scripting programming each year for any changes necessary, like the retirement rates for agency contributions for FY 2020 or the Federal Employee Health Benefit rates changes that occur every year.In charge of updating the Excel lead sheets macro and templates for the AUPs procedures that are performed manually.Prepared the.

Alexandria, Virginia

Participated in the FY 2019 MRF oversight audit.Served as the Working Group member for the Military Retirement Fund (MRF) oversight audit and the DoD Agency Wide Financial Statements audit, to submit the deliverables by the required due date in the MRF project.Review every deliverable to ensure it complied with all requirements specified in the.

Alexandria, Virginia

Use professional judgment when documenting the results of analyses.Easily analyze big databases with IDEA.Prepare written assignments such as audit client walkthroughs, interview write-ups, data analyses, and other working papers in accordance with DoDIG procedures.Participate in meetings, briefings, interviews, and other oral communications to discuss.

Alexandria, Virginia

Helped in the FY 2017 and FY 2018 DoD Agency Wide Financial Statements Audit Project.Developed Excel VBA programming to streamline the extraction of data from the Un-Adjusted Trial Balance (UTB) to Adjusted Trial Balance (ATB) reconciliations and import it into IDEA.During the FY 2017 DoD Agency Wide Financial Statements Project, I processed information.

Puerto Rico

Work with raw data and organize it to make it understandableLook for relations, patterns and other hidden signs in dataCompare data from different tables by linking common fieldsData can be text, dates or numeric fieldsPrepare analytical reviews of financial accounts with ACLPerform Benford’s Law data analysis with ACLEvaluate construction contracts costs.

Cabo Rojo, San German, Yauco, Mayaguez Mall

In charge of the front end of the supermarketWork as Assistant Manager in charge of the whole storeSupervise directly over 100 employees and every department when their managers were not availableAssign duties to employees and prepare their working scheduleReview weekly financial reportsKeep payroll expense low by taking management decisions

Nice job for a college student. I had fun there. Laly, the owner was a sweet woman.