Hector Meléndez

Hector meléndez

bookmark on deepenrich
Followers of Hector Meléndez403 followers
  • Timeline

  • About me

    Data Engineer at Driscoll's

  • Education

    • Universidad del valle de atemajac

      2012 - 2015
      Licenciatura international business/trade/commerce
  • Experience

    • Ibm

      May 2016 - Aug 2021

      My experience includes:Preacquisitions: Supporting over 121 customers of Brazil in Portuguese. Placing SW and HW new orders, analyzing quotes, managing internal spend and financial approvals, tracking and placing orders, and coordinating purchases with Procurement.My biggest accomplishment in this role was to work with a global team to develop and deploy an Order Management dashboard in Cognos Analytics, that helped customers to have an easy and quick overview of their purchases. I acted as consultant, providing insights about the process, focalizing and obtaining information and data, and pitching the project to Senior Leadership.SW Entitlement: responsible for SW inventory and SW tracking, inventory accuracy continuous improvement and Business Controls metrics. Automating inventory reports using data mining software.My greatest achievement was to design, pitch and deploy a dashboard using Data Mining, Excel macros, and Business intelligence software that focalizes around 12 databases and helps customers visualize inventory data for Hardware, Software, and Purchase Expenditure. Show less Coordinator for Asset HW service to one of the biggest brewery in LA. - Responsible for IT asset inventory for Mexico, USA, and Caribbean facilities of around 100,000 assets; - Responsible for key team metrics and SLA’s, as well as HW inventory continuous accuracy improvement-Managing E2E scrap process and device refresh with onsite staff, vendor and customer.- Focal point for implementation of new asset hardware management services and processes with customer and other IBM Service Lines and optimization of existing processes, -Providing IT inventory related reports and annual IT refresh forecasts to help the client make budget decisions-Tracking and providing asset information-Dispatching and dividing existing workload to Asset HW analysts and provide operational feedback. -Focal point and follow up for escalations. Show less

      • Business Intelligence Developer

        Jan 2021 - Aug 2021
      • Brazil End to End Asset Management Analyst

        May 2019 - Jan 2021
      • HW Asset Management Coordinator

        Apr 2017 - May 2019
      • Order Management Analyst

        May 2016 - Apr 2017
    • Deloitte

      Aug 2021 - Feb 2022
      Data quality engineering lead

      I act as lead for a team of 4 experienced testers for Data Quality Engineering for 6 different downstream systems that handle data for an Insurance Company, providing leadership experience and working alongside the business, PM team, developers, 3rd parties, data consumers and testers to analyze requirements and technical documentation, build test strategies, test scripts and manage SIT and UAT test execution to comply with deadlines and audit requirements for complex changes and integration of systems acquired through mergers, as well as migration of databases from OnPrem to cloud. Ingesting data from business extracts or mainframe databases using ETL jobs and providing test data to data analysts and consumers developing complex queries.Technical Environment: DB2, MSSQL, SQL, Informatica Powercenter (ETL), Python, Mainframe, Jira Show less

    • Tribal

      Feb 2022 - Apr 2023
      Data quality engineer

      - Create quality oriented data models using ELT pipelines (dbt), Snowflake and looker.- Transform business rules to actionable data monitors.- Research, document and monitor data business rules using complex SQL queries.- Drive cross departamental collaboration to implement Data Quality strategies and data remedies- Analyze and detect quality trends on data.- Implementation of test batteries in dbt Expectations as well as custom tests- Assist the Data Analytics team with Quality Assessments of critical dashboards.- Test and analyze ELT jobs for potential data issues, and triaging resolution with Data Engineering.- Performed data validations and analysis using Python (Pandas, Numpy)- Assisted the Engineering team on a database migration with Quality monitoring and testing suite.- Quality Assess critical financial reports.- SQL, Jinja, Python, Snowflake, Looker, Gitlab, Jira, dbt, Kubeflow, R. Show less

    • Driscoll's

      Apr 2023 - now
      Data engineer
  • Licenses & Certifications

  • Volunteer Experience

    • Consultor

      Issued by Secretaría de Economía México on Apr 2015
      Secretaría de Economía MéxicoAssociated with Hector Meléndez