SUMMARY

• More than 15 years experience in managing accounting and financial controls systems in complex corporate environments in the publishing, manufacturing, not for profit, media and marketing research, and construction industries.
• Clear and consistent record of successfully introducing automated systems to improve control and reporting processes and generate major cost and time savings. Adept in assembling and managing the work of talented teams of accounting and bookkeeping professionals.
• Thoroughly knowledgeable of GAAP standard and compliance issues; direct experience in managing finances and reporting through a complex bankruptcy reorganization. Excellent interpersonal communication and presentation skills.
• Experience writing functional/technical documents e.g. specification design, unit test, release doc, etc. Bilingual: English/Spanish. Over 8 years of expertise including 6 as SAP 4/3 Fico Consultant. Expertise in configuration and customization of FI, GL, A/R, AP, AA, SPL. Extensive experience in full life SAP cycle implementations.

PROFESSIONAL EXPERIENCE

Confidential

ERP Systems Analyst

Responsibilities:

• Setup all incoming payments including Lockbox using EDI823, Electronic bank statement (EDI820)
• Created origin - destination, house bank, partner profile, port definition, message types and logical message types
• Configured payment program to process transaction from banking database
• Upgraded auto clear program to process more open item after lockbox is processed
• Configured automatic payment program, which included creation of house banks, company code payment methods, employee tolerances, terms of payment, and reason codes
• Configured settings for Company code, posting period variant, assigned document number ranges, tolerance groups for customers, G/L accounts and users
• Configured partial payments, exchange rate differences, payment advices, payment proposal/payment schedule, payment run, and payment media
• Active participation through Blueprint, Design, Realization, Testing, Go Live and Stabilization activities.
• Part of the implementation team for FI-GL, FI-AP, FI-AA Product Costing, Profitability Analysis, Cost center Accounting and Profit Center accounting modules at HASS Automation.
• Defined result analysis keys, cost elements, result analysis versions and valuation methods to calculate Work in Process (WIP) and its settlements.
• Configured valuation areas, multiple currency types, movement type groups and material update structure in product costing.
• Responsible for carrying out valuation in COPA to access pricing and product cost information thereby allowing projected revenue and cost of sales figures to be calculated.
• Implemented transfer of overhead costs, transfer of activities from cost center accounting over to COPA segments.
• Configured account assignment objects for incurred costs and revenues to profit centers.
• Upgrading all P&L Departmental analysis reports into SQL Reporting services written initially in f9 and Crystal.
• 5+ years of Business Analyst in deployment of web-based, Client-Server applications, developing business processes and system solutions for Banking and Financial Industries for various projects from conceptualization to implementation.
• Excellent technical writing skills to create Business Requirements Document (BRD), Functional Specifications Document (FSD), Nonfunctional Requirements Document and Use Cases Specifications.
• Strong process modeling using UML (Use Cases, Sequence Diagrams, Activity Diagrams, etc.)
• Strong in writing SQL queries and reporting the results to the business team.
• Working on a centralized reporting application and integration tool that will coordinate all applications and ERP Platforms.

Confidential

Senior Project Consultant

Responsibilities:

• Set up systems to report to the court by migrating financial data into Great Plains which had not been GAAP compliant.
• Installed and supported FRX 6.7 and used it to create a number of financial reports including a Cash Basis P&L giving the client the ability to a 3 level drill down.
• Worked with GP Smartlist Builder to create numerous joins, views and selection criteria so that current users were able to extract information easily.
• Developed an “ERP Reporting System” using SQL reporter to extract data from a number of various sources within GP. The system executes these reports on a predetermined basis and distributes it via email to administration and accounting personnel. Reports for Purchasing, Payments and Cash Analysis are common schedules.
• Designed and implemented all budget and forecast scenarios using SQL Reporting Application.
• Assisted all non-accounting personnel in creating reports, shortcuts and executable processes for their everyday use.
• Trained staff on various models of GP including AP, AR, GL, banking module. Included in the training are the various functionalities while adding or making changes as requested.
• Upgraded the 3 satellite offices to Navision v2009 from an earlier version. Assisting sister facility with the preparation of all reports in FRX and Sequel Reporting Services. Implemented third party add-on into GP to automate communication parameters between the Oracle based billing application and GP.

Confidential

Senior Financial Manager

Responsibilities:

• Automated outdated, manual accounting systems by adopting the Timberline accounting software from AccPack, reducing the accounting staff to save $37,000 annually. Oversaw entry of 3 years manual data into new system.
• Saved $15,000 annually by reducing the need for tax extensions and resulting fees to retained CPAs.
• Enabled delivery of annual financial statements by March instead of July.
• Stabilized the position, which had turned over 3 times in a single year.
• By shopping banks, developed a relationship with CapitalOne in 2003, which guaranteed annual funding for the Mendelsohn Survey, saving at least $15,000 annually in storage and cash-management fees.
• Handled all work papers and audit for not for profit at year, including OMB A-133 filing. (Grant Received totaled $1M)
• Developed Crystal Reports to run in .NET and Crystal Viewer Environment.
• Converted SAS database extractions into PostgreSQL.
• Created workarounds for the following Crystal Reports issues: sub-report within a sub-report, passing parameters from main report to sub-report, not allowing for the use of multi-value or date range parameters.

Confidential

Senior Accountant/System Analyst

Responsibilities:

• Trained various accounting personnel on payroll processing for parent and subsidiary company.
• Played a key role in selecting and implementing QuickBooks and Great Plains Dynamics systems.
• Collaborated with the Accounting Firm in writing the Accounting System Handbook.
• Created report format from Crystal Reports this enabled exporting of data from GP into ADP and vice versa.
• Assisted the implementation consultants with the mapping of Wenn Soft (Point of Sale) to General Ledger and Inventory module. This process assured that all costs associated with inventory maintenance were properly accounted for when marginal analysis were reviewed.
• Developed custom Financial, Accounting and ADHOC reports using Crystal Reports, combining the SQL server and various tables within GP. Included were Store Profitability Analysis, Budget to Actual variances, Forecast to Budget scenarios.
• Supported the ERP Dynamics V6.2 production system, installation, upgrades, enhancements, trouble shooting, and 3rd party migration problems.
• Created cross-tab seven day weekly reports based on current week and previous week, using report custom functions to convert epoch dates.
• Created SQL stored procedures to extract data from Remedy Tables, scheduled and maintained the automatic generation of reports using Info View.
• Conversion of all reporting to Crystal Reports.