SUMMARY

• Having 10+ years of work experience implementing Sales and CRM related systems including 5+ years as a Salesforce business analyst.
• Extensive experience working on various stages of Software development lifecycle (SDLC) including Requirement gathering, Design, Implementation, Testing and support.
• Conduct meetings and facilitate collaborative discussions for requirement changes and new functionality needs.
• Experienced in working with clients to map out their existing Business Processes and providing system - based solutions that increase efficiency and reduce operating costs.
• Develop functional specifications and system design specifications.
• Proficiency in SFDC Administrative tasks likeCreating Profiles, Roles, Users, Objects, Fields, Tabs, Page Layouts, Email Services, Validation rules, Approvals, Workflows, Reports, Dashboards, Tasks and actions.
• Worked with Apex Data Loader tool to migrate the data from other data base.
• Used MS-Visio for process modeling,Use case Diagrams, business process flow diagrams.
• Experience with complete Software Development LifecycleSDLCWaterfall andAgile with scrum.
• Worked extensively on various salesforce.com standard objects like Accounts, Contacts, opportunities, Products, Price books,Contracts, Cases, Leads, Campaigns.
• Expert in generating and analyzing custom reports and dashboard for management and various business unit personnel to provide detail information on key performance indicators.
• Created new user accounts and configure Salesforce.com to fit security needs at the user and organization levels.
• Extensive Knowledge in building Custom Applications that includes administration, configuration, implementation and support experience with Salesforce.com platform.
• Analyzing bugs, interacting with team members in fixing errors and UAT, also assisted in Post - Production support.
• Experience in Salesforce Testing and Administration spanning all facets of package software and SaaS application implementation.
• Responsible for creating, managing, and delivering of required documents for application.
• Excellent communication and inter-personal skills, accustomed to working in both large and small team environments.

TECHNICAL SKILLS

SFDC: Visual Force, Force.com IDE, Workflow & Approvals, Custom Objects, Dashboard.

SFDC Tools: Data Loader, Connect offline, Salesforce-to-Salesforce, Apex Explorer

CRM: Salesforce.com, SugarCRM, SAP CRM, SAP R/3 SD/MM

Databases: Oracle, SQL server, MS Access, SAP.

Packages: Microsoft Project, Microsoft Office suite 2003/2007/2010 Open office, Adobe Photoshop, Google Docs

Databases: Oracle, SQL server, MS Access, SAP.

Modeling Tools: Artisan and Rational Rose, Microsoft Visio, Database.com

Methodologies: Agile, Waterfall

Operating Systems: Windows (97thru 2000/XP, 2003, Vista, and 7), LINUX, MAC, MS-DOS

PROFESSIONAL EXPERIENCE

Confidential, Waltham, MA

Sr. SFDC Business Analyst

Responsibilities:

• Serve as a functional lead on Salesforce Service Cloud project.
• Involved in gathering customer requirements from business user teams spread over the Sales, Marketing and Customer service.
• Involved in creating gap analysis document, clearly identifying the data, business process and work flows of the organization with respect to salesforce.com implementation.
• Developed and Customizing salesforce.com application based on the user needs.
• Developed field & page layout customization for the standard objects like Account, contact, Leads.
• Maintained and gave permissions to communication templates based on Profiles.
• Performed Data Analysis and migrated data from SQL Server database to salesforce.
• Involved in Accounts Merging, maintaining Public Groups.
• Created Reports and Dashboards as per the customer requirements.
• Created and managed technical and business process documents.
• Worked on Record Types, Validation Rules, Triggers and Page Layouts.

Confidential, Minneapolis, MN

SFDC Functional Analyst

Responsibilities:

• Evaluated Business Development representative team needs while conveying the value of SalesCloud. Conducted Analysis and design of the Salesforce.com; performed process analysis of sales activities to determine business solutions or process improvement opportunities.
• Partnering with ERP and CRM stakeholders to analyze, understand and improve finance/sales operations that increase employee productivity and end-user effectiveness.
• Created users, profiles, roles hierarchy. Created rules in CRM duplicate blocker to prevent duplicate leads, created Docusign documents for contracts. Created validation rules, workflows to fulfill business processes.
• Trained and supported end-user groups, executives, managers and agents on scheduled intervals in face-to-face presentation and real-time remote on opportunities, leads, accounts, etc.
• Support business applications portfolio by advising best practices, recommending process improvements and implementing system enhancements that advance

Confidential

Salesforce Business Analyst

Responsibilities:

• Analysis of functional and design documents and map it to the application in test environment.
• Working closely with business units to develop business scenarios
• Documenting the changes in organization structure and the business since inception of application for future enhancements.
• Assist in analyzing the user profiles as well as their assigned roles and responsibilities through interviews.
• Interacting with heads of business units to facilitate the process of implementing the application.
• Bulk load of majority of users on Chatter as well as loading some user’s one individual basis.
• Configuration of Chatter for email notifications, creating groups for sales and offers.
• Analyzing the Test data, Test environment and execution plan to conduct Business user testing.
• Conducting Business Users Integration Tests and User Acceptance Tests.
• Analyzing the defects and collaborate with off shore team members for suitable remedies to remove defects.
• Interacting with senior management to provide the progress of application development and suitability for business users.
• Analyzing the gaps between original requirements and the functionality of the application.
• Documenting the identified gaps in the test application and business needs.
• Conduct workshops for business users of the application.
• Conducting mock ups to test the approval and case management functionality of the system
• Developing Generic Test Scripts for Business users and overseeing the process of test-script production by various members.

Confidential, San Francisco, CA

Business Analyst

Responsibilities:

• Reviewed, analyzed and created detailed documentation of business systems and user needs, including workflow, program functions and steps required to develop or modify application programs.
• Assisted in developing and maintaining business & financial reports and IT work/databases which was required to support the various lines of business and specific projects.
• Consulted with IT Personnel to determine business, functional and technical requirements for specified applications.
• Developed effective reporting tools for the business unit and completed existing projects from original concept through final implementation
• Organized chart-holding facilities and assisted in training staff. Assisted various projects from start to finish through the SDLC process.
• Participated in Code Reviews, System Testing and UAT followed by production verification, post production testing and support
• Performed internal & external reporting, cash management, cost reduction & efficiency

Confidential, San Francisco, CA

Sr. Informatica Consultant

Responsibilities:

• Proficient in understanding business processes/requirements and translating them into technical requirements
• Understanding the Business Requirements and Develop an ETL process to load data from source to target.
• Created ETL mappings using Informatica Power Center to move Data from sources like flat files, databases, loaded into Oracle, SqlServer.
• Created ETL mappings & Mapplets for various layer of data loads like Staging, DWH, Data Mart.
• Reviewed the mappings, sessions and workflows for ETL standards.
• Involved in review of detailed Design document, LLD, HLD & Unit Testing of Code.
• Prepared Unit Test/ Assembly Test cases and executed unit test cases successfully
• Created the sample Files for SIT and Tested in SIT Environment.
• Supported during QA/UAT/PROD deployments and bug fixes.
• Parameterized the mappings and increased the re-usability
• Created and defined DDL’s for the tables at staging area.
• Maintained the Defect Tracking and fixed the Defects.
• Responsible for creating shared & reusable objects in Informatica shared folder and update the objects with the new requirements and changes.
• Setting up and coordinating meeting with Offshore and business users.

Confidential, Minneapolis, MN

Sr. Informatica Consultant

Responsibilities:

• Extensively involved in all phases of Project life cycle right from Requirements Gathering to Testing etc.
• Coordinated with Client SMEs and offshore team to get the requirements and get the code delivered in timely manner and with high quality and performance.
• Worked on coming up with templates for Source to Target Document, ETL Detail Design Document, Unit Test Plan, Code review checklist, Migration Check List and Production Handoff document.
• Developed and scheduled Workflows using task developer & workflow designer in Workflow manager and monitored the results in Workflow monitor.
• Performed thorough Unit testing & Integration testing using sample data from PROD, once the code is reviewed and met the standards, promoted to higher environments.
• Supported in UAT testing & fixed the defects and thoroughly tested them back & promoted to UAT for further testing.
• Responsible for migration and deployment of folder or mappings and sessions from development to QA environment.
• We constantly monitored the cycle run times and looked into the long running jobs and did performance tuning in order to meet the SLAs.
• Troubleshoot problems by checking sessions/error logs in the Workflow Monitor and also used debugger in Mapping Designer to debug complex mappings.
• Used the client tools (Ivalidator, dbView and db compare) to validate the Informatica objects and compare the source and target data.
• Maintained all standards & implemented the best practices in our development process.

Confidential, Denver, CO

Informatica Consultant

Responsibilities:

• Understand the Business Requirements in depth.
• Analyze the requirements of the business users by using ETL Specifications.
• Developed Entity Level, High level & Detail design documents based on requirement documents.
• Understanding the Business Requirements and Develop an ETL process to load data from source to target.
• Developed Informatica Mappings and Sessions based on business user requirements and business rules to migrate data from source reports & Oracle tables to flat files.
• Did performance tuning at source, transformation, target, and workflow levels.
• Parameterized the mappings and increased the re-usability.
• Created PL/SQL procedures to enable and disable the users while running the jobs and to load the data in control tables.
• Tuned the SQL queries used in the SQL override, Lookup Override of the Source Qualifier and Lookup transformations.
• Prepared the assembly test cases to perform the testing at E1 environment and involved in SIT and UAT.
• Created RFCs & worked with BIDW admin team on Migration between Development, Test and Production Repositories.
• Monitoring execution of implemented job in production during the warranty period and fix the identified issues.
• Supported the Quality Assurance team in testing and validating the Informatica workflows.