Troy Patrick Email & Phone Number

Greater Minneapolis-St. Paul Area

Minneapolis, Mn, United States

Greater Minneapolis-St. Paul Area

Business AnalystResponsible for ensuring all inbound/outbound data file schedules were met on time.Managed data file mapping projects in a JIRA agile process through to completion with development and QA.Elicited business requirements from internal and external stakeholders to design and build employee wellness data integration programs, including eligibility, incentive, biometric and other custom wellness data files types.Managed workload to fully support daily data integration relationships for 10 key accounts.Worked with leadership to identify process and product improvements to SaaS platform

Maplewood, Mn

Coordinated directly with other analysts to identify required trading partner’s to onboard and then configured Sterling Integrator with these EDI relationships for an SAP migration.Built SQL scripts and Excel spreadsheets to analyze and build trading partner configuration automation scripts.

Eden Prairie, Mn

Business Analyst IIIDesign, develop and manage dozens of transportation management software implementation projects for many of the organizations top 25 outsourced customers.Facilitates requirements review and validation with stakeholders and project team for large projects impacting a single business area. Communicate requirements and collaborate with developers and stakeholders to refine proposed solutions.Coordinate directly with application development business analysts and developers to design new system functionality to close all application gaps.Business Analyst IICoordinated with branch users to elicit and define their business requirementsAnalyzed trading partner guidelines to build a solution for branch users to meet their requirements.Always reached, and occasionally exceeded, the top-tier of projects completed per quarter metric.Responsible for refining solutions to meet evolving needs of the trading partner and business stake holders.Programmer AnalystResponsible for analyzing customer EDI guidelines and building EDI maps to fit the needs of transportation loading, ordering, status messages and invoicing.Coordinated with infrastructure team to install maps, workflows and troubleshoot production issues.

Minneapolis, Mn

• Managed EDI relationships using a variety of hosted EDI Integration services to over 1000 retailers. • Implemented new integrated solutions to various backend systems. • Analyze clients EDI specifications to define mapping requirements for new relationships. • Worked to resolve escalated issues ranging from EDI setup to EDI syntax received by trading partners. • Configured, managed and implemented over 150 AS2 and 50 FTP connections. • Managed all production data systems in an on-call rotation. • Developed a training program for new employees.• Led a tier two support group, resolving escalated issues generated by customers using a web-based EDI solution. Analyzed database inconsistencies using PL/SQL to improve data integrity. • Scripted solutions to common problems and reduced workflow times by 75%. Coordinated efforts to reduce customer issues in times of system change.• Received incoming calls from customers using a web-based EDI solution.• Responsible for resolving 70% of calls on the first contact. If resolution wasn’t met, all pertinent data was collected for escalation to tier two support.