SUMMARY

• 8+ Years of Industry experience as a Business Analyst with solid understanding of Business Requirements Gathering, Business Process Mapping, Evaluating Data Sources and Data Mapping.
• Extensive experience in the Retail and e - commerce environments with knowledge of commerce ATG suite and WebSphere.
• Experience in Retail Operations, Supply Chain, Logistics, International Growth/Global Operations, Customer experience, and Technology
• Expertise in creating Business Requirement Document (BRD), Functional Requirement Specification (FRS) document, User Requirement Specification (URS) and Change Request (CR) document for system application development
• Experience in a major effort to improve the Warehouse Management System (WMS) capabilities of Supply Chain Management.
• Experience with trading (OMS), Market Data, Fund accounting, Portfolio Management, Compliance, portfolio risk and back office systems.
• Experience in Using JIRA for User Story requirements management throughout the Agile Sprints and development life cycle.
• Experience in full life cycle implementation of Logistics from scoping studies to post go live production support design and implementation.
• Expertise in UML (class diagrams, object diagrams, GAP Analysis, use case diagrams, state diagrams, sequence diagrams, activity diagrams, and collaboration diagrams) as a data analysis methodology for application functionality designs using IBM's Rational Rose.
• Extensive experience of analyzing complex IT projects throughout SDLC - from scope definition to successful implementation using Waterfall and Agile framework (Scrum, Kanban, and SAFe methodologies).
• In depth knowledge of Supply chain functionalities, with emphasis in Operations and functional requirements of WMS systems in a Distribution Center environment.
• Worked with ETL Developer and possess a strong knowledge in Teradata, Data warehousing, SQL, Unix, Shell Scripting, Crontab.
• Extensively executed SQL queries on Oracle and SQL/MP tables in order to view successful transactions of data and for validating data and backed testing
• Experience in working with Functional Users, Cognos Development team, and Data Warehouse team to gather information using a variety of business analysis techniques. Used Blue Works Live for documenting.
• Extensive experience in Performing GAP analysis of software functionalities to select between multiple WMS (Warehouse Management system)
• Experience in modeling UI wireframes, mockups and documenting the end-user's AS-IS workflow and TO-BE business processes
• Experience in data Extraction, Loading and Transforming of data at the Data Warehouse level as well as skilled in various ETL tools for design and development of work flows, transformations and mappings
• Experience in conducting Joint Application Development (JAD) sessions with end-users, expert team, development and QA team for project meetings, walkthroughs and customer interviews.
• Extensive experience in web development executing Adobe Analytics and Google Analytics tagging, QA testing

PROFESSIONAL EXPERIENCE

Confidential - Atlanta, GA

Sr. Business Analyst

Responsibilities:

• Worked on development of High-level design, Conceptual design, Logical and Physical design for Database, Data warehousing and many Distributed IT systems
• Performed creation of WebSphere Commerce Suite design documents for a new B2B and B2C e- commerce site.
• Gathered requirements from clients to create Business Requirements Document (BRD) for the existing system to improve project goals
• Defined requirements for WebSphere Commerce Server.
• Worked on the Supply Chain scope includes the entire supply chain from production order to shipping & delivery and order management.
• Analyzed business requirements for the IBM POS retail system, process flow and gap analysis, and writing test cases for the QA team. (Used Visio, Crystal reports, Word)
• Credited for creating system/network documentation to support Warehouse Management System (WMS) and third-party Shipping software to comply with all company policies
• Facilitated team meetings and teamwork to continual improvement of team's Agile practices Strong ability to balance data with other factors when making decision, ability to integrate Agile
• Conducted JAD sessions with management, SME, vendors, users and other stakeholders for open and pending issues.
• Kept track of Agile (scrum/ Kanban), Safe metrics tracking variables to gain transparency on product and sprint backlogs
• Involved in logistics Execution Organizational Structure Elements including Storage Bins and Quants, Material Master and Customer Master.
• Good knowledge of ETL reporting tools Power BI, Tableau, Qlikview and Excel to develop dashboards and data
• Used JIRA for User Story requirements management throughout the Agile Sprints and development life cycle.
• Helped with data modeling and defining the conceptual and logical model of the data warehouse
• Worked with SQL queries using MS Access for data manipulations and involved in writing scripts for patient online registrations using the VB Script.
• Worked on Reengineering warehouse to increase organizations daily operation, including piece per hour, stock put away, receiving and replenishment functions.
• Worked on Advanced Excel VBA Macro coding to automate many areas of complex reporting using if then else, match index, VLOOKUP, case statements and advanced nested formulas.
• Involved in customizing the goods movement types occasionally to go well with the vendor needs and to support logistics.
• Participated in major effort to improve the Warehouse Management System (WMS) capabilities of Supply Chain.
• Involved in inventory management value assessment to improve financial performance and the customer experience by reducing working capitals and supply chain costs, and improving on shelf availability.
• Exposed to Agile methodology Performed Gap analysis (AS-IS) & (TO-BE) by identifying existing processes, technologies, and documenting the enhancements needed to meet the end state requirements.
• Maintained documentation of ETL processes to support knowledge transfer to other team members.
• Planned and defined system requirements to Wire Frame with Use Case, Use Case Scenario and Use Case Narrative using the UML (Unified Modeling Language) methodologies
• Coordinated with the Data warehousing team in ETL, data cleansing and reports requirements by using Informatica.
• Performed data validation testing using SQL queries to validate data. Reviewed the vendor API to reduce stock issues
• Responsible for writing and modification of PL/SQL stored procedure, functions, packages and Database triggers.
• Co-ordinate User acceptance testing (UAT) performed by the business users
• Assisted to develop the Test Plan, Test Cases and Test Scenarios to be used in testing based on Business Requirements, technical specifications and/or product knowledge.
• Conducted review sessions on regular basis with QA and development teams for preparing status, delivery report and client reporting.

Confidential - Portland, OR

Business Analyst

Responsibilities:

• Worked on project plan with definition of deliverables and required delivery dates for the implementation of phase one of the new Retail Merchandise System with an offshore vendor.
• Worked on inventory management value assessment to improve financial performance and the customer experience by reducing working capitals and supply chain costs, and improving on shelf availability.
• Wrote SQL Statements to extract data from the Tables. Involved in the creating the reports using the Business Intelligence and Cognos Reporting.
• Involved in setting up environments for Adobe CMS, integrating with WebSphere Commerce.
• Responsible for implementing supply chain and operations solutions in the exploration & production line
• Worked on creating Data Stage jobs to extract, transform and load data into data warehouses from various sources like relational databases, application systems, temporary tables, flat files etc.
• Worked on Formulating and implementing a requirements management approach using IBM Rational Requirements Composer
• Actively participated in business requirements and suggested a consulting strategy to fulfill these requirements so that clients could better integrate their processes related with finance, logistics and human resources
• Worked on Managing Agile Life Cycle, Product backlog, Iterations plan, created user stories and product backlog
• Business Analysis reports development efforts by working closely with Micro strategy, Teradata, and ETL teams
• Coordinated the move from Excel-based documentation of security reference data to a more flexible software-based Graphic User Interface
• Responsible for expanding the strategic enterprise warehouse management initiative and rollout WMS template across Technicolor distribution centers
• Prepared Business Requirement Documents (BRD’s) after the collection of Functional Requirements from System Users that provided appropriate scope of work for technical team to develop prototype and overall system.
• Actively participated in gathering requirements from various SMEs, Financial Analysts, Risk Analysts and Portfolio Management via JAD/JAR sessions.
• Designed Use Cases, Use Case Diagrams, Use Case Scenarios, Workflow and Data Flow Diagrams. Business Process Flow Diagrams, Activity and Sequence Diagrams using Microsoft Visio.
• Worked in team organized under Scaled Agile Framework (SAFe) following incremental delivery.
• Responsible for implementing supply chain and operations solutions in the exploration & production line
• Worked on Creating Jira User Guide and performed training sessions to introduce Jira to the team.
• Involved and reviewed TSQL/SQL queries and stored procedures to process, analyze and implement data integrity initiatives for various business units.
• Extracted data Analysis from different sources like Oracle and text files using MS Access, SQL procedures and created datasets.
• Responsible for WMS set up, configuration, training, and successful implementation of new server. Successfully upgraded Server and Oracle Warehouse Management System with no down time or production loss
• Worked with other team members to write detailed Business Requirements Document. Developed Functional Requirements Specifications and System Requirement Specification from the business requirements.
• Involved in various brainstorming sessions to investigate, identify, analyze and solidify business rules.
• Managed User Acceptance Testing for system updates on the RTA and TPM Planning systems as needed.
• Worked with SME for the Source to Pay Project Team representing Accounts Payable group
• Worked with the QA team to develop test plan, test cases and test conditions for integration and functional testing. Traceability Matrix was used to ensure complete end-to-end testing.

Confidential

Business Analyst

Responsibilities:

• Involved in gathering business requirements from the end users and management.
• Created high quality functional requirement specifications and supporting documents for business systems.
• Identified and retail procedures for emerging retail chain
• Created Physical Inventory process for retail stores, consisted of data integration and inventory processes with third party vendor
• The Supply Chain scope includes the entire supply chain from production order to shipping & delivery and order management.
• Participated in major effort to improve the Warehouse Management System (WMS) capabilities of Supply Chain.
• Identified/documented data sources and transformation rules required populating and maintaining data warehouse content.
• Used Agile life cycle Methodology for Iterative development and Rapid delivery of the product
• Followed Agile methodology, being Business Analyst as Product Owner for better Collaboration among Scrum Master, Scrum Team and Business Stakeholders
• Worked on Exporting large data sets to excel relational worksheets, pivot tables, create massive formulas and VLOOKUP’s to compare data and perform searches
• Involved in configuring Logistics Invoice Verification for procure to pay process and testing the integration with FI.
• Created Business Requirement Document (BRD), Functional Requirement Specification (FRS) document, User Requirement Specification (URS) and Change Request (CR) document for system application development
• Actively involved throughout all steps of the Software Development Life Cycle (SDLC)
• Worked on Gap analysis (AS-IS) & (TO-BE) by identifying existing processes, technologies, and documenting the enhancements needed to meet the end state requirements.
• Worked with SQL queries using MS Access for data manipulations and involved in writing scripts for patient online registrations using the VB Script.
• Involved in conducting quarterly trainings, monthly forums and manages the Cognos Power User SharePoint site.
• Wrote PL/SQL statement and stored procedures in Oracle for extracting as well as writing data.
• Worked on UI/UX and created mockups and wireframes for the application.
• Created and maintained user stories in JIRA for better understanding of the requirements for the development team also use JIRA for bug tracking.
• Created Use cases, activity report, logical components and deployment views to extract business process flows and workflows involved in the project. Carried out defect tracking using Clear Quest
• Used Clear Case for creating documents repository and sharing the documents across the team.
• Facilitate JAD sessions involving the management, development and user teams for clarifying requirements and facilitating better communication.
• Involved in assisting the development of functional requirements, static testing the applications by preparing and developing the Test Plans and Test Rules, editing and writing Test Cases, Test Scenarios and Test Scripts
• Worked closely with the project team in planning, coordinating and implemented QA methodology on various phases of the application.