ARPITA SAHA
Senior Data Modeler
Bilaspur
Summary
Detail-oriented Data Modeler with 8+ years of experience specializing in designing, implementing and optimizing data models ensuring data integrity, performance and scalability. Adept in building robust pipelines using Azure Data Factory, Matillion, SQL, Python. Expertise in ETL/ELT, data immutability, slowly changing dimensions across industries such as FMCG, Insurance, Real Estate etc. Proficient in cloud-based tech like Snowflake, Azure. Adept at developing database architectural strategies at the modelling and implementation stages.
Overview
11
11
years of professional experience
4
4
years of post-secondary education
Work History
Senior Data Modeller
Tiger Analytics, PepsiCo
01.2022 - 04.2025
- Designed and built medallion lakehouse architecture featuring Bronze, Silver, and Gold tiers. Worked closely with business stakeholders to analyze and interpret intricate business needs, translating them into comprehensive data models.
- Analyzed complex retail data, created conceptual, logical and physical data models.
- Developed the foundational & semantic layer using Erwin for client material procurement application, facilitating the management of commodity purchasing & seam less integration with PowerBI reports.
- Created Erwin data models using features like reverse engineering, forward engineering, macros, source to target mapping, report generation etc.
- Worked extensively on activities such as data analysis, data profiling, defining data quality rules.
- Automated table physicalization process using Python by directly converting Source to Target Documents into JSON files to be uploaded to Azure Repo, eliminating any scope of human errors, reducing the physical model creation efforts by 83% per resource per table
Consultant
Hangar Worldwide, Ralph Lauren
11.2020 - 01.2022
- Implemented end to end migration project from legacy system (MS SQL Server) to Snowflake using Matillion ETL.
- Spearheaded data loading into external stage in Amazon S3 buckets.
- Implemented Matillion orchestration through Change Data Capture loading data from Snowflake landing tables to target tables.
Data Integration Analyst
Cognizant USA
06.2019 - 11.2019
- Designed and implemented presentation layer utilizing Denodo raw layer. This facilitated visualization of key performance indicators (KPIs) such as Coverage, Projected Rent Growth, and Time to Monetization for a major real estate client
- Analyzed existing Denodo VQL queries to identify opportunities for improvements.
Software Analyst
Accenture Services Pvt. Ltd, Travelers Insurance
12.2015 - 04.2017
- Led every stage of the software development life cycle for a Marketing Analytics application utilizing Ab Initio, with a project value exceeding $10 million
- Developed a system to receive real time transactional data coming from the Online Quoting System
- Designed fact and dimension tables to effectively capture the data, subsequently, enhanced BI reports to encompass insights on throughput, cross-selling, and purchase methods.
Associate Software Analyst
Accenture Services Pvt. Ltd, Travelers Insurance
07.2014 - 12.2015
- Supported over 12 Ab Initio application versions of Marketing Analytics ETL application during it’s guarantee period
- Worked on performance optimization of Marketing Intelligence application by using complex SQL queries and stored procedures that reduced the run time of application by 3 hours
Education
Master of Science - Management Information Systems
University of Illinois Chicago
01.2018 - 05.2018
Bachelor of Engineering - Electronics and Telecommunication
University of Nagpur
06.2010 - 04.2014
Skills
- Data Analysis : SQL, Python (nltk, re, NumPy, SciPy, Pandas, Streamlit), PySpark
- Databases: Teradata, Microsoft SQL Server, PostgreSQL , Azure Databricks
- Visualization: Tableau, D3js, Matterjs, Metabase
- ETL/Orchestration: Ab Initio, Informatica,ADLS, Apache Airflow
- Data Modeling: Synapse, Hackolade, Erwin
- Cloud: Snowflake, Azure - (Azure Data Lake Storage, Azure Data Factory, Azure DevOps), Databricks - (Databricks Notebooks, Databricks Unity Catalog)
Timeline
Senior Data Modeller
Tiger Analytics, PepsiCo
01.2022 - 04.2025
Consultant
Hangar Worldwide, Ralph Lauren
11.2020 - 01.2022
Data Integration Analyst
Cognizant USA
06.2019 - 11.2019
Master of Science - Management Information Systems
University of Illinois Chicago
01.2018 - 05.2018
Software Analyst
Accenture Services Pvt. Ltd, Travelers Insurance
12.2015 - 04.2017
Associate Software Analyst
Accenture Services Pvt. Ltd, Travelers Insurance
07.2014 - 12.2015
Bachelor of Engineering - Electronics and Telecommunication
University of Nagpur
06.2010 - 04.2014
Similar Profiles
ARPITA SAHAARPITA SAHA
Data Architect at Tiger Analytics, PepsiCoData Architect at Tiger Analytics, PepsiCo
Chockalingam BChockalingam B
Machine Learning Engineer at Tiger AnalyticsMachine Learning Engineer at Tiger Analytics
G VSN SAI YASHASWEA BHARADWAJG VSN SAI YASHASWEA BHARADWAJ
Data Scientist at Tiger AnalyticsData Scientist at Tiger Analytics