I am a Data Analyst and Business Intelligence Specialist with over 2 years of experience in the IT and Energy sectors. My expertise lies in utilizing advanced data analytics, data visualization, data warehousing, and data management tools such as SQL, Power BI, Python, and SQL Server tools (SSMS, SSIS, SSAS, SSRS) to drive strategic decision-making and enhance business performance.Throughout my career, I have demonstrated a proven track record of improving query performance by 25%, enhancing workflow efficiency by 20%, and developing insightful dashboards and reports. My ability to optimize data processes, perform ETL (Extract, Transform, Load) operations, and mentor team members has consistently contributed to successful project outcomes.𝐊𝐞𝐲 𝐀𝐜𝐡𝐢𝐞𝐯𝐞𝐦𝐞𝐧𝐭𝐬:- Optimized stored procedures in SSMS, boosting query performance by 25%.- Designed and implemented SSIS packages, improving workflow efficiency by 20%.- Developed Power BI dashboards and SSRS reports, transforming complex data into actionable insights.- Mentored junior team members, significantly boosting their skills in BI tools and data analysis techniques.𝐏𝐫𝐨𝐟𝐞𝐬𝐬𝐢𝐨𝐧𝐚𝐥 𝐄𝐱𝐩𝐞𝐫𝐢𝐞𝐧𝐜𝐞:At Kazancı Holding A.Ş., I optimized data retrieval processes and supported strategic initiatives with advanced SQL queries and data analysis techniques, leading to substantial improvements in data processing and decision-making capabilities.During my tenure at Enqura Information Technologies, I enhanced client satisfaction by developing dynamic dashboards and optimizing data relationships with DAX measures in SSAS.𝐒𝐤𝐢𝐥𝐥𝐬:- Data Integration & Management || SSMS, SSIS, ETL Processes, Data Warehousing- Data Analysis & Reporting || SQL, Power BI, SSRS, Excel, Tableau, Python (NumPy, Pandas, Matplotlib, Seaborn, Pyspark)- Data Visualization || Expertise in creating dynamic and interactive dashboards𝐂𝐞𝐫𝐭𝐢𝐟𝐢𝐜𝐚𝐭𝐢𝐨𝐧𝐬Microsoft SQL from A to Z, Python Data Structures, Apache Spark, Advanced Excel for Business𝐋𝐚𝐧𝐠𝐮𝐚𝐠𝐞𝐬:-Turkish (Native)-English (Full Professional Proficiency)-German (Limited Working Proficiency)
-
Data AnalystSmart PricerBerlin, De -
Data Analyst & Bi Specialist | Sql, Python, Power Bi (Seeking New Opportunities)Self-Employed Jun 2024 - PresentBerlin, Berlin, GermanyExperienced Data Analyst & BI Specialist with 2 years of expertise in data visualization, business intelligence, and data-driven decision-making. Proficient in SQL, Python and Power BI. Currently enhancing my skills in Tableau, dbt, and Snowflake. Seeking new opportunities to leverage my skills and grow in a dynamic organization.
-
Business Intelligence SpecialistKazancı Holding A.Ş. Mar 2023 - Jan 2024Istanbul, Türkiye▪ Updated and enhanced existing stored procedures in SSMS, ensuring optimal performance which resulted in improving query performance by approximately 25% and enhancing data reliability.▪ Wrote complex SQL queries, utilizing sophisticated multi-table joins and advanced analysis techniques to extract insights, supporting strategic business initiatives and contributing to informed decision-making.▪ Designed and implemented advanced data integration solutions by creating and refining SSIS packages, streamlining the data consolidation process, and significantly enhancing workflow efficiency by 20%.▪ Developed and enhanced SSRS reports and Power BI dashboards, leveraging DAX to transform complex data sets into actionable insights, thereby improving decision-making capabilities for management.▪ Mentored and trained junior team members in BI tools, data analysis techniques, and best practices in data management, enhancing the overall skill set of the team and improving project outcomes. -
Jr. Data AnalystKazancı Holding A.Ş. Mar 2022 - Mar 2023Istanbul, Türkiye▪ Prior to my promotion, I Optimized data warehouse architecture by merging staging and fact packages into a unified master package in SSIS, reducing data processing time.▪ Refined reporting processes by optimizing stored procedures and developing and enhancing SSRS reports, leading to an average 20% reduction in report preparation time.▪ Executed advanced SQL queries to extract crucial information from various tables, improving data retrieval accuracy and supporting strategic decision-making.
-
Business Intelligence SpecialistEnqura Information Technologies Jul 2021 - Nov 2021Istanbul, Turkey▪ Improved data retrieval and manipulation by creating views and stored procedures with SQL queries, reducing data processing time.▪ Developed dynamic dashboards tailored to clients' requirements using Power BI, enhancing client satisfaction and decision-making.▪ Optimized data relationships by establishing connections between tables and crafting DAX measures using SSAS, improving data accuracy and reporting efficiency.
Hasan Burak Ersan Education Details
-
Civil Engineering -
Hüseyin Avni Sözen
Frequently Asked Questions about Hasan Burak Ersan
What company does Hasan Burak Ersan work for?
Hasan Burak Ersan works for Smart Pricer
What is Hasan Burak Ersan's role at the current company?
Hasan Burak Ersan's current role is Data Analyst.
What schools did Hasan Burak Ersan attend?
Hasan Burak Ersan attended Boğaziçi Üniversitesi, Hüseyin Avni Sözen.
Free Chrome Extension
Find emails, phones & company data instantly
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial