SKILL:

TransactSQL 12 years: Develop SQL scripts, Stored Procedures, View, Function, Loop, Cursor Data Engineering, Data Warehousing, Data Analysis, Data Visualization.

Microsoft SQL Server 20052012: 10 years - install, configure, support, upgrade and backup.

Microsoft SSRS 7 years: Report design and development.

Microsoft SSIS 3 year: ETL, data integration and scheduled data synchronization

Infor SyteLine ERP 8 years: ERP install, maintenance, support, update, upgrade.

Sage MAS 200 ERP 6 years: ERP install, maintenance, support, update, upgrade.

Crystal Reports 13 years: Report design, develop, deploy.

Visual Basics 7 years: VB script in Confidential ERP software, MS Access and Excel.

Microsoft Servers administration 2003, 2008, 2012: 15 years - Install, configure and upgrade.

Microsoft Exchange administration 2003, 2007: 13 years Install, configure and upgrade, VMWare 6.5 VSphere multiple VM administration - 3 year, Joomla, Shopify Web Content Mgmt with MySQL Database and PhpMyAdmin, HTML - 6 years

HTML: 12 years Website modification and content change

Ruby on Rails: 1 year Website modification and content change

Linux administration: 1 year CentOS, RedHat Linux server install and configuration

VoIP management and setup: 1 year VoIP Linux based server install and configuration, Familiar with accounting AP/AR/GL/Inventory/Purchasing/Bill of Material/Work Order functions

WORK EXPERIENCE:

Confidential

Director of IT

Responsibilities:

• Consolidate Data between ERP (3 separate company entities), WMS and other external data. (tax rate, UPS/Fedex cost, UPC code, forecast).
• Create custom data set with specific dimensions for faster user data needs, such as dashboard, executive daily reports, availability, inventory, aging, forecast, demand expense reports.
• Maintain and support Sage MAS200 4.4 ERP system, ROI InSynch data synchronization, and MS SQL 2012 Server, and 7 Microsoft 2008 and 2012 servers.
• Coordinate and support data synchronization between Distribution Warehouse Management System and Sage MAS200 (linking two SQL servers in East to West Coast locations)
• Database Synchronization between Sage MAS200 and SQL Server with SSIS (Data Warehousing)
• Create SQL Database and data synchronization from MAS200 database through SSIS for faster data analysis and reporting. (ETL)
• Create T-SQL queries, functions, jobs and stored procedures in MS SQL server for data synchronization, reporting, and update, insert, and delete queries. (Data Visualization)
• Work closely with management and multiple departments to produce Daily Sales report and inventory control data and variety of reports; assisting with inventory cycle count.
• Create Automated VI Jobs and T-SQL scripts to import and export large amount of data up to 5 million records and data synchronization between MS SQL and MAS200 via SSIS.
• Oversee day to day IT operations, network security, VPN setup, Webroot antivirus, LogMeIn network monitor, ransomware troubleshooting, and user support for three offices.

Confidential

Database / ERP / Network Admin

Responsibilities:

• Install, maintain, and modify Confidential ERP system modules including Customer Service, Purchasing, Inventory Management, Accounts Payable, Accounts Receivable, Bill of Materials, Production Scheduling and Planning, Quality Assurance, General Ledger, HR, Data Collection.
• Develop T-SQL select, update, insert, delete, Cursor queries for SyteLine ERP software or data change including Transact SQL
• Generate Weekly Production Reports for managements including Sales Booking, On-time Delivery, Vendor Performance, Manufacturing Efficiency and Resource Utilization using SQL Studio, SSRS, Excel. (Data Visualization)
• Analyze needs of all departments and enhance their business process by developing and modifying Confidential ERP software forms, features and programming to enhance usability.
• Design and Automate reports and email alerts for Sales, Production, Accounting with SQL Studio, SSRS, Excel and Crystal Report.
• Analyze, develop, and modify tables, stored procedures, views to enhance Confidential ERP usability and Reporting needs with use of Cursor, temp table, and variables.
• Develop daily flash report and periodic reports for management on sales, shipping, production.
• Develop MS SQL daily jobs for database and Confidential ERP optimization.and monitoring.
• Develop Access Databases for Engineering Nomenclature, Maintenance, QA and Tooling.
• Maintain Copy of SQL database for testing of patch update, version upgrade, and modification.
• Configure security on SQL Server database, Active Directory, MS Exchange, network shares.
• Joomla website content management on Rackspace.com cloud CentOS Linux server MySQL
• Encrypting all engineering drawings with Microsoft and Adobe Acrobat.
• Automated windows scripts for time synchronization, data file organization and cleanup.
• Liaison to SyteLine ERP, VoIP, Engineering and Manufacturing software, and other IT vendors
• AS9100:2009 Rev C Internal Auditing Certified and carried out internal audit.
• Support 5 server, network infrastructure, 50 workstations, and VoIP phone system.

Confidential

IT Manager

Responsibilities:

• Work closely with management for reporting and data requests; install configure and maintain Sage MAS 200 ERP system; report developments with Crystal Reports, MS Access and Excel.
• Install, configure and maintain,server, network infrastructure and workstations.
• EDI support and data troubleshooting to Walmart, Costco and other retailers.