RISHAVCHATTERJEE

Key Achievements:

• Initiated B2B analytics reporting with key insights through Funnel Analysis, Forecasting, and more
• Optimized Programmatic Advertisers pipeline, reducing processing time by 60%
• Executed NetSuite invoice data integration with Salesforce
• Led migration from Qlik Sense to Python for Datorama nPrinting
• Implemented data-driven decision making across business units leading to 25% increase in revenue
• Architected cloud-based data solutions that reduced infrastructure costs by 30%

Key Achievements:

• Expertise in designing and developing micro services, REST APIs using python.
• Rich work experience in Open Source frameworks like Apache Spark, Airflow and Flask framework.
• Have good knowledge of AWS services i.e. Batch, Glue, Lambda, S3, Redshift, DynamoDB, and DMS.
• Good experience in conducting proof-of-concept and developing prototypes.
• Have working knowledge of JIRA, Azure DevOps for project management and collaboration.
• Have knowledge of Docker.
• Hands on experience with Python, SQL, HTML, Shell Script and JavaScript.
• Used GITLAB, GITHub, Bitbucket as a code repository and versioning.
• Good understanding of Algorithms, Data Structures and Design Patterns.
• Working knowledge in Relational Database Systems like SQL Server and PostgreSql.
• Work experience on Windows, Linux and UNIX environment.
• Proficient with XML related technologies.
• Implemented CI/CD through Jenkins.
• Good analytical and programming capabilities coupled with excellent decision making skills.
• Excellent team player and ability to perform well under pressure.
• Good documentation skills and excellent technical, Communication and Interpersonal Skills with strong Client Interfacing Skills.
• Conducting/Attending regular Conference Calls to gather requirements and preparing MOM for the activities.
• Responsible for Analysis discussions with the end users, getting signoff, plan, lead, manage and execute a conversion process to move the existing lotus notes to development, UAT and Production deployment.
• Implemented/developed policies and procedures, standards and best practice methods.

Key Achievements:

• Migrated from HIVE to Snowflake, increasing pipeline performance by 60%
• Orchestrated jobs using Apache Airflow and Alteryx, improving system speed by 40%
• Maintained 99.5% data accuracy with 9.5/10 stakeholder satisfaction
• Led team of 3, collaborating with 15+ data vendors and 10+ brand leaders
• Led Data Integration for 15 brands and 50+ dosages from 20 vendors; processed over 100GB of structured and unstructured data
• Developed sales and demand forecasting dashboards using custom models like the Elapsed Days Model and moving average method
• Automated previously manual data ingestion pipelines, reducing processing time significantly
• Currently automating National Demand Reports using Qlik, Alteryx, SQL, and Python
• Built QA dashboards to monitor data quality and monthly sales projections for Oncology brands

Key Achievements:

• Worked with Jubilant FoodWorks to reduce production pipeline execution time by 66%
• Migrated IndiaMART's on-premises system to AWS
• Delivered automated prediction model workflows for Reckitt Benckiser using Azure Databricks
• Successfully started cloud-based services as a new vertical for the organization