SUMMARY

• Qualified professional with 8+ years of experience as a Business Systems Analyst in Ecommerce, Retail and Supply Chain with solid experience working with the technical staff to implement management and staff's business requirements into the software application in retail and e - commerce and digital marketing environments.
• Experience defining requirements for eCommerce platforms powered by WebSphere Commerce, Sterling Commerce, and Endeca.
• Expertise in Sterling OMS, a Sterling Commerce Supply Chain Management Tool.
• Hands on experience of working on SCM modules (viz. Order Management, Inventory, Shipping Execution, Advanced Pricing) for discrete manufacturing & distribution/retail industry.
• 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.
• Practical knowledge of SDLC methodologies like Waterfall, Iterative and Agile software development.
• Worked with Multi-Channel Fulfillment & Inventory Management, Order Management and Omni channel retailing operations.
• Extensive experience in analyzing and requirements gathering and writing system functional specifications including use cases.
• Leverage expertise in category management, inventory, customer service, loss prevention, and sales and marketing to produce results in highly competitive environments.
• Experience in designing and reviewing of various documents including the Software Requirement Specifications (SRS), Business requirements document (BRD), Use Case Specifications, Functional Specifications (FSD), Requirement Traceability Matrix (RTM) and testing documents.
• Experienced in different aspects of both Supply Chain analytics and operational expertise. Seamlessly direct deadline-driven, interrelated activities and related personnel. Hands-on experience planning and coordinating operations and Supply Chain functions; quickly master new tools, equipment, and technology.
• Experience on Retail / Supply Chain domain with strong knowledge of standard business processes like E-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.
• Extensive use of MS Office tools like MS Access, MS Word, MS Excel, and MS PowerPoint MS Project for data migration in to the CI System Knowledge Data Base in Microsoft SharePoint.
• Solid experience with SQL Server and T-SQL in constructing triggers, tables, user functions, views, indexes, user profiles, relational database models, data dictionaries, and data integrity
• Experience in Project tools such as MS Project, MS Visio, JIRA and MS Office Suite
• Expertise with supply chain strategies/vendor manufacturing process methods to determine level of procurement and strategic sourcing strategies/plans and worked with vendors/peers to determine lead times, schedules and cycle counts, established requirements needs.
• Proven expertise in data mapping identifying data source and target tables / columns along with business rules, validation rules, null rules, and transformation rules to construct the ETL process.
• Very good understanding of Business Intelligence and Data Warehousing, Data Mapping, Data Modeling, concepts with emphasis on ETL and Life Cycle Development including requirements analysis, development, testing and implementation.
• Expertise in UML (class diagrams, object diagrams, GAP Analysis, use case diagrams, state diagrams, sequence diagrams, activity diagrams, and collaboration diagrams) as a business analysis methodology for application functionality designs using MS Visio and Confidential 's Rational Rose.
• Strong experience in conducting User Acceptance Testing (UAT) and documentation of Test Cases. Expertise in designing and developing Test Plans and Test Scripts.

TECHNICAL SKILLS

• MS Access
• MS Word
• MS Excel
• MS PowerPoint
• SQL Server
• T-SQL
• SDLC

PROFESSIONAL EXPERIENCE

Confidential, North Bergen, NJ

Sr. Business System Analyst

Responsibilities:

• Conducted user interviews, gathered requirements and analyzed the requirements in RUP framework.
• Using Rational tools such as Rational Rose to model requirements and Rational Requisite Pro to manage the requirements.
• Conducted JAD session with Stakeholders, users, vendor and SME's, Project Directors for open and pending issues to develop specifications.
• Gathered, analyze, define and document business and technical requirements needed to support internal and external projects related to prepaid and payment solutions interfaces, including: client integrations, migrations and strategic platform and or/process enhancements.
• Documented use cases, workflow diagrams, screen mock-ups and functional requirements specification documents for various functionalities like Site Search, Product Detail Page, Shopping Cart and Checkout Process for desktop and mobile platforms.
• Reviewed the data model and reporting requirements for Cognos Reports with the Data warehouse/ETL and Reporting team.
• Provided input to third party UI development team in providing wireframes and comps for desktop, tablet and mobile interface.
• Documented omni channel requirements for OMS in collaboration with business stakeholders including logistics and supply chain management teams and with Manhattan OMS development team to successfully rollout BOPUS and BOSTS orders.
• Wrote BRD, FRD, use cases, test scenarios, test cases for testing the functional and non-functional aspects of both ETL jobs and Reporting jobs.
• Worked closely with various business stakeholders to come up with wireframes and get functional requirements for Buy Online Pick up in Store (BOPUS), Buy Online Ship to Store (BOSTS), Auto Refill, Product Comparison and Product Bundling etc. for desktop and mobile platforms.
• Assisted the business team to set up content data for various products via BCC on a day to day basis.
• Helped business define search customization criteria and setting up the same via Endeca Experience Manager.
• Worked with business stakeholders from merchandising department and acted as the single point of contact for end to end implementation of product recommendations with third party vendor Rich Relevance.
• Worked with offshore developers to walkthrough wireframes and FRS on various functionalities like Site Search, Product Detail Page, Shopping Cart and Checkout process for desktop and mobile platforms.
• Responsible for tracking bugs and replying to any clarifications needed by development, QA and business teams to get those bugs fixed via JIRA.
• Gathered requirements for Order management, Warehouse management system (WMS), Ecommerce B2Cand B2B portals.
• Used Confidential Websphere for Mobile application in giving seamless shopping experience to guest in selecting products, shopping cart, check out, bill payments modes.
• Responsible for identifying Data Elements along with accountable for defining the entire lineage of each Critical Data Elements back to the System of Record (SOR)
• Generated Usage Models (i.e., prototyping storyboards, screen mockups, User Interface designs, User stories) based on Agile and SDLC standards.
• Assisted Project Management in developing Scope/ Vision Documentation and Project Plan, tracking project process, and developed Risk Mitigation Plan.
• Created Use-Case diagrams, Sequence Diagrams and Activity Diagrams after accessing the scope of the Project and understanding the business processes.
• Assisted end users and IT staff in the use of data to satisfy informational and reporting requirements
• Well versed in writing SQL queries, Creating Data Mapping Documents and performing Data Extraction and Data Compilation using SQL queries.

Confidential, Atlanta, GA

Business System Analyst

Responsibilities:

• Collected detailed requirements from Marketing Merchandising team.
• Documented the Homepage, My Account, Browse Page, Product Detail Page, Cart, Checkout FRS (Functional Requirement Spec)
• Extensive use of Adobe Web Analyst/Omniture Site Catalyst for web-site analysis.
• Gathered requirement for Confidential 's iPad and iPhone app. Documented iPhone iPad App FRS
• Provide support in developing and maintaining ETL processes that extract data from multiple SOR residing on various technology platforms then transport the data to various delivery points such as data marts or data warehouses.
• Worked on WebSphere Commerce Catalog subsystem, Member subsystem, Order management subsystem, Account subsystem and Payment Subsystem.
• Acted as SPOC (Single-point-of-contact) at offshore for any functional aspect of the Confidential Sterling OMS application and its features for the assigned module.
• Works across digital teams, such as web development, digital marketing & communications, web merchandising, and copy teams to prioritize and implement improvements to user experience based on analytic findings.
• Worked closely with different stakeholders and from various departments like Merchandise Information Office (MIO), Order Optimization and Merchandise Presentation teams during the course of the project.
• Enhances digital data collection across web properties through creation of tagging specifications and QA of implementation.
• Helps to establish Omni-channel measurement at the customer level for new CRM tool and mobile marketing beacons to connect in store behaviors to online users.
• Analyze website and app data on engagement, traffic patterns, browse, and conversion.
• Supports multiple clients with system and business requests and needs using JIRA and SharePoint.
• Involved in implementing Omni channel point of sale (POS) and upgrading Order Management System (OMS) with third party vendor support.
• Interacted with Business Owners, Users, and Stakeholders to identify Business System Needs, evaluated solutions for business problems, and prepared Business Requirements Document (BRD) and later translated them into Functional Requirements Document (FRD).
• Facilitated business requirements gathering sessions with the business owners and key technical resources
• Elicited business and user requirements from business partners using a variety of Industry Standard/Best Practices techniques
• Validated requirements for quality attributes, such as clarity, conciseness, correctness, completeness, testability, and traceability
• Translated the business and user requirements into system requirements.
• Used Agile methodology and utilized Software Development Life Cycle (SDLC) to configure and develop process, standards procedures.
• Reviewed and approve project documentation, including estimates, business requirements, design documents, technical documents, test plans, and test results
• Modeled the AS-IS system and performed GAP Analysis for the existing system in order to map it to the To-Be system.
• Worked closely with the UI team to model the screens, which met user defined requirements, organizational and regulatory standards.
• Create tasks and update tasks in the MS Project and Project Management Directory for the senior management reviews.
• Involve in the system workflow analysis and contributed to the overall work flow diagram for the website
• Reviewed test cases written by QA team and made changes for better execution of test cases.
• Documented Requirement Traceability matrix in Requisite Pro for traceability of requirements through test cases.
• Maintained and monitored Project progress status using MS Project.
• Communicated status of efforts to management and business partners on a regular basis to ensure that all stakeholders have accurate and current information throughout the process.
• Conducted User Acceptance Testing (UAT) with the stakeholders and business users, fixed the discovered errors and verified it through regression testing

Confidential, Wayne, NJ

Business Systems Analyst

Responsibilities:

• Worked with IT leads, business stakeholders and development teams to define detailed UI requirements for customer profile; My Account, Baby Registry, Shopping Cart, Checkout and OMS for Confidential "R" Us and Babies "R" Us online storefront.
• Documented detailed level requirements in the form of User Stories for various functionality like Promotions, Product Detail Page, Shopping Cart and Checkout.
• Worked on UI and data requirements with vendors and development team to successfully implement tax calculation, single use coupons, gift cards and payments (Credit Card and PayPal) with third party vendors like DMA, Cashstar, Cardinal Commerce, BAMS, PayPal and Synchrony and to ensure that customer data flowing through the process is PCI compliant.
• Worked on requirements to implement "R" Us brand credit card provided by third party vendor Synchrony Financial. Synchrony implementation provided Confidential "R" Us shoppers with the ability to apply for a credit card and buy with the same card during checkout.
• Developed detailed level end to end process flow diagrams for Confidential "R" Us and Babies "R" Us online payment processing, including integrations like PayPal, Synchrony, Cardinal Commerce, Cashstar and TRU payment gateway, BAMS (Bank Of America Merchant Services)
• Documented data attributes for create order, update order and cancel order from ATG to Manhattan OMS.
• Primary Business Systems Analyst for supporting Clarity PPM application for CIF (New Product Development) and IT PPM (IT Governance); ATG Web Commerce for E-Commerce platform.
• Developed BRD and FRD for illustrating storefront experience for individual users, broker and Medicare segment users
• Collaborated with development team to create OMS (Order Management System) to ensure significant improvements in working efficiency and organize orders in a timely and systematic manner;
• Prepare use case documents and utilized MS Visio to create UML diagrams including use case, activity and class diagrams to extract business process flows and workflows, thereby assisting development and quality assurance teams in understanding the requirements.
• Created object-oriented Use Cases, UI mock up's for simulating the system functionality to the Business clients.
• Participated in JAD sessions for requirement, feasibility and risk analysis with various stakeholders, including designers, developers, QA and management to identify critical and high-risk areas of the application.
• Documenting workflow analysis on the business area processes, systems, and information flows, as part of agile project management activities.
• Strong understanding of Data mining techniques with knowledge in end-to-end data reconciliation, SQL, PL\SQL, Oracle\ETL environments (tools like Toad\Informatica).
• Designed and developed project document templates based on SDLC methodology.
• Involved in one-to-one interview sessions and JAD sessions with stakeholders, SME's and business owners to discuss the scope of the conversion.
• Prepared Scrum artifacts - product backlog with user stories, sprint backlog, burn down charts, and sprint releases using JIRA.
• Documented the Traceability Matrix for tracing the Test Cases and requirements related to them.
• Develop Non-Functional requirements (NFR) along with client SMEs to ensure coverage of requirements such as browser support, load testing and other mandatory US Government norms specific for healthcare industry
• Analyzing feasibility and Risk to identify the business critical and high-risk areas of the application.
• Facilitated UAT activities for various project releases.

Confidential, Columbus, OH

Business Systems Analyst

Responsibilities:

• Analyzed the existing claims process and specific business rule logic will be applied in the ACP model.
• Prepared questionnaire based on the System Analysis Performed for all entities.
• Considered Unified Dimensional Model (UDM) using views, and Unified Modeling Language (UML) and object-oriented design.
• Participated in design and build of different OMS modules - Order Capture, Order Processing, Order Promising & Fulfillment, Payment Processing and Reverse Logistics etc.
• Responsible for generation of project artifacts such as Charter, Business Case, Detailed (Functional/Non-Functional) Requirements, SharePoint documentation.
• Responsibility to map and test data requirements for futures, options and other derivative instruments into existing trade order management system and back-office accounting.
• Utilized corporation developed Agile SDLC methodology. Used ScrumWork Pro and Microsoft Office software to perform required job functions.
• Collaborated with Order Management (OM) and Supply Chain Management (SCM) team members.
• Conducted extensive Joint Application Development (JAD) sessions for all business-related issues.
• Maintained records and statistical information for E-Commerce managers, E-Commerce personnel, other departments and outside vendors
• Determined project scope and engineering requirements, estimated schedules, tracked item completion, certified milestones and maintained project documentation and corporate e-commerce web site Testing.
• Established connectivity to all major buy-side vendor order management systems (OMS).
• Involved in project scope meetings with the Pricing manager to understand the type of requests and issues handled by the pricing team and documented the high-level business requirements to the product backlog using JIRA Agile.
• Prepared High Level Logical Data Models and BRD's (Business Requirement Documents) supporting documents containing the essential business elements, detailed definitions, and descriptions of the relationships between the actors to analyze and document business data requirements.
• Reviewed the data model and reporting requirements for Cognos Reports with the Data warehouse/ETL and Reporting team.
• Identify customer marketing opportunities by applying data mining models and writing advanced T-SQL stored procedures and queries.
• Responsible to import the data from Crystal reports by using Business Objects Live office into Microsoft Excel and Word.
• Provided data modeling support for numerous strategic application development projects.
• Documented the meeting minutes with issues of about discussed and solutions resolved.
• Used MS Visio to create Flow diagrams and Use Case Diagrams.
• Created and executed detailed test cases for testing the application on Android and iPhone.
• Created test scripts for all the test cases in PL/SQL.

Confidential, Irving, TX

Business Analyst

Responsibilities:

• Worked closely with technology and business user staff to complete workflow improvement and document functional specifications for systems
• Maintains and updates all the POS related FSD (Functional specification document) at the end of every release
• Involved in requirements gathering and system analysis through RUP of an online portal to provide visibility to corporate customers.
• Developing Use Case Models, Entity Relationship Diagrams (ERD), Activity Diagrams, State Diagrams and Data Flow Diagrams (DFD).
• Facilitated collection of functional requirements from system users and preparation of business requirement documents using Rational Requisite Pro.
• Followed agile methodologies in executing the project with daily standups, discussing roadblocks, documenting issues with JIRA tickets and updating the status
• Agile Assigned tasks among development team, working with clients to better understand their needs and present solutions using structured SDLC approach.
• Work on the Data Modeling, Entities and Attributes of the Data points and Templates.
• Involved in preparing interview questionnaires for the clients to gather requirements and prepared Functional Specifications and User Requirements. These specifications included UML-based use case models and activity diagrams, and usability analysis/user interface specification including wireframes and usability analysis.
• Prepared for each sprint, ensuring all stories are fully defined with user journeys, user stories
• Involved in developing business requirements document (BRD), User stories, User requirements and functional requirements.
• Prepared Use Case Models based on Business Requirement documentation gathered through interaction with users.
• Prepared Flow Diagrams, Sequential Diagrams in MS Visio.
• Conducted JAD Sessions for understanding the workflow.
• Conducted Previews and User Acceptance Test (UAT) sessions with the marketing team.