Hector Chapa - Data Analyst,

Feedback from Hector’s ex-colleagues

Let me see

Keep in touch with meI'm using Intch to connect with new people. Use this link to open chat with me via Intch app

Work Background

U.S. BankData Analyst

Mar. 2024 - Jan. 2025Fort Worth, Texas, United States• Integration for critical data across a multitude of source types (SQL, Hive, Oracle, and DB2) with the intent to design and structure key queries • Manually supported data pipelines which serve the Quality Analyst team, and subsequently support the long-term integration into automated solutions • Key documentation and speed to market assistance for Platform Product Teams to integrate Source to Target integration for Quality Audits • Key Visio Maps of the data integration paths developed as well as Database Schematic documentation, field mapping, and query development with strong quality validation testing and evidence collection. • Power BI dashboard developed which support the integration demands of the quality assurance and data exploration needs • Gap analysis and Requirements development required to support Engineering requirements to close data gaps • Data mine, analyze data, and pipeline via Python to present insights in a meaningful way • Developed and maintain strategic partnership with Senior Business Unit management, business partners and project sponsors, as well as communicate effectively with business, and development teams, end users, and product owners

KeyBankData Analyst

Jul. 2023 - Jan. 2024Dallas, Texas, United States• Worked on projects involving Business and Data Analysis, Data Profiling, Data Migration, Data Integration and Data Discovery. • Data Modelling by gathering specifications and requirements and interacting with end users. • Manage all data collection, extraction, transformation and load (ETL) activities using SSMS. • Ability to develop, design and optimize ETL workflows, ensuring efficient data extraction, transformation and loading. • Creation of ERDs to visually represent data models and their relationships. • Creation of Tableau dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality. • Creation of interactive dashboards in Tableau for monitoring performance on a day-to-day basis.

Wells FargoBusiness Intelligence Analyst

Jan. 2022 - Jan. 2023Irving, Texas, United States● Extensively worked on of credit bureau data flow under Originations process across all Lines of Business ● Data Mapping of Credit Bureau Data Flow Diagrams under Originations, Bureau Refresh and Account Management processes across Lines of Business ● Gathered and developed Requirements from Business users in JIRA (feature stories and user stories) and record them clearly in a format useful to developers and test analysts. ● Worked collaboratively with LOBs, SMEs, stakeholders and PMOs to fulfill daily tasks such as creation of diagrams and/or gathered requirements data migration and delivered source to target mapping documents. ● Gathered requirements by working with the business users on Business Glossary, ● Data Dictionary, Reference data, and Policy Management. Environment: MS Office 2007, MS Visio 2003, Windows XP, MS Excel, SharePoint, PowerPoint, MS Project, MS Outlook, JIRA

VerizonData Engineer

May. 2021 - Dec. 2021Irving, Texas, United States● Worked collaboratively with LOBs SMEs, stakeholders and PMOs to fulfill daily tasks such as creation of diagrams and/or gathered requirements data migration and delivered source to target mapping documents. ● Gathered requirements by working with the business users on Business Glossary, Data Dictionary, Reference data, and Policy Management. ● Created ad-hoc reports to users in Tableau by connecting various data sources. ● Preparing dashboards using calculated fields, parameters, calculations, groups, sets and hierarchies in Tableau. ● Created sheet selector to accommodate multiple chart types in a single dashboard by using parameters. ● Created and maintained issue log where business users enter their feedback by working on dashboard in test environment. ● Implemented the feedback and incorporated the necessary changes. Environment: SharePoint. SQL Teradata Server, Tableau, Gmail, Google Docs., Python

JPMorgan Chase & Co.Data Analyst

Dec. 2019 - Apr. 2021Dallas, Texas, United States● Experience in working in investments accounting with financial statements analysis and preparing monthly reporting. ● Involved in Data Quality validation by writing several SQL queries and back-end testing. ● Performed data analysis and data profiling using SQL on various sources systems including Oracle and Teradata ● Conducted GAP analysis to analyze the variance between the system capabilities and business requirements. ● Involved in defining the source to target data mappings, business rules, business and data definitions. ● Created Report-Models for ad-hoc reporting and analysis. Environment: MS Office 2007, MS Visio 2003, Windows XP, MS Excel, Sharepoint, MS Powerpoint, MS Project, SQL Server, Tableau, Power BI, Oracle and Teradata Server

Japan International Cooperation Agency (JICA)Company - Wide Quality and Productivity Management Trainee

Jan. 2019 - Aug. 2019Nagoya, Aichi, JapanTo learn Japanese Techniques and Methods for Quality and Productivity Management in the Organization

London Consulting GroupManagement Consultant

Jun. 2017 - Nov. 2018Monterrey Area, Mexico▪ Process Management applying London Consulting methodology among several business departments which include: Sales, Marketing, Human Resources and Supply Chain ▪ Analyze business units by performing tasks to determine weaknesses ▪ Business Units Productivity Improvement Guatemala PERCO Project ▪Observational studies made for Warehouse and Sales Departments to seek opportunity areas and apply continuous improvement. (Such observational studies consist of targeting an individual and following him through out his working hours to record all of his movements for a SWOT Analysis) Argentina AMCOR Project ▪Observational studies made for Warehouse, Sales, Purchase and Logistics Departments. ▪For Quality, Purchase and Sales Departments Statistical Analysis were made related to labor hours. These statistical analysis showed an approximate number of working hours for each individual on each department. These analysis were compared to the optimum working hours each individual should work making it easy and quick to find opportunity areas. Ecuador Project ▪Observational studies made for Warehouse, Sales and Customs Departments to ensure the job was being done as dictated by the job description. Puerto Rico HELAPAN Project ▪Successfully increased customer satisfaction and loyalty rate by 46% by creating a product catalog and route planning for freight line suppliers for Puerto Rico ▪Weekly and Monthly executive presentations to show company´s as-is vs. to-be

Autlán Grupo FerromineroLogistics Coordinator

Mar. 2016 - Jun. 2017Monterrey Area, MexicoResponsibilities: ▪ Arrangement of transportation services for all orders to ensure bulk and packed material is delivered per schedule (Ferroalloys, Non – Ferroalloys and Chemical products) ▪ Expedites all freight purchase orders with local freight lines ▪ Obtains and forwards information to operations and sales teams to receive feedback and improve service ▪ Creation and update on a monthly and annual basis of Executive PPT for Logistics and Procurement Department Achievements: ▪ Successfully decreased freight costs rate by 50% by creating a route planning to assign freightlines to each speciﬁc route and ensuring all low boys and hopper trucks were loaded at all times

Autlán Grupo FerromineroMarket Strategy and Sales Analyst

Aug. 2014 - Mar. 2016San Pedro Garza GarcíaResponsibilities: ▪ Analyses of international manganese ore prices and ferroalloy prices and its impact on local and international customer prices (formula prices) ▪ Compilation of historical information about exports and national sales by volume, income and weighted average price for Ferroalloys, Manganese Nodules and Fines, Chemical Industry and Non-Ferroalloys areas. ▪ Update on a monthly and annual basis of Executive PPT for Sales Department (Chief Commercial Officer), Ferroalloys Production Department (Chief Operating Officer) and Executive Management (Chief Executive Officer) ▪ Update of International ferroalloys, manganese ore and nonferroalloy prices by Ryan’s Notes publications. Achievements: ▪ Increased proﬁt rate during period 2016 - 17 by 314% by working side by side with Ferroalloys Production Departments lowering production costs and ensuring all sales with local steel mills preventing them from exporting overseas material by negotiating sales prices

Autlán Grupo FerromineroLogistics Coordinator

Mar. 2014 - Aug. 2014San Pedro Garza GarcíaResponsibilities: ▪ Arrangement of transportation services for all orders to ensure bulk and packed material is delivered per schedule (Ferroalloys, Non – Ferroalloys and Chemical products) ▪ Expedites all freight purchase orders with local freight lines ▪ Obtains and forwards information to operations and sales teams to receive feedback and improve service ▪ Creation and update on a monthly and annual basis of Executive PPT for Logistics and Procurement Department Achievements: ▪ Accomplished throughout logistics job career 100% rate of national deliveries by developing freight line suppliers and Increased freight line suppliers by 160% throughout a suppliers development planning