Haniyeh Ghanavati
Senior Business Intelligence Developer | BI Architecture
Salary / Daily rate
İstanbul, Türkiye
Freelance
Skills
Languages
About me
Intro
Senior BI Developer with 12+ years transforming data into strategic insights, currently leading teams at Digikala.com. Proven expertise in reducing churn by 20%, doubling revenue through analytics, and optimizing BI architecture using Kimball/Inmon methodologies. Specialized in KPI measurement, ETL optimization, and cross-functional collaboration to drive business growth.
Work experience
Digikala.com
Jun 2018 - Present
8 years 5 months
Senior Business Intelligence Developer |Team Lead
Mar 2021 - Present
5 years 8 months
• Mentor junior team members on best practices in BI development and data analysis. • Collaborate with cross-functional teams to define and monitor pivotal organizational KPIs such as GMV, NMV, NPS, and customer rate. • Implement CRISP methodology to ensure accurate measurement and continuous improvement of KPIs. • Design and optimize BI architecture, integrating Inmon's centralized approach with Kimball's dimensional modeling principles. • Implement automation scripts to streamline data integration processes and enhance data accessibility. • Collaborate effectively with cross-functional teams to drive alignment and deliver impactful business solutions. • Utilize Python programming skills to efficiently extract and integrate data from external sources such as Google Analytics and Google Sheets.
Business Intelligence Developer
Jun 2018 - Mar 2021
2 years 10 months
• Construct and maintain OLAP cubes (Tabular, Multidimensional) using SSAS, employing Star/Snowflake schemas for analytical dashboards. • Develop robust ETL pipelines using SSIS to extract, transform, and load data from diverse source systems into the data warehouse. • Optimize ETL processes for performance and reliability, ensuring timely and accurate data delivery. • Create insightful and interactive dashboards and reports using Power BI, SSRS, and other BI tools.
Business Intelligence Developer
ParsOnline Group
Mar 2012 - Jul 2018
6 years 5 months
• Developed and monitored appropriate measures and KPIs for each department based on telecom business KPIs and measures such as ARPU, ACPU, Churn Rate, and CLV. • Suggested and developed a customized package offering to clients through user behavior analysis in close cooperation with Marketing and Sales teams, which doubled the revenue of selected users and reduced the churn rate by 20%. • Integrated and designed automated reports with QlikView, VB.net, and SSRS. • Designed and maintained databases and performed performance tuning of SQL queries. • Monitored SQL Server job performance and alerted the BI system to detect long-running jobs, queries, and inefficient data structures. As a result, the number of errors and failures reduced by 50% after a short period. • Set up and configured OLAP Cubes (Star Schema and Snowflake Schema) using SQL Server Analysis Services. • Performed performance tuning of MDX and designed dimensions to scale to large numbers of users in SQL Server Analysis Services (SSAS). • Enhanced the functionality of databases and data warehousing concepts (OLAP, OLTP) by creating KPIs, actions, and perspectives using SQL Server Analysis Services (SSAS).
Software Engineer
Bandar Imam Petrochemical Company
Apr 2010 - Dec 2012
2 years 9 months
● Code, debug, document and install new programs and make changes to existing programs/technologies. ● Identified and understand the business processes and control requirements for the same via application or infrastructure control review documentations and self-assessments (system control review process). ● Thorough knowledge of VB programming, testing methods, debugging or troubleshooting techniques. ● Summarized and implement quality assurance documentation.
Education
Amirkabir University of Technology - Tehran Polytechnic
Master's degree
2012 - 2014
3 years
Azad University of Bandar Mahshahr, Khuzestan, Bandar Mahshahr
Bachelor’s Degree
2006 - 2010
5 years