Business Analyst Resume
Milpitas, CA
PROFILE SUMMARY:
- A proficient Business Analyst with 9+ years of experience in Client Interaction, requirements gathering, analysis and Working with end clients to define needs and to develop clear business solutions, to gather and analyze quality data to assist management.
- Well established track record for achieving corporate success in delivering results on time and ability to support under tight deadlines often with competing priorities and complexities.
- Proactive, result oriented professional that has successfully delivered clear measurable bottom line improvement results dealing with both internal and external stakeholders.
- Extremely competent in Requirement Gathering, skilled in using UML tools and proficient with the RUP, and SDLC methodologies.
- Analyzed business partner needs, authored various business documents & process flows, involved during implementation of project roll - out, supported post go live activities
- Involved in gathering customization requirements during the application upgrade which involved feasibility study, communication of customer requirement to the development team and thereafter to oversee the successful implementation of these customizations
- Strong experience in developing Test Plans, Test Cases, Test Scripts, Traceability Matrix using requirements and design documents while specifying Testing Overview, Approach, Strategy, Scope, Roles and Responsibilities
- Extensive knowledge and experience in providing in depth QA support in every phase of SDLC
- Experience with Oracle Apps (AR, AP, GL), Distribution/Supply Chain (OM, Shipping), Manufacturing, interface programs, customization of Forms / Reports and other technologies like JAVA, JSP, ASP, Visual Basic, MS-Access and Oracle.
- Extracted data from Oracle database using ODBC (Oracle Database Connectivity) into Excel spreadsheets.
- Ability to collaborate with peers in both business and technical areas to deliver system solutions in line with corporate priorities
- Preparation of the roll out plan for string testing, functional testing and enterprise testing methodologies using the V-model structure
- Developed detailed Use Cases, Functional/Technical Requirements and maintained traceability to the Business Requirements.
- Extensive experience in Manual and Automation Testing Processes.
- Experience in Capturing, Tracking, Managing and analyzing various types of requirements using Rational RequisitePro.
- Experience with Unified Modeling Language (UML) for developing Use Cases, Activity Diagrams, Sequence Diagrams and Data Flow Diagrams using Microsoft Visio
- Knowledge of Software Development Life Cycle (SDLC), having thorough understanding of all phases Requirement Gathering, Analysis/Design, Development and Testing.
- Developing and understanding overall plans with determining scope, timeline, resource allocation, and relevant details of a project plan
- Possess expertise in Testing of Oracle Applications 11i/R12 implementation, interface programs, customization of Forms / Reports
- Skilled in using MS Project for creating and managing the project schedule
- Developed Test Strategy/Test Plan and Defect Management Strategy to support Testing cycle
- Involved in manual testing and facilitated UAT to get the sign-off for testing
- Independent analytical problem solver, team builder, verbal and written communication, and decision making skills
TECHNICAL SKILLS:
ERP Modules: AR, AP, GL, OM and Manufacturing
Testing Tools: Win Runner 7.5, 8.0 and Load Runner 9.51, 9.0, 8.0, 7.6, 6.5, 6.0, Quick Test pro QTP 7.8/8.2/9.0/9.5 , Rational Tools
Management Tools: Test Director 7.6/8.0, Quality Center 11.0/9.2/9.0/8.2 and Rational Clear Quest
Languages: C, C++, PL/SQL, Java Enterprise Edition (J2EE), JCL, COBOL
Database: Oracle 8.x/9.x/10g, SQL Server2000/2005 and MS Access
Tools: TOAD, SQL Developer & SQL Plus, MS Visio.
PROFESSIONAL EXPERIENCE:
Confidential, Milpitas, CA
Business Analyst
Responsibilities:
- Review PSD and complete Gap analysis, impact assessment, gather business requirements, process flow documentation and change control management for all aspects of project delivery.
- To engage with the stakeholders to elucidate the scope of the project and elucidate business requirements.
- Engage with IT team to elucidate the scope of the project and business requirements. .
- Involved in managing tasks to date, key milestones to develop and track project plan.
- Participate in BRD and FSD reviews of various tracks of the project.
- Responsible to present the I2C status metrics, dashboard to senior management and all stakeholders.
- Involved in regular walk through meetings with the developers, business and QA teams.
- Conducted daily meetings with users to share day to day progress.
- Work with the Development Team to ensure that the design solution meets the Architecture Framework for the project.
- As part of post implementation involved in the application support, finding the bugs after production, bug fixing and enhancements to the applications; enhancements include enhancing the existing functionality of reports and brand new custom reports.
- Good understanding of OM module like creating orders, adding the additional headers/line info, checking contract details etc.
- Good understanding of GL module like entering/posting journals, open/close periods, enabling accounts etc.
- Thorough knowledge on I2C areas like Credit, Collections, Invoicing, and revenue recognition.
- Worked on Cisco Internal tool RRR (Rapid Revenue Reporting) and validated the front end data with back end.
- Worked with RAO (Revenue Accounting Operations) stakeholders, Global Credit and collections end users and shared UAT data with them to check whether the tests meet their requirements.
- Worked on Cisco’s Clarity PPM to raise any project level issues/risks/CRs from I2C track
- Worked on Cisco’s CG1, QTC, BV, CFN, CTS and RRR tool.
- Clear understanding of the order entry, Credit check process, order booking, ship confirmation, Invoicing, Revenue recognition, Collections, receipts, ADI upload and reconciliation process.
- Hands on experience - Invoicing rule setups, revenue recognition setups.
- Active participation in transition and Functional/UAT/BAT/E2E QA activities.
- Responsible for Timely delivery of testing milestones by providing guidance to QA teams in creating and executing test cases in HP Quality Center. Also, coordinated with pears in creating, executing E2E/BAT/UAT test cases.
- Active participation in coordinating the period close activities with ERMO teams.
- Active participation in UAT cycle with stakeholders including coordination and user signoff.
- Involved in Functional testing and helped QA team members by giving them the information about the functionality that has been given.
Environment: Oracle APPS R12, 11.5.10, 10.7, Window NT, Oracle 8i, TOAD, SQL*Loader, SQL Server, PL/SQL, SQL* Plus, AP, AR, GL, Order Management, Inventory, BOM., Quality Center 11
Confidential, Palo Alto, CA
Business Analyst
Responsibilities:
- Involved in constant communication and interaction with the clients.
- Responsible for the definition and the scope of the business requirements for the application developed. Responsible for the documentation of the various modules that were involved in the business process.
- Gathering of business requirements and converting them into functional requirement specification and user requirement specification
- Interact with the Business Users to convert requirements documents into Business System Design documents and Technical Specifications for the Development Team.
- Work with the Development Team to ensure that the design solution meets the Architecture Framework for the project.
- Involved in regular walk through meetings with the developers and testers.
- Involved in code review process, unit testing, UAT and helped other QA team by giving them the information about the functionality that has been given.
- Experienced in Regression tests to check in one area of the application did not cause problems to the other area.
- Involved in Testing of reports migrated into Production and are comprehensively tested and documented.
- Used Test Director as bug tracking database and assigned bugs to related developers.
- Developed Test Cases for various functionalities, Conducted Functionality, Integration, Security, Data Driven testing during the various phases of the development of the application using Quick Test Pro (QTP).
- Use Test Director as bug tracking and reporting tool and followed up with development team to verify bug fixes, and update bug status.
- Involved in Cut over Planning and execution, involved in post-production support, involved in user training for helping the users to understand the functionality of customizations.
- As part of post implementation involved in the application support, finding the bugs after production, bug fixing and enhancements to the applications; enhancements include enhancing the existing functionality of reports and brand new custom reports.
Environment: Oracle APPS 11.5.10, 10.7 NCA, Unix, Window NT, Oracle 8i, Reports 6i, Forms 6i, TOAD, SQL*Loader, SQL Server, Data Load, PL/SQL, SQL* Plus, AP, AR, GL, Order Management, Inventory, AR, GL, AP, PO, BOM., Test Director, QTP, Load Runner.
Confidential, Woodland Hills, CA
Business/Quality Analyst
Responsibilities:
- Assisted project manager in determining timeline and allocating resources for the project based on iterative development
- Developed design prototype of new information processing application. Met with client groups to determine user requirements and goals. Utilized Rational Unified Process (RUP) to configure and develop process, standards, and procedures
- Followed a structured approach to organize requirements into logical groupings of essential business processes, business rules, and information needs, and ensured that critical requirements are not missed
- Developed business requirements, user requirements and functional requirements and documented the same by creating use case document and system functional requirements document
- Created Customer Requirements, Product Requirements and Entity Relationship Diagrams
- Created Systems Requirement Specification by combining the functional and nonfunctional requirements
- Facilitated JAD sessions to address critical issues by preparing a Meeting Agenda, documenting Meeting Minutes and summarizing what was resolved by the JAD session.
- Formed a bridge between the Project Manager and different teams with effective presentations.
- Followed the UML based methods using MS Visio to create use cases, activity diagrams, state chart diagrams, sequence diagrams, collaboration diagrams
- Using RUP provided technical leadership and expertise in reorganization of a complex End-to-End Testing effort and performed System analysis and organizational review of existing QA process
- Helped the testing team in carrying out manual testing and also assisted in writing test cases and a Test Plan.
- Coordinated work plan between project manager and client with Microsoft Project; implemented and managed migration process & developer fixes; retested fixes; scheduled and tracked progress for team members of project through completion
- Responsible for Test Planning, Preparation, Validation and Implementation of Test Strategy, Risk Assessment, Task Prioritization, and Task Assignment.
- Used automation tool Win Runner for Member registration and data creation.
- Created Test data for User Acceptance Testing
- Involved in Regression and System testing of Bank Application
- Involved in maintaining Requirement Tractability Matrix (RTM).
- Manual execution of test cases using Mercury Quality Centre to the front end web application, and Defect logging, Defect tracking.
- Interact with the Business owners for various modules, develop and update the module requirements.
- Developing Test Plan and Test Strategy for the Release cycle and testing cycles within a release.
- Performing data integrity testing by executing SQL statements and validated the tables in the database
- Create and Monitor the test execution reports and manage allocation of work within the team as per the execution status.
- Conduct defect call meetings, escalate the defect issues to the Application coordinators, assign planned closing versions and follow up as necessary.
- Analyzed Technical specs and Requirements, based on business requirements prepared Test Cases, wrote Test scripts for various test scenarios
- Used the automated tool Win Runner for Functional Testing and Regression Testing.
- Wrote SQL statement in Test Script Language (TSL) using WinRunner and performed backend testing.
- Updated WinRunner Scripts for new releases using TSL and wrote functions
- Created Data Driven tests for multiple iterations using WinRunner and Excel sheet
- Developed performance test scripts for all the scenarios using mercury LoadRunner for VPR (Views Portfolio Reports)
- Enhanced the scripts through correlation, parameterization, additional user functions and modified the script to reflect modular test approach
- Created various performance scenarios in LoadRunner’s Controller and executed them on Daily bases successfully
- Analyzed performance testing results using LoadRunner’s Analysis and Created various business reports based on the analysis
- Recorded Bugs and reported them through creating a Bug Report document
- Actively interacted with the team and developers in weekly status meetings to resolve open bugs
- Tested the project according to business requirements and specifications.
- Performed Test Plans and Test Cases for testing the application in reference to the specified Documentation.
- Written Data Driven test to handle the scenario requiring multiples sets of data.
- Reported defects to the team lead and helped the developer to resolve the technical issues.
- Created application specific and generic functions to reduce redundant code.
- Used Quick test Professional for verifying application functionality, Regression Testing and the business processes to identify the defects.
- Used GUI Map Editor in Quick test Professional to change the logical and physical description whenever necessary.
- Created sub-procedures and made QTP record key strokes using low level
- Validated the back-end data by writing UNIX shell scripts to interact with the database
- Wrote SQL statement in Test Script Language (TSL) using Win Runner and performed backend testing.
- Performed the Database testing by writing the SQL queries and inserted the Database checkpoints into the Win Runner scripts.
- Participated intensively in the White box Testing & Black Box Testing of the application.
- Developed and modified scripts as per testing requirements.
- Prepared User requirements and developed business and technical specifications accordance to business requirements.
- Documented Test Cases, Test Results and Test Procedures.
Environment: Mercury Tool suite Win Runner, Quick test Professional, Test Director, Unix, Windows XP/NT, Oracle 9i, Java,J2EE, HTML, JavaScript, Servlets, ASP.
Confidential
Software trainee
Responsibilities:
- Understanding requirements and created system level test cases.
- Executed system test cases and reported bugs
- Involved in regular walkthroughs with Business Analysts to understand the functional requirements and in turn identifying the test conditions.
- Used Test Director to design and formulate the Test plan, Test cases, Test procedures based on the Requirement documents.
- Developed, executed test cases and validated against expected results.
- Involved in writing the Test plans, Designing the test cases and implementing them into Manual and Automated test cases.
- Based on the requirements, created & executed automated test scripts / test procedures using Win Runner
- Did Data Validations in the log files stored in the UNIX box for the trades being executed to different exchanges throughout the day.
- Did the Volume and Stress testing of the applications by executing bulk trades through the automation using WinRunner.
- Actively involved in writing, executing, and analyzing Functional, Regression, and Data driven test scripts using Win Runner.
- Used SQL Queries extensively to get the data from the database to validate against the GUI.
- Wrote Macros in Excel Spread sheet to load excel data into tables
- Reported, Tracked and Managed Bug Reports in Test Director
Environment: Win Runner, Test Director, JAVA, JSP, J2EE, JDBC, SQL, HTML, XML, Rational Clear Quest, UNIX.
