SUMMARY

• More than 8 years of experience in salesforce.com CRM platform as a Business analysis with expertise in Software Development Life Cycle (SDLC) including analysis, requirement gathering, architecture design, development, enhancements, testing, deployment and maintenance of standalone, Multi - tier, web-based and portals based object oriented enterprise applications.
• Excellent facilitation skills in conducting walkthroughs, surveys, questionnaire, interviews, brainstorming, JAD and JAR sessions.
• Excellent documentation skills - demonstrated in documenting software requirement specification (SRS) Business Requirement Documents (BRD), User Requirements (URS) and Functional Requirements (FRS).
• Experience working with Agile, RUP, Waterfall methodology.
• Design, Architecture, Administration, Configuration, Implementation and Support experience with Salesforce.com platform (extensively on Sales applications).
• Experience integrating Salesforce with SAP using Scribe.
• Extensively worked on all phases of Data Warehousing project like Data Cleansing, Data modeling for data staging & Data Mart, ETL, Indexing, Quality Assurance, Data updating plan, and Data presentation to business users.
• Experienced in working with clients to map out their existing Business Processes and providing system-based solutions that increase efficiency and reduce operating costs.
• Hands on experience with all phases of Software Development Life Cycle (SDLC) and working in full life cycle, maintenance and re-engineering projects.
• Worked on CRM-Salesforce.com (SFDC both Sales cloud & Service Cloud).
• Possess comprehensive understanding of CRM business processes like Campaign Management, Lead Management, Account Management, Case Management, Quote, Forecasting, and Call Center.
• Experienced in migrations/deployments between Salesforce.com & multiple-instance production environment
• A skilled problem solver and an efficient team player. Can effectively work in both independent and collaborative work environments.

TECHNICAL SKILLS

Tools: Workbench, Dataloader, SOQL Commander, SQL Server Management Studio, Quality Center, Data Analysis, Data Cleansing, Data Normalization, Data Migration, NBLog, Eclipse, Force.com Explorer, Force.com Excel Connector, Ant Migration, PRM Portal.

Programming Languages: Apex, Visual Force pages, HTML, Ajax, JQuery and JavaScript.

Packages: MS Office, Open Office

Databases: Apex Data Loader, SQL Server 2010

Configuration Skills: Campaigns, Leads, Accounts, Contacts, Opportunities, Forecasts, Products, Assets, Contracts, Cases, Solutions, Ideas, and Custom Object development Field creation, Page Layout creation/editing, Related list customization, Record Types, Field Level and Object level security, role hierarchies, sharing models, Reports, Dashboards, Formula Fields and Cross Object, Formula Fields.

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

PROFESSIONAL EXPERIENCE

Confidential, New York, NY

Sr. Salesforce Business Analyst

Responsibilities:

• Interacted with various business team members to gather the requirements and documented the requirements.
• Assist with management of day-to-day SFDC end user support cases, resolving cases in an efficient and timely manner.
• Provide ongoing support in the areas of SFDC administration, configuration, data migration, reporting, solution design and project coordination.
• Implemented salescloud and service cloud to improve customer retention and service delivery process improvement.
• Translate business requirements into SFDC system functionality. Identify, evaluate, test and deploy solutions that are cost-effective and meet business requirements.
• Designed conceptual and logical data models of Data Warehouse and tables.
• Worked on different versions of Microstrategy and had good understanding of OLAP, ROLAP and MOLAP.
• Participated in Requirement Gathering Sessions & JAD Sessions.
• Organized JAD sessions with business users and project teams for gathering, document and communicate application system requirements.
• Implementing SalesCloud, Service Cloud, Chatter and custom applications in Force.com.
• Used field level security along with page layouts to manage access to certain fields.
• An end-to-end exposure on force.com business cloud applications Analysis and development.
• Implementing sales cloud and service cloud for different business.
• Designed and developed SSIS packages, store procedures, configuration files, tables, views, and functions; implement best practices to maintain optimal performance.
• Performed data analysis and data profiling usingSQLandInformaticaData Explorer on various sources systems including Oracle and Teradata.
• Responsible for managing Users in Production and supporting users in UAT.
• Created Reports and Dashboards as per the customer requirements.
• Created Workflow Rules, Page Layouts, Approval Process, Tasks, Email Alerts, Field Updates and Outbound Messages to manage the Workflow &Approvals.
• Working extensively with Tableau Business Intelligence tool to develop various dashboards.
• Working extensively using Excel to validate the data and use as the source data files.
• Involved in Designing the ETL process to Extract translates and load data from OLTP Oracle database system to Teradata data warehouse.
• Used SOQL & SOSL with in Governor Limits for data manipulation needs of the application using Force.com Explorer.
• Configured Dynamic products with variable attributes and integrated price lists with products in Salesforce.
• Created custom Dashboards for manager's home page and gave accessibility to dashboards for authorized people.
• Worked on Agile and Scrum Methodology for Salesforce custom app implementation.
• Created new custom objects, assigned fields designed page layouts, custom tabs, components, custom reports
• Implemented pick lists, dependent pick lists, lookups, master detail relationships, validation and formula fields to the custom objects.

Environment: Salesforce, Product Catalog, Oracle, Informatica, Cognos, Tableau, ETL, SQL, Oracle, UAT, SQL, Informatica, SSIS, Visio, Quality Center, EIM, QTP, Access.

Confidential, Richmond, VA

Salesforce Business Analyst

Responsibilities:

• Responsible for Bug free delivery of Sales and Service Oriented applications developed on (Salesforce.com) Force.com Platform.
• Created Business Requirements Document and converted into System Requirement Specifications Document tying well with the design.
• Developed complex SQL Queries to validate the data in the Cognos Custom reports against Safety Database
• Experience on various salesforce.com standard objects like Accounts, Contacts, Opportunities, Products and Price books, Cases, Leads, Campaigns, Forecasting, Reports and Dashboards.
• Writing SQL statements and analyzing query performance as it relates to Crystal reporting.
• Experienced in using Apex Data loader, for exporting and importing the data from SFDC.
• Created new custom objects, assigned fields, custom tabs, components, custom reports.
• Created custom Reports based on business need and associated them to Dashboard.
• Written and implemented Teradata stored procedures to implement business logic.
• Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database
• Worked on various salesforce.com standard objects like Accounts, Contacts, Leads, Campaigns, Opportunities, Quotes, Activities, Dashboards and Reports
• Develop Business Objects Reporting and Dashboard.
• Created ETL test data for all ETL Informatica mapping rules to test the functionality of the SSIS/SSRS packages.
• Developed Test Plan and reviewed and wrote test cases, data creation to perform SIT & UAT testing tasks.
• An end-to-end exposure on force.com business sales cloud applications Analysis and development.
• Design, implement, unit test, maintain, and troubleshoot various applications and integrations with Salesforce.com.
• Created Workflow Rules, Page Layouts, Approval Process, Tasks, Email Alerts, Field Updates and Outbound Messages to manage the Workflow &Approvals.
• Configured interfaces and portal application (PRM) for lead Management so that Assurant Lead Vendor agents.
• Supported ETL and testing team with any defects or technical issues with the data.
• Maintained and managed the risk/issue log throughout the complete life cycle of the project.
• Prepared and created test cases and tested multiple views in Tableau.
• Extensively worked on database query tools such as TOAD, Teradata SQL Assistance and SQL Plus.
• Developed ongoing Integration to get Accounts and Contacts data from Partner Database into salesforce.com on daily basis using informatica.
• Worked on various salesforce.com standard objects like Accounts, Contacts, Leads, Campaigns, Opportunities, Quotes, Activities, Dashboards and Reports.

Environment: Salesforce, Agile, SQL, Tableau, Informatica, Cognos, Tableau, ETL, SQL, Oracle, OBIEE, ESP OID, Scrum, CPQ, OAM, Business Objects

Confidential, East Providence, RI

Business Analyst

Responsibilities:

• Liquidity Management forensuring optimum utilization of funds, ensuring appropriate liquidity to provide for working capital requirements.
• Involve in Asset Liability Management including preparation of ALM Reports, policy revision, and process improvement.
• Responsible for managing a portfolio of foreclosure loans.
• Complete required actions and events to ensure that all loans are timely taken to foreclosure sale, based on business guidelines for conventional loans
• Work closely with Loss Mitigation department to monitor holds and stops of the foreclosure action based on loan modification, forbearance, or special repayment agreement.
• Work closely with Foreclosure staff to ensure that functional groups within the foreclosure process are assisting in supporting the processes that need to be completed.
• Ensure the accurate & timely referral to Bankruptcy & Post Sale areas as they move through the process to prevent delays & the potential for monetary loss or exposure.
• Involved in AS- IS and TO- Be discussion for SHAW to AFS conversion.
• Created source-target data mapping document.
• Facilitated JAD Sessions and gathered Business Requirements
• Assisted the PM in developing Use Cases and project plans and also managed changes to the scope of the project.
• Performed extensive data modeling to differentiate between the OLTP and Data warehouse models
• Conducted User Acceptance Testing (UAT).

Environment: DB2, XML, XML Spy, ETL, WSDL, SOUP UI, HP Q.C, MS Visio, RUP, UML, MS Project, SQL, MS Access, MS Excel and MS Word

Confidential, Indianapolis, IN

Business Analyst

Responsibilities:

• Responsible for gathering user requirements and specifications for designing a mortgage based loan system using and documenting the same.
• Conducted Business Requirements, Functional and Technical meetings with Business groups.
• Provide innovative IT, business & e-commerce solutions to perspective and existing clients.
• Was involved n the creation of new E-Commerce Products (Arrival Notices and Customized Reporting).
• Led and conducted JAD sessions for requirements gathering, analysis and design of the system.
• Designed the system, prepared UML and sequence diagrams using Rational Rose.
• Collaborated on creation of documents such as the Vision, business requirements (BR) and business systems design (BSD) documents.
• Defined web services using message mapping using SOAP Input, SOAP Request, SOAP Reply nodes.
• Performed Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data.
• Incorporated Rational Unified Process (RUP) to create Requirement Document Specifications using Visible Analyst.
• Responsible for writing detailed descriptions of user needs, program functions, and steps required for developing or modifying software programs using Rational Rose (UML).
• Worked extensively with the QA team for designing Test Plan and Test Cases for the User Acceptance Testing.
• Worked with Quality Control Teams to develop Test Plan and Test Cases.
• Used MS Visio for Process modeling and Business Process flow diagrams.

Environment: UNIX / Oracle Platform, MS Visio, RUP, Rational Clear Quest