SUMMARY:

• 14 years of IT experience in the testing of Business Intelligence solutions using Data Warehouse/Data Mart, ETL, OLAP, Hadoop and Client/Server Applications.
• Expertise in creating Test Plan documents and developing test strategy documents and preparing the Traceability Matrices.
• Experience in testing involving ETL systems (Data stage and Informatica)
• Strong knowledge of different development lifecycles and methodologies, including SDLC, and Agile development approach.
• Strong experience in test management tools like Test Director, Quality Center, HPALM, JIRA, Rational Quality Manager
• Experience with Integration testing of the applications using various sources like flat files, Sybase and oracle databases.
• 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)
• Experience in debugging the issues using Informatica Workflow manager, Informatica Workflow monitor, Autosys and database.
• Experience in Functional Testing, Integration Testing, Regression Testing, GUI Testing, Smoke Testing, System Testing.
• Hands on experience in BI Reports testing using Microstrategy, SAS, OBIEE, Cognos, Business Objects and Crystal Reports.
• Hands on experience in writing complex SQL for data validation and Reports & Dashboards validation.
• Extracted the data from Teradata into HDFS using Sqoop.
• Created and worked Sqoop (version 1.4.3) jobs with incremental load to populate Hive External tables.
• Experience in writing Pig (version 0.11) scripts to transform raw data from several data sources into forming baseline data.
• Developed Hive (version 0.10) scripts for end user / analyst requirements to perform ad hoc analysis.
• Capable of validating large sets of structured, semi - structured and unstructured data from files and database .
• Very good understanding of Partitions, Bucketing concepts in Hive and designed both Managed and External tables in Hive to optimize performance
• Validated and reported performance issues in Hive and Pig scripts with understanding of Joins, Group and aggregation.
• Validated UDFs in Java as and when necessary to use in PIG and HIVE queries
• Validated Oozie workflow for scheduling and orchestrating the ETL process
• Very good experience in monitoring and managing the Hadoop cluster using Cloudera Manager.

TECHNICAL SKILLS:

Database: Oracle 11g/10g/9i/8i, DB2, SQL server 2005,2008, 2012, Teradata 14, HBASE, Cassandra

ETL Tools: Informatica, Datastage, SAS, Talend, SQL*Loader, SQL Server DTS and BCP and Import/Export,

Reporting Tools: OBIEE, Cognos, Crystal Reports, Business Objects, Microstrategy

Big Data tools: PIG, Hive, Sqoop, Flume, Oooze, HDFS, Impala, SPARK

Test Management Tools: Test Director 7.0, 8.0, Quality Center 10.0,11.0, ALM, JIRA, Rally, RQM

Operating System: Windows, UNIX

Languages: SQL, PL/SQL, JAVA, PYTHON, PIG, HIVE, Unix Shell Scripting

Other tools: Toad, MS Visio, AQT, SQL Developer, SharePoint, MS Office, MS Visio, MS Project, ACMS, EPIC

Version Control Tools: MS Visual Source Safe (VSS), Rational Clear Quest, Subversion(SVN)

PROFESSIONAL EXPERIENCE:

Confidential, Richardon, TX

Test Lead

Responsibilities:

• Developed Hive queries (Hql) for Data mapping and validation.
• Developed Python UDF for getting the correct UTF timestamp
• Wrote Shell scripts for data loading and injecting into HDFS.
• Understand the bottlenecks and dependencies of existing systems
• Determine the optimal way to extract, integrate and maintain the data in the new system
• Responsible for direct interaction with client to gather the requirements.
• Performed requirement analysis and design in building the data lake.
• Work with business and Architect to understand the impact and streamline of the requirement.
• Worked as an interface between the business and technical team to get solutions to identify and solve the issues.
• Actively participated in requirement gathering and analyzing business requirement .

Environment: Cloudera 5.8.3, Syncsort DMX-h, Hive, Impala, Java UDF, Unix Shell scripts, Python, DB2, SAS, Cobol Copy book, Sql Server, Hadoop 2.0(HDFS & Map Reduce)

Confidential

Test Lead

Responsibilities:

• Ensure that quality processes are carried out through all phases of the Software Development Lifecycle.
• Validated data in reports are populated correctly as per business requirement document.
• Validated layout in reports are populated correctly is as per requirement.
• Validated balancing reports balance date between Guidewire and ODS.
• Developed test data in Guidewire to test requirements.
• Requested to upstream for test data requirement’s as per test scenarios.
• Make sure data in test environment is available as per requirements.
• Worked in onsite offshore model and delegated and reviewed task to offshore.
• Develop process for Data Analysis and testing Data flow.
• Create and maintain test cases in ALM.
• Actively participate in walkthrough, inspection, review and user group meetings for quality assurance
• Work with business users, system analysts, designers and programmers to create and analyze various required project documents
• Plan, document, evaluate and track testing results to ensure system applications are free from defects
• Communicate and interact with appropriate areas on problems, changes and enhancements that may impact data, workflow and /or functionality within Information Technology software
• Comply with standards of the software development life cycle and follow strategies, plans and procedures within information Technology software
• Design test plans, scenarios, scripts, and procedures.
• Develop testing programs that address areas such as database impacts, software scenarios, regression testing, negative testing, error or defect retests, or usability

Environment: Informatica, Guidewire, Oracle, Cognos

Confidential, MN

Hadoop/ Big Data & DW BI QA

Responsibilities:

• Ensure that quality processes are carried out through all phases of the Software Development Lifecycle
• Work with business partners, systems analyst, designers and programmers to create/analyze required project documents and ensures that quality assurance processes are incorporated
• Developed test data in Teradata to test requirements.
• Created source file as file format mentioned in mapping document to validate requirements.
• Requested to upstream for test data requirement’s as per test scenarios.
• Make sure data in test environment is available as per requirements.
• Ability to write test cases and execute testing within a Unix /Database environment
• Develop process for Data Analysis and testing Data flow.
• Apply solid understanding of the Software Development Life Cycle, Data Warehouse Hadoop and QA process.
• Establish and maintain test cases and test data
• Create and maintain test cases in Quality Center
• Actively participate in walkthrough, inspection, review and user group meetings for quality assurance
• Work with business users, system analysts, designers and programmers to create and analyze various required project documents
• Participate in production implementation verification and being accountable for validating system quality
• Plan, document, evaluate and track testing results to ensure system applications are free from defects
• Communicate and interact with appropriate areas on problems, changes and enhancements that may impact data, workflow and /or functionality within Information Technology software
• Comply with standards of the software development life cycle and follow strategies, plans and procedures within information Technology software
• Comply with standards and strategies of the software development life cycle

Environment: Informatica, DB2, TWS, Teradata, UNIX, Hadoop

Confidential, Portland, OR

DW BI Test Lead

Responsibilities:

• Develop Test plans, Test Strategy, Test Cases & decided on automation when required.
• Run jobs from Informatica and Autosys.
• Created test data to validate business logic/requirements.
• Developed Test Plans, Test Cases, and Test Scripts for UAT tests.
• Tested Reports in the Dashboards for the Oracle Financial Analytics modules like GL, AP, AR and created the Ad-hoc report according to the client needs.
• Developed test data in Teradata to test requirements.
• Responsible for defining test strategy and test approach for validating Microstrategy canned reports, Adhoc reports and Dashboards
• Hands on experience on validating Microstrategy reports, cubes, Adhoc reports and Dashboards.
• Configured Interactive Dashboard with drill-down capabilities using global and local Filters, Tested Cascading Prompts and Multi Level Prompts on Dashboards.
• Identified issues, performance bottlenecks, and optimized the Business Intelligence Dashboards and Reports.
• Tested different kinds of reports (pivots, charts, tabular) using global and local Filters.
• Wrote Custom SQL Codes for the reports.
• Applied Optimization Techniques for the better performance of the reports.
• Used external tables to Transform and Load data from Flat files into target tables.
• Used Debugger to validate Mappings by creating break points to analyze and monitor Data flow.
• Involved in troubleshooting the load failure cases, including database problems.
• Created Test Cases, Test Scripts and defects in RQM Rational Quality Manager.
• Managed and conducted System testing, Integration testing, Functional testing, and Regression testing.
• Execute batch processing and verify the jobs status and data in database tables.
• Tracked the defects using RQM and generated defect summary reports.
• Prepared status summary reports with details of executed, passed and failed test cases.
• Interacted with developers, Business & Management Teams and End Users.
• Validated requirements are correctly implemented using database, INFA mapping designer and Autosys.
• Deployed Autosys file (.txt and .jil) in Autosys database using Autosys GUI.
• Created and changed the database connections in INFA workflow manager.
• Changed the SQL Query in INFA mapping designer and INFA Workflow manager

Environment: Informatica, Microstrategy, Autosys

Confidential, Portland, OR

ETL Tester (QA Lead)

Responsibilities:

• Develop Test plans, Test Strategy, Test Cases & decided on automation when required.
• Run SQL query in Apache Hive to validate data.
• Created test data to validate business logic/requirements.
• Validated test data in files received from Upstream are as per data requested.
• Validate test data follows format requested.
• 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 through developed Tractability Matrix and Test Coverage reports.
• Managed and conducted System testing, Integration testing, Functional testing, and UAT and Regression testing.
• Validating Microstrategy Adhoc reports, canned reports, Dashboards.
• Designing complex queries for Report and ETL validation.
• Execute batch processing and verify the jobs status and data in database tables.
• Tracked the defects using Quality Center and generated defect summary reports.
• Prepared status summary reports with details of executed, passed and failed test cases.
• Used Autosys jobs to run Informatica Workflows.

Environment: Informatica, SAS, Island Pacific (AS/400), Microstrategy, Autosys

Confidential

Lead - QA Test Analyst

Responsibilities:

• Involved in Creating and Administering the Physical Layer, Business Model & Mapping
• Involved in Design and Data Modeling using Star schema.
• Developed several mappings to load data from multiple sources to data warehouse.
• 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.
• Developed shell scripts to run Abinitio jobs
• Executed Informatica workflows from Informatica workflow manager and Autosys.
• Layer and Presentation Layer using Oracle Business Intelligence Admin tool.
• Created connection pools, physical tables, defined joins and implemented authorizations in the physical layer of the repository.
• Created Dimensional Hierarchy, Level based Measures and Aggregate navigation in BMM layer.
• Managed security privileges for each subject area and dashboards according to user requirements.
• Created groups in the repository and added users to the groups and granted privileges explicitly and through group inheritance.
• Developed custom reports/Ad-hoc queries using Oracle Answers and assigned them to application specific dashboards.
• Developed different kinds of Reports (pivots, charts, tabular) using global and local Filters.
• Handled Full load and refresh load via staging tables in the ETL Layer.
• Developed and tested Store procedures, Functions and packages in PL/SQL for Data ETL.
• 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.
• Executed shell scripts to run PL/SQL programs, Cognos reports from Autosys and jobs.

Environment: Oracle, Business Objects, Autosys, Informatica

Confidential

Lead - QA Test 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.
• Used Informatica as an ETL Tool for testing the Data Warehouse.
• 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.
• Used Shell scripts extensively for automation of file manipulation and data loading procedures.
• Execute batch jobs and verify status and data in database tables.
• 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.
• Prepared status summary reports with details of executed, passed and failed test cases.
• Validated report layout, data with requirements.

Environment: Informatica, Crystal Reports, Teradata

Confidential, Saint Paul, MN

Senior ETL Tester

Responsibilities:

• Develop Test plans, Test Strategy, Test Cases & decided on automation when required.
• Developed Test Cases for Functional, Integration and Regression Testing.
• Collected the test data from the central system to validate the test cases.
• Analyzed use case requirements and developed test cases.
• Performed queries to the database using SQL to check the data integrity using TOAD.
• Participated in Testing Methodologies like Planning, Execution, Bug Tracking and Analyzing.
• Created and executed SQL queries to fetch data from the database to validate and compare expected results with those actually obtained.
• Verified the bugs fixed by developers during each phase of testing such as Black Box Testing.
• Analyzed, documented and maintained Test Results and Test Logs.
• Run UNIX jobs in Putty to validate input and output files.
• Used manual testing for Regression testing for each new build under test.
• Used Mercury’s Test Director to log defects and bugs.
• Run Abinitio jobs to validate mappings.
• Managing the Defect Tracking process, which included prioritizing bugs, assigning bugs, and verifying bug-fixes, using Test Quality Center

Environment: Abinitio, Teradata, DB2, Business Objects

Confidential

ETL Test Analyst Leader

Responsibilities:

• Involved in analyzing the business process through Use Cases, Work Flows and Functional specifications.
• Analyzed the business and functional requirements of the application and developed detailed test plans, test cases in Test Director.
• Defined the test criteria and project schedules, and baseline the Test Plan with the help of project meetings, walkthroughs.
• Developed the Test plans for quality assurance based on functional requirements.
• Involved in the automation of testing process QTP as testing tool.
• Performed database testing using SQL.
• Run the Datastage jobs.
• Memory leaks, Network bottlenecks, Response time for each scenario was monitored.
• Involved in the documentation of the complete testing process.
• Interacting with the development and testing teams to improve overall quality of the software.
• Involved in creating periodic status reports.
• Followed Rational Unified Change Management Process.
• Created GUI, Bitmap, Database and Synchronization Checkpoints to compare the behavior of a new version of the application with the previous version
• Developed Test Strategy, prepared Track Sheets to keep track of the tasks assigned to the Jr. Testers, and resolved issues.
• Actively participated in BUG meetings to resolve the defects in efficient and timely manner.
• Assured that all QA Artifacts are in compliance with corporate QA Policies and guidelines.
• Used Test Director to detect defects, communicates to the developers and tracking the defects.
• Coordinated and communicated the whole QA effort by effectively working with different teams.

Environment: Datastage, Oracle 10g, Cognos

Confidential

Project Leader

Responsibilities:

• Reviewed the System Requirement Specs (SRS).
• Analyzed business requirements document and Involved in developing test plan, test objectives, test strategies, test priorities etc.
• Managed requirements and developed Test Scripts and Test Cases using Test Director.
• Mapped requirements to business scenarios to assure that all requirements were covered.
• Implemented and automated regression test scripts based on business requirements using Win Runner. Enhanced the scripts by adding control and conditional statements using TSL
• Used GUI, Text, Bitmap, Database checkpoints and synchronization statements extensively to customize the Win Runner scripts. Parameterized the scripts and data drove them to improve the flexibility of the tests.
• Involved in the performance testing and analyzed the response times under various loads.
• Used Performance monitor and Load Runner graphs to analyze the results.
• Manually performed Back-End testing by writing SQL queries.
• Performed testing in Mainframe using Attachmate
• Worked with users to develop user acceptance plan and test cases.
• Tracked bugs using Test Director and performed regression testing of the entire application once the bugs are fixed.
• Attended various meetings with the developers, clients, and the management team to discuss major defects found during testing, enhancement issues, and future design modifications.
• Developed detailed test conditions and documented test scripts and test procedures.
• Developed various reports and metrics to measure and track testing effort.
• Used Win Runner for regression testing and Load Runner for server performance testing.
• Planning and estimating for the testing efforts, keeping the plan up to date.
• Coordinating with development team at on-site.
• Coordinating with testing team at offshore.

Environment: Informatica, Oracle 9i, Microstrategy

Confidential

Test Analyst

Responsibilities:

• Created Quality Assurance test strategy. Coordinated the entire test effort with team members and developers.
• Developed test plan based on Business Specifications.
• Prepared test cases using Mercury Interactive Test Director based on the business requirements and the Test Plan.
• Reviewed the test cases written by the team members and suggested any updates if necessary.
• Update the test cases according to the change requests approved.
• Keep QA Network Drive Folders/Contents “Clean” and Up-to-Date.
• Provide daily and weekly updates to Project Manager regarding testing progress and notify issues if any.
• Follow up on issues and make sure they get resolved ASAP so that they do not impact testing plan.
• Organize and conduct weekly Defect Review meetings.
• Communicate with Offshore team regarding project updates and work assignment on a daily basis.
• Co-ordinate with the development team to have a quick turnaround of defects.
• Mentored team members on using the tools like Test Director and Clear Quest efficiently.
• Verify data in Mainframes and validate it against the UI.
• Enhanced existing Test Scripts based on changes to the requirements.
• Used Test Director for writing and executing Test Cases.
• Used Clear Quest for defect tracking.
• Involved in discussions with the Business Team and the developers regarding any changes in the requirements.

Environment: Informatica, Oracle 9i

Confidential

Senior Tester

Responsibilities:

• Reviewed the System Requirement Specs (SRS).
• Create Use Cases process Flows, Data Flows, transitions and Decision trees by conducting Interviews, requirement workshops, brainstorming sessions; questionnaires with actuarial, stats, finance teams and getting the requirement of the system and changes need to be done.
• Analyzed business requirements document and Involved in developing test plan, test objectives, test
• Created Test strategies, test priorities etc.
• Managed requirements and developed Test Scripts and Test Cases using Test Director.
• Mapped requirements to business scenarios to assure that all requirements were covered.
• Involved in the performance testing and analyzed the response times under various loads.
• Used Performance monitor and Load Runner graphs to analyze the results.
• Manually performed Back-End testing by writing SQL queries.
• Worked with users to develop user acceptance plan and test cases.
• Tracked bugs using Test Director and performed regression testing of the entire application once the bugs are fixed.
• Attended various meetings with the developers, clients, and the management team to discuss major defects found during testing, enhancement issues, and future design modifications.
• Developed detailed test conditions and documented test scripts and test procedures.
• Developed various reports and metrics to measure and track testing effort.
• Used Win Runner for regression testing and Load Runner for server performance testing.
• Planning and estimating for the testing efforts, keeping the plan up to date.
• Preparation of system test plan & performance test plan.
• Coordinating with development team at on-site.
• Coordinating with testing team at offshore.
• Preparation of system test plan & performance test plan

Environment: ASP.NET, SQL SERVER 2000, JavaScript