PROFESSIONAL SUMMARY:

• Certified SALESFORCE Administrator with ADM 201.
• Experience professional with 10+ years IT experience with 7+ years of experience in implementation, configuration, design, analysis and understanding of SFDC CRM Application.
• Experience in Lightning Components and Salesforce Lightning Design System (SLDS) with Salesforce Marketing cloud.
• Well experience with Visual Force, APEX, Force.com platform, Triggers, Components and Controllers in Salesforce Classic &Lightning.
• Creating Business Requirement Documents (BRD), Functional Requirement Documents (FRD), Business process documents, user manuals.
• Strong Knowledge in Salesforce Administration and Customization, Data Validation, Sales, Marketing, Customer Service and Support Development team.
• Experience in developing Entity - Relationship diagrams and modeling Transactional Databases and Data Warehouse using tools like Erwin, ER/Studio and Power Designer.
• Directly responsible for the Extraction, Transformation & Loading of data from multiple sources into Data Warehouse.
• Strong knowledge database and data manipulation skills using SQL. Worked in SQL Server and Salesforce database structure.
• Well versed in Business Process Modeling with expertise in creating User Cases, Sequence Diagrams, Class Diagrams, Activity Diagrams, writing User Stories.
• In depth knowledge of Software Development Life Cycle (SDLC), having thorough understanding of various phases like requirements, analysis/design, and development and testing.
• Good knowledge of database relationships and concepts; worked on RDBMS like MySQL and MS SQL server.
• Experience in other ETL tools like DTS and SSIS (SQL Server Integration Services).
• Design and implemented SQL queries using joins, unions, outer joins, group by and aggregate functions to extract data from different data sources. Knowledge of Relational Database Management systems (RDBMS).
• Experience in creating ETL test scenarios and test cases and deployment plan by using ETL mappings
• Extensive experience in Test Planning, Test Preparation, writing Test Scripts, Test Execution and validating defects/bugs Integration/system testing, Performance testing, User Acceptance testing (UAT) and Regression Testing.
• Possess excellent interpersonal, written, verbal communication skills and strong analytical, problem solving, decision-making skills coupled with the proven ability to work independently or as a member of a team successfully.
• Hands-on experience working with large data values SOQL, SOSL, Aggregate and Dynamic queries and fine tune of queries in Apex Classes &- Triggers.
• Adept in reviewing Test Procedures, creating Test plans, Test Scenario, executing Test Cases, Test Data reviewing and maintaining and executing detailed Test scripts for User Acceptance Testing (UAT) for CRM applications in Salesforce environment.

TECHNICAL SKILLS:

SDLC Methodologies: Agile, Waterfall, SAFe, RUP

Technical Skills: Technical Project Management, Agile Methodology, Waterfall Methodology, Technical Training, Technical Writing, Data Migrations, SQL Server Installs, Active Directory Management, Advanced Microsoft Excel

Databases: SQL Server … MS-Access, MySQL, T-SQL Oracle

Testing tools: SOAP, Test Director, HP QC, HP ALM

Databases: Oracle, DB2, MS SQL Server, SQL Server Management Studio (2012)

Tools: ESP, MS Visio, MS Excel, MS PowerPoint, MS Word, MS Project, SharePoint, Jira, Confluence.

Salesforce Tools: Service cloud console, Salesforce CPQ, Sales Cloud Einstein, Reports, Dashboards, Analytic Snapshots, Custom Objects, Page layouts, Communities, SSO, Lightning Apex Data Loader, MS Project, SharePoint, Apttus CPQ & CLM, ANT Migration Tool.

PROFESSIONAL EXPERIENCE:

Confidential - San Francisco, CA

Salesforce Business System Analyst

Responsibilities:

• Implemented and customized Salesforce customer relationship management (CRM) for Marketing, Sales and Case Management also implemented sales cloud and service cloud to improve customer retention and service delivery process improvement.
• Gathered business requirements and capturing them to BRD's /SRF's.
• Identified, planned and implemented new Salesforce.com features and functions (new screens, workflow, force.com objects, reports, apex code) in response to business needs in Sales Cloud.
• Interacted with the stakeholders to understand the current state of system and defined future needs based on analysis of business requirements after implementing gap analysis.
• Successfully used Agile/Scrum Method for gathering requirements and facilitated user stories workshop.
• Worked with technical resources to analyze data, source systems, data models, and generate source to target mapping documentation.
• Developed Process architecture using Business Requirement Document (BRD).
• Implemented the requirements on Salesforce.com platform and Force.com IDE Plug-in using Eclipse.
• Gathered business requirements and break them down into relevant, accurate and detailed functional requirements and user stories.
• Worked on Apttus CPQ(Configure Price Quote ) to produce accurate and highly configured quotes making all of the complex product, pricing, and business rules centralized, automatic and available in real-time.
• Designed and developed Use Cases using UML and Business Process Modelling.
• Used MS-Visio for flow-charting, process model and architectural design of the application.
• Researched and prepared economic and accounting reports on rate of return, depreciation, working capital requirements, investment opportunities, investment performance, and impact of governmental requirements.
• Built Salesforce reports as requested by management, along with standard sales reports.
• Created mapping documents to define and document one-to-one mapping between source data attributes and entities in target database.
• Utilized defect tracking tool JIRA for reporting bugs/defects in functionality. Conducted weekly status meeting with development teams for defect resolution. Utilized SQL for querying database tables during testing.
• Created Ad-hoc reports by data analysis using MS-Access via ODBC or TOAD for data import and SQL analysis of reconciling data
• Performed User Acceptance testing, verification testing and System testing manually.

Confidential - Portland, OR

Salesforce Business System Analyst

Responsibilities:

• Reviewed, updated, and created Business Requirements Documents - (BRDs) and Functional Requirement Specifications (FRDS).
• Administrated and monitored the company's Salesforce sales cloud application by creating the workflows for automated lead routing, lead escalation and email alert.
• Used for most complex products, pricing or channels, CPQ boosts sales effectiveness by giving you the power to create the best quotes possible.
• Worked with business stakeholders to rank and prioritize the backlog, and to ensure user stories are ready for the next sprint.
• Communicated the power of the Community Cloud to stakeholders and defining Salesforce lighting components to replace visual force pages.
• Executed SOQL queries in workbench and data loader to verify Product /Pricing staging data in SFDC/CPQ.
• Implemented Apex Data loader "Command Line Interface (CLI)" to automate the data loading process for the sand box refresh activity.
• Implemented Apex classes, Visual Force Pages, Apex Components and Controllers, Triggers, Test Methods and wrote SOQL/SOSL queries.
• Tested the ETL process for both before data validation and after data validation process. Tested the messages published by ETL tool and data loaded into various databases
• Designed and developed UNIX shell scripts as part of the ETL process, automate the process of loading, pulling the data.
• Designed and implement updates to the Salesforce.com solutions using best practices through standard configuration.
• Ensured data integrity throughout Salesforce as well as between Salesforce and internal systems.
• Created complex SQL queries in Toad to analyze data defects, test results and retested fixes.
• Followed Agile Methodology to analyze and design business needs in an iterative manner.
• Worked on Requirement Analysis, Coordinated Designing of Documents and development, writing, execution of detailed Functional Requirement Document and Test Scripts.
• Created Process Flow and Data Flow Diagram in MS Visio by gathering and analyzing business requirements.
• Utilized technical writing skills to create effective documentation and training materials.
• Tested web services by generating XML, SOAPUI Requests and validated the corresponding XML, SOAPUI Responses.
• Create User Stories and define acceptance criteria.
• Used JIRA for continuous update with project schedules, quality, issues & managing resources.
• Created Test Plan, Test Cases and Test Scripts with respect to Test plan.

Confidential - Bellevue, WA

Salesforce Business System Analyst

Responsibilities:

• Involved in Analysis, design, development and implementation of salesforce.com applications.
• Incorporated Salesforce Sales Cloud Best Practices into the solution decisions for the future state Opportunity management and order management capabilities.
• Created User Stories into Product Backlog Items (PBIs) and lead PBI grooming sessions for Prioritization and Sprint planning.
• Created Use cases and UML models like Use-Case diagram, Activity diagram and Sequence diagrams in MS Visio.
• Worked in Agile and waterfall Methodology with emphasis on creating Epics, user stories, acceptance criteria, backlog grooming, sprint planning, sprint review, sprint retrospective and conducting daily scrum.
• Involved in building the ETL architecture and Source to Target mapping to load data into Data warehouse.
• Trained others on Financial Management functions and technologies involved for operational excellence.
• Ensured all invoice validation processes were completed on time for client projects using PeopleSoft financial system.
• Wrote triggers in SOQL, SOSL to make complex validation process using Apex Classes and Used Data Loader to insert, update, and bulk import or export of data from Salesforce.com Objects, to read, extract, and load data from comma separated values (CSV) files.
• Developed ETL technical specs, Visio for ETL process flow and ETL load plan, ETL execution plan, Test cases, Test scripts etc.
• Responsible for ETL development with successful design, development, and integration of components within the Talend ETL Platform.
• Used SQL for querying and analysis purposes on various source tables and conditions applied
• Identified & Isolated software defects, ability to find the bad defects / bugs quickly, report and verify defect fixes via JIRA.

Confidential - San Francisco, CA

Salesforce Business System Analyst

Responsibilities:

• Worked on various salesforce.com standard objects like Accounts, Contacts, Leads, Opportunities, Activities, Dashboards and Reports.
• Provided direct support to Salesforce users during post-implementation issues and migrated metadata from sandbox to production.
• Created the objects and developed the UI based on client requirement using the declarative approach of Salesforce.com.
• Standard and custom field creation and maintenance at the direction of B2B Salesforce Manager on the platform and on service cloud.
• Agile experience included writing stories/epics for specifying business requirements for enhancing future state. Conducted daily scrums. Initiated backlog reviews of epics and stories. Prioritized, sized and sequenced stories.
• Coordinated requirement gathering sessions and design reviews with business users and technical teams across the organization to bring forward best possible solutions.
• Created UML diagrams such as Use Case Diagrams, Activity diagrams, Decision Tree Diagram using MS- Visio to define the business process.
• Collaborated with external business partners on projects dealing with systems integration, reporting and XML data transfer to identify data elements for data mapping and migration.
• Used XML and other type of formats to transport, store, and structure and represent data and derived information from source to destination data maps.
• Maintained traceability through updates to the Requirement Traceability Matrix (RTM) using Requisite Pro.
• Translated business requirements into functional/technical specifications, User Stories, and Acceptance Criteria.
• Manipulated large amounts of data using MS Excel, Pivot Tables, v/h-Lookups, and MS Access.
• Analyzed data through querying via SQL from various database sources(i.e. Oracle, SQl Server, MySQL)
• Retrieved and validate business requirements to set up SQL queries for reports
• Created test cases in Excel and executed in JIRA and HP QC
• Worked extensively with the QA team for designing Test Plan and Test Cases for the User Acceptance testing (UAT) and validation.

Confidential - Seattle, WA

Business System Analyst

Responsibilities:

• Managed Sprint backlog list and help identify features for upcoming releases.
• Participated in daily Agile Scrum "Stand-up", Biweekly Sprint Planning and Retrospective Sessions and updated the team on status of upcoming User Stories.
• Participated in testing of procedures and data, utilizing PL/SQL, to ensure integrity and quality of data in data warehouse.
• Created and Maintained Supporting documents (technical, business, project level and sops) to meet SDLC standards.
• Worked with Product owner to review the potentially shippable increment during review meeting and decided which of the features are done.
• Tracked and maintained user requested enhancements and changes in product backlog.
• Documented business workflows in UML diagrams (State diagrams) and forwarded them to stakeholders to review.
• Prepared the Business requirement Document (BRD) and system requirement document (SRD) for the enhancement of the existing services.
• Created workflow diagrams, UML diagrams, process models, activity diagrams, use cases, for incorporating design changes in the system.
• Developed business requirement for online web form for capturing application information
• Created, executed and translated manual test cases and scenarios into automated test scripts in order to validate functional requirements using HP Quality stage.
• Collaborated with Quality Assurance Analyst in testing.
• Developed test cases and performed UAT testing for all the files and reports