SUMMARY:

• Over 7+ years of excellent IT experience in requirement gathering, data analysis, design, development, Testing and Implementation of Data Warehouses using ETL & Business Intelligence solutions, UNIX, OLAP for multiple domain.
• Expertise in understanding Business/Functional/technical requirements and compliance rules.
• Experienced in writing test plans, test cases and test scenarios.
• Complete exposure to all stages of SDLC process with strong skills in writing various test plans, developing, maintaining test cases and test scenarios.
• Excellent Understanding in relational Data modelling, Dimensional data modelling, logical/Physical Design, ER Diagrams, analyzing data sources.
• Expertise in designing Web Intelligence Reports, Desk Intelligence Reports, Dashboard using Business Objects Enterprise XI R2 / XI R3.
• Highly experienced in various features of Micro Strategy like managing multiple projects, project migration and defining standards, procedures for development, production environment
• Experience in testing complex reports generated by Cognos, Business Objects including dashboards, summary reports, master detailed, drill down and score cards.
• Expertise in Data Analysis, Understanding in Dimensional Data Modelling, Data Extraction, Transformation & Loading (ETL), Cubes and End User Reports.
• Good Understanding on Star Schema Modelling, Snow - Flake Modelling, FACT and Dimension Tables, Physical and Logical Data Modeling.
• Extensive experience in using SQL, PL/SQL Procedures/Functions, Triggers and Packages for testing purposes.
• Experienced in designing reports using SQL Server Reporting Services (SSRS) and Excel Pivot table based on OLAP cubes.
• Good hands on experience in the testing methodologies of Client/Server, Web-based and Data warehouse ETL applications.
• Experienced with ETL tools like Informatica, SSIS, Ab Initio and Data stage.
• Experienced in working in Agile Scrum, Agile XP, Waterfall, RUP, RAD and SDLC methodology environments
• Experienced in functional, integration, regression, compatibility, security, back end, acceptance testing (UAT), and GUI Testing.
• Advanced user in using Test management tools like HP Quality Center/ ALM, JIRA.
• Worked on Oracle 11g/10g/9i/8/7.3, MS SQL Server 2012/2008/2005, IBM DB2 7.1/8.2/v9, Teradata V2R6/R5 databases.
• Prepared and loaded test data in different environments for different testing needs.
• Ability to quickly adapt to different project environments, work in teams and accomplish difficult tasks independently within time frame.
• A good team player with excellent written and verbal communication skills.
• Excellent problem solving skills with a strong technical background and good interpersonal skills. .

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 9,8.5.1 (Designer, Workflow Manager, Workflow Monitor,) SSIS,Abinitio GDE

OLAP Tools: IBM Cognos v9, SAP Business Objects 2010/2008/XIR2, SSRS,Microstrategy 8.0

Data Modeling: E rwin, Microsoft Visio, Rational Rose (UML), ER Studio

Operating Systems: Windows NT/2000/2003/XP, UNIX, Solaris and MSDOS

Databases: Netezza, Oracle 11g/10g/9i/8i, SQL Server 2008/2005, DB2, MS Access, Teradata V2R5.

Testing Tools: Quality Center, Test Director, JIRA, HP Quality Center 9.0/9.2/10.0, Doors

Languages: XML, SQL, PL/SQL, C,C++, VB

PROFESSIONAL EXPERIENCE:

Confidential,

Arlington VA

Sr. ETL QA Test Analyst

Responsibilities:

• Involved in Regression, Functional, Integration, System Testing and User Acceptance Testing.
• Participated in analysis of Business and functional requirements
• Worked in Agile technology with Scrum and waterfall models.
• Interacted with Business users to determine User requirements and goals.
• Created reports that included a general overview, open bugs, new bugs and enhancement requests.
• Entered new bugs and maintained the current status of those bugs.
• Responsible for communicating Defect Status Reports to business in project meetings.
• Participated and Organized weekly meetings and walkthroughs to improve the testing efforts.
• Strong ability in developing advanced SQL queries to extract, manipulate, and/or calculate information to fulfil data and reporting requirements including identifying the tables and columns from which data is extracted.
• Worked with business team to test the reports developed in SSRS.
• Tested several packages developed using SSIS.
• Tested tables like SCD type 1 and Type 2.
• Based on the business requirements, created Test Plan, Test Cases, and Test Script documents to test the Business Objects reports
• Wrote stored procedures in Netezza.
• Re-engineering Netezza tables by using proper distribution key(s) and dimensions to achieve co-located joins.
• Tested ad hoc and canned reports for Business objects.
• Developed Test Strategy, Test plans, and Test scenarios using MS Word and MS Excel.
• Developed Test Cases and Test Scripts for System and UAT Testing.
• Performed Positive and Negative Testing for many scenarios and applications.
• Responsible for creating Test Strategy for the Data Warehouse.
• Testing the source and target databases for conformance to specifications.
• Conditional testing of constraints based on the business rules.
• Conducted regression testing on the application under test and Debugging the SQL-Statements and stored procedures.
• Tested the Oracle SQL testing programs and tested the Oracle Applications and Portals like Executive Dashboard, lookup built on Oracle.
• Updated UI keyword functions to handle various languages in the same data sheet.
• Conducted review sessions on test case and regression test scripts in Quality Centre.
• Verified and maintained Data Quality, Integrity, data completeness, ETL rules, business logic.
• Tested several UNIX Korn Shell scripts for ETL data loading
• Verified the property and loan order information like data in the pricing models against source and target databases by using SQL Queries.
• Worked with Compatibility Testing for Browser, Operating, Mobile & Printing options for Web Apps
• Tested whether the reports developed in SSRS are as per company standards.
• Written several test cases for SSIS Packages and for data flow.
• Extensively used SQL queries to check storage and accuracy of data in database tables.
• Used SQL for Querying the Oracle database.
• Performed all aspects of verification, validation including functional, structural, regression, load and system testing.
• Used Agile Test Methods to provide rapid feedback to the developers significantly helping them uncover important risks.
• Reported bugs and tracked defects using Quality Center/ALM.
• Developed User-Acceptance Test cases and assisted users in conducting UAT
• Personalized SSRS Connection for specified display options for testing regional options and personal Information; Also written several complex SQL queries for validating Reports.

Environment: Oracle 11g, (SQL Server SSIS, SSAS SSRS 2012 / 2008), Agile, Business Objects XIR3, XML, Test Cases, NETEZZA 6.0.5, UNIX, Test Matrix, NET, ASP.NET, VB.NET, TOAD, and HP ALM/ Quality Center 11.0, HP QTP/UFT 11.0

Confidential, Charlotte NC

Sr. ETL QA Test Analyst

Responsibilities:

• Involved in reviewing/analyzing Business Requirement Documents/Functional specifications/use cases.
• Worked with Business Analysts, developers while reviewing the Business Requirement Documents and when there are enhancements in the applications.
• Worked in an agile technology.
• Involved in the design of web application using HTML, DHTML, Cascading style Sheets Java script and ASP.
• Created ETL test data for all ETL mapping rules to test the functionality of the SSIS Packages.
• Developed Test Cases for Deployment Verification, ETL Data Validation, Cube Testing and Report testing.
• Tested the ETL process for both before data validation and after data validation process. Tested the messages published by ETL tool and data loaded into various databases
• Peer reviewed test cases developed by QA team members and advice/point/discuss possible complex scenarios and make sure requirements are completely covered.
• The reports that were created in Business Objects were testing by running the SQL statements
• Worked on a Business Intelligence reporting system that was primarily functioning on Oracle Applications OLTP environment with Business Objects for Business Intelligence reporting
• Supported and provided test cases for UAT, staging and production Participated in review meetings and attended training sessions to understand various business concepts.
• Prepared Entry and Exit criteria for Testing cycles, review with functional leads and PMO.
• Exported Requirements, test plans and test cases to QC 10.
• Tested the SSRS report functionalities like Queries, Slice and Dice, Drill Down, Cross Tab, Master Detail and Ad hoc, Dashboards etc.
• Created Traceability Matrix to ensure that all requirements are covered in test cases.
• Develop Risk-based Test Strategy whenever required, to save time and to determine which test activities to carry out and created complexity matrices.
• Conducted Defect meetings on daily bases to track defects status with functional leads and to speed up resolution process at end of each cycle.
• Interacting with developers, business analysts to communicate the defects.
• Bug reporting and Bug tracking using HP Quality Center.
• Involved in UAT process before rolling out to production when required. Participated in debugging prod issues along with support team.
• Worked in Agile methodology during application development and participated in daily scrum meetings.
• Developed user defined functions, created objects where required and used descriptive programing to automate.
• Tested all formats of SSRS reports including Excel, PDF, CSV, XML, TIFF and many other
• Experienced in creating the SSIS packages, DTS packages.
• Worked exclusively with Integration Test Team for E-Commerce units integration testing.
• Conducted result analysis and interacted with developers to resolve bugs.
• Developed and Executed SQL statements in Toad to retrieve data and to validate data.
• Tested data migration to ensure that integrity of data was not compromised.
• Validated the data thru various stages of data movement from staging to Data Mart to Data Warehouse tables.
• Writing complex SQL queries for data validation for verifying the SSIS Packages and business Rules.
• Responsible for documentation of test results, test matrix, and participated in daily/weekly QA meetings.
• Used Quality Center for logging the defects.
• Tested reports using SSRS functionality like Queries, Slice and Dice, Drill down, @Functions, Formulae etc.
• Conducted down test and up test for release builds pushed to UAT and to Production.

Environment:: SQL Server 2010, SSIS, SSRS, Web Services, SOAPUI, Oracle 10g, NET, ASP.NET, VB.NET, MS SQL, HP ALM Quality Centre 10.0/9.2, HP QTP 10.0, Agile, TOAD, MS Excel, MS Project.

Confidential, Providence, RI

Sr. QA ETL/DWH Test Analyst

Responsibilities:

• Analyzed the Business requirements and developed Test cases based on functional requirements, general requirements and system specifications.
• Prepared test data for positive and negative test scenarios for Functional Testing as documented in the test plan.
• Exclusively involved in writing test cases, test scripts, test plans and execution of test cases reporting and documenting the test results using Mercury Quality Center.
• Worked as ETL Tester responsible for the requirements / ETL Analysis, ETL Testing and designing of the flow and the logic for the Data warehouse project.
• Involved in the error checking and testing of the ETL procedures and programs Informatica session log.
• Extensively used Informatica to load data from Flat Files to Teradata, Teradata to Flat Files and Teradata to Teradata
• Experienced in writing complex SQL queries for extracting data from multiple tables.
• Tested to verify that all data were synchronized after the data is troubleshoot and also used SQL to verify/validate my test cases.
• Involved in backend testing for the front end of the application using SQL Queries in Teradata data base.
• Testing the ETL data movement from Oracle Data mart to Teradata Data mart on an Incremental and full load basis
• Managed and executed the test process, using Agile Methodology
• Wrote SQL queries to validate source data versus data in the data warehouse including identification of duplicate records.
• Tested whether the reports developed in Business Objects and Crystal Report are as per company standards.
• Tested Ad-hoc reports, drill down and drill through reports using SSRS.
• Tested different detail, summary reports and on demand reports.
• Involved in pre and post session migration planning for optimizing data load performance.
• Interfaced with the Portfolio Management and Global Asset Management Groups to define reporting requirements and project plan for intranet applications for Fixed Income and Equities.

Environment:: Informatica Power Center 8.6, MS SQL 2008,Agile, Oracle 9i, SQL, PL/SQL, SQL Navigator, Business Objects, Crystal Reports, Teradata V2R6, HP Quality Center 9.2, HP QTP 9.2.

Confidential

ETL QA DWH Tester

Responsibilities:

• Analyzed business rules to generate consolidated (fact/summary) data identified by dimensions using Informatica ETL (Power Center) tool.
• Maintained stored definitions, transformation rules and targets definitions using Informatica repository manager.
• Scheduled sessions and Batch process based on demand, run on time, run only once using Informatica server manager.
• Written Test Cases to cover overall quality assurance testing.
• Performed manual testing on different modules of the application.
• Performed data integrity testing by executing SQL statements and manually verifying the contents.
• Used SQL to perform Backend Testing on databases.
• Involved in supporting the deployment of data marts and reports.
• Performed manual testing prior to automate testing on the application.
• Scheduled and monitored transformation processes using Informatica Server Manager.
• Prepared Test status reports for each stage and logged any unresolved issues into Issues log.
• Prepared Test Plan from the Business Requirements, detected defects, tracked and reported bugs using Test Director.
• Involved in writing testing methodology by following standards for test documentation, test requirements and test procedures.

Environment:: Informatica Power Center 7.1, Oracle 9i, PL/SQL, TOAD, SQL*Loader, XML, XSLT, XSD, VSAM, JCL, MVS, COBOL II, Copy Books, SQL, PL/SQL, Autosys, Test Director, HTML, Windows NT/2000