Larry Pan Email & Phone Number

Santa Clara, Ca

Santa Clara

Responsible for designing, coding and modifying company web-based business transaction systems. Support users with visually appealing sites that feature user-friendly design and clear navigation.

San Francisco Bay Area

- Develop a web based e-visa application portal for MECO (Manila Economic Culture Office) for Taiwanese nationals to submit Philippine tourist visa applications. Approx. 600 applicants per day, users upload pictures, make electronic payment and the system sends approved travel authorization number with PDF attachment.- Helping Client succeed by documenting and Proof of Concept a automated BI dashboard corporate wide solution as the Single Source of Truth for Cisco SGG Operations, Strategy and Planning.- Designing MS Access based sales objective attainment reporting solution at Abaxis.- Implement True Demand bookings definition change to downstream applications at Cisco.- Host weekly Marketing office hours and convert Excel based Marketing Monitization Report to cloud based (Hadoop) dashboard platform at Google.- Define business requirements and work through IT to operationalize key metrics via OBIEE dashboards at NetApp.- Identify and document data requirements for an integrated information management system at CPUC. - Streamline Service Contract renewal process and recoup revenue at Brocade. - Provided insightful analysis customer spending patterns and identified next wave business opportunities.

- Responsible for tracking and measuring all project performance and effectiveness. The Lean Forward project was a corporate wide initiative to improve product distribution and provided $72M Working Capital Benefits in FY09.- Operation enablement of metrics tracking across multiple data systems. Automated accurate dashboard with drill down metrics. Modeled business scenarios and potential revenue savings.- Quarterly Renewals Management: Provided a simplified and accurate process to manage opportunity scrub with 85 users. Tracked various performance metrics for improvement. Increased data accuracy to 95% in 3 quarters.- Renewals Forecasting: Provided 4 quarter forecasting totals to Inside Service Sales Operation for staffing preparations. Worked with Finance on goaling projections.- Renewals Outsourcing: Implemented data validation rules and drove the fallouts to zero. Improved outsourcing data delivery from week 13 to week 9 in 2 quarters.- Ad-hoc reporting and data mining analyses on Cisco POS data to provide key takeaways for the Sales and Marketing PMs- Built a custom database to provide Singel Souce of Truth reporting. Weekly incremental updates are made to the database to allow users to self service

- Oracle ERP multi-org implementation and application administration. - Collected business requirements and built custom web-based database applications.- Created real-time reporting tool to track Install Base location along with issue tracking for each product.

- Oracle ERP implementation - document the as-is, to-be processes, and functional spec.- Developed and facilitated unit testing, link testing, and conference room pilot.- Post go-live support which includes call center, logging/tracking issues, and sustaining.

- 3-D CAD modeling design and Finite Element Analysis- NC programming; Manufacturing process optimization

Ms, Engineering Management

Bs, Mechanical Engineering