Qualification Summary
• Working experience data entry and data loading
• Experience using ERP system (Salesforce and SAP)
• 2+ years working experience in oil and gas industry
• Strong skills in MS Office (Excel and Word)
Work Experience
SMART Technologies Calgary, AB • June 2012
Data Migration Technician (Temporary)
- Input data from Excel spreadsheet to Salesforce CRM and ensuring all account and opportunities are included in SaleForce
- Resolving data quality and accuracy issues within SalesForce accounts and opportunities
- Identifying records with incorrect values, researching required information, and entering data into the missing fields
- Liaising with sales team to determine account information
Cantest Solutions • Airdrie, AB • 2010 –2011
Junior Database Administrator
- Maintaining and monitoring Oracle 10g and MySQL Databases running on Ubuntu Linux
- Extracted data from various sources and generated data analysis reports on Compiere (ERP) system
- Created and maintained DB schema objects (tables, views, sequences, synonym, index, procedures, and functions)
- Assistance in troubleshooting problems relating to database issues
Kelman Technologies Inc. • Calgary, AB • 2010
Database Administrator (Contractor)
- Data load and migration (PPDM3.2 to PPDM3.8) using PL/SQL, SQL*loader, data pump, import/export
- Verification of data migration quality
- Documented data modules
- Generating business reports and ad-hoc data analysis using SQL and PL/SQL
- Updated database morning checking reports (Korn shell scripting)
- Installed and configured Oracle Enterprise Manager
Southern Alberta Institute Technology (SAIT) • Calgary, AB • 2008
Database Administrator (Education Project)
- Gathered and documented business requirements, constructed logical and physical data models
- Database building (Create database and various objects)
- Data cleanup and loading from Excel spreadsheet to Oracle
- Implement and maintain database security (create users and roles, assign privileges)
- Database backup strategies development and recovery strategies testing
- Hot backup coding using shell scripting
- Developed Web application using Oracle Application Express 3.0
Education
. Certificate, Database Administrator, South Alberta Institute of Technologies, Calgary, AB
. Bachelor degree of Computer Science, China