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
Data Warehousing
Data Modelling
SQL, PL/SQL
Apache Spark
Azure Data Factory
Power BI
Azure Databricks
AWS : S3, Glue
Python
GIT
Java
ETL processes
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