Ottawa, ON | aselekoglu97@gmail.com | LinkedIn | GitHub
Technical Business Analyst with 3 years of experience in process optimization, automation, and management of CRM systems. Spearheaded multifaceted projects aimed at optimizing operational efficiency across sales, marketing, and project departments, leveraging advanced technical skills by enhancing CRM automation tools with custom middlewares via JavaScript. Led projects such as development and implementation of tailored scripting solutions for meticulous goal tracking, seamless CRM integration via REST APIs, and comprehensive process automation.
Call Center Studio | Remote | Mar 2021 – Feb 2024
Responsible for business process integrations, CRM management, and custom scripting (JS - Google Script). Spearheaded in navigating and transforming processes amid the company's rapid expansion, as the sole Business Analyst in the company. Designed and implemented financial processes such as invoice calculation, forecasting and collection; marketing processes such as lead tracking, lead distribution and meeting scheduling by region, leveraging technical expertise to streamline operations. Engineered sophisticated middleware solutions and automation tools, utilizing a wide range of skills such as integrating with different APIs, manipulating JSON data, employing event-driven triggers, and demonstrating adeptness in various software development methodologies and library utilization, ensuring seamless workflow orchestration and data synchronization.
Call Center Studio | Istanbul, Turkiye | Oct 2020 - Mar 2021
Played a pivotal role in the department's early stages, leveraging the opportunity to enhance operational efficiency. Actively engaged with several teams to understand and optimize processes within sales, marketing, and project departments. Key involvement in the strategic selection of a suitable CRM system through effective planning and execution of the procurement process.
Bogazici University | Istanbul, Turkiye | Sep 2017 - Jan 2023
Management Information Systems
Acquired Skills: Java, Kotlin, Python, JavaScript, OOP, COBIT/IT Governance, CRM, Arduino IDE, HTML/CSS, MySQL, Cisco IOS
Developing an Android Application for Crowdsourcing: Spotify to Chords | 2023
Designed and implemented a crowdsourcing application using Kotlin, leveraging Spotify API’s Audio
Analysis Endpoint to grant users instant access to song chords. To incorporate the functionalities of a
similar open-source study, created an API endpoint with ExpressJS to establish seamless communication
between the Android app and the pre-existing study, enabling the Android app to request Spotify Track
IDs and retrieve processed chord data for direct display to the user. Additionally, integrated social
media features for user interaction and utilized Firebase for efficient user
authorization/authentication and data management.
Presentation: YouTube
Developed a new accessory class for the Homebridge platform to control a Tuya-based pet feeder,
enabling seamless integration and control via Apple HomeKit. Implemented custom accessory logic
using
TypeScript, handling device commands and status updates through the Tuya API. Enhanced the existing
homebridge-tuya-web plugin by creating a PetFeederAccessory class, which included methods to start
and stop the feeder
and to retrieve the current feeding. Updated the configuration and index files to support the new
accessory type,
ensuring a smooth user experience for Homebridge users.
GitHub: Project
Repo
Engineered a custom middleware in Google Script to transfer deal object information from Hubspot CRM to Zoho CRM by using UrlFetchApp for HTTP requests, XML parsing for data extraction, and JSON manipulation for processing. The project aimed to synchronize data between different CRMs used by various departments, ensuring data reliability. The middleware retrieved deal object information, including associated line item objects, from Hubspot, processed the data, and pushed it to Zoho as account, potential, and sales order objects. Utilized: JS (Google Script), API, CRM, JSON.
Implemented middleware using Google Script to track sales goals. Created a custom object "Goals"
within the CRM and established a workflow to push created goals to Google Sheets. Utilized
event-driven triggers on Google Script to process each goal based on type and duration. Triggers
execute functions upon goal completion, querying the CRM based on goal details (team/personal goal,
new qualification/contracts signed, etc.) and associating the fetched objects (contacts or deals)
with the initial Goals object in the CRM. Calculated KPIs (e.g., total created deal amount, number
of contacts created) within the CRM using custom-calculated fields.
GitHub: Project Repo
Designed a custom signature for the company using HTML/CSS, then developed a signature editor page
hosted on GitHub for new members to create their own signatures, enhancing brand consistency.
Utilized: HTML, CSS, JavaScript.
GitHub: Project
Repo |
Web page
Developed a Google Script project to query US numbers for rate center information. The script takes a
US number from a spreadsheet, queries an open-source web API, retrieves rate center information, and
updates the spreadsheet. Utilized: Google Script (JS), API, JSON.
GitHub: Project
Repo
Activities and Societies: Bogazici University Music Club (BUMC) Jazz Choir Member, BUMC Rock Choir Member
Languages: English (Full professional proficiency), French (Limited working proficiency), Turkish (Native)