Tim Lei

• Oracle APEX Developer (full-stack)
• Hold a Masters in Software Engineering and a Bachelors in Computer Science
• 15+ years’ experience as developer in Oracle technological fields with Oracle PL/SQL and SQL on Oracle DB 9i/10g/11g/12c
• 10+ years’ experience with Oracle APEX 3.2/4/5/18/19
• 10+ years experience on web development experience involving HTML, CSS, jQuery and JSON
• Oracle 10G OCA certified and Oracle 10G OCP Test Passed (score: 96%)

Senior Oracle Developer 2021 - Present

Oracle Canada

• Successfully delivered and maintained new APEX applications, resulting in improved data collection and enhanced user experience on Oracle Cloud Infrastructure
• Led and executed the migration for business data from OCI to new SI-DV platform, including backend logic and front APEX Apps.
• Implemented ETL/ELT process to prepare data for visualization on Oracle Analytics Cloud (a cloud-native data warehouse service), designed and implemented data flow, datasets based on data connections from varied source for data visualization
• Analyzed requirements from business dashboard mockups, like forecast, YoY, coverage and conversion, attainment, scorecard, etc., and transferred all logic and calculation into implementation

Sogema Technologies, Longueuil, Canada

• Developed restful API in PLSQL for payment and post transaction processes with WSO2
• By re-writing SQL, adding hint and building proper index, enhanced the loading performance of APEX IR by an impressive 50% or more
• Migrated features from Oracle Forms, reports or legacy APEX Applications to Oracle APEX 5+

CK-Telecom, Chengdu, China

• Led customized Android OS for smartphone based on QUALCOMM chipset platform in over 50 people team

Beijing Sinoprof, Chengdu, China

• Conducted system analysis and consulting for two sub-systems of Supply Chain Management in Telecom industry, including user case, UI, data structure, workflow, test cases and statistical reports; analyzed customer’s financial system built by Oracle EBS and provided interface solutions

Sichuan Yulintu, Chengdu, China

• Led an agile team of 15 people for upgrading land right confirmation product, transformed and improved the native .NET form application to web-based application, with .NET and Esri GIS architecture.

Tieto, Chengdu, China

• Used Oracle APEX 4 to develop in-house OTD (On Time Delivery) report system 
• Provided service support and application administration on Oracle databases, Linux servers and applications

EC Wise, Chengdu, China

• Developed internal task management system using Oracle APEX 3.2
• Did design work by power designer, code in Oracle PL/SQL with complex business process and logic, and package by bash with ant scripts

PMP certified (project management certification) 2011

Oracle 10g OCP (Testing Passed, 96%), Oracle 2009

Oracle 10g OCA, Oracle 2008

Master of Science 2005 - 2008 

Software Engineering, Sichuan University, Chengdu, China

(Canadian Equivalency of Master as assessed by World Education Services )

Bachelor of Computer Engineering 2001 - 2005

Computer Science and Technology, China University of Geoscience, Wuhan, China

(Canadian Equivalency of Bachelor as assessed by World Education Services)