Sign in

Sales Supply Chain

Dayton, Ohio, United States
September 19, 2019

Contact this candidate



Business Analyst



7+years of professional experience as Business Analyst with solid understanding of requirement gathering, documenting Business Requirements Documents (BRD), Functional Requirements Documents (FRD), Non-Functional Requirements Documents (NFRD), Use Requirements Specifications (URS), JAD Sessions, Gap Analysis, UML diagrams. Worked in all types of software development methodologies mostly Agile (Scrum), RUP and Waterfall. Highly motivated self-starter and capable of working independently.

Developed sustainable, repeatable and quantifiable business process improvements utilizing a data driven approach.

Skillful in creating design documents like process flow diagrams using MS Visio. Experience in creating UML based Modeling views like Activity diagrams/ Sequence diagram/ Use Case/Data Flow/ business Flow/ diagrams using MS Visio, MS Word, MS PowerPoint, MS Excel and MS Project

Experience with CRM processes like Sales, Marketing, Customer Service and Customer Support, Business Processes, Campaign Management, and recommended solutions to improve their processes using SFDC.

Adept in reviewing Test Procedures, creating Test plans, Test Scenario, executing Test Cases, Test Data reviewing and maintaining and executing detailed Test scripts for User Acceptance Testing (UAT) for CRM applications in Salesforce environment.

Highly experienced in using Blue Print as a tool for documenting business requirements, creating diagrams, making versions of FRD, etc.

Worked using various methodologies such as Agile Software Development, Rapid Application Development (RAD), Joint Application Design (JAD) and Prototyping

Knowledge of Business Intelligence, Data Warehousing, Data Modeling and Analytics concepts with expertise in grasping transaction flows and process management

Proficient in interacting with users and creating process-flows for business process re-engineering.

Strong knowledge about capital market integrity which can help to detect abnormal trading behavior among various asset classes.

Provided SharePoint best practices and advice regarding site set-up, site security, maintenance, and future needs.

Experienced in performing GAP analysis, SWOT analysis, Cost benefit analysis, Risk analysis.

Worked on Requirement Traceability Matrix (RTM) to trace and verify if all requirements are met.

Proficient in developing & automating reports, iteratively build & prototype BI dashboards using Tableau to provide insights at scale, solving for analytical needs of business team.

Experience in preparing PowerPoint presentations using bar diagrams, pie diagrams, charts, Pivot and graphs.

Excellent analytical skills in understanding the business process (AS-IS and TO-BE), understanding the functional requirements and translating them to system requirement specifications.

Experienced in conducting Joint Application Development (JAD) and Rapid Application Development (RAD) sessions. Conducted Requirement Gathering Sessions and interviewed Subject Matter Experts, gathered detailed functionality aspects of business process and updated the information to the requirements in an easily comprehensible format

Extensive experience in creating business process flow diagrams, UML (Unified Modeling Language) tools to create Activity, Sequence, Use Case, Class, and Collaboration diagrams

Developed Test Strategies, Test Plans, Test Cases, Test Scripts, test development test execution and Test Scenarios in Quality Test Professional (QTP). Extensive experience in HP Quality Center, Jira and Microsoft test center.

Competent in Creating Unified Modeling Language (UML) diagrams such as Use Case Diagrams, Activity Diagrams, Class Diagrams and Sequence Diagrams.

Maintain database of regulatory enquiries, due diligence conducted for internal reporting

Works with business management in projects affecting assigned line of business and/or area of regulatory specialization (including system testing)

Proficient in Technical and Business Writing, Business Process Flow, Business Process Modeling, Business Analysis and testing various methodologies.

Strong Communication and Presentation Skills substantiated in past assignments with developers, project managers, subject-matter experts, stakeholders, system implementers, and application end-users.

Business Modeling Tools

Rational Requisite Pro, MS Visio, Clear Case, Clear Quest, SharePoint 2007,

Statistical Tool

MS Excel, MS SQL server, MS Access, Windows, SharePoint

Project Methodology

RUP, SDLC, Agile, Scrum, Waterfall, Rational Requisite Pro,


Rational Rose, MS Office, MS Project,MS Visio, Remedy, Quality Center, SQL Server Reporting Services (2000/2005/2008 R2,2012,2014)

Defect Tracking Tool

Jira, Quality center, HPQL ALM, RTM

Programming languages

Java, HTML, DHTML, Visual Basics(VBA)

Operating Systems

MS-Windows, Linux


MS Office, MS Project, MS Visio, JIRA, Remedy Quality Center


MACY’S Inc Cincinnati, OH Jan 2018 – Present

Business Systems Analyst

Macy's, Inc., is an American multinational holding company headquartered in Cincinnati, Ohio. It is the owner of department store chains Macy' which specialize in the sales of clothing, footwear, accessories, bedding, furniture etc.

The role intended to incorporate Lean Procurement for a Demand driven Supply Chain Network which included a system of processes and technologies that enabled the organization to sense and respond to real-time demand across a network of suppliers, employees, and customers. The Lean Procurement activities focused on proactively managing supply chain events using Supply Chain Event Management System(SCEM) embedded with Oracle and at the same time focused on streamlining buyer productivity, eliminating non value-added activities across the supply chain, optimizing the Enterprise Resource Planning(ERP) and Electronic Data Interchange(EDI) by migrating from push to pull system, developing a flexible and responsive supply chain & reducing the wastes involved in the procurement activities.


Coordinate with product owner and business users to gather requirements for creating user stories and acceptance criteria.

Analyzed business model, user requirements and logical specifications to deliver appropriate solutions

Focused on improving our supply chain operations by gathering global data across multiple functions and conducting analysis utilizing analysis tools such as: supplier data, SAP, BW, Query Designer and Excel

Implemented and customized Salesforce customer relationship management (CRM) for Marketing, Sales and Case Management also implemented sales cloud and service cloud to improve customer retention and service delivery process improvement.

Facilitated workshops between business stakeholders and offshore developers to modify Merchant CRM platform to conform to Best Practices and to improve performance. Played the role of a Business Analyst in Agile environment by eliciting Business Requirements from Business users using Brain Storming sessions, interviews and JRP sessions and converting them to Functional Requirements.

Created Project Charter, managed the project management plan, established risk management process and metrics for the deliverables

Conducted JAD sessions with business partners and technical teams to communicate their perspectives with each other, resolve any issues, and come to an agreement quickly.

Coordinated and prioritized outstanding defects and enhancement/system requests based on business requirements, allowing sufficient time frame to ensure accuracy.

Conducted workflow, process diagram and gap analyses to derive requirements for existing systems enhancements

Assisted Program Manager in scope estimation and work breakdown structure (WBS) to meet Project Milestone

Conducted JAD sessions with Export team to understand AS – IS process and created TO –BE process

Support the maintenance of SAP functions and system business rules.

Created, administered, and compiled extensive user surveys and conveyed the requirements to developers

Documented end-to-end functional requirements from the front end web based applications, to the Data Warehouse, Data Marts, Business Objects Universes and Tableau Dashboards. Performed end-to-end testing and UAT through each layer.

Assisted the project manager in PM tasks like preparing scope statements, templates and status reports

Defined business scope and assumptions, estimated resource and work requirements and suggested effective strategies to meet business objectives

Publish daily, weekly, and quarterly reports that are sent to and reviewed by internal customers and the leadership team

Worked with user to define user acceptance test cases. Involved in UAT testing (User Acceptance Testing) and procured signoff from the involved parties.

Gathered requirements for the integration of POS system with the supply chain system.

Designed and documented Business Process Flows, UML Use Cases, and Systems Documentation including requirements, functional Specifications and System Design

Created custom reports for stakeholders and key business users

Evaluated user needs in online ordering and online account management

Involved in User Acceptance Testing (UAT); documented the changes/enhancements required after interacting with the end users

Ensured constant relation with users and technical teams to develop custom solutions.

Environments: HP Quality Center ALM, Salesforce, MS Visio, MS Access, SharePoint, Confluence, BizTalk, MS office, Angular JS, SQL, Express.

Gap Inc. Rockville, MD Nov 2016 – Dec 2017

Systems Analyst

GAP, Inc. is one of the world's leading apparel retailers. The main goal of the project was to modernize the Content Management System (CMS). I worked on implementation of NetSuite integrated CRM/ERP system, which included: defining implementation strategy, converting legacy systems, Point-Of-Sale (POS) system and internet store. My responsibilities also included redesigning Order Fulfillment and Shipping operations. Implemented an E-commerce Application which included inventory tracking and distribution of goods to its various distributors.


Functioned as a primary liaison between the business, operations, and the technical team throughout the project.

Worked closely with technology and business user staff to complete workflow improvement and document functional specifications for systems.

Assisted other business analysts in performing Feasibility and Complexity Analysis to identify technically feasible functionalities, and determine the level of effort (LOE).

Collaborated with Product Owners to write up and prioritize customer centric documents like User Stories for Product Backlogs.

Analyzed the changes performed in CRM application for marketing, sales etc. translated them to business and functional requirements for Sales and Service Clouds in SFDC.

Convert legacy reports from excel and SAS into automated reports in Tableau while updating to more visual analytics.

Translate code from outdated systems and legacy SAS reports to usable SQL data to be ingested into Tableau

Prepared and documented Sprint Backlogs to identify and monitor the activities performed in the time boxes.

Provided detailed User Interface Document to the development and testing team for clear understanding of the system.

Served as a liaison between the Business and Technology Department. Enhanced communication lines between executives, managers, and peers.

Gathered requirements for the integration of POS system with the supply chain system.

Trained all Users on use of Point of Sale (POS) system.

Assisted the SCRUM Master in facilitating daily SCRUM meetings, Sprint Planning, Review and Retrospective meetings.

Created Burn-down Charts to monitor the completion of work within the time-boxes.

Participated in Daily Standup meetings and worked with the team in resolving issues that could potentially cause delays in the sprint completion.

Formulated test case scenarios from the user stories.

Created UAT test cases and assisted senior business analysts in conducting UAT tests.

Made extensive use of SQL queries for the arrangement of customer data.

Conducted training sessions and updated Product Manual upon successful delivery of each sprint.

Resolved issues reported by business Post-Production.

Dick’s Sporting Goods, Coraopolis, PA Jul 2015 –Sep 2016

Business Analyst

Dick's Sporting Goods, Inc. is a sporting goods retailer offering a broad assortment of brand name sporting goods equipment, apparel and footwear in a specialty store environment. The main objective of the project was to improve Online Order Management System (OOMS) so asto generate online orders in stores, create a user friendly experience for customers, and ship orders placed in-store for free. In addition, it would be possible for vendors to ship directly to customers, thereby improving inventory turns. Increase in customer satisfaction, lower shipping costs and improved utilization of inventory can be achieved by connecting online customers with any products in any store.

Functioned as a primary liaison between the business, operations, and the technical team throughout the project.

Interviewed clients and business users to understand theBusiness and Functional Requirements, and transforming them to Functional Specifications.

Involved in interviewing Subject Matter Experts (SMEs) and carefully recording the requirements in a Business Requirements Document (BRD).

Analyzed and translated business requirements into system specifications utilizing UML and RUP methodology.

Documented Requirements, Objectives and formulated systems to parallel overall business strategies.

Prepared the Functional Design Specifications employing use case diagrams, sequence diagrams, and Data Flow Diagrams (DFD's).

Created Screen designs for the development team to ensure client’s requirement were adequately represented.

Performed Gap Analysis between the “As-Is” model of the legacy system and the “To-Be” model to identify the gaps logged issues relating to the identified gaps and worked with the SME to get clarifications.

Involved with regular walkthroughs and meeting to discuss bottlenecks in the system and possible solutions with the development team.

Performed report validation writing SQL queries on an SQL Server database.

Prepared and maintained Requirements Traceability Matrix.

Tracked change requests and monitored workload and schedule.

Target Corporation - Minneapolis, MN Feb 2014–Apr 2015

Sr. Business Analyst / Data Analyst

Target Corporation is an American retailing company. It is the second largest departmental store retailer in United States. The project involved developing and modernizing the Gift Registry website and the mobile application for potential Guests by providing the ability to migrate items from store to registry platform. Guests are provided the ability to customize their own personal registry. Checklist, gift tracker, group gifting, coupons and order pickups were some of benefits and features were developed as a component of this project.


Creating presentation material for the client and upper management approvals and sign-offs.

Implemented SDLC process for developing personal gift registry application using agile approach.

Interacting and organizing meetings with business team to understand business objectives and get EPIC for migrating products from store to registry platform

Drafting user stories and acceptance criteria for creating personal gift registry page and mobile interface on website

Grooming user stories, allotting subtask and putting stories into Gift registry product backlog

Prioritizing user stories according to Target's list and registry needs

Interacting and arranging meetings with dev team for estimating and calculating story points of the stories backed in registry backlog

Conducting sprint planning meeting to put user stories from product backlog to sprint backlog based on its priority level defined

Drafted Wireframe diagrams for gift registry visualization on and Registry application

Facilitate daily scrum meeting, Backlog grooming and retrospective meetings throughout the process of developing and modernization of gift registry website and mobile application

GAP Analyze for Gift Registry website and application specification and providing proposal for enhancement of the system

Worked with QA team for designing Test plan and Test cases for User Acceptance testing (UAT) before the final release

Wrote SQL queries to extract and validate Data

Identify the root cause and provide accurate solution for the issues raised while accessing the application

Change and release management for change demanded and issues related to enhancement of gift registry

Sent REST API calls through postman for developing and integrating registry feeds API

Conducted meetings with Marketing and sales department for feedbacks

Entitled for training new users/guests for operating gift registry as a part of post-production duties

ICICI Bank Limited, India Jun 2012 – Nov 2013

Business Analyst

Monitor current business processes used by the Business Banking, Capital Market, Consumer Banking, and PEP groups for reviewing bank customers for AML and KYC systems

Utilize Visual Basic to create interactive business documents used by analysts, QC and bankers to retrieve necessary customer information and create completed KYC review.

Create and implement SharePoint based applications for general use by KYC

Develop business analysis systems to assist in the designation of customer activity as normal or abnormal using statistical measures and holistic review

Strong exposure to the Retail banking front office functionality and processes including

Screen triggered business banking accounts for red flags constituting further anti-money laundering investigation

Create narratives expanding upon the expected and actual activity of customer's accounts identifying discrepancies and ultimately recommending further investigation, closure, or observation of the account

Collect and analyze qualitative data from bankers through creation of pointed customer questionnaires

Contact this candidate