Franklin Rojas Email & Phone Number

Miami, Florida Area

Performed Technical and administrative accounting; maintaining the City’s fiscal recordsEnsured grants were implemented according to the City’s operational and financial needsMaintained all grant related activities including preparing reports and managing receivables and payment recordingCreated and recorded monthly journal entries including month-end adjustments by using Great PlainsPerformed monthly reconciliation of payroll benefits general ledger accountsAssisted City officials as well as the general public by answering inquiries and resolving issuesEnsured that the various City contracts and agreements with Federal, State and local agencies were in complianceReviewed the various fund revenue and expenditure accounts to ensure accuracy and completenessPerformed monthly bank reconciliations and resolved inaccuraciesAssisted with preparing fiscal financial statements and notes to the financial statements; reviewed to ensure conformity with GASB

Miami/Fort Lauderdale Area

Recorded, reconciled and analyzed revenue from School system into Workday Financial Management System.Created journal entries and used a method to self-review and Reconciled $140 Million in revenuesGenerated the Endowment Fund investment reportsReviewed and reconciled payroll liability accounts including FICA withholding, retirement and employee benefitsCoordinated the preparation, review and accurate submission of abandoned property files to the state of Florida on a timely basisPrepared monthly financial statements from Colleague, Business Objects and Workday. Compared to ensure no discrepancies. Researched to resolve and correct any variancesDeveloped excel journal entry templates in order to upload financial data to Workday thus resulting in a performance enhancement of 20%. The result, more accuracy and less time to perform the taskGenerated 1099’s and all subsequent reportsWorked with external auditors throughout the year and subsequent annual auditsWorked directly with the Controller supporting and developing tools that helped to streamline accounting processes. Handled exclusive projects that helped the accounting staff

Coral Gables, Fl

Responsible for reconciling a portfolio exceeding $20 BillionVerified securities for Asset pricing, mark downs rates and interest accruals via Bloomberg Recorded monthly valuations received from various investment funds.Implemented procedures and controls to maximize department workflow as well as reducing the process time for general ledger account reconciliation Reconciled securities constantly with Custodians as well as Master Record Keeper for Portfolio accuracyGenerated monthly journal entries to Oracle general ledger via excel templatesReconciled General ledger via Oracle to insure compliance with GAAP and FAS requirementsCreated monthly and annual consolidated financial statementsPerformed Monthly comparison for variances between budget and actual Generated monthly consolidated financial statements via HyperionReconciled monthly cash activity to banks

Miami/Fort Lauderdale Area

Developed and automated accounting system to manage revenue, expenses, costs and payroll activitiesEstablished and maintained close relationships with auditors to ensure compliance with all regulatory requirementsReconciled general ledger via Microsoft Dynamics - Great PlainsCreated a relational database system to effectively track network performanceBuilt and generated monthly consolidated financial statementsManaged cash flow, capital expenditures, accounts payable, accounts receivable operationsAudited output from accounting system to verity accuracy and resolved identified discrepanciesPrepared and coordinated financial planning, business activity reports, budgeting, or reports required by the management team Implemented and ensured proper internal controls and compliance with company policies & procedures Compiled and prepared various employee benefit reportsGenerated variance reports between budget and actual

Greater New York City Area

Mba, Business Administration

Education record