Sayani Chatterjee

Sayani Chatterjee

Senior Technical Lead

Followers of Sayani Chatterjee556 followers
location of Sayani ChatterjeeWestborough, Massachusetts, United States

Connect with Sayani Chatterjee to Send Message

Connect

Connect with Sayani Chatterjee to Send Message

Connect
  • Timeline

  • About me

    Integration Architect | Data Integration Expertise in Boomi | Boomi 3X Certified | Data Driven | Continuous Improvement #BoomiCertified

  • Education

    • Kamala girls' School, Kolkata, India

      -
    • Heritage Institute of Technology, Kolkata, India

      2003 - 2007
      BTech Electronics & Communication Engg
  • Experience

    • Wipro Limited

      Jul 2007 - Jan 2018
      Senior Technical Lead

      Working as an on-shore Project Lead and leading a team of 5 offshore members for a major off-price retailer in US. Designing and developing robust data warehousing solution. Designing MDM layer and extensive snowflake data model to aid operational and financial reporting of the company. Liaising with business and client for different technical and business requirements. Preparing weekly project reports.

    • Veolia North America

      Aug 2020 - Dec 2024

      • I am part of a team of skilled application support professionals to triage issues on internal and external applications offered to our business.• End-to-End handling of the Integrations and Architecture of the integration models• Detailed configuration of Dell Boomi Atom Clouds, local Atoms and Molecules enabling integration landscapes for the proposed architecture for integration processes. • Integration of multiple in house and cloud based systems, multiple Enterprise platforms such as SalesForce CRM, SAP, Hubspot, ADP, Servicenow and SAP Ariba, SAP Concur etc. On-Demand as parts of solutions in Linux and Windows environment.• Creating datalake and Datawarehouse in AWS Redshift, integrating SAP data with Boomi through API• Help build and support new integrations between applications and data stores (Data Warehouses, Universal Data Stores etc.)• Designing and developing complex data integration pipelines in Boomi• Focus on continuous improvement by building SLAs and collaborating with the business to better assist them• Manage Unix/Linux based servers (Mainly OEL Red Hat).• Create and Troubleshoot FTP/SFTP job automation across platforms• Manage BOOMI automation in production environments. Built BOOMI automation scripts• Work with a team of dedicated Data Architects to translate and integrate data into Redshift and Oracle databases.• Creating and manage report generation environments using tools such as Sidense, PowerBI• Job creation and management within Dollar Universe Software Suite• Automating transfers across interfaces using Batch, Powershell, Shell, and Crontab• Programming in languages including: Groovy, Python, Batch, Powershell and JavaScript, SQL• Supporting applications include: BOOMI, $Universe• Supported Operating Systems include: Linux, Windows• Databases include: Oracle, Amazon Redshift, Amazon RDS Show less • End to End Analysis, design and development of Procurement Spend Cube data model and dashboards• Understanding the Dashboard KPIs and building the data model accordingly• Understanding methodologies for Requisition, PO, Invoicing for different business unit and integrating the data from SAP, Ariba, Concur using API, SFTP etc. via Boomi to the data lake.• Analyzing the data in AWS Redshift and report development in Sisense.• Working with multiple business teams in transversal functions and BUs to analyze spend data and derive spend patterns for increasing procurement efficiency.• Programming in languages including: Groovy, Python, JavaScript, SQL• Supporting applications include: BOOMI, $Universe• Supported Operating Systems include: Linux, Windows• Databases include: Amazon Redshift Show less

      • Integration Architect

        Jul 2022 - Dec 2024
      • Senior Integration Analyst (Procurement)

        Aug 2020 - Jul 2022
    • Slalom

      Jan 2025 - now
      Senior Integration Consultant
  • Licenses & Certifications

    • Solace Certified Solutions Consultant

      Solace
      Apr 2025
      View certificate certificate
    • Boomi Certified Professional Integration Developer

      Boomi
      Jun 2024
    • Solace Certified Event Driven Architecture Practitioner

      Solace
      Mar 2025
      View certificate certificate
    • Boomi Certified Integration Architect

      Boomi
      Jun 2024
    • Automation Pro III Certificate

      Workato
      Jun 2025
      View certificate certificate
    • Boomi Certified Associate Integration Developer

      Boomi
      May 2024
    • Solace Certified Developer Practitioner (Level 1)

      Solace
      Apr 2025
      View certificate certificate
    • Automation Pro II Certificate

      Workato
      Jan 2025
      View certificate certificate
    • Automation Pro I Certificate

      Workato
      Jan 2025
      View certificate certificate