Business/Systems Analysis and Design, Programming, Testing
Process Analysis and Redesign
Change Management Analysis
Credit, Billing, Inventory Analysis
Warehouse Operations, Supplies Procurement
Forecasting Inventory, Sales Budgets
06/2012 to 04/2015
Database and Systems AdministratorHop Industries Corporation － Lyndhurst, New Jersey
Radio Beacon WMS (Warehouse Management System) servers, Infor FACTS (Distribution ERP) server, MS SQL Servers.
Warehouse supplies procurement, supplier negotiations and inventory management,.
Programmed new modules, modified Import Shipping program in Visual Basic 6 including system analysis and design, new features and reports, corrected and improved program functions.
Conducted system analysis and redesign for existing Slitting, Sheeting and Guillotine Machine Program, coordinated with outside programmer.
Spearheaded Internet Bandwidth and Phone Upgrade: Needs analysis, provider research, price negotiations, coordinated provider/management meetings and communications, contract negotiations.
Created IT Policy and Procedure Manuals for the Credit, Billing, and IT Departments.
Created Access Programs for Sales Forecasting (Dept3), Credit Department.
Coordinated with Outsourced technicians on Virtualization of Company servers (price negotiations, testing and server migration, rollout, troubleshooting) - windows 2000, SCO Unix, windows 2005, windows 2008.
Maintained/Troubleshoot, updated, upgraded server softwares, network equipments, company workstations, warehouse inventory hardwares, printers, copiers, audio visual equipments, phones.
Installed and implemented helpdesk support system (Spiceworks).
Trained on Credit and Billing operations, Inventory System, International and Truck Shipping Operations.
Evaluated and Approved credit worthiness of new and old customers for sizeable sales orders, manufacturer orders, contacted and collected past due invoices from customers.
Shipping: Scheduled truck shipments originating from instate and out of state warehouses, prepared customs documentation for Canadian shipments.
Checked and approved company reports prior to release to management - Cost differential, daily/monthly/quarterly/yearly sales, multiple warehouse inventory, outstanding invoices,.
10/2008 to 06/2012
Database AdministratorAffinity Home Care, LLC － Roseville, MI
Ensured back-end and front-end organization of data for better accessibility of end users.
Provided Troubleshooting, system backups, archiving, and disaster recovery plans.
Provided direct administration, improvement and maintenance of the company's IT infrastructure (computer hardware, software and network equipments).
Built and maintained vendor relationships and managed purchase of hardware and software products.
Implemented network security and connectivity, internet access, email, etc.
Controlled access permissions and privileges for all users.
Identified and provided standards for gathering information for use in trend analysis and reports information to company management to improve and facilitate operations.
Trained personnel of all levels on use of Healthcare Assistant (information system supporting financial, administrative and clinical functions).
Managed claim accounts receivables, also worked directly with Chief Financial Officer.
Communicated with Medicare and other major health insurances to resolve claim issues for timely processing of payments.
Established and maintained the company's electronic access to Medicare and other major insurances.
Transmitted OASIS data to the State of Michigan for verification of services provided to patients.
Generated OASIS reports/ trend analysis for the Clinical Director to ensure that Affinity maintains national standards for quality home health care.
Scheduled teleconferences and webinars/ trainings for all personnel in coordination with Medicare and other major insurances for continuous improvement of operations.
Programmed and maintained Affinity's secure web presence.
Coordinated with the company's marketers to create marketing materials.
08/2006 to 09/2008
Database AdministratorMaxicare Home Health Agency － Fraser, MI
Customized software as necessary to ensure accessibility of Maxicare's clients' medical and billing information.
Provided technical assistance on hardware and software systems to administrative employees as well as field employees in accessing information vital to performing their work.
Analyzed and troubleshoot network and computer operations to ensure that all systems are in optimal condition.
Analyzed and recommended hardware systems that best meet the needs of the staff for physical database storage as well as accessibility to individual users/employees.
Reported to management on system upgrades as necessary and implemented technical changes deemed necessary to maintain integrity of information.
Streamlined Intake/ Medical Records process and operations.
03/2005 to 08/2006
Change Management AnalystINFOnxx, Inc － Makati City, Philippines
Received and scheduled change activity requests, ensured their completeness, secured necessary approvals and track activities until activities were completed for Infonxx call centers and POP locations in the US, UK, Philippines, France and Italy.
Supported hardware, software, and voice and data communication equipment.
Served as first line of support, using basic troubleshooting skills for phone calls and network monitoring pages: contact on-call staff as required and work with the problem coordinator to escalate/resolve problems as defined by ITIL.
Applied fixes to known issues (routers, servers, switches, and network) for quick resolution.
Updated and maintained troubleshooting guides.
Maintained technical expertise in the rapidly changing technology and utilize state-of-the-art techniques when implementing or recommending solutions.
Kept a log of all activities and troubleshooting, attended meetings and trainings.
Generated metric reports: utilization, peaks, outages, etc.
Updated and maintained operations and configuration documentations.
Created technical evaluations of critical issues and incidents, participated in root cause analysis teams and facilitated management of project activity impacting the call centers.
Led a team in the NOC Service Desk and assist the NOC Supervisor in executing daily operation tasks.
Education and Training
Bachelor of Science: Computer ScienceAMA Computer University － Quezon City ManilaPhilippinesComputer Science