Javascript must be enabled to properly navigate this site.
Home
Why oDesk
Tour
Who Uses oDesk
FAQs
Press
Find Providers & Jobs
Find Providers
Find Jobs
Tests
Trends
oConomy
Groups
My Jobs
Openings
Candidacies
Assignments
Post a Job
Manage & Work
Team Room
Work Diary
Reports
Team Admin
Staffing Console
Payments
Financial Activity
Payment Methods
Withdrawals
Referrals
Sign In
or
Create an Account
Community
What's New
Forums
Blog
Store
?
Help
Help Center
A-Z Index
Resources & Downloads
Contact Support
Providers
Jobs
Tests
Community
Help
Find Providers
Find Jobs
Tests
Trends
oConomy
Groups
Share
Flag as Inappropriate
Last 6 mos.
All-time
Feedback:
none
none
Hours:
0
0
Assignments:
0
0
See all Work History & Feedback
Location:
Calgary, Canada (GMT-07:00)
English Skills:
(self-assessed)
5.0
Member Since:
October 21, 2009
Last Worked:
oDesk Ready:
Yes
Related links:
Trends for
Access Consultants
Pavlo Pedan
-
"
Database developer (MS Access/SQL Server/Crystal Reports)
-
Freelance
Programmer / Developer
,
Canada
"
Permalink :
Overview
Résumé
Work History & Feedback (0)
Tests (4)
Portfolio (1)
Having 20 years of overall programming experience, my primary expertise is Microsoft Access/VBA database applications development, customizing and troubleshooting. I have experience working with all versions of Access starting from 2.0 and up to 2007.
I am seeking an opportunity to build and support MS Access databases as well as MS SQL Server and Crystal Reports projects.
I also have experience with MS Visual Studio (VB.NET, C#, C++ and ASP.NET)
See All Work History & Feedback
(0 items, with Feedback)
Recent Work History & Feedback
Buyer ID
From/To
Job Title
Hours
Feedback
Work History & Feedback is empty
See All Tests Taken
(4 items)
oDesk Tests Taken
Name of Test
Score
Percentile
Date Taken
Duration
MS Access 2007 Test
4.90
100%
TOP 10%
1st Place!
10/27/2009
22 min
MS Access 2003 Test
5.00
100%
TOP 10%
1st Place!
10/27/2009
19 min
MS Access 2000 Test
4.00
98%
TOP 10%
10/25/2009
25 min
oDesk Readiness Test for Independent Contractors and Company Managers
10/21/2009
12 min
Recent Candidacies
Job Opening Title
Initiated By
Date
Microsoft Access Client Database
Provider
October 27, 2009
Job Category Interests
Software Development
Desktop Applications
Other - Software Development
Networking & Information Systems
DBA - Database Administration
Skills
Skill
Experience
Level
Last Used
Description
MS Access
16 yrs
5.0
2009
http://sites.google.com/site/m
saccesscode/
More than 16 years of experience in Microsoft Access (versions 2.0, 97, 2000, 2002, 2003, 2007) database applications development, consulting, customizing, support and troubleshooting.
Development of MS Access/MS SQL 2008 various database projects using VBA, SQL, including:
- creating new database, front-end data-entry and search forms, macroses, queries (including pass-through) and reports
- Internet & MS Office automation, DAO, ADO, ODBC, Win API, WinHTTP, XMLHTTP, Winsock
- T-SQL (views, stored procedures, table-valued and scalar-valued functions, triggers, constraints, Full-Text Search)
- Third-party ActiveX objects (Chilkat, WeOnlyDo)
- Import/export data from/to MS Excel spreadsheets, CSV and plain text files
- Extracting data from web-pages, filling interactive web-forms
- object-oriented approach, use of MS Windows Accessibility
- MS Office2007 Ribbon creation, XML, EDI (Canada Customs ACROSS and CADEX)
Certifications
Date Earned
Name
Score
Percentile
Organization
Description
2001
MS Access 2000 Fundamentals
-
100%
Brainbench
—
2008
MS SQL Server 2005 [70-431]
Microsoft
TS: Microsoft SQL Server 2005 - Implementation and Maintenance
Score: 940
Employment History
From
To
Company
Title/Role
Description
08/2007
Present
DSKN Inc
Database Developer / Independent Contributor
http://www.dskn.ca/
Key challenge: Canada Food Inspection Agency (CFIA) legal web-based reference system was used for filling customs entries. All the data was typed in manually, while it was already present in client's (customs brokerage company) database. As the system uses iteration procedure to generate response, filling of 1 entry line (including received data and entering it back to database) was taking up to 5 min.
Action: Implemented fully automated procedure of entering data from database to web-form, responding to system's clarification queries and entering data from final result web-page to client's database.
Result: Time required for 1 line processing reduced form 5 min to 10-15 sec, what made the client highly competitive in customs clearance of commodities that require CFIA approval.
Other challenges solved:
- use of TreeView control to navigate though database records with parent-child relationships allowed to improve overall system usability and performance.
- Bank of Canada RSS feed was used to populate foreign currency selection combobox with real-time currency exchange rates.
- search for earlier processed items, based on several parameters (vendor reference code, full description, any part of description). Parameters were applied successively, based on complex business logic to avoid wrong classifications.
- extraction data from bulk amount of Excel spreadsheets with heterogeneous layout into one database table using ActiveX MS Spreadsheet control. Extraction was followed by column-specific postprocessing.
Simple and user-friendly interface allowed to import large quantity of complex spreadsheets from different vendors and clients easily and with almost no training of operator.
Other activities included development of MS Access/MS SQL 2008 various database projects using VBA, SQL, including:
- creating new database, front-end data-entry and search forms, macroses, queries (including pass-through) and reports
- Internet & MS Office automation, DAO, ADO, ODBC, Win API, WinHTTP, XMLHTTP, Winsock
- T-SQL (views, stored procedures, table-valued and scalar-valued functions, triggers, constraints, Full-Text Search)
- Third-party ActiveX objects (Chilkat, WeOnlyDo)
- Import/export data from/to MS Excel spreadsheets, CSV and plain text files
- Extracting data from web-pages, filling interactive web-forms
- object-oriented approach, use of MS Windows Accessibility
- MS Office2007 Ribbon creation, XML, EDI (Canada Customs ACROSS and CADEX)
Current project deals with automation of customs brokerage company working environment.
Operating Systems: Windows XP/Vista/Server2008; Languages: VBA, T-SQL, Database: MS Access/SQL2005, Reporting Tools: Crystal Reports
03/2007
Present
ARGO Business LLP
Database Seveloper / Independent Contributor
Key challenge: MS Access front-end was using lookup hierarchical data table with 30000+ records. Traditional Access search was impermissibly slow on Memo fields if several keywords involved, as operators had to answer phone calls under time-limit conditions.
Action: Implemented Full-Text Indexed Search on words located on different levels of hierarchy but referring to one record at a leaf level. The approach was similar to one used by MS SQL Server, including "noise" words filtering.
Result: System's response time reduced from 30-40 sec to 0.5 sec, what allowed operators to respond to client's queries immediately.
Other challenges solved:
- Subform contained a subdatasheet, that included child subdatasheet. Not all records of latter were always populated. When processing big number of records, operator was not able to click on every record to expand it to see if there are any child records present. On the other hand MS Access allows to expand/collapse only all subdatasheet at a time. In this case that would be hard to see for example 1 existing record among 30 empty that will be expanded as well. I used MS Accessibility library to fire default action of expansion control for necessary records only.
- Main form of application was populated by numerous controls. Every time when critical event fired Message Box, that was hard to understand which control requires attention and sometimes Message Box covered control and operator had either to close Message Box or to drag it aside. I used Windows API functions to determine location of necessary control and place Message Box or pop-up form next to it.
Other activities included development of MS Access/MS SQL 2005 database projects (accounting, office management) using VBA, SQL, ODBC, ADO.NET including:
- running, enhancing and maintaining existing databases
- views, stored procedures, table-valued and scalar-valued functions, backup, ETL, SSRS, SSIS, BIDS
- creating front-end and reports
- new database development
- web-based MS SQL Server back-end
- creating front-end and reports (MS Access, Crystal Reports)
- web hosting support
Operating Systems: Windows XP/Vista; Languages: VBA, T-SQL; Databases: MS Access, MS SQL 2005; Reporting Tools: Crystal Reports; CMS: Parallels Plesk Panel 9
01/1996
08/2007
POE Korpus-PI, Ukraine
Database Developer / Manager
http://www.korpus.lviv.ua
Developed several MS Access/MS SQL 2005 and MS Access/Oracle9i database projects for automation of data input and exchange between remote databases and data processing of financial operations of customs brokerage enterprise.
FTP, E-mail and SMS messaging services provided support for updating users and clients:
- design, developing and installation of database software and a local Linux server based network.
- invoices and financial transactions, reports and documentation written in MS Access. Various types of invoices, banking documents, analyze forms and diagrams, many material and human-resource forms, with appropriate reports.
- writing code for invoices, bank documents and other "money-flow" and tax documents while updating money balance.
- full usage of object-oriented approach and dynamic SQL constructions.
- clients support (including collecting and documenting user’s requirements, database management modifying and testing).
- project included development of the product for file sharing system under network using front-end/back-end architecture.
- MS Office Word and Excel automation.
- back-end database table and relationships structure update according to the new version of front-end requirements.
Operating Systems: Windows 98/2000/XP, Languages: VBA, SQL, Databases: MS Access, MS Access, Oracle9i.
Other Experience
Forex
Writing indicators and experts for Metaquotes Metatrader 4
Education
From
To
School
Degree
Area of Study
Description
07/2008
10/2008
Hands On Technology Transfer Corp.
Other
MS SQL Server
- Microsoft SQL Server 2005 Administration
- SQL Server 2005 Business Intelligence Application Development
- Microsoft SQL Server 2005 - Implementation and Maintenance
- Windows Forms Programming Using C#
- SQL Server 2005 Business Intelligence Application Development (Reporting, Analisys, Integration Services)
09/1981
05/1986
Lviv Polytechnic Institute
Bachelors
Radio Engineering
Graduated with distinction
Project Title:
Database Development
Attachment:
none
Completed:
10/21/2009
Category:
Software Development > Desktop Applications
URL:
http://sites.google.com/site/msaccesscode/
Description:
Please find some samples of my code (including sample databases and video demonstrations) and more information on me at my personal web site.
Hourly Assignment History
Buyer ID
From/To
Job Title
Hours
Feedback
Hourly Assignment History is empty
Fixed-Price Assignment History
Buyer ID
From/To
Job Title
Paid
Feedback
Fixed-Price Assignment History is empty
oDesk Tests Taken
Name of Test
Score
Percentile
Date Taken
Duration
MS Access 2007 Test
4.90
100%
TOP 10%
1st Place!
10/27/2009
22 min
MS Access 2003 Test
5.00
100%
TOP 10%
1st Place!
10/27/2009
19 min
MS Access 2000 Test
4.00
98%
TOP 10%
10/25/2009
25 min
oDesk Readiness Test for Independent Contractors and Company Managers
10/21/2009
12 min
