PROFESSIONAL SUMMARY:

• Excellent communication, writing and client handling skills to preserve positive and productive client relationships with an ability to handle sensitive personnel related communication and issues with discreteness and sound judgment
• Handful experience in requirement gathering, documenting, verification, validation, analysis and design
• Strong organizational and planning skills, ability to work well under pressure, result - oriented, self-motivating and versatile in problem solving.
• Hands-on experience across a range of logistics functions including: production planning, inventory management, customer service, merchandising, forecasting, transportation and distribution with a diverse group of companies, products, and services.
• Well-developed business and supply chain understanding attained through diverse assignments in logistics, sales, and business analysis at both staff and manufacturing locations.
• Prepared detailed reports analyzing the supply chain practices and offered suggestions for improvement.
• Web Testing in Retail/E-Commerce with different browsers and Operating Systems.
• Skillfully used techniques like interviews, surveys, workshops, JAD, JRP sessions by using design modeling tools like Microsoft Visio
• Experience working on the ATG ecommerce software.
• Inclusive knowledge in Product Development Life Cycle(PDLC) involved in all stages Including Defining, Designing, Developing, Debugging, and Deployment of applications
• Supported in generating deeply integrated applications and automation system in entire system
• Educated on Vendor Delegation Module
• Involved in creating various artifacts like BRD, functional specifications, Use Cases, UML diagrams, data mapping documentation, pre and post RTM, weekly reports etc
• Capability to communicate with configuration manager, production manager and end users
• Developed thorough Use Case Diagram, Activity diagrams based on UML, methodology and business process flow diagrams, Data flow diagrams, state chart diagram using Microsoft Visio
• Considerable experience working with onshore and offshore development team
• Experience conducting User Acceptance Testing(UAT) and writing test cases for the same
• Involved in test planning, test preparation, test execution and issue resolution and report generation to assure that all aspects of the project are in compliance with the business requirements
• Worked with various departments (E-commerce, IT, Sales, Marketing, Statistics, Customer Service) that were the part of the projects teams.
• Extensive Knowledge of sample management.

TECHNICAL SKILLS:

Business Modeling Tools: MS Visio, MS Word, MS Excel, MS PowerPoint, Outlook express, MS Project

Software Dev Methodologies: Rational Unified Model, UML, Agile, Waterfall,Product life cycle management

Testing tools: Quality Center, Quick Testing Professionals, Clear Quest

Requirement Managerial Tools: Requisite Pro, Doors

Database: MS SQL Server, MS Access, Oracle

Language: SQL

PROFESSIONAL EXPERIENCE:

Confidential, Woonsocket, RI

Sr. Business Analyst

Responsibilities:

• Examined Request for Proposals from Store Operations business unit as well as Digital Innovation units for mobile App of Confidential and created Business Cases, Objectives and Statement of Work for all projects under Strategic Initiative.
• Led consulting engagement from pre-sales stage to successful delivery of the project in terms of scope, deliverables, client satisfaction and achievement of required business outcomes
• Managed Stakeholders requirements to re-write desktop static reporting to on-demand reporting; translating these requirements into User Stories for technical team to implement
• Handled full lifecycle implementation for multiple iOS/Android mobile applications complete with feedback functionality, and complex data rich visualizations
• Extensively worked on store Operations - Fulfillment reporting & dashboards
• Prepared all client-facing & internal deliverables such as - determining business objectives and benefits, creation of project plans, requirements analysis, issues/risk register, mitigation strategy, providing weekly updates, and acceptance testing of new systems within assigned business unit
• Led and facilitated Joint Application Development (JAD) sessions with relevant stakeholders from business units - project directors, project sponsors, project liaisons to elicit meaningful requirements for complex business processes
• Provided estimates and provided input to the overall general planning process for assigned business unit
• Worked with key SMEs and business unit stakeholders to identify requirements and translated them into flowcharts, swim lane diagrams in Visio and wireframes to assist in design walkthrough signoff
• Gathered requirements, built logical & physical data models, created and provided quality documentation of detailed user requirements to Development for design and development of systems
• Assisted team with making commitments through user story selection and estimates split into tasks
• Created Adhoc reports for reminder selection.
• Desktop application upgrade client created custom offline desktop application for their users to browse recommended products at their leisure which needed to be upgraded to work with new infrastructure, security and ATG E-Commerce suite
• Rapidly identified proposed Success Factors and Key Performance Indicators for the project and communicated to relevant stakeholders
• Lead the implementation of new ATG e-commerce system, including quality assurance and migration from existing platform.
• Ensured the systems meet the needs of the Business Unit through User Acceptance Testing (UAT) on all projects
• Conducted Functional Requirement Document walkthroughs with the Business Owner and took a sign-off
• Prepared detailed business flow diagrams to present business process effectively for business, developers and QA using MS Visio.
• Extensively used SQL statements to query the Oracle Database for Data Validation and Data Integrity.
• Verified the data transformations and loaded from external data sources in Teradata, Oracle and SQL Server to the data warehouse and from the data warehouse to data mart using SSIS.
• Prepared Business Requirements Specification (BRS) and Functional Requirement Specification (FRS) documents
• Prepare Requirements Traceability Matrix (RTM) to enable development team and QA team match their design and test cases respectively with requirements
• Performed User Acceptance Testing (UAT) and identified as expert in identifying defects in complex scenarios and tracking them to closure in Quality Center
• Supported ongoing changes to production mobile application as requested by stakeholders
• Used MS Access, MS Excel (Pivot tables), SQL to design and test.
• Worked with data validation, Adhoc report, report validation using excel, VBA Macro, SSRS, crystal Reports, Business Objects, Cognos and OBIEE.
• Oversee the deployment process of application code onto Development, QA, and Production environments
• Managed resources in accordance with the schedule; ensured on-time delivery of milestones with ability to multi-task, prioritize tasks and quickly adjust in a rapidly changing environment
• Utilized Soap UI and Postman for bug and issue-tracking in Project UAT.

Environment: Windows 7, iOS/Android, Microsoft Office (PowerPoint, Excel, Word), MS Visio, MS Project, IBM Blue work, Postman, ATG, Endeca Search Engine, XML and SQL.

Confidential, Columbus, OH

Business Analyst

Responsibilities:

• Provided business and technical analysis, implementation, training and support for the number three volume global online shopping company in the U.S. Analysis included both U.S. and International ecommerce sites.
• Worked in all phases of the product lifecycle management i.e. conceive, design, realize, service.
• Interacted with stakeholders to finalize the Business Requirements
• Coordinate with development teams on enterprise wide third party tools-Site Catalyst, Endeca, and Web Content Management System, sample management and merchandising.
• Collaboration proprietary Web Content Management Application (WCM), QoS (Quality of Services),Search Engine Optimization (SEO), SLDC enhancement and third party tool integration projects for: Endeca, Google Commerce Service and Webmaster Tools
• Led selection and implementation of new e-commerce issue tracking system which improved efficiency of the work flow process under product life cycle management.
• Perform Web analytics (Adobe Site Catalyst) requirements, analysis, implementation, testing and on-going support of web quality analytic tools to improve site quality, availability and search ranking.
• Followed a structured approach to organize requirements into logical groupings of essential business process, business rules, information needs and ensured that critical requirements are not missed and provided e-commerce based solutions to their complex business problems.
• Closely interacted with designers and software developers to understand application functionality and navigational flow and keep them updated about Business user’s sentiments.
• Standardize documents for agile project implementations.
• Custom tools upgrade client had created marketing, merchandising, promotion and product tools to support their custom web application which needed to be re-architected to work with ATGs ecommerce suite
• Produced pivot tables to create reports that performed dicing and slicing functions on data.
• Worked with Large DB2 and Oracle, SQL Server databases doing loading, validation and manipulation of data
• Created Test Plan and Test cases from the Business Requirements
• Worked with the Business Objects developers to provide input for generating automated and adhoc Business Objects reports.
• Owned the weekly Burn down charts, agile wall updates, Tracking Planck cards (a communication protocol between the onsite-offshore agile team members).
• Conducted tests against an internal ATG developed java web application.
• Liaise across teams- development, project management, business managers and vendors to identify and resolve issues to deliver projects on time in a Microsoft .net/SQL environment.

Environment: Windows 7, Microsoft Office (PowerPoint, Excel, Word), MS Visio, MS Project, JIRA Postman, ATG, XML and SQL.

Confidential, Framingham, MA

Business Analyst

Responsibilities:

• Managed the project using the Agile Method of project development.
• Implemented Scrum development methodology
• Helped end users in creating User stories
• Served as a liaison to the subject matter experts and developers (Java, EJB environment)
• Created interactive simulation for end users using real time data.
• Closely interacted with designers and software developers to understand application functionality and navigational flow and keep them updated about Business user’s sentiments.
• Interacted with group to facilitate for timely and effective requirement translation.
• Developed Use Case stories, business flow diagrams, Activity/State diagrams and Sequence diagrams so that developers and other stakeholders can understand the business process.
• Wrote full functional and technical specifications and communicated requirements to development teams.
• Created and maintained a project schedule using MS Project showing all of the deliverables target dates.
• Involved in Design and development of Workflows rules, triggers, validation rules and other customizations with Salesforce CRM
• Expertise in developing Business Intelligence and Data Warehouse applications. Creating Universes for Adhoc reporting and also for Dashboards. Creating Full Clients and Web Intelligence Reports.
• Worked with Source system Subject Matter Experts (SMEs) to ensure that the extracts are properly mapped. Used SQL for data mapping and querying.
• Created various Reports and Report folders to assist managers to better utilize Salesforce as a sales tool and configured various Reports for different user profiles based on the needs of the organization.
• Used Pivot tables, formulas and relational tools to show the relation between the tables in Excel for the upload purposes.
• Developed detailed BRDs and DFDs using various modeling tools and developed databases based on the system model following the techniques in product life cycle management.
• Created and maintained complete development plans that included functional specifications, requirements engineering, Use Case modeling, risk assessment and mitigation, internal and external workflow.
• Used MS power point presentations for conduction JAD sessions with the stakeholders.
• Worked with relational databases, and developed PL/SQL queries to interact with Databases.
• Conducted walkthroughs with the end users and stakeholders to gather the modification requests from the user to upgrade or change the business specifications for the product.

Environment: Windows 7, Microsoft Office (PowerPoint, Excel, Word), MS Visio, MS Project, Pos, Soap UI, Salesforce, XML and SQL.

Confidential, New York, NY

Business Analyst

Responsibilities:

• Managed all aspects of quality assurance for warehouse management system upgrades. Responsibilities included: planning, analysis, testing and deployment of system upgrades.
• Flow Diagrams using MS Visio and MS Excel Performed the requirement analysis and documented the requirements.
• Organized weekly Project Status and Task Review meetings
• Created PowerPoint presentations and project updates using MS Project for management review
• Performed SWOT and GAP analysis for new functionality requirements as well as prioritized them based on actual business needs
• Created Test Plan and Test Strategy for different releases
• Performed risk analysis of the requirements to identify the key business risks areas for the project and prioritized the application development and testing.
• Performed GUI, functionality, integration, regression and acceptance testing for client server, web and host based applications.
• Extracted data from Teradata and Oracle and created pivot tables in Excel
• Created data structures by using SQL in Teradata & TOAD.
• Worked closely with compliance team to provide customer risk rating and adhoc reports.
• Developed SQLs for Extracting data from database and built data structures, reports
• Designed and developed various Ad hoc, Daily, Weekly, Monthly and year-end reports for the Business Analyst using SQL, Ms Excel, Ms Access and Teradata
• Created and maintained a project schedule using MS Project showing all of the deliverables target dates.
• Led the analysis, planning and launch of CMMI (Capability Maturity Model) process improvement of IT team.

Enviro nment: MS Project, MS Excel, MS Word, Share Point, Quality center, TOAD, HTML, PL/SQL, Oracle, Windows NT, Unix (Sun Solaris), Load Runner.

Confidential, Brighton, MA

Business Analyst

Responsibilities:

• Derived Functional Requirement Specifications (FRS) based on User Requirement Specification URS.
• Understood and articulated business requirements from user interviews and then converted requirements into technical specifications.
• Authored functional specification document to integrate the look and feel with current interfaces, minimizing the number of places/screens customers have to go.
• Involved in walkthroughs and meetings with development team to discuss related issues.
• Worked closely with the database architect to finalize database design, table structures and other key database artifacts for the system
• Created data dictionary for often used business and technical terminology for benefit of developers and customers respectively.
• Influenced and communicated with business partners on the vision of Confidential 's Retail systems at a strategic and tactical level in merchandising.
• Performed gap analysis to compare the existing system with the proposed system and documented new requirements and features.
• Worked with various departments (E-commerce, IT, Sales, Marketing, Statistics, Customer Service) that were the part of the project team.
• Involved in the budget analysis, proposals and financial reporting processes.
• Conducted technical/non-technical presentations to the management and training workshops for the clients.
• Facilitated changes to the web site and other marketing programs through analysis, decision process facilitation, report preparation, developed cost-benefit analysis and tracked defects.
• Worked on Unix Platform and experienced in back end testing by executing SQL Queries.
• Checked the data flow through the front end to backend and using SQL Queries to extract the data from the database.

Environment: UML, RUP, MS Visio, Adobe Reader, Rec Pro, SQL-Teradata, Rational Requisite Pro, Adobe Photoshop, Macromedia Dream Weaver

Confidential, Dallas, TX

Business Analyst

Responsibilities:

• Involved in planning JAD sessions and resulting business processes.
• Developing positive and professional relationships with internal and external users.
• Responsible of gathering, analyzing requirements for complex applications of Confidential ’s Extended Viewing Fees and Reverse Phone Append.
• Maintain updated documentation on business processes, applications and business solutions.
• Write proposals and simple business cases in support of business community.
• Involved in the Design phase for the Customer Payment Solutions (CPS), Reverse Phone Append (RPA) and Extended Viewing Fees (EVF) applications.
• Worked exclusively on e-commerce applications of Confidential ’s Online Subscription, Purchase Order System, Warehouse, and Order Fulfillment.
• Assist in managing the work plans in MS Project, linking various project teams participating in the Release along with business organizations.
• Participated extensively in providing training to the project teams about Program tools utilizing PMO project tools as appropriate.
• Assisted Manager in scheduling for the planning, providing estimates across various SDLC phases of projects and proficient in using Excel.
• Accepted the challenging role to provide project management responsibilities during the Integration Test of the Point of Sale system with the Host systems team.
• Participated in creating Use Cases from Business requirements, analyze ad-hoc reports
• Facilitated the Defect tracking process for testing the e-commerce applications of Purchase Orders and Online DVD’s Returns and Exchange functionalities and then closing the defects in Quality center.
• Exclusively participated in the Peer reviews and supported escalation during various Releases.
• Support Stage gate and SOX methodology compliance deliverables adhering to the program standards.
• Primarily supported project leads participating in the release by tracking weekly progress thru Traceability matrix

Environment: Windows XP/7/, MS Word, MS Excel, MS outlook, MS PowerPoint, MS Project 2010, MS Visio, Rational Rose, SQL Server, MySQL, Load Runner, Quality Center