Hima

Data Analyst

Bepec Solutions • Período integral

Jun 2023 - Present • 3 yrs 4 mos

BEPEC Solutions, Role and Responsibilities: - Conducted data mining, data modelling, data extraction, data analysis, data visualization and reporting, designed and implemented a data pipelines by storing datasets on different platforms, Performed exploratory data analysis (EDA) and descriptive analytics to ensure high-quality data inputs - Maintained data models and relational databases, performed data extraction using stored procedures, Normalize and DeNormalize the database for faster query retrieval, Design A/B testing on sales data; generate tracking reports with KPI, designed and developed interactive, proprietary dashboard and analytics solution by identifying, analyzing and interpreting trends or patterns in complex data sets, turning data into synthesized executive-level recommendations and business cases - Optimized Employee Performance by analysing key performance indicators using Python and Power BI, leading to a 16% reduction in customer escalations through predictive modeling - Conducted Customer Lookalike Analysis for a food & beverage manufacturer by cleaning, analysing, and visualizing data, resulting in a 10-15% business growth from non-commercial segments - Performed Marketing Strategy Analysis using statistical and inferential techniques to quantify sales impact and competitor, influence, supporting budget allocation decisions for a flagship medication - Communicated & collaborated within the team as well as the stakeholders, to present complex data insights to both technical & non-technical audiences, ability to prioritize work, work in a dynamic environment