Charles William Email and Phone Number
Charles William work email
- Valid
- Valid
- Valid
- Valid
Charles William personal email
- Valid
Charles William phone numbers
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).
Prime Therapeutics
View- Website:
- primetherapeutics.com
- Employees:
- 5988
-
Data Solution Architect - Thought Leader - Independent Consultant - ConsultingPrime TherapeuticsSaint Paul, Mn, Us -
Data Solution Architect - Thought Leader - Independent Consultant - Thru Genesis10 ConsultingPrime Therapeutics Jul 2022 - PresentEagan, Mn, UsData 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. -
Big Data Architect - Independent Consultant - Thru Genesis10 ConsultingPrime Therapeutics Jul 2021 - Nov 2022Eagan, Mn, UsProgram 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. -
Big Data Architect - Independent Consultant - Thru Q ConsultingUcare Mar 2020 - Jun 2021Minneapolis, Mn, UsClient 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. -
Principal/Application ArchitectPrime Therapeutics May 2014 - Mar 2020Eagan, Mn, UsKey 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. -
Data Integration LeadPrime Therapeutics May 2011 - May 2014Eagan, Mn, UsKey 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. -
Core Etl Team (Development Lead)Wells Fargo Jan 2007 - May 2011San Francisco, California, UsApplication 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. -
Sr. Systems Analyst; Cs Solutions Inc.Client; Agribank, Fcb Feb 1998 - Jan 2007St. Paul, Minnesota, UsKey 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. -
Sr. Software EngineerCiber, Inc. Aug 1995 - Jan 1998Client: 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.
-
Software Developer (Training)Dsrc Pvt. Ltd., May 1994 - Jul 1995
-
Edp In-ChargeBajaj Garments Ltd., Jun 1993 - Mar 1994
-
Software EngineerTurbo Systems Pvt. Ltd., May 1992 - May 1993
Charles William Skills
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
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
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.
Start your free trial