SUMMARY

• Over 7 years of IT experience in Quality Assurance and Software Testing of various business applications in Data Warehousing and Business Intelligence solutions.
• Expertise in conducting Rapid Application Development (RAD, Joint Requirement Planning (JRP) and Joint Application Development JAD sessions, interviews, workshops and requirement gathering sessions with business, stakeholders and development team.
• Created data mapping documents mapping Logical Data Elements to Physical Data Elements and Source Data Elements to Destination Data Elements.
• Experienced in gathering requirements and authoring Business Requirement Documents (BRD), Functional Requirement Document (FRD), Technical Document andmaintaining Requirement Traceability Matrix.
• Tested and implementedExtraction, Transformation and Loading of data from heterogeneous sources into Data warehouse using ETL Tools.
• Experienced in Data Warehousing concepts, Data Analysis, Data Cleansing, Data Profiling, Data Mapping, Data Validation and Verification, Data Conversion, Data Migrations, Data Warehouse Architecture and Designing.
• Good understanding of Data Modelling in data warehouse environment such as star schema and snow flake schema.
• Strong knowledge of SDLC and Software Test Life Cycle and highly proficient in SQA methodologies for Waterfall, Agile.
• Wrote TestPlans, Test Strategy, Test Procedures,UserStories, UseCases, Test cases and validation.
• Proficient in different Databases like Oracle, SQL Server, DB2 and Teradata and Hadoop.
• Proficient in Store Procedure, view, index, triggers, and functions.
• Experiencedin testing and writingTSQL and PL/SQL statements.
• Experiencedon UNIX commands and Shell Scripting.
• Strong Testing experience in variousreports using SQL Server (SSRS).
• Strong Knowledge inALM Toolsto updatesand test cases loading and writing Test Plan and executing Test Cases and printing status report for the team meetings.
• Experiencedin ETL tools likeAbinitio, SSISand Informatica.
• Experiencedinbatch job,Job Scheduler like SQL Server Agent, Autosys,Oracle JobScheduler.
• Extensively involved in Data - centric testing to test the data completeness, data integrity,and datavalidation, data quality of the data as it is extracted from source and loaded into target.
• Experiencein Source to Target Testingtovalidate the data before and after it passes through the transformation/mappings are exactly same and to test if the values before transformation and after arecorrespondingto the expected values.
• Experienced increating DTSXPackages.
• Involved in application upgradation testing during which, data validation was performed to test if the data from the older application was same as the data loaded into DB through new application.
• Involved and implemented various phases oftestingsuch as integration testing, system testing, regression testing, performance testing, operational testing of the mappings, jobs and sessions atareinvolved in extraction, transformation, and loading of data from source to DWH.
• Worked on Dimensional modeling, Data cleansing and Data Staging, Data integration of operational sources using ETL processes.
• Involved in preparation of Requirement Traceability Matrix (RTM), Defect Reports, and Weekly Status Reports.
• Worked closely with BI teams to explain the logic of business and help creating areport.
• Conducted interview sessions with users and different levels of management to extract requirements to understand the functional specifications of the AS IS system and did the GAP and IMPACT analysis to design the TO BE system.
• Excellent communication skills, Good organizational and interpersonal skills, outgoing personality, Self-motivated, hardworking, ability to work independently or cooperatively in a team, eager to learn, ability to adapt based on the demands of work.

TECHNICAL SKILLS

Testing Tools: HP ALM/Quality, QTP, TFS,Jira, Facets.PatientPlus

Operating Systems: MS-DOS, UNIX, Windows 9x/NT/2000/XP.

Languages: TSQL, PL/SQL,XML, XSLT, XSD, HiveQL

Tools: Toad, SSMS, Teradata SQL Assistant,XMLNotepad.

Database: MS SQL, Oracle SQL Server, DB2, Teradata

ETL Tools: SSIS, Informatica

Reporting Tools: SSRS.Cognos, QlikView

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, NC

Responsibilities:

• Responsible for the execution for the project life cycle (SDLC), including requirements gathering, design, testing, implementation and documentation, as required.
• Tested different master detail, summary reports, ad-hoc reports and on demand reports using SSRS Reports and Cognos Reports.
• 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.
• Experienced in store procedure, functions, joins, views used to validate the business logic and transformation.
• Experience in validatingdataingested in to Hadoopdatalake from different sources.
• Worked in anagiletechnology with Scrum.
• Wrote User Story as per the requriments.
• Reported bugs and tracked defects using Quality Center.
• Executed SQL queries to perform backend database testing and verify/modify user data.
• Compared the actual result with the expected results. Validated the data by reverse engineering methodology i.e. backward navigation from target to source.
• Established and documented ETL QA standards, procedures and QA methodologies.
• Verifieddevelopment of rule-set test scenarios, test cases, expected results and analysis of XML test scripts.
• Experienced inInformatica power center for extraction, transformation and loading process.
• Worked andtested several ETL Mappings developed using Informatica.
• 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.

Environment: Informatica9.0/8.6, SQL Server 2008/R2, Teradata SQL Assistant, Teradata, HiveQL SSRS, Cognos, TFS,Oracle 10g / 11g,Agile, UNIX, XML, XSLT

Confidential, FortMill, SC

ETL Tester

Responsibilities:

• Gathered software requirements through interviews (group and one-on-one) and JAD sessions and met client needs.
• Worked and validating on user stories, use cases to understand the user requirement for existing report and business logic.
• Created and executed Test Plan, Test Scripts, and Test Cases based on Design document and User Storiesdocument for testing purposes.
• Performed SQLQueries,creating Tables, and Views.
• Performed Data Validations using Microsoft SQL Server Management Studio 2008/2012.
• Wrote SQL and PL/SQL scripts to perform database testing and to verify data integrity.
• Tested different detail, summary reports and on demand reports developed by Report Studio.
• ReporteddebuggingusingInformaticaand tracked defects using Quality Centre/ALM and TFS.
• Involved in extensive datavalidation by writing several complex SQL queries and Involved in back-end testing and worked with data quality issues.
• Writing complex SQL queries for data validation for verifying the Informatica Packages and business Rules
• Performed all aspects of verification, validation including functional, structural, regression, load and system testing
• Worked in AGILE Methodology and used Agile Test Methods to provide rapid feedback to the developers significantly helping them uncover important risks.
• Developing advanced and complex 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.
• Wrotecomplex SQL queries for validating Business Objects Reports.
• Focused on Data Quality issues / problems that include completeness, conformity, consistency, accuracy, duplicates, and integrity.
• Involved in backend testing for the front end of the application using SQL Queries in Teradata database.
• Worked with XML transactions for multiple feeds.
• Created Data Mapping Document, validatingdata asin sourcesand tables in the data warehouse as target.
• Worked with Data Conversion projects for testing data quality after migration.
• Experienced in data analysis using SQL, PL/SQL and many other queries-based applications.
• Testedreports based on the statistical analysis of the data from various time frame and division using SQL Business Objects
• Tested all Business Objects Dashboards according to the requirement.
• Validatedthe business functionality usingUATTesting.

Environment: Informatica9.0/8.6, SQL Server 2008/R2, Teradata SQL Assistant, Teradata SSRS, TFS,Oracle 10g / 11g,Agile, UNIX, XML, XSLT

Confidential, Buffalo, NY

ETL Tester

Responsibilities:

• Involved in Business analysis and requirements gathering.
• Worked with business requirements analysts/subject matter experts to identify and understand requirements. Conducted user interviews and data analysis review meetings.
• Analysed Business Requirements performed gap analysis and segregated them into high level and low level Use Cases, Activity Diagrams/State Diagrams and Class Diagram.
• Created business and technical requirements, functional specs, gather and translate functional requirements into technical requirements and provide analytical support to the management team as needed.
• Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
• Used Quality Centre for tracking the defects.
• Validatedpackages using Informatica (ETL) to verify data completeness, data transformation, data quality, integration testing, UAT & regression testing.
• Tested mapping for extracting, cleansing, transforming, integrating, and loading data using Informatica ETL Tool.
• Tested various operational Drill-through and Drill-down reports using Business Objects
• Used Agile Test Methods to provide rapid feedback to the developers significantly helping them uncover important risks.
• Tested the outgoing links from all the web pages from specific domain.
• Involved in Implementing Agile (Scrum) methodologies for the complex project modules.
• Tested and worked on creating open document reports for business.
• Interacted with Users to understand the bugs in Business Reports generated from Business Objects.
• Coordinated and Interacted with Development team and actively participated in status meetings during the defect life cycle, reported the bugs and maintained their status.
• Developed Test Strategy, Test plan, Test cases, and Test scripts and various other project documentation in HP Quality Center.
• Extracted data from various sources like Oracle, flat files and DB2.
• Tested SCD tables Type 1, Type 2 and Type 3.
• Experiencedin loading from various data sources like Teradata, Oracle, Fixed Width and Delimited Flat Files.
• Experiencedin testing XML files and validating the data loaded in tables.
• Worked on optimizationof SQLqueries for better performance and efficiency.
• Worked on issues with migration from development to testing.

Environment: Informatica, Business Objects, Quality Center 10.0,Jira,Quality Center 10.0/ALM,Teradata SQL Assistant SQL,, Test Cases, Test Scripts, Test Plans,Agile, Unix,XML, XSLT, XSD

Confidential, Arlington, TX

ETL Tester

Responsibilities:

• Responsible for the execution for the project life cycle (SDLC), including requirements gathering, design, testing, implementation and documentation, as required.
• Interacted with the Users for collecting their requirements to design and format reports.
• Involved in Relational modeling and Dimensional Modeling Techniques to design ER data models and Star Schema designs.
• Tested different master detail, summary reports, ad-hoc reports and on demand reports using SSRS Reports and Cognos Reports.
• 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.
• Extensivelyworked on Claims,Members,Providers andAuthorization Modules.
• Worked in anagiletechnology with Scrum.
• Wrote User Story as per the requriments.
• Reported bugs and tracked defects using Quality Center.
• Executed SQL queries to perform backend database testing and verify/modify user data.
• Compared the actual result with the expected results. Validated the data by reverse engineering methodology i.e. backward navigation from target to source.
• Tested complex mappings using mapplets and reusable transformations.
• Established and documented ETL QA standards, procedures and QA methodologies.
• Verifieddevelopment of rule-set test scenarios, test cases, expected results and analysis of XML test scripts.
• Experienced inInformatica power center for extraction, transformation and loading process.
• Worked andtested several ETL Mappings developed using Informatica.
• Worked with ETL Source System and Target System (ETL Mapping Document) for writing test cases and test scripts.
• Tested Cognos reports to check whether they are generated as per the company standards
• 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.

Environment: Informatica Power Center, Cognos 7 Series, QTP, SOAP, Windows NT, Test Cases, Test Scripts, Test Plans. Oracle 8i, SQL Server,Agile, SQL, PL/SQL, Quality Center, TOAD