Burçin Yazıcı
Verified Expert in Engineering
SQL and Web Developer Developer
Istanbul, Turkey
Toptal member since October 11, 2021
Burcin is an SQL and web developer with 20+ years of experience. He developed web-based financial products and designed transactional databases for more than 15 years. He can design relational databases with a performance perspective and write stored procedures for SQL Server, PostgreSQL, and MySQL, and prefers using MongoDB for NoSQL requirements. He develops web projects with Spring Boot and specializes in Java back end and Docker containers as well.
Portfolio
Experience
- SQL - 18 years
- Relational Databases - 14 years
- Relational Database Design - 12 years
- PostgreSQL - 7 years
- Data Analytics - 6 years
- REST APIs - 6 years
- Linux - 6 years
- MongoDB - 4 years
Preferred Environment
Docker, PostgreSQL, SQL Server 2016, Java 8, SQL, MongoDB, Relational Database Design, Google Cloud Platform (GCP), Query Optimization, Kubernetes
The most amazing...
...thing I've developed is an API that became a kind of sector standard. The API provided collecting daily portfolio assets for consolidation and reporting.
Work Experience
Database Administrator
Bractlet, Inc.
- Maintained all cloud-based PostgreSQL databases of the project.
- Observed performance improvement possibilities and solved performance issues.
- Planned an extensive timescale database migration (PostgreSQL) and applied over terabytes of data.
Analytics Product Team Leader
Infina
- Developed a web app that provides data-entry pages and management reports for a mid-sized company.
- Built REST APIs that collect asset definitions and prices and serve that data as APIs. Used Microsoft SQL Server and Spring Boot.
- Created business intelligence dashboards that collect data from multi-sources, clean, and do calculations for the finance sector. Dimensional modeling is used for that project in Qlik Sense.
- Developed an internal project, maintaining data-vendor data. MongoDB and API with Spring Boot were used as the main technologies.
- Developed custom ETL projects for fİnancial data with Python and Postgres.
- Created data migration and report generation for a company in the banking sector with Power BI. Collected data from web services and Excel files.
Software Team Leader
Infina
- Implemented projects for a stock exchange module and redesigned order management communication with Istanbul Stock Exchange with Java and Message Queuing (MSMQ).
- Designed and implemented new features for brokerage house operations software based on Microsoft SQL Server.
- Developed a buy and sell risk calculation for a trading module with Java and SQL Server.
- Created a project about remodeling some parts of a big relational database for performance improvement.
- Developed the portfolio performance calculation project. Used Python for calculations and Spring Boot for creating APIs to serve calculated data and prepared dashboards with data analytics.
Software Developer
Infina
- Developed dozens of screens for the brokerage house operations web application with Java, Sybase, and stored procedures.
- Created the database design for equity and fixed-income security operations.
- Executed a Sybase DBA role to handle customer database implementations. Organized and developed backup loads, database optimizations, and data migrations.
Software Specialist
Dogan Holding
- Developed CRM, call center, customer services, website, credit card integration, and finance software (Logo Pro) integration.
- Built a web-based inventory application for internal use with ASP.NET and SQL Server.
- Developed a utility for investors to see asset prices and calculations based on the data from data vendors within a company.
Software Specialist
eNova
- Created a web-based B2B project for providing communication with HQ and branches for a telecommunication company.
- Developed a project in cooperation with Ericsson Crea World. It was about processing incoming SMS messages and sending processed response messages to the sender using .NET and SQL Server 2000 technologies.
- Made an application using Embedded Visual Basic and SQL Server for CE. It consists of managing surveys, collecting data, and transferring data to the central database.
- Developed a project about transferring data from Microsoft Access to SQL Server. Access database held a product catalog of about 80,000 records in total.
Software Developer
VeriPark Companies
- Developed an e-banking web application for a well-known local bank.
- Implemented an e-invoice payment functionality for the e-banking app that requires communication with banking legacy systems.
- Contributed to various B2B and B2C web-based projects and implemented database design.
Experience
Guide to Camera Website
Highly detailed product definitions were saved to the database with the admin form. Based on these product details, automated reviews and comparisons were generated.
Crypto Robo Web Project
Java, Servlet, Bootstrap, and MySQL are used for development. I implemented integration with the BtcTurk, a crypto trading website known in Turkey.
This website is not active right now.
Scraping eCommerce Website Products
https://github.com/byazici/python-homedepot-scrapeEducation
Bachelor's Degree in Mathematics and Computer Science
Istanbul Technical University - Istanbul, Turkey
Certifications
Finance Fundamentals in Python Track
DataCamp
Financial Analytics in Spreadsheets
DataCamp
Skills
Libraries/APIs
Complex SQL Queries, REST APIs
Tools
Microsoft Excel, Jira, Qlik Sense, Git, Microsoft Power BI, Excel 2007, BigQuery, Google Analytics, pgAdmin, GitHub
Languages
SQL, Python, SQL DML, Transact-SQL (T-SQL), Java, PHP, Bash, Active Server Pages (ASP), HTML, JavaScript, XML, Stored Procedure
Paradigms
ETL, Automation, Business Intelligence (BI), API Architecture, Database Design, Agile
Storage
Microsoft SQL Server, Relational Databases, Databases, SQL Architecture, Database Modeling, JSON, Data Pipelines, PostgreSQL, SQL Server 2012, SQL Server 2016, MySQL, NoSQL, Database Architecture, Database Administration (DBA), Database Migration, Google Cloud SQL, Database Backups, MongoDB, SQL Server 2007, SQL Server 2000, Sybase, Google Cloud, SQL Stored Procedures, Database Performance
Frameworks
Spring Boot
Platforms
Docker, Linux, Google Cloud Platform (GCP), Linux CentOS 7, Airbyte, Oracle, Amazon Web Services (AWS), Kubernetes, QlikView
Industry Expertise
Web Design
Other
Relational Database Design, Data, Data Engineering, Data Modeling, Reporting, Architecture, Database Schema Design, Data Queries, Data Migration, CSV File Processing, API Integration, APIs, JSON REST APIs, Data Warehousing, Data Architecture, Consulting, Database Optimization, Data Analytics, Dashboards, Data Management, Data Warehouse Design, Software Consulting, Data Scraping, Performance Tuning, Scripting Languages, Data Visualization, Data-driven Dashboards, Excel 365, Data Processing Automation, Data Analysis, Scripting, Data Security, Google BigQuery, Monitoring, FastAPI, Finance, Mathematics, Financial Calculations, Cryptocurrency, Analytics, Back-end Development, Message Queues, Data Science, Query Optimization, Amazon RDS, Google Data Studio, Google Pub/Sub, Internet of Things (IoT), Data Build Tool (dbt)
How to Work with Toptal
Toptal matches you directly with global industry experts from our network in hours—not weeks or months.
Share your needs
Choose your talent
Start your risk-free talent trial
Top talent is in high demand.
Start hiring