SUMMARY:

• Over 8 years of IT experience with 4+ years of experience with Salesforce Administration, configuration and development.
• Salesforce Certified Administrator (201).
• Salesforce Certified Platform App Builder .
• Experience with Salesforce Customization, Security Access, Workflow Approvals, Data Validation, Analytics, Sales Cloud and Service Cloud Administration in Salesforce.com CRM
• Experience in implementing various advanced fields like Pick lists, Custom Formula Fields, Many to Many Relationships, Lookups, Master - Details, Field Dependencies, Validation Rules, Work Flows, Approval Processes, Process Builder and Visual Flow for automated alerts, field updates & Email generation per application requirements.
• Developed SFDC Customized Reports, Dashboards and Processes to continuously monitor data quality and integrity.
• Proficient in all phases of Software Development Life Cycle (SDLC), which involves requirement gathering, requirement analysis, agile, functional design, implementation and enhancement of projects in SalesForce.com.
• Involved in project to understand the business needs and objectives of the system and interacted with the end client/ users and stakeholders, involved and gathered requirements for the integrated system.
• Developed Apex classes, Controller classes and Apex Triggers on Force.com platform to customize application per the functional needs
• Proficient in creating triggers, Apex classes, Visual force Pages, App Exchange Package & Custom Application, Sandbox data loading and Web services API for implementing web services in the application for access to data from different users.
• Strong knowledge on Administration setup, Apex, Visual Force and experience with different SFDC development tools like Force.com Eclipse IDE and integration tools like Apex Data Loader.
• Excellent work ethics, self-motivated, quick learner and team oriented. Continually provided value added services to the clients through thoughtful experience and excellent communication skills.

TECHNICAL SKILLS:

Salesforce.com: Apex, Visual Force, Triggers, Reports, Dashboards, Workflows, OWD, Sharing Rules, Profiles, Sites, Data Loader, Force.com IDE, Site.com, Packages, web service API, SOQL, SOSL, WSDL, Component & Controllers, S-Controls, Triggers, Custom Objects, Workflow & Approvals, Reports, Dashboards.

Programing Languages: HTML, CSS, Visualforce, Apex, PL/SQL.

Integration Tools: Data Loader, Force.com, Force.com Workbench,SSIS (SQL Server Integration Services).

Databases: SQL Server 2012/2008R2/2005, MS Access.

Interface Tools: Data Loader, SQL loader.

Operating Systems: Windows 95/98/2000/2003/ XP/windows7/8, OS X

Others: Microsoft Office (Word, Excel), SSRS (SQL Server Reporting Services),MS Visio, Force.com IDE and Force.com Migration tools.

PROFESSIONAL EXPERIENCE:

Confidential, Reston VA

Salesforce Administrator /Developer

Responsibilities:

• Involved in Salesforce.com Application Setup activities and customized the apps to match the functional needs of the organization.
• Perform detailed analysis of business and technical requirements and designed the Confidential by customizing various standard objects of SalesForce.com (SFDC) and other Platform based technologies like
• Managed and participated in all phases of the project, including Project Plans, Documentation, and Configuration.
• Developed Apex Classes, Controller Classes, Test Classes and Apex Triggers for various functional needs in the application.
• Integrated the Web Services by generating the necessary stubs from the WSDL file for extracting the data Used SOQL & SOSL with consideration to Governor Limits for data manipulation needs of the application using platform database objects
• Worked on various salesforce.com standard objects and custom objects.
• Designed, Implemented and deployed the Custom objects, Page layouts, Custom tabs and Components to suit to the needs of the application.
• Customized tabs among different business user groups and business centers.
• Created various profiles and configured the permissions based on the organizational hierarchy requirements.
• Created the workflows for automated lead routing, lead escalation and alerts
• Implemented various Custom Reports and deployed them for different business user levels.
• Implemented case management automation (on Case Object) to track and solve customer's issues. Implemented Email-to-Case entry and manual case entry for entering customer's cases in Cases Tab.
• Customized the Dashboards to track usage for productivity and performance of business centers and their sales teams .
• Worked on salesforce.com sandbox and production environments for development and testing and then to production environments.

Environment: Force.com Platform, Salesforce Enterprise Edition, Salesforce.com Custom/Standard Objects, Custom Tabs, Page Layouts, Workflow & Approvals, Reports, Security Controls. Visual Force (Pages, Component & Controllers), Apex.

Confidential, Bethlehem, PA

Salesforce Administrator/Dev

Responsibility:

• Played the role of Administrator and Analyst, involved in maintaining salesforce .com application user profiles, roles, permissions, generating security tokens, validation rules.
• Used Salesforce Automation (SFA) for Sales Lead Management, Campaign Management, Opportunity Management, Account and Contact Management.
• Customized Salesforce CRM beyond native functionality with Visual Force and Apex code according the requirements.
• Developed workflow rules and defined related tasks, time triggered tasks, email alerts, field updates to implement business logic.
• Created profiles and implemented object level, field-level and record-level security and managed roles, visibility settings.
• Created email templates in HTML and inbound emails using Visual force for the clients and customers portal.
• Designed, developed, deployed page layouts, components, custom objects, custom tabs, visual force pages to reach the needs of organization.
• Extracted the data from Salesforce.com application into the external databases for generating large data reports.
• Created users, roles, public groups and implemented role hierarchies, sharing rules and record level permissions to provide shared access among different users.
• Created various reports (summary reports, matrix reports, pie charts and dashboards) and Report Folders to assist managers to better utilize salesforce.
• Created various dashboard per requirement of the user and business need.
• Having worked on salesforce.com sandbox and production environments for development and testing and then to production environments.

Environment: Saleforce.com platform, Visual Force, Data Loader, Workflow & Approvals, Reports, Custom Objects, Custom Tabs, Email Services, Sales cloud, Data Migration, Security Controls, Sandbox data loading, Data Loader, Apex.

Confidential, Schaumburg IL

Salesforce Administrator

Responsibilities:

• Customized page layouts based on the record types for standard and custom objects.
• Implemented automation of business by developing workflows and approval processes.
• Assigned standard profile to new users based on requirements.
• Maintaining Role hierarchy for data access.
• Created OWD and then sharing rules including Owner to Owner (Role/Public Group) and criteria based sharing as per requirements.
• Implemented field level security and page level security based on the profiles.
• Worked on Page layout creation and page layout assignment based on the profile and assigning different picklist values to the different record types.
• Created Formula fields, Validation rules to maintain the quality of the data.
• Implemented Web-to-Case, Email-to-Case to generate cases.
• Used Import wizard and Data loader to migrate the existing data to Salesforce
• Implemented Assignment rules to assign cases to various users and Queues.
• Design and create Reports and Dashboards as per business requirement

Environment: Salesforce Enterprise Edition, Visualforce, Custom/Standard Objects, Custom Tabs, Page Layouts, Workflow & Approvals, Reports, Dashboard, Security Controls.

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.

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.