PROFESSIONAL SUMMARY:

• A Salesforce Administrator and business analyst with over 8+ years of experience with focus on business analysis, Data Analysis, requirement gathering, technical documentation, Database development and software validation.
• Experience in Software Development Life Cycle (SDLC) Methodologies and Object Oriented Analysis.
• Knowledge of Agile Methodology and Waterfall Methodology.
• Processes for automated alerts, field updates, and Email generation according to application requirements.
• Skilled in customizing standard objects like Accounts, Contacts, Opportunities, Products, Price books, Cases, Leads, Campaigns as per client’s need.
• Created page layouts, search layouts to organize fields, custom links, related lists, and other components on a record detail and edit pages.
• Implemented Picklists, Dependent Picklists, and Lookups, Junction objects, Master detail relationships, Validation and Formula fields to the custom objects.
• Expert in generating and analyzing custom reports and dashboards.
• Experience working on Workflow rules, Validation rules, Assignment rules, Email alerts and Templates.
• Used Data Loader for insert, update, and bulk import or export of data from Salesforce.com subjects. Used it to read, extract and load data from comma separated values (CSV) files.
• Good experience with SOQL, Relationships and Lookups.
• Provided customer with best practice solutions as related to Salesforce CRM.
• Experience on working with Process Builder.
• Created Custom Objects and defined lookup and master - detail relationships on the objects
• Excellent communication skills, accustomed to working in both large and small team environments and ability to think out-of-the-box.

TECHNICAL SKILLS:

Salesforce Technologies: Salesforce.com, Apttus, VisualForce, Agile /Scrum Workflow & Approvals, Dashboards, Analytic Snapshots, Case Management Automation, Custom Objects, Including Integration technologies. SFDC, Workflows, Approvals, Email Templates, Formulas, Validation Rules, AppExchange, Customer Portal and Partner Portal, Eclipse.

Salesforce Tools: Force.com Eclipse IDE Plug-in, Force.com Explorer, Force.com Data Loader, Excel Connector, Force.com Platform (Sandbox and Production), Cloud based Apex tools Force.com Migration Tool, SharePoint 2007, SharePoint 2010.

Languages: PL/SQL, HTML and UML

Project & Requirement Management Tools: Rational Rose, Microsoft Visio, Visual Paradigm, Rational Requisite PRO, Microsoft Project.

Operating Systems: Windows NT / 2000 / XP Pro / Vista, Windows Server 2000 / 2003 / 2008.

Documentation Tools: MS Office (Outlook, Word, Excel, PowerPoint)

PROFESSIONAL EXPERIENCE:

Confidential, NY

Salesforce Admin / Business Analyst

Responsibilities:

• Performed detailed analysis of business and technical requirements and designed the solution by customizing various standard objects of SalesForce.com (SFDC).
• Worked as an Administrator to perform detailed analysis of business and technical requirements and designed robust, secure and scalable the solution.
• Worked with business users to analyze the business requirements and created mapping documents for Salesforce.
• Worked on standard salesforce.com objects like Accounts, Contacts, Leads, Campaigns, Opportunities, Dashboards and Reports.
• Customized page layouts for Campaigns, Leads, Opportunity, Contacts, Cases and Accounts depending upon user roles, and groups.
• Worked on creating reports and dashboards.
• Assigned profiles and roles to users as per the organizational requirements.
• Created Custom Objects and defined lookup and master-detail relationships on the objects. Also created junction objects to establish many-many connectivity among objects.
• Designed Workflow rules, Validation rules, Assignment rules, Email alerts and Templates.
• Implemented complex approval processes to ensure proper authorization.
• Defined object and field level security.
• Used sandbox mode for testing and migrated the code to the production instance in installments.
• Implemented new enhancements, including creation of custom objects, custom fields, custom tabs.
• Implemented various advanced fields like Picklist, Custom Formula Fields, Field Dependencies.

Environment: Sales cloud, Windows XP, Force.com Platform, Salesforce.com Custom/Standard Objects, Custom Tabs, Page Layouts, Force.com, Workflow & Approvals, Reports, Force.com, Data Loader, Salesforce Outlook, Email to case, SalesForce.com Sandbox, and Email Services.

Confidential, NY

Business Analyst / Salesforce Administrator

Responsibilities:

• Interfaced with stakeholders, gathered requirements for system change request work request.
• Imported Accounts, Leads, Campaigns, and custom object data in Salesforce.
• Created business processes for custom and standard objects with appropriate record type and assigned them to specific profiles and page layouts.
• Administered and monitored the company’s Salesforce CRM application. Created the workflows for automated lead routing, lead escalation and email alerts.
• Developed various picklists, formula fields, master-detail relationships, lookup relationships and custom report types.
• Created reports in Salesforce.com to meet operational requirements including maintaining a standard set of queries/reports to satisfy requirements, validate queries/reports created by others in the organization and assist in the interpretation of data.
• Developed Triggers, Formulas, Workflows to update the newly imported data based on rules defined in existing business processes. Set both object-level and record level security.
• Created Profiles, Roles based on Organization role hierarchy and implemented Record-Level and Field-Level security and configured their sharing settings.
• Analyzed Business Requirement Document (BRD), Technical Requirement Specification and Functional Requirement Specification
• Responsible for understanding the business needs and analyzed the existing system for determining the information gaps and deficiencies, as well as evolving information needs.
• Created functional specification document which includes Use Case Diagrams, Sequence Diagrams, and Activity Diagrams that provide the developers a view of the requirements for the system development.
• Designed and deployed the custom objects, custom tabs, validation rules, workflow rules, auto-response rules to suit the needs of the application.
• Responsible for Extraction, Transformation and Loading (ETL) of data into new database management system.
• Responsible for maintaining and updating Data mapping documents.
• Wrote complex SQL queries using joins, sub queries to retrieve data from the database.

Environment: MS Visio, SDLC, Oracle EBS, MS Office, MS SharePoint, UML, Microsoft Word, Power Point, Business Objects, HP Quality Center

Confidential, Newark, NJ

Database Developer

Responsibilities:

• Involved in analysis, planning, and defining data based on business requirements, and provided documentation.
• Designed database, tables, and views structure for the application.
• Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server 2008 R2 and Flat files.
• Developed complex T-SQL code such as Stored Procedures, functions, triggers, indexes, and views for the application.
• Scheduled and maintained packages by daily, weekly, and monthly using SQL Server Agent in SSMS.
• Optimized SQL queries and stored procedures to improve the performance time.

Environment: SSRS 2008, SSIS 2008, T-SQL, Microsoft SQL Server 2008/2012, Visual Studio 2005/2008, BIDS, Microsoft Word 2010, Microsoft Excel 2010.