SUMMARY

• Over 5 years of Professional Experience in Software Quality Assurance and Testing in different environments and platforms.
• Expertise in Automated Software Quality Testing & Manual Testing of Web based and Client - Server applications.
• 5+ years of experience in Data Warehouse applications testing using Informatica Power Center and Data stage on multiple platforms.
• Excellent in writing SQL queries and UNIX shell scripts to perform Backend testing
• Possess excellent skills in Automation Testing using Mercury´s Quick Test Pro (QTP), Win Runner and Quality Center.
• Well versed with various types Software Development methodologies- Waterfall, Agile, RUP, Iterative and Extreme Programming.
• Involved in validating the data that has been populated into Data warehouse Fact and dimensional tables using Ab Initio Data Warehouse tool.
• Created Test Cases, Test Scenarios, Test data in JAMA
• Performed Black box, Unit/Integration (SIT), System, User Acceptance (UAT), Regression, Usability, End-to-End Testing.
• Provided estimates for the testing effort of the application SIT, End to End testing phase and change controls.
• Worked on Data mapping and Data validation for source to target using Ab initio.
• Ran several Ab Initio UNIX scripts from backend for getting the data counts to verify the reconciliation process.
• Worked on metadata graphs from legacy source system to target database fields and involved in creating Ab Initio DMLs.
• Extensive experience in reviewing Business Requirement Documents, Software Requirement
• Strong technical Knowledge of UNIX Utilities, Shell Script to automate process.
• Ability to develop complicated SQL script for Data validation testing by running SQL script, procedures.
• Experience in testing Business Report developed in Cognos and OBIEE

TECHNICAL SKILLS

Reporting Tools: Business Objects 6.5/XIR3, Cognos 8.0 Suite, OBIEE 10g, 11g, MicroStrategy 8.x

Data Modeling: Star-Schema Modeling, Snowflake-Schema Modeling, FACT and dimension tables, Pivot Tables, Erwin

Testing Tools: Win Runner, Load Runner, Test Director, HP Quality Center, Rational Tools

RDBMS: Oracle 11g/10g/9i/8i/7.x, MS SQL Server 2005/2008, UDB DB2, Sybase, Teradata V2R6, MS Access 2008

Programming: UNIX Shell Scripting, Korn Shell, C Shell, Bourne Shell, Bash, SQL, PL/SQL, TOAD, C++

Web Technologies: JavaScript, HTML 4.0, and DHTML, .NET, Java, J2EE, XML, XSD, XSLT

Environment: UNIX, MVS, HP-UX, IBM AIX 4.2/4.3, Hyperion, Novell NetWare, Win 3.x/95/98, NT 4.0, Sun-Ultra, Sun-Spark, Sun Classic, and SCO

MPP Databases: Netezza NPS 8050

PROFESSIONAL EXPERIENCE

Confidential, MD

Lead QA Test Analyst

Responsibilities:

• Lead The team of 5-6 people and co-ordinate offshore team of 6 people in INDIA
• As Test lead worked on test management throughout the Testing process
• Experience in Software Development Life Cycle and Testing Methodologies.
• Created test case scenarios, executed test cases and maintained defects in JIRA
• Developed and executed various manual testing scenarios and exceptionally documented the process to perform functional testing of the application
• Performed extensive Data Validation, Data Verification against Data Warehouse
• Experienced Data Quality Testing Data Analysis, Data Validation, Data Verification, Data Cleansing, Data Completeness and identifying data mismatch.
• Data verification and data integration test was done using SQL queries. 
• Created Test Cases, Test Scenarios, Test data in JAMA
• Prepared test data for testing the 270/271
• Involved in ETL batch process for 8001
• Validated outbound 8001 files
• Expertise in testing EDI Transactions 834
• Involved in Web Form Testing for QHP
• Worked on 8001 file (Medicaid and CHIP) to validate the enrollment into Medicaid/ CHIP
• Involved in Life Event Changes in Cúram, Notice generation, mapping various denial/ approval codes with the relevant Eligibility of the applicant, Income Verification via IRS, MABS (MD Automated Benefit System) and web services; and validated Outstanding Verifications for various eligibilities.
• Written Test Cases and Test scenarios based on MD Medicaid Assistance Chart for Regression and End-To-End testing
• Heavily involved in Smoke test
• Apart from testing the Application externally (Connecture), worked extensively in the testing of the Cúram (internal portal) as an acting Case Worker
• Validated the data migration from Connecture to Database (using DB Visualizer and SQL Developer)and to the CURUM
• Interacting with senior peers (State Personnel) and SMEs to learn more about the Application Requirement

Environment: SharePoint, DB Visualizer, SQL Developer, Putty, Windows 7, Outlook for various purposes, Oracle 11g, SQL Server 2008, Informatica 9.1, Control M, HP Unix, Agile/Waterfall, Web Services, SQL Developer, Agile/Scrum, JAMA

Confidential, Rochester, MN

Sr QA Analyst/ SQL Backend Tester

Responsibilities:

• Performed Smoke, Functional, Integration, User Acceptance and Regression testing on the web-based application.
• Developed and maintained the Keyword Driven Framework.
• Enhanced the QTP scripts using VB as per the requirements.
• Created scripts using Quick Test Professional based on the business scenarios.
• Developed reusable, readable automated test scripts using Quick Test Professional
• Participated in the team meetings to discuss the enhancement and modification and issues arising out of testing.
• Developed Functional & GUI test plans from specs, automated using Quick Test Pro.
• Utilized HP ALM as a test management tool for planning and executing Manual scripts and for defect reporting and tracking. Expert in using HP Load Runner 10 and 11 for performance testing, load testing and stress testing.
• Expert in using QTP, generating scripts for automation and manual for functional test, regression test
• Assign task to each testing team member and monitor testing progress as well as provide timely feedback to Department manager and Project Manger
• Set up dashboard to generate the analysis reports and also working on different management reports such as (Daily Defects Daily Metrics test plan vs. test lab and combination of Requirements).
• Validate and generate BI report developed in OBIEE, also used different functionalities such as Drill Down, Drill Up, Cross tab, generate Graphs and Pie Chart and checked for cosmetic error for reporting.
• Performed several data quality checks and found potential issues, used the Ab Initio graphs to resolve them.
• Created test plans and performed unit testing for the Ab Initio graphs and its components.
• Developed/Modified test graphs based on business requirements using various Ab Initio Components like Filter by Expression, Partition by Expression, reformat, join, gather, merge rollup, normalize, denormalize, replicate etc.
• Used Ab Initio for Error Handling by the verification of the attached error and rejection files to each.
• Used Clear Quest for defect tracking.
• Worked closely with users and program developers to ensure application development meets user expectations.

Environment: HP-ALM 11, Center 9.0/10, QTP 10, Load Runner 10/11, Oracle 10g, Ab Initio (GDE 1.14, Co>Op 2.14), Flat Files, .Net, SQL, MSSQL Server, Agile and Water Fall, BI OBIEE 10G/11G, Job Scheduling, Control-M, HP-Unix, Toad, Windows , SQL Developer , XP/2000

Confidential, Pennington, NJ

QA Analyst SQL Tester

Responsibilities:

• Analyzed business requirements, system requirements, data mapping requirement specifications, and responsible for documenting functional requirements and supplementary requirements in Quality Center 9.2
• Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
• Involved in the testing of Data Mart using Power Center.
• Extensively used Informatica Power Center for Extraction, Transformation and Loading process.
• Used Teradata load utilities Fast load, Multiload and FastExport to extract, transform and load the Teradata data warehouse.
• Worked in an Agile technology with Scrum.
• Involved in automation of test cases using QTP.
• Did functional testing using QTP
• Effectively distributed responsibilities, arranged meetings and communicated with team members in all phases of the project.
• Used import and export facilities of the application to download/upload XMLs of failed test cases so as to re-verify.
• Writing UNIX scripts to perform certain tasks and assisting developers with problems and SQL optimization.
• Created and executed SQL queries to validate the data and used data manipulation language. (DML) to update the data in the database and verify with front end that application handles the changes correctly. Initiated defects and assigned to Development teams with appropriate severity levels.
• Configured Quick Test Pro with Quality Centre and Maintained the project information in Quality Centre.
• Extensively used Autosys for automation of scheduling jobs on daily, bi-weekly, weekly monthly basis with proper dependencies.
• Wrote complex SQL queries using joins, sub queries and correlated sub queries
• Performed Unit testing and System Integration testing by developing and documenting test cases in Quality Center.
• Did Unit testing for all reports and packages.
• Tested ad hoc and canned reports for Business objects.
• Responsible for migrating the code changes from development environment to SIT, UAT and Production environments.

Environment: Informatica 8.6.1, Flat files, Perl, Erwin 4.0, DTS, MS SQL Server 2008, Oracle 10g, SQL, PL/SQL, IBM DB2 8.0, AGILE, Teradata V2R6, Teradata SQL Assistant, Business Objects XIR3, COBOL, HP QTP 9.0, HP Quality Center 10, Autosys, UTL FILE, TSO, ISPF, OS/z, JCL, Mainframes, Toad, Unix Shell Scripting, Windows XP/2000