Ender is available for hire
Hire EnderEnder Akpil
Verified Expert in Engineering
Software Developer
Istanbul, Turkey
Toptal member since June 18, 2020
Bio
Ender is a leader with an impressive 15+ years of experience in delivering advanced solutions, implementing technical and business strategies for Turkey’s biggest corporations. His top accomplishments include many DWH and BI project implementations—development or lead role—on on-prem or in the cloud. Also, he has expertise in data modeling and governance, master data and metadata management, BI architecture, and data visualization.
Portfolio
Freelance Work
Azure Data Factory (ADF), Azure Synapse, ETL, Azure SQL, Data Governance...
Freelance
Microsoft SQL Server, Oracle, Snowflake, Oracle Database...
phiLogica
Business Objectives...
Experience
- Oracle RDBMS - 15 years
- T-SQL (Transact-SQL) - 15 years
- PL/SQL - 15 years
- Microsoft SQL Server - 15 years
- Java - 15 years
- SQL - 15 years
- JavaScript - 10 years
- Python 3 - 2 years
Availability
Part-time
Preferred Environment
Azure, Amazon Web Services (AWS), Google
The most amazing...
...project I've created is a telco commission management system, a flexible architecture that applied huge amounts of data daily.
Work Experience
Data Team Manager
2019 - PRESENT
Freelance Work
- Performed two major projects. One of them is a supermarket with +10k stores, eCommerce, and mobile app sales. The platform was implemented in hybrid architecture and contains many components such as MDM, streaming, DWH, CRM, and campaign management.
- Implement a solution that collects all information from stores and distributors daily in Azure for a middle east country that aims to control the price and stock level of some major products and materials.
- Developed a retail data model and reusable components. I built and transformed the team to use cloud technologies.
Technologies: Azure Data Factory (ADF), Azure Synapse, ETL, Azure SQL, Data Governance, Oracle Database, Data Privacy
Developer
2016 - PRESENT
Freelance
- Prepared a Datamart for IFRS reporting on SQL Server for one of the international banks. Designed a data model and populate it with data.
- Prepared a requirement driven data model on Oracle database for one of the International Insurance Company which has products on life, non-life, and pension.
- Prepared a data transformation solution on SQL Server and SSIS which uses excel files as the source system. Designed a target data model on SQL Server for a company serving in the financial sector.
- Gave Bitcoin training at The Banks Association of Turkey.
- Prepared a dashboard for a company serving in the financial sector.
Technologies: Microsoft SQL Server, Oracle, Snowflake, Oracle Database, Microsoft Azure Cloud Server, Data Privacy
Lead Architect
2007 - 2016
phiLogica
- Developed a data quality framework with PL/SQL for one of the GSM company. They used it to test and profile the data before populating their target systems.
- Developed a commission management system for a GSM Company, which delivers around 200 million based on that system output. The daily amount of processed data is more 4TB and the number of rules applied to data is more than 200. OBIEE and ODI are also used for reporting, data transformation respectively.
- Utilized Oracle, Sybase IQ, and business objects to perform a monthly, quarterly and yearly performance measurement of the branch. There were very complex rules and transaction types from banks operation.
- Implemented a dealer management system for a GSM company on Oracle Exadata and BO (business objects) was implemented. End to end design and implementation done by using PLSQL and ODI.
- Implemented an end-to-end data warehouse solution by using OCDM (Oracle communication data model). Oracle Exadata, Exalytics, OBIEE, ODI, and PLSQL was used as the technology stack.
- Gave Business Intelligence 101 and Data Modeling training at The Banks Association of Turkey. My average teacher evaluation score was above 9 over 10.
- Completed assessment study for one of the biggest banks and insurance firms. The main goal is to analyze current structure, identify problems, and prepare a roadmap to support their business now and in the future. Created specifications to measure the success of data management to support the continuity of the system.
- Contributed to several other small or mid-size projects. Most of them were a data transformation project for a subject area at banks or insurance firms. Commonly used technology or database system was Oracle or Sql Server.
Technologies: Business Objectives, Oracle Business Intelligence Enterprise Edition 11g (OBIEE), Oracle Data Integrator (ODI), Teradata, Microsoft SQL Server, SAS, Oracle, Oracle Database, Data Privacy
Experience
GSM Commission System
GSM firms work heavily with dealers and distribuıtors. And gave them a huge amount of commisisoın for a different type of transactions monthly, quarterly or yearly. To calculate these commissions you have to deal with a lot of data and lots of data quality rules. Also business keeps changing since GSM is a dynamic sector, you need an expandable system so we try to implement a design pattern named Open - Close. It was a very flexible and powerful data solution. Plsql, ODI, Java, shell script, UC4, and OBIEE is used as the technology stack.
Bank Branch Performance System
Banks have branches and employees. To measure their performance we created a database solution based on rules on different transactions. It was one of the challenging projects since there were too many rules and transactions. Capturing all rules and find related data and apply all data quality rules on it was very difficult and required high attention and focus.
Sybase IQ, Oracle, and Business Objects were used.
Sybase IQ, Oracle, and Business Objects were used.
Education
2007 - 2009
Master's Degree in Actuarial Science
Bahçeşehir University - Istanbul, Turkey
1993 - 2002
Bachelor's Degree in Mathematics
Middle East Technical University - Ankara, Turkey
Skills
Tools
Toad, Oracle Business Intelligence Enterprise Edition 11g (OBIEE)
Languages
SQL, T-SQL (Transact-SQL), Snowflake, SAS, Java, JavaScript, Python 3
Frameworks
Apache Spark
Paradigms
ETL
Platforms
Azure Synapse, Oracle Database, Oracle, Oracle Data Integrator (ODI), Azure, Amazon Web Services (AWS)
Storage
PL/SQL, Oracle RDBMS, Microsoft SQL Server, SQL Server Management Studio (SSMS), Teradata, Azure SQL
Other
Azure Data Factory (ADF), Data Governance, Microsoft Azure Cloud Server, Data Privacy, Business Objectives, Actuarial, Mathematics, Google
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.
1
Share your needs
Discuss your requirements and refine your scope in a call with a Toptal domain expert.
2
Choose your talent
Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.
3
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