Close Close Preview

Your amazing online presence is right this way.

Create your profile
Capture who you are, what you do, and where you're going. All in one place.

Ken Lee

Ken Lee

Consultant, Market Information Services & Airport Services

InterVISTAS Consulting

Richmond

Aviation Consultant, Market Information Services & Revenue Management, MBA, B.Sci

Message
MENU ☰

InterVISTAS Consulting

Consultant, Market Information Services & Airport Services

• Expanded former role to include requirement gathering, proposal writing, presenting study findings and building meaningful relationship with clients
• Designed, validated, troubleshot and maintained passenger flow tracking system based on Bluetooth technology in the Vancouver International Airport. System includes 120 Bluetooth tracking devices that calculate passenger process times for arrivals, departures, connections and their respective sub-processes
• Analyzed data and advised airport on operational changes to improve their passenger flows
• Managed more than 15 market size projects for major airports around the world
• Performed benchmarking, competitive analysis, hub and network analysis for major national airlines

Career medium 04
Career
Career medium 03

InterVISTAS Consulting

Senior Analyst, Market Information Services

• Developed statistical and mathematical passenger choice models to estimate origin-destination market sizes and airport shares in multi-airports regions. As a result, I helped airports to identify unique or emerging markets and build strong and credible business cases to attract new air services.
• Crafted detailed business presentations, reports and proposals and complemented with insightful charts and tables
• Automated data analytical portion of monthly reporting by writing SQL, Python and Excel Macro scripts
• Designed, maintained and mined airline schedule, travel tickets, custom entries, charter, and quality of service databases using various sources of government, public and proprietary data
• Built SQL and Python scripts to performed extract, transform and load, largest dataset includes an annual row count of 900 million

Career

TP Systems Ltd.

Database Developer and Server Adminstrator

• Provided reliable database administration to Ministry of Child and Family Development by recommending mission- critical upgrades and resolving user issues with the data
• Exceeded manager’s expectation through batch-processing data zaps that require investigation, testing and deployment

Career medium 01
Career
Career medium 05

Octopus Logistics Ltd.

Export Account Executive

• Nurture customer relationship with current clients, manage profit and loss and report to director and expand business by acquiring new clients
• Sustained business by managing export accounts, which consists of $3 million revenue annually.
• Triple revenue for exports originating from the United States by conducting research to identify new potential metal scrap clients and up-selling to current customers
• Streamlined export operations through transforming customer billing and profit and loss reporting processes using automated and integrated software

Career

Octopus Logistics Ltd.

Information System and Network Consultant

• Connected and secured one server and eight workstations by constructing an Ethernet network with firewall protection
• Enabled normalized digital communication among employees by installing and standardizing protocols used in the office with commercial off-the-shelf products
• Increased employee satisfaction by initiating, designing, and implementing a virtual office that employees can remotely connect to the office from home
• Improved workflow through influencing and advising operational changes: standardizing all external documentation, digitally storing supplier’s invoices, and utilizing VoIP in place of a traditional telephone line to save operational cost
• Saved company money and time by planning, organizing and mitigating risks with centralized network backup and as a result, recovered two system critical failures

Career medium 05
Career

Simon Fraser University

BSc, Computer Science

Beedie School of Business, Simon Fraser University

Master of Business Administration, Strategy, Management Information System, Finance, Operation Management, Economic