SUMMARY:

• I am seasoned financial professional with 22+ years of diversify exposure working in the financial industry where I have identified areas of efficiency, streamlining operating expenses which impact the quality and standards, and improved upon existing procedures that are in - line with the Generally Accepted Accounting Principles .
• Strong background in corporate accounting where I analyze and journalize financial transactions, prepare month-end closing, and assist on the preparation of financial packages for 13+ years. In addition, I worked on data mapping for ET&D Operations for multiple platforms of businesses such as Global Wealth Investment Management, Card Technology, and Home and Loan where I was responsible for data mapping and validating these cubes before promoting them to CTO as valid to run their specific financial reports for the period.
• Furthermore, have a strong background in preparing multi-jurisdiction sales and use tax returns within 45 states to Department of Revenue Services on monthly, quarterly, and semiannually basis where I have recovered $53.3 million in sales and use tax, $165 thousands in Motor Fuel, and $200 thousands in Aviation Fuel. In addition, I had recovered over a half million dollars in over-remittance on SALT Taxes.
• In addition to the recovery, I have optimized their filing procedures to 80% electronically from 20%, and ensure the organization has valid sales or manufacturing exemption certificates on file. Finally, throughout my consulting career, I have displayed an excellent record of accomplishment of delivering high quality results on time and under budget.
• I am highly organized and possess strong analytical and technical skills with a great attention to details.
• Enterprise Resource Planning, Information Technology for Management, Project Management, Management Science, Managerial Economics, Managerial & Financial Accounting, Global Supply Chain Management, Innovation Management, Pearson Product-Moment Correlations, ANOVA Testing, Two way contingency tables, & Multiple Linear Regression.

TECHNICAL SKILLS:

Statistical Application: Quantitative Business Data Analysis - SPSS

Microsoft Applications 2013: Access, Excel, PowerPoint, Publisher, Visio, & Words

Accounting G/L Systems: AS/400, Crystal Reports Writer, Essbase, Great Plains, Hyperion Financial Management, JD Edwards, Lawson, MAS90/200/500 ERP, Oracle JD Edwards EnterpriseOne ERP, Oracle E Business Suite ERP, PeopleSoft ERP, SAP ERP, In$ight, Microsoft FRx, & QuickBooks Pro.

Databases: Access, Multidimensional Cubes, Relational Database, Oracle 9i & 10g, SQL Server 2003 & 2007, & Sybase

Programmer Applications: Networking, Dreamweaver CS4, PL/SQL, Visual Basic.Net, System Design & Implementation, Health Information Systems, and Security Information System

Sales & Use Platforms: CCH, DEO, PPL, In Source RS Sales & Use Tax, RIA, Tax Data System, Tax Ware, Solomon, Vertex, Vertex Series Q, & Vertex Series O, & Confidential OneSource Property Tax

PROFESSIONAL EXPERIENCE:

Confidential

Data Analytics Consultant

Responsibilities:

• Approximately four months project working with the Risk Escalation Team
• Six months project reconciling China’s VAT output and input for tax purposes between IBIS GL and KECCI -Tradeworks
• Daily extract and transform IBIS GL transactional dataset to perform V-lookup against KECCI’s transactional dataset
• Develop a macro to manipulate and message the dataset to arrive at an exception report for management.
• Foreign currency translations
• Invoice issuance and management
• Responsible for creating a Business Requirements Document to have an overall automated reconciliation approach from a go forward perspective
• Ensure the project stays on task, requirements complete, requirements review, test plans, test execution will all need to take place

Confidential

Accountant II

• Sales and use tax recovery $53.3 Million
• Managed and provide directions to my one Staff Accountant
• Discussed tax mitigation provision
• Prepared monthly returns for estimated sales tax pre-payments due
• Prepared monthly returns for actual sales and use tax incurred
• Prepared semi-annual sales tax refund request
• Prepared federal excise tax deposits due and file returns quarterly
• Prepared monthly NC motor fuel claim for refund
• Prepared tax filings for motor fuel
• Researched all tax related issues and provide guidance/direction
• Assessed all Confidential retail sales locations for proper handling/remittance of sales tax
• Reviewed all 1099-MISC forms received by Confidential and file Form 990-T for refund of back-up withholding
• Reconciled all tax receivable accounts
• Prepared journal entries as needed
• Reviewed invoices processed to assess proper handling of sales tax
• Reviewed all changes in tax rules made by Confidential impact on Confidential facilities. Served as tax expert and resource to Finance VP and regional facility CFOs/controllers to address and assist with interpreting tax rules.
• Responsible for identifying process improvements and coordinating implementation of changes.
• Provided direction and guidance on occasion to other staff in department

Confidential

Senior Tax Accountant

• Furnished daily cash management reports
• Daily reconcile and allocate markets revenue cash flows
• Provided daily sales projection by 11:00 am
• Daily reconcile the bank ledger account
• Trial Balance Reconciliation

Confidential

Senior Tax Accountant

• Performed Reverse audits to recover over payments made to State and Local taxing agencies.
• Filed and prepared sales and use tax returns.
• Retrieved transactional data from various third party vendors where I compiled the data in Access and Excel, where I and perform V-lookups, IF Statements to massage the data for reporting purposes.
• Responded to tax inquiries
• Performed accounts analysis
• Worked on Tax Matrix

Confidential

Senior Tax Analyst

• Reviewed assignments and journal entries prepared by Junior & Staff Accountants.
• Mitigated risk by timely researching and escalating variances and by coaching staff through issue resolution.
• Assisted with month end closing process including timely and accurate preparation of journal entries.
• Prepared and entered journal entries, including but not limited to correcting entries, allocating expenditures, accruals.
• Performed and maintain balance sheet account reconciliations in Microsoft FRx Financials modules.
• Prepared and present monthly financial statement results and report on variances to the Accounting and Finance management team.
• Assisted in quarter, mid-year and year-end audits.
• Ensured all financial information is recorded in accordance with GAAP and Federal and State regulations and consistent with established company policy and procedures
• Escalated issues as appropriate.
• Acted as the Vertex Series O facilitator.
• Interacted with all Accounting management within the organization.
• Ensure d adherence to Sox requirements.
• Analyzed and document department processes and procedures and recommend improvements as needed.
• Participated in special projects as needed.

Confidential

Tax Analyst

• Worked on Denver 2007 through 2009 Sales and Use Tax Audit for the County & City of Denver, Colorado.
• Assisted on implementation of Tax-ware ERP System.
• Required multiple inquiries on various platforms such as PeopleSoft Contract and PeopleSoft GL Retriever.
• Monthly financial dumps in Excel where, I performed V-Lookups, Pivot Tables, IF Statements, and Conditional Formatted to scrub the data for specific information to mitigate organization tax exposures.
• Prepared property tax renditions for 2013.
• Filed all property tax returns on Confidential ’s One Source Property Tax.
• Retrieved documentations that are required for the audits by utilizing their PeopleSoft Contract Model and reaching out to various line of business partners for additional inquiries.

Confidential

Tax Accountant

• Weekly scrubbed I-buy/Purchase cube to identify pricing differential by performing V-Lookups and IF Statements.
• Responsible for uploading all data adjustments in SAP ERP modules pertaining to A/P & A/R each month.
• Initiated all data updates and upgrades in the format accessible for the upload from Vertex to SAP Financials.
• Monthly prepared 300+ business licenses and renditions for the TS Sector.
• Monthly renewal remittance to the state’s municipalities for business license, property taxes, and SALT.
• Responded to tax inquiries immediately to resolve issues within states and local authorities.
• Furnished the necessary documents for tax auditors.
• Assisted our strategic partners in filling out their exemption certificate.
• Performed monthly Black Line account reconciliation to ensure the Tax Liability Accounts are being accurately updated.
• Worked very closely with the Point of Contract for each subdivision within TS-Sector to resolve all their issues.
• Assisted in gathering the Year-end Financial Tax Package Provisions for Corporate.

Confidential

Sales and Use Tax Analyst

• Prepared and file sales and use tax return for seven of the organization regions, which consist of 28 states.
• Prepared the monthly sales and use tax liability forecast.
• Respond to tax inquiries and resolves issues with states and local authorities.
• Generated the necessary documents for sales and use tax auditors.
• Assisted clients in filling their exemption certificate.
• Performed monthly account reconciliation within Confidential ERP, to ensure the Tax Liability Accounts are being updated correctly.
• Created tables utilizing SQL syntax due to organization 6 regions financial data were not on a shared database.
• Performed G/L, A/P, A/R financial transactions dumps, where I manipulated all of data in Pivot Tables, SUMIF, and IF Statements for reconciliation and filing purposes.
• Documented SALT procedures to hand-off to the parent company.

Confidential

Financial Analyst III

• Analyzed and reported plan and forecast allocations for proper cost pools such as GWIM, HLI, Card Tech. and Corporate Tech Apps by performing V-Lookups and Pivot Tables comparison.
• Validated Chief Technology Officers "CTO" cubes to verify all data were compile accurately by creating a master template in Access where I created a variance report by executing scripts to update the new data for validation.
• Reconciled and validated Essbase and Hyperion cubes to ensure that volume and cost data billable to the lines of businesses are reasonable.
• Recorded the flow of data mapping in Visio of financial transactions from various banking proprietary platforms that included Merrill Lynch depository server by utilizing Visio.
• All Data were scrub and uploaded into MS Access where SQL scripts were executed to perform data comparison.
• Analyzed data and highlight anomalies and research for commentary to report to specific line of businesses.
• Computed hierarchy residuals within Insight GL for actual, plan, and forecast that need to be adjusted in the cubes.
• Validated actual sum totals in the Consumable cube for 2010 Plan and forecasts to ensure discrepancy free.
• Comparison of the Emerging Markets month over month were finalize in Crystal Reports template.
• Prepared 2010 Scorecard of Top 100 Applications Comparison.
• Brought in as a QuickBooks and MAS 500 ERP liaison specialist to assist the Controller with their legacy GL conversion and ensure that new accounting chart of accounts map accurately to the old accounting structure.
• Utilized Excel for data dumps manipulation.
• Assisted Sage Consultant to verify Crystal Reports depicted segmented financial reports that board requested.
• Consolidated financial trial balances in Pivot Tables for the prior periods and prepared the upload template.

Confidential

Responsibilities:

• Worked closely with IT department to develop a checkbook to track cash inflows and outflows.
• Assisted IT department with documents gathering and preparing SQL scripts to facilitate this deliverable.
• Checkbook eliminated daily manual A/R and AP JE entries and reduces month-end-close by 7 days.
• Performed daily cash management to ensure all receipts, disbursements, fees, and reversal were recorded.
• Filed sales and use tax monthly and property taxes

Confidential

• Reconciled South America accounts for exceptions, assessed broker fees, and prepared bank statement.
• Brought in as a Crystal Report specialist to assist the controller in extracting, transforming, loading their month-end data. Converted their general ledger system from Legacy MAS90/MAS 200 to Computer Ease which is tailored for construction. Developed data maps for new chart of accounts infrastructure lay-out. Managed capital investment, construction in progress schedule, and depreciation run.

Confidential

• Prepared certificate of origin for customers who qualified for NAFTA preferential tax treatment on duties.
• Assisted preparing segmented financial reporting generating from Crystal Reports and Monarch.
• Implemented Sales and Use tax procedures for Sarbanes Oxley, and reconciled sales tax ledgers in Oracle ERP
• Month-end-closing in Oracle E-Business Suite ERP System
• Verified customer’s tax status, reviewed exemption certificates, and requested updated exemption certificates by performing V-Lookups to ensure clients exemption certificates were valid for tax exemption. Responsible for adjusting the balance sheet and Fixed Assets accounts in SAP F/3 monthly.
• Applied adjustments for short paid, price discrepancies, and download monthly tax rates from Vertex Series Q.
• Updated all business occupancy licenses.

Confidential

Sales & Use Tax Analyst

• Established sales and use tax Matrix for Confidential, where I noticed 80% of their customer had valid exemption certificate on file where I recovered over $500 hundred thousand dollars in overpayments of Sales and Use Tax remitted in error by Confidential .
• Performed GL transaction dumps to reconciliations Liability Ledgers in Oracle E-Business Suites ERP.
• Saved another organization $36 thousand dollar my first month by identifying invoices that should be exempted.
• Amended $300 thousand dollars of Sales and Use tax

Confidential

• Utilized Oracle E-Business Suite ERP to ensure that organization in compliance with filing their state sales and local use taxes to department of revenue.
• Manipulated financial data within Excel’s pivot tables and ensured that data recorded in the proper GL Account.
• Filed monthly, quarterly, semiannually, and annually sales and use tax for 46 states, and prepared property tax.

Confidential

• Independently worked during the slowdown in the economy where I consulted each client below on specific software applications and tailored a chart of accounts to ensure that they were in accordance with GAAP guidelines.
• Green Pond Garden of Eden located in South Carolina, Stand-Out Nails located in Waxhaw, NC, & Newport Wood Unlimited LTD located in Charlotte, NC.
• Trained each client on QuickBooks modules how to analyze source documents that need to be recorded and how to generate profit and loss statements for several periods.

Confidential

Sales & Use Tax Analyst

• Revamp their Sales and Use Tax processing from manual to electronically EFT/EDI which reduced their tax penalties by $10 thousand per month and reduced the processing time by twelve days.
• Hyperion financial modules were utilizing to generate the Sales and Use schedules.
• Generated a monthly summary reports from AS400 GL dump by manipulating the data in SQL and creating Pivot Tables to perform monthly states’ compliance.
• Filed and remitted sales and use taxes return monthly to 45 states, prepared additional 129 returns to multi-jurisdiction taxing authorities, and responded to states and local taxing authority’s inquiries.
• Updated the tax rate table monthly and ensure that 2,500 retail outlets receive POS Terminal push.
• Renew business and privilege occupancy license.

Confidential

Senior Accountant

• Reconciled $7 million dollars out-of-balance escrow accounts from proprietary banking platforms to the new system.
• Performed multiple reconciliation of their legacy platforms in-order to trace original loan origination to identify loans that did not transferred properly.
• Required various IF Statements and V-Lookups Functions to manipulate the transaction dumps.

Confidential

Operation Portfolio Analyst

• Managed 29 institutional investor accounts with a net worth exceeding $100 billion.
• Reconciled daily cash position through recognize third party clearing houses such as Bloomberg Program Trading, Bank of New York, and PACE before updating institutional investors’ accounts.
• Responsible for identifying and resolving exceptions on institutional investment accounts.
• Informed Fund Managers Institutional Investors accounts that would become overdraw.
• Go-to-Tech for my group, where I was responsible for 2006 Microsoft Outlooks migration for my teammates.

Confidential

• Managed BSN-Jobst Canadian Portfolio which has a net worth of $5 million.
• Prepared daily US and Canadian sales reports for management, updated the capital investment schedule, distributed monthly report to project owners, capitalized the fixed assets, performed month-end-close journal entries for accruals and deferrals, reconciled inter-company transactions, and prepared financial package.
• Filed monthly states’ sales and use tax returns for 28 states.

Confidential

Budget Analyst

• Audited and monitored $6.9 Billion of State, Local, and Federal adopted appropriation.
• Reviewed budgets contents to ensure accuracy, funds balances, over-run budgets, and verified authorize approver(s) requisitions before a check was dispensed by procurement department.
• Pre-audited blanket and master service contracts from vendors soliciting business.
• Prepared monthly budget variance and budget amendment schedule.
• Hyperion’s Essbase was implemented for financial planning and analysis reporting for metric performance.

Confidential

Bookkeeper/Senior Accountant, Charlotte, NC

• Saved the organization annually $23 thousand dollars by compiling unit prices of the most frequent items purchases per month in Access Database table where I negotiated unit price with various suppliers.
• Managed all aspect of Accounts Payable which included reviewing invoices, purchase orders, general contractors, price discrepancies, coding, and account analysis within MAS90/200.
• Reviewed agents’ commission, renewal of service agreements, required lien waiver before final payment.
• Managed and updated 15 properties fixed assets schedules by performing V-looks up
• Performed month-end account analysis.

Confidential

Senior Project Accountant

• Performed account analyses more quickly by utilizing v-lookup and pivot tables to identify anomaly.
• Managed GlaxoSmithKline and Viropharma FDA approved medical projects which were valued at $42.3 Million.
• Created budgets to informed keynote leaders within medical industry the benefits of new FDA approved drugs.
• Monitored each project expenses and recorded the cash receipts within Oracle general ledger system.

Confidential

Supervisor of Sales Audit Department

• Exported the daily trial balance activities into Excel and created macro, where I kept a daily summary of all profit center receipts in a separate workbook to streamline the month-end-close processing from 10 days to 3 days.
• Overseen all cash flows and ensured all financial records were recorded to the appropriated profit centers.
• Prepared and filed monthly Multi-jurisdictional Sales and Use Tax for 33 states and property tax assessments.
• Submitted daily Sales Reports to VP of Operations to disseminate to regional and store managers.
• Created Access database to record all financial transactions daily to publish financial snapshots for senior management.
• Prepared Bank Reconciliations for all Retail Stores’ affiliated banks plus main depository account within MAS 90 general ledger system.
• Performed month-end closing, adjustments, account analysis, and balance sheet reconciliation.