Summary
Overview
Work History
Education
Skills
Interests
Timeline
Generic

Sayantani Nath

Lead Data Architect
Chennai,India

Summary

To seek and maintain full-time position that offers professional challenges utilizing interpersonal skills, excellent time management and problem-solving skills.

Overview

9
9
years of professional experience
6
6
years of post-secondary education

Work History

Lead Data Architect-Data Modeler

Hexaware Technologies
Chennai, India
11.2020 - Current
  • Currently working on IQVIA's ( Client) Global Data Model GDM is the the core strategic data model for all projects, thereby ensuring data consistency across IQVIA by providing common business definitions and
  • Business rules and defining how commonly used data should be structured. Mainly working on Bayer's requirements which IQVIA offers as part of GDM.
  • Creation of Source to Target Mapping documents for data modelling requirements.
  • Creation of Snowflake & Star Schema based on business requirements.
  • Data Profiling & Analysis of Data on Hive/Impala/Snowflake Database.
  • Designed data models for complex analysis needs
  • Understanding of MDM in terms of IQVIA's master data.
  • Developed database architectural strategies at modeling, design and implementation stages to address business or industry requirements.
  • Drafted conceptual and logical data models for high-level system planning tasks, optimizing each model to customers' needs and budgets.
  • Work as a team to facilitate the integration of IQVIA information assets across countries so that the organization can produce high value global offerings as part of IQVIA's Data Governance mission.
  • Understanding of Kimball & Inmon Methodology and implementing the same in IQVIA's Global Data Model.
  • Have Knowledge on different types of dimensions and facts, data Vault, ODS.
  • Technologies Used : Erwin, Hive, MS Excel, SQL, Snowflake, ADF, Azure Synapse( learning on job)

Senior Data Reporting & Visualization Engineer

Dow Chemical Company
Chennai, India
10.2018 - 11.2020
  • Worked on developing multiple ETL packages to automate and handle millions of data required for showing visualizations on dashboards based on multiple project criteria, create reports , visualizations, maintain databases in terms od administration activities, create stored procedures, reports, schema, views, performance tuning, clean up of databases, schedule jobs, automate data.
  • Extensively worked on understanding business
  • Develop, design, maintain and tune SSIS packages
  • Perform data profiling and source to target mappings (while capturing ETL) for populating Kimball style dimensional models.
  • Hands on experience on Tableau Desktop , tableau Server & Power BI.
  • Create charts mainly on Tableau including Tree map, conditional map, column, bar, line, pie charts etc
  • Design, develop, test,and maintain Tableau functional reports based on user requirements.
  • Modify existing dashboard to create attractive visuals to convey story inside data.
  • Technologies used: MS SQL Server 2012 & 2016, SSIS, Tableau desktop 2019, Power BI, Python, T-SQL.

Senior Software Engineer

Fundsindia
Chennai, India
08.2017 - 09.2018
  • Worked as Data Engineer on projects that include mutual fund portfolios for any kind of investment requirement – lump sum or SIP, long-term or short-term, goal-oriented or ad-hoc, tax-saving or regular, and more, mainly on back end maintenance and development
  • Administration , monitoring & maintenance of Database.
  • Designed database & Index maintenance and restructuring.
  • Using SQL Profiler to identify and manage long running queries in production.
  • Work on performance tuning and optimization of complex queries in production.
  • Perform database backups and recovery mainly using Amazon RDS. ➢ Knowledge on backup methods, disaster recovery , database migration plans.
  • Worked in a team to upgrade database and installation.
  • Managing the controlled based access for different types of users.
  • Performance tuning and optimization of queries and stored procedures using Query Execution plans.
  • Create SP, index, Views and maintenance of transaction level scoping at the code level.
  • Create ETL packages to automate data. Technologies used: MS SQL Server 2012 & 2016, T-SQL , SQL Profiler, Amazon (AWS) RDS & EC2, SQL Server Reporting Services, SQL Server Integration Services(SSIS).

Senior Consultant

VirtusaPolaris
Chennai, India
07.2013 - 08.2017
  • Worked as Database Engineer (on client site From VirtusaPolaris) at FXLM, Citicorp Services India Private Ltd (CSIPL), Citi's flagship nonbanking technology entity in India providing technical solutions to various Foreign Exchange and Investment Banking services offered by Citi.
  • Worked on eDealer, one of the largest applications in the FX domain for Citi, that serves as a treasury middle office for booking FX, FI deals. It is spanned across 100 countries and supports over 400 currency pairs. It has database hosted in 3 regions around the world. Developed various stored procedures, triggers, optimized existing procedures that involves complex sql.
  • Technologies used: Sybase 15.1, SQL Server 2008 R2 &SQl Server 2012, Hermes, shell script (execution), SSIS.

Education

BTECH - Computer Science

National Institute of Technology, Agartala
Agartala, Tripura, IN
08.2009 - 05.2013

High School, ISC - All Subjects

Holy Cross School, Agartala
Agartala, Tripura, IN
06.2007 - 03.2009

Skills

    Data Warehousing Architecture

undefined

Interests

Cooking, DIY Home Decor, Gardening

Timeline

Lead Data Architect-Data Modeler

Hexaware Technologies
11.2020 - Current

Senior Data Reporting & Visualization Engineer

Dow Chemical Company
10.2018 - 11.2020

Senior Software Engineer

Fundsindia
08.2017 - 09.2018

Senior Consultant

VirtusaPolaris
07.2013 - 08.2017

BTECH - Computer Science

National Institute of Technology, Agartala
08.2009 - 05.2013

High School, ISC - All Subjects

Holy Cross School, Agartala
06.2007 - 03.2009

Similar Profiles

CREATE PROFILE
Sayantani NathLead Data Architect