Joseph Serrano Email & Phone Number

Gilroy, Ca, Us

Morgan Hill, Ca

Oversaw successful migration of the billing and accounting software RealWorld from Unix platform to Windows SQL-based Passport Business Solution. Monitored system and checked data integrity to ensure there were no service interruptions.Designed and developed OE Gateway system that automated the order entry process and eliminated two to three hours of manual labor time. Reduced overtime costs significantly. The system is able to load all the details of the customer order like materials, door types, profiles, dimensions, and lineal footage into Passport software. Implemented new invoice template with a better format that fits all the order details.Created Invoice Print application that automated the invoice printing and sending to customers via email and fax. Created multiple utilities to overcome Passport's limitations like sales reporting (Live View system), data load to shipping system (Driver Board), and database backup utility. Currently working projects: * Online Live View (http://liveview.caldoor.com) - sales dashboard and one-stop shop for value added information and data analysis. * Establish new credit card payment processing system.Future projects: * Redesign and rewrite corporate website (http://www.caldoor.com). * Redesign and rewrite Online Ordering system. * Create Pricing Matrix system and automate price quotes workflow.

San Jose, Ca

Designed and developed Work-RVU system that measures productivity and patient care quality of the physicians based on relative-value of the provided procedure. Also used by Finance for physician compensations and incentives.Designed and developed Batch Job Monitoring System that streamlines the data extraction from the Practice Management System (GE IDX), transforms and loads the data to SQL, and delivers high-quality reports to Business Managers, Finance, Medical Directors and Executives. Also generates integration files for revenue data – charges, credits, debits, adjustments, payments, claims expenses and capitation to Great Plains system enabling the GL books to close in a timely manner. Designed and developed Office Ally Claims processing system that pulls Health Insurance Claims from the clearinghouse in industry standard 837 X12 format, validates and loads the data to SQL, then enters the data to IDX Managed Care. Handles warnings and errors thrown by IDX and shown in effective user-friendly web UI. Establishes process and workflow improvements, creates implementation strategies and automations, and maintains system integrity and configurations.

Morgan Hill, Ca

Designed and developed Decision Support System that serves as a powerful demand planning and inventory management and has been effectively fulfilling products (12,000+ SKUs) from different domestic and foreign suppliers (300 vendors) to the distributing warehouses (17 locations) across North America. In 2009, the system has helped the company reduced inventory by $7.7 million while achieving higher order fill rates and less operational costs.Designed and developed the Team-Coast Business Intelligence platform that effectively provides greater business visibility to the Executives, Product and Sales Managers. Delivers high-quality reports, key performance indexes and market dashboards.Created various enterprise systems and databases that are outside the company's core AS400 platform to support the business needs and requirements – Sabrix Tax Reporting, Warranty Online System, Employee Resource Center, Pricing Maintenance, Dynamic Management Tool, and AppService XML Web Services.

Manila, Philippines

Managed 17 Software Developers and 2 Database Administrators and spearheaded critical projects to deliver integrated database solutions for administrative, academic operations, student registrations, enrollment, grading and class scheduling.

San Francisco, Ca

Designed and developed Occurrence Event Analysis System that serves as a powerful tool for Department Managers to track business projects and production issues with embedded collaboration and auditability.