Enterprise Reconciliation & Root-Cause Analytics
Trusted Databricks-based logic that explains processing failures, supports USPS assessment review, and provides Power BI visibility into root causes and financial exposure.
Read the case study →I combine advanced SQL, business intelligence, data modeling, automation, and operational expertise to investigate difficult problems, build reliable analytical solutions, and turn findings into action — while training and mentoring analysts along the way.
Four case studies that best represent my current mix of analytical ownership, technical depth, stakeholder trust, and measurable business impact.
Trusted Databricks-based logic that explains processing failures, supports USPS assessment review, and provides Power BI visibility into root causes and financial exposure.
Read the case study →An end-to-end solution spanning business-rule design, SSIS, SQL Server, data modeling, Power BI development, stakeholder validation, rollout, and user support.
Read the case study →Governed fraud and financial-risk analytics developed in Databricks, refined through management and executive review, and designed for Power BI.
Read the case study →Turning raw application logs and payload text into standardized root-cause signals inside the broader enterprise reconciliation framework.
Read the case study →My strongest work happens where business processes, data quality, analytics, and technical implementation meet.
Advanced SQL, KPI development, exploratory analysis, root cause analysis, segmentation, financial impact analysis.
Power BI, Tableau, dashboards, executive reporting, data visualization, reusable reporting logic.
SQL Server, SSIS, SQL Server Agent, ETL, physical & dimensional data modeling, Databricks, Synapse, data warehousing, data lakes.
Data validation, quality checks, lineage, data dictionaries, process mapping, source-to-target validation.
Reporting automation, Microsoft Copilot, Databricks Genie Code, AI-assisted research and SQL optimization.
Product, Finance, IT, Customer Service, Operations, consultants, USPS, requirements and stakeholder communication.
Training and mentoring analysts on SQL Server, SSIS, and T-SQL; coaching frontline teams and onboarding new hires; building team capacity and technical self-sufficiency.
Training and developing others has been part of every role since 2013 — from coaching frontline teams and training cross-site supervisors early in career, to mentoring analysts on SQL Server, SSIS, and T-SQL in more recent roles, independently documented in performance reviews by five different managers from 2015 to today.
Formal DHL recognition, leadership comments, and selected professional credentials earned throughout my career.
Selected feedback from formal DHL performance and leadership evaluations spanning 2015–2025.
“Because of Cody's hands on experience with our internal processing systems and databases that support these activities he is able to identify and highlight ‘pinch points.’ He can generate data that supports DHLeC's pushback on postage payment with the USPS that saved $9.1 million dollars in 2025.”
“Continuing to mentor [new team members] showed strong leadership skills. Getting the team involved in different tasks and allocating responsibilities showed your leadership skills … I regularly tell team members to reach out to you for assistance as I know you are a great teacher.”
“Cody has shown the upmost dedication and willingness to craft the solutions the business needs to drive Quality, Postage Visibility, and our P & L. He is often thrown a challenge with little to no clear requirements. He steps up to the plate and engages the necessary subject matter experts to figure out how to craft information for management to make educated decisions. A clear example of this is the ~ $503K in Postage related savings his solutions helped the company to realize in 2018.”
“Cody has always been the go-to resource on our team when it comes to making our internal customers more successful in fulfilling many requests as it pertains to Quality, Ad-hoc Data Pulls, and Postage analysis. Cody has made a name for himself in the organization by bringing his operational knowledge of what goes on in the DCs and tying that with the data flow of information and that unique skill set has allowed him to becomes successful in creating many solutions for the department. Our teams success has been directly correlated in Cody's ability to satisfy business needs through his skills.”
“Cody brings a work ethic that motivates everyone on the team, self included. His eagerness to jump into projects and help all business partners has greater contributed to the growth in scope the department has experienced over the past year. DHL is very fortunate to have someone like Cody on the team.”
“The success of our organization is a direct result of your efforts and dedication. Your commitment to quality in both personal and professional integrity is the differentiating factor that sets us apart from our competition.”
Certificate of Achievement for meeting the required standards for completion of the Dale Carnegie Course.
Deutsche Post DHL Group recognition for successfully contributing to First Choice, DHL's structured continuous-improvement program.
DHL eCommerce internal certification covering the company's operating principles, quality standards, customer promise, and the role employees play in delivering Excellence. Simply delivered.
These labs document hands-on learning separately from professional experience. The roadmap is intentionally focused on Python, practical statistics, Snowflake, dbt, Git/GitHub, and one integrated capstone using synthetic or public data. Planned work is labeled accordingly and will be updated only as each lab is actually built.
An end-to-end analytics platform using Python for ingestion and validation, Snowflake for cloud warehousing, dbt for tested transformations and dimensional marts, Power BI for business reporting, and practical statistical analysis for decision support.
View roadmap →An analyst-focused study using synthetic operational data to evaluate hypotheses, confidence intervals, A/B-style comparisons, regression fundamentals, and anomalies, then translate the results into practical business recommendations.
A before-and-after performance lab using inefficient queries to demonstrate execution-plan analysis, indexing, query rewrites, and measurable improvements in runtime and logical reads.
A public dashboard built entirely from synthetic data to demonstrate KPI design, drill-down analysis, dimensional modeling, business storytelling, and dashboard usability.
I am open to senior analytics opportunities and flexible contract work involving SQL, BI, reporting automation, data quality, operational analytics, and business problem solving.