PROFESSIONAL SUMMARY:

• Business Analyst with over 8+ year’s industry experience in business data modeling, software requirement analysis, process modeling, process flow and quality assurance skills using different methodologies, mainly OOA, OOAD and UML.
• Experience as a Business Analyst specializing in Retail, E - Commerce with a focus on designing, development implementation of the business processes.
• Extensive knowledge and experience in Optimizing SCM, Reducing Inventory & Holding cost, Manufacturing Process Improvement, Supporting and enhancing POS (Point of Sale systems) in Retail Domain.
• Extensive knowledge of all phases of the software development life cycle (SDLC) and the iterative Rational Unified Process (RUP).
• Extensive experience working with vendor e-commerce tools like Microsoft commerce as well as helping construct and integrate in-house e-commerce applications.
• Experienced working with Order Management system products (IBM Sterling OMS & Manhattan).
• Expertise in utilizing e- commerce tools such as ATG to facilitate site improvement recommendation to increase sales and Omni Channel strategies and Price Optimization.
• Organized many Joint Application Developments (JAD) sessions and Joint Requirement Planning sessions (JRP), walkthrough, Interviews, Workshops and Rapid Application Development (RAD) sessions with end-user/clients/stake holders and the IT group.
• Strong in ETL, data validation using Informatica, Worked on Stage, Core & Work (Data warehouse) Tables.
• Extensive experience in modeling the AS IS and TO BE e-commerce solutions.
• Design and review of various documents including the Software Requirement Specifications (SRS), including USE Cases, Business requirements document (BRD), Use Case Specifications, Functional Specifications (FSD), Systems Design Specification (SDS), Requirement Traceability Matrix (RTM) and testing documents.
• Experience in modeling UI wireframes, mockups and documenting the end-user's AS-IS workflow and TO-BE business processes
• Proficient in creating Risk Analysis documents, Risk Management Plan, User Requirement Specification, Functional Requirement Specification and Business Process Flows.
• Proficient in using UML in behavioral, structural and architectural modeling - in creating Use Case, State, Activity, Class and Sequence diagrams using Rational Rose.
• Experience in development methodologies like RUP, SDLC, AGILE, and Waterfall.
• Used Erwin to capture data by creating Entity-Relationship and Use Case diagrams.
• Worked with Rational Suite of tools to create requirements documents (Requisite Pro), visual data models (Rose), manage and track defects (Clear Quest).
• Well-versed in project management tool (MS Project) for status reporting, planning and resource allocation.
• Experience in a major effort to improve the Warehouse Management System (WMS) capabilities of Supply Chain Management.
• Worked on data profiling and analyze data in the database SQL server by running SQL queries. Expertise in running SQL quires on oracle databases, Microsoft server etc. for the purpose of data analyst.
• Experience in conducting GAP analysis, User Acceptance Testing (UAT). SWOT analysis, Cost benefit analysis and ROI analysis.
• Tools and technologies: IBM Initiate, IBM Web Sphere Application Server, IBM MQ, IBM Initiate Message Broker, Shell scripting, Oracle, SQL, MS Office, Visio, IBM AIX, J2EE, SVN, IBM RAD, Python, XML (XSD, DTD).
• Involved in MDM Process including data modeling, ETL process, and prepared data mapping documents based on graph requirements.
• Assisted the QA team to design Test plans and Test Cases for User Acceptance Testing (UAT), Black-box Testing, Functional Testing, various System Testing, Integration Testing, Regression Testing, Security Testing, Load/Stress Testing, and Performance Testing in both manual and automation testing environment and creation of Test plans, Test cases and Test scenarios for validating it against business requirements document.
• Demonstrated ability to perform Root Cause Analysis, consider both the long and short-term impact of proposed solutions and develop effective solutions.
• Successful as a team player to work in conjunction with other DBA’s, testers, developers and other team members in validation and testing complex scenarios and projects and in the maintenance of Quality Standards in Projects especially with Test Director.
• Strong communication, problem solving, organizational, interpersonal, and presentation skills.

WORK EXPERIENCE:

Confidential, Seattle, WA

Sr. Business Analyst

Responsibilities:

• Gathered and wrote functional/ business requirements used by engineers and programmers on multiple e-commerce applications as well as collaborate with User Experience/Interface designers to develop wireframes/schematics that support such requirements.
• Followed the Agile methodology as the SDLC approach.
• Worked collaboratively with Marketing, Planning, Finance, and Customer Care Center in various stages of SDLC.
• Involved in E- Commerce POS testing Product Search, Payment System, Online transaction processing.
• Maintained records and statistical information for E-Commerce managers, E-Commerce personnel, other departments and outside vendors.
• Good knowledge on Sterling OMS helped to define the contract between systems and modeling the tables.
• Determined project scope and engineering requirements, estimated schedules, tracked item completion, certified milestones and maintained project documentation and corporate e- commerce web site Testing.
• Coordinated workflow across ecommerce, IT, UI, retail and UAT teams.
• Performed analysis of several websites to identify competitive advantages and value addition to Wal-Mart.
• Exposed to Agile methodology Performed Gap analysis (AS-IS) & (TO-BE) by identifying existing processes, technologies, and documenting the enhancements needed to meet the end state requirements.
• Demonstrated the project through Agile Life Cycle & elicited requirements from clients to create Business Requirements Document (BRD) for the existing system to improve project goals.
• Provided product support to Enterprise, Supply Chain, and Order Management Applications.
• Gathered Software requirements through Customer interface, requirement workshops, task and workflow analysis, interviews, and brainstorming.
• Configure and analyze IBM Initiate MDM system for a two entity (provider and location) data model with relationships.
• Performed Data Analysis of existing data through SQL and experience with EDI & ETL.
• Expert knowledge of Sterling Order Management System components, API's, and related Interfaces
• Participated in joint application development (JAD) sessions with stakeholders in order to capture business rules, business processes, and system requirements.
• Participated in creating business requirement documents and integrated the requirements and underlying platform functionality.
• Used JIRA for User Story requirements management throughout the Agile Sprints and development life cycle.
• Produced metrics which provide management insight into the requirements process, to include, status, size, volatility, quality, effort, etc.- Visio, Rational Tools, Traceability Matrixes.
• 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
• Partnered with continuous product engineering teams on investigating systemic issues.
• Involved in creating and executed SQL queries to find clues on what may be causing the opportunity.
• Assisted to develop the Test Plan, Test Cases and Test Scenarios to be used in testing based on Business Requirements, technical specifications and/or product knowledge.
• Participated and provided signoff based on (UAT) User Acceptance Testing results.
• Performed GUI testing and analyzed end-to-end functionality by testing the application manually.

Confidential, Burlington, NJ

Business Analyst

Responsibilities:

• It is a web-enabled system, which works in conjunction with ATG through which Call Center Executives input their incoming call data depending upon the nature of call and category. It features data management, workflow, time taken for a call, depending whether the type of call is through phone, e-mail or chat.
• Involved in developing e-commerce products that allowed beauty consultants and customer service agents place ordering online.
• Help analyze, troubleshoot, and/or tune Sterling Commerce product performance or deployment issues when required.
• Designed and implemented data integration modules for Extract/Transform/Load (ETL) functions.
• Experience with various ETL, data warehousing tools and concepts.
• Implemented metadata standards, Collabra Data Governance and stewardship, master data management, ETL, ODS, data warehouse, data marts, reporting, dashboard, analytics, segmentation, and predictive modeling
• Usage of ATG platform including repositories and RQL to build an e- commerce site.
• The focus of the Project was to upgrade Dell’s IVR system by developing an application in Siebel Call Centre.
• Trained new analysts in E-Commerce best practices, Magneto platforms, technologies and business strategy.
• Conducted user interviews, gathered requirements, analyzed the requirements using RUP methodology and documented the requirements using Rational Requisite Pro.
• Worked with the SME’s to define business critical needs and analyze the possible technical solutions.
• Responsible for identifying, documenting and testing the data mapping feeds from several reference data systems, to risk applications.
• Responsible for providing technical and functional expertise and direction for the Sterling (formerly known as Yantra) OMS (Order Management System) delivery.
• Partially involved in the Wire Frames, User Interfaces, AS-IS and TO-BE flows and the Use Cases to encapsulate the information with ease.
• Worked on reviewing and Analyzing 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.
• Worked with the ETL tool like Informatica for data integration and data quality services.
• Utilized corporation developed Agile SDLC methodology. Used Scrum Work Pro and Microsoft Office software to perform required job functions.
• Worked on creating Process Flow diagrams, Use Case Diagrams, Class Diagrams and Interaction Diagrams using Microsoft Visio and Rational Rose.
• Performed Data mapping, logical data modeling, created class diagrams and ER diagrams and SQL queries to filter data.
• Captured and tracked Business and Functional requirements including data flows, developed Use Cases, wireframes, Process Flows, Data Modeling and Flow Diagrams, and documented Systems Specifications using RUP methodology.
• Authored various Use Cases and Activity diagrams, Sequence diagrams using Rational Requisite Pro and used UML methodology to define the Data Flow Diagrams (DFD).
• Performed GAP analysis for the modules in production, conducted feasibility study and performed impact analysis for proposed enhancements.
• Use Cases and other Process Flow Models were designed using MS Visio and Rational Rose.
• Coordinated JAD session with system analysts, development team, project manager for application development and Pre-validation specifications.
• Coordinated various kinds of User Acceptance Testing (UAT) including regression testing, system testing, integration testing, functional testing, alpha & beta testing.
• Used Test Director which is a Mercury tool to help manage defects and issues log during the testing phase.

Confidential, Nashville, TN

Business analyst

Responsibilities:

• Participated in Scrum ceremonies including Daily scrum meetings, Sprint planning, Product Backlog Grooming Sprint review and Sprint retrospective.
• Creation of product backlog for B2C e-commerce marketplace moving from custom system to hybrids.
• Worked with B2B and B2C e-commerce applications include an Omni channel Offering, Product Information Management, Order Management, SAP Hybrids Marketing Conversion, and powerful search and merchandising.
• Introduced Agile and RUP methodologies to reflect liquid nature of front-office improving time-to-market.
• Gathered requirements using Brainstorming, Active Observation and Interviews.
• Collaborate with data modelers, ETL developers in the creating the Data Functional Design Documents.
• Manage Scope and change throughout the SDLC process of the product.
• Analyzed requirements using Gap and Impact analysis and documented business requirements in Business Requirement Documentation.
• Provided Sterling B2B Integrator team within the IBM Smarter Commerce practice team with business understanding, translated the requirements from store systems.
• Partially involved in the Wire Frames, User Interfaces, AS-IS and TO-BE flows and the Use Cases to encapsulate the information with ease.
• Extensively involved in Data Extraction, Transformation and Loading (ETL process) from Source to target systems using Informatica Power Center.
• Authored various Use Cases and Activity diagrams, Sequence diagrams using Rational Requisite Pro and used UML methodology to define the Data Flow Diagrams (DFD).
• Conducted Joint Application Development sessions to convert business requirements to technical requirements and documented them in System Requirements Specification document
• Analyzed the current system using Document Analysis and Gap Analysis and provided efficient solutions using Impact Analysis and Cost Benefit Analysis.
• Worked on daily basis with lead Data Warehouse developers to evaluate impact on current implementation, redesign of all ETL logic.
• Used Business Requirements Documents to write Business User Stories and Systems Requirements.
• Worked with other team members to write detailed Business Requirements Document. Developed Functional Requirements Specifications and System Requirement Specification from the business requirements.
• Participated in designing Use Cases, Use Case Diagrams, Use Case Scenarios, Workflow and Data Flow Diagrams. Business Process Flow Diagrams, Activity and Sequence Diagrams using Microsoft Visio.
• Involved in various brainstorming sessions to investigate, identify, analyze and solidify business rules.
• Managed User Acceptance Testing for system updates on the RTA and TPM Planning systems as needed.
• Worked with SME for the Source to Pay Project Team representing Accounts Payable group
• Worked with the QA team to develop test plan, test cases and test conditions for integration and functional testing. Traceability Matrix was used to ensure complete end-to-end testing.
• Conducted review sessions on regular basis with QA and development teams for preparing status, delivery report and client reporting.

Confidential, Richfield, MN

Business Analyst

Responsibilities:

• Involved in gathering business requirements from the end users and management.
• Involved in creating high quality functional requirement specifications and supporting documents for business systems.
• Involved in implementing Omni channel Point of Commerce (POC) and Point of Sale (POS) upgrading Order Management System (OMS) with third party vendor support. Experience in IT industry with focus on E-commerce, Retail and Supply chain domain.
• Worked as E-Commerce data analyst managing ERP, POS, Orders, Ticketing, JIRA.
• Identified and retail procedures for emerging retail chain
• Prepared Physical Inventory process for retail stores, consisted of data integration and inventory processes with third party vendor.
• Extensively designed Data mapping and filtering, consolidation, cleansing, Integration, ETL, and customization of data mart.
• Used Agile life cycle Methodology for Iterative development and Rapid delivery of the product
• Followed Agile methodology, being Business Analyst as Product Owner for better Collaboration among Scrum Master, Scrum Team and Business Stakeholders
• Prepared Business Requirement Document (BRD), Functional Requirement Specification (FRS) document, User Requirement Specification (URS) and Change Request (CR) document for system application development
• Actively involved throughout all steps of the Software Development Life Cycle (SDLC)
• Worked on Gap analysis (AS-IS) & (TO-BE) by identifying existing processes, technologies, and documenting the enhancements needed to meet the end state requirements.
• Worked with SQL queries using MS Access for data manipulations and involved in writing scripts for patient online registrations using the VB Script.
• Wrote PL/SQL statement and stored procedures in Oracle for extracting as well as writing data.
• Worked on UI/UX and created mockups and wireframes for the application.
• Involved in GUI testing and end-to-end testing of client requirements, business use cases, and JIRA validation.
• Organize requirements into high level Use Cases and low-level Use Case Specifications and modeled them into UC, Activity and Sequence Diagrams using Rational Rose and MS Visio.
• Used Clear Case for creating documents repository and sharing the documents across the team.
• Facilitate JAD sessions involving the management, development and user teams for clarifying requirements and facilitating better communication.
• Involved in assisting the development of functional requirements, static testing the applications by preparing and developing the Test Plans and Test Rules, editing and writing Test Cases, Test Scenarios and Test Scripts
• Worked closely with the project team in planning, coordinating and implemented QA methodology on various phases of the application.

Confidential, Ada, MI

Business Analyst

Responsibilities:

• Involved in JAD sessions with Business users to gathering requirements.
• Based on the requirements from product manager to created detailed Use Cases by utilizing UML (activity diagram, class diagram), and worked with team member to identify and map detailed existing processes.
• Extensive work experience with Hybris E-commerce for developing and implementing e- Commerce applications.
• Eliciting, analyzing, documenting and validating business requirements and user stories, process flows for the new ATG e-Commerce Platform spanning all aspects of browsing and purchasing hardware and services.
• Involved in the preparation of Use cases to create detailed Functional Requirement Documents (FRD). Worked with core team to design business requirement based on the project scope and SDLC Methodology. Understood and assisted with merchandising and marketing tools such as Content management, Promotion Engine and Search.
• Partially involved in the Wire Frames, User Interfaces, AS-IS and TO-BE flows and the Use Cases to encapsulate the information with ease.
• Performed Gap Analysis of the processes to identify and validate requirements.
• Assisted senior business analyst to create data mapping, logical data modeling, and used SQL queries to convert data within the Oracle database.
• Experienced create Requirement Traceability Matrix to make sure the current project requirements are met.
• Assisted in end user training and generating descriptive user manual.
• Involved in test cases and participated in UAT (User Acceptance Testing).
• Involved in assisting the development of functional requirements, static testing the applications by preparing and developing the Test Plans and Test Rules, editing and writing Test Cases, Test Scenarios and Test Scripts
• Participated in managing small to medium size team on work efforts at client site.
• Involved in developing and managed SEM activities, including optimizing on page, optimization of text ads and keywords to drive web and mobile traffic, increasing overall sales conversions.