SUMMARY:

• Over 9 years of Professional Experience in Software Quality Assurance and Testing in different environments and platforms including Data Warehousing, Client - Server and Legacy Mainframe applications.
• Extensive experience in reviewing Business Requirement Documents, Software Requirement Documents and preparing Test Cases, Test scripts and Execution.
• Experience in Black box testing with a complete QA cycle - from testing, defect logging and verification of fixed bugs.
• Tested Subscribers/Providers and claims in Facets.
• Extensively used SOAPUI to validate SOAP/WSDL and web services
• Done heavy batch testing using AUTOSYS and data validation using SQL and Toad
• Worked on different versions of Cognos for Report testing.
• Experienced in DW projects ETL testing against DW testing with Informatica, Ab Initio and data stage tools.
• Excellent Communication, Analytical and Interpersonal skills.
• Worked with IT Operations to ensure test environment readiness.
• Experienced in working in Agile Scrum, Agile XP, Waterfall, RUP, RAD and SDLC methodology environments
• Extensive experience in Functional testing, Integration/System testing, Regression testing and User Acceptance testing.
• Well versed in GUI application testing, Database testing and Front-end testing.
• Experience in Financial, Banking, Brokerage, and Securities industries.
• Extensively used ETL methodology for testing and supporting data extraction, transformations and loading processing, in a corporate-wide-ETL Solution using Informatica.
• Experience in Dimensional Data Modeling using Star and Snow Flake Schema.
• Experience in testing and writing SQL and PL/SQL statements.
• Expertise in Developing PL/SQL Packages, Stored Procedures/Functions, triggers.
• Solid Back End Testing experience by writing and executing SQL Queries.
• Experience with Agile Methodology.
• Ability to interact with developers and product analysts regarding testing status and to maintain detailed QA documentation.
• Extensive background in QA methodologies.
• Strong Problem Analysis & Resolution skills and ability to work in Multi Platform Environments like Windows and UNIX.
• Experience in Installation and Implementing Mercury Interactive Test Suite.
• Has expertise in Test Case Design, Test Tool Usage, Test Execution, and Defect Management.
• Experience in UNIX shell scripting and configuring cron-jobs for Informatica sessions scheduling.
• Experience in testing XML files and validating the data loaded to staging tables.
• Good experience in Cognos & Business Objects Reports testing.
• Experience in Performance Tuning of SQL and Stored Procedures.
• Automated and scheduled the Informatica jobs using UNIX Shell Scripting.
• Expert knowledge in UNIXshell scripting (Korn shell/Bourne shell).
• Excellent analytical, programming, written and verbal communication skills.

TECHNICAL SKILLS:

OPERATING SYSTEMS: Windows 95/98/2000/NT/XP and Linux (RedHat), UNIX (Sun Solaris 9.0/8.0/7.0, IBM AIX, HP UX 11i v1.5/1.6/2.0).

LANGUAGES: C, PL/SQL, SQL*Plus, SAS

Data Modelling tools: Erwin 4.5/4.0/3.5.5/3.5.2, MS Visio

RDBMS: Teradata V2R6 (MLOAD, FLOAD, FAST EXPORT, BTEQ), Oracle 7.X/8.X/9.X, MS SQL Server 6.5/7.0/2000, MS Access 7.0/ 97/2000, MySQL 3.X/4.X, Sybase, SQL Server 11.x/12.0

REPORTING TOOLS: Crystal Reports 6.5, Business Objects XIR3/XIR2/6.5.1(Supervisor, Designer, Reporter), Cognos 6.5/7.0, SSRS, IBM Cognos 8

DATAWAREHOUSING: Ab Initio, Informatica 8.6.1/8.1/7.1/6.1, OLTP, OLAP, Data Stage 8.x, Data Mining, DataMart, SQL*Loader, TOAD 7.5.2

TESTING TOOLS: MS Project Test Scheduling, Test Director, Quality Center, QTP

PROFESSIONAL EXPERIENCE:

Confidential, Syracuse, NY

QA Tester

Responsibilities:

• Responsible for Business analysis and requirements gathering.
• Responsible for coordinating testing throughout both systems ODS and EDW which were two different teams.
• Tested XML feeds loaded into Data Warehousing.
• Tested SQL to extrapolate data from the autosys database to populate a spreadsheet
• Tested several complex reports generated by Cognos including Dashboard, Summary Reports, Master Detailed, Drill Down and Score Cards
• Extensively involved in testing Facets Member/Subscriber, Billing, Medical Plan, Dental Plan modules.
• Used Agile Test Methods to provide rapid feedback to the developers significantly helping them uncover important risks.
• Experience in Leading the Offsite Project, managing a team of 8 Offshore and 4 Onsite consultants..
• Responsible for leading team and co-coordinating with offshore team.
• Developed data quality test plans and manually executedETL and BI test cases.
• Worked in AGILE Methodology.
• Designed and kept track of Requirement Traceability Matrix
• Quality Center updates and test cases loadingand writing Test Plan and executing Test Cases and printing status report for the team meetings.
• Involved in Integrating and Functional System Testing for the entire Data Warehousing Application.
• Used Quality Center for defect tracking.
• Performed data quality analysis using advanced SQL skills.
• Performed data analysis and data profiling using SQL and Informatica Data Explorer on various sources systems including Oracle and Teradata
• Tested slides for data flow and process flows using PowerPoint and Microsoft Visio
• Strong ability in developing advanced SQL queries to extract, manipulate, and/or calculate information to fulfill data and reporting requirements including identifying the tables and columns from which data is extracted
• Involved in testing Facets for Group Information, Enrolling Subscribers, adding members, Related Entities, Class/Plan definition, Premium Rate Tables and all.
• Worked on Autosys which involved in creation of Autosys jobs, execution
• Inserted Assertions on the Test Cases to validate the XML SOAP response.
• Conducted Load testing using SOAPUI tool.
• Generated reports using SOAPUI.
• Involved in Writing Detailed Level Test Documentation for reports and Universe testing.
• Involved in data warehouse testing by checking ETL procedures/mappings
• Implemented and maintained tools required to support data warehouse testing.
• Performed the tests in both the FIT, QA and contingency/backup environments
• Worked on test data and completed unit testing to check all business rules and requirements are met. Also tested for negative data to check that the job fails on any critical error.
• Tested several data migration application for security, data protection and data corruption during transfer
• Responsible to help testing team on creating test cases to make sure the data originating from source is making into target properly in the right format.
• Functioned as the Onsite / Offshore coordinator and Team Lead
• Tested Cognos reports and written test cases using HP Quality Center.
• Wrote SQL and PL/SQL scripts to perform database testing and to verify data integrity.
• Written several complex SQL queries for validating Cognos Reports.
• Involved in Data Extraction from Teradata and Flat Files using sql assistant.
• Created different user defined functions for applying appropriate business rules

Environment: Quality Center 10.0, SQL, PL/SQL, SOAP,Cognos 8.0 Series, Informatica 8.6.1/8.1,, MainFrame Flat Files, Agile, COBOL II,JCL, UNIX, Autosys, Facets,,Korn Shell Scripting, Oracle 10G, DB2, XML, XSLT, XSD, TOAD9.7

QA Tester

Responsibilities:

• Responsible for Business analysis and requirements gathering.
• I have imparted and organized training to newcomers in the team regarding different technologies like SQL, PL/SQL and different processes.
• Written various Autosys JIL Scripts to activate the UNIX scripts in production .
• Involved in testing the Cognos reports by writing complex SQL queries
• Involved in the error checking and testing of the ETL procedures and programs Informatica session log.
• Performed Check Printing Process using XML and third party tool Xpression
• Designed and developed UNIX shell scripts as part of the ETL process to automate the process of loading, pulling the data for testing ETL loads.
• Worked in an Agile technology with Scrum
• Written several complex SQL queries & PL/SQL stored procedures for validating Cognos Reports
• Written several shell scripts using UNIX Korn shell for file transfers and clean up process.
• System Integration testing for Facets core modules with external systems.
• Performed Data Driven, Data sink testing using JDBC connection as well as load testing using SOAPUI.
• Used Property Transfer test step when needed in SOAPUI.
• Involved in extensive DATA validation by writing several complex SQL queries and Involved in back-end testing and worked with data quality issues.
• Involved in testing of Universes from different data sources like Oracle/SQL Server.
• Managed and executed the test process, using Agile Methodology
• Involved in data warehouse testing by checking ETL procedures/mappings.
• Performed the tests in both the SIT, QA and contingency/backup environments
• Involved in backend testing for the front end of the application using SQL Queries in Teradata data base.
• Involved in Data Extraction from Teradata and Flat Files using sql assistant.
• Strong ability in developing advanced SQL queries to extract, manipulate, and/or calculate information to fulfill data and reporting requirements including identifying the tables and columns from which data is extracted
• Reported bugs and tracked defects using Quality Center
• Worked with business team to test the reports developed in Cognos
• Verify development of rule-set test scenarios, test cases, expected results and analysis of XML test scripts
• Worked on projects independently and also managed a Facets testing effort..
• Involved in creating source target mappings based on the Technical Design requirements.
• Involved in Manual and Automated testing using QTP and Quality Center.
• Created different user defined functions for applying appropriate business rules
• Worked with business team to test the reports developed in Cognos
• Worked on test data and completed unit testing to check all business rules and requirements are met. Also tested for negative data to check that the job fails on any critical error.

Environment: SQL,PL/SQL, HP Quality Center 10, Cognos 7 Series, SOAP,Rational Clear Quest, MS Excel,, Teradata 12.0 Agile, Informatica Power Center 7.2,JCL, Facets,, Korn Shell Scripting, XML, XSLT, XSD, XPath, Unix,XML Spy 2010, MVS, Autosys, COBOL II, JCL, VSAM Files, Copy Books, TSO, Putty

QA Tester

Responsibilities:

• Involved in creating source target mappings based on the Technical Design requirements.
• Involved in Business analysis and requirements gathering.
• Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
• Quality Center updates and test cases loading and writing Test Plan and executing Test Cases and printing status report for the team meetings
• Extensively used SQL programming in backend and fr­ont-end functions, procedures, packages to implement business rules and security
• Followed RUP and AGILE development methodology and adhered to strict quality standards in requirement gathering
• Experienced using query tools for Oracle to validate reports and troubleshoot data quality issues.
• Solid testing experience in working with SQL Stored Procedures, triggers, views and worked with performance tuning of complex SQL queries.
• Developed scripts, utilities, simulators, data sets and other programmatic test tools as required executing test plans.
• Effectively communicate testing activities and findings in oral and written formats.
• Extensively used Informatica power center for extraction, transformation and loading process.
• Worked with ETL group for understating mappings for dimensions and facts.
• Extracted data from various sources like Oracle, flat files and SQL Server.
• Designed and developed UNIX shell scripts as part of the ETL process, automate the process of loading, pulling the data.
• Validated cube and query data from the reporting system back to the source system.
• Tested analytical reports using Analysis Studio
• Used different sources for Input.
• Applied appropriate validation rules and created graph parameters to check the validations are correct so that the graph should stop.
• Used Quality Center for defect tracking
• Created lookup files where necessary for validation of critical enterprise codes, lender identifiers and service numbers.
• Created different user defined functions for applying appropriate business rules
• Written test cases and completed unit test documentation.
• Involved in pager rotation program to support 24 x 7 production support.

Environment: AB INITIO CO>OP 2.13, AB INITIO GDE 1.13, Quality Center, EME, MVS, UNIX (K-Shell Script), Oracle 10G, DB2, Windows 2000 Pro, XML, Agile, XSLT, XSD, Rapid SQL, PL/SQL, TOAD

QA Tester

Responsibilities:

• Interacted with end-users and functional analysts to identify and develop business requirements and transform it into technical requirements.
• Involved in requirements analysis by interacting with analysts for the creation of Data marts using Informatica.
• Worked on complete SDLC from Extraction, Transformation and Loading of data using Informatica.
• Wrote shell scripts (Korn Shell) to automate and migrate data from operational data source to datawarehouse.
• Involved in designing the Data Mart model with Erwin using Star Schema methodology.
• Creating dimensions and facts in the physical data model.
• Design and Development of pre-session, post-session routines and batch execution routines using Informatica Server to run Informatica sessions.
• Tuning of SQL queries for better performance.

Environment: Informatica Power Mart 6.1, Oracle 8.1.1/9i, Windows, UNIX, Excel, SQL Server 7.0/2000, Erwin, Visio, TOAD, Business Objects.