SUMMARY:

• Experience in Requirement Analysis and documentation
• Developed several innovative automation tools to abet Development/Testing activities
• Hand on experience on ETL tools, QTPV10.0, Quality center V11.0
• Experience in Bug Tracking and Bug Reporting using Quality Centre, BugZilla
• Highly proficient in Functional testing, Integration testing, System testing, Regression testing, User Acceptance Testing (UAT) and Cross Browser testing (IE/Firefox/Chrome/Safari) in different Operating Systems (Win XP/2003)
• Experienced in estimation, planning, task assignment and resource management.
• Good knowledge in using Data structures and Algorithms.
• Authoring / reviewing test scripts & Test Scripts Execution
• Proactive, need minimal supervision to execute plans, attain objectives and meet deadlines
• Sound knowledge and Experience in Software Quality Assurance with Waterfall and Agile Models
• Broad experience of testing in different sectors: Procurement, Healthcare, Insurance & Investment Banking
• Experience in web service testing using SOAP UI
• Good experience in working with UNIX scripts for loading the files into tables.
• Process Commendable knowledge on Application development using ASP.NET, VB.NET and C#
• Participated in cross - functional teams to reengineer and improve business processes.
• Worked on  black box/white box and functional testing . Worked on application testing and data warehouse testing.
• Excellent Knowledge of Database Systems - Oracle 10g, SQL Server, DB2 and Data ware house concepts.
• Extensive Working experience in applying Relational Database Concepts, Entity Relation diagrams and Normalization concepts.
• Extensively used ETL methodology for supporting data E xtraction, T ransformations and L oading processing, in a corporate-wide-ETL Solution using Informatica
• Expertise in  Data Warehouse and ETL Verification
• Extensive testing ETL experience using  Informatica 9.X(Power Center/ Power Mart) (Designer, Workflow Manager, Workflow Monitor and Server Manager).
• Expertise in extended validation of report functionality testing, using BI tools like SAP BO
• Knowledge on Reporting tools like Tableau

EXPERTISE AREA:

• Business Analysis, Requirements analysis, User discussions, review and traceability
• Application testing management, Creating Test plans with an assortment of test cases Managing testing activities, status reporting, coordination with development teams for bug fixed
• Team Coordination, conducting meetings with stakeholders, users and team members, managing project discussions, Onsite-Offshore coordination
• Process Documentation, frequent review and ongoing improvement of Requirement Management / testing process planning
• Functional testing, Functional testing of modules, Analysis of defects reported for functionality validation, reviewing severity of bugs reported, Status reporting
• Process Improvements; identify process improvements and suggesting the same during and after project implementations
• Presentation, Strong communication, problem solving, organizational, interpersonal, and presentation skills
• Status Reporting to Client Managers and Project Management with respect to Requirements, Defects, Issues, Risks and assumptions

TECHNICAL SKILLS:

BI Tools: Quick Test Professional (QTP), Quality Center, Windows 9x/XP/2000/2003 Server/Vista, Informatica Power Center, SAP Business Objects, Tableau

Programming Knowledge: C, C#.Net,AJAX,HTML,SQL,XML, VB Script, Excel Macros

Other Utilities and Tools: Informatica 9.0, VSS, Beyond Compare tool, ESP Scheduler CA WorkStation

Database: Oracle, My SQL,MS SQL Server, MS Access, TOAD

PROFESSIONAL EXPERIENCE:

Confidential

Test Analyst, Eagan, Minnesota

Technology : Informatica9.0, ETL, MS SQL Server, Quality Center

Responsibilities:

• Developed Test Plans, test scripts and executed the test scripts for PDE DW Project.
• Thorough out the project in various iterations/Sprints - conducted system testing, integration testing, functional testing and integration testing.
• Tested Dashboard/Ad-hoc reports using SAP BO Reporter functionalities like Master Detail and Formulas, filters, conditions, sorting, Alerts, Cascading Prompts and export to options.  
• Experience in creating UNIX scripts for file transfer and file manipulation.  
• Prepared the Test Plan and Testing Strategies for Data Warehousing Application
• Developed ETL test scripts based on technical specifications/Data design documents and Source to Target mappings.
• Extensively interacted with developers, business& management teams to understand the PDE project business requirements and ETL design document specifications.
• Extensively used and developed SQL scripts/queries in backend testing of Databases.
• Prepared daily status reports with details of executed, passed, and failed test cases and defect status.
• Tested a number of complex ETL mappings, mapplets and reusable transformations for daily data loads.
• Creating test cases for ETL mappings and design documents for production support
• 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 test the flat files data in the databases.
• Extracted data from various sources like Oracle, flat files and DB2 server.

Confidential 

Technology: Informatica9.0, ETL, MS SQL Server,Quality Center

Responsibilities:

• Verify the implemented ETL code against the corresponding mapping document
• Involved in daily Scrum meetings (Agile Methodology). Also involved in Iteration/Sprint planning meeting to plan the stories that needs to be developed and tested in the upcoming sprint based on the priority and estimated effort
• Experience in Web service testing using SOAP UI.
• Prepared the Test Plan and Testing Strategies for Data Warehousing Application
• Involved in testing the Informatica mappings, by validating whether the mapping adhere to the development standards and naming conventions; whether the mapping do what the technical design says it should do. 
• Tested Dashboard/Ad-hoc reports using SAP BO, Reporter functionalities like Cross Tab, Master Detail and Formulas, filters, conditions, sorting, Alerts, Cascading Prompts and export to options.
• Conducted various management activities by analyzing and verifying test results, providing status reports. 
• Involved in Regression, Functional, Integration, System Testing and User Acceptance Testing
• Performed verification of UNIX logs using Putty while performing the testing.
• Performed Black box, Integration, Regression, Systems, and Backend testing
• Tested a number of complex ETL mappings, mapplets and reusable transformations for daily data loads.
• Confirm the data loads from source files into staging table and staging table to target table.
• Setting up the environment using CA Workstation.
• 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. 
• Wrote complex queries to compare the counts and data from source to target.
• Validate Source data and the compare it with the target data
• Running the Informatica workflows in Test Environment
• Writing the Test scripts
• Writing complex SQL queries using Case Logic, Intersect, Minus, Sub Queries, Inline Views, and Union in Oracle
• Assign and monitor the offshore work and coordinate with external teams
• Assign defects to Dev team and track the reports and send it to Management

Confidential

QA Test Analyst, Columbus, OHIO

Technology: Informatica9.0,ETL,MS SQL Server,Quality Center, Teradata

Responsibilities:

• Verify the implemented ETL code against the corresponding mapping document.
• Confirm the data loads from source files into staging table and staging table to target table.
• Setting up the environment using CA Workstation.
• Designed policies, standards and procedures for testing life cycle for the data warehouse and datamarts.
• Written test cases for checking the populated data correctly into fact and dimension tables.
• Used TOAD Software for Querying ORACLE. And Used Teradata SQL Assistant for Querying Teradata
• Extensively used Informatica power center for extraction, transformation and loading process.
• Conducted extensive manual Black Box testing to better understand the functionality of the Application.
• Test Environment Setup and Performed the  Functional and Regression  Testing
• Created the Macros using VB scripting to validate the data transformation from source to target.
• 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. 
• Writing complex SQL queries using Case Logic, Intersect, Minus, Sub Queries, Inline Views, and Union in Oracle. 
• Worked with data analysts to implement Informatica mappings and workflows, shell scripts and stored procedures to meet business requirements.
• Performing backend testing of the DB by writing PL/SQL queries to test the integrity of the application and Oracle databases.
• Wrote and modified SQL validation scripts, and writing scripts in SQL to validate the outputs.
• Wrote complex queries to compare the counts and data from source to target

Confidential  

Technology: Informatica9.0,ETL,MS SQL Server, Quality Center ,Teradata

Responsibilities:

• Throughout the project in various iterations/Sprints - conducted system testing, integration testing, functional testing and integration testing.
• Developed complex SQL queries for querying data against different data bases for data verification process.
• Prepared the Test Plan and Testing Strategies for Data Warehousing Application
• Developed ETL test scripts based on technical specifications/Data design documents and Source to Target mappings.
• Conducted Functional testing, Regression testing, Integration testing, User Acceptance Testing (UAT) and Data validation testing.
• Developed automated regression test scripts for all the identified test scenarios
• Participated in functionality testing and regression testing
• Involved in automation testing using QTP.
• Formulating the QA plan for black box testing of the application including Functional, Regression, Integration, Systems and User Acceptance Testing.
• Performing database testing to verify backend database transactions.
• Wrote complex queries in Teradata SQL assistant to analyze the data
• Working on conversion of manual tests into automated test scripts
• Status reporting with Clients and Business users
• Working on preparing the test scenarios for data validation
• Co-ordinate with the offshore team to explain the test case scenarios and provided clarifications to their queries.
• Validate the Actual and expected results and reported the defects to IT team
• Crims to Confidential Sub advisors, Crims to Confidential Positions and Portfolio interfaces etc were validated by connecting to Crims database (written sql queries based on transformation mapping) and compared the input and output files with Confidential (MS Access).
• Worked in CRIMS (Trade Order Management System), Perfdb, Funds 2000, Eagle (performance) and Confidential (Accounting System) systems

Confidential 

Technology: Informatica, JAVA, Wicket Framework, MS SQL Server, QTP

Responsibilities:

• Performed Verification, Validation, and Transformations on the Input data (Flat files) before loading into target database.
• Validated data in between source and target after running Mappings by the developer team.
• Participated in User Acceptance testing (UAT) and involved in UA test cases, Executed test cases, Documenting Defects, Resolved defects and Signed Off from Application.
• Involved in Test Plan, Test Scenarios, Test Scripts preparation and review phases
• Close coordination with business users, Designers, Development and Test teams
• Status reporting with Clients and Business users
• Working on preparing the test scenarios for data validation
• Co-ordinate with the offshore team to explain the test case scenarios and provided clarifications to their queries.
• Involved in Regression, Functional, Integration, System Testing and User Acceptance Testing
• Validate the Actual and expected results and reported the defects to IT team
• 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 

Confidential

Technology: Informatica, JAVA,Wicket Framework, MS SQL Server

Responsibilities:

• Performed Business Validation for the data in new system (FODS) against current legacy system (FIRS) and reported all the defects found to IT team. 
• Close coordination with business users, Designers, Development and Test teams
• Handled team (5 associates) for executing test phase
• Working on preparing the test scenarios for data validation.
• Co-ordinate with the offshore team to explain the business requirements and provided clarifications to their queries.
• Interacted with the business users for new requirements.
• Analyzed and applied the business rules for new requirements in the project.
• Prepared the Test Plan and Testing Strategies for Data Warehousing Application
• Preparation of technical specifications and Source to Target mappings
• Manually performed Ad-Hoc testing, end-to-end testing, and system testing.
• Performed manual testing by entering positive values, negative values, and boundary values to the application.

Confidential

Technology: VisualStudio.Net 2008, Microsoft SQL , QTP

Responsibilities:

• Application Business requirement gathering
• Understand the test scripts
• Automate the Manual scripts
• Assisting Team Lead in customer and application related meetings
• Attending application management training
• Building team confidence by conducting knowledge transfer sessions
• Good experience on Technical documentation
• Conducted Functional testing, Regression testing, and Data Validation Testing
• Developed automated Test scripts using QTP to perform Functional and Regression testing
• Executed and managed test cases and reported bugs in Quality Center