SUMMARY:

• Over 8 years of diverse experience in Business Analysis, Software Quality Assurance and software Development.
• Experienced in project planning, project design, creating functional specifications, data flow diagrams and test plan documents
• Translated user requirements into technical specifications and mapping the process design, workflows for SDLC with documenting and managing business requirements.
• Thoroughly worked with MS Office, MS Project, and MS Visio on various projects
• In - Depth knowledge SDLC
• Created UML diagrams including Use Case diagrams, Activity Diagrams using MS Visio and Rational Rose.
• Documented requirements for the reporting front end and back end data attributes (received from multiple sources) based on ETL code and application analysis.
• Participated in meetings with business process owners, SMEs (subject matter experts) and marketing team for Requirements gathering in definition stage.
• Worked with various business process and systems modeling Tools: data flow diagrams, process models, ER diagrams, use case scenarios
• Experienced in all phases of software testing; requirements, planning testing process, executing tests, analyzing and reporting results.
• Competent in manual, Functional, Regression, System and User Acceptance Testing in Client/Server & Web-based application environments
• Experienced working in fast paced environments, interacting with developers and product analysts regarding Testing Status and Defects, bug tracking and bug reports using test management applications like QC
• Excellent organizational skills with problem solving, analytical, troubleshooting, and information management abilities.
• Experienced in defining Testing Methodologies, Designing Test Plans and Test Cases, and Documentation based on standards for Software Development and effective QA implementation in all phases of Software Development Life Cycle (SDLC).
• Experienced in conducting Black Box Testing GUI, Functional Testing, Integration testing, compatibility, System Testing, Sanity Testing.
• Reviewing Test Plan, Preparing Test Cases and Execution of test cases.
• Proficient in all cycles of test life cycle from test planning to defect tracking and managing defect lifecycle.
• Developing and Maintaining Test Scripts, analyzing bugs and interacting with development team members in fixing the defects.
• Used SQL database queries to verify defects.
• Extensive experience in coordinating testing effort, responsible for test deliverables, status reporting to management, issue escalations.
• Has working knowledge with CMM Level 4 SDLC processes.
• Well Versed with Black box and White box testing.
• Inserted check points, Transaction points, Synchronization point, iterative (For, While, etc) and conditional Statements (If and Case) in QTP scripts while editing them.
• Good interpersonal skills, commitment, result oriented, hard working with a quest and zeal to learn new technologies and undertake challenging tasks.
• Experience in Web Application, Web Services, Client/Server Application and Database.
• Experience in scripting with QTP and automation test tools and QC Manual tool.
• Strong in Defect Reporting and Tracking, Defect Life Cycle using Quality Centre.
• Developed and Executed Software Test Plans and Software Test Cases.
• Executed different types of Test Suites: Smoke, Integration, Functional, Regression, GUI, System Testing, Compatibility, Installation, and Black Box Testing.

TECHNICAL SKILLS:

Tools: HP Quality Center, HP QTP, HP Load Runner, Rational

Bug Reporting Tools: Test Director, Rational Clear Quest, MS Excel,Jira

GUI / Languages: TOAD 11.0, SQLPLUS HTML, JAVA, JavaScript, VBScript, XML, Visual basic 5.0/6.0, C/C++, C#

Web Server: Web logic 5.0, MS IIS 5.0/6, JBASS, APACHIE.

Databases: Oracle 9i, MS-Access, MS SQL Server 6.0/7/2000, DBMS.

Software: MS-Office 2003/2000, MS Word, MS Excel, MS Power Point

Operating Systems: Windows XP/2000/2003/Vista (Beta)

PROFESSIONAL EXPERIENCE:

Confidential, NYC, NY

Business Analyst

Responsibilities:

• Interviewed Business Users to gather Requirements and analyzed the feasibility of their needs by coordinating with the project manager and technical lead.
• Created Source to target data mapping documents identifying key data elements and prepared Data Flow Diagrams
• Used SQL queries to find trends in data as well as data profiling tools such as Abinitio data profiler.
• Created Business Requirements Documents (BRD), Functional Requirements Documents (FRD), Use Cases, Test cases, User Acceptance Testing (UAT) document.
• Interacted with database developers for formulating the ER diagrams and data flow diagrams.
• Developed and managed the formal SDLC implementation using the Lean/Agile Methodology.
• Performed requirements modeling and develop analysis diagrams, activity diagrams, sequence diagrams, state diagrams, data models, and use-case realizations using RUP tools in Agile.
• Conducted business process modeling and analysis; identified, assessed and articulated gaps/operational risks associated, operational enhancement solutions to project management.
• Project management update and controlling to ensure on time delivery using MS Project
• Interacted with users for verifying User Requirements, managing Change Control Process, updating existing Documentation
• Assured that all Artifacts are in compliance with corporate AGILE Policies and guidelines.
• Developed strategies with Quality Assurance group to implement Test Cases in Mercury Quality Center for stress testing and UAT (User Acceptance Testing)
• Used SQL queries for organizing and abstracting data from MS Access, created reports, forms on MS Access.
• Performed Data mapping, logical data modeling, class diagrams and ER diagrams. Used SQL queries to filter data.
• Intricately involved in Business Process Flow development, Business Process Modeling, and ad hoc Analysis Created source table definitions in the Data Stage Repository by studying the data sources.
• Recorded retention stored in Knowledge Link. Ad Hoc reporting, Admin for MS Project, Excel dbase and pivot tables, Clarity and MS Project Server Admin duties.
• 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.
• Conducted User Acceptance Testing, gathered and documented User Manuals and Business Rules

Environment: Agile, UML, Requisite Pro, Rational Rose,Jira, Clear Quest, SQL Server 2005/2008, Windows.

Business Analyst/QA Analyst

Responsibilities:

• Analyzed system requirement and business requirement documents and developed test cases and test scripts.
• Defect Raising, Defect management & preparation of dashboards through Quality Center & JIRA.
• Worked with team on data mapping and ETL process.
• Used SQL commands to validate the database and test its integration with the front end.
• Performed GUI Testing, Functional Testing, Integration Testing and Regression Testing.
• Execution of manual test cases and responsible to track and log the defects using Quality Center.
• Interacted with developers to sort out the issues and the defects.
• Performed data driven testing and GUI Check Points using QTP and enhanced the overall functionality of the application.
• Systems include using SQL Server 2012 for extensive data analysis, and Team Foundation Server (TFS) for backlog, requirements and development management.
• Written reusable VBScript functions and accessed them from the library files which are stored in the Quality Center
• Developed automated regression scripts using Quick Test Professional utilizing VBScript scripting for both positive and negative boundary conditions.
• Created and executed scenarios in Load Runner controller to analyze system performance in Load Runner Analyzer under load.

Environment: QTP 9.5, Load Runner, HP Quality Center 9.5, VB, Net, C #, Windows XP, HTML and SQL

Business/Quality Assurance Analyst

Responsibilities:

• Formulating detailed Test Plan, after analyzing business rationale and software requirement artifacts.
• Interacted with the users to ensure meaningful development of the test scripts and simulated real time business scenarios.
• Worked o TFS to manage requirements and log the defects.
• Gathered requirements by analyzing Abinitio Graphs and Prepared Technical specification document.
• Extensive use of complex SQL query to perform back-end test
• Developed, executed and documented test plans, and test cases manually for the application
• Worked with Project Management to scope the testing effort and provide status and estimates
• Involved in implementation of manual testing methodology.
• Extensive Manual Testing was performed for Functional, Back-End and GUI testing
• Performed Manual Back End Testing on Database on a MS SQL server
• Wrote complex SQL queries to perform the backend testing of the SQL database using SQL and UNIX shell commands
• Conducted UAT testing manually
• Performed data analysis using Abinitio data profiler and running SQL in an Oracle database.
• Maintained documentation of the whole project using Test Director.
• Organize project requirements and Test Cases using Test Director.
• Integrated Microsoft Word documents into Test Director using plug-ins and tags.
• Performed GAP analysis.
• Responsible for testing newly created tables (ETL Process) as per BRS
• Attend regular meetings with developers about the unclear topics in the business requirements.
• Reviewed manual testing methods and developed and executed automated scripts using QTP to perform regression testing.
• Used QTP for GUI Testing and Automated Testing of the application
• Used Test Director for version, tracking defects, enhancement requests, assign work activities and assess the real status of project throughout the lifecycle.
• Worked closely with ETL Testing team for QA & UAT Signoff.
• Mentoring and building skills in more junior members of the QA team.
• In absence of Team Lead, Communicated and collaborated information flow between QA Team and Developers.
• Wrote Status Report both for managers and development team highlighting the major issues

Environment: Microsoft Project 2000, Jira, Java Script, VB Script, UML, Rational Clear Quest, Rational Unified Process, Rational, HP Quality Center 9.5, VB, Net, C #, Windows XP, HTML and SQL

Business/QA Analyst

Responsibilities:

• Conducted and analyzed business processes.
• As a Business Analyst, prepared departmental reports providing analytical framework related to the budget process
• Logged issues in Jira and monitored resolution to completion
• Analyzed, revised and created test plans according to business requirements.
• Writing Used cases and Activity Diagrams.
• Use Rational Rose for Modeling.
• Followed the RUP methodology for the entire SDLC.
• Analyzed consumer surveys and gave technical inputs in Business meetings.
• Gathered requirements from the customers so that the existing website could be improved and it could include portfolio diversification for decreasing market risk and doing risk management.
• Involved in the meeting with Business process owners, SME (subject matter experts) and Marketing Team for Requirements gathering in definition stage.
• Facilitated the customer in defining the high-level functional requirements and needs.
• Gathered the Requirements, Develop Process Model and detailed Business Policies and modified the business requirement document.
• Extensive experience in Gap Analysis.
• Performed Web testing using WinRunner.
• As a member of Performance, Volume and Stress Testing Team, I was responsible for batch performance testing
• Used LoadRunner Vuser Generator and LoadRunner Controller to generate 250 VUsers and conduct Load Testing.
• Compared Network Delay Time and Running Vusers Graphs to analyze bottlenecks in the server using LoadRunner.
• Performed Parameterization using LoadRunner.
• Involved in the Data Movement between Systems validated the Business Requirements.
• Wrote numerous test cases based on test strategies.
• Involved in Functionality and Regression testing during the various Phases of the development.
• Assessed potential risks and analyzed issues of importance with project managers.
• Validated the system end-to-end testing to meet the approved functional requirements.
• Experienced in providing fiscal and economic solutions through financial modeling and cost basis analysis.
• Analyzed team performance with the QA manager and implemented the changes if any with respect to raising the efficiency of the entire team.
• Conducted the final customer acceptance testing, system acceptance and end-to-end testing.
• Used Rational Clear Quest to report defects and Chain management.

Environment: UNIX Windows2000, e-business solutions, MS-Visio, MQ Series, Microsoft Project 2000, Java Script, VB Script, UML, Rational Clear Quest, Rational Unified Process, Rational Requisite Pro.

QA Analyst / Business Analyst

Responsibilities:

• Reviewed Business requirements and IT Design documents for all assigned project releases.
• Involved on testing the new functionalities based on test cases and coordinated with development team in fixing the issues.
• After successful release of projects, developed automation scripts using QTP and integrated the script with master script.
• Ensure that all the test cases are updated in the Quality Center along with Master test plan.
• Involved as part of automation team using QTP, developed test scripts.
• Tested critical bug fixes including critical fixes and coordinated with developers in release of bug fixes meeting tight timeline.
• Involved in Release support - Release to QA, involved in environment setup, testing the release process.
• Involved in Performance testing QA using Load runner 8.0.
• Involved in Backend Database testing in Oracle using SQL.
• Updating the test cases based on the Change Requests/Enhancements
• Preparation of test cases based on Functional specifications. Execution of test cases, bug reporting and bug verification.
• Updating the Requirement Traceability Matrix document
• Involved in System Testing, Sanity Testing and Regression Testing.
• Developed Reusable Actions
• Developed automation test scripts.
• Review of automation test scripts developed
• Perform one round of unattended (Batch) execution and resolve any bottle necks.
• Preparation of Test Summary Report

Environment: QTP 8.2, Load Runner, HP Quality Center 9.5, Net, Java, Windows XP

Software Engineer

Responsibilities:

• Provided web interface to read the data for all modules (Presentation Tier) and created screen prototypes using HTML/JavaScript/XML.
• Used the Oracle concepts in creating the Tables, Data Insertion, Queries, Sequence Creation and Stored Procedures (Database).
• Implemented the Java programming in designing different Bean Classes.
• Implemented DB classes like Customer Registration, Courier Order Booking, Courier Delivery List Generation, Courier Delivery, Invoice Generation and Sterling DAO (Business Tier) using the Advanced Java programming concepts.
• Provided the Menu System for easy accessing other functionalities for web based applications.
• Tester and Bean Classes were tested based on the design options.
• Implemented the concepts of JEE in making both server-side and client-side validations.

Environment: Jdk1.5 Version, Eclipse IDE, Jboss, Oracle