Volkan Alemdar
Automating data workflows with SQL, Python, and Azure Data Factory—including a Python auction bot that drove $400K profit on 1,800 loads with 98% uptime. Also skilled in delivering full-stack solutions with .NET & React.
- Role
- Data Analysis & Engineering Ii at Reliable Transportation Solutions | RTS
- Location
- Cincinnati, OH, US
- LinkedIn followers
- 500 followers
About Volkan Alemdar
Hi, I\'m Volkan Alemdar, and you could say I\'m a bit of a data detective, helping…
Experience
Data Analysis & Engineering Ii
Reliable Transportation Solutions | RTS
Oct 2022 — Present
Designed and managed 300+ ETL pipelines using Azure Data Factory, streamlining data integration across SQL Server and other sources, enhancing data availability for business intelligence.• Optimized SQL Server performance by refining 300+ queries, views, and stored procedures across datasets of 26M+ rows, increasing execution efficiency by 96% in a high-traffic environment.• Built and maintained 28+ SSRS reports, automating distribution to stakeholders, enhancing data accessibility, and reducing manual reporting time.• Developed and optimized SSIS packages to automate secure data transfers and ETL workflows, integrating Send Mail tasks and real-time notifications for improved reliability.• Designed and maintained 50+ interactive Tableau dashboards, enhancing data visualization and supporting business intelligence needs through KPI tracking.• Enhanced Tableau Bridge job completion rate to 99% for daily jobs, ensuring data reliability and uninterrupted reporting.• Developed a Python-based Robotic Desktop Automation (RDA) solution, including a web scraper for automated bid submissions, saving a full-time employee’s workload and generating $400K in gross profit from 1,800 awarded loads.• Partnered with stakeholders to identify bottlenecks and designed a Python-based Hybrid Client with an intuitive GUI, achieving a 96% reduction in processing time for accessorial charge reimbursements.• Developed a data-driven carrier performance scoring system, securing predictable revenue for 70% of contract freight, optimizing partnerships and accelerating sales growth.• Created a web-based data import and validation tool to process CSV files, identify errors, and apply automated corrections, improving data accuracy.• Developed a scalable.NET Console Application to monitor a SQL Server database table and send adaptive card notifications via Microsoft Teams, implementing logging in a separate data warehouse for reliability.
Education
The University of Toledo, IOTM department of Business
Bachelor of Business Administration - BBA, Information Systems, Digital Marketing, and Management
Find verified contacts for anyone on LinkedIn
Unifers gives sales teams verified emails and direct dials, enriched profiles, and outreach that lands in the inbox.
Free plan included · No credit card required
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.