Database Developer

Kandidát je specialistou na MS SQL DB se zaměřením na komplexní řešení problémů. Má zkušenosti z různých oblastí IT, včetně mikroelektroniky, programování, testování, CAD/CAM a CNC. S MIS DB (MS SQL) pracuje od roku 2001. Ve volném čase se věnuje technice, manuální práci, stavebnictví a autům. Motivuje ho poznávání nových a efektivnějších řešení ve svém oboru a rád využívá analytické myšlení při hledání odpovědí na nejasná zadání. Pracoval na zajímavých projektech, jako je podpora výroby PC na montážních linkách a integrace systémů pro plánování oprav. Má zkušenosti s analýzou kódu, vývojem v jazyce T-SQL, optimalizací DB a dolováním dat. Spolupracoval s různými klienty, například se společnostmi Innogy Group, Hartmann Rico a Ernst & Young. Má vysokoškolské vzdělání a postgraduální studium v oboru inženýrství. Ovládá angličtinu a má pasivní znalost němčiny, polštiny a ruštiny. Mezi jeho technické dovednosti patří MS SQL Server, T-SQL a další znalosti v jazycích C#, VB a WPF. Je držitelem certifikátu MSSQL 2005 - TSQL. Podílel se na různých projektech, včetně projektu FT pro zákaznický provoz, pomocného nástroje pro plnění databáze a aplikační podpory pro aplikace FT. Pracoval také na projektech pro ČSOB PFM, UPC ČR, E&Y a Českou Pojišťovnu. Kromě práce v oblasti IT se věnoval také solárním aplikacím a vývoji univerzálního CNC soustruhu.

Role 1: MS SQL DB Specialist

As an MS SQL DB Specialist, I have been technically focused on complex problem solving in the field of database management. I have experience in various IT fields such as microelectronics, programming, testing, CAD/CAM, and CNC. My expertise in MIS DB (MS SQL) spans over 18 years. I have a passion for learning about new and more effective solutions in my field and enjoy using analytical thinking to find answers to challenging assignments. Some of the most interesting projects I have worked on include supporting PC production on assembly lines, integrating repair planning systems, and optimizing database performance. I have worked with clients such as Innogy Group, Hartmann Rico, and Ernst & Young.

Role 2: MS SQL DB Specialist

In my role at Capitol, I was involved in the development and support of a FT project for customer operations on the PXE/CDCP securities market. I provided support over MS SQL and played a key role in the development of the project.

Role 3: MS SQL DB Specialist

During my time at CMRZB, I worked on an auxiliary tool for database filling in JSON format. This project involved converting data from Excel to MS SQL and was completed within a span of 7 months.

Role 4: MS SQL DB Specialist

At Linet Group, I participated in a pre-pilot operation where I was responsible for mapping attributes to dimensions and facts, developing stored procedures and views for the data warehouse layer, and defining MDS code lists and data sources. I also handled application busy requests for exceptions or local conventions.

Role 5: MS SQL DB Specialist

In my role at ČSOB FT, I provided application support for FT applications and was involved in the maintenance and development of the FT infrastructure.

Role 6: MS SQL DB Specialist

At ČSOB PFM, I analyzed and provided solutions for data integrity issues, developed scripts for data cleaning, and performed housekeeping tasks. I also worked on the initial load of data and handled job automation.

Role 7: MS SQL DB Specialist

During my time at UPC CZ, I worked on the Fénix Expedition project. This involved developing required back-end supplements with an error message system and updating SOAP services for the messaging system. I also worked on the development of tables, stored procedures, and functions for working with data and XML.

Role 8: MS SQL DB Specialist

At E&Y LIC, I worked on the development of the banking tool LIC for external consultants of banks and financial institutions. This involved working with MS SQL 2008 R2 and MSRS to develop solutions for credit cards and the American mortgage industry.

Role 9: MS SQL DB Specialist

During my time at Česká Pojišťovna, I worked on the LPU Property project. I designed triggers for evaluating event status and integration with the existing Eurocalc system.

Role 10: MS SQL DB Specialist

At Datalan SK, I worked on the Ekoos and Evoting projects. This involved analyzing business requirements, designing process flows and databases, and optimizing the relational database model.