Assisted with the preparation of audit schedules and confirmation letters. Performed control walkthroughs and tested operational effectiveness. Ensured that purchase requisitions are properly coded, correct and tracked. Tested reasonableness of accruals by analyzing historical trends. Worked with Pivot tables in Excel to extract data to ensure that it was compliant with regulations.
System specification testing of SAP – Business Objects software development. Maintenance of Materials and Resources Database for Supply Managers. Performed database contact updates for direct and indirect material suppliers. Initialized detailed mapping of suppliers for system integration project. Updated monthly spend and savings reports in Sharepoint for companywide business segments. Modified visual basic macros for more efficient normalization of Master Data. User administrator for suppliers and supply change managers. Queried supply chain databases of both companies in order to merge data for company acquisition. Coded scripts in VBA Excel in order to scrub data.
Involved in troubleshooting import errors. Performed end user testing for performance reporting. Executed and edited macros for routine tasks. Utilized SQL Server 2008 to perform database cleanup. Worked heavily with transfer of transactions and balances in Wachovia / Wells Fargo conversion. Imported data from comma delimited files into Microsoft Excel.Used pivot tables and vlookups to perform account reconciliation
Documented defects in software integration objects using Quality Assurance software. Created test plans and test scripts according to documented technical requirements. Participated in manual testing for tests until formal tests were provided by IT department. Provided assurance as to the validity of general ledger balances. Worked with foreign currency transactions to ensure that balances were properly translated from Oracle and Insight into SAP general ledger. Exported data from legacy system into Excel in order to validate data input into new system. Acted as liaison with cross divisional business and technology representatives to verify test requirements. Lead team members in script testing and script writing based on their responsibilities in the testing process. Created tables and queries in Microsoft Access to store and extract historical data. Created outline of instruction to be used in creating software compliance testing. Reviewed current requirement data to ensure that employees in both the IT and Accounting departments would be satisfied with the output of their existing project. Participated in meetings to determine if the current documentation specified the requirements necessary for successful implementation of the proposed software. Verified that software components were complete, correct, and consistent with respect to the software requirements for that component. Validated that the integrated components satisfied the needs for their intended purpose. Performed operational testing to ensure that mathematical functions of input data produced the correct output. Utilized SQL to test data integrity of the system integration project.
Closed out hotel books each night. Managed hotel and cared for guests during evening hours. Reconciled cash and credit card receipts. Managed hotel staff.
Input hours from time sheet submissions. Kept track of wage garnishments and multi-state withholdings. Participated in periodic close for monthly, quarterly and yearly reporting.