Post Job Free
Sign in

Data Manager

Location:
Calgary, AB, Canada
Posted:
July 17, 2012

Contact this candidate

Resume:

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



Contact this candidate