Wednesday, February 23, 2011

Simple Resume Template - Tomasz Pęczek - http://tpeczek.blogspot.com/


ęczek
Golkowice 486, 30-698 Kraków
phone: 505 131 056
e-mail:
tpeczek@gmail.com
TECHNICAL SKILLS AND COMPETENCES
Software Designing: UML
Software Development: C# (.Net Framework 2.0/3.5/4.0), C/C++ (STL/WinApi)
Databases: SQL, PL/SQL, MS SQL Server, Oracle
Web Development: ASP.NET MVC, ASP.NET, ASP.NET AJAX, XHTML, CSS,
JavaScript, jQuery
Additional: XML (XSD, XSLT), WiX
PERSONAL INFORMATION
Date of birth: 06.09.1984, Sosnowiec
Nationality: Polish
EDUCATION
2003 – 2008 Silesian University of Technology in Gliwice
Faculty of Automatic Control, Electronics and Computer Science; Institute of
Computer Science, specialization: „System Software” graduated with honors.
1999 – 2003 IV Liceum Ogólnokształc
WORK EXPERIENCE
I 2009 – present Global Services sp. z o.o. –
ące im. Stanisława Staszica in Sosnowiec
Software Development Engineer
·
of application architect and developer in a pilot project in this technology.
Introduction of ASP.NET MVC technology into the company, taking the role
·
web applications in ASP.NET 3.5 and ASP.NET AJAX technologies.
Performing the role of application architect and lead developer for number of
·
processes management module for the National Health Fund Departments,
based on Windows Workflow Foundation technology.
Performing the role of application architect and developer for business
·
in Smart Client Software Factory technology.
Performing design and development tasks within the .Net desktop applications
·
use of Windows Communication Foundation technology.
Development of SOA architecture in National Health Fund Departments with
·
module implemented as Windows Services.
Performing the role of application architect and developer for system services
·
Designing and developing for Oracle database
·
Creating application installers in WiX technology
·
Conducting internal technologies trainings.
XI 2009 – I 2011 TECHBAZA.PL sp. z o.o. –
Software Developer
·
build with use of ASP.NET 3.5, ASP.NET AJAX and PostgreSQL database.
Working as developer in „Techbaza.pl” project – an online prices comparer,
·
"Techbaza.pl" project.
Preparation of individual and commercial users management system for the
·
Development of the products filtering system of the portal.
·
Development of the favorite products module.
·
Design and development of the advanced statistics module.
·
Development of the errors reporting module.
·
Design and development of images host module.
VI 2009 – VI 2010 Gospodarstwo Pomocnicze przy CMJ –
Application Architect, Software Developer
·
wska
developed with use of ASP.NET 3.5, ASP.NET AJAX and SQL Server 2008
database.
Performing all design and development tasks within the "System badaniaźników jakościowych" ("Quality indicators research system") project,
XI 2006 – XII 2008 Gliwickie Studio Komputerowe –
At the beginning as Software Developer and after one year also as
Application Architect (.Net)
·
sp. z o.o. (working in „System Informatyczny Wspomagania Działalno
NFZ” (National Health Fund Activity Support System) project).
Working as a subcontractor for Sygnity S.A. and after that for Global Servicesści
·
in „Systemu Informatycznego Wspomagania Działalno
carrying out the process of their migration to ASP.NET AJAX technology.
Obtaining the role of the application architect for most of the Web applicationsści NFZ”, and then
·
National Health Fund Departments, based on Windows Workflow Foundation
technology.
Design and development of business processes management module for the
·
of SIWDNFZ system (with use of Smart Client Software Factory technology)
Performing design and development tasks within the .Net desktop applications
·
use of Windows Communication Foundation technology.
Development of SOA architecture in National Health Fund Departments with
·
Designing and developing for Oracle database.
XII 2005 – X 2006 Biuro Usług Rynkowych Zbigniew Maciej Szymik
Network Administrator
·
1 server)
Administration of company network based on Windows 2003 Server (20 users,
·
Installation and configuration of Windows 9x/2000/XP based stations
·
Administration of Microsoft SQL Server database
·
accounting software
Installation, configuration and assist in the implementation of financial and
·
Configuration and repairs of hardware
VI 2005 – XI 2005 Firma Wasyluk.com
– Game Developer
·
Poland
Organization and administration league games in Electronic Sports League.
PRESENTATIONS
X 2010 – Rich user interface in ASP.NET MVC applications with jQuery plugins
Presentation at
Microsoft Technology Summit 2010, Warsaw, Poland.
CERTIFICATES
Microsoft Certified Professional Developer – Windows Developer
Microsoft Certified Professional Developer – Web Developer
Microsoft Certified Technology Specialist – .Net Framework 2.0 Windows
Applications
Microsoft Certified Technology Specialist – .Net Framework 2.0 Web Applications
Microsoft Certified Technology Specialist – .Net Framework 3.5 Windows Workflow
Foundation Applications
Microsoft Certified Technology Specialist – .Net Framework 3.5 ASP.NET
Applications
KNOWLEDGE OF LANGUAGES
English- fluent in writing and speaking (confirmed by FCE certificate)
ADDITIONAL INFOMARTION
Blog: http://tpeczek.blogspot.com/
Microsoft course: „Microsoft SQL Server”
Driving License: Category B
„Wyra
niezb
Osobowych, Dz. U. Nr 133, poz. 883).”
żam zgodę na przetwarzanie moich danych osobowych zawartych w tym dokumencie dla potrzebędnych do realizacji procesu rekrutacji (zgodnie z ustawa z dnia 29.08.1997 o Ochronie Danych

Tomasz P

Tuesday, February 22, 2011

Taking one sample from each group

Problem : You have a database table like following and want to return only one DeviceIMEINo for
one type of UnitModel.



UnitModelDeviceIMEINo 
GPRMC357224020036161 
GPRMC357224020065137 
KS-1689650492806 
KS-16813632782450 
M1AVL355689017535734 
M1AVL359587013296408 
M1AVL359587013296655 
M1AVL359587013296846 
M1AVL359587013296879 
M1AVL359587013297331 
M1AVL359587013297430 
M1AVL359587013297992 
M1AVL359587013299576 
M1AVL359587013302065 
M1AVL359587013307155 

This table is actually result of group by query:
select UnitModel , DeviceIMEINo from livedatagroup by UnitModel , DeviceIMEINo order by UnitModel , DeviceIMEINo

You need to write a subquery for this :
select unitmodel , deviceimeino , ID from (select UnitModel , DeviceIMEINo ,row_number() OVER ( partition by unitmodel order by unitmodel) as id from livedatagroup by UnitModel , DeviceIMEINo ) Awhere id = 1

The inner table creates a row_number column  . The outer query simply takes one rec from each group
with id = 1 (i.e. min id ) You can take min  or max as well if required.

The result is as follows :

unitmodeldeviceimeinoID
GPRMC3572240200361611
KS-16896504928061
M1AVL3595870149474621

Wednesday, February 9, 2011

CREATE TRIGGER AND ALTER TRIGGER MUST BE THE FIRST STATEMENT IN A QUERY BATCH.

CREATE TRIGGER AND ALTER TRIGGER MUST BE THE FIRST STATEMENT IN A QUERY BATCH. EVEN A 'USE' DATABASE command is not allowed. SO THE FOLLOWINNG :

USE GPS_Live
ALTER TRIGGER [dbo].[Trigger_gt06_1]
ON [dbo].[gt06]
AFTER INSERT

GIVES Following ERROR :
'ALTER TRIGGER' must be the first statement in a query batch.

The error is given for create trigger also