SUMMARY

• Over 7+ years of IT experience in various phases of IT projects such as Development, Testing, deployment and application support.
• Have good experience with AXIOMSL Regulatory Reporting tool.
• Hands on experience with all phases of Software Testing Life Cycle (STLC).
• Have the ability to elicit, understand and articulate business requirements and perform detailed analysis to map them to functional QA requirements.
• Expertise in creating Test plan documents and Test strategy documents.
• Expertise in designing the test scenarios and scripting the test cases in order to test the application.
• Expertise in QA process and different levels of testing like Functional, Regression, and Integration testing with business scenarios.
• Proficient in quality assurance testing by manually and using Automation tools (QTP, ALM/Quality Center).
• Extensive experience with ETL tools Informatica Power Center.
• Supporting presales activity for Data centric warehouse testing projects.
• Worked with ETL group for understanding Data Stage graphs for dimensions and facts.
• Experienced in coordinating resources within Onsite - Offshore model.
• Strong experience with ETL systems, and having expertise with tools Informatica and Data stage.
• Strong experience in testing Data Warehouse (ETL) and Business Intelligence (BI) applications.
• Strong experience in Data Analysis, Data Validation, Data Profiling, Data Verification, Data Loading.
• Experience in Dimensional Data Modeling using Star and Snow Flake Schema.
• Strong working experience in the Data Analysis and Testing of Data Warehousing using Data Conversions, Data Extraction, Data Transformation and Data Loading (ETL).
• Experience in maintaining Full and Incremental loads through ETL tools on different environments.
• Experienced in Defect Management using ALM, HP Quality Center.
• Good experience in writing SQL in order to data validation in migration as part of backend testing.
• Good exposure with databases like Oracle 10g, DB2, SQL Server 2012.
• Good expertise in using TOAD, SQL*Plus and Query Analyzer.
• Worked with different data sources ranging from VSAM files, flat files, and DB2, oracle and SQL Server databases.
• Experience with creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.
• Experience in debugging the issues by analyzing the SQL queries.
• Good experience in working with UNIX scripts in executing and validating logs for the issues.
• Experience with testing reporting tools (Cognos/Business Objects).
• 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.

TECHNICAL SKILLS

ETL Tools: Informatica 5.x/6.x/7.x/8.x (Power Mart & Power Center), SSIS, DataStage, AxiomASL.

BI / Reporting Tools: Objects XIR4, Cognos 8.0 Series, Crystal Reports, Hyperion, OBIEE, AXIOMSL

Testing Tools: HP Quality Center 10.0, Rational Clear Quest, Bugzilla, QTP/UTP

Data Modeling Tools: Erwin 3.x/4.x

Utilities: Toad, SQL Server Management Studio, Citrix server, Oracle SQL Developer, SQL Advantage, Putty

Databases: SQL Server 2012, Oracle 11i/10g/9i, Teradata V2R6, DB2, Sybase 12.5, Netezza

Programming Languages: SQL, PL/SQL, UNIX Shell Scripting

Operating System: Windows, Red Hat Linux, UNIX (Sun Solaris 5.8)

PROFESSIONAL EXPERIENCE

Confidential - San Francisco, CA

Quality Analyst - AXIOMSL ETL Testing

Responsibilities:

• Experience using Axiom tool and testing the Regulatory Report in SIT Environment.
• Tested large volume of data sets between the source and target.
• Have experience handling the data aggregations from several data sources/multiple servers and performing data validations
• Extensively used Informatica power center for extraction, transformation and loading process.
• Developed test strategy, detailed test plan, test cases and test scripts using Quality Center for Functional and Regression Testing.
• Effectively leveraged HPALM Quality Center for executing test cycles, and managing defects
• Experience working with multi-functional teams across onsite, offshore and near site
• Using Macro tool for data comparison and excel for large amounts of data comparison.
• Designed and kept track of Requirement Traceability Matrix for BRD, FDD and DDD.
• Created and Developed Reports and Graphs using ALM.
• Experience in leading offshore teams
• Used SharePoint and similar tools for content repository management
• Very good at leveraging Excel functions including Pivot table, Lookup, and Charts for reporting, etc.
• Have good experience writing complex SQL Queries for various scenarios using TOAD and SQL Server clients.
• Performed Interface and Integration (SIT) Testing.
• Performed all aspects of verification, validation including functional, structural, regression, load and system testing.
• Worked on test data and completed unit testing to check all business rules and requirements are met. Also tested for negative data to check that the job fails on any critical error.
• Performed data analysis and data profiling using SQL and Informatica Data Explorer on various sources systems including Oracle and SQL Server.
• Extracted Data from Different Servers using Informatica Power Center ETL and DTS Packages to the target database including SQL Server and used the data for Reporting purposes.
• Created ETL test data for all ETL mapping rules to test the functionality of the Informatica Mapping.
• Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing).
• Tested the reports using Business Objects functionalities like Queries, Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae etc.
• Used Putty to access files and directories in UNIX environment.
• Experience in creating UNIX scripts for file transfer and file manipulation.
• Used Agile Test Methods to provide rapid feedback to the developers significantly helping them uncover important risks.

Environment: Informatica 9.1, AXIOMSL, Oracle 11i, TOAD for Data Analysts, MLOAD, SQL Assistant 6.0, SQL Server 2005, HP Quality Center 9.2, SQL/PLSQL, SOA Test, Control-M, OBIEE, UNIX, Agile, Windows XP

Confidential - San Francisco, CA

Quality Analyst - Web Services and Manual Testing

Responsibilities:

• Worked in Agile methodology, attended daily stand up meetings to review User Stories.
• Attending sprint plan meetings every two to four weeks to review the user stories.
• Developed Test Plan and Test cases based on the user stories (Functional requirements) using the HP Quality Center.
• Executed Test cases and complete QA testing life cycle.
• Reported the defects. Involved in complete defect life cycle from creating new defect, assigning to responsible developers based on the module, retest, close and reopen etc.
• Execute SQL queries to validate data.
• Tracked the defects with developers, created detailed information for each defect with valid log files.
• Escalated issued with Team Leads, Technical architects and Project Manager based on the need.
• Tested Web Services, Validated Request and Response XML, SOAP Calls, Restful calls and WSDL using SOAPUI tool.
• Validated End Points in WSDL File, XML Schema.
• Added data related assertions to validate response XML in Web Services.
• Generated test coverage report and defect tracking report.
• Interacted with off shore team to resolve defects and functional issues of the application.
• Extensively used Quality Centre / HP ALM for test planning, bug tracking and reporting.
• Uploaded Business requirements, test scenarios, test cases and defects to Quality Center.
• Executed shell scripts in UNIX.
• Experience in testing Web-based and Client-Server applications on Windows platforms including application installations and configurations.
• Experience in Reviewed Business Requirement and Technical Specification Documents.
• Experiences in defining Test Methods, in-scope items, out-scope items and Policies.
• Hands On experience in delivering the high-quality documents as part of deliverables during the project.
• Performed Manual Testing and Data Integrity/Back-End Testing Data Base Testing by executing SQL Statements and tracked defects using Test director attended Bug-Review meetings.

ENVIRONMENT: Java/J2EE, SoapUI Pro, Remedy, XML, Quality Center, ETL, Linux, Oracle, TOAD, Web Services.

Confidential

Quality Analyst - ETL Testing

Responsibilities:

• Analysis of Business requirements & Design Specification Document to determine the functionality of the ETL Processes.
• Prepared Test Plan from the Business Requirements and Functional Specification.
• Participated in workflow migration from development to QA and to UAT environments as required.
• Worked in an agile technology.
• Extensively used Informatica client tools. The objective is to extract data stored in Oracle database, flat files to load finally into a single data warehouse repository, which is in Oracle.
• Written several complex SQL queries for validating OBIEE Reports.
• Tested SOA application interface and communication paths.
• Tested SOA security with limited access to communicate between the service.
• Developed test cases and scripts for ETL rules in Quality Center Test Plan.
• Interacted with DBA for setting up QA environment.
• Extracted Data from Teradata using Informatica Power Center ETL and DTS Packages to the target database including SQL Server and used the data for Reporting purposes.
• Executed SQL queries using SQL Assistant to validate data mart tables.
• Involved in Regression, Functional, Integration, System Testing and User Acceptance Testing.
• Tested all OBIEE Dashboards according to the requirement.
• Worked with Users to develop Test cases for user acceptance testing.
• Maintained the test logs, test reports, test issues, defect tracking using Quality Center.
• Developed Requirement Traceability Metrics (RTM) using Quality Center.
• Used Toad for Data Analysts to compare Oracle and Teradata databases.
• Used Putty to access files and directories in UNIX environment.
• Validated target table after extracting the data from source tables by running SQL queries using TOAD.
• Opened and Updated defect status in Quality Center.
• Attended daily QA status and defect meetings.

Environment: Informatica 9.1, Oracle 11i, TOAD for Data Analysts, MLOAD, SQL Assistant 6.0, SQL Server 2005, HP Quality Center 9.2, SQL/PLSQL, SOA Test, Control-M, OBIEE, UNIX, Agile, Windows XP

Confidential

ETL QA Tester

Responsibilities:

• Created Test Plan and developed test strategies.
• Created Manual Test Suites for various modules.
• Tested stored procedures & views.
• Tested the reports like Drilldown, Drill Up and Pivot reports generated from OBIEE.
• Performed Teradata SQL Queries, creating Tables, and Views by following Teradata Best Practices.
• Written SQL queries in order to data validation in migration as part of backend testing.
• Involved in extensive DATA validation using SQL queries and back-end testing.
• Extensively used SQL to verify and validate the data load.
• Worked with developing advanced SQL queries to extract, manipulate, and/or calculate information to fulfill data and reporting requirements including identifying the tables and columns from which data is extracted.
• Performed the tests in both the SIT, QA and contingency/backup environments.
• Writing the test scripts for manual testing.
• Worked on environment issues, Compatibility checks after post migration of applications to Unix to Linux
• Worked with UNIX scripts in executing and validating logs for the issues.
• Reported bugs and tracked defects using Quality Center 8.0 (Test Director) .
• Used FTP and Telnet protocols in order to migrate files to heterogeneous Operation systems like UNIX, Linux and windows.
• Submitted weekly bug or issue report updates to the Project Manager in the form of the QA Error Log.
• Involving in Functional testing, End to End testing and Regression Testing.
• Preparing and supporting the QA and UAT test environments.
• Understanding of Functional Requirement Specifications and System Requirement Specifications.
• Extensively tested several OBIEE reports for data quality.
• Wrote Complex SQL queries to verify report data with the source and target system (data warehouse) data.
• Assisted business users to execute UAT test scenarios and test data as part of Validation Testing .
• Experience on Data validation, Data merging, Data cleansing and Data aggregation activities.
• Validating the data against staging tables and target warehouse.
• Find report defects and subsequently validating the fix, repeating the process until done.
• Perform Sanity Testing, Data Driven Testing & Ad-hoc Testing when required.
• Perform system testing to ensure the validity of the Report requirements and mitigation of risks prior to formal acceptance.
• Performed Interface and Integration (SIT) Testing.
• Extensively use SQL queries for data validation and backend testing.
• Working with Data base testing Involved in Data Migration Testing and preparing documents. Functionality, Interface, and Regression testing.
• Preparing the SQL queries to fetch the data from databases.

Environment: Informatica Power center 8.6, OBIEE, Oracle 9i/10g, Teradata SQL Assistant, Teradata V2R6, TOAD for Oracle, Quality Center, Windows XP, UNIX