Ege Ikizoglu Email & Phone Number

Philadelphia, Pa, Us

California, United States

Chantilly, Virginia, United States

Project: Kickstarter is an online crowdfunding platform that was created in 2009. Kickstarter helps creators fund a project or venture through raising small amounts of money from larger groups of people. Kickstarter has a full range of diverse project categories such as Tech, Design, Illustration, Arts, Music, etc. Responsibilities: • Working with project managers to understand and maintain focus on their analytical needs, including identifying critical metrics and KPIs, and delivering actionable insights to relevant decision-makers.• Implementing data cleanup and analyzed data integrity problems.• Leveraging Power Query editor to efficiently transform data into optimal format for analysis. • Implementing advanced data visualization techniques using Power Query, Power Pivot, and Power View to communicate key insights to stakeholders. • Using Power BI features to build and configure Hierarchical dimensions, Measure, Calculated Columns, KPIs, and Filter and Aggregations. • Creating and developing Power BI visualizations for the KPI’s and trend analysis. • Creating dynamic aggregation by using DAX formula language to customize calculations for Calculated Columns and for Measures. • Creating side by side bars, Scatter Plots, Stacked Bars, Heat Map, Tree Map, Matrix according to data is being analyzed.• Working with cross functional teams and translating business requirements into SQL queries to answer business questions. • Generating joins and subqueries in SQL for intricate queries involving multiple tables and fields.• Proficient in designing and developing reports and dashboards in Tableau to visualize the reports and clarify end user requirements. • Using data blending feature in Tableau to connect different databases like Oracle, MS SQL Server.• Creating reports in Tableau to understand successful project patterns and funding trends. • Good experience in publishing various kinds of interactive dashboards, and workbooks and setup schedule refreshes.

Chantilly, Virginia, United States

Project: Afiniti is an AI company that provides services to boost a company's efficiency by predicting interpersonal behavior between callers and agents. When a customer calls a call center, Afiniti matches their phone number with any information tied to it from up to 100 databases. These databases carry purchase history, income, and other demographic information. Data on customers is collected from the customers and from data brokers. Afiniti does not charge for the software or service itself but instead takes a percentage of any proven revenue increases resulting from the use of the software. Responsibilities: • Worked in data storage structures and data cleansing.• Attended the project review meetings, daily/weekly status meetings.• Excelled in performance with the interactive dashboard presentations.• Extracted data from multiple source systems using Oracle SQL.• Created various SQL Scripts for verification of the required functionality.• Wrote complex SQL queries to perform data analysis. • Created visualizations in BI tools according to deliverable specifications.• Utilized Tableau and Power BI for data intelligence and analysis.• Designed, developed, tested, and maintained Tableau functional reports based on user requirements.• Applied basic DAX functions to create calculated columns and measures, enabling accurate calculations and data transformations.• Configured incremental data refresh for the data sources.• Experienced with VLOOKUP and used PivotTable to calculate, summarize, and analyze data in Microsoft Excel.