SUMMARY

• 6 years of experience as a Sr. Business Analyst, with in - depth knowledge of SDLC (System Development Life Cycle) with mostly initial phases of Waterfall, Scrum & Agile.
• Strong domain Experience of Retail, online retail, Supply Chain, e-Commerce, Buying/Planning, Merchandising, Logistics & Inventory and POS system.
• Skilled at performing different analyses like Gap analysis, SWOT analysis, Risk analysis, Cost-benefit analysis, along with good knowledge of process workflow tools and techniques.
• Experienced in conducting Joint Application Development (JAD) Sessions and Joint Applications requirements session (JAR) sessions.
• Experience in Using various CRM applications and integrated databases through the teams and projects.
• Excellent writing skills in preparing business requirements documents (BRDs), system requirements specifications (SRS), system design specifications (SDS), functional specifications, and defining project plans.
• In depth knowledge of UML in visualizing and documenting the artifacts using Use Cases diagrams, Class diagrams, Sequence diagrams and Activity diagrams.
• Extensive experience in project management best practices, processes, & SDLC methodologies including Waterfall and Agile (SCRUM).
• Developed/maintained all project communication deliverables including roadmap, planning list, change request, timeline, budget, scope and other requirements.
• Experience in conducting UAT, and documentation of test case and test plan. Expertise in creating training materials and conducting training sessions
• Excellent interpersonal, decision-making, communication and presentation skills and involved in high interaction with variety of audiences (PMs, technical specialists, developers, architects, SMEs).
• Experienced in working with business users as a primary liaison between the business users and the development team.

TECHNICAL SKILLS

Process/Model tool/IDE: MS Visio, Rational Unified Process (RUP), Rational Rose, Rational Requisite Pro, Test Management, Class Diagrams, Use Case Diagrams, Sequence Diagrams, and Activity Diagrams.

Desk top software: MSOffice, MS Word, Power point, Adobe Acrobat, Ms Project, Crystal Reports

Project Management: MS Project (PERT, Gantt charts), Excel spread sheets

Languages: Java

Operating System: Windows, UNIX, DOS

RDBMS: MS SQL Server 2000, Oracle

Web Tools: Font Page, Photoshop.

Test Tools: Test director, Quality Center.

PROFESSIONAL EXPERIENCE

Confidential - Seattle, WA

Business Analyst

Responsibilities:

• Interfaced with business users to document receiving, binning, customer picking, inventory processing and reporting processes for click & collect orders.
• Worked with Project Management team to perform an extensive financial analysis of various initiative the program; planned the project as per the resources and timeline.
• Interacted with various stakeholders to collect their user stories; document, manage and ensure real-time tracking of them as project proceeds.
• Worked closely with Store Planning teams to re-design Point of Sale (POS) systems to integrate the changes for implementing Omni channel shopping.
• Worked on e-commerce content gathered in past, performed in depth BI functions to derive useful insights from raw data.
• Coordinated with warehouse team, back end seller management and the logistics teams to ensure effectiveness of order management is maintained.
• Developed work flow diagrams in Visio from customer order to Point of Sale (POS); identified steps to modify for re-designing the supply chain.
• Worked with the business teams to map existing Order & Contract Management & Order Evaluation systems; re-designed data flow operational flow process to reflect the newly aligned strategic goals.
• Analyze business data, to understand customer behavior and also organizational activities of past in customer ordering and fulfillment processes.
• Worked on Business Case Development and carried out intensive research with Business and System executives to set the strategic goals and future
• Created Business Requirements Document (BRD), Use Case Specifications, Systems Requirements Specification (SRS), Functional Specification and User Stories; also created ad hoc reports as per the situation needs.
• Studied the current system functionalities & behavior and documented "As-Is" process; later upon business requirements and identifying the application shortcomings developed "To-Be" processes. Developed business case studies by collecting survey information regarding footfall ratio in store locations and purchasing behavior of customers.
• Coordinated the planning of in store merchandizing and product marketing with the store managers.
• Created mockup screens and presentations for designing the receiving, binning, and customer pickup processes on the mobile handheld devices.
• Documented processes for associate alerting on the mobile handheld devices for orders in queue.
• Oversaw end to end activities of SDLC, from planning to implementation of product; conducted User Acceptance Testing (UAT).
• Created a Requirements Traceability Matrix (RTM); kept a track of product backlog, sprint backlog, and time estimates using agile tools like Jira.
• Involved in virtual conferences via phone/digital conference system with offshore teams based in India and coordinated their work with the local teams.
• Coordinated the activities of Customer Relationship team in altering the contract management as per the business initiatives.
• Worked with supply chain & logistics teams to plan for Omni channel shopping process and also in development of extensive product returns mechanisms; integrated multiple payments systems for the convenience of customers.
• Developed BPMN work flow diagrams to show the process starting with customer login to product delivery; included with information exchange in various stages.

Environment: Jira, Agile, Balsamiq, MS- Office, MS- Visio, SWOT analysis, Competitive landscape analysis, Order Management System (OMS), Order Evaluation Systems, Agile SDLC, Share point, Point Of Sale (POS), Supply chain, BPMN, XML.

Confidential - New York, NY

Systems Analyst

Responsibilities:

• Meet with different stakeholders and business users to define project scope, timeline, milestone, budget, acceptance criteria, and approval process.
• Act as a liaison between the clients and IT team to develop system solutions to solve business problems quickly and effectively.
• Major contribution in building up a friendly environment between the developer team and clients to clearly understand the requirements and possible outputs.
• Extensively used ETL methodology for supporting data extraction, transformations and loading processing in a corporate wide ETL solution using informatica.
• Verify data completeness running SQL queries with both Merchandising team and marketing team after data import is done and validate business rules based on requirements.
• Help with ETL documentation to specify how data should be extracted from different sources and transformed into ideal format as cleaned data so that they can be loaded into Oracle ATG database.
• Created data mapping spreadsheet for DBA to understand how Demand ware platform attributes are mapped to Oracle ATG attributes.
• Manage testing activities in JIRA for both QA team and UAT teams, such as creating test plan and test cases.
• Export data from JIRA system and build daily JIRA reports so that teams can review the development and testing progress during scrum meeting.
• Write SOP standard operation procedure documents for doing different business tasks in Oracle BCC.
• Work with mobile app UI designers to create screen mockups and discuss UI requirements by using Adobe Photoshop and Mockflow.

Environment: Oracle ATG, HP-ALM, Balsamiq, SQL Server, JIRA, Microsoft SharePoint, Informatica, IDQ

Confidential, Irvine, CA

E-Commerce Business Analyst

Responsibilities:

• Worked with the agile team to create high level approach/design for solutions.
• Defined detailed business requirements by gathering input from vested business and technical parties to create a PRD and user stories using Excel Sheets.
• Prioritized user stories from product backlogs and helped generate sprint backlogs with Excel.
• Conducted day to day operations and managed team communication effectively by using Lotus Notes.
• Understood and assisted with merchandising and marketing tools such as Content Management, Promotions Engine, Search, and Data Feeds.
• Provided performance requirements like load to support UAT testing.
• Generated analysis of product productivity based on position within site, produce reports on position productivity.
• Developed specifications for reporting of ecommerce conversions, engaged visitors, readers, calls of actions, bounce rate, social engagement tracking and email tracking based on Google Analytics
• Participated and assisted with the test teams in deliverable testing and quality assurance review to ensure that all the business requirements have been satisfied.
• Worked with the marketing team to test positions and strategies for driving increases in specific product or category sales.
• Created insightful automated dashboards and data visualizations to track key business metrics
• Assisted in creating weekly KPI reports.
• Helped create analysis of within site search productivity and make recommendations on improvements which can drive sales increases.
• Assisted in creating weekly checkout funnel analysis to identify opportunities and obstacles to the checkout process.
• Generated cross-sell/up-sell analysis with the marketing team to identify selling opportunities.
• Created Jira Tickets and managed backlogs for sprint.
• Excellent at conducting A/B and multi-variant testing to improve site performance.
• Helped in providing sales, margin and ROI analysis for proposed direct-to-consumer initiatives, and productivity of online destinations and merchandise positions.
• Ensured that the business is prepared to use and exploit solutions once delivered.

Environment: Rally, MS Visio, Test Director, MS Project, e-Procurement services, WebSphere Commerce, Google Analytics, UML, HTML, MS Office suite, Rational Rose, Rational Clear Quest, Jira

Confidential

Business Analyst

Responsibilities:

• Actively participated in all team meetings and walkthroughs including peer reviews, process improvement, presentations and demos.
• Analyzed the source data, coordinated with Data Warehouse team in developing Relational Model.
• Involved in discussion with developers for resolving the Defects and Bugs.
• Created Data Flow Diagrams and Process flow diagrams for various load components like FTP Load, SQL Loader Load, ETL process and various other processes that required transformation.
• Assisted project manager with the creation of project plan covering Project Schedule, Assignment of tasks, Risk management Plan and Test Strategy.
• Created as-is data flow and work flow diagrams and to-be data flow and work flow diagrams and conducted walkthrough sessions for these diagrams to make sure that the business and SME's were on the same page as us.
• Worked with the SME's, and baseline team to redesign the business process.
• Created Business use case model, business use case specification, supplementary GUI requirements, reporting requirements and non-functional requirements to capture all the business requirements. Used DOORS or requirements and documents management.
• Created UAT test plan and conducted a walkthrough session to make sure all other teams understood their roles and effort.
• Created test cases and test scripts for user acceptance testing and maintained them in Rational Test Manager and created traceability to Doors.
• Conducted UAT and made sure all identified defects and enhancements were logged in clear quest.
• Coordinated and prioritized outstanding defects and enhancement identified during UAT, and escalated the same if necessary to achieve the deadline.

Environment: Rational Requisite Pro, Rational Clear Case, ERWIN, Rational Clear Quest, Rational Rose, SQL Server, Visio.