Summary
Overview
Work History
Education
Skills
Websites
Certification
Accomplishments
Timeline
OperationsManager
Tania Nag

Tania Nag

Senior Consultant
Kolkata

Summary

Experienced Data Engineer with over 5 years of expertise in designing and implementing complex data models and ETL processes. Proficient in writing efficient SQL queries and enhancing database performance. Successfully led a team in migrating a large-scale data warehouse to Snowflake, resulting in a 50% reduction in credit consumptions and improved data accuracy.

Overview

5
5
years of professional experience
4
4
years of post-secondary education
2
2
Certifications

Work History

Senior Data Engineer

PwC
Kolkata, West Bengal
03.2023 - Current
  • Crafted robust data architecture to support diverse data sources and reporting needs
  • In Snowflake DW, managed individual databases for 36 different geographical regions, addressing challenges of handling data volume and accommodating source-specific logic dynamically for consolidated reporting
  • Worked as data modeler to design reports considering data from all regions
  • Optimized performance to reduce Snowflake credit consumption by ~50%
  • Leveraged Azure Data Factory for orchestrating seamless data workflows.

Data Engineer

PwC
Kolkata
01.2022 - 02.2023
  • Migrated SAP modules related to BAIP to Snowflake via ETL tool AWS Glue and transformation method used over Snowflake-based stored procedure via data warehousing layers, i.e., Staging, Datamart, and KPI
  • Collaborated closely with stakeholders to design and implement comprehensive Sales Order data model, ensuring efficient tracking and management of sales transactions
  • Played key role in designing Inventory data model to facilitate snapshots over time period of stock levels.
  • Collaborated with cross-functional teams to gather requirements and translate them into logical and physical data models.
  • Reduced query response time up-to 50% by creating materialized views and indexed views for commonly accessed datasets.

System Engineer

TCS, TATA McGraw-Hill
Kolkata
07.2019 - 10.2021
  • Worked on order to cash flow using EDI technology (Sterling Map Editor, B2B Sterling Integrator)
  • Implemented process using EDI from order placing to order delivery that has ability to drop ship to students on behalf of channel partners to protect revenue in case bookstore is unable to fulfill orders.
  • Leveraged cloud technologies to optimize costs, improve scalability, and facilitate seamless integration across platforms.
  • Managed end-to-end software development life-cycle, from initial requirements gathering to post-implementation support and maintenance.

Education

B.TECH - Information Technology

MAKAUT, WB
Kolkata
08.2015 - 05.2019

Skills

Terraform

undefined

Websites

Certification

SnowPro Core Certified

Accomplishments

  • Achieved 1st runners-up in Guest Speakathon contest, hosted by TCS Maitree Toastmasters Club - 2020
  • Got the On the Spot Excellence Award from the COO of McGrawHill for taking complete ownership of a critical project with perfect fulfillment of requirements - 2021
  • Received the Award and Beyond Team Award for great diligence and outstanding teamwork- 2022
  • Received PwC Star R&R award for the exemplary feedback received from the client - 2023

Timeline

Senior Data Engineer

PwC
03.2023 - Current

Data Engineer

PwC
01.2022 - 02.2023

System Engineer

TCS, TATA McGraw-Hill
07.2019 - 10.2021

B.TECH - Information Technology

MAKAUT, WB
08.2015 - 05.2019

Similar Profiles

CREATE PROFILE
Tania NagSenior Consultant