SUMMARY

• 8+ Years of Professional Experience as Business Analyst in Retail, E - Commerce, and Supply Chain Environments.
• Good experience at B2B, B2C and Ecommerce portals web application developments and CRM.
• Expert understanding of Electronic Data Interchange EDI Process, standards, and transactions.
• Good working experience at Master Data Management (MDM), Identity data, Trade Promotions Management (TPM) and Point of Sales (POS).
• Performed Gap analysis and implemented updates for the Data Warehousing Application.
• Experience on Retail / Supply chain domain with knowledge of standard business processes like Inventory Control, Procurement & Allocation, Merchandise Planning, Returns, Warehouse & transportation management process, knowledge on POS and Assortment Planning.
• Involved in writing test plans, defining test cases, test scenarios and data sets; developed and maintained test scripts, analyzed bugs, and interacted with development team in fixing the errors.
• Reworking the user experience through improving the systems informational architecture and overhauling the application user interface usingUX/UIbest practices.
• Interacting with business SMEs, enterprise architects, developers, business intelligence, and data warehouse teams regarding project requirements explanation and interpretation.
• Experience working with Retail Oracle POS application, Payment processing (EMV).
• Expertise with Supply Chain Management (SCM), supply chain strategies/vendor manufacturing process methods to determine level of procurement and strategic sourcing strategies/plans and worked with vendors/peers to determine lead times, schedules, and cycle counts, established requirements needs.
• Extensive experience in Gathering Requirements, Scoping Requirement and creating Business Requirement Documents, User Requirement Specifications, Functional Requirement Specifications, System Requirement Specification, Test Plan, analyzing and Creating Use Cases, Use Case Diagrams, Activity diagrams, System Workflow Diagrams, Data Flow Diagrams, Business Flow Diagrams.
• Expert in documenting project plan, Business Requirements Document (BRD), Test Plans, Use Case Specifications, Functional Specifications (FSD) and Systems Requirements Specification (SRS).
• Experienced in facilitating Joint Application developments (JAD) and Joint Requirement planning sessions (JRP), End user interviews, workshops, and requirement elicitation sessions, providing production support, interacting with the business customer to resolve issues during UAT.
• Extensive experience working with FMCG (Fast-moving Consumer Goods) / CPG (Consumer Packaged Goods) clients.
• Expert in business process engineering and software development life cycle methodologies i.e., Waterfall, RUP, Agile, Scrum, and Prototype., including analysis, design, development, gap analysis testing and implementation of software applications.
• Very Good at ATG Dynamo B2B Commerce, ATG B2C Commerce, Shopping Cart, Product Catalog, Merchandizing, Droplets.
• Expert level working knowledge in different verticals and areas like Localization, Mobile-Commerce, SCM and CRM.
• Experienced with multiple WMS systems and IT technologies related to WMS systems in a high-volume retail warehouse.
• Experience in Oracle Retail Modules like RMS, REIM and RPM and has very good experience in Order Management Application Sterling WMS.
• Excellent communication skills, Interpersonal skills, interacting with team members, leadership qualities, mentoring, ability to work independently.
• Well versed in using project management tools for managing and facilitating the development process using Jira, MS Project, Visual Studio Online.

PROFESSIONAL EXPERIENCE

Confidential, Oakland, CA

Sr. Business Analyst

Responsibilities:

• Served as primary contact between retail locations and Headquarters to resolve IT POS application issues.
• Developing business requirement updates while working with different user groups to define priorities concerning project development.
• Conducted brainstorming and JAD sessions with stakeholders and end-users for requirement analysis and documented the same.
• Provide support in developing and maintaining ETL processes that extract data from multiple SOR's residing on various technology platforms then transport the data to various delivery points such as data marts or data warehouses.
• Gathered requirements for a Merchandise Assortment planning tool created for Retail Business that created worksheets of merchandise assortments that were based on location that provided retail stores laid out the detail diagrams.
• Provide daily user support of the WMS Functional modules during and post implementation.
• Determined the process and wrote unique T-SQL scripts for non-standard data imports for the Merchandising.
• Involved in developing estimates, project plans (Microsoft project), training material, BI reports using MicroStrategy.
• Performed testing on a data warehouse platform, including data integrity and data validation.
• Involved in developing business solutions through implementation of Business Requirement Gathering, Business Process Flow Analysis and Business Process Modeling by utilizingCaliberas well as Scenario Based Requirements processes (SBR).
• Used UML during requirements gathering and created Use Case Models and Use Case Diagrams for the purpose of stakeholders in the project to help them understand the workflow of the system associated with the requirements.
• Updated and remediate existing Business Intelligence scripts and Teradata applications to reflect changing business data requirements.
• Determined merchandise needs for store locations and created and completed corresponding purchase orders.
• Analyzed, coordinated, documented, and managed project requirements, project processes and procedures and its changes throughout the software development lifecycle.
• Performed Requirements Analysis and traceability using Test Director and MS Word.
• Involved in developing prototypes to demonstrate the newUIfor stakeholders.
• Involved in writing test plans, defining test cases, test scenarios and data sets.
• Created and segregated SQL views and stored procedures for obtaining meaningful set of data.
• Involved in developing and maintaining test scripts, analyzed bugs, and interacted with development team in fixing the errors.
• Worked with Subject Matter Experts (SME), project team members (business and technical), to define technology application for the business and system requirements.
• Also worked with the QA Team Lead to develop QA standards and ensured compliance with all regulatory requirements.
• Involved in developing several MS Excel spreadsheets and applications to automate manual calculations and optimize reporting structure.
• Extensively used MS Project for status reporting and planning throughout the project lifecycle.
• Conducted Joint Application Development (JAD) sessions with IT groups. Identified the Key Changes and participated in Stakeholder Management to communicate effectively with them.
• Created Mock-up forms in MS word for better visualization and understanding of the software solution. Tracked change requests and monitored workload and schedule.

Confidential - Andover, MA

Sr. Business Analyst

Responsibilities:

• Analyzedbusinessfunctions to define specifications/requirements for automating and improvingbusinessprocesses.
• Gathered detail level business requirements through open-ended discussions, brainstorming sessions, and requirement workshop.
• Involved in developing several detail and summary reports including line and pie charts, trend analysis reports and sub reports according tobusinessrequirements.
• Prepared Mapping documents to map various interfaces.
• Analyzed B2C and B2B web properties and create newbusinessplan,businessrequirements, and staffing requirements.
• Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database.
• Gathered requirements for both B2B and B2C parts of the project.
• Performed Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data.
• Support major effort to improve the Warehouse Management System (WMS) capabilities of Supply Chain.
• Performing end to end system testing of the customized ATG BCC tool. Preparation and execution of business scenarios to validate the implementation of the ATG ecommerce suite.
• Analysis of the workflows and use cases demonstrated by the third-party vendors as part of the vendor selection.
• Involved in creatingbusinessprocesses and modeling diagrams using MS Visio.
• Created Mock-up forms in MS Excel for better visualization and understanding of the software solution.
• Tracked change requests and monitored workload and schedule.
• Facilitated JAD sessions with management, development team, users, and other stakeholders to refine functional requirements.
• Worked with Business to suggest different configuration in DOM (Manhattan Distributed Order Management) with POS / WMS (Manhattan Warehouse Management System) for handling orders better and increase sale and better customer experience.
• Used SQL, Data Warehousing and Data Cleansing for the arrangement of customer data. Used Data mapping for collecting the data.
• Support WMS users in their daily business solutions including system training and production issue troubleshooting.
• Documented the processes of Regional Distribution for the B2B and B2C System.
• Scheduled meetings with developers, System Analysts, and testers to collaborate resource allocation and project completion.
• Authored progress and completion report which were then submitted to project management on a weekly basis.
• Analyzed and triaged defects for System Integration Testing and end-to-end testing.
• Assisted Testing Team on preparing the test cases and expected results for System Testing and Unit Integration Testing.
• Consolidated the meeting minutes and the open issues tracker.
• Expertise in developing various interfaces and Reports using AS400 technology across different modules like Picking, Packing, and shipping modules of WMS and Order Management module for Retail domain.
• Maintained and kept track ofbusinessrequests for enhancements and changes.
• Verified the functional aspect as per theBusinessProcess and validated the interfaces with the other systems and data conversion from the legacy system.
• Uploaded documents produced onto SharePoint, an intranet website for all Technology Information Group members to download, revise and upload shared documents.
• Custom tools upgrade client had created marketing, merchandising product tools to support their custom web application which needed to be re-architected to work with ATGs ecommerce suite.
• Created and managed project templates, use case templates, requirement types and tractability matrix in Requisite Pro.
• Used MS Visio for Process modeling, Process mapping and Business Process flow diagrams.

Confidential, Stratham, NH

Business Analyst

Responsibilities:

• Involved in Inception Phase and prepared vision statement and initial data models that contain Business Requirement Documents and supporting documents that contain the essential business elements and detailed definitions.
• Performed the requirement analysis and documented the requirements using Rational Requisite Pro.
• Co-authored business requirements document with project teams. Extracted, discussed, and refined business requirements from business users and team members.
• Interacted with the business users in knowing the business views and gathered the reporting requirements to design the universes and business objects.
• Scheduled and maintained web analytics source data and provided UI reports using Omniture Site Catalyst.
• Develop and maintain sales reporting using in MS Excel queries, SQL in Teradata, and MS Access. Produce performance reports and implement changes for improved reporting.
• As part of CRM Activities, gathered client data, managed, tracked, and analyzed this data to improve customer relationships and targeted marketing campaigns and pricing along with Marketing Team.
• Experienced in testing product qualification testing in point of sale (POS) application.
• Worked with Data Warehouse in the development and execution of data conversion, data cleaning and standardization strategies and plans as several small tables are combined into one single data repository system MDM (Master Data Management).
• Strong understanding of Data mining techniques with knowledge in end-to-end data reconciliation, SQL, PL\SQL, Oracle\ETL environments.
• Used Rational Tools for creating use cases, version control and defect tracking, monitoring. Used Rational Unified Process (RUP) methodology in all areas of the software development life cycle.
• Helped design data warehouse solutions and business intelligence dashboards and scorecards.
• Worked with information architects and creative groups in detailing the wireframes and depicting GUI design.
• Planned and defined Use Cases created Use Case diagrams, Scenarios and Use Case Narratives using the UML methodologies.
• Participate in Development Solution in regard to Interwoven TeamSite related design and implementation concepts.
• Analyzed company specific data - Production amounts, forecasting and demand planning, inventory stocking at wholesaler & distributor, inventory turns per SKU, retail outlet coverage region-wise, merchandising & tax costs.
• Involved with multiple project teams of technical professionals through all phases of the SDLC using technologies including Oracle, Erwin, DataStage, Data Warehousing, WebSphere, and Cognos.
• Involved in developing E-Business Suite programs for databases supporting supply chain management, order management, inventory, warehouse management system, purchasing, and iProcurement.
• Reviewed the data model and reporting requirements for Cognos Reports with the Data warehouse/ETL and Reporting team.
• Coordinate testing efforts across multiple JDA supply chain and retail applications includingallocations and replenishment.
• Used MS SharePoint for the purpose of managing documents and for hosting websites which was used to access shared workspaces and documents.

Confidential, Andover, MA

Business Analyst

Responsibilities:

• Function as the main conduit between the IT development group and the operation’sbusiness managers and users to help prioritize requirements and optimize resources.
• Included numerous trips and conference calls to gather requirements, identify issues and gaps, prepare training documents, train superusers, provide go-live and follow up support as needed.
• ComposeBusinessRequirements Documents andBusinessFunctional Specification Documents routinely as new requirements are presented.
• Engaged in Requirement gathering (BRD), Solution Design (Process Documents) for Inventory, Costing, Quality,WIP&BOMmodules.
• Developed dozens of test plans for implementing new system functionality.
• Extensive working knowledge of Oracle 11.5.9 in Purchasing, Planning, Inventory, Bills of Material & Manufacturingas a user, as a trainer and as a change advocate.
• As a user, focus on data conversion validation and training co-workers on daily activities.
• As a change advocate, deal with training, managing sections of the data conversion and various project checkpoints (Conference Room Pilots, User Acceptance Testing, Go-Live and Post Go-Live support).
• Worked with Data Warehouse in the development and execution of data conversion, data cleaning and standardization strategies and plans as several small tables are combined into one single data repository system MDM (Master Data Management).
• Involved in designing, training, and implementing an automatically distributed supplier forecast.
• Enables buyers, managers, and suppliers to quickly access the continually changing requirements.
• Consolidated reports from 8 company sites to now have a single face to the supply base.
• Spearheaded the implementation of Oracle I Supplier which allows the purchasing group to seamlessly communicate purchase order requirements with the supply base.
• When a reoccurring issue is revealed, I proactively investigate the size, scope, and audience to understand what the best course of action is.
• Routinely participate in GAP analysis efforts and new software assessments.
• Work with Operation's management team to prioritize issues and identify future improvement opportunities.
• Periodically engagebusinessusers to identify pain points and other opportunities for enhancements.
• As additional sites were migrated to Oracle, I helped identify that transitioning from MRP to DRP, along with setting up inter-company sourcing rules which has enabled supply and demand signals to be distributed across organizations instantaneously.
• Involved in developing functional spec for outbound interface to the transfer intercompany billing documents to AS400 system.
• Conduct training classes for a broader audience such as non-inventory requisition training as well as very specific training classes directed at buyers, planners, ormanufacturingengineers.
• Project lead for implementing online requisition and purchase order approvals which included defining the requirements with the management team, developing the solution, performing the setups in a test environment, running user acceptance testing sessions, writing the training documentation, and successfully implementing the system.
• Improved inter-company ordering and fulfillment processes across organizations on Oracle by setting up various sub inventories for Min-Max planning and using inter-location transit times and shipping networks to accommodate for in transit time between internal and/or external locations.

Confidential- Columbus, OH

Business Analyst

Responsibilities:

• Interfaced with the client as part of the Requirements Engineering team to finalize the project scope.
• Used SDLC (System Development Life Cycle) methodologies like the RUP and the waterfall.
• Use Cases and other Process Flow Models were designed using Visio and Rational Rose.
• Partnering with Hybris, an industry leader with expertise in both B2B and B2C ecommerce.
• Assisted the PM in developing Use Cases and project plans and managed changes to the scope of the project.
• Custom tools upgrade client had created marketing, merchandising product tools to support their custom web application which needed to be re-architected to work with ATGs eCommerce suite.
• Functioned as the primary liaison between the business line, operations, and the technical areas throughout the project life cycle.
• Used Unified Modeling Language (UML) for process modeling and use cases.
• Prepared user training manual for merchandising team on managing commerce assets through ATG BCC (Business Control Centre).
• Software Development Life Cycle documentation SDLC (testing, technical and functional documents)
• Conducted user interviews, gathered Requirements, analyzed the Requirements, and managed changes using Rational Suite.
• Interfaced between Business new product builders and System platform builders.
• Worked with systems area to translate business needs into system requirements.
• Assisted QA team in performing Unit testing, System Integration Testing (SIT), End to End testing (E2E) and User Acceptance Testing (UAT).
• Experience working as Joint Application Development (JAD) facilitator and meetings coordinator with excellent interpersonal skills.
• Made sure the test cases and test process guarantee accountability to business and systems requirements.
• Involved in all phases of the SDLC, SQL, Agile, perform UAT testing. Understand, translate, communicate business requirements into detailed technical system specifications, develop use cases.
• Conducted review sessions on regular basis with QA and development teams for preparing status, delivery report and client reporting.
• Conducted interviews with end-users to collect requirement and business process information.