SAIPRIYA MORAVANENI

Role: Senior Data Analyst
Description: Liberty Mutual Insurance is a Fortune 100 global insurer, offering a wide range of insurance products and services. I contributed to the development of dynamic BI dashboards, automation of ETL workflows, and analytics strategy to support operations, risk, and marketing.
Responsibilities:
• Conducted comprehensive data profiling, cleansing, and standardization from diverse sources including Oracle, SQL Server, Salesforce, and flat files, enhancing data reliability and consistency by 40%.
• Designed and deployed 20+ interactive Tableau and QlikView dashboards to visualize KPIs, claims metrics, and operational performance for underwriting and policyholder services.
• Automated recurring data pipelines using Python, dbt, and SSIS, reducing manual workload by 50% and ensuring scalable transformation and load processes.
• Created CI/CD pipelines to support deployment of SQL transformations and dashboard changes to AWS Redshift and Azure Synapse, ensuring rapid iteration and production delivery.
• Utilized Looker, Google Data Studio, and Adobe Analytics to unify customer interaction data and marketing funnel metrics, improving data-driven campaign performance.
• Developed complex PivotTables, data models, and VBA scripts in Excel to summarize claims, trends, and customer retention insights across product lines.
• Designed custom data visualizations and storyboards using D3.js, enhancing executive reporting presentations and investor-ready insights.
• Led efforts in data governance, defining Source to Target Mapping (STM), business logic documentation, and implementing validation checks using Alteryx.
• Coordinated with QA, BI, and DevOps teams to ensure unit testing, integration, and UAT cycles adhered to business requirements and regulatory standards.
• Applied regression, hypothesis testing, and time series analysis using R and Python to validate insurance rate models and claims forecasting.
• Integrated operational and third-party datasets into enterprise dashboards using Domo, Power BI, and SharePoint Apps, enabling cross-functional visibility and alerts.
• Ensured consistency of reporting standards by publishing semantic layers and metadata definitions across Tableau Server and Power BI Service.
• Maintained high data availability and refresh reliability by using Control-M, Airflow, and scheduled refresh in Tableau and Power BI portals.
• Participated in Agile ceremonies, collaborated with stakeholders via Jira, Confluence, and Azure Boards, and supported sprint planning with data requirement breakdown.
• Provided L2 support for legacy reports, migration guidance to modern BI platforms, and mentoring for junior analysts in Power BI and SQL development.

Role: Data Analyst / Developer
Description: Sun Pharma is a leading global pharmaceutical company. I contributed to clinical and operational data solutions by developing ETL pipelines, performing advanced analytics, and delivering dashboards to support RD and manufacturing insights.
Responsibilities:
• Developed optimized SQL and PL/SQL queries for processing high-volume transactional data across clinical, sales, and supply chain systems.
• Created interactive dashboards using Power BI, integrating data from Salesforce, CRM, and ERP systems to visualize market performance and batch analysis.
• Built ETL pipelines using SSIS, ADF, and Airflow, automating ingestion from legacy and cloud sources.
• Applied statistical techniques such as regression and clustering using Python and R for evaluating RD and trial outcomes.
• Created complex Excel models, Power Query scripts, and VBA macros to support stability testing and deviation tracking.
• Implemented data validation and profiling using Talend and Toad, improving report accuracy and regulatory readiness.
• Wrote and optimized REST API integrations and Azure Functions for real-time reporting between SAP and internal systems.
• Documented data flows, STM, and business rules using MS Visio and Confluence, enhancing knowledge sharing across QA and manufacturing.
• Participated in Agile sprint cycles, using Jira and Confluence for project tracking and requirement alignment.