Sr. Business System Analyst Resume
Dallas, TX
SUMMARY:
- More than 6 years of extensive experience in the field of Business Analysis and Requirements gathering in E Commerce and Web based applications.
- More than 5 years of experience in agile methodology and scrum ceremonies
- Ability to gather Business and Technical Requirements from both formal and informal sessions utilizing a variety of techniques including Interviews, JAD Sessions, Document Analysis and Interface Analysis
- Translating Business Requirements and user expectations into detailed specifications employing Unified Modeling Language (UML)
- Broad experience in writing user stories, creating business documents including Business Requirement Documents, Functional Requirement Documents, Non - Functional Requirement Documents even Technical Requirement Documents
- Worked cross functionally and interface with partners of all ranks to build process knowledge to model efforts to achieve determined goal of Omni Channel platform
- Solid experience of Visio and MS office tools for creating diagram, workflow and data mapping
- Broad understanding of Waterfall, Agile and RUP Software Development Life Cycle methods
- Experience in Quality Assurance methodologies and processes to reduce occurrence of bugs and maintain high standards of functionality.
- Experience working as Joint Application Design (JAD) facilitator and meetings coordinator
- Acquired knowledge of trade order processing from initiation to final settlement with partners
- Performed GAP Analysis to check the compatibility of the existing system infrastructure with the new business requirements and performed User Acceptance Testing (UAT)
- Working knowledge of querying and analysis database through SQL commands
- Experience in E Commerce environment with front end working, Point of Sale kiosk, multiple warehouse integration and collections
- Performed Cost Benefit Analysis for estimating monetary benefits over budgeted outlay and reporting to Project Lead decision making
- Attained better communication and developed stakeholder friendly attitude skills through meeting stakeholders, System developers, other teams and external business partners
TECHNICAL SKILLS:
Software Development Methodologies: Waterfall, Agile, RUP
Business Modeling Tools: MS Visio, MS Project, Axure
Requirement Management Tools: Microsoft Visio TFS, DOORS
Content Management System: SharePoint
Defect Tracking Tools: JIRA, MS Team Foundation Server
Operating Systems: Windows NT/XP/2000/2003/7
Databases: MS SQL Server, MS Access, Oracle
Reporting Tools: SAP Business Objects and Crystal Reports
Desktop Tools: MS Word, MS Excel, MS PowerPoint
PROFESSIONAL EXPERIENCE:
Confidential, Dallas, TX
Sr. Business System Analyst
Responsibilities:
- Acted as a liaison between the business leads, users and the ATG BCC team for e-Commerce website, order management system integration with sales order and customer service module
- Coordinated with business stakeholders and customers to write and document functional and technical user stories for E-commerce website.
- Elicited and gathered requirements using Agile and Scrum methodologies.
- Worked with the Marketing Department (MD) customers on website content asset delivery.
- Analyzed the current business processes for online order on e-commerce website and in-store pick up and analyze gap with desired business process with email and text alerts
- Integrated sales order and customer service module with the e-commerce website for front end and back end with Ignify e-Commerce support
- Gathered technical requirements for back end enhancement to support web based application within the enterprise
- Created detailed functional specification document from user stories for developers.
- Documented functional and non-functional requirements for automatic interface to trickle feed sales order data from front end to backend system
- Worked closely with the development team on functionality designing and development
- Created detailed designs displaying the data flow from front end to back end database for inventory and general ledger booking.
- Created data mapping document for XML developers to retrieve nodes, tags and values to feed in back end server
- Manually validated XML files for each transaction types to verify entity nodes, tags and values are populated.
- Discovered the business requirements and needs from the user stories elicited and obtained
- Facilitated daily standing meetings with the onsite and offsite teams and retrospective meetings at the end of sprint
- Conducted follow up weekly meeting with business leads and other functional analyst on action items
- Worked with Change Control Board for change management with gap analysis and requirement change.
- Worked on customer data migration from legacy system to Microsoft SQL Server database
- Assisted business team and back end users for testing new functionality of new inventory features on website.
- Developed the business anomalies workarounds and describe them in documentation and present the matter to the upper management for review using SharePoint.
- Created wireframe and screen mock ups with internal customers for development team
- Worked with third party developer team for online payment gateway on e-Commerce website.
- Responsible for analyzing and identifying issues with the payment gateways for securing customers’ information regarding credit/debit cards, and other mode of payment
- Executed process, End-to-End, and user Acceptance Test (UAT) test cases and logged defect in Microsoft TFS tool.
- Use Cases and other Process Flow Models were designed using Visio and Rational Rose.
- Facilitated defect triage meeting with the business leads, Quality Assurance and development team during testing phase.
- Scripted test steps in Microsoft Team Foundation Server and maintained its status.
- Collaborated with the QA team for developing scenarios for system validation and testing.
- Got involved in the User acceptance Testing (UAT) and SIT and documented the test scenarios and outcomes.
- Designed and developed various Ad hoc, Daily, Weekly, Monthly and year-end reports for the Business Analyst using SQL, Ms Excel, Ms Access and Teradata.
Environment: Agile/Scrum, MS Project, ATG BCC, MS Team Foundation Server, Ignify e-commerce, Microsoft Dynamics AX, Oracle RMS, Oracle
Confidential, Plano, TX
Ecommerce Business Analyst
Responsibilities:
- Interfaced with the client as part of the Requirements Engineering team to finalize the project scope.
- Managed the product backlog of future development tasks and project timelines as part of the agile methodology for software development also providing project estimates and frequently performed gap analysis to reduce any discrepancies when required.
- Facilitated JAD Sessions and gathered Business Requirements for Ecommerce website upgrade
- Used JAD sessions, and one-on-one meetings to identify business and System Requirements, and documented using Use Case Modeling, Process Flow diagrams and documentation.
- Facilitated workshops during the inception of the new web based application for the inventory Information.
- Conducted user interviews, gathered Requirements, analyzed the Requirements and managed changes
- Custom tools upgrade client had created marketing, merchandising, promotion and product tools to support their custom web application which needed to be re-architected to work with ATG e Commerce suite
- Developed business process models in UML to document existing and To Be process.
- Involved with all the phases of Software Development Life Cycle (SDLC) throughout the project life cycle.
- Performed extensive requirement Analysis including data analysis and gap analysis.
- Designed and developed project document templates based on SDLC methodology.
- Identified internal and external system requirements, design and configuration set-up, also created User Documentation
- Applied UML notations and methodology in developing models that accurately represent the business process reengineering and workflows and clearly communicate them to the stakeholders.
- Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, OOD using UML.
- Worked with Rational Clear quest for defect management
- Documented and delivered Functional Specification Document to the project team.
- Participated in the logical and physical design sessions, assisted and developed high and low level design documents.
- Assisted with user testing of systems, developing and maintaining quality procedures, and ensuring that appropriate documentation is in place.
- Used Pivot tables, formulas and relational tools to show the relation between the tables in Excel for the upload purposes.
- Participated in developing Web based applications using Java, JSP, J2EE, SOAP on WebLogic Application server.
- Used CSS, HTML and Javascript for GUI front end designing and validations.
- Documented requirements using Use Case (UC) analysis for the development team. Also, stored the documentation in a common SharePoint Repository for version control.
- Conducted Functional Walkthroughs, User Acceptance Testing (UAT), and supervised the development of User Manuals for customers.
- Prepared UATs, Reviewing System Test Plans and defect monitoring.
- Performed task decomposition, delegated tasks and monitored project milestones using MS Project.
Environment: Microsoft Office Suite, Unix, Windows NT/XP, Oracle, SQL Server, Sybase, Siebel, J2EE, VBScript, C#, ASP.NET, Quality Center
Confidential, Framingham, MA
Sr. Business Analyst
Responsibilities:
- Supported e-Commerce website development team with functional and non-functional business specifications.
- Analyzed current sales ordering process in brick and mortar stores to elicit the e-commerce website sale ordering process.
- Utilized Agile methodology in the implementation of the system analyzed and designed business process flow diagrams using Visio.
- Gathered business rules for customer creation and customer account management with personally identifiable information (PII) captured from online website.
- Worked on interface to automate batch processing to send sales data from online to back end inventory management system.
- Elicited business requirements through personal SME interviews, focus group interviews, workshop and Joint Application Design (JAD) Session for integrating customer related databases for Omni channel implementation
- Collected and analyzed high level business requirements and decomposed them into detail functional requirements for setting up Omni channel platform
- Draft Business Requirement Document, Functional Requirement Document; their update and version control.
- Host the application online using Microsoft SharePoint excluding some functionality those were developed to use by employees only.
- Worked with database developers to integrate the customer backend servers with different channels like retail stores, website and telephone orders.
- Conducted walkthroughs and presentation for obtaining consensus of business and technical ends
- Prepared Business models using UML such as Use Case Models, activity diagram, process flow diagram via MS Visio
- Created Graphic User Interface screens and web page for website and mobile application using Axure Pro software
- Developed Business specification diagram to understand the whole Omni channel workflow
- Managed Scope and change throughout the SDLC process of the product.
- Responsible for physical/logical data modeling; metadata documentation; user documentation
- Performed sample data analysis through SQL Query commands such as distinct, like, where, joins and update
- Worked with ATG BCC for personalization of the customer preferences and tested on the beta site.
- Collaborated with Tier Management and SME to define business rules for operations and constraints
- Executed System, Integration, End-to-End, and user Acceptance Test (UAT) test cases for customer servers.
- Performed gap analysis between the AS IS process and desired process and ascertain their impact.
- Followed up with business leads, development team and conduct action item follow up weekly meeting.
- Established traceability matrix using Rational Requisite Pro to trace completeness of requirements in different SDLC stages.
- Microsoft Office (Outlook, Word, Excel, Visio, Access) at various phases of development for documenting the requirements.
- Collaborated with the QA team for developing scenarios for system validation and testing.
- Participated in the analysis, requirements gathering, design, development (coding), testing, and implementation of Siebel solutions.
- Summarized the users’ manual guide for standard operating procedures and training
- Got involved in the User acceptance Testing (UAT) and SIT and documented the test scenarios and outcomes.
Environment: Agile/Scrum, Java, ASP .NET, MS Office Suite, UML, Axure Pro, SQL
Confidential, Milford, CT
Business Analyst
Responsibilities:
- Conducted workshops with the business community to gather web based application front and back end requirements.
- Successfully used Agile/Scrum Method for gathering requirements and facilitated user stores workshop.
- Written high-level epics and broken into functional user stories.
- Validated the written user stories with the business and prioritize in the product backlog with the product owner.
- Attended daily stand up meeting with the team and follow up with the open items
- Acted as a liaison between the business owners and technical group for clarification of needs
- Prioritized business requirements through collaborating with stakeholders and development team.
- Draft functional document for developers and to coordinate with top management for the approval process
- Created visual business models to gain process, data flow and system understanding using UML diagrams in MS Visio.
- Designed wireframes and mock up screens for mobile application using Balsamiq.
- Managed Scope and change throughout the SDLC process of the product.
- Conducted daily test team meeting to identify the bottlenecks and issue during test execution.
- Executed System, Integration, End-to-End, and user Acceptance Test (UAT) test cases.
- Conducted daily defect meeting with the business to triage the defects and assign the priority and severity levels
- Assisted development team as well as end users for testing new functionality in the POS system
- Manual test case development, automated test tools, regression testing, and performance testing
- Performed cost benefit analysis for determination of value addition and variance analysis for managing project.
- Used SharePoint to store document and version control.
- Collaborated with the Quality Assurance team for developing scenarios for validation and testing.
- Got involved in the User acceptance Testing (UAT) and SIT and documented the test scenarios and outcomes.
- 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.
Environment: Agile/ Scrum, UML, Use Case diagrams, Microsoft Visio, MS Project
Confidential, Coraopolis, PA
Business Analyst
Responsibilities:
- Worked as a Business Analyst, interviewing clients to understand their business and functional requirements, gathering their future needs and transforming them to functional specifications.
- Involved in interviewing Subject Matter Experts (SMEs) and carefully recording the requirements in a Business Requirements Document (BRD).
- Conducted daily SCRUM meetings during the Sprint Development as a part of Agile Methodology. Also captured and addressed concerns from IT to Product Management or Business Team as needed
- Documented requirements, defined scope and objectives, and formulated systems to parallel overall business strategies.
- Created Screen designs for the development team to ensure client’s requirement adequately represented.
- Performed gap analysis between the “As-Is” model of the legacy system and the “To-Be” model to identify the gaps, logged issues relating to the identified gaps and worked with the SME to get clarifications.
- Created Use Case documents and Process Flow diagrams using Microsoft Visio for all System Functionalities.
- Followed UML based methods using Rational Rose to develop Use Cases; assisted developers in creating sequence diagrams and Activity diagrams.
- Involved with regular walkthroughs and meeting to discuss bottlenecks in the system and possible solutions with the development team.
- Performed report validation writing SQL queries using TOAD on an SQL Server database.
- Prepared and maintained Requirements Traceability Matrix.
- Followed formal test plans to ensure the delivery of quality software module by performing Grey box testing.
- Created and executed test plans that improved data warehouse report quality using Word, Excel and Access.
- As a key member of the Quality Assurance, team was involved designing test plans, test cases, test results analysis and conducted reporting defect management and test status matrices.
- Tracked change requests and monitored workload and schedule.
Environment: Windows XP/7/8, MS Word, MS Excel, MS outlook, MS PowerPoint, MS Project 2010, MS Visio, Rational Rose, SQL Server, MySQL, Load Runner, Quality Center
Confidential, Dublin, CA
Business Analyst
Responsibilities:
- Conducted one to one interviews with SME to gather Business Requirements and was involved in the documentation of Business Requirement Documents.
- Assisted the Project Manager in setting realistic Project expectations and in evaluating the impact of changes on the organization and plans accordingly and conducted Project related presentations.
- Desktop application upgrade client created custom offline desktop application for their users to browse recommended products at their leisure which needed to be upgraded to work with new infrastructure, security and ATG ecommerce suite
- Identified internal and external system Requirements, design and configuration set-up.
- Developed strategic partnerships with the Business units to develop a solid knowledge base of the Business line, including the Business Plan, Products, and Process.
- Gathered requirements from the various groups through JAD sessions and user interviews.
- Conducted JAD sessions with the stakeholders, which included business presentations at regular intervals.
- Designed and developed Use Cases and UML models using Microsoft Visio.
- Use Cases and other Process Flow Models were designed using MS Visio and Rational Rose.
- Develop Business Requirement Document as well as High-Level Project Plan.
- Function as the primary liaison between the Business line, operations, and the technical areas throughout the Project Cycle.
- Develop Functional Specification Document and Supplementary Specification (non-functional) Document.
- Understand the Mapping requirements between the Siebel and legacy application.
- Designed and implemented basic SQL queries for QA Testing and Report / Data Validation.
- Collaborate with the Technical Areas in the research and resolution of System and User Acceptance Testing.
- Worked with Quality Control Teams to develop Test Plan and Test Cases.
- Developed User Manuals, and Training Manuals as per Project Specifications and timelines.
Environment: Microsoft Office Suite, MS Visio, Windows XP, PL/SQL, VB, J2EE, ASP, Crystal Reports, Adobe Photoshop, Mercury Test Director