SUMMARY

• Over 8 years of Business Analyst experience with solid understanding of business process analysis especially in Retail, E - commerce, and Supply Chain with experience in B2B, B2C and Ecommerce portals integration.
• Expert in business processes and software development life cycle methodologies i.e. Waterfall, RUP, Agile, Scrum, and Prototype, including analysis, design, development, gap analysis testing and implementation of software applications.
• Extensive experience in full life Cycle implementations of Distribution & Supply chain Modules in a complex Multi Org.
• Excellent expertise in enhancing co-ordination between different teams and promote the Functional Flow of the Business Process.
• 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 interviewing SMEs and Stakeholders to get a better understanding of client business processes and gather business requirements.
• Proficient in Technical and Business Writing, Business Process Flow, Business Analysis and testing various methodologies.
• In-depth knowledge of creating use cases, functional design specifications, activity diagrams, logical, component and deployment views to extract business process flow.
• Highly experienced in conducting JAD sessions, created Use Cases, work flows, screen shots and Power Point presentations for the Web Applications.
• Good experience at Demandware, ATG Dynamo B2B Commerce, ATG B2C Commerce, Shopping Cart, Product Catalog, Merchandizing, Catalog, Droplets.
• Experience in Oracle Retail Modules like Retail Merchandising System (RMS), Oracle Retail Invoice Matching (REIM), and Retail Price Management (RPM) and also has very good experience in Order Management Application.
• Working experience across Omni channel, Customer Order fulfillment, Product management, Inventory management, Forecasting and Replenishment.
• Experience with both functional and technical aspects of project design and implementation in Warehouse Management System.
• 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.
• Good experience at B2B, B2C and Ecommerce portals web application developments and CRM.
• Expertise with Supply Chain Management (SCM), 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 need.
• Good working experience at Master Data Management (MDM), Identity data, Trade Promotions Management (TPM) and Point of Sales (POS).
• Utilized disciplined development methodology for continuous evolution and optimization for the WMS solution.
• Highly experienced in Working on Email, Search Engine Marketing, Display Advertising, Webcasting, Social Media and other campaigns with extensive knowledge on CPC, CPM and CPA.
• 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.
• 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.
• Hands on experience in creating SQL Queries, Stored Procedures, Triggers, Views, Indexes in SQL Server with a strong understanding of data & analytics.
• Expertise in designing and developing Test Plans and Test Scripts.
• Coordinating with the UAT and Project management teams and performed User Acceptance Testing with the Users
• Evaluation of the Test cases, scripts, environment designed by the QA Department to ensure precision of the Business, Functional and Usability Requirements.
• Experience in Functionality Testing, User Acceptance Testing, Database Testing, Regression testing and Risk Based Testing.
• Excellent communication skills, Interpersonal skills, interacting with team members, leadership qualities, mentoring, ability to work independently.

PROFESSIONAL EXPERIENCE

Confidential - Quincy, IL

Sr. Business Analyst

Responsibilities:

• Interacted with client and the Technical Team for requirement gathering and translation of Business Requirement to Technical specifications.
• Responsible for business analysis, requirement specifications and identifying the resources and implementation of the project.
• Gathered high level requirements and developed scope of the project for the implementation of NetSuite’s CRM.
• Developed a consolidated and prioritized high level requirements matrix for both B2C and B2B that detailed current and future state needs.
• Investigated and resolved issues within Supply Chain module as well as WMS (Warehouse Management System) software.
• Applied Supply chain Management (SCM) methodologies to ensure coordination in the supply chain.
• Aligned withWMSteam and development team based on requirements and mapping.
• Interacted with stakeholders and gathered requirements as per the business needs.
• Involved in preparing project plans and identifying major milestones for each stage as per the SDLC model (Agile Methodology).
• Created a task plan for the team identifying the key deliverables and the respective deadlines.
• Gathered analyzed and documented business and technical requirements from both formal and informal sessions and validate the needs of the business stakeholders.
• Gathered requirements for the integration of POS system with the supply chain system.
• Assisted with the BRD for the POS implementation project.
• Analyzed and translated business requirements into system specifications utilizing UML and RUP methodology.
• Conducted gap analysis and made As-is-to-be diagrams to understand new business requirements and challenges in implementing new modules.
• Conducted interviews, meetings and JAD sessions during the process of Requirement Gathering.
• Reviewed the Joint Requirement Documents (JRD) with the cross functional team to analyze the High Level Requirements.
• Planned and documented procedures for data processing and prepared data flow diagrams for the application.
• Documented the Traceability Matrix for tracing the Test Cases and requirements related to them.
• Conducted weekly meetings for deciding the Policies and Procedures to be followed while constructing new sites.
• Performed the requirement analysis, impact analysis and documented the requirements using Rational Requisite Pro.
• Designed and developed Activity Diagrams, and Sequence Diagrams utilizing MS Visio.
• Documented the server farm requirements and requirements related to security within Share Point.
• Followed a systematic approach to eliciting, organizing, and documenting requirements of the system.
• Created Physical Inventory process for retail stores, consisted of data integration and inventory processes with third party vendor.
• Rewrite, Add and Define, Rewrite existing requirements, breakout into new requirements, and create additional documentation where appropriate.
• Designed workflows and allocated permissions within SharePoint.
• Maintained key records for purposes of Compliance review and/or regulatory inquiry.
• Performed Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data Involved and reviewed TSQL/SQL queries and stored procedures to process, analyze and implement data integrity initiatives for various business units.
• Performed complex SQL queries for retrieving data from the database, generating ad-hoc reports, and conducting data validation testing.
• Designed merchandising and marketing databases; developed stored procedures and reports to automate reoccurring tasks using SQL Server.
• Performed Unit Testing and User Acceptance testing and documented detailed results.
• Provided input (scope, goals, risks, constraints, timelines and interfaces) to PM for project planning and control.
• Assisted QA team in developing test strategy, and test cases and actively monitored various types of testing - functional testing
• Progression testing, system testing, load testing, smoke testing, and regression testing.
• Managed Requirement Traceability Matrix to ensure test cases are traceable to requirement specifications.
• Actively facilitated complete UAT process - creating UAT schedules, testing guidelines, managing feedback, follow-up, and resolving open issues.
• Facilitating workshops, JAR/JAD sessions, during the inception of the new web-based application for the Portfolio Information.
• 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.
• Analyzed the test results from QA teams using Performance Studio Analysis to create various scenarios.

Confidential - Mahwah, NJ

Sr. Business Analyst

Responsibilities:

• Gathered requirements by conducting meetings and brainstorming sessions with end users and SME and document them using Requisite Pro - the documentation tool offered by Rational.
• Involved in Inception Phase and prepared vision statement and initial data models that contain Business Requirement Documents and supporting documents that contain the essential business elements and detailed definitions.
• Identified and retail procedures for emerging retail chain.
• Created Physical Inventory process for retail stores, consisted of data integration and inventory processes with third party vendor.
• Worked on the up gradation of e-commerce web site engine by managing resources and responsible for installing new software version to increase site uptime by 3%.
• Agile Assigned tasks among development team, working with clients to better understand their needs and present solutions using structured SDLC approach.
• Gathered user and business requirements through open-ended discussions, brainstorming sessions and role-playing.
• Documented the user requirements Analyzed and prioritized them and converted them as system requirements that must be included while developing the software.
• Experienced in Designing, developing, implementing and roll-out of Micro strategy Business Intelligence applications
• Suggested web security using encryption and authentication technologies for reporting and complaint filing procedures.
• Planned and defined Use Cases created Use Case diagrams, Scenarios and Use Case Narratives using the UML methodologies.
• Created Mock-up forms in MS word for better visualization and understanding of the software solution.
• Facilitated JAD sessions with management, development team, users and other stakeholders to refine functional requirements.
• Used MS Visio for Process modeling, Process mapping and Business Process flow diagrams.
• Worked with multiple project teams of technical professionals through all phases of the SDLC using technologies including Erwin, Data Stage, Data Warehousing, Web sphere and Cognos.
• Performed extensive data modeling to differentiate between the OLTP and Data Warehouse data models.
• Expertise in development of High-level design, Conceptual design, Logical and Physical design for Database, Data warehousing and many Distributed IT systems.
• Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data within the database.
• Created and managed project templates, use case templates, requirement types and tractability matrix in Requisite Pro.
• Agile Assigned tasks among development team Managed workload, schedules and coordinated status review meetings with project managers, business managers and team members.
• Develop and maintain sales reporting using in MS Excel queries, SQL in Teradata, and MS Access.
• Produce performance reports and implement changes for improved reporting. Interface with internal customers.
• Provide ad-hoc reporting and analysis from data sources including PeopleSoft (SET) and Teradata.
• Authored progress and completion reports which were then submitted to project management on a weekly basis in MS project.
• Identified various frequently used modules within the application as well as the peak user volume for load testing purposes.

Confidential - Franklin, TN

Business Analyst

Responsibilities:

• Gathered requirements for both B2B and B2C parts of the project.
• Performed Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data.
• Worked as a team to employ Scrum Methodology within an agile development environment to improve software development processes and elevate product quality while meeting defined goals and key deadlines.
• Provided weekly, monthly & ad hoc web analytics reports using Adobe Site Catalyst & Google Analytics.
• Helped team removing impediments by proper communication within Scrum team and timely mitigating project risks.
• Helped to establish Omni-channel measurement at the customer level for new CRM tool and mobile marketing beacons to connect in store behavior’s to online users.
• Used the Agile (Scrum) methodology to carry out every step of the business modeling process.
• 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.
• Responsible for gathering requirements from users in operations group and performing data mapping for the application, confirm and vacillating the requirement at time of BA testing.
• Obtained Data requirements, identified data sources, determined the content of data fields, and created Data mapping documents and performed Data Extraction and Data Compilation using SQL queries.
• Provided recommendation for use of ATG Commerce for B2B and B2C business.
• Involved in creating Process Flow diagrams, Use Case Diagrams, Class Diagrams, and Interaction Diagrams using Microsoft Visio and Rational Rose.
• Worked with Data Warehouse in the development and execution of data conversion, data cleaning and standardization strategies and plans as several small tables are combined into one single data repository system MDM (Master Data Management).
• Worked with User Interface UI / UX team to create report mock up's from wire frames to ensure that functionalities are captured and presented on the front end as per the BRD's.
• Analyzed company specific data - Production amounts, forecasting and demand planning, inventory stocking at wholesaler & distributor, inventory turns per SKU, retail outlet coverage region-wise, merchandising & tax costs.
• Determine and create the best UI/UX design concepts for the product.
• Maintained project plans, task, defect, and issues lists, team meetings to discuss all aspects of the project’s execution, developed test scripts, executed UAT, participated in the QA process, and developed training materials and system documentation.
• Utilized JIRA to communicate constantly changing functional and design requirements with business users and developers.
• Reviewed Stored Procedures for reports and wrote test queries against the source system (SQL Server) to match the results with the actual report against the Data mart (Oracle).
• Facilitating workshops, JAR/JAD sessions, during the inception of the new web-based application for the Portfolio Information.
• 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.
• Analyzed the test results from QA teams using Performance Studio Analysis to create various scenarios.

Confidential - Chicago, IL

Business Analyst

Responsibilities:

• Acted as a liaison between business users and technical department managing a team of subject matter experts for E-Commerce user acceptance testing efforts.
• Worked as a BA in web-based E-commerce site development project.
• Developed documentation for POS Systems including Corporate Policies.
• Participated in design and build of different OMS modules - Order Capture, Order Processing, Order Promising & Fulfillment, Payment Processing, and etc.
• Acted as a main point of contact between the client and technical teams to deliver high quality, crisp requirements for the implementation of a complete end-to-end E-commerce application utilizing ATG (Oracle Web Commerce).
• Was involved in the creation of new E-Commerce Products (Arrival Notices and Customized Reporting).
• Responsible for requirements gathering, analysis, detailed process flow design, user acceptance testing and rollout of new & modified feature functionality deployed on the E-commerce website applications.
• Responsible for analyzing the business process, creating requirements documents, maintaining vision documents, supplementary specification documents, and developed use cases.
• Involved in Designing business requirement & systematic approach based on project scope and SDLC.
• Created different Experienced in User experience (UX) definition and User Interface (UI) design for project as well as prototypes and wire frames.
• Conducted User Interviews and Work Shops to gather accurate Business Requirements.
• 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 Demandware and their legacy system.
• Gathered requirements from business owners perform system analysis & created business and functional requirement documents /user stories in Rally for the Change Request/Enhancements.
• Involved in designing and developing Data Models and Data Marts that support the Business Intelligence Data Warehouse.
• Participated in Daily Agile Scrum "Stand-up", Biweekly Sprint Planning and Retrospective Sessions and update the team on status of upcoming User Stories.
• Conducted JAD sessions with management, SME, vendors, users and other stakeholders for open and pending issues.
• Performed Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data.
• Created technical design documentation for the data models, data flow control process, metadata management.
• Utilized JIRA to communicate constantly changing functional and design requirements with business users and developers.
• Also involved in E-Commerce POS testing Product Search, Payment System, Online transaction processing.
• Assisted QA team in executing Test plans and wrote Test Cases
• Collaborated with quality assurance/quality control to ensure that the final product met all the requirements.
• Cooperated with various teams during the user acceptance testing (UAT) of the final product.

Confidential - New York, NY

Business Analyst

Responsibilities:

• Worked on converting and documenting 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.
• Involved in all phases of the SDLC, Agile, perform UAT testing. Understand, translate, communicate business requirements into detailed technical system specifications, and develop use cases.
• Obtained business requirements from business users and stakeholders using JAD sessions, brainstorming sessions, focus groups and personal interviews on AGILE/ SCRUM methodology.
• Drafted User Stories and Use Cases and Identified User Story points with the Developers and assigned user stories to Sprints in Agile Methodology.
• Involved in mentoring specific projects in application of the new SDLC based on the Agile Unified Process, especially from the project management, requirements and architecture perspectives.
• Worked on various tools and techniques including market research, industry analysis, shipping cost analysis, sales and marketing initiatives, refer-a-friend, loyalty programs to increase and improve visitor traffic, site sales and functionality, etc.
• Determined, diagnosed and proposed solutions to problems with the system's functions through data analysis.
• Attended interviews and JAD sessions with stakeholders and other key decision makers in order to identify requirements and business-related information.
• Worked with developers to simplify checkout process, such as reducing time and procedures for returning customers to complete prior saved shopping carts.
• Designed merchandising and marketing databases; developed stored procedures and reports to automate reoccurring tasks using SQL Server.
• Assisted Test Lead, Testers understanding business process and helped them for successful completion of Unit Testing, Integration Testing and Requirements Testing.
• Involved in test cases and participated in UAT (User Acceptance Testing).