Umut Can

As a seasoned Data Warehouse (DWH) Technical Product Owner and Scrum Master, I bring a wealth of experience in spearheading DWH initiatives across Marketing, Credit, Finance, and Operations domains. My expertise lies in managing the technical aspects of DWH projects, ensuring alignment with business objectives and delivering actionable insights through data. My role has involved significant contributions to projects such as DWH transformation, Risk Datamart development, and data governance, showcasing my ability to navigate complex data environments and drive data-driven decision-making processes. With a strong foundation in Agile methodologies, I have effectively led project teams as a Scrum Master, fostering collaboration, facilitating sprint planning, and ensuring timely delivery of project milestones. My experience spans across creating strategic roadmaps for DWH development, overseeing the lifecycle of data warehousing solutions, and implementing best practices in data management to support organizational goals.

Data Warehouse Transformation Project

• Project Leadership and Agile Methodology: Spearheaded the DWH transformation project, identifying and addressing the data needs of various business units. Acted as the Scrum Master, leading the project through Agile methodologies, including scrum practices such as sprint planning, sprint reviews, and sprint retrospectives. Demonstrated leadership in removing obstacles for the scrum team and guiding the team in adherence to Agile principles.
• Data Architecture Design: Engineered the logical and dimensional data architecture of the DWH to meet the technical requirements of business units. Developed Entity-Relationship (ER) diagrams to visualize the data architecture, ensuring efficient data organization and accessibility.
• ETL Development and Data Integration: Executed ETL developments to facilitate data extraction, transformation, and loading processes. Analyzed data sources to ensure accurate and effective data transformation, aligning with the needs of the business units.

• User Acceptance Testing (UAT) and Documentation: Organized business units for UAT processes, ensuring the developed data warehouse met the end-user requirements. Created analysis documents and functional test documents to support the testing phase and document the system's functionality.
• Project Management: Led cost estimation and project planning processes, ensuring project delivery within budget and timelines. Designed work plans for a team of seven, optimizing resource allocation and project execution.
• Process and Governance Mechanisms: Established processes and governance mechanisms for the overall operation of the DWH, promoting data democratization among business units and ensuring data quality and compliance.
• Scrum Practices: Guided the scrum team through sprint planning, sprint review, and sprint retrospective sessions, fostering a collaborative environment and ensuring continuous improvement and adherence to Agile principles.

Technologies Used: ODI 12C, PL/SQL, MS Visio, Jira, Confluence.

Early Warning System Data Mart Development Project

• Data Needs Identification: Proactively identified data requirements to feed an early warning system, ensuring the system's effectiveness in monitoring and predicting credit risk.
• Risk Data Mart Construction: Constructed a comprehensive data mart containing credit risk information, serving as the foundation for risk assessment and management processes.
• UAT Support: Provided critical support to business units during User Acceptance Testing (UAT) processes, ensuring the developed solutions met user expectations and requirements.
• ETL Development: Spearheaded ETL (Extract, Transform, Load) development efforts, facilitating the integration, cleansing, and consolidation of data from diverse sources into the data warehouse.
• Documentation: Authored comprehensive analysis and functional test documents, detailing the system's specifications and ensuring clarity and usability for both technical teams and business stakeholders.
• Agile and Scrum Leadership: Led the project utilizing Scrum methodology, serving as the Scrum Master. Successfully guided the team through sprint planning, sprint review, and sprint retrospectives, ensuring adherence to Agile principles and facilitating continuous improvement.
• Team Obstacle Management: Effectively identified and removed obstacles facing the Scrum team, fostering a productive and agile development environment. Demonstrated leadership in promoting Agile principles and ensuring the team's alignment with project goals.

Technologies Used: ODI 12C, PL/SQL, MS Visio, Jira, Confluence.

Engaged in four pivotal projects at Şekerbank, focusing on Data Warehouse (DWH) Reengineering, Effective Reporting, 360 Customer View, and Incorporation of Alternative Data. Each project aimed at enhancing the bank's data management, reporting capabilities, and customer understanding through advanced analytics and data integration techniques.

DWH Reengineering Project

• Led a comprehensive analysis of the bank's main banking OLTP database to design and establish a new DWH architecture, including Fact Tables, Dimension Tables, and Lookup Tables.
• Spearheaded ETL developments for ODS, DW, and DM using ODI 12c, ensuring efficient data integration and storage.
• Utilized PowerDesigner for data modeling and created a detailed DWH data dictionary to support data governance.
• Conducted thorough testing of ETL processes and developed essential project documentation, including attribute mapping and analysis documents.

Technologies Used: ODI 12C, Toad, PL/SQL, PowerDesigner, Jira.

Effective Reporting Project

• Implemented a project to model all bank reports and dashboards on Microstrategy, enhancing reporting efficiency and accessibility.
• Converted existing SAP BO and Qlik Sense reports to Microstrategy, and developed mobile reports and dashboards for Android and iOS platforms.
• Established role-based authorizations for reports to enforce Row-Level Security, ensuring data confidentiality and compliance.

Technologies Used: Microstrategy Developer, Microstrategy Web.

Customer 360 Project

• Aimed to provide the bank's customer representatives with a 360-degree view of customers, enhancing personalized communication and service.
• Conducted data warehouse analysis, data mart modeling, and ETL developments for customer representative-specific data, creating a comprehensive customer portfolio data mart.
• Designed and implemented a data pipeline to support ongoing data integration and analysis efforts.

Technologies Used: ODI 12C, Toad, PL/SQL, PowerDesigner, Jira.

Alternative Data Project

• Explored and integrated alternative data sources to enrich the bank's core banking and data warehouse with external data, enhancing analytical depth and insight.
• Converted customer address information into coordinates using geospatial packages in Python and created new variables by scanning specific areas around customer addresses.
• Employed web scraping and API calls to retrieve data from alternative sources, broadening the scope of data analytics capabilities.

Technologies Used: Python, Toad, PL/SQL, Jira.

Worked on the development of an AI-powered assistant named Merlin for PepsiCo, designed to optimize field operations for sales representatives. This project provided guidance on how much product to leave at specific retail locations, how much of each product to load onto their trucks, and which routes to follow.

• Requirement Gathering and Analysis: Spearheaded the collection and analysis of product needs from relevant business units to align project objectives with strategic business goals.
• Data Analysis and Infrastructure: Led the analysis of data to feed the artificial intelligence model, playing a pivotal role in the creation and optimization of the data infrastructure to ensure model accuracy and efficiency.
• AI Model Development Support: Provided critical support in the development processes of the AI model, contributing to the model's design, algorithm selection, and tuning to meet project specifications.
• AI Interface Analysis: Conducted comprehensive analysis during the creation process of AI interfaces, ensuring user requirements and interface functionality were perfectly aligned.
• Agile Project Management: Played a key role in establishing sprint plans and implementing Agile project management methodologies, ensuring projects were delivered efficiently and effectively.
• Leadership in Agile Ceremonies: Led key Agile ceremonies such as sprint planning and sprint reviews, fostering team collaboration and ensuring alignment with project goals and timelines.

While at Linktera, a firm renowned for delivering technological consultancy services to banks in Turkey, I was integral to two pivotal projects for Şekerbank: the CRM Data Mart Development and the Marketing Automation Architecture initiative. These projects were designed to elevate Şekerbank's capabilities in marketing analytics, campaign analytics, and to streamline marketing operations through the integration of advanced automation systems.

Şekerbank CRM Data Mart Development Project Highlights:

• Analyzed the bank's data sources for the creation of a CRM Data Mart, essential for marketing and campaign analytics.
• Developed a comprehensive data mart model featuring 32 tables and over 3,000 variables, coupled with extensive ETL (Extract, Transform, Load) processes using ODI 12c.
• Produced critical documentation including analysis, testing, and a detailed data dictionary, and conducted thorough functional and UAT testing.
• Employed PowerDesigner for data modeling, facilitating a robust and scalable analytics foundation.

Şekerbank Marketing Automation Architecture Project Highlights:

• Led the implementation of the SAS Marketing Automation product, significantly enhancing marketing efficiency and personalization.
• Established CRM data mart connections and modeled data within SAS Management Console and SAS Information Map Studio.
• Designed the campaign structure across various channels including SMS, Email, ATM, and mobile applications, ensuring a seamless customer experience.
• Provided comprehensive training on campaign design to bank personnel, fostering an environment of continuous improvement and learning.

Technologies Used: Toad, PL/SQL, ODI 12c, PowerDesigner, Jira, SAS EG, SAS CI, SAS Information Map Studio, SAS Management Console.

• Conducted comprehensive data analysis for CRM processes, applying descriptive, predictive, and prescriptive analytics to optimize customer relationship management, improve customer experience, and support decision-making.
• Utilized machine learning and analytical techniques, including RFM (Recency, Frequency, Monetarists) and K-Means Clustering, for advanced customer segmentation. This enabled targeted marketing strategies and personalized customer engagement.
• Developed and deployed machine learning models to predict customer churn, employing algorithms such as Logistic Regression, Naive Bayes, and XGBoost, which significantly improved customer retention strategies.
• Implemented Market Basket Analysis to identify and leverage cross-sell opportunities for health products, enhancing sales strategies and increasing revenue.
• Designed and maintained dynamic dashboards and detailed reports using Power BI to provide actionable insights into customer behavior, campaign performance, and business metrics.

Technologies Used:

• Microsoft SQL Server: For database management and advanced SQL queries.
• R: Employed for statistical analysis and machine learning model development.
• Power BI: Utilized for creating interactive dashboards and reports for data visualization and business intelligence.