Data Analyst with proficiency in Python (Pandas), SQL, and Power BI for the full data cycle: extraction, cleansing, analysis, and visualization. My previous experience allows me to understand business requirements and translate them into actionable insights that support strategic decision-making.
I performed extraction, cleansing, and analysis (ETL) of patient data from various sources, consolidating it for reporting and analysis. I developed a dashboard in Looker Studio (Google Data Studio) connected to Google Sheets to visualize appointment availability and workload in real time, optimizing resource allocation.
Major achievementI used advanced features and pivot tables in Google Sheets to analyze customer satisfaction and present insights to the management team.
I used SQL to perform ad-hoc queries and extract sales data directly from the Salesforce database. I automated the generation of commission and sales performance reports using Python scripts (with the Pandas library), reducing manual processing time by over 80%.
Major achievementCreated data visualizations to present sales campaign performance to stakeholders, facilitating strategic decision-making.
I designed and built a comprehensive Power BI dashboard, centralizing Shopify sales metrics, Stripe transactions, and inventory data, which became the company's primary business analytics tool. I analyzed large volumes of Shopify user behavior data using Python (Pandas, Matplotlib) to identify purchasing patterns and cross-selling opportunities.
Major achievementI developed and maintained data pipelines (ETL) to ensure that information from different platforms was consistent and up-to-date for analysis.