PROFILE

Broad based experience with various aspects of financial management and reporting from AP A/R Payroll and Government Contracts Administration using GWAC STARS WICAP Procurement and Payables Gateway administration systems to recognize and generate revenue recognition General Ledger to Month End Closing, financial systems consolidations and/or reconciliation's budget analysis and setup. Project Management Accounting to include project setup maintenance of monthly/annual financials reporting and reconciliations. As well as administrative executive reports for sales, marketing inventory analysis, revenue recognition and job costing. Using PeopleSoft versions 8.46/8.8/8.9/9.0 Oracle Financials SCM/CRM/MFG ERP Systems versions 10g/11i/Release12 FAS Software MS Excel MS Word MS Access MS Visio SAP R/3 MS Project Works JD Edwards EnterpriseOne SAP Hyperion Reports Crystal Reports Oracle Discoverer Reports and/or Great Plains Software.

COMPUTER SKILLS

IBM PC AS400 Windows 95/98/00/XP, MAS90 A/P, A/R Module Government Systems STARS GWAC WICAP FARS FAST Visio Studio Software Peachtree Accounting DOS Windows MS Projects 2003 MS Visio Business Modeler Flow Chart MS Access 97/2002/2003 MS Excel 2002/2003/2007 Mercury Quality Test Center Test Director Timberline Software Lotus Notes MS PowerPoint Lotus SmartSuite ADP Windows DOS Payroll Software MRI Property Management Software Rent Roll Property Management Software Skyline Asset Management Tracking Software Quickbooks JD Edwards EnterpriseOne PeopleSoft Financials v. 8.8/8.9/9.0 -HRMS Module- Enduser 3yrs/Technical 2yr , A/P Module- Enduser 3yrs/Technical 2yrs , A/R Module- End-User 3yrs/Technical 2yr , G/L Module-- Enduser 3yrs/Technical 2yr , Asset Management-- Enduser 3yrs/Technical 2yr Oracle Financials v10.g/11i A/P, A/R, G/L Fixed Assets Asset Management Procure-to-Pay Inventory, BI Business Intelligence , ETL Tools, Cash Management/Treasury Bank Recon Real Estate EDS Advanced Collections Billing Project Management Procurement Purchasing HRMS Time Reporting Expenses Procure-to-payment EDI UPK Platinum Financials Software A/R, A/P, Billing Invoicing Great Plains Software SAP/Solomon Financials Lawson Software, Microsoft Project Works Project Management and ARIBA.

SUMMARY

• More than fifteen 15 years of total accounting and information technology experience of which more than Eleven 11 years of experience in financial management and reporting from AP, AR, Payroll and Government/Civilian Contracts Administration, GWAC, STARS, WICAP, Procurement and Financial Gateway administration systems to recognize and generate revenue recognition, General Ledger to Month End Closing, financial systems consolidations and/or reconciliation's, budget analysis and setup, Project Management Accounting to monthly annual financial statements using PeopleSoft Financials 9.0/9.1 Oracle Financials EBS Suite Oracle Financials 10/11i/rel 12i, or MS Dynamics 7.0 HRIS, AP, AR, Billing, Order-to-Cash, Procure-to-Pay, Cash Management, Inventory Management, General Ledger, Project Administration Costing, Fixed Assets Project Resource Management utilizing Clarity NIKU Project Management Analysis, AP/AR/Project Management/Purchasing, Oracle Financials modules versions 10g/11i/release 12i. for the following modules iReceivables iPayables iProcurement iExpense Procure-to-Pay G/L A/R Billing FA Order Management Inventory Management FAS Software, MS Excel, MS Word, MS Access, MS Visio, SAP, MS Project Works, SAP R/3, Hyperion Reports, Crystal Reports, Report Writer, Oracle Discoverer Reports and Business Intelligence Software. Expertise in creating administrative use cases, test cases/scripts and executive reports for sales, month-end closing, marketing inventory analysis, revenue recognition, and job costing.
• Three 3 full implementations PeopleSoft Financials 8.9/9.0/9.1 Projects/Project Costing, Grants Administration, Property Management, Procure-to-Pay AR, AP PO Order-toCash, Asset-to-Retire FA Oracle Discover Report Web ADI TOAD Hyperion Enterprise HRIS eExpense eReceivables ePayables/eSupplier Time Expense, SCM/CRM Advanced Collections with specialty to the Procure-to-Pay life cycle and its implementation in Oracle Purchasing and Payables Internet Business Solutions applications for the following releases 8.9/9.0/9.
• Maintain and/set up information regarding suppliers, sites, and quotations used in the procure-to-pay process.
• Working knowledge of the procure-to-pay cycle and key implementation issues in PeopleSoft Sourcing, Order Management eRequisitions, eProcurement, eiExpense eReceivables Multi-National Currency Vertex Tax Software and Purchase Orders systems.
• Identified processes involved in different phases of the procure-to-pay life cycle to include preparation of Use Cases, Test Scripts and Business Process improvement. Match the applications used in the procure-to-pay process with their descriptions.
• Identified role of suppliers in the sourcing phase of the procure-to-pay process.Provide enhancements to AR, GL, FA AP Procure-to-Pay, HR Cash Management features, Portal Management options of suppliers ASL's, supplier sites. - Create a PO catalog quotations. - Create a standard Purchase Order PO using Workflow. - SME for POS transactions, EFT payments EDI payments standard payment forms.Identified the tasks to perform when preparing for closing a Payables period.Identified tasks related to invoices and accounting entries that needed to be performed to close a Payables period.Identified accounts payable AP PO AR Advanced Collections and GL-related tasks that need to be performed for closing a Payables and Accounts Receivables period end and reconciliations.3-4 years of custom reporting design and implementation experience with TOAD, NVision, BI Analytics, Web ADI, SQL/SQR Reports, DOD OTL XML Publisher Hyperion and Vista Plus or Mobius.lop, review, test and maintain automated web forms and system reports I.e. P L, Balance Sheet, Cash Flow and other operational reports for month-end Actuals close, Forecasting, Budgeting and Long Range Planning processes to ensure and improve the accuracy and integrity of the data maintained in the financial systems. The primary focus will be end user support for the Financials, ePurchasing/eProcurement, eReceivables/Billing, ePayables, Advanced Collections, Inventory and Maintenance applications.Provide support and assist users with ERP application issues as recorded and routed through the corporate call logging application LanDesk, Clarity Portfolio Management PeopleSoft/Oracle Support Metalink or Remedy Ticketing Software.
• Coordinated and document end user testing for all issues as they are resolved using Requisite Pro Software
• Provided technical solutions primarily SQL ADI and PeopleTools to resolve data and integrity issues Gather and document business requirements, business processes for configurations, functional specifications and Five years of domain expertise in OTC and Supply chain domain with specialization in Order Management and Advance Pricing and Receivables modules. Experience in implementation, requirements gathering, process mapping, training, configuration, conference room pilot, Fit/Gap analysis, functional and technical design specifications, and post implementation support in Oracle Applications. Excellent functional and technical knowledge in Oracle Order Management and Distribution modules like Warehouse Management System, Inventory, Bills of Material BOM , Work in Process WIP , Costing CST , Material Requirements Planning MRP . PROFESSIONAL EXPERIENCE

Confidential

Senior Applications Support Analyst P2P, OTC, RTR

• Maintain and/set up information regarding suppliers, sites, and quotations used in the procure-to-pay process.
• Working knowledge of the procure-to-pay cycle, functional and technical processes involiving key implementation issues in Oracle Sourcing, Order Management Requisitions, iProcurement, iExpense iReceivables Multi-National Currency Supplier setup, E-Business Tax Software and Purchase Orders systems.
• Identified processes involved in different phases of the Procure-to-Pay and Order-to-Cash Life Cycles. Match the applications used in the procure-to-pay process with their descriptions.
• Identified role of suppliers in the sourcing phase of the procure-to-pay process.
• Provide enhancements to AR, GL, FA AP Procure-to-Pay, GL HR Cash Management features, options of suppliers ASL's, supplier sites. - Create a PO catalog quotations. - Create a standard Purchase Order PO using Workflow. - SME for POS transactions, EFT payments EDI payments standard payment forms.
• Identified the tasks to perform when preparing for closing a Payables period.
• Identified tasks related to invoices and accounting entries that needed to be performed to close a Payables period.
• Identified accounts payable AP PO and GL-related tasks that need to be performed for closing a Payables and Accounts Receivables period end and reconciliations.
• 3-4 years of custom reporting design and implementation experience with Web ADI, SQL/SQR Reports, DOD OTL XML Publisher Hyperion and Vista Plus or Mobius.
• Develop, review, test and maintain automated web forms and system reports I.e. P L, Balance Sheet, Cash Flow and other operational reports for month-end Actuals close, Forecasting, Budgeting and Long Range Planning processes to ensure and improve the accuracy and integrity of the data maintained in the financial systems.
• The primary focus will be end user support for the Financials, iPayments, iProcurement, iReceivables/Billing, iSupplier Portals, Advanced Collections, Inventory and Supplier Maintenance applications.
• Provide support and assist users with ERP application issues as recorded and routed through the corporate call logging application.
• Coordinated the resolution of complex issues with financial Enduser's and Oracle's support desk.
• Coordinated and document end user testing for all issues as they are resolved
• Provided technical solutions primarily SQL ADI and Oracle Accelerator to resolve data and integrity issues
• Provided direction and training for end users as required / requested

Confidential

PeopleSoft 9.1 Functional Lead Analyst 9.1 Implementation - Asset to Report P2P AP, PO, ePro, Grants - Consultant

• Facilitated Functional Design meetings and lead requirements definition sessions, planning sessions, status meetings, and issue resolution sessions for End-User Training.
• Perform FIT/GAP analysis and Business Requirements documentation.
• Perform/Create Test Scripts for System Performance Unit Testing Business Process Modeling QA Testing etc. using Mercury Quick Test, Test Director and/or manual.
• Facilitate meetings with client representatives to identify and create functional requirements.
• Implemented explicit Procure to Pay process for insurance organization to include a online requisitioning system PeopleSoft eProcurement
• Implement baseline PeopleSoft P2P and PO Document layout customized using baseline Oracle data definition
• Implemented baseline automated emailing of PO Doc to Suppliers multiple OU
• Created process/documentation for manual and mass automated Customer data conversion to baseline Oracle requirements.
• Generated training documentation for Purchasing and Order Management modules
• Led training classes local and Taiwan - teleconference for PO and OM changes.
• Oversaw test script completion for PO and OM logged and resolved testing issues
• Dataload files to migrate all configuration functional changes from one instance to another.
• Concurrent request-based Reporting that outputs in Excel format
• Configured and completed the system Configuration workbooks for the Procure to Pay modules.
• Planned and managed Application Assessment and Requirements activities such as Test Cases, Test Scripts and Demo script creation.
• Assisted clients in defining key capabilities /requirements that will enable their strategy by: Defining the application entrance and exit criteria Planning and managing application design and architecture activities Creating project deliverable templates and standards including coding standards, etc Creating complex conceptual designs including application interfaces and interactions Planning and managing program-wide application build, test, and deploy activities Identifying and monitoring interdependencies between various application implementation activities Planning and establishing after go-live activities including ongoing application support Escalate priority issues to project managers.

Confidential

PeopleSoft 8.8/9.0 Functional/Technical Analyst 8.8/9.0/9.1 Upgrade - GL, Grants, PC, CM, BI/CA - Consultant

• Update and Provide End-User Training materials for PeopleSoft Financials v8.9 and Oracle Financials v11i for the following Modules A/R Billing A/P G/L Fixed Assets/Asset Management Procurement Project Cost HRMS Multinational Currency Taxes Hyperion EssBase Financials Clarity and Discoverer.
• Participate in and lead requirements definition sessions, planning sessions, status meetings, and issue resolution sessions for End-User Training.
• Perform FIT/GAP analysis and Business Requirements documentation.
• Perform/Create Test Scripts for System Performance Unit Testing Business Process Modeling QA Testing etc. using Mercury Quick Test, Test Director and/or manual.
• Facilitate meetings with client representatives to identify and create functional requirements.
• Planning and managing Application Assessment and Requirements activities
• Assisted clients in defining key capabilities /requirements that will enable their strategy by: Defining the application entrance and exit criteria Planning and managing application design and architecture activities Creating project deliverable templates and standards including coding standards, etc Creating complex conceptual designs including application interfaces and interactions Planning and managing program-wide application build, test, and deploy activities Identifying and monitoring interdependencies between various application implementation activities Planning and establishing after go-live activities including ongoing application support Escalate priority issues to project managers.
• Create reports for financial analysis and reconciliations for the financial team to create journal entries, perform mass allocations and/or projects P L reports or adhoc reports.

Environment: PeopleSoft Financials v8.46/8.8/9.1 Modules General Ledger Project Accounting Cash Management Accounts Receivable/ FSG Financial Reporting ETL Tools People Code Report Writer MS Office Suite Excel Access Projects Visio SharePoint and Word Crystal Reports . NVision Report Structure Workflow Mercury Quick Test and/or Test Director Oracle Tutor and Business Intelligence Tools BI .

Confidential

PeopleSoft 8.8/9.0 Functional/Technical QA Analyst 8.8/9.0 Upgrade - GL, AP, AR, PC, Purchasing, Inventory - Consultant

• Use QTP Mercury QuickTest, Quality Center and/or Test Director for Data Warehousing concepts, writing test plans / scripts.
• Create Use Case Scenarios for the GL, AP, AR, Procurement, Procure to Pay, Inventory Management, Project Costing and HCM PeopleSoft version 8.80 to 9.0 Financial Modules.
• Create, write, execute and maintenance Test Plans, Strategies and Test Scripts Automated or Manual using UPK, Quality Center, Mercury QT Testing Tools for releases, updates and/or upgrade enhancements.
• Responsible for performing analysis, and gathering and writing requirements including but not limited to: business requirements, User Group/Joint Application Design JAD sessions, report/screen mock ups, use cases, and additional support documentation as requested.

Environment: PeopleSoft Financials v8.46/8.8/9.1 Modules Accounts Payable Purchasing General Ledger Project Accounting Procure-to-Pay, Order to Cash Cash Management Accounts Receivable/Billing Advanced Collections HRMS Inventory Management iExpense iReceivables iPayables iSupplier iExpense Fixed Assets Asset Management Clarity Clarity Portfolio Management eProcurement FSG Financial Reporting ETL Tools People Code Procurement and HRMS I-Pay/I-Procure to Payment Cash Management/Treasuary Time Reporting Expenses HRMS APP Engines Interfaces SQL/SQR Hyperion EssBase Report Writer MS Office Suite Excel Access Projects Visio SharePoint and Word Crystal Reports . NVision Report Structure Workflow Mercury Quick Test and/or Test Director Oracle Tutor and Business Intelligence Tools BI .

Confidential

Sr. PeopleSoft Consultant / Sr. PeopleSoft Financials Functional Analyst

Sr. Business Analyst / Financial Analyst

• Participate in formal code review process and provide support to the project teams in resolving issues in production post implementation when needed
• Update and Provide End-User Training materials for PeopleSoft Financials v8.9 and Oracle Financials v11i for the following Modules A/R Billing A/P G/L Fixed Assets/Asset Management Procurement Project Cost HRMS Multinational Currency Taxes Hyperion EssBase Financials Clarity and Discoverer.
• Participate in and lead requirements definition sessions, planning sessions, status meetings, and issue resolution sessions for End-User Training.
• Perform FIT/GAP analysis and Business Requirements documentation.
• Perform/Create Test Scripts for System Performance Unit Testing Business Process Modeling QA Testing etc. using Mercury Quick Test, Test Director and/or manual.
• Facilitate meetings with client representatives to identify and create functional requirements.
• Facilitate meetings with Development Team to document technical design requirements.
• Meet with other members of CIS to review completed functional specifications, technical specifications and customizations.
• Perform systems analysis and design activities and provide support to Technical team in designing test scripts, data integation and conversion using Clarity.
• Determine and resolve application and program problems using Clarity.
• Assist in the creation and review of test scripts.
• Advise and assist ERP Application Analysts and Senior ERP Application Analysts in areas of special knowledge or certification, i.e. Crystal Reports, HR, Benefits, Payroll, Benefits Administration, etc.
• Document meeting minutes, action items, and issues as assigned by the project manager.
• Create QA test scripts Regression Testing UAT Testing System Testing, etc. and perform testing using Mercury Quick Test and/or Test Director.
• Planning and managing Application Assessment and Requirements activities
• Assisted clients in defining key capabilities /requirements that will enable their strategy by: Defining the application entrance and exit criteria Planning and managing application design and architecture activities Creating project deliverable templates and standards including coding standards, etc Creating complex conceptual designs including application interfaces and interactions Planning and managing program-wide application build, test, and deploy activities Identifying and monitoring interdependencies between various application implementation activities Planning and establishing after go-live activities including ongoing application support Escalate priority issues to project managers.
• Create reports for financial analysis and reconciliations for the financial team to create journal entries, perform mass allocations and/or projects P L reports or adhoc reports.
• Assist in the development of standards and guidelines around business processes and procedures.
• Ensure compliance of all standards and guidelines within the project.
• Distribute and review project tasks for both the ERP Application Analyst and the Senior ERP Application Analyst.
• Assist the Project Manager in developing and maintaining the Project Charter. Assist and manage Project Schedules. Assist with issue resolution.
• Participate in vendor contract negotiations by providing comments for such documents as Master Service Agreement, Service Level Agreement, Technical Hosting Descriptions, and other contractual documents.

Environment: PeopleSoft Financials v8.46/8.8/9.0 modules Accounts Payable General Ledger Project Accounting Procure-to-Pay, Cash Management Accounts Receivable/Billing Advanced Collections HRMS Inventory Management iExpense iReceivables iPayables iSupplier Purchasing Fixed Assets Asset Management Clarity SAP FICO SIRAX Net Weaver Clarity Portfolio Management eProcurement FSG Financial Reporting AppEngines PeopleCode Project Costing Procurement and HRMS I-Pay/I-Procure to Payment Cash Management/Treasuary Time Reporting Expenses HRMS APP Engines Interfaces SQL/SQR Hyperion EssBase Report Writer MS Office Suite Excel Access Projects Visio SharePoint and Word PeopleSoft Financials Telecom Software One-View ABACUS and Delphi Crystal Reports . PeopleSoft Financials v8.9 A/P A/R HRMS Fixed Assets G/L: Project Costing FSG Reporting Procurement Time Reporting Expenses NVision Report Structure Workflow Mercury Quick Test and/or Test Director Oracle Tutor and Business Intelligence Tools BI .

Contract Companies Employed by and performed Implementations/Upgrades:

Confidential

PeopleSoft 8.9/9.0 Functional/Technical UPK Tester Training Analyst 9.0 Upgrade - , GL, AP, AR, PC, Purchasing - Consultant

Confidential

PeopleSoft 8.9/9.0 Functional/Technical Lead Analyst R12 Upgrade - , GL, AP, AR, PC, Purchasing - Consultant

Confidential

Oracle/PeopleSoft Functional Lead Analyst R12 Upgrade - Time Expense, HRIS, Payroll, GL, AP, AR, PC, Purchasing - Consultant

Confidential

PeopleSoft Functional Lead Analyst R12 Upgrade - Order-to-Cash, GL, AP, AR, Expenses - Consultant

Confidential

Oracle/PeopleSoft Functional/Tech Analyst - GL, AR, AM, AP, Pr0cure-to-Pay - Consultant

Confidential

PeopleSoft Financials QA Lead Analyst Consultant

Job Titles: Trainer / Administration / Functional / QA / Configuration / Implementation / Technical Skills:

• Oracle Financials versions 10g, 11.5.10, 11i, Rel.12i configurations and reporting experience with GL, AP, AR, Procurement and Billing modules.
• Provide support to custom interfaces between Oracle and Front-End systems using Integration Broker and Oracle Messaging as well as support various other modules of our Oracle System.
• Proficient with Oracle development tools such as AppEngine, PeopleCode, Integration Broker, Workflow, Messaging, Web Portal and SQR.
• Responsible for developing detailed batch job design and job scheduling specifications for discretionary projects in Financial Information Systems.
• Work as SME expert in the technology architecture and batch job design of mainframe applications in the financial business area Oracle General Ledger, Accounts Payable, OPUS, Cognus, CAT, etc.
• Provide necessary Production Support oversight for Oracle /Legacy applications and effectively troubleshoot day-to-day issues in our mainframe Financial Systems. Provide guidance and recommendations to business partners and team-members for overall improvements.
• Liaison with our business partners to proactively plan job schedules and oversee daily job scheduling. Supervise the implementation of these changes.
• Coordinate and Quality Assure overnight batch monitoring conduct daily meetings in the morning to review status of the previous night's batch and conduct daily afternoon meetings to communicate changes to outsourced vendors.
• Quality Assure completed development work. Provide guidance and assistance to developers in making coding changes and migrating code. Ensure that documentation is complete and in conformance with SDLC and CMMi requirements. Ensure that all Change Management documentation in CA Unicenter conforms to company standards.
• Migrate MVS programs to staging environments in preparation for production migration. Coordinate and Quality Assure migration of code and objects to MVS production.
• Function as the Financial IT Team Local Security Administrator, authorizing business and IT personnel to our testing environments. Perform periodic SOX re-certification of access to our technical environments.
• Maintain systems that provide a means of the clients name to centrally manage vendor payments through a web enabled payment tool. Manage, track, research, and report on all payment disbursements using SQR, PL/SQL ADI.
• Maintain integration touchpoints which would be: payment requests, payment requisition confirmation, and payment draft confirmation. Each integraOracle Techno-Functional, Financials, GL, AP, PO, AM, Procurement, SQL, Application Engine, Application Messaging, Component Interface, Integration Broker, and PeopleCodetion point will be used for the following....process flow, process description, file format and data, integration, configuration, additional requirements, and enhancements.
• Ownership of an internally-developed non-PS Investor Accounting application and its surrounding development processes.
• Strong development skills covering all technical aspects of customization including: 1 interface development, 2 PeopleTools development new/modified page, table, code, and 3 reporting development. Current platform is MS SQL Server 2000. Current version is v8.8.
• Experience with SQL, SQR, Application Engine and Component Interface.
• Exposure to Crystal and nVision and how they are creatively deployed.

Environment: PeopleSoft v8.46/8.8/8.9/9.0 modules A/R A/P G/L AM FA HRMS Billing Procure to Pay Advanced Collections Cash Management Asset Management Fixed Assets Treasury Management EDI Banking Time Expense OTL Bank Recon TOAD Query FSG Financial Reporting PeopleCode Project Accounting, Contracts Project Costing Procurement and HRMS iPay/iProcure to Payment Time Reporting Expenses HRMS APP Engines Interfaces SQR Hyperion EssBase Report Writer MS Office Suite Excel Access Projects Visio SharePoint and Word PeopleSoft Financials Telecom Software One-View ABACUS and Delphi Crystal Reports . PeopleSoft Financials JD Edwards Enterpriseone v8.9 A/P A/R HRMS Fixed Assets G/L: Project Costing FSG Reporting Procurement Time Reporting Expenses NVision Report Structure Workflow Mercury Testing.

Confidential

Financial Business Analyst

• Preparation of monthly IT and Research Development budgets variance reports for internal review by management using Oracle Financials 11i modules Project Accounting A/P G/L Purchasing and Financial Reporting and PeopleSoft 8.0/8.8 Modules A/P A/ Invoicing Billing Projects Administration .
• Assistance in researching the reasons for monthly variances vs. budgets.
• Assistance in communicating monthly budget variance results to relevant department managers.
• Preparation of QARA departments' month-end journal entries for submission to the Accounting department. Maintained and updated consultant, vendor and association files.
• Headcount tracking and reporting.
• Provided assistance in preparing of journal entries for calculating and preparing adjustments to budgets as part of annual review process.
• Processed purchase orders requests and check requests for QARA and/or R D departments.
• Prepared other ad-hoc reports and requests i.e., capital expenses, hardware software .
• Created and maintained reporting templates in NVision and EssBase systems.
• Overall planning, designing, and writing of manuals to be reviewed by the Business Analysts for accuracy using MS Visio, MS Word and MS Project to create and design Flowcharts, Organizational Charts Manuals SOP's and Technical manuals as well as updates to the UPK's.
• Translated GL monthly for Wireless customer Dues and corporate Fees ad hoc requests.
• Prepared and input Budget totals with retrieved Actual totals and make variance reports and reconciliations accordingly.
• Created Year End Presentations.
• Worked with R D for Implementation products to include Oracle/PeopleSoft Projects Costing and Billing, Oracle Project Contracts, OP3, and Oracle Project Resource Management.
• Performed Audits and corrected Error Exception Reports
• Processed and interpreted Projects information i.e., Payroll Expenses P L Revenue recognition into the Oracle/PeopleSoft Project Costing Module.
• Reclassed general ledger items that have been misallocated as well as reconciling and maintaining database for invoices to be paid by Executive Office division.

Environment: Oracle Financials 11i/ Primervera PeopleSoft Financials v8.46/8.8/8.9 Hyperion EssBase Oracle Discover Crystal Report Writer MS Office Suite Excel Access Projects Visio SharePoint and Word PeopleSoft Financials GL AM PA/PC Telecom Software One-View ABACUS ARIBA and Delphi Crystal Reports NVision Report Structure TOAD Query

Intercontinental Hotel Group, Inc., Atlanta, Georgia January 2005 - April 2005

Project Administrator Accountant

• Assisted with implementation of Oracle 10/11i and PeopleSoft8.0/8.8 Financials Modules Financial Reporting EssBase Software SAP SQL MS Excel and Hyperion Reporting for queries created to determine revenue recognition for the Information Technology group.
• Prepared miscellaneous accrual reconciliation's, created reports and interacted with diverse clients upper management and external staff members in order to manage the monthly cost of billable/non-billable subcontractor's expenses, time and materials for ongoing projects.
• Oversee the Capital Expenses/Purchase orders process to ensue instilled processes were followed correctly.
• Identified all prepaid expenses that were paid by the A/P Team and created amortization schedules, necessary journal entries and general ledger entries for individual and departmental expenses.
• Created links macros and queries using MS Excel and MS Access.
• Developed user manual, training materials, and test plans, and marketing materials for OP3, the Primavera to Oracle Projects integration tool and PeopleSoft 8.0/8.8 UPK's User Product Kits using Visio MS Word Smartdraw and other MS Office Software.
• Environment: Oracle Financials 11i PeopleSoft Financial Modules 8.46/8.8 Financial Reporting Hyperion Enterprise FCM/EssBase
• Report Writer NVision SAP SQL General Ledger Asset Management Documentation Software MS Outlook MS Excel MS Access MS Visio PeopleSoft Portal Web ADI SharePoint MS Projects Crystal Reports and NVision

Confidential

Government Contracts Project Administrator

• Reconcile and/or enter cost and revenue data to ABEST, WIFA and Procure Gateway Government finance tracking database using Oracle Project Management Microsoft Project Works and Great Plains Software, MS Excel Spreadsheets and MS Access.
• Perform audits of subcontractor expenses submitted paid for in compliance with Master Service Agreement MSA and GAAP accounting rules. Identify any prepaid expenses that are paid by the accounts payable team and create amortization schedules for individual expense items.
• Generate monthly and quarterly capital reports that accurately reflect current capital spending.
• Verify budgeted and spent amounts with the Procurement Team, Sales Team and End Users on a continual basis. Prepare journal entries to include i.e., prepaid expenses, DNP Accruals, capital assets, and reversals/reallocations related to subcontractor time .
• Developed user manual, training materials, and government compliance forms, and sales manuals for OP3, the Primavera to Oracle Projects integration tool using Visio MS Word Smartdraw MS Projects SharePoint and other MS Office Software.Perform government contract bidding and Request for Quotes processing using the FAST, GWAC, WICAP, FARS, Gateway Procurement and GSA Contract maintenance systems.
• Consulted with military logistics agencies GSA, DOL's, DODDAC's-Military Installations and/or FAA Departments State Government Agencies concerning sales order requests.
• Provide customer support for delivery of goods to DODDACS Military Installations in excess of 1 million or more monthly.
• Manages monthly cost of billable/non-billable subcontractors and generates/verifies corresponding reports.
• Ensure that established processes are followed and that financial operations deliverables are produced on schedule and according to firm standards.
• Overseen the management/reporting of capital assets and prepaid expenses to ensure correct accounting.
• Maintain working relationships with subcontractor vendor contacts to ensure timely receipt of monthly invoices for A/R processing. Investigate variances from standard invoice processing procedures while reconciling monthly revenue cost estimates to actual amounts and provide explanations for any variances that arise.

Environment: Oracle Financials 11i Great Plains Financial Software Crystal Reports MS Office Suite Outlook Excel, Access,

Word MS Visio MS Projects Government Software STARS GWAC WICAP FARS FAST

Confidential

Project Administrator

• Ensured that established processes were followed and that financial operations deliverables was produced on schedule and according to firm standards.
• Additional duties included the management/reporting of capital assets, oversight of prepaid expenses to ensure correct accounting using Great Plains Financial Software and Crystal Reports.
• Maintain working relationships with subcontractor vendor contacts and Project Functional managers to ensure timely receipt of monthly invoices for A/R processing.
• Investigate variances from standard invoice processing procedures while reconciling monthly revenue cost estimates to actual amounts and provide explanations for any variances that arise.
• Reconcile/enter cost and revenue data to EMT/Comet finance tracking database using Oracle Financials and MS Access.
• Perform audits of subcontractor expenses submitted paid for in compliance with Master Service Agreement MSA and GAAP accounting rules.
• Identify any prepaid expenses that are paid by the accounts payable team and create amortization schedules for individual expense items.
• Generate monthly and quarterly capital reports that accurately reflect current capital spending. Verified budgeted and spent amounts with the Procurement Team and Sales Team on a daily basis.
• Prepare journal entries to include i.e., prepaid expenses, DNP Accruals, capital assets, and reversals/reallocations related to subcontractor time and expenses .
• Developed user manual, training materials, and test plans, and Engineer plans using Visio MS Word Smartdraw SharePoint and other MS Office Software.
• Environment: Great Plains Financial Software PeopleSoft Financials Timberline Crystal Reports Documentation Requirements
• using the following software i.e., MS Excel MS Access, MS Projects MS Visio and SharePoint

Confidential

Project Administrator Specialist

• Reported to the Business Sales Team Leader within the Business Sales department.
• Entered and processed orders and assisted in the day-to-day administrative tasks whereas I utilize MS Office for Word to create, edit, mail merge documents and/or letters for the Business Sales Division.
• Used Microsoft Excel to create, edit, import/export and maintain more than 50 different spreadsheets. Investigated reasons for return of products or cancellation of service or changes to vendor reporting structures.
• Ensured that all information sought by Account Executives, Business Associates or Sales Managers is accurate and received in a timely manner.
• Performed calculations for Flex Spending Accounts FSA, 401K, Healthcare deductions from employee's payroll, processed and balanced weekly, exempt and nonexempt employee payroll for multi-state and international payrolls consisting of 500 employees. As well as payroll audits and bank reconciliation's for these payroll cycles.

Environment: PeopleSoft Financials ADP Payroll MS Excel MS Access MS Visio MS Projects Report Writer, Crystal Reports

Confidential

Senior Financial Analyst

• Consolidated and prepared inter-company, inter-department journal entries for Corporate Accounting departments using GAAP Standards and EssBase.
• Performed systems Great Plains Financials, PeopleSoft Financials/ Oracle Financials, and Hyperion Reporting financial close processes including posting all expense accruals, prepaid expenses, and revenue entries and running interfaces e.g., AR, AP, etc. that affect company earnings entries.
• Administered the reconciliation of Accounts Payable and Payroll department functions, i.e., journal entries for 401K, Cafeteria plans, Payroll taxes, Payroll Deductions, and reclassification of expenses by journal entries when necessary via PeopleSoft automated MS Excel spreadsheet upload and ADP Report structures using MS Excel and MS Access .
• Verified and process accounts payable and payroll department's batches by running query reports that pull and then view standardized information such as payment information, voucher information, and account review using MS Excel, MS Access, Crystal Reports, Report Writer and Company Financial Systems.
• Perform maintenance of standard operating procedures and manuals such as maintaining tables designing new queries for private and public use setting up new companies and/or business units and creating SOP Manuals for the Business Analysts.
• Administered the efficiency and reduction of errors by Supervising and cross-training office staff consisting of 2 Payroll Clerks, 2 Accounts Payable Clerks and 1 Expense Distribution Clerk so that each order was handled by one person instead of four.
• Promoted consistent levels of timeliness, accuracy, and completeness in performing month end closing processes preparation of liability and/or expense account reconciliation as well as accruals allocations on a monthly basis to ensure totals are allocated accurately and interface with Financial Reporting Fixed Assets staff on the tracking and reporting of balances according to GAAP standards.
• Reconciled monthly bank deposits and/or transactions, to include EFT ACH Check Register and payroll transactions.
• Handled Bank Register reconciliations for Operating Payroll Investment Money Market and Account Payables accounts.
• Input payroll as an end-user through ADP and process checks through PeopleSoft Financial software. Code with appropriate PeopleSoft General Ledger codes. Generated an accurate accounts receivable and accounts payable system and prepared payroll entries for 1000 employees. Prepare sales and quarterly payroll reports.
• Interacted with Controller and/or Financial committee and other Accounting Managers in regards to daily Accounting Systems Proce
• Additional duties were the assignment to the Implementation Team to provide assistance with PeopleSoft 8.0/Oracle Platform upgrades and other software upgrades NVision, Crystal Reports, SharePoint Report Writer and etc. to interface with standing Legacy Systems.

Environment: PeopleSoft Financials Oracle Financials Great Plains MS Excel MS Visio MS Access SharePoint MS Projects