José Pablo Herrera Fernández Email & Phone Number

Aguascalientes, Ags., Mx

Aguascalientes, Mexico

Developing and maintaining robust ETL pipelines: Utilizing Matillion to extract data from various sources, including legacy MS SQL databases, transforming it to meet business requirements, and loading it into Snowflake's high-performance cloud data warehouse. This ensures a consistent and reliable flow of data for analysis and reporting.Designing and implementing scalable data warehouse solutions: This encompasses data modeling, schema design, and performance tuning within Snowflake to create a robust and efficient data warehouse architecture.Transforming data into actionable insights: Leveraging tools like Power BI to translate raw data into compelling visualizations and reports that drive informed decision-making across the business.Championing data quality and integrity: Implementing rigorous data quality checks, validation rules, and error handling procedures throughout the data lifecycle. Utilizing Sentry to proactively monitor data health and address potential issues.Collaborating with business stakeholders: Working closely with business users to gather requirements, understand their needs, and translate them into technical solutions. This includes identifying key performance indicators (KPIs) and designing reports that provide actionable insights.Essentially, my role is to bridge the gap between raw data and business value. I ensure the right data gets to the right people at the right time, empowering them to make data-driven decisions that move the organization forward. It's a role I find both challenging and incredibly rewarding.

Aguascalientes, Mexico

-Proactively maintain and optimize IT infrastructure performance, ensuring seamless business operations and a high level of user satisfaction.-Effectively manage and mentor IT teams, assigning roles and responsibilities to maximize individual and collective performance.-Assume full accountability for the IT infrastructure, guaranteeing the functionality and reliability of systems critical to core business operations.-Develop and execute comprehensive migration plans and strategies, minimizing downtime and ensuring smooth transitions to new technologies.-Proactively identify and analyze market trends, threats, and opportunities, providing valuable insights to support strategic decision-making.

Aguascalientes, Ags, México

-Provide expert-level support for data loading operations, ensuring the timely and accurate delivery of data across various platforms (Teradata, Informatica, MS SQL, SSIS).-Proactively identify and resolve data quality issues within ETL processes, maintaining the integrity and reliability of critical business data.-Design, develop, and maintain MS SQL databases and data warehouses, supporting diverse business functions including restaurant operations and construction inventory management.-Utilize advanced SQL Server technologies (SSIS, SSAS, SSRS) to develop and maintain robust data solutions, including ETL processes, data analysis, and reporting.-Serve as a technical team lead and subject matter expert (SME), providing guidance and mentorship to junior team members.

San Francisco De Los Romo, Aguascalientes

-Act as the subject matter expert (SME) for the RAINDE ERP system, providing guidance and support to end-users on all aspects of system functionality and configuration.-Manage and maintain ERP user roles and permissions, ensuring data security and compliance with company policies.-Ensure the accurate and timely entry of critical ERP data, including truck float information, insurance details, and transit permissions.-Provide comprehensive technical support for all IT-related issues, including network connectivity, hardware troubleshooting, and software support.

Costa Rica

Proactively identify bugs in the views, tables, stored procedures or any SQL code residing in Teradata, be able to modify ETL graphs in AbInitio, within the team scope, drive enhancements requested by final users through the environments, following the best guide and practices by ITIL.Develop solutions like views in HANA Studio for new processes and be able to go into SAP GUI and seek for information needed.

Costa Rica

Accountable for Monthly, Quarterly and Year End financial close, comprehend the relationship with stakeholders and have business acumen. Respond to autosys alerts for all finance related batch jobs, set up new finance batch jobs and modify current finance batch jobs to meet business needs. Focus on supporting processes in EDW, SAP and AbInitio environments that provide reporting for financial teams. Implementing solutions to return the production environment to normal operations.

Costa Rica

Provide monitoring and prompt response for multiple platforms such as Windows Server, Data Bases (MS SQL), Infrastructure and Clusters, perform remote management troubleshooting and managing incidents in the enterprise-wide world computing environment strongly align to ITIL’s Standard.Identify resolution actions, and implementing solutions to return the production environment to normal operations. Identify opportunities for internal business processes improvements and participating in continuous or project-based teams. Team Lead staff, responsible for critical production system monitoring SAP (SAPGUI)

Costa Rica

Responsible to remote monitor production systems such as Oracle reports, SQL reports, Solar Winds (Network behavior) events and alerts and UNIX systems alerts. Troubleshoot all the incidents related to Active Directory users and domains. Responsible to properly escalate issues/alerts to the concerning teams (networking). Interface with local site support at any Arbonne location.

Costa Rica

Monitor and perform remote management, troubleshooting, and manage incidents related to the telephony infrastructure such as Avaya, Nortel and Cisco for Intel. Identify issues, and implement solutions to return the environment to normal operations.

Master’S Degree, Data Modeling/Warehousing And Database Administration

Emphasis on Big Data and Business Intelligence

Bachelor’S Degree, Systems Engineering

Activities and Societies: Cisco CCNA modules 1 and 2