SUMMARY

• 7+ years of experience in Software Quality Assurance of Web and client/server applications on Windows and Unix platforms, expertise in analysis and design of applications. Well expert in both area of manual and automated testing, and currently seeking for a Quality Assurance/Software Tester /Software Test Engineer position to utilize my skills and further my experience.
• Experience with focus on Quality Assurance/ Software Testing of Web based applications; Web based services, Client/Server and Mainframe applications.
• Experience utilizing two or more of the following automated test or test methodology tools: HP Quality Center, QTP, Rational Robot, Rational Functional Tester, Clear Case, and Clear Quest.
• Experienced in DW projects ETL testing against DW testing with Informatica, Ab Initio and data stage tools.
• Familiar with SDLC, test phases, quality standards (ISO, CMM), practices and test methodologies.
• Experience with supporting Test Life Cycles, Compiling Test Status Reports, Environmental Log, participating in Defect Status meetings, Project Status meetings and interacting with Project Managers, Operations Teams and Engineers.
• Utilize Quality Center for maintaining the Test Plans, Test Cases, Test Execution, Defect Management, and Bug Reporting.
• Substantial experience in writing and executing Test Plans, Test Cases and Test Scripts and working with overall team to meet project goals.
• Proficient in different phases of testing: Smoke, Functional, Integration, System, Regression, Black Box and Performance Testing.
• Experience with Software Bug Tracking used PVCS Tracker, Quality Center, and Clear Quest.
• Experienced in working in Agile Scrum, Agile XP, Waterfall, RUP, RAD and SDLC methodology environments
• Experience in testing Business Report developed in OBIEE
• Automated and scheduled the Informatica jobs using UNIX Shell Scripting
• Ability to apply engineering approaches to solve problems and ability to utilize research methods, problem solving and resolution skills.
• Database Testing knowledge, especially Microsoft SQL Server and Oracle.
• Develop SQL queries to collect Test Data and to perform Backend Testing.
• Develop Automated Test Scripts using QTP and automated various Business Flows for the application to perform Regression Testing.
• Clear and concise verbal, written and interpersonal communication skills including the ability to work in teams.
• Excellent Work with technical documentation and reporting skills.
• Attention to detail, organized, good analytical and troubleshooting skills, and being a key team player are a must
• Knowledge of and adherence to Change Control procedures
• Ability to work independently, multitask and focus on critical path deliverables are essential skills for this position.

TECHNICAL SKILLS:

Tools: Quality Center, Quick Test Professional, Load Runner, Rational Robot, Rational Requisite Pro, Rational Test Manager.

ETL Tools: Informatica, Ssis, AB Initio, Datastage

Languages: C++, J2EE, Visual Basic, Pl/SQL, VBS, JavaScript.

Web Technologies: HTML, DHTML, XML, XSL, JavaScript, CSS, ASP, ASP.NET

Operating Systems: Windows XP/2000/98/95, Windows NT, Unix/Linux and MS - DOS

Databases: Oracle, SQL server, Access

CM Tools: VSS, Star Team, CVS, PVCS Tracker.

Others: MS Word, Excel, Power Point, Out Look.

WORK EXPERIENCE

Confidential, New York, NY

ETL Tester

Responsibilities:

• Responsible for Planning, Execution and Analysis of the project and also involved in creating Test Plan, Test Scripts and Test cases using HP Quality center.
• Analyzed the specifications and identified the source data that needed to be moved to the data warehouse
• Worked closely with Team leads in planning, scheduling, developing, and executing tests by using HP Quality Center
• Excellent understanding of entire Software development life cycle(SDLC) and Software testing life cycle(STLC) including methodologies such as Waterfall, Iterative and Agile methodology .
• Developed test cases based on functional specifications and design documents.
• Analyzed and maintained Requirement Traceability matrix (RTM) between Requirements and Test Cases.
• Promoted Unix/Informatica application releases from development to QA and to UAT environments
• Involved in Manual, Negative, Positive, Integration and System Testing
• Designed, developed and executed Quick Test Pro VB scripts for functional and regression testing.
• Tested the different sources such as Flat files, PeopleSoft accounting data and Oracle to load into the Teradata data warehouse
• Worked on Waterfall, RUP and Agile methodologies.
• Tested reports developed by OBIEE Universes for both Adhoc & Canned Reporting users of OBIEE
• Performed manual front-end testing to check all functionalities of different modules.
• Involved in Functionality, Integration, Regression, System, UAT (User Acceptance Testing) testing during various phases of the application.
• Involved in validating the data that has been populated into Data warehouse Fact and dimensional tables using Ab Initio Data Warehouse tool.
• Extensively communicated with developers using bug-reporting tool HP Quality Center.
• Performed data analysis and data profiling using SQL and Informatica Data Explorer on various sources systems including Oracle and Teradata
• Testing of OBIEE and Reports which Includes, Database Connectivity, Tested objects in the Universe to ensure the correct mapping of the objects, Tested the Universe s Structure to ensure that tables are properly uploaded., Tested the aggregate Universe to ensure the query is pulling correct level of Aggregation
• Used Agile Test Methods to provide rapid feedback to the developers significantly helping them uncover important risks.
• Involved in SQL Optimizations, Performance Analysis, and future growth analysis for OLTP and data warehouse applications
• Experienced in Object Repository, Object Identification set the Environment variables, Output value, Recovery scenario, Data Driven Test by using Quick Test Pro (QTP).
• Participated in all QA review meetings.
• Extensively used Informatica power center for extraction, transformation and loading process.
• Wrote some Generic Functions that deal with different sets of data.
• Generated Reports, analyzed data according to the business needs.
• Used Oracle SQL plus to test the integrity of data by querying the database.
• Performed back end testing by writing SQL statements using TOAD.
• Wrote SQL Queries and executed them using TOAD and SQL Editor.
• Prioritized defects and logged them in PVCS Tracker and coordinated their resolution with the development team.

Environment: QTP, Quality Center, OBIEE, agile, PVCS Tracker, Informatica 9.1, TOAD, HTML, Java Script, XML, Java, JSP, EJB, Oracle, SQL Server, Web logic, Unix, Windows Server.

Confidential, Boston MA

ETL/QA Tester

Responsibilities:

• Written functional test Conditions and test cases in Mercury Quality Center
• Performed Smoke, Navigational, Integration, Functional and GUI testing of the application
• Involved in back end, End-to-End testing phases and corresponding process of migration
• Worked in an Agile technology with Scrum
• Tested ad hoc and canned reports for Business objects.
• Extensively used Informatica client tools. The objective is to extract data stored in Oracle database, flat files to load finally into a single data warehouse repository, which is in Oracle.
• Worked closely with developers to communicateQAissues, testing status and with the testing team
• Identified and documented the defects in Mercury Quality Center
• Verified the bugs fixed by developers during each phase of Black Box Testing
• Communicated defects encountered during regression test and followed-up with developers until all the issue were resolved
• Contributed overall testing efforts for performing smoke, functional, back end and regression testing
• Test procedure and test case preparation, defect tracking and monitoring using HP Quality Center
• Tested OBIEE and Web Intelligence reports
• Extracted Data from Teradata using Informatica Power Center ETL and DTS Packages to the target database including SQL Server and used the data for Reporting purposes.
• Test planning, designing test cases, test execution, error reporting, analysis and error
• Test planning, designing test cases, test execution, error reporting, analysis and error
• Verification. Coordination test cycles with client
• We follow -Agile methodology on daily bases, to get the sates of the work.
• Performed Regression testing using QTP
• Worked with development, Marketing teams to release quality product
• Analyzed the outcome of results and reported toQAmanager
• Performed cross browser testing
• Responsible for testing Business Reports developed by OBIEE
• Extracted Data from Teradata using Informatica Power Center ETL and DTS Packages to the target database including SQL Server and used the data for Reporting purposes.
• Implemented the SDLC for testing life cycle and followed the RUP in the application, which meet SEI standards.

Environment: Mercury Quality Center, OBIEE, Informatica 8.6.1/8.1, agile, JIRA, Oracle, SQL, Java Weblogic, Unit and Windows XP

Confidential, Wilmington DE

QA Analyst

Responsibilities:

• Testing systems for functionality, accuracy, and adherence to specifications by performing systems, integration, interface and regression testing
• Developed, maintained and executed Test Plans and test cases to ensure quality of software solutions, including Production rollouts
• Assisted with designing and developing the automation architecture, and configuring the automation test environment
• Assisted with automation methodology, follow it and direct others in regards to automation methodology Developed and maintained automated test scripts (VB script, Quick Test Pro and Quality Center) Assisted the team with integration of Mercury with the MKS configuration tool.
• Involved in the error checking and testing of the ETL procedures and programs Informatica session log.
• Tested Canned/Ad-hoc reports using OBIEE functionalities like Cross Tab, Master Detail and Formulas, Slice and Dice, Drill Down, variables, filters, conditions, breaks, sorting, @Functions, Alerts, Cascading Prompts and User Defined Objects.
• Involved User Acceptance Test, Regression Test on the different versions of the application.
• Executed Test cases manually, validate test results, determine defects, record and report defects.
• Extensively executed SQL Queries on Oracle Database to verify the data for Back-end.
• Reported, tracked, reviewed, analyzed and compared bugs using a defect tracking in Quality Center defect tracking systems.
• Performed Integration testing to test the functionality of the modules.
• Recorded and maintained defect-tracking inventory
• Ensure adherence to Quality Assurance procedures
• Use OBIEE OLAP Intelligence to natively access and analyze OLAP servers. OLAP Intelligence tool helps to Slice, dice, and drill directly on multidimensional sources and deliver workflows via the Web, Windows, and Microsoft Excel
• Worked closely with developers and interact with other departments such as, Product Management, Technical Support, etc.
• Coordinated with Project Management team when providing quality assurance services for particular projects
• Extensively used Informatica power center for extraction, transformation and loading process
• Submitted daily and/or scheduled status reports to the Quality Assurance Manager
• Handled multiple quality assurance projects concurrently.
• Attended periodic meetings, teleconferences and led discussions on problem resolution

Environment: Quality Center, QTP, Informatica Power Center 7.2, PVCS Tracker, VB, Oracle, Windows, Microsoft Outlook, OBIEE,HTML, SQL, Oracle.

Confidential, New York

Quality Analyst

Responsibilities:

• Documented Software requirements and developed Use Cases for various application level processes.
• Conducted Integration, Security, Data Driven, Regression and System testing on various versions.
• Setup and installed Rational components for automated testing environment, Rational Robot, Test Manager, Clear Quest, Clear Case, Requisite Pro and other required tools.
• Planned and managed test in Test Manager, Testing application with Test Factory, Managed defects with Clear Quest, managed requirements with Requisite Pro and trained team members accordingly.
• Generated monthly financial reports for supervisors and customers using Crystal Reports.
• Researched and analyzed competitors and their evolving solutions.
• Wrote functional test plans and test cases using Rational Test Manager and Excel
• Developed automated test scripts using Rational Robot
• Oversaw requirements tracking process with Rational Requisite Pro.
• Worked with Rational Requisite Pro for use cases.
• Analyzed System Requirement Documents.
• Created, Executed and Enhanced test scripts.
• Extensively executed SQL Queries on Oracle Database to verify the data for Back-end.
• Attended periodic meetings, teleconferences and led discussions on problem resolution.
• Participated in the weekly team meeting actively.
• Effectively communicate testing activities and findings in oral and written formats

Environment: Windows, Java, JavaScript, HTML, SQL, Oracle, Win Runner, and Test Director.