Damla Peker

Internal Projects (QCA – HR & Finance):

• Developed Power BI dashboards for employee performance, hourly tracking, and operational KPIs.
• Used DAX, Power Query, and Row-Level Security (RLS) to build dynamic, user-specific reports.
• Integrated data from APIs and SQL Server to support interactive analytics and decision-making.

External Clients (Industrial Manufacturing Sites):

• Built real-time monitoring and alarm systems in Ignition SCADA using data from PLCs and sensors.
• Designed and deployed dashboards in Ignition (Vision & Perspective) to visualize operational KPIs directly from live sensor and historian data.
• Developed backend logic with Python and SQL Server stored procedures for automation and diagnostics.
• Enabled seamless IT–OT integration by preparing and delivering real-time SCADA data to SQL databases and client-specific reporting platforms.
• Created ETL flows to combine data from multiple sources and generate meaningful outputs for operators and engineers.
• Developed UI components (e.g., export buttons, filters, toggles) within Ignition to support user actions and file exports (CSV, Excel), enhancing usability and report delivery.

• Implemented Agile methodologies and used Jira for end-to-end task tracking, improving team efficiency and on-time project delivery.
• Built ETL pipelines using Python, SQL, and IBM DataStage; leveraged PySpark, Kafka, and Elasticsearch in a Big Data Transformation Project, achieving a 30% reduction in ETL time.
• Designed interactive dashboards and reports using IBM Cognos and Power BI, supporting strategic decision-making across departments.
• Delivered visually intuitive analytics solutions, providing actionable insights to stakeholders.
• Managed OLAP/OLTP systems and implemented DataOps practices, optimizing data pipelines and enhancing system performance.
• Led a Customer Engagement Project, improving real-time data delivery and ETL accuracy. Conducted stakeholder meetings to gather detailed requirements aligned with business needs.

• Enhanced ETL efficiency and reliability through proactive 24/7 monitoring, ensuring data accuracy, business continuity, and timely report delivery.
• Managed ETL operations using Oracle ODI and UC4, reducing job failures by 25% and improving data processing time by 35%.
• Automated scheduling and agent control with shell scripts on Linux/Unix, increasing automation by 30% and reducing manual effort by 35%.
• Led data transfer projects between Exadata systems, contributing to optimized performance and successful delivery.
• Gained hands-on experience in build automation, installation scripting, and release management on Unix environments.
• Implemented CI/CD pipelines to streamline development workflows, enabling efficient continuous integration and delivery.

• Developed and deployed ETL packages using Oracle ODI and Informatica, ensuring reliable data integration across the Data Warehouse.
• Optimized monthly dealer reports using UC4, improving precision by 15% and reducing turnaround time by 20%, boosting operational planning.
• Streamlined ETL workflows by integrating data into the ODS layer and resolving inconsistencies; applied SQL tuning to reduce job runtimes.
• Provided ongoing technical support and issue resolution to improve data processing reliability.
• Utilized SQL and PL/SQL for efficient data manipulation, ensuring accurate and optimized database operations.

• Applied Agile and Waterfall methodologies to streamline project execution and enhance cross-team collaboration.
• Configured and deployed tariff updates on Ericsson Charging System, including full-cycle testing, validation, and handover to QA for live monitoring.
• Facilitated weekly stakeholder meetings, gathering business requirements and translating them into detailed tracking spreadsheets.
• Delivered key Excel reports on tariff usage and customer behavior, enabling data-driven promotion strategies that improved retention and acquisition.