Pallavi P

Snowflake Development & Data Architecture

• Designing and implementing efficient data architectures, including databases, schemas, tables, views, and materialized views in Snowflake.
• Developing and managing data pipelines for extracting, transforming, and loading (ETL/ELT) data using DBT, SQL, and external ETL tools.
• Expertise in Snowflake Multi-Cluster Warehouses, Snowpipe, Internal/External Stages, Clone, Tasks, and Streams.
• Handling data migration from traditional databases (e.g., Oracle, SQL Server) or other cloud platforms to Snowflake, ensuring data quality and integrity.
• Loading raw data from AWS S3 into Snowflake using Storage Integration, Stages, File Formats, COPY INTO, and Snowpipe.
• Implementing fact & dimension tables and defining materialization properties (e.g., table, view, incremental) using DBT models.
• Designing and implementing data models in DBT Core to structure data for optimal analysis.

DBT & Data Transformation

• Developing and maintaining DBT models, implementing transformations, tests, and documentation.
• Performing generic and singular tests in DBT to ensure data accuracy and business alignment.
• Using Jinja templates, macros, incremental strategies, and snapshots to develop complex transformations.
• Storing data in raw and curated layers with different schemas for structured processing.
• Managing incremental data loading and transformation strategies for optimal performance.
• Writing modular SQL queries to transform raw data into clean, analytics-ready datasets.

Version Control & CI/CD

• Pushing DBT model changes to the development branch after implementation.
• Using GitHub Actions to automate CI/CD workflows for deployments.
• Monitoring workflow performance and making optimizations as needed.

Performance Optimization & Security

• Optimizing SQL queries using techniques like partitioning, clustering, and scaling virtual warehouses.
• Implementing robust data security policies, access controls, and user roles to ensure compliance.
• Automating data loading and processing tasks using Snowflake Tasks and Stored Procedures.

• Created reports using Desktop Intelligence and Web Intelligence
• Created reports using other data providers like Personal data files, Freehand SQL Stored procedures
• Created different kind of charts based on user requirement in Desktop Intelligence and Web Intelligence
• Involved in creating reports using BO thick Client and thin client
• Created the reports using Business objects functionalities like Queries, Slice and Dice, Drill Down, Cross tab, Master Detail and Formulas etc
• Involved in creating Complex reports
• Created Xcelsius Dashboards based on business requirement
• Created different kind of reports using crosstab, Vertical and horizontal based on user requirement
• Created Drill reports, linking of reports using Hyperlink option based on user requirement in Web Intelligence
• Designed, developed, tested, and maintained Tableau functional reports based on user requirements
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Dropdown menu option and Parameters using Tableau
• Involved in creating database objects like tables, views, procedures, triggers, functions using SQL Server to provide definition, structure and to maintain data efficiently
• Extensively involved in creating graphs by using measures and dimensions data from various databases by using data blending concept
• Converted existing BO reports to tableau dashboards
• Created different KPI using calculated key figures and parameters
• Developed Tableau data visualization using Cross tabs, Heat maps, Box and Whisker charts, Scatter Plots, Geographic Map, Pie Charts and Bar Charts and Density Chart
• Developed donut charts and implemented complex features in charts like creating bar charts in tooltip
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics and table calculations
• Provided Production support to Tableau users and Wrote Custom SQL to support business requirements
• Utilized Tableau server to publish and share the reports with the business users
• Responsible for creating calculated fields, combine fields, bins, sets, geo coding and hierarchies using Tableau Desktop
• Involved in creating a dual-axis bar chart with multiple measures
• Implemented data blending to blend related data from different data sources.

• Created reports using Desktop Intelligence and Web Intelligence
• Created reports using other data providers like Personal data files, Freehand SQL, Stored procedures
• Created different kind of charts based on user requirement in Desktop Intelligence and Web Intelligence
• Involved in creating reports using BO thick Client and thin client
• Created the reports using Business objects functionalities like Queries, Slice and Dice, Drill Down, Cross tab, Master Detail and Formulas etc
• Involved in creating Complex reports
• Created Xcelsius Dashboards based on business requirement
• Created different kind of reports using crosstab, Vertical and horizontal based on user requirement
• Created Drill reports, linking of reports using Hyperlink option based on user requirement in Web Intelligence
• Effective use functions like alerts and ranking Web Intelligence reports
• Involved in scheduling reports in CMC.
• Utilized data visualization tools to effectively communicate business insights.