SUMMARY:

• A self - motivated, responsible and reliable team player with a set of strong technical skills.
• Software Test Engineer with over 8+ years of experience in Software Testing, IT support, Test Automation development and testing ETL, Data warehouse, Client/Server and web applications.
• Expertise lies in Functional testing, Manual Testing and Automated Testing, Back end Testing, Regression testing, User Acceptance testing (UAT), System testing, Integration testing Ab Initio and Black Box Testing.
• Experienced in testing and implementation of JIRA from source code with customization
• Extensively used HP Quality Center and Mercury Test Director for Test Estimation, Test Planning, Test Designing, Test Analysis, Test Execution, Defect Tracking and Test Result.
• Expertise in testing of new smart list in Great Plains for Periodic reporting
• Experience in ETL methodology for supporting Data Extraction, Transformations and Loading Process in a corporate-wide-ETL solution using IBM Datastage8.0,7.X /6.X (Manager, Designer, Director, Administrator), Parallel Extender, Data Mining, OLTP, OLAP
• Experience in Testing knowledge of Great Plains and Microsoft CRM processes.
• Experience in Testing BI applications using OBIEE, SSRS.
• Behavior driven development approach to write automation test script to test web applications with Selenium-Cucumber
• Worked with Cucumber, using Selenium web driver to test web application and mainframe applications.  
• Diversified experience in Manual and Automated testing; extensively used automated Testing Tools such as Mercury Interactive Test suite in both Windows and UNIX environment (Win Runner, QTP and Test Director).
• Proficient in Defect management, including Defect creation, modification, tracking, and reporting using Industry standard Tools like Quality Center(QC )11,/ALM, Test Director, JIRA, Clear Quest
• Tested trading partner specifications and EDI mapping guidelines
• Experience in writing complex SQL, Oracle PL/SQL queries including calling stored procedures by passing parameters, functions using SQL Developer and Toad as development tools.
• Familiar with SQL Server, Oracle PL/SQL Packages, Stored Procedures, Functions & Triggers.
• Experienced in dealing with clients to gather requirements, understanding the Business Requirements, product demonstrations and providing product support.
• Experience in full Software Development Life Cycle (SDLC) (designing, debugging, testing, Documentation, maintenance and enhancement).
• Having excellent problem solving and analytical skills and experience of test plans, strategy and Procedures throughout the life cycle of a project from specification reviews through to user Acceptance.
• Perform migration and testing of static data and transaction data from one core system to another.
• Writing and executing SQL queries to ensure data integrity to meet user requirements exposure in Database testing.
• Experience in testing automation scripts with Win Runner for all the components of application.
• Experience in data analysis and problem solving with large amounts of data
• Work across multiple functional projects to understand data usage and implications for data Migration.
• Proficient in automating the QA process using various automation tools QTP, Load Runner, & Quality Center.
• Exported Manual Test Cases from MS Excel template directly to HP Quality Center and executed all the Test Cases in Quality Center with Pass/Fail/Blocked status.
• Experience in Load runner using various technologies like WEB, SOA.
• Prepare data migration plans including migration risk, milestones, quality and business sign-off details.
• Hands on experience with analysis of business, technical, and functional requirements and Tested the test plans, test cases and test strategies.
• Experience with software test management tool HP Quality Center/ALM.
• Familiar with the use and working of Rational Requisite Pro for requirements management.
• Expertise in Data Warehouse, ETL Verification, BI reports.
• Experienced in web and client/server applications QA testing.
• Expertise in QA Testing in distributed Unix Environment and Oracle databases as back end, Performed end-to-end testing & back-end testing.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 9.5/8.x/7.x,Ab Initio GDE 1.15/1.14 / 1.13 / 1.12, DataStage9.1/8.0/ 7.x/6.x, Operating System 2.15/2.14 / 2.12 / 2.11 , EME

Data Bases:  Oracle11i/ 10g / 9i / 8i / 7.x, Mainframe via web3270, DB2 UDB, MS SQL Server 2008/2005/2000 / 7.0 , MS-Access, TeraData v2r6

Development Languages:  SQL*Plus, T-SQL, PL/SQL 2.2 / 8.x, Unix Shell Scripting, TOAD 7 / 7.6, SQL Loader, VBA

Operating Systems:  UNIX, Windows vista / XP / 2000 / NT / 98 / 95.

BI Tools: Congo’s 10.1/8.4, business objects xir3, ssrs, ssas, olap

Data Modeling Tools:  Erwin 9.5/7.3/ 4.1 / 4.0

Methodologies:  Ralph Kimball’s Data modeling, Star and Snowflake Schema Modeling

Testing Tools:  Mercury Quality Center 9.0 / 8.0, Test Director 7.6 / 7.0, Quick Test Professional 6.5 / 5.6, Win Runner 7.5 / 7.0, Load Runner, HP,ALM

Workflow Tools:  PUTTY, WinSCP3, MS-Project, MS-Excel, MS-PowerPoint, MS-Word.

Management Tools:  Peregrine Service Center 5.1, HP Project and Portfolio Management Center (ITG) 7.1

PROFESSIONAL EXPERIENCE:

Confidential, Warren, NJ

Sr ETL Tester

Environment: Informatica Power Center 9.1, Quality Center, Windows NT, Microsoft Great Plains, Micro Strategy, Oracle11i/10g, SQL Server, PL/SQL,JIRA, Toad, VSAM Files, XML, XSD, HP Quality center/ALM.

Responsibilities:

• Worked with Data Completeness, Data Transformation, Data Quality, Integration testing, Performance, Scalability and Regression Testing.
• Documented the validation rules, error handling and test strategy of the mapping.
• Tuned the complex SQL queries for better performance by eliminating various performance bottlenecks.
• Tested software defect via JIRA
• Compared the actual result with the expected results. Validated the data by reverse engineering methodology i.e. backward navigation from target to source.
• Created temporary tables for validations after understanding the transformation logic.
• Tested several UNIX shell scripting for File validation and also PL/SQL programming
• Tested complex mappings using Mapplets and reusable transformations.
• Established and documented ETL QA standards, procedures and QA methodologies.
• Verify development of rule-set test scenarios, test cases, expected results and analysis of XML test scripts
• Troubleshoot to resolve problems in an existing JIRA installation and implement all approved changes
• Extensively Used HP Quality Center (QC)/ALM as test management tool and Created and maintained the defects in HP Quality Center/ALM.
• Involved in testing data reports. Written several SQL queries for validating the front-end data with backend.
• Conducted back to back meetings with developers and discussed about all open issues.
• Conducted test case daily reviews to ensure scenarios accurately capture business functionality.
• Worked with ETL Source System and Target System (ETL Mapping Document) for writing test cases and test scripts.
• Written several SQL statements to confirm successful data transfers between source and target.
• Worked with data profiling, data scrubbing and data cleansing.
• Tested Standard Reports, Cross-tab Reports, Charts, Master-Child Drill through Reports and Multilingual Reports

Confidential, Philadelphia

ETL Data stage Tester

Environment: IBM Web sphere Data Stage 9.1 /8.5/ 8.0.1/8.0/7.5/7.1 , HP Quality center9.2, QTP 9.2 Selenium, SQL server SSIS (2005), SQL server SSRS (2005), SSAS, Teradata V2R6, Windows 2000, T-SQL, SQL Plus, UNIX, Rational Clear Case, , DB2 8.x, IBM AIX 5.5, MVS, ISPF, VSAM Files, Flat Files, XML Files, Shell Scripting, PERL, XML, XSD, TOAD, Win SQL, HP ALM.

• Tested the Online Services application to ensure that the requirements, artifact from each phase, and the final product--are complete and correct.
• Identified the requirements and arranged peer reviews, walkthroughs and sign off meetings.
• Defining and performing the Test strategies and associated scripts for the verification and validation of the application and ensuring that it meets all defined business requirements and associated functionality.
• Monitor security batch processing jobs in multi-platform shop via Control-M & Tidal Schedulers.
• Interacting with the Offshore Team members about the project status thru Conference calls and need to prepare a Teams of Memorandum for the same.
• Used Data Stage to move data to the warehouse using the stored Procedure thereby enabling faster Moment of data.
• Performed backend testing and reviewing DB tables for updates
• Used the Data Stage Director and its run-time engine to schedule running the solution, testing and debugging its components, and monitoring the resulting executable versions.
• Performed the Unit and functional testing which validate the data is mapped correctly which Provides a qualitative check of overall data flow up and deposited correctly in Target Tables
• Tested the application for web functionality, and verified the online modules for broken links.
• Performed SQL validation to verify the data extracts and record counts in the database tables.
• Tested policies, standards and procedures for testing life cycle for the data warehouse and data marts.
• Performed usability testing frequently to ensure continuous availability of online services to Personal clients.
• Extensively written Teradata SQL Queries, creating Tables and Views by following Teradata Best Practices.
• Attended the Requirements reviews, Design reviews, Code reviews to understand the overall Process flow and Source to Target Mappings.
• Writing SQL Queries to retrieve data from data base.
• Responsible for testing packages using SSIS (ETL) to verify data completeness, data Transformation, data quality, integration testing, UAT & regression testing.
• Tested transformation functions and record formats for various input data files.
• Tested all formats of SSRS reports including Excel, PDF, CSV, XML, TIFF and many other
• Tested the SSRS report functionalities like Queries, Slice and Dice, Drill Down, Cross Tab, Master Detail and Ad hoc , Dashboards etc.
• Performed Data validation to verify the data extracts and record counts in the database tables.
• Conducted weekly batch testing to incorporate changes in new builds.
• Provided the management with weekly QA documents like test metrics, reports, and schedules.

Confidential,MA

BI Tester

Environment: Informatica 8.1, Test Director 8.0, Win Runner 5.0, Load Runner , Business Objects 6.x, Rational Clear quest, SQL Server 2000,2005. Teradata V5R12, UNIX and XML, Quality Center 9.0, QTP

• Involved to create Business Risk Levels to determine Test Priorities.
• Analyzed Test Plans and Test Cases based on Requirements and General Design Documents, Involved in both Manual and Automation Testing.
• Performed Regression testing using Test Director.
• Extensively used SQL Queries to verify and validate the Database Updates.
• Used Test Director a workflow automation tool for defect tracking and product automation.
• Created User Defined Functions and procedures in Test Director Library to re-use them in Different tests.
• Performed data analysis and data profiling using SQL and Informatica on various sources systems Including Oracle and Teradata.
• Responsible for full testing life cycle, system testing and validating the Informatica mappings against the pre-defined ETL design standards.
• Tested SQL 2000 Reporting services, Integration services and Analysis services
• Defining and performing the Test strategies and associated scripts for the verification and Validation of the application and ensuring that it meets all defined business requirements and Associated functionality.
• Tested the Load Runner scenarios with various user-mix incrementing in constant ratios, till the peak load is achieved.
• Tested SSRS reports based on SSAS Cubes and OLTP with drill through and drill down.
• Tested OLAP cubes and SSRS reports for various business needs.
• Worked with SSIS system variable, passing variables between packages.
• Tested the created SSIS packages to transfer data from various sources like Oracle, Excel.
• Created high level test cases and test procedures for Unit Testing on reinsurance and documented them.
• Used Test Director to create test plans, gathering requirements, analyzing the results and reporting.
• Responsible for Reviews and documentation for reporting the status to the project manager.
• Played a significant role of QA testing at various stages of the project including Data Quality Testing, Data load Testing, Data Integrity testing, Business Objects Reports Testing etc.
• Tested Complex metrics, Nested Filters, Nested Prompts, Custom Drill Maps, Templates for Graphs and Templates for Drilled reports.

Confidential , OH

ETL Quality Analyst

Environment: Test Director 8.0, SQL server 2005, SQL Server, DTS Packages, Remedy, Windows NT, UNIX, MS Excel, VSS(Visual SourceSafe), Load Runner, Quality Center 8.2, QTP 8.2

• Tested different methodologies like Waterfall and AGILE, well versed with both Methodologies of SDLC.
• Identified the requirements and arranged peer reviews, walkthroughs and sign off meetings.
• Involved in Gathering and Analyzing Business Requirements, High Level Designing and Detail Technical Design of ETL application.
• Involved in unit testing and integration testing of the developed work Analyzed production support Issues.
• Gathered UI specifications and analyzed business process and established test strategies.
• Tested the values for test, Component parameters in Quality Center.
• Performed Backend Testing, Database validations, patient claims validations by writing complex SQL minus queries
• Installing, Configuring and maintaining of Load runner and QTP Tools .
• Wrote scripts to perform basic Sanity Testing and uploaded Test Scripts in Test Director.
• Responsible for developing PL/SQL Stored Procedures, Functions, Packages, triggers and other Database objects.
• Assigned users in TD administration, Created Test folders in Test Directors users in Project Customization.
• Logged issues in Test Director and tracked them to see whether the bug is fixed in the next Version.
• Communicated with Developers regarding technical issues.