Ali Khan

214-382-9363
Alikhanba08@gmail.com

PROFESSIONAL SUMMARY

 8+ years of professional experience as a Business Analyst with a strong understanding of Business Analysis,
System Analysis in Retail and E-commerce domain.
 Experienced working on Order Management System (OMS), Omni Channel Fulfillment, Retail Point of sales
(POS) Applications, Store operations Customer Relationship Management (CRM i.e., Loyalty Program),
Fleet management, Ecommerce platforms.
 Expertise in Software Development Life Cycle (SDLC) methodologies such as RUP, Agile / Waterfall
methodologies with hands on experience in all of them.
 Experienced in Business Requirements gathering and writing skills with expertise in developing and
documenting Business Requirement document (BRD), Functional Requirement Document (FRD), and
Software Requirement Specification (SRS) across the deliverables of a project.
 Experienced in conducting JAD sessions with SME (subject matter experts), stakeholders, developers and
end-user representatives to make sure all the stakeholders and developers are on the same page.
 Experienced in conducting Joint Application Development (JAD) sessions with end-users, expert team,
development and QA team for project meetings, walkthroughs and customer interviews.
 Extensive knowledge of the E-commerce Retail Sales lifecycle and the Retail Ecommerce ecosystem, Order
management system (OMS), Warehouse management system (WMS), Fulfillment, Trade Promotions
Management (TMS) and Support.
 Extensive experience in Performing GAP analysis of software functionalities to select between multiple
WMS (Warehouse Management system).
 Experienced in UML methodology to create UML Diagrams including Use Cases Diagrams, Activity
Diagrams, Sequence Diagrams, Data Flow Diagrams (DFDs), ER Diagrams using Rational Rose and MS Visio
and thus defining the Business Process Model and Data Process Model.
 Experienced in tracing requirements throughout the development process and verifying adherence using
the requirements Traceability Matrix (RTM).
 Strong work experience on Ecommerce portals web application developments, Business (B2B) and
Business to Customer (B2C), Online Retailing, and Content Management Systems (CMS) for Ecommerce
like ATG.
 Solid understanding on various E-commerce tools such as Demandware, Magento Open Cart.
 Experienced working with Content Management Systems (CMS), Order Management System (OMS),
Supply Chain Management and UX teams.
 Expertise in preparing strategies for Cross Channel/Multi-channel integration providing a consistent
experience across the customer's preferred channels and platforms like Mobile and E-Commerce.
 Experienced on various Software and Customer Relationship Management (CRM) packages and Integration
of merchandising systems with Warehouse Management Systems.
 Experienced working with Retail Oracle Point of sale (POS) application, Payment processing (EMV) and
Knowledge of Web Services Description Language (WSDL), web services SOAP API.
 Experienced in Business Process Flow, Business Process Modeling, Business Process Re-Engineering Data
Warehouse Data Analysis, Data Mapping, Data Modeling.
 Experienced in performing backend testing and writing SQL Queries for testing RDBMS such as SQL Server,
Oracle, and Teradata for data integrity.
 Experienced in the Informatica/ ETL (Extract, Transform and Load) of data into a data ware house/date
mart and Business Intelligence (BI) tools like Business Objects Modules (Reporter, Supervisor, Designer,
and Web Intelligence).
 Excellent understanding of Data Models, Master Data Management, Databases like Oracle, and sound skills
in SQL.
 Extensive knowledge of Salesforce.com implementation cycle in Sales Cloud, Marketing Cloud, and Service
Cloud.
 Expertise in problem solving, system analysis and strong analytical and product management.
 Strong experience in working with Business and Technology teams through collaboration tools such as
Confluence, JIRA, etc.
 Expertise in Advanced MS-Excel (Gsuite, sheets), PowerPoint, spreadsheets (Pivot table & Pivot Charts,
Macros, VLOOKUP).
 Proficient in the use of Visual Studio, MS Visio, MS Word, MS PowerPoint, MS Excel, as well as MS Project.
 Solid understanding of Test Plans, Test Strategies, Test Scenarios, Test cases by reviewing Business and
Software Requirement specifications and creating Gap Analysis for test purpose.
 Experienced and complete understanding of QA Life Cycle, which includes Designing, Developing,
Execution and Documentation of the Test Cases, Automated Test Scripts and Test Plans.
 Experienced in GUI Testing, UAT (User Acceptance Test), Manual, Functional Testing of Client/Server &
Web based application.

PROFESSIONAL EXPERIENCE

Ingles Market – Asheville, NC (Remote) February 2022 – Present

Sr. Business Analyst
The project was to develop a cloud-based ecommerce platform for an online secure shopping site and to
incorporate an Order Management System (OMS), Warehouse Management System (WMS) and Distributed
Order Management System (DOM). The project scope to gain customer loyalty through Omni-channels and to
meet demand, inventory and create tailor-made promotions.
Responsibilities:
 Worked on User Requirements gathering by interacting with stakeholders and business users using JAD
and One to One interview technique to get a better understanding of the domain and current system.
 Elicited and analyzed the business requirements of client implementing Customer relationship
management (CRM) module to maintain records of customer data on a monthly basis.
 Performed GAP Analysis between the "AS-IS" model of the legacy system and "TO-BE" model to identify
the project gaps.
 Created charts, graphs and PowerPoint presentations for financial reviews meetings and Prepared
PowerPoint presentations to manage databases.
 Converted Business Requirements into the Functional Specifications from UML and worked on changes
with the help of Requirement Traceability Matrix and Impact Analysis.
 Documented Omni-Channel reports which include daily dashboards, operational metrics reporting, ad hoc
operational troubleshooting and strategic reporting.
 Involved in developing in-house Order Management System (OMS) for order entry and processing and also
developing Distributed Order Management (DOM) software for Seamless Order Processing to improve
efficiency.
 Involved in tracking and Maintain accuracy of inventory through the use of WMOS also Support warehouse
and business operation teams through WMS.
 Involved in design and build of different Order Management System OMS modules - Order Capture, Order
Processing, Order Promising & Fulfillment, Payment Processing, and etc.
 Involved with other team members to categorize, prioritize and resolve software application issues dealing
with all levels of the Order management systems (OMS) and execution management systems (EMS).
 Worked on Order Management System (OMS) to ensure compliances with upgrade requirements, and
generated documents for the workflow of exiting system and desired system that involve Cash Analysis,
 Portfolio Analysis, Order Initiation, Order Execution, Trade Clearing, and Booking, and performed GAP
Analysis.
 Worked on Modification to host, Warehouse management system (WMS) and shipping systems to allow
efficient processing of e-Commerce orders and client selected samples.
 Worked with Team on Manhattan WMS integration to support Ecommerce Growth with automation,
process optimization and integration with new WCS system.
 Involved in the integration of the Warehouse Management System (WMS) with Logistics and other EDI
enabled external systems.
 Worked on analyzing and creating reports, as well as gathered data from credible sources to support and
enhance Omni-channel initiatives and performances.
 Worked on integrating analytics for Omni channel campaigns with established data models.
 Involved in functionally validating Web services delivered in SOAP XML format as provided in specification
document.
 Involved in migrating the end to end environment includes Windows server, SQL databases and
applications hosted on that database from on premise to cloud (AWS, Confidential cloud) and Cloud to on
premise.
 Worked with team on AWS Auto Scaling to provide high availability of the application and EC2 instances
based on the load of the application by managing CloudWatch events and alarms.
 Involved in Salesforce Sales, Service & Marketing Cloud and guiding clients on CRM solution for sales,
marketing and services teams in the Ecommerce-Digital Marketing.
 Responsible for creating UML modeling plan, Use Cases, process flows, screen flows and business
requirements documentation to model system development specifications, using MS Visio and Rational
Requisite.
 Worked with the team for defect tracking by using tool like Mercury Quality Centre (QC) and Team
Foundation server (TFS) for reviewing requirements, bug reporting, and bug tracking.
 Uploading user stories on Team Foundation Server and creating task for developer.
 Worked with ETL Team for writing query to create backlog for testing on Team Foundation Server.
 Used the Office Suite extensively which included MS Word, MS Excel, MS Access, MS Project, MS Visio for
various documentation and analysis reports.
 Worked on Agile, Scrum methodology for development and Backlog documentation, wrote user stories
based on INVEST criteria and documented the Sprint Backlog and technical backlog.
 Defined user stories in JIRA by creating tickets and elaborated stories to offsite development and QA
teams.
 Worked with the team designing and implementing SQL queries for QA testing and report / data
validation.
 Executed SQL queries to test the database for records that detect pricing and product label filters.
 Worked closely with the development team to troubleshoot bugs using defect tracking tool JIRA.
 Involved during the User-Acceptance Testing with end-users, management and development team in
order analyze the risk involved in the updating of the existing system.

Altria Group Inc. – Richmond, VA November 2019 – January 2022

Sr. Business Analyst
The project includes the enhancement of E-Commerce and web-based applications and coordinated between
the Business team, the Development team, the QA team and various other groups like Release Management,
Production Support, and Operations.
Responsibilities:
 Conducted user interviews, gathered requirements, analyzed the requirements using agile methodology
and documented the requirements using Rational Requisite Pro.
 Analyzed Business to Customer (B2C) and Business to Business (B2B) web properties and create new
business plan, business requirements, and staffing requirements.
 Worked on web-based application and systems development project including customized Content
Management System (CMS).
 Involved in managing live ecommerce clients of mid-sized B2B and B2C ecommerce websites integrated
with the company's existing ERP software and Shipping Software in a Content Managed System (CMS).
 Evaluated existing ecommerce applications to identify areas of improvement and carried out program
enhancements and modifications.
 Performed Joint Application Development sessions with SMEs and development teams and documented
functional business requirements as product backlogs using JIRA.
 Conducted JAD sessions with internal and external stakeholders (Sales, Credit, Finance, IT, Ecommerce,
Management, Marketing, and customers) to gather requirements.
 Worked on the Credit card/ EMV process for paying through the web or mobile application.
 Worked on ATG Software (B2C, B2B, Scenarios, BCC, Merchandising and CSC).
 Worked on analyzing, developing specifications & lead projects for ERP software applications in the areas
of Mail Order, Website, Store Interface, CRM, Price\Cost Management, Purchase Order\Receiving,
Warehouse management system & Order Tracking interface.
 Worked on PCI (Payment Card Industries) compliance to address security vulnerabilities to the Altria’s
Online Stores thus enhancing the websites security.
 Worked on Merchandising, Point of Sale (POS) Systems, and Ecommerce and Supply chain systems.
 Worked on compiling and analyzed various reports: E-commerce internal support report (Excel, Access).
 Involved in designing the Database architecture and implementing stored procedures, functions, views,
and scripts using SQL to build data processing modules.
 Worked on RTM Test Matrix, GAP analysis and SWOT analysis to check the compatibility of the existing
system infrastructure with new business requirements.
 Involved in creating defect tracking using HP QC and JIRA and reviewed them in subsequent iterations of
the application development process.
 Involved in preparing SDLC Documents such as Business Requirement document (BRD), Functional
Specification document (FSD), Test Plan, Test Report.
 Worked on Hybris e-commerce web platforms, Hybris Ecommerce framework, Order Management, Hybris
product content module (PCM).
 Created user stories and documented in detail entire work flows in confluence, managed scrum master
responsibilities with Sprint Span of two week.
 Create implementation and test plans for the CRM Marketing Email campaigns using Confluence.
 Worked on Data Cleansing or Data Scrubbing concepts to validate the corrupted data.
 Ensuring accuracy and integrity of ecommerce data through SQL queries which enhances the data quality
as per business standard.
 Involved in defining technical goals and business processes for the ecommerce platform in ATG E-
Commerce and Retail services.
 Responsible for working with customers to gather the requirements and created functional specifications
and created the dashboards using Tableau.
 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 MS Word, MS Excel, MS Access, MS Project, and MS Visio for documentation and analysis reports
among other project management and reporting tools.
 Daily tracking of projects using Test Director/Clear Quest/Team Foundation Server- TFS.
 Provided project plan which included a product backlog of User Stories and tasks to small team of analyst
and developers utilizing TFS agile Kanban template.
 Worked on SQL Queries for testing and data analysis of PL/SQL source code.
 Created Use Cases for the applications and facilitated QA group to develop Test Plan and Test scripts based
on Used Cases.
 Involved with the QA team to conceptualize, determine and develop test approaches and methods for unit
testing, integration and functional testing, load and usability testing according to the application
complexity and test requirements.
 Documented and involved in User Acceptance Testing (UAT).
 Responsible for regularly updating the Test Plan and uploading on Confluence for sharing with the team
and management.
 Worked with the testing team on the final application including Mobile Application for Usability testing to
verify whether all the user requirements were catered to by the application.
 Involved in online store Production Support that included incident troubleshooting and resolving tickets.

Del Monte Foods - Pittsburgh, PA May 2018 – October 2019

Business Analyst
Completed implementation of NetSuite’s integrated CRM/ERP system which included: defining
implementation strategy; converting company’s legacy financial system, Point-Of-Sale (POS) system and
internet store to NetSuite; training office, sales and warehousing personnel on the software; and redesigning
Internet, Warehouse, and Order Fulfillment and Shipping operations.
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 with WMS team 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.
 Ensured all bugs, requirements, mockups and test cases are logged with adequate information into JIRA to
assist developers and the team in developing a sound product based on customer standards.
 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.
 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.
 Designed workflows and allocated permissions within SharePoint.
 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.
 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 on User Manuals, and Training Manuals as per Project Specifications and timelines.

Beemac Trucking - Ambridge, PA January 2017 – April 2018

Business Analyst
This project involved development and implementation of a transportation solution that serves the tracking of
aftermarket movement of products and bridging the gap between Beemac logistics, third party service
providers 3PSPs, Original Equipment Manufacturers OEMs and other branded marketers. The primary
objective of the project was to build an online solution to support B2B collaboration platforms to provide
seamless flow of items in reverse logistics.
Responsibilities:
 Worked with the technical team in writing high-level design documents.
 Conducted highly interactive JAD sessions with project stakeholders to identify and resolve issues. Ensured
consensus between Line of Business and IT Teams.
 Involved with the team writing specifications for various reports and generating canned reports using
Business Objects.
 Participated in JAD sessions with SMEs and technological experts to gather data requirements such as
securities pricing, corporate actions and custodial data.
 Involved with the team implementing Agile - Scrum methodology throughout the process life cycle.
 Worked on Agile methodology attending daily standup calls with a sprint timeline which were tracked with
JIRA.
 Worked on identifying various data sources from where the data had to be extracted for the new platform.
 Involved in designing and developing Use Cases, Use Case Diagrams, Activity Diagrams and Data Flow
Diagrams.
 Worked on sorting out the Reverse logistics, Inbound/Outbound Supply Chain product solutions.
 Worked on conducting Customer Service Operations and Supply Chain Management with the guidance of
Product Manager.
 Worked with the team fulfilling the duty of Supply Chain analyst for Reverse logistics.
 Worked with the different stakeholders within the Supply Chain Management landscape, including
business product owners, to identify and deliver Supply Chain Management system enhancements as well
as facilitate systems support.
 Worked on delivering the releases in Agile- Sprint fashion.
 Worked on the fit/gap analysis reviews based upon documented functional designs or "to-be" business
processes with industry-leading Supply Chain Management software packages.
 Involved in projects from initial consulting through all project phases, including funding negotiation,
technical and process design, development, testing and implementation.
 Facilitated meetings among the Change Management, Problem Management and other relevant teams to
discuss the impact of the changes, problem tickets and prepare project milestone plans.
 Gathered requirements, developed Process Model and detailed Business Policies.
 Prepared the Business Workflow using MS-Visio with input, output, and Pre and Post conditions.
 Tracked defects using JIRA and generated defect summary reports
 Worked on developing recommendations and designed solutions for process improvements.
 Participated in UAT Testing with the Business team.
 Performed Use Acceptance Testing and scheduled demos for User training.

Wholesome Harvest Baking – Chicago, IL September 2015 – December 2016

Business Analyst
The project includes implementing the Trade Promotions Management (TPM), Supply chain management and
Order management (OMS), Inventory management system and Supply chain groups to work together to
address critical dependencies between processes like demand, supply, tooling and warehousing. It has been
implemented for maintaining the Demand, Production, supply, Shipping, Logistics and purchase order
processes.
Responsibilities:
 Worked on requirements gathering by conducting meetings and brainstorming sessions with end users
and SME and document them using Requisite Pro.
 Facilitated JAD sessions which includes the management, development and user teams for clarifying
requirements and better communication.
 Worked on all the phases of Software Development Life Cycle (SDLC) methodologies throughout the
project life cycle using agile methodology.
 Worked on Trade Promotions Management (TPM) by interacting with different sources of information and
provide a unified view of information to all the stakeholders.
 Worked with Category Development Managers (CDM) to accurately document promotional events
communicated to customers and enter promotional events into the Trade Promotions Management
system (TPM).
 Involved in creating processes and methods to gather supply chain management data and implement
supply chain optimization project (e.g., warehouse-slotting, route planning).
 Involved in gathering data and conduct analysis with the goal of improving the organization's supply chain
operations in logistics, sales.
 Analyzed inventory requirements from Business to Business (B2B) & Business to customer (B2C) clients
and based on sales developed a process to optimize orders that needed to be fulfilled based on SKU
dimensions, pallet sizes, customer requirements and delivery requirements; followed the Omni channel
fulfillment strategy for tracking inventory and sales.
 Involved in implementing the Trade and Logistics functional area of Microsoft Dynamics CRM.
 Involved in reporting bugs/defects in JIRA while doing exploratory testing in the testing phase.
 Involved in creating test Scripts & test Scenarios to check report content, layout, and parameters.
 Involved in user experience (UX) and user Interface (UI) design for project as well as mockups, prototypes
and wire frames.

Education: Bachelors in Business Administration, Bahria University, Islamabad Pakistan 2014