PROFESSIONAL SUMMARY:

• Salesforce Consultant with 7 years of industry experience and around 4 years of experience as CRM Salesforce Developer
• Customize and personalize Salesforce.com to fit environment's specific needs.
• Create new user accounts and configure Salesforce.com to fit security needs at the user and organization levels.
• Extensive experience with business specific reports & dashboards
• Data migration and manipulation using Salesforce tools.
• Integration using Salesforce APIs, Apex, Salesforce chatter and mobile integration.
• Experience in administration, configuration, implementation, and support of Sales Force CRM, and Sales Force SFA applications based on Apex Language and leveraging Force.com Platform - - world's first commercial Software as a Service (SAAS) application running in Cloud Computing Environment.
• Salesforce.com and SQL Server Integration with the DBAmp.
• Extensively exposed to creating objects, fields, Record Types, workflows, approval processes, Escalation rules, Assignment rules, validation rules, Email services, data migration activities, custom page layouts, custom fields and other standard functionality.
• Strong planning, management & communication to coordinate and lead cross functional teams towards a common organizational goal.
• 3 years of professional experience in Data Extraction, Transformation, Loading ETL, Dimensional data modeling, Star schema modeling, Snow-Flake modeling, identification of fact and dimension tables, Normalization and Physical and Logical data modeling.
• Experience in Database design and development using Oracle 9i, 10gR1 and 10gR2.
• Strong experience in SQL, PL/SQL programming and Query optimization.
• Gathered Business requirements by interacting with the business users.
• Experience in Repository and Reports performance tuning.
• Extensive knowledge of the Application development lifecycle, Business Objectives, Business Processes and ability to work in a fast paced environment.
• Extensively used SQL performance tuning for queries used in the repositories to fetch data.
• Excellent working knowledge of ORACLE, SQL Server, TOAD, SQL Query Analyzer, PL/SQL.
• Experience in developing UML Diagrams (Use case Diagrams, Sequence Diagrams and class diagrams) using Rational Rose Software.
• Strong Conceptual, Business, Analytical skills & highly motivated team player and ability to provide work estimates and meet deadlines.

TECHNICAL SKILLS:

Operating Systems: Windows NT 2000/2003 Server, Windows XP, UNIX.

Languages: T-SQL, Oracle PL/SQL, MS DOS C, C++, SQL server 2000/ 2005/ 2008, XML.

Databases: MS Access 2003/2007, Oracle 11g,10g,9i,8i, SQL Server Enterprise Manager, Query Analyzer, SQL Profiler, SQL * Loader, SQL * Plus.

SFDC Technologies: Apex, Visual Force Pages, Reports, SOQL, SOSL, API, Dashboards, Data Loader, Controllers, Triggers, Custom Objects, Salesforce Chatter Workflow & Approvals, Custom Objects.

GUI & Fusion Middleware: Oracle BI Publisher 10.1.3.4.1/ 10.1.3.3, Oracle BI EE(SBA)11g/ 10.1.3.4.1 /10.1.3.3, Reports 10g and Oracle Application server 10gR1 and 10gR2

Web Servers: IIS 5.0/6.0, Apache, Tomcat.

Scripting Language: HTML, CSS, JavaScript, SOAP, WSDL, JSF, Ajax, XML

ETL: SQL Server BI Tools, DTS, Informatica, Datastage.

Other Tools: Microsoft Visual Studio 2003/2005, Source Control, MS Office suite, MS Visio, Rational Rose, Eclipse.

PROFESSIONAL EXPERIENCE:

Confidential, Phoenix, AZ

Sales Force Developer/Administrator

Responsibilities:

• Participated in requirements Gathering and definition of Entity Relationship diagrams using MS Visio2007.
• Customized tab worked with various standard objects including Accounts, Contacts, Leads, Campaigns and Cases.
• Designed, Implemented and deployed the Custom objects, Page layouts, Custom tabs, Components to suit to the needs of the application.
• Created page layouts, search layouts to organize fields, custom links, related lists, and other components on a record detail and edit pages.
• Designed, developed and deployed Apex Classes, Controller Classes, Extensions and Apex Triggers for various functional needs in the application using the Eclipse IDE.
• Develop Visual Force Pages, Visual Force Custom Controllers Components, Advanced Search Functionality, Custom Objects, Analytic Snapshots, Tabs, Tags and Components.
• Created Custom Objects and defined lookup and master-detail relationships on the objects.
• Created workflow rules and defined related tasks, time-triggered tasks, email alerts and field updates to implement business logic.
• Used SOQL & SOSL with consideration to Governor Limits for data manipulation needs of the application using platform database objects.
• Created mash up between sales force CRM and Gmail through Force.com AppExchange Email integration engine.
• Used the sandbox for testing and migrated the code to the deployment instance after testing.

Environment: Saleforce.com platform, Apex Language, Visual Force (Pages, Component & Controllers), Workflow & Approvals, Reports, Custom Objects, Custom Tabs, Email Services, Security Controls, Windows Vista.

Confidential, Peoria, IL

SalesForce.com Developer

Responsibilities:

• Gathering and documenting requirements and conducting Gap analysis for data migration for all objects including knowledge base.
• Implemented Approval process and work flow rules to automate existing business processes.
• Migrated data from existing systems to standard and custom objects.
• Implemented Partner Portal to manage channel sales.
• Created a comprehensive Auto Case management system and Assignment rules for assigning the specific case to the specific user or role.
• Created sharing rules for providing cross functional teams of the organization access to records which they do not own.
• Developed Triggers, VF Pages, and Controller classes.
• Created the Web Service Client class, Wrapper classes for integration.
• Performed mass insert, update, upsert, delete using Data loader.
• Maintained an e-mail to Case system with auto-notifications sent to users when a case is created for their departments.
• Created Custom fields, field dependencies and custom formula fields for auto calculations.
• Created custom Reports (Matrix and summary reports) and built dashboards for organization-wide presentations
• Service Cloud enhancements - Portal entitlement wizard changes (discovery & design).
• Integration of Salesforce.com with external applications by using Web Services API, Metadata API, WSDL, SOAP.
• Managed the overall smooth flow of Salesforce automation process
• Conducted Business Process Review sessions to analyze the existing and to-be implemented business processes for Clients.
• Maintained documentation of all requirements, deliverables and business processes implemented in Salesforce.com
• Tracked and Reported total hours and expense on a weekly basis.
• In charge of getting sign off on all project deliverables before the final project closure.
• Gathered Requirements and configured the application to meet user requirements.
• Implemented Case management and Solutions management modules.
• Performed Salesforce.com data Integration using APIs, Batch Integration.
• Experience in following Transact SQL rules for WHERE clause AND/OR precedence.
• Experience in using Query Optimizer to execute the SQL statements.
• Customized SF for existing users and involved in data clean up and migration.
• Prepareddetailed Test Plan, Test Strategy, and Test Scenarios to test business requirements.
• Provided end user .

Environment: Sales Cloud, Service Cloud, Data loader and Data management, Workflow rules and Approval processes, sandbox, workflows, Custom objects, Reports and Dashboards, Partner Portal, Custom Profiles, Page Layouts, Security Settings, Data Sharing Rules

Confidential, Buffalo, NY

Salesforce Developer

Responsibilities:

• Involved in Salesforce.com Application Setup activities and customized the apps to match the functional needs of the organization.
• Implemented the requirements on Salesforce.com platform and Force.com IDE Plug-in using Eclipse.
• Worked on various salesforce.com standard objects like Accounts, Contacts, Cases, Leads, Campaigns, Reports and Dashboards.
• 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
• Used the Force.com explorer to build and test SOQL and SOSL queries.
• Designed, and deployed the Custom objects, Entity-Relationship data model, validation rules on the objects and tabs, Page layouts, Custom tabs, Components, Visual Force Pages to suit to the needs of the application.
• Defined lookup and master-detail relationships on the objects and created junction objects to establish connectivity among objects.
• Designed developed and deployed Apex Classes, Controller Classes and Apex Triggers for various functional needs in the application.
• Developed and configured various Reports and Report Folders for different user profiles based on the need in the organization.
• Developed Custom Objects, Custom Reports and configured the Analytic Snapshots to dump the data on regular basis for the sales performance and lead generation statistics.
• Used SOQL & SOSL with consideration to Governor Limits for data manipulation needs of the application.
• Develop VisualForce pages, VisualForce Custom Controller Components, Advanced Search functionality, Custom Objects, Tabs, Tags and Components.
• Created Custom Objects and defined lookup and master-detail relationships on the objects.

Environment: Salesforce.com platform, Workflow and Approvals, Reports, Custom Objects Tabs, Email Services, Apex Language, Visual Force Pages, Components and Controller, JavaScript, Eclipse IDE Plug-in, Data Loader.

Confidential, San Diego, CA

Sales Force Consultant

Responsibilities:

• Worked with the business community to gather requirements and converted them into Business Requirement Documents (BRD) and Functional Requirement Documents (FRD)
• Created various Custom Objects as per requirement.
• Worked on various standard Objects like Accounts, Case, and Contact.
• Created Security Settings for Roles and Profiles and managed Security Sharing Settings.
• Developed Validation Rules for the Custom Objects and Workflow rules and Approvals for some fields.
• Restructured Custom objects, Master detailed relationship between objects to better suites the organization.
• Deploy SFDC package from one organization to other organization.
• Developed APEX class, Controller class and APEX Triggers from various functional needs in the application.
• Involved in Salesforce.com application setup activities and customized the apps to match the functional needs of the organization.
• Created various Reports (Summary reports, Matrix reports, Pie charts, Dashboards) and set up Reports folders.
• Individually worked on creating and implementing the Web-TO-Case functionality to solve and track customer issues.
• Importing and exporting large volume of data using Data Loader.
• Used Sandbox for testing and migrated the code to the deployment instance after testing.

Environment: Saleforce.com platform, Apex Language, Triggers, Visual force, SOQL, Change Set, Data Loader, Force.com, Work Flows-approval, Custom objects, Custom tabs, Email service, Html, Web service, Sharing Rules.

Confidential

Oracle PL/SQL Consultant

Responsibilities:

• Designed and developed Customer conversion program.
• Involved in gathering user requirements and translated them into technical documents to develop Reports.
• Created temporary tables and developed SQL*Loader control files to load the legacy data into the temporary tables for all the conversions.
• Used SQL * Loader to load Freight invoices from comma delimited file to Conversion tables.
• Created custom reports, PL/SQL packages, request sets, menus and tables.
• Creating Reports Involving hierarchies on Natural Accounts and the Cost Center using Discoverer.
• Creation of Cross - Tab Reports to display the data, creating an alternate sort.
• Creating Item Classes and Creating Alternate Sort.
• Responsible for design, development of reports across various modules using Discoverer.
• Using Functions to Perform Calculations (Variances, Percentages etc).
• Developed custom Packages, Functions and Procedures.
• Created custom reports, PL/SQL packages, request sets, menus and tables.
• Creating Reports Involving hierarchies on Natural Accounts and the Cost Center using Discoverer.
• Creation of Cross - Tab Reports to display the data, creating an alternate sort.
• Creating Item Classes and Creating Alternate Sort.
• Exporting Folders, Workbooks, Item Classes, and hierarchies from Developing to Testing.
• Generated weekly/monthly/yearly Reports using Discoverer for Account and Department segments.
• Developed On hand Quantity report discoverer, which would track all items in sub-inventory.
• Automated the process of migrating Data Definitions and Templates from Instance to Instance.
• Designed and developed validation programs for Journal Import Interface to import journals information from legacy systems.

Environment: Oracle 9i, Discoverer 4i, PL/SQL, SQL*Plus, TOAD, Reports 6i, UNIX.