Mar 2024 – Nov 2024 · 8 mos · Chennai, Tamil Nadu, India · On-site

• In depth analysis of Advertisement campaign
• performance
• Extracted key insights which tells how. Advertisement campaign perform in Digital
• Marketing platforms
• Optimizing data solutions with tools and platforms such as Python, SQL and Tableau
• Developed a Tableau dashboard rendering the need for post-campaign offer reports
• Developed SQL Queries for data extraction.

Nov 2021 – Jan 2024 · 2 yrs 2 mos · Bengaluru, Karnataka, India · On-site

• Developed SQL queries to extract, transform, and load (ETL) data into Snowflake from various sources.
• Integrated Snowflake with AWS S3
• Created and managed external stages referencing AWS S3 buckets with proper IAM credentials and security configurations.
• Validated and transformed data stored in AWS S3 before loading into Snowflake using file format definitions and COPY options.
• Performed data loading and unloading between Snowflake and AWS S3
• Created and managed internal and external stages, and defined appropriate file formats (e.g., CSV, JSON, Parquet).
• Optimized Snowflake SQL queries using clustering keys and best practices for query performance.
• Participated in data modeling sessions and contributed to the design and implementation of database schemas.
• Developed and maintained Snowflake data warehouses, ensuring performance, scalability, and security.
• Wrote and optimized complex SQL queries for data analysis, dashboards, and reporting.
• Scheduled and orchestrated Snowflake workflows using Apache Airflow DAGs

Feb 2021 – Nov 2021 · 9 mos · Bengaluru, Karnataka, India · On-site

• During promotional periods taken extra responsibility to maximize sales
• Created Business Reports for higher management using data visualization
• techniques.
• New price and advance% are updated on the server as per Sales manager’s
• approval
• Prepared Data Visualization Dash Boards, Charts &Calculations using Tableau
• Experienced in designing complex dashboards that take advantage of all Tableau
• functions including data blending, actions, parameters, Reference Lines and more
• Expertise in creating different visualizations using Lines, Pies, Histograms, Waterfall
• Chart, Funnel Chart, Donut Charts, Scatter, Bullets, Heat Maps, Tree maps, etc.
• Prepared MIS Reports using MS Excel and published the same to Relevant teams.

Nov 2019 – Jan 2021 · 1 yr 2 mos · Bengaluru, Karnataka, India

• Created purchase orders as per Buying manager’s request.
• Coordinated with Buying Managers and Warehouse Managers.
• Prepared Supply Chain Reports like Purchase Orders, Goods Received & Sales.
• Preparing Dashboards using calculations, parameters in POWER BI
• Used Trend Lines, Parameters, Slicers, Aggregate Functions and filters.

Apr 2016 – Aug 2017 · 1 yr 4 mos · Bengaluru, Karnataka, India · On-site

• Resolved Vendor issues related to Pricing and total invoice amount
• Validated the documents like GRN, PO, Invoice, Debit note, and Credit note
• Coordinated with Buying managers and vendors on price related issues
• Prepared supply chain Reports like Inventory Report, Purchase orders Report, Goods
• Received Report, Sales Report using MS Excel.
• Used advanced excel formulas like Index match, VLOOKUP and Nested IF conditions.
• Prepared summary reports using Pivot Tables
• Developed Excel Dash board with various Charts and Graphs.
• Quickly Responded to emailed requests for data updates.
• Resolved vendor’s complaints relating to short or over deliveries