Ukraine's #1 job service
Назар
SQL-програміст
- City:
- Kyiv
Contact information
The job seeker has entered a phone number .
Name, contacts and photo are only available to registered employers. To access the candidates' personal information, log in as an employer or sign up.
You can get this candidate's contact information from https://www.work.ua/resumes/17554197/
Uploaded file
Quick view
version
This resume is posted as a file. The quick view option may be worse than the original resume.
Piletskyi Nazar
[open contact info ](look above in the "contact info" section), [open contact info ](look above in the "contact info" section), Ukraine, Kyiv
Education
Master of Software Engineering Sep 2017 - Feb 2019
National Aviation University (Ukraine, Kyiv)
Bachelor of Software Engineering - Graduation grade: 77/100 Sep 2013 - Jun 2017
National Aviation University (Ukraine, Kyiv)
Professional experience
SQL Developer Mar 2019 - current time
IT-Star (team size – 6 members)
● DWH development
● Database optimization, creating tables, stored procedures, views, triggers, indexes etc.
(MySQL)
● ETL development using PHP, Python, bash from different sources (Databases, APIs,
files, logs, Google sheets etc)
● Writing scripts for scraping websites (Python)
● Version control and code management using GitHub
● BI administration, designing, scripts development (Sisense, Tableau)
● Implement database solutions based on business requirements of analytics team
● Create and document models for existing databases (reverse engineering) Dec 2021 - current time
SQL Lecturer/Mentor
Dan-IT (class size - 30 students)
● Lecturing and practical tasks in SQL(MySQL, Ms SQL, Oracle) for analytics
● Lecturing and practical tasks in SQL(MySQL, Ms SQL, Oracle) for database
design/optimization
● Interviewing candidates for lecturer position
SQL developer Aug 2017 – Mar 2019
Intellect Service (team size – 9 members)
●SQL development (Ms SQL, Oracle): databases optimization, creating tables, stored
procedures, views, triggers, indexes, performing database programming for management
and accounting automation system etc
●Writing procedures and functions using Pascal Script, Java Script, Basic Script
●Implement database solutions based on requirements of business analytics
Leading specialist of sales efficiency increasing Feb 2017 - Jul 2017
Raiffeisen Bank Aval (team size – 5 members)
●Writing, optimization and troubleshooting of SQL and T/SQL scripts
●Development of SQL module used for reporting automation
●Information analysis and consolidating
●Taking part in KPI system development and implementation
●Collaborate with business analytics to develop database solutions
SQL developer Mar 2016 - Jan 2017
Listex (http://listex.info/) (team size – 7 members)
● Database optimization, creating tables, stored procedures, views, triggers, indexes etc. (MySQL)
● Analysis of user requirements and developing specifications for the various database solutions
● Writing PHP scripts for information processing automation
● Writing the code part to provide correct data transfer from files to database (PHP)
● Work closely with business analytics to implement database solutions for their business requirements
● Create and document models for existing databases(reverse engineering)
Technical skills:
● Proficient knowledge of query languages T/SQL, SQL
● Experience in working with Git, Bitbucket, Docker, DBMS: MongoDB, Oracle, Ms SQL, MySQL, Project Management
system Jira
● BI: Sisense, Power BI, Tableau
● Knowledge of programming languages (PHP, Python, Java, C #, C / C ++, Pascal), HTML5, CSS3, bash
● Working with operating systems: Debian, Linux, Mint, Windows, macOS
● Installation and setting of network equipment
Language skills:
● Ukrainian - native
● English - Upper intermediate (Canada, Montreal, Dawson College Level 5)
Course:
English (Canada, Montreal) July 2014
Canada, Montreal, Dawson College, Level 5
Leadership:
● Participation in analysis of existing decision-making methods and software products in the field of information security
in Ukraine
● Development of decision-making support system aimed at providing simplification of decision-making process for
information security specialists on C# language, using the method of paired comparisons
● Participation in the improvement of the decision-making support system, development of the software module for risk
assessment for the decision-making support system on C# language
● Developed a Telegram bot that scans job websites and delivers up-to-date job openings tailored to specific criteria to
dedicated Telegram channels
Other achievements:
Qualified as an expert chess player in Ukraine and won first place at the junior Eastern European chess competition. Also captain of
the NAU team and twice captain of the regional chess team in Eastern Europe having won multiple regional competitions in chess.
[
Education
Master of Software Engineering Sep 2017 - Feb 2019
National Aviation University (Ukraine, Kyiv)
Bachelor of Software Engineering - Graduation grade: 77/100 Sep 2013 - Jun 2017
National Aviation University (Ukraine, Kyiv)
Professional experience
SQL Developer Mar 2019 - current time
IT-Star (team size – 6 members)
● DWH development
● Database optimization, creating tables, stored procedures, views, triggers, indexes etc.
(MySQL)
● ETL development using PHP, Python, bash from different sources (Databases, APIs,
files, logs, Google sheets etc)
● Writing scripts for scraping websites (Python)
● Version control and code management using GitHub
● BI administration, designing, scripts development (Sisense, Tableau)
● Implement database solutions based on business requirements of analytics team
● Create and document models for existing databases (reverse engineering) Dec 2021 - current time
SQL Lecturer/Mentor
Dan-IT (class size - 30 students)
● Lecturing and practical tasks in SQL(MySQL, Ms SQL, Oracle) for analytics
● Lecturing and practical tasks in SQL(MySQL, Ms SQL, Oracle) for database
design/optimization
● Interviewing candidates for lecturer position
SQL developer Aug 2017 – Mar 2019
Intellect Service (team size – 9 members)
●SQL development (Ms SQL, Oracle): databases optimization, creating tables, stored
procedures, views, triggers, indexes, performing database programming for management
and accounting automation system etc
●Writing procedures and functions using Pascal Script, Java Script, Basic Script
●Implement database solutions based on requirements of business analytics
Leading specialist of sales efficiency increasing Feb 2017 - Jul 2017
Raiffeisen Bank Aval (team size – 5 members)
●Writing, optimization and troubleshooting of SQL and T/SQL scripts
●Development of SQL module used for reporting automation
●Information analysis and consolidating
●Taking part in KPI system development and implementation
●Collaborate with business analytics to develop database solutions
SQL developer Mar 2016 - Jan 2017
Listex (http://listex.info/) (team size – 7 members)
● Database optimization, creating tables, stored procedures, views, triggers, indexes etc. (MySQL)
● Analysis of user requirements and developing specifications for the various database solutions
● Writing PHP scripts for information processing automation
● Writing the code part to provide correct data transfer from files to database (PHP)
● Work closely with business analytics to implement database solutions for their business requirements
● Create and document models for existing databases(reverse engineering)
Technical skills:
● Proficient knowledge of query languages T/SQL, SQL
● Experience in working with Git, Bitbucket, Docker, DBMS: MongoDB, Oracle, Ms SQL, MySQL, Project Management
system Jira
● BI: Sisense, Power BI, Tableau
● Knowledge of programming languages (PHP, Python, Java, C #, C / C ++, Pascal), HTML5, CSS3, bash
● Working with operating systems: Debian, Linux, Mint, Windows, macOS
● Installation and setting of network equipment
Language skills:
● Ukrainian - native
● English - Upper intermediate (Canada, Montreal, Dawson College Level 5)
Course:
English (Canada, Montreal) July 2014
Canada, Montreal, Dawson College, Level 5
Leadership:
● Participation in analysis of existing decision-making methods and software products in the field of information security
in Ukraine
● Development of decision-making support system aimed at providing simplification of decision-making process for
information security specialists on C# language, using the method of paired comparisons
● Participation in the improvement of the decision-making support system, development of the software module for risk
assessment for the decision-making support system on C# language
● Developed a Telegram bot that scans job websites and delivers up-to-date job openings tailored to specific criteria to
dedicated Telegram channels
Other achievements:
Qualified as an expert chess player in Ukraine and won first place at the junior Eastern European chess competition. Also captain of
the NAU team and twice captain of the regional chess team in Eastern Europe having won multiple regional competitions in chess.
Similar candidates
-
SQL-программист
30000 UAH, Kyiv, Remote -
SQL-програміст
40000 UAH, Kyiv, Remote -
SQL-програміст
Kyiv, Bucha, Remote -
SQL-розробник
Kyiv, Remote -
SQL-програміст
30000 UAH, Kyiv -
SQL-програміст
100000 UAH, Kyiv, Remote
Compare your requirements and salary with other companies' jobs:
The candidate's resume is posted at https://www.work.ua/resumes/17554197/