Mesut Ugur Bolat

Data Analyst & BI Specialist

B-Fixed Tech LLC•  October 2022 - Present•  New Jersey, United States

Collaborated with key stakeholders to translate requirements into actionable insights and intuitive dashboards. • Implemented best practices for data visualization and dashboard design. • Improved data quality for BI reports in collaboration with the data warehouse team. • Conducted training sessions on advanced Power BI and Tableau techniques. • Acted as a subject matter expert in Power BI and Tableau. • Developed interactive dashboards and reports using Power BI. • Conducted data analysis and data cleansing to maintain data integrity. • Implemented row-level security and role-based access control (RBAC). • Processed and manipulated large data sets using SQL, Python, and Excel. • Automated data extraction, profiling, cleaning, and transformation. • Built and maintained SQL scripts, indexes, and complex queries. • Coordinated project resources to ensure timely and budget-compliant delivery. • Participated in Agile Project Management.

Data Scientist

Pergamo E-comm. LLC•  September 2021 - October 2022•  Essen, Germany

• Advanced Data Extraction and Pre-processing: Performed advanced data extraction techniques from databases using SQL, along with data manipulation and pre-processing to prepare data for analysis. • Exploratory Data Analysis and Statistical Modeling: Conducted exploratory data analysis (EDA), statistical data modeling, and machine learning using Python to drive various analytics use cases. • Algorithm Development and Automation: Developed and coded algorithms and automated processes to cleanse and evaluate large datasets from multiple disparate databases. • Data Insights and Visualization: Pinpointed meaningful insights from large data and metadata sources using Power BI. Created data visualization graphics, built dashboards, and translated complex data sets into comprehensive visual representations. • Application of Data Science Techniques: Applied appropriate data science techniques to solve business problems, including EDA, statistical analysis, and both supervised and unsupervised machine learning algorithms. Examples include customer segmentation and retention models, RFM analysis, market basket analysis, and natural language processing (NLP). • Stakeholder Collaboration: Liaised with business and technology stakeholders to understand the business context and enhance domain knowledge. • Presentation and Documentation: Presented insights and carried out documentation of the projects to ensure clear communication and knowledge sharing.

Data Analyst

ProjectGroup Institutional•  July 2018 - June 2021•  Ankara, Turkey

• Business Requirements Translation: Translated business objectives into functional data requirements to ensure alignment with organizational goals. • Data Visualization: Utilized data visualization tools such as Power Pivot and Tableau to communicate business insights effectively. • Data Development: Developed tables, views, and materialized views using Google Sheets and Python to support data analysis and reporting. • Statistical Analysis: Conducted statistical analysis to guide decision-making processes and provide actionable insights. • VBA and DAX Solutions: Implemented VBA macros and DAX solutions to automate and enhance data processing tasks. • Applicant Support: Supported applicants through visa, work and residence permit, and citizenship processes. • Business Planning and Analysis: Assisted in business plan creation, financial analysis reports, SWOT analysis, market analysis, and marketing strategy development.