PATTABHI NADIMPALLY

**** ********** ** ****: 614-***-****

Dublin, OH 43016 Email: adzurs@r.postjobfree.com

Data Architect

Extensive Enterprise Data Architecture and Data Management experience

Cross-functional experience delivering Data Warehouse solutions

Excellent problem solving, analytical, presentation and communication skills

SKILLS

Enterprise Data Architecture

Master Data Management (MDM)

Data Warehouse Architecture

Enterprise Data Standards, EIM & Meta Data Management

Data Governance, Data Stewardship

Compliance, Data Security & Data Privacy

CMS/Medicare (Part A, Part B, Part D)

Agile / JIRA

Snowflake, Netezza, Terradata, Azure, DB2(UDB, Z/OS), MS SQL Server, Oracle, Sybase

SAP Power Designer, CA Erwin, Idera E/R Studio, DB Schema

Data Lakes, OLTP/OLAP Data Modeling, Data Vault, Dimensional, Semantic Models

Conceptual, Logical, Physical modeling

ETL/ELT, Data Migrations, Source-to-Target Mapping

Healthcare . . . Finance & Insurance … Telecommunications . . . OH Government . . .

EDUCATION / PUBLICATION

Master of Science Degree in Computer Applications, University of Hyderabad, Hyderabad, India

Article: Privacy, Security and Data Architecture – DM Review (Online archive)

PROFESSIONAL EXPERIENCE

OhioHealth, Columbus, OH 02/2018 – 10/2022

Architected Population Health Warehouse to integrate external Medicare, Medicare Advantage, Commercial Medical/RX Claims with EPIC Clarity clinical data

Defined data structures working closely with stake-holders at all levels for PHS Data Warehouse and Master Data (MDM) outbound data extracts and interfaces as part of Find-A-Doctor Enterprise solution

PHS Warehouse contained a dozen or more Insurance claims data from various private and federal agencies (CMS, UnitedHealthCare, Humana, MMO, CIGNA etc. Medical / RX Claims)

Designed CMS Medicare Part A/B/D CCLF Claims for ACO PHS care management groups

Designed data strategies for Provider / Customer Master Data Management (MDM) Hubs and EPIC/Caboodle extracts

Advisor to data governance and data steward teams implementing Axon/EDC Data Governance solutions

Elicited requirements and designed PHS Semantic Layer, driving development of patient care dashboards, enumeration of HEDIS metrics and other reporting layers

Architected integration and upkeep of Medical/RX Billing Codes (ICD/CPT/HCPCS/PCS/NDC/etc.) in the warehouse

Profiled external data streams using IDQ and Source-target mappings for ETL teams

SME for data certifications and data utilization by the business

Modeled PHS Medical/RX Claims MS SQL Server data warehouse using ER/Studio

JPMorgan Chase, Columbus, OH 06/2017 – 02/2018

Customer data integration models for Mortgage Banking and Treasury reporting on Teradata using ERWin

Data models for classifications of Customer privacy and risk data attributes for DECO transition to Hadoop and to manage Customer privacy preferences for XLOB Hadoop data mart

Fiserv, Columbus, OH 04/2014 – 03/2017

Designed Bill Pay (ePayments - Electronic Payment Transactions) EDW solutions on DB2 / Netezza plaforms using SAP Power Designer

Designed custom Master Data Management (MDM) solution across ePayment/BillPay, Pop data and ACH financial Customers on Netezza platform

Architected Customer Marketing Segmentation solution for Marketing department

Designed Person-to-Person (POP) payments OCR data integrations with Bill Store data warehouse

Performed data quality analyses related to Biller transactions using IDQ

Designed Enterprise Data Governance strategies to purge Subscriber and financial transaction (base grain, summaries and aggregates) data as part of regulatory compliance

Initiated Design Review Board processes and championed EIM standards and best practices

Time Warner Cable (now Charter Comm.), Charlotte, NC 06/2009-12/2009, 08/2011 – 03/2013

Delivered EDS data layer and EDW for Netezza / Oracle EIM framework

Designed Customer Data Hub

Designed BI data marts for Audience Measurement, Order processing, Service Mangement

Architechted customer behavior data models and strategies to integrate Adobe Site Catalyst click stream data and WiFi usage with data hubs for marketing segmentations

Championed Enterprise Data Warehouse Standards and Best Practices

Health Care Dataworks, Columbus, OH 08/2010 –06/2011

Designed data models to integrate EPIC/Clarity Patient data with Diagnostic and Drug Administration data drawn from Sunquest and Pixel systems for Nationwide Childrens hospital

Designed data models to track hospital readmissions and operation theater KPI's

Department of Mental Health, State of Ohio, Columbus, OH 12/2009 – 06/2010

Delivered data warehouse framework for the Program Planning division

Designed data warehouse to integrate Medical Claims data with internal/external data flows for Cognos BI solution to report on Patient Episodes and efficiency KPI's of Program Planning

Provided technical leadership to DBA’s and ETL developers to implement the solution

Call Center Analytics (Various), Columbus, OH ; Chelmsford/MA & Manchester/NH 11/2006 - 04/2009

Developed call center data marts for Genesis CTI / Infomart at DSW and Harte Hanks

Developed BI reports using Business Objects / Crystal Reports to track Agent efficiency, Call Routing efficiency and Case resolution metrics/KPI's

Designed Customer Data Integration solution to design reporting Data Mart, integrating Avaya PBX and Genesis CTI data with Billing data for Customer 360 degree view dashboard for Comcast, NH

Various Pre-2006

Enterprise data architecture for Interaction-to-Insight, a multi-tenant hosting SaaS solution and developed data privacy, security and risk mitigation strategies to ensure customer data privacy at Extraprise Boston, MA (Nov 2005 – Oct 2006)

Delivered Sales and Marketing Data Mart for COGNOS Report net BI solution at John Hancock/Manulife, Boston, MA (June 2004 – Oct 2005)

Implemented Vantive/PeopleSoft CRM systems for various over 25 clients across various veriticals working with Vantive / PeopleSoft, Boston, MA (June 1997 – July 2001)

Delivered Customer Data Integration's and CRM customization's with Customer 360 degree views at Sterling Commerce, Columbus, OH (March 2003 – April 2004)

Managed CRM upgrades and data migrations for Freddie Mac on multiple occasions (May 2001 – Aug 2001, Sep 2002 – Jan 2003)

Managing consultant on the enterprise-wide data integration and portal development project. Integrated 35+ distributed databases at Sapphire Technologies, Woburn, MA (August 2001 – July 2002)

Contact this candidate