SYSPRO and Financial Consultant
Resume:
Richard A. Helm
Pembroke Pines, FL 32738
**************@*****.***
The first part of my career was spent in Management Accounting and IT working with the various management teams, assisting them in stabilizing their financial position, and then providing them with the necessary analysis of their operations to help in sound management decisions that resulted in solid growth. For the past 15 years I have been more heavily involved in IT/Finance with the ERP SYRPO package. I was able to capitalize on my prior Process Flow experience, understanding of audit trail, Team approach, and understanding of Separation of Duties in overlaying the client's business flows into the various modules, assisting in implementations over a six month time period, designing financial reports via SYSPRO, Crystal, Access, and excel. After a time with a SYSPRO VAR, I ventured out on my own helping various companies take advantage of all SYSPRO had to offer. In addition to consulting I also did several stints as a SYSPRO Administrator which also gave me more clarity/understanding on the package as I was actually using it and was assisting users (at all levels) when they would encounter issues (for whatever reason). So I now possess the understanding of both the theory and the practice behind SYSPRO. With the advent of SYSPRO 7 I have had to alter my normal update procedures to encompass a Test Environment prior to bringing the new Ports into the Production model of SYSPRO.
Some of my accomplishments have been:
1- Converted antique network to a Pentium network via Novel and Microsoft Back Office SBS
2- Enhanced financial reporting from a simple current period and year to date set of statements to a more meaningful prior year, current budget, and year to date comparisons (including gross profit comparisons).
3- Designed (in-house) Association Mgmt System for 8 K rather than buy limited outside product for 25 K
4- Instituted online banking procedures resulting in enhanced investment income, liquidity, and simplified use
5- Developed the budgeting process into a short, efficient one-day process instead of a week ordeal
6- In one case, Implemented and went live with SSYSPRO in less than two months while responsible for two additional projects. This was largely due to strong dedicated interaction with the client team and myself.
7- Designed the only known EVMS Application in SYSPRO
8- Developed Knowledge Bases replete with SYSPRO Tutorials and Step by Step Operational Instructions
9- Designed G/L Flash report combining Balance sheet Ratios, P /L Rations, Turns multi-year Balance Sheet Summary, and Multi-year P/L Summary in one report via real-time SYSPRO Data
10- Have handled time clock data import-conversion into ABRA payroll for clients who use ABRA with SYSPRO for their payroll needs.
11- Completed a fulfillment system so WMG could handle Toyota North America and Toyota Canada sales
12- Use of SQL CTE's in Excel to allow Accounting to reconcile a sub ledger to the General Ledger in 15 minutes instead of hours (allowing the Accounting department to spend more time in analysis of Operations).
Richard Helm
8930 NW 8th St
Pembroke Pines, FL 33024
**************@*****.***
Objective
Assist firms in getting their SYPRO house in order, establish a strong training regimen,
keep their SYSPRO up to date, and assist in IT infrastructure Improvements.
Profile
• Experienced Financial and IT Professional with well-proven problem solving and growth
record.
•Comfortable working under pressure and handling emergency situations.
•Self motivated, focused; comfortable working independently or as part of an
integrated team.
•Proficient in Access, SYSPRO, Word, Excel, SQL, most accounting packages and
software integration.
Experience
2.0+ Years of SQL Code Generation including CTE's
5.0 Direct MFG IT/SYSPRO administration with a mid-sized firms
15+ Years of IT Analysis & Design, Implementation, Instruction, and Administration
20+ Years of Hands on Experience in Accounts Receivable, Accounts Payable, General
Ledger, and Payroll (QuickBooks Pro, Real World, and other packages)
20+ Years of Financial Statement Preparation, Financial Statement Analysis, Financial Modeling, & Financial Statement Reporting
10+ Years of Supervisor Experience
20+ Years of Job Costing and Activity Based Accounting Experience
20+ Years of Budget Preparation, Budget Analysis, and Budget Reporting
15+ Years of Cash Management, setting Investment Policies, and Handling Investment
Portfolios
5+ Years of Grant Accounting and Grant Preparations
10+ Years of New Product and Operational Analyses
20+ Years of Audit Liaison Work & Handling External Corporate Relationships i.e.
Banking, Insurance, etc)
15+ Years of Hardware and Software System Conversions and Network Administration
15+ Years of IT Management, IT Design, IT Systems Analysis, Various
Programming Chores (data base & Spreadsheets), Systems Instruction, Support, &
Implementation, assist in sales demonstrations as necessary
9+ Years of Corporate Board Experience as Vice Chair of Operations Committee
9+ Years of Board Experience for a Non-Profit Foundation (including its inception)
10+ Years of Small Business Financial and IT Consulting Work
9+ Years of Assisting with Meeting Planning, Seminar Management, and Trade Show
Management
Work History
AAR CORP July2015 to Feb 2017
IT Development, SYSPRO Administrator, Accounting Support
WMG May 2010 to 2013
IT Manager, SYSPRO Administrator, Systems Analyst
Lonehill Systems Nov 2004 to Aug 2007
SYSPRO Instructor, Administrator, Engineer, Analyst, Programmer, Implementation
Specialist, and Reporting Artist (conventional and ODBC)
RJH Holdings Oct 2001 to Present
Owner
International Project Development in Concert with Sandford Technologies in England
Implementation/Support of Small to Medium Businesses with SYSPRO Software
American Bronze Foundry Aug 2002-March 2004
System Engineer & Assistant to Foundry Mgr
Responsible for design, implementation, & maintenance of mfg system (starting from
scratch & operational in less than 4 months)
Contract Work, South Carolina and Florida, USA 2001-2002
Upper Level Accounting/Corporate Revitalization
Ohio Grocers Association & Affiliates, Columbus, OH, US 1991-2001
Controller/Sec'y/Treasurer/IT Manager
Ohio Electrical Contracting, Columbus, Oh, US 1990-1992
Controller
Friends of the Homeless, Columbus, OH, US 1989-1990
Fiscal Manager
Merit Electrical Contracting, Columbus, OH, US 1987-1990
Controller & System Consultant
Self-Employed, Columbus, OH, US 1981-1987
Owner/Operator providing Financial System Design/Support
Sandefur Companies, Columbus, OH, US 1977-1981
Senior Accountant
Education
Kent State University, Kent, OH, US
Accounting,
Spent three years with a minor in Sociology
Contact this candidate