Lambert Lu Email & Phone Number

Toronto, Ontario, Canada

Oracle,PHP,PythonLinux OS custom build

Design, develop and implement the Enterprise Central Database Project for business needs.

Design built and migrated database and Server solution. Responsible for designing, developing and implementing the service systems for SUPERDEMOGRAPHICS.COM Platform: RedHat Enterprise Linux 5.3 x64, Apache, Oracle 11g and PHP Build Oracle 11g and SQL Server 2008 integration environment

Comark is a leading Canadian specialty fashion retailer, serving customers through three popular divisions: cleo, Ricki's and Bootlegger.My job was: Assisted in all the four-hundred stores across Canada for three divisions with designing measurable direct marketing campaigns. Built major reports providing analytical (eventually statistical) analyses in support of marketing initiatives (all 3 Divisions + Comark). Supported and developed programs to enhance the data mining environment, increase the capabilities of customer targeting and perform various data analysis projects (mostly campaign reporting). Designed, developed and implemented the Data Mining Project for customer database system. Analyzed database to help marketing department make business decisions. Built Customer profiling Calculation Solution. Integrated Customer segmentation and predictive modeling into marketing campaigns Built query tools for data mining purposes and response evaluation; communicate key insights to marketing teams within each Division.

Data Mining is a leading micro-marketing data and analytic service provider. Using the most granular micro-marketing data and the most advanced analytical techniques the company helps clients gain insights of their existing customers and find more high potential prospects.; Designed, developed and implemented the Data Mining Project for Insurance, Retail and Energy Companies.Analyzed traffic data to support the marketing departments of transportation companies make business decisions.

is a leading BtoC platform service provider.Database AnalyzerResponsible for designing, developing and implementing the shopping and service systems for ishopca.com(Open Source Platform LAMP: Linux, Apache, MySQL, and PHP).

First work as a C developer under UNIXThan add a lot SQL workBecome a DBA after 2 yearsDesign system for CHINA TELECOM, China Mobile and some insurance company• Setup development schedule and performed system design, detail design for complex database projects and distributed systems• Maintained more than 200 Oracle database servers.• Installing, configuring and maintaining all database software, patches, upgrades and utilities• Support of ERP DB servers including Oracle, PeopleSoft, and Custom Development• Maintained Integrity and security of database systems (change control, security procedures, user passwords, backups, etc)• Problem analysis and resolution as part of daily function.• Successfully migrated databases in 70 projects. Technology included Sybase upgrades, Oracle upgrades, or cross platform migrations• Analyzed and supported database of Oracle Database (IBM P690, HP Superdome) (Upgrade, Migratory from Oracle 8.1.7.4 to 9.2.0.6 and Turning).• Analyzed and supported Telecom Company. Design Version 2.5(PHP, PowerBuilder 6.5, standard C under UNIX) (Upgrade, Migratory from Oracle 8i to 8.1.7).• Designed, developed and implemented the billing and service systems for Telecommunication Companies (IBM S75 HP N4000 + Oracle 8.1.5) (Sun 5500 + Oracle 8.0.5) (PowerBuilder 6.5, standard C under UNIX).• Designed and Tuning Information Security System (Oracle 10G + X86 blade server)• Designed and Maintained Hospital Management System.• Web services interfaces as applied to an Oracle database(Apache + PHP, Tomcat + JSP)• Oracle replication and standby database experience (Bank and Insurance industry system)• Experience with RDBMS backup and restore scenarios• Troubleshooting and recovering down database systems:• Fixed IBM S7A 7133 Disk Array broken system• Fixed Compaq 160 Tru-64 system hung up system• Fixed HP Superdome which Power adapter had burned out

is the largest software development and IT Services company in China, founded in 1991. As of January 2009, Neusoft employed over 15,000 employees and is headquartered; Successfully developed 24 large-scale database projects, all of them which were delivered to the market for 2 to 4 years. Maintained more than 200 Oracle/Sybase database servers.Successfully migrated databases in 70 projects. Technology included Sybase upgrades, Oracle upgrades, and cross platform migrations between Sybase, Oracle, SQL Server and DB2.Designed, developed and implemented the billing and service systems for Telecommunication Companies (Biggest in China more than 500 million active users).Designed and implemented customer info system for Insurance Company.