SUMMARY

• Extensive 6+ years’ experience as a Business System Analyst in e - commerce, retail industry with all phases of software development life cycle (SDLC), including Requirement gathering and documentation, Data Analysis, Data modeling, Data Mapping and Designing etc.
• Experience on Retail / Supply chain domain with strong knowledge of standard business processes like Inventory Control, Procurement & Allocation, Merchandise Planning, Pricing & Invoicing, Demand Planning & Forecasting, Returns, Warehouse & transportation management process. Little knowledge on POS and Assortment Planning.
• Experience in root cause analysis identifying the different possibilities for a transaction failures (outbound/inbound) to WMS. Experience in JDA WMS implementation and production support of the system by working with warehouse users.
• Familiarity with numerous data warehousing concepts like pivoting, data slicing/dicing, data cleaning/scrubbing, metadata, data mart, fact table, dimension table, star schema, snowflake schema, fact less fact table, etc.
• Provide best practice recommendations in the areas of Order Management System and CRM. Worked on Trade Life Cycle as well as the Order Management System (OMS). Prior Knowledge/experience with Microsoft Team Foundation Server
• Ability to configure and ran transportation planning, optimization & execution, carrier contract & rate management, freight billing & auditing with functional and technical orientation. Conducted overall business management and data management by using Microsoft Excel and database tools including SQL, MySQL and MS Access.
• Experience with JIRA or other Agile SCRUM tracking applications is an asset and using jira to document epics, users stories, risks, issues, defects.
• Collaborate with different areas of the business and Supply Chain areas to identify and understand business needs and solutions for assigned projects. Identify, understand, interpret, and document the business requirements and process flows for assigned Supply Chain projects
• Created and implementation of a new store order management system and the inventory system, where the Manager can order Inventory from the Warehouse.
• Strong experience in Scrum/Agile methodology and proficient in writing user stories of core business systems. Hands on experience in creating Test Plan and Test Cases using HP ALM based on the system/functional requirements
• Experienced in developing reporting application using ETL (Informatica) and Cognos Business Intelligence Suite with multiple data sources like Oracle, MS SQL and DB2 database.
• Extensive experience with Business-to-consumer (B2C) sales of tangible goods/online services and Business-to-business (B2B) scenarios, such as e-procurement

TECHNICAL SKILLS

Project Methodologies: Agile-SCRUM, Waterfall

Business Modeling Tools: MS Visio, Rational Rose

Document Management Tools: Rational Requisite Pro, SharePoint

Issue Tracking Tools: JIRA, HP ALM, Rally

Business Applications: Microsoft Office Suite - MS Word, Excel, PowerPoint, Outlook

Project Management Tools: MS Project

RDBMS: Oracle, SQL Server

Operating System: Windows, Mac, UNIX

PROFESSIONAL EXPERIENCE

Confidential, Memphis, TN

Sr. Business System Analyst

Responsibilities:

• Developed business models and use cases to clearly depict process flows relating to specific business requirements to convey business, system and functional requirements to both business and technical staffs.
• Worked on creating SOP's based on standard supply chain functionality as well as simple to complex customer enhancements to Manhattan WMS Product suite
• Provide guidance and help to implement and maintain a Global Supply Chain strategy that supports the company's business goals and objectives. Coordinate activities related to the implementation of the strategy across multiple manufacturing and distribution sites
• Substantial report development experience utilizing SQL Server Reporting Services (SSRS), Cognos Impromptu, and Microsoft Excel. Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Assist the OM Lead in developing and reviewing performance results for Order Management processes in the region. Process improvements with customers to improve their ability to build efficient loads and streamline the order management process
• Created, enhanced and maintained Application Integration EDI maps in translation of X12 and Extensible markup Language (XML). Monitor EDI transactions daily, looking at multiple sources to identify inbound and outbound issues and failures
• Work under direct supervision to perform Supply Chain activities for assigned product portfolio to optimize inventory, minimize cost, and set and achieve customer service goals.
• Accomplished Senior IT professional with a background in business intelligence, reporting systems, data quality including ETL, and full life-cycle development.
• Provided Metrics reporting for the Central Order Management organization to ensure Organizational Level Metrics were on track and met. Conducted JAD sessions with supply chain management and development team to brain storm Point of Sale (POS) and Inventory and Order Management System (IOMS).
• Collaborated with internal and external teams to meet client business needs using the Agile/SDLC methodology and User stories. Created defect tracking using HP QC and JIRA and reviewed them in subsequent iterations of the application development process.
• Worked as a Scrum Master on the shopping cart application the B2B exchange of data & online transaction processing & Electronic Funds Transfer (EFT). Supported UAT/business testing activities using Team Foundation Server as the tool to track agile progress.
• Published daily/weekly volume projections, ran daily trackers & metrics to provide volume visibility to senior management on key supply chain performance metrics
• Create and maintain documentation for EDI processes including: mapping setup and changes, tracking trading partners by transaction sets, and EDI/ERP configuration setups
• Conducted Process mapping, Data mapping and logical data modeling, created Class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database.

Confidential, Edina, MN

Business Analyst/System Analyst

Responsibilities:

• Execute weekly POS analysis and report out to the organization with insights. Gathered requirements for the integration of POS system with the supply chain system. Followed up with reviewers, and approvers promote projects and document flow through release management deliverables
• Developed documentation for POS Systems including Corporate Policies and responsible for Business Process Management (BPM) for development of various projects.
• Experienced in data warehouses and data marts for business intelligence reporting and data mining along with developing and documenting process flows for business processes.
• Implemented Oracle Inventory to our warehouses, introducing physical inventory processes, improved shipment time, accuracy improvement for shipping product.
• Researches integration issues between Full Circle and various systems with primary responsibility on EDI Customer interfaces with suppliers and customers. Worked as an EDI Analyst and built business rules, matched them against the client specifications to create the Mapping Requirements Specification (MRS).
• Collaborate with CRM to understand opportunities and boutique active base performance. Validating Order Management System (OMS) and Customer Relationship Management (CRM) system.
• Documented the processes of Regional Distribution for the B2B and B2C System. Gathered and defined requirements from the field for the Order Management System.
• Worked with ETL teams and used Informatica Designer, Workflow Manager and Repository Manager to create source and target definition, design mappings, create repositories.
• In-depth knowledge of Relational Database, Data modeling, Data mapping, and design using UML (Unified Modeling Language), Rational Rose and Visio. Experience developing SQL queries for data mining delimited text file/excel file to SQL Server table columns.
• Participate in external forums and tool user groups looking for improvement techniques in tool deployment and development, host Learning Sessions with vendor support and contribute to the future vision of Data Supply Chain
• Extensively used test management tool like TestRail and JIRA to develop test cases, test scripts, executing the scripts and tracking the defects, Logging the defects and reporting the defect bug.
• Reviewed Stored Procedures for reports and wrote test queries against the source system (SQL Server) to match the results with the actual report against the Data mart.
• 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, Eau Claire, WI

Business System Analyst

Responsibilities:

• Analyzed Business Requirements and created Use Cases, Use Case Diagrams, Navigation Flow, Business Flow Diagrams and Work Flow Diagrams for applications and created Activity Diagrams / State Chart Diagrams using MS Visio and created conceptual model, behavior diagrams.
• Collaborate with different areas of the business and Supply Chain areas to identify and understand business needs and solutions for assigned projects.
• Worked with various e-commerce modules for electronic funds transfer, supply chain management, Internet marketing, online transaction processing, electronic data interchange EDI inventory management systems, and automated data collection systems. Conducted tech reviews for various modules for the team.
• Provided recommendation for use of ATG Commerce for B2B and B2C business and documented the processes of Regional Distribution for the B2B and B2C System.
• Helped lead the transition of Requirements Management in the Business Analyst Team to the agile methodology by creating and managing user stories.
• Explored Mercury Interactive Tools (QTP, Quality Center and Load Runner) and Rational tools (Clear Case, Clear Quest, Test Manager and Functional Tester), JIRA for Client/Server and Web-Based Applications
• Worked on Oracle Manufacturing and Supply Chain Management modules including OM, Shipping and Execution, Pricing, Inventory, and AR.
• Prepared data dictionaries and Source-Target Mapping documents to ease the ETL process and user’s understanding of the data warehouse objects. Conducted interviews with end-users to collect requirement & business process information and used TFS for requirement tracking.
• Responsible for requirements gathering, analysis, detailed process flow design, user acceptance testing and rollout of new & modified feature functionality deployed on the B2B web applications
• Executed complex SQL queries on the database and performed data analysis to audit the data being retrieved and generate reports.
• Did extensive research and analysis on Web based Point of Sale (POS) systems and presented to Executive sponsor. Implemented a successful supply chain management process within the POS group and Involved in continuous Business Requirement scrubbing to ensure the stores merchandising and POS strategies.
• Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database.

Confidential, Irving, TX

Business Analyst

Responsibilities:

• Involved with all the phases of Software Development Life Cycle (SDLC) methodologies throughout the project life cycle. Conducted JAD (Joint Application Development) Sessions and RAD (Rapid Application Development) Sessions with stakeholders.
• Implementation of an ERP warehouse and distribution systems and Worked with supply chain methodology and wholesale distribution processes.
• Provided Metrics reporting for the Central Order Management organization to ensure Organizational Level Metrics were on track and met.
• Have performed end to end WMS application support and have worked on issues across different modules of the warehouse such as receiving, returns, replenishment, waving, picking, packing, fixed pick location assignments, shipping, cycle counting, inventory balance report, inventory adjustments, emulators, printing of different types of labels such as shipping etc.
• Create and maintain documentation for EDI processes including: mapping setup and changes, tracking trading partners by transaction sets, and EDI/ERP configuration setups
• Performed Data profiling of current state of data in the Data Warehouse by doing Data Analysis using SQL Queries and Microsoft Excel, finding Gaps in Data and formulating solutions for the same.
• Provides subject matter expertise of supply chain functions/processes (Forecasting, Demand and Supply Planning, SAP, Global Distribution and Fulfilment & Order Processing)
• Helped lead the transition of Requirements Management in the Business Analyst Team to the agile methodology by creating and managing user stories and Requirements Traceability Matrices in the JIRA toolset.
• End to End testing of Telnet Mainframe application which is used as interface between Enterprise one Application Oracle DB server and other DB2 servers
• Employed SQL queries for data retrieval, data validation, investigate issues and generate reports and executed complex SQL queries to retrieve data, validate data, and build user reports.
• The Project involved implementing an Ecommerce application which deals with B2B and B2C Customers where all the At Home and Away from Home users can make purchases online
• Created and implementation of a new store order management system and the inventory system, where the Manager can order Inventory from the Warehouse. Reviewed the data model and reporting requirements for Cognos Reports with the Data warehouse/ETL and Reporting team.
• Worked in parallel on other projects: Monitored the Point of Sale (POS) software requirement specification re-write project where the tasks entailed converting the existing requirement into a new template
• Familiarity with using MS Team Foundation Server (TFS) to manage all requirements in PBIs. Performed requirements modeling and develop analysis diagrams, activity diagrams, sequence diagrams, state diagrams, data models, and use-case realizations using RUP tools in Agile.