Business Intelligence Azure Data

Kannapiran Raghunathan ***************@*****.*** Page 1 of 6

KANNAPIRAN RAGHUNATHAN

Lead Data & BI Engineer Enterprise Data and Healthcare Analytics Eden Prairie, Minnesota-USA +1-630-***-**** ***************@*****.*** https://www.linkedin.com/in/kannapiranr/

Microsoft Azure Cloud, Azure Data, Azure AI Certified and OPTUM AI & Ethics (Carnegie Mellon University) PROFESSIONAL SUMMARY

Experienced data Engineer with 19 years of hands-on expertise in data engineering, cloud modernization, building data warehouse and business intelligence data platform solution with a deep focus on healthcare analytics. Specializes in building scalable, efficient data platforms and leading high-impact modernization efforts that turn complex data into actionable insights. Passionate about AI/ML, automation, and ethical data use, always exploring emerging technologies to drive smarter, faster decision-making. I thrive in collaborative environments, embracing an open mindset to continuously learn from others and contribute meaningfully to team success. As a proactive mentor, I support colleagues in skill development while fostering a culture of knowledge-sharing. My ability to navigate matrix organizations ensures seamless coordination across teams, driving efficiency and innovation. COMPREHENSIVE SKILL MATRIX EXPERIENCE (Technical & Soft Skills) Databases Microsoft SQL Server, Azure SQL Managed Instance, MySQL, Oracle, Mongo DB and Azure SQL.

Programming & Scripting SQL, PL/SQL, Python (Pyspark, NumPy, Pandas, PyMongo), Snow SQL (basic) and KSQL (basic), Power Query, DAX, Airflow DAG with Python Operators.

Data Integration & Engineering Azure Data Factory, Synapse Analytics, Azure Data explorer, Databricks, SSIS, Talend Open Studio, Logic App and SAP Data Services Integrator.

Data Architecture Principle Data Warehouse, Data Lineage, Lakehouse, Data and Delta Lake and Data Modeling (logical, physical, Star & snowflake).

Visualization and Business Intelligence Tableau (Desktop, cloud), Power BI Desktop, SSRS, Alteryx(basic), SAP Business Objects

Integrated Development Environment (IDE) SQL Server Management studio, TOAD, SQL Developer studio, Visual Studio Code Editor, MySQL work bench, Mongo DB compass and Notebooks.

Logging Azure monitor and log analytics, Splunk, Rundeck Log API, Power BI audit logs

Source Control and Versioning Git Desktop, GitHub Integration (Azure data factory & Azure Synapse Git repos), Databricks repos

Orchestration Rundeck, IBM Tivoli workload Scheduler (TWS) and Airflow, XL Deploy, JFrog Artifact Repository

Cloud Storage Azure blob storage, Azure Data Lake Storage Gen2(ADLS), Amazon S3/CloudBerry Explorer

Project Management Rally Agile tool (Aha) and HP ALM (Micro focus) Soft Skills Team Leadership, Mentoring, Strategic Thinking, Stakeholder Management, Decision-Making, Conflict

Resolution, Change Management, Problem-Solving,

Communication, cross functional collaboration,

Adaptability, Critical Thinking

Kannapiran Raghunathan ***************@*****.*** Page 2 of 6 AREA OF EXPERTISE

• 15 years of hands-on Proven expertise in building scalable, actionable data platforms using Medallion Architecture to drive data augmentation and enrichment for business, product, and engineering outcomes.

• 12 years of strong experience in various healthcare data platforms by implementing integrated clinical data solutions, data platform migration, data process movement automation in Medicare, Medicaid, Provider enrollment, Provider credentialing, patient member engagement, Clinical performance (STARS Measures, HEDIS, NCQA compliance) and claims (medical, RX, lab, 837, 835).

• 10 years of experience in adopting and implementing system design and architecture methodology for efficient data ETL pipeline to improve performance, data quality and business rich data metrics.

• 10+ years of working experience in UnitedHealth Group (OPTUM) in critical value-based care model data transformation platform for Medicare Advantage products such as Home and Community, Optum at Home, Skilled Nursing Facility and OPTUM Medicaid FISMA Environment.

• 6+ years of experience in migrating to an azure data factory (ADF) from on-premises data pipeline (SSIS and Talend ETL) and implemented transformation using Databricks DLT pipeline and synapse analytics.

• 8+ years of experience in working with JSON, XML, PARQUET, CSV and TXT file formats during lake house and data warehouse processing.

• 10+ years of experience in developing data solutions for enriched BI dashboard and visualization in HealthCare domain using Tableau and Power BI.

• 6+ years of experience in Talend Open Studio, Talend Enterprise and Talend Cloud platform.

• 8+ years of experience in mentoring, knowledge sharing with junior analysts, foster a data-driven culture within the organization and developing clear design/process flow documentation aligned to vital business functions (VBFs).

• 10+ years of strong track record of delivering within Agile SDLC framework to ensure iterative, collaborative, ready to market value-drive project outcomes.

• 5+ years of Domain knowledge experience in Banking, Financial, Manufacturing and Media & Entertainment.

• Experience with Snowflake architecture, tools and data processing using snowSQL, SnowPipe, time travel with fundamental badge Hands On Essentials - Data Warehouse - Credly

• sExperience in using CI/CD automation, version control and code quality best practices.

• Skilled in leveraging AI/ML methodologies and tools (e.g., GitHub Copilot, Azure AI Cognitive services

) To automate workflows, improve productivity, and optimize costs.

• Experience in analyzing, debugging and solutioning for better optimization tuning techniques based on query plan from database SQL programs and spark query.

• Actively pursuing upskilling through certifications (Microsoft Fabric (DP 700)-In Progress, Microsoft AI 102-In Progress).

PROFESSIONAL EXPERIENCE

Company: UnitedHealth Group / OPTUM

Role & Duration: Lead Data & BI Engineer (June 2023- May 2025) Domain: HealthCare

Project: Medicaid Data Conversion, Eden Prairie, USA Tools & Programming

Used:

Azure data factory, Synapse Analytics, Databricks notebooks, Delta Lake and DLT pipeline, ADLS Gen2, Talend Open Studio, MongoDB, Mongo DB Compass GitHub, Power BI, Oracle, MySQL, MySQL Workbench, SQL Server Management Studio (SSMS) and Airflow.

RESPONSIBLITIES:

• Worked in end-to-end cloud migration strategy due to growing medicaid data (provider, claims and eligibility) data volume and MySQL (inbound DC framework) performance bottlenecks. Designed blueprint and migration plan to transition from on-prem to Azure SQL Managed Instance for optimized scalability. Kannapiran Raghunathan ***************@*****.*** Page 3 of 6

• Spearheaded medicaid EDL (Enterprise Data Lake) cost rationalization by migrating legacy data pipelines to Azure Cloud-native services using a phased and modular approach. Successfully modernized ETL into azure Data Factory and Azure Data Lake Gen2 with significant cost savings.

• Designed and developed over 50+ reusable ADF pipelines for ingestion, transformation, and load processes, improving automation and reducing repetitive development efforts.

• Engineered and deployed a modular data processing framework to ingest data from source APIs and inbound file systems into Delta Lake layers (Bronze, Silver, Gold) using Databricks Delta Live Tables, ensuring reusability and data lineage.

• Developed common utility process for data cleansing and transformation in DLT pipeline for different inbound file types. Implemented data governance, RBAC, permission configuration across different layers.

• Collaborated closely with BI engineers and product teams to develop an aggregated BI layer, accelerating dashboard development and data-driven decision-making across the enterprise.

• Worked in data conversion framework for provider data migration such as provider enrollment, work history, credentialing, convictions, business owner, licensing to ADLS and Lakehouse for pipeline consumption.

• Created a semantic layer by exposing Gold Delta tables as external tables in Synapse Serverless SQL Pools, enabling low-latency and cost-effective access to data via Power BI and Tableau, decreasing dashboard refresh times by 60%.

• Designed and developed data enriched business intelligence layer using synapse analytics for powering visualization and reporting in Tableau and Power BI for provider enrollment, Medicaid eligibility and claims.

• Implemented dynamic and parameterized pipelines with robust error handling and log analytics integration to enhance observability, proactive alerting, and root cause.

• Experience in developing azure log analytics workspace for unified log monitoring for data pipeline, error handling and notification. This approach helped the project data transformation strategy and performance.

• Created Airflow DAG for orchestration of ADF, DLT and Synapse pipeline as part of data transformation.

• Delivered technical knowledge transfer sessions to team members, product owners, and maintenance/support groups, fostering broader understanding of ETL orchestration and cloud transformation patterns.

Company: UnitedHealth Group / OPTUM

Role & Duration: Senior Data Engineer (May 2021 – May 2023) Domain: HealthCare

Project: Medicare Advantage & Medicaid Program, Eden Prairie, USA Tools & Programming

Used:

Azure SQL, Azure data factory, Databricks notebooks, Delta live tables, Talend Open Studio, GitHub, Power BI, SQL Server Management Studio (SSMS), Microsoft SSIS (SQL server Integration Services),

RESPONSIBLITIES:

• Architected and implemented a hybrid data platform using Azure Data Factory, Databricks (Delta Lake + DLT), and Synapse Analytics to ingest, transform, and serve over 15 million weekly healthcare records, including medical claims, Rx claims, eligibility, enrollment, and lab data.

• Designed parameterized, metadata-driven ingestion pipelines using Change Data Capture (CDC) techniques in ADF and Databricks, enabling incremental file-based loads and reducing end-to-end pipeline runtimes by 80%.

• Designed and deployed Delta Live Tables (DLT) pipelines to automate the ingestion, transformation, and modeling of Medicaid claims, member eligibility, and provider enrollment reference data from raw landing zones to curated gold layer.

• Used Azure data explorer to analyze inbound and outbound data for data exploration to get better understanding before building data pipeline.

Kannapiran Raghunathan ***************@*****.*** Page 4 of 6

• Tuned DLT pipeline performance using Z-Ordering, optimized file sizing, and materialized views, reducing batch latency and improving SLA adherence for regulatory reporting.

• Boosted care delivery efficiency by 80% through automated data ingestion from HouseCalls (Optum at Home) to Pathway Complex care management.

Company: Cognizant Technology US CORP

Role & Duration: Technology Specialist - Data Narrative Engineer (May 2015 – Apr 2021) Domain: HealthCare

Project: HouseCalls Data & BI Analytics UnitedHealth Group / OPTUM, Eden Prairie, USA Tools & Programming

Used:

Microsoft SSIS (SQL server Integration Services), Azure data factory, Databricks notebooks, Delta live tables, Talend Open Studio, GitHub, Power BI, Server Management Studio (SSMS)

RESPONSIBLITIES:

• Built SSIS-based ETL frameworks and automated pipelines with TWS for clinical performance data metrics from various sources.

• Developed Talend workflows for ingesting healthcare datasets, including Member Roster, Claims (837, 835), Eligibility, and Provider Data, ensuring data accuracy and compliance.

• Worked in ETL migration project to save cost and performance from Talend Enterprise to Talend open studio. Implemented global context variables, remediated components, data flow to improve data integration in Talend open studio.

• Designed interactive healthcare dashboards in Tableau and Power BI to visualize call center performance, medication adherence, provider scorecards, and patient outcomes, improving decision-making.

• Designed Tableau dashboards for pre/post HouseCalls, finance metrics, referral trends, and SMT call history.

• Performed various Proof of concept and produced metric to leadership team for azure cloud migration from on-prem data and ETL components.

• Migrated Crystal Reports into Tableau, integrating key attributes like IVR Calls, Summary Dashboards, and Agent Scorecards for enhanced operational insights in healthcare call centers.

• Received Multiple Bravo Awards for automating BI reports from SSRS to Tableau which improved business driven action by 80% based on power visualization and monitoring metrics. Company: Cognizant Technology US Corp

Role & Duration: Senior Associate - Viz & Data Narrative Engineer (May 2012 -Apr 2015) Domain: HealthCare

Project: Aetna/Coventry- Care Radius Health Management System, Downers Grove-IL USA Tools & Programming

Used:

Microsoft SSIS (SQL server Integration Services), Business Objects XI R2, Web-I, Desk-I, Oracle10g, TOAD, ORACLE APPS 11i, SQL Loader, Oracle PL/SQL and Erwin Data Modeling.

RESPONSIBLITIES:

• Created reusable transformations and Mapplets and used them in mappings.

• Created dashboards for utilization, behavioral health, complaints, and transplant programs.

• Published and scheduled Tableau dashboards with role-based access control.

• Led data warehousing/reporting for member 360 care radius team from onsite client location.

• Used various transformations like Source Qualifier, Expression, Aggregator, Joiner, Filter, Lookup, Update Strategy Designing and optimizing the Mapping.

• Developed Workflows using task developer, worklet designer, and workflow designer in Workflow manager and monitored the results using workflow monitor.

• Worked on TOAD and Oracle SQL Developer to develop Procedure, functions and view for business objects, crystal reports reporting layer.

Company: Cognizant Technology Solutions

Role & Duration: Associate-Data & Viz Narrative Engineer (Sep 2010 - Apr 2012) Kannapiran Raghunathan ***************@*****.*** Page 5 of 6 Domain: HealthCare

Project: Aetna- Care Radius Health Management System Tools & Programming

Used:

Microsoft SSIS (SQL server Integration Services), Business Objects XI R2, Web-I, Desk-I, Oracle10g, TOAD, ORACLE APPS 11i, SQL Loader, Oracle PL/SQL and Erwin Data Modeling.

RESPONSIBLITIES:

• Created Dimension Tables and Fact Tables based on the warehouse design for Aetna Health Care management system.

• Involved in creating Logical and Physical design of databases using Erwin.

• Worked in building Data Warehouse, which includes the Design of Data mart using Star Schema.

• Created ETL detail design document and implemented data integration using PL/SQL procedure and functions. Performed analysis on the existing universe, BO reports for new functionality enhancement.

• Developed Oracle Reports and PL/SQL packages for enterprise analytics platforms.

• Optimized performance with indexing, table partitioning, and concurrent programming for financial analytics.

Company: Capgemini Technology Solutions India Pvt Ltd Role & Duration: Senior Software Engineer, India (Jan 2008 - Aug 2010) Domain: Banking & Finance

Project: Union Bank of California

Tools & Programming

Used:

Business Objects XI R2, Web-I, Desk-I, Oracle10g, TOAD, ORACLE APPS 11i, SQL Loader, Oracle PL/SQL, Oracle ERP and BO Data Modeling.

RESPONSIBLITIES:

• Developed Business Objects (dashboard & credit management) reports, oracle PL/SQL packages and functions. Worked in Universe Creation and respective mapping components.

• Developed open interfaces for loading data Apps Interface tables. Key player in the project related to Oracle Database issues. Developed open interfaces for loading data Apps Interface tables.

• Worked in writing shell script for CRON job purpose. Involved in creating Procedure which uses API

(OE_ORDER_PUB.PROCESS_HEADER) for updating the OE_ORDER_HEADERS_ALL table. Performance tuning of oracle PL/SQL queries.

Company: HTC Global Solutions India Pvt Ltd

Role & Duration: Senior Software Engineer, India (July 2006 - Jan 2008) Domain: Banking & Finance

Project: Reserve Bank of India (Integrated Data Management System -DESACS) Tools & Programming

Used:

Oracle 10G, TOAD, SQL, PL/SQL, Oracle 6i Forms & Reports RESPONSIBLITIES:

• Developed web source in Oracle 10G reports. Developed Functions and procedures for analytical reporting platform.

• Created Concurrent program for the oracle reports, package, and triggers. Worked in Performance tuning for oracle PL/SQL procedures. Worked in preparation of design documents like functional specification.

• Performance tuning of oracle reports using GLOBAL TEMPORARY TABLE, creating Index and Partition of Table.

Company: HTC Global Solutions India Pvt Ltd

Role & Duration: Software Development Engineer, India (June 2005 – June 2006) Domain: Banking & Finance

Project: Reserve Bank of India (Integrated Data Management System -DESACS) Tools & Programming

Used:

Oracle 10G, SQL, PL/SQL, Oracle 6i Forms & Reports RESPONSIBLITIES:

Kannapiran Raghunathan ***************@*****.*** Page 6 of 6

• Worked in development and coding in PL/SQL and SQL in ORACLE 10G Forms and reports for Data Management system for the Department of Statistical Analysis and Computer Services for financial Institution.

• Worked in developing Stock Screens and Transaction Reports. Worked in developing PLL’s (project linked libraries).

• Involved in Unit Testing and defect fix.

EDUCATION

Bachelor of Engineering (B.E.), Electrical & Electronics (2001 to 2005) Anna University, Chennai, India

Contact this candidate