Somdeb Mukherjee Email & Phone Number

• Snowflake Data Architecture Development: Leading the creation, maintenance and enhancements of a layered data architecture for our enterprise data warehouse in Snowflake, incorporating a near-real-time data pipeline..
• HR Data Integration: Designed and deployed a data pipeline for integrating HR data into Snowflake, which subsequently provided a dual function as an access control lookup mechanism.
• Third-Party Vendor Integration: Successfully integrated Snowflake EDW with a wide array of third-party vendors/data providers including Responsys, Optizmo, HubSpot, Click, ServicePower, GreenMountain, UPS, Anaplan.
• Diverse Data Source Integration: Extended Snowflake EDW’s capabilities by integrating with various data sources such as APIs, flat files, databases, and FTP/SFTP, ensuring a comprehensive data ingestion framework.
• Snowflake Library Development ( WIP ): Pioneered the development of Snowflake libraries and modules in Python, aimed at streamlining and accelerating data integration tasks. This initiative has significantly reduced.
• Data Migration Activities: Led enterprise data migration activities from legacy systems to cloud, specifically managing end-to-end complex data migration from Teradata to Snowflake.

United States

• Supported deployment of solution, cut over planning, and execution activities
• Demonstrated expertise in Snowflake, AWS (Amazon Web Services), Matillion, Python, SQL, GCP (Google Cloud Platform), PLSQL, and SQL Tuning and Code Tuning/Optimization.
• Defined the migration strategy and plan and developed and delivered a detailed data migration plan.
• Managed a small team and the data and reporting analyst and oversaw / ensured delivery of all aspects of data analysis, data governance, data loading and data processing.
• Liaised with key stakeholders and system integration partners and identified the data migration impact of all proposed changes.
• Owned the quality of the migrated data and the validity of the migration processes and operation.

United States

• Orchestrated coordination between Architects, Data Modelers, Junior Analysts/Data Engineers, and Visualization experts to create scalable analytics solutions for various business units and top executives.
• Constructed data pipelines (using Teradata SQL) from diverse sources such as MySQL, Informix, Oracle, flatfiles, and web, and provided data to reporting solutions including Microstrategy and Tableau.
• Served as the subject matter expert for code maintenance and deployment, addressing user inquiries, conducting historical data refreshes, troubleshooting complex data issues, and assisting junior team members with.
• Managed the data mart for the Targeted Interactions group, incorporating data from various subject areas (Transactional, Profile, Demographics, Communications, Household) gathered through third-party sources like.
• Facilitated coordination on data-related matters and supplied data feeds to third-party analytics vendors such as Pikato (Retail Next) and Coherent Path Inc.
• Coded, modified, and deployed offers through the Unica Interact system across 130+ touchpoint channels for multiple business units.

India

• Spearheaded the creation of a robust, automated, and scalable ETL (data flow and transformation) engine that can be utilized across multiple projects. This engine later became the industry standard program across the.
• Designed and implemented an Interface program between CONTROL-M, an enterprise-wide scheduling tool, and personal desktop terminals. This initiative significantly improved Alert, Monitoring, and Support capabilities.
• Acted as an SME for Sears' SCORE (Service Contract Reporting) program within the Home Services BU. Developed an ETL process to deliver Services and Contracts related data at an Item and Customer Segment Level. This.
• Worked as Data Engineer/ Analyst to build automated QA process for Daily/historic data loading. This involved extensive Teradata Queries and Unix Shell Scripts to validate 150+ steps in ETL processing and 300+ metrics.