Source system
Reliable ingestion of high-volume data from telecom, healthcare and financial processes.
Software Engineer (MSc) · Solution Architect · Ankara
Mehmet KARACAN
A software engineer working across high-volume data systems, Oracle PL/SQL, ETL, DWH, reporting and enterprise architecture, with a focus on performance and sustainable delivery in critical systems.
01
Profile
Expertise in the layers that process data, keep systems running and support business decisions.
Mehmet KARACAN combines experience in telecommunications, healthcare IT, financial workflows and public-sector projects with enterprise software development, database performance, ETL/DWH processes and integration architecture.
His career is centered on processing high-volume data reliably, turning complex systems into clear operations and guiding technical teams toward sustainable delivery discipline.
Professional story
The journey of a record: from source to decision screen.
In enterprise systems, success is not measured only by code running. Data must be captured correctly, transformed accurately, remain observable, create trust in reporting and scale without slowing operations. Mehmet's expertise appears across this journey: connecting Oracle PL/SQL, ODI, ETL, DWH, Java services, CI/CD and reporting layers into one reliable flow.
Transformation
Clean, fast and observable data flows with Oracle SQL, PL/SQL, ODI, ETL and data warehouse processes.
Decision
Supporting operational decisions through reporting, audit screens and executive dashboards.
Experience
Operational impact in critical systems.
A career path focused on scalable systems, data flows, reporting and team coordination across telecommunications and healthcare IT.
November 2022 – Present
İnnova Bilişim Çözümleri A.Ş.
Software Development Consultant · Çankaya, Ankara
- Worked on scalable, performance-oriented solutions with Java, Spring Boot, Oracle SQL, PL/SQL and ODI for high-volume data infrastructures.
- Optimized data processes and handled ETL and data warehouse flows end to end with a focus on performance and operational efficiency.
- Contributed to critical architectures for high-volume systems managing mobile charging and dealer sales commission workflows.
- Completed an ODI migration from 11g to 12c, contributing to system continuity and maintainability.
- Automated CI/CD workflows with Jenkins, Git, Maven and SVN, supporting a more disciplined delivery culture in version control and code integration.
- Took active responsibility in Agile/Scrum sprint planning, backlog management, technical prioritization, team guidance and onboarding new developers.
- Built sustainable software solutions by aligning technical design, data processes and organizational goals.
September 2017 – November 2022
Sisoft Healthcare Information Systems Inc.
Training and Software Support Team Lead · Çankaya, Ankara
- Managed multi-institution rollout and training processes in digital healthcare transformation projects across Türkiye.
- Contributed to hospital HIMSS EMRAM readiness and coordinated development and integration work across Hospital Information Management System modules.
- Optimized SQL queries for Ministry of Health audit preparation, supporting data monitoring, reporting and performance tracking.
- Developed executive monitoring and statistics screens aligned with ministry standards, strengthening decision-support systems.
- Gained global field experience through projects with healthcare institutions in the Middle East and Asia, combining cross-cultural communication with technology management.
- Redesigned e-Invoice, e-Archive and data transfer processes, improving data consistency and process continuity.
- Worked directly with CEO, CTO and CIO-level stakeholders across needs analysis, demos, go-live, user adoption and support processes.
- Contributed to wider software adoption through team leadership, mentoring, user training and field needs analysis.
Technical skills
End-to-end practical expertise from database layers to services, reporting and delivery.
Programming and frameworks
Java, JavaScript, C#, Spring Boot
Database and integration
Oracle SQL, PL/SQL, PostgreSQL, MySQL, Microsoft SQL Server, T-SQL, Oracle Data Integrator
Data warehouse and performance
ETL, DWH, high-volume data systems, data modeling, performance optimization
DevOps and delivery
Jenkins, Git, GitHub, Maven, SVN, CI/CD automation, version control
Tools and platforms
JIRA, Confluence, JasperReports, Power BI, IntelliJ IDEA, Eclipse, Oracle JDeveloper, WebLogic, Tomcat
Leadership and domain knowledge
Agile/Scrum, backlog management, sprint planning, mentoring, technical leadership, telecommunications, healthcare IT, financial processes, public-sector projects
Focus areas
The quiet but critical parts that keep enterprise systems running.
Telecommunications data systems
Healthcare IT and HBYS
Financial process automation
Public-sector audit reporting
ETL, DWH and data quality
CI/CD and release management
Executive decision-support screens
Data systems focus
Experience connecting ODI, data transfer and SQL performance in one operational flow.
In high-volume systems, technical value becomes visible when data transfer continuity, PL/SQL query performance, ETL/DWH observability and reporting reliability are handled together.
ODI and data transfer
A focus on continuity, maintainability and data consistency across ODI 11g-12c migration, e-Invoice/e-Archive and enterprise data transfer processes.
PL/SQL and data performance
Faster and more observable operations in high-volume record flows through Oracle SQL, PL/SQL and query optimization.
ETL, DWH and reporting
Turning operational data into decision-support structures through data warehouse processes, JasperReports, Power BI and executive screens.
Enterprise software continuity
Sustainable development of critical systems through Java Spring Boot, CI/CD, release management and team coordination.
Highlighted contributions
Where technical contribution turns into operational value.
High-volume data performance
Faster and more observable operations in high-volume record flows through query optimization, data modeling and process improvements.
ODI 11g – 12c modernization
A modernization approach centered on continuity, maintainability and delivery speed during the migration process.
Digital healthcare transformation
End-to-end contribution across HBYS modules, decision-support screens, audit readiness, user training and field adoption.
Reporting and audit reliability
Making operational data decision-ready through SQL optimization, JasperReports, Power BI and executive screens.
Anonymous case notes
Solution patterns that preserve confidentiality.
Data integration modernization
Context: A high-volume telecommunications data flow.
Approach: ODI version migration, SQL/PLSQL improvement and delivery continuity were handled together.
Outcome: A transition structure was established to simplify maintenance and operational monitoring.
Evidence boundary: Organization, customer, data and topology details are not disclosed.Healthcare reporting reliability
Context: A healthcare information system with audit and decision-support needs.
Approach: Query behavior, reporting flow and user feedback were brought into the same improvement cycle.
Outcome: The clarity of monitoring and reporting processes was strengthened.
Evidence boundary: Organization, customer, data and topology details are not disclosed.Technical writing
Technical notes grounded in practice.
The right index is like the right book in a library
A technical review of database indexes through access patterns and query behavior.
Read on LinkedIn ↗How can one change in coding philosophy affect performance?
A technical article discussing measurement, data structures and approach changes in performance decisions.
Read on LinkedIn ↗Education and certificates
Continuous development across software engineering, management information systems, quality and data.
Education
MSc · Software Engineering
Ahmet Yesevi University, Faculty of Engineering · 2024 – 2025 · GPA 2.85
BSc · Management Information Systems
Anadolu University, Open Education Faculty · 2020 – 2024 · GPA 3.15
Associate Degree · Computer Programming
Gaziantep University, Nizip Vocational School · 2015 – 2017 · GPA 3.40
Certificates
- Data Analysis School – Artificial Intelligence Module (Participation & Achievement Certificate) · Under the auspices of YÖK, coordinated by Marmara University's Population and Social Research Institute, with contributions from ODTÜ, İTÜ and Boğaziçi University · October 2025 – May 2026 Verifiable certificates: #1 ↗, #2 ↗, #3 ↗, #4 ↗
- Oracle Database 12c SQL – Advanced · İnnova Academy · Instructor: Semih Sungur · October 2023
- ISO/IEC 27001:2017 Information Security Management System Basic and Internal Auditor Training · BBS Certification · Certificate No: 22010247 · September 2022
- ISO/IEC 15504 SPICE Basic and Internal Auditor Training · BBS Certification · Certificate No: 22010322 · September 2022
- ISO 13485:2016 Medical Devices Quality Management System Basic and Internal Auditor Training · BBS Certification · Certificate No: 22010114 · July 2022
- Microsoft Power BI · İMMİB Academy · October 2021
Digital profile
Mehmet KARACAN
Email
mehmet@mkaracan.com
LinkedIn
linkedin.com/in/mehmet-karacan
GitHubgithub.com/mehmet-karacan
Location
Ankara, Türkiye
Focus
Data systems and enterprise software