SUMMARY

• Over 7 years of experience in Software Quality Assurance (QA) and tested Data Warehouse, Database (ETL & BI), Web, and Client - Server Systems and Applications for Banking, Insurance, Financial, Mortgage, Healthcare, and Telecommunication Industries.
• Extensive experience in ETL Testing and Reports Testing.
• Strong experience validating the data according to functionality of the applications.
• Working Experience with Agile Methodology, Water fall and Iterative Models.
• Experience in Defining Testing Methodologies; creating Test Plans and Test Cases, Verifying and Validating Application Software and Documentation based on standards for Software Development and effective QA implementation in all phases of Software Development Life Cycle (SDLC).
• Experience working with Data Warehousing, Data Validations, Data Scrubbing, Data Cleansing, Data Profiling and Data Frequency Analysis.
• Extensively used ETL methodology for supporting data extraction, transformations and loading processing, in a corporate-wide-ETL Solution using Informatica.
• Validated data consistency, data completeness, de-duping logics in data migration and data conversion projects.
• Experience in using UNIX commands and shell scripts for file management.
• Experience in validating the ETL and PL/SQL batch jobs scheduled using Autosys.
• Experience in Dimensional Data Modeling using Star and Snow Flake Schema.
• Experience in BA, QA and software testing roles that includes requirements analysis, development of test plans, test strategy planning, creating test cases, test case execution.
• Excellent working knowledge of software development life cycle (SDLC) and software testing life cycle (STLC) in requirements gathering, analysis, design, development, implementation and testing,
• Actively involved in business and system requirements document review and key resource for UAT phase and production roll-out.
• Experience using Quality center, Rally, JIRA as test management tools.
• Experienced SQL Data Analyst / Data Reporting Analyst with strong background in design, development, and support of online databases and information products as well as data analysis / reporting / processing.
• Extensive experience in ETL process consisting of data transformation, sourcing, mapping, conversion and loading
• Proficient in Oracle, PL/SQL Development, Toad, DB2, SQL Server, PL/SQL Developer, SQL Navigator, Perl, UNIX.
• Ability to communicate effectively with customers to eliminate disruptive situations.
• Proven strength in problem solving, coordination and analysis.
• Strong experience in multi-tasking and meeting deadlines in time.
• Achievement oriented with excellent people management skills and an ability to manage change with ease.
• Strong communication, interpersonal, learning and organizing skills matched with the ability to manage stress, time and people effectively.

TECHNICAL SKILLS

Operating Systems: Windows 8/7/XP, UNIX (Linux, Sun Solaris, IBM AIX)

Test Management Tools: ALM, Quality Center, Rally, TFS, JIRA

Databases: Oracle 11g/10g/9i, Server 2008/2012, DB2, Teradata

Big Data: Hadoop, Hive, Pig, Map Reduce, HDFS

ETL Tools: Informatica, Data Stage, Ab Initio, SSIS

Reporting Tools: Cognos, Business Objects, SQL Server Reporting Services (SSRS), SSAS

Query Tools: Toad, SQL Query Analyzer, SQL Plus, Teradata SQL Assistant

Scripting Languages: XML, HTML, Shell Scripting

Languages: SQL, PL/SQL, Siebel

Packages: MS-Office, Visual Studio 2005

PROFESSIONAL EXPERIENCE

Confidential, Ann Arbor, MI

Sr. ETL/Big Data/Reports QA Analyst

Responsibilities:

• Developed and maintained Test Plans, Test Cases and Test Scripts to ensure the development and delivery of software applications.
• Planned, managed, and executed tests in accordance with Test Strategy.
• Accomplished testing of Reporting System at various stages of Database Migration.
• Validated source and target Tables, Data Structures, Data, Count, duplicates, Lookups, joins, Mapping/ETL rules.
• Reviewed Test Cases and other testing artifacts created by other team members for completeness and accuracy.
• Developed and executed test strategies and plans for various testing types and levels.
• Participated in all phases of SDLC starting from Analysis to Delivery of the projects.
• Worked in all cycles of STLC: Defect Tracing, Defect Raising, Fixing, Retesting, Closing, and Deferring.
• Used Informatica IDQ for data validation and data profiling.
• Verified and maintained Data Quality, Integrity, Data Completeness, ETL rules, Business Logic.
• Conducted Manual/Functional testing such as: Smoke, Integration, Regression, End to End Testing.
• Coordinated testing efforts, responsible for test deliverables, status reporting to management, Issue Escalations.
• Validated the ETL and PL/SQL batch jobs scheduled in Autosys.
• Tested data in Staging area, Operational data store, Base Layer, and BI layer.
• Developed Test cases in a form of SQL query and stored procedures and triggers to verify logic for standard and Custom Reporting system.
• Managed the test cases, scripts and monitored the bug using Quality Center.
• Created/Modified SSIS packages to support future enhancements.
• Created SSIS packages to clean and load data to data warehouse.
• Used JIRA for Test management and task management.
• Implemented and validated Log shipping between production servers to Hadoop HDFS using Flume.
• Written several pig and hive scripts to validate the data coming from Hadoop and the data that is copied on to the Hadoop.
• Used Flume to load the log files into Hadoop HDFS.
• Worked in accordance to QA methodology, project schedule and time lines.
• WrittenComplex SQL scriptsand analyzed them for effective Data validation and Data Integration purposes duringETL/Backend Testing.
• Tested the presentation layers of the application by cross browser behavior and browser logic to ensure positive experience for end user.
• Validated data moving from source to target using Informatica Data Validation Option.
• Validated the initial and incremental loads.
• Worked on application integration testing in SOA Architecture and validated the SOAP based web services.
• Validated several OBIEE ad hoc reports.
• Used Informatica workflow manager to run the workflows and workflow monitor to verify the session logs.
• Identified the root cause for errors using Informatica workflow designer.
• Validated SSRS packages according to report specification documents.
• Participated in Story reviews, Daily agile scrum meeting, and retrospectives to discuss about the project.
• Validated the OBIEE reports for data quality and lay out of the reports.
• Involved in onshore offshore coordination of projects.

Environment: Informatica 9.5/9.1, DVO, IDQ, Oracle 11g, OBIEE reports, Hadoop, HDFS, Map Reduce, JAVA, Hive, Pig, Sqoop, SQL, PL/SQL, Toad, SQL Server 2012, SSIS, SSRS, SSAS, QTP, Quality Center, .Net, UNIX, Shell Scripting, DB2, JIRA, SharePoint, Rational Requisite Pro, Clear Quest, Clear Case, Autosys, XML, XSD, Web Services, SOA, Soap UI

Confidential, San Francisco, CA

Sr. BI ETL/Big Data/Web QA

Responsibilities:

• Analyzed the User requirements, Functional Specifications and Use Case documents and created the Test Plans, Test cases for Functional testing.
• Coordinated ETL team in each phase of project (Data Requirement Analysis, Data Field Analysis, Data Mapping and ETL Testing).
• Validated various SSIS, SSRS packages and SSAS cubes.
• Developed external mapping to transfer data from SQL Server database to Oracle Data Warehouse.
• Validated the interfaced data from various environments into SSQL Server database using SSIS packages.
• Validated the web Services using Soap UI.
• Coordinated the testing of SSIS ETL using complex stored procedures.
• Developed Test Plans for User Acceptance Test.
• Used TFS for test management and defect management.
• Participated in preparation of UAT Test Plan, Test cases and executed the UAT Test cases.
• Accomplished Integration Testing, Data Testing, Functional testing, System testing, and Ad-hoc testing
• Analyzed bugs and coordinated with development team and ETL team members to fix defects.
• Evaluated many ETL packages for the project according to data mapping requirements.
• Tested ad-hoc and standard reports generated by Micro Strategy.
• Updated QA Manager and Lead weekly with the testing status, which included Test Task Plan, Defect Management, and Test Metrics.
• Successfully Coordinated User Acceptance Testing (UAT) on each release of the project.
• Involved in doing Business analysis and Requirements gathering for new tables.
• Coordinated all aspects of the solution delivery including Design, Development, Testing, and Deployment.

Environment: SQL Server 2008, SSIS, SSRS, SSAS, Oracle 10g, SQL, T-SQL, PL/SQL, Micro Strategy, TFS, Share Point, Windows, SQL Server Agent, Toad, Soap UI, Web Services, SOA, Java, Hadoop, HDFS, Pig, Map Reduce, Sqoop, Hive.

Confidential, Chicago, IL

Sr. ETL QA Analyst / Data Analyst / Production Support

Responsibilities:

• Prepared test strategies, test plans, test cases, test scripts for ETL and Report Testing.
• Validated the implementation of fact and dimension tables in Star Schema model based on requirements.
• Validated data requirements and elements used in XML transactions.
• Troubleshooted resolved and escalated data related issues and validated data to improve data quality.
• Validated files from source to make sure correct data has been captured to be loaded to target tables.
• Validated Autosys batch jobs according to requirements.
• Designed and developed UNIX shell scripts.
• Used Cognos Report studio, Analysis studio, Query studio for report validations.
• Written SQLs to validate Ab Initio ETL graphs according to data mapping specifications.
• Used Quality Center to track and report system defects and bug fixes.
• Validated the Map reduce, Pig, Hive Scripts by pulling the data from the Hadoop and validating it with the data in the files and reports.
• Imported the data from databases into Hadoop using Sqoop.
• Written Map reduce programs and Identity reducer programs to achieve the data analysis requirements in Hadoop
• Monitored the status of the Hadoop HDFS periodically and performed root-cause analysis on the issues identified.
• Written modification requests for the bugs in the application and helped developers to track and resolve.
• Validated the migration of Cognos reports from 8.6 to Cognos 10.
• Validated the load process of ETL to make sure the target tables are populated according the data mapping provided that satisfies the transformation rules.
• Performed the file level, field level validations for loading of data into staging tables by Ab Initio graphs.
• Validated the archive process to purge the data that meet the defined business rules.
• Written complex SQL queries using Case Logic, Intersect, Minus, Sub Queries, Inline Views, and Union.
• Involved in validating the aggregate table based on the rollup process documented in the data mapping.
• Written several complex SQL queries for validating and verifying the data across different databases including SQL Server and Oracle.
• Validated the business objects reports for data quality and the cosmetics.
• Prepared test plans/test schedules with inputs from Project manager and development team.

Environment: Oracle 11g, Ab Initio, SQL, PL/SQL, Quality Center, QTP, UNIX, SQL Server 2008, Cognos 8, UNIX Shell Scripts, Autosys, XML, XML Spy, AS400, Main Frames, Business Objects XI, Doors, Rally, Clear Case, Clear Quest, Doors

Confidential, Boise, ID

ETL QA Analyst / Data Analyst

Responsibilities:

• Validated the data in the reports by writing simple to complex SQL queries in the transactional system.
• Executed reporting test cases for Crystal Reports and Cognos.
• Performed shakeout testing on the historical loads in UAT and PROD environments.
• Worked on integration of all the processes in UAT/PROD.
• Written several complex SQL queries for validating the data stage jobs.
• Created various PL/SQL stored procedures for dropping and recreating indexes on target tables.
• Performed data inspection/analysis of tables as well as outbound files.
• Used data stage director to execute the jobs and verify status.
• Validated functionality of PL/SQL Procedures, Functions, Over loaded Functions, Triggers,
• Involved in validating the ETL mappings from various systems (CRM, OLTP) to transaction history/ reporting database.
• Validated SSIS and SSRS packages according to business requirements documents.
• Verified layout of data files and control file entries as per business requirement.
• Based on the generated test data wrote test cases to demonstrate testing approach.
• Conducted functionality testing during various phases of the application.
• Tested the entire data reconciliation process for multiple source and target systems.
• Involved in creating the test data for generating sample test reports before releasing to production.
• Wrote complex SQL scripts using joins, sub queries and correlated sub queries.
• Provided input into project plans for database projects providing timelines and resources required.
• Validated the data integrity and security maintained using integrity constraints and data base triggers.

Environment: Data Stage, SQL, PL/SQL, TOAD, IBM DB2, Mainframes, Crystal Reports, Cognos 8, Oracle 10g/9i, Teradata V2R6, SQL Server 2005/2000, Quality Center, SSIS, SSRS, SSAS Clear Case, Clear Quest, Requisite Pro, UNIX, Putty, JIRA

Confidential, New York City, NY

ETL QA Analyst

Responsibilities:

• Verified layout of data files and control file entries as per business requirement.
• Validated the base table (Star schemas- Fact and Dimension) by writing complicated SQL statements and reports.
• Developed backend programming in Oracle using PL/SQL and SQL.
• Performed Requirements Verification Testing, Unit Testing, Functional Testing, Security Testing, Regression Testing, Positive, Negative testing, Post Production testing and End to end Testing of ETL code and reports.
• Tested daily, monthly and quarterly loads end to end.
• Created new Oracle Stored Procedures and modified the existing ones. Designed, Developed and tested PL/SQL Programs to prepare and clean Data for data migration and also to retrieve data from the database to compare against the input sets.
• Validated micro strategy reports for the data and the layout.
• Prepared Mapping documents and design documents for data conversion.
• Developed validation procedures and error reporting on the data in the intermediate tables.
• Wrote Test cases for Enterprise Data Warehousing (EDW) Tables and Data Mart Staging Tables.
• Wrote SQL queries for each Test case and executed in SQL Plus to validate the data between Enterprise Data Warehousing and Data Mart Staging Tables.
• Validated Informatica ETL workflows according to functional and data mapping specifications.
• Wrote and ran Unix Scripts for batch jobs.

Environment: Informatica, Oracle 8i, Toad, SQL, Shell Scripting, PL/SQL, Micro Strategy, UNIX, SQL Server, Windows XP