Find freelancers. Lose those costly delays.

With 1.7 million freelancers, we'll match you with the perfect talent.

or, Register with Elance »

Yawar Amin | Elance
 
176985602337900
Last Sign-in: Feb 23, 2015

Yawar Amin

Data analysis / data management / reporting
   Canada
  |   Mississauga, ON
  |  2:39 pm Local Time

Overview

Your data is the vital core of your business. Understanding it, managing its flow, and extracting value from it is key to your success. I specialise in doing all of the above.

My skillset is analysis, modelling and reporting using a wide variety of tools like Microsoft Excel, Access, Microsoft SQL Server, Talend Open Studio, MySQL, R, Python, VBA/VBScript, C# etc. But I also bring more the table. For example, I use a multi-disciplinary approach to analyse your problems and suggest the simplest, most maintainable solutions possible. I create...

Read More »
Apr 17, 2013|Database Development|Private|Completed
|
5.0
Mar 17, 2013|Database Development|Private|Completed
Mar 15, 2013|Database Development|Private|Working
Mar 8, 2013|Database Development|Private|Completed
|
5.0

View All »

Portfolio

A sample form to demonstrate managing a transaction-based workflow in Access. In this...
This is a Microsoft Access report designed in the style of a double-entry ledger to...
This query shows the top 3 departments across all stores in terms of average salary...
This query shows the use of named sets [1997 Measures] on the columns axis and [Higher...
This query shows the use of the MTD, QTD, and YTD functions to calculate the average...
This query shows the use of the Ancestor function to calculate the percentage of...
This query shows filtering for only HQ departments, and slicing for the year 1997.

Skills (10)

Tested
MySQL Administration
MySQL 5.0 Test
My Score
avg
Microsoft Access Administration
Microsoft Access 2010 Test
My Score
avg
Microsoft Excel
Microsoft Excel 2003 Test
My Score
avg
Microsoft Excel 2010 Test
My Score
avg
C
Programming with C Test
My Score
avg
Python
Python 2.x Test
My Score
avg
Data Warehousing
Data Warehousing Test
My Score
avg
Data Modeling
Data Modeling Test
My Score
avg
OLAP
C#
Programming with C# Test
My Score
avg
SQLite Programming

Service Description

Database management; creation of ad-hoc queries for custom reporting needs; data migration between different formats. Technical support for database development; helping users optimize their tech use; programming resources; recommendations of best practices, etc.

Reproducibility. I take great care to ensure that my work product is as transparent as possible and can be reproduced by someone on the client side. For example, if I'm designing a database for you, instead of using the point-and-click tools to define all the tables, queries, etc. I will create a SQL script that can be read by Access to define all the relevant objects. Of course this doesn't apply to forms and reports; but with the data you'll get full transparency.

Read More »

Education

University of Illinois at Urbana-Champaign
Certificate of Professional Development
2010 - 2011

Keywords

excel
access
data
database
sql
mdx
analysis
python
R
My Snapshot
IT & Programming
2
Elance Level
Level represents activity and experience on Elance. Freelancers start at Level 1 and achieve higher levels through their work. A higher "Level" indicates greater earnings, ratings and other achievements on Elance. Learn More »
  • 12 months
  • Lifetime
Jobs
0
0
0
Total
Milestones
Hours
Reviews
Recommend
Clients
Total
Repeat
Earnings
Private
Private
Total
Per Client
Identity
Username
yawaramin
Type
Individual
Member Since
January 2011
Elance URL
Verifications
0
Groups
Yawar Amin | Elance

Yawar Amin