Data Architect

• Jun 2020 - Present

Lead BI Data Architect / Data modeler

• Jun 2020 - Present

Cardinal is revamping their existing payer application Cardinal Innovation with Conduent HSP product for their NC state sponsored behavioral health program. HSP is payer product to configure member eligibility, Provider credentials, Claim authorizations, Adjudications and payments through batch and real time. North Carolina state category population into under Medicaid and state funded sponsorship. Eligibility information is exchange with HIPAA EDI X12 834, 835,837 file formats. These files are processed as batch with relevant workflows authorize claims, payments in HSP. Relevant data is extracted from HSP to load in to Azure Data Lake for further BI Analytics. Responsibilities: • Involved in the gathering Business requirement for Member Eligibility, Authorization and Payments. • Analyzed X12 file segments, trading partner information to configure in HSP HIPAA gateway application to process with required transformations. • Creating mapping for source EDI file attributes with HSP application attributes • Involved in developing the SSIS package to process EDI files through HSP HIPAA Gateway application and generate as CSV files • Involved in creating BRD document and circle back with customer business team to gather all require information • Involved in setting up Azure Devops process to do code repository, build and deployment process • Involved in Design discussions of Analytics reporting requirement Show less

Lead Snowflake Data Architect / Data modeler

• Nov 2017 - Apr 2020

• Interface with the business client to understand business needs and requirements, and to help develop and maintain the client relationship • Building data pipelines from data sources to report generation and solutions for a variety of exciting applications. • Experience with SnowFlake Cloud Data warehouse, deep understanding of Snowflake architecture and processing. • Experience with performance tuning of SnowFlake data warehouse with Query Profiler, Caching, and Virtual data warehouse scale out, scale up, and scale down in the multi-cluster warehouse. • Experience in working TASKS, STREAMS, and snowflake procedures, and functions. • Created Clone objects to maintain zero copies in Snowflake. • Worked on TASK creation for scheduling/Automate Snowflake jobs. • Handling large and complex data sets like JSON, ORC, PARQUET, and CSV files from various sources like Azure Blob storage. • Hands-on experience in bulk loading and unloading data into Snowflake tables. • Experience in writing complex SQL scripts using Statistical Aggregate functions and Analytical functions to support ETL in the snowflake cloud data warehouse. • Used COPY/INSERT, PUT, and GET commands for loading data into Snowflake tables from internal and external stages. • Good exposure to Snowflake Cloud Architecture and SnowSQL and SNOWPIPE for continuous data ingestion. Show less

Data Architect

• Sep 2012 - Oct 2017

Analysis, design of the Requirements Reverse engineering the existing DW Data Model to visualize and further enhance Analysis of different source target mapping , Business rules Enhancing landscape of Existing Data warehouse design ( Staging, Integration and Warehouse layers) Interaction with Business Users and Business Analysts to analyze the different scenarios Approach discussion of Self-service BI Solution Analysis, design of the Requirements Reverse engineering the existing DW Data Model to visualize and further enhance Analysis of different source target mapping , Business rules Enhancing landscape of Existing Data warehouse design ( Staging, Integration and Warehouse layers) Interaction with Business Users and Business Analysts to analyze the different scenarios Approach discussion of Self-service BI Solution

Senior Technical Lead

• Sep 2006 - Mar 2012

expertise in designing Conceptual , Logical and Physical data models for transactional and dimensional systems. I have good experience in reverse engineering existing data base data models across enterprise to build data migration, data integration. I have exposure to cloud based database , data models. I have hands on experience in On cloud, On premises database architecture. I worked on Meta data management for Largest healthcare company. I have exposures to Big data Unstructured , unmanaged volumes data to integrate with Structure data. I worked on Legacy application data consolidation , Data profiling and Data integration using ETL tools. I created Source to Target Data mapping , Business rules and rolling out strategies for several projects. Show less

Project lead

• May 2001 - Apr 2005

Involved in Requirements study , design , development , testing and implementation of ERP application module Finance Accounts, Sales modules to IT service organization. Designed and Developed Data Warehousing Project named Project Costing System (PCS) to monitor project health by project , division, Line of Business and corporate. Involved in Requirements study , design , development , testing and implementation of ERP application module Finance Accounts, Sales modules to IT service organization. Designed and Developed Data Warehousing Project named Project Costing System (PCS) to monitor project health by project , division, Line of Business and corporate.

Senior Software Engineer

• Jun 2000 - Apr 2001

Developed new module exports sales to ERP application EWIS , Sucessfully implemented ERP package to Laxmi Organics, Mumbai corporate office and Mahad factory location. Developed new module exports sales to ERP application EWIS , Sucessfully implemented ERP package to Laxmi Organics, Mumbai corporate office and Mahad factory location.

Software Engineer

• Oct 1998 - May 2000

Custom ERP package name WISE development team member. Whole Integrated System Enterprise is a client server technology based application using Visual Basic 5.0 as front End , Oracle as Back end and Crystal Reports are reporting module. As a part of team developed Domestic, Export sales module with Integrated Inventory and Accounts modules. Custom ERP package name WISE development team member. Whole Integrated System Enterprise is a client server technology based application using Visual Basic 5.0 as front End , Oracle as Back end and Crystal Reports are reporting module. As a part of team developed Domestic, Export sales module with Integrated Inventory and Accounts modules.