Sayani Dutta
	 Phone:+91-8250245969
Email: sayanisfdc@gmail.com
 
5X Certified Salesforce Admin/Developer 

SUMMARY
	             
•	+7 Years of IT Experience in various database technology and tools. Currently, Working as Data Architect, India .
Great Experience on salesforce data migration in CPQ, Salesforce veeva using DBAMP and SSIS 
•	Good Experience in handling complex project with Large data
volumes (300M ) -Like IOPP, Perkin Elmer, EDF Energy, UK.
Have worked on +5 Migration projects migrating data into salesforce environment.
•	Have a good experience of salesforce complete architecture and error handling.
•	Data Architect Certified, App Builder Certified , ADM Certified ,
Tableau CRM & Einstein Discovery Consultant .
•	Played multiple roles on different projects - Data lead, Data
consultant, SSIS Developer.
•	Done migration using other tools like – Launch box, Salesforce Inspector ,Data loader,SSIS.
•	Did Data Migration to various Platform  like Flat files to SQL,SQL to Salesforce,XMLs to SQL. Various platforms to salesforce  CPQ org..
•	Good Understanding on Salesforce CPQ like -Contract, Subscription, Asset etc
•	Good experience of handling multi-lingual data in databases and salesforce migrations.
•	Good knowledge of Sales Cloud, Service Cloud and supporting the applications.
•	Worked on Triggers, Apex classes, Asynchronous Apex (Batch, Queueable, Future, Schedulable)
•	Experience in Agile methodologies
•	Proficiency in SFDC Administrative tasks like Creating Profiles, Roles, Process builder, Users, Page Layouts, Email Services, Validation Rules, Approvals, Workflows, Validation rules, Reports, Dashboards.
•	Experience in writing Stored Procedure, debug stored procedure in SQL.

TECHNICAL SKILLS:

Salesforce Technologies	Data Loader, DBAMP, Salesforce.com customizations like Workflow Rules, Role Hierarchy, Validation Rules, Formulae, Custom objects, Page Layouts, Record Types,	
Salesforce Tools	Salesforce inspector, App Exchange Data Loader, Data Loader, work bench.	

EDUCATION

•	Bachelor of Technology, Netaji Subhash Engineering College-West Bengal, India. 

CERTIFICATIONS

•	Salesforce Certified Data Architect
•	Salesforce Certified Administrator (SCA)
•	Salesforce App Builder
•	Tableau CRM & Einstein Discovery Consultant
•	Salesforce Associate
•	Internet of Things and Embedded Systems, by University of California, Irvine
•	SQL Tips, Tricks, & Techniques

CURRENT ORGANIZATION:
Wipro

   
PROFESSIONAL EXPERIENCE:

Project: Salesforce

Client: IOPP   
July'2022– Till Now

Client:perkinelmer                                                   Jan'2022– July'2022

Role :
Data Architect

•	SFDC data lead on Global Client site and involved in Complex  requirement gathering sessions.
•	Multiple Data migration to Complex system like CPQ, Salesforce Service cloud and Sales cloud

•	Conducting gap analysis of system functionality and target requirement design review with architects.

•	Taking ownership of functional issues by identifying underlying problem and analyzing potential solutions including feasible workaround and leading the offshore data team with daily interaction to ensure progression on timely.

•	Manage activities between customer, senior management, implementation team, development team and support team to resolve initial implementation and post go live.

•	Configure custom objects, custom fields entity-relationship data model, formula fields, page layout, record type and custom tabs to suite to the need of application.

•	Worked on Apex Classes, visual force pages, Triggers, Asynchronous Apex (Future, Batch, Schedulable, Queueable), Workflows, Process Builder, Lightning and SFDC Configuration to meet the Functional requirements.

•	Preparing project/ Mock cutover plan that contain overall system dependencies in sequence considering actual Go Live.

•	Planning UATs, Regression, Key user training, Go-live/ Post Go-live hyper care and support Handover.

•	Planning/ maintaining deployment activities, legacy system integration, data migration, custom reports, and data cleansing.

Project:Salesforce
Client:BAYER                                                                                    Nov’2018– Dec 2021 

Role:Developer
Project Description:

Role: Salesforce.com  Admin /Dev
Project Description:
We have built Salesforce.com for the Pharma Company Bayer to maintain their records of sales, sales representative, doctors, hospitals etc. and integrated with different systems to load information into this application.
Enhanced  Salesforce Service cloud and Community portal for online customers (where the customers can register themselves) and the business support and technical support. Web-to-case, email-to-case was configured for case management. This project includes Sales , Service and production Support as well.
This application has been integrated with external systems like SAP, SQL using Informatica and web services.
Responsibilities:
•	Worked with Business Users and Business analysts for requirements gathering, analyzing the requirements.
•	Worked on Workflows, Process Builder and SFDC Configuration to meet the Functional requirements
•	Developed Reports and Dashboards, validation rules, formula fields for the application.
•	Created Page Layouts and assigning different layouts based on Record Types.
•	Worked on Triggers, Apex classes, Asynchronous Apex (Batch, Queueable, Future, Schedulable)
•	Created Custom Reports and Dashboards for the application.
•	Developed Workflow rules, Field, Email updates to implement the business logic for Standard and Custom Objects as per the business needs.
•	Used Dataloader , Batch Apex to bulk load data into Salesforce.com.
•	Configured/Created Profiles, Roles, and Permission Sets and sharings (all security controls) for the organization and setting up Field-level, Object-level security rules for the application.
•	Developed Visualforce pages using Apex for proprietary Salesforce application to track the flow of business
•	Created new custom objects, assigned fields, designed page layouts, custom tabs and components
•	Provided solutions to workflow issues and structured environment for ease of use
•	Created custom objects and its related reports/dashboards to hide data access from other profiles across the organization

Project: SSIS/SQL Developer
Client: BAYER                                                                                Sep’2015 – Aug’2018

Role: SSIS/SQL Developer and Data Analyst and support

Project Description:
•	Bayer  is an integrated energy company in the Germany, with operations spanning Pharma products  generation and the sale. It employs 13,331 people and handles 5.7 million customer accounts.

Responsibilities:
•	Involved in designing, developing and deploying reports in MS SQL server management -2008 and SSIS in Business Intelligence Development Studio(BIDS).
•	Using ETL(SSIS) to extracting, cleaning, transforming and loading data to database. 
•	Enhancing and deploying SSIS package to development server to production server. 
•	 Developed the SQL server integration service (SSIS) packages to transform data from SQL 2005 to MS SQL 2008 as well as created interface Stored Procedure used in SSIS to load/transform data to database. 
•	Designed SSIS to transfer data from flat file to database using Business Intelligence Development Studio.
•	Extensively used SSIS transform as looked up, derived column, Data conversion, Aggregate and Conditional Split, SQL task, Script Task, Send Mail task etc Used SQL Server Agent for scheduling jobs and alerts involved in installation and configuration of MS SQL server.
•	Ensure data quality by writing and executing procedures for cross checking totals and identifying data anomalies. Triage data related issues
•	Utilize various tools to evaluate performance and implement remedies to improve performance, including tuning database parameters and SQL statements
•	Assist in troubleshooting and impact analysis of any changes made to the database Objects
•	Optimize SQL performance, integrity and security of the project’s databases/schemas.
•	Contribute to the optimization of data management and performance tuning
•	Work as data steward in maintaining data integrity of transactional and referential data. 
•	Define & maintain business and technical rules for cleansing and maintaining data. Enforce data quality standards
•	Develop stored procedures to manipulate data
•	Clean, transform and model data to ensure and improve accuracy of metrics calculations
•	Create, modify and troubleshoot SQL queries, stored procedures and jobs

Personal Details:
•	Date of Birth		            :              01.02.1992			
•	Gender			:              Female	
•	Languages Known		:              English , Bengali , Hindi

Place:

Date