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
  
   

Oracle Developer                                                          2017 - 2021

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+

System Analyst                                                                                                   2016

CK-Telecom, Chengdu, China

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

System Analyst                                                                                         2013 - 2015

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

Tech Analyst                                                                                       2012

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.

Software Engineer                                                                                                       2009 - 2011

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

Oracle Developer                                                                                                  2008 - 2009

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)