SUMMARY

• Business/Quality Analyst with over 7+ years industry experience in business data modelling, software requirement analysis, process modelling, process flow and quality assurance skills using different methodologies, mainly OOA, OOAD and UML
• Extensive knowledge of all phases of the software development life cycle (SDLC) and the iterative Rational Unified Process (RUP)
• Good understanding of Store Warehouse Inventory Movement (SWIM),Store returns (RTI ),check in, chech out, Adjust in, Adjust Out.,Transfer IN,Transfer OUT
• Experienced in manual and automated testing for both front - end and backend. Extensively used automated test tools of Mercury like Quality Center, Quick Test Pro, Win Runner, Test Director, Performance and Load Runner Testing.
• Expertise in the use of tools such as Caliber RM, Rational Rose, Requisite Pro, Starteam, Test Director
• Proficient in using UML in behavioural, structural and architectural modelling - in creating Use Case, State, Activity, and Class and Sequence diagrams using Rational Rose.
• Strong experience in conducting User Acceptance Testing (UAT) and documentation of Test Cases. Expertise in designing and developing Test Plans and Test Scripts.
• Used Microsoft Visio for Business Process Modelling and Data flow diagrams.
• Worked with Rational Suite of tools to create requirements documents (Requisite Pro), visual data models (Rose), manage and track defects (Clear Quest).
• Experience in development methodologies like RUP, SDLC, AGILE, SCRUM and Waterfall
• Experience in conducting GAP analysis, User Acceptance Testing (UAT). SWOT analysis, Cost benefit analysis and ROI analysis..
• Successful as a team player to work in conjunction with other DBA’s, testers, developers and other team members in validation and testing complex scenarios and projects and in the maintenance of Quality Standards in Projects especially with Test Director.
• Expertise in Analysis of Problem Severity, Defect tracking and reporting system.
• Strong communication, problem solving, organizational, interpersonal, and presentation skills.

TECHNICAL SKILLS

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

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

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

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

Operating Systems: Windows XP/95/98/NT/2000, Mac OS X, DOS, UNIX, Linux

Databases: Oracle 8i/9i; SQL Server 7.0 & 2000; Access 2000, MS SQL Server, DB2

Languages: UML, C, C++, HTML, Java, SQL, PL/SQL, ASP.NET

PROFESSIONAL EXPERIENCE

Confidential, Katy, TX

Sr Business Analyst/QA Analyst

Responsibilities:

• Performed Requirement Analysis by gathering both functional and non functional requirements based on interactions with the process owners & stake holders and document analysis, represented them in Requirements Traceability Matrix (RTM).
• Created workflow scenarios, designed new process flows and documented the Business Process and various Business Scenarios and activities of the Business from the conceptual to procedural level.
• Came up with test cases from the requirements, validated/exercised those test cases in form of integration and regression tests. Used Test Director to map the requirements with test cases (automated/manual), used QTP for automated testing.
• Transformed Business requirements into functional specifications, focused on user interface design, created mockup screens.
• Manually verified the validity of the failed test cases. Performed Positive, Negative and Black box testing on the application
• Analyzed and translated business requirements into system specifications utilizing UML and RUP methodology
• Clarified QA team issues and reviewed test plans and test scripts developed by QA team to make sure that all requirements will be covered in scripts and tested properly.
• Analysed the business and functional requirements of the application and developed detailed test plans, test cases in Test Director.
• Used SQL and MS Excel using macros for all Data validation based on the Business Rules.
• Developed Test cases for manual testing and automated them using Win Runner, Silk, Load Runner, Silk performer and QTP.
• Involved in a module to track the sales, material inventory, Warehouse inventory, Counter sales maintenance, daily cash and bank reconciliation for the client
• Interacted with business partners to perform the Initial Project Analysis define new and document retail sales reporting requirements and Change Requests (CRs) in Borland CaliberRM.
• Created Process Flow diagrams, Use Case Diagrams, Class Diagrams and Interaction Diagrams using Microsoft Visio and Rational Rose.
• Involved in migrating the data from the current legacy system to the ORMS.
• Developed Process modeling, entity diagrams, data modeling, data mapping and business process flow diagram.
• Provided clear and concise documentation regarding requirements management plans, Functional Requirements, supplemental Requirements, Test Plans and Test Cases.
• Used Test Director and Mercury Quality Center for updating the status of all the Test Cases & Test Scripts that are executed during testing process.
• Conducted UAT to confirm that all derivative products can be successfully processed through stages of the trade life cycle
• Designed the System Flow, Data Flow diagrams, using these as the base to obtain requirements and wrote Use Cases.
• Create and maintain requirements, test cases and defects in Mercury Quality Center
• Designed and implemented basic SQL queries for QA testing and report / data validation.
• Created DTS Packages for migration of data between MS SQL Server database and other databases like MS Access, MS Excel and Flat Files.
• Prepared Business Context Diagram, Use Case diagrams and corresponding Activity Diagrams using Rational Rose to depict the workflows to be incorporated into the development of Pega Business Process Management (BPM) tool.
• Performed requirements modeling and develop analysis diagrams, activity diagrams, sequence diagrams, state diagrams, data models, and use-case realizations using RUP tools in Agile.
• Queried database using SQL for backend testing
• Involved with the QA team to conceptualize, determine and develop test approaches and methods for unit testing, integration and functional testing, load and usability testing according to the application complexity and test requirements.
• Created current and future state processes, along with prototype BPM solution at medical device company
• Coordinated defects routing in the team and created Excel macros to generate daily defects report status from Quality center across multiple teams.
• Took lead role in migrating pages and data from old intranet to newSharePointplatform

Environment: Oracle 8x/9i, MS Project, MS Office Suite, RUP, UML, Rational Rose, Requisite Pro, Clear Case 2002, Rational Clear Quest 2002, MS office suite, MS Access, CaliberRM, MS Visio 2003, SharePoint, Mercury LoadRunner, Mercury Testdirector

Confidential, Salt Lake City, UT

Business Analyst/QA Analyst

Responsibilities:

• Performed extensive data modeling to differentiate between the OLTP and Data Warehouse data models
• Wrote Test Plans in MS Word for Manual Testing, System Testing, Integration Testing, Performance Testing, Regression Testing & reviewed their consistency with the business requirements.
• Implementing Oracles Retail Management System (ORMS) in order to provide a streamlined solution for performing an end to end process of creating a Purchase Order by buyers to Offshore Vendors.
• Created Functional Unit/String test cases for Order Management, Warehouse & Inventory Mgmt, and Planning & Procurement.
• Gathered requirements, organized team meetings requirements from business users such as insurance policy managers, generated business process models, & use-case models, and created business requirements document (BRD) & functional requirements document (FRD).
• Participated in UAT and worked with Mercury Quality Center for bug and defect tracking.
• Worked with SME’s in Europe, to finalize the layout of the new Work-flow diagram. Also, the design (wire frames) was re-formulated.
• Planned and documented procedures for data processing and prepared data flow diagrams for the application.
• Involved in development & documentation of Software Requirements Specification (SRS) using Borland Caliber RM.
• Developed entity diagrams, data interface mapping to map all the possible inputs and outputs.
• Wrote Test Cases in MS Excel for user registration, access to material, and activity log-in, reviewed the test cases and finalized
• Gathered requirements and modeled the data warehouse and the underlying transactional database
• Performed Requirement Analysis and developed Use Cases, Activity Diagrams using Rational Rose
• Developed automated Test Scripts in Win Runner using Test Script Language (TSL) for Functional Testing, Regression Testing, Data Driven Testing, Usability Testing, and Verifying Specific content through using Checkpoints
• Responsible for Data Extraction, Data Compilation, Data Analysis, Data Manipulation and Data Validation using SQL queries in a MS SQL Server 2005 environment
• Involved in creation and execution of manual test cases in Mercury Test Director and automated Test Cases in QTP and analyzed the Test Results.
• Involved with the QA team to conceptualize, determine and develop test approaches and methods for unit testing, integration and functional testing, load and usability testing according to the application complexity and test requirements.

Environment: Windows XP/2000, Oracle, PL/SQL, CaliberRM, SharePoint, Unix, MS-Project, MS-Office Suite, MS Visio, Rational Requisite Pro, Clear Case, Clear Quest, MS Access, Test Director 7.6, Quick Test Pro (QTP)

Confidential, Portland, OR

Business Analyst

Responsibilities:

• Conducted user interviews, gathered requirements, analysed the requirements using RUP methodology and documented the requirements using Rational Requisite Pro.
• The project focused on Exceed suite of products and involved tracking of warehouse inventory in multiple locations.
• Conducted business analysis, acted as a liaison between project manager, business users’, & IT team, and used MS Office for the documentation.
• Worked with the SME’s (Financial Analysts, Risk Managers, and Project Managers) to define business critical needs and analyse the possible technical solutions.
• Responsible writing Test Plans, Test Cases and Test Scripts using manual and automated testing tools from Rational and Mercury Interactive such as test Director, Winrunner.
• Involved in Data Modeling of both Logical Design and Physical design of data warehouse and data marts in Star Schema and Snow Flake Schema methodology.
• Interacted with database developers for formulating the ER diagrams and data flow diagrams.
• Prepared Use cases and Activity flow diagrams and Work flow diagrams, considering the scope of the project with MS VISIO 2003.
• Writing PL/SQL procedures for processing business logic in the database. Tuning of SQL queries for better performance.
• Facilitated Joint Application Development sessions and facilitated stakeholder meetings to identify business process and requirements; exhaustive management of project requirements using CaliberRM
• Responsible for creating the Business Process Model for the Global New Account Opening utilizing the BPM methodology and notations.
• Core responsibility involved complete manually testing of the User Acceptance Test (UAT)
• Use Cases and other Process Flow Models were designed using Visio and Rational Rose.
• Conducted joint requirements planning (JRP) sessions as a facilitator to gather requirements from the business area and to discuss different critical success factors of the project like Operational Feasibility Analysis, Technical Feasibility Analysis, Cost Benefit Analysis & etc.
• Prepared the functional test cases and performed the functional testing of the application using mock and live data at the back end.
• Managed and organized requirement coverage, Test Case Management and Defect Management using Mercury Quality Center.
• Developed and managed project plans, schedules, issues log created and business-technical conflicts.
• Coordinated various kinds of User Acceptance Testing (UAT) including regression testing, system testing, integration testing, functional testing, alpha & beta testing.
• Authored test plans, test cases for various test scenarios and helped testing team to better understand the test scripts.
• Designed and created prototypes of reporting tools for data validation and verification initiatives using macros in Ms Excel.
• Used Test Director which is a Mercury tool to help manage defects and issues log during the testing phase.
• Involved in the creating the User Interface Specification Document and User Manual as per project specification with the help of development team
• Followed the UML based methods using Microsoft Visio to create: Use Cases Diagrams, Activity Diagrams, State Chart Diagrams, Sequence Diagrams and Collaboration Diagrams.

Environment: Rational Suite (Rose, Requisite Pro), Windows XP/2000, SQL, XML, CaliberRM, HTTP, MS-Project, MS-Office Suite, MS Visio, WinRunner, Load Runner, SharePoint, Test Director (Mercury Interactive), Java, Oracle

Confidential, Parsippany, NJ

Business Systems Analyst

Responsibilities:

• Worked closely with the loan officers (SMEs) to obtain a detailed knowledge of the loan life cycle process, risk analysis etc;
• Determined the functional requirements through conducting user interviews, and created the business requirement document (BRD) and traceability matrix, and thus develop the standardization of processes.
• Used SQL queries to test the integrity of data by querying the database
• Creating, Process Flow Diagram, Context Diagram and Activity diagrams using UML.
• Extensively involved in the modeling and development of Oracle Data Warehousing System.
• Wrote Test Cases in Mercury Quality center that would test various Test scenarios.
• Used BEA (BPM Tool) to map Process flows and migrated Visio Process flows into BEA Tool.
• Used UML and RUP best practice methodologies along with supporting toolset including Mercury Test Director, Caliber RM and Star Team for overall development framework
• Manually tested and GTS modules using Quality Center.
• Wrote Test plan and Test cases for the Integration testing and system testing.
• 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.
• Queried database using SQL for backend testing
• Provide implementation assessment, strategy, and mentoring services for Rational Rose, UML and RUP.
• Served as a resource for analytical services utilizing SQL Server, TOAD/Oracle, and SQL Developer.
• Developed and maintained the project plan using MS Project
• Rational ClearCase was used to manage all the changes and change requests in the projects. Worked with QA team with the aid of ClearQuest for the bug tracking and Mercury Test Director for Test Case Management.
• Designed and implemented SQL queries for QA testing;
• Conducted User Acceptance Testing (UAT).
• Prepared user manual and performed user acceptance testing.

Environment: Rational Suite (Rose, Requisite Pro), Rational Unified Process (RUP), LoadRunner, WinRunner, SharePoint, Windows XP/2000, Oracle, PL/SQL, MS-Project, CaliberRM, MS-Office Suite, MS Visio, MS Access, MS Word, MS Excel