Patrick Mcelhose Email & Phone Number

Columbus, Ohio, United States

Columbus, Ohio, United States

Columbus, Ohio, United States

• Interviewed provider and patient data stakeholders to determine current state of Data Governance and MDM
• Documented pain points based on current data processes and business operations
• Developed a Data Governance and MDM roadmap to support the implementation of a Provider Finder website
• Identified key use cases to drive business value for the MDM implementation

• Developed Test Plan, Cases, & Cycles for the MDM system testing phase
• Tested data quality rules, batch loads, and real-time interfaces for MDM
• Reported progress, defects, and blockers to client project manager to maintain alignment
• Analyzed defects to identify the root of the problem and offer solutions

• Interviewed customer data stakeholders to determine current state of Data Governance and MDM
• Documented pain points based on current data processes and business operations
• Developed a Data Governance and MDM roadmap to support ongoing business initiatives
• Provided a conceptual architecture for MDM and providing/consuming systems
• Identified business requirements for the future MDM implementation

• Interviewed customer data stakeholders to determine current state of Data Governance and MDM
• Documented pain points based on current data processes and business operations
• Developed a Data Governance and MDM roadmap to achieve an ideal future state
• Formalized the definition of a Customer across the enterprise

• Interviewed customer data stakeholders to determine current state of MDM
• Documented pain points based on current data processes and business operations
• Developed a Customer, Partner, and Account MDM roadmap to achieve an ideal future state
• Formed a business glossary with critical data elements for Customer, Location, and Account

• Interviewed customer data stakeholders to determine current state of Data Governance and MDM
• Documented pain points based on current data processes and business operations
• Developed a Data Governance and MDM roadmap to achieve an ideal future state
• Presented findings and roadmap to C-level executives and business stakeholders

• Profiled customer data based on industry best practice data quality standards
• Analyzed MDM customer match and merge rules to determine under matching
• Developed integrations between ICHS MDM and Amazon S3 bucket
• Presented analysis in a refreshable dashboard for business stakeholders

• Trusted adviser to both IT and business users for integration related items
• Assist client resources with design discussions around ERP and CRM systems
• Lead status, requirements, and ad-hoc meetings with client and internal resources
• Develop “near real-time” integration process orchestration architecture

• Developed integrations between MDM, ERP, and CRM systems
• Led ERP and CRM integration requirements gathering
• Developed reusable AtomSphere process architecture
• Led test case development and execution

• Mapped data transformations from several different legacy systems to the target MDM system
• Profiled legacy data to determine needed extract criteria and transformations
• Developed workflows and applications to write data to the target MDM system
• Unit tested source to target mappings to ensure accuracy of promotion activities
• Provided technical guidance to client resources

*Assisted with ETL testing at client site*Documented ETL testing and PowerCenter guidelines*Developed analytical queries to display new database architecture functionality*Presented analytical queries to internal project team members at client site

Charlotte, North Carolina Area

*Analyzed approximately eight and a half years of sustained electrical outage data*Developed project report of the sustained outage data as a reference for the Grid Analytics team*Presented main findings of the report to Grid Analytics team, managers, and other project stakeholders

Dayton, Ohio Area

*Assisted with company rebrand*Contacted sales reps about potential leads for customers*Tradeshow logistics*Handled promotional items inventory

Bachelor'S Degree, Mis & Finance

Activities and Societies: Angler's Club, Campus Crusade Freshman Committee, the National Society of Collegiate Scholars, Association of.

High School

Activities and Societies: Track & Field (3 years), Cross Country (3 years), Varsity T Club (3 years), and Spring Musical (1 year)