Joel R Madera Morales Email & Phone Number

Orlando, Fl, Us

United States

-Lead implementation projects from the discovery phase to post support stage. -Understand and document client need. -Configure system based on client’s requirements. -Train the client’s team on how to use the software. -Support client on troubleshooting after going live.-Propose and create custom solutions (dashboards, reports, and invoices).-Lead internal meetings with team to share experiences and to assist each other’s.

Orlando, Florida Area

-Developing and implementing a 12 month cash flow forecast with a 90 day rolling focus.-Lead all aspects of new foreign banking initiatives for Mortgage Ops and HOA.-Create and maintain a Treasury's bank transaction database and use it as a platform for forecasting and as a cash management tool.-Monitor all daily activity in bank accounts and ensure that liquidity requirements are met.-Reports and explain material variances between actual cash flow activity vs forecast and budget.-Administrate new Kyriba Treasury Cash Management Software.-Analyze monthly bank fees reports and reports finding to management.

Orlando, Florida Area

-In charge of all accounting processes from posting of journal entries to prepare final financial statements for our six divisions by department and send it to management for review.-As an Administrator of Adaptive Planning, upload monthly financial information to create final consolidate financial statements and create financial reports as requested by management.-Maintenance of Weekly Cash Forecast and make cash management recommendations (funding requests, payable disbursement, etc.)-Create and modify financial and operational reports using Crystal Reports, Microsoft Access, and Microsoft Query. Design and review SQL queries to make sure data accuracy and network security.

Guaynabo, Puerto Rico

-Prepare annual budget, quarterly forecasts, and annual medium-term plans.-Prepare monthly financial statements and submit them to Headquarter in Europe.-Perform monthly financial analysis and report finding to the management.-Prepare gap analysis for monthly P&L vs. forecasts and budget and explain variances.-Evaluate Accounting Department’s efficiency and identify areas to improve.-Establish and implement inventory control procedures.-Investigate and explain COGS variance vs. standard.-Maintenance of Bill of Material and calculate the standard cost per item in system.-Investigate and reconcile difference in GL inventory balance with subsidiary and physical count.-Use Microsoft Access and/or VBA to create software to manage daily transactions.

-Prepare financial statements and submit them to the company controller.-Reconcile balance in GL with all subsidiaries (AP, AR, COGS, Fixed Assets, Inventory, ect.).-Review transaction from Account Payable, Inventory & Payroll Modules.-Prepare end-of-period adjustment entries.-Perform Balance Sheet accounts analysis periodically.-Perform banks reconciliation for all bank accounts.-Supervise two assistant accountants.-Design special reports for the management.

Inventory Analyst / Accounting

Bba, Accounting

Education record

Classes required to sit for the CPA in Florida: Advance business law Accounting information systems Advance Taxes