SUMMARY

• 9+ of IT experience in the testing of Business Intelligence solutions using Data Warehouse/Data Mart, ETL, OLAP, and Client/Server Applications.
• Expertise in creating Test Plan documents and developing teststrategy documents and preparing the Traceability Matrices.
• Experience with MS Office software, Visio, relational DBMS (Oracle, MS SQL Server), SQL, Doors, Quality center, Share point.
• Expertise using Wiley, Dynatrace, Loadrunner,QTP for Performance monitoring.
• Expertise in Datacentric Testing.
• Expertise in testing involving ETL systems (Data stage and Informatica)
• Expertise in QA process and different levels of testing like unit, Functional, Regression, and Integration testing with business scenarios.
• Expertise using AML in Bank systems and Technology.
• Hands on expertise in Data ware housing concepts and tools. Involved in the ETL processes where in the organizations were using Datastage, Informatica, Ab initio and Autosys tools.
• Expertise using winrunner for Interface Testing.
• Experience in testing involving ETL systems (Data stage, SSIS and Informatica)
• Experienced in Onsite - Offshore Co-ordination, Test Management, Test Automation, Onsite Offshore Model Process Consulting, Requirements Management, Defect Management, Release Management and Team Management. Has performed planning and testing of Client/Server and Web applications
• Strong knowledge of different development lifecycles and methodologies, including SDLC, and Agile development approach.
• Strong working experience in the Data Analysis, Design, Development, Implementation and Testing of Data Warehousing using Data Conversions, Data Extraction, Data Transformation and Data Loading (ETL)
• Extensive experience in Oracle, SQL Server 2008, SQL Server Integration Services,
• Strong experience in test management tools like Test Director, Quality Center.
• Expertise in testing and writing SQL and PL/SQL statements.
• Good expertise in using SQL*PLUS, WinSQL, TOAD, SQL Server Management Studio.
• Experience in testing and writing complex SQL, T-SQL and PL/SQL statements.
• Experience in all aspects of project development life cycle.
• Experience with Integration testing of the applications using various sources like flat files, Sybase and oracle databases.
• Used DATASTAGE as an ETL Tool for Developing the Data Warehouse.
• Experience in debugging the issues using Informatica Workflow manager, Informatica Workflow monitor, Autosys and database.
• Proficient in working with UNIX shell scripts using PUTTY Environment.
• Involved in jobs scheduling using Autosys, monitoring and application support.
• Excellent communication skills and Ability to work in-groups as well as independently with minimum supervision and initiative to learn new technologies and tools quickly.
• Experience working on cross browser testing for various browsers Internet Explorer, Fire Fox, Google Chrome etc.
• Experience in designing, creation and execution ofTest Plans, Test Cases andTest Scripts based on defined testing standards.
• Experience inFunctional Testing, Integration Testing,Regression Testing, GUI Testing, Smoke Testing,System Testing.
• Experienced in GAP analysis and developing traceability.
• Experience in BI Reports testing usingSAS, Cognos, Business Objects andCrystal Reports.

TECHNICAL SKILLS

Operating Systems: Sun Solaris and Windows NT/2000/XP/

Programming Languages: SQL, PL/SQL, JAVA, Unix Shell Scripting, Java scripting.

Database Technologies: Oracle 10g/9i/8i,DB2 and SQL server 2005,2008

GUI: Toad, WinSQL, SAS Enterprise Manager and SQL Developer

Version Control Tools: VSS, SVN

Tools: & Utilities: Informatica, Datastage, Abintio, SAS, Cognos, Crystal Reports, Business Objects, SQL*Loader, SQL Server DTS and BCP and Import/Export, ALM

Others: SharePoint, MS Office, MS Visio, MS Project, Visual Source Safe

CASE Tools: ERWIN

Bug Tracking tools: Bugzilla, Jira, Mantis

Testing Tools: Test Director 7.0, 8.0,Quality Center 10.0,11.0, RQM

PROFESSIONAL EXPERIENCE

Confidential, West Chester, PA

Automation/ETL Tester/UAT tester

Responsibilities:

• The SDLC methodology followed was Agile (SCRUM).
• Attending Daily scrum meeting (Stand up meeting every morning)
• Meetings with product owner, scrum master and solution analysts
• Conducted JAD (Joint Application Development) sessions and Gather Business Requirements, analyze and prioritize requirements by using Rational Requisite Pro.
• Developed scope document, financial projections and performed Cost/benefit analysis for the project.
• Identified and validated high potential business opportunities for stakeholders and developed customized business strategies that are aligned with corporate strategic objectives.
• Provided analysis, understanding and business perspectives on many financial and operational issues.
• Develop UML diagrams like Use Cases and Use case Narrative, Activity Diagram, Sequence Diagram, class diagram and coloration diagram using MS VISIO 2007.
• Worked with Data Warehousing developers who extensively used DATASTAGE, to design mapping to move data from source to target database using Stages to do the functionality.
• Streamlining the team’s development activities, and actively involved in validating the requirements.
• Prepared Business Process Models that includes modeling of all the activities of business from conceptual to procedural level.
• Involved UI, requirement and data modeling sessions and developed DFD and performed Data Mapping.
• Defined and performed the Test strategies and associated scripts for the verification and validation of all defined business requirements and associated functionality.
• Assisted in developing the project reports every month and coordinated work plan between project manager and business area with Microsoft Project.
• Maintained a Traceability Matrix to ensure that all Functional Requirements are addressed at the Use Case Level as well as the Test Case Level.
• Used SharePoint to upload all the business documents.
• Worked closely with the QA Team to create Test Plans, Scenarios and test cases along with the scripts for User Acceptance Testing (UAT) and getting QA signoff.
• Tested several Data warehouseETLInformatica Mappings to validate the business conditions.
• Involved in the error checking and testing of the Data warehouseETLprocedures and programs Informatica session log.
• Experience in automating embedded Linux systems using Python automation frameworks.
• Worked on Cross Browser testing throughSeleniumWebDriver by testing the website on different browsers like Chrome, IE and Firefox.
• Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
• Compared the data sets resulted from the databases Oracle and SQL Server using the tool, Toad for Data Analysts.
• Tested Dimensional tables SCD Type 1, Type 2 and Fact Tables in Star Schema.
• Identified and Documented additional data cleansing needs and consistent error patterns that could diverted by modifyingETLcode.
• Extensively used Teradata load utilities Fast load, Multiload and FastExport to extract, transform and load the Teradata data warehouse.
• Developed TSL (Test Script Language) for automated Testing using Win Runner.
• Worked with business team to test the reports developed in Cognos.
• Coordinate release activities and involved in Producation.
• Written several complex SQL queries for validating Cognos Reports.
• Performed extensive Backend Testing by developing, modifying, and executing SQL queries for data validation and data verification on database.

Environment: Informatica 9, Informix, DB2, Java, TFS, VSTS, Cognos 7 Series, SQL, SQL Server 2000/2005, DataStage 7.5.3, Teradata V2R6 (MLOAD, FLOAD, FAST EXPORT, BTEQ), RALLY, SOAP, SOAPUI, Web Services, AutoSys, Teradata SQL Assistant 7.0, SSIS, XML, XSLT, XML Spy 2008, UNIX, HP QTP v5.5/6.5, HP Quality Center 12.21

Confidential, Wilmington, Delaware

ETL Tester

Responsibilities:

• Currently working with Agile development approach.
• Expertise in using Selenium for performance and load testing.
• Developed Test Plans, Test Cases, and Test Scripts for UAT tests.
• Developed shell scripts to run Datastage jobs
• Executed Datastage jobs from Windows and UNIX server.
• Used Cognos as reporting tool for testing the BI Reports.
• Generated Adhoc reports from Cognos to validate logic.
• Works for QA processing and different levels of testing like unit, Functional, Regression, and Integration testing with business scenarios.
• Developed SQL queries for Back-end testing/Database testing and participated in end to end testing.
• Worked with Business analysts to understand Business/System requirements in order to transform business requirements into functional test cases.
• Designing, creation and execution ofTest Plans, Test Cases andTest Scripts based on defined testing standards.
• Loaded data to different databases using SQL scripts to create required test data
• Used Shell scripts extensively for automation of file manipulation and data loading procedures.
• Execute batch processing and verify the jobs status and data in database tables.
• Study and analysis of the mapping document indicating the source tables, columns, data types, transformations required.
• Created Test Cases in Quality Center and mapped Test Cases through developed Tractability Matrix and Test Coverage reports
• Executed Test Cases using positive and negative data.
• Tracked the defects using Quality Center and generated defect summary reports
• Running the ETL Jobs for refreshing the data in Cognos reports. Running the IQ for every new or sub release for the defects fixed in Dev.
• Executed shell scripts to run PL/SQL programs, Cognos reports from Autosys and jobs.
• Validated the source system data with the staging data using SQL and Pl/SQL scripts.
• Reached Testing Goals by doing Data Completeness, Data transformation, Data Quality, Performance and Scalability.
• Tested several UNIX shell scripting for File validation.
• Provided daily and weekly status reports.

Environment: Quality Center 11, Selenium, Ms Excel, Cognos 8.4.1., DataStage, Oracle /11g10g/9i, SQL, PL/SQL, Teradata utilities, TOAD, UNIX, SQL Server Integration Services, HP Quality Center, Rational Clear Quest, Rational Clear Case, SQL SERVER 2000 and 2008

Confidential, WV

ETL Tester

Responsibilities:

• Worked with Business analysts to understand Business/System requirements in order to transform business requirements into functional test cases.
• Responsible for reviewing Functional specs, user documentation and use cases and developing manual test cases out of it.
• Developing various Test Scripts, Test Execution using Quality Center based on the Functional Specifications.
• Testing and validation of the developed Informatica mappings.
• Testing and Validation by Datacentric Testing using Checksum comparison and Domain comparison.
• Expertise using QTP, Loadrunner, Wiley, Dynatrace for performance testing.
• Expertise in using SSIS for high performance data integration solutions.
• Expertise in using winrunner for Graphical User Interface Testing.
• Worked with Testing of Flat File and source data.
• Developed SQL queries for Back-end testing/Database testing and participated in end to end testing.
• Experience in writing tests with Selenium, used for load and performance tests. Used to identify functional issues. Debugging the tests.
• Tested several UNIX shell scripting for File validation and also PL/SQL programming

Environment: Quality Center 11, Selenium, SSIS, WebDriver 2.42.0, 2.43.0, Informatica Power Center 7.1.3/8.1, Loadrunner 11.52/11.51 , QTP 11/10, Fitnesse, Erwin,winrunner, Ms Excel, Oracle /11g10g/9i, SQL, PL/SQL, Teradata utilities, TOAD, UNIX, Cognos 8.4.1, SQL Server Integration Services, HP Quality Center, Rational Clear Quest, Rational Clear Case, SQL SERVER 2000 and 2008, Gateway, Master Control, IQ Assistant, Test Data Creation Tool, Altova XMlSpy

Confidential, New York

ETL/DWH Analyst

Responsibilities:

• Develop Test plans, Test Strategy, Test Cases & decided on automation when required.
• Involved in the entire project life cycle from analysis, installation, development, testing, production and end user support
• Developed Test Plans, Test Cases, and Test Scripts for UAT tests.
• Created Test Cases in Quality Center and mapped Test Cases to Requirements in Req Pro.
• Developed Tractability Matrix and Test Coverage reports.
• Managed and conducted System testing, Integration testing, Functional testing, and UAT and Regression testing.
• Loaded data to different databases using SQL scripts to create required test data.
• AML used for pre and post- implementation times for data capture and monitoring.
• For fine tuning of rules to reach the desired balance between the suspicious activity alerts and false positives.
• Tracked the defects using Clear Quest and Quality Center and generated defect summary reports.
• Executed shell scripts to run PL/SQL programs and jobs.
• Executed Informatica sessions and tasks from Informatica workflow manager and validated results from database and informatica workflow monitor.
• Validated the data using datacentric Testing with Multi-value comparisons and Domain comparisons.

Environment: Datastage, AML, Crystal Reports, Teradata, Manual testing, Quality Center, Oracle 9i, SQL, TOAD, Java, J2EE, Java Script, HTML, XML, WebSphere5.1,SSIS,SSRS, Clear Quest,QNXT, Facets,QTP, MS Office and Windows XP,Jira

Confidential, Simi Valley, CA

QA analyst

Responsibilities:

• Developed Test Plan, Test Cases based on Functional Requirement Specifications (FRS) and System Requirement Specifications (SRS).
• Developed Test specifications and test plans for ETL and BI Reporting.
• Tested and documented Data Mappings/Transformations, and Informatica sessions as per the business requirement.
• Utilized INFORMATICA Power Center designer to analyze mapping, sources, source transformations, expressions, sequencers, normalizes, filters and targets
• Tested several Informatica Mappings which will populate the data into dimensions and Fact tables.
• Validated workflows, sessions and WORKLET to check in and check out and verifying the data loaded into the Data Warehouse.
• Validating the reports like List, Crosstab and charts. Testing the reports for number of Filters, Prompts, Calculated expressions, Drill Throughs, Master Detail Relationships.

Environment: Windows 2000, Quality Center 9.2, Cognos 8.4BI, Cognos v8.1BI, PowerPlay Transformers, Informatica 8.1.1, SSIS & SSRS, Unix, Teradata, SQL Server 2000 & 2008, MS Office Tools.

Confidential

Tester

Responsibilities:

• Creating test case and test data, executing test case, reporting defects. Developed script in Winrunner.7.2.
• Tested all the ETL processes developed for fetching data from OLTP systems to the target Market Data warehouse using complex SQL queries.
• Tested all the compliance reports generated using Business Objects BI tool by validating the data in the report against the database according to the requirement specifications using SQL.
• Tested PL/SQL procedures that were developed to load the data from temporary tables in staging to target tables in the data warehouse
• Provided support to offshore QA team by giving them knowledge transfer and helping them with closure of the defects.
• Performed data validation on the flat files that were generated in UNIX environment using UNIX commands as necessary.
• Tracked defects to closure by coordinating with the dev team.
• Tested source data for data completeness, data correctness and data integrity.
• Performed End to end testing starting from the source to the report.
• Conducted and coordinated integration testing and regression testing.

Environment: Oracle 10g/11g, Business Objects, SQL Developer, SQL Server 2008, TOAD, Informatica Power Center 8.6.1, HP Quality Center,QTP, PL/SQL, UNIX, Putty, Session log files, Flat files, XML files, Remedy, SnagIT, CompareIT, MS Office, Clear Quest (CQ) and Clear Case. ASP, IIS, Javascript, HTML, Ms Access.

Confidential

QA Tester

Responsibilities:

• Performed Manual Testing on the Web Application
• Prepared Test Plan by analyzing the business requirements.
• Written test cases and functions for performing these tests using technical document.
• Performed execution of test cases manually to verify the expected results.

Environment: Manual Testing, QTP, Rational Quality Manager, Java, J2ee, Oracle8i/9i, HTML, JavaScript, Weblogic and Win2k, Windows 2000, Quality Center 9.2, Impromptu v7.4, Cognos 8.4BI, Cognos v8.1BI, PowerPlay Transformers, Informatica 8.1.1, SSIS & SSRS, Unix, Teradata, SQL Server 2000 & 2008, MS Office Tools.

Confidential

QA Tester

Responsibilities:

• Designed and prepared test cases based on use cases and Functional specification.
• Executed test cases manually.
• Involved in Screen Navigation Testing.
• Functionality testing on all screens to make sure that all the objects, buttons and icons are performing according to all the specified functional requirements.
• Involved in Integration Testing, System Testing, Regression Testing, GUI Testing, Installation Testing, Compatibility Testing, Performance Testing and Smoke Testing.
• Participated in Functionality and Regression Testing.
• Bug Report generation using Test Director.
• Coordinating with the developer in fixing bugs.
• Involved in Test Cases Review for multiple MCR’s (Maintenance Change Request).
• Created Code Standard Review documents

Environment: Manual Testing, QC, Db2, TestDirector5.0, Java, JavaScript, HTML, Oracle, Weblogic and Windows NT, XML, Oracle8i, SQL Assistant, Toad, Win Runner 7.5, Quality Center 8, LoadRunner7.5, Java/J2EE, HTML, Web Logic, Unix, Windows NT.