SUMMARY

• 6+ years of IT experience with the focus on Testing and Quality Assurance, Web based applications, Client/Server applications, Stand Alone and Vendor applications.
• Good idea of data and testing with working knowledge of Finance/Banking and Healthcare domains.
• Experience with complete Software Development Life Cycle (SDLC) and STLC.
• Experience with Waterfall and Agile Methodologies.
• Defined Test Strategies and Plans for several testing projects.
• Involved in preparation of Requirement Traceability Matrix (RTM), Defect Reports, and Weekly Status Reports.
• Hands - on experience in System and Integration Testing, UAT, Functional Testing, Regression testing and Automation of testing efforts.
• Proficient in SQL with solid experience on database query tools such as TOAD, SQL Navigator, and SQL Assistant.
• Extensively worked on Oracle, MSSQL Server and other RDBMS Databases for testing.
• Experienced in using the Oracle SQL Loader features for loading the data from Flat Files to Data Base tables for Bulk Loading.
• Experience on working with various UNIX commands along with testing the batch jobs using UNIX.
• Experience in testing initial and delta loads.
• Worked on the legacy system testing for the applications developed in COBOL.
• Experienced in interacting with Clients, Business Analysts, UAT Users and Developers.
• Experience in testing several complex reports generated by Business Objects and Cognos, including dashboards, summary reports, master detailed, drill down and score cards.
• Excellent Interpersonal, Analytical, Problem Solving and Documentation skills
• Self-Starter, Motivated, Quick Learner and works with minimal or no supervision.

TECHNICAL SKILLS

Platforms: Unix and Windows

Languages: SQL, PL/SQL

RDBMS: Oracle, MS SQL Server, Teradata, DB2

Defect Reporting: Bugzilla, HP ALM/Quality Center

ETL Tools: Informatica, SSIS

BI Tools: Business Objects, Cognos, OBIEE

Methodologies: SDLC, Waterfall, Spiral, Agile, Scrum

PROFESSIONAL EXPERIENCE

Confidential, San Leandro, CA

QA Analyst/Tester

Responsibilities:

• Worked on Agile methodology for testing and have used HP Mercury ALM.
• Preparing Test Cases, Test Strategies, Test Plan and Review Test Scenarios.
• Designing the Strategies and Guiding the team in ETL Testing.
• Providing the metrics to senior management on the release testing.
• System Study, Data Migration Requirements Analysis.
• Logged defects in HP ALM and communicated that to the development team during daily defect status call.
• Executed End to End Testing for the Integration of Microsoft Dynamics CRM to Sales Force.
• Experienced in UI testing for Microsoft Dynamics CRM.
• Executed and tested Reports on Microsoft CRM and Sales Force.
• Analyzing the Test requirements and Preparing the required Test Bed.
• Supporting Development Integration Testing in various releases.
• Written several complex SQL queries for validating and verifying the data across different databases including SQL Server 2008 and Oracle 11g
• Creating Complex SQLs for testing the data in the database after ETL process execution.
• Worked on SQL Server and Oracle databases for the validating data.
• Checking log files in UNIX for back end exceptions, and forwarding the same to developers.
• UNIX and Oracle are using in this project to write Shell Scripts and SQL queries.
• Work with Informatica 8.6 to dig into the code to find the development issues.
• Extensively used Informatica power center for extraction, transformation and loading process.
• Tested migrated data using Count queries, Source, Target comparison using Minus queries.
• Developed QA Automation using Excel Macros for the Data Migration Testing.
• Co-ordinate between the Project teams and setting up triage calls and project meetings to resolve issues.

Environment: Agile, Oracle 11g, MS-SQL Server, TOAD, MS Excel, Sales force, HP ALM, SQL, Unix, Informatica 9.5

Confidential, Windsor, CT

Data Warehouse Tester/Data Analyst

Responsibilities:

• Involved in Business analysis and requirements gathering.
• Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
• Preparation of technical specifications and Source to Target mappings.
• Extensively used SQL programming in backend including functions, procedures, packages to implement business rules and security.
• Solid testing experience in working with SQL Stored Procedures, triggers, views and worked with performance tuning of complex SQL queries.
• Optimizing/Tuning several complex SQL queries for better performance and efficiency.
• Created various PL/SQL stored procedures for dropping and recreating indexes on target tables.
• Defects identified in testing environment where communicated to the developers using defect tracking tool Mercury Test Director.
• Reported bugs and tracked defects using Quality Center.
• Used QTP for performing functional testing.
• Written test cases to test the application manually in Quality Center and automated using Quick Test Pro QTP.
• Extracted data from various sources like Oracle, flat files and SQL Server.
• Assisted in promotion of Informatica code and Unix Shell scripts from UAT to Production.
• Implemented and supported the Business Intelligence environment and User Interface.
• Promoted Unix/Informatica application releases from development to QA and to UAT environments as required.
• Designing and creation of complex mappings using SCD Type II involving transformations such as expression, joiner, aggregator, lookup, update strategy, and filter.
• Written several complex SQL queries for validating Business Objects Reports.

Environment: HP Quality Center 9,Business Objects XIR3, Sales Force, Agile, SQL Server, FDA, CFR PART 11, Oracle Clinical Trial, PL/SQL, SQL, QTP

Confidential, Louisville, KY

QA Tester

Responsibilities:

• Analyzed business requirements and module-specific functionalities to identify test requirements and formulate an effective master test plan.
• Responsible for review of Functional Requirement Specification and System Design Specification documents for testing.
• Used DOORS for reading/analyzing the requirements for the project.
• Performed extensive manual testing on critical functionalities of the application.
• Design and Development of QA documentation like Test Cases and Test scenarios from business and functional requirements.
• Used Rapid SQL tool to query the DB2 data and verified the results.
• Tested reports in Cognos using Analysis studio, Report studio and query studio.
• Experienced in analyzing the issue by checking the log files in the AIX environment.
• Used Mercury Quality Center for Test Planning, Test Designing, Test Analysis, Test Execution, Defect Tracking and Test Result
• Extensive querying using TOAD to run SQL queries and monitor quality & integrity of data.
• Actively participated in creating requirements Traceability matrices and Test plans
• Performed Unit and functional testing for all the Mappings and Sessions.
• Implemented automated Processes & scheduling using Autosys.

Environment: DataStage, Oracle 9i, SQL Server 2005, SSIS, SSRS, SSAS, DOORS, SQL, PL/SQL, Autosys, TOAD, IBM AIX, MS Access, DB2, Rapid SQL, Cognos, Unix, TIBCO, Quality Center