Merve is available for hire

Merve Seren

Verified Expert in Engineering

Back-end Developer

Location

Eindhoven, Netherlands

Toptal Member Since

November 22, 2021

Merve is an experienced analytics engineer. During her six years of work experience, she always combined her data analytics skills with a solid technical background by taking the responsibility of designing, transforming, and visualizing the data and creating and maintaining the data pipelines. Merve is most proficient in working with SQL, PySpark, Databricks, Microsoft PowerBI, and Tableau,

Data Analysis Enterprise Resource Planning (ERP)Data Visualization SQL Toad Oracle Forms Oracle Workflow XML Publisher Oracle PL/SQL Oracle SQL PL/SQL Oracle Relational Databases Oracle E-Business Suite (EBS)Business Intelligence (BI)Databricks Platform Oracle EBS SUN

Portfolio

Sympower

Databricks, PySpark, SQL, Data Modeling, Microsoft Power BI, Data Visualization

Roketsan

SQL, Performance Tuning, Oracle EBS, SOAP, Tableau, Data Analysis, Oracle Forms...

Roketsan

Business Intelligence (BI), SQL, Data Analysis, Dashboard Design...

Experience

SQL - 6 years Entity-relationships Model (ERM) - 5 years Tableau - 3 years Business Intelligence (BI) - 3 years PySpark - 2 years Databricks - 2 years Microsoft Power BI - 1 year Python - 1 year

Availability

Part-time

Preferred Environment

SQL, Tableau, Business Intelligence (BI), Python, PySpark, Databricks, Microsoft Power BI

The most amazing...

...solution I've developed is an integration of a 3rd-party supplier relationship management software with the Oracle ERP system.

Work Experience

Analytics Engineer

2022 - PRESENT

Sympower

Used star-schema data modeling approach to define and draw the most suitable structure for each use case.
Developed data pipelines in PySpark and centralized company data in Databricks.
Created many dashboards in Microsoft PowerBI to help different teams throughout the company.
Created self-service data tools in Databricks to make company data accessible without assistance.
Possessed knowledge of many Databricks features such as workflows, Delta tables, unity catalog, and SQL editor.

Technologies: Databricks, PySpark, SQL, Data Modeling, Microsoft Power BI, Data Visualization

ERP Applications Developer | Data Analyst

2016 - PRESENT

Roketsan

Performed the back-end Oracle PL/SQL development of applications built by different technologies such as .NET.
Built workflows to speed up business processes and provide communications between different users and units of the company.
Used Oracle Forms Builder, Oracle Discoverer, and Oracle Concurrent Request to develop Oracle EBS applications, such as a supplier quality control application, a custom requisitions application, and integration interfaces.
Provided user support on the Oracle Purchasing module in a company with 3,000 users.
Used Oracle APIs and customization modules to apply user-demanded customizations to Oracle applications.
Created data models by listening and analyzing customer requirements and implemented the database development of those models.

Technologies: SQL, Performance Tuning, Oracle EBS, SOAP, Tableau, Data Analysis, Oracle Forms, Oracle Workflow, XML Publisher, Python, Oracle PL/SQL, Oracle Discoverer, Entity-relationships Model (ERM), Data Integration, Pandas, Requirements Analysis, Agile Sprints, Agile, Scrum, Oracle SQL, Customer Support, Data Processing, Data Preparation, Toad, Relational Databases, Database Modeling, Subversion (SVN), Systems Thinking, Programming

Senior Data Analyst | BI Developer

2016 - 2021

Roketsan

Collaborated with different business units to understand their data visualization and reporting needs and created Tableau dashboards for different management levels.
Wrote queries and created views to provide data sources for Tableau dashboards.
Developed web services between the Oracle ERP system and 3rd-party software, such as PLM and SRM.
Performed SQL tuning for low-performance queries and views.

Technologies: Business Intelligence (BI), SQL, Data Analysis, Dashboard Design, Oracle SQL Developer, PL/SQL, Web Services, Performance Tuning, Oracle EBS, Tableau, Data Visualization, Relational Databases, SoapUI, Database Modeling, Subversion (SVN), Toad, Systems Thinking, Programming

Experience

Supplier Relationship Management Software Integration

The software was integrated into the Oracle ERP system. I took part in different project steps and worked close to the in-house system's functional users and software developers. The two groups analyzed business requirements, and we made software integration decisions, first from a functional point of view and then from a technical one. I was then responsible for developing web services using the Oracle SOAP Web Service technology and the Oracle PL/SQL to write the web service package. Current-used ERP applications included new features and change requests during the project, which led to the needed Oracle PL/SQL development.

PLM Integration

This project included integrating PLM software into the Oracle ERP system and sending both item and BOM information created on PLM to Oracle. I developed the web service using Oracle SOAP Web Service technology and Oracle PL/SQL to write the web service package. I also built an integration interface using Oracle Forms technology.

Quality Control Dashboards for Production

Prepared several Tableau dashboards for the company's quality control workshops. These dashboards rotate on TVs during the workshops and are open to instant access by employees. Employees can track their weekly or daily transactions, waiting for items or scrap and rework rates. The company received good feedback from the employees.

Tableau Dashboards for a Brazilian eCommerce Website

https://public.tableau.com/app/profile/merve.seren.boyac.

Created three business-related dashboards for a Brazilian eCommerce website as part of a self-study project. The dashboards give information on sales, shipment performances, and seller performances and use datasets provided by Kaggle.

Skills

Languages

SQL, Python

Tools

Toad, Oracle Forms, Oracle Workflow, SoapUI, Oracle E-Business Suite (EBS), Oracle ERP, Subversion (SVN), Tableau, Microsoft Power BI

Paradigms

Requirements Analysis, Business Intelligence (BI), ETL, Scrum, Agile, Unit Testing

Platforms

Oracle, Databricks

Storage

XML Publisher, Oracle PL/SQL, Oracle SQL, PL/SQL, Relational Databases, Database Modeling, Data Integration, Oracle SQL Developer

Other

Systems Thinking, Analytical Thinking, Programming, Data Analysis, Entity-relationships Model (ERM), Customer Support, Data Processing, Data Preparation, Data Visualization, Enterprise Resource Planning (ERP), Management Information Systems (MIS), Performance Tuning, Oracle EBS, Oracle Discoverer, SOAP, Agile Sprints, Dashboard Design, Web Services, Data Engineering, Data Modeling

Libraries/APIs

Pandas, Oracle API, PySpark

Education

2011 - 2016

Bachelor's Degree in Industrial Engineering

Middle East Technical University - Ankara, Turkey

Collaboration That Works

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

Discuss your requirements and refine your scope in a call with a Toptal domain expert.

Choose your talent

Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.

Start your risk-free talent trial

Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.

Top talent is in high demand.

Start hiring