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. This pipeline, reads data from over 54 mainframe sources via GoldenGate CDC software, Utilizes AWS Lambda as well as Snowpipe for ingestion and implements a complex type 1 processing within Snowflake to ascertain the most current records. This architecture is the foundation of our Snowflake EDW and also serves as a template for other Snowflake data applications/data pipes. • 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, SmartyStreets, RedPrairie, Neustar, Acqueon, Accertify, BrassRing etc, facilitating seamless data interchange and enhancing data utility across the enterprise.• 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 development time, learning curve and increased efficiency in our data engineering processes.• 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.•Other Collaborations: Collaborated with other teams to make enterprise data available to them.

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.• Provided "level 3 support" which included development of minor/major enhancements, defect fixes, and providing workarounds for technical problems.• Developed new ETL applications, maintained, supported, and improved the performance of existing applications in production.

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 technical challenges.• 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 Acxiom, Zillow, GNIIP, and Social Media web scraping.• 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.• Successfully developed a robust ETL and data aggregation engine, generating over 200 metrics across seven time slices.

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 enterprise.• 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 provided valuable insights for assessing profit/loss/revenue on a monthly or weekly basis, derived from both running contracts and Service Calls.• 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 to gauge performance in terms of Sales, margins, associate productivity across various time slices and location slices.