Post Job Free

Resume

Sign in

Data Salesforce

Location:
St. Louis, MO
Posted:
November 05, 2020

Contact this candidate

Resume:

Kaveri Jaiswal

Sr. Business System Analyst/Product Owner

Business System Analyst with over 8 years of experience in Finance, Banking, Retail, Procurement and Supply Chain industry with a thorough knowledge of Agile Safe, Software Development Life Cycle (SDLC), documentation, UAT, and systems implementation and integration. Experience working in a SAFe framework as a Product Owner/Business Analyst, with understanding in writing f eatures, capabilities and stories for various ERP systems. Agile product ownership experience in software development environment.

Skills

Experienced, working with various Software Development Life Cycle (SDLC) methodologies such as Waterfall and Agile methodologies such as SAFe, Scrum-Waterfall (Hybrid), Kanban and Scrum.

Executed responsibilities with an understanding of the product vision, strategic objectives, and priorities

Translated high-level strategy & product direction into features, epics and user stories; prioritize in the product backlog for selection for sprint backlog

Prioritized the backlog according to business value and stakeholder input.

Works with engineering to decompose business epics and stories into system level stories and/or designs

Prioritizes the iteration and defect backlog grooming and management.

Involved with extensive client interactions and converting business functionalities into Service Oriented Architecture (SOA) models across heterogeneous IT environments.

Facilitated elicitation techniques such as Document Analysis, Interface Analysis, Brainstorming, Interviews, Focus Groups, Prototypes and Joint Application Development (JAD).

Collaborated on creating Work Breakdown Structure to define and group project’s discrete work elements using MS project and achieving the milestones by tracking schedules and evaluating the impact of changes.

Created UML diagrams such as Use Case, Activity, Sequence, Component and aware of the other diagrams.

Functional experience in crafting Workflow, business process flow, data flow, creating UI mock-ups, and wireframes using BPMN

Collaborated with QA team to document test cases, and test plans, also been a part of UAT and performing defect tracking

Tracked budget and delivery of engineering projects and releases.

Worked with 3rd party system integrators to drive process on schedule and on budget

Drive beta and pilot programs with early-stage features, Proof of concepts, etc

Excellent knowledge in Procurement Process: Subcontracting, Third-party, Consignment, Outline agreements, RFQ, Quota Arrangements, Source lists, Info records.

Analyzed source systems and business requirements, to develop User requirements, Functional and Nonfunctional requirements.

Assisted ETL developers with specifications, documentation, and development of data migration mappings and transformations for Data Warehouse loading

Strong experience in interacting with stakeholders, gathering requirements through interviews, workshops, and existing system documentation or procedures, while defining business processes, identifying and analyzing risks using appropriate templates and analysis tools using BPMN.

Evaluating business processes, anticipating requirements, uncovering areas for improvement, and developing and implementing solutions. Leading ongoing reviews of business processes and developing optimization strategies.

Experience supervising Black-Box Testing, Functionality Testing, System Testing, Integration Testing, Regression Testing, Performance Testing.

Assisted in Creating user stories using INVEST criteria, helped Product owner and scrum master in decomposing epics and themes using vertical slicing, served in writing acceptance criteria for any given user story and assisted Product Owner for prioritizing Product Backlog.

Professional Certifications

Alteryx Designer Core Certified

SAFe 5.0 Certified Product Management/Product Owner

Education

Bachelor of Engineering, Information Technology

Master’s in Business Analytics

Tools and Technologies

Business Skills

Business Process Analysis, Business Process Improvement, Use Case Modeling, JAD Sessions, Risk Analysis, Requirements Workshops, GAP Analysis, SWOT Analysis, Document Analysis, Impact Analysis, Data Analysis, Process Mapping, BPMN.

SDLC Methodologies

Waterfall, Agile Scrum, Scrum-Waterfall Hybrid

Project Management Tool

Microsoft SharePoint, Confluence, JIRA, MS Visio

ERP Tools

Coupa, Ariba, SAP-MM, MetricStream, Salesforce

Requirement Management

JIRA, Rally, Confluence

ETL tools

Alteryx

Testing Tools

HP ALM, Selenium, Jenkins (Continuous Integration), MSI Issue Portal, Bugzilla, Remedy

Databases

MySQL database, Oracle, SQL server

Reporting Tools

Tableau, Power BI

Programming Language

PL/SQL & Java, C, C++, HTML

Professional Experience

Mastercard, O’Fallon, Missouri Jan 2018- Present

Sr. Business System Analyst

Scope: This project was to implement third party risk data management tool-MetricStream and to have this integrated with the tools like Coupa, Oracle, Workday & Salesforce. The integration plan was implemented in two different phases-Phase -2A (Oracle -MSI Integration & MSI-Coupa Integration) and Phase 2B (Coupa-MSI & MSI-Workday).

Responsibilities:

Analyzing existing reporting architecture and creating data migration/system integration strategies for the Coupa E-procurement, Oracle, Ariba and Metricstream third party risk management tool.

Assist in the creation, review, negotiation, analysis, approval, and activation or identified sourcing agreements of supplies and equipment.

Work with buyers Sr. buyers to resolve ongoing exception management issues identified.

Meet with vendors for business reviews, new product implementations, contract compliance issues and price negotiations.

Working in a cross functional team environment comprised of technical staff, application end-users, business owners and an external vendor to provide functional application support for the Coupa application implementation, and roll-out.

Well versed in project management tools like MS Project for project planning, Project scheduling. Organized JAD sessions to gather requirements at various stages. Worked extensively with the team to meet business requirement, create prototypes and analyze workflow.

Preparing documentation on data integrating from salesforce to MetricStream and MetricStream to Oracle Database.

Experience in implementing Salesforce Service Cloud support in lightning through Web to Case, Email to case and Chat Bot.

As a Salesforce administrator, responsible for providing user access configuration, mapping field and relationships, layouts and creating customized objects.

Assisted developing out of box and extended Salesforce functionalities using force.com customization - Apex, Visualforce, Triggers, Process Builder, Workflow Rules, Approval Processes, Validation Rule, Email Services, Reports and Dashboards.

Participated in projects of a cross-functional nature and delivered processes and applications to customers.

Developed, documented and executed test cases and scripts and coordinate UAT Testing with the Business Users

Developed Test Cases and prepared test scripts using SQL to test transformation logic in the data.

Experienced in creating Business Requirement Documents, User Requirement Specification, and Functional Requirement Specifications. Experienced in creating Data Flow Diagrams, Use Cases, State Diagrams, Sequence Diagrams, Component Diagrams, Use Case Diagrams & Activity diagrams.

Providing technical support for coupa procurement supply chain application.

Going through the release note and coordinating with coupa supply chain team for upgrade activities.

Querying various databases using PL/SQL and Toad for various adhoc requests from clients.

Assisted QA team in developing Test Scripts, Test Cases and Test Plans for the User Acceptance testing.

Used JIRA for drafting the features and user stories and managing the requirement.

Joining forces with the Scrum Master on the project to ensure that the organization is following Agile SAFe practices.

Documented artifacts like Functional Specification Documentation, with Business Use cases & Use Case Diagrams, Technical Specification and Technical integration documentation with UML diagrams, Requirements Traceability Matrix for the Development and Testing team's use.

Executed SQL Queries to provide the testers with sample test data.

Tracking the changes to requirements in change control log and gaining approval by business team and management before converting for development.

Acted as a focus point for technical and third party risk data management related to third party onboarding and monitoring process, Due Diligence Questionnaires, Issue management and Supplier Information Management services in MetricStream.

Lead and own data integrations using SFTP and Restful API’s with on premise and in cloud applications. Managed error handling scenarios troubleshoot and logged them into Remedy tool.

Lead the testing with QA team for designing Test Plan and Test Cases for integration testing, UAT and regression testing.

Expertise in defect tracking in ALM and Bugzilla portal for identifying and documenting all issues, functionality gaps and new functionality needs. Addressed the logged defects for an easy communication with developers and testers to ensure quality assurance and ticket closure.

Tableau was used as a data visualization tool to communicate information clearly and efficiently via the statistical graphics, plots, information graphics, tables, and charts selected throughout the project.

Environment and Tools: Waterfall, Coupa, Metricstream, Oracle, Ariba, MS Visio, MS Project, Sharepoint, Remedy, Bugzilla,BPMN, MSI issue portal, Salesforce

Ally Financials, Charlotte, NC Oct 2016- Dec 2017

Business Systems Analyst/ Product Owner

Scope: The scope of the project is to automatically aggregate operational risk data from 150+ banks across the organization, the client found it difficult to get timely visibility into their overall risk data and loss profile. We have integrated MetricStream into our systems which provided a centralized, cloud-based operational risk data management solution that scales across our organizational silos, integrating and rolling up risk data management in real time, and thereby strengthening operational risk transparency. This, in turn, has helped us to enhance decision-making, as well as compliance with Basel II.

Responsibilities:

Organized and facilitated meetings with the management and the development team, conducted requirements gathering sessions with the purpose of defining the functional business and system requirements.

Conducted Business Requirement sessions in the form of questionnaires and scenarios with end users, Product Owners and Subject Matter Experts (SME) and the developers.

Involved in discussion with vendor MetricStream audit team to handle issues and support in the deployment process with new patches to DEV, UAT, Prod and Pre-Prod environments.

Writing technical documents for the specified requirements and following up till the requirement moves to production including integration, testing, and deployment.

Maintaining partnership with vendor (Coupa & System Integrator) as well as business owners in sourcing, Risk and legal. Lead and own data integrations, system changes and enhancements and additionally support upgrades and other system support activities.

Created Business Requirements Gathering sessions in the form of questionnaires and business scenarios with the end users, subject matter experts (SME) and the developers. Gathered user and business requirements through interviews, surveys and prototyping.

Analyzed and prioritized user and business requirements as system requirements that must be included while developing the software. Planned and defined system requirements to Use Case, Use Case Scenario and Use Case Narrative using the UML methodologies.

Created Use Case Diagrams, Data Flow Diagrams, Activity Diagrams and Sequence Diagrams in MS Visio.

Created Business Requirements Gathering sessions in the form of questionnaires and business scenarios with the end users, subject matter experts (SME) and the developers. Gathered user and business requirements through interviews, surveys and prototyping.

Proficient in querying a variety of databases like Oracle, SQL Server, MS Access using SQL, PL/SQL.

Conducted JAD sessions with management, SME, vendors, users and other stakeholders for open and pending issues. Implemented SOA concepts (search oriented architecture) for the application and implemented search engine based techniques.

Responsible for identifying business Use Cases and creating functional Use Cases model, Business flow diagrams, Activity/State diagrams and Sequence diagrams and functional specification documents using UML in MS Visio.

Creating artifacts for system architecture document, supplemental requirements document, architecture diagrams, verifying technical production infrastructure, designing and executing performance tests; and documentation.

Organized and managed all phases of the software testing process, including planning tests, writing test cases, executing tests and tracking defects using Quality Center.

Worked extensively with the QA team for designing Test Plan and Test Cases for the User Acceptance testing (UAT) and validation.

Also used Power BI for creation of better ad-hoc reports by conductive better predictive analytics

Environment: Scrum, JIRA 7.2, MS office suite 2016, Salesforce Winter’16, Oracle 11g, SAP ERP, MetricStream, Jenkins 2.0, HP- Quality Center 12.0, Microsoft Power BI, SAS, Datawarehouse

Accenture Pvt. Ltd. Rajasthan, India Dec 2014 – Nov 2015

Business System Analyst

Scope: The project was to migrate data from the source system to the target system. Create purchase orders/services for the vendors and deliver material/resources following procure to pay(procurement and supply chain).

Responsibilities:

Actively Involved in Pre-Analysis of project with SME (Subject Matter Experts) and Developers

Involved in requirements analysis and development using Activity, Use Cases, Sequence diagrams and Visio approach and produced detailed use cases and functional specifications for all the required users and teams.

Conducted and managed meeting sessions with users, team members, business managers for collection of requirements and business process information. Designed the application using Unified Modeling Language.

Utilized and maintained two major software systems of the company used in the consolidation of monthly Balance Sheets and P/L.

Analyzes orders and requisitions for accuracy and acts as primary liaison between departments and vendors to resolve PO discrepancies i.e. items not received, shortages, credits and pricing . Ensures corrective action taken, documents outcomes and works closely with Customers, Sourcing, Vendors and Accounts Payable in resolving discrepancies.

Manages the designated suppliers and departments of responsibility in regards to purchases, back-orders and returns. Provide key reports to departments i.e. back order reports and training end-users on how to use Supply Chain Tools.

Analyzes back order situations, provides back order reports to departments, identifies with vendor substitutions options when necessary, manages vendor. Report trends and involves Sourcing team when new vendor or product line is needed.

Conducted book allocations and collected requirements for preparation of tax workbooks. Developed several excel-based Macros for accounting and taxation.

Computed and inputted month end adjustments and closing entries, processed, maintained and communicated financial and informational data to traders and evaluated and computed daily and monthly cash reconciliation reports.

Responsible for writing Functional Requirement Specifications (FRS) and User Requirement Specification (URS).

Utilized Rational Unified Process model for the different phases of the application development of the Software Development Life Cycle. Conducted daily build validation and report status to product and QA teams.

Monitored order progress and their timely delivery at site after delivery of contract in SAP-MM.

Liaising with purchasing, engineering, accounts & finance, warehouse & Logistics for timely delivery of the material.

Review and analyze gathered data to locate was areas in the supply chain process and develop methods to improve

Research partner companies and seek to negotiate best-price contracts to increase business revenue

Communicated with foreign vendors for delivery of the material to required export and arrange necessary invoices, providing the same with our clearing agents and giving clearance to vendors for delivery.

Environment: SQL Server, MS Word, MS Excel, MS PowerPoint, and MS Visio, HP QC, UAT Testing, SharePoint, Enterprise Architect 6.5, Oracle 10g, MS Project, MS office suite, Coupa eProcurement, Vendor Compliance Management, PO / Requisition Processing, Vendor Management

Sodexo Solutions, Noida, India Nov 2013 – Dec 2014

Business Systems Analyst

Scope: The project was about handling facility management, invoicing and vendor management, managing engagements with various

Responsibilities:

Responsible for the creation of Test Strategy and Design documentation, test scripts and expected results, use cases, requirement/testing coverage and defect tracking.

Identifying the defects during system testing and log the defects in Team Foundation Server TFS . Make sure that the defect status is updated on a daily basis.

Act as a scrum master and running the daily scrum meeting with both offshore and onsite testing and development teams.

Interacting with the development team and retest the fixed issues identified during system and User Acceptance testing and see that the issues got resolved.

Interacting with business and communicate the fixed defects that ready to test in both systems and UAT testing and getting the sign off.

Preparation of Taxability Matric for each module, these metrics could be an inherent goal for the test team as well as what is being testing.

Identifying the needed testing effort by calculating the sizing needed for the given release and plan the effort needed for the same.

Figure out what skills are needed and balance the test resources accordingly with those needs based on their own interests as well. Also identify if there are skill gaps and plan training and education sessions for the identified test resources.

Identify the tools for test reporting, test management, test automation, etc. and educate the team as required to be able to use those tools. Again, plan knowledge transfer sessions in case required for team members for the tools they would use.

Initiate the test planning activities for test case design and encourage the team to hold review meetings, ensure the review comments are incorporated.

Check if there might be any delays in achieving the schedule and hold discussions with testers to figure out the issues they may be facing and strive to resolve them.

Present the timely status to the stakeholders and management and to keep them inform about the progress of testing work being done

Captained meetings with the management, portfolio managers, quant analysts for analysis and prerequisites of the project.

Handled documents for security purposes and regulatory compliance within the registration, arrival departure notification prohibited area permission, and visa extension.

Understood end to end processes in sales and distribution, material management and finance.

Environment: Waterfall, MS Office, SAP-MM, Ariba, MS Excel, MS Word, MS Visual Studio, Share point, testing methodologies, MS Outlook, Manual Testing, VB.NET, Visual Studio 2010, .NET, SQL Server 2008, Web testing, UAT TFS Team Foundation server

Fabindia, New Delhi, India July 2012 – Nov 2013

Business Analyst

Fabinida had a legacy reporting system that implemented standard data warehouse (EDW) which had issues implementing loss prevention detection resulting in negative impact on revenue. The project was to improve their centralized data repository which enabled alert-based reporting capabilities, ability to track and manage losses and KPI tracking.

Responsibilities:

Interviewed Business Users to define the vision and scope of the project, gather high level requirements and define business rules.

Performed Gap Analysis to identify the shortages of the existing system, identifying the requirements for modification in the proposed system and making recommendations based on findings during requirements gathering

Conducted Impact Analysis to identify potential change issues with the legacy system

Gather system functional and non-functional requirements

Documented Activity Diagrams, Data Flow Diagrams, Use Case Diagrams, Sequence Diagrams

Prepared Functional Requirement Document (FRD), Business Requirement Documents (BRD) and System Requirement Specification (SRS).

Writing SQL Queries on different Oracle databases and pulling sample data into excel.

Created wireframes using mock-flow and detailing out all required functional specification

Provided source to target mapping (STM) for the new application system

Identify KPIs to measure performance of the business, created balance scorecards, report specs to track the status of the business

Created and executed SQL Queries for analysis and migration.

Document and prepare User Acceptance Testing (UAT) plan and obtaining the necessary signoffs from business users.

Made sure all deployment schedules were on time and provided needed user training.

Environment: Waterfall, Microsoft SharePoint, MS Visio, MS Office Suite 2007, Wireframes, MSSQL Server, UML, Main Frame, Oracle DB, MS Project, HTML 5, CSS3, PL/SQL.



Contact this candidate