Patrick Lee Email & Phone Number

Toronto, ON, CA

Toronto, ON

Toronto, Canada Area

Santa Clara, CA - Remote From Toronto, Canada

• Onshore Applications Support Manager for Oracle 11i Applications. Prepared weekly metrics for operations call, created monthly utilization reports, maintained team’s skills matrices, co-ordinated shift and vacation.
• Drove team to resolve issues on time as per SLA. Improved ticket closure rate by 10% and reduced backlog tickets by 20%.
• Rotated in Shift Manager duties for all IBIS tracks. Facilitated escalated (financial and/or system impacting) support and request issues by co-ordinating and driving required personnel from different teams.
• Continued with Team Lead roles carried over from Sun Microsystems (see below).

Santa Clara, CA - Remote From Toronto

• Team SPOC (Single Point of Contact) for all ATR related escalated support issues and requests during onshore hours. Provide end-to-end management oversight of high priority issues, particularly in Oracle 11i AP, GL.
• Process Lead – provided guidance and leadership for team members in support procedures and protocol based on ITIL methodology.
• AIT Analyst – facilitated data and patching requests for all IBIS tracks on time. Ensured proper code versions were checked into repositories, documentation was accurate and testing was performed..
• Period Close Activity – Performed monthly close activities for AP and PA.
• Consistently high feedback from customers. Recognized for contributions via Recognitions Awards and mentions in the Sun Energizer newsletters.

Brampton, Ontario

• Maintained system integrity of Oracle Applications instances, established and subscribed to required security protocols, practiced business/data methodology and configuration management.
• End-to-end support for Financial customers using Oracle 11i, primarily on GL, AP, CDI, Workflow and Legacy custom code.
• Fulfilled development requests via work orders. Provided analysis, estimates and design documents, through to code changes and deployment using SDLC practices. Development involved PL/SQL, Unix Shell scripting, Pro*C.
• Successfully delivered larger development project. One sample was creating CDIs (Common Data Interfaces) to bridge gaps between legacy systems and Oracle 11i when migrating from Oracle 10.7.
• SOX (Sarbanes Oxley) Initiative – 2004 to 2007. Toolkit prime for Oracle Applications and AP Interfaces. Documented processes, performed Gap Analysis and Gap Remediation, developed solutions and assisted in 3rd party.
• CCC Harvest – Administrator – 2000-2007 - created, maintained and administered repositories for CSC developers to check-in, check-out code.

Brampton, Ontario, Canada

• Oracle V11 Project – Upgraded custom character-based Financial Applications to browser-based Web Application through the use of Oracle 8i database and Forms 4.5. Used Developer 2000 to develop front-end and enhanced.
• Infrastructure Consolidation Project – Consolidated multiple Oracle database instances (US Local General Ledger sites) into one instance. Effort was to reduce consolidation points, simplify the close process and reduce.
• Resolved support tickets, enhancements and user requests. Tasks often required UNIX scripting (e.g. awk, sed to manipulate flat files) and UNIX fundamentals (cron jobs, system resource maintenance). Requests included.