Chad Warner Email & Phone Number

Philadelphia, PA, US

Chicago, IL, US

• Performed data profiling across multiple datasets, uncovering patterns, anomalies, and quality issues to enhance data accuracy and consistency throughout the organization.
• Designed and managed interactive Power BI and Tableau dashboards, delivering real-time insights into operational metrics and performance indicators to support rapid decision-making by leadership.
• Executed root cause analysis for recurring data discrepancies, documenting processes, findings, and resolutions to ensure transparency and continuous improvement.
• Crafted complex SQL queries to extract, cleanse, and analyze large datasets from diverse databases, streamlining data processing for critical business insights.
• Identified trends through meticulous data cleaning and validation, ensuring reliable and high-quality data for reporting and decision-making.
• Leveraged advanced Excel functions, including macros, pivot tables, and slicers, to analyze extensive datasets and deliver actionable business insights to management.

Chicago, IL, US

• Collected, cleaned, and analyzed large datasets to uncover trends, patterns, and actionable insights, driving improved strategic decision-making.
• Designed and implemented data models while collaborating with cross-functional teams to define data requirements, ensuring accurate and timely reporting.
• Created interactive dashboards and visualizations using Tableau and Power BI, enabling stakeholders to explore data and derive meaningful insights.
• Developed and optimized SQL queries, including writing stored procedures and refining existing scripts to enhance performance and reduce execution times.
• Built predictive models to forecast business trends, contributing to a 15% increase in operational efficiency through enhanced strategic planning.
• Conducted thorough data audits to validate data integrity, achieving 99.5% accuracy in reporting.

• Designed and maintained healthcare-focused dashboards, visualizations, and reports in Power BI and Tableau to track key performance indicators (KPIs) such as patient readmission rates, treatment outcomes, and resource.
• Leveraged technical tools like SQL, Python, and Excel to extract, transform, and analyze data from electronic health records (EHR) and other healthcare databases.
• Implemented ETL (Extract, Transform, Load) and ELT (Extract, Load, Transform) processes to consolidate and transform healthcare data from diverse sources, ensuring accuracy, consistency, and operational efficiency.
• Ensured strict adherence to healthcare regulations, including HIPAA, PII, and PHI, by deploying robust data security and privacy protocols.
• Identified areas for procedural improvement using SQL, Python, and Excel, resulting in an 8% increase in profitability across various campaigns.
• Analyzed complex healthcare datasets to uncover trends, leading to a 15% boost in operational efficiency.

San Francisco, California, US

• 600+ hours of hands-on course material, with 1:1 industry expert mentor oversight and completion of 2 in-depth capstone projects.
• Mastered skills in data cleaning, data wrangling, exploratory data analysis, feature engineering, pre-processing data, and modeling.
• Presented projects and communicated my finding and recommendations to audiences with technical and non-technical backgrounds.Capstone Project
• Developed a model that had the capability to predict housing prices using a linear regression, Bayesian models with accuracy of age classifier with 101 classes and 80% accuracy
• Implemented Convolutional Neural Network (CNN) with PyTorch
• Implemented metrics to calculate loss functionsTopics covered in mini projects include:

• Designed and implemented data models and pipelines using Python to extract, transform, and load (ETL) data efficiently, ensuring data readiness for analysis.
• Cleaned and validated data to maintain integrity and developed scripts to automate repetitive data analysis tasks.
• Leveraged Python libraries such as Pandas, NumPy, and SciPy to analyze and interpret data.Created predictive models to forecast customer behavior, driving targeted marketing strategies and improving decision-making.
• Utilized Microsoft Excel for advanced data analysis, including pivot tables, VLOOKUPs, XLOOKUPs, macros, and INDEX/MATCH functions, to streamline reporting and analysis processes.
• Designed customized visualizations, dashboards, and reports in Tableau and Power BI to uncover data trends and patterns, delivering actionable insights.
• Developed and managed databases in Microsoft Access and Microsoft SQL Server, employing SQL for storing and querying customer, inventory, and employee data while integrating ETL processes for seamless data.

Bachelor Of Engineering - Be, Systems And Information Engineering

Doctor Of Law - Jd, Law