SUMMARY

• Around 8 years of extensive experience Business System Analysis, Software Validation and business process re - engineering with proven ability to articulate business values in Retail and E-Commerce Industry, in all the phases of SDLC (Agile Process and Waterfall Method) and Rapid Application Development (RAD) methodologies.
• Conducted Root Cause Analysis, Time studies, Process Mapping exercises, performance and risk matrices etc. using various tool sets
• Functional experience with concentration on Use Case modeling using UML, Business Process Modeling, Data Modeling, Change Management, Technical Training, Software Development methodologies, QA testing, and Systems Testing of client server and web-based systems.
• Strong business analysis and an understanding of the software development life cycle SDLC methodologies including RUP, RAD, Waterfall, and Agile.
• Experience working on Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database.
• Experience on Retail / Supply chain domain with knowledge of standard business processes like Inventory Control, Procurement & Allocation, Merchandise Planning, Returns, Warehouse & transportation management process, knowledge on POS and Assortment Planning.
• Experience working onDistribution Management Systems (DMS), Warehouse Management Systems (WMS), Order Management Systems (OMS)for Omni-Channel Retailers.
• Experience on Supply Chain domain with strong knowledge of standardbusinessprocesses likeE-commerce, Inventory Control, Procurement & Allocation, Merchandise Planning, Pricing & Invoicing, Demand Planning & Forecasting, Returns, Warehouse & transportation management process, Accounting & financials. Good knowledge on POS and Assortment Planning.
• Experience capturing requirements for web development specifically in eCommerce Payment Transactions.
• Possess strong knowledge of Digital Ad Sales & Operations business with digital marketing and analysis of individual campaigns.
• Worked on MDM to help the organization with strategic decision making and process improvements.
• Expertise in utilizing e-commerce tools such as ATG to facilitate site improvement recommendation to increase sales and Omni Channel strategies and Price Optimization.
• Experience with concentration on Use Case modeling using UML, Business Process Modeling, Data Modeling, Change Management, Technical Training, Software Development methodologies, QA testing, and Systems Testing of client server and web-based systems.
• Experience in conducting Joint Application Development (JAD) sessions with end-users, expert team, development and QA team for project meetings, walkthroughs and customer interviews
• Extensive experience in modeling the AS IS and TO BE E-commerce solutions.
• Proficient in creating Risk Analysis documents, Risk Management Plan, User Requirement Specification, Functional Requirement Specification and Business Process Flows.
• Hands on experience working on translating Business needs into end-user reports with Business Intelligence Tools likeTableau, Power BI.
• UsedInformaticato extract and transform data from various relational databases to the data warehouse.
• Extensive experience in configuring data mapping between different Databases.
• Experience working on various business technologies including business process tools such as Microsoft Project, Primavera, Promote, MS Excel, MS Access, MS Visio, technical assessment tools, Data Warehousing concepts.
• Possessed extensive experience in B2C and B2B ecommerce and broad knowledge of various commerce platforms.
• Well-versed in project management tool (MS Project) for status reporting, planning and resource allocation.
• Extensive experience in developing Use Cases, creating Screen Mockups, conducting Gap Analysis and Impact Analysis, SWOT analysis, Cost Benefit Analysis, Risk Analysis.
• Worked on data profiling and analyze data in the database SQL server by running SQL queries.
• Interface with clients from Operations, Marketing, Sales, Technologies, and Outside Vendors and act as their customer interface point as the lead of the Projects.
• Strong experience in conducting User Acceptance Testing (UAT) and documentation of Test Cases. Expertise in designing and developing Test Plans and Test Scripts.

PROFESSIONAL EXPERIENCE

Sr. Business Analyst

Confidential, Hoffman Estates, IL

Responsibilities:

• Work from the inception Phase and prepare vision statement and initial data models that contain Business Requirement Documents and supporting documents that contain the essential business elements and detailed definitions. Interacted with the PM in managing the Agile Scrum process to ensure smooth delivery of projects.
• Worked with the Project Manager in setting realistic Project expectations and in evaluating the impact of changes on the organization and plans accordingly and conducted Project related presentations.
• Identified internal and external system requirements, design and configuration set-up, also created User Documentation and conducted training class.
• Involved in design of order fulfillment and integration with multiple external systems like Inventory Management System, Warehouses, vendor merchandizing systems etc.
• Gathered requirements for Order Management, Warehouse Management System (WMS), Ecommerce B2C and B2B portals for supporting the Sterling Order Management System (OMS) solution.
• Responsible for implementation of Sterling Order Management system and actively involved in in processing Invoices, Credit memo, Re-bills & order management Transactions.
• Validating new platform for Sterling OMS by executing End to End test cases in integrated environment
• Followed Agile methodology to gather, document and implement requirements in an iterative manner through bi-weekly sprints and monthly releases.
• Gathered requirements for the integrationofPOSsystem with the supply chain system.
• 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.
• 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.
• Acted as a liaison betweenBusinessusers and Development team; created Functional requirement document and Product requirement document (PRD).
• Provided best practice recommendations in tech areas of Order Management System (OMS).
• Involved in creatingcustom Magento extensionsand template integration in E-Commerce tool Magento OpenCart to enhance the functionality of the website.
• Worked on requirements for proprietary ERP system enhancements (Comprehensive Commerce Suite), including User Stories and wireframes.
• Responsible for developing, maintaining and supporting process improvements for the Corporate ERP systems including MS Dynamics GP (Great Plains) and MS Dynamics CRM, and integrated systems.
• Worked on implementing Agile Scrum methodology guidelines to build artifacts in different sprints and phases of the application development process.
• Responsible for implementing supply chain and operations solutions in the exploration & production lines.
• 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 product development of a proprietary EDI system enabling the integration of electronic invoicing with billing systems and order fulfillment.
• Checked to make sure orders from customers are accurate and free of any variance by working closely with the sales, shipping department and warehouse.
• Facilitated User meetings to gather requirements, Workflow Analysis, Business Process Models and Functional Design Definitions and High-Level Analysis and Designs. Gathered and documented MDM application, conversion and integration requirements.
• Involved in managing live eCommerce clients of mid-sized B2B and B2C eCommerce websites integrated with the company's existing ERP software and Shipping Software in a Content Managed System (CMS)
• Evaluated existing e-Commerce applications to identify areas of improvement and carried out program enhancements and modifications.
• Worked with the Project Managers and SME’s to co-ordinate with regards to the various ongoing projects like PIM (Product Information Management, STIBO, MDM) and ERP solutions (Oracle NetSuite).
• Worked along with ETL developers using Informatica Workflow Manager, by assisting them in Extraction, Transformation, and Loading operations.
• Also, worked on ETL document and monitored ETL logs.
• Involved in Extracting data from business intelligence system and generate reports for planning/MDM, manufacturing and other areas of the supply chain.
• Generated reports for my manager through PowerBI and Tableau, and flow charts for the integration mapping
• Worked with ATG Software (B2C, B2B, Scenarios, BCC, Merchandising, CSC.)
• Communicated and documented business requirements for technical teams.
• Compiled and analyzed various reports: E-commerce internal support report.
• Involved in designing the Database architecture and implementing stored procedures, functions, views, and scripts using SQL Server to build data processing modules.
• Worked with data analyst team to design model and generate data mapping documents and participated in data analysis using SQL Server in MS Visual Studio and create reports with Business Objects and using Tableau for data visualizations.
• Created mockup diagrams using MS VISIO and provided the screenshots replicating the changes to the User Interface (UI) as per the requirements.
• Answered Detailed Questions regarding API flows and types of APIs to be used. Determined type of web-service API calling Model to be used (Synchronous API calling versus Asynchronous API calling) in the designed solution “Approach document”. Depended on Partner Capability, Business Billing Requirements.
• Provided Schemas, XML samples, Business purpose of the APIs, Onboarding sheet, etc. to key resources belonging to different system modules.
• Facilitated Connectivity Setup & Connectivity Testing with Infrastructure Team.
• Performed RTM Test Matrix, GAP analysis and SWOT analysis to check the compatibility of the existing system infrastructure with new business requirements
• Ensuring accuracy and integrity of ecommerce data through SQL queries which enhances the data quality as per business standard.
• Test the user stories for accuracy and compliance to ensure undisputed acceptance and validation of stories.
• 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.
• Support and collaborate with QA Team and prepare Test Plan and review Test Cases and approval process.
• Worked with QA team in conducting GUI testing, Functionality testing, System testing, Unit testing, Integration testing, Front-end testing, Back-end testing and Regression testing of Client/Server and Web based applications.
• Worked on on-shore/off-shore model. Coordinated with the off-shore testing team to ensure smooth functioning of the team.
• Documented and Performed User Acceptance Testing (UAT).
• Analyzed business processes, requirements and data necessary to provide detailed logic for ETL development.
• ImplementedScrum with JIRAto track the progress of project and involved in creating Product Backlogs, EPICs and User Stories

Business Systems Analyst

Responsibilities:

• Worked closely with Business owners & end users for Business functions and analyzed business requirements and detailed design of the software.
• Involved in preparing test data for the application; publish content and assets like images into the application through CMS and ATG BCC systems that help in effective testing of the application.
• Lead Business Intelligence reports development efforts by working closely with MicroStrategy, Teradata, and ETL teams.
• Worked with customers on identifying unique B2B ordering requirements and reporting functions.
• Involved in designing the Data Warehousing ETL procedures for extracting the data from all source systems to the target system
• Involved in Designing and customizing data models for Data warehouse supporting data from multiple sources.
• Create Use Case diagrams, Use Case Templates and process flow diagrams using MS Visio for both the systems.
• Extract data from business intelligence system and generate reports for planning/MDM, manufacturing and other areas of the supply chain.
• Analysis of the workflows and use cases demonstrated by the third-party vendors as part of the vendor selection.
• Involved in creating Mock-up forms in MS Excel and Tableau for better visualization and understanding of the software solution.
• Prepared reports on analyses, findings, and project progress, and presented results to management and customer personnel for E-Commerce applications.
• Worked on User experience (UX) definition and User Interface (UI) design for project as well as mockups, prototypes and wire frames.
• Involved in developing an in-house Comprehensive Order Processing software or OrderManagementSystem (OMS) for order entry and processing. Also developed Distributed OrderManagement(DOM) software for Seamless Order Processing & Multi-WarehouseInventoryManagementfor Improved Efficiency.
• Worked with product information management (PIM) focused team to facilitate design and development of various data quality initiatives, import mappings and BPMN workflows.
• Analyzed business functions to define specifications/requirements for automating and improving business processes.
• Involved in the development and documentation of data governance policy and procedures as well as Stewardship inventory and control set up processes for MDM projects.
• Involved in implementing Omni channel Point ofCommerce(POC) and Point of Sale (POS) upgrading Order Management System (OMS) with third party vendor support.
• Worked with SMEs andbusinesspartners to gatherbusinessrequirements forRetailPricing Management.
• Worked closely with product owners to introduce new integrations from external systems to Product Information Management (PIM) using Outbound and Inbound integration endpoints.
• Develop several detail and summary reports including line and pie charts, trend analysis reports and sub reports according to business requirements.
• Assisted in the design of data warehouse solutions and business intelligence dashboards and scorecards.
• Gathered requirements for the integration of Point of Sales (POS) system with the supply chain system.
• Responsible for translating the business requirements and user expectations into detailed specifications employing Unified Modeling Language (UML) in an SOA environment.
• Assisted in testing the newly redesigned Oracle POS system.
• Participated in all the phases of Rational Unified Process with specific focus as it pertains to the software testing and used the guidelines, templates and Rational tools in all the phases.
• Involved in creating Salesforce reports and dashboards for KPIs, trending, forecasting, account plans, SPIFFs, business reviews, customer growth initiatives and ad-hoc analysis.
• Worked with key members from various cross-functional teams to analyze various third-party CRM solutions to make a ‘buy vs. build’ decision. Conducted cost/benefit and impact analysis.
• Performed numerous Ad-hoc involving SQL scripts, and Teradata.
• Supported User-Acceptance phases by performing data validations and metrics calculation across every layer including source systems, Staging, Mart and MicroStrategy layer.
• Maintenance of existing and development of new Unix Korn and C shell scripts for EDI data extraction and uploading to Excel spreadsheets and MS Project files.
• Designed and Administered Teradata Scripts, Tables, Indices and Database Objects.
• Worked on a consolidated and prioritized 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.
• Apply Supply chain Management (SCM) methodologies to ensure coordination in the supply chain.
• Participated in UAT and worked with Jira for bug and defect tracking.
• Created specifications for data cleansing and conversion programs, EDI sales data loading processes and procedures, mapping of client/territory alignments and hierarchies.
• Involved in creating and testing the Campaigns and Promotions on Salesforce Commerce Cloud (Demandware) platform.
• Used Rational RequisitePro for managing the requirements
• Documented Test Plans and Test Cases using Rational Test Manager.
• Used SQL Queries to validate and manipulate the data in Oracle database.
• Tested Reports functionality and result applying Business rules with estimated Results, which were developed on the GUI.
• Used Rally and TFS for updating the status of all the Test Cases & Test Scripts that are executed during testing process.
• Assisting with introductory stage planning/development of managed CRM solutions for Field Marketing Organizations (FMO) on Microsoft Dynamics CRM.
• Interacted with developers and various members of my team to discuss and resolve defects and their priorities
• Conduct JAD sessions to gather information about user experience for developing the User Interface and Reporting.
• Coordinated the User Acceptance testing (UAT) with the end use.

Business Analyst

Confidential, Bentonville, AR

Responsibilities:

• Conducted interviews and JAD sessions with stakeholders and other key decision makers in order to identify requirements and business-related information.
• Worked on converting business requirements into BRD, User Stories and SRS.
• Used Use Cases, User Stories, Flow Charts, Process maps and Workflows Diagrams to supplement the planning phase.
• Worked with IT team members and stakeholders about requirement changes and updates.
• Determined, diagnosed and proposed solutions to problems with the system's functions through data analysis.
• Documented project specifications and communicated the same with the cross-functional partners to create and maintain standardized Omni-Channel reporting which includes daily dashboards, operational metrics reporting, ad hoc operational troubleshooting and strategic reporting.
• Collaborated with third party web developers, photographers, SEO (Search Engine Optimization) and SEM (Search Engine Marketing) teams conducting daily, weekly and monthly check-ins on progress of projects to ensure all business requirements and objectives are met.
• Wrote SQL queries for data analysis and validation.
• Worked with developers to simplify checkout process, such as reducing time and procedures for returning customers to complete prior saved shopping carts.
• Worked on creating Validation queries (SQL) for testing of ETL workflows using ETL mapping document.
• Performed analysis of several websites to identify competitive advantages and value addition to Confidential .
• Conducted Customer Service Operations and Supply Chain with the guidance of Product Manager.
• Provided product support to Enterprise, Supply Chain, and Order Management Applications.
• Worked with key Business Stakeholders, engineering development, and PMO on developing system enhancements.
• Analyzed inventory requirements from B2B & B2C clients and based on sales developed a process to optimize orders that needed to be fulfilled based on SKU dimensions, pallet sizes, customer requirements and delivery requirements; followed the omni channel fulfilment strategy for tracking inventory and sales.
• Gathered Software requirements through Customer interface, requirement workshops, task and workflow analysis, interviews, and brainstorming.
• Identified internal and external system Requirements, design and configuration set-up.
• Gathered user and business requirements through open-ended discussions, brainstorming sessions and role-playing.
• Translated the Business needs into system Requirements, communicating with the Business on a broader scale and with an in-depth view.
• Gathered requirements and facilitated DCO sessions to capture the business objectives for the Omni application.
• Participated in joint application development (JAD) sessions with stakeholders in order to capture business rules, business processes, and system requirements.
• Partnered with continuous product engineering teams on investigating systemic issues.
• Created and executed SQL queries to find clues on what may be causing the opportunity.
• Participated in the Logical and Physical Design sessions and developed Design Documents.
• Played key role in defining test automation procedure and standards, creating
• Win Runner and Quick Test Professional scripts for all the modules, which reduced the regression cycle drastically and improved the testing efforts for daily builds.
• Worked with Quality Control Teams to develop Test Plan and Test Cases.
• Worked on User Manuals, and Training Manuals as per Project Specifications and timelines.
• Involved in E-Commerce POS testing Product Search, Payment System, Online transaction processing.
• Participated and provided signoff based on User Acceptance Testing results.
• Performed GUI testing and analyzed end-to-end functionality by testing the application manually.
• Partnered with the Technical Areas in the research and resolution of System and User Acceptance Testing.
• Analyzed the test results from QA teams using Performance Studio Analysis to create various scenarios.
• Worked on the execution of both eCommerce exclusive and omni-channel promotions.
• Used Agile methodology and utilized Software Development Life Cycle (SDLC) to configure and develop process, standards procedures
• Created business requirement documents and integrated the requirements and underlying platform functionality.
• Produced metrics which provide management insight into the requirements process, to include, status, size, volatility, quality, effort, etc.- Visio, Rational Tools, Traceability Matrixes.

Business analyst

Confidential, NYC, NY

Responsibilities:

• Reviewed business and overall functional requirements by conducting detailed interviews with business users, stakeholders, and Subject Matter Experts (SME's)
• Participated in the testing of B2B and B2C websites, including creating test plan and test cases, executing test cases (including regression and ad-hoc testing), and defect management
• Helped to establish Omni-channel measurement at the customer level for new CRM tool and mobile marketing beacons to connect in store behaviours to online users.
• Led and implemented the entire agile methodology of application development with its various workflows and activities.
• Gathered the requirements for the desired system and reviewed a GAP analysis report as to the difference between the AS and TO-BE system.
• Created Use case and User stories as part of the functional specification document.
• Conducted weekly status meetings after collecting status of the project.
• Included the 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 in order to maintain detailed verbal description of the project.
• Created use-case scenarios and storyboards in MS Word and MS PowerPoint for better visualization of the application and managed them using Rational Requisite Pro.
• Complete project leadership of E-Commerce solution for target.com business platform for multiple sales channels
• Business direct (B2B), Consumer Direct (B2C) and Retail channels using Microsoft Project with Agile software development.
• Facilitated meetings and detailed communication with developers, system analyst and testers to collaborate resource allocation and project completion using MS Project.
• Involved in Designing and implemented basic SQL queries for QA testing and report/ data validation.
• Validated the business, user and functional requirements as the current project went along.
• Reviewed and validated BRD (Business Requirements Document) and convert business requirements into FSD (Functional Specifications Document)
• Conducted Joint Applications Requirements Capturing Session (JAR) and Joint Application Development (JAD) sessions to understand, capture and confirm requirements and resolve cross-functional issues.
• Participated in data analysis and documentation, and got involved in business test cases and expected results.
• Created functional requirements document for technical team as per the business requirements.
• Involved in the web parts to make sure that the documents are easily available to sales teams & senior management.

Business analyst

Confidential, New York City, NY

Responsibilities:

• Have gathered requirements by conducting brainstorming, interviews, JAD Sessions with stakeholders and SMEs to understand the needs of the application.
• Performed feasibility study, SWOT analysis and cost benefit analysis.
• Involved in custom tools upgrade client had created marketing, merchandising product tools to support their custom web application which needed to be re-architected to work with ATGs ecommerce suite.
• Utilized corporation developed Agile SDLC methodology. Used Scrum Work Pro and Microsoft Office software to perform required job functions.
• Involved in process/functional aspects of Supply Chain Industry.
• Worked with SME’s in analyzing the business processes, requirements and data necessary to provide detailed logic for ETL development.
• Instrumental in developing Use Cases, Use Case Diagrams, Activity Diagrams using MS Visio.
• Involved in Implementing the entire Rational Unified Process (RUP) methodology of application development with its various workflows, artifacts and activities.
• Partially involved in the Wire Frames, User Interfaces, AS-IS and TO-BE flows and the Use Cases to encapsulate the information with ease.
• Involved in reviewing and Analyzed Business Requirement Documents (BRD), Functional Requirement Documents (FRD) and translated them to System Requirement Specification (SRS) and developed requirements that are included in RFP's.
• Assisted in conducting workflow, process diagram and GAP analysis by identifying existing technologies, documenting the enhancements to meet the end state requirements.
• Participated in the analysis design and implementation and enhancement of hybrids e-commerce platform
• Gathered requirements for Client-Side Validation, and Server-Side. Created Test Plans, Test Cases, and Test Scenarios and conducted Functional/Non-Functional Testing.
• Assisted QA team in Testing calls and responses to various REST API's and documented them using Swagger.