Epicor ERP administration and IT administration.

Administered maintained and upgraded Epicor ERP system for manufacturing company. Built customizations and integrations as needed to achieve company goals.• Led ERP version upgrade implementation projects, leveraging vendor improvements to maintain state-of-the-art performance.o Created project plans and presented to management team.o Interfaced with consultant team and led SME stakeholders’ team.o Performed data conversion and validation and led acceptance testing.o Customized reporting in SSRS and Crystal Reportso Tracked issues to resolution.• Administered n-tier servers in VMWare including MS SQL server, customized Crystal and SSRS reports, automated ERP backup. Analyzed business processes and created custom BAQs and dashboards providing reliable real-time information.• Developed and delivered ETL queries for ERP data migration from Epicor to IFS, delivering static and transactional data for stakeholder validation and successful system migration.• Attained >99.95 up-time on 5x12 work-hour standard by customizing and maintaining ERP system with periodic patches.

Managed IT department through company transformation from manufacturer to North American service provider.• Greatly improved infrastructure robustness and security by migrating to physically secured server room, performing VMWare server virtualization and effecting ITSM incident tracking.• Designed and launched web-based client order entry system, integrated with ERP-SRM and built workflow automation for order-fulfillment-invoice process, reducing process man-hours by 70% and saving > $0.5M/year.• Achieved compliance and audit certification under Sarbanes-Oxley Act by devising and implementing ISACA framework procedures.• Managed implementation of Microsoft Dynamics ERP in external datacenter, supporting creation of Chinese subsidiary.