Ipek Celik

Results-oriented Business Analyst with over 4 years of experience bridging business objectives with technical execution. Skilled in gathering and analyzing data, improving business processes, and collaborating with cross-functional teams to deliver efficient solutions. Proficient in SQL and data visualization tools such as Tableau and Power BI, with hands-on experience in SAP Commerce Cloud. Strong communicator with a solid background in Agile environments and a passion for solving complex problems through data-driven insights.

Capstone project, Conducted an in-depth analysis of real estate market trends by reorganizing raw datasets into a time-series format and engineering features like seasonal effects and economic indicators. Applied advanced predictive models (Linear Regression, KNN, and ARIMA) to forecast property prices with 72% accuracy (R²=0.72). Designed an interactive Power BI dashboard with calculated columns using complex DAX formulas, enabling users to explore dynamic visualizations and analyze market trends. Delivered actionable insights into pricing trends, seasonal variations, and event-driven impacts (e.g., COVID-19), supporting data-driven decision-making for real estate professionals and investors. Database Management Project, Led the design and implementation of a simplified and relational database to track independent expenditures in support or opposition to political candidates. Initiated the project by preparing and restructuring datasets, separating key information (Payee, Expenditures, Spender, and Candidate data) into individual tables. Used ERD Plus to create a relational diagram and establish table relationships. Implemented the database in MySQL, utilizing advanced functions to create a seamless data input and retrieval structure.