SUMMARY

• Over 9 years of IT industry experience in designing, development, testing and support.
• Has worked on multiple Salesforce Integration Projects in domains like banking, insurance, healthcare, retail.
• Has extensive experience in Salesforce integration and data migration with ETL tools like Informatica on Demand, Dell Boomi, Informatica Power Center, Jitterbit and Talend.
• Has worked on Informatica Power Center to integrate Salesforce and Oracle data base.
• Worked on Informatica transformation like Lookup, Filter, Aggregator, Sorter, Expression, Joiner, and Router.
• Worked on Informatica Power exchange for Salesforce and used transformation like Lookup, Picklist transformation.
• Worked on Informatica on Demand to for data migration and integration purpose.
• Created synchronization jobs and replication jobs in Informatica Cloud.
• Created mapping, Tasks and Scheduled the jobs.
• Used Jitterbit Harmony tool for data migration and integration with flat files.
• FTP server integration with Salesforce to transform and load data from XML file to Salesforce.
• Worked on Jitterbit proprietary scripting language for data transformation and used inbuilt function including DbLookUp, SfLookUp and DbLookUpAll. Also worked with local variable, global variable and project variables.
• Worked on Talend Open Studio for data migration from legacy application to Salesforce.
• Used inbuilt Salesforce connectors for bulk Salesforce data load and other inbuilt data transformation components.
• Worked on Dell Boomi to migrate the data from SQL Server to Salesforce with creating Processes, Data Mapping, Data Profile and Connections.
• Used Java Script to write transformation logic in Dell Boomi and used other components like Branch, Decision and Route.
• Used various components like Branch, Decision, Route, Program Command, Data Process and Set Property.
• Worked on Salesforce attachment migration in huge size using Salesforce Data Loader.
• Experience writing query with SQL, ORACLE, SOQL, SOSL, Relationships with Salesforce Lookups and Master - Detail.
• Has experience in Salesforce tools like Force.com Eclipse IDE Plug-in, Apex Data Loader, Force.com Platform (Sandbox and Production).
• Apart from integration has good understanding of Salesforce Platform including Configuration, Visual force, Workflow, Approvals, Process Builder, Validation Rules, Security management, Reports and dashboard.
• Leading the analysis and business requirements gathering to develop detailed functional requirements, clearly stating project scope.
• Interact daily with business units and business owners to understand business processes and key requirements, proactively work to resolve client issues.
• Gather, create and document current and future business process flows.
• Conduct analysis of systems specifications and use analysis / diagramming tools to represent business / technical processes.
• Perform application configuration, testing and evaluation to ensure quality and consistency.

TECHNICAL SKILLS

Salesforce Technologies: Apex, Visualforce, Workflow, Approvals, Process Builder, Validation Rules, Security management, Reports, Dashboards

Salesforce Tools: Force.com Eclipse IDE Plug-in, Apex Data Loader, Force.com Platform (Sandbox and Production)

ETL Tools and Salesforce Integration tools: Informatica on Demand, Informatica Power Center, Informatica Power exchange, Talend Open Studio, Dell Boomi, Jitterbit Harmony

Database: Oracle, SQL Server 2000/2005, PL/ SQL, MS Access 2013.

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

Salesforce Integration Developer

Responsibilities:

• FTP XML file integration with Salesforce using Jitterbit harmony tool.
• Reading complex XML nodes structure and migrating the data into multiple custom objects in Salesforce.
• Used Jitterbit scripting language for data transformation, custom filtering condition.
• Used all kind of functions like SFlookUp, DBlookup, DBlookupAll to read the data base and process.
• Used Salesforce request and response with in Jitterbit for error handling.
• Scheduling and monitoring the Jitterbit process for continuous integration.
• Data migration from SQL Server to Salesforce using Jitterbit tool.
• Configured the staging data base environment in SQL server compatible for Salesforce data model.
• Created all kind of process for Insert, update and Upsert operation in Salesforce.

Environment: and Tools: Salesforce, Jitterbit, SQL Server 2014, XML files

Confidential

Salesforce Integration Developer

Responsibilities:

• Legacy system data migration to Salesforce APTTUS CLM application to multiple Standard and Custom objects like Account, Agreement etc.
• PDF, Doc and excel Contracts migration to APTTUS CLM using Salesforce Data Loader.
• Used Informatica Power center 9.6.1 for data migration to Salesforce.
• Worked on Informatica Power Exchange for Salesforce plugin to get Salesforce connectivity and Salesforce related transformation.
• Involved in extracting the data from the Flat Files and Relational databases into staging area.
• Developed Workflows using task developer and workflow designer
• Used multiple transformation like Salesforce Lookup transformation, Picklist Transformation, Filter, Aggregator, Expression, Joiner etc.
• Worked on Flat files with Informatica, Salesforce Success and Error files management.
• Data modelling, Data analysis and Configuration of staging data base in MS Access.
• Configuration the Salesforce Org using Workflow, Approval Process, Validation rules, formula fields.
• Writing Apex controllers, Triggers and Visual force pages.
• Configured the Salesforce data model and security model.
• Designed architecture diagram and data flow diagram for project.

Environment: and Tools: Salesforce, Informatica Power Center 9.6.1, Informatica Power Exchange for Salesforce, MS Access, Salesforce Data Loader.

Confidential

Salesforce Integration Developer

Responsibilities:

• Salesforce integration with SAP and EDW application.
• Worked on Informatica power center to implement complex business logic.
• Created mappings using Designer and extracted data from various sources, transformed data according to the requirement.
• Effectively used Informatica parameter files for defining mapping variables, workflow variables, FTP connections and relational connections.
• Worked on Lookup, Filter, Aggregator, Sorter, Expression, Joiner, and Router, Normalizer transformation.
• Developed Workflows using task developer and workflow designer in Workflow manager and monitored the results using workflow monitor.
• Worked on Oracle server as staging data base to make data ready to move to Salesforce.
• Worked on Informatica on Demand to create synchronize data from Oracle server to Salesforce.
• Created synchronize jobs in Informatica Cloud to transfer data in bidirectional way.
• Created fields mapping, filter and look up logic.
• Worked on Informatica replication jobs to create table schema and as well as data into Oracle server.
• Created tasks in Informatica Cloud and created multiple schedules on daily and weekly basis.
• Worked on Oracle writing queries for unit testing.
• Analyzed the errors thrown by Salesforce from Salesforce Validation rules, workflow, Security management and triggers.

Environment: and Tools: Salesforce, Informatica Power Center, Informatica Cloud, Oracle, Flat files.

Confidential

Salesforce Admin

Responsibilities:

• Sales Cloud implementation using Account, Contact, Lead and Opportunity Management.
• Configured the data model and security model.
• Created the Reports, Dashboard and Analytic Snapshots.
• Developed various Custom Objects, Entity-Relationship data model, validation rules on both custom and standard objects, Components and Visual Force Pages.
• Developed Apex Classes, Controller Classes and Apex Triggers for various functional needs in the application.
• Developed validation rules to ensure the data integrity.
• Managed search layouts and created page layouts to organize fields, custom links, related lists, and other components on a record detail and edit pages.
• Created workflow rules and defined related tasks, time triggered tasks, email alerts, filed updates to implement business logic.
• Created profiles and field level security to hide critical information on the profile users.
• Created and executed the test cases covering various business use cases.
• Deployment using the Change Set.
• Created Functional Requirement Document and Technical Design Document.

Environment: and Tools: Salesforce, Apex and Visualforce Page

Confidential

Salesforce Integration Developer

Responsibilities:

• Migrated 40 GB of documents to Salesforce Notes and Attachment object using Data Loader.
• Created the strategy to make documents to relate to parents records from multiple objects.
• Used multiple machines to distribute the data load to Notes and Attachment.
• Data migration using Talend open studio from SQL server to Salesforce.
• Written the procedure in SQL server to encapsulate the logic to establish Salesforce objects relationship.
• Worked on various components tMap, tJoin, tFilter and tLogRow.
• Worked on SQL connection and Salesforce connector tSalesforceConnection, tSalesforceBulkExec.
• Using Talend Migrated data directly from Excel spread sheet taking as source to Salesforce.
• Worked on built in and repository schema, used OnSubJobOk and OnComponentOk to link the components and jobs.
• Written routines in Java language to process the complex business logic.
• Involved in designing the architecture of data migration stages.

Environment: and Tools: Salesforce, Talend Open Studio, SQL Server, Salesforce Data Loader.

Confidential

Salesforce Integration Developer

Responsibilities:

• Data migration from SQL Server to Salesforce using Dell Boomi AtomSphere creating Processes, Data Mapping, Data Profile and Connections.
• Created various transformation logic using Java Script, created lookup.
• Used various components like Branch, Decision, Route, Program Command, Data Process and Set Property.
• Co-ordination with onsite team to gather the accurate requirements
• Install and configuring the database.
• Configure data base connector using credentials.
• Creating the table and rows in data base and importing to Boomi.
• Getting the data from third party connector’s success factors, database and performing the tasks as per the client requirement.
• Created flows which includes the components -Mappings, Process and various other components.
• Created new environment like Test/Production.
• Deployed the build process in different environments like Test/Production mode.
• Involved in Unit testing.
• Configuration of Dell Boomi SFTP connections.
• Enable communication with application and data sources using connectors
• Used Document cache, Map components, Process properties and Dynamic Process properties.
• Execution of process from process properties, scheduling of process.
• Validated Requirements, technical feasibility and design consideration.

Environment: and Tools: Salesforce, Dell Boomi AtomSphere, SQL Server, FTP Server

Confidential

Salesforce Integration Developer

Responsibilities:

• Data migration with Informatica on Demand from Worldwide disparate legacy applications to Salesforce.
• Migrated data into Accounts, Contacts, Task and events objects.
• Created mappings, tasks flow, scheduling, and connections in Informatica Cloud.
• Implementation of data transformation using inbuilt Informatica on Demand functions.
• Worked on Salesforce look up and Flat file look up to bring the required data.
• Automation of flat files data migration process through batch script to move the files from Source directory to Target directory with system time stamp.
• Worked on Informatica pre and post command to invoke the batch script.
• Involved in thorough testing making sure data integrity and Salesforce relationship.
• Data cleansing, de-duping and merging with CRM Fusion’s Demand tool.

Environment: and Tools: Salesforce, Informatica Cloud

Confidential

Salesforce Integration Developer

Responsibilities:

• Veeva CRM Integration with Oracle database using Informatica Power Center and Informatica on Demand.
• Integration with Informatica on Demand creating mappings, tasks flow, scheduling, connections and filters for integration.
• Integration with Informatica Power Center Creating mapping to migrate data from Oracle, Flat files to Salesforce Org. Used expression, lookup to transform the data, created connection to Oracle server, monitored the jobs, and analyzed the error log files.
• Created mappings using Designer and extracted data from various sources, transformed data according to the requirement.
• Developed Workflows using task developer and workflow designer in Workflow manager and monitored the results using workflow monitor.
• Worked on Connected and Un-Connected look up.
• Deployment of the workflow among different environment using XML import and export provision.
• Configuring Primary Care functionality My Accounts, My Schedule, My Samples, Medical Events.
• Managing security, profiles, roles and territory management for Primary Care, Specialty Care, Medical Liaisons, and Outcome Liaisons representative.
• Functional and Technical documentation.

Environment: and Tools: Salesforce, Veeva CRM, Oracle, Informatica Power Center, Informatica Cloud.

Confidential

Salesforce Admin

Responsibilities:

• Developed various tabs, custom objects, validation rules on objects and tabs, components and Visual force pages.
• Created workflow rules, and defined related tasks, time triggered task, email alerts and field updates to implement business logic.
• Created profiles, permission set and OWD setting.
• Worked upon standard as well as custom reports, dashboards.
• Written test classes to check the 80-90% code coverage.
• SOQL queries to fetch the data used in Custom controllers.
• Created visual force pages using visual force components.
• Written controller, custom controller and extension controller using apex.
• Uploaded data using data Loader, created data mapping files, and formatted data.
• Written trigger on custom objects.

Environment: and Tools: Salesforce, Apex, Visualforce

Confidential

Software Engineer

Responsibilities:

• Worked on Electronic Medical Record System/Practice Management (Windows application) in using .Net technologies 3.5.
• Responsible for understanding user requirements, designing and developing the application.
• Involved in the development of Presentation Logic for GUI of ASP.NET pages.
• Used ADO.NET to interact with SQL Server Database.
• Used Asp.net validations Controls for side validations.
• Involved in the development of Family Member module
• Used Java Script validations for Compare Validation, Regular Expression validation.
• Involved in creation of stored procedures in MS SQL Server 2005.
• Worked on the modules implementing the business logic in C#.
• Worked on Fitnesse to tool for automation testing.
• Written .Net Classes for unit testing to be invoked by Fitnesse tool.
• Unit testing Module level.
• Acquired knowledge related to health care domain, US healthcare industry norms, HIPAA regulation, HL7 standards, US hit regulations.

Environment: and Tools: .Net framework, Fitness, SVN, SQL Server

Confidential

Programmer

Responsibilities:

• Designed and developed web and windows-based application on the .Net framework using C#, ASP.Net, SQL Server.
• Designed various web pages using HTML/DHTML/web server controls and applied client-side validation using Java Script.
• Prepared database using entity relationship diagram and normalizations and processing using ADO.Net/SQL Server (PL/SQL queries, functions, procedures, and indexes etc.).
• Enhanced, maintained and supported the web application.
• Written stored procedures, triggers using SQL in SQL SERVER 2005.
• Worked intensely on the User Interface.
• Developed Web Forms using C# and ASP.NET, Used AJAX in some Web Forms.
• Worked on Cascading Style Sheets and XML-Schemas.
• Implemented Template Columns for Custom Nested Grid Views
• Deployment of Application on Test and Production Server.
• Handled many production issues and enhancement to the existing live portals.

Environment: and Tools: ASP.Net, SQL Server, HTML