Database Developer

Kandidát je špecialista na MS SQL DB so zameraním na komplexné riešenie problémov. Má skúsenosti v rôznych oblastiach IT vrátane mikroelektroniky, programovania, testovania, CAD/CAM a CNC. S MIS DB (MS SQL) pracuje od roku 2001. Vo voľnom čase ho baví technika, manuálna práca, stavebníctvo a autá. Motivuje ho spoznávanie nových a efektívnejších riešení v jeho odbore a rád využíva analytické myslenie pri hľadaní odpovedí na nejasné zadania. Pracoval na zaujímavých projektoch, ako je podpora výroby PC na montážnych linkách a integrácia systémov plánovania opráv. Má odborné znalosti v oblasti analýzy kódu, vývoja jazyka T-SQL, optimalizácie DB a dolovania údajov. Spolupracoval s rôznymi klientmi vrátane spoločností Innogy Group, Hartmann Rico a Ernst & Young. Má vysokoškolské vzdelanie a postgraduálne štúdium v oblasti inžinierstva. Ovláda anglický jazyk a má pasívnu znalosť nemčiny, poľštiny a ruštiny. Medzi jeho technické zručnosti patria MS SQL Server, T-SQL a ďalšie znalosti v jazykoch C#, VB a WPF. Je držiteľom certifikátu MSSQL 2005 - TSQL. Podieľal sa na rôznych projektoch vrátane projektu FT pre zákaznícke operácie, pomocného nástroja na napĺňanie databázy a aplikačnej podpory pre aplikácie FT. Pracoval aj na projektoch pre ČSOB PFM, UPC CZ, E&Y a Českú pojišťovnu. Okrem práce v oblasti IT sa venoval aj solárnym aplikáciám a vývoju univerzálneho CNC sústruhu.

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.