Caleb Dunham Email & Phone Number

Leawood, Ks, Us

Milwaukee, Wi, Us

Meet with clients to gather project requirements. • Designed and implemented an end-to-end data integration system using Azure services and Azure DevOps. This system enabled seamless data ingestion from various formats (CSV, JSON, XML, Excel) into Azure Blob storage, orchestrated data flow through Azure Functions and Event Hub, and automated data transformation and loading into a Snowflake data warehouse via Matillion, streamlining data processing and analysis workflows. • Developed multiple Snowflake Native Apps using Streamlit, Python, and Snowpark, including an application for mapping shipping manifests to industry codes using Snowflake Cortex LLM functions. • Developed and implemented Alteryx workflows to efficiently transform data files and seamlessly create new or update existing Snowflake tables.• Conducted a comprehensive analysis of existing ESG (environmental, social, & governance) Alteryx workflows and successfully reengineered them for improved efficiency and modularity. • Conducted one-on-one instructional sessions with Alteryx users, providing guidance, answering questions, and assisting in troubleshooting issues, fostering a more efficient and informed user community. • Developed and enhanced dbt models to effectively transform client data, showcasing skills in building reusable data transformation pipelines. • Efficiently migrated existing Excel VBA macros to Alteryx workflows, improving data processing efficiency and integration within the overarching data ecosystem. • Established seamless connectivity to JIRA utilizing Fivetran and dbt, enabling the extraction, transformation, and loading of data into a Snowflake Data Warehouse for enhanced data integration and analysis.

Las Vegas, Nevada, Us

Work with business stakeholders to identify key variables for analysis and reporting; analyze and visualize data to provide performance and improvement metrics.• Utilized Tableau and other business intelligence tools to develop analytical content including reports, dashboards, and ad-hoc analyses and data sets.• Codified business logic in SQL to meet reporting requirements for all areas of operations.• Collaborated with business unit owners to constantly improve work product, debug erroneous logic, and create new features in existing report packages.• Utilized relational database and data warehouse design skills to create an effective data model for efficient and robust historical and real-time reporting.• Piloted use of Azure Databricks to develop and execute Big Data Analytics and Machine Learning applications.• Elicited requirements when necessary, using interviews and data analysis; defined requirements for and performed user-acceptance testing of new data in the data warehouse.• Supported end-user adoption of Tableau through trainings and creation of documentation.• Logged, tracked, and managed issues and requests in JIRA.

Las Vegas, Nevada, Us

Developed processes that leveraged existing systems to create technical solutions.• Analyzed existing tools and protocols and worked with internal and external stakeholders to build test tools for potential expansion.• Collaborated with the Information Technology (IT) and Business Intelligence teams to validate that strategic business needs were met, appropriate training was created, and data integrity was maintained.• Evaluated systems and processes to create efficiencies; built test solutions; provided solution documentation; coordinated implementations with IT and the Project Manager leads for creation of real-time monitoring and analysis of Key Performance Indicators (KPIs); developed standard reporting models with visualizations to aid decision-making and overall strategy.

Las Vegas, Nv, Us

Provided strategic business analysis services for casino clients by identifying trends, performance metrics, and areas of strategic improvement through data analytics.• Utilized modeling tools to acquire and analyze data from a variety of sources.• Supported business intelligence (BI) initiatives in Tableau, including report development and data management.• Partnered with gaming sales and marketing teams to develop and deliver advanced analytics including dashboards, KPIs, and other metrics.

Las Vegas, Nv, Us

Processed, cleaned, and reviewed data from multiple sources, then analyzed it to assist with internal and external business decisions and trends for Kansas Lottery.• Modeled data using SQL, Alteryx, and other various analytical tools.• Designed, produced, and interpreted dashboards to track and improve data quality.• Worked with team members, management, and external customers to understand business needs and formulate strategies to address those needs.

Kansas City, Ks, Us

Designed, created, deployed, and managed the cortical plasticity lab's data architecture for neurophysiological data collected from various sources, demonstrating expertise in scientific data engineering and management. • Developed robust ETL processes to extract data from diverse scientific file formats (Intan rhd/rhs, lvm, and TDT tsq and tev binary files), transforming the resulting data into MATLAB-readable formats, and loading data into the lab's data warehouse, showcasing strong data pipeline development skills. • Implemented data quality checks and validation processes to ensure the integrity and accuracy of scientific data throughout the ETL pipeline. • Researched and developed machine learning models for neuronal event classification, applying data science techniques to solve complex scientific problems. • Developed statistical methods for analyzing multi-channel neuronal time-series data, demonstrating proficiency in handling and interpreting complex scientific datasets. • Utilized MATLAB to perform exploratory data analysis on neurophysiological recordings, creating visualizations and reports to communicate findings to the research team. • Designed and deployed a MATLAB distributed computing server cluster, which significantly reduced data processing time, accelerating research outcomes. • Collaborated with cross-functional teams of scientists and researchers to understand data requirements and deliver tailored data solutions. • Implemented version control and documentation practices for data processing scripts and analysis workflows, ensuring reproducibility and traceability of research outputs.

Scottsdale, Az, Us

• Created and managed an efficient employee locker database system.• Administered and monitored complex access control systems.• Ensured secure key transactions and promptly resolved any anomalies.• Maintained optimal functionality of access control hardware.

Kansas City, Ks, Us

• Maintained inventory for cortical plasticity lab and provided desktop support for both Windows and Mac systems, ensuring smooth operations for researchers and staff.• Designed and developed a comprehensive purchasing and product expiration tracking database using MS Access.• Created a customized behavioral training program using VB.Net.

Jacksonville, Fl, Us

• Developed and managed multiple databases for accounting department groups, enhancing data accuracy and accessibility.• Provided prompt and effective technical support for hardware and software issues, ensuring minimal downtime.

Bachelor Of Science (B.S.), Neuroscience

Technical Diploma, Computer Programming