We provide IT Staff Augmentation Services!

Sr. Business Systems Analyst Resume

4.00/5 (Submit Your Rating)

Framingham, MA

SUMMARY:

  • 8+ years of diversified experience in IT industry working as a Business Systems Analyst
  • Strong domain knowledge about Supply chain management in multiple areas like; Procurement, Strategic sourcing, supplier allocation, Inventory management, Point of sale, Strategic Component Identification, Value Chain Analysis, Order Processing, invoicing, JIT, Vendor management, material handling, logistics etc
  • Demonstrated expertise in translating user requirements into System Specifications and mapping the process design for SDLC (Software development Lifecycle) with documenting and managing business requirements
  • Worked and exposed to various Agile - lean and traditional software development environments and methodologies including Agile-scrum, Waterfall-Scrum hybrid, Waterfall, Scrum ban, XP and Spiral
  • Excellent liaison and fluent communicator with Business Users, Key Business Stakeholders, Subject Matter Experts (SMEs), Project Managers, Scrum Master, Testers, Developers, Architects and Deployment Analysts
  • Conducted detailed project analyses such as Business Processes analysis (AS-IS & TO-BE), GAP analysis, risk review & assessment, Impact assessment, Cause and effect analysis (root cause analysis), Effort estimation, maintenance of risk register, Cost-Benefit analysis, Ad-hoc, SWOT analysis & Feasibility study
  • Well versed with Requirements Elicitation Techniques like Brainstorming, JAD sessions, Job shadowing, Survey/Questionnaire, One-To-One Interviews, Prototyping, Requirements Workshop & Focused Group Sessions
  • Proficiency in documenting artefacts such as Business, functional and systems Requirements Document
  • Took part in breaking down, sizing of stories, prioritizing, tasking and distributing the requirements within SCRUM
  • Experienced in creating low-medium fidelity representations as a part of wireframing & mock-ups
  • Designed use case diagrams, activity, sequence diagrams to give a better understanding of the business processes
  • Created use cases considering parameters like triggers, pre-conditions, post-conditions, alternative flow, exception flow, special requirements, normal flow/ happy path and various business rules
  • Assisted programmers towards techniques like TDD (Test Driven Development), BDD (Behaviour Driven Development) and ACTDD (Acceptance Criteria Test Driven Development) based on the certain business needs
  • Used Ms Project in Project Management, Scheduling, Allocation of Resources, Gantt-Chart View Creation, WBS (Work Breakdown Structure), Critical Path Analysis, Budgeting, and End-To -End task & Milestone Tracking
  • Efficient in handling change requests and assessing change requests through impact analysis on triple constraints
  • Experienced in creating conceptual and logical data models that captures data flows and elements
  • Well versed in creating Data Flow Diagram, Entity Relationship diagram, for database modelling
  • Good knowledge in implementation of dimensional data modelling (Star & Snowflake schema), Dimensions, Facts data modelling & OLAP (MOLAP & ROLAP), Data aggregation, Data mapping, Data integration
  • Performed OLAP operations such as slicing, dicing, roll-up, drill down, pivoting (transpose) and summarization
  • Performed ETL process for transformation of data sources into one integrated system (Transformation performed include Sorter, Filter, Source Analyzer, Aggregator, Joiner, Lookup, Stored Procedures, Expression and Router)
  • Skilled in performing SQL queries like select, update, delete, create, alter, drop, joins etc using MY SQL WB
  • Understanding of request to the web service, to specify REST API CRUD operations having HTTP verbs on GET, POST, PUT & DELETE on application layer that utilized POSTMAN as the powerful HTTP client to test web services
  • Facilitated end-to-end Web Service testing on SOAP & REST API through Swagger Tools, SOAP UI & POSTMAN
  • Experienced in Black Box, Manual, System, Performance, Load, Stress, Regression, Automated, Functional, Non-Functional, UAT, Smoke and Sanity Testing of applications with knowledge on Software Testing Lifecycle by creating Test plan, Test Scripts, Test cases, Test Scenarios, Test reports and Requirements Traceability Matrices
  • Managed Traceability matrix to trace Business requirements, functional requirements and test cases
  • Sound knowledge of Relational Database Management System (RDBMS), Object-oriented programming, Business Process Re-Engineering, & Business Intelligence tools such as Power BI, Polaris & Tableau for reporting needs
  • Created, maintained and described the Scrum Product Backlog items, and prioritized them to achieve project goals
  • Created User stories (by SMART & INVEST techniques) and acceptance criteria (list method or Given-When-Then method) for an iterative and developmental model of application with the help of Scrum Master & Product Owners
  • Participated in Sprint Planning (WHAT & HOW meeting), Daily Stand Up, Sprint Execution, Sprint Review & Sprint Retrospective Meetings, and followed disciplined SCRUM framework, guidelines and rules for successful releases.

TECHNICAL SKILLS:

Categories: List of Technology/Tools used

SDLC Methods: Waterfall, Scrum, Custom-Agile (Water-Scrum-Fall) Waterfall & Scrum hybrid

Project Management, Business tools: MS Project, MS SharePoint, MS PowerPoint, MS Access, MS OneNote, MS Publisher, MS Visio, Atlassian JIRA, HP ALM, Confluence, Rally

Testing: Selenium Web Driver, HP LoadRunner, Cucumber, HP ALM, POSTMAN

Web services: SOAP API, REST API, XML, JSON, Swagger Tools, SoapUI, IBM WebSphere

Database Tools: Microsoft SQL SMS (Server Management Studio), MySQL

Reporting Tools: QlikView, Power BI, Polaris, Tableau

Technologies (CRM/ERP/ETL): Informatica PowerCenter, Salesforce marketing cloud, SF Lightning, SF commerce cloud

UI Development: HTML5, CSS3, jQuery

Wireframes, mockups: Lucid Charts, Draw.io, 0Balsamiq, MS Visio

PROFESSIONAL EXPERIENCE:

Confidential, Framingham, MA

Sr. Business Systems Analyst

Responsibilities:

  • Worked with Business users and technical team for requirements gathering, facilitation of business process discussions, solutions design, configuration, documentation, testing, user support and UAT
  • Conducted Gap analysis and Cost benefit analysis to determine the effects & performance of new features
  • Created Business Requirement Document and estimated requirements for creating KPIs such as requisitions, invoicing, spends, time periods and also created wireframes and mock-ups for visual representation & management discussions supported in creation of User stories & Acceptance Criteria along with Product owner for Sprint releases
  • Supported in development of dashboards for various modules of procurement, for each metrics by embedding reports and providing intuitive drill downs and links to exploit the full benefit of Analytics in providing reports
  • Assisted in practices such as Behaviour driven development (BDD) by writing test cases in Gherkins using cucumber
  • Involved in configuration of supplier modules and worked on supplier data clean up using Essbase cubes
  • Used SQL queries like select, insert, update, count, join, update, delete for data Analysis, retrieval, validation & modification on supplier data to get insights about requisitions, number of suppliers, order quantity status and so forth
  • Developed Conceptual and Logical data models that capture data elements and data flows using ERWIN
  • Created end to end Data Flow Diagram, Entity Relation diagram for database modelling using MS Visio
  • Assisted ETL team in mapping internal data (ERP data, customer custom data, and other enterprise OLTP data) and external data (product data, market place data) and also transformation of data sources into one integrated system (transformation performed includes sorter, filter, Source Analyzer, Aggregator, Joiner, Lookup, Expression and Router)
  • Facilitated meetings and conducted Regression Tests, UAT testing across BOM support functions & KPIs including parameters such as cost, current inventory level, lead time length, procurement material, percentage spends etc
  • Co-ordinated and prioritized outstanding defects and system requests based on business requirements
  • Managed Requirement Traceability matrix to trace Business Requirements, Functional Requirements and test Cases
  • Used Web methods of GET, POST, DELETE & PUT for testing API endpoints and validated the response, response time & error code by executing HTTP requests using POSTMAN, to ensure that API aligns with expectations
  • Collaborated with the QA/testing team/Scrum team in preparing test data for positive and negative test scenarios as per application specifications; writing test plans and performing functional, smoke and end-to-end testing

Environment: JIRA 7.12, Confluence 6.2, Ms Visio, Ms Excel, SOAP & REST API, XML, JSON, POSTMAN (5.2.1), Balsamiq mock-ups, Oracle reporting and Polaris, OBIEE 12 C, Informatica power centre 9.6, JIRA v7.4x

Confidential, Charlotte, NC

Business Systems Analyst

Responsibilities:

  • Analyzed business requirements and assisted developer to implement them to Salesforce Lightning framework
  • Performed detailed analysis of business and technical requirements and designed the solution by customizing various standard objects of Salesforce.com (SFDC) and using other Platform based technologies like Visual Force and performed feasibility analysis for integrating commerce cloud to gain deep insight of inventory management documented functional/technical specifications for on-and offshore development teams, configured Salesforce declaratively, troubleshot Apex errors and updated classes/triggers, responded to User Acceptance Test feedback
  • Worked with developers on the Approved Email templates to add the AMP Script according to the business req.
  • Assisted in creating Microsite landing page of unsubscribe page & made sure the triggered emails are configured
  • Possess working knowledge of Agile concepts such as continuous development and deployment, TDD & BDD
  • Maintained defects by prioritizing them against the backlog items and tracked them till completion using JIRA
  • Assisted the Scrum Master in the producing the Burn-Up & Burn-Down Charts and updating them when required
  • Generated Dynamic Reports with the help of Tableau for visualization of dashboard data for customer conversion
  • Used Sales Force Automation for Lead, Account and Contact Management and Approvals and Workflow
  • Created data flow and process flow diagrams to facilitate better system understanding of customer segmentation
  • Collaborated with team members to provide and maintain documentation of high-level process flow & reports
  • Involved in Conceptual, Logical data model, database schema design, metadata documentation
  • Assisted in Performing Smoke testing, White-Black box testing, Functional Testing, Regression Testing and UAT

Environment: SFDC, Salesforce Lightning, marketing cloud, SF Einstein, Commerce cloud, JRIA v 7.2.x, Tableau v 10.3.3, POSTMAN v 4.11.1

Confidential, Louisville, KY

Business Analyst

Responsibilities:

  • Worked on all phases of the system development, procedures for implementing & supporting the process
  • Interviewed Subject Matter Experts and Business/Technical Leads to gather high-level Business Requirements
  • Worked closely with Senior Product Manager to manage ranked product backlog to increase early adoption of product (Comparison of actual vs planned velocity), assess & prioritize business needs and feature enhancements
  • Responsible for creating UML Modelling Plans, Use Cases, activity diagrams and sequence diagrams.
  • Co-ordinated with developers and testers in writing complex tests by implementing BDD using cucumber
  • Involved in the creation and maintenance of the workflow plans and worked with portfolio managers to resolve issues encountered with the Order Management module & handled requirements churn with Product Owner
  • Identified and managed project risk by creating a forum where both developers and business users could participate equally in the continuous improvement of inventory processing module and supplier allocation module
  • Assisted in qualitative analysis of suppliers by assigning weights while developing the Minimum Viable Product
  • Supported the technical team while creating process components of inventory handling such as current stock handling, Re-order Point, Purchase order processing, logistics operating unit and allocation content
  • Used Atlassian JIRA to maintain and track the issues and co-ordinated with the team for early adoption of solutions
  • Acted as proxy scrum master, facilitating all sprint activities (Burndown charts, information radiators)
  • Assisted the developers in documentation of the RESTful API web servers using swagger tools
  • Conducted User Acceptance Testing (both Alpha & Beta) along with trade managers and registered representatives
  • Assisted the Testers with Performance and load testing to test the enormous load parameters within the application
  • Developed post-implementation reviews through coordination with QA teams for risk management

Environment: s: JIRA 7.0, HTML, CSS, Ms Word, Ms Visio, RESTful API, XML, IBM WebSphere (app server), Cucumber v 3.1.0, JavaScript, Java EE, HP Load Runner.

Confidential

Business Analyst

Responsibilities:

  • Created AS-IS & TO-BE processes and integrated them to show one end-to-end business model & process mapping
  • Was a point of Contact between Business Stakeholders, remote clients, and technology teams
  • Conducted Gap analysis and Cost benefit analysis to determine the effects & performance of new features.
  • Conducted JAD session, Questionnaire, one-on-one interviews to collect requirements with Product Owner about privacy levels, inclusion of Supplier system, Retailer system, customer system and related end users
  • Estimated requirements and created BRD and Product backlog items (SMART & INVEST techniques to break down user stories), supported in creation of User stories & Acceptance Criteria along with Product owner for Sprint releases and involved in Sprint Planning, Daily Stand Ups, Execution, Reviews and Retrospective meetings
  • Responsible for creating UML Modeling Plans, Use Cases, activity diagrams and sequence diagrams
  • Created wireframes & mockup screens using MS Visio to facilitate discussion before designing the UI/UX app
  • Analyzed the system using Data Flow Diagrams, Functional Hierarchy & Process Development Diagram
  • Managed and monitored requirements by developing Requirement Traceability Matrix against the test cases
  • Involved in UAT Test Plan, Test Cases and Test Strategy creation based on the functional and non-functional requirements to maintain RTM, and performed Smoke, Functional and Regression Testing
  • Performance & load testing using HP LoadRunner tool to test the enormous load parameters
  • Used Atlassian JIRA to maintain and track the requested enhancements and changes of issues
  • Acted as proxy scrum master, facilitating all sprint events and sprint reports (Burndown charts, Info radiators)

Environment: Microsoft Office (Word, PowerPoint, Excel, Access), SSIS, Microsoft Project, REST, JSON Draw.io, Rally (CA technologies), Onetime Data Population, Realtime API, HP LoadRunner, JavaScript, MySQL

Confidential

Jr. Business Analyst

Responsibilities:

  • Worked in Water-Scrum-Fall (Custom-Agile practice) to implement the technologies under specification and took rough feature requests from operational managers & real-time project stakeholders to turn them into detailed BRD
  • Worked in IPCS (Inventory Planning Control Systems), Contract Management, Risk review meetings, Management Information System & Scope planning and maximization of return on investments focusing on inventory turns
  • Implemented knowledge of QA principles, FMEA (Failure Mode Effect Analysis), Critical Path analysis, SWOT analysis
  • Prepared and maintained documentation on business analysis (that include Requirements plan, Scope Document, departmental specification document), quality management system, standard operating procedures, Engineering-work methods manual, checklists & quality assurance plan; Led internal project team client meeting, vendor meetings, resource lead for various items concerned with Information technology

Environment: Ms SharePoint, Ms Word, Ms Excel (VBA-Macro), IBM SPSS, Ms Project, and Power BI

Confidential

Junior QA Tester

Responsibilities:

  • Experience in analysing functional requirements and translate them to test cases
  • Extensive experience in testing lifecycle - Test Planning, Test Designing, Test Development, Test Execution, and Test Evaluation for quality assurance.
  • Expertise in Functional Testing, Integration Testing, System Testing, GUI Testing, Performance Testing, Smoke Testing, Regression Testing, Database Testing and User Acceptance Testing (UAT)
  • Strong experience in application testing methodology such as Agile Scrum
  • Proficient in developing, maintaining and executing test cases for different Black Box Testing methodologies

We'd love your feedback!