Customer Service Sales

SANDY ELLINGSON

N**** County Highway G

Reeseville WI, 53579

920-***-**** Cell: 262-***-****

**********@***.***

AREAS OF EXPERISE

Versatile, goal-directed senior systems analyst with 20 years of progressive experience

ERP packages: i.e. JDE, ASI, Lawson and Hyperion (focus on JD Edwards)

Supported corporate systems: legal tax, HR and treasury

Main focus in finance (Accounts Receivable, Accounts Payable, General Ledger, Fixed Assets,

Costing and multicurrency)

International travel and work

Support in Customer Service (sales order management), inventory management, MRP, BOM,

forecasting, marketing and audits.

Strong focus on optimizing processes with innovative IT solutions.

Skilled in the design and/or implementation of complex systems, using a strategic approach.

Consolidates multiple business requirements and provides intuitive solutions.

Designed and developed documentation controls to comply with the Sarbanes-Oxley Corporate

Accountability Act of 2002.

Total package: development, functional, project management, integration strategies and Business

intelligence projects, training and complete documentation

TECHNICAL SYNOPSIS

JD Edwards One World complete toolset along with all technical training. (over-view, reports,

toolsets, applications and financial reporting)

SQL server tools

FormScape integration with customer facing documents.

AS400 tools including query and SQL.

Knowledge of user profiles, database design, file transfer and communication using cross

platform transfers.

Expert on AS400 COBOL and CL.

Applied fixes for Lawson in AS400 RPG.

Worked with Robot products, Outlook, Lotus notes and On Demand imagine system.

Very knowledgeable working with banking institutes on payments. Proficient in working with

many 3rd party software.

CAREER HISTORY

Bou-Matic LLC, Madison, Wisconsin August 2005 - 2009

Placed at Bou-Matic in Madison, Wisconsin.

Systems Analyst

Duties

Project managed the shut down of a company (all areas from inventory, work orders, purchase

orders, sales orders, inter-branch set up, customer set up and finance)

Lead on inter-company processes using multi-currency (sales, purchasing, AP, AR and GL)

Designed, tested and implemented the emailing of customer facing documents

Supported, tested and system modifications during 2 Formscape upgrades

Collaborated with venders, external customers and internal customers during UPS upgrade and

interfacing using crossware (testing and restructure)

Co-managed with outside consultant on the feasibility of contract billing in Belgium.

Managed several small projects to enhance our JDE system.

Respond to day to day problems and support user requests via Sysaid tickets.

Helped with the implementation of JDE in our Belgium company. Created complete training CBT

using power point

Traveled to Belgium for post implementation support and other projects. (around 8 to 10 times

last 3 years)

Created daily gross margin report (was not available before) with incoming orders and shipments

(daily, monthly and YTD). The shipments has the GL adjustments added to the Gross margin

amount. There is open orders and plan orders and plan shipments added to the report. – many

applications, tables and UBE had to be created in order to accommodate this.

Created daily reports which tied to the GL

Aided in the implemented of auto cash

Assisted in year end cost roll

Robert Half Technology, Madison, Wisconsin 2002-August 2005

Placed at Bou-Matic in Madison, Wisconsin.

Senior Systems Analyst/Contractor

Contract Duties

J.D. Edwards security and menus One World (B7334)

Created user menus, roles and assigned menus

added user classes to designate security

updated SQL server with correct users

J.D. Edwards Reports and applications One World (B7334) This includes: costing, invoicing,

pricing, cost verses price, pick/move tickets, labels,

Created many reports for analytical work across all functional areas.

Support of system

Support of Outlook email system during conversion (new installed, changed security and

passwords, updated improper installations, managed help calls both in house and field)

Created complete COGNOS training CBT using power point

Tracking sales leads – created access database to hold all sale leads from the reps and updated

with JDE information

Placed at ABS Global in DeForest Wisconsin.

Senior Systems Analyst/Contractor

Contract Duties

J.D. Edwards sole support: One World (B733,2) and World A7.3, support all systems but not

limited to HR, AP, AR, GL, inventory and Sales order management - and any additional

programming needed in AS400 RPG

With no formal CNC training - reduced the AS400 capacity from running at 90% down to 20%

Worked on AS400 hardware including remote printers and internal modems

Supported inventory and created a month end process to keep the work files for reuse at any time

Worded with the business team to implemented EDI on line banking for both lockbox and AP

payments

Worked with JD Edwards support staff on moving central objects

Updated the UPS system for distribution with additional JDE interfacing

documented and trained users on new systems which included business processing

Gave a weekly status reports on any issues or questions and resolution

Converted a bad debt system from access into JDE activity manager

Documented part of current system with business requirements and technical flow using tables,

event rules and processing options for future updates.

Modisit, Chattanooga TN 2004-2005

US Xpress. (Independent – off hours and on weekends – remote)

Technical Writer

Contract Duties for Sarbanes-Oxley

Documented selected applications with processing controls, integrity controls, program file and

calls, and cross reference to the business flow.

Created detail IT documents

Created business overviews

Identified missing controls

Used Visio to create data/program flow charts

JOHNSON DIVERSEY, Sturtevant, Wisconsin 1997-2002

Formally was Johnson Wax Professional. Industry leaders in providing professional cleaning care.

Senior Systems Analyst

Design, implemented and supported all financial systems, external interfaces, and system enhancements.

Business supported of corporate systems including tax legal, human resources, consolidation, and audit.

Global ERP effort.

AS400 Cobol was the language choice used other than JD Edwards and Lawson.

ERP

J.D. Edwards global effort: One World (B733,2) and XE (B733.3)

Requirements both technical and business functional, design and creation of 30% of reports in

first phase (report writer)

Created/changed on-line applications and batch (UBE) including business views, files, processing

options and event rules.

Requirements, design, or consulted on 50% of interfaces for North America including EDI

transactions, address book and item master

Set up matrix table for multiple use in finance reporting

Lawson financials - written in AS400 RPG

Managed and/or provided hands-on experience on all major projects

Created many added interfaces from, and into, Lawson, including EDI, ACH, AP, AR and GL

Managed and implemented On Demand imaging system for AP and AR

Implemented the financial suite of ASI Cool 2E, (1998-1999) system in Europe for Polymer Division

– traveled to the Netherlands for implementation and support

Corporate Systems

Designed and implemented complex stock tracking system in only 3 months

Corporate consolidation - worked with Hyperion using HAL and Hyperion Enterprise, created actual

and budget interfaces first for Lawson GL and later for J.D. Edwards GL

Major support of Quantum Tax, human resources payroll, legal software, and tax audits

TECHNOLOGY CONSULTING CORPORATION, Waukesha, Wisconsin 1995-1997

Consultant

Placed at SC Johnson Wax for support of the Lawson Financial System.

ERP - Lawson financials - converted from a main frame system to Lawson

Changed software focus from ASI to Lawson

Added many billing hours for additional enhancements

Responsible for AR interface into Lawson

Acquisitions-developed template to convert customers into AR and order management system.

Model used extensively.

Implemented Robot Scheduling/reports to co-exist and to completely automate processing

Set up daily, weekly, monthly yearly and on request scheduling of all financial jobs

Using the tools - set up receiving of Emails or work station messaging

Created the distribution of 1,500 Statement of Expenses (SOE's)

Interfaces for Lawson Financials

GL Interfaces including stock transfers, payroll, IT hours and cost of goods.

Combined techniques into multiple interfaces including EDI, 820, ACH and BAI

BROAN MANUFACTURING, Hartford, Wisconsin 1988-1995

Major manufacturer of home ceiling and exhaust fans.

Senior Computer Programmer

Responsible for Finance and Order Processing

Full system conversion and training from custom mainframe system to AS400 ASI Cobol system

completed in nine months.

Changed the processing of the ‘capture-of-sales history’ report from 17 hours per week to 2 hours per

month, saving $60,000 per year.

Provided pertinent information to reduce audit time from 2 weeks to 3 days.

Developed on line-invoice system.

Designed and implemented complex sales commission system resulting in accurate reporting.

Volunteered to cross-train in forecasting, EDI, MPS, MRP to be backup in all areas. This resulted in

my being given more responsibilities.

Support of all financial systems, HR, customer service, forecasting and audits

EDUCATION

Madison Area Technical College, Madison, Wisconsin

Associate Degree in Computer Science, 1988

120 + credits towards Bachelor degree

OTHER RELEVANT TRAINING

Hyperion, 2002 and 2000 JDE, 2001 Cool 2E, 1998-1999 AS400

Cobol 1994 to present

Lawson, 1996-1997 ASI, 1994 AS400 RPG

1997 to present

PERSONAL ACHIEVEMENTS

Sexual Abuse Hotline, 2003-2004 Franksville Business Association, 2000-2005

Special Olympics, 2001 Kids Connection Community, 2000

Emergency Foster Parent, 1986-1988

Contact this candidate