Jesus Alejandro Eca Avila

Experience

• 

  Bayer

  Apr 2006 - Jun 2010

  Market Research Analyst

  Responsible for the analysis of information on the pharmaceutical market through the design and generation of market indicators, competition analysis and market studies. Identification of market opportunities for launching new products.• Creation of an integral Business Intelligence solution (DataMart, olap cubes, KPI's and managerial reports) that generated a saving of 80% in the time in information generation and 15% in the cost of purchasing information from consultants.

• 

  IBM Business Services

  Jun 2010 - Jul 2011

  Business Intelligence Analyst

  Consultant in Business Intelligence projects, implementing Datawarehouse, DataMart, ETL’s, KPI’s and managerial reports to monitor sales, budget, customers and production. Reporting to the Project Manager.• Automation of the sales control panel, reducing the time and use of resources for its generation by 70%.

• 

  Rimac Seguros y Reaseguros

  Aug 2011 - Dec 2016

  Responsible for strategic planning, commercial intelligence and increased productivity. Preparation of the sales budget, assignment of goals, monitoring of compliance and generation of actions to close deviations. Implementation of digital tools for monthly sales planning, monitoring of indicators and increasing productivity. Reporting to the commercial vice president and supervising fifteen people.• Implementation of commercial methodology for daily planning and improvement of the productivity of sales teams, achieving an increase of 15% in this indicator. Show less Responsible for creating performance monitoring indicators for FFVV, products, campaigns and projects, implementing DataMart, reports, balanced scorecards and segmentation models. Design of commercial campaigns and initiatives for their fulfillment. Reporting to the Sales Manager and supervising six people.• 90% reduction in information generation time thanks to the implementation of a BI solution with commercial indicators and goals to monitor performance.• Design and measurement of commercial campaigns that increased average premium by 12%. Show less

  • Commercial Development Manager

    Sept 2015 - Dec 2016

  • Commercial Support Manager

    Aug 2011 - Aug 2015
• 

  Oficina de Normalización Previsional

  Feb 2017 - Feb 2019

  Business Intelligence Architect

  Lead the implementation of business intelligence and digital transformation solutions according to the institutional strategic plan, managing suppliers and tenders for their execution. Generation of control dashboards and balanced scorecards with a complete view of the business and key indicators. Reporting to the Innovation and Development Manager and supervising two people.• Proposal, design and implementation of the institutional Datawarehouse, DataMart and management reports associated with it, allowing to save of S/ 100 thousand per year in payment to a help desk provider for generating databases and reports.• Proposal, design and construction of DataMart and CRM reports (oriented to the commercialization of SCTR insurance) and customer segmentation, allowing a saving of 60% of time in the generation of reports, presentations and information analysis. Show less

• 

  Mibanco

  Apr 2019 - now

  Lead business intelligence and analytics projects and initiatives applying agile methodologies to increase value delivery. Strategic planning of the team, establishing objectives, key results, indicators and prioritization of initiatives. Reporting to the Tribe Leader and supervising seven people.• Implementation of a predictive model for early customer attrition, optimizing the effort of the sales force for its management and retention, achieving an improvement in the churn indicator by 20%. Show less Responsible for the design of information models and business intelligence solutions for daily monitoring of indicators through management dashboards and ad-hoc analysis. Trend analysis, customer segmentation and sales force performance measurement, discovering actionable business insights. Reporting to the Information Management Manager and supervising five people.• Daily personalized alerts to sales teams, including prescriptive analyzes with levers to activate to ensure compliance with key indicators, increasing compliance with the disbursement indicator by 8%.• Implementation of the optimized Datamart with “online” information (updated every 30 minutes), which, together with the migration of reporting to a single dashboard in Power BI, managed to increase productivity by 10% at month-ends. Show less

  • Business Intelligence Manager

    Nov 2023 - now

  • Business Intelligence Assistant Manager

    Sept 2022 - Nov 2023

  • Information Management and Monitoring Supervisor

    Apr 2019 - Sept 2022