Donald De Witt

Donald De Witt Email and Phone Number

Azure Data Integration Architect @ SPS Health
Milwaukee, WI, US
Donald De Witt's Location
Madison, Wisconsin, United States, United States
Donald De Witt's Contact Details
About Donald De Witt

With over 8 years of experience in cloud solutions, architecture, migration, storage, and analysis, I am a hands-on technical leader and a business-savvy professional. I have a proven track record of creating and implementing action plans that improve business intelligence, data warehousing, and project management for small to large scale projects across various industries and domains.Currently, as the IT Director / Solution Architect at Advanced Pain Management, a newly established Medicare/Medicaid pain clinic startup, I am responsible for creating the IT presence on Google Cloud Platform, implementing Microsoft platforms, acquiring and purchasing software and hardware, and working with state and federal agencies and compliance departments. I also leverage my expertise in Salesforce, Snowflake, DBT, LookML, DataStudio, Teradata, Azure, SQL Server, Oracle, Tebra (Kareo), and other tools to design and develop analytical financial and medical provider data extracts and reports. My mission is to enable the company to deliver high-quality, cost-effective, and patient-centered care through innovative and reliable IT solutions.

Donald De Witt's Current Company Details
SPS Health

Sps Health

View
Azure Data Integration Architect
Milwaukee, WI, US
Website:
spshealth.com
Employees:
99
Donald De Witt Work Experience Details
  • Sps Health
    Azure Data Integration Architect
    Sps Health
    Milwaukee, Wi, Us
  • Advanced Pain Management
    It Director / Solution Architect
    Advanced Pain Management May 2023 - Present
    Evans, Georgia, Us
    Performing as a Hands-On Technical Leadership Role:• For newly established Medicare/Medicaid pain clinic startup (http://www.apmclinics.com), created IT presence on Google Cloud Platform; creating analytical financial and medical provider data extracts/rpts • Implemented Microsoft platforms, using Office 365, OneDrive, Teams, on Windows 11 staff laptops / PCs• Acquired and purchased software, hardware, established online IT subscriptions, website online accounts• Worked with Nevada state government agencies (PECOS/ CMS) and compliance departments to license Nurse Practitioners, billing clearing houses, BellMedEx billers, Healthcare Insurance companies• Evaluated and implemented Healthcare cloud platform systems: Practice Fusion and Tebra (formerly Kareo) • Configured Tebra Healthcare EHR; systems to manage clinic doctors, patients, pharmacy, insurance billing• Coded and managed all data to create pre authorizations, super bills, intake appointments, de-mographics• Provided DevOps for entire IT infrastructure and all clinic communications and electronic data inter-change.
  • Logicmonitor
    Senior Data Architect
    Logicmonitor Oct 2022 - Apr 2023
    Santa Barbara, Ca, Us
    Performing as a continent worker, modernizing the Business Intelligence Data Warehouse serving Finance, Marketing, Sales and Leadership. Data Architecture (DBT, LookML) , BI Analysis and Analytics Dashboard development on the Google Analytics stack (Looker, DataStudio) ingesting source system (Salesforce, Zuora, Zendesk, Workday, Marketo, Lacework, AWS) data hosted in the Snowflake Cloud database platform, transformed and moved via Fivetran.
  • Tata Consultancy Services
    Senior Solutions Architect
    Tata Consultancy Services Jan 2020 - Oct 2022
    Mumbai, Maharashtra, In
    For Humana Healthcare, currently (2+years) acting as Data Architect Lead, on Rapid Response Team (RRT) Data Analytics concurrent projects serving Claims, Pharmacy, Medicare/Medicaid, Finance Auditing, and COVID tracking business initiatives. * Solutioned Oracle (Exadata) Enterprise Data Warehouse BI Analytics reporting, Microsoft Azure data migra-tions from Microsoft on-prem SQL Server and Microsoft legacy Access DBs to Azure Cloud SQL Server. De-signed, using Erwin Data Model tool, multiple JSON Log, OLTP, ODS, and Star Schema Analytics predictive and historical data models with data masking, encryption, and row level security at the database level. * Supported multiple database servers for Microsoft Power Platforms (Flow, PowerApps, PBI) applications. Participated in SCRUM daily offshore calls, weekly business status calls, and led offshore design sessions. * Coordinated provisioning and procurement of new Azure Cloud subscriptions with sizing and costing estimates with Humana Cloud and Solution Architects. Mentored and managed offshore and nearshore junior / midlevel teams. * Published and implemented Microsoft Power Platforms (Flow, PBI, and PowerApps) best practices. Enforced Data Architect table and column naming standardsFor Kaiser Permanente Healthcare (6 months) acted as Senior Solutions Architect for the TIMS program engagement.* Delivered BRD (Business Requirements Document), ALSD (Application Solutions Design Document), DMS (Data Mapping Sheet), and Data Model for the DML 2.0 (custom inventory MDM application) and TDR (Technology Data Repository). * Managed and mentored offshore developers to communicate design solutions for coding delivery. * Mentored Engagement Management with planning and roadmap strategic creation client reviews. * Worked with Senior management at KP (Kaiser Permanente) IT Services as required on current state issues.Stack: Azure Cloud, Synapse, PowerPlatforms (PBI, Flow) SQL Server 2003-16, Access, Oracle Exadata, Mongo
  • Linkedin
    Senior Data Architect
    Linkedin Mar 2018 - Dec 2019
    Sunnyvale, Ca, Us
    Tata Consultancy Contingent worker: Driving Data Warehouse tactical and strategic initiatives at LinkedIn:* HRIT - TCS HRDW Roadmap: Delivered gap analysis revisions specific to People vs Data Strategy GTO initiatives* HRIT - Diversity DM Resign : Delivered conceptual, logical, and physical reporting star schema data models for the functional areas, Supervisory Org, Location, Pipeline Workflow, Recruiting, Diversity Grouping, Disposition, Requisitions, Candidates, Applications* HRIT - ATS DM Redesign : Delivered Reporting star schema Dimensional Data Model for Application State Changes, Supervisory Org and Employee Functional Areas* HRIT – Talent Acquisition DM Resign : Delivered conceptual, logical, and physical reporting star schema data models for the following functional areas, Organization , Offers ,Interviews , Candidate/Applicant, Requisition* HRIT - Conducted Dimensional Modeling Training: Sessions for TI Analysts specific to HRDW current and future states* TCS - Learning and Development: Manage training needs for the account, follow up with the team to complete iEvolve trainings (includes iSecurity course), any follow up with team for mandatory enrollments , coordinate L&D Training
  • Wynn Las Vegas
    Senior Data Warehouse (Etl-Edw-Informatica)
    Wynn Las Vegas Dec 2016 - Mar 2018
    Las Vegas, Nevada, Us
    For the EDW team, lead redesign of tactical data models, using ER Studio sourcing from IGT Gaming system - MS SQL Server 2012, to existing Teradata EDW. Started strategic rewrite of future state Dimensional / 3 NF concecptual models.▪ Reversed engineered source system data models, from legacy to new upgraded IGT Gaming system data models.▪ Conducted source system analysis, data profiling, and schema compare synchronization ER Studio models▪ Utilized and wrote ER Studio Macros for faster and efficient data dictionary implementation of data type conversion.▪ Forward engineered tactical LDM and PDM (Physical Data Models) to Informatica Stage Layer on Teradata Platform.▪ Generaed DDLs, and deployed to stage and production environments in accordance with implementation plan.▪ Optimized SQL Performance DDL with Teradata best practices PDM design (Index, Partitioning, UPIs, NUPI).▪ Developed Informatica 10.x Mapping, Sessions, ad Workflows for Historical and CDC PWX , PWC.▪ Created strategic Conceptual Data Models for Customer, Hotel, Gaming, and Finance subject areas; started LDM.
  • Williams-Sonoma, Inc.
    Senior Data Warehouse Architect
    Williams-Sonoma, Inc. Nov 2014 - Nov 2016
    San Francisco, Ca, Us
    Collaborated with multiple implementation consulting partners and evaluated new software solutions with vendors; also wrote disaster recovery, security compliance, data governance plans, and future state roadmap▪ Led /approved technical data integration ETL/database designs and code delivery for customer and retail data warehouses, IBM Sterling Data Mart, and Customer Data Management (MDM) teams▪ Directed performance tuning and sql optimization initiatives with onsite and offshore Teradata DBAs, Ab-Initio ETL Leads, and Mi-crostrategy Report Leads▪ Implemented Business Intelligence/Enterprise Data Warehouse best practices and standards within the marketing analytics user and data analyst community▪ Drove ER Studio Data Model redesign and new design multidimensional platforms▪ Participated in HortonWorks Big Data Ab-Initio ETL off-load and Teradata Aster Site Search projects
  • Practice Fusion
    Senior Data Warehouse Architect
    Practice Fusion Jan 2014 - Oct 2014
    San Francisco, Ca, Us
    Provided leadership in critical role in a highly agile scrum environment with light requirements; worked with database administrators and archi-tects to remove obstacles and ensure standards are followed Implemented ETL processes following preset guidelines and deployed processes for database code deployment and synchronization across settings ▪ Led and managed JIRA story writing and grooming for Data Architecture and ETL efforts; provided SQL Server source data analysis, data definitions, data profiling, database tuning SQL queries, and indexes▪ Hands on IBM Netezza appliance database schema creation, application development, and production deployments
  • Capgemini
    Solutions Architect / Engagement Manager
    Capgemini Jun 2011 - Nov 2012
    Paris, France, Fr
    Contributed designs that addressed business expansion and growth, delivered documentation for the data dictionary and MDM references, and developed an Agile delivery plan to meet client data model requirements▪ Managed multiple on/offshore resources to each project lifecycle, overseeing issue resolution, stakeholder relations, and client ser-vice/support for multiple projects, achieving sign off approval and full customer satisfaction▪ Completed ARP release from coding to deployment in the finance audit department; re-platformed legacy accounting to a Microsoft SQL Server partial stack (SSRS/SSIS) with Business Objects WEBI front ▪ Managed data model and data migration requirements to BI solution for re-platforming mainframe legacy▪ Inherited budget project plan, issues log, existing client SDLC implementation and approval processes, project scope, and project char-ter from the Senior Project Manager and drove successful completion and client satisfaction▪ Implemented GREAT BI project staffing modeling and EFFORT cost estimations ▪ Awarded Q1 2012 Capgemini Engagement of the Quarter for delivery excellence
  • Ntt Data Corporation
    Principal Solutions Architect
    Ntt Data Corporation Nov 2009 - Jun 2011
    Tokyo, Jp
    Led ETL/database design session activities in creation of best practices and infrastructure; provided reliability via data validations, data govern-ance, audit controls, and batch controls for traceability▪ Implemented Oracle best practices and database design to enhance data model design/functionality Coordinated technical implementa-tion details for ETL and database resources with client infrastructure teams; assisted client management with status reporting, client issue resolution, and technical team ▪ Contributed to client facing data design reviews and supervised data/business analysts while facilitating performing tuning by us-ing efficient querying methods with standard tools to increase data load speed▪ Provided fixed data model anomalies with claims, authorization sponsors, membership, providers, contract, and premium billing where upstream designs were not in sync with the healthcare subject areas▪ Added ODS layer between QNXT and Staging database to deliver accurate data identification integration▪ Integrated Kalido MDM solution between facets and Enterprise Data Warehouse to ensure data conformity
  • Innovatively.Com
    Solutions Architect (Bi-Edw-Etl-Callidus)
    Innovatively.Com May 1998 - Feb 2009
    For multiple nationwide clients, Bank of America Securities, Wachovia Securities, Principal Financial, Sprint PCS, At&T, Comcast, Cigna Healthcare, Aetna Healthcare ▪ Designed and developed OLTP and EDW solutions as required participating in full SDLC▪ Led EBay/StubHub’s data architecture strategy redesign legacy OWB to Informatica 9 migration; analyzed data sources and BI re-quirements to develop Business Objects reports in SQL and universes ▪ Worked with Accenture on-site and off-shore IDC technical teams to implement Oracle PL/SQL database load stored procedures to de-liver Business Objects XI / Crystal and xCelsius Salesforce Dashboards▪ Modeled customer StubHub 360 data requirements using ER Studio Data Architect on Oracle and analyzed re-platform to Cloudera Hadoop▪ Led ETL Informatica design efforts for PG&E’s EP data warehouse while also leading ETL developers in integrating disparate source 3NF databases into EP DW for BO XI; delivered dimensional model for the EP data warehouse and accommodated disparate Excel data▪ Designed ODS and dimensional model for Operational Reporting and BI Analytics data marts sourced from Callidus TrueComp 60 OLTP for Comcast; trained and mentored on/offshore teams in vendor application and data model SQL logic/ERD while designing test cases for peer unit testing -delivery of Oracle PL/SQL▪ Acted as Data Integration Lead and BI Analyst for the Data Warehouse Group implementing Business Objects 8 on Callidus at Auto-desk; customized Oracle 8i TrueComp 51 Data Mart Reporting star schema and architected the SAP data warehouse while also designing and coding Informatica 72 ETL for deposit data warehouse extracts

Donald De Witt Skills

Data Warehousing Business Intelligence Etl Data Modeling Sdlc Pl/sql Oracle Agile Methodologies Sql Informatica Integration Databases Requirements Analysis Microsoft Sql Server Business Objects Dashboard Requirements Gathering Db2 Database Design Obiee Unix Shell Scripting Data Architecture Data Migration Performance Tuning Callidus Project Management Enterprise Software Sql Server Teradata Cognos Truecomp Actuate Reporting Data Integration Business Analysis Software Development Life Cycle Large Scale Data Analysis Hadoop Hive Hdfs Hortonworks Nosql Mongodb Cloudera Columnar Key Value Pair Bde Vldb

Donald De Witt Education Details

  • Cal State East Bay- College Of Business & Economics
    Cal State East Bay- College Of Business & Economics
    New Ventures - Small Business Management
  • Cal State East Bay- College Of Business & Economics
    Cal State East Bay- College Of Business & Economics
    Business - Computer Info Systems
  • Teradata University
    Teradata University
    Teradata Consulting
  • Tata (Tcs) Ievolve Training Program
    Tata (Tcs) Ievolve Training Program
    Information Technology

Frequently Asked Questions about Donald De Witt

What company does Donald De Witt work for?

Donald De Witt works for Sps Health

What is Donald De Witt's role at the current company?

Donald De Witt's current role is Azure Data Integration Architect.

What is Donald De Witt's email address?

Donald De Witt's email address is do****@****tcs.com

What is Donald De Witt's direct phone number?

Donald De Witt's direct phone number is +141523*****

What schools did Donald De Witt attend?

Donald De Witt attended Cal State East Bay- College Of Business & Economics, Cal State East Bay- College Of Business & Economics, Teradata University, Tata (Tcs) Ievolve Training Program.

What are some of Donald De Witt's interests?

Donald De Witt has interest in Social Services, Nba, Nfl, Civil Rights And Social Action, Education, Environment, Science And Technology, Mlb, Human Rights, Animal Welfare.

What skills is Donald De Witt known for?

Donald De Witt has skills like Data Warehousing, Business Intelligence, Etl, Data Modeling, Sdlc, Pl/sql, Oracle, Agile Methodologies, Sql, Informatica, Integration, Databases.

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.