Summary of Qualifications:

• I have 7 years' experience performing finance and accounting task within the Public and Private sector.
• The area of experience, management and payment of A/P and the Internal Control of project finances allocated for Infrastructure Rebuilding Projects with-in the Public Sector DOD . In the private sector, the processing of weekly Payroll, Accounts Receivable, and producing weekly Finance Reports, relative to the reconciliation of the weekly transactions. Inventory control, forecasting per SKU stock keeping unit with exponential smoothing models, calculating reorder points per EOQ Economic Orders of Quantities and Min and Max models as well as using Normal Distribution probability to calculate safety stock levels as well as service levels. The use of Microsoft Excel VBA/MACRO automated Spreadsheets, to conduct analysis and research. The use of Microsoft Excel Analysis Tool Pace and Excel functions such as SUMIF, AVGIF, LINEST, TREND, Boolean IF statements, NORMDIST, NORMINV, NORMSINV, AVG, Pivot Tables, VLookUp as well as VBA to program Active X controls and Excel objects on forms, in order to automate inventory control task as well as other related automation task related to Financial and Accounting research.
• AIPB Bookkeeper Course CPE passed Payroll 1 and 2, Mastering Adjusting Entries, Mastering Correcting Accounting Errors, Mastering Depreciation, Mastering Inventory, Mastering Credit Collections Business to Business, Mastering Internal Control Fraud and Prevention and Mastering Statement of Cash Flow Analysis. QuickBooks Pro Advisor Certified: Desktop and Online.

Skills Include:

Accounting/Finance Manager

Civil Information Management Chief

I have passed the exam for Advanced Civil Information Management, Project Manager and Project Payment Officer for the USAR. As CIM Chief my tasks include the Collection, Collation, Processing, Analysis, Production and Dissemination of data complied into information. This information is used to conducted trend analysis via measures of effectiveness and measures of performance that relate to various reconstruction projects as well as Civil Affairs missions conducted in order to manage or assist in the managing of a given country's government. Proprietary software is used to process the data but Microsoft Excel is used to conduct trend analysis via Excels ATP Analysis Tool Pack and other statistical functions within the Excel environment. Pivot Table as well as Pivot Charts are used to graphically portrait trend analysis. Dashboards are also created to consolidate and manage data within the Excel environment.

Confidential

I have taken and passed the H R Block California Income Tax Course for State and Federal Tax Returns. I prepared 1040ez, 1040A and 1040 tax forms for clients. I interviewed clients and discerned their financial situation as it relates to tax filings. I prepared the primary form 1040 for itemized tax returns and the applicable Schedules such as A,B,C,D,E,F,G,H and R. I researched adjustments to Gross income. I researched adjustments to tax liability per applicable credits. I ultimately filed the tax return for the client. Provided audit of past tax returns for client via the H R Block Look Back product of which I reviewed a client's past tax returns in order to find mistakes as well to see if the tax return could be prepared with a higher tax return.

Inventory Control Manager Energy Suspension

The task that I performed on a daily basis consisted of using M3 ERP system for gathering metrics for automated Excel Spread Sheets VBA Macros/Excel Functions that Calculated Safety Stock, Minimum and Maximum Inventory levels per SKU, Reorder Points and forecasted demand per SKU. I designed Spread Sheets that calculated EOQ Economic Order of Quantities , Probabilities of Service level satisfaction by using normal distribution probability analysis. Inventory auditing using Cycle Counting for SKU's as it relates to their stratospheric use in terms of sales i.e. ABC per Pareto's Model 20 of products produce 80 of sales thus focusing inventory analysis and accuracy on these SKU's to increase productivity. I Attended, weekly meetings with Vice President in order to brief on the progress of the project of building the new inventory system.

Confidential

Finance Department

Task included filling of Veterans Bene-Travel Payments, calling Veterans for their payments inquiries, sorting and distributions of office mail, filing and organizing the file room along with basic office support, assisting the Program Analyst with the auditing of documents for the licensing of providers. Assisting the Budget Technician in notating descriptions from the Field Service Receipts for a General Post Fund Reconciliation Audit. Assisting in Internal Audit which entailed reconciling vouchers to SF 1129 forms, pulling documents, correlating and coping vouchers for transfers between appropriations all in preparation for the audit team.

Finance Manager

Confidential

The tasks that I performed weekly were calculating payroll, Reconciling weekly transactions, Updating Aging Report, Updating Point of Sale Report, Billing for Corporate Accounts, Auditing Financial Reports relative to productivity such as weekly cash out report, weekly summary report, Batch reports, Journal entries report and Posting to Account Receivables Ledger on Oracle E- Business Suite database.

Confidential

I trained and passed the Series 7 exam and 63. I engaged in marketing training. Performed numerous cold calls per day 400 . I marketed Municipal bonds such as Revenue and General obligations bonds and funds which were the primary products of the Full Service Brokerage Dealer firm.

Project Payment / Manager

As Project Payment Officer and Manager I procured services from contractors in order to contribute to the reconstruction of a given governments infrastructure per nominated projects. One of the tasks assigned to me was to perform Quality Assurance vetting of how CERP Commanders Emergency Response Project funds could be used in a given area of operation. Each contractor's proposal was also vetted according to compliance rules. I participated in Internal Audits which were conducted to ensure that these projects were funded correctly as well as managed according to the contracts signed and CERP policy. The implementation of these projects improved the government's ability to govern and provide services to its populous. I issued Small business Grants to business owners with the skills needed to maintain the infrastructure. The projects being managed and payments made were in the range 25,000 to 200,000 per project. After a project was approved per compliance a purchased order request was made and the Finance and Budget department would approve the allocation of funds. I made and approved project payments and maintained a Special Accounts Payable Journal which was reconciled with Finance and Budgeting at the conclusion of each project. Each payment made to the relative contractor consisted of filing a SF44 Invoice / Receipt and updating an A/P ledger relative to the project. I built automated spread sheets to help track the productivity of each project using pivot tables and VBA Macros Excel. Power Point was also used to illustrate data analysis as to the effects of Reconstruction Projects per city. An Access database was developed in order to facilitate data entry with Forms and Report building per query. Queries were exported to Excel for further data analysis using Functions and VBA. I performed Quality Assurance Audits on selected Battalion with in the Brigade to ensure compliance with CERP policy. Briefed S8 and S9 on status of existing projects as well as proposed projects.

Confidential

Information Management Officer

As System Administrator, Access Developer, Network Security Specialist, Hardware Repair and Maintenance for a 30 workstation LAN of which was connected to a Campus Area Network. I Performed Audits on end users and their workstations in order to ensure the end users were following computer security policy. I performed the task of the Installation of Security patches and updates. I wrote a security accreditation for non-secret and secret LAN's. I developed an Access database for training management. I trained end users on how to use Microsoft Access. I managed the Brigade Web Page using Microsoft Front Page .I installed NT Server 4.0 on AS 400 Mainframe. I managed desktop Microsoft Outlook accounts doing things such as trouble shooting connectivity to Outlook server as well as adjusting settings per workstation. I assisted Campus Area Network Administrator with trouble shooting the network as it relates to Switch, Router and installation of hot fixes and patches on each workstation. I performed internal Information Management audit on LAN's connected to the Campus Area Network. I attended several courses on network security Advanced 1 and 2 Network Security, Basic 1 and 2 Network Security, A preparation in order to manage the Brigaded LAN. I wrote SIPR and NIPR net accreditation security policy for upgraded LAN.