Burak Demirtas

I joined Yale University's Academic Analytics team as a Business Intelligence Developer and Data Analyst by Sep '23. I'm still working as a full time member of Yale. My daily routine looks like:

• General support and QA activities on FLA Datamart (SQL Server) project, creating logic and codes needed for new fields to provide to the data architecture team, defining requirements for structural changes. (Data engineering, lost of SQL coding)

• Defining needs for coming data requests and external surveys, creating data pipelines and data flows needed for accurate and seamless reporting

• Creating interactive reports & dashboards on Power BI service and maintenance

• PBI Service workspace and SharePoint Site administration

• Leading the technical initiatives, creation of security documentation and check tools, providing technical consultancy on data analytics or MS power platform related topics 

I have attended the MIT's Data Science and Machine Learning (with Python) and Datacamp's Professional Data Analyst (with R) certification programs and got certifications from both. In MIT's course, I completed the course as the 2nd best student in the program.

I have completed MSc. in Business Analytics which was heavily based on R programming, statistics, machine learning, deep learning, data analytics, data visualization, database management and data science. After my exceptional success in the first semester, I also became a TA for Business Analytics lab classes, created lab curriculum and tutored R programming, statistics and advanced excel to both undergraduate and graduate students. Finally, I have completed my program with 4.0 GPA and "Outstanding Achievement Award" which is given to the best students of the program.

During my time as a supplier product quality development engineer, my main responsibility revolved around ensuring timely delivery of parts that met our quality standards and design specifications. This role resembled a combination of technical auditing and project management. However, along the way, I discovered a strong inclination towards developing my skills in data analytics rather than solely focusing on engineering. The signs of my inner passion were evident. For instance, while using QlikSense to access quality and project data, I went beyond mere utilization and learned to create dashboards with it. Another one; my task was "reviewing the lessons learnt process" which was going on excels and ppts. I didn't stop just by reviewing it, but also, we created a return of experience database and application with PowerApps. The point is: I had zero experience with PowerApps, yet I knew MS Access and how to build an interface linked to data behind. I said "we can do it!", and we did it!

After years of blending engineering, data analysis, and programming, my heart became set on focusing solely on data analytics, programming, and data science. This conviction led me to make the boldest decision of my life—to move to the United States and pursue my dream of becoming a Data Scientist. 

I started to aerospace as continuous improvement expert. I have consulted six sigma projects and initiated lean applications, gave trainings and I was a part of lean transformation of Turkish Aerospace. I heavily relied on my statistical data analysis, SQL and data visualization skills and my six sigma expertise in this role to improve the processes with data-driven approach. That's where I truly learned reporting and dashboarding tools like SAP Crystal Reports and Microsoft Report Builder with MS SQL Server. I also used my MS Access and VBA skills to create a software to automize the work orders of my area. Also, I've created a "Quality Issues Tracking System" to analyze better the root causes of the quality problems.

In the digital transformation department, I worked with machine learning experts and that's where truly initiated my interest on Machine learning.

I was mainly responsible for new product launch coordination at Ford's product development team. (PVT) This position provided me with opportunities to enhance my advanced Excel skills, including extensive use of VBA, and develop expertise in SQL and Oracle & IBM DB2 table structures used in our ERP (CMMS) and Engineering Release (WERS) systems. By writing thousands of lines of VBA code in MS Access, I successfully finalized our engineering change tracking system. Our innovative approach to engineering changes, facilitated by a smart system, enabled us to implement hundreds of parts each year with great success. I also became a true MS Access developer and expert. (certified by Bilge Adam with "Advanced MS Access Certification")

Also, I took my Six Sigma Green Belt and Black Belt trainings at FORD including Minitab trainings. That was an amazing hands on experience on using statistical analysis on real world engineering problems. 

Throughout my career, starting from high school years, I was always into software, data and analytics.  During my undergrad years, I was running a WordPress blog. I used HTML , CSS, and PHP along with MySQL in those years. I have also learnt VBA for Excel macros which saved me in the future from a lot of routine tasks. Yet, my first serious programming experience was with MATLAB. After doing all my school projects with Matlab, I've done my last project on 'Creating the emission map of a public bus from one stop to another by using real time data gathered from the bus.' The study was also used in the Phd research after me.