SUMMARY:

• Over all 7+ years of professional experience as a Business Analyst with Retail environment.
• Extensive knowledge of all phases of the software development life cycle (SDLC) and the iterative Rational Unified Process (RUP).
• Organized many Joint Application Developments (JAD) sessions and Joint Requirement Planning sessions (JRP), walkthrough, Interviews, Workshops and Rapid Application Development (RAD) sessions with end - user/clients/stake holders and the IT group.
• Extensive experience in the Retail and with knowledge of sales order management, retail operations, order fulfillment
• Experienced in Develop, maintain and execute Salesforce test cases (functional and regression) as per the test plan.
• Design and review of various documents including the Software Requirement Specifications (SRS), including USE Cases, Business requirements document (BRD), Use Case Specifications, Functional Specifications (FSD), Systems Design Specification (SDS), Requirement Traceability Matrix (RTM) and testing documents.
• Process documenting using Microsoft Visio, Excel, SharePoint, and Word documents. Experienced working on POS (Point of Sale) and involved in performing all POS activities.
• Experience in development methodologies like RUP, SDLC, AGILE, SCRUM and Waterfall.
• Well-versed in project management tool (MS Project) for status reporting, planning and resource allocation.
• Expertise in Analysis of Problem Severity, Defect tracking and reporting system.

TECHNICAL SKILLS:

Business Tools: Rational Suite (Requisite Pro, Rose, Clear Quest, Clear Case), MS Visio, MS Project, MS Access, MS Office Suite, Visual Paradigm, Doors Erwin Data Modeler 4x, Business Object (Crystal Reports)

Business Skills: Business Definition Requirements, Business Process Analysis, Gap Analysis, Use Case Modeling & Analysis, Business Environment and Market Research Analysis

Methodologies: RUP, AGILE, UML & Business/Data Modeling

Testing Tools: Win Runner, Load Runner, Test Director, Quick Test Pro, PR Tracker

Operating Systems: Windows XP/95/98/NT/2000, UNIX, Linux

Content Management Tools: Documentum, SharePoint.

PROFESSIONAL EXPERIENCE:

Confidential, Springfield, MO

Business Analyst

Responsibilities:

• Conducted user interviews, gathered requirements, analyzed the requirements using RUP methodology and documented the requirements using Rational Requisite Pro.
• Developed function specifications for modifications of POS system for multiple chains. Included integrating new chain into existing systems which encompassed, gap analysis, specific brand requirements and full POS integration.
• Extensively interacted with clients to understand their technical and business requirements to ensure highest level of customer satisfaction.
• Responsible for all web development, E-commerce and optimization and web strategy and corporate website and self-service intranet site.
• Responsible for testing Business Requirement Specifications, to capture functionalities at all E-Commerce touch points.
• The project was on a Point-of-Sale (POS) application developed by company, has a feature-rich POS system that supports Java POS technology, the industry standard for retail peripherals.
• Extensive experience working with vendor e-commerce tools like Microsoft commerce as well as helping construct and integrate in-house ecommerce applications.
• Responsible for requirements gathering, analysis, detailed process flow design, user acceptance testing and rollout of new & modified feature functionality deployed on the E-commerce website applications.
• Actively participated in all the stages of the Project Life Cycle and was extensively involved in all dimensions of UAT, Functionality, Usability, Reliability and Performance testing.
• The project also covered an Order Management System (E-Commerce App) that was part of the supply chain and Data Warehouse Inventory System which plans, implements and controls the efficient, effective forward and reverse flow and storage of goods, services and related information between the point of origin and the point of consumption in order to meet customers' requirements.
• The system includes an e-commerce as well as online procurement (supply chain management).
• Built data mapping document, mapping data market and data from various external data sources to database, via set of business rules and assisted ETL team in setting-up data integration process.
• Identified and documented the gaps in the Existing Business Rules of the FRY 14M/Q attributes and tracked them via Application Lifecycle Management ALM.
• To participate in the full lifecycle of ecommerce engagement to deliver a complex, comprehensive business solution for B2B ecommerce
• Documented the processes of Regional Distribution for the B2B and B2C System. Gathered and defined requirements from the field for the Order Management System.
• Expertise in Bug tracking using Bug tracking Tools such as HP ALM/Quality Center, JIRA and Bugzilla.
• Gathered Functional and Data Requirements, analyzed workflows and created Use Cases, Requirement Specifications, Report Specifications, Data Requirements, Data Mappings and Data Flow Diagrams.
• Utilized corporation developed Agile SDLC methodology. Used Scrum Work Pro and Microsoft Office software to perform required job functions.
• Cultivate Agile Scrum methodology principles with a development team in transitioning from a Waterfall to an Agile SDLC environment.
• Prepared test Data sets and performed data testing using the PL/SQL scripts. Also used MS excel for data mining, data cleansing, data mapping, and data dictionary and data analysis.
• 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.
• Substantial report development experience utilizing SQL Server Reporting Services (SSRS), Cognos Impromptu, and Microsoft Excel.
• Strong business analysis skills are critical to success in this role, with emphasis on business process analysis, and the application of EDI to alleviate workload, increase accuracy, improve reliability and automate functions where applicable
• Extensive knowledge of EDI transaction sets used in a distribution business, their function, development, implementation and communications.
• Work with the team leads, collaboratively using JIRA, to help prioritize stories, tasks and their dependencies to ensure a smooth agile process.
• Involved in mentoring specific projects in application of the new SDLC based on the Agile Unified Process, especially from the project management, requirements and architecture perspectives
• Well-versed with leading industry tools like Jira, Version1, Caliber, MS Visio, MS Word, MS Excel and MS PowerPoint to develop various project deliverables
• Working on Lifecycle, Create and follow up on JIRA tickets for the change requests received from various business partners. Test them in prestige and test to validate and bring them to closure.
• Build Platform features, user stories, and maintain backlog with priorities, using Rally and JIRA platforms; Drive HLD, Low Level, and Integration (SOAP, REST, JSON, XML 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.
• Established strong retail network starting at initial dealer contact to implementation of sales and service programs.
• Utilized corporation developed Agile SDLC methodology. Used Scrum Work Pro and Microsoft Office software to perform required job functions.
• Created Process Flow diagrams, Use Case Diagrams, Class Diagrams and Interaction Diagrams using Microsoft Visio and Rational Rose.
• Cultivate Agile Scrum methodology principles with a development team in transitioning from a Waterfall to an Agile SDLC environment.
• Created and implementation of a new store order management system and the inventory system, where the Manager can order Inventory from the Warehouse.

Environment: Rational Suite (Rose, Requisite Pro), PL/SQL,HTTP, MS-Project, MS-Office Suite, SharePoint, MS Visio, Win Runner, Load Runner, JavaScript, UAT, Agile, Scrum,POS.

Confidential, Deerfield, IL

Business Analyst

Responsibilities:

• Worked closely with project managers, technical leads, information architects, and mobile app developer team, and Scrum master.
• Organized and facilitated JAD sessions and elicited high-level business requirements from business owners and stakeholders.
• Documented business requirements for management of retail, clearance and promotional prices; plus item setup and maintenance.
• Extensively used MS SharePoint a content management platform, for managing content across the organization within a shared repository.
• Gathered requirements for the integration of POS system with the supply chain system.
• Organized and coordinated with external data vendors to map market and data onto project database along with set of business rules throughout the project life cycle by creating data mapping document.
• Worked on developing data mapping which mapped data from various sources to targets within the application assisted ETL team to integrate source and target data in the data warehouse.
• Was involved in implementing a successful supply chain management process within the POS group.
• Implemented a successful supply chain management process within the POS group (inventory control, purchasing, receiving and transferring of products to and from other locations).
• Provided recommendation for use of ATG Commerce for B2B and B2C business. Created metrics reports using Adobe Omniture, Google AdWords, and a number of different Marketing Affiliate sites.
• Provided recommendation for use of ATG Commerce for B2B and B2C business.
• 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
• Performed audit of key business reports and assessed the impacts of the e-commerce channel to existing business reporting
• The solution supports an unlimited number of product catalogs enabling the population of several Websites from the unified inventory control or allowing customers to browse specific groupings of product based on their profile or ps.
• Designed and implemented ERP business processes and custom transactions for manufacturing and inventory management systems.
• Work closely with the team during the Agile sprint planning, facilitate daily stand up (scrum) meetings .
• Execution of the WCAG Test cases in ALM and escalation and coordination of the logged encountered defects with development team for all high, medium and low priority defect resolution.
• Used ALM to manage and create defects, analyze, log, and prioritize defects monitor defect fixes, maintain defect log, periodic status update.
• Strong understanding of project life cycle and SDLC methodologies including RUP, RAD, Waterfall and Agile.
• Performed requirements modeling and develop analysis diagrams, activity diagrams, sequence diagrams, state diagrams, data models, and use-case realizations using RUP tools in Agile.
• Worked as a part of scrum team, in an agile methodology with sprint cycles, daily stand ups and story implementation. Large cross functional project and support teams.
• 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.
• Executed complex SQL queries on the database and performed data analysis to audit the data being retrieved and generate reports.
• Performed Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data.
• Used SQL to ensure updates were being made in backend, as and when records were being entered in the new POS application.
• 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.
• Producing Business Requirements Documentation in JIRA/Confluence as well as Use Cases, Process Flow Documentation
• Analyzed POS, historical trends and customer inventory to provide an accurate demand and replenishment forecast.
• Created Physical Inventory process for retail stores, consisted of data integration and inventory processes with third party vendor.
• Extensive testing is carried out in the integrated systems: ATG for E-Commerce, Sterling Commerce for Order Management Systems and IBM Web-Sphere Message Broker for Integration catering to multiple channels like Sam's Clubs, Sam's Auctions- using e-Bay.
• Analyzed impacts from front end systems such as E-Commerce, Commerce Manager and POS to Databases and Reporting Tools.
• Understand, document and update business process flows for all interfaces and transactions including EDI document transactions
• Set up and monitor a national e-commerce and web shop customer support process for Rexel USA, including processes to answer requests by chat, email, phone around web shop, EDI, punch-out catalog integration, and customer catalogs
• Extensive experience in designing, developing, and implementing innovative business process and system solutions based on E-commerce application.
• Strong understanding of project life cycle and SDLC methodologies including RUP, RAD, Waterfall and Agile.
• Documented business requirements for management of retail, clearance and promotional prices; plus item setup and maintenance.
• Created Use Cases diagram and Activity diagram to depict the interaction between the various actors and the system in Rational Rose for the Business Use Case and System Use Case.
• Participated in the bug review meetings, updated requirement document as per business user feedback and changes in the functionality of the application.

Environment: Rational Suite (Rose, Requisite Pro), Agile, Scrum, Rational Unified Process (RUP), Windows XP, UML, UNIX, MS-Project, MS-Office Suite, MS Visio, Mercury, JavaScript, Win Runner, Test Director

Confidential, Tampa FL

Business Analyst

Responsibilities:

• Involved in business analysis and project management, coordinating between the team members, addressing scope issues
• Interfaced with the client as part of the Requirements Engineering team to finalize the project scope.
• Worked with the project manager for planning and organizing the project activities, and in communicating with other business center mangers and stakeholders of the project.
• Analyzed current business process to find gaps & weakness in the various business processes of content management& designed workflows.
• Created Process Work Flows, Functional Specifications, and responsible for preparing Software Requirement Specifications (SRS), Functional Specification Document (FSD).
• Involved in continuous Business Requirement scrubbing to ensure the stores merchandising and POS strategies.
• Created and maintained weekly/monthly/YTD POS reports, in-stock/inventory reports to develop strategic relationship with the account
• Maintained records and statistical information for E-Commerce managers, E-Commerce personnel, other departments and outside vendors.
• Analyze B2C and B2B web properties and create new business plan, business requirements, and staffing requirements.
• Extensive experience with Business-to-consumer B2C sales of tangible goods/online services and Business-to-business B2B scenarios, such as e-procurement.
• Coordinated with external data vendors like Bloomberg / Reuters to map market and data onto project database along with set of business rules, created data mapping document and assisted ETL team to setup the data load process in data warehouse
• Documented Business Requirements Document, Technical Specifications Documents, and data mapping documents.
• Defined sources & target systems for reporting system, performed data mapping from to database to meeting sales requirements.
• Responsible for all web development, E-commerce and optimization and web strategy and corporate website and self-service intranet site.
• Monitoring of the Test case executions and Traceability of all the critical project requirements using the HP Quality Center-11.0 ALM. Coordination for the defect tracking for the resolution of all the critical high/Medium and low encountered defects with the development team.
• Single point of contact for Business to approach for administrative JIRA related issues, example: access, report of open issues etc.
• Developed Test Cases and prepared test scripts using SQL to test transformation logic in the data.
• Performed Data Analysis and Data Validation by writing complex SQL queries using SQL Assistant.
• Write SQL queries and review view code delivered by the offshore development team.
• Working experience in SQL including writing complex queries and stored procedures for data manipulation, application development, and researching data issues.
• Employed simple and complex SQL queries for data retrieval, data validation, investigate issues and generate reports and created comprehensive profiling artifacts for presenting to Business Users.
• Create and maintain documentation for EDI processes including: mapping setup and changes, tracking trading partners by transaction sets, and EDI.
• Researches integration issues between Full Circle and various systems with primary responsibility on EDI Customer interfaces with suppliers and customers
• Translate high-level business requirements on multiple, complex reporting requests into detailed functional and technical specifications. Responsible for maintaining requirements queue in JIRA.
• Serve as a point of contact for the client’s stakeholders and provided customer support in addition to team building with on and off shore agile teams.
• Create story board of back log items in Agile and develop item according to business needs.
• Assisted QA team by reviewing test cases and clarifying requirements to ensure complete coverage of requirements, worked in agile environment and was able to bring projects to completion.
• Support for an 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.
• 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.
• Developed a project plan for the entire implementation of the new system using case models to depict the system functionality & create application for Supply Chain Planning, Inventory Planning, Performance Management and Reporting & Analysis.
• Responsible for testing Business Requirement Specifications, to capture functionalities at all E-Commerce touch points.

Environment: Microsoft Office Suite, SharePoint, Adobe Photoshop and Quality Center

Confidential, Chicago, IL

Business Analyst/QA Analyst

Responsibilities:

• Responsible for gathering user requirements and specifications for designing a mortgage based loan system using and documenting the same.
• Created context and workflow models, information and business rule models, Use Case and Object Models during the analysis using rational tools.
• Extensively involved in maintaining requirements traceability and communicating any changes to these requirements to different business groups and programmers.
• Collaborated on creation of documents such as the Vision, business requirements (BR) and business systems design (BSD) documents
• Performed audit of key business reports and assessed the impacts of the e-commerce channel to existing business reporting
• Extensive testing is carried out in the integrated systems: ATG for E-Commerce, Sterling Commerce for Order Management Systems and IBM Web-Sphere Message Broker for Integration catering to multiple channels like Sam's Clubs, Sam's Auctions- using e-Bay.
• Responsible for writing detailed descriptions of user needs, program functions, and steps required for developing or modifying software programs using Rational Rose (UML).
• Worked with multiple vendors nationwide for POS consumable purchases as well as for hardware & equipment for 39 locations nationwide.
• Actively interacted with different business groups to perform Gap analysis to identify the deficiencies in the system by comparing the actual objectives with the system objectives desired.
• Oversaw implementation and of Omniture's Site Catalyst and Test Target on the new B2C site.
• Experience in B2B, B2C and Ecommerce portals web application developments.
• Extensive experience in Strategic development of a Data Warehouse and in Performing Data Analysis and Data Mapping from an Operational Data Store to an Enterprise Data Warehouse.
• Extensive experience in conducting Market Research, Feasibility Studies, Data Analyses, Data Mapping Gap Analyses, Risk Identification, Risk Assessment, Risks Analyses, and Risk management.
• Analyzed the business and functional requirements of the application and developed detailed test plans, test cases in Test Director.
• Worked in Agile environment allowing teams to deliver project piece-by-piece and make rapid adjustments as needed. Good understanding working in Agile and bringing projects to completion.
• Involved in the Agile Backlog Grooming Session and Prioritized Stories according to the users prospective used Version One.
• Designed the business requirement collection approach based on the project scope, Created Business Analysis using agile methodology.
• Developed the UAT scripts with different multiple scenarios for the UAT validation of the J-System Audit Project requirements and logging and tracking of the defects encountered using HP-ALM.
• Designed and implemented SQL queries using joins, unions, outer joins, group by and aggregate functions to extract data from different databases (Oracle, SQL Server) for timely reporting and Validation.
• Experience in database design, modeling, development and maintenance including creating ETL procedures using tools like Informatica, Ab Initio, Data Stage, SQL Loader
• Experience in integrating databases in Client/Server applications with Oracle and SQL Server as the backend and in writing stored procedures, functions, views, database triggers
• Querying various databases using PL/SQL and Toad for various requests from clients
• Developed PL/SQL procedures for creating/dropping of table and indexes of performance for pre and post session management
• Monitor EDI transactions daily, looking at multiple sources to identify inbound and outbound issues and failures
• 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.
• Expertise in functions like E-commerce Merchandising, Store operations, Supply Chain Inventory, Warehouse Management, POS and Content management
• Work with the team leads, collaboratively using JIRA, to help prioritize stories, tasks and their dependencies to ensure a smooth agile process
• Review JIRA ticketing intake system and update email notifications (for updates and new tickets) and make sure that new tickets get assigned to a resource and existing ones are actioned on.
• Knowledge in utilities like E-commerce Merchandising, Store operations, Supply Chain Inventory, Warehouse Management, POS and Content management.
• Acquisition Operations will be responsible for analyzing many areas of the business, including but not limited to: receipts routing, planning, receiving, buying, shipping, inventory management, grading, item number creation and purchase order management
• The ERP system ties together different aspects of the website including inventory management, customer accounts, shopping cart, credit card processing and other ecommerce functionalities.
• The project involved creating a centralized product tracking/ Inventory management solution used for order processing, accurate deliveries, controlling inventory, performing audits, maintaining cylinder history records, maintaining accurate billing records and report generation.
• Created Physical Inventory process for retail stores, consisted of data integration and inventory processes with third party vendor

Environment: Rational Rose, Rational Req Pro, RUP, WinRunner, LoadRunner, TFS, Crystal Reports, SDLC, MSOffice2000, SQL, SQL Server, .NET