SUMMARY:

• 8+ years of extensive experience as a Quality Assurance Engineer/Business Analyst involving in the entire SDLC and working with DWH ETL/BI applications.
• Extensive experience in the Information Technology industry, involving analysis, ETL and BI testing of DWH applications and reporting.
• Extensive Experience in Agile Methodology and waterfall methodologies of SDLC.
• Proficient in writing Test Strategies, Test Plans, Test Cases, Test Scripts and Test Scenarios.
• Experienced in testing requirements that were developed in ETL and BI tools and reviewed scripts for positive and negative test scenarios, and prepared test summary reports.
• Possess extensive experience performing Backend, Frontend, Regression, Functional, System, Interface, Us ab ility, Black box, Integration and User Acceptance Testing.
• Coordinate the testing efforts for: QAT, SIT, UAT, Regression, Smoke, Integration, Migration, Performance, Stress and Data Driven.
• Well experienced in writing complex SQL queries for extracting data from multiple tables.
• Experience in Performance Tuning of SQL and Stored Procedures.
• Technical strengths and automated test tool expertise includes Application Lifecycle Management (ALM), VBScript, SQL and IBM Rational Tool Suite - Rational Clearcase, Rational Doors.
• Responsible for testing packages using SSIS (ETL) to verify data completeness, data transformation, data quality, integration testing, UAT & regression testing.
• Excellent experience in different Databases like Oracle, SQL Server, DB2 and Netezza 7.0.
• Proficient in ALM for Test Designing, Requirement Mapping, Reports and Defect Tracking.
• Hands on expertise in Data ware housing concepts and tools.
• Extensive experience working with ETL tools like DataStage, Informatica, Ab Initio, SSIS, SSRS and AutoSys tools.
• Experience in UNIX shell scripting and configuring cron-jobs for Informatica sessions scheduling.
• Proficient in Rational Clear Quest and Quality Center for Defect Tracking.
• Defined and Implemented Processes and Procedures for QA Departments.
• Possess strong interpersonal skills, communication and presentation skills with the ab ility to interact with people at all levels.

TECHNICAL SKILLS:

Databases: MS Access, DB2, SQL server, Oracle, Netezza 7.0

Data Warehouse Tools: Ab Initio, Informatica 9.1,8.1/7.1, SSIS, MS DTS Packages

BI Tools: Cognos 8, Business Objects XIR3, Crystal Reports, OBIEE

Languages: C, C++, Java, PHP, HTML, XML

Operating Systems: MS Windows 2000/XP/Vista/7, Sun Solaris2.8, Mac OS X, Unix

Requirement/ Defect Mgmt Tools: IBM-Rational RequisitePro, Rational ClearCase, Rational ClearQuest, ALM

Project Mgmt Tools: MS Excel, MS Word, MS Project, MS Outlook, MS SharePoint, Lotus Notes

Business Modeling Tools: OOAD, MS Visio, Rational Rose, UAT

Defect Reporting Tools: Rational ClearQuest, Bugzilla, TFS

PROFESSIONAL EXPERIENCE:

Confidential, Miramar, FL

QA Lead (Functional Testing)

• Understanding the requirement document for changes which are being developed in each build.
• Designing the Test scenarios and Test cases as per the BRD in the Team foundation Server.
• Functional testing by using the UI for NPT application- feed the data into the tabs available for activities by creating a new project.
• Data Preparation for checking the depletion allowances and discount participation in Sapphire and NPT.
• Executing the query for the back-end testing in Sapphire and validating the changes affecting and not affecting the columns as mentioned in the document.
• Executing each test case after validating the result and logging the Defect linked to the failed test cases.
• Attending the weekly meeting to discuss on the execution percentage and defect percentage.
• Regression testing after the bug is fixed in the tool.
• Preparing report each day on execution, defect logged and defect closed as per defect triaging.
• Review in the retrospective meeting after the cycle is complete for that test plan.
• Participate in the requirement gathering meeting of each sprint with the users and developers.
• Responsible to verify and process pricing projects within National Pricing Tool.
• Validating the Test environment for non-pricing related maintenance in OTC system and other data systems as assigned.
• Responsible for validating reports generated from Sapphire on adhoc, weekly, monthly, quarterly and yearly for different locations in the country for NPT.
• Verifying the process entry of orders, different processes for requested credits approved.
• Finding Defects on price discrepancies on pick-ups and returns.

Environment: MS Access, SQL/PL SQL, Team Foundation Server(TFS), Oracle 11g, Informatica 9.1, MS Excel, MS Project, MS Outlook, MS SharePoint, TOAD, MS SQL Server 12.0, Autosys, UNIX

Confidential, Reston, VA

QA / Testing Analyst

• Setup for each version Execution- on the Kanban Board for MIT and S2S Execution (Backlog, Ready, In-Progress Request, In-Progress Response, Complete and Accepted).
• Designed the test cases ALM for Calendar Execution for ARM, FRM & Conversion pools to be sent according to the Use Case Scenarios planned for four Sprints.
• Two-Setup In SharePoint to find each version Documents and to save the files which we are sending to CSP and Files which will be coming in Response from CSP.
• Attended the Sprint Planning Meeting for understanding this sprint Focus.
• ECF files from Upstream Application. Generating MISMO standard file as described by ‘Uniform Mortgage Data Program Initiative’ from ECF file for respective Interface.
• Sourcing and Vending to CSP through GATEWAY server.
• Checking WINSCP out-archive and in-archive for the SENT files from FNMA and Response files from CSP.
• In Case of Exception Received find out the root cause and logging the Defect in I-CART.
• Discussing the Defect in Internal-DRB meeting, E2E meeting and with CSP Team for Addressing Defects, which are resolved, closed, and Deferred Sprint.
• Sending FNMA-MISMO files and Receiving Responses from CSS for various Interfaces.
• Uploading the Database tables, from where the MISMO standard XML file picks the Loans from.
• Generating Reports from ALM, I-CART Defects and Daily FNMA-CSS Dashboard Reports.
• Keeping track of In-scope and De-scoped Scenarios through Execution Calendar and Updating in ALM.
• Working on the SIR-UI for making changes to generate file for one of the Interface.
• Defect triaging meeting with E2E and CSP Teams. Defect Triage- Referred to ISM specification, Requirements from Doors, XML schemas validation for files formation according to Interface to find out the root cause.
• Followed up on development teams for Code, Data, and Environment Defects with Developers, Business in the DRB meeting.
• Also Referred to Test Plan, Use Cases-Scenarios, and Execution Calendar for finding defect in our Internal Document for unspecified behavior which have been encountered.
• On the other hand getting ready to process the files from Backlog, as well execution of files due on that date.
• Reviewing the previous 4 sprints in the Sprint Review Meeting.
• Coordinating with cross functional backend teams for Dependencies.
• Executing Java script for eclipse for taking the file from WINSCP in-archive and out-archive and uploading to SharePoint, validating, do ALM up-date.
• The scripts for automation has been fixed on to do the job without any issues.
• Defect triaging with Internal Application and CSP side for time constraints on Response generation and Error in Reports.
• Tested/Validated several XML Documents using XML Spy and generated XSD’s for corresponding XML documents.

Environment: ETL Informatica, Abinitio, SQL, PL/SQL, Oracle 10g, Selenium, Autosys, XML Spy 2015, UAT, IBM Clearcase, IBM Clearquest, Doors, ALM 11.25, Unified Functional Testing, Regression Testing, Eclipse, TOAD, UNIX.

Confidential, Moline, IL

IT QA Analyst

• Involved in all phases of project starting from planning phase and contributed towards project scheduling and implementations.
• Involved in detailed analysis of business requirements and produced requirement artifacts.
• Collaborated with business and applications team in designing ETL solutions to meet the business requirements.
• Participated in Daily Scrum Meeting, Retro Meetings, PSI and Sprint Planning Meetings and giving Updates.
• Prepared Unit test cases executed them and documented the test results. Managed defect tracking log and resolved defects arising during UAT phase.
• Automation testing using Cucumber and DVO tool for Validation purpose on mapping per Business Rules and planning data for boundary analysis on each field.
• Experience using multiple RDBMS and flat file sources (UDB, Oracle, fixed-width files). Imported the source & target definitions in a shared folder and leveraged short cuts in various mappings and folders.
• Understand complex mappings using various transformations (Source qualifier, Look up (connected and unconnected), Expression, Aggregate, Update strategy, Sequence generator, Joiner, Filter, Rank, and Router transformations) to meet the ETL design specifications.
• Utilized mapping parameters and variables wherever possible for reusability and ease of enhancements.
• Executed sessions, both sequential and concurrent for efficient execution of mappings and used other tasks like email, decision, command and pre/post SQL.
• Prepared command line programs using PMCMD for execution & automating of scheduling via esp. mainframe.
• Project had User interface via SQL queries or tools such as Business Objects and Tableau.
• Testing was on for machine readings - was working in an actual analytic environment.
• Dealt with big data - DB2 and Netezza databases using Toad and Aginity respectively.

Environment: ETL Informatica, SQL, PL/SQL, Oracle,DB2, Netezza, Informatica D.V.O, TOAD, UNIX, Cucumber, SVN, OBIEE, Rally, Aginity, Mainframe

Confidential, NYC, NY

IT QA Analyst

• Written Test Cases for ETL to compare Source and Target database systems.
• Interacting with senior peers or subject matter experts to learn more about the requirements
• Identifying duplicate records in the staging area before data gets processed
• Extensively written test scripts for back-end validations
• Writing complex SQL queries for data validation for verifying the SSIS Packages and business Rules.
• Ensured data integrity and verified all data modifications and calculations
• Developed test cases to accomplish ETL data migration
• Conducted data validation testing
• Tested Informatica Mappings and worked on Staging area to validate the data with SQL Queries.
• Tested various jobs and performed data loads and transformations using different stages of Informatica and pre-built routines, functions and macros.
• Extensively involved in writing & execution of SQL statements for back-end testing and eventually automating them using QTP
• Developed User-Acceptance Test cases and assisted users in conducting UAT
• Validated Crystal Reports by running the SQL queries based on the business rules.
• Testing the source and target databases for conformance to specifications
• Written SQL scripts to test the mappings.
• Create and execute test scripts using Mercury Test Director parameterized scripting
• Used ALM 11.25 as the test management tool for the maintenance of the test cases and to track the defects.
• Validating the Target data based on the test cases.
• Involved in creation of defect analysis report for system Test and UAT.
• Worked in importing and cleansing of data from various sources like DB2, Oracle, flat files onto Oracle 10g with high volume data.
• Extensively used Toad to verify records that has been populated by ETL process.

Environment: ETL, SQL Server 2005, BI Crystal Reports, XML, SSIS, TOAD, UNIX, UAT, Shell Scripting, XML Spy, Windows XP, Oracle 8i, Test Director, QTP, Load Runner

Confidential

• Interaction with the business users and analyzed the business requirements.
• Generation of various financial reports using Oracle APEX for individuals, businesses, institutions and the organization itself to have a track record of the direction and volume of investment flows.
• Finding of the errors at the earliest and shoot reconciliation.
• Maintenance of accounts with proper business requirement details that is helpful for both the organization and the clients.
• Worked closely with UAT team on bug tracking and defect resolution.
• Participated in code deployments and best practice implementation.
• Developed PL/SQL scripts and SQL as per client requirements using Oracle 11g.
• Extensively worked on TOAD, SQL*PLUS for code development.

Environment: Oracle 11g, TOAD, Oracle APEX, PL/SQL, UNIX Solaris 10, MS Windows Advanced Server 2003, SQL Management Studio, .NET Framework, Database Maintenance Plan Wizard