Sr. Business Analyst Resume
4.00/5 (Submit Your Rating)
Plano, TX
SUMMARY
- Having over 9 years of professional experience as a Business Analyst with a strong understanding of Business Analysis, System Analysis, Business Process Management and Business Process Modeling.
- Experience in Business Requirements gathering and writing skills with expertise in developing and documenting Business Requirement document (BRD), Functional Requirement Document (FRD), and Software Requirement Specification (SRS) across the deliverables of a project.
- Excellent experience in the E - commerce and Retail Industries.
- Expertise in Software Development Life Cycle (SDLC) methodologies such as RUP, Agile / Waterfall / Spiral methodologies with hands on experience in all of them.
- Business Analyst with extensive background in eCommerce, (SAP Hybris, Magento), Digital Strategy, CMS (content management systems), CRM (customer relationship management), Data Management and related applications /technologies utilized by the e-Commerce.
- Experience in e-Commerce platform as Big Commerce, Shopify, Interspire and Demand ware.
- Experience in all aspects of Supply Chain Management, Global Demand Planning, Aggregate Forecasting, Planning, Master Scheduling, Inventory Management, Risk Analysis, and ROI Analysis.
- Experienced and have detailed knowledge about Order Management System, Retail POS Applications, Customer Relationship Management (CRM), Ecommerce platforms.
- Extensive knowledge of the E-commerce Retail Sales lifecycle and the Retail Ecommerce ecosystem, OMS, WMS, Fulfillment, TMS and Support.
- Proficient in Supply Chain and Ecommerce types such as B2B, B2C, C2B, and C2C.
- Strong Work experience on Ecommerce portals web application developments, B2B, B2C, Content Management Systems for Ecommerce like ATG.
- Conversant with Oracle Supply Chain modules and Distribution Modules - Quoting, WMS, Advance Pricing, OM, ASO, INV, VCP, Warehouse Management (WMS).
- Experience working with Content Management Systems (CMS), Order Management System (OMS) Supply Chain Management and UX teams.
- Expertise in risk analysis, systems analysis and requirements for enterprise integration and POS system enhancements for Oracle XStore, Oracle Locate Order Broker and Retail Interact.
- Experience in conducting JAD sessions with SME (subject matter experts), stakeholders, developers and end-user representatives to make sure all the stakeholders and developers are on the same page.
- Expertise in managing multiple projects while maintaining constant communication with the relevant stakeholders
- Good experience at Demand ware, ATG Dynamo B2B Commerce, ATG B2C Commerce, Shopping Cart, Product Catalog, Merchandizing, Catalog, Droplets.
- Ecommerce experience in Online Retailing, Business to Business (B2B) and Business to Customer (B2C) functions.
- Worked on projects that developed strategies for Cross Channel/Multi-channel integration providing a consistent experience across the customer's preferred channels and platforms like Mobile and E-Commerce.
- Working experience on various Software and Customer Relationship Management (CRM) packages.
- Experienced with Integration of merchandising systems with Warehouse Management Systems.
- Expert in UML methodology to create UML Diagrams including Use Cases Diagrams, Activity Diagrams, Sequence Diagrams, Data Flow Diagrams (DFDs), ER Diagrams using Rational Rose and MS Visio and thus defining the Business Process Model and Data Process Model
- Experience in Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
- Experience testing applications based on cloud service providers like AZURE in an Agile environment.
- Proficient in using version control tools, Team Foundation Server (TFS), GitHub and agile management tools like JIRA, RALLY.
- Experience in all components of OBIEE like DAC, Informatica, Business Modeling, and Reporting structure Modeling & Report Building, Dashboards and Oracle Answers.
- Expert in Tracing requirements throughout the development process and verifying adherence using the requirements Traceability Matrix (RTM)
- Experience in GUI Testing, UAT (User Acceptance Test), Manual, Functional Testing of Client/Server & Web based application.
- Experience and complete understanding of QA Life Cycle, which includes Designing, Developing, Execution and Documentation of the Test Cases, Automated Test Scripts and Test Plans.
- Good experience in developing Test Plans, Test Strategies, Test Scenarios, Test cases by reviewing Business and Software Requirement specifications and creating Gap Analysis for test purpose.
- Proficient in the use of Visual Studio, MS Visio, MS Word, MS PowerPoint, MS Excel, as well as MS Project.
PROFESSIONAL EXPERIENCE
Confidential - Plano, TX
Sr. Business analyst
Responsibilities:
- Elicited business requirements for a web content management system (CMS) that will be employed to support the production of the agency's primary website.
- Interfaced with the client as part of the Requirements Engineering team to finalize the project scope.
- Facilitated JAD Sessions and gathered Business Requirements.
- Assisted with the BRD for the POS implementation project. Managed changes to the POS system
- Define and document CRM specifications for Randa’s ERP system (NetSuite) for customer support, sales orders and offshore helpdesk.
- Analyze key Functional area (Financial, Sales & Distribution, Production, Inventory, Supply chain) and make HP team better understand our business process to configure software modules to optimize and eliminates paperwork.
- Techno-Functional Consultant, Supply Chain Applications including Pricing, Order Management, Rapid Replenishment and Supply Distribution Management implementations.
- Analyzed daily user SAP MM tickets, resolve their issues and document solutions.
- Create Standard Operating Procedures (SOPs) for use of the ERP System (NetSuite) sales ordering process, logistics and inventory management, RMAs & support call logging.
- Analyzed current "AS-IS" business processes for potential business process changes as a result of SAP
- Established average cost methodology utilizing NetSuite including inventory valuation and accurate reporting.
- Assisted the PM in developing Use Cases and project plans and also managed changes to the scope of the project.
- Functioned as the primary liaison between the business line, operations, and the technical areas throughout the project life cycle.
- Involved in developing and maintaining Business Objects universes to ease the task of developing reports for the MIS reporting team.
- Effectively managed live e-commerce clients of mid-sized B2B and B2C e-commerce websites integrated with the company's existing ERP software and Shipping Software in a Content Managed System (CMS)
- Helped in designing new Web Content Management Repository by analyzing requirements; constructing workflow charts and diagrams; studying system capabilities; writing specifications.
- Prepared reports on analyses, findings, and project progress, and presented results to management and customer personnel for E-Commerce applications.
- Responsible for creating the test scripts and testing the integration between the OMS, Manhattan WMS and Material Handling Equipment.
- Created complicated use cases to test the current system which led to various defects in the mobile site this gave way to more specific goals for the project's needs.
- Utilized Informatica toolset (Informatica Data Explorer, and Informatica Data Quality) to analyze legacy data for data profiling.
- Performed extensive Requirement Analysis including data analysis and gap analysis.
- Gained a thorough knowledge and maturity in all the phases of SDLC and familiar with industry standard best practices & frameworks such as RUP (Rational Unified Process), Agile & Lean.
- Involved in data validation of the results in Tableau by validating the numbers against the data in the database tables by querying on the database.
- Created custom reports and deployed them on server using SQL Server Reporting Services (SSRS).
- Created business requirement specification documents as well as high-level project plan.
- Worked with Rational Clear quest for defect management.
- Provided multiple demonstrations of Tableau functionalities and efficient data visualizations approaches using Tableau to the senior management at the client as part of the BRD.
- Involved in data validation of the results in Tableau by validating the numbers against the data in the database tables by querying on the database.
- Worked with data analyst team to design models and create data mapping documents for data analysis and created reports adopting business objects.
- Worked on creating basic dashboards in tableau connected to Azure SQL database for client reporting.
- Created Use Cases, Activity Diagrams, Sequence Diagrams, and OOD using UML.
- Created various Reports and Dashboard with Tableau and Power BI to gain and gather insights.
- Involved in inception phase and prepared vision and supporting documents that contained essential business elements, BRD, and detailed definitions.
- Documented and delivered Functional Specification Document to the project team.
- Performed task decomposition, delegated tasks and monitored project milestones using MS Project.
- Assisted the PM in performing Risk Assessment, Management and Mitigation.
- Assisted QA testing in formulating the test plans, reviewed QA test plans for appropriate test coverage and managed the Change request documentation for Change management processes.
Confidential - Mahwah, NJ
Business Analyst
Responsibilities:
- Gather requirements by conducting meetings and brainstorming sessions with end users and SME and document them using Requisite Pro - the documentation tool offered by Rational.
- Provided recommendation for use of ATG Commerce for B2B and B2C business.
- Translated business requirements to technical specifications for Hybris/ SAP/Sterling Integrator development team and maintains work backlog.
- Worked on Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database.
- Conducted JAD sessions which include the management, development and user teams for clarifying requirements and facilitating better communication.
- Deep understanding of all the phases of Software Development Life Cycle (SDLC) methodologies throughout the project life cycle.
- Work with Product Development and Customer Service to solve demand- supply mismatch situations, provide Supply-demand feedback mediations to all stakeholders in the supply chain.
- Gathered requirements for the integration of Point of Sales (POS) system with the supply chain system.
- Involved in Development E-Business Suite programs for databases supporting supply chain management (SCM), order management, inventory, warehouse management system and purchasing.
- Provided subject matter expertise for functional and technical aspects of the Demandware E-commerce platform.
- Worked on Implementation, enhancement and support solutions to meet client's needs using Demandware ecommerce platform.
- Created different Experienced in User experience (UX) definition and User Interface (UI) design for project as well as prototypes and wire frames.
- Created datasets for Omni channel reporting project that incorporates email, marketing, and member interaction data.
- Created Activity Diagrams, and Sequence Diagrams utilizing MS Visio.
- Rewrite existing requirements, breakout into new requirements, and create additional documentation where appropriate.
- Worked on high level requirements matrix for both B2C and B2B that detailed current and future state needs, along with a gap analysis against Salesforce Commerce Cloud (Demandware) and SAP Hybris capabilities.
- Created workflows and allocated permissions within SharePoint.
- Maintained key records for purposes of Compliance review and/or regulatory inquiry.
- Performed Data mapping, logical data modeling, created class diagrams and ER diagrams and analyze and implement data integrity initiatives for various business units.
- Involved in Designing merchandising and marketing databases; developed and reports to automate reoccurring tasks using SQL Server.
- Participated in design and build of different OMS modules - Order Capture, Order Processing, Order Promising & Fulfillment, Payment Processing, and etc.
- Followed reverse engineering to document UI and Functionality.
- Perform Gap Analysis of the processes to identify and validate requirements.
- Apply UML notations and methodology in developing models that accurately represent the business process and workflows and clearly communicate them to the stakeholders.
- Used Agile/SCRUM requirements management tool Rally for managing story cards, efforts, and preparing burn-down charts and velocity charts.
- Collaborated with developers as needed to determine the root cause of defects.
- Provided input (scope, goals, risks, constraints, timelines and interfaces) to PM for project planning and control.
- Assisted QA team in developing test strategy, and test cases and actively monitored various types of testing - functional testing, Progression testing, system testing, load testing, smoke testing, and regression testing.
- Created and tested Campaigns and Promotions on Salesforce Commerce Cloud (Demandware) platform.
- Created and maintained user stories in JIRA for better understanding of the requirements for the development team. Also use JIRA for bug tracking.
- Review the Test Plan developed by the testing team for testing the application.
- Created Test Scripts & Test Scenarios to check report content, layout, and parameters.
Confidential - Dallas, TX
Business analyst
Responsibilities:
- Gather requirements for the listed options risk management system, specifically for index options risk management spreadsheet. Defining requirements for product control and risk management end of day feeds.
- Conducted JAD (Joint Application Development) Sessions and RAD (Rapid Application Development) Sessions with stakeholders.
- Interacted with the PM in managing the Agile Scrum process to ensure smooth delivery of projects.
- Identified internal and external system requirements, design and configuration set-up, also created User Documentation and conducted training class.
- Also involved in E-Commerce POS testing Product Search, Payment System, Online transaction processing
- Performed Data Profiling of current state of data in the Data Warehouse by doing Data Analysis using SQL Queries and Microsoft Excel, finding Gaps in Data and formulating solutions for the same.
- Performed GAP Analysis of business rules, business and system process flows, user administration, and requirements. Ensured POS PCI compliance requirements were met.
- XML order header and order detail data transfer, inventory/supply chain management modules
- Involved in designing automated POS system using involving monthly import of POS excel files into a database using SSIS packages. Created templates for power users to create their own SSRS reports.
- Worked with supply chain methodology and wholesale distribution processes.
- Responsible for addressing, diagnosing, and resolving issues that arise on a day-to-day basis for the team. Also responsible for documenting the causes, analysis and final resolution to the issues/errors.
- Manage the development of multiple reports in order to consolidate information that would assist upper management of various departments in making enterprise decisions via Tableau.
- Checked to make sure orders from customers are accurate and free of any variance by working closely with the sales, shipping department and warehouse.
- Established connectivity to all major buy-side vendor order management systems (OMS).
- Involved in implementing (POS) Point of Sale system and Point of Commerce for US retail/Online stores.
- Implemented SQL queries for QA testing and Report / Data Validation.
- Worked as Business Analyst for collecting customer requirement for managing supply and delivery translating the requirements into documentation for effective process flow mapping.
- Conducted interviews with key business users to collect requirement and business process information.
- Performed the business requirement collection approach based on the project scope and SDLC methodology.
- Created various Test Cases and Test Plan for the new Magneto shopping cart.
- Created Use Cases, Activity Diagrams, Sequence Diagrams, and OOD using UML.
- Participated in requirements analysis using a Use case driven approach and produced detailed use cases and functional specifications for all the interfaces.
Confidential - Winona, MN
Business Analyst
Responsibilities:
- Gathered analyzed, documented business and technical requirements from both formal and informal sessions and validate the needs of the business stakeholders.
- Involved in the creation of new E-Commerce Products in Inception Phase and prepared vision statement and initial data models that contain Business Requirement Documents and supporting documents that contain the essential business elements and detailed definitions.
- Co-authored business requirements document with project teams. Extracted, discussed, and refined business requirements from business users and team members.
- Act as a resource in understanding how IS systems carry out business functions and assists in ensuring the timely and effective implementation.
- Involved in Developing two stages of value stream map for office supply chain link.
- Modeled AS IS and TO BE processes using MS Visio.
- Analyzed Business Requirements and segregated them into high level and low-level Use Cases, Activity Diagrams / State Chart Diagrams using Rational Rose according to UML methodology thus defining the Business Process Models.
- Documented the evaluation of various reporting tools like Oracle Analytics/Business Objects, made recommendations about the product depending on the reporting requirements
- Supervised and managed project throughout SDLC to ensure that project management methodology based on RUP is followed during the project lifecycle using MS Project and NIKU Workbench.
- Used Rational Tools for creating use cases, version control and defect tracking, monitoring. Use Rational Unified Process (RUP) methodology in all areas of the software development life cycle (SDLC).
- Planned and defined Use Cases created Use Case diagrams, Scenarios and Use Case Narratives using the UML methodologies.
- Applied Supply chain Management (SCM) methodologies to ensure coordination in the supply chain.
- Involved in the creation of new E-Commerce Products (Arrival Notices and Customized Reporting) and worked with Front-end and Back-end systems.
- Created relationships in Requirement Traceability Matrix linking Business Requirements to Functional requirements and Functional Requirements to Systems Requirements.
- Performed the requirement analysis and documented the requirements using Rational Requisite Pro.
- Established traceability matrix using Rational Requisite Pro to trace completeness of requirements in different SDLC stages.
- Responsible for creating different sessions and workflows to load the data-to-Data Warehouse using Informatica Workflow Manager.
- Designed flexible project foundation enabling rapid implementation of e-commerce website capabilities.
- Conducted Joint Application Development (JAD) sessions with IT groups. Identified the Key Changes, and participated in Stakeholder Management to communicate effectively with them.
- Facilitated JAD sessions with management, development team, users and other stakeholders to refine functional requirements.
- Created Mock-up forms in MS word for better visualization and understanding of the software solution.
- Tracked change requests and monitored workload and schedule.
- Used MS Visio for Process modeling, Process mapping and Business Process flow diagrams.
- Managed workload, schedules and coordinated status review meetings with project managers, business managers and team members.
- Used Rally tool for requirements management and tracking user stories in a sprint and product backlog.
- Tracking business reporting issues on JIRA by creating problem statements that help breakdown the underlying issue.
- Involved in developing strategies with Quality Assurance group to implement Test Cases in Mercury Test Director for stress testing and UAT (User Acceptance Testing)
- Collaborated with Quality Assurance Analyst in Automated and Manual Black box testing using Mercury's WinRunner.
- Suggested measures and recommendations to improve the current application performance.
- Assisted with the development of test plans and strategies, coordinated testing events, and executed test cases in support of changes to business systems.
- Participated user acceptance testing cycle; worked with business users to define business scenarios, user acceptance test cases and user acceptance criteria.
- Conducted user interviews, gathered requirements, and analyzed the requirements using-Rally.
Confidential - Benton Harbor, MI
Business analyst
Responsibilities:
- Performed as a Business Analyst on various web-based applications and systems development projects including customized Content Management System (CMS)
- Collaborated with a variety of internal and external stakeholders to gather requirements.
- Support Sales and Marketing to promote ecommerce programs through the number one revenue generating website.
- Evaluated existing e-Commerce applications to identify areas of improvement and carried out program enhancements and modifications.
- Involved in the support for a major effort to improve the Warehouse Management System (WMS) capabilities of supply chain.
- Communicated and documented business requirements for technical teams.
- Compiled and analyzed various reports: E-commerce internal support report (Excel, Access, QlikView),
- Excellent experience in performing RTM Test Matrix, GAP analysis and SWOT analysis to check the compatibility of the existing system infrastructure with new business requirements
- Involved in preparing SDLC Documents such as Business Requirement document (BRD), Functional Specification document (FSD), Test Plan, Test Report.
- Used Microsoft Azure for building, testing, deploying, and managing applications and services.
- Diverse experience in ATG E-Commerce and Retail services.
- Test the user stories for accuracy and compliance to ensure undisputed acceptance and validation of stories.
- Successfully launched multiple e-commerce platforms with integrated enterprise and content management systems
- Executed SQL Queries for testing and data analysis of PL/SQL source code.
- Grouped the Use Cases and other diagrams into sequence and collaboration Diagrams using Rational Rose based on UML methods thereby defining the business process model.
- Created Use Cases for the applications and created Test Plan and Test scripts based on Used Cases.
- Documented and Performed User Acceptance Testing (UAT).
- Involved in Staples online store Production Support that included incident troubleshooting and resolving tickets.
Confidential - Englewood, CO
Business Analyst
Responsibilities:
- Interacted with the SMEs and stakeholders to get a better understanding of client business processes and gather business requirements.
- Identified/documented data sources and transformation rules required populating and maintaining data warehouse content.
- Performed Gap analysis and implemented updates for the Data Warehousing Application.
- Modeling the As-Is system and doing the complete Gap Analysis for the existing system in order to map it to the To-Be system.
- Conducted JAD sessions for communicating with Stakeholders and Project directors.
- Created business process workflow diagrams (Activity diagrams) in Rational Rose.
- Maintained various Business unit reports by using Teradata, SQL, and MS Excel.
- Created Use-Cases and Business Use-Case Model after accessing the status and scope of the project and understanding the business processes.
- Integrated Requisite Pro with Clear Quest and Rose to provide all teams visibility and maintain tractability among requirements, use cases and change requests.
- Managed all the requirements in Requisite, making requirements available to all team members.
- Created requirements analysis and design phase artifacts using Requisite, Rational Rose and Smart Draw to create DFDs, ER diagrams, Use cases, Activity/ State chart, Sequence, Collaboration and Deployment Diagrams.
- Used the Unified Change Management from Rational to track changes to multiple artifacts by versioning artifacts, associating requirements to specific change request/defects to streamline the defect/change tracking process.
- Performed Feasibility Analysis, Risk Analysis and Gap Analysis on vendor/third party tools.
- Followed the UML based methods using Rational Rose/MS Visio to create: Use Cases, Activity Diagrams / State Chart Diagrams, Sequence Diagrams, and Collaboration Diagrams.
- Assured that all Artifacts are in compliance with corporate SDLC Policies and guidelines.
- Coordinated and prioritized outstanding defects and enhancement/system requests based on business requirements, allowing sufficient time frame to ensure accuracy and consider deadlines
- Monitored client expectations and conducted user interviews.