Data Entry Specialist with SQL & Excel Expertise

OBJECTIVE:

To find a position for my expertise on data entry.

QUALIFICATION SUMMARY

Completion of a 2-year Civil Engineering Technology diploma in SAIT Polytechnic with course work in GIS, database and spreadsheet applications

Over 10 years related working experience in the data entry by SQL database, word and Excel

Strong ability in manipulating excel spreadsheet for comparison purposes and get requirement results

Experience in complex formula and scripts in MS Excel to finish logic calculation

Proficient in word document edition

Database maintenance, table creation

Extremely well organized and the ability to multi-task

Strong abilities in MS Office Suite, database and spreadsheet, data management optimization demonstrated by holding Microsoft MCSD certification which includes Designing and Implementing Databases with Microsoft SQL Server and Analyzing Requirements and Defining Solution Architectures

Competency in the use of transportation data collection technologies such as MS Excel, MS Access, SQL, Traffic Count Management (TCM)

Excellent oral and written communication skills in English;

Strong attention to detail and analytical aptitude, problem solving skills and time management;

Experience in the compilation and interpretation of complex statistical reports and summaries specifically in analyzing and processing traffic information and data

Advanced database and spreadsheet skills using Microsoft Access and Excel

Ability to summarize, prepare and interpret complex statistical reports for management

Problem solving skills demonstrated by programming and applying Transportation Data Analysis Software and Axle Load and vehicle statistics analysis software

High organization with demonstrated analytical and problem-solving skills with strong attention to detail

Work with team members effectively

A valid class 5 Alberta Motor Vehicle Driver’s License

Relative working Experience

Enter over 500,000 words in Word Document, different charts from 2018 to 2023

T&T Superstore

Staff September 2020 to Now

Provide service to the customers who come to seafood to purchase seafood product at seafood department

City of Edmonton

Traffic data assistant technician September 2012 - November, 2012

Collection of traffic data, travel time, traffic count

Tianjin Guoteng Consulting Company

3/1998 –8/2008

Engaged in the management and supervision of data collecting, data processing, data reporting and database (Excel, SQL Server)

Controlled engineering process of projects by the result of the manpower resource and equipment

Entered high volumes of data in various databases and work management systems

Kept the inventory updated and available on our company desktop computer system

Transmitted work electronically to other departments upon request

Did the various data analysis calculation by using Excel (formula)

Created Charts and did traffic forecast by using Excel

Maintained hard copy backup of sensitive business information

Finished lab raw data analysis

Did the data filter, sort, pivot table, provided relative reports according to the requirement

Made engineering computations and measurements and to interpret maps, plans, survey notes, and other engineering data accurately

Prepared neat and accurate designs, charts, graphics, and drawings from raw data according to standard Engineering procedures, and to use drafting equipment, mechanical lettering devices, and other standard drafting implements

Assisted in field data collection procedures

Reviewed data for sure data integrity, consistency and accuracy

Identified equipment and supplies needed to meet the data collection schedule

Collected traffic data on site

Estimated and recommended required budget amounts to maintain a satisfactory level of traffic control device

Produced detailed and concise drawings and layout plans with technical accuracy Interpret information from preliminary data, field notes, sketches

Analyzed traffic data and studied the time that vehicle pass the intersection, gave suggestion of traffic signal configuration

Reviewed digital survey information, field notes and sketches to determine what the information indicated and what approach needed to be taken to create a comprehensive plan

Processed digital data and gave assessment by using Axle Load and vehicle statistics analysis software

Used Excel to extract relative information from text format data and data analysis

Used Excel to do data analysis of traffic flow volume

Organized and entered data to produce standard reports

Reviewed the reports and correcting errors

Tested software Architect starting from the creation of projects, creating Attributes, Hierarchies etc

Implemented and tested advanced functionalities, such as Relationship Filters, Conditional Metrics, Consolidations, Pass-through functions, and Business Analysis functions

Designed, Implemented and tested “Axle loads and vehicle statistics software and Vehicle analysis software” to create report service documents, and to combine and join reports from different data

Implemented and tested Logical Views to remodel data by using different schemas

Provided documents for release notes and technical notes

Researched the new features of the latest release of different RDBMS platforms such as SQL Server, and Excel, using the new features to improve the query performance

Provided third party supports for all the testing teams

Provided information to other divisions and business units as required.

Extract data items from import/export databases (SQL Server to Excel, Excel to SQL Server), conduct analysis and prepare reports in support of research, monitoring and verification investigations

Programmed and applied Transportation Data Analysis Software to update, manipulate, analyze and interpret traffic volume information

Designed and Completed software development of experiment data

Designed and completed software development of evaluation method of the asphalt pavement surface material quality

Designed and completed software development of pavement surface deflection assessing system

Completed the application and maintenance of China highway Bridge Management system (CBMS) and SM2000s traffic software

EDUCATION:

SAIT Polytechnic: Civil Engineering Technology 2012

CERTIFICATIONS AND TRAININGS:

Microsoft Certificated Professional Solution Developer (MCSD), August 2001

Analyzing Requirements and Defining Solution Architectures. March 2001

Designing and Implementing Databases with Microsoft SQL Server 7.0, November 2000

Certificate of Recognition for 5 years of service with the Civil Census in Collecting Civil Census Data from the City of Calgary in Calgary, July 2018

Contact this candidate