SUMMARY:

• Over (7+) experience, Seeking an opportunity as Software Tester/QA Analyst/ Test Automation Engineer or Senior QA Consultant to contribute technical knowledge,Specializing in e - commerce, mobile banking, financial and Telecommunication industries. Experienced in all aspect of Software Development Life Cycle (SDLC) Policy, QAPrinciples, Software Testing Life Cycle (STLC), Test Methodology, Change Management, Configuration Management, Risk Analysis and GAP analysis.
• Solid understanding in QA Methodologies, Test strategy, Test metrics, Software Development Life Cycle (SDLC) and CMMI.
• Strong in Analyzing Business specifications with regards to Test Case Scenarios.
• Expert in software test automation, test tools like Quick Test Pro, Load Runner, Quality Center and PVCS Tracker.
• Extensive knowledge in Relational Database Management System (RDBMS), and expert in writing complex queries using SQL/ PL SQL.
• Extensive knowledge in using Quality Center and PVCS Tracker tool to report bugs/ defects.
• Performed all kinds of testing such as Smoke Testing, Functional Testing, Negative Testing, Boundary Testing, Regression Testing, Ad hoc Testing, System Testing, System Integration Testing, Sanity Testing, Load Testing, Stress Testing, Volume Testing and Cross Browser Testing.
• Experience in writing and executing Automated Test Scripts, Tracking Defects and interacting with the development team in correcting the defects.
• Experience in preparing Test Plan/Technical specification/ Strategy Documents.
• Conduct internal reviews to measure and assure adherence to established QA standards for software development, and corresponding documentation.
• Ensured the execution of UAT test cases and documentation of test results. Provided UAT testing status information to the quality assurance lead, project manager, and various business stakeholders.
• Excellent knowledge in SQL, Sybase and Oracle databases.
• Involved in writing SQL Queries using Rapid SQL for Sybase database and SQL Developer for Oracle Database for Data conversion.
• Verified and validated testing results by accessing and querying databases using SQL
• Executed SQL Queries using the simple and complicated join.
• Experience in focusing on delivery high quality, reliable results within aggressive deadlines, and meeting technical requirements.
• Experienced in analyzing Business Requirements and Specifications.
• Excellent verbal and written communication skills and a good team player. Fast in learning new ideas, processes, concepts and technologies.
• Experience in Mobile testing on IOS, Android,Blackberry and Kindle mobile operating systems.
• Expertise in Manual and Automation Testing and User Interface testing on Android mobile applications on IOS platform.
• Experience in Mobile, i-pad, Tablet Testing using Browser Stack.

TECHNICAL SKILLS:

ETLtools: InformaticaPower Center 9.1/8.X/7.X, Ab Initio, Data stage, SSIS, Replication server, info sphere Replication server

Databases: Oracle 8i/9i/10g, MS SQL, DB2, Teradata V2R6/V2R5, SQL Server 2003/2005/2008, DB2data management studio, postgresql

Methodologies: Waterfall, Agile/Scrum, RUP, Compass

Reporting Tools: Cognos, Business Objects BOXI, QlikView, Crystal Reports

Test Management Tools: HP Quality Center 10.0/9.0/8.2, Rally, TFS

Data Access Tools: TOAD, SQL Navigator, Oracle SQL Developer, data management

Programming Languages: SQL, PL/SQL, Java,.NET3.5

Modeling Tools: MS Visio, Rational Rose 6.0

Requirement Tools: Rational Requisite Pro, DOORS

Version Control Tools: Rational Clear Case, Win Confidential, SharePoint

Scheduling Tools: Autosys, Informatica Job Scheduler

Incident/Defect Management Tools: BMC Remedy, Clear Quest, Quality Center, TFS, Rally, Bugzilla

Operating Systems: MS DOS, Win 98/2000/XP, UNIX, Linux

Other Tools: Web Services, Win SCP, PuTTY, Compare IT, Text Pad

PROFESSIONAL EXPERIENCE:

Confidential, NYC NY

Sr. ETL SQL QA BI Test Analyst

Responsibilities:

• Responsible for defining the Test Strategy, creating the Test Plans and the Test cases basing on the Business requirements document.
• Review Business and Functional Requirements and develop Detailed Test Plan and Test Cases
• Interact with Business Team and Development Team to review Detailed Test plan and Test Case document
• Conducted Weekly Onsite-Offshore Status Meetings.
• Interaction with Client and Offshore team members on daily basis
• Experience in Leading the Offsite Project, managing a team of 8 Offshore and 4 Onsite consultants
• Interaction with Client and Offshore team members on daily basis
• Perform extensive Integration Testing involving Database and System Testing
• Validating the web server logs using UNIX commands and wrote Unix Shell Scripts to perform batch jobs.
• Validate Web services built in SOA Architecture using SOAP UI and HP Service Test tool
• Performed Integration testing with the Web Service and overall System testing.
• Designed and Developed data validation, load processes and test cases using PL/SQL, SQL.
• Perform extensive Backend Testing using SQL scripts to pin point the breakage in the Data Flow
• Tested source to target data mappings using SQL commands.
• Responsible for performing ETL Data Migration validation and Data Integration validation.
• Involved in a team for testing ETL process which constitutes five major processes and Installed Data Stage Client.
• Tested Informatica mappings by writing SQL queries.
• Wrote complex SQL queries to verify data in the target tables
• Responsible for creating and executing QTP Scripts to perform Functional and Regression Testing
• Exposure HP QTP Automation using VB script and Descriptive programming.
• Read test data from Excel,write test results back to Excel.
• Run our test Automation DDF framework, Developed the VB scripts in Quick Test Professional 11.0
• Responsible for raising defects using HP Quality Center and track them to closure
• Create Defect Status report for Development Team and Stakeholders on a daily basis.
• Responsible for generating reports using HP Quality Center to deliver the End of testing notes to various teams that would help analyzing loopholes.
• Work with the Business Team to review UAT validation scenarios and execute the UAT test cases
• Updated SharePoint Document Management tool for accessing and updating the Test deliverables
• Responsible for performing Post Deployment validation at the time of release / implementation
• Conduct Test Status meetings with the Business Team,QAManager, and Development team to review Test Progress and discuss business critical issues identified during application validation.
• Created test cases in test plan and executed them from test lab in Quality Center.

Environment: XML, Oracle, UNIX, Windows, Soap UI, QTP 11.0, HP Quality Center 11.0, HP ALM 11.0, UNIX, Autoys, SOAP UI, Informatica 9.5, ETL, Business Objects XRI3 SQL, Pl/SQL, Oracle 11g, SQL Server 2010.

Confidential, Charlotte, NC

Sr. ETL SQL QA BI Test Analyst

Responsibilities:

• Analyzed business requirements, system requirements, data mapping requirement specifications, and responsible for documenting functional requirements and supplementary requirements in Quality Center 9.0
• As a Test Lead Created Test plan, Test scenarios and test cases
• Worked with leadership team to analyze current SDLC process and recommended process improvements
• Experience in Leading the Offsite Project, managing a team of 8 Offshore and 4 Onsite consultants
• Experienced in co-ordinating resources within Onsite-Offshore model
• Ensuring smooth onsite to offshore transition of requirements and conducting knowledge transition sessions.
• Involved in developing detailed test plan, test cases and test scripts using Quality Center for Functional and Regression Testing.
• Performed Black-box testing, White-box testing, System Testing, Data Integrity Testing, Sanity, Regression and end-end testing
• Used workflow manager for session management, database connection management and scheduling of jobs.
• Captured business requirements for reconciliation reports and designed metrics in Microstrategy
• Implemented Database Checkpoints for Back-end Testing
• Perform extensive Backend Testing using SQL scripts to pin point the breakage in the Data Flow
• Design and populate test data for ETL/Aggregations, DW & MicroStrategy BI reporting projects
• Extracted Data from Teradata using Informatica Power Center ETL and DTS Packages to the target database including SQL Server and used the data for Reporting purposes.
• Used multiple data providers, Master/Detail, cross tab, Charts.
• Involved in gathering the requirements for the Operational Reports.
• Helped the Testing team by writing SQL statements to validate the reports
• Used multiple data providers, Master/Detail, cross tab, Charts.
• Involved in the error checking and testing of the ETL procedures and programs Informatica session log.
• Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing).
• Developed business process models in RUP to document existing and future business processes for the data warehousing.
• Developed and involved in both Manual Testing and Automation Test scripts based on Use cases developed.
• Involved in Data mapping specifications to create and execute detailed system test plans. The data mapping specifies what data will be extracted from an internal data warehouse, transformed and sent to an external entity.
• Solid testing experience in working with SQL Stored Procedures, triggers, views and worked with performance tuning of complex SQL queries.
• Used T-SQL for Querying the SQL Server database for data validation and data conditioning Experienced in data analysis using SQL, PL/SQL and many other queries based applications.
• Experienced in writing test cases, test scripts, test plans and execution of test cases reporting and documenting the test results using Mercury Quality Center.
• An extensively used Complex SQL statement for retrieving data using TOAD and it is used in TSL scripts
• Tested Complex ETL Mappings and Sessions based on business user requirements and business rules to load data from source flat files and RDBMS tables to target tables.
• Created the test environment for Staging area, loading the Staging area with data from multiple sources.
• Extraction of test data from tables and loading of data into SQL tables..
• Tested several stored procedures.
• Worked with Equivalence Partitioning and divided the input data into various partition of data based on test case condition.
• Tested the ETL process for both before data validation and after data validation process. Tested the messages published by ETL tool and data loaded into various databases
• Responsible for Data mapping testing by writing complex SQL Queries using WINSQL
• Experience in creating UNIX scripts for file transfer and file manipulation.
• Validating the data passed to downstream systems.
• Worked with Testing Data Extraction, Transformation and Loading (ETL).
• Involved in testing data mapping and conversion in a server based data warehouse.
• Involved in testing the UI applications
• 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: Informatica 9.1/8.6/8.1/7.1/6.1, SQL,PL/SQL, HP Quality Center 10, HP QTP 10,Rational Clear Quest, MS Excel, MicroStrategy 9.0, MS SQL Server, 2005/2008 SSIS, SSRS, SSAS,Teradata 12.0 (Multi-LOAD, Fast-LOAD, FAST EXPORT, TPUMP, BTEQ), Teradata SQL Assistant, Korn Shell Scripting, UNIX, XML, XSLT, XSD, XPath, XML Spy 2010, MVS, COBOL II, JCL, VSAM Files, Copy Books, TSO, Putty

Confidential, Woonsocket, RI

Sr. ETL QA DWH SQL BI Test 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.
• Designed the data flow diagrams using VISIO.
• Prepared the Test Plan and Testing Strategies for Data Warehousing Application.
• Reviewing the project and coordinating with onsite Clients, onsite Project Leads and local reporting managers.
• Ensuring onsite to offshore transition, QA Processes and closure of problems & issues.
• 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
• Extensively worked with Metrics, Filters, Transformations, Custom Groups, and Consolidations using Micro Strategy tools
• Worked with SOAPUI for testing Web Services
• Tested both the Web Service Architecture and Service Oriented Architecture
• Created several SOA test cases for validations which were based on the behavior of a specific service.
• Written test cases to test the application manually in Quality Center and automated using Quick Test Pro.
• Created project plans for development of MicroStrategy projects.).
• Development and MicroStrategy Development Teams for external clients and internal management executives.
• Developed automated test scripts from manual test cases for Regression testing based on the requirement documents using Quick Test Professional.
• Written Test Plans and Test Cases on Mercury’s Test Director Tool.
• Defects identified in testing environment were communicated to the developers using defect tracking tool Mercury Test Director.
• Developed scripts, utilities, simulators, data sets and other programming test tools as required for executing test plans.
• Tested several Ab Initio graphs for each line of business and created test data for the same.
• Tested a number of complex ETL graphs, transformation logic for both full load and daily data loads.
• Creating test cases for ETL graphs and design documents for production support.
• Setting up, monitoring and using Job Control System in Development /SIT /QA/ UAT/ 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.
• Reported bugs and tracked defects using Test Director 6.5
• Worked with ETL group for understating mappings for dimensions and facts.
• Extracted data from various sources like Oracle, flat files and SQL Server.
• Worked on issues with migration from development to testing.

Enviroment: Ab Initio (GDE 1.15, Co>Op 2.15),,PL/SQL, SQL, SQL Server Analytical Server, SQL Server Reporting Server, TOAD 9.2, Oracle 9.2, HP Quality Centre 9.2, DB Artisan 8.5.2, Autosys, Metal (Meta Data Driven ETL), MicroStrategy 8.2. BI Reports, MS Access, MS Excel, MS PowerPoint, Microsoft Share Point, Unix Shell Scripting, Windows NT/XP//200

Confidential, New York, NY

EDW Tester/ Report BI Test Analyst

Responsibilities:

• Developed and tested all the backend programs, Informatica mappings and update processes Populated the Staging tables with various Sources like Flat files (Fixed Width and Delimited), Relational Tables in Oracle, DB2, MS Access
• Generated and Executed SQL Queries to be fired on the Repository Tables to analyze the results of the Sessions
• Identifying field and data defects with required information in ETL process in various jobs and one to one mapping.
• Tested Complex ETL Mappings and Sessions based on business user requirements and business rules to load data from source flat files and RDBMS tables to target tables.
• Created the test environment for Staging area, loading the Staging area with data from multiple sources.
• Extraction of test data from tables and loading of data into SQL tables.
• Validated the data in the reports by writing simple to complex SQL queries in the transactional system
• Executed the Test cases for Cognos Reports.
• Performed segmentation to extract data and create lists to support direct marketing mailings and marketing mailing campaigns.
• Extensively tested several Cognos reports for data quality, fonts, headers & cosmetic.
• Oversaw the historical loads in UAT and PROD environments.
• Also worked on Integration of all the processes in UAT/PROD.
• Optimizing/Tuning several complex SQL queries for better performance and efficiency.
• Prepared the test cases after thorough analysis of each requirement.
• Prepared test data by modifying the sample data in the source systems, to cover all the requirements and scenarios.
• Conducted and actively participated in reviews, walkthroughs of test cases.
• Reviewed the ETL mappings (Informatica) to ensure the transformation rules are applied correctly.
• Designed test plans, scenarios, scripts and traceability matrix.
• Assists in developing detailed testing estimates and timelines.
• Prepared test cases and test data by using requirement documents.
• Involved in testing of Pearson website by using web services.
• Write and execute complex SQL queries to validate actual test results match expected results.
• Involved in loading of data into database through UNIX.
• Validated the source and target data count.
• Involved in writing of SQL scripts.
• Validated the XML files by using Altova XML spy and against XSDs which are posted in the JMS topic.
• Document software defects, using a bug tracking system, and report defects to software developers.
• Involved in defect tracking meetings.
• Executed the workflows in the workflow manager, to start the ETL process.
• Worked on UNIX Shell wrapper scripts
• Worked on Autosys which involved in creation of Autosys jobs, execution.
• Worked on issues with migration from development to testing.
• 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

Environment: Informatica 6.1, MVS, UNIX (K-Shell Script), Oracle 8i/9i, SQL Server 2000, DB2, Windows 2000 Pro, XML, XSLT, XSD, Rapid SQL, PL/SQL, TOAD, Dat Files, XML Files, Autosys