Cooking, DIY Home Decor, Gardening
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
Data validation
Data profiling
Erwin
TSQL
HiveQL
Snowflake
Microsoft Excel
Azure
Dimensional Modelling
SQL
Tableau
SQL database systems
Python
Interests
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