	Last 6 mos.	All-time
Feedback:	none	none
Hours:	0	0
Assignments:	0	0

Location:: Łódź, Poland (GMT+01:00)
English Skills: (self-assessed): 4.0
Member Since:: July 29, 2009
Last Worked:
oDesk Ready:: Yes

Jacek Szarapa - "Software Develper Delphi\C#\C\PHP\MS SQL\MySQL\Firebird - Freelance Programmer / Developer, Poland"

Permalink :

I have a long experience (over 15 years) in software development and project management. My programming skills involve Delphi, C#, PHP, C/C++, T-SQL (MS SQL, Interbase / Firebird, MySQL). Projects range I was responsible of is quite wide from small, medium and end on big size. I worked and (I still work) for companies placed in Poland as well abroad (especially UK)

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 (2 items)
oDesk Tests Taken
Name of Test	Score	Percentile	Date Taken	Duration
Delphi 6 Test	4.60	97% TOP 10%	10/09/2009	10 min
oDesk Readiness Test for Independent Contractors and Company Managers			10/09/2009	2 min

Recent Candidacies
Job Opening Title	Initiated By	Date
Optimize speed of a complex sql server 2005 query	Buyer	November 6, 2009

Job Category Interests
Software Development Desktop Applications Scripts & Utilities Software Project Management Other - Software Development	Networking & Information Systems DBA - Database Administration ERP / CRM Implementation

Skills
Skill	Experience	Level	Last Used	Description
Delphi	13 yrs	5.0	2009	http://jacek-szarapa.com/index.php?p=jacek_szarapa_projects I have long experience in software development using Delphi. The environments that was used be me include Delphi 1.0, 3.0, 4.0, 5.0, 6.0, 7.0, 2006. The sample projects designed with Delphi : Time and Attendance Manager, Positive ERP system, Rental System.
MS-SQL	7 yrs	5.0	2009	http://jacek-szarapa.com/index.php?p=jacek_szarapa_projects I use MS SQL Server since 7 years. During that time I was responsible of MS SQL Server administration, T-SQL programming (triggers, stored procedures etc.), database architecure, designing structures, search engines optimization, OLAP solutions (MDX), replication. The sample projects using MS SQL : Time and Attendance Manager, Positive ERP system, Foodoo
MySQL	13 yrs	5.0	2009	http://jacek-szarapa.com/index.php?p=jacek_szarapa_projects I use My SQL Server for almost 13 years especially for web projects. During that time I was responsible of My SQL administration, database architecture , search engines optimization The sample projects using My SQL : Positive Hospitality ePOS, Rental software, WAP based on-line games

Certifications
Date Earned	Name	Organization	Description
2007	Designing and Implementing OLAP Solutions Using Microsoft SQL Server 2000 [MS...	Altkom	Designing and Implementing OLAP Solutions Using Microsoft SQL Server 2000 Course
1997	English Summer Course [English]	Kingsley School of English	Summer English Course at Kingsley School of English in London
2006	Implementig Replication Using Microsoft SQL Server 2000 [MS 2591]	Altkom	Implementig Replication Using Microsoft SQL Server 2000 Course
2007	Implementing Busines Logic with MDX in Microsoft SQL Server 2000 [MS 2093A]	Altkom	Implementing Busines Logic with MDX in Microsoft SQL Server 2000 Course
2009	Microsoft SQL Server 2005 Server-Side Solutions [MS 2781A]	Altkom	Microsoft SQL Server 2005 Server-Side Solutions Course
2006	MS Project [MS Project]	Altkom	MS Project Course
2006	MS SQL Server for Experienced Database Professionals [MS 2723A]	Altkom	MS SQL Server for Experienced Database Professionals Course
2006	Pogramming Microsoft SQL Server 2000 [MS 2073]	Altkom	Pogramming Microsoft SQL Server 2000 Course
1998	Summer English Course [English]	Kingsley School of English	Summer English Course at Kingsley School of English in London
2007	Supply Chain Management [Supply Chain Management]	Altkom	Supply Chain Management Training

Employment History
From	To	Company	Title/Role	Description
03/2008	Present	Insite Solution	Freelancer, System Architect, Developer. / Independent Contributor	Development of custom software (Time Attendance managment). * Analyzing clients' needs * Design of the detailed target solution architecture (with support from technology experts) * Defining solution concept including business and technology elements based on clients' requirements * Designing database structures (MS SQL) * Developing Time Manager application. (DELPHI, C#) * Building knowledge required for the service * Work independently and deliver under the pressure of deadlines and commitments to the customer, * Remote work from Poland This role requires: Very good communication skills (English), very good database designing skills, very good database MS SQL (2005) programming and optimization skills, very good work organization, very good problem solving skills (Projects based on MS SQL 2005,ASP.NET, C#, DELPHI)
09/2009	Present	JS Software	Freelancer, System Architect, Developer, Owner / Independent Contributor	IT consulting   * IT Project Management * IT Outsourcing * Designing database architecture (MS SQL, Firebird, MySQL) * Custom software development (C#, DELPHI, PHP)
07/2007	09/2009	Horeca Online S.A.	Product Manager, System Architect / Manager	Development of foodoo.pl portal for food ordering and table reservation. * Analyzing clients' needs * Design of the detailed target solution architecture (with support from technology experts) * Defining solution concept including business and technology elements based on clients' requirements * Designing database structures (MS SQL) * Manage the team of 6 programmers (ASP.NET, MS SQL). * Support SQL programmers for query optimization (MS SQL). * Issues tracking within the designed solution This role requires: very good database designing skills, very good database MS SQL (2005) programming and optimization skills, very good work organization, very good problem solving skills (Projects based on MS SQL 2005,ASP.NET, C#.)
03/2005	07/2007	LSI Software S.A.	Product Manager, Senior Software Developer / Team Lead	Development of Positive Retail (ERP) System. * Analyzing clients' needs * Defining solution concept including business and technology elements based on clients' requirements * Designing database structures * Development of several applications that work in the chain of retail sales points (Positive Retail System). From single sale point (Delphi, Java, MS SQL), through data exchange between central application and sales points (Java, MS SQL), central application that contains Main Storage management, sales management, reports and analyses, Business Intelligence (Delphi, SQL, MDX) * Manage the team of 8 programmers (ASP.NET). * Manage of quality control of development process * Providing expertise in the areas of design, development, and implementation of assigned projects, * Building knowledge required for the service Projects based on MS SQL 2000,Delphi5/7 with extentions of ReportBuilder, DevExpress controllsets.
12/2001	03/2005	LSI Software S.A.	Software developer / Independent Contributor	Development of Windows application ePOS system for hospitality market using DELPHI, MS SQL, Pervasive (Positive Hospitality System) * Work in a development team of 5 members.
07/1994	12/2001	Vega s.c.	Owner, software developer / Independent Contributor	programmer (Delphi, PERL, PHP, CGI, HTML)

Other Experience
Project Managment During my work I was responsible of Project management and team leading. My experience in that area is about 5 years. The sample projects : Positive Retail/ERP System, Foodoo, Time and Attendance Manager
Project Managment During my work I was responsible of Project management and team leading. My experience in that area is about 5 years. The sample projects : Positive Retail/ERP System, Foodoo, Time and Attendance Manager

Education
From	To	School	Degree	Area of Study	Description
09/1996	06/2002	Technical University of Lodz	Masters	Software Software Engeenering

Jacek Szarapa - "Software Develper Delphi\C#\C\PHP\MS SQL\MySQL\Firebird - Freelance Programmer / Developer, Poland"

Software Development

Networking & Information Systems