Juan Carlos Ortiz Abrego

Experience

• 

  Intellego Latam

  Feb 2008 - Mar 2009

  Business Intelligence Junior Consultant

  - Delivered the first successful implementation and integration of HP Neoview with Oracle Business Intelligence and Informatica Power Center in Latin America, reducing the processing data time by 60%- Provided administration of Siebel Business Analytics applications and created BI reports and interactive dashboards that helped clients to reduce the time spent on reports creation.- Performed SQL and Oracle DB development.

• 

  Maxcom Telecomunicaciones

  Mar 2009 - Jun 2009

  Informatica Power Center and Oracle BI Developer

  - Designed and developed multidimensional data models with Erwin, ETL interfaces with Informatica Power Center, and business executive dashboards with OBIEE.- Managed the SDE and SIL mappings used to control the data extraction and load logic for the Data-Warehouse.

• 

  CIS Corporate

  Jun 2009 - Jul 2012

  Business Intelligence Senior Consultant

  - Led the design and implementation of a complete Business Intelligence solution that allowed the customer team to have a unique data repository and interactive dashboards that significantly reduced the report’s generation time.- Oversaw technical requirements determination, physical and logical modeling, diagrams, workflows, and documentation.- Trained new junior consultants in technologies such as Informatica Power Center and Oracle Business Intelligence EE.- Translated technical and functional requirements into business terms. Show less

• 

  Accenture

  Jul 2012 - Mar 2020

  - Served as an ETL Specialist, Data Architect, BI Team Lead, and Application Developer on projects in the U.S. and Mexico. - Provided remote and onsite leadership, supervising up to 4 persons per project in the U.S., Mexico, India, and the Philippines. - Worked with clients of different industries such as banking, telecommunications, insurance, and health services, among others.- Produced Proof of Concept, technical designs, interactive dashboards, ETL interfaces, technical and functional documentation.- Enhanced project efficiency for clients by implementing Agile methodology. Show less

  • Associate Manager

    Jan 2014 - Mar 2020

  • Associate Manager

    Jul 2012 - Dec 2013
• 

  Henkel

  Apr 2021 - Jun 2021

  Global eCRM Intern

  Joined the Global eCRM Capability of the Laundry & Home Care BU to work on the design and documentation of their Operating Model in a single, transferable, and upgradable document as part of the work for my Master Thesis.Additionally, I had the opportunity to manage specific tasks for the successful launch to the market of a new eCRM service called "The Wash Label Scanner", based on AI image recognition.

• 

  PreSales Collective

  Sept 2021 - now

  Member

  Our mission is elevate the role of PreSales in organizations worldwide. We aim to provide PreSales professionals with the resources, knowledge, network, and mentorship to develop long, impactful careers.Our vision is to create a global community of professionals who have a passion for PreSales. A place where individuals in a PreSales role, or anyone who aspires to be, will be supported in their professional development.

• 

  ATOSS Software AG

  Jan 2022 - Jul 2022

  Project And Process Manager

  Enable the internal digitalization efforts by gathering users’ requirements, researching the market, contacting software solution providers, and designing the work plan for the implantation of innovative software solutions for multiple departments.Managing and designing the initial phase for the implementation of a new Business Intelligence solution in multiple departments.

• 

  Tata Consultancy Services

  Oct 2022 - now

  Project Manager

  - Serve as the Technical Lead, overseeing the delivery of Operational Reports by analyzing and exploiting data stored in the cloud (Snowflake).- Assign tasks and allocate Sprint work using Jira, ensuring efficient project management and adherence to timelines.- Actively engage in technical tasks, including the development of ETL interfaces, code migration via GitLab, and creation of SQL scripts.- Navigate and overcome challenges related to comprehending diverse business rules, ensuring accurate implementation in operational reports.- Successfully steer the team to meet Sprint goals, addressing obstacles, and ensuring continuous improvement in project delivery. Show less