Cengizhan Tunaydin
Finance Expert
Istanbul, Turkey
Skills
Data Analysis
About
Cengizhan Tnaydn's skills align with IT R&D Professionals (Information and Communication Technology). Cengizhan also has skills associated with Communication, Marketing and Public Relations Managers (Communication, Marketing and Public Relations). Cengizhan Tnaydn has 9 years of work experience, with 3 years of management experience, including a low-level position.
View more
Work Experience
Data Analyst & Analytics Engineer
Python and Power
May 2023 - Present
- • Utilized SQL, Python and Power BI for data analysis/science tasks, turned problems into analytics & insight projects, using veterinary health related data (Redshift, Power BI, Jupyter notebooks, HubSpot, Notion, GitHub). • Led the development of the Insight Reporting project from inception to completion - preparation of specs, assumptions & logic building with Python, creating of the views with SQL on Redshift, creation of the data model, security, accesses, reports and visualization on Power BI. These reports were sold to clients as part of the exclusive tier. • Prepared reports on KPIs such as LTV, churn, customer retention, ROAS, conversion rate etc. Reports were visited by the colleagues (mainly executives) ~10 times per week. • Developed custom analyses for ad-hoc requests, which were then sold to clients as one-time reports (~500 USD each). • Leveraged HubSpot and Power BI connectors to generate marketing and growth insights and reporting. Helped around +2 lead conversions per month. • Implemented SQL and Python scripts for seamless data migration of new clients, ensuring data reliability through testing and communication with clients. Also provided peer review for teammates' code. Data Scientist
Celtra Slovenia
February 2021 - May 2023
- • Used mainly Python, SQL & Power BI for data analysis/science tasks (Databricks, Snowflake, PyCharm, Jupyter notebooks, Power BI, Jira) • For Celtra, a marketing tech company, I turned questions from stakeholders (mainly business executives, product managers and clients) to product analytics and data science projects • Main projects: • Prepared an all-inclusive product usage report for 2 main parts of our software with insights and predictions that affected/changed the product development process. Reports were visited 30 times per week by the executives & product managers. • Prepared an executive level BI report that quantifies & shows all main KPIs of the product (engineered the data needs, owned the stakeholder management, analysis & the reporting from backend on SQL & Python to visualization on PBI). Includes the calculation of LTV, churn, customer retention, ROAS, conversion rate etc. • Owned the statistical analysis project for product efficiency with tests, which in the end helped us understand the driving factors of our product's efficiency and prepare specs for new reports that would benefit the clients. • Wrote a custom clustering algorithm to group client projects, that in the end helped with reuse of components in our platform. This fed other projects for deriving the efficiency and creating insightful reports. • Many ad-hoc requests for A/B testing, product analytics & optimization, efficiency.
Finance Project Lead & Senior Financial Analyst
Pfizer Czech Republic
April 2018 - February 2021
- Led the SAP deployment project for 3 different legal entities, mainly for process design, reporting automatization and enhancement, data analysis & migration, post go-live stabilization • Had 1 project analyst reporting to me • Utilized Excel, SAP and PBI for reporting development activities & automatization of mutual tasks: decreased the time spent for 90% for several regular reporting activities Financial Analyst
Pfizer Czech Republic
October 2015 - April 2018
- 10.2015 to 04.2018 (2 years 6 months) • Supported decision making with budget & receivables forecasting, sales allowance calculation • Utilized Excel and Power BI to interpret financial data to draw conclusions • Provided support to finance and commercial leaders with monthly reports on financial data • Prepared many ad-hoc requests for insights from financial data, automatized processes • Led Order to Cash and Sales Order Management areas in the SAP Deployment Project, mainly for process automatization & design, data analysis, testing, data transfer and coordination
Education
