Tyler Liggett B.Sc

OBJECTIVE
A position in Web Administration and/or Database Administration. With a growing company that will take advantage of my experience in IT and Operations allowing me to contribute as a team member or leader facing challenges in day to day operations as well as tactical and strategic projects.

 

 

 

FUNCTIONAL SUMMARY
Professional Database Administrator with strong skills developed over 15 years in data base design, financial and operational analysis and ad hoc report preparation. Experienced in system administration. Solid background in Distribution and Warehousing Operations. Responsible for multiple, successful project management with emphasis on achieving the highest possible standards in system stability and availability, XML integration using DBMS tools for high efficiency and development of relational database models.

 
AREAS OF EXPERTISE

• Budget Management Database Design Strong Communicator
• Project Management DB2 and SQL Problem Solving
• Attention to Detail Multi-tasking Change Management
• System Load Balancing AS/400 "I"-OS/400 ODBC
• Data Warehousing HTML System Security
• DBA / .Net Web development Disaster Recovery Experienced Manager
• WMS (Warehouse Management Systems) TMS (Transportation Management Systems)

KEY HIGHLIGHTS

• Managed $300k budget for project to replace ERP on three occasions
• Used LPAR for system load balancing on AS/400
• Managed DASD utilization and RAID 6 for data integrity and recovery from disk failures
• Developed and led design and implementation of WMS system resulting in an increase of gross profit of 2%. System increased accuracy of order fulfillment and increased accuracy of inventory counts.
• Design of data warehouse using AS/400 relational database structures.
• Interfaced with C level management to develop strategic directions for the enterprise.
• Communicated with developers and end users in designing efficient user interfaces and tools to provide critical tactical information for day to day operations.
  

TECHNICAL EDUCATION

• North Hennepin Community College - Brooklyn Park, Minnesota
• Web Design / Data Base Administrator Certificate
• MCSE (1999)
• Windows NT 4.0 Server, TCP-IP, Exchange 5.5

University of Washington

• Warehousing practices and operations
  

IBM Training

• AS/400 Operations and Administration
• AS/400 Externally defined data base structure.
• Query 400
• PC Support, 5250 terminal emulation, printer support
• Disaster recovery for AS/400 and IT operations
• SDLC (Synchronous Data Link Control)
• Data transfer between AS400 and SQL type data structures (DTS)
• WAF and IPDS Imaging and Workflow functions
• EDI Packet structures and flat file transfers
• R/F terminal 5250 emulation
• Data base design, analysis and optimization

 

EDUCATION

Moorhead State University - Moorhead, MinnesotaBachelor of Science - Education

• GPA (3.7)
• Graduated with honors, Magna Cum Laude

WORK EXPERIENCE

Inventory Control Manager - Central Power Distributors - Anoka, Minnesota  2008 - 2008
Responsible for maintaining inventory of 37,000 skus for distribution centers in Anoka, MN, Menomonee, WI and Dayton, OH. Assigned project to interface AS/400 "i" series database (DB2 and OS400) with Microsoft Office products including Excel, Access, Query (SQL) and Word. The purpose of the project was to develop tools to make the ordering process more efficient, provide more accurate forecasts, generate suggested order quantities and process purchase orders.

• Accomplishments
  Implemented SQL to retrieve reorder information from ERP (DMAS, AS/400) in order to streamline reorder quantity calculations
  Demonstrated track record for achieving goals in a team environment.

 Freight Broker Agent / Owner - Golden Ridge Enterprises, LLC - Saint Helens, Oregon   2005 - 2007
Started my own business as a freight broker agent working under the authority and through a brokerage firm out of Medford, OR called "InTransit" (InTransit has since become a part of UTI.) My work consisted of finding shippers, customers, that needed freight moved and find or have in place a carrier to pickup and deliver the freight at a negotiated price. I concentrated on temperature controlled shipping moving truck loads throughout the 48 states, Canada and Mexico. I moved freight by truck, rail and container.

Accomplishments

• Achieved largest annual gross sales percentage growth in InTransit history during the first six months of operations.
• Specialized in Truck Load temperature controlled shipments throughout the lower 48 states and Canada.
• Expanded into Less than Load temperature controlled shipments for processors and retail outlets.

 

Director of IT, H/R and Transportation - Western Boxed Meat Dist. - Portland, Oregon 1988 to 2005
Began as controller and quickly found myself wearing many "hats" in a fast growing business. I was responsible for the purchase, design and installation of three ERP systems and numerous enhancements as we modified the original distribution software to fit our changing needs. I developed H/R policies and procedures and wrote two employee manuals. Took over general management of the transportation department which consisted of 30 tractor-trailer units, about 40 employees and a half a doze contract carriers. Turned the department into a profit center by hiring freight brokers in 1993 in order to supplement delivery and backhauls which generated income to off set the cost of delivering company products. Designed and implemented WMS, TMS, H/R, financial and operation reports. I as ery much involved in operations in all departments except sales.

Accomplishments

• Four direct reports with responsibilities in Human Resources, Logistics, Fleet Management, IT Projects and Administration. Total responsibilities for approximately 75 employees.
• Worked to maintain a cooperative, team-oriented environment between direct labor and management.
• Project manager for construction, SOP rollouts, benefit changes and enrollment, union activities and any IT related initiatives.
• Responsible for the accuracy of all financial reporting and ERP system controls on AS/400 platforms ranging from "B" series to "i" series hardware.
• Maintained database structures including optical storage and indexing services.
• Tools for report generation included Query 400, ODBC, SQL, MS Query, MS Access, MS Word and proprietary software that I designed and contracted to programmers in RPG III, Visual Basic and AS/400 scripting.

References are available on request or may be found with other detailed information at my web site http://TLiggett.web.officelive.com.

 

Contact Information: Phone: 763-427-6079    EMail: tyligt@gmail.com

 

 

Tyler Liggett Professional Web Site
Detailed information on my abilities, accomplishments and future goals.