IT MANAGER / System Administrator

SUMMARY

I am an Information Systems and Manufacturing Professional, seeking a position as a System Administrator. With over 25 years of Information Technology experience .I have held the positions of MIS Liaison, DBA, Business Analyst, Network Administrator and as an Information Technology Manager. Amongst My most recent responsibilities as an IT Manager were monitoring and enhancing an ERP system (Vantage6.10 by Epicor). Prepare and manage the migration to Vantage 8.0. Serving as the DBA for SQL Server databases, establishing ODBC connection and ad hoc report writing using MS ACCESS and Crystal Reports, Disaster Recover, VPN Management, Migration from Exchange 5 to Exchange 2003, daily weekly and monthly backups using Veritas backup software, System upgrades from Windows 2000 server to windows 2003 server I was also responsible for maintaining the System Firewall using Checkpoint. I acted as the single point of contact for all network related issues responding to system and user problems. My Administrative Network responsibilities included but were not limited to DNS server maintenance, Active Directory, new user accounts, security monitoring, Group Policies, DHCP.

Having held various positions in different capacities in my 25 years in Information Technology, I have the ability to connect technology to business applications in a cost effective and efficient manner.

Key word descriptors of background and focus include:

Data Warehousing Systems Interface Report Design Veritas Backup Software Pricing Customer Service Performance Improvement Novell Certification Cognos Data Base MSQuery Crystal Reports Quality Systems EDI ODBC Oracle A+ MCSE Microsoft Office DNS DHCP Active Directory

Group Policies Distributed File systems Remote Access VPN Firewall Cisco Routers

Network Infrastructure Local and Network Security Manage2000 by Epicor Vista / Vantage by Epicor Questys Document Management

See my profile on LinkedIn http://www.linkedin.com/in/dramirez2

EXPERIENCE

BTL Machine March 2008 – Sept. 2008

Network Administrator / Analyst

Major responsibilities are: Maintain and enhance the current ERP system, Vantage 6.10 by Epicor. Prepare for migration to Vantage 8. Acted as Liaison between to Epicor for updates, patches and troubleshooting purposes. Decreased response time for trouble tickets from 10 days to 2 days. On call and available 24/7 for network monitoring and emergency response. Understanding business and system flow. Primary contact for all database related questions. System security. Create Procedures and maintain documentation and Disaster Recovery documentation. All system administrative functions. Assist users daily in improving the computing environment. Ad-hoc report writing and database development Using Crystal Reports Progress, Access, Excel and SQL Server. Verify daily backup and review system logs. Maintain SW/HW inventory. Monitor and maintain a network of servers and PC’s consisting of Windows XP operating systems. Participate in quarterly and annual audits. Document and implement system upgrades. Install update and maintain various Manufacturing programs such as Kubotek, Multi-DNC, Master Cam and Vericut.

Ceradyne Inc. July 2006 – Dec 2007

Sr. Business Systems Analyst

Plan and direct analysis of complex business problems to be solved with automated systems.

Provide backup support to existing staff for help desk support.

Improve the effective use of information technology by educating employees on the functionality of the systems and report writing.

Actively support upgrades.

Acted as Liaison between to Epicor for updates, patches and troubleshooting purposes. Decreased response time for trouble tickets from12 days to 3 days.

Understand requirements and develop reports from data warehouse.

Understand the IT infrastructure and provide day to day support

Fundamental understanding of database structures and using tools necessary to extract information from these structures.

Western Methods Santa Ana Ca Oct 2004 – April 2006

Network Administrator / Analyst

Major responsibilities are: Maintain and enhance the current Database system (Vista by Epicor). Understanding business and system flow. Primary contact for all database related questions. System security. Create Procedures and maintain documentation and Disaster Recovery documentation Using Veritas 9.1. All system administrative functions. Assist users daily in improving the computing environment. Ad-hoc report writing and database development Using Crystal Reports and Access, Excel and SQL Server. Verify daily backup and review system logs. Maintain SW/HW inventory. Monitor and maintain a network of servers and PC’s consisting of Windows NT, Windows 2000 and Windows XP operating systems. Participate in quarterly and annual audits. Document and implement system upgrades. Implemented a Data Management System by Questys as well as preparing to update our ERP system to Vantage by Epicor. Acted as Liaison between to Epicor for updates, patches and troubleshooting purposes.

Dram Services 2002 - 2004

Desktop Consultant

Install repair and modify Personal Computers and West Coast Consultant for Connecticut based Cortland Associates. Including installation repair and trouble shooting of the software installations on the west coast.

Web Development

Created and am currently maintaining www.paradisefntns.com

Parker Hannifin Customer Support 1994 – 2002

Senior Analyst

Responsible for establishing spare parts prices and price repair jobs utilizing a number of databases (Paradox, Access, SQL)to produce accurate and up to date information.

Responsible for maintaining the same data bases with accurate and current data acquired from an IBM Main Frame and SQL databases.

Using various report writers, generated reports on an as need basis, for Contracts Administrators. Marketing Managers and Business Unit Managers.

Acquired the data for the reports from an IBM Main Frame, SQL Server and Local Databases both Access and Corel Paradox.

Utilized MSQuery to extract data to Excel, Access and wrote queries in Corel Paradox and Cognos Impromptu in creating accurate status reports to communicate to customers.

Using Excel I generated Risk analysis reports for future and ongoing Fleet assessments

Partnered in Data Warehouse Database design using MS. SQL6, SQL7 and report writing using Crystal Reports, MS Excel, MS Access, MS Word, and Cognos Impromptu for end-users. Also participated in Cognos Administration

Produced significant enhancements to the Spec2000 Automated Order Processing System that reduced hands on requirements by 50%.

Responsible for all RFP/RFQ requests

Actively participated in user training for Lotus Notes

Parker Hannifin Customer Support 1984 – 1994

Information Systems Manager

Parker Hannifin Customer Support 1977 - 1984

Production Control Manager

EDUCATION

General Education, Rancho Santiago College

College of Information Technology

CERTIFICATIONS

SQL2000 pending

Oracle 8i pending

Oracle 9i pending

APICS

Inventory Control, Capacity Planning and Production Activity Control

NOVELL

Service and Support, 2.2 System Manager, 2.2-Advanced System Manager

Cognos Data Base Management

Impromptu Administration 4.0

Proficient in: MS Word, Excel, Access, Query, SQL Server, Corel Paradox Database Manager, Data Warehouse Management, Oracle Database Management

Supervisory skills include: production, planning, master scheduling, inventory control, shop floor control, electro-mechanical and hydro-mechanical.

Contact this candidate