SUMMARY

• Around 8 years of experience in Quality Assurance and Data Analysis
• Extensive knowledge on all phases of Software Development Life Cycle (SDLC)
• In depth knowledge of Software development life cycle and testing methodologies
• Proficient in Functional and Regression testing of Client - Server and Web-Based Applications
• Hands - on experience with diverse testing tools like QC
• Very good understanding of Data Warehousing concepts, Data Analysis, Data Warehouse Architecture and Designing.
• Extensively used ETL methodology in testing for supporting data extraction, transformations and loading processing, in a corporate-wide-ETL solution using ETL tools like Informatica
• Experienced in Onsite-Offshore Co-ordination, Test Management, Test Automation, Onsite Offshore Model
• Experienced in querying the databases by developing and running SQL and PL/SQL queries using utilities like TOAD and SQL Query Analyzer
• Experienced in DW projects ETL testing against DW testing with Informatica, Ab Initio and Data Stage tools
• Experience in writing SQL queries to validate data from the database
• Experience HP ALM/Quality Center - Design Test Steps, Requirement Mapping to Tests, Executing Tests, Defect Logging, Defect Reporting
• Experienced in software testing which involves development of test cases and test scripts.
• Proficient in designing, reviewing and documenting system test plans, defining test procedures and creating test cases based on product release features, client requirements and related technical documents
• Worked with defect tracking tools like ALM and JIRA
• Performed data validations on complex data sets on Oracle, Teradata and DB2
• Experience in writing scripts and queries
• Excellent communication, interpersonal and analytical skills

TECHNICAL SKILLS

Testing Tools: HP ALM, JIRA, QTP, Bugzilla

ETL Tools: Informatica 10.2/10/9.5, DataStage 8.7/8.1, SSIS

Programming: SQL

Databases: Oracle 11g/10g, SQL Server 2008/2005, Teradata 14

BI Tools: Tableau, Cognos 8.4

OS: UNIX, Windows

PROFESSIONAL EXPERIENCE

Confidential, Laurel, NJ

Sr. ETL/BI Tester

Responsibilities:

• Developing test scenarios, test cases and executing them.
• Backend testing of newly developed ETL processes and reports by writing SQL queries and also using MS Excel to compare data.
• Assigned task to all testing team members
• Acted as the single point of contact between development and testers for iterations, testing and deployment activities
• Extensively used SQL programming in backend and front-end functions, procedures, packages to implement business rules and compliance
• Organized and conducted internal training on various feeds.
• Validate production data in the backend tables related to the reports for data completeness and data correctness and generate an excel report with the discrepancies found on daily basis through below activities:
• Writing SQL queries and executing them in TOAD.
• Data comparison between source and target was done using MS Excel.
• Performing end to end testing once the individual processes were tested
• Testing ETL processes that use flat files as source and generate flat files in UNIX environment using UNIX commands
• Publisher-Subscriber process testing by comparing the data in source tables to the generated XMLs and finally to the target tables using SQL.
• Front end testing of the PEGA derived applications.
• Validating the data flow between front-end PEGA application and corresponding backend tables.
• Identified and resolved many application bugs and bottlenecks.
• Validating the source data for reports to find any data inconsistencies
• Testing the reports format by generating the report in Infoview and then saving as excel
• Validating the tickets raised by the report users and assigning them to the developers for fix
• Raising defects, validating fixed defects and tracking defects to closure using HP Quality Center
• Entering all the requirements in the requirements tab of the HP Quality Center and uploading test cases into test plan tab and mapping both the test cases and requirements.
• Preparing the test data and cleaning up the data in tables of lower environments for testing purposes.
• Attending daily Scrum meetings, defect review meetings, requirements understanding meetings with Business Analysts

Environment: Informatica 9.5, UNIX, SQL, PL/SQL, HP ALM, JIRA, Oracle 11g, Tableau, TOAD, JMS Client, XML Spy, XSD, XML

Confidential, Columbus, OH

Software QA engineer - ETL/BI

Responsibilities:

• Analyzed system requirement specification document and developed test plans, test cases to cover overall quality assurance testing.
• Performed browser compatibility testing on different platforms and data validations for all reports
• Conducted Functional Back-End Testing by breaking the test data into finite number of testable pieces based on the application’s functionality on both input and output criteria.
• Developed a Back-End Boundary Test Strategy on the database to verify boundary conditions based on Financial Business logic
• Reviewed and fine-tuned the SQL queries using hints for maximum efficiency and performance during the System Integration and User Acceptance Testing for Database Testing.
• Extensively worked with UNIX commands and Unix shell scripts
• Tested Oracle PL/SQL Packages
• Prepared test data for positive and negative test scenarios for both Back-End and Functional testing as documented in the test plan.
• Used ALM to plan tests, manage test assets, and create and run manual and external scripts to check GUI and functional features.
• Communicated status and presented defect information to the developers and various members of the project team to resolve issues to ensure the defect-free delivery of the Software application.
• Responsible for weekly status meetings showing the progress reports and the future testing efforts of the QA Team
• Documented the Daily Defects Status with the help of Test Metrics
• Performed formal reviews of all documented test cases and keep the latest documents in a common repository for Project Team.

Environment: Informatica 9.0, Cognos, Oracle, TOAD, Flat files, HP ALM

Confidential, Columbia, MD

SR. QA Analyst

Responsibilities:

• Involved in clinical trials programming of tables and listings for reporting on safety
• Experienced in cleaning and resolving data issues as well as merging data from different sources into a single integrated dataset.
• Import raw data from various sources such as CSV, XLS, DLM and flat files.
• Verification and validation of data using SQL and modified existing programs to review data generated tables, listings and assisted in ad hoc reports generation.
• Test plan preparation, Test Strategy preparation, Test cases review, test cases execution, designing, executing, verifying, and analyzing test programs.
• Created test scripts to validate the data between various LOBs as source and EDW as target system/
• Uploaded all test cases to HP ALM
• Mapped test cases with the requirement and created RTM.
• Logged all the defects in the Quality Center
• Performed smoke and sanity testing
• Review of test cases, test plan with business and edited Entry & Exit criteria
• Identification of test scenario for automation
• Preparation of regression test bed for automation
• Develop various documents for automation and performance shared testing services division
• Business components preparation and storing in Quality center
• Coordination with tech support team.
• Requirements review, Design review, test plan review, test cases review meetings coordination.
• Weekly reports, interim test reports, build status reports.
• Preparation and presentation to management.
• Analyzed the existing business scenario and understood the business rules.

Environment: HP QC, Rally, SQL Server, Java, JavaScript, TOAD

Confidential, Bridgeport, CT

Backend Tester

Responsibilities:

• Reviewed, analyzed, FDR, DD documents, Developed Strategies, Test Plans, Test Cases and executed the Test Cases.
• Major responsibility in testing area was in System, Functionality, Integration, Regression testing.
• Wrote many SQL queries to retrieve/storing data and testing source to target data storage
• Tested application prior to release as a Final part, keeping the bug trackers status maintained perfectly.
• Analyzed and maintained requirements and created Test Data, Traceability between Requirements and Test Cases.
• Involved in Manual, Negative, Positive, System, Functionality, Integration, Regression, UAT, and Backend testing during the various phases of the application
• Worked as Team player, involved in daily Agenda, interaction with Managers, Business Analyst, Leads and others, involved in walkthroughs, vendors meeting, testing issues and defects review meetings.

Environment: SQL, Load Runner, HTML, XML, Java, Oracle, Informatica, DB2, TSYS TS2, UNIX, Java scripts