We provide IT Staff Augmentation Services!

Systems Analyst Resume

Crystal Lake, IL

SUMMARY

Recent SMIS graduate with 15 years of experience in various manufacturing environments focusing on the relationship between physical activities and recording that data into the various systems used in manufacturing today. Looking for a challenging career centered more around the information systems and programming side of the business. Motivated, personable business professional with technical skills to improve communication and work flow. Talent for identifying and eliminating waste in processes. Diplomatic and tactful with professionals at all levels of the organization. Accustomed to handling sensitive, confidential records. Demonstrated history of improving scheduling processes to support sales while reducing inventory levels through optimization of ERP systems and customization where necessary.

Flexible and versatile - able to maintain a sense of humor under pressure. Poised and competent with demonstrated ability to easily transcend cultural differences. Thrive in deadline-driven environments. Excellent team-building skills.

SKILLS SUMMARY

  • Microsoft Office Suite
  • Project Management
  • ERP/MRP Systems
  • VBA Programming
  • SQL Administration
  • Lean Manufacturing
  • Crystal Reports
  • J.D. Edwards
  • Report Preperation
  • Inventory Control
  • Scheduling
  • Capacity Planning
  • SSRS
  • Six Sigma Green Belt
  • AS/400 RPG
  • JobBoss
  • Purchasing
  • ISO qualified processes
  • Front-Office Operations
  • Professional Presentations
  • JavaScript
  • New System Development
  • BPCS / KRONOS

PROFESSIONAL EXPERIENCE

Confidential - Crystal Lake, IL
Programmer / Systems Analyst

Information Technology Experience Windows 2003 and 2008 Server

  • Active Directory
  • SQL Database administration
  • Event Manager (SQL Trigger software)
  • Training of all levels of organization in new technology and system requirements
  • Stand alone database development
  • Programmed stand alone ECR/ECN database with secure logins and email alerts
  • Programmed scheduling database to track work load hours to available hours
  • Programmed executive dashboard to track daily build, sales, inventory, load, and backlog
  • Development of a robust quality system with actionable alerts and approval verifications
  • Inventory reports in MS Excel that identified consumed and unconsumed inventory, R&D levels, customer returns, Forecasted inventory, by product type and customer
  • Master schedule by work center in MS Excel that looks out 12 weeks of scheduled and planned production to visualize capacity, bottlenecks, and overtime risks.
  • Actively woked with production to improve throughput, reduce lead-times and increase on time delivery
  • Automation of SQL stored procedures to aid in repetitious manual activities
  • Relational Queries across a number of system platforms (AS/400 to SQL to Access to Excel for analysis)

Scheduling/ planning/ purchasing / inventory control

  • Managing system driven planning parameters to make/buy what is needed when it’s needed
  • Scheduling manufacturing work centers for early detection of bottlenecks and improved throughput
  • Procurment of long lead raw material with follow-up for timely delivery
  • Analysis of the entire production schedule from raw material to assembly of finished product including out of plant sourcing..
  • Improvement in on time delivery and reduction in overtime expenses by accurate manual capacity planning.
  • Reduction of inventory levels by analyzing supply and demand and adjusting planning parameters to better suite the needs of production and service parts.
  • Run out inventory analysis for replacement model launch to reduce unconsumed inventory
  • Understanding of consumed and unconcumed (slow moving) inventory and experience in reducing and eliminating the growth of aged and obsolete inventory projects and teams
  • Member and leader of project teams
  • New ERP Implementation Project Leader.
  • Quality Improvement Team member
  • Process Improvement Team leader
  • Customer Satisfaction Improvement Team leader

Hire Now