Rounak Saha profile photo 1 on Tal

Rounak Saha

BI Developer | Snowflake | ETL | Power BI | SQL | Assistant Manager–Data Science @ WNS | Data Analytics & Engineering Expert

Bengaluru

6+ years of work experience

WNS
Jun 20251 y 3 moPresent

Remote

● Designed and orchestrated robust data pipelines to ingest, transform and load multi-source healthcare datasets into the Snowflake Data Warehouse, ensuring seamless alignment across data discovery, mapping and transformation processes. ● Mentored team members, led knowledge-sharing sessions and drove the adoption of optimized Snowflake architecture, as well as development and platform best practices across the team. ● Developed and dynamically optimized complex SQL Views in both Snowflake and Amazon Redshift to serve analysis-ready data directly to the Visualization team for critical dashboards (Pre-Planning, Resource Utilization, Competitor Sales, Payor, A2D). ● Engineered Redshift MDM tables and automated Data Quality frameworks using custom SQL to validate and cross-reference daily, weekly and monthly feeds from 31 SPs against master data. ● Bridged business and technical execution by translating complex pharmaceutical data rules to guide team members in building accurate S3-to-Redshift ingestion pipelines. ● Spearheaded the in-house migration of data aggregation, eliminating third-party dependency and seamlessly integrating the cleansed SP data into the existing enterprise data warehouse. ● Engineered an interactive Sales Tracker in Power BI, writing advanced DAX to enable dynamic time-intelligence analysis across LTD, YTD, QTD and Weekly timeframes, empowering stakeholders with actionable performance trends. ● Built a comprehensive Patient Analytics Power BI report to track Total Enrolments, Active Patients and Discontinuations, enabling leadership to optimize patient engagement and retention strategies. ● Designed a Patient Switch Behaviour analytics table in Amazon Redshift by integrating massive datasets (RX/DX/PX Claims, Physician and Drug Info), establishing a foundational dataset for Python-based machine learning models. ● Served as a Data Manager and technical liaison, gathering requirements from internal teams and external clients, managing change requests via JIRA and overseeing end-to-end data builds for timely project delivery.
WNS
Dec 20246 mosMay 2025

Axtria - Ingenious Insights
Apr 20231 yr 9 mosDec 2024

Bengaluru, Karnataka, India · Hybrid

● Spearheaded the design and implementation of the buy-and-bill and hybrid sales channels for Axtria's Field Intelligence product. This involved designing ingestion definitions and developing end-to-end data pipelines to clean, transform and process various datasets, including Call Activity, Call Plan, Rep Triggered Emails, Expense, Sales, Goals, Customer Universe, Next Best Action Suggestions and more. ● Designed and implemented ETL workflows using Axtria DataMAx to extract data from multiple sources, load it into the Snowflake Data Warehouse and transform it according to business requirements. ● Developed and optimized SQL queries for data retrieval, analysis and reporting, ensuring accuracy and efficiency in data operations. ● Achieved a significant reduction in data processing time from 1.5 hours to under 20 minutes through query optimization and refinement of redundant join conditions and filters. ● Enhanced the data model by implementing primary key, foreign key and not null constraints, and by standardizing column data types and lengths. These improvements significantly boosted data integrity and consistency. Additionally, by adding table and column-level comments, the data model became more readable, resulting in a 15% faster delivery time and an 80% reduction in communication between product and delivery teams regarding data model understanding. ● Ensured quality, security of data and optimized performance of reports to deliver best solutions to clients. ● Engineered a robust Patient Enrolments report tailored for a Specialty Pharmacy, leveraging Power BI to analyse patient activity patterns, conversion rates and critical insights for Head Office, driving strategic initiatives and optimizing operational efficiency.
Axtria - Ingenious Insights
Jun 202210 mosMar 2023

Bengaluru, Karnataka, India · Hybrid

● Created an advanced Power BI report for Patient Risk Analysis, revealing key cancellation trends; facilitated proactive measures that reduced patient discontinuations by 25% within the first quarter. ● Proficient in database management, data transformation, and data analysis, with extensive experience in visualizing complex datasets using Power BI to derive actionable insights and support data-driven decision-making. ● Partnered with cross-functional teams, including data architects and business stakeholders, to gather requirements, resulting in a 30% improvement in data integration efficiency and a 20% reduction in project delivery time. ● Conducted data profiling, cleansing and validation activities to maintain data integrity and quality. ● Implemented performance tuning techniques to optimize query execution and improve overall system performance.
Axtria - Ingenious Insights
Apr 20223 mosJun 2022

Bengaluru, Karnataka, India · Hybrid

Wipro
Feb 20211 yr 3 mosApr 2022

Bengaluru, Karnataka, India

● Designed and implemented Power BI reports to enhance process management and bug tracking, providing actionable insights for stakeholders. ● Engineered complex data loading and extraction workflows through Microsoft SSIS, optimizing ETL processes and reducing data processing time by 40%, enhancing overall system efficiency by 25%. ● Extensively engaged in SQL tuning, debugging and script optimization. ● Orchestrated the migration project from Master Data Services to Profisee MDM, establishing a robust framework for data governance that ensured compliance with industry standards and reduced data retrieval time by 25%. ● Conducted data and code analysis in critical situations using SQL Server and SSIS. ● Designed and developed ETL packages with a focus on data quality, data integrity and performance. ● Strong experience of data warehouse concepts, data ingestion, transformations and data flows. ● Effectively managed critical failures and incident responses related to ETL jobs. ● Experienced in execution of functional and automation testing using Functionize on Salesforce based on user stories.
Wipro
Sep 20206 mosFeb 2021

Bengaluru, Karnataka, India

Rounak’s AI Stack

claude
claude
gemini
gemini
ChatGPT
ChatGPT
Microsoft Copilot
Microsoft Copilot

Education

Guru Nanak Institute of Technology , Kolkata

Bachelor of Technology - BTech, Computer Science and Engineering

Guru Nanak Institute of Technology , Kolkata

20164 yrs2020

Join Rounak and 10k+ other professionals on

Tal Boss

Tal is the app where bosses meet engineers & builders directly, without middlemen

Download Tal Boss

Rounak Saha on Tal

Headline

BI Developer | Snowflake | ETL | Power BI | SQL | Assistant Manager–Data Science @ WNS | Data Analytics & Engineering Expert

About

As a Snowflake/ETL Developer specializing in data integration and scalable pipelines. Proficient in Snowflake's cloud platform, I design efficient solutions driving data insights and informed decision-making. With an analytical mindset and commitment to learning, I collaborate cross-functionally to deliver impactful data solutions. Skilled in performance optimization and troubleshooting, I ensure data accuracy and governance. Additionally, I leverage Power BI to develop insightful reports, enhancing data visualization and analysis. Proactive and adaptable, I stay updated with evolving technologies and industry trends to deliver innovative solutions. Dedicated to empowering organizations with reliable data solutions, I am eager to contribute expertise to drive business success.

Location

Bengaluru

AI stack

claude

gemini

ChatGPT

Microsoft Copilot

Work experience

Assistant Manager-Data Science at WNS, Jun 2025 - Present · 1 y 3 mo, Remote, ● Designed and orchestrated robust data pipelines to ingest, transform and load multi-source healthcare datasets into the Snowflake Data Warehouse, ensuring seamless alignment across data discovery, mapping and transformation processes. ● Mentored team members, led knowledge-sharing sessions and drove the adoption of optimized Snowflake architecture, as well as development and platform best practices across the team. ● Developed and dynamically optimized complex SQL Views in both Snowflake and Amazon Redshift to serve analysis-ready data directly to the Visualization team for critical dashboards (Pre-Planning, Resource Utilization, Competitor Sales, Payor, A2D). ● Engineered Redshift MDM tables and automated Data Quality frameworks using custom SQL to validate and cross-reference daily, weekly and monthly feeds from 31 SPs against master data. ● Bridged business and technical execution by translating complex pharmaceutical data rules to guide team members in building accurate S3-to-Redshift ingestion pipelines. ● Spearheaded the in-house migration of data aggregation, eliminating third-party dependency and seamlessly integrating the cleansed SP data into the existing enterprise data warehouse. ● Engineered an interactive Sales Tracker in Power BI, writing advanced DAX to enable dynamic time-intelligence analysis across LTD, YTD, QTD and Weekly timeframes, empowering stakeholders with actionable performance trends. ● Built a comprehensive Patient Analytics Power BI report to track Total Enrolments, Active Patients and Discontinuations, enabling leadership to optimize patient engagement and retention strategies. ● Designed a Patient Switch Behaviour analytics table in Amazon Redshift by integrating massive datasets (RX/DX/PX Claims, Physician and Drug Info), establishing a foundational dataset for Python-based machine learning models. ● Served as a Data Manager and technical liaison, gathering requirements from internal teams and external clients, managing change requests via JIRA and overseeing end-to-end data builds for timely project delivery.

Assistant Manager - RNA at WNS, Dec 2024 - May 2025 · 6 mos

Software Engineer at Axtria - Ingenious Insights, Apr 2023 - Dec 2024 · 1 yr 9 mos, Bengaluru, Karnataka, India · Hybrid, ● Spearheaded the design and implementation of the buy-and-bill and hybrid sales channels for Axtria's Field Intelligence product. This involved designing ingestion definitions and developing end-to-end data pipelines to clean, transform and process various datasets, including Call Activity, Call Plan, Rep Triggered Emails, Expense, Sales, Goals, Customer Universe, Next Best Action Suggestions and more. ● Designed and implemented ETL workflows using Axtria DataMAx to extract data from multiple sources, load it into the Snowflake Data Warehouse and transform it according to business requirements. ● Developed and optimized SQL queries for data retrieval, analysis and reporting, ensuring accuracy and efficiency in data operations. ● Achieved a significant reduction in data processing time from 1.5 hours to under 20 minutes through query optimization and refinement of redundant join conditions and filters. ● Enhanced the data model by implementing primary key, foreign key and not null constraints, and by standardizing column data types and lengths. These improvements significantly boosted data integrity and consistency. Additionally, by adding table and column-level comments, the data model became more readable, resulting in a 15% faster delivery time and an 80% reduction in communication between product and delivery teams regarding data model understanding. ● Ensured quality, security of data and optimized performance of reports to deliver best solutions to clients. ● Engineered a robust Patient Enrolments report tailored for a Specialty Pharmacy, leveraging Power BI to analyse patient activity patterns, conversion rates and critical insights for Head Office, driving strategic initiatives and optimizing operational efficiency.

Software Analyst at Axtria - Ingenious Insights, Jun 2022 - Mar 2023 · 10 mos, Bengaluru, Karnataka, India · Hybrid, ● Created an advanced Power BI report for Patient Risk Analysis, revealing key cancellation trends; facilitated proactive measures that reduced patient discontinuations by 25% within the first quarter. ● Proficient in database management, data transformation, and data analysis, with extensive experience in visualizing complex datasets using Power BI to derive actionable insights and support data-driven decision-making. ● Partnered with cross-functional teams, including data architects and business stakeholders, to gather requirements, resulting in a 30% improvement in data integration efficiency and a 20% reduction in project delivery time. ● Conducted data profiling, cleansing and validation activities to maintain data integrity and quality. ● Implemented performance tuning techniques to optimize query execution and improve overall system performance.

Analyst at Axtria - Ingenious Insights, Apr 2022 - Jun 2022 · 3 mos, Bengaluru, Karnataka, India · Hybrid

Test Engineer at Wipro, Feb 2021 - Apr 2022 · 1 yr 3 mos, Bengaluru, Karnataka, India, ● Designed and implemented Power BI reports to enhance process management and bug tracking, providing actionable insights for stakeholders. ● Engineered complex data loading and extraction workflows through Microsoft SSIS, optimizing ETL processes and reducing data processing time by 40%, enhancing overall system efficiency by 25%. ● Extensively engaged in SQL tuning, debugging and script optimization. ● Orchestrated the migration project from Master Data Services to Profisee MDM, establishing a robust framework for data governance that ensured compliance with industry standards and reduced data retrieval time by 25%. ● Conducted data and code analysis in critical situations using SQL Server and SSIS. ● Designed and developed ETL packages with a focus on data quality, data integrity and performance. ● Strong experience of data warehouse concepts, data ingestion, transformations and data flows. ● Effectively managed critical failures and incident responses related to ETL jobs. ● Experienced in execution of functional and automation testing using Functionize on Salesforce based on user stories.

Project Engineer at Wipro, Sep 2020 - Feb 2021 · 6 mos, Bengaluru, Karnataka, India

Education

Bachelor of Technology - BTech, Computer Science and Engineering, Guru Nanak Institute of Technology , Kolkata