Miguel Rodriguez
Senior Analytics and Automation Professional
Grand Prairie, TX · 972-639-7421 · marodriguez_2010@ymail.com
Professional Summary
Analytics and automation professional with 13+ years across workforce and benefits operations, business reporting, data products, and stakeholder delivery. Builds practical tools from complex requirements and evidence. Current freelance and independent work spans business applications, local software, and AI evaluation, using AI-assisted implementation with rigorous review, reproducible tests, and clear ownership of outcomes.
Core Skills
Analytics and systems: Power BI, DAX, Power Query, Python, Alteryx, Excel, workflow automation, API integration, data quality
Product and execution: Requirements discovery, user experience, stakeholder consulting, AI orchestration, evaluation, Git, documentation
Professional Experience
Independent Analytics and AI Project Work
Freelance work and applied R&D | Current
- Direct freelance and independent projects from requirements and design through AI-assisted implementation, testing, and iteration, maintaining active practice across analytics and software delivery.
- Break complex work into bounded tasks, preserve reusable context, and coordinate handoffs across tools to reduce avoidable rework and keep progress reviewable.
- Evaluate generated code and analysis against requirements, source evidence, and test outcomes; require corrections to unsupported claims or incomplete behavior before accepting work.
Lockton | Senior Data Analyst
Plano, TX | May 2025 - April 2026
- Scaled Employee Sentiment Analysis from divisional work into a national, multi-division analytics capability supporting executive client-acquisition decisions.
- Built Power BI dashboards across thousands of proprietary data points, using DAX, Power Query, industry benchmarking, privacy-aware executive views, and longitudinal analysis.
- Built a configurable Python Research Toolkit for profile searches and HTML collection and parsing; used JSON-driven schemas and packaged EXE tools for nontechnical analysts.
- Designed a workflow connecting Smartsheet intake, automated research, Power BI dashboards, templated PowerPoint reporting, and AI-assisted insights with analyst review.
Lockton | Data Research Analyst
Dallas, TX | August 2023 - May 2025
- Established data-sufficiency thresholds and analytical tiers so limited review volume did not become unsupported conclusions.
- Partnered with consultants and senior stakeholders to turn ambiguous questions into benchmark analyses and executive presentations supporting acquisition and retention conversations.
Lockton | HRO Data Analyst
Dallas, TX | May 2022 - August 2023
- Automated billing reconciliation, invoice creation, carrier census templates, COBRA-related notices, and reporting with Excel, Power Query, M, macros, and Alteryx.
- Delivered Power Query training for analysts and taught client-management teams recurring billing, HRIS, carrier-management, and benefits processes.
Lockton | Benefits Analyst and Benefits Specialist
Dallas-Fort Worth, TX | November 2018 - May 2022
- Supported benefits administration, enrollment, client onboarding, reporting, and vendor coordination. Concurrent Lockton contractor assignment at MoneyGram (March 2020 - May 2022) covered reimbursement and benefit-invoice reporting.
Selected Projects
U1 Mechanical
Ongoing owner-review application
Directed a connected customer website, owner dashboard, and field interface using Next.js, TypeScript, Prisma, and PostgreSQL. Combined UX research, shared workflows, permissions, and browser verification in a hosted owner-review rollout.
FAULTLINE
Published synthetic-data evaluation lab
Directed a Python/PostgreSQL lab comparing conventional recovery with a bounded local model. Independent record checks, captured failures, and reproducible evidence show how AI results are evaluated before they are trusted.
Memory Relief
Local desktop project
Directed a Python and React/GTK utility for memory diagnostics and storage review. Kept cleanup scoped and recoverable, with explicit permissions and protection for active work.
Earlier Experience
Hilton Worldwide | National Sales Data Analyst | February 2015 - May 2017. Created revenue reports and dashboards, researched business prospects, and contributed to an internal lead-automation concept.
CSC ServiceWorks | Workforce Analyst and A/R Billing | March - November 2014. Built an Excel/PeopleSoft billing workflow that reduced a three-day process to approximately five hours; provided workforce data and forecasts.
Additional roles: United Way of Metropolitan Dallas, Auditor (June 2017 - March 2018); Etan Industries, Collections/Data Specialist/Workforce Analyst (September 2012 - November 2013).
Education and Languages
Dallas College | Associate of Science, Data Science | 2011 - 2015
English and Spanish | Native or bilingual proficiency