Summary:

• Business Analysis: 7 years experience as Business Analyst, Systems Analyst, in Business Requirement Gathering, Gap Analysis, Business Process Modeling, Process Management, Change Management, and Application Development & Release Management in domains like Finance, Healthcare, Insurance and Telecom.
• Four years of experience as Salesforce.com Business Analyst in Business Requirements Analysis Requirement Gathering and Gap Analysis.
• Worked with SFDC Visual Force Pages, Controllers, SOQL, SOSL, Triggers, Validation rules, sharing rules, Webservices, Tabs, Custom Objects, Reports and Dashboards.
• Experience in creating Picklists, Dependent Picklist, Tabs, Role based Page layouts, Validation Rules, Email Templates, Workflow Alerts and Actions, Workflow Approval, Approval Processes, Custom Reports and Report folders.
• Expertise with Salesforce.com Sandbox and production environments.
• Experience with Salesforce.com Data Management using Apex Data Loader.
• Strong Knowledge in AppExchange Applications for integrating with third party applications.
• Good experience in implementing Sales Cloud, Service Cloud, Chatter and custom applications in Force.com.
• Strong visual modeling and business process modeling skills and Agile Unified Process (AUP) with tools like MS Visio, Mind Map and well experienced in developing Use Case Models, Context Diagrams and UML CASE tools, screen mockups using MS Expression.
• JRP & JAD: 5 years of Facilitating Joint Requirement Planning (JRP), Joint Application Development (JAD) with Business User Groups, Subject Matter Experts, and IT Groups to converge early toward a design acceptable to the customer and feasible for the developers and to limit a project’s exposure to the forces of change.
• Gap Analysis: Strong gap analysis capabilities which involves determining, documenting and approving the variance between business requirements and current capabilities.
• Data Analysis: Experience in Data Analysis involving Data Cleansing, Data Conversions, Data Transformation, Data Quality Analysis, Data Relationships, Source Systems Analysis and Reporting Analysis.
• Data Integration: 4+ years of Data Integration between various systems, sources, and databases. Experience in implementation of ETL methodology in Data Extraction, Transformation and Loading using SSIS. Proficient in business intelligence concepts, design principles, and software architecture.
• Data Modeling: Experienced in Data Modeling and concepts such as Physical/Logical Data Modeling, UML data modeling.
• UAT &Testing: 5+ years of Quality Assurance (QA) in reviewing Test Procedures, defining Test cases, reviewing and maintaining Test scripts, analyzing bugs, interacting with team members in fixing errors and conducting User Acceptance Testing (UAT).
• An effective team player with excellent problem solving and interpersonal skills.
• Good team player and a quick learner to new concepts and applications.

Qualification:
Bachelors of Technology

Business Skills:

• Requirements Gathering.
• Business Definition Requirements.
• Business Processes research, analysis & documentation.
• Use Case Modeling & Analysis.
• Functional & Nonfunctional Requirements gathering.
• Gap Analysis and Risk Mitigation.
• Experience in different relational databases and data quality analysis.
• Experience in efficiently leading a team.

Technical Skills:

Requirement Management Tools

: Rational Requisite Pro

Project Management Tool

: MS Project

Business Modeling

: MS Visio, Rational Rose

Defect Tracking Tool

: Mercury Quality Center 9.2, JIRA, Rational Clear Quest, Soap UI

Salesforce.com

: Apex, VisualForce, SOQL, SOSL, Apex Triggers, Workflows and Approvals, Email Templates, Formulas, Validation Rules, AppExchange, Eclipse, Force.com IDE, Salesforce.com, Apex Data Loader

Languages

: C, C++, Microsoft .Net, Java, J2EE, HTML, CSS, Javascript, VB Script, JSP, SQL

Web Technologies

: JavaScript, XML, XSL, HTML, XHTML, CSS, AJAX, ASP, ASP .NET

Databases

: Oracle 10g/9i/8i, My SQL, MS SQL Server 2008/05/2000, Teradata, DB2

Servers

: Apache, Tomcat, Weblogic, JBoss, Websphere, IIS

Methodologies

: Agile, Scrum, Waterfall

Version Control

: CVS, VSS, VSTF

Operating Systems

: Windows 2003/XP/2000/NT/98/95, UNIX

ETL & BI Tools

: Data Stage, Ab initio, Informatica, SQL Server Business Intelligence Development Studio, SSRS

Other Tools

: MS Office, Toad, WinSCP, Putty, Share Point, Teradata SQL Assistant

Experience:

Sr. Salesforce Business Analyst
Confidential,June’ 2011 to Present
San Francisco, CA
Responsibilities:

• Primarily involved in developing prototype of the application as proof of concept (POC) for business team and as a guideline for development team.
• Facilitated and led group discussions to elicit requirements in Joint Application Development (JAD) sessions by communicating with documented business requirement document working prototype and work flow diagrams.
• Deployed, configured and supported the prototype application for its demo /UAT for various line of business from various cities , prepared deck for UAT & gathered feedback and followed up with further updates on the prototype and related documents.
• Primarily involved in developing use case document for the application , traceability matrix , system requirement specification (SRS) and presentations for proposed solutions
• Worked on various Salesforce.com Standard objects like Accounts, Opportunities, Leads, Campaign and Reports.
• Created various Tabs, Workflows, Reports, triggers and validation rules for the application.
• Created Email templates in Text, HTML and VisualForce necessary for the application.
• Analyzed and Created Custom Profiles as required for the business needs and implemented Object level, Field level and Record level security.
• Defined various Validation rules to validate the data in the application.
• Customized Page Layouts for Salesforce.com Standard and Custom objects.
• Created custom report types and generated report using the report types.
• Good experience in Salesforce.com Configuration of roles, profiles, user accounts, implemented role hierarchies, sharing rules and record level permissions to provide shared access among different users.
• Experience in working with Development team for solving the gaps in Business requirements.
• Created and maintained the documentation for Design, Migration and Integration.

Environment: MS SQL Server, UML, MS Visio 2008, Microsoft Office 2008, MS Project, Visual Studio 2008 professional, MS Expression 2008, Visual Source Safe, Salesforce.com, Chatter, Apex Classes, VisualForce Pages, Data Loader, Workflow Alerts, Approvals, Validation Rules, Sharing rules, Reports, Standard & Custom Objects, Tabs, Email Templates, Roles, Profiles, HTML, Force.com IDE.

Salesforce Business Analyst
Confidential,Feb’ 2010 to May’ 2011
Minneapolis, MN
Responsibilities:

• Closely worked with Salesforce.com consultants while implementing the solutions needs for organization.
• Designed Custom application interface using VisualForce API and Apex Classes.
• Designed, developed and deployed the custom objects, page layouts, custom tabs, components, VisualForce pages to meet the needs of the application.
• Created various custom reports for standard objects as well as custom objects to give complete detail overview of customer (Account) Orders, renewal forecasting and customer balance report.
• Created email templates and inbound emails for clients and customers.
• Used Data Loader for loading the data.
• Developed business documents for Salesforce.com Custom objects.
• Created documentation for workflow rules and defined related tasks, time triggered tasks, email alerts, field updates to implement the business logic.
• Provided support ongoing salesforce.com maintenance and administration services including periodic Data cleansing, Custom objects, Workflows and Triggers.
• Implemented S-Controls to manage sales plan call sheets within Salesforce, capturing data and call activity.
• Primarily involved in developing a business model for developing the lead generation.
• Developed the scope and vision documents that defined the primary goals, objectives and scope of the project.
• Facilitated with team of two business analyst to elicit requirements in Joint Application Development (JAD) sessions by communicating with various background and skills, documented Scope Definition, Functional Specifications, Use Case document , Software Requirements Specification (SRS) and created User Interface Mockups/Prototypes using Ms Visio.
• Maintained project plans, task, defect and issues lists, lead meetings to discuss all aspects of the project’s execution, developed test scripts, executed UAT, participated in the QA process, and developed training materials and system documentation.
• Used MS Visio to carry out business modeling, Screen Prototype, Object modeling (use case) to develop business architecture for rapid and controlled Application development.
• Identified various business processes and developed process flow diagrams for the business processes and validated the same with SMEs. Developed prototypes for the UI and also helped in development of screen navigation flows.

Environment: Salesforce.com, Apex, VisualForce, Apex Data Loader, Chatter, Workflow, Approvals, Reports, Custom Objects, Tabs, Custom Profiles, Roles, HTML, CSS, Eclipse IDE Plug-in, Force.com IDE, Meta-data API, UML, MS Visio 2003, Microsoft Office Project, Case Complete.

Salesforce BA
Confidential, Jul’2009 to Jan’ 2010
Sunnyvale, CA
Responsibilities:

• Primarily involved in developing use case document & traceability matrix document for valuation pricing application. Developed the UI screen to data base, calculation to database mapping documents, data movement specification document.
• Worked as a liaison between developer, QA & business team in order to define or clarify requirement, address to functional queries and approach for solution to be used with proper documentation or change control forms
• Involved in SFDC application support for end users.
• Designed System Configuration Enhancements (Dashboards, Reporting, Page Layouts, Sharing Rules, Role Hierarchy, etc.)
• Created Sharing rules.
• Involved in reports development.
• Customize Salesforce.com page layouts, fields.
• Develop Validation rules and workflows.
• Involved in User Management – Creating users, Roles, Profiles.
• Developed the scope and vision documents that defined the primary goals, objectives and scope of the project using CMMI process document templates.
• Identified various business processes and developed process flow diagrams for the business processes and validated the same with SMEs, Documented business requirements for system issues and enhancements.
• Used MS Visio to carry out business modeling, data modeling (ER Diagrams), Object modeling (use case) to develop business architecture for rapid and controlled Application development.
• Created mock up screens (Screen prototype) using Microsoft expression
• Jointly involved in reviewing test case, master test strategy, UAT plan documents
• Participated in conducting UAT for the business users.

Environment: Salesforce.com CRM, Force.com platform, Custom & Standard Objects, Apex, VisualForce Pages, Workflow, Approvals, Reports, Tabs, HTML, JavaScript, Force.com IDE.

Confidential,
Websphere Admin/QA Lead-Business Analyst Jan’2008 to June 2009
Atlanta, GA
#1 Labor Exchange (LEX): Employment Services and Unemployment insurance system
#2 Workforce Investment Act (WIA): The WIA/TAA Tracking and Reporting System provides a tool for detailed tracking of funding, obligations, and expenditures for the Workforce Investment Act (WIA)
#3 State Information and Data Exchange System (SIDES): GDOL exchanges information of UI separation responses with large Third Party Administrators (TPA) and other employer customers.
#4 UI Legal (also worked as Business Analyst for this project): Tracks petitions that are filed with the Georgia Department of Labor.
Responsibilities:

• Involved in design and Implemented GDOL Web Infrastructure across all the environments (Test, QA, Training, UATand Production).
• Installed, configured, administered and supported IBM WebSphere Application Server and IBM HTTPServer.
• Deployed j2ee applications on WebSphere Application Server.
• Deployed static content on WebServers.
• Installed emergency fixes, latest fix packs on IBM WebSphere and IBM HTTPServer.
• 24x7 support on WebSphere and IBM HTTServer.
• Reviewed Business Requirements, Technical Specifications and Source to Target Mapping (STM) document for creating Test Plan and Test Scenarios.
• Analyzed the user requirements and Data mapping documents by interacting with system & data architects, developers, DBAs and business users
• Conducted testing using the standards, guidelines and structured methodologies in testing the application.
• Documented, Implemented and executed Test plans, Test cases and Test scripts based on baseline requirements.
• Created Test Cases, Test Scenarios, Test data, execution schedule and traced back to requirements for building RTM.
• Designed test cases to cover System testing, Integration testing and Regression testing and UAT.
• Tested Web Services using SOAPUI tool and monitored error logs to identify program and/or data processing errors.
• Tested DDLs, data loads, referential integrities, Views and reports
• Tested database by writing complex SQL queries to verify the database tables as part of data validation and Data warehouse testing.
• Coordinated with business SME’s and end users for requirements updates and during entire testing life cycle of migration for testing needs
• Participated in all the review meetings, Project meetings, Walk through and Defect report meetings periodically.
• Responsible for creating and managing defects for all projects as a lead tester using IBM Rational Clear Quest and HP Quality Center.
• Conducted Defect Triage meetings with Developers and Business users on daily basis, and also responsible for creating defect management reports using Quality Center for Executive Management and Steering Committee
• Responsible for planning test execution schedule, and allocation of resources, tracking and monitoring actual work progress against planned work assignments as part of Data Center Migration.
• Conducted JAD session with business users and created business requirements for UI project and also conducted peer review of requirements
• Updated business requirement document as per peer review comments and baseline BRD in Requisite Pro /Quality Center.
• Created process flow mappings and use cases for UI project and presented to Business users.
• Responsible for creating testing status reports and summary reports for Go/ No Go decision making and supported application deployments as part of migration.

Environment: IBM WebSphere 6.x/7.0, IBM HTTPServer 6.x/7.0, WebSphere Cast Iron, SNA, CTG, windows 2008 server, DB2, Oracle, SQL Server, UNIX, Quality Center 11, QMF, WIN SCP, Putty, IBM Rational Suite, Java, J2EE, Web Services, SOAP, XML, Business Objects and MS Office

Confidential,
Redmond, WA April 2007 to Dec’2007
Data Warehouse/ETL QA Analyst
BICOE (Business Intelligence Center of Excellence) – Allocations
Responsibilities:

• Reviewed requirements and technical specifications, Source to Target Mapping (STM) document for creating Test Plan and Test Scenarios.
• Created Test Plans, Test Cases, Test Scenarios, Test data and test strategies.
• Performed technical tests such as installation scripts validation for build installation
• Performed System testing, regression testing, Integration testing and User Acceptance testing (UAT)
• Performed data validation on Source, Staging and target dimension and fact tables.
• Developed complex sql queries to validate data in Cube against data mart.
• Executed test cases/scripts and documented test results.
• Performed Security testing on most critical modules.
• Tested SSRS reports as part of data validation between cube and reports.
• Created bugs and issues during testing in VSTF and communicated to team in Test Triage meetings on daily basis.
• Created test reports and status reports and presented to Test lead on daily basis and to the management on weekly basis.

Environment: .Net 3.5, Server 2008 (SSAS, SSIS, SSRS), Visual Studio Team Foundation (VSTF), METaL, Excel and Business Intelligence Development Studio (BIDS).

Rochester, MN Oct’2006 to Feb’2007
Business Intelligence QA Analyst
EDT (Enterprise Data Trust) - Cancer Center: I was a member of a QA – Team testing Enterprise Data Trust - Cancer Center applications where each project is called as a concept and full SDLC is followed for each concept.
Responsibilities:

• Analyzed Functional specifications and requirement documents to identify the gaps and reported identified gaps to the project teams to raise change requests.
• Created Test Plans, Test Procedures and Test Cases.
• Conducted System Testing to test each and every part of the System.
• Responsibilities include functional, integration and User acceptance testing.
• Developed Request for Change (RFC) documents for the defects in the application.
• Prepared Test data (Input Data) strictly following referential Integrity for testing large quantities of data.
• Transformation rules applied are thoroughly reviewed; data is tested efficiently at each level of ETL process by writing complex SQL queries against the source and Target.
• Validated the given DDLs, tested data loads and verified objects created.
• Participated in various project status meetings and updated testing status
• Executed test scripts and verified the results.
• Interacted with developers, Business & Management Teams and End Users.
• Participated in Walkthrough and defect report meetings periodically.
• Mentored team members (5) on testing process and conducting testing.
• Extensively worked on Quality Center 9.0 for Defect reporting/tracking.
• Documenting and communicating test results using Quality Center 9.0.

Confidential,
Minneapolis, MN/India June2005 to Sep’2006
ETL QA Analyst

Member of a large EDW-QA team (15) testing Consumer Credit Group (CCG). Each project is called an MR (Maintenance Request) and a full SDLC is followed for each MR. This application comprises of many modules which are used by the Business Users to obtain the information as and when needed.
Responsibilities:

• Prepared test plans for the whole system.
• Worked in all phases of the QA Life Cycle and SDLC with timely deliverables.
• Reviewed Business requirements and System requirement specifications documents and developed test scenarios.
• Test cases were designed to cover System testing, Regression testing and Integration testing.
• Participated in walk through meetings with project manager, developers, business analysts and DBAs.
• Transformation rules for all the columns (STM) are tested writing complex sql queries, DDL statements are verified and the objects created are validated.
• Executed test cases/scripts and documented test results. Reported Bugs through Quality Center bug-tracking tool.
• Submitted status and test evaluation reports to Test Lead. Constantly updated test deliverables by maintaining Test Matrix for latest test results information by tracking requirement changes using Clear Quest.

Environment: Quality Center 9.0/8.2, Data Stage, Clear Quest, HTML, J2EE, Java, VB Script, JavaScript, XML, HTTP, Windows 2000 server, Cognos and Oracle 9i.