Purushottam Kulkarni

About Purushottam Kulkarni

Accomplished technology architect and data integration specialist with over 20 years of experience designing, developing, and implementing robust data warehousing and ETL solutions across cloud and on-premises environments.• Hands-on expertise in Informatica Cloud (IICS aka IDMC), Informatica PowerCenter, SQL Server Integration Services (SSIS), Snowflake, Azure Cloud Services (including Azure Data Factory, Blob Storage, SQL Server), and traditional data integration tools.• Extensive experience with healthcare payer data, including enrollment, billing, claims, care management, provider data, and enhancing member experience.• Proven ability to lead cross-functional teams, manage complex projects, and deliver innovative solutions that enhance business intelligence and drive strategic decision-making.• Strong background in healthcare, insurance, consulting, and life sciences industries.• Provided architectural solutions to healthcare payer organizations, managing teams of 10+ onshore resources.• Contributed to RFPs and POCs, resulting in a significant increase in revenue from $2M to $16M.• Expertise in delivering and supporting large-scale, high-profile applications and services.• Skilled in managing teams, building strategic relationships, global sales, and business and technology architectures.• Facilitated planning sessions, tracked project progress, gathered client requirements, and created technical specifications for various data integration projects.• Mentored and guided junior team members on technical best practices and project execution• Key Skills: ETL Development/Data Integration, Data acquisition, Data Engineering, Data Analysis, Data warehousing, Data Modelling (Dimensional, Relational, Star Schema, Snowflake Schema), Database Management (Oracle, SQL Server), Cloud Computing (Azure, Snowflake), Data Visualization (Power BI), Agile Methodologies, Project Leadership, Team Management, Requirements Gathering, Technical Documentation.

Experience

1. Technology Architect Manager Lead

   Infosys

   Jun 2007 — Present · Baltimore, MD, US

   Led the design and development of cloud-based data warehouses and ETL pipelines using Informatica cloud (IICS), Snowflake, and Azure Data Factory resulting in efficient handling of 200% more data, 30% improvement in data processing speed, a 15% improvement in data quality rate.• Provided architectural solutions to clients in the healthcare, insurance, and life sciences industries, managing teams of 10+ onshore resources and contributing to RFPs and POCs.• Successfully migrated Snowflake databases from commercial Azure regions to FEDRAMP government regions, ensuring compliance with security and regulatory requirements.• Developed and maintained ETL jobs supporting critical business functions such as enrollment, billing, and payment processing for CareFirst core platforms, using Informatica PowerCenter, SSIS and Azure Data Factory.• Optimized ETL pipelines and SQL queries for performance and scalability achieving 10% to 30% improvement in the performance.• Designed and Implemented data integration solutions that supported marketing analytics dashboards, leveraging Azure Data Factory, Azure Functions, and Power BI to provide actionable insights to marketing teams.• Facilitated planning sessions, tracked project progress, gathered client requirements, and created technical specifications for various data integration projects.• Mentored and guided junior team members on technical best practices and project execution.

Education

• Gulbarga University

  Bachelor of Engineering - BE, Computer Science

  1997 — 2001