PROFESSIONAL SUMMARY:

• Around 8 years of Experience in Software Quality Assurance in diversified platforms like Microsoft and Sun technologies and rich experience in Manual and Automation of Functional and Performance testing as QA consultant.
• Solid Back End Testing experience by writing and executing SQL Queries
• Excellent testing experience in all phases and stages of Software Testing Life Cycle and Software Development Life Cycle (SDLC) with good working knowledge of testing methodologies, disciplines, tasks, resources and scheduling
• Expertise in creating Test Plan documents and developing test strategy documents and preparing the Traceability Matrices
• Developing a RESTful API for mobile application backend services using Amazon Web Services (AWS)
• Validating Web Services and message responses (SOAP and RESTFUL) and creating functional test suites using SOAPUI
• Extensive experience in testing of large client server applications, Web based applications, E - Commerce Applications and Middleware applications on various Window and UNIX Environments.
• Involved with testing team and created Automation framework using QTP
• Worked with Appium, Selenium-WebDriver and Cucumber testing tools
• Performed Function, Integration, Regression, stress, IVR and User Acceptance Testing.
• Proficient in Quality Assurance and Testing, experience in documentation of Test Plans, Test Metrics, Test Strategy and Test Approach for Manual and Automated testing tools such as Selenium, QTP, App Perfect, J-Meter and Win Runner
• Experienced in creating Data Driven framework using QTP/UFT.
• Expertise in designing the test scenarios and scripting the test cases in order to test the application
• Extensively involved in testing the ETL process from different data sources (SAP, PeopleSoft, Teradata,Netezza, SQL Server, Oracle, flat files) into the target Oracle database as per the data models.
• Played a key role in setting up the new web system’s infrastructure on AWS cloud.
• Expert in PERL, UNIX Shell Scripting & SQL writing for several technology needs
• Involved in Developing Data Marts for specific Business aspects like Marketing & Finance
• Creation of test data and Automation of test cases for system and analyzing bug tracking reports
• Validated Restful Web Services using Test NG and Mongo DB
• Performed test execution in various Billing system areas (Data provisioning, Product Catalog, Offers Management, Subscribers management, Order Management, Unified platform, security server, workflows, Balance Management, Usage, Recurring & Non-Recurring Charges, Billing & Financials, Charging, Recharge, IVR, Self Service Web UIs, CRM Web UIs, backend jobs and processes) and stabilizing the test environment by troubleshooting and resolving environment related issues on the test system during each test cycle,
• Experience in working within the Cloud platforms like OpenStack and AWS for integration processes
• Experience with WebServices, SoapUI tool, XML, Validating request and response
• XML, SOAP and RESTFUL WebService calls.
• Profound knowledge of web services testing using Service Oriented Architecture tools SOAP UI.
• Expertise Shell Scripting experience on UNIX, Linux and Windows environment
• Automated and scheduled the Informatica jobs using UNIX Shell Scripting
• Good working experience in Oracle, Unix Shell Scripting
• Extensively strong on databases including Oracle, MS SQL Server, and Teradata
• Strong in testing Stored Procedures, Functions, Triggers and packages utilizing PL/SQL
• Good experience in Data Modeling using Star Schema and Snow Flake Schema and well versed with UNIX shell wrappers, KSH and Oracle PL/SQL programming
• Involved in generating Test Scripts using Quick Test Pro (QTP) for different transactions to execute Functional Testing, Regression Testing and Acceptance Testing
• Experience in testing and writing complex SQL, T-SQL and PL/SQL statements to validate the database systems and for backend database testing

TECHNICAL SKILLS:

Languages: SQL, PL/SQL, C and C++ Concepts, PERL, Test Script Language (TSL), CSS, HTML, VBScript, JavaScript, Shell Scripting, Teradata, Netezza,, Dot Net Framework 4.5

Databases: Oracle, MS SQL Server, MS Access, Teradata, DB2 UDB, Informix

Reporting Tools: Business Objects (Supervisor, Designer, Reporter), Cognos, Crystal Reports

Tools: TOAD, Win SQL, Teradata SQL Assistant, BTEQ, XML Spy 2008, Cucumber

Operating Systems: Windows, UNIX

Tools: MS-Office suite (Word, Excel, Project and Outlook)

Testing Tools: Mercury (Quality Center, Win Runner, Load Runner, Quick Test Professional, Performance Center, VU Scripting, Business Availability Center) Rational Test Manager, Rational Robot, RequisitePro, RUP, UML, MS Project, MS Visio & Visual Source Safe, App Perfect, J-Meter

ETL Tools: Informatica (Repository Manager, Designer, Workflow Manager, and Workflow Monitor), Web Intelligence, Essbase Excel Add-in, DataStage, Ab Initio

PROFESSIONAL EXPERIENCE:

Confidential, Mooresville, NC

SR. ETL/QA Tester

Responsibilities:

• Involved in Business analysis and requirements gathering.
• Backend database testing in Teradata SQL environment including validating duplicate records for Business intelligence purpose.
• Create, maintain and execute test plans and test cases(MTM)
• Developed, document and maintain functional test cases and other test artifacts like the test data, data validation, harness scripts and automated scripts
• Identified test requirements from specifications, map test case requirements and design test coverage plan
• Hands on experience in Ruby/Cucumber, functional testing, regression testing, integration testing and deep understanding of ATDD.
• Conducted performance testing on the Selenium test cases using J-Meter.
• Extensively used Informatica power center for extraction, transformation and loading process.
• Developed automated UFT scripts using keyword driven and hybrid framework
• Hands on experience in writing test scripts, Gherkins using Ruby Cucumber
• Automate test case using Cucumber testing tool.
• Perform EDW validations on Netezza
• Utilize puppet for configuration management of hosted instances within AWS.
• Performed Web Services Testing (SOAP and RESTFUL) using SOAP UI and validated messages using xPath. Also, created and maintained functional test suites.
• Tested Cognos reports functionality extensively.
• Tested various ETL Scripts to load the data into Target Data Warehouse (Oracle / Teradata).
• Tested IVR systems and insurance consumer websites/services
• Learned IVR testing and tested IVR projects over the phone.
• Extracted certain column of data from a number to files using PERL
• Executed scenarios to verify the POS reporting features and interfaces to inventory details
• Managed and executed the test process, using Agile Methodology.
• Experience in creating UNIX scripts for file transfer and file manipulation
• Ensured that validated deliverables meet functional and design specifications and requirements
• Performed manual and automated test procedures for functional testing of Web services using SoapUI
• Tested Informatica mappings for various ETL data conditions and mapping rules.
• Loading Flat file Data into Teradata tables using Unix Shell scripts
• Involved in front and end to end testing.
• Testing and Defect Management Tools Manual testing, Application Life Cycle Management (ALM)
• Tested XML files using Soap
• Extensively tested several Cognos reports for data quality, fonts, headers & cosmetic
• Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing).
• Tested POS system software for data validation, data verification.
• Worked with Teradata SQL Assistant for data retrieval and data validation
• Participated in defining and executing test strategies using agile methodology.
• Involved in Test Summary Report preparation
• Responsible for Setting up Web Services project using WSDL in SOAPUI and provided setup help to other team members.
• Tested the Dashboard reports using Cognos Report Studio and Metric Studio.
• Conducted review sessions on test case and regression test scripts in with Business team
• Preparing manual test cases and test data for Scenarios
• Prepared Execution procedure document format to prepare the Test cases based on mapping document.
• Assisted UAT testing.

Environment: Oracle 11g, UNIX Shell Scripting, Informatica 9.1, SOAP, SOAP UI, Cognos, MVS, ISPF, Agile, JCL, VSAM, Mainframe, DB2, SQL, PL/SQL, Toad for Oracle, ALM/HP Quality Center 11,J-meter,, Ruby/Cucumber, RESTFUL),UNIX, Teradata,Netezza

Confidential, Johns Creek, GA

SR.QA/ETL SQL Tester

Responsibilities:

• Involved in Business analysis and requirements gathering.
• Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
• Testing and Defect Management Tools Manual testing, Application Life Cycle Management (ALM)
• Personally recorded over 300 defects in Visual Studio Team Foundation Server 2013 (TFS). Responsible for test case management using MTM (Microsoft Test Manager).
• Added assertions to validate the xml in WebServices SOAP and RestFul services.
• Validated WSDL File for webservices.
• Microsoft Visual Studio 2010 - 13, TFS, MTM, Coded UI code reviews.
• Deployment of QA Process and artifacts
• Validated Data in Database using SQL queries (Teradata, Oracle)
• Improved team efficiency by 50% through creation of functional Test Automation Suites Create web UI tests using cucumber, gherkin, Selenium WebDriver (tests written in ruby)
• Manage requirements with Traceability matrices in MS Excel and HP ALM.
• Involved in Test Summary Report preparation
• Developed Test Plan, Test Cases, Test Data and Test Summary Reports and followed Agile/Scrum process.
• Performed Defect Tracking & Management in JIRA.
• Designed software configurations to accommodate multiple interaction features, including telephone, voice and video over Internet, utilizing NetMeeting, Keyboard Chat, IVR, eMail, voicemail and fax.
• Process and validate trade feeds from source to Oracle to Netezza trade tables
• Tested whether the reports developed in Cognos are as per company standards
• Verified the execution of business checks & rules in POS software and defect reporting
• Expert in Waterfall Lifecycle, AGILE and Iterative project testing methodologies
• Defined data requirements and elements used in XML transactions.
• Involved in Business analysis and requirements gathering.
• Developed test scripts using QTP for Functionality and Regression Testing
• Designed Traceability Matrix to match the test scripts with the Functional design document.
• Reviewed and approved database modifications
• Created test data for testing specific Membership functionality
• Promoted Unix/Informatica application releases from development to QA and to UAT environments as required
• Involved in User Interface Testing and Web Services Testing using SoapScope and MQ tools
• Performed Teradata SQL Queries, creating Tables, and Views by following Teradata Best Practices
• Tested POS application reports for reports of daily transactions, receipts of the goods purchased.
• Worked with data validation, constraints, source to target row counts
• Extract data from Mainframe data sets to compare against Target Values.
• Automated and scheduled the Informatica jobs using UNIX Shell Scripting
• Conducted review sessions on test case and regression test scripts in quality center
• Setting up, monitoring and using Job Control System in Development/QA/Prod
• Analyzed and verified the flat, Mainframe IMS and XML data using Informatica Data Explorer.
• Created test scripts for the application which uses SOA, Web services, SOAP and WSDL.
• Tested Cognos Reports using most of the Report studio features (Conditional Formatting, Conditional Page layout, Sections, page Breaks, Master-detail, Drill Through, Drill Down, Drill Up).
• Extensively worked with flat files and excel sheet data sources. Wrote scripts to convert excel to flat files
• Scheduling and automating jobs to be run in a batch process
• Effectively communicate testing activities and findings in oral and written formats
• Extracted data from Oracle and upload to Teradata tables using Teradata utilities FASTLOAD

Environment: DB2, SQL, Teradata 13, Informatica, SOAP, SOAP UI, Agile, Cognos, Teradata SQL Assistant, Mainframes, JCL, UNIX, Shell Scripting, Quality Center, Autosys,JIRA,, Ruby/Cucumber,Restful, UNIX, Teradata,Netezza

Confidential, Charlotte, NC

Sr. QA/SQL ETL BI Tester

Responsibilities:

• Involved in understanding Logical and Physical Data model using Erwin Tool
• Prepared the guides for UAT
• Prepared Execution procedure document format to prepare the Test cases based on mapping document.
• Implementing logical and physical data modeling with STAR schema using Erwin in Data Marts
• Ensured that the mappings are correct and Conducted data validation testing
• Worked with PERL control structures & Regular Expressions for substitutions based on matches
• Worked with business analyst and developers in setting up test data
• Developed several SQL queries for data retrieval from TERADATA and used every utility available in including MLOAD, FLOAD, FAST EXPORT, BTEQ AND TPUMP
• Writing complex SQL queries for data validation for verifying the ETL Mapping Rules
• Extensively test the reports for data accuracy and universe related errors
• Used T-SQL for Querying the SQL Server database for data validation and data conditioning
• Tested several dashboards and deployed them across the organization to monitor the performance
• Testing Cognos reports using review checklists for Quality Assurance before delivering to the end users
• Worked with clients to demonstrate Agile techniques for software development.
• Used SQL tools to run SQL queries and validate the data loaded in to the target tables
• Validated the data of reports by writing SQL queries in PL/SQL Developer against ODS
• Involved in user training sessions and assisting in UAT (User Acceptance Testing)
• Promoted Unix/Informatica application releases from development to QA and to UAT environments
• Written extensive UNIX Shell scripting for error logging, cleanup, data archiving & job scheduling
• Preparing manual test cases and test data for Scenarios
• Implemented SDLC, QA methodologies and concepts in the Project
• 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
• Experience in creating UNIX scripts for file transfer and file manipulation
• Created and executed Test scripts for system validation and user acceptance testing (UAT)
• Did database backup and recovery mechanism using PERL
• Created ETL execution scripts for automating jobs
• Written several complex SQL queries for validating Cognos Reports.
• Involved in extensive DATA validation using SQL queries and back-end testing
• Tested Analytical Data Mart (ADM) of Oracle system and Stored Procedures
• Tested Operation Data Store process of ODS/DWL product
• Used workflow manager for session management, database connection management and scheduling of jobs

Environment: SQL, PL/SQL, XML, XSLT, XPath, Informatica, XQuery, Agile, SQL Server 2008, ALM/Quality Center 11, DTS, T-SQL, Teradata 13.0, Oracle 11g, PL/SQL, IBM DB2, PERL, Cognos, MS Access, Flat Files, Korn Shell Scripting,UNIX

Confidential, NYC, NY

Sr. SQL/QA ETL Tester

Responsibilities:

• Analyzed business requirements, system requirements, data mapping requirement specifications, and responsible for documenting functional requirements and supplementary requirements in Quality Center 9.0
• Created test data for testing specific Membership functionality
• Promoted Unix/Informatica application releases from development to QA and to UAT environments as required
• Extraction of test data from tables and loading of data into SQL tables
• Extracted certain column of data from a number to files using PERL
• Used PERL for automating all the types of modules at a time
• Responsible for Data mapping testing by writing complex SQL Queries using WINSQL
• Validating the data passed to downstream systems
• Involved in developing detailed test plan, test cases and test scripts using Quality Center for Functional and Regression Testing.
• Performed Teradata SQL Queries, creating Tables, and Views by following Teradata Best Practices
• Tested end users to effectively use the Cognos reporting tool to build and customize their ad-hoc reports.
• Worked with data validation, constraints, source to target row counts
• Developed automated Test Scripts using QTP
• Used data conversion to Protect the data and prevent data loss
• Strong in writing sql queries and makes table queries to profile and analyze the data in MS Access
• Created macros to automate the process of refreshing the data in MS Access
• Provided technical support and coaching to team members about functionality of MS Access
• Wrote test plan and test cases to test the application manually in Quality Center
• Involved in testing data mapping and conversion in a server based data warehouse
• Involved in testing the UI applications
• Involved in Security testing for different LDAP roles
• Worked with business team to test the reports developed in Cognos
• Used Microsoft excel and Word 2003 to document the test status reports and the Test Data
• Used Quality Center to track and report system defects
• Involved in testing the XML files and checked whether data is parsed and loaded to staging tables

Environment: Quality Center, Cognos, SQL, Informatica, SQL Server, PERL, Teradata, XML, XSLT, XML Spy, IBM AIX, UNIX, Shell Scripting, QTP,WinSQL, Ultra editor, Rumba UNIX Display

Confidential, Omaha, NE

QA Analyst

Responsibilities:

• Assisted in creating fact and dimension table implementation in Star Schema model based on requirements
• Develop test plans based on test strategy. Created and executed test cases based on test strategy and test plans based on ETL mapping document
• Written complex SQL queries for querying data against different data bases for data verification process
• Performed UAT testing
• Designed the data flow diagrams using VISIO
• Prepared the Test Plan and Testing Strategies for Data Warehousing Application
• Preparation of technical specifications and Source to Target mappings
• Extensively used SQL programming in backend and front-end functions, procedures, packages to implement business rules and security
• Written test cases to test the application manually in Quality Center and automated using Quick Test Pro
• Extensively tested several Cognos reports for data quality, fonts, headers & cosmetic
• Analyzed SQL code to ensure Business Objects queries the correct data from the database
• Defects identified in testing environment where communicated to the developers using defect tracking tool Mercury Test Director
• Developed scripts, utilities, simulators, data sets and other programmatic test tools as required executing test plans
• Loading Flat file Data into Teradata tables using Unix Shell scripts
• Conducted review sessions on test case and regression test scripts in quality center
• Setting up, monitoring and using Job Control System in Development/QA/Prod
• Extensively worked with flat files and excel sheet data sources. Wrote scripts to convert excel to flat files
• Scheduling and automating jobs to be run in a batch process
• Effectively communicate testing activities and findings in oral and written formats
• Extracted data from Oracle and upload to Teradata tables using Teradata utilities FASTLOAD
• Extracted data from various sources like Oracle, flat files and SQL Server
• Worked on issues with migration from development to testing

Environment: PERL, UNIX Shell Scripting, Oracle, Informatica Power Center 8.1, Quality Center 10.0, QTP, SQL *Loader, Cognos 7.0 Series, Oracle8i, SQL Server 2000, Windows 2000, TOAD 7, PL/SQL

Confidential

ETL/QA Analyst

Responsibilities:

• Involved in Design and development of test plans based on high-level and detailed designs
• Analyzed the use cases given by the business analysts and developed test cases using them
• Responsible for complete manual testing of application under test (UAT)
• Written complex SQL queries for data validation and to verify the extract rules
• Tested several Datastage ETL jobs and ran on UNIX for loading purpose and checking the log files
• Performed black box/functional testing, regression testing on Application Under Test
• Performed manual testing on various modules of the Application
• Generates functional test cases that capture actual code behavior as a deployed application is exercised
• Did extensive backend testing using SQL, UNIX and PL/SQL
• Written PERL scripts for text processing, database connectivity & data parsing
• Written complex SQL queries for data validation and data verification
• Executes the test suite to identify regressions and unexpected side effects
• Parameterizes test cases for use with varied, controlled test input values (runtime-generated, user-defined, or from data sources)
• Worked with Data Completeness, Data Transformation, Data Quality, Integration testing, UAT and Regression testing for all ETL feeds
• Monitors test coverage and achieves high coverage using branch coverage analysis
• Tests individual methods, classes, or large, complex applications
• Tracks how test results and code quality change over time
• Conducted performance and load testing using Load Runner
• Analyzed, reported and kept track of defects using Test Director

Environment: Datastage, Windows NT, Shell Scripting, MS-Office Tools, SQL, PL/SQL, XML, XSLT, Web Services, SOAP, Manual Testing, Test Director, Load Runner, Oracle, Java, Servlets and Java Script