EXPERIENCE SUMMARY:

• Over 7+ years of overall IT exposure in Quality Assurance using Manual & Automation testing with Data Warehousing which involves ETL, Teradata, Reporting and Data modeling experience.
• Experienced in working in Agile Scrum, Agile XP, Waterfall, RUP and SDLC methodology environments
• Strong in Data warehousing concepts, dimensional Star Schema and Snowflakes Schema methodologies
• Proficient in using ABInitio workflow manager, Workflow monitor to create, schedule and control workflows, tasks, and sessions
• Proficient in using Datastage Designer and Director to create, schedule, control workflows and monitor. Extensive work in ETL testing using SQL, UNIX, PL/SQL.
• Strong SQL query skills using an enterprise wide RDBMS (Oracle, MS SQL Server & MS Access) and familiar with concepts of SQL queries ranging from DML, DDL and TCL
• Strong expertise in Relational data base systems like Oracle, SQL Server, MS Access, MYSQL and Teradata
• Experience in performing the Load testing with JMeter / Load Runner.
• Extensively tested data validation, load processes (ETL) using Toad and SQL Developer.
• Experienced in testing BI reports generated using different BI tools like MicroStrategy and Business Objects
• Experience in testing/validating the Source, Stage and Target (End - to-End).
• Experience in Unit Testing, Functional Testing, System Testing, Integration Testing, Regression Testing, User Acceptance Testing and Performance Testing.
• Good Knowledge in Data Modeling and HADOOP.
• Experience in Functional Testing, Data Driven Testing and Web/HTTP for Web Services using SOAP UI, iTKO LISA and SOA Test tool.
• Extensively performed automated testing for SOAP/WSDL/XML web services for the different portfolio event alterations by iTKO LISA Test.
• Proficient in understanding business processes / requirements and translating them into technical requirements. Experience in executing selenium test cases and reporting defects.
• Well versed handling elements in selenium Web Driver
• Co-ordinate in creation and execution of QA and testing processes, test strategies and plans, bug documentation and bug tracking and used Requirement management and bug tracking testing tools like Rally, ALM and Clear Quest.
• Team Player with excellent communication, analytical, verbal, writing and interpersonal skills.
• Team management for onsite-offshore teams including performance tracking and technical support.
• Time management, Strong analytical, Excellent organizational, Detail oriented and problem solving skills with a consultative approach in defining solutions.

TECHNICAL SKILLS:

Data Warehousing ETL: Abinitio, Data Stage, HADOOP, Repository, Metadata, Data mart, FACT & Dimensions tables.

Data Modeling: Physical Modeling, Logical Modeling, Relational Modeling, Dimensional Modeling (Star Schema, Snow-Flake, Fact, Dimensions), Entities, Attributes, Cardinality, ER Diagrams

BI Tools: Cognos 8.x/7.0, Micro Strategy, Business Objects XIR3/XIR2/6.x

Databases: Oracle 11g/10g/9i/8.0, MySQL 5.4, MYSQL, OLTP

Programming: SQL, PL/SQL, SQL*Loader, Unix, Shell Scripting, C, Java, HTML,XML, Perl, PHP, JavaScript

Tools: TOAD, SQL*Plus, Dream weaver, Jmeter, Load Runner

Environment: UNIX(IBM AIX, Sun Solaris), Windows XP/Vista, Linux(RHEL)

Testing Tools: SOAP UI, iTKO LISA, HP Quality Center 10, QTP, Selenium, Test Director

PROFESSIONAL EXPERIENCE:

Confidential, Eden Prairie, MN

Sr. Data (TDM) & Quality Analyst

Responsibilities:

• Analyzing system requirements and technical specifications to create and execute test cases for large business initiatives
• Actively participated in walk - through, inspection, review and user group meetings for quality assurance
• Worked with business users, system analysts, designers and programmers to create and analyze various required project documents
• Working on Hadoop Architecture and various components such as HDFS, Job Tracker, Task Tracker, Name Node, Data Node, Spark and MapReduce concepts
• Experience in working with MapReduce programs using Hadoop for working with Big Data Performed Importing and exporting data into HDFS and Hive using Sqoop.
• Involved in creating Hive tables, loading with data and writing hive queries that will run internally in map reduce way. Proficient in using test automation tools such as Selenium
• WebDriver/RC/IDE/Grid, QTP and Mercury Quality Centre to develop automation testing scripts for web and client server applications.
• Establishing and maintaining test cases and test data. Creating and maintaining test cases in Rally
• Testing Product and driving defect resolution
• Plan, document, evaluate and track testing results to ensure system applications are free from defects Involved in Automation Infrastructure Development using Selenium.
• Created Test Cases using Element locators and Selenium Web driver methods.
• Enhanced Test cases using Java programming features and TestNG Annotations. Execution of Selenium Test cases and Reporting defects.
• Involved in Regression Testing using Selenium.
• Communicated and interacted with appropriate areas on problems, changes and enhancements that may impact data, workflow and / or functionality within Information Technology software
• Performed within standards of the software development life cycle and follow strategies, plans and procedures
• Used SQL to perform Backend Testing, Involved in Load Testing and Regression Testing using Load Runner.
• Some modules are Tested for Performance using JMeter for Web based Scripts. Evaluating the level of automation and the availability of the system test environment.
• Verified that an appropriate level of test coverage is achieved, that test results are verified and also the correct code configuration has been tested, and that the tests are appropriately documented, including formal logging of errors found in testing.
• Verified that appropriate acceptance testing based on the defined acceptance criteria is performed satisfactorily before acceptance of software products.
• Given demos to Product Owners for acceptance of the software.
• Verified that procedures are in place and are being followed to review the completed data for completeness and accuracy and to perform data cleanup as required.
• Provided recommendations on making the conversion process more efficient and on maintaining the integrity of data during the conversion.
• Verified new and existing database designs to determine if they meet existing and proposed system requirements.
• Recommended improvements to existing designs to improve data integrity and system performance.
• Assisted business users in defining User Acceptance Testing, test cases and plans
• Participated in production implementation verification and being accountable for validating system quality

Environment: HADOOP, SQL Server2012, SQL, PL/SQL, Load runner 8.1, Selenium, Jmeter, Mozilla FireFox, Chrome, Internet Explorer, Sauce Labs, Red Hat, XML, XSLT, XSD, Test Cases, Test Plan, Traceability Matrix, UNIX, QTP, HP ALM, Jenkins and Rally.

Confidential, Minneapolis, MN

Sr. System Analyst

Responsibilities:

• Interacted with clients to determine User requirements and goals. Participated in analysis of Business and functional requirements
• Wrote SQL queries to test the application for data integrity and verified the contents of the data table.
• Developed Test Plan and overall Test Strategy for the Application. Developed Test cases, Test plans, and Test procedures using MS Word and MS Excel
• Developed Test Cases and Test Scripts for System and UAT Testing. Performed Positive and Negative Testing for this application.
• Extensively used SQL queries to check storage and accuracy of data in database table. Performed basic testing of security features using manual testing
• Responsible for creating Test Strategy for the Data Warehouse
• Involved in creating the design and technical specifications for the ETL process of 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 Used
• Load Runner and JMeter for Performance Testing and Capacity Testing.
• Preparation and execution of test scripts using JMeter and SOAP UI tool to perform Web Services testing.
• Developed and maintained Automated regression test cases in Selenium WebDriver using Java programming language and Junit Framework.
• Developed Test Frameworks in Selenium for UI Regression Test Automation and when necessary, and potentially execute Unit Test Automation (Java /TestNG). Used Erwin to reverse engineer the existing database design in SQL Server 2000
• Developed Test Cases and Test Scripts for System and UAT Testing. Performed Positive and Negative Testing for application.
• Responsible for communicating Defect Status Reports to business in project meetings.
• Participated and Organized weekly meetings and walkthroughs to improve the testing efforts.
• Tested the reports using Business Objects functionalities like Queries, Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae etc.
• Involved in automation of test cases using QTP. Tested various business rule and data load rule files.
• Involved in the production support team for planning cycle after production implementation. 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 extensive DATA validation using SQL queries and back-end testing
• Performed periodic checks to run crosscheck against QA/SIT/PROD environments to ensure it is up and running.
• Involved in offshore and onsite Coordination activities. Involved in integration/system testing and backup/restore testing for all components
• Involved in the production support team for planning cycle after production implementation.

Environment: Erwin 8.0, DynaTrace, Selenium, SQL Server2012, SQL, PL/SQL, MS Excel Add-in, XML, XSLT, XSD, Test Cases, Test Plan, Traceability Matrix, UNIX, QTP, HP ALM

Confidential, Eden Prairie, MN

Sr. DWH ETL Tester

Responsibilities:

• Experienced in writing test cases, test scripts, test plans and execution of test cases reporting and documenting the test results using Quality Center/ALM and performing end to end testing and created Reports.
• Participated in Regression testing after each build
• Extensively worked in agile environment, with daily scrum meeting, stand up meetings, presentations and review
• Performed Data Analysis and data profiling using SQL and ETL DataStage Data Explorer on various sources systems including Oracle and Teradata
• Good experience in writing SQL in order to data validation in migration as part of backend testing
• Responsible for validation of Target data in Data Warehouse and Data Marts which are Transformed and Loaded using Datastage.
• Experience in creating UNIX scripts for file transfer and file manipulation.
• Prepared Test data preparation strategy and data masking strategy for the shared test environment
• Experience in Database Testing, ETL Testing, Automation (QTP, LOAD Runner) testing& Manual Testing.
• Involved in the error checking and testing of the ETL procedures and programs DataStage session log.
• Wrote Complex SQL queries to validate the standard reports, Dashboards and BI Business objects Universes.
• Involved in preparing the Data-driven and keyword-driven frameworks in QTP for system and UAT environments and performed data comparison and functional comparison.
• Debugging the SQL-Statements and stored procedures for various business scenarios.
• Loading Flat file Data into database tables using Unix Shell scripts.
• Co-ordinate with development and QA team for handling of defects with respect to data
• Validated Business Objects Reports and Universes against Data warehouse/Data mart Database by writing SQL Queries
• Performed data quality analysis using advanced SQL skills.
• Expertise in bug-reporting and bug-tracking using the test management tool like Clear Quest, ALM and Quality Center.
• As an ETL Tester responsible for the understanding the business requirements, ETL and subsequently design ETL testing strategy using SQL scripts.
• Perform Data Integration, Data comparison and Data Validation for Back End Testing by using SQL Queries Microsoft SQL Server.
• Tested Canned/Ad-hoc reports using Business Objects Reporter functionalities like Cross Tab, Master Detail and Formulas, Slice and Dice, Drill Down, variables, filters, conditions, breaks, sorting, @Functions, Alerts, Cascading Prompts and User Defined Objects
• Tested the different sources such as Flat files, Main Frame Legacy Flat Files, SQL server and Oracle to load into the Oracle data warehouse
• Performed Regression testing with QTP by executing the automation test scripts
• Verified the design for maintainability, scalability, refreshability, concurrence, normalization and any other factors affecting performance and data integrity.
• Verified the project’s process for administering the database, including backup, recovery, mirroring, version control, performance analysis and control of data item creation.
• Created ETL mapping documents for every mapping and Data Migration document for smooth transfer of project from development to testing environment and then to production environment.
• Tested and validated the Business Objects reports by running similar SQL queries against the source system(s).
• Working on a integration project with the SQL server data services to maintain the data quality by creating new look ups
• Used SAOP UI as an integration project to validate the request /response in data using assertions.

Environment: ETL Informatica 9x, BI Business Objects XIR4, Quality Center/ALM (HP Application Lifecycle Management 11.0), Rally, SQL Server 2012, UNIX, Oracle 11g, Datastage, SQL, PL/SQL, Oracle 10g, Agile, MS Office, Teradata 12, DB2, XML, HTML, Windows and Unix, Shell Scripting, SOAP UI, SQL Server Data services 2012.

Confidential, San Francisco, CA

QA Analyst

Responsibilities:

• Analyzed the existing Process plan, requirement docs, and application functional specs in a structured RUP environment.
• Attended meetings and walkthroughs with Business Analyst, Development Lead and QA Team
• Coordinated the key strategic planning, program development, implementation and evaluation committees.
• Analyzed the all types of the document in ordered to achieve the validate all features of the product
• Conducted performance and load testing using Load Runner. Developed the main automation steps in Integra and iTKO LISA automation tool
• Extensively worked with QC to develop full lifecycle Test Plans including business rules and business models for functional, end to end and User Acceptance testing
• Categorized the Test Cases based on priority and managed them in Quality Center. Developed Test Cases to validate the functionality and business logic implementation
• Verified the workflow with different scenarios and created Test Data sets for simulating scenarios
• Experience in writing and executing load scripts using JMeter as well as Load Runner.
• Developed and executed SQL scripts to validate the database activities and data generation
• Performed GREY-BOX tests on application functionalities and verified the interfaces to content
• Execute test scenarios to verify the data transfer and standard formats (XML), Web Service requests and data processing (XML, XML Spy)
• Validate the message response against message specification and against XML Schema
• Responsibility to write the major SQL commands to validate the Web Services update and feed the seed script in order to make test case is recursive
• Major involvement in Regression failures due to customer data problem. Interact with data team to fix the data problem ASAP
• Expertise in MQ and AQ concept to trouble shootings. Unix shell scripting experience for automation of processes
• Led the test engineers in analyzing the data processes and developing test cases.
• Leveraged expertise on XML and XSL, SOAP, Web Services and related tools and techniques, as well as object-oriented coding methodology for application logic, data storage and report generation.
• Extensively worked with XML Spy for editing, analyzing XSL formats and tags and verified Web Services requests and responses.
• Used Altova XML Spy to generate XML, DTD and to create a SOAP request from a WSDL file and then test the service.
• Led the functionality, integration, system and regression testing and executed various test cases to validate the web functionalities and dynamic data contents.
• Performed Regression testing using iTKO LISA test of the entire build according to the change been updated and ensuring by cross validating the entire components of the application.
• Analyzed the iteration plan and studied the task distribution diagrams.
• Worked with simulators and recorders (Web/HTTP) to simulate web transactions, and executed real time scenarios with load (Virtual Users).
• Configured simulators in iTKO LISA to measure performance of the servers (CPU Utilization, Memory, Hits/sec, Response time).
• Worked towards process improvement, and contributed with Templates and workflow formats

Environment: and Tools: iTKO LISA, SOAP UI, Jmeter, Load Runner, Integra (Automation, Simulator and Recorder), IBM MQ Series, Oracle AQ concepts, XML Spy, HP Application Lifecycle Management 11.0, Clear Quest (WIB and Windows client), Clear case, Oracle, Terra data, Java, Eclipse, MS Office, UNIX, SOA Architecture.

Confidential, Foster City, CA

QA Engineer (Performance Testing)

Responsibilities:

• Analyzed the existing Process plan, requirement docs, and application functional specs in a structured Agile environment.
• Participated as a team member in the Agile development process, working closely with the other team members to complete the set sprint assignments and meet production goals.
• Attended meetings and walkthroughs with Business Analyst, Development Lead and QA Team.
• Responsible for supervising the team in the absence of Lead.
• Conducting knowledge transfer session for testing team.
• Proficient in analyzing the SRS (Software Requirement Specifications), Functional Design Documents to formulate Test Plans and Test Strategies.
• Wrote test cases for each valid transaction and reported bugs.
• Involved in Functional, Regression, Integration and Compatibility Testing of web-based application.
• Execute automation test suite for regression testing using Selenium. Involved web service testing using SOAP UI.
• Performed GUI Automation using Selenium.
• Extensively worked with QC to develop full lifecycle Test Plans including business rules and business models for functional, end to end and User Acceptance testing.
• Expertise in MQ concept to trouble shootings.
• Profound knowledge in IIS Manager.
• Validated request/response of data using assertion in SOAPUI. Manually performed back-end testing by writing SQL queries.
• Actively participated in daily bug triage meetings and interacted with developers diplomatically to ensure high quality of the application under test.
• Compared actual and expected test results, discussed the defects in defect meeting with development team.
• Responsible for updating and maintaining the test results in Quality Center (HP Application Lifecycle Management) and Clear Quest for all the defects found during functional and regression testing and follow up of the bug life cycle.
• Used simulators (Web/HTTP) to simulate web transactions. Created test data to cover all positive and negative scenarios.
• Primarily involved in Integration Testing of Web based Application and its integration with the back end application and Database.
• Validated the web elements (links, images, html tags and forms) to ensure user friendliness and verify security features.
• Reporting to QA Manager and coordinating with development team for completion of testing and fixing-bugs tasks.

Environment: and Tools: Windows, UNIX, MAC OS, Selenium, SOAPUI 3.6, Quality Center 9.2, HP Application Lifecycle Management 11.0, Clear Quest, IBM WebSphere MQ 7.0, MS SQL Server, DB2, MS Office, SOA test 9.2, Putty, Agile Methodology, IIS Manager.

Confidential, Fremont, CA

QA Engineer

Responsibilities:

• Involved in Functional Testing, Integration Testing, System Testing, Regression Testing and Load Testing for each release.
• Manually performed back-end testing by writing SQL queries. Performed compatibility testing of the upgraded Oracle database from 9i to 10G.
• Involved in test case development and its execution. Used Groovy Script to create Database Connection
• Used Groovy Script to do conditional Property Transfers for dependent test cases. Executed XML Validation, added assertions in the script using SOAPUI.
• Checked the broken links in the application and conducted cross browser testing.
• Wrote Automation test cases and executed it according to the application. Validated Request and Response data using SOAPUI.
• Coordinate with the team to resolve problems and defects identified during testing. Reported the issues in Quality Center and followed-up with development team
• Part of implementation meetings with project team before deploying the release into production.
• Hands on experience performing performance testing using Jmeter open source tool.
• Worked extensively on Jmeter using web (HTTP/HTML) and webservices.
• Worked with business users to analyze business operational procedures to perform quality testing.
• Coordinated with business users for the User Acceptance Testing.

Environment: and Tools: Sun Solaris, Windows, MAC OS, DB2, ORACLE, MS SQL Server, Quality Center 9.0, SOAPUI 3.5, MS Office, JAVA, Agile Methodology.