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 and September 30, 2019 - Tier 3/4 Support (Tier 3/4), and Oversight of the Audit of the FY 2020 Military Retirement Fund (MRF) Financial Statements.Also participated in the FY 2017 to FY 2019 AUPs attestation engagements.Developed IDEA Scripts that makes it possible to run the complete AUPs project and get the results in a couple of hours. The programming to complete the AUPs project through IDEA is prepared in a way that any auditor with basic IDEA knowledge can complete the technical data processes of the project.Developed Excel Visual Basic for Applications (VBA) programming to complete the AUPs project in a way that any auditor without advanced Excel knowledge can automatically process the final spreadsheets with macros, format them with all the formulas, tables and colors, and analyze the results. This process was something that could take days or even weeks. Now it is completed in minutes.Developed several methodologies for any auditor to perform all the steps required to conduct the AUPs project in its entirety. The methodologies include how to prepare the data files and the directory structure of the AUPs IDEA project subfolders, how to run an Excel macro, by using the VBA Editor or just by simply clicking a button on a simplified Excel macro enabled document, how to run individual IDEA scripts by using the IDEA Script editor or by just clicking a button, and another to complete all the AUPs Procedures.

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 announcement package for the FY 2019 and FY 2020 AUPs Project.Developed the Audit/Attestation Guide for the FY 2018 and FY 2019 AUPs project.Prepared the slides and conducted the Entrance Conference for the Department of Veterans Affairs (VA) during the FY 2018 and FY 2019 AUPs project.Wrote several sections of the FY 2018 AUPs audit report.Coached two additional auditors to run the AUPs project completely using IDEA and Excel. AUPs Program Manager and I expect both of them to run the project during FY 2020.Also participated in the FY 2018 and FY 2019 Tier 3/4 Support audits.Identified the Defense Civilian Payroll System (DCPS) fields necessary to query the civilian pay information for the tests to be performed during the FY 2018 to FY 2020 Tier 3/4 audit.Developed the methodology to process the payroll data of all civilian DoD employees, and filtered the employees to select a judgmental sample for the FY 2018 Tier 3/4 audit.Developed the audit tests to perform to the samples for the FY 2018 Tier 3/4 audit.Wrote 7 out of 10 Notice of Finding and Recommendations (NFRs) for the FY 2018 Tier 3/4 audit. Four of the 7 were new NFRs based on the tests I performed to the samples, and three were reissued from the previous audit.

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 communication letter of the MRF. Was responsible for ensuring the deliverables complied with applicable auditing standards or other criteria.Received an award as part of the FY 2019 Agency Wide Financial Statements Audit Working Group: Organizational Improvement Award of the Quarter, First Quarter, FY 2020.Participated in the TI-97 Cash Management Report (CMR) audit. Developed methodology in IDEA to analyze 100% of the records of the CMR resulting in a finding of $11 billion of transactions that used unidentified limits.Created the working paper in the CMR project with the unidentified limits analysis that was the backbone of the CMR audit report.Received an award for that audit report: FY 2018 Financial Management Report of the Third Quarter.

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 project work performed and to explain project conclusions.Complete time sheets and other administrative tasks accurately, in a timely manner, and in accordance with required procedures.Take training and make annual training plans in agreement with the Project Manager.Take mandatory and other scheduled training in accordance with prescribed requirements and by the required dates.Working to complete the Federal Financial Management Certificate Program (FFMCP) Performance Auditing Master Track from Management Concepts.Acted as sponsor for two team member, helping them with all the on-boarding process.Coached multiple auditors on audit topics, Excel, Word, PDF advanced manipulation, and IDEA data analysis.Coach the 2019 Financial Management and Reporting (FMR) FP Division intern on the work assigned by the Team Leader.

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 from more than 30 DoD entities with over 1.7 million rows of data and transferred them from multiple Excel spreadsheets into IDEA, because Excel cannot handle that amount of data. I performed all the analyses the Agency Wide audit team needed in a timely manner. Since I had already most of the programming to work with the UTB to ATB Excel files, I modified it to be able to import into IDEA and analyze the DoD Agency Wide FY 2018 files, in case that audit team needed the same analysis. In FY 2018, when the Agency Wide audit team asked for the same analysis, I was able to process data from more than 40 DoD entities with over 3.6 million rows of data, and transfer them from Excel spreadsheets into IDEA, and prepared the same analyses in less than an hour.Plan, organize, and prioritize assigned tasks.Develop estimates of time frames to complete assigned tasks.Research applicable laws, directives, regulations, manuals, prior studies, and audit reports to gain knowledge and understanding of projects.Have knowledge of Teammate Audit Management Software and been using it since 2004.Have knowledge of Generally Accepted Government Auditing Standards (GAGAS) and the DoDIG Audit Handbook.Perform work to develop and support findings that accurately report conditions, criteria, causes, and effects.Completed multiple working papers within the established time frames.

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 and billing proceduresMake written findings and propose recommendationsInvestigate fraud, waste and abuseResponsible for auditing Puerto Rico's municipalitiesInterview people as necessaryPerform audit work and register everything in TeamMate Audit Management softwarePrepare presentations about ACL for coworkers and external professionalsI am very good at speaking in front of groups and making formal presentationsI have done audit work of the following:Cash, accounts receivable, property and equipmentRevenues; purchase process accounts payable, disbursementsConstruction contracts, professional services contracts;Human Resources; ordinances and resolutions; State and Federal programsComputers: I have been a PC auditor in many audit engagements since 2002.I discovered and investigated a fraud against one municipality that resulted in the recovery of $1,000,000. I developed ACL programming that helped in the reduction of time of some processes from hours to seconds. With ACL I can compare the checks cleared by banks with the checks registered in an accounting system and I can detect which transactions were manually processed and never registered. With that I have discovered thousands of checks not registered in accounting systems.Knowledge of TeamMate Audit Management software. I can document everything I see and find in audit engagements by narrative documents and formal findings reports. When fraud, waste or abuse is discovered, I have prepared digital flowcharts by images to be able to explain the schemes to the Office of the Comptroller's supervisors and the Department of Justice Officials.

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.