John C. Profile

5.0

(2 reviews)

You're now following

Error following user.

This user does not allow users to follow them.

You are already following this user.

Your membership plan only allows 0 follows. Upgrade here.

Successfully unfollowed

Error unfollowing user.

You have successfully recommended

Error recommending user.

Something went wrong. Please refresh the page and try again.

Email successfully verified.

$25 USD / hour

sydney,

australia

$25 USD / hour

It's currently 12:20 AM here

Joined July 17, 2013

0 Recommendations

John C.

@JohnABC

5.0

(2 reviews)

1.9

75%

$25 USD / hour

sydney,

australia

$25 USD / hour

100%

Jobs Completed

100%

On Budget

100%

On Time

N/A

Repeat Hire Rate

Teradata / Excel Developer and Data Analyst

Dependable and accomplished Teradata / Microsoft Access developer based in Australia. Specialties are for Teradata V12, V14, V15, Vantage: 1. Data modelling 2. Stored procedure creation 3. Macro creation 4. Data wrangling and data ingestion (ETL) 5. Integration with other products. Specialties are for MS Access 2000, 2003, 2007 & 2010: 1. Database design & optimisation 2. Form & report design 3. Macro creation & VBA solutions to adhoc requests 4. Dashboard Report Designs MS Access 5. Integration with other Microsoft products.

See all Microsoft Access Developers in Australia

Contact John C. about your job

Portfolio

MS Access Report

This search form allows the user to search multiple fields using a variety of selections

MS Access Search

Menu for a client working in finance industry

Menu Form MS Access

The client wanted a form for their employees to complete on how the spent time in their daily duties.

Time Management Analysis Form

This project was to list and hyperlink in an excel spreadsheet tab all files found matching certain criteria the client would input into a form. The result was to create a directory of files the client could quickly link to without the need of navigating through their complex folder structure.

File Directory Creator in Excel

MS Access Report

MS Access Search

Menu Form MS Access

Time Management Analysis Form

File Directory Creator in Excel

Reviews

Changes saved

Showing 1 - 3 out of 3 reviews

Filter reviews by:

4.0

$20.00 USD

Non Profit Mental Health Center needs Access Database Created for Outcomes Measurement/System Improvement

@JohnABC won the contest on 15 April 2015

Database Development

Microsoft Access

Christopher C.

@cjcelio

•

9 years ago

5.0

$26.70 AUD

Create MS Access Database for FIX Protocal

This Freelancer was really professional in the way that he handled our job. He was able to communicate well and adapt to our requested changes quickly. Will consider using him again!

Microsoft Access

Joey L.

@joeylong83

•

9 years ago

5.0

$50.00 AUD

MS Access Database

John did good work on the project. He was very quick and professional and delivered beyond expectations. I intend to hire him for future work.

Microsoft Access

Microsoft Office

Jason T.

@bigjasoz

•

9 years ago

Experience

Government

Feb 2002 - Jul 2023 (21 years, 5 months)

Data Analyst. Specialising in Teredata database modelling and analysis. Chief duties: create user tools and reports based on data from multiple sources and in different structures, optimising code, create stored procedures and macros, build views and data models. Other duties: ETL, visualisation of reports, creating campaign populations, train others.

Education

Bachelor of Business (Accounting)

Charles Sturt University,

Australia

1991 - 1995

(4 years)

Qualifications

Teradata Customer Education

2011

SQL advanced concepts - analysing SQL EXPAIN plans (the execution plan of parsing engine) for code optimisation. Understanding on how SQL table statistics impact code optimisation. How to collect statistics, when to collect them and what should be collected. Developing stored procedures and macros.