Accountant in Marietta, Georgia

US Citizen Cesar Alexander Morales Marietta, GA 30064 Cell: 678-308-... [email protected] I am looking for an accounting position on a company in Marietta/Smyrna no more than 20 miles from this area. I am very familiar with Microsoft Excel, Word and Access. Have several years of experience in ERP Systems as described below. I am very good working with a team and can find solutions. Professional Summary: Senior Accountant with over twenty years of experience using and implementing ERP Systems. PeopleSoft General Ledger, Assets Management, Accounts Payable, Order Management,. Vast experience in end of period closing and reporting. Journal Entries, Allocations, Consolidations. Very knowledgable in Oracle and MS Sql. Implementations involve setting up accounting systems such as General Ledgers and schedule taskd such as Journal Entries, Allocations, Consolidations, Reconciliations and Reporting requirements. Accounts Payable, Assets Management, Supply Chain Management Microsoft Office and Access. Able to work as a team member as well as leading large and small teams. Technical Summary: CRM Package: Siebel 1999, 20...,PeopleSoft Modules: General Ledger, , Accounts Payable, Accounts Receivable, Assets Management, Budgets, Project Cost, Inventory, eProcurement, , Purchase Order, Inventory,HRMS, PeopleTools, PeopleCode, Application Designer, Application Engine, Data Mover, SQA Robot, Process Scheduler, Process Monitor, Security Administrator, Operator Security, File Layouts, Upgrade Assistant, Commitment Control (KK), Multi Currency. Others: SQL, PL/SQL, EMR Other Training: Siebel 7, Oracle Administration 1 and 2 , Oracle Fine Tuning the Data Base, SQLPlus, IBM Various, Project Management, Meeting facilitating, the art of listening, Team Building, Implementation Methodology (AIM, Compass, RAD) Recent: Purchasing 9.1, Accounts Payable 9.1, PeopleCode 8.5, Application Engine 8.5, Assets Lifecycle Management 9.1, General Ledger 9.1, General Ledger Foundation 9.1, Purchase Order 9.1, nVision for GL 9.1 • MS SQL DataBase2012, TSQL, MSRS, MSIS,MSBI, Visual Studio 2013 Education: MS University of Miami, 1978 Major in Accounting BBA University of Miami, 1971 Major in Accounting AA Miami Dade College 1969 Major in Accounting University of Phoenix 2004 Master of Science in Computer Information Systems (incomplete) Miami Dade College 2014 Microsoft SQL Database Administration with Business Intelligence MAADA Certificate 2016 Negotiating for Gross Profit MAADA Certificate 2016 Professional Selling Skills Detailed Experience: Marietta Toyota New Car Sales and Leasing Jan 2016 – Present • New Car Sales and Leasing Emtec Inc. (Contract) at BSO Accounting Consultant January 2015 – November 2016 • PeopleSoft Upgrade version 8.9 to 9.2 • General Leger, Assets Management, Commitment Control • Supply Chain Management, Financials and Human Resources • Fit Gap, Fit Gap Plus • Modular Testing • Training Manument Inc. (Contract), Functional Accounting Consultant November 2012 – November 2015 Various Projects • Two PeopleSoft Financials Implementations V 9.1 • One Supply Chain Management • One upgrade version 9.0 to 9.2 Fin & SCM • Project Plan, tracking deliverables and milestones • Used offshore teams Environment UNIX operating system, Oracle DBMS, PeopleSoft V 8.2, 8.9, 9.1 Palm Beach County School District, PeopleSoft Functional Accounting Consultant, May 2012 – September 2012 Second largest School System in Florida Provide PeopleSoft support as well as developing and managing technical team in the system modifications and interfaces to third party software for School System during 9.0 to version 9.1 upgrade. • Assets Management • Purchasing • Accounts Payable • Commitment Control • General Ledger • Very comprehensive use of Commitment Control (GL, AP, PO) Environment: PeopleSoft Version 9.1, DB2/AIX,. Windows XP Transamerica Training Management, Education Solutions Manager, Sep 2011 to April 2012 Coral Gables We are an Oracle Education Center and Oracle University Partner of the Year. Provide education planning on Oracle products to all client companies in the State of Florida. PeopleSoft Instructor in Financial Functional Ares (see recent above) in Coral Gables, Rhode Island, Albuquerque and Puerto Rico Have taught: • General Ledger 9.1 • Assets Management 9.1 • Accounts Payable 9.1 • nVision for GL 9.1 Environment: PeopleSoft Versions 8.8, 9.0...ls 8.5 Margin 10 Consulting at Ace Insurance, GL, KK, AP, AM Techno/Functional Accounting Lead, October 2009 – July 2011 Miami International Insurance Company deploying PeopleSoft in Mexico, Puerto Rico and Chile required Technical/Functional Design Documents; different countries have different reporting and regulatory requirements. Client needed these documents so that proper resources could be allocated and budgetary requirements be properly funded. Prepared all documents in a bilingual format for use in Latin America and US corporate headquarters. Environment: PeopleSoft Version 9.1 Oracle Corporation Technical Accounting Project Manager, Clinical Delivery Practice, Oracle from July 2007 – Aug 2009 Dallas, Houston, Cincinnati, Portland, Los Angeles Project Manager at multiple implementation and upgrade sites for PeopleSoft FMS and SCM Providing hands on expertise on GL, KK, AP, AM Project Plans using Microsoft Projects, prepared Budgets, SDLC, determined resource requirements, Critical Path resource allocation, PeopleSoft Fit/Gap analysis, Task allocation monitoring • Upgrades • Implementations • Configuration • Business analysis Environment: PeopleSoft versions 8.8, 8.0 and 9.0, Oracle versions 7.0 to 10g Acclaim Systems (contract), Miami-Dade Aviation Department, Feb 2007–July 2007, Techno/Functional Accounting Project Manager Miami Post implementation support and configuration help so that GL could be closed (2005-20...),Reconciling external systems (Propworks AR) to PeopleSoft AR, reconciling AR Balances to GL. Correcting KK problems, reconciling AP Balances to GL, Reclassifying conversion items posted to wrong periods, Distributing items that erroneously had an “I” flag Environment: PeopleSoft Financials 8.8 Sage-Mark Advisors at RGA,(Contract),Dec 2006 – Feb 2007,GL Accounting Techno/Functional Lead, (End of Assignment) St. Louis Troubleshooting GL, KK configuring Interfaces to several external systems, Tested modified interfaces and reconciled new results, documenting all new processes Environment: PeopleSoft Financial Version 9 Omnitech, (Contract), FannieMae, March 2006 – Nov 2006, GL Functional Accounting Lead Lead, (End of Assignment) Washington D.C. Part of the GL Re-statement Project, GL Support Team for a 50 Billion dollars mortgage company, Support for the on-line and batch posting process, Defined Reporting needs, Defining the Functional Requirement documents, Tree Management setup and maintenance, establishing and documenting operational processes Environment: PeopleSoft Financials Version 9 KAAVA Consulting, (contract), BCBSLA, Jan 2006 – March 2006, Senior Accounting Project Manager, (End of Assignment) Baton Rouge Upgrading PeopleSoft GL, KK AP, AR, PO and INV from V 8.4 to V 8.9, Implementing GL,KK and Cash Management V 8.9 Developed project Plan development using MS Project, developed project Charter, develop project scope, consolidations Chart of Accounts evaluation, chartfield configuration. Fit/Gap analysis, established dependencies in Project Plan, Helped client Technical project Manager with integration to overall PP, Established time line for bundles application (78 bundles behind), Met with stake holders and steering committee on a weekly basis, Helped Blue Cross Management developed a system vision Environment: DB2, PeopleSoft 8.9 System Efficiency, (contract), LANDAMERICA, Dec 2005 – Jan 2006, Techno/Functional Accounting Project Manager GL, AP, AM, Cash Management PeopleSoft implementation, (End of Assignment) Richmond Replaced Original Project Manager, reviewed and modified following items: General Ledger configuration, Billing, Purchasing, Inventory, external systems mapping to General Ledger, Conversion, Interfaces, Chart of Accounts, Chartfield Configuration, Functional Design Document Project Plan preparation on Microsoft Environment: DB2, PeopleSoft 8.9 Orizon Consulting, July 2005 – Jan 2006, Deputy Project Director at Housing and Urban Development Corporation • Responsible for completion and timely submission of project deliverables in SCM side • Coordinated development activities, requirements, testing for customizations to PeopleSoft Accounts Receivable module. • Manage staff of nine; four Testers, four Analysts and one Test Lead. • Created and implemented new processes for team of 30 Developers, Testers and Analyst to use for custom software development and testing. • Managed activities, project planning and status reporting for three PeopleSoft Enterprise Revenue Management (ERM) applications and interfaces to Financials. Environment: UNIX, Oracle 91, PeopleSoft 8.8 PHNS, Adventist Healthcare, June 2004 – July 2005, Financial Applications Manager, PeopleSoft and Kronos, Rockville, MD Managed a team of five functional consultants and six technical consultants Adventist outsources to PHNS, 23 Direct Report, and Provided client with strategic vision, Establishing Department Direction, Setting Standards, Hiring/Firing Responsible for Budget, Ensuring Client Satisfaction, Handling all Project Management functions, Steering Committee Status Meetings, Management focus meetings, Project Plans (Microsoft projects), Scope Documents, Fit/Gap. Accomplishments: Implemented: eRecruit, eProfile, eDesktop Management, Portal, Integrated 2 new Hospital into AHC HRMS, Integrated a new Cytology Lab into AHC, Upgraded Financials 8.4 to 8.4 SP2 MP1, Upgraded HRMS 8.3 to 8.3 MP1,Upgraded tools to 8.4.4 an then to 8.4.5, Upgraded from Oracle 8i to 9i. In Process: RFP for new Time and attendance system from Kronos 3.4, Upgrading HRMS from 8.3 to 8.9, Implementing Assets Management 8.8 Modules - General Ledger, Accounts Payable,. Purchasing, Inventory, Base HR, Base Benefits, eProfile, eRecruit, eDesktop Management, Position Management Environment: Oracle 9i, UNIX, WebLogic, Dec Alpha ES40 and ES45, PeopleSoft Harris County Hospital District, (Contract), May 2004 – June 2004, GL Accounting Lead, Houston Reconciling PeopleSoft GL to AP, Correcting recent conversion errors Environment: PeopleSoft GL/AP 8.4 Freddie Mac (Contract), March 3, 2004 – May 2004, Senior Accounting PeopleSoft Project Manager, Washington, D.C. Doing an assessment on the upgrade from 8SP2 to 8.8 identifying challenges and opportunities for de-customization., Also a fit/gap analysis for business requirements to 8.8 delivered functionality. Environment: PeopleSoft AR/Billing 8.8 Manument Inc., (Contract), Keane Consulting in Boston, MA, August 4, 2003 –March 1, 2004, Techno/Functional Business Analyst, Charlestown, MA PeopleSoft Financials 8.4 Global Implementation, for GL, Payables and Travel and Expenses, Production Support for UK operations, Analyst for North America Implementation, Preparing Functional Requirement Documents, Recurring JE, Unposted Journals, Expenses Open Liabilities, GL Conversion – Functional document and testing, Standard Budgets Imports – File Layouts, GL interface to Infinium Assets Management System, Allocations, Chartfield Configuration, Chart of Accounts Evaluation and Configuration, Positive Payments, Bank Interfaces, Multi Currency – Primary and translate ledger, Bundles and Fixes, Reviewing Technical Requirement Documents, LOFT testing, Approving end-user testing, Updating defect tracking database – STAT, Updating Software development database (STAT) Environment: PeopleSoft Version 8.4 SP1 on a Unix DB2 database, OS390/6000..., Windows 2000, AIX P690 (AIX 5.1) Tech-Partners, (Contract), Edward Jones in Saint Louis, March 10 – April 24, 2003, PeopleSoft Developer, 7.52 to 8.4 PeopleSoft Upgrade, Panels to Pages conversions, Pages Development, VAT and Multi-Currency Application Designer, PeopleSoft Coding, SQR Interfaces to Vendors from external systems, EDI - Vouchers in, Running Traces for SQL and PeopleCode, Troubleshooting Vendors audit process Modules: General Ledger, Accounts Payables, Projects, Assets Management, Accounts Receivable Environment: PeopleSoft 7.52 to version 8.4 on a UNIX and Oracle environment Data Trend Consulting, (Contract), Boeing Corporation, May 2002 – Mar 2003, Accounting Project Manager, Seattle, WA Replacing prior Project Manager, Used Microsoft Project 2000, Developed and modified Project Plan, Developed Test Scripts and UTP documents, Setup directory mappings, directory authentications mapping and User Profile Mappings, Modified existing public PSQuery, Applied tools upgrades, Developed design documents, Developed functional business flowcharts, Allocated resources according to needs, Lent hands-on expertise on the General Ledger, Accounts Payable, eProcurement, Assets Management and Budgets modules as well as helping with the upgrade assistant. Supervised 15 consultants plus an additional 11 developers from the client side. Approx. budget 7M PeopleSoft Modules – General Ledger, Assets Management, Accounts Payable, Project Costing, Accounts Receivable, Billing, Order Management Environment: PeopleSoft version 7.5, 8, 8.4, Oracle version 8i, Windows 2000 Server. Convergence Communications, Inc., Oct ’00 – May ’02, MIS Director for an International Telecommunications Company, Miramar, FL Directed a PeopleSoft, Siebel 2000, Intranet Implementation across, Belgium, Salvador, Guatemala, Panama, Mexico and Venezuela, Setup VAT, Multi-Currency, French, Spanish and English were languages used by various teams. Developed Project Plan, Used Microsoft Project 2000, SQL, SQLPlus, Determined individual legal countries need for reporting purposes, Developed testing strategies, Developed and tracked required budget. PeopleSoft Modules: General Ledger, A/R, Purchase Orders, Budget, Accounts Payable Other Modules: Portal’s Infranet Billing System, Vitria third party connectivity software Environment: PeopleSoft 8 SP1, Oracle 81, Sun Solaris, UNIX, Linux Windows NT 4.0 Norwegian Cruise Lines, (Contract), June ’00 – Oct ’00, Senior PeopleSoft Technical Analyst, Miami Norwegian Cruise Lines was Post Production Support for General Ledger, Accounts Receivable, Budgets, Billing, Accounts Payable, Inventory, Designed Reports as requested using Crystal Reports, Used SQR to troubleshoot and modify existing Reports, Created Check formats for England using Crystal Reports, Provided general support using PeopleTools for operations in US, England and Germany PeopleSoft Modules- General Ledger, Accounts Receivable, Budgets, Billing, Accounts Payable, Inventory, Project Costing Environment: PeopleSoft Version 7.5, MVS, DB2 Edge Software Services, Inc, Jan ’00 – June’00, CRM / ERP Consulting Firm, Siebel Project Manager, Virginia Reviewed Business Process Requirements, Built Development Database, Configured Application, Built Reference Data, Built Interfaces, Used MS Project Siebel Modules – Call Center, Service Module Environment: Siebel 1999, UNIX, Oracle Sunbeam Corporation, (Contract), Aug’99 – Dec ’99, PeopleSoft Developer during a PeopleSoft HRMS Upgrade. Boca Raton Converted from PeopleSoft HRMS version 4.0 to version 7.5, Production Support to General Ledger, Accounts Payable, Purchase Order, Created new Panels, Menus, Created New Projects, Wrote PeopleCode for Panels, Converted data to new version using DBA skills (SQLPlus, SQL), Modified version 4 Reports to version 7.5 compatible reports. PeopleSoft Modules: HRMS, Base Benefits, Payroll Interface Environment: HRMS version 4 and 7.5, Oracle, UNIX Answerthink Consulting, Oct ’98 – Jul ’99, Large National Consulting Firm, Techno/Functional Project Manager, New, Jersey, Michigan, Atlanta PECO (Philadelphia Electric Company), Book Crafters, Inc. and Car Spa, Internal Interfaces development team lead. Government Assignments - City of Springfield, Used SQLPlus, SQL, Develop nVision Reports, Developed Interfaces technical standards for Answerthink, Developed Interfaces templates for consulting practice use, Supervised, coordinated and reviewed Interfaces templates initiative enterprise wide, Developed Technical Project Plan using Microsoft Project, Lead team internally developing templates for Interfaces and Data Conversions, Fit Gap Analysis PeopleSoft Modules – General Ledger, Accounts Payable, Assets Management, Project Costing, Accounts Receivable, Purchase Order, Billing, Inventory, Order Entry Environments: Financials and Distributions versions 7.5, Oracle and Windows NT. SE-Technologies, (Contract), Tamor Manufacturing, Mar ’98 – Oct ’98, ERP Consulting Firm, PeopleSoft Project Manager and PeopleSoft DBA, Leominster, MA Converted system from Peach Tree Accounting to PeopleSoft s. I Used Application Engine to Modify PS processes, Developed Functional and Technical Project plan using Microsoft Project, Analyzed Business Requirements, Reviewed and Mapped Data Conversion Requirements, Fit Gap Analysis, Project Scope. Environment: PeopleSoft 7.5, Windows NT, Oracle PeopleSoft Modules – General Ledger, Accounts Payable, Assets Management, Purchase Order, HRMS, Budgets, Project Costing, Manufacturing, Inventory, Order Management, Billing Litton Enterprise Solutions, (Contract), Jul’97 – Mar ‘98), Very Large Commercial and Governmental Consulting Firm, PeopleSoft Technical Lead, Los Angeles, Virginia Hilton Implementation, United Waters in NJ and City of Gainesville, Developed Technical Project Plan using Microsoft Project, Implemented PeopleSoft version 6.0 Financials, Distribution, Billing, Order Management, Inventory, Technical Lead in Team of five developers, Developed SQR based Interfaces, Prepared Technical documentation, Developed SQR, Crystal and nVision Reports. PeopleSoft modules: General Ledger, Accounts Payable, Accounts Receivable, Assets Management Environment: PeopleSoft version 7, Sybase, UNIX Shared Medical Systems, Inc., Aug ’96 - Jul’97, Largest Hospital Software Company in US, PeopleSoft Healthcare Systems Project Manager Pennsylvania, Charlottesville, Birmingham, Boynton Beach University of Virginia Medical Center, Baptist Health Systems, Bethesda General Hospital Implemented PeopleSoft version 5.0 and 5.1 Financials and Distribution (Inventory, Order Management) Developed Functional Project Plan using Microsoft Project, Analyzed Business Requirements, Defined training requirements and directed training sessions as a prerequisite for tables setup, Scoped Requirements, Performed Fit Gap Analysis. PeopleSoft Modules - General Ledger. Accounts Payable, Assets Management, Inventory, Purchase Order Environment: PeopleSoft versions 5, 5.1 and 6 using Oracle on UNIX MedicaLogic, Inc., Clinical Systems Consultant and Oracle DBA, Mar ‘95 - Aug 1996, Beaverton Electronics Medical Records Software Company, Project Manager at various locations using client staff, Barnes Jewish Hospital Midwest Cardiology Associates, Springfield General Hospital, Minneapolis Hospital, Ft. Wayne General Hospital, Was part of quality assurance testing team for software development, Used Microsoft Project to develop Project Plan., Modified Panels and Reports utilizing a proprietary SQL like language. Modules: The Logician, Electronic Medical Records/Billing Software Environment: Oracle, UNIX, Windows Aiello, Serrú and Associates, Sep ‘94 - Mar ’95, Senior Oracle Database Consultant Miami A Systems Consulting Firm, Oracle 7.0 Database Administrator, SQL Plus, SQL Environment: Oracle, UNIX, Novell South Miami Hospital, Senior Accountant, 1987, Aug ’94, A 550-bed Acute Care Hospital with a 30-bed Rehab TEFRA unit, a HHA, a SNF applies for and as part of South Miami Health Systems a second 150-bed hospital in Homestead, Third party reimbursement coordinator, Medicare Cost Reports, Financial Statements preparation, Business Systems Analysis, SMS Implementation Coordinator. Modules: SMS, Harmony, HBO Environment: MVS, CICS Prior to 1985 Rex Discounts (Controller) Jackson Memorial Hospital (Assistant Controller) Public Health Trust (Miami-Dade County) Arvida Corporation (Chief Accountant) Personal: Veteran Married US Citizen PMI Member