Charles William

Charles William Email and Phone Number

Data Solution Architect - Thought Leader - Independent Consultant - Consulting @ Prime Therapeutics
Saint Paul, MN, US
Charles William's Location
Greater Minneapolis-St. Paul Area, United States, United States
Charles William's Contact Details
About Charles William

Experience in: Healthcare, Pharmacy Benefit Manager(PBM), Banking, Finance, Product development for Insurance, Financial Services, Retail sector, Software Development and Information TechnologySpecialties: Experience in Data Architecture, Solutions Architecture, Data Management (Lakehouse, EDW, Big Data Platform, OLAP & HTAP/OLTP workloads, FHIR). Data Integration across multiple platforms(On-Prem & Cloud).

Charles William's Current Company Details
Prime Therapeutics

Prime Therapeutics

View
Data Solution Architect - Thought Leader - Independent Consultant - Consulting
Saint Paul, MN, US
Employees:
5988
Charles William Work Experience Details
  • Prime Therapeutics
    Data Solution Architect - Thought Leader - Independent Consultant - Consulting
    Prime Therapeutics
    Saint Paul, Mn, Us
  • Prime Therapeutics
    Data Solution Architect - Thought Leader - Independent Consultant - Thru Genesis10 Consulting
    Prime Therapeutics Jul 2022 - Present
    Eagan, Mn, Us
    Data Solution Architect for Innovation & Enterprise Clinical PortfolioComprehensive 'Population Health Management' data strategy and architecture that supports data-driven decision making, improves patient outcomes, and optimizes costs. Leveraging the 'Google Cloud Platform' technology stack for mixed workloads (OLAP & OLTP/HTAP).Introduced the concept of Event-Based Architecture and Event Store Data Model to support 'Population Health Management' Opportunities Identification Rules Engine, AI & ML Modeling processes.
  • Prime Therapeutics
    Big Data Architect - Independent Consultant - Thru Genesis10 Consulting
    Prime Therapeutics Jul 2021 - Nov 2022
    Eagan, Mn, Us
    Program Data Architect - BI and AI EngineeringLead the Data Architecture Initiative for 'Enterprise Data & Analytics' initiative, designing the architecture for a Data Lakehouse solution on Google Cloud Platform (GCP) utilizing BigQuery, Dataflow, etc..Designing the data ingestion, storage, processing, and consumption layers of the Data LakehouseEnsuring the architecture is scalable, secure, and aligned with the organization's data and analytics strategy.
  • Ucare
    Big Data Architect - Independent Consultant - Thru Q Consulting
    Ucare Mar 2020 - Jun 2021
    Minneapolis, Mn, Us
    Client UCare• Developed a data management strategy (hybrid cloud solution architecture) to support mixed workloads (OLTP & OLAP) for UCare.• Implemented a Lambda Architecture for clinical data management as an initial use case.• Designed a layered architecture including intake/ingest, data lake, curated layer, virtualization, security, data delivery, data quality, and metadata management.• Performed a proof-of-concept for an interface engine (Qvera QIE) to ingest HL7 C-CDA CCD data and support CMS interoperability mandates for data delivery.• Evaluated the use of neo4j and TigerGraph databases for the clinical data management curated layer.• Worked on data projects for core data domains such as pharmacy claims, member, benefit, and reference data.• Designed an end-to-end data management architecture for pharmacy claims, member, and benefit domains, including intake, ingest, data management layer to support mixed workloads (OLAP & OLTP), and data delivery patterns to support APIs, query services, and batch processing.• Developed a conceptual/graph data model for the product/insurance plan resource. • Designed a hybrid relational/JSON physical data model for the insurance plan resource.• Performed a proof-of-concept for a reference data hub and business-owned datasets using SQL Server Master Data Services.
  • Prime Therapeutics
    Principal/Application Architect
    Prime Therapeutics May 2014 - Mar 2020
    Eagan, Mn, Us
    Key Role: Application ArchitectBig Data Hadoop Platform• Designed the application architecture for Prime's Big Data Hadoop Platform• Implemented a metadata-driven approach for process/operations metadata collection, data quality & audit balance and control, and data security (RBAC & ABAC)• Developed a micro-batch/batch framework for a data hub using a Lambda architecture on the Cloudera platform.• Leveraged technologies such as IBM CDC Replication Engine for Kafka, NiFi, Cloudera HDFS, Spark Streaming, Spark Batch, Scala, Kudu, HBase, Hive, Impala, Airflow, and DenodoEnterprise Data Initiatives• Provided thought leadership for all enterprise-level data platform initiatives (EDH, EDW, ODS) to support operations and analytics.• Implemented a layered application architecture for the Teradata EDW (Prime Analytics) following ETL and ELT metadata-driven patterns with process/operations metadata collection, data quality & audit balance and control frameworks.• Designed and implemented role-based access control (RBAC) for Teradata and extending it to DB2.Architected a tokenization solution compliant with PCI security standards.Data Management Strategy• Collaborated with data architects to initiate a managed data repository (MDR) pattern.• Designed the application architecture for a data management strategy, including a standard intake process for vendor-purchased reference data (setting up for future account consolidation)• Implemented a business-managed rules fully automated execution framework and an interim population segmentation using this framework.Key Role: Principal Data IntegrationMedical Data Acquisition• Implemented a standard intake framework with a data quality framework, including controls, notifications, and involving data stewards for remediation.• Center of Excellence (COE) for Data Integration• Implemented change data capture (CDC) for data integration.
  • Prime Therapeutics
    Data Integration Lead
    Prime Therapeutics May 2011 - May 2014
    Eagan, Mn, Us
    Key Role: Solution Architecture for the following projects:EDW Pharmacy Benefit Plan• Integration & Distribution LayersConsumer Focused Pharmacy Claims ODS• An interim strategy for Pharmacy Claims Data management.Master Data Management• Single View of a Person (Patient 360) for Guided Health.Key Role: ETL Development LeadResponsibilities:• Pharmacy Benefit Plan EDW: Integrated and distributed data, delivered solution as per architectural direction and vision• Guided Health ODS Phase I: • Designed and delivered solutions for member, program, and population managementMember-Level Benefit: Delivered solution as per architectural direction and vision.
  • Wells Fargo
    Core Etl Team (Development Lead)
    Wells Fargo Jan 2007 - May 2011
    San Francisco, California, Us
    Application Systems Engineer; Wells Fargo Nov 2009 to May 2011Key Role: ETL Development Lead (DataStage & PL/SQL) The CORE Program (Common Opportunities, Results and Experience) is responsible for creating a better end-to-end architecture for real estate-secured lending (mortgage)Key Role: DSG ABCC Data Services Group (DSG/TOG) Audit & Compliance team Responsible to ensure that BCP’s for all Technology and business processes are technically viable.• Work with Oracle, Microsoft SQL Server, UDB and Sybase DBA’ & Audit team to effectively maintain all db recovery solutions. • Worked with all other Technology BCP administrators in DSG/TOG to provide guidance and support in an effort to bring all Business Unit, Technology Application and Technology Database BCP plans to the required standard.Key Role: Mainframe ETL Tech Lead for AIMS (Analysis Information Mortgage System) team, Responsible for analysis, design and development of system. • AIMS Support: Served as a Subject Matter Expert for AIMS legacy system Extract & Transform process of ETL• Produces high quality data solutions on time.
  • Client; Agribank, Fcb
    Sr. Systems Analyst; Cs Solutions Inc.
    Client; Agribank, Fcb Feb 1998 - Jan 2007
    St. Paul, Minnesota, Us
    Key Role: Mainframe ETL Developer;Sr. Software Engineer, Responsible for design and development of system on IBM z/OS platform.JavaScript, HTML, BroadVision 4.1, UNIX and DB2 Stored procedures integrating mainframe data across multiple platforms.Interface system for CSF (Metavante's Customized Statement Formatter) to generate monthly statements, bills and rate notice for its customers with a personalized touch.
  • Ciber, Inc.
    Sr. Software Engineer
    Ciber, Inc. Aug 1995 - Jan 1998
    Client: CIBER Denver (off-site).• Designed the conversion of the Year 2000 utility from character-based interface to a GUI based interface with a smart editor for making the required changes to the Y2k effected code using Visual C++. Client: CIBER Minneapolis (off-site).• Designed and Developed a Year 2000 utility with character-based interface using c for analyzing COBOL, MARK IV, & Easytrieve source code.
  • Dsrc Pvt. Ltd.,
    Software Developer (Training)
    Dsrc Pvt. Ltd., May 1994 - Jul 1995
  • Bajaj Garments Ltd.,
    Edp In-Charge
    Bajaj Garments Ltd., Jun 1993 - Mar 1994
  • Turbo Systems Pvt. Ltd.,
    Software Engineer
    Turbo Systems Pvt. Ltd., May 1992 - May 1993

Charles William Skills

Data Warehousing Etl Sdlc Db2 Databases Oracle Sql Unix Data Integration Software Development Datastage Pl/sql Mainframe Performance Tuning Data Analysis Cobol Business Process Data Modeling Sybase Requirements Gathering Software Development Life Cycle Banking Data Quality Data Migration Solution Architecture Informatica Database Design Teradata Soa Javascript Oracle Sql Application Development Ibm Db2 Insurance

Frequently Asked Questions about Charles William

What company does Charles William work for?

Charles William works for Prime Therapeutics

What is Charles William's role at the current company?

Charles William's current role is Data Solution Architect - Thought Leader - Independent Consultant - Consulting.

What is Charles William's email address?

Charles William's email address is cw****@****ail.com

What is Charles William's direct phone number?

Charles William's direct phone number is +161277*****

What skills is Charles William known for?

Charles William has skills like Data Warehousing, Etl, Sdlc, Db2, Databases, Oracle, Sql, Unix, Data Integration, Software Development, Datastage, Pl/sql.

Who are Charles William's colleagues?

Charles William's colleagues are Donna Kosla, Sumaya Ali, Kevin Gordon, Alyssa Nissen, Lisa Mickelson, Andrew Thill, Jenni Fulton.

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.