David Barragan Email & Phone Number

Phoenix, Az, Us

Remote

• Executed data cleansing initiatives within Alphabroder’s NetSuite ERP system, improving data accuracy by 90%+ through advanced Excel functions.

United States

• Led data management initiatives for PPG Industries, ensuring data integrity and facilitating the integration of product information into eCommerce platforms through close collaboration with product platform leaders.• Managed project activities across aerospace product teams, employing advanced business analysis to deliver accurate data solutions, while utilizing Excel for data consolidation and creating presentations to communicate progress and future initiatives.

• Led master data management initiatives to enhance data quality and accuracy, ensuring customer identification numbers aligned with Duns and Bradstreet numbers and NAICS codes within US LBM’s Master Data Management system.• Collaborated with Data Stewards to gather requirements and inform governance processes, while developing pivot tables for management insights and utilizing Excel formulas for data validation and cross-referencing.

Chandler, Arizona, United States

• Directed data cleansing initiatives for large datasets and coordinated SAP ERP projects at Insight Enterprises, utilizing Excel and BI tools to ensure data accuracy and enhance client master data records for new sales representatives.• Facilitated stakeholder meetings to address data governance and analysis requirements, established a repository of governance policies, and developed metrics reports in Databricks, while creating an Excel-based data enrichment template using third-party data sources.

Chandler, Arizona, United States

• Evaluated client contractual budgets in Excel, providing allocation recommendations to minimize overspending while leveraging Power BI for data visualization and analysis of construction project budgets and performance metrics.• Collaborated with stakeholders to create KPI trackers in Excel, gathering and analyzing performance data and trends to support business operations.

Mesa, Arizona, United States

• Evaluated existing supply chain reports in Tableau, promoting best practices for transitioning to the Ariba SAP ERP reporting system and documenting attribute characteristics to create a comprehensive data dictionary.• Updated data in SAP Ariba using Excel mappings and the ETL process, collaborating with cross-functional stakeholders to develop test cases for data quality assurance, achieving a data cleanliness rate of 90% or higher through rigorous testing and collaboration efforts.

• Analyzed and cleaned student data in Excel, identifying inaccuracies and streamlining processes to reduce manual work and improve reporting efficiency.• Managed financial aid data auditing to ensure full compliance with Department of Education regulations, ensuring accurate resource allocation.• Tested and optimized SQL scripts, documented recommendations, and consolidated reporting requirements to improve data accuracy and reporting effectiveness.

Gilbert, Az.

• Performed complex data manipulation in Excel at Cascade Financial Services, utilizing advanced formulas to analyze client mortgage data and leveraging SQL for efficient data retrieval from enterprise databases.• Collaborated with stakeholders to develop robust KPI trackers in Excel, contributing to data improvement solutions and playing a key role in data-driven decision-making by providing insights and recommendations based on thorough analysis with Excel and SQL.

Tempe, Arizona, United States

• Excelled as a proactive Business Intelligence/Business Analyst at the University of Phoenix, utilizing Excel and SQL for sophisticated data analysis and problem-solving within a business intelligence framework.• Organized training sessions to empower personnel in report utilization, delivered comprehensive reports and dynamic data visualizations to stakeholders, and provided actionable insights from meticulous analysis with Excel and SQL to enhance data-driven strategies and drive organizational growth.• Managed change of status requests to ensure students were swiftly transitioned between courses within 48 hours, mitigating potential financial aid issues, while also assisting faculty with various student administrative requests to enhance operational efficiency.

Master'S Of Science In Information Systems Engineering, Computer And Information Sciences, General

Bachelor Of Science - Bs, Business/Concentration In Information Systems