Data Analyst with 4+ years of experience with ETL processes to develop reports, dashboards and actionable insights in alignment with business KPIs that enable leadership teams to make better decisions from real time data.
-
Data AnalystOlive.Com Jan 2023 - Present• Developing and maintaining data-driven reports in Power BI to monitor the performance of sales, active products, cancelled products, marketing insights and new sales initiatives with Python and SQL, enabling data-informed decisions on multiple projects management.• Leading weekly data analysis presentations to management, providing insights into KPIs across sales, marketing, data processing and customer interactions to show business pain points, improvement opportunities, and early warning signs with Power BI and SQL.• Managing QA analysis with SQL and Power BI to assure that our key processes meets quality standards for marketing campaigns.• Migrated DOMO data processes to SQL codes for application on PowerBI. -
Data AnalystFlorexpo Llc Feb 2021 - Dec 2022• Worked with Florexpo, one of the leading importers and distributors of fresh-cut flowers in the West Coast of the United States.• Managing sales data analysis projects with Python and SQL to clean, structure and compile information.• Generating dashboards to track, analyze and display daily data with PowerBI and Excel.• Developing time series regression models to forecast sales with Python decreasing the amount of dump across all facilities.• Leading weekly meetings with sales account managers to discuss the next 13 week projections.• Analyzing trends, seasonalities, promos, holidays and events that affects the sales across all customers with data analysis on Python.• Developing Process Automation with UiPath and migrating low risk processes to Python and Selenium. -
Planning AssistantGrupo Uribe Sep 2020 - Feb 2021Medellín, Antioquia, Colombia• Worked on the analysis and planning of picking clothes process, always looking for the best strategy to have an efficient process.• Maintenance and update of KPI reports with PowerBI to monitor the performance of the whole process, identifying flaws, improvement points and new methodologies to work with.• Reorganizing the distribution of the products across the Distribution Center to make the process easier for strong sales weeks. -
Production PlannerKendal Floral Supply, Inc Jan 2020 - Jun 2020Carlsbad• Worked on the production planning to provide the schedule and the priority that the products will be worked on in the most efficient way.• Supported the development of tools with VisualBasic to simplify the balancing process for each production line.• Developed a productivity data analysis tool for each production line to make better decisions and plan the next days production with Excel. -
Student ResearcherUniversidad Eafit Aug 2018 - Dec 2019Medellín, Colombia• Member of MIT GeneSys project that brings solutions and tools to small and micro business in order to increase their growth and survival rate in Medellín and the surrounding areas. • Worked with manufacturing companies of goldsmith, labels and inks on the different production lines after identifying all the flows of the processes.
Sergio Galvis Education Details
-
Operations And Logistics Management
Frequently Asked Questions about Sergio Galvis
What company does Sergio Galvis work for?
Sergio Galvis works for Olive.com
What is Sergio Galvis's role at the current company?
Sergio Galvis's current role is Data Analyst.
What schools did Sergio Galvis attend?
Sergio Galvis attended Universidad Eafit.
Not the Sergio Galvis you were looking for?
-
1hotmail.com
-
-
-
Sergio Galvis
Cajicá
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