Gamal Gonzalez Perez Email & Phone Number

United States

United States

Proficient in Excel, MS Power Point, SQL, Tableau & PythonPerformed Case Study for a mock company.Obtained, combined and explored data for case study in Excel. Analyzed data by correlating data from different data sources and developing ad-hoc reports showcasing targeted segments of the data. Developed a profitability model with the goal of maximizing profits for the data provided.Prepared visual presentations of data projects via the use of PowerPoint presentations.Performed numerous SQL queries on a number of different databases. Queries performed varied from simple table queries to complex queries with the intent of obtaining statistical information from the data sources. Data sources ranged from single table query to multiple data table relationships within specified Schema.

Created over 4000 user profiles for Defense Counterintelligence Security Services (DCSA) formerly known as Defense security Services (DSS) in the government’s Defense Travel System (DTS) due to a governmental reorganization that shifted thousands of employees between governmental agencies. Conducted research for DCSA accounting department for obligations of Un-liquidated Obligations (ULO) and Negative Un-liquidated Obligations (NULO) reported in in DCSA Defense Agency Initiative (DAI). Coordinated with agency personnel for research resolution.Coordinated with DAI Customer Support team during the DSS/DCSA transition and implementation of the Defense Working Capital Fund.

Assisted the accounting team to validate the quarterly non-statistical samples of Undelivered Orders by ensuring all supporting documentation (Contracts, Purchase Requests, Military Interdepartmental Purchase Requests, Inter Agency Agreements as well as other supporting documentation based on resources within the USCG intranet) were reviewed for completeness and accuracy and compliant with applicable regulations. Conducted initial Fraud Risk Assessments over multiple USDA standard operating procedures (SOP) in order to identify areas in which fraud was most likely to occur. Discussed risk assessments thoroughly with USDA process owners and identified potential risk areas in payroll and government purchase cards SOPs. Published updated SOPs with the inclusion of safeguards against high/potential risk areas. Documented business processes/standard operating procedures (SOP) for the Us Air Force (USAF) for Civilian Payroll Assessable Unit (AU). Identified current internal controls within SOP and performed a risk assessment on each identified control throughout payroll process. Developed testing procedures for identified control based on control objectives in accordance with US GAAS and FIAR regulations. Acted as liaison between USAF AU personnel and auditor throughout FY testing phase of the audit.

Mclean, Virginia

PWC public sector became Guidehouse. See Guidehouse description

Performed a gap analysis on multiple US Coast Guard (USCG) SOPs by analyzing documentation of current states of SOPs and Finance Resource Management Manual. Developed Corrective Action Plans (CAP) for every identified gap found within USCG SOPs. Documented and updated Government Furnished Equipment and Heritage Assets SOPs from USCG and identified key and process controls by using a gap analysis and benchmarked common and known practices with other governmental and private industries. Assisted USCG Commandant CG-844 (Personal Property) inventory audit by validating supporting documentation of physical assets for completeness and accuracy. Assisted the performance improvement lead by providing guidance on financial regulations as issued by FASB as well as performing Root Cause Analysis for USCG self-identified weaknesses.

Performed a Qualitative Drill Down (QDD) for USAF Statement of Budgetary Resources (SBR) for transactions made in FY 2013. Developed sampling methodology for FY13 financial audit based on data exploration and analysis of QDD in accordance with FIAR guidance issued in 2013. Documented USAF SOP for the Mechanization of Contract Administration Services (MOCAS) and identified key and operating controls. Assisted Task Lead perform a root cause analysis in identified material weaknesses found during substantive training for FY13. Documented SOPs for a Research & Development audit conducted under regulation OMB A-133. Performed substantive testing for regulations on non-compliant transactions. Drafted Notice of Finding Recommendations (NFRs) for non-compliant transactions to OMB A-133. Performed audit services as part of the effort to identify Personal Service Contracts (PSC) and Inherently Governmental Functions (IGF). Efforts included: documenting business processes including contract award; contract administration and contract closeout.

Washington D.C. Metro Area

Analyzing banks statements and other financial data needed for the preparation of individual and business Federal and State income tax returns. Prepare and process on behalf clients: payrolls, State sales taxes forms and Employers quarterly tax forms as well as other administrative duties.

In charge of performing sales of light fixtures and electric materials by contacting clients over the phone or by visiting contractors at the projects sites, performed general, administrative and accounting duties such billing, collections and account receivable reconciliations, filling documents and made occasional deliveries of inventory to project sites.

At reservations, I was in charge for processing accurate detailed reservations to accommodate customers in the best possible manner. This task involved contacting travel agencies to arrange customers' reservations in satisfaction with customer needs based on rooms, rates, referrals and hotel availability. At Front desk, I was responsible for attending and processing guest check-in/out, sales, collections and providing general customer services in a professional courteous manner. Also, I provided administrative support managing hotels' mechanical and engineering shortcomings and petty cash management.

Data Analytics Immersion Program, Data Analytics

Ba, Business Administration; Accounting

Related Courses: Business, Ethics, Organizational Management, Database Management, Probabilities & Statistic, Basic Accounting, Cost.

Bachellor, Accounting