Laura A. Sugg
Bartlett, TN **135
abky3m@r.postjobfree.com
[pic]
Dedicated IT professional with excellent data reporting, analysis,
accounting and business intelligence experience.
[pic]
Professional Summary:
. Created reports and provided system functionality to end users to
access data that was needed on a daily basis, reducing daily
dependency on independent contractor
. Streamlined table import process for price increases, providing sales
staff with current price increases in less than 8 hours, previously
price increases were taking up to 2 weeks
. Created an intranet site for employees, allowing easy access to
process documentation, to provide them with additional resources to
assist them in their daily work routines
. Perform Business Analysis and prepare supporting documentation
. Data Import/Export, Migration
. Automated the transfer of sales orders to invoices, saving the A/R
department 4 hours daily
[pic]
Technical Summary:
. Data reporting in SQL while gathering data from multiple systems
. ETL and DTS applications - SQL 2000 and SQL 2005
. Excellent technical and analytical skills with clear understanding of
design goals for ERP applications
. Designed and implemented role based security for ERP users,
controlling access of users to specific areas of the accounting
package
. Consulted with users to create process documentation, as well as
assisting with automation of any and all functions allowed by
technology
. Intermediate knowledge of: HTML, CSS, Perl
[pic]
Software and Environments:
. Dynamics (Great Plains) 6.0 - 10
. Crystal Reports
. Microsoft Office Suites (2003 & 2007)
. Visual Studio 2008
. Windows XP
. SQL Query 2000 & 2005
. Numara Track-IT! 8.0
. Backup Exec 12.5
. Active Directory
. ADP
[pic]
Education and Training:
. Southwest Tennessee Community College
- Seeking degree in Application Development and Programming
(GPA - 3.4)
. New Horizons Memphis
- Seeking MCTS - Business Intelligence and Maintenance
. CEU Classes: SQL query Level 1 and Level 2, Crystal Reports Level 1
[pic]
Laura A. Sugg (Continued)
pg 2 of 3
[pic]
Experience:
. System Analyst - Power Equipment Company - Memphis, TN - 07/2009 -
05/2010
- Analyze and evaluate present and proposed business
procedures or problems to define data processing needs
- End user testing for upgrade and software modifications
- Interview workers, observe job performance and/or perform
the job in order to determine what information is processed
and how it is processed to assist in streamlining business
processes
- Trained users on PC operation and applications - Great
Plains and Microsoft Office
- Provided data queries to management and staff according to
request
- Network maintenance - Active Directory, data backups and
security
. Business Analyst - Kele, Inc. - Memphis, TN - 04/2007 - 11/2008
- Installed, monitored, and maintained Help Desk (Numara
Track-IT) software
- Configured, deployed, and thoroughly tested new Sales Tax
calculation software
- Developed user and system documentation for new processes
- Supported Accounting, Purchasing, and Payroll department on
Great Plains 7.5 & 9.0 software
- SQL table updates and queries as requested by departments
. Insurance Auditor - Millennium / Langer - 07/2005 - 04/2007
- Audit services for client's customers to determine payroll
and / or sales exposure to assist in determining policy
premiums for Work Comp and GL policies
- Collect data from payroll and general ledger accounts, and
validated back to tax records
- Functional knowledge of NCCI Workers Compensation and ISO
General Liability rules, manuals and industry practices
. Office Manager / Field Supervisor / Auditor - Overland Solutions -
Memphis, TN - 10/2001 - 07/2005
- Hire and train office staff
- A/P, A/R, Payroll, IT Support for field staff
- Managed office staff and 15 field auditors
- Assisted with manpower analysis and budget reports for
management
. Assistant Payroll Manager - GateGourmet - Memphis, TN - 09/2000 -
04/2001
- Supervised eight payroll specialist who were responsible
for a 11,000 employee payroll
- Created Excel spreadsheets to assist specialist and saving
them processing time for calculations
- Monthly G/L reconciliations and journal entries
- Quarterly 941's, State taxes and year end 940's and W2
processing
- Garnishment and child support processing
. Payroll Supervisor - EUSA Management - Memphis, TN - 04/1999 - 04/2001
- Multi -state payroll for 12 locations
- Back-up for A/R and A/P
- Journal Entries
- Taxes
. Payroll Supervisor - D. Canale - Memphis, TN - 06/1993 - 04/1999
- Weekly and Semi monthly payroll and bonus processing
- Section 125 plan administration as well as 401k benefits
- Bank reconciliation
- Drug test administration and monitoring
- Accounting period closes - work papers, accruals and
journal entries
[pic]Laura A. Sugg (Continued)
pg 3 of 3
[pic]
Additional Qualifications:
. Project Management : Team Building & Leadership
. Excellent oral and written communication skills
. Proven ability to reach goals
. Strong organizational, problem solving and analytical skills
. Application process documentation
. Accounting background
. Excel - Pivot Tables, VLOOKUP, Charts
. Excellent customer service skills
[pic]
Outstanding professional and personal references, available upon request.