SUMMARY

• 9+ years of experience in Testing of Data Migration, Integration and Implementing database applications and solutions using best of breed technologies, Server, Web Based applications, Data Warehousing, BI Reports and ETL Testing.
• Expertise different testing such as white box, black box, smoke, regression testing.
• In depth technical knowledge and understanding of Data Warehousing, Data Validations, OLAP, SQL Server, Oracle and ETL.
• Worked on Hive query execution and validation with Hortonwork distribution and Kafka to HDFS pipeline streaming.
• Extensive experience in SQL Server 2012/2008/2005/2000 , Transact SQL (T - SQL), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Data Transformation Services (DTS) packages.
• Experience in Logical and Physical Database design & development, Normalization and Data modeling using Erwin.
• Worked on data migration validation using Informatica to SQL Server 2012.
• Experience in Software QA and Testing Methodologies, verification and validations in all phases of the SDLC.
• Experienced in creating Test Plans, Test Designs, Test Strategy Specifications, Test Cases and Scenarios.
• Experienced in DW projects ETL testing against DW testing with Informatica, Ab Initio and Datastage tools.
• Experienced in documenting defects, generate defect and test progress graphs with overall test summary.
• Validated various database objects and elements like tables, joins, views, stored procedures, User defined Functions, triggers, indexes and partitions.
• Extensive understanding in creating Clustered, Non-Clustered, Covered indexes and indexed views.
• Knowledge in creating Partitions, Partition function, Partition Scheme, Partitioning tables and indexes, Querying and managing Partitions.
• Ability to manage multiple project in testing by managing team, automate process and delivered all task using Rally, Pivotal Tracker, Service Now and Footprint task management system.
• Ability to develop complicated SQL script for Data validation testing by running SQL script, procedures.
• Extensively involved in SIT and UAT by supporting Testing and implement QA Process.
• Extensively Used Quality Center, PVCS Tracker, Rational Clear Quest for Test Case and defect tracking management.
• Experience in Data modeling (Dimensional & Relational) like Star-Schema Modeling, Snowflake Modeling, fact and dimension tables.
• Extensive experience in writing SQL to validate the database systems and for backend database testing
• Expert in working with various cross geo teams across the world with various time zones.
• Excellent interpersonal and communication skills with good learning curve in short span of time.
• Ability to work in a Team or individually and very flexible to work in complex environment with tight schedules

TECHNICAL SKILLS

Operating Systems: Windows XP/ 2000 Professional /98/NT, Unix, MVS

Languages: PL/SQL, Shell Scripting, SQL, HQL, Pyspark

Big Data Ecosystem: Hadoop, MapReduce, HDFS, HBase, Spark, Zookeeper, Hive, Sqoop.

Database: ORACLE, MS SQL, Teradata, DB2 and MS Access, OLTP, OLAP

Testing Tools: Rational Clear Quest, Quality Center 8.0/9.0/10, HP ALM, JIRA

ETL Tools: Informatica Power Center, Datastage, SSIS, Ab Initio

BI Tools: Business Objects XIR3, Cognos Series 8.0, Crystal Reports, Report2Web

Application: Guidewire, Policy System, Onbase, MyTMM

PROFESSIONAL EXPERIENCE

Confidential, San Antonio, TX

ETL/BI QA Test Lead

Responsibilities:

• Worked on design and implementation of C3I Analytical solution for Operational support.
• Expertise in Data Warehouse, ETL Verification, BI reports.
• Reviewed Physical and Logical Design docs and clarified design solutions with Developers and data modeler.
• Data validation ofHadoopstreaming jobs to process petabytes data
• Involved in performing functional, application, integration, system, and regression tests.
• Good experience working withHortonworksDistribution.
• Processed Real time data usingSPARK STREAMING in Pyspark.
• UsedKafkapipeline for streaming data transmission.
• UsedSPARK SQLto query directly on the Spark Streaming data
• UsedChange Data Capture (CDC) to simplify ETL in data warehouse application.
• Test scenario creation, Test strategy and Test Plan creation.
• Worked as ETL Tester responsible for the requirements / ETL Analysis, ETL Testing.
• Experience in Error and Event Handling using Squirrel SQL.
• Validated data sourced from XML, XSLT, File load into Squirrel DB2 table.
• Data validation of large sets of Structured and Semi structured data loaded using Kafka streaming into HDFS.
• Moved various formats like TSV, CSV etc. files from RDBMS to HDFS for furtherProcessing.
• Involved in creating Hive table and loading and analyzing data using Hive query.
• Worked on Hive query execution and validation of Hadoop Migration of Operational communication file system to DB2 database table.
• Extensively involved in UAT by supporting Testing and implement QA Process.
• Excellent knowledge on Agile Methodology and task management tool in RTC.
• Exported Manual Test Cases from MS Excel template directly to HP ALM and executed all the Test Cases in Quality Center with Pass/Fail/Blocked status
• Analyzed test results, identified issues and reported it to the developers and project manager through Jira.
• Self-motivated with an ability to work independently to meet operational deadlines in a demanding fast-paced environment.
• Good intercommunication skills to work with all levels of management.

Environment: SQL Server 2014, Squirrel SQL, XSLT 2.0. Autosys, HP ALM 12.0, JIRA, HDFS, HQL, Splunk, Hortonworks distribution, Spark.

Confidential, Charlotte, NC

ETL/BI Test Lead

Responsibilities:

• Worked on design and implementation of MSTR Reporting for Customer Credit Risk Management System.
• Expertise in Data Warehouse, ETL Verification, BI reports.
• Reviewed Physical and Logical Design docs and clarified design solutions with Developers and data modeler.
• Involved in performing functional, application, integration, system, and regression tests.
• Designed policies, standards and procedures for testing life cycle for the data warehouse and Summary tables.
• Worked as ETL Tester responsible for the requirements / ETL Analysis, ETL Testing.
• Experience in Error and Event Handling using Precedence Constraints, Break Points, Check Points, and Logging using Sql Server 2014.
• Performed end-to-end test from Input/Output Database to Microstrategy Reports.
• Extensively involved in UAT by supporting Testing and implement QA Process.
• Excellent knowledge on Agile and waterfall Methodology.
• Exported Manual Test Cases from MS Excel template directly to HP Quality Center and executed all the Test Cases in Quality Center with Pass/Fail/Blocked status
• Analyzed test results, identified issues and reported it to the developers and project manager through Jira.
• Test plan, Test Strategy and Test scenario preparation.
• Demonstrated sufficient oral and written communication skills for effective dialogue with Colleagues on a project team and superiors.
• Worked on Code Migration and Job Scheduling from development to QA and to UAT environments using AnthilPro and AutoSys.
• Participating actively in system, performance, regression and UAT testing for every new build released.
• Presented Daily Analysis Report to highlight bugs, issues and risks involved.
• Leading the team to perform QA activities.
• Attended project meetings, release meetings, and QA status meetings.

Environment: SQL Server 2014, Autosys, AbInition, AnthilPro, Microstrategy, HP ALM 12.0, JIRA.

Confidential, New York, NY

ETL Tester Lead

Responsibilities:

• Enhancement and implementation of Guidewire Claim Center Integration and System Test Specifications.
• Extensively worked on Policy system implementation and integration of Commercial line and personal line of various Line of business.
• Reviewed High Level and Low Level Design docs and clarified design solutions with Developers.
• Worked as ETL Tester responsible for the requirements / ETL Analysis, ETL Testing.
• Performed end-to-end test from Guidewire and to various downstream application.
• Determined testing requirements developed and reviewed scripts for positive and negative test scenarios, conducted baseline testing, white box testing, black box testing and regression testing and generated reports. Tested server and Web Portal.
• Verified Historical data conversion and migration from Legacy (PMS) System into Policy System and Guidewire Claim Center using SQL Server 2012 and Informatica Power center 9.5.
• Reviewed and Tested data load from Policy System to Middleware and from MW to data warehouse using SQL Server 2012.
• Experience in Error and Event Handling using Precedence Constraints, Break Points, Check Points, and Logging using SSIS 2008.
• Validated custom ad-hoc reports by using SQL Server Reporting Services (SSRS).
• Performed data validation testing of production defect using SQL and resolving and testing back end process.
• Participating actively in system, performance, regression and UAT testing for every new build released.
• Demonstrated an organized, systematic, disciplined and analytical approach to problem solving.
• Hands-on experienced with defect tracking tools like HP ALM.
• Extensively involved in UAT by supporting Testing and implement QA Process for data load and reporting using Cognos Series 8 V-10.2.2.
• Presented Daily Analysis Report to highlight bugs, issues and risks involved.
• Responsible for different Data mapping activities from Source systems to Reporting.
• Involved in all walk through for test designs, data designs and code reviews.
• Developed Test cases & Test Scenarios for new features and involved in Test estimation.
• Excellent knowledge on Agile and waterfall Methodology.
• Test plan, Test Strategy and Test scenario preparation.
• Test Estimation, Team reporting and resource management.

Environment: SQL Server 2008/2012, Informatica 9.5, Cognos Series 8 V-10.2.2, Report2Web, HP ALM, OnBase application, MyTMM, RMS, Guidewire, Autosys.

Confidential, Jacksonville, FL

ETL/BI Test Lead

Responsibilities:

• Reviewed High Level and Low Level Design docs and clarified design solutions with Developers
• Worked as ETL Tester responsible for the requirements / ETL Analysis, ETL Testing.
• Extensively executed SQL queries in order to view successful transactions of data.
• Involved in all three centers (Claims Center, Policy Center and Billing Center) Integration and their Replication data load in Guidewire.
• Performed end-to-end test from Guidewire to Reporting Database.
• Determined testing requirements, developed and reviewed scripts for positive and negative test scenarios, conducted baseline testing, white box testing, black box testing and regression testing and generated reports. Tested server and Web Portal.
• Reviewed and tested several T-SQL Queries using Joins, Indexes, Stored Procedures, User Defined Functions and Views.
• Validated Historical data load from Legacy System into SQL Server 2008.
• Experience in Error and Event Handling using Precedence Constraints, Break Points, Check Points, and Logging using SSIS 2008.
• Involved in design and development of SSIS Packages for loading data to star and Snow Flake schema.
• Tested ad-hoc reports by creating Test script and inserting Test data using SSMS.
• Created various reports using SSRS such as Drill down Reports, Parameterized Reports, Linked Reports and Sub Reports apart from generating Ad-hoc Reports.
• Performed data validation testing of production defect using SQL and resolving and testing back end process.
• Participating actively in system, performance, regression and UAT testing for every new build released.
• Demonstrated an organized, systematic, disciplined and analytical approach to problem solving.
• Hands-on experienced with defect tracking tools like HP ALM.
• Extensively involved in UAT by supporting Testing and implement QA Process using Cognos Series 8.0.
• Proficiently worked in designing, reviewing and documenting system test plans, defining test Procedures and creating test cases on the basis of product releases features, client’s requirements and related technical documents
• Demonstrated sufficient oral and written communication skills for effective dialogue with Colleagues on a project team and superiors.
• Presented Daily Analysis Report to highlight bugs, issues and risks involved.

Environment: SQL Server 2008, Guidewire, Windows Enterprise Server 2003, IIS 7.0, Visual studio 2008, Performance point, Flat Files, Excel, Ms PowerPoint, Autosys, ASP.NET

Confidential, Hartford, CT

ETL QA Tester

Responsibilities:

• Reviewed and analyzed Business Requirements and clarified with Business Analyst.
• Written several UNIX scripts for invoking data reconciliation.
• Extensively used ETL methodology for supporting data extraction, transformations and loading processing, in a corporate-wide-ETL Solution using Informatica.
• Reviewed High Level and Lows level Design docs and clarified design solutions with Developers
• Worked as ETL Tester responsible for the requirements / ETL Analysis, ETL Testing.
• Developed the ETL and BI testing strategy
• Extensively executed SQL queries in order to view successful transactions of data
• TOAD is used to perform manual test in regular basis.
• UNIX and Oracle are using in this project to write Shell Scripts and SQL queries.
• Wrote SQL queries to validate source data versus data in the data warehouse
• Developed Test Strategy, Test plan, Test cases, and Test scripts and various other project documentation in Mercury Quality Center
• Familiar with CMMI, the Rational Unified Process (RUP) methodology within the Software Development Life Cycle (SDLC) along with Agile and Scrum.
• Promoted Unix/Informatica application releases from development to QA and to UAT environments
• Experienced in writing complex SQL queries for extracting data from multiple tables.
• Used TOAD Software for Querying ORACLE. And Used Teradata SQL Assistant for Querying Teradata
• Responsible for different Data mapping activities from Source systems to Teradata
• Involved in all walk throws for test designs, data designs and code reviews.
• Developed Test Plan, Test cases & Test Scenarios for new features.
• Used QTP for Checkpoints, Regular Expression and Accessed Data Tables for multiple applications.
• Updated existing Regression Test cases for impacted features due to new features.
• Tested the Application in UNIX Environment and collecting the Test data from the Business Team
• Identified the Test Environment for Database Testing.
• Prepared Test status reports for each stage and logged any unresolved issues into Issues log.
• Used T-SQL for Querying the SQL Server database for data validation.
• Writing the test scripts for manual testing.
• Involved in writing test scripts and functions in Test Script Language using QTP for automated testing.
• Loading the Data from the tables into the OLAP application and further aggregate to higher levels for analysis
• Quality Center updates and test cases loading and writing Test Plan and executing Test Cases and printing status report for the team meetings
• Testing (that includes unit, integrated, regression, and UAT) a new .NET application which uses Microsoft Visual Studio under the Scrum (Agile) Methodology.
• Reviewing the database Test cases and performs the Database Testing when writing the SQL queries.
• Executed the Stored procedure when passing the valid/Invalid Parameters.
• Involved in Data migration and Data distribution testing.
• Extensively used Informatica power center for extraction, transformation and loading process.
• Tested reports developed by Business Objects Universe for both Adhoc & Canned Reporting users of Business Objects XI R3
• Used the Agile methodology to build the different phases of Software development life cycle. (SDLC)
• Testing of Business Objects and Reports which Includes, Database Connectivity, Tested objects in the Universe to ensure the correct mapping of the objects.
• Tested the Universe Structure to ensure that tables are properly uploaded., Tested the aggregate Universe to ensure the query is pulling correct level of Aggregation
• Tested several reports developed using Business Objects.
• Scheduled the ETL jobs and ran jobs using Auto sys and automated the reports
• Analyze the results and log the defects in bug tracking tool
• Communicate with Db Developers and DBA

Environment: Mercury Quality Center 10.0, QTP 10.0,PVCS, SQL, PL/SQL, Informatica 8.6.1/8.1, EME, Oracle 10g, Teradata V2R6, Business Objects XIR3, TOAD, XML, XSD, PERL 5.12.1, XML Spy, Flat Files, Excel, Ms PowerPoint, Autosys, UNIX, IBM AIX 6.1, Shell Scripting

Confidential, Jersey City, NJ

ETL Tester

Responsibilities:

• Interacting with Business Analysts and Development teams to understand the business requirements and giving the estimates from testing prospectus
• Test plan preparation, preparing daily status reports and defect reports.
• Involved in prioritizing the requirements according to business needs and putting all the requirements in QC.
• Experienced in Property & Casualty Billing
• Extensively used Informatica power center for extraction, transformation and loading process.
• Extracted Data from Teradata using Informatica Power Center ETL and DTS Packages to the target
• Involved in writing and executing the test cases and involved in Defect reporting and verification.
• Involved in identifying the cause of Defect and reporting the same to developers.
• Diversified experiences in property and casualty insurance, brokerage, major city agency and not for profit organization.
• Validating the data between Oracle Tables and SQL Server Tables by using SQL Statements.
• Testing the data present in fact tables and dimensions tables.
• Wrote Use Cases, prepared use case diagrams (using Rational Rose & UML) and followed Agile at every stage of the processes
• Automated detailed test cases by using Quick Test Pro
• Reported bugs and tracked defects using Mercury Quality Center (Test Director)
• Involved in Data Validation, Data Conversion and Data Reconciliation Testing.
• Involved in HUT (Hard unit testing), SIT (System Integration Testing) and WIL (Week in Live Testing) Testing.
• Tested all the entities like customer records, payment records have been loaded target database according to its own table structure during the migration process.
• Tested database integrity referential integrity and constrains during the database migration testing process
• Attending defect triage meetings.
• Analyzed and created the bug tracking reporting and summary report in the Quality Center
• Testing (that includes integrated and regression) an application which uses Microsoft Visual Studio under the Scrum (Agile) Methodology.
• Leading provider of auto, property, and casualty insurance. Assignment involved Web-based online submission of insurance claims.
• Wrote PL/SQL /Complex SQL queries for system testing.
• Performed data quality test to determine whether processed data is correctly extracted, transformed and loaded. provides policy administration and technical services to commercial property/casualty insurers of all sizes
• Executed regression tests at each new build in QTP
• Tested data warehouse ETL process using SSIS (Integration Service).
• Extensively executed SQL queries in order to view successful transactions of data and for validating data.
• Extensively used Informatica tool to extract, transform and load the data from Oracle to DB2.
• Automated and scheduled the Informatica jobs using UNIX Shell Scripting.
• Written complex SQL queries for validating the data against different kinds of reports generated by Business Objects XIR2
• Tested the Business Objects Universe and validated Business Objects Reports using backend testing
• Responsible for reporting and escalating data issues arising from project or daily support.
• Involved in Defect prevention, productivity improvement and knowledge management activities
• Wrote complex SQL syntax using case, having, connect by etc

Environment: Oracle 10g, SQL, PL/SQL, Informatica 8.1, SSIS,SQL Server 2008/2005, SQL Navigator 5.0, Business Objects XIR2, Mercury Quality Center 9.2, QTP 9.2, DB2 8.x, IBM AIX 5.5, MVS, ISPF, VSAM Files, Flat Files, XML Files, Shell Scripting, PERL, XML, XSD, TOAD, WinSQL