SUMMARY

• Sr. Business System Analyst with over 10 years of experience distributed across entire aspects of general information technology industry and its applications in e - commerce, retail and supply chain sector with in-depth end-to end understanding of Omni-channel, B2B and B2C processes.
• Extensive working knowledge of all the phases of Software Development Life Cycle (SDLC), and have experience in traditional waterfall, spiral and agile methodologies such as Extreme Programming (XP), Scrum, Kanban and Scaled Agile Framework (SAFe 4.0) and Waterfall-scrum hybrid.
• Well acquainted with various e-commerce platforms such as Magento, Shopify and Oracle ATG.
• Exposure to Marketing and Web Analytics for e-commerce website using Google Analytics, AdWords and Adobe Analytics for intelligent data collection and analysis.
• Adept in eliciting business requirements with various techniques such as Joint Application Development (JAD), Focus groups, Requirements Workshops, Brainstorming, Document analysis, Pilot Projects and Interviews.
• Hands-on experience in preparing wide range of documents including High Level and Low-Level documents (HLD/LLD) such as Business requirement documents (BRD), System Requirements specification (SRS), Use case Specification, configuration documents, and RACI matrix (Responsible, Accountable, Consulted and Informed).
• Expertise in creating mock-up screens and wireframes using Mock-up screens and Balsamiq.
• Highly skilled in structured planning methods for project evaluation including GAP Analysis, SWOT Analysis, Cost-benefit Analysis and Feasibility Analysis.
• Adept in creating design models using UML diagrams including Sequence Diagrams, Use-case
• Diagrams, Class Diagrams, Activity Diagrams and Data Flow Diagrams.
• Adept in performing both Quantitative and Qualitative Risk Analysis using techniques such as Delphi technique, Root cause analysis, Monte Carlo Simulation analysis and Decision Tree.
• Skilled as a Scrum Master and have facilitated scrum events (Backlog grooming, Sprint Planning, Daily Scrum, Sprint Review and Sprint Retrospective), and have introduced best practices such as Test-Driven Development (TDD), Simple Design and Continuous Integration.
• Expertise in handling requirement churn efficiently by using Prioritization and Estimation techniques such as MoSCoW, Kano, Planning poker, Bucket system and Relative mass valuation.
• Expertise inSQLqueries usingjoins,unions,outer joins, group byandaggregatefunctions to extract data from differentdatabases(Oracle, SQL Server) for timelyreportingandValidation.
• Proficient in creating Data Mapping Specification document, Entity Relationship (ER) models, dimensional models, data profiling, data cleansing and data validation in Data Warehouse projects
• Extensively used ETL methodology for supporting data extraction, transformations and loading processing in a corporate wide ETL solution using Informatica.
• Strong knowledge of implementing Databases, Data Table Structures, Data marts, Data Analysis, Data Integration, Schemas and OLAP operations viz. Slice, Dice, Pivot, Roll-up and Drill-down.
• Significant experience gained by extensive client interactions in highly cohesive and loosely coupled Service Oriented Architecture (SOA) and 3-tier architecture with strong and in-depth understanding of Web Services (WSDL, SOAP, REST), XML, JSON.
• Documented requirements for API development i.e. was responsible for technical writing using both XML and JSON. Used SOAP UI and Postman for API testing.
• Proficient at using both manual and automated testing tools to troubleshoot systems, integration, user acceptance, positive and negative, functionality, object, and regression.
• Adept at supervising Black-box Testing, Functionality Testing, System Testing, Integration Testing, Regression Testing, Security Testing, Load/Stress Testing, and Performance Testing
• Strong experience in creating Test planning, Test scenarios for validating Business requirements during User Acceptance Testing (UAT) and A/B testing.
• Thorough understanding of Business Intelligence (BI) tools and experienced in creating interactive, analytical dashboards using Tableau and MicroStrategy for decision making.
• Excellent oral and written communications, interpersonal, negotiation, judgment, decision-making, analytical skills, analysis and problem-solving skills.

TECHNICAL SKILLS

SDLC Methodologies: Waterfall, Agile-Scrum, Kanban Waterfall-Scrum Hybrid, XP, Spiral

Business Skills: Change Management, Conflict management, Impact Analysis, Project Planning, Project Scheduling and Project Budgeting, DMAIC, 5S, Root-Cause Analysis, GAP Analysis, SWOT Analysis and ANOVA.

Requirement Management: Atlassian-JIRA, CA Agile, and HP-ALM

Project Management Tools: MS Project, MS SharePoint Server, Confluence, Visio, JIRA, Rally, TFS

Modeling Tools: MS Visio, Draw.io, Rational Rose, Lucid Chart, Balsamiq, Mock-ups

Testing Tools: HP Quality center, Selenium, Load Runner, Soap UI, Swagger, Postman, Junit, Cucumber, Gherkin

ETL Tools: Informatica Power Center, SQL Server Data Tools

IDE: MS Visual Studio, Eclipse

Reporting Tools: Tableau Desktop, QlikView, MicroStrategy

Languages: HTML, SQL

E commerce Tools: Google Analytics, Salesforce, Moz, Buffer

Databases: MySQL Server 2012, Oracle, Hbase

Operating Systems: Windows, Mac OS

PROFESSIONAL EXPERIENCE

Sr. Business System Analyst

Confidential, Richfield, MN

Responsibilities:

• Assisted in developing Project Proposal, Business Case and Business rules for the high-level requirements.
• Performed Gap analysis to show As-is state and To-be state of the need for the system to be implemented.
• Helped in creating a Work Breakdown Structure (WBS) in Microsoft Project to visualize the workflow.
• Gathered business requirements from stakeholders and translate them into detailed requirement specification document to keep track of all the requirements for implementing the new system.
• Good Understanding of Oracle EBS and Salesforce Integration to optimize the customer experience and to make integration easier, both flat file and REST API were used to manage the complex integrations.
• Elicited requirements using interviews & JAD sessions with the Product Owner to integrate Oracle E-Business Suite with SALESFORCE as the new CRM platform used by sales personnel for the complete view on lifecycle of customers from prospects to account management.
• Analyzed Business Requirements and segregated them into high level and low-level Use Cases, Activity Diagrams or Sequence diagrams to have better understanding of the system.
• Prepared Business Requirement Document (BRD) from the elucidated requirements and helped the Product Owner and Development Team in making User Stories by using Three C’s.
• Developed several Use Cases using Draw.io and the company’s templates for better understanding and implementation for developers and uploaded them into Confluence and linked it with JIRA.
• Analyzed data through creation of schemas, tables, views, materialized views, triggers, stored procedures and functions using SQL Developer as a front-end programming workbench.
• Created Data mapping specifications, Source to Target mapping documents including the transformation rules by identifying Data mapping components.
• Designed data models and conducted Normalization and De-Normalization of the data as per the Online Transaction Processing (OLTP) and Online Analytical processing (OLAP) frameworks for data analysis.
• Performed slicing and dicing of data marts to facilitate the analytical decision-making process.
• Integrated applications by establishing Enterprise Service Bus (ESB) which translated calls and services from one system to other in terms of API calls to support CRUD operations.
• Implemented Asynchronous Java script and XML or Ajax which is client-side validation techniques without reloading the entire web-page to reduce the traffic between the client and the server.
• Helped in development of the prototypes and test scenarios for User Acceptance Testing.
• Helped Quality Assurance Analyst to formulate test cases and test scenarios from the use cases.
• Created and maintained Requirement Traceability Matrix (RTM) to ensure all the requirements are fulfilled and all the test cases have been executed according to the proposed plan.
• Planning along with Traceability back to the requirements to ensure complete coverage of the Program increment.
• Worked Extensively with the Dev Ops Team for the successful implementation of the Project.
• Designing Test Cases in SOAPUI for API testing, Test Plans for all the processes using Confluence, hence did the Black Box Testing and was part of System Testing.
• Tracked the identified defects using JIRA. Performed JSON and XML documentation of web services using Swagger, IO docs for JSON & XNSDOC for XML.
• Created automated scenarios using HP-QTP for functional regression test automation and Data-Driven testing
• Used CUCUMBER for Behavior Driven Development and used MAVEN to build the project and connect it to JENKINS CI Tool.
• Implemented Lean and Six-Sigma techniques including 5S, Fish Bone Diagram, Analysis of Variance, Design of experiment and Spaghetti diagram to reduce waste in the warehouse management system (WMS).
• Used Ideaboardz (SaaS) for Retrospective meeting to come up with the Action Items.
• Developed reports using Tableau v9.0 to communicate information using graphs, charts and other info graphical solutions to the project team.

Environment: Oracle E-Business Suite, Salesforce Sales Cloud, SKUID, WSO2 ESB, JIRA, CONFLUENCE, MS Project, Oracle DB, MS-VISIO, JMS API, XML, Tableau, SOAPUI, J2EE, Cucumber, Jenkins, Scrum-Waterfall Hybrid, Ideaboardz.

Sr. BUSINESS SYSTEM ANALYST

Confidential, Framingham, MA

Responsibilities:

• Assisted the Project Manager with planning, scheduling, and controlling projects based on schedules and requirements outlined by the business.
• Gathered requirements for Business-to-business (B2B) and Business-to-consumer (B2C) parts of the website for online and onsite user’s ability of search online, shopping cart management, membership subscription, payment processing, order processing and Customer support.
• Provided recommendation for use of ATG Commerce for (B2B) and (B2C) business.
• Extensively worked on Business Requirements Document (BRD), Functional Requirement Documents (FRD), systems requirements specification (SRS), high level design documents (HLDD), and traceability mapping / matrix with the assistance from the business group, and the IT team members.
• Involved profoundly in the GAP Analysis of Employer Rosters, and analyzed "AS IS" and "TO BE" scenarios, designed and documented new process flows business process and various business scenarios.
• Performed Impact Analysis, Feasibility Study/PEST Analysis, Cost-Benefit Analysis and Return on Investment (ROI) to mitigate certain risks associated with the project and project output.
• Designed and developed Use Cases using UML and Business Process Modeling.
• Applied Unified Modeling Language (UML) to design Use Case Diagrams, Activity Diagrams and Sequence Diagrams in MS Visio
• Facilitated JAD sessions for analysis, design and development strategy.
• Created business process models using BPMN on Current State and Future State for functional and technological process improvements.
• Created and updated Project Track Plan Slides via MS PowerPoint, MS Project, MS Excel and MS Visio.
• Conducted and created User Interface for web pages and documented user interface forms with relevant data dictionary, and models to communicate to database and development teams.
• Facilitated prioritization of user stories using Moscow and estimation using Planning Poker techniques.
• Wrote SQL queries to create database views and reports to track customer data.
• Executed SQL queries, to retrieve data from different databases, for data validation & analysis, researching underlying data errors, and generating reports
• Extensively involved in Data Governance that involved data definition, data quality, rule definition, privacy and regulatory policies, auditing and access control.
• Performed Data Analysis and data manipulation of source data from SQL Server and other data structures to support the business organization.
• Used Swagger UI to look for the list of APIs & validate implemented functionalities with a goal to identify gaps.
• Worked as a part of API testing and measured the data flowing between request and response.
• Helped QA Team in writing test cases, test plans and tested the final application to verify whether all the User Requirements were catered to by the application.
• Participated in UAT and worked with HP Quality Center for bug/defect tracking.
• Created test plans, test case and test data for integration and system testing all the components and applications involved and executed them.
• Conducted functional black-box testing for unit, integration and regression of different modules within SOA.
• Facilitated User Acceptance Testing (UAT) with end users by providing necessary training and setting up testing data, test scenarios, and testing environment.
• Developed and analyzed the Sprint/Product burn down chart to calculate the team’s velocity and track sprint progress.
• This was then utilized for planning of the upcoming sprints. Used Jira to plan and track the sprints.
• Involved in Business Intelligence (BI) and Data Visualization, analyzed the Transaction Processing Data (TPS) using advanced MS Excel.

Environment: CA Agile (Rally), SharePoint 2013, Oracle9i, MS Visio 2013, JBOSS, Apache Webserver, Oracle DB, MS Project 2013, Oracle ATG, Java/J2EE HTML, XML, JSP, Scrum-Waterfall Hybrid.

Sr. Business Systems Analyst

Confidential, Greensboro, NC

Responsibilities:

• Elicited business requirements from business owners, users, and Subject Matter Experts (SME's) using various elicitation techniques like Interviews, Brainstorming, Focus groups, Requirement workshops, and JAD session.
• Performed Document Analysis, Interface Analysis, and Interviews to understand AS-IS business process and documented the TO-BE business processes by conducting GAP Analysis to identify the gaps.
• Created RACI Matrix to identify, categorize, and manage all relevant stakeholders in the project.
• Gathered functional and non-functional requirements and documented them in a Business Requirement Document.
• Participated in User Story Writing Sessions to decompose BRD into User Stories and write Acceptance Criteria
• Conducted Feasibility Study to study the feasibility of cloud computing explored various cloud computing options.
• Assisted in configuring AWS instances, Auto Scale, EBS and Cloud Watch alarms. Worked closely with the system architects to develop logical architecture diagram for the system.
• Worked on Content Management System and assisted in consolidating Product Catalogue for various channels.
• Assisted in creation of data models, as a part of development of dynamic content determination and targeting system.
• Worked on Order Management Systems(OMS), ERP systems and Customer Relationship Management (CRM)
• Created Mockups and Wireframes to create throw away prototypes of Graphical User Interface (GUI)
• Created Use cases and UML models like Use-Case diagram, Activity diagram and Sequence diagrams in MS Visio.
• Executed View SQL queries with different Where Clauses to create specific views for reports.
• Involved in API technical writing for both SOAP and REST. Documented XML and JSON request and responses.
• Responsible for writing Feature Files in Cucumber for which the QA writes step definition file.
• Prepared and executed test cases, test scenarios and tracked defects in HP Unified Functional Testing (HP UFT).
• Conducted functional black-box testing for unit, integration and regression of different modules.
• Used Swagger UI to look for the list of APIs & validate implemented functionalities with a goal to identify gaps.
• Worked as a part of API testing and measured the data flowing between request and response.
• Aided in development of UAT test plans and worked with UAT team to clarify BRD.
• Conducted User Acceptance Testing (UAT) with stakeholders and system users to uncover latent defects in the system.
• The defects were corrected and verified through a new cycle of regression testing.
• Developed and maintained quality procedures and ensured that appropriate documentation was in place.
• Used JIRA for issue tracking, user story management and requirement traceability and Confluence for repository management and collaboration.
• Generated web analytics reports using Google Analytics to understand the funnel conversion rates.

Environment: SCRUM, JIRA, Confluence, MS Visio, MS Project, Tableau, XML Copy Editor, REST API, Cucumber, Jenkins, HTML5, CSS3, JavaScript, Java EE 7, Microsoft Excel, Microsoft PowerPoint, Microsoft Word, Selenium Web driver, AWS EC2, AWS RDS, My SQL, Red Hat Linux.

Business System Analyst

Confidential, Trenton, NJ

Responsibilities:

• Extensively involved in maintaining requirements traceability and communicating any changes to these requirements to different business groups and programmers.
• Conducted JAD sessions for requirements gathering, analysis and design of the system.
• Actively interacted with different business groups to perform GAP Analysis to identify the deficiencies in the system by comparing the actual objectives with the system objectives desired.
• Created Mock-up Screens and Wireframes using UI Components such as Radio Buttons, Drop-down and Check boxes, and demonstrated it to stakeholders.
• Actively involved in reading data from varied file types created standard and ad-hoc reports using SQL and Erwin, generating delimited files and SQL script to load data into SQL tables.
• Used Decision matrix tool to prepare for data mapping by identifying the data components from mapping indicator to source table to target data type.
• Worked with complex data transformation and helped the ETL developers to understand it.
• Performed technical analysis related to advanced data analysis, data mining, and source to target mapping.
• Worked on service-oriented architecture (SOA), RESTful API’s generating JSON, BSON, XML responses using PL/SQL and JDBC drivers to establish connections with databases.
• Assisted in Scheduling Informatica ETL tasks to transfer data with extensive unit and integration testing.
• Captioned meetings to gather the API Requirements for both the source and target system.
• Documented the REST API requests and responses in XML format.
• Prepared UAT test document and developed Test Scenarios for validating the Business requirements and Uploaded Test scenarios, mapped Business requirements to Test scenarios and updated defects and defect tracking in Quality Center.
• Assisted testing team in UI testing using selenium and documented the defects in the Jira.
• Authored progress and completion reports, which were submitted to program manager and business owner on a weekly basis.

Environment: - Java, HTML/CSS, AngularJS, Bootstrap, JQuery, SQL, Erwin Data modeler, Informatica Power Center, Web Services, API, MS Office, MS Visio, Share Point, JIRA, HP QC, Tableau, Oracle Data Miner.

Business System Analyst

Confidential

Responsibilities:

• Worked with the Business, Operations, and Engineering stakeholders to define the functional integration and end-2-end test cases for the Inventory Management project.
• Reviewed and streamlined existing business processes, information, and data requirements to ensure accurate adoption metrics reporting. Deactivated users to release licenses.
• Performed GAP Analysis to analyze the current system and worked with internal users to help define system requirements.
• Responsible for scheduling meetings with users, SME's and stakeholders to identify problems resolve issues and improve the process to ensure a stable and accurate solution.
• Updated and maintained the project plan, budget spreadsheet, and quality process assurance documentation.
• Conducted the FRS and SRS reviews and walkthroughs with designers, developers and stakeholders.
• Created Activity diagrams and Use-case Diagrams (UML Diagrams) using Rational Rose.
• Involved in preparing flow diagrams for the decision logic using Visio tool.
• Assisted with data modeling and defining the conceptual and logical model of the data warehouse.
• Extensively involved in data modeling & Data Mapping.
• Performed backend testing to check the system data integrity for insert, update, delete and retrieve transactions by writing complex SQL queries including joins, group by, having clause etc.
• Performed Functionality testing, Integration Testing, Unit testing and System Testing.
• Creation of Test Cases for functional testing of the system.
• Review requirements and create a test strategy to be implemented.
• Involved with the Test planning, test development and test execution.
• Resolved issues related to requirements during system testing and UAT plan preparation.
• Participated in the planning of the User Acceptance testing effort.
• Coordinated with Scrum Master for Project Progress and Release Management. Managed Product and Sprint Backlog to achieve the Sprint objectives in Agile methodology.
• Maintained Requirement Traceability Matrix.

Environment: Rational Requisite Pro 5.6, Microsoft Project 2004, Symphony, MS Excel, MS Word, Power Point, SAP ERP, Rational Software Modeler, Clear Quest, Quality Centre, Windows 2000 and HTML.

Business Analyst

Confidential

Responsibilities:

• Facilitated JAD Sessions, Interviews sessions, Survey/Questionnaire and Focus Groups to elicit requirements with stakeholders, business users and SME’s for understanding requirements.
• Planned and worked with the online marketing team to develop direct-to-customer initiatives.
• Played key role in developing and driving continuous improvement and Lean initiatives in Supply Chain & Logistics function.
• Worked with development team for handling of shopping cart and accounts management.
• Participated in Change Board Meeting (CAB) for any changes in the business requirements.
• Assisted the testing team in developing the Test Plan, Test Conditions, and Test Cases based on business requirements and technical specifications in UAT.
• Used Tableau for data reporting, studying the trends, data patterns and for data forecasting.
• Assisted in defining implementation and deployment tasks for the new platform as per the requirements.

Environment: - Waterfall, UML, Java, XML, SOAP, SharePoint, MS Visio, MS Project, Quality Centre, A/B testing.

Junior BUSINESS ANALYST

Confidential

Responsibilities:

• Elicited business requirements for the project using interviews, document analysis, surveys, site visits, use case scenarios and used standard template of the organization to develop requirements.
• Conducted Joint Application Development (JAD) sessions with Subject Matter Expert (SME) sessions.
• Maintained and build relationships with stakeholders to ensure their performance management and business analysis needs are understood and supported.
• Elicited and documented Functional requirements, business requirements AS-IS and TO-BE business process models.
• Analyzed and gathered requirements for preparation of Business Requirement Document (BRD), Functional Requirement Document (FRD) and System Requirement Specification (SRS).
• The methodology used for the project was Waterfall. Provided clear and consistent information about project status both internally, IT team and stakeholders.
• Responsible for creating UML diagrams (Use Cases, Activity Diagram and Class Diagram) to capture the dynamic behavior of different applications.
• Developed Use Cases, Activity Diagrams and Sequence Diagrams for a clear understanding of the vision document.
• Prepared Business process models; used Visio to create process flow diagrams for management and mapping the logical aspects of the process.
• Created the following types of documents mainly: Functional Requirement Specification (FRS), Functional Test Summary, Chance Control Documentation and Validation Specification.
• Designed Test Plans and Test Cases for User Acceptance testing (UAT) with the help of QA teams.
• Prepared Requirement Traceability Matrix and interacted with QA team to ensure quality of software.

Environment: SDLC Waterfall, MS project, MS office Tools (Word, Excel, PowerPoint and Visio), MS Project, MS Visio, HTML, CSS, JavaScript, Visual studio, MS SQL 2008, IBM Cognos.

Junior Analyst

Confidential

Responsibilities:

• Worked in Waterfall methodology of Software Development Life Cycle (SDLC).
• Assisted Business Analyst in gathering requirements from key stakeholders, customers and SME’s to define the scope of the project.
• Defined the context of the system by creating various Use Cases for the development system requirements specifications encompassing Functional and Non-Functional requirements.
• Developed Business Requirement Document (BRD) and Use Case Document (UCD).
• Created screen mockups for the new platform using MS Visio.
• Created Requirements Traceability Matrix (RTM) using HP QC tool.
• Created ad-hoc reports using MS-Excel and Pivot tables to do the calculations and creating reports according to the needs of the users.
• Worked with the QA team for designing Test Plan and Test Cases and assisted in conducting User Acceptance Testing (UAT)

Environment: - Waterfall, MS Office, SQL, UAT Testing, HP QC, COTS