John Pi Email & Phone Number

• Manage a development team that supports in-house mission critical Oracle ADF and Dot Net web applications with over 500 users servicing a 4 billion dollars Auto Loan portfolio.• Manage development projects and drive teams, in a collaborative environment, to deliver quality core functionalities on time and on budget.• Establish mentorship to educate junior developers on ITIL and SDLC methodologies and Oracle and SQL Server technologies.• Setup, publish and monitor team and systems performance metrics and apply preemptive measures to correct any potential issues.

Irvine Ca

• Provided expert technical and business knowledge for on-shore and off-shore teams during the buildout of the Next Generation Business Financial System.• Designed the initial planning and build out of the Hyundai Capital Insurance IT infrastructure and integration strategies with internal systems and external vendors.• Managed the Tibco Integration team that developed and supported customer MDM, data cleansing and other API and Cloud integrations.• Worked with Business Analyst and Information Security to define core financial system data archival requirements and lead IT teams to deliver the data archival solution ahead of schedule.

Irvine Ca

• Developed and supported in-house Oracle finance/leasing systems with hundreds of users across all lines of businesses.• Collaborated with business to develop a monthly automatic charge-off process which yielded huge efficiently gain in reducing hundreds of hours of manual work per month.• Provided expert guidance leading team in upgrading and deploying an Oracle financial application from Oracle Forms client server to a J2EE application on the Oracle Fusion middleware weblogic application server.

• Worked with LA County departmental personal to gather the requirements and upgrade the LA Country Criminal Historical Record Service (CCHRS) J2EE applications including Oracle Forms, Oracle Database, Java Web Services and Servlets from 9i Oracle Application Server to 10g. • Successfully ported over 100 ProC programs, daemons, cron/at jobs and UNIX scripts from HPUX to a 64 bits IBM AIX server.• Successfully migrated the CCHRS 8i database to 11g and created PL/SQL scripts to ensure the data integrity after the database import.

• Successfully extracted and transformed legacy Oracle and SQL Server financial data into Capital One Auto Finance systems.• Worked with Business to provide data/reports for investors, auditors, and legal and government regulators.• Supported an Oracle base Business Process Model empowered J2EE financial web application deployed on Sun Solaris cluster by enhancing, tuning and debugging 100s of Oracle SQL, stored procedures, functions, packages and Java programs.• Resolved production issues by collaborating with management and business partners. Coordinated with various Development teams to ensure a successful Change Release process. • Developed and supported a HP-UX Loan application with over 100 Oracle Forms/Reports and Visual C++ executables for over 300 internal and remote users.• Worked with the business community to develop data warehouse with Oracle database and Business Objects.• Provided performance tuning and internal Oracle SQL/Forms/Reports training and technical mentoring for the developers. • Collaborated with UNIX administrator, network and storage engineers to ensure peak Oracle performance, 24/7 uptime requirement, and to design the Disaster Recovery strategy.

• Provided support to a multi-platform Oracle base Warehouse management application by tuning, debugging and enhancing 100s of Oracle Forms/Reports/Graphics, C and Pro-C APIs.• Developed and supported an in-house Oracle client/server and Web base CRM application utilizing Oracle development tools, java script, and HTML and ASP.Net.