Resume

Sign in

CS/TS/DEV

Location:
Laval, Quebec, Canada
Posted:
November 19, 2018

Contact this candidate

Resume:

Justin Bai

***-**** ********* ******** ***** Number : Home 514-***-****

Mobile 514-***-****

Montreal (Quebec ) H3R 3G1 Email address: ac7qqc@r.postjobfree.com

Language : French, Enlish and Mandarin

Summary

Over 9 years of experience in the DB area (Development, Implementation and Maintenance) in ORACLE and MYSQL/MSSQL/SYABASE. Have a service-oriented mentality.

Excellent knowledge of SQL. Ability to optimize SQL. ORACLE and MS SQLSERVER/MySQL and MongoDB.

4 years of IT Technician in the Canada telecommunication area(Technical support Level 1 and 2, Customer service, Computer and Network equipment/software installation and configuration, maintain,optimization)

Technical skills

Excellent in Database’s maintenance and development,Experience in ETL with SSIS. Understand: SSRS. Knowledge:SSAS,SCRUM

Model design with ERWIN and Visio for OLTP/OLAP sys.(CRM/Billing etc.), ormalization:3NF-CRM in RDBMS.

OS: Windows, Ubuntu,HP-UNIX. Language: PHP, SQL, PL/SQL,TSQL, PB,VB,C. JavaScript, HTML5, Excel, POWERShell.

Network: TCP/IP, UDP, HTTP, FTP,SSH, VPN, DNS, DHCP, MML,SMPP+,SIP,F5

DetaBase: Oracle,MSSQL, Sybase,Mysql,Mongodb .

Others:MVC,TWIG,Opencart,Laravel,PHPstorm,Apache, ETL(SSIS),SSMS.C#

Professional experience

Altima Telecom, Montreal, Canada 2014-Present

Technical support&advisors

Build rapport with Mysql/MSSQL PHP for analytical and manager. Design and Develop ETL processes with SSIS. Creation of a database schema based on business requirements by SSDT.

Inventory manager: Receive and distribute equipment, Inventory count of device. Assist in ensuring production quality meets business specifications, Create shipping labels with EST,

Provide technical support to customer (Internet and ipphone) by analyzing all problems raised by the customer; Provides product advice and assistance for internet, ipphone where applicable.

Solve the technical problems accompanying the customer throughout the process; Recommend solutions and actively participate in settlements.

Diagnose problems: bad connections equipment, modem and router malfunction, technical configuration, etc;Contact specialized partners(VDN, BELL, ROGERS,TELUSetc.) to resolve certain problems.

Place Order to partners, Configure and repair Modem, Router, Printer, Office equipment etc. Install OS and applaction, antvirus software etc. Check and resolve the safety of equipment and systems.

United Network Communications Corporation, Chine 2003-2012

Technician System BSS technical installation and implementation (2008-2012)

Construction and modernization BSS system and applications according to plan and the application for the business unit.

Design platforms and functionality of services according to the scope, costs and project timelines and to ensure the necessary follow-up.

Determine the impacts of service on business processes (supply, billing, support) and on operations

Accept requirements of business units(front and end). Translate business requirements into an optimal IT solution, and provide new innovative solutions.

Prepare and perform tests and procedures of implementation detailed procedures for the improvements and fixes applied to systems. Build and Maintain an Database with robust process automation.

Maintenance Technician of BSS (2003-2008)

Accept customer and businesscomplaints and resolve their requests affairs. Performs acceptance testing (ATP)

Accepts and analyzes the requirements of the units, design plan and apply in system. Plan, design and optimize the network based on the technical functionality.

BSS supports functions such as monitoring the underwriting process, billing and credit control modules, resource management (MSCport, offline, phone number).

Ensures the daily operation of computer applications and systems.

Xi'an future international software company Xi'a, China (1999-2003)

Software developer

Maintenance BSS systems and development of the user -Unix HP, SYBASY, PB.

Adjusts and optimizes business processes for billing telecommunications.

Organizes a data data flow software and ER models Development.

Education

Telecommunications Engineering degree 1999

Computer Application and Communications Engineering

Université Xidian, China

Technical training for the database program 2007

Programmes ORALCE9i PL-SQL program et Database tuning

ORACLE Université Shanghai, China

References available upon request



Contact this candidate