SUMMARY

• 8 Years of hands on experience in the field of Information technology with emphasis on Software Quality Assurance. Expertise in QA Methodologies, Quality Assurance Life Cycle (QALC) and involved in testing on Client/server, web based Applications.
• Experience in DWH Tools Informatica Power Center 9.x/8.x and Business Objects.
• Experience with RDBMS and MPP databases like Oracle 10g/9i, SQL Server 2005/2008.
• Expertise in Automated Software Quality Testing & Manual Testing of Web based and Client - Server applications.
• Experienced in writing complex SQL Scripts/queries for data validation and query tuning as well as performance tuning.
• Possess excellent skills in Automation Testing using Mercury's Quick Test Pro (QTP), Win Runner and Mercury Quality Center.
• Experienced in User Acceptance (UAT) and System integrations testing.
• Possess strong understanding of the Software Development Life Cycle (SDLC) And Software Test Life Cycle (STLC).
• Proven experience in complete life cycle of Design, Maintenance and Documentation of Data Marts.
• Experienced in Manual and Automated testing of client server and web applications in QA Tester and Analyst roles.
• Strong business understanding of Financial, Health care, Education, Banking and Service oriented industries.
• Performed Duties related to website testing and quality assurance to warrantee the best user experience and Browser/Operating System compatibility.
• Experienced in Providing the Test Manager with accurate and precise estimates for assigned task duration, along with confidence levels and foreseeable dependencies.
• Experienced with process flow and system diagram development using tools such as MS Visio And Mind Jet Manager for use in requirements or technical documents.
• Experience in scheduling and executing workflows and sessions using Informatica workflow manager and workflow monitor tools
• Experienced in writing Test Plans and Test cases using requirements and design documents.
• Experienced mentoring the development of Test Overview, Test Approach, Test Strategy, Test Scope, and Test Evaluation Summaries, tracking of test coverage and providing Metrics to the management.
• Represent QA in all phases of product development including requirement, design, construction, testing, implementation, code reviews and support. Sound business knowledge to improve current business practices.
• Professional expertise in Manual Testing, Functional testing, End to End Testing, Ad-hoc Testing, System Integration Testing, System Testing, Regression Testing, Black Box Testing.
• Experience in Keyword Driven, Data driven frame works, function libraries, enhancements in the scripting.
• Well Versed in GUI application testing, Database Testing & Security Testing on Client-server and web- based applications with multiple server domains.
• Active role in requirements review, functional document review, testing review and key resource for System Testing phase and production roll-out.
• Defect tracking, creating test summary reports and documentation of the results
• Experience in writing the SQL queries. Performed backend testing and data validation by writing SQL queries.
• Experience to log the defects in Quality center and close the defects if they are fixed.
• Has experience in testing applications that work with Oracle, Web Technologies, and Java based platforms
• Experienced in testing products in Agile (Scrum) development environment as well as in waterfall model. Have strong exposure to full cycle of software development and testing
• Multitasking and prioritizing projects, as well as the ability to appropriately set & manage expectations.
• Create, review and maintain test data and test results documentation. Document and report software defects using specific tools.

TECHNICAL SKILLS

ETL Tools: Informatica Power center 7.x/8.x,9.x PL/SQL procedures

BI Tools: Business Objects 6.5/5.x (Designer, Supervisor), Cognos 7.x (Impromptu, Power Play, Transformer)

Operating Systems: Windows 2000/NT 4.0 Server, AIX, HP-UX 11i v2, Redhat Linux

Programing Languages: Java, .Net, C#, C++, XML, HTML

Database: Oracle 11g R2,DB2, SQL Server 7.0, Teradata, MS Access 7.0,Query Utility(BTEQ)

GUI: Forms 4.5/5.0, Reports 2.5/3.0, Visual basic 5.0/6.0, Developer 2000

Web/App servers: Internet Information Server, Apache Web server, Web Logic

Tools: SQL*Loader, Toad, Mainframes JCL, SQL-Programmer Win Runner7.0/6.0,Mind Jet Manager LoadRunner8.0/7.8,RQM,RTC,Quick Test Professional 8.0/8.2/9.0/9.2/9.5, Quality Center.

PROFESSIONAL EXPERIENCE

Confidential, NY

Quality Analyst

Environment: Informatica9.x, Cognos Report Studio, Report Builder, Unix/Linux, Putty 0.60, Oracle 11gR2, PL/SQL,HP QC, XML, Ultra Edit, Windows7.

Responsibilities:

• Performed Functional, System, and Regression testing of a web based application working in an agile environment.
• Involved in developing detailed Test Strategy, test plan, test cases using Quality Center for Functional and Regression Testing, Involved in writing Test plans and Test Design.
• Interacted with end users to obtain specific system requirements.Prepared test cases for Boundary Value Analysis using BlackBox testing techniques.
• Executed test cases manually and automated to check GUI and Functional features of the AUT, compared and analyzed actual with expected results and reported all deviations to the appropriate individual(s) for resolution using QC.
• Navigating the UNIX/LINUX system when executing the commands.
• Involved in troubleshoot the Issues in UNIX box when testing the Application.
• Converted manual test scripts to automated test scripts in QTP.
• Used HP QTP to develop and maintain reusable Test scripts and worked with Expert view Environment using Parameterization, Checkpoint, Regular Expression, Object Model, Virtual Objects, and Recovery Scenarios etc.
• Implemented BPT framework using QTP tool, Used BPT to enable Subject Matter Experts to create business process tests using reusable business components.
• Exported and Imported test data between Quality Center and MS Excel/Word.
• Checked the data flow through the front and backend and used SQL queries to extract the data from the database.
• Performed an end-to-end test in a production environment to validate new or updated business processes, customization and configuration, reports, and data migration.
• Testing the operational tasks involved in loan products covering account creation, approvals, and disbursals, making payments and closing of accounts using end- end testing.
• Performed end-end testing to carry out operational tasks in saving products, client management and fee payback.
• Prepared weekly productivity reports and submitted test metrics to the management.
• Logging and managing the defects in Quality Center. Highly knowledgeable in software development, requirements analysis, and database design.
• Advanced Excel spread functions such as: Pivot Tables, V Lookup, & Goal Seek

Confidential, OH

Quality Analyst

Environment: Informatica9.x, Business Objects XIR3.1, WebI, Universe Designer, WinRunner, Unix, Perl, VI Editor, Oracle 11gR2, PL-SQL, Remedy5.0, Windows XP

Responsibilities:

• Analyzed, developed, documented and validated QA work product for the application, against the Use Case and Business Requirements Documents as part of the SDLC activity.
• Handled the entire testing process including vast amounts of test data creation, execution, data validation
• Documented test requirements using quality center and set the traceability between different requirements.
• Responsible for preparing and executed of Test Cases (System, Integration Regression test cases).
• Performed peer to peer reviews and communicated the inconsistencies between the requirements and application
• Participated in developing software test plans for various testing phases.
• Functional responsibilities included performing GUI Testing, System testing, Database testing, Usability testing, and Regression Testing
• Prepared test data and Compared the Expected Results with the Actual Results and the Results are Stored in the Quality Center
• Tracked the bugs using Quality Center and generated reports & Defect metrics
• Recorded, maintained and tracked defects in Quality Center. Documented the test results and test processes.
• Executed the test cases in different QA environments and for this enhanced the test cases using data scenarios and data driven approach.
• Developed test oriented SQL Queries to query the database to test the back end process of the application
• Wrote DDL, DML scripts for Schema, Table space, Cluster creation and Alteration.
• Worked with Super Users and Business Analysts to define and design test scenarios and test data.Wrote and recorded TSL scripts for automating the testing procedure using Win Runner.
• Imported De-limited files Into Excel file and validated data quality Using MS Excel.
• Meet with customers to determine their needs, gather and document requirements, communicate with customers throughout the development project to manage customer expectations, resolve issues, and provide project status.

Confidential, German Town, MD

ETLQuaity Analyst

Environment: Informatica 8.6, Quality Center8.0, Quick Test Pro8.0, UNIX, Oracle, SQL, PL-SQL, Unix shell scripts, HTML,XML, Java, JSP, SQL, Windows XP.

Responsibilities:

• Identified test objectives and scenarios from (BRD) Business Requirement Document and test strategy documents of the application under Test.
• Involved in Verification and Validation phase of the development life cycle.
• Involved in developing test cases based on high-level and detailed designs to include prerequisites, detailed directions and descriptions of the anticipated outcome
• Prepared test cases for Functionality and GUI testing
• Performed manual testing of the complete application and identified mismatches between actual and expected behavior of the application.
• Analyzed the results of the test cases executed and recorded defects and updated the information to QA Lead
• Set up definitions and process for test phases including integration test and system test.
• Involved in database testing of the application to check for insert and update operations using SQL queries
• Performed integration and cross browser testing to check if application under test was performing as expected.
• Involved in testing Web services and XML with tool called ‘SOAP UI’. I have been using this tool to locate WSDL file on internet, create Test cases, run them, do load testing, security testing.
• Reported Defects using bug-track and actively involved in analysis of the defects on severity and priority.
• Performed Back End testing using Toad Tool to verify whether the data is getting populated in the Oracle Database correctly or not.
• Analyzed modules and designed test scenarios and test scripts in UNIX environment.
• Verified in UNIX environment to make sure user home directories are created with correct access.
• Participated in defect meetings and build meetings to resolve outstanding issues and to prioritize defects and asses risks.
• Documented and communicated test execution results.
• Participated in status meetings to report any bugs, issues and risks.

Confidential, MI

Quality Analyst

Environment: Informatica Power Center 8.1, SQL*Loader,Java, Mainframes DB2, JIRA, Business Objects 6.5, Web Intelligence 2.0, Oracle 9i, Windows NT.

Responsibilities:

• Involved in designing the data model using ERWIN and generated the DDL for DBA to implement the tables in the development and production environment.
• Using Informatica Repository Manager maintained the repository, created users, user groups and security access control.
• Setup and maintenance of database on Oracle. Database administration tools used includeOracle Enterprise Manager, Spotlight on Oracle AndTOAD.
• Created and stored metadata in the repository using Informatica Repository Manager.
• Cleanse the source data, Extract and Transform data with business rules, and built re-usable mappings, using Informatica PowerCenter Designer.
• Involved in deriving the Test Scenarios and designing, executing the Test cases.
• Involved in generating the test data and preparing the weekly status reports.
• Involved in manual test execution and was involved in various testing phases like Sanity Testing, Smoke Testing, Retesting, Regression Testing and System Testing.
• Executed the test cases manually on timely basis and detected the defects.
• Interacted with the developers to solve the defects and retested the scenarios once the defect is fixed and closed the defect if it no longer exists.
• Provides the status reports like how many test cases executed, defects found, defects pending, defects solved.
• Documented the test results and informed to QA lead about the status.
• Performed the database testing by executing the SQL queries.
• Good interaction with team to ensure good relationship among the team.

Confidential

Software Engineer

Responsibilities:

• Identify the sources, Analyze the source data.
• Using Informatica Repository Manager maintained the repository, created users, user groups and security access control.
• Created and stored metadata in the repository using Informatica Repository Manager.
• Cleanse the source data, Extract and Transform data with business rules, and built re-usable mappings, using Informatica PowerCenter Designer.
• Created complex joiners, transformations of all types as needed to smoothly pass data through ETL maps.
• Using Informatica PowerCenter created mappings and mapplets defining the transformation logic according to the business rules for the loads.
• Configured session properties and target options for better performance.
• Test all the applications and transport the data to target Warehouse Oracle tables on NT server.
• Schedule and run Extraction and Load process and monitor sessions by using Informatica Server Manager.
• Used JIRA For Bug tracking purpose.
• Maintain and enhance the application to meet all the required business needs, mainly to optimize the supply vendors cost.

Environment: /Tools:Informatica Power Center 5.1,JIRA, Oracle8.0, SQL, Windows