ARPITA SAHA
Senior Data Engineer
Etobicoke,ON
Summary
A meticulous senior data engineer proficient in crafting, constructing, and up keeping robust data frameworks that prioritize scalability, security, and reliability. Experienced in collaborating closely with business stakeholders, system architects, and software experts to grasp industry needs, thereby crafting detailed data models. Skilled in formulating database architectural strategies throughout the modeling, design, and implementation phases.
Overview
10
10
years of professional experience
Work History
Data Architect
Tiger Analytics, PepsiCo
01.2022 - Current
- Designed and built 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.
- Developed and implemented foundational layer for Global Procurement Application, facilitating the management of commodity purchasing within the company.
- Created the semantic layer for the Global Procurement Application, enabling seamless integration with PowerBI reports.
- Analyzed complex retail data, created dimensions and fact tables.
- Created mapping documents to translate business requirements to technical design.
- Automated table physicalization process by directly converting Source to Target Documents into JSON files, to be uploaded to Azure Repo. This reduced the physical model creation time by 6 hours per table enhancing error handling and resource utilization by %.
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.
- Loaded data into external stage in Amazon S3 buckets.
- Created Matillion orchestration using Change Data Capture to load data from Snowflake landing tables to target tables.
Data Integration Analyst
Cognizant USA
06.2019 - 11.2019
- Designed and developed the presentation layer from Denodo raw layer in order to visualize KPIs like Coverage, Projected rent growth, Time to monetization etc for real estate client.
- Analyzed existing Denodo VQL queries to identify opportunities for improvements.
Graduate Research Assistant
University of Illinois at Chicago
09.2017 - 05.2018
- Built a web-based chemistry visualization tool as a part of The Connected Chemistry Curriculum that visualizes various chemical reactions in real time impacting over 2000 students and 25 schools
- Designed and developed SQLite based database for the application.
Software Analyst
Accenture Services Pvt. Ltd
12.2015 - 04.2017
- Spearheaded all phases of software development life cycle for Marketing Analytics application using Ab Initio worth over 10 million dollars
- Developed a system to receive real time transactional data coming from the Online Quoting System
- Created fact and dimension tables to capture the data
- Developed Business Intelligence reports which capture information regarding throughput, cross-sell and purchase methods
Associate Software Analyst
Accenture Services Pvt. Ltd
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
Bachelor of Engineering - Electronics and Telecommunication
University of Nagpur
Skills
Data Analysis : SQL, Python (nltk, re, NumPy, SciPy, Pandas, Streamlit)
undefinedTimeline
Data Architect
Tiger Analytics, PepsiCo
01.2022 - Current
Consultant
Hangar Worldwide, Ralph Lauren
11.2020 - 01.2022
Data Integration Analyst
Cognizant USA
06.2019 - 11.2019
Graduate Research Assistant
University of Illinois at Chicago
09.2017 - 05.2018
Software Analyst
Accenture Services Pvt. Ltd
12.2015 - 04.2017
Associate Software Analyst
Accenture Services Pvt. Ltd
07.2014 - 12.2015
Master of Science - Management Information Systems
University of Illinois Chicago
Bachelor of Engineering - Electronics and Telecommunication
University of Nagpur
Similar Profiles
ARPITA SAHAARPITA SAHA
Senior Data Modeller at Tiger Analytics, PepsiCoSenior Data Modeller 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