Collaborated with a financial services organization to develop a dynamic pricing model backed by a structured PostgreSQL database hosted on AWS RDS. Created two core data tables: a Pricing Model and an Input Sheet, both designed for scalability and real-time updates. Developed an interactive dashboard using R and the Shiny framework to allow users to input variables and visualize pricing outputs instantly. Deployed the dashboard via shinyapps.io, enabling secure, web-based access for business users and decision-makers.

Designed and built a modern data warehouse architecture using SQL to implement the bronze (raw), silver (cleaned), and gold (curated) layers. Automated data ingestion and transformation processes that improved data reliability by 90% and reduced report preparation time by 70%. Integrated with Power BI for business-friendly dashboards and Notion for documentation and data lineage tracking.

Performed end-to-end EDA using advanced SQL queries to uncover behavioral patterns, identify churn signals, and analyze customer demographics. Designed interactive Power BI dashboards that enabled cross-functional teams to explore key insights independently. Documentation and insight narratives were centralized in Notion to streamline knowledge sharing across stakeholders.

Built advanced analytics workflows combining SQL-driven data models with custom DAX in Power BI to forecast sales trends and customer lifetime value. Reduced forecasting errors by 30% and improved business planning cycles. Used Notion to maintain model assumptions, version history, and executive summaries for ongoing collaboration and clarity.