I am a data professional with 9 years of experience in data analysis and modeling across finance, healthcare, and insurance domains. I have hands-on experience in business and data analysis, data profiling, data migration, data integration, and metadata management services. I’ve designed multidimensional data models using Kimball methodologies, built end-to-end ETL pipelines with Informatica PowerCenter, and optimized data warehouses in Snowflake. I collaborate with actuaries, clinicians, underwriters, and data scientists to translate analytical needs into scalable data solutions. I value data quality, governance, and automation, and enjoy delivering executive dashboards in Tableau and Power BI, along with Python-based data validation and reconciliation.

Sai Pallavi

I am a data professional with 9 years of experience in data analysis and modeling across finance, healthcare, and insurance domains. I have hands-on experience in business and data analysis, data profiling, data migration, data integration, and metadata management services. I’ve designed multidimensional data models using Kimball methodologies, built end-to-end ETL pipelines with Informatica PowerCenter, and optimized data warehouses in Snowflake. I collaborate with actuaries, clinicians, underwriters, and data scientists to translate analytical needs into scalable data solutions. I value data quality, governance, and automation, and enjoy delivering executive dashboards in Tableau and Power BI, along with Python-based data validation and reconciliation.

Available to hire

I am a data professional with 9 years of experience in data analysis and modeling across finance, healthcare, and insurance domains. I have hands-on experience in business and data analysis, data profiling, data migration, data integration, and metadata management services. I’ve designed multidimensional data models using Kimball methodologies, built end-to-end ETL pipelines with Informatica PowerCenter, and optimized data warehouses in Snowflake.

I collaborate with actuaries, clinicians, underwriters, and data scientists to translate analytical needs into scalable data solutions. I value data quality, governance, and automation, and enjoy delivering executive dashboards in Tableau and Power BI, along with Python-based data validation and reconciliation.

See more

Experience Level

Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Intermediate
See more

Work Experience

Senior Data Analyst/ Data Modeler at Webster Bank
June 1, 2024 - November 4, 2025
Responsibilities include leading all data warehouse life cycle phases within the Data Quality Design framework, developing extraction and loading processes using Informatica, and translating insurance domain requirements into conceptual, logical, and physical data models using ERwin and MarkLogic. I performed source-to-target data mappings for critical attributes (e.g., Package ID, Business Risk Unit Number, Loan Number) to ensure consistency across EDH systems. I designed and optimized star schemas for APV and ACV lines of business, including code/decode structures and item standardization. I created mappings, mapplets, workflows, and reusable transformations to support scalable data integration. I supported QA/UAT and data reconciliation, partnered with ETL developers to ingest structured and semi-structured data into Snowflake and Oracle warehouses, and documented BRDs, data dictionaries, and lineage. I also analyzed data in Google BigQuery, applied NLP to unstructured data, built A
Data Analyst at Allianz SE, India
March 1, 2021 - March 1, 2021
Led analytics for operations, creditor development, and customer service; mined large datasets with SQL and Python to derive insights; developed ETL mappings in Informatica PowerCenter 10.4 to load data from DB2 and Netezza into Snowflake; analyzed policy attributes to ensure harmonization and integration; built Power BI dashboards for workforce, material, and energy forecasting; created data dictionaries and lineage reports; collaborated with actuaries, underwriters, and business analysts; monitored batch processes with Control-M; participated in Agile ceremonies.
Data Analyst at Essjay Ericsson,
December 1, 2017 - December 1, 2017
Worked with analysis and management teams by providing variables based on requirements. Generated PL/SQL scripts for data manipulation and validation, reviewed SQL queries, and developed multiple database objects. Analyzed existing data models, performed data cleansing, and developed live reports in Tableau. Connected AWS Redshift with Tableau for visualization and created storytelling dashboards in Tableau Server. Assisted with mapping, testing dashboards, and creating reports in Excel for wider distribution. Engaged in Agile tasks and contributed to data governance activities including metadata management.

Education

Master's in Business Analytics at Avila University
January 11, 2030 - November 4, 2025
Bachelor degree in Computer Science at Hyderabad Institute Of Technology
January 11, 2030 - November 4, 2025

Qualifications

Add your qualifications or awards here.

Industry Experience

Healthcare, Financial Services, Professional Services, Other