Accounting Marine Corps

Frank Gastelum

PERMANENT ADDRESS:

***** ****** **** ** *

Valley Center CA 92082

Phone Number: 760-***-****

EMAIL ADDRESS: ********@*****.***

EXPERIENCE (Retired):

*/**** ** */****, Resource Evaluation Analyst, MCTSSA Comptroller Applied professional knowledge of management controls and resource evaluation analysis. I provided internal controls and reasonable assurance of: effectiveness and efficiency of operations, reliability of financial reporting, safeguarding of assets, the reliability and integrity of information, and compliance with policies/procedures/laws/regulations. I provided risk assessments and monitoring of MCTSSA's operations that mitigated vulnerability risks. Maintained a secret security clearance with the Federal Government.

3/2012 to 1/2014, Supervisory Systems Accountant, MCTSSA Comptroller

As a Managerial Accounting Officer (MAO), I was responsible for supervising two Marines and four civilians. The Accounting section is comprised of two parts, Accounting and Payroll. Accounting is staffed by two Marines, the Fiscal Clerk and the Fiscal Chief. Payroll is staffed by one civilian, which is a Financial Management Specialist. The remainder of Accounting is staffed by three civilians. One is a Financial Technician and two are Financial Management Specialists. I was responsible for the following: invoicing for service contracts, payment of FEDEX invoices, purchase requests financial approver for invoices, end of year daily reporting on status of year end buys, time/attendance and payroll review, review daily transactions, and most time and effort is spent mentoring, supervising, reviewing and correcting deliverables from the accounting personnel. Maintained a secret security clearance with the Federal Government.

9/2008 to 3/2012, Systems Accountant, MCTSSA Comptroller

Applied professional knowledge of accounting policies and procedures as well as my systems/computer knowledge to support/assist with financial matters of the Marine Corps (specifically organizational components under the MCTSSA MARCORSYSCOM authority). I served as MCTSSA’s technical expert in financial management systems design and analysis. Responsible for identifying system requirements; and implementing and integrating new systems or releases with existing systems. Responsible for systems support, maintenance and training. Responsible for responding to trouble calls with financial systems. I provided analysis and advice on accounting programs, financial systems, and business operations. Provided civilian labor system support to MCTSSA and coordinates system requirements with higher headquarters. Provided accounting system problem liaison and resolution support. Performed accounting and budget systems security support (maintenance of user profiles and access). Provided financial management information and content to the MCTSSA MS SharePoint sub-site 'Comptroller'. I was MS SharePoint administrator for the sub-site 'Comptroller, which included content management and financial processes. Maintained a secret security clearance with the Federal Government.

9/2007 to 9/2008, Accounting Financial Analyst, MCIWEST Comptroller Applied professional knowledge of accounting policies and procedures as well as my systems/computer knowledge to support/assist with financial matters of the Marine Corps (specifically organizational components under the Marine Corps Installation West authority). I was responsible for resolving procedural problems relating to input and output for the Marine Corps accounting system SABRS (Standard Accounting Budget and Reporting System) and subsystems. The problem resolution process is conducted via a problem reporting system that entails data gathering from various sources (system and personnel). This data gathering is necessary to determine the description and resolution of problems reported from our customers and/or system generated problems. At the Marine Corps regional level, I functioned as a liaison with Headquarters Marine Corps, Marine Forces Pacific and DFAS in resolving matters pertaining to the coordination and implementation of accounting procedures. In addition, I was responsible for advising, coordinating, and assisting with the implementation of new/changed accounting policies/procedures prescribed by higher headquarters and/or DFAS. I managed and administered the Marine Corps Installation West Comptroller’s homepage (Microsoft SharePoint). This systems support requires data gathering and publishing of accounting/financial information to the webpage/intranet. In addition, I provided PC and systems support to the personnel of the Comptroller Department. Systems support includes security of user accounts, PC usage and shared services (i.e. network printers, network scanners, and local intranet).

10/2006 to 09/2007, Systems Accountant, DFAS San Diego

Applied professional knowledge of accounting policies and procedures as well as my systems/computer knowledge to the different special projects that present themselves. I was responsible for special projects for the Accounting Business Line supporting Navy customers world wide. This includes any project or data call that headquarters assigns to the San Diego site. I served on a team assigned to coordinate Base Realignment and Closure (BRAC) transition of workload from DFAS San Diego to DFAS Cleveland. This project required extensive knowledge of both General Funds and Navy Working Capital Funds systems/applications. On this project I developed electronic documents to aide in gathering information of applications, systems, and functions from DFAS San Diego to DFAS Cleveland. I served as a team leader in weekly BRAC Transition meetings. In addition, I was part of a project 'document imaging' that was implementing a disbursement voucher scanning/retrieval imaging system known as Voucher Access System (VAS). I was responsible for hardware/software installation, user training, scanner process procedures, and systems administration. I was a Systems Analyst for Finance systems (FRS, DRO, and IPAC). I was responsible for Unisys system Job Batch processing of input files and on-line data entry to Finance systems. This systems support also required the distribution of report output to local users. In addition, I provided PC and systems support to the local users of the Finance systems. Systems support included security of user accounts and user system change requesst for the Finance systems.

06/2005 to 10/2006, Systems Accountant, DFAS San Diego

Performed General Ledger Accounting and Systems tasks. Consolidated DWAS Interface file processes for NAVFAC Southwest and Northwest. Provided systems support in the implementation of new feeder systems to DWAS. Migrated and assumed NAVFAC Southwest systems workload form DFAS Oakland. My experience included working with PC, Mid-Tier and mainframe systems of all types. I have worked intricately with Comptroller personnel at NAVFAC Southwest in DWAS file and interface processing on a UNIX environment. I maintained UNIX user accounts and access to the accounting system (DWAS). I processed Billing cycles that required the distribution of electronic files and hard copy financial reports. Processed DWAS Interface file jobs; troubleshot DWAS Interface file processing errors; and, provided daily statistical spreadsheets of DWAS Interface file processing results to NAVFAC Southwest Comptroller personnel. Routinely reconciled General Ledgers to Subsidiary Ledgers. Prepared Journal Vouchers in accordance with DFAS directives. Researched and corrected abnormal trail balances. Performed month-end tasks/requirements: balanced Trial Balances with customer, prepared numerous Trial Balance worksheets, prepared data submissions of DONIBIS/DDRS, and prepared Financial Exhibits. Provided DWAS security support for internal and external customers: password resets, account unlocks, account creations, and account group assignments (DWAS accounting roles). Submitted Remedy tickets (for DFAS and NAVFAC Southwest) to resolve DWAS accounting problems (system and user error).

01/2002 to 06/2005, Information Technology Specialist, DFAS San Diego

Gained a great deal of knowledge with computers and earned one computer certification. Provided a formal Monarch software training course to customer (NADEP Jacksonville).

Gained confidence and ease when talking at conferences and in a training environment. Had input into policy matters. Demonstrated my supervision capabilities. Made the command more efficient by automating tasks. Provided routine OLRV and Monarch training to the command.

Implemented RightFax (Fax automation) and provided training for the command. Graduated from a CISCO Networking Academy. Earned a Novell Administration Certification. Team member in many command reorganizations that required PC moves/configurations. I gained extensive experience in workstation configuration and operating systems including Windows 3.1, NT and 2000. I developed workstation configurations and instructions for setup and installation. This required a thorough knowledge of software used on-site as well as the operating system of the new workstation. I installed software automatically via login scripts. I restored files, and scheduled back-up jobs, which required knowledge of ARCServe. In troubleshooting and resolving workstation and network problems, I used knowledge of the network and organizational configuration as well as the ins and outs of workstations and software. I was an Exchange, Active Directory and Novell NetWare administrator, which dealt with understanding the organizational structure and applying knowledge of the rules for each application, how they differ and how they interact. I have taken college courses outside of work to develop my own knowledge and my professional certificates were a result of these courses. I have trained users on various software and hardware products including Microsoft Office suites 95 and 97, Windows 3.1, NT, 2000 as well as Novell NetWare and Monarch (data mining software). Generally, I have provided training to the employees anytime a change of software or need is identified. I have attended various Enterprise Local Area Network (ELAN), Online Report Viewer (OLRV) and information technology related conferences. Traveled to a Navy installation and provided user training on the use of Monarch software. I coordinated and attended meetings regarding current IT policy and procedures, and propose changes and resolutions. I frequently recommended problem resolutions to managers and implemented those that have been adopted. With my knowledge of the accounting systems in use, I was able to advise the Local Area Network (LAN) Support Team (LST) on how implementations of software or network changes will affect the operational side. I have served as Acting Local Area Network (LAN) Support Team (LST) Lead and as Acting Systems Management Office Head. This made me responsible for work assignments and coordination for up to 16 employees including programmers, analysts, computer specialists and contractors. I have served as team lead for several special projects including RightFax implementation, and Monarch data mining. My involvement with the RightFax implementation required me to lead a group of 10 people from different areas to gather information and centralize it. We used the information to streamline manual process (paper to email receipt/delivery). My involvement with the Monarch data mining required me to analyze the information given to me by the accountants, and identify softcopy reports with data to be extracted via Microsoft Office products vice manual input. These tasks were so efficient that I was given awards for my work. Familiar with several IBM and UNISYS mainframe applications and their interfaces. I have experience with several mainframes, desktops, mid-tier systems, and WAN devices (routers, firewalls, and switches). Through my different work assignments I have functional knowledge of various types of governmental accounting and their systems such as working capital/DIFMS and DWAS, general funds/STARS-FL and OneBillPay. This knowledge allowed me to effectively identify areas that may be impacted by telecommunications, mainframe or ELAN changes.

05/1995 to 01/2002, Accounting Financial Systems Analyst, DFAS San Diego

Converted Navy legacy accounting system (NIFMS) to the migratory accounting system DIFMS (to include data mapping). Trained accounting/financial personnel on the use of microcomputer utilities. As a Configuration Control Board member, provided accounting system changes. Administered an on-line report distribution system/server. Implemented an on-line report distribution system/server which resulted in monthly cost savings of $50,000 in the elimination of paper/microfiche.

09/1992 to 05/1995, Computer Specialist, MCB Camp Pendleton

Processed accounting data/files jobs via Computer Associates 7/11 Scheduling software (on an IBM mainframe computer). Troubleshot/resolved abnormal termination of accounting data/file jobs via IBM JCL system software (on an IBM mainframe computer). Developed and wrote accounting reports/programs via IBM COBOL software (on an IBM mainframe computer). Coordinated and established data/file feeder system interfaces to a Marine Corps accounting system (SABRS). Published monthly accounting system processing and General Ledger close-out schedules for the Marine Corps.

08/1986 to 09/1992, Accounting Systems Analyst, MCB Camp Pendleton

Maintained approximately 100 database tables for Marine Corps accounting system SABRS. Submitted accounting system change requests to the Marine Corps regional data processing project office. Installed microcomputers (to approximately 100 users) in the Marine Corps Base Comptroller department. Prepared and submitted Abbreviated Decision Papers for purchasing data processing hardware and software. Instructed/trained Marine Corps Base Comptroller department personnel on the use of microcomputer hardware and software. Developed microcomputer spreadsheets and databases for Marine Corps Comptroller department personnel. Converted Marine Corps legacy accounting system (PRIME) to the migratory accounting system SABRS (to include data mapping).

08/1982 to 7/1986, Lead Payroll Clerk, MCB Camp Pendleton

Maintained (pay entitlements) approximately 300 payroll accounts on an automated Marine Corps payroll system. Inputted bi-weekly pay adjustments and balanced payroll accounts (on exception basis). Resolved individual employees pay discrepancies with both employee and supervisor.

EDUCATION:

San Diego State University, San Diego CA, No Degree, Finance, GPA: 2.56, 1991

Relevant Coursework:

1Federal Income Tax 410, 4 Semester Hours, 1987

2Managerial Cost Accounting 312, 4 Semester Hours, 1982

3Intermediate Accounting 310, 4 Semester Hours, 1982

Mira Costa College, Oceanside CA, Associates of Arts, Accounting, GPA: 3.2, 1980

Relevant Coursework:

4Fundamentals of Accounting 101, 3 Semester Hours, 1977

5Fundamentals of Accounting 102, 3 Semester Hours, 1978

6Business Law 101, 3 Semester Hours, 1978

7Business Law 102, 3 Semester Hours, 1979

PROFESSIONAL TRAINING:

Defense Acquisition University, San Diego, 2009-2010 Introduction to Access 2003, 2005.

Intermediate Access 2003, 2005.

Advanced Access 2003, 2005.

The Federal Budget Process MC-5090, 2005. Prompt Payment Act and Voucher Examination MC-5136, 2005.

Appropriations Law Seminar MC-5111, 2005.

Linux Fundamentals 3036, 2005.

Cisco Networking Academy Program, 2001.

LICENSES AND CERTIFICATIONS:

Certified Novell Administrator, 2003 Defense Acquisition Workforce Certified Level II, 2010

HONORS, AWARDS, AND SPECIAL ACCOMPLISHMENTS:

Group Cash Award, Sep 2010 Individual Cash Award, Sep 2008

Special Act Award (BRAC Support for DFAS San Diego), Sep 2007

Special Act Award (Development and Testing of Direct Feed Reporting), Oct 2006

Individual Cash Award, 2006

Special Act Award (Collected systems data required for BRAC preparation), Dec 2005 Special Act Award (PWC SD workload transfer from DFAS OK to DFAS SD), Oct 2005 Individual Cash Award, 2005 Group Cash Award, 2005

REFERENCES:

Darrel Fulmore 760-***-**** Personal Reference

Avon Teague 760-***-**** Professional Reference

Chris Musel 760-***-**** Professional Reference

Karen Rielly 760-***-**** Professional Reference

Monique Gastelum 760-***-**** Personal Reference

Contact this candidate