Sayani Chatterjee

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