SUMMARY

• Around 10+ years of experience in Software Development Life Cycle (SDLC) which involves requirement gathering, analysis, design, developing, administrating, implementation & enhancement of Projects in both SalesForce.com in Sales Cloud, Service Cloud, Marketing Cloud and HEDA Education Data Architecture along with experience in ETL tools, Oracle Eloqua.
• Exceptional experience in Salesforce Architecture, Design and Development and Proficient in Salesforce developer toolkit including Apex Classes and Triggers, Visualforce Pages, Force.com IDE, Migration Tools.
• Thorough knowledge of data management, SQL and RDBMS technologies, SOA design principles
• Good expertise in SOQL, HTML, XML, JavaScript, SQL, REST & SOAP - based web services
• Amazing ability to integrate business processes across disparate systems
• Experienced in interacting with business users and executives to identify their needs, gathering requirements and authoring Business Requirement Documents (BRD), Business System Design Documents (BSD).
• Experience in Administration, Implementation and support experience with Salesforce.com platform along SF communities.
• Enabled Salesforce Communities, Managed the Community to view dashboards for groups, members, feed activity, and license usage, and manage the community’s reputation system.
• SFDC Configurations/Customizations - User Interface, Page Layouts, Tabs, Custom fields, Custom objects, Validation Rules, Triggers etc.
• Extensive experience over creating workflows, approval processes, validation rules and sharing & security rules.
• Working knowledge in generating Reports, Dashboards, customized reports and analyzing the data in Sales Force.
• Data Load for SFDC Standard objects and Custom objects, Using data tools - Data Loader, Excel Connector, Import Wizard, Zapier for middleware and SFDC Data Export and Mass Delete etc.
• Experience in managing full sandbox, developer sandbox.
• Strong Knowledge in AppExchange Applications for integrating with Third Party Applications as DocuSign, Drawloop
• Proficient in Data Migration from Traditional Applications to Salesforce Using Data Loader Utility and Informatica on Demand.
• Experience in working with Databases with Oracle and MySQL.
• Certified Jitterbit Foundation, Core Training from Jitterbit experience in connecting Salesforce with external systems
• Excellent domain knowledge on ERP Applications: CRM, Finance, Retail.
• Ability to quickly adapt and learn, work in-groups as well as independently with minimum supervision.
• Committed to excellence, self-motivator, quick-learner, diligent, team-player, and a prudent developer with strong problem-solving skills and communication skills.
• Experience in Object Oriented Analysis/Design/Development/Testing and Implementation, Client/Server Architecture.
• Bachelors in CSIT (Computer Science and Information Technology) @ JN Tech, University, INDIA

TECHNICAL SKILLS

Sales force.com: Apex, visual force, SOQL, SOSL, apex trigger, workflow and approvals, Process Builders, Custom Metadata, Email template, Validation rules, Sharing rules, Queues, Reports and Dashboards, Profiles, Roles, Apex data loader, Salesforce Workbench, Salesforce Data Migration, Ampscript, Journey Builder, Automation Studio, Email Studio, Web Studio, Content Builder, Marketing Cloud Connect, Salesforce Communities .

Web technologies: Java script XML, HTML, XHTML.

Database: SQL server 2008/05/2000 , My SQL, DB2.

ETL Tools: Informatica Data Loader, JitterBit Studio 9.3

PROFESSIONAL EXPERIENCE

Confidential

Salesforce HEDA (Education Cloud for HigherEd) Developer

Responsibilities:

• Education Cloud empowers institutions to achieve a connected campus vision and allows schools to better serve the needs of their students, staff, alumni and donors.
• EDA Education Data Architecture is an open source and captures a 360-Degree view of your students, community-driven data architecture built to configure Salesforce out of the box for the full K-20 student lifecycle.
• Designed to be flexible and scalable data architecture for institutions of all sizes.
• Recruitment and Admissions, to Find, engage and enroll best-fit students. Find and Connect with Prospective Students.
• Student Success, Created a 360° Prospect Profile for all of your prospective student and application data available in one place, anytime, anywhere to Identify At-Risk Students, Align Staff to Help Students and easy Navigation
• Deliver Personalized Communications and build personal relationships at scale by mapping engagement experiences that span email, SMS, web, and more. Move prospective students along a meaningful journey towards your institution, including pre-advising to ensure they succeed on Day 1.
• Track Your Progress easily monitors how you’re doing against your goals, from managing your funnel to projecting net tuition revenue. Build, view, and deliver reports and dashboards yourself, reducing your reliance on your college’s IT department.
• Created a List of Prospective Students to Recruit, List of Graduate School Candidates, Use Relationships and Affiliations to Build a Network and Customized Alumni Reports.
• Created Accounts and Affiliations, Relationships Between Contacts, Programs and Program Enrollments and Courses, Course Offerings, and Course Connections
• Developed Salesforce training videos, How to Doc s and other on-boarding materials and immediate delivery of training.
• Migration & Integration of student data from Banner into Salesforce through nightly jobs via Middle-ware Zapier middle-ware appln.
• Conversion of email campaigns from Banner BRM legacy system to Oracle Eloqua and updating preferences in sales, service and Eloqua. Setting Up and Managing Salesforce Communities from Enabling to Deploying into Prod.
• Upgraded all the CRM related transition of current web forms to Eloqua forms to capture leads.
• Develop and implement Salesforce and Eloqua reports to measure the efficacy of each campaign and incorporate trend analysis, linking public website behavior into reporting
• Improvements to Banner-to-Salesforce integration / Salesforce-to-Eloqua integration to enhance and streamline campaign management, Enhancing Campus Tour capability and Assist with the development of new Eloqua campaigns.
• Web-forms data is integrated through Zapier, which moves your data between Salesforce and hundreds of other apps and connects Salesforce to all the web apps you use the data in Salesforce and all related clouds.
• Updated Org-Wide Community Settings, Community Setup Basics, Customize Login, Self-Registration, and Password Management for Georgian Community.

Confidential

Salesforce Marketing Cloud Developer

Responsibilities:

• Good knowledge of Salesforce Marketing Cloud with technical expertise & experience along with Comprehensive AMP Script & SQL experience.
• Salesforce Marketing Cloud Design, Implementation and Administration Experience.
• Connecting Accounts with Marketing Cloud account to the corresponding Sales or Service Cloud org at the account level to continue Marketing Cloud Connect setup.
• Built journeys using the journey activities with Entry Source: audience selection, Decision Splits, Engagement Splits, Exit Criteria, Testing journeys, Activate journeys, Update Contact activities, Wait/Wait until steps Joins.
• Email Studio which includes building data extensions and lists, importing and exporting data in and out of marketing cloud, building triggered and user-initiated emails, building reports to track email performance.
• Automation Studio which includes building automations and monitoring them, understanding how to best use activities mostly SQL Query, Filter, Data extract, import file, publish audience and send email.
• Audience builder which includes building segmentation, applying filters and exclusions, creating attribute sets and appending them, publishing audience which can be used by business for marketing campaigns.
• Create & Connect Marketing Cloud API User to the Salesforce system user to enable core system communication activities in SFMC Connect, it includes pushing tracking data from the SFMC into your Sales or Service Clouds and then assigned Business Units for Marketing Cloud Enterprise 2.0 accounts.
• Lead the deployment of complex and dynamic data-driven email marketing campaigns within expected timelines from set up to testing, to live launch.
• Experience with REST API, AMP script, Audience Builder, Content Builder, Contact Builder, Journey Builder, Marketing Cloud Connect, and Data Extensions.
• Experience building Responsive Email Templates and designing and executing campaigns.
• Set up data imports, exports & segmentation filters and Implement personalization & dynamic content.
• Validating with A/B testing alongside Account Team for client UAT testing. Performance reporting, tracking & datapulls.
• Worked with vendor platform support and deliverability teams to proactively investigate and resolve client issues.
• Provide support and expertise to the Development Team in building, versioning and testing emails effectively based on campaign requirement.
• Understanding of Canada’s Anti-Spam regulation (CASL).

Confidential

Salesforce Developer and Salesforce Data Migration Specialist

Responsibilities:

• Successfully migrated data by Querying and Inserting SObjects (Campaign->Lead->Account->Contact->Opportunity) by following the sales objects flow.
• Reviewed business requirements and prepared data elements mapping for Salesforce Sales Cloud and Service Cloud.
• Documented business rules and implemented data transformations from Legacy Sytems, NetSuite Cloud ERP system and other Salesforce Orgs.
• Generated data quality reports and dashboards in Salesforce Classic and Lightning.
• Migrated reports, report types & dashboards between unconnected orgs and resolved data quality issues.
• Handled the deployment activities effectively using Blue Canvas, Metadata API and Change Set.
• Administered and managed data migration tasks utilizing Excel, JitterBit Data loader and Workbench. Managing all data migrations into Salesforce XBU from multiple sources, NetSuite and Other Salesforce Orgs
• Suggested database modifications and prepared training materials for end users.
• Analyzed data integrity issues and developed data migration templates and supported technical data solutions in adherence to business requirements using Jitterbit.
• Administered and managed data management, reporting services related to salesforce.com (XBU) from Salesforce Taliance (U.K), Salesforce Az (Australia), Salesforce Tax USA and Canada.
• Developed CR s & SR s in Salesforce, with strong proficiency in Apex, Visual force, and SOQL, and in-depth understanding of SFDC Profiles/Roles and Sharing Rules, Validation Rules, Workflow rules, and Triggers, etc.
• Designed and modified Approval processes and created Approval steps which used email alerts and field updates.
• Developed, supported and administrated Salesforce State and Country/Territory Picklists. Implemented for APAC, EMEA and AMER regions.
• Print and export reports; email and scheduled reports and refreshed dashboards.
• Debug Apex scripts using Debug Logs and System Log Console to catch Exceptions and check for Governor Limits.
• Used Organization security, Network-based security and Session security to implement platform security.
• Used Picklists, Dependent Picklists, and Record Types to enforce data quality.
• Used Tab permissions, Record Type permissions and Field Level Security to implement Component-based security.
• Configure the default login, logout, password management, and self-registration options for the org community. Or customize the behavior with Apex and Visualforce or Experience Builder (Site.com Studio) pages for SF Communities.

Confidential

Salesforce Developer

Responsibilities:

• Collaborated with business owners to determine the business model objective and facilitate the customer journey process from launch to implementation.
• Worked within the CRM Journey team to map out campaign logic, data requirements and workflows, and update these workflows as changes to business requirements occur.
• Proposed and leveraged best practices, A/B testing and modern communication trends to ensure max effectiveness.
• Developed, supported and administrated Salesforce sales, service cloud application.
• Worked with existing requirements from the business user and add new features as enhancements of existing features in the application.
• Solid experience in connecting Salesforce with external systems via API (REST) and data integration using Jitterbit(ETL tools) and Workbench, data loader etc. to connect with databases and to collect data from various sources to make it available for Salesforce and also other way around (from Salesforce to database) for reporting and analysis purpose.
• Provided daily production technical support of CRM technology 24/7 support and On call support to business stakeholders in investigating and fixing SFDC application production issues and deploying hot fixes during upgrade/fixes
• Worked with SFDC administrative tools such as managing users, Bucher and Sutton packaged licenses for call centers, data management, generating reports, dashboards and communication templates.
• Developed and deployed new and modifying existing custom fields/objects, workflows, and user roles
• Created new scheduled batch process to Activate or Deactivate, delete Dealers, Customers status, pins and vin validation as per business requirement using Apex Scheduling, Batch processes, Apex Class controllers & Triggers by considering the impact on Governor Limits
• Configuration & release management using change sets in Salesforce.com and other deployment, versioning control (GitHub) and continuous integrations tools such Git, Github Enterprise.
• Develop personalized communications to Confidential Canada customers for email, social and mobile channels. This will include the use of Sales Force Marketing Cloud, AMP Script and Journey Builder.
• Develop reporting and analytics requirements and work closely with the Research & Analytics team to analyze and measure marketing campaigns based on business requirements.
• Worked with the Digital Marketing and IT teams (Enterprise Architect and Salesforce Administrators) to support integration between Salesforce and Salesforce Marketing Cloud (Exact Target) to enable the organization to support its digital marketing initiatives

Confidential

Salesforce Administrator and Developer

Responsibilities:

• Analysis and Understanding the requirements & functional specifications.
• Development of the new APEX Classes, Apex Triggers, Visualforce Pages and deployment activities.
• Design Requirement documents and functional document for the development team.
• Created page layouts, record types, Workflow rules, Validation Rules, Sharing rules, Queues, Reports and Dashboards, Profiles, Roles
• Created Custom Controllers to make external web service callouts, validate and insert data.
• Created Custom Visualforce components and attributes to override the look and feel of standard Sales force UI.
• Created Visualforce pages that could be rendered as PDF's, build dashboard components and define email templates.
• Created Visualforce pages which identified a region to be updated to enforce partial page refreshes and display the status of Ajax requests to display different values depending on whether it is in progress or completed.
• Configured the Case Management Process.
• Deployed Apex using Change Sets and ANT tool.
• Integrated Apex with External services by making callouts that used SOAP and WSDL.
• Worked with Apex Scheduler to invoke Apex classes at regular intervals.
• Worked with Dynamic Apex to access SObjects and Field describe information, execute dynamic SOQL, SOSL and DML queries.
• Add methods that can be called from Visualforce pages to Controller Extensions.
• Implemented Visualforce pages with public-facing websites by using Force.com Sites.
• Used Visualforce in development mode to change the behavior and appearance of Visualforce components.
• Used Visualforce Templates and Placeholders to encapsulate page elements to be reused across several Visualforce pages.
• Used Tabular, Summary and Matrix reports to create Standard reports and Custom reports.
• Worked with Approval processes that used Email Approvals and Parallel Approval steps
• Created Dashboards and Dashboard Components and implemented multiple levels of Dashboards and scheduled Dashboard refresh.
• Created Many-to-Many relationships and created Junction objects to implement Roll-up Summary fields to aggregate data from child records on the parent.
• Designed Validation Rules along with Roll-Up Summary Fields to maintain data quantity and data consistency. Implemented relationship fields for proper data loading.
• Worked with Standard Controllers and record identifiers to implement automatic record retrieval and display/update a record's data, bind input fields to new records, display warning and error messages, create links for form processing, place command buttons and create custom messages, implement nested Visualforce pages.
• Worked with Methods to insert and update records without re-directing users to a new record.
• Fine tuning the existing process and giving potential solutions for Business problems
• Analyzed business flow of document. Coding the program as per the client specifications mentioned

Confidential

DWH- Database Analyst & Salesforce Developer

Responsibilities:

• Involved in Requirement analysis, developing application involving Apex classes and SOQL/SOSL Queries.
• Quality SPOC for the QC activities, Implementing Workflows, Validation Rules within SLA.
• Analyzing the work requests/Incident Reports from the customers
• Used Apex Data Loader to Manage and Query the data.
• Configured Identity Confirmation and Login Restrictions, User Interface settings, Company Profile, Customized Profiles and created custom fields
• Worked with standard objects, business processes and field-level security
• Created/Modified Dependent Picklists, Lookup Fields, Formula Fields, Roll-up Summary Fields, Page Layouts and Record Types
• Set security and access rights using Organization Wide Defaults, Roles, Roles & Hierarchies, Sharing Rules, Public Groups, and Folders.
• Performed data validation and use data utilities including Data Loader and Mass Delete
• Configured and used standard reports, custom reports and custom report types
• Configured and used dashboards and dashboard components.
• Set up Salesforce Console functionality and navigation, Configured custom objects, applications and tabs
• Installed/Uninstalled packages from AppExchange and Manage tasks, events, public calendars and multiday events.
• Added custom fields and validations to new and existing objects and added custom functionality using custom controllers and custom extensions.
• Used workflows to govern data flow across various objects and modified simple workflows to incorporate Email Alerts and Field Updates
• Defined lookup and master-detail relationships on the objects and created junction objects to establish connectivity among objects.
• Used sandbox mode for testing and migrated the code to the production instance in installments.
• Worked with Global variables and expression language syntax to manipulate data types for conditionally executing operations
• Laid the groundwork for the Force.com platform by creating custom objects, fields, tabs and filled object data using Data Loader.
• Prepared and Maintained HOW TO DOC used by all the Business Users and testers which involves new/updating tables, extracts(flat files),packages and procedures, schedulers and business reports built on Cognos Mainframes.
• Loading huge volumes of data and ETL processes, Client Server Applications, Front and Back End development with Unix and SQL,SQL scripting to check reports data integrity before and after code changes and performed manual and automated data set-up, configurations and data load Life Cycle.
• Worked heavily with relationship database models, schemas entity-relationship diagrams (ERMs) to create technical/system design documents.
• Building/Developing Oracle Tables, Triggers for supporting other activities i.e. for data validations, similar to that of the client’s database. Using SQL LOADER, Imports UTL files based on multiple file formats using UNIX, file conversion from EBCDIC to ASCII and SQL Developer for validation of all columns with different data types.
• Validating data, setting up of data and creating and following the business logic and working and co-coordinating with Dev.’s, DBA’s in order to run ETL’s for data migration testing all the transformations are as per the business logic complete data validation.