Jeremy Panasuk · 715-970-0204 · jpanasuk@gmail.com · jpanasuk-netizen.github.io/for-paylocity
04 — Sr. Software Developer, Talend · MOBE · Minneapolis
Live production data integration — mappings, pipelines, on-call
Jul 2023 – Aug 2024
Talend 8 mappings from simple through complex on a live production platform. GitLab CI/CD migrations. Amazon Redshift + SQL Server tuning. Sustained 99.99% stability. On-call incident command and root-cause writeups the next morning. The support queue with a name on it.
05 — Informatica Specialist · Tata Consultancy Services
PepsiCo · Ameriprise · Ace Hardware — follow-the-sun, virtual teams
Mar 2020 – Dec 2021
PepsiCo — Grid/HA + Data Integration Hub across NA/LATAM. Led v9→v10 with zero data loss. Teradata → Big Data (~40% analytics lift). Follow-the-sun with offshore. Tuning standards written into production go-live timelines. Ace Hardware — PowerCenter → Big Data. Business + QA deploy path. Ameriprise — Enterprise Data Governance: IDQ, EDC, Axon. 200+ critical data elements. 24×7. Control process, not a slogan.
06 — Consulting Manager / SEAL · Informatica · Jun 2008 – Oct 2019
Started as Analyst in 2008. Analyst → Sr. Analyst twice in four years. Sr. Analyst → Program Manager in ten. SEAL team. Teams of 7–14. $4M+ services in two years. v7–v10 upgrade specialist. Consultant of the Year runner-up (2016). Parachute closer: 20 troubled accounts entered, 19 recovered. Personnel management with a technical badge. Ladder: Sr. Analyst → Principal Consultant → Technical Delivery Manager → Solution Delivery Manager → Program Manager / Consulting Manager.
SEAL team
v7–v10 upgrades
19 / 20 recovered
World-first Grid/HA + DR
Teams 7–14
SQL · XML · files
Named skill-up
Cargill CFO Award · 2005Highest financial-project award. Six awarded that year. Horizon Milling time-dimension visibility.
Quarterly Excellence · 2006Demantra demand planning design and implementation. Separate from the oils plant ERP.
Consultant of the Year runner-up · 2016Micron: grew a 2,080-hour fab program to 7,000 hours. $3M extensions. Zero downtime.
8h→1h
Dawn Foods — PowerExchange CDC on AS/400 remote journals. Type 2 DW. Featured because it got used.
−50%
West Bend Mutual — live SOAP/XML quote path cut in half. Agent turnaround. Partner integration.
+200%
Mercedes-Benz — longest workflows rescued. TCS trained on the path. Playbook stayed with the team.
7,000h
Micron — fab EDW. PowerExchange, Grid/HA, Fast Clone. $3M extensions. Zero downtime.
$800k
Toyota — Engine Management go-live. All consultants 5/5.
20+ nodes
MF Global — world-first Grid/HA + DR on RHEL GFS. India, UK, New York, Chicago. Owned global DR.
$2.3M+
BNY Mellon — Grid/HA with senior VPs, support, and CEO Sohaib Abbasi in the room.
$10M+
JPMorgan Chase — enterprise DW / CoE roadmaps. ELA + professional services.
~$2M
Kohl’s — Informatica v9 Grid/HA capacity planning and upgrade, including multiple high-availability and Grid components. Target Grid/HA on commodity hardware (Cisco or IBM); cutover off AIX. Current volumes plus a 3-year growth curve; sized to that. Briefed through Senior VPs. Closed ~$2 million in Informatica software. DQ / MDM POCs when Informatica VM labs were not enough for their data.
2 wks
Volkswagen Group of America — complete Grid/HA in two weeks: bonded network / dual NICs, Oracle RAC on InfiniBand, three 8-core PowerCenter servers. Live demo a day early. Four customer consultants shadowed. Parallel DQ on the other side of VW was burning down (pressure, not a DQ miss).
$375k
Unnamed customer — two-week PowerCenter + Data Quality full build on their metal (not the Informatica VM lab), plus complete use-case analysis. Closed $375k the night before quarter end.
$600k
Smith & Nephew — FDA-validated platform. Control process. Licensing contention resolved.
3,000h
Navy Federal — Informatica + BI V1 from architecture through go-live training.
v9
Harvard — Version 9. Off-load Solaris 8.1.1. Resource plan through hypercare.
Phase 2
Farmers — Guidewire XML. Skill-up named. Linux SOAP/REST.
P1
Northwestern Mutual — domain best practice. QA twin of production. Hypercare default.
v9→v10
Waddell & Reed — measured I/O. Upgrade types + tests. Written operating path.
2 days
Milwaukee insurer — three-month outage closed in two days. One buried IBM DB2 driver setting.
Also: Merrill / Time Inc. SFDC lift-shift. Ivy Funds Grid/HA. Federal Reserve Philadelphia Windows→Unix. Giesecke & Devrient — REST/SOAP, VMs, GitHub, Docker. Micron Fast Clone + Financial Force. Lectures on v7–v10 upgrades. File transfers, EDI/XML-class payloads, SQL across Oracle / SQL Server / DB2 / Teradata / Redshift.
Sr. Integration Engineer · Prime Therapeutics
Jan 2007 – Jun 2008
Technical lead for Medicare and Medication Therapy Management data marts — HR/benefits-adjacent data. EDW test lead. Analyst → Sr. Analyst on a 4/5 annual review. Delivered above grade-level.
Business Analyst, Oils Plants · Integration Associate · Cargill
Dec 2004 – Jan 2007
Oils plants: BA overseeing plant ERP — live mill operations. Demantra: Quarterly Award for Excellence, Oct 2006. Horizon Milling: CFO Award Sept 2005 (six / year). 24/7 support across 20+ warehouses / ODS.
“Jeremy has been a pleasure and an asset to work with. His knowledge not only of the Informatica suite but also at the operating system level has been truly invaluable.”Dawn Foods · client
“He’s a rock star out at Dawn. The customer loves him and the sales team has been leaning on him hard.”Informatica IPS · sales
“It is the belief of the infrastructure staff that you have sent one of the best that Informatica has to offer in Jeremy.”MF Global · infrastructure
“I trusted that Jeremy would deliver, with quality… exceeded the expectations at someone of his grade level.”Prime Therapeutics
Origin · Secret Key / Fireworks Forever · Inventory Manager · St. Croix Falls, WI · 1996–2005
$800K+ seasonal inventory. Turnover under three months. Four full-time sales. Profit up six years. Class B shooter. No schema, no second take. People pay you. Loyalty is the metric. Paylocity’s line — people matter most — was forged here.
07 — Stack · this posting
Manage · teams of 7–14 · high-volume programs · SOW / roadmap / hypercare · 1:1s / skill-up · virtual / follow-the-sun · incident command
Code / data · SQL · Python · SOAP/XML · REST · file transfers · Informatica PowerCenter · Grid/HA · PowerExchange CDC · Talend 8 · IDQ · EDC · Axon · Oracle · SQL Server · DB2 · Teradata · Hadoop · Docker · GitLab CI/CD
AI / automation · local LLM lab · TabbyAPI · Ollama · CUDA · MCP · RAG · OpenClaw · SQLite telemetry
This posting · U.S. remote · BBA MIS, UW–Eau Claire, 2004 · Informatica Certified Specialist: Administrator, Big Data Administrator, PowerCenter Developer I & II
Honest · No Lean Six Sigma belt. Repeatable operating paths, metrics, and corrective action instead. Payroll/HR product: not a decade inside HCM — Prime MTM/Medicare data plus twenty years of customer-facing implement-and-stay.
Operating line · Customer satisfaction is worthless. Customer loyalty is priceless.
