H

Hector Chapa

About

Detail

Data Analyst
Tamaulipas, Mexico

Timeline

work
Job
school
Education
folder
Project
auto_stories
Publication

Résumé

Jobs verified_user 0% verified
  • Usbank
    Data Analyst
    Usbank
    Feb 2024 - Jan 2025 (1 year)
    • Designed and optimized complex SQL queries for data analysis, cleansing, and transformation. • Implemented Python scripts to automate ETL processes and improve data pipeline efficiency. • Developed advanced Power BI dashboards with DAX measures to provide actionable insights for stakeholders. • Enhanced data lineage and traceability by documenting workflows and integrating metadata management practices. • Collaborated with cross-functional teams to improve data governance and data quality policies. • Conducted root cause analysis and resolved data discrepancies across multiple systems. • Provided training and mentoring on Python best practices, SQL optimization techniques, and data analysis methodologies. • Streamlined data mappin
  • KeyBank
    Sr. Data Analyst
    KeyBank
    Jul 2023 - Jan 2024 (7 months)
    • Spearheaded data analysis, data profiling, data migration, and data integration initiatives. • Designed and optimized ETL workflows using SSIS, Talend, and Informatica, ensuring data accuracy and efficiency. • Developed and maintained Tableau dashboards and Power BI reports to monitor daily operational performance. • Implemented DAX measures in Power BI for advanced analytics and reporting. • Led data governance projects, using Collibra for documenting data lineage and ensuring compliance. • Designed and maintained Azure Data Warehouse and integrated AWS services for seamless data management. • Conducted EDA and statistical analysis using PySpark to uncover actionable insights.
  • W
    Sr. Data Analyst
    WellsFargo
    Jan 2022 - May 2023 (1 year 5 months)
    • Conducted comprehensive data lineage assessments and identified data quality issues and control gaps. • Utilized AWS Key Management Service for securing data during transit and at rest. • Designed and developed machine learning models using TensorFlow and Scikit-learn to enhance decision-making. • Built and maintained data models in Erwin, ensuring logical consistency and adherence to design standards. • Migrated databases to Snowflake, leveraging its multi-cluster architecture for scalability. • Automated data mapping and transformation processes to improve ETL efficiency and data quality testing.
  • Verizon
    Data Engineer
    Verizon
    May 2021 - Dec 2021 (8 months)
    • 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 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:
  • J
    Data Analyst
    JP MORGAN CHASE,
    Dec 2019 - Apr 2021 (1 year 5 months)
    • Managed data model changes using version control features in Erwin. • Created and customized Microsoft Dynamics 365 forms and workflows for business process automation. • Automated complex workflows using Python and UNIX shell scripting, reducing manual effort and errors. • Deployed machine learning models into production, integrating them into web applications and APIs. • Designed real-time OLTP-based reporting solutions for instant insights into transactional data. • Streamlined ETL processes, reducing processing time by 20% using PySpark and optimized SQL queries. • Delivered data lineage documentation that improved data transparency and compliance by 30%. • Designed Snowflake and AWS solutions, reducing cloud operational costs
Education verified_user 0% verified
  • ITESM CAMPUS MONTERREY
    Master's in Engineering
    ITESM CAMPUS MONTERREY
    Dec 2014 - May 2018 (3 years 6 months)
Projects (professional or personal) verified_user 0% verified
  • U.S. Bank
    Q&A CSC Project
    U.S. Bank
    Feb 2024 - Jan 2025 (1 year)
    Retrieval of key fields accordingly to stakeholders from different data sources utilizing SQL or Python according to the number of data sources been queried at once for the data retrieval. The outcome of each procedure consisted of a data sample saved in an Excel file with its corresponding main core field "call_id" to be tracked by the CSC Analysts to listen to the call and audit the bank agent.
  • Wells Fargo
    Bureau Credit Information Repository
    Wells Fargo
    Jan 2022 - May 2023 (1 year 5 months)
    Creation of a repository to migrate data from different data sources to native-cloud environment Snowflake to store all credit bureau information and to serve as the main bureau data repository.
  • JPMorgan Chase & Co.
    Churn Prediction and Fraud Detection
    JPMorgan Chase & Co.
    Dec 2019 - Apr 2021 (1 year 5 months)
    Creation of a Machine Learning Model for Churn Prediction and Fraud Detection. Logistic Regression, RandomForestClassifier, Multiple Linear Regression and XGBoost models were used but lowest MSE model was considered for this. Hyperparameter tuning was performed in the process.
Publications verified_user 0% verified