We provide IT Staff Augmentation Services!

Sr. Business Analyst Resume

Princeton, NJ

SUMMARY

  • Business professional with over 8 solid years of experience in the area of Business Research/Analysis. Working with professional personnel to integrate management and staff's market specifications into technological applications in Retail and E - commerce, Supply Chain and Warehouse Management systems.
  • Self-starter and a team player; able to multi-task as well as work in a fast-paced environment to ensure that the customers’ and business needs are met first.
  • Experience Working across Omni channel, Customer Order fulfillment, Product management, Inventory management, Forecasting, Assortment, order management system (OMS) and replenishment.
  • Proficient in Technical and Business Writing, Business Process Flow and testing various methodologies.
  • Strong understanding of project life cycle and SDLC methodologies including RUP, RAD, Waterfall and Agile.
  • Extensive Experience in Gap analysis to compare As Is with To Be business processes and offered solutions.
  • Extensive Experience in Designing and reviewing of various documents including the Software Requirement Specifications (SRS), Business requirements document (BRD), Use Case Specifications, Functional Specifications (FSD), Systems Design Specification (SDS), Requirement Traceability Matrix (RTM) and testing documents.
  • Experience in Oracle Retail Modules like Retail Merchandising System (RMS), Oracle Retail Invoice Matching (REIM), and Retail Price Management (RPM) and also TEMPhas very good experience in Order Management Application.
  • Working experience across Omni channel, Customer Order fulfillment, Product management, Inventory management, Forecasting and Replenishment.
  • Extensive experience in full life Cycle implementations of Distribution & Supply chain Modules.
  • Highly experienced in conducting requirement gathering sessions, feasibility studies and Impact Analysis and organizing the software requirements in a structured way using Rational Requisite Pro to track development.
  • Excellent communication, presentation, project management skills, a very good team player and self-starter with ability to work independently and as part of a team.
  • In-depth knowledge of creating use cases, functional design specifications, activity diagrams, logical, component and deployment views to extract business process flow.
  • Experience in interviewing SMEs and Stakeholders to get a better understanding of client business processes and gather business requirements.
  • Conducted JAD sessions, created Use Cases, work flows, screen shots and Power Point presentations.
  • Experience managing the product development of a proprietary EDI system enabling the integration of electronic invoicing with billing systems and order fulfillment.
  • 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.
  • Extensive experience with Business-to-consumer (B2C) sales of tangible goods and Business-to-business (B2B).
  • Experience in B2B, B2C and E-commerce portals and web applications.
  • Excellent Retail e-commerce domain knowledge, with working experience in Salesforce commerce cloud (Demand ware).
  • Good experience at Demand ware, ATG Dynamo B2B Commerce, ATG B2C Commerce, Shopping Cart, Product Catalog, Merchandizing, Catalog, Droplets.
  • Good working experience at Master Data Management (MDM), Identity data, Trade Promotions Management (TPM) and Point of Sales (POS).
  • Experience working with Retail Oracle POS application, Payment processing (EMV).
  • Expert level working knowledge in different verticals and areas like Localization, Mobile-Commerce, SCM, and CRM.
  • Experienced in SQL, Access, Excel and internally developed business data and marketing tools. Also experienced in UX design & testing.
  • Proficient in using version control tools, Team Foundation Server (TFS), GITHUB and agile management tools like JIRA, RALLY.
  • Experienced in SQL Server Reporting Service (SSRS), Executing Queries and Running Stored Procedures.
  • Experience in extracting UI based information by querying the Oracle database using SQL queries.
  • Strong knowledge in SQL Server disaster recovery, backup/restore, migration and upgrade.
  • Highly Experienced in Microsoft Office Suite including MS Visio, Excel, PowerPoint, Word and Outlook.
  • Experience in working with defect tracking tools like JIRA, and Quality Center.
  • Expertise in designing and developing Test Plans and Test Scripts.
  • Experience testing implemented systems and system changes including liaising with QA teams to develop test cases, test plans, test scenarios, and generating test data and conducting manual testing.
  • Facilitated Change Management across entire process from Project conceptualization to Testing through Project Delivery, Software Development and Implementation Management in diverse Business and Technical Environments.
  • Strong experience in conducting User Acceptance Testing (UAT) and documentation of Test Cases.

PROFESSIONAL EXPERIENCE

Confidential, Princeton, NJ

Sr. Business analyst

Responsibilities:

  • Created business requirements for a web content management system (CMS) & ERP System that will be employed to support the production of the primary website.
  • Created business requirement documents and integrated the requirements and underlying platform functionality.
  • Participated in the development of in-house Comprehensive Order Processing software or Order Management System (OMS) for order entry and processing. Also involved in Order Management (DOM) software for Seamless Order Processing & Multi-Warehouse Inventory Management for Improved Efficiency
  • Document requirements by illustration of Product Backlogs, User Stories and End to End Process Flows inclusive of Business Rules, Business Process Modeling, Flows and Work Flow diagrams.
  • Business Process Analysis & Product management for Global Retailers in Omni Channel Fulfillment using Sterling commerce order management and Manhattan Warehouse management
  • Analyze, develop specifications & lead projects for ERP software applications in the areas of Mail Order, Website, Store Interface, CRM, Price\Cost Management, Purchase Order\Receiving,WMS& Order Tracking interface.
  • Effectively managed 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).
  • Assisted project manager in utilizing Warehouse Management System (WMS).
  • Track and Maintain Stakeholder requested enhancements and changes through SharePoint
  • Cleaned various documents before sign offs were commenced such as API Specs and BRD's.
  • Improved SharePoint security by proposing and implementing improved security access controls and policies.
  • Prepared reports on analyses, findings, and project progress, and presented results to management and customer personnel for E-Commerce applications.
  • Performed Gap Analysis to check the compatibility of the existing system infrastructure with the new business requirements.
  • Gathered requirements for the integration of POS system with the supply chain system
  • Created complicated use cases to test the current system which led to various defects in the mobile site dis gave way to more specific goals for the project's needs.
  • Used Jira/Confluence to track and delegate defects on the current system.
  • Worked on the financial area of ERP system, concentration with Supply Chain Management, GL, AP, Manufacturing SSB Project, Purchase and Invoicing..
  • Served as the primary point of contact, and independently resolved a high percentage of technical support issues for customers (WMS) applications.
  • Utilized the 80-20 rule to prioritize and in corporate the critical features. Used Time-Boxing techniques to finish within set time frames.
  • Designed new Web Content Management Repository by analyzing requirements; constructing workflow charts and diagrams; studying system capabilities; writing specifications.
  • Revised / Reviewed Business Requirement, Functional requirement, technical specification document, SharePoint Governance plan, Architecture document.
  • Was involved in the creation of new E-Commerce Products (Arrival Notices and Customized Reporting)
  • Accumulated system requirements from various departments through surveys and interviews.
  • Created user stories and managed the requirements effectively in TFS
  • Involved in prioritizing the defects and writing business requirements to resolve them.
  • Conducted JAD sessions with management, SME, vendors, users and other stakeholders for open and pending issues including sign offs.
  • Planned and defined system requirements to Wire Frame with Use Case, Use Case Scenario and Use Case Narrative using the UML (Unified Modeling Language) methodologies.
  • Managed, maintained, and implemented all site wide content via Hybris Management Systems (PCM, CMS, HMC)
  • Interfaced between Business new product builders and System platform builders.
  • Worked with systems area to translate business needs into system requirements.
  • Made sure the test cases and test process guarantee accountability to business and systems requirements.
  • Provided guidance to development team required to complete transition from Broad vision to Hybris ecommerce platform.
  • Involved in the testing phase right from the Unit testing to the User Acceptance testing.
  • Used SDLC (System Development Life Cycle) methodology Agile Scrum.
  • Experience in writing SQL queries for extracting information from databases
  • Using API's from the desktop site to create the mobile website and mobile applications as per requirements.
  • Relayed all Desktop BRDs to the tech team to prepare for Web crawling via API's.
  • User account profile, authentication, cart, category, checkout, content, customer service, inventory, navigation, search, stores, promotions, product collections, product list.
  • Use Cases and other Process Flow Models were designed using Visio and Rational Rose.

Confidential, Monroe Township, NJ

Business Analyst

Responsibilities:

  • Consulting Business Analyst for client Oracle XStore POS integration and enhancements..
  • Prepare 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.
  • Designed the Data Warehousing ETL procedures for extracting the data from all source systems to the target system
  • Designing and customizing data models for Data warehouse supporting data from multiple sources.
  • Helped design 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.
  • Worked with key members from various cross-functional teams to analyses various third-party CRM solutions to make a ‘buy vs. build’ decision. Conducted cost/benefit and impact analysis.
  • Translated business requirements and user expectations into detailed specifications employing Unified Modeling Language (UML) in an SOA environment.
  • Explored new growth areas for Omni channel Retailing, forging Partnerships/Alliances with other players in the value chain leading to new client engagements
  • Assisted in testing the newly redesigned Oracle POS system.
  • Wrote Test Strategy and Test Plans for XSTORE POS implementation to map out the testing strategies and timeline.
  • 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.
  • Create reports and dashboards for KPIs, trending, forecasting, account plans, SPIFFs, business reviews, customer growth initiatives and ad-hoc analysis.
  • Established UX design as the first stage of all Web and mobile application developments, instituting a user-centered design (UCD) approach.
  • Performed numerous Ad-hoc involving SQL scripts, UNIX, and Teradata.
  • Supported User-Acceptance phases by performing data validations and metrics calculation across every layer including source systems, Staging, Mart and Micro strategy layer.
  • Designed and Administered Teradata Scripts, Tables, Indices and Database Objects.
  • Extensive knowledge of RUP methodology and its implementation through the entire software development lifecycle in all four phases of a project: Inception, Elaboration, Construction and Transition
  • Working knowledge of Software Development Life Cycle (SDLC), having thorough understanding of various phases like Requirements, Analysis/Design, Development and Testing.
  • Developed 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 Sales force Commerce Cloud (Demand ware).
  • Manage the product development of a proprietary EDI system enabling the integration of electronic invoicing with billing systems and order fulfillment.
  • Applied Supply chain Management (SCM) methodologies to ensure coordination in the supply chain.
  • Participated in UAT and worked with HP Quality Center for bug and defect tracking.
  • Tracked bugs and reported issues and defects using JIRA.
  • Created specifications for data cleansing and conversion programs, EDI sales data loading processes and procedures, mapping of client/territory alignments and hierarchies.
  • Created and tested Campaigns and Promotions on Sales force Commerce Cloud (Demand ware) platform.
  • Used Rational Requisite Pro for managing the requirements
  • Documented Test Plans and Test Cases using Rational Test Manager.
  • Tested the web application components of Content Merchandising System, Oracle RMS (v9, v10), and WebSphere commerce functionality on various web browsers as part of UI testing.
  • Used SQL Queries to validate and manipulate the data in Oracle database.
  • Tested Reports functionality and result applying Business rules with estimated Results.
  • 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
  • Assisted in JAD sessions to gather information about user experience for developing the User Interface and Reporting.
  • Created and authored Use Case Diagrams and Activity Diagrams using MS Visio.
  • Coordinated the User Acceptance testing with the end use.

Confidential, West Chester Township, OH

Business analyst

Responsibilities:

  • Gathered requirements for Order Management, Warehouse Management System (WMS), Ecommerce B2C and B2B portals for supporting the Sterling Order Management System (OMS) solution
  • Followed all the phases in the Software Development Life Cycle for successfully launching the Mobile App.
  • Analyzed, converted and documented business requirement into BRD, User Stories and SRS.
  • Conducted JAD sessions for better understanding of the project goal and refined the business requirements in coordination with multiple teams.
  • Documented and analyzed thebusinessprocess for receiving and processing customer sales based on "Opportunity to Order" and coversbusiness-to-business(B2B) andbusiness-to-consumer (B2C) sales.
  • Project development with ULM modeling and documentation, Kaizen and Six Sigma methodology, Agile approach, project lead, project management training.
  • Interacted with the team for implementation, installation and deployment of Mobile POS, management and optometrist application.
  • Worked with B2B and B2C commerce applications include an Omni-Channel Offering, Product Information Management, Order Management, Hybris Marketing Conversion, and powerful search and merchandising.
  • Contribute to the discussions and understand the flow of Data from ETM to OMS and Database
  • Responsible for supporting and enhancement to these products. All products are available on desktop, and mobile platform where in our customer can order using desktop, tablet as well as smart phone. The platform used for ecommerce sites is
  • Develop and distribute frequent analytics reporting to include customer feedback, and overall KPI metrics. Analysis and make recommendations on enhancements to leadership based on findings.
  • Involved in developing customer online survey and analyzed results for website content and design management.
  • Participated in assessment of Agile maturity across the enterprise and identified areas for future improvement
  • Working in an agile team using SCRUM methodology for testing web, mobile-web, and Rest-API & Mobile web based application.
  • Worked with Development to figure out the different Activities OMS does for inter Applications data transfer with CRM in Java.
  • Involved indatavalidation of the results in Tableau by validating the numbers against the datain the database tables by querying on the database
  • Collaborated with the business and technical teams to develop the scope and vision document that defined the primary goals, objective and features of the new Ecommerce platform built In house.
  • Actively involved with the marketing strategy teams for the advertising campaign idea and conducted the marketing strategy into our web content catalog.
  • Utilized UML in behavioral, structural and architectural modeling - in creating Use Case, Activity, Class and Sequence diagrams.
  • Communicated with data analyst team to design models and create data mapping documents for data analysis and created reports adopting business objects.
  • Maintained and monitored project progress and status through MS Project. Presented periodic/monthly status reports to the Project manager to serve as the team's assessment of the project and its schedules.
  • Worked as POC with key responsibilities, which are highly accountable and aligned towards client requirements.
  • Worked on multiple streams to deliver the new website on ATG platform sitting on SOA framework and also integrated customer loyalty stream and Ad sales.
  • Maintained the product catalogs, search and navigation, search engine optimization (SEO), Business Intelligence (BI) and personalization, etc.
  • Formulated SQL Queries to generate relevant reports from the Data Ware house using Informatica.
  • Maintained the Traceability Matrix table to uniquely identify and trace the business requirements to general design to testing as to prove that the requirements has been developed into a solution and it TEMPhas been tested and tracked.
  • Worked closely with the developer team to implement the application and responsible for the user accepting test (UAT).
  • Prepared Test Reports and submitted the Bug Findings to the Bug Tracking system using Quality Center and its modules (Requirements, Test plan, Test lab and Defects)

Confidential, MO

Business Analyst

Responsibilities:

  • Worked with various e-commerce modules for electronic funds transfer, supply chain management, Internet marketing, online transaction processing, electronic data interchange (EDI), inventory management systems, and automated data collection systems. Conducted tech reviews for various modules for the team.
  • Collaborated with members of the Ecommerce team as well as Merchandising, Creative, and Brand Marketing teams to provide analytic support to measure performance of efforts. Assisted end-users in identifying key performance indicators for their areas and proactively share knowledge and learning.
  • Maintained daily and weekly dashboards. Support the creation and on-going maintenance of daily and weekly KPIs.
  • Assisted in gathering and analyzing consumer feedback to inform product, website, or functional enhancements.
  • Work with business sponsors and stakeholders to understand business requirements and develop technical specifications for projects.
  • Identifies data sources, constructs data decomposition diagrams, provides data flow diagrams and documents the process.
  • Worked with Multi-Channel Fulfillment & Inventory Management, Order Management and Omni channel retailing operations.
  • Oversee, coordinate, and participate in organizational, operational, and procedural analyses to determine information input, and desired output for potential and/or up dated computerization for a large number of users in support of a multi departmental or country wide applications.
  • Reviewed and analyzed variety of forms, documents (RT or Approach Framework) reports, data output, and record-keeping requirement to identify any questions or requirements POS team TEMPhas. Contribute in weekly staff and Analyst/Dev Meetings.
  • Used Google Analytics to analyze website usage, page views, traffic and exit to find out popular products and the reason why potential customers abandon shopping carts.
  • Simplified check out process by simplifying customer registry process. And Improved payment gateways by using Authorize.net and PayPal Pro.
  • Conducted email marketing based on customer preference.
  • Involved in creating and prioritizing the Sprint Backlogs in Rally Scrum Sprint Planning Sessions, conducting Sprint Retrospectives and Reviews, sharing metrics to identify and implement improvements.
  • Created Alternate Milestone schedule for the each assigned project that to the particular release.
  • Scheduled and host weekly internal project meetings beginning onset of analysis to implementation
  • Worked with developer leads and managers, System Testers & UAT; to review requirements of the project, status of testing and any issue needing discussion.
  • Synchronized POS and cross team delivery schedules to ensure needed resources are available.

Confidential, Houston, TX

Business Analyst

Responsibilities:

  • Gathered 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.
  • Involved in designing automated POS systems 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.
  • Checked to make sure orders from customers are accurate and free of any variance by working closely with the sales, shipping department and warehouse.
  • 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.
  • Designed the business requirement collection approach based on the project scope and SDLC methodology.
  • Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, and OOD using UML.
  • Experienced with content management, e-commerce and order management.
  • Participated in requirements analysis using a Use case driven approach and produced detailed use cases and functional specifications for all the interfaces.

Hire Now