PROFESSIONAL PROFILE

• 5 years experience designing, coding and supporting mission critical software applications in a manufacturing
• environment.
• Strong analytical skills, able to identify opportunities to improve the efficiency of business processes.
• Excellent knowledge of object-oriented programming principles and methods.
• Solid understanding of good database design principles, database administration and database performance tuning in
• a highly transactional environment.
• Highly skilled in writing and troubleshooting complex SQL queries and stored procedures.
• Working knowledge of TCP/IP networks and Microsoft Active Directory.
• Self-motivated with the ability to prioritize and meet deadlines.
• US resident, no sponsorship required.

SKILLS SUMMARY

• Programming Languages: VB.NET, Java, ActionScript3/Adobe Flex, Objective-C, PHP
• Database: Microsoft SQL Server, MySQL, Microsoft Access
• Reporting tools: Microsoft SSRS/Report Builder, Microsoft Access
• Web Technologies: HTML, CSS, Drupal 6 CMS, Apache 2, Apache Solr
• Version control: SVN, Mercurial
• Operating systems: Windows Server 2003/2008, Windows XP/Vista/7,Mac OS X
• EDI: 850, 810, 816, 860, 856, 997, Gentran: Director, Gentran Integration Suite/AS2
• ERP: Macola Progression

WORK EXPERIENCE

Systems Analyst/Director of IT – Confidential 2008 – Present

• Lead the development of new software applications to support business growth objectives and improve process efficiency.
• Replaced existing, out-of-the-box production management software on the production floor with a custom, in-house designed and developed software solution.
• Designed database structure to store transaction data gathered from production stations using Microsoft SQL Server.
• Developed stored procedures and queries to transform and import data from existing software on a nightly basis.
• Designed and developed software for each station in the production process using VB.NET.
• Implemented order prioritization system based on order due date, order attributes, inventory availability and shipping schedule to increase on time delivery of product from 75% to 98%.
• Increased shop floor efficiency by up to 30%.
• Implemented e-mail based automated order status query system for retail clients to reduce helpdesk calls by 90%.
• Developed reports using Microsoft SSRS/Report Builder to provide production managers with unprecedented insight into every aspect of the manufacturing process.
• Designed, coded and implemented production management software for Timeless Frames to replace existing paper-based system.
• Designed database structure to store transaction data gathered from production stations using Microsoft SQL Server.
• Designed and developed software for each station in the production process using VB.NET.
• Eliminated all manual data input, reducing labor costs.
• Designed, coded and implemented Timeless Expressions website to support the company objective of being able to sell product online.
• Developed Timeless Expressions website using Drupal 6 CRM.
• Developed online tools allowing customers to create custom frames, custom photo books, custom calendars and custom photo gifts online using Adobe Flex.
• Developed backend photo processing software to convert customer orders into high quality, ready to print PDF files.
• Integrated custom production management software data into existing Macola Progression ERP software for inventory tracking purposes.
• Developed stored procedures and reports as needed to enhance existing Macola Progression ERP software functionality and support business growth.
• Interacted with managers, production supervisors and end users to define, schedule and implement new features and reports as needed.
• Served as primary point of contact for implementation of new and troubleshooting of existing EDI implementations using
• Gentran Director and Sterling Integrator AS2.
• Developed data transformation scripts and programs to ensure EDI compliance and compatibility with existing systems.
• Created and maintained disaster recovery plan
• Ensured 100% uptime of all critical IT systems and backup integrity.
• Directed and manage work assignments and priorities for the IT team.
• Responsible for managing IT vendor relationships and IT budget and purchases.

Systems administrator – Confidential 2007 – 2008

• Implemented and maintained Active Directory forest and group policies.
• Extended Ethernet lines as needed throughout facility to support addition of new stations and management users.
• Configured and installed Windows-based workstations for production and management users.
• Configured and maintained Cisco network infrastructure (VLANs, EIGRP, access lists)
• Maintained accurate network documentation.
• Monitored server health using Hyperic HQ and installed patches and software upgrades.
• Performed after hours server maintenance on a monthly basis.
• Maintained network security.

EDUCATION

• Confidential High School, – Assistant software developer.
• Confidential University – Systems analyst (2 years).
• Cisco CCNA