Sr. Business Systems Analyst Resume
Charlotte, NC
PROFESSIONAL SUMMARY:
- Around 8 years of experience as a business analyst/ business systems analyst in Supply Chain and E - commerce domain with a focus on Procurement, Resource Allocation, Planning, Pricing and Invoicing, Demand Planning & Forecasting, Reverse Logistics, Warehouse Management System (WMS), Transport Management System (TMS)
- Knowledgeable and experienced in Software Development Life Cycle (SDLC) involving traditional methodology like Waterfall and Agile methodologies like Scrum, Scrumban, Hybrid Water Scrum Fall, & Lean six sigma
- Professionally collaborated with Business Owners, Business Users, third party vendors and stakeholders
- Well experienced in performing various analysis as Gap analysis, Impact analysis, risk analysis, SWOT analysis, feasibility analysis, cost benefit analysis, benchmarking or market analysis, various Root cause analysis techniques (5 why’s, Ishikawa diagram)
- Elicited requirements using various techniques like Joint Application Development (JAD) sessions, Interview sessions, Document analysis, Focus Groups, Requirement workshops and Questionnaire over the years
- Collaborated with Project Managers in developing Concept Proposal, Project Scope Statement, Project Management Plan, Project Charter, Risk Management Plan and Work Breakdown Structure (WBS)
- Experience in writing High Level Document (HLD) like Business Requirements Document (BRD), Functional Requirement Document (FRD); and Low-Level Documents (LLD) like Functional Specifications, Systems Requirements Specification (SRS), Data Mapping Specification Document, Workflows, User stories and Requirement Traceability Matrix (RTM) as per the requirement
- Extensively used JIRA for managing Epics, User stories and contributed in Scrum Ceremonies like Release Planning, Backlog grooming, Sprint Planning, Daily stand ups, Sprint Reviews and Retrospective
- Assisted Product Owner in defining minimum viable product (MVP) features of the application under development
- Extensive experience in assisting Product owner in choosing prioritizing techniques like Moscow, KANO and estimating techniques like Agile Planning Poker, T-shirt Sizing, Bucket sizing and Relative Mass Valuation
- Experienced in both capacity-based and velocity-based sprint planning based on the level of team's maturity
- Expertise in creating UML diagrams like Use Cases, Activity & Sequence diagrams using Lucid Chart and MS Visio
- Experienced in creating Wireframes and Mock-Up Screens to visualize Graphical User Interface (GUI) as to understand the layout of the interface using tools like Balsamiq, Mockups and get them validated.
- Hands on experience in retrieving data and running queries using SQL queries like Joins, views, Sub queries and Aggregate functions like max, min, sum and average with good understanding of Procedures, Functions and Triggers. Also used Informatica Transformations (Filter, Source, Aggregate, Joiner etc.,) for Modifications
- In-depth knowledge on Databases, Data Structures, Data marts, Data Analysis, Data Integration, Data Modelling, Data Migration, Schemas, Architecture and OLAP operations i.e., Slice, Dice, Pivot, Roll-up, Drill-down
- Widespread knowledge on different types of extraction process of data from source system, transformation of the extracted data and loading the data into target system (ETL) for a Data Warehouse using (Informatica) and gave necessary technical support in the use of Informatica tool for testing
- Assisted data architects in creating Data Models, E-R Model in the form of entities and relationships and Dimensional Modeling in the form of facts & dimensions to capture the user requirements properly in the underlying database
- Good understanding of Business Intelligence tools and experienced in creating interactive dashboards with heat maps, bar graphs, pie charts, line graphs, bubble charts and pivot tables using Tableau and Excel for reports
- Strong and concrete understanding of web service concepts like HTTP, REST, SOAP, JSON, XML also under various architectures like Three-Tier & n-Tier Architecture and Service Orient Architectures (SOA)
- Assisted in API testing using POSTMAN to check if the API's are returning the data in JSON or XML format as defined in the API documentation using SWAGGER Tool and as required by process workflow
- Used GET, POST & PUT methods to test the API’s
- Good knowledge in Continuous Integration and Continuous Deployment (CICD) using Cucumber
- Experienced in defect tracking, defect analysis & ability to organize, document & track changes using Jira
- Experience of working in different phases of Software Test Life Cycle (STLC) and involved in designing Test plans, Test strategies and Test Cases for User Acceptance Testing, Black-box Testing, Functional Testing, various System Testing, Integration Testing, Regression Testing, Security Testing, Load Testing Stress Testing, and Performance Testing in both manual testing and automation testing environment
- Well versed in creation of Test plans, Test strategies, Test cases and Test scenarios for validating it against business requirements document and worked on HP Quality Center/ Application Lifecycle Management
- Adopted various engineering practiced like Test Driven Development (TDD), Behavioral Driven Development (BDD), Acceptance Test Driven Development (ATDD), Pair Programming (PP) for performance & efficiency
SKILL:
Agile: Scrum, Waterfall, XP, Kanban, Water Scrum Fall, RUP, DMAIC
Database & Data Analysis tools: Tableau, MS SQL server, Oracle, DB2, MS Access, Informatica Power Center, MuleSoft, Slicing, MS SSRS (SQL Server Reporting Service)
Programming Languages: MY SQL, JQL
Requirements, Test & Defect Management: JIRA, Quality Center, HP ALM, Confluence, Selenium, Cucumber, Load Runner
Modeling Designing: MS Visio, Sparx, Lucid chart, Balsmiq
Tools: MS SharePoint, MS Word, MS PowerPoint, MS Excel
Operating Systems: Windows XP, Windows 8, Windows 10, LINUX, IOS
Web Services API: SOAP, REST, JSON, XML, WSDL, Postman, Swagger
Integration tools: MuleSoft, Red Hat, SAP MII
PROFESSIONAL EXPERIENCE:
Confidential, Charlotte, NC
Sr. Business Systems Analyst
Responsibilities:
- Interviewed Subject Matter Experts (SME) and shop floor personnel, structured and unstructured questions to develop an understanding of business processes & analyzed the supply chain process
- Performed process mapping to understand and document the As is and To be state, thus fetching the required process improvement
- Performed document analysis, observations and JAD to gather requirements related to inventory, stock, suppliers, machine efficiency, customers, etc., from tech lead, Inventory manager, Logistics manager, SAP lead, stakeholders, and shop floor workers
- Prepared Business Requirement Document after collection of Functional Requirements from the system users that provided appropriate scope of work for the technical team for development
- Created UML diagrams like use case & activity diagrams and created high level ER diagrams using MS Visio
- Assisted the architects on developing a prototype of the ME system to get an optimal solution
- Analyzed requirements from clients based on the sales and deliveries to optimize the orders that were to be fulfilled based on SKU dimensions, pallet size, customer, and quality requirements
- Participated in Scrum ceremonies, writing down user stories, breaking down the epics and user stories into tasks, acceptance criteria and framing Definition of Done (DOD) for the PSPI
- Managed the quality of the SKU’s by keeping proper track of the OEE (Overall Equipment Effectiveness), compared the potential capacity of the machine with the real time capacity
- Efficiently studied and tested the SAP MII integration process and assisted as and when required
- Managed to get the picture of SOAP and REST API’s and tested the response between ERP and MES which were in JSON and XML format
- Gathered and documented the specifications of API’s from the API Governance Team, validated the response using Swagger
- Leveraged knowledge of the iDocs’s and BAPI’s used for EDI transfer between the ERP and SAP MII
- Created data mapping specification document and used the intelligence feature of SAP MII to create reports and dashboards of the shop floor data
- Performed SQL- CRUD operations for analyzing the data in the database, read and updated the data of the customers when needed
- Identified & documented SOAP API & REST API using Swagger & involved in testing of APIs using Postman
- Conducted User Acceptance Testing (UAT) and actively participated in scrum review and retrospective. Involved in testing of the system during Smoke Testing, Black Box Testing and Regression Testing with the help of QA team
- Created OEE (Overall Equipment Effectiveness) reports, delivery reports, real time production reports etc.
- Created wireframes and mockups of the SAPMEINT UI using balsmiq tool and presented it in the review meeting
- Worked with Tableau to create custom reports and dashboards with sales, inventory, suppliers & customer trends and reported them in the management. Used SAP MII’s Monitor to check the health of the systems integration
- Implemented JIRA for tracking and managing the user stories, tasks, bug and issue log
Environment: Agile-Scrum, JIRA, Oracle ODS, MS Visio, MS Excel, MySQL, Postman, Swagger, Tableau, SAP ERP, SAP ME, SAP MII integration, Informatica Power Center, Confluence
Confidential, Fishers, IN
Sr. Business Systems Analyst
Responsibilities:
- Facilitated interviews and cross-functional working sessions with Product Owner, Warehouse manager, Transportation lead, Technical lead and other business stakeholders and customers to enhance the company's business case
- Performed document Analysis and created process flow diagrams to understand the AS-IS process and collaborated with the team to design the TO-BE process based on the gathered requirements
- Engaged in Scrum meetings and assisted the product owner in converting the requirements into user stories, framing the acceptance criteria, definition of done and definition of ready
- Worked closely with the technical team to convert the functional requirements into technical specifications like Prototypes, Graphical User Interface (GUI) and User Interface (UI) mock-ups using Balsamiq
- Created Use Case diagrams, Use Case Templates and process flow diagrams MS Visio for the updated UI
- Performed CRUD operations on SQL & stored procedures using SELECT & JOIN for drill downs to pull data while being actively involved in reading data from varied file types, created standard and ad-hoc reports using SQL, generating delimited files and SQL script to load data into SQL tables
- Efficiently studied and tested MuleSoft Integration process and assisted as and when required
- Facilitated meetings with Salesforce Admin and Developers to determine the data that should be integrated into Salesforce platform, as it was used for powerful data integration of WMS and TMS
- Perceived knowledge of SOAP and REST API’s and tested the response of API’s which were in JSON and XML format
- Gathered and documented the specifications of API’s form MuleSoft, validated the response using Swagger
- Used MuleSoft’s AnyPoint template for Salesforce integration to simplify the process of merging data, updating Salesforce with ERP data in real time, ensuring data consistency across Salesforce instances & creating and integrating APIs that pulled data from multiple systems
- Analyzed response time of the quote, booking and confirmation, generated reports using load runner analyzer
- Conducted User Acceptance Testing (UAT) and actively participated and facilitated testing of the system during Smoke Testing, Integration Testing, Black Box Testing and Regression Testing with the help of QA
- Assisted testing team in UI testing using Selenium and documented the defects in the Jira
Environment: Agile-Scrum, MS Visio, MS SQL server, Salesforce.net, Oracle, JIRA, Tableau, Web Services, SOA, Bulk API, REST, Balsamiq, MS Office Suite (MS word, MS Excel, PowerPoint), Load Runner Analyzer, Selenium, MuleSoft
Confidential, Grand Rapids, MI
Business Systems Analyst
Responsibilities:
- Identified key stakeholders and gathered functional and non-functional requirements associated to website enhancement, customer trends, market insights etc., through interviews, document analysis and JAD sessions
- Created the As-Is business process flow and To-Be business process flow by performing the Gap analysis
- Assisted in developing user stories based on the AS () I WANT TO () SO THAT () format and stored them in JIRA
- Assisted in prioritizing the user stories and breaking them into task, thus assigning them in different release plans of the sprints
- Performed source analysis to identify, analyze the required data from SAP ERP & from other on-premise databases and used SQL queries to retrieve the required data and identify the data formats
- Attended scrum meetings facilitated by the scrum master and assisted product owner with the user stories
- Designed and created wireframes and mockup-screens using Balsamiq for the functionality and created UML diagrams like Use case, activity and sequence diagrams using MS Visio to display an interactive layout
- Efficiently studied and tested Red Hat’s integration process and assisted based on the need
- Created data mapping specification to show the flow of data from the multiple data sources (ERP to Salesforce)
- Assisted developers in customizing service, e-commerce and marketing cloud console by embedding visual force. Defining the data-specific rules for an interactive website experience
- Also assisted the design team in designing page layouts, tabs, used validation rules and relationship for creating custom objects and application like business process, camping metrics, custom cases, etc.,
- Implemented email-to-case entry and manual case entry for entering customer cases in case tabs
- Worked with the developers and assisted in case management, lead management and camping management
- Assisted in data profiling, data cleansing, setting the data connection and data integration of Salesforce and SAP-ERP system to gather the required data using Red Hat integration platform
- Assisted with data imports, exports, updates to Salesforce using data loader to gather data from CSV format
- Ensured the data being mapped was according to the field requirements and validation rules set in Salesforce
- Developed and created customized reports and dashboards in SFDC for service and marketing clouds
- Performed API testing using Postman and created API documentation for request & response using Swagger
- Prepared test data from user stories, documented and executed those test cases in JIRA and coordinated with the business partners in conducting the User Acceptance Testing (UAT) to get the feedback from the end client
- Utilized Test Driven Development (TDD) & Behavioral Driven Development (BDD) along with the QA team
- Developed reports, dashboards using Tableau which helped in analyzing the current market, customer performance and in improving the omni-channel experience and customer satisfaction
Environment: Agile-Scrum, JIRA, Oracle, MS Visio, MS Office, MySQL, Postman, Swagger, Tableau, Red Hat CodeReady studio, Balsamiq, Informatica Power Center, Salesforce, Visual Force, Confluence
Confidential
Business Analyst
Responsibilities:
- Interviewed product owner, business users, technical leads, database engineer, data architects and other stakeholders to understand their Business & Functional Requirements and gathered their future needs
- Created a Macro Document incorporating components of Business Requirement Document (BRD) and System Requirement Specification (SRS) incorporating business, functional, non-functional, data and GUI requirements which would in turn serve as the centerpiece of the project
- Created Release Planning document and Pre-defined release schedule, to deliver the documentation part in the project
- Participated in a story writing session with an aim of decomposing the scope into epics and user stories using INVEST criteria. Also, worked on the acceptance criteria for the above developed user stories
- Helped the Product Owner to Prioritize the Product Backlog items for developing Sprint tasks by taking technical suggestions from the cross-functional development team
- Assisted Data architect in creating Staging Area, Source, Target Databases for ETL and data mapping using Informatica created Data mapping specification document template to map elements/files with tables and columns in database by constantly interacting with the developers
- Created ER diagrams- conceptual and logical. Identifying the dimensions, facts and the schema of the centralized data warehouse with the team
- Helped the data architects and data base engineer in the data transformation when the data was sitting in the staging area
- Aided in designing data models and conducted normalization and de-normalization of data to fit OLAP frameworks, slicing and dicing of data marts for analytical decision-making
- Assisted in the creation of deployment flow chart in conjunction with development, infrastructure, and network teams containing information for maintaining application
- Logged and tracked the defects using HP ALM and assisted the data architect in the testing process with the QA team
- Involved heavily in Sprint Planning, Issue Tracking and Impediment Management using JIRA tool
- Created interactive reports and detailed dashboards using Tableau for forecasting and marketing needs
Environment: Water Scrumfall (Hybrid), JIRA, Confluence, Oracle, MS Visio, MS Office, MySQL, Tableau, Informatica Power Center, Balsamiq, HP ALM
Confidential
Jr. Business Analyst
Responsibilities:
- Involved throughout various phases of the System Development Life Cycle (SDLC) in Waterfall methodology
- Identified and analyzed needs for various functionalities of the portal by using various techniques such as JAD, Document Analysis, SWOT Analysis, Requirements Workshops, and Interviews with Subject Matter Experts (SMEs) and project stakeholders
- Prioritized the development of missing tools and content in the existing framework by performing the GAP Analysis. Documented the gap between the existing system and desired system
- Developed a high-level Business Requirements Document (BRD) and Functional Requirements Specification (FSD) document and had them base-lined from the business owner
- Performed heavy data analysis to generate internal reports in order to understand customer data, their discount structure and other sales Key Performance Indicators (KPIs)
- Worked with GUI development team to create the initial UI wireframes, and mockups. Developed Mockup screens and prototypes for the home page requirements document
- Created Use Case document by specifying actors, normal flow, alternative flows for all use cases
- Extensively used MS SharePoint for team collaboration and version control
- Created activity diagrams to represent the current state business process, context flow diagrams to identify the interfaces and the data flow of the system, and sequence diagrams to specify the order of interactions
- Constructed Requirements traceability matrix to determine the source of the requirement, to ensure all requirements are met and to locate affected system components when there is a requirement change. Maintained the traceability matrix until business requirements were signed off
- Prepared UML Diagrams, Process Flow Diagrams, Business Process and Data Process Model using MS Visio
- Analyzed Business Requirements from Black Box testing perspective. Reviewed Test Strategy and Test Plans to ensure that test cases reflect user needs for the functional, UI, Performance, Usability and Security requirements
- Facilitated Postproduction Validation and actively participated in production call support whenever necessary
Environment: Waterfall, JIRA, MS SQL, MS Visio, MS Excel, Tableau, MS SharePoint, Confluence
Confidential
Quality Analyst
Responsibilities:
- Communicated with QA team, supervisor, development team, clients, and other stakeholders about the requirements
- Identify test requirements from specifications, maps test case requirements and designs test coverage plan
- Developed, documented and maintained functional test cases and other test artifacts like test data, data validation, harness scripts, and automated scripts
- Executed and evaluated manual and automated test cases and reporting test results
- Facilitated test plan/case reviews with cross-functional team members
- Identifying potential quality issues per defined process and escalated potential quality issues immediately to management
- Managed daily process of identifying and reconciling test breaks, including working with business analysts to rectify true breaks
- Participated in daily stand-ups
- Present Business Owners with updated status on new and existing application issues
Environment: Kanban, MS Excel, Selenium, Jira