OBJECTIVE:

An excellent Business Analyst / System Analyst with 7+ years of experience. Result - Oriented Business Consultant with experience spanning across IT, Ecommerce, Supply Chain Management and Retail. Analytical and detailed Business Analyst, with strong ability to gather Business Requirements creates Project Requirement artifacts, excellent knowledge of SDLC, Business Process and Reengineering, Agile, Waterfall and QA Testing.

SUMMARY:

• Involved in workflow, process flow and GAP Analysis to derive requirements for existing systems enhancements and reported on business processes.
• Involved in creating various artifacts like BRD, functional specifications, Use Cases, UML diagrams, data mapping documentation, pre and post RTM, weekly reports etc.
• Built strong rapport with team members, stakeholders and also delegated effectively and motivated team members towards achieving on-time project completion.
• Interfaced with both technical and business teams to ensure initiatives are administered and implemented according to business intent.
• In-depth understanding of eCommerce domain with specializations in digital marketing, content management, etc.
• Good understanding on Inventory, Point of Sales (POS), Order Management System (OMS) and Bill of Materials (BOM).
• Experience in Warehouse Management System (WMS) including Requirement Gathering, Functional Analysis, Design, Testing (Unit and Integration) and Implementation.
• Experience in working on the different phases of web development life-cycle along with good experience in creating web applications for Android, and iOS.
• Helped to create and maintain the Sprint Backlog, Sprint burn-down chart and task board.
• Planned and defined system requirements to Wire Frames with Use Case, Use Case Scenario and Use Case Narrative using UML and RUP.
• Profound knowledge of Data Warehousing concepts, data modeling and database design. Experience creating and maintaining the data model and physical integrity of the database.
• Authored & implemented UAT plans, Test cases & monitored the user acceptance testing.
• Liaised and gathered business requirement for migration efforts to migrate data from source data to target data.
• Liaised with Business SMEs, executives, facilitated JAD sessions, one-on-one interviews and group sessions to elicit, gather and document business requirements, business process.
• Liaised between technology, offshore stakeholders, external vendors and prepared RFP, RFI proof-of-concept requirements.
• Authored and gathered requirements for business cases, use case scenarios, test scripts and cases, mock ups, functional decomposition of requirements.
• Experienced with Relational Database Management Systems (RDBMS) in SQL Server.

TECHNICAL SUMMARY:

Methodologies & Tools: Business Objects, Rational Unified Process (RUP), Rational RequisitePro, UML, Use Cases, SDLC, MS Project, MS Visio, Rational Suite, HP ALM Quality Center, MS Word, MS Excel, MS PowerPoint, MS Access, Agile.

Industry Knowledge: Detailed understanding of various securities - Equity, Fixed Income, Derivatives, Securities Trade Processing, Payments and Transaction Processing, Insurance

Project Management Tool: Primavera, MS Project

Testing Tools: Perfecto, Quality Center, HP ALM

Bug Tracking/Reporting Tools: Test Director, Rational Clear Quest, JIRA, SharePoint, cucumber

Database: Oracle, MS SQL Server, MS Access, Informatica, SAP

Operation system/platform: MS Windows 2003/XP/2000/NT, UNIX,SQL, MAC

PROJECT EXPERIENCE:

Confidential, Brentwood, TN

Technical Business Analyst

Responsibilities:

• Assisted in the product planning and development cycles: from gathering requirements to writing specifications and shaping the software development process.
• Prepared the business requirement document (BRD) and system requirement document (SRD).
• Requirements were gathered through interactions and meetings, and periodic walkthroughs with the different stakeholders
• Conducted Business Process Reengineering to build a new version of the existing system.
• Conducted Use-Case reviews and identified gaps, leading to improvements/enhancements in the same
• Worked in fast paced agile environment.
• Follow agile methodology for gathering requirements, development and testing for the mobile platform.
• Created disaster recovery and business continuity document for WebSphere Commerce Suite (WCS) and IBM Sterling OMS.
• Composed use cases for WMS integration with OMS in functions like, PO creation, shipment creating, pick-pack-ship, inventory reservation, cancelation, returns, and exchanges.
• Designed and built order management system and online shopping capabilities.
• Trained the Operations Team on Steps to complete the Force off SKU and the Stage Prop Processes.
• Provided assistance for the business users and QA on how to: apply manual product sequencing on the browse / guided navigation pages, setup a web activity that will display an e-Marketing spot on the website, setup a web activity that will display an e-Marketing spot on the Search Results page when specific words are used in a keyword search using business tools such as the IBM Management Center (CMC).
• Facilitated Joint Application Development (JAD) Sessions for communicating and managing expectations
• Worked on EDI 850 and EDI 204, the B2B exchange of data.
• Ability to read and interpret EDI 850 and EDI 204 transaction set.
• Validated the scripts to make sure they have been executed correctly and meets the scenario description.
• Managed and tracked Defects using QC.
• Proposed SharePoint-based solutions to improve existing business challenges
• Implemented company's business standards in SharePoint.
• Involved in data dictionary management, extraction, transformation and loading (ETL) of data from various sources. Participated in ETL requirements process during data transition from source systems to target systems.
• Performed Data Analysis and converted the full logic to plain SQL codes and put it in data selection strategy document.
• Utilized SQL in every step of creating data warehouse including data warehouse design, data warehouse database, and loading data into data warehouse.
• Developed the business anomalies workarounds and described them in documentation and presented the matter to the upper management for review using SharePoint.
• Maintained meeting minutes, meeting agenda and communicated them with the SMEs and the stakeholders on timely manner using MS Word, MS PowerPoint and created reports using MS Excel.
• Worked directly with software engineers to ensure clear communications on requirements and defect reports.
• Designed and developed scenarios based on business requirements.
• Interacting with other teams through walkthroughs, teleconferences, meetings, etc. to resolve various issues.
• Performed Data Profiling of current state of data in the Data Warehouse by doing Data Analysis using advanced SQL Queries and Microsoft Excel, finding Gaps in Data and formulating solutions for the same.

Confidential, Charlotte, NC

Business System Analyst

Responsibilities:

• Identified and implemented processes for developing and documenting detailed business requirements. Data was collected from end-users and analysts.
• Coordinated with different business groups of client to provide the ultimate solution to maintain effective supply chain flow.
• Worked with Business to suggest different configuration in DOM (Manhattan Distributed Order Management) with POS / WMS (Manhattan Warehouse Management System) for handling orders better and increase sale and better customer experience.
• Elicited business requirements through interviews, document analysis, design workshops, surveys, use cases, and workflow analysis.
• Interacted with the users and used various elicitation techniques like interviewing them, and also by preparing questionnaires and getting their feedback.
• Acted as a liaison between end users, developers, architect and the QA team.
• Worked with Large DB2 and Oracle, SQL Server databases doing loading, validation and manipulation of data.
• Improved efficiency of corporate finance and supply chain systems by 15 percent through detailed analysis and proposed solutions.
• Structured an interface requirement between Ecommerce, Order management system and a Warehouse management system (WMS).
• Assembled business requirement documents (BRD) and the functional specifications as per the user requirements.
• Conducted weekly meetings to provide Supply chain activities and status for problem resolution for enhancing the E-commerce applications.
• Implementation and maintenance of Confidential ’s Retail software and multi systems integration to POS and data warehouse. Includes IT planning, project management, business models, business rules, and supply chain integration.
• Analyzed POS requirements, Designed Test plans, Test scenarios and Test Case.
• Collected and managed requirement to develop efficient POS.
• Provided primary business support to Category Management (CM) and the Global Sourcing Center (GSC) with respect to Purchasing and Supply Market Intelligence, responsible for leading the development reporting templates, tools and processes.
• Prepared documents for all ecommerce business procedure and analyzed all site traffic to recommend efficient marketing plans and administer all email programs and search marketing activities.
• Coordinated Daily scrum stand-up meetings, sprint planning, sprint review and sprint retrospectives.
• Formed advanced SQL Queries and used Microsoft Excel to investigate data issues in the Data Warehouse and worked with the Users and Technology Team to formulate a solution to resolve the issue.
• Created project plans, detailing projects Scope, process flow, timelines, and requirement documents and analyze risks.
• Created well-defined business vision documents, business glossaries and requirements management plan as per the Agile Methodology.
• Conducted JAD sessions to develop architectural solutions to open and conflicting issues.
• Analyzed “AS IS” and “TO BE” scenarios, designed new process flows and documented the business process and various business scenarios.
• Wrote use cases and relevant UML diagrams such as Use Cases, Activity and Sequence diagrams.
• Analyzed user requirements, conducted change request meetings as a part of the Change Management process to document changes and manage them.
• Extensively used SQL statements to test the DB2 database.
• Performed Data Analysis, Data profiling and Data validation by writing SQL queries using TOAD.
• Involved during UAT test plan and conducted User Acceptance Testing at the end of the testing process and write the signoff document for the future .
• Extensively worked on the SharePoint application especially on the Intranet Portal, Extranet site and managing the enterprise content and document Management.
• Worked on the Data warehouse for the requirement gathering and updated to the SharePoint.
• Developed user stories, facilitated story pointing, managed the project backlog, prioritized product backlog off user stories for sprint planning schedule and helped to clear impediments.
• Performed Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data.
• Performed SQL queries for retrieving, organizing the database with general commands like select, create, update, and joins.
• Microsoft Office (Outlook, Word, Excel, Visio, Access) at various phases of development for documenting the requirements.
• Conducted Data analysis using SQL on the backend databases for producing mapping documentation and transformation rules for developers

Confidential, Landover, MD

Business System Analyst

Responsibilities:

• Gathered requirements from both technical and functional teams for BRD.
• Participating in onshore / offshore hand-off calls.
• Analyzed sales and supply chain data and participated in a cross-functional team documenting AS IS, identifying brainstorming solutions and preparing recommendations.
• Involved and managed change management program to monitor impact of SCOR (Supply Chain operations) Prepare Detail questionnaire and template for functional requirement gathering for SCOR implementation.
• Involved in validating POS sales transactions from source to target.
• Elicited requirements from key stakeholders as regards the goal and timelines of the project.
• Establish documentation for Agile methodology for implementation with a very water-fall-centric development team
• Tasked to design, document and develop business process to automate and standardize Work Order Management process.
• Engaged in project scope, process design and planning to provide input on functional requirements, project designs schedules or potential problems and reported such risk to appropriate stakeholders. Review software documentation to ensure technical accuracy, compliance, completeness and to mitigate risks.
• Performed SME roles during requirements workshops and JAD sessions.
• Prepared UML diagram including Use case diagrams, activity diagrams, and sequence diagrams using Microsoft Visio.
• Facilitated requirement workshops and developed documentations for SDLC.
• Facilitated product backlog grooming sessions and scrum rituals activities.
• Gathered Business Requirement, created Process Flow, Use Case, Context diagram, relationship diagram, performed GAP Analysis of ‘As-Is’ & ‘To-Be’ process.
• Using Microsoft Visio, developed swim-lanes to provide graphical and visual enumeration of processes and milestones in SDLC.
• Reported status and issues to the Director Ecommerce and tracking them till they are resolved and closed.
• Logged and reported defects daily to the project team.
• Reviewed the defects at the daily defect meeting during the extension of SIT and UAT cycles.
• Product creation and supply chain groups worked together to address critical dependencies between processes like demand, supply, tooling and warehousing.
• Performed data manipulation of data components and wrote SQL queries.
• Used data analysis techniques to validate business rules and identify low quality missing data in the existing enterprise data warehouse (EDW).
• Developed a quick and thorough understanding of MS SharePoint. Performed quality assurance testing on developed SharePoint sites and web parts.
• Assisted with the facilitation and development s on using MS SharePoint.
• Closely worked with ETL team to understand Data extraction and Data conversion from application front-end with SQL databases and data warehouse.
• Used Microsoft Word, Excel, Access and Visio as working tools.
• Performed Backend Testing using SQL Queries to validate the data in Oracle Database.
• Analyzed business impact and value of user stories and created story cards and points product and sprint backlog prioritization and also engaged the development team in working towards successful and timely product release.
• Authored & implemented UAT plans, Test cases & monitored the user acceptance Testing (UAT) of the system with end users also created GUI (graphical user interface) for the end users during UAT.

Confidential, Columbus, OH

Business System Analyst

Responsibilities:

• Performed Requirements Gathering and Analysis, interviewed the SME (Subject Matter Experts), and ensured that contributors and all key stakeholders were motivated to complete assigned tasks.
• Performed GAP Analysis to identify the deficiencies of the current system and to identify the requirements for the proposed system.
• Incorporated Agile to create Business Requirement Document Specifications using MS Visio and MSWord.
• Facilitated JAD sessions and design meetings with the Stakeholders, SME's and Leads of Interfaces.
• Facilitated collection and prioritization of functional requirements from system users. Documented the Business Requirement Documents (BRDs), Functional Requirement Documents (FRDs) using Rational Requisite Pro.
• Manage the Requirements (Business as well as System requirements), performed requirements analysis along with the creation of Use Case Scenarios.
• Provided business and technical analysis, implementation, and support for the number three volume global online shopping company in the U.S. Analysis included both U.S. and International ecommerce sites.
• Owned the weekly Burn down charts, agile wall updates, Tracking Planck cards (a communication protocol between the onsite-offshore agile team members).
• Led selection and implementation of new e-commerce issue tracking system which improved efficiency of the work flow process under product life cycle management.
• Worked in all phases of the product lifecycle management i.e. conceive, design, realize, service.
• Interacted with stakeholders to finalize the Business Requirements
• Coordinated with development teams on enterprise wide third party tools -Site Catalyst, Endeca, and Web Content Management System, sample management and merchandising.
• Involved in writing extensive SQL Queries for back end testing oracle database. Retrieved files using SQL statements and UNIX commands.
• Worked as an IT liaison among business units to define logical and innovative solutions that support changing business processes while maintaining technological integrity and adhering to industry best practices.
• Fostered and maintained good working relationships with IT and business partners to ensure systems and processes are able to support expected service levels.
• Used Data warehousing for Data Profiling to examine the data available (Data Analysis) in an existing database
• Developed tables, Views, Stored Procedures and Triggers using SQL Scripting.
• Established Inner Join, Outer Joins and created primary key indexes (paired with foreign keys) for dimension tables whenever necessary.
• Worked on Data mapping, logical data modeling used SQL queries to filter data within the Oracle database tables.
• Documented the dimensional models of ETL system.
• Involved in design of the data warehouse using Erwin, created Informatica source and target definitions and mappings.
• 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.
• Developed business process diagrams and other related models to capture business requirements, modeling both current and future state.
• Developed business cases including Use Cases that included baseline and target metrics to support the strategic objectives of the business units.
• Communicated and translated business requirements into functional requirements and then developed the functional design document.
• Worked closely with developers and end-users throughout the development lifecycle to ensure technical and business process integrity of future state systems.
• Analyzing User and Functional requirements to point out gaps between used SQL queries to extract the data from the database.
• Participated in quality assurance planning and execution to ensure documented business requirements are achieved.
• Insured all requirements were tested via the creation of a Requirements Traceability Matrix (RTM).
• Facilitated the development and implementation of corrective actions.

Confidential, New York

Business System Analyst

Responsibilities:

• Developed process flow diagrams to clearly identify business processes.
• Worked with cross functional teams on cross-channel, integrated, digital marketing campaigns including Video, Display, Search, Email, Web, Mobile.
• Created Use-Cases, User Interface documents and functional/requirements specification documents to document business needs.
• Requirements were gathered through interactions and meetings and periodic walkthroughs with potential users of the application.
• Participated and Facilitated Joint Application Development (JAD) Sessions for communicating and managing functional requirements and project expectations.
• Implemented a successful supply chain management process within the POS group.
• Analyzed current business process to find gaps & weakness in the various business processes of e retailing, catalogue, content management, merchandizing & designed workflows.
• Coordinated with the Project Manager to set project activities like keeping track of Project Status report, Deadlines, and Compliance Issues.
• Implemented CMS (Content Management System) in automating various aspects of Web and Publication Content Creation, Document Management and Delivery.
• Provided hands-on leadership for the day to day operations of Supply chain and Material Management including Planning, Purchasing, Shipping and Receiving.
• Followed AGILE methodologies, and was involved from gathering requirements to testing phase.
• Documented the user requirements Analyzed and prioritized them and converted them as system requirements that must be included while developing the software.
• Wrote service methods and SQL queries, PL/SQL to interact with the DB2.
• Determined project scope and engineering requirements, estimated schedules, tracked item completion, certified milestones and maintained project documentation and corporate e-commerce web site Testing.
• Used JIRA to track the project updates and ensured the sprints were completed without much discrepancies.
• Worked closely with scrum master to design sprint overview and ensure smooth project delivery.
• Created Activity Diagrams, Sequence Diagrams and ER Diagrams.
• Created Mock-up forms in MS word for better visualization and understanding of the software solution.
• Developed strategies with Quality Assurance group to implement Test Cases in Test manager for User Acceptance Testing.
• Ran SQL queries to retrieve the data for data analysis and reporting.
• Actively involved with UI team to ensure the project deliverable resembles the requirements.
• Created User Stories, Test Cases utilizing Target Process Agile methodology tool.
• Substantial report development experience utilizing SQL Server Reporting Services (SSRS).
• Analyzed and recommended improvements to all sites and prepare reports for productivity programs and coordinate with team to design effective test strategies to increase site productivity for all ecommerce procedures.
• Managed and developed working relationships with third party digital marketing vendors and agencies.
• Gathered requirements and created functional and system requirement documents.
• Created reports of BRDs and approval status for project team.
• Gathered requirements for reports used by the business to analyze the impact of localized pricing at a store level.
• Created Process Flow diagrams, Use Case Diagrams, Class Diagrams and Interaction Diagrams using Microsoft Visio and Rational Rose.
• Used SQL Queries in Oracle to pull out data from the databases for the data validation and routine report generation.
• Worked closely with the Enterprise Data Warehouse team and Business Intelligence Architecture team to understand repository objects that support the business requirement and process
• Involved in developing test plans, test scenarios, test cases, test strategies, and UAT (User Acceptance Testing).
• Defined and promulgated test cases based on the requirements outlined in the test plan as part of the development cycle.
• Involved and coordinated the tests with the QA team to verify implementation of new features and enhancements.