Raymond Miecznik

Details

Please indicate if you are: a person with a disability

Skills

SQL, Advanced Microsoft Excel, Tableau, Data Analysis, Large Data Set Analysis, ETL (Extract Transform Load), Business Intelligence, Data Visualization, Dashboard Development, Data Validation, Data Reconciliation, Financial Reporting, Management Reporting, Revenue Reporting, Forecasting, Variance Analysis, Metric and KPI Definition, Data Governance, Python, R, Oracle, Amazon Redshift, Teradata, Google BigQuery, Excel VBA, Metabase, A/B Testing, Statistical Analysis, Google Analytics, Salesforce Marketing Cloud, General Ledger Reporting, Billing, Purchase Order Processing, Microsoft Word, Microsoft Outlook, Microsoft Teams, Git, Agile/Scrum, Jira, Cross-Functional Collaboration, AI-Assisted Analytics (Claude Code), Process Automation, Documentation

About

Most recently, I spent nearly two decades at Nordstrom as a data analyst, where I grew from a junior analyst into a Lead and then Analyst 2. My core strength there was making data trustworthy: writing advanced SQL across Oracle, Redshift, Teradata, and BigQuery, building the validation and reconciliation routines that caught problems before they reached anyone, and turning the results into Tableau dashboards that Director and VP-level leadership relied on to make decisions. I built an A/B testing framework from scratch and ran it at large scale, led four database platform migrations end to end with zero downtime, and created a self-service dashboard, approved all the way up to VP level, that replaced a slow manual process.

Earlier in that run I spent over a decade running the catalog business behind multi-million-circulation programs, and automated a manual prospecting process that used to take weeks down to about ten minutes. I was recognized with several internal awards along the way.

Before Nordstrom, I worked at Microsoft from 2005 to 2007, where I first learned SQL hands-on building operational tracking tools in Access and SQL, supported general ledger reporting and billing for the mailing division, and automated manual reporting using Excel and VBA.

Outside of my employment, I design, build, and sell my own commercial software, FFmpeg Commander, a video toolbox for Mac, Windows, and Linux that I wrote solo in Python. I also built and run its full analytics pipeline, ingesting and validating site traffic every fifteen minutes and feeding live dashboards, which keeps me hands-on with the end-to-end data work I enjoy most.