SUMMARY:

• Fifteen years of client - based ERP systems configuration, design and user support emphasizing SAP Financials and integration with Logistic type modules; extensive database management, data analysis, online documentation writing, user training and bespoke functional development within a global multi-national and currency environment.
• Twelve years of Finance/IS experience: Financial Systems Analyst, Accounting, and Data Modeling Design; extensive use of MS Office tools EXCEL and ACCESS design for financial analysis, ROI, capital budgeting, risk management scenario analysis and Project Management with VISIO project tools.
• Roles included Business Analysis involving multi-functional scoping requirements for quality control and integrated systems mapping for legacy data and external interfaces; eight years Crystal report design.
• Eight years work experience in Accounting and Financial Analysis for Private and non-profit institutions applying GAAP and Fund Accounting principles to GL maintenance, financial statement preparations, tax returns and year end audits for a public accounting firm

EMPLOYMENT:

Financial Systems Analyst

Confidential, Herndon, VA

Responsibilities:

• Design, systems implementation and improved systems support for multi-national service company’s Western Hemisphere in SAP Financials and Operations (FI,CO, FA, SD, MM, Purchasing, Plant Management); all aspects of user support; maintain multi-currency exchange valuations; configuration and maintaining of data integrity and internal process controls; enhanced internal reporting with extensive ABAP Query design based on query info sets; developed legacy and master data uploads through Batch Data Communication templates; full implementation of fixed assets SAP-Fixed Asset module
• Results: 300% increase in Revenue and Net income within jurisdiction
• Revenue maximization with re-developed and streamlined pricing process to comply with specific customer and contractual requirements
• Enhanced User multi-purpose reporting tools for Account Receivable collectors aging, Work In Progress analysis, Plant site financial and contact data, Invoice history, Revenue statistical analysis for finance executives and other users
• Design query reports for external auditors related to Revenue, costs, regional analysis, Fixed asset tracking and inventory
• Full-cycle implementation of new entities with duties including requirements scoping, legacy master and financial data transfer to new platforms, user support and process preparation, document and posting control configuration, development of enhanced invoice systems implemented with multi-nation tax rules, multiple ledger and currency revaluation and reconciliations
• Results: streamline global consolidation for timely executive reporting
• Simplify inter-company balance reconciliation and cash transfers with multiple currency
• Development and implementation of consolidation financial tools, most recently VENA FP&A Software as a service.
• Developed underlying queries processed by SAP to VENA front-end
• Tested and coordinated development with SME and developers to verify periodic data transfers
• Drill-down transaction data provided to executive users for first time to enhance decision making
• Coordinated user acceptance testing for implementations, enhancements and hardware upgrades in SAP
• Examples: Developed with Sapscript programmers Electronic outputs auto sent to customers with balances
• Design electronic payment advices sent automatic with payment programs
• Develop local DME files for ACH and Priority Payments through SAP
• Managed data integrity for integration of functions FI/CO/SD/FA including: activity cost rates applied to intercompany recharges and job expenses; job pricing codes; material master tables applied to Billing and revenue recognition; fixed asset master data and depreciation cycles; global foreign currency rate maintenance and periodic currency revaluation; nation specific financial statement versions containing alternative account structures for local reporting
• Maintained General Ledger accounts as well as Profit/Cost Center hierarchy
• Developed Data Warehouse reporting programs using Crystal reporting tools for Profit Center accounting, aging and tracking receivables, Service Orders and Profitability analysis; Crystal reports for all Financial and Operational uses based on tables from MS Sequel; designs involved table linkages and program functions
• Assisted in compliance with multi-nation legal requirements by developing business cases and solutions with local technical personnel to align local reporting, taxes and local invoice and government interface requirements with SAP processes incl. SPED sales order tax compliance in Brazil and sales tax provisions for Canada and Mexico operations
• Tested implementation and maintained CONCUR employee expense system hierarchy; developed through SAP automated external employee 1099 tax returns based on reimbursed fees
• Results: reduced 1099 tax preparation time 50 percent;
• Extensive user training and support with all aspects of the Accounting cycle incl. period closing and global consolidated reporting on SAP, COGNOS and Hyperion platforms
• Supported all accounting functions with tasks including: finance and data analysis, journal entries, periodic reporting and budget preparation and variance analysis through SAP Profit Center Accounting
• Business analysis provided for miscellaneous finance related operations, treasury cash management, and development and integration of online marketing functions to SAP
• Augmented fifty percent savings in treasury function time through full development of Electronic Bank Statements and Lockbox automated banking; involved configuration, function specification, user training, coordination with banking entities
• Maintain HR module personnel role and profiles when necessary
• Provided audit and compliance reporting for USA and other countries

Programmer/Business Analyst

Confidential, Bethesda, MD

Responsibilities:

• Provide technical support and systems development for Project Accounting and Management in Marriott’s architecture and construction division to enable building managers to better trackproject development and costs
• Developed third-party reporting system using MS ACCESS used for tracking project activity derived from Siebel’s OASIS project software: gathered requirements from business leads to facilitate system integration; developed ACCESS queries, reports and front-end user switchboard for the database; coordinated and supported daily data load from OASIS to reporting system liaising with programming team; wrote process documentation using MS Word and Visio; trained users for new system
• Facilitated mapping and UAT in liaison with team leads for transition of Project Management systems
• Maintained and applied Peoplesoft queries for Finance Team

General Ledger Analyst

Confidential, Washington, DC

Responsibilities:

• Data Analyst in Accounting operations group for a large financial restatement project
• Verified, edited and posted accounting related journal entries delivered by the various organizational workstreams into the Peoplesoft G/L system
• Maintained identification system of journal vouchers in Peoplesoft
• Configured and maintained new classes in Peoplesoft’s Tree management reporting function to reflect the Accounting rollup of Company’s workgroups into a consolidated reporting structure
• Defined reporting scopes for nVision reports based on company specific parameters

Business Systems Analyst

Confidential, Sparks, MD

Responsibilities:

• Developed and revised Report Tools and database Query reports for Balance Sheet, Income Statements, Profit and Cost Center variance analyses
• Configured Special Ledger reporting tool, Internal Order management, cost allocations
• Scheduled integration and regression test procedures and data
• Developed Accounts Payable 4.6C system in liaison with A/P principal, data management and purchasing teams: basic configuration of A/P, invoicing and payment program; assisted in the design of spreadsheets for legacy data and vendor master loads;
• Presented training and information workshop on SAP system financial concepts to corporate financial principals
• Prepared Business Process Procedures and configuration documentation according to ASAP implementation methodology
• Trained SAP end-users on system upgrade and optimization tools for analyzing line items

Confidential, Pittsburgh, PA

Business Systems Analyst

Responsibilities:

• Coordinated deployment of SAP software for a branch office in Accounting, Purchasing, Sales, Reporting;
• Lead installation of version upgrade to SAP 4.6 by installing new software version, developed testing data scripts, trained end-users for new interfaces;
• Enforced the proper deployment of software and integration of program various bolt-ons, i.e.
• Vertex Sales and usage Tax, Confidential, Corporate Accounts Receivable Management program;
• Developed manual entry process for G/L entries;

Confidential

Financial Analyst

Responsibilities:

• Maintenance and upgrade of MS ACCESS systems to produce period results from historical data migrated from legacy Database system;
• Design database programs, queries and MS Office models for various performance and variance analyses; assorted Data Mining functions.
• Developed joint Excel and Powerpoint programs downloaded from central databases that displayed monthly financial results for airline mileage campaigns
• Designed MS ACCESS Database used to synthesize data loaded from AS400 system to be applied for variance, product profitability and budget analysis; loaded ACCESS Tables, designed queries and complex calculations, forms and reports in order to save keypunching time by staff

Financial Systems Analyst SAP R/3

Confidential, Oakbrook, IL

Responsibilities:

• Gap Analysis and Blueprinting based on Question & Answer database; Coordination with management of company’s accounting policies to SAP functionality - GL chart of accounts structure, tax jurisdictions, internal projects,
• Post-implementation support for Accounts Receivable and Sales & Distribution systems;
• Implemented a new Lockbox Bank from system configuration to testing and realization;
• Provided EDI e-commerce feasibility consultations to investigate improved efficiency of AR customer payment programs;
• Supervision and training of Financial team and end-client users in GL, AP and AR Coordination of company’s accounting policies to SAP functionality with company financial management - GL chart of accounts structure, tax jurisdictions, check payment programs, internal order settlements, payment tolerances, fiscal year variants;