SUMMARY:

• Over all 14+ Years of IT Industry experience along with 8+years’ extensive experience of Salesforce CRM application on Classic and Lightning.
• Strong experience of SFDC standard Data structures and familiarity with designing Custom Objects and Force.com platform and Force.com Sites.
• Extensive experience using Salesforce Administration, Profiles, Creating Roles, Page Layouts, Security (Org - Wide default, Sharing rules) and Authentication Work Flows, Approval Workflow, Reports/Graphs and Dashboards.
• Strong Implementation and Integration experience using Custom objects, Triggers, workflows/ workflow rules, approvals, S-Controls, Visual Force Pages, and Apex classes, Chatter.
• Experience in Sales cloud, Service cloud and Customer Portal.
• Experienced in integration of Salesforce.com with external applications by using Web Services API, Metadata API, SOAP, and IBM web sphere.
• Experience in wide range of languages and technologies such JSP/JSF, AJAX, Spring MVC Framework, HTML5, CSS3, JavaScript, XML, and SOAP.
• Certified DEV401.

TECHNICAL SKILLS:

Force.com: Apex Language, Apex Classes, Apex Triggers, AppExchange, SOQL, SOSL, Platform Visual Force (Pages (Lightning), Components & Controllers), Chatter, S-Controls, Apex Web Services, Batch Apex,AJAX, Workflow & Approvals, Validation Rules, Dashboards, Reports, Analytic Snapshots, Custom Objects, Force.com Eclipse IDE Plug-in, Sales Cloud and Service cloud.

Languages: Java, C, XML, HTML5, SQL, JavaScript, JQuery, CSS3.

Database: Oracle 10g/9i, MS SQLServer 2005/2000, UDB DB2, MySQL, MS Access 2007/2000

PROFESSIONAL EXPERIENCE:

Confidential, Westbrook, ME/San Francisco, CA

Salesforce Admin/ Developer

Responsibilities:

• Creating new user accounts and assigns proper user based controls related to access. 
• Managing Salesforce user requests, system troubleshooting, and system escalations, & manage third party consultants on systems integration projects.
• Assisting other departments to develop new workflows to improve efficiency or assist in the modification of current Salesforce workflows. 
• Maintain and customize all aspects of the Salesforce platform including objects, fields, layouts, security, reporting, validation rules, workflows, data manipulation and migration.
• Create Email templates, approval processes, and define approval actions for task automations. 
• Developing new queues based on business need.
• Working with Salesforce objects such as Accounts, Contacts, Leads, Contracts,Activitiesand Reports.
• Extracted and Imported Data from existing system by using Data Loader tool.
• Created reports based on various requirements in a timely fashion. 
• Developed and modified Controller Classes, extensions and Visual Force Pages for various functional needs in the application.
• Managing Salesforce configuration changes as per business request.
• Maintains data quality by identifying and deleting or merging duplicate records, cleansing and updating inaccurate data. 
• Clearly communicate status and open issues to team members and leadership. 
• Provide technical leadership and work effectively within a collaborative team environment to implement projects in a timely manner. 
• Responsible for access and data security within Salesforce. 

Environment: Sales Cloud, Service Cloud, Salesforce1 (Cloud1), Chatter,AppExchange, Chatter, Apex, Visual force Pages, Java Script, JQuery, HTML5, CSS3, Eclipse IDE, Data Loader.

Confidential, Bloomington, IL

Salesforce Admin/ Developer

Responsibilities:

• Followed Agile SDLC methodology throughout the life cycle.
• Collaborates with the business to prioritize key business/technical initiatives.
• Participating in project team meetings and communicated effectively with Architects, business analysts, project managers, quality control, and across other technology team boundaries, reporting project status as required.
• Created the Console on Service cloud and configured the all components on console.
• Worked with Business in creating user stories.
• Created various Profiles and Permission Sets, Role Hierarchy for Agents and Agent Team Members.
• Designed and configured Custom Objects, Validation Rules, Assignment rules, Queues and workflows as business. Implemented logic for migrating cases to different queues based on the type of customer enquiry.
• Worked on Case Management.
• Developed and configured various Custom Reports and dynamic Dashboardsfor different user profile (Agents and Agent Team members)based on the need in the organization.
• Created Sales Path (Salesforce1) for agents to make available other opportunities.
• Worked on Customer Portal (Cases), provided solutions for Customers raised cases in portal.
• Implemented Process Builder functionality to send Chatter post on Case close and also on Lead conversion.
• Developed Apex class and Triggers on SPI(Sensitive personal Information) feature.
• Developed Visual Force pages by using Lightning and also Used Java Script UI framework.
• Integrated the existing MPD data into Salesforce application by using REST API.
• Worked on high priority bugs, trouble shooting and fixing emergency issues.
• Developed Unit Test Scripts and completed all unit testing.
• Developed and prepared deployment packages.

Environment: Service Cloud,Salesforce1 (Cloud1), Chatter, Data Loader, Java Script, JQuery, HTML5, CSS3, Eclipse IDE, Data Loader.

Confidential, Troy, MI

Salesforce Developer

Responsibilities:

• Involved in Salesforce.com Application Setup activities and customized the apps to match the functional needs.
• Created Profiles and implemented Object and field level security to hide critical information on the profile users.
• Created users, roles, public groups and implemented role hierarchies, sharing rules and record level permissions to provide shared access among different users.
• Created Workflow rules and defined related tasks, time triggered tasks, email alerts, filed updates to implement business logic.
• Developed Apex Classes, Triggers,Visualforce pages.
• Technical accountability by identifying and deleting unused fields, workflows, validation rules, reports, dashboards, objects and users. 
• Customized Canvas on Chatter Feed to make available for the users.

Environment: SaleForce.com platform, Visual Force (Pages, Component & Controllers), Apex Language, Eclipse IDE, Canvas.

Confidential

Salesforce Admin/ Tester

Responsibilities:

• Create and customize Salesforce objects, workflows, page layouts, fields, validation rules, reports, dashboards, and user profiles. 
• Followed good development practices by testing changes within the Salesforce sandbox before deploying to production.
• Simplified and reduced technical responsibility by identifying and deleting unused fields, workflows.
• Maintain data quality by identifying and deleting or merging duplicate records, cleansing and updating inaccurate data
• Contributed the implementation of security practices by monitoring login and user activity, de-activating unused users, and auditing field and profile access and security permissions.

Environment: SFDC toolkit (Visual force, Apex, S-controls, Triggers, Chatter),Data Loader, Eclipse IDE, Permission Sets.

Confidential, Wooster, Ohio

SQL Server / SSIS / SSRS Developer

Responsibilities:

• Continuously interacted with end user to gather business requirements.
• Build SSIS Master and child packages for initial load of data and incremental (monthly) loads of data for small data marts.
• Managed the ETL function and use of staging tables.
• Intensively used SQL Server Integration Services to create the extraction and loading process.
• Develop ETL specifications, source to target mapping and other documentation required for ETL development.
• Performed data conversions from Different types of data sources into SQL server using SSIS.
• Created packages that use several control flow and data flow tasks.
• Generated different types of Reports like Tabular, Matrix and Charts.
• Created stored procedures and user-defined functions for different Reports.
• Deployed and configured the reports in the Report Server.
• Created Subscription of Reports in different formats like pdf, excel etc. to be executed automatically on weekly or monthly basis.
• Created complex correlated sub queries to generate reports.
• Responsible for Full Report Cycle including Authoring, Managing, Security and generation of Reports. Maintained report security by creating Service Accounts and Security Groups and configuring in the Report Server.

Environment: MS SQL Server 2008 R2, MS SQL Reporting Services 2008 R2, T-SQL, SSIS 2008 R2.

Confidential, Schaumburg IL

SQL SERVER / MSBI Developer

Responsibilities:

• Involved in requirements gathering, analysis, design, development, change management, deployment.
• Analyzed the specifications provided by the client and gathered the requirements for design and development
• Designed, developed and deployed Business Intelligence solutions using SSIS, SSRS
• Wrote complex PLSQL queries using Joins and Sub queries and Functions to retrieve data from data sources.
• Developed SSIS packages bringing data from diverse sources such as Excel, SQL server, flat files, Oracle DB for the daily load to create and maintain a centralized data warehouse.
• Designed and configured SSIS packages to migrate the important data from Oracle, legacy System using various transformations.
• Scheduled and monitored the SQL Server Agent jobs to run the SSIS packages and stored procedures. Validated and tested all packages on development server.
• Coding, troubleshooting and performance tuning SQL and complicated SSIS packages.
• Generated customer reports using SQL Server Reporting Services 2012/2008R2from the OLTP data sources. Designed and deployed reports with Drill Down, Drill Through and Drop down menu option and Parameterized and Linked reports.

Environment: SIS, SSIS, MS SQL Server 2005/2008, MS Office Access 2003.