Juan Pablo Sáenz Corredor Email and Phone Number

Responsible for the design, development, and support of the analytical tools and reports on the QlikSense Business Analytics platform.Responsible for the integration of the SQL Server databases and Excel files into QlikSense QVD’s.Involved in the creation of the price lists for different seasons and holidays.

Created an equivalent sales price metric for wholesale flowers, which helped to increase average sales prices by 38% over three years.Created flower demand forecasting models by varieties, grades, and colors.Optimized sowing area plans for short cycle flowers, improving area utilization indices by an average of 25% over two years.Developed metrics for the evaluation of rose production projections and execution, by color and by grade.

Instructor of the Industrial Engineering production and inventory control courses (IEN 765 and IEN 465).

Participant in several Department of Energy funded energy, waste and productivity assessments to small and medium-sized manufacturers, providing a minimum of eleven cost reduction techniques with implementation costs and payback times; with annual savings averaging approximately $190,000 in each company.

As a sales department intern, developed a procedures manual for the sales department; documenting the framework for vehicle purchases, transportation sales and delivery from various sources.As a marketing analyst intern, was largely responsible for the introduction of the 2006 Explorer Sport Trac into the Colombian market.