SUMMARY

• Software Test Engineer with over 7 years of experience in Software Testing, IT support, Test automation development and testing ETL, Data warehouse, Client/Server and web applications.
• Expertise in Functional testing, Manual Testing and Automated Testing, Regression testing, User Acceptance testing (UAT), System testing, Integration testing and Black Box Testing.
• 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.
• Assisted in defining the tasks/schedule to achieve the MDM vision.
• 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 BI applications using OBIEE, SSRS.
• Experience in usingJenkinsfor Continuous Integration (CI).
• 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).
• Script writing and editing for Sybase related batch jobs.
• Meeting with the prospective clients to provide a short presentation of the mortgage loan products that we offer.
• Complete knowledge of pricing and the underwriting procedures in the mortgage industry.
• Involved in testing MDM, Informatica MDM Hub, Informatica Data Director.
• Experience in data analysis and problem solving with large amounts of data
• Extensively used ETL methodology for supporting data extraction, transformations and loading processing, in a corporate-wide-ETL Solution using Informatica
• Hands on experience with analysis of business, technical, and functional requirements and Developed, Executed & Tested the test plans, test cases and test strategies.
• Experience with software Test Management tools Like HP Quality center/ALM
• Familiar with the use and working of Rational RequisitePro for requirements management.
• Expertise in Data Warehouse, ETL Verification, BI reports.
• Move the data from SQL Server to Sybase using bcp.
• Interviewed the pre-qualified and prospective clients and pacified their doubts regarding the mortgage loans and repayment schedule.
• Managing the creative content that coincides with the promotional and special packages to attract mortgage loan customers. handled the system testing and regression testing for Master Database Management (MDM).
• Experienced in web and client/server applications QA testing.
• Experience in Database performance tuning and optimization.
• Expertise in QA Testing in distributed Unix Environment and Oracle databases as back end, Performed end-to-end testing & back-end testing.
• Expert in functional and regression testing for web services using Soap UI
• Certified from American Software Testing Qualification Board (ASTQB)
• A self-motivated, responsible and reliable team player with a set of strong technical skills.

TECHNICAL SKILLS

Testing Tools: Mercury Test Director 8.2/7.2, HP Quality Center 10.0/9.0,Jenkins.

Operating Systems: UNIX, Windows 98/ NT/2000/XP

Reporting Tools: SSRS 2005/2008, OBIEE 10.0.3, Business Objects XIR3

ETL Tool: IBM Datastage8.0,7.X/6.X (Manager,Designer,Abinitio,Director, Administrator)

Database: DB2 8/7/5.1, Oracle 10g/9i, SQL Server 2008/2005/2000 , Teradata .

Version Management: Rational ClearCase

Programming Languages: PL/SQL, T-SQL, C, C++, Java, SQL

Other tools: Remedy (ARS) Trouble Ticketing, Rational RequisitePro

PROFESSIONAL EXPERIENCE

Confidential

ETL /Back End Tester

Responsibilities:

• Developed test plans based on test strategy. Created and executed test cases based on test and test plans based on ETL Mapping document
• Involved in understanding the ETL mapping document and source to target mappings.
• Prepared the test plans and test cases for different functionalities involved in the application.
• Used Quality Centre as the test management tool for the maintenance of the test cases and to track the defects.
• Coordinated efforts with SAP ERP team regarding SAP Master Data Tables with the Enterprise MDM Solution. Collaborated with Marketing leadership to assess and define eCRM (electronic Customer Relationship Management) as part of the Enterprise MDM solution for Amtrak
• Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing).
• Performed the Smoke, Functional testing, Ad Hoc testing and Regression testing of the application.
• Executed SQL Queries for testing integrity of data in database (Backend Testing).
• Performed backend and database testing: Oracle, MS-SQL Server, MS Access databases.
• Used PRISM for to get the HLD (High Level Design Document) AID (Application Interface Design Document) and Mapping Document.
• Used Web Services to subscribed, unsubscribed request, created alarms, created tickets to clear the alarms and close the tickets for cleared alarms.
• Performed functional testing and validated request and responses of Web Services .
• Used Quality Center for store the requirements, test cases, and execute the test cases and bug reporting.
• Designed and implemented customized multi-national Address Standardization process using IBM Web Sphere Quality Stage v 7.5 for PCCM Migration and Integration process for the MDM.
• Tested different detail, summary reports and on demand reports.
• Performed backend testing for the front end of the application using SQL Queries in SQL Server database.
• Responsible for designing, developing and testing the software (Informatica, PL SQL, UNIX shell scripts) to maintain the data marts (Load data, Analyze using OLAP tools).
• Used all the Informatica power center 9.1.0 client components like Designer, Workflow Manager, and Workflow Monitor.
• Used InformaticaPowerCenter 8.6.1forextraction, loading and transformation (ETL) of data in the data warehouse.
• Optimized/Tuned several complex SQL queries for better performance and efficiency.
• Created various PL/SQL stored procedures for dropping and recreating indexes on target tables.
• Worked on issues with migration from development to testing.
• Tested UNIX shell scripts as part of the ETL process, automate the process of loading, pulling the data.
• Participated Weekly Team Meetings, Test Case review meetings and to updated the Weekly Status Report to Team Lead.

Environment: INFROMATICA 8.1/7.1/6.2/5.1 ,Abinitio, HP QTP 10.0, HP Quality center 10.0, Teradata, SQL Server 2005/2008, Test Director 8.0,Jenkins, SSIS, Oracle 9i, Sybase,PL/SQL, TOAD 7, Shell Scripting, PERL, IBM AIX 5.2, TOAD.

Confidential, Somerset, Nj

Sr ETL/SQL Tester

Responsibilities:

• Design and Development of QA documentation like Test Cases and Test scenarios from business and functional requirements.
• Designed, coded, and tested the Information Server components for MDM integration.
• Identified the requirements and arranged peer reviews, walkthroughs and sign off meetings.
• Used HP Quality Center 9.0 for Test Estimation, Test Planning, Test Designing, Test Analysis, Test Execution, Defect Tracking and Test Result.
• Co-ordinate testing efforts between onsite and offshore teams.
• Performed SQL validation to verify the data extracts and record counts in the database tables by writing complex SQL minus queries.
• Experience in manual testing which involves web-based application testing for provider and claims system.
• Promoted Unix/Informatica application releases from development to QA and to UAT environments
• Writing complex SQL queries for data validation for verifying the SSIS Packages and business Rules.
• Lead the development of MDM and data quality standards and processes, including service level agreements (SLAs).
• 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.
• Experience in ETL Data Warehousing, database testing using DataStage for Workflow process.
• Create various test Batch jobs to run and monitor group of jobs with DataStage Director.
• Written test cases for checking the populated data correctly into fact and dimension tables.
• Created Test Case documents in MS Excel template from the Test Plan and the Business Requirements documents.
• Designed policies, standards and procedures for testing life cycle for the data warehouse and datamarts.
• Used Control-M scheduler to schedule the ETL processes
• Prepared test cases by understanding the business requirements Data Mapping documents and technical specifications.
• Used TOAD Software for Querying ORACLE. And Used Teradata SQL Assistant for Querying Teradata.
• Tested the ETL Data Stage jobs and other ETL Processes (Data Warehouse Testing)
• Tested the ETL process for both before data validation and after data validation process. Tested.
• Tested reports using SSRS functionality like Queries, Slice and Dice, Drill down, @Functions, Formulae etc.
• Experience with Customer Master Data Management (MDM) software tools (e.g., IBM Initiate, Informatica Siberian MDM) a plus.
• Responsible for different Data mapping activities from Source systems to Teradata
• Extensively used Informatica power center for extraction, transformation and loading process.
• Wrote and implemented manual automated test scripts for Risk Warehouse decision support system using HP Quality Center.
• Extracted Data from Teradata using Informatica Power Center ETL and DTS Packages to the target
• Coordinated with development team in system integration test and services level unit testing.
• Responsible for identifying and defining the Key Performance Indicators in SSAS 2008.
• Exported Manual Test Cases from MS Excel template directly to HP Quality Center/ALM and executed all the Test Cases in Quality Center with Pass/Fail/Blocked status.
• Extensively worked with backend activities for testing several reports developed by BI tools. Written several complex SQL queries.
• Tested SSRS reports based on SSAS Cubes and OLTP with drill through and drill down capability to confirm with production reports run in Business objects/Crystal reports for cross verification
• Experience in testing SOA and Web services using tool tools like SOAP UI/XML Spy
• Published and Tested SSAS Cubes to Upfront by using Power play Enterprise Server
• Extensively used SQL Queries to verify and validate the Database Updates.
• Actively participated in creating requirements Traceability matrices and Test plans
• Prepared test requirements, test plan approach document and test cases.
• Performed Unit and functional testing for all the Mappings and Sessions.
• Tested Complex Reports in OBIEE functionalities like Slice and Dice Drill down Functions Cross Tabs Master/Detail and Formulae.

Environment: IBM Web sphere Data Stage 8.5/ 8.0.1/8.0/7.5/7.1 , Abinitio, HP Quality center 10.0, QTP 10.0, OBIEE10.1.3, Oracle 10g, Teradata V2R6, SQL server SSIS (2008), SQL server SSRS (2008), SSAS, PL/SQL, Toad, PL/SQL, PERL 5.12.1,SOAP-UI, Sybase, Jenkins, Autosys, UNIX, IBM AIX 6.1, Shell Scripting, Windows server

Confidential, Jersey city, NJ

Sr.QA ETL Tester

Responsibilities:

• Verified 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.
• Create Data Stage Parallel Jobs to extract, transformation and loading of the data using Data Stage design toll in the parallel processing mode.
• Used Data Stage to move data to the warehouse using the stored Procedure thereby enabling faster moment of data.
• 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.
• Experience with web technologies HTML, XML, X-PATH and Web Services
• Performed SQL validation to verify the data extracts and record counts in the database tables.
• Designed 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.
• Expertise in Cube designing in Business Intelligence Development Studio ( SSAS ) to edit various properties of a cube, including the measure groups and measures, cube dimensions and dimension relationships, calculations.
• Created complicated reports using SSRS, SSAS to display key performance indicators and upload to Teradata tables using Teradata utilities FASTLOAD. 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.
• TOAD is used to test various ETL process flow graphs to meet the Business rules and Technical Requirements.
• 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.
• Divided the graphs into various phases and used checkpoints to avoid Dead locks.
• Extensively worked on debugging ETL process graphs.
• Used Rational ClearCase to maintain the versioning and change management for the test document repository.
• Developed and 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.
• Experience in testing Web Services using SOA and tools like SOAP UI/XML Spy.

Environment: IBM Web sphere Data Stage 8.5/ 8.0.1/8.0/7.5/7.1 , HP Quality center9.2, QTP 9.2 Oracle 9i/10g, PL\SQL, OBIEE 10.1.3, SQL server SSIS (2005), SQL server SSRS (2005), SSAS, Teradata V2R6, Windows 2000, 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, XQuery, XPath XSD, TOAD, WinSQL

Confidential, MA

BI Quality Engineer

Responsibilities:

• 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.
• Involved in developing test cases to test Teradata scripts (Bteq, multiload, fastload).Updated the status of the testing to the QA team, and accomplished tasked for the assigned work to the Project Management team regularly
• Designed and supported SQL 2000 Reporting services, Integration services and Analysis services created variety of reports from SSAS cubes
• 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 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.

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