Jerry Hosack

Jerry Hosack Email and Phone Number

Sr Data Governance Specialist and Data Modeler @ Integra Connect
Emporia, KS, US
Jerry Hosack's Location
Emporia, Kansas, United States, United States
Jerry Hosack's Contact Details
About Jerry Hosack

- Experienced Data Modeler, Solution Architect, and Data Architect with extensive experience in gap analysis, specializing in transforming complex business requirements into effective data solutions. - Master Data Management (MDM): Spearheaded MDM initiatives to ensure data consistency, accuracy, and governance across enterprise systems, enhancing data quality and integration. - AI-Augmented Development: Leveraging AI tools to enhance coding efficiency and adapt to new technologies swiftly. - Proficient leading cross-functional teams, database assessments, and implementing scalable architectures. - Expertise: Deep knowledge in normalization, OLTP, OLAP, ROLAP, MOLAP, BI analytics, Big Data, NoSQL, and AI-driven data solutions.TECHNICAL SKILLS:- Database Systems and Data Platforms: Snowflake, Oracle, SQL Server, MongoDB, Azure Cloud. - Data Modeling: Enterprise Data Modeling, 3NF, Dimensional Data Modeling, Star schema. - Programming Languages: Python, SQL, PL/SQL, with AI tools for code generation and optimization. - Tools: Tableau, Erwin, ER/Studio, Power Designer, OBIEE, Power BI, AI for coding assistance.

Jerry Hosack's Current Company Details
Integra Connect

Integra Connect

View
Sr Data Governance Specialist and Data Modeler
Emporia, KS, US
Website:
integraconnect.com
Employees:
755
Jerry Hosack Work Experience Details
  • Integra Connect
    Sr Data Governance Specialist And Data Modeler
    Integra Connect
    Emporia, Ks, Us
    View
  • Team Collaboration Software Llc
    Development Manager / Owner Of Team Collaboration Software Llc
    Team Collaboration Software Llc Jul 2008 - Present
    Macomb, Mi, Us
    (Active Consulting Since 2019) Enterprise Data Architect and Project Lead for RL Carriers, Wilmington, OH:Redesigned data architecture for transit time calculation and compliance analytics, enhancing both OLTP and OLAP systems. Led cross-departmental teams to implement solutions, resulting in optimized data retrieval and transit time by over 300%.Enterprise BI/EDW Architect/Project Manager for Mercedes-Benz Financial Services:Developed and led the EDW and BI framework for the Americas, aligning with global strategies. Facilitated data modeling workshops, ensuring consistency and usability across reporting systems.Data Architect/Project Manager for JMA Services:Spearheaded the development of a mobile property inspection application, integrating innovative data capture and validation techniques. This project led to a patent for managing property inspections.Business Intelligence Architect/Technical Lead for Takeda Pharmaceutical:Designed and implemented a comprehensive BI system for brand campaign analytics, personally developing dashboards that supported critical business metrics. Program Manager/Solutions Architect for LeCom and Golden Dental Plans:Led the development of vehicle fleet management and dental claims adjudication systems, respectively. These projects involved complex data modeling and system architecture, significantly improving operational efficiency.Consulting Focus Since 2019: Strategic Consulting: Provide specialized consulting services in data modeling, system architecture, and project management, focusing on enhancing scalability, integration, and data governance for clients transitioning to or optimizing cloud-based solutions. Impact of Economic Downturn: Adaptation and Resilience: Post the loss of key SaaS clients due to economic factors after pandemic, refocused business strategies towards AI assisted coding and integration capabilities.
    View
  • Usda Forest Service
    Data Architect And Data Modeler
    Usda Forest Service Mar 2024 - Aug 2024
    Washington, Dc, Us
    · Conducted database assessments, migration planning, and optimization to reduce redundancy and enhance data integrity.· Utilized AI coding tools to accelerate the development of data models and ETL processes, ensuring rapid adaptation to new data technologies.· Developed comprehensive data dictionaries and business glossaries for current and future state models.· Designed logical and physical data models, documenting source-to-target mappings and transformation logic for ETL processes.
    View
  • Esl Federal Credit Union
    Technical Lead And Project Manager
    Esl Federal Credit Union Oct 2023 - Mar 2024
    Rochester, Ny, Us
    · Led data profiling and analysis for Boomi MDH implementation at a major credit union, coordinating between multiple teams.· Created an enterprise data model to streamline data cleansing and integration processes.
    View
  • Zelis Healthcare Corp
    Technical Lead And Data Architect
    Zelis Healthcare Corp Mar 2022 - Jul 2023
    · EDI Modernization, Data Governance, Claims Reporting, and Role-Based Security· Design of Snowflake structures to support key reporting· Created Normalized and DeNormalized canonical data models supporting CMS Standards for 834 Member Enrollment, 835 Remittance, and 837 Claims. Led discussions regarding ETL design, documented Source-to-Target Data Mappings and transformation logic· Environment: Sql Server, Snowflake, JSON, Postgres, Collibra, Oracle, Erwin, Python, AWS, Azure, Tableau, Power BI
    View
  • Cigna Healthcare
    Data Architect And Data Modeler
    Cigna Healthcare Apr 2019 - Mar 2022
    Bloomfield, Ct, Us
    · RDBMS migration analysis and conversion designs using MongoDB collections and fields· Create DDL & DML and maintain current and future state Data Flows and Architecture diagrams· Environment includes: Oracle, Teradata, MongoDB, JSON, Erwin, Git, Liquibase, DDL, JSON, AWS, Azure, and Udeploy
    View
  • Credit Acceptance
    Lead Data Architect/Modeler
    Credit Acceptance Jun 2004 - Jul 2008
    Southfield, Mi, Us
    Led database design and developed migration strategy to consolidate multi system redundancy, improve performance and increase accuracy. Worked with business owners and technical team to insure data and object models support complex credit risk scoring algorithms. Managed the effort to identify and reverse engineer legacy data structures into central metadata repository. Defined process for documenting legacy database and define use-cases and software specifications supporting new SOA and Object Oriented J2EE development environment. Managed design and implementation of data mart of Oracle HR, Project, Help Desk and employee information to drive time and forecast reporting. Work with users, data source owners, and development teams for report requirements and signoffs. Environment: Sun E450 test servers, Originations and Servicing running Oracle 10G RAC Cluster on 4 Sunfire 4800 production servers, J2EE, Liquibase, Subversion, Oracle developer suite, SharePoint, Visual Basic, Excel, MS Access, Apache Web Servers 2 Dell Enterprise 1850s with Linux V9; Exchange Mail server Dell 2850s.
    View
  • Wayne County Register Of Deeds
    Project Manager/Solution Architect
    Wayne County Register Of Deeds Jul 2002 - Jun 2004
    Led strategy, analysis, design and managed implementation of a Tract Index, Records Management and Imaging system. Supports research of survey drawings and relevant information for contract administrators to track corners through the state mandated monument process. The solution tightly integrates maps providing point-and-click Geo index to scanned historical documents, survey drawings, and Land Corner Recordation Certificates (LCRCs). The GIS interface dynamically changes corner symbols based on process dates updated in the database. Environment: Oracle 8i, JDeveloper Suite, Apache, Oracle Reports, Forms Server, .NET, C+, ASP. (Wayne County Register of Deeds, Detroit, MI.)
  • Technical Solutions Inc.
    Senior Consultant/Project Manager
    Technical Solutions Inc. Jun 1999 - Jan 2002
    Data Architect/Project Manager/Sales Support· Prepare Scope of Work, Job Cost Estimates, Integration and Fit analysis.· Managed development teams, perform data, process and functional modeling. · Managed assignments, time reporting, and schedules.Environment: Sun, Solaris, Oracle 8i, Netscape, Oracle J Developer.
  • Passage Corporation
    Product Development Manager
    Passage Corporation Jun 1994 - Jun 1999
    Product Development Manager Product Development Manager responsible for product design, job cost estimates, and integration fit analysis.· Work with customer management and users to obtain sign offs. · Manage development assignments, time reporting, and schedules Environment: Dell dual Pentium server, NT, Oracle 8i, Oracle Forms and Reports.
  • Oracle Corporation
    Sales Consultant
    Oracle Corporation Oct 1990 - Jun 1994
    Austin, Texas, Us
    SALES CONSULTANT· Conducted technology seminars, case workshops, and Rapid Application Development (RAD) · Product demonstrations, installations, and build prototypes· Responded to Request for Proposals (RFP) and perform integration fit analysis.Environment: HP, Sun, Sequent, DEC, IBM, OS2, and Windows servers, Oracle Designer, Forms, Reports, Graphics, PL*SQL, CASE and Pre Compilers.
    View

Jerry Hosack Skills

Data Warehousing Etl Business Intelligence Oracle Sdlc Data Modeling Integration Informatica Enterprise Architecture Pl/sql Database Design Sql Unix Requirements Gathering Agile Methodologies Business Analysis Requirements Analysis Db2 Unix Shell Scripting Software Development Life Cycle Databases Solution Architecture Service Oriented Architecture Enterprise Software Software Development Data Migration Software Project Management Project Management

Jerry Hosack Education Details

  • Emporia State University
    Emporia State University
    Mathematics
  • Emporia State University
    Emporia State University
    Earth Science

Frequently Asked Questions about Jerry Hosack

What company does Jerry Hosack work for?

Jerry Hosack works for Integra Connect

What is Jerry Hosack's role at the current company?

Jerry Hosack's current role is Sr Data Governance Specialist and Data Modeler.

What is Jerry Hosack's email address?

Jerry Hosack's email address is jh****@****ech.net

What is Jerry Hosack's direct phone number?

Jerry Hosack's direct phone number is +124842*****

What schools did Jerry Hosack attend?

Jerry Hosack attended Emporia State University, Emporia State University.

What are some of Jerry Hosack's interests?

Jerry Hosack has interest in Kids, Collecting Antiques, Exercise, Investing, Traveling, Outdoors, Electronics, Home Improvement, Crafts, Music.

What skills is Jerry Hosack known for?

Jerry Hosack has skills like Data Warehousing, Etl, Business Intelligence, Oracle, Sdlc, Data Modeling, Integration, Informatica, Enterprise Architecture, Pl/sql, Database Design, Sql.

Who are Jerry Hosack's colleagues?

Jerry Hosack's colleagues are Selvakumar Selvaraj, Stephanie R., Jen Wolf, Robin Tardif, David Ott, Mark Kintner, Pavani M S.

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.