Somarita Chakraborty

At Accenture, my role as an Application Development Associate Manager blends scrum leadership with specialized proficiency in data migration, notably transitioning SQL servers to Salesforce with meticulous adherence to platform-specific regulations.

Over a span of 3+ years, I have spearheaded projects focusing on Snowflake Cloud and Generative AI, consistently leading teams to deliver cutting-edge solutions within the pharmaceutical domain.

• Conducted system analysis to gather requirements and develop user stories.
• Evaluated third-party dependencies to ensure seamless migration.
• Facilitated agile ceremonies: daily scrums, sprint planning, backlog maintenance, sprint review, and retrospective.
• Managed DataOps and Snowflake operations, resolving Talend job failures and data mismatches.
• Conducted weekly status calls to address project roadblocks and dependencies.
• Communicated project progress and challenges to stakeholders and clients.

Led a team in the migration of data from Microsoft Dynamics to Salesforce, focusing on ensuring data integrity and efficiency. Responsibilities included developing and executing complex SQL queries for data clean-up and remediation, creating detailed table mapping and migration documents, and optimizing existing stored procedures for data loading into Salesforce and SQL Server environments. Designed and implemented SSIS packages utilizing Kingsoft Salesforce add-on for incremental data loading into SQL Server, and developed dynamic scripts for effective data insertion, updating, and deletion during migration processes.

• Coached team members through new or difficult workflows.
• Professionally handled difficult customer complaints and objections to maintain first-class customer service standards.

I developed an SSIS package to automate the ingestion of third-party XML files into a SQL Server database, optimizing data flow and transformation processes. Responsibilities included gathering requirements from upstream and downstream users, creating high-level designs to align with requirements, and designing database schemas to accommodate vendor specifications. Additionally, I designed and implemented an application for user-friendly downstream team usage, ensuring seamless integration and data delivery. I conducted thorough unit testing across modules to ensure defect-free deliverables and prepared comprehensive KT documents and data flow documentation for user guidance and project continuity.

• Improved data integrity with rigorous auditing and cleansing.
• Analysed large datasets, drawing meaningful conclusions and providing actionable recommendations.
• Built, reviewed and maintained data models to meet business requirements.
• Coordinated cross-functional teams in delivering data input, extraction and analyses.