SUMMARY

• Over 12 years of experience in Information Technology with extensive experience in software testing, Applications involved with e - Commerce, cloud computing, ETL process, API, SOA Architecture,e-Commerce, N-Tier Architecture.
• Strong experience in developing Test Plans using requirements and design documents while specifying Testing Overview, Approach, and Test Strategy for ETL.
• Experienced as 5 + years Test Lead for ETL, DWH and BI Dashboards with clear understanding of business processes for Healthcare, Pharma, financial, sales, retail, Insurance and Mobile Applications
• Experienced with on-primise to cloud computing in Azure environment for data validation and data completeness.
• Experience in ETL methodology for supporting Data Extraction, Transformations and Loading process in ETL Life cycle.
• Strong working noledge of Software Development Life Cycle (SDLC), QA Methodologies like agile and sprint processing methods which involved, .NET, Java and API architecture.
• Experienced as ETL & BI testing using informatica, datastage, OBIEE, SSRS using complex SQL
• Extensively worked as ETL tester almost 7 years involved in Data Completeness, Data Transformation & Data Quality for various data feeds coming from source.
• Worked with Program Managers, Requirement Analysts, Mappers, ETL Developers, and other testers to resolve issues with requirements/mapping transformations
• Proficient in SQL Programming for testing database integrity with oracle and sql server.
• Extensive working noledge in UNIX and Windows platforms.
• Experienced as a test coordinator dealing with onshore offshore model.
• Good communication skills, Team player and positive approach.

TECHNICAL SKILLS

Testing Tools: ALM Quality Center,JIRA, xRay, Selenium, cucumber

Operating Systems: Windows, UNIX.

Database: Teradata, AZURE, Oracle, SQL Server, Rapid SQL, BIGDATA, RxClaim, Netezza

App/Web Servers: Web logic, Web sphere Application server, JBoss, Java Web Server, IIS, Web services.

Web Technologies: NET, J2EE, C++, JSP, HTML, VBScript

Others: VISIO, XML Schema, SSIS, SOAPUI, TOAD, Informatica, OBIEE, ETL, BI Reports

PROFESSIONAL EXPERIENCE

Confidential, NY

ETL Test lead

Responsibilities:

• Test lead for MOTEAM qa team on shore and off shore model.
• Developed test strategy and test plans for Tier 1, Tier 2 and Tier 3 projects.
• Extensively used testing tools JIRA, X-Ray develop test scenarios and test cases in agile methodology.
• JIRA stories developed with Gherkin format for mapped requirements as part of RTM.
• Software testing methodologies with .Net, Java Applications for data validation.
• Day to Day participation in Sprint meetings, coordination with cross teams to resolute defect life cycle.
• Expertise in data validation in ETL life cycle using Informatica, API SOA Architecture for system testing using postman, Integration testing and End to end testing.
• Experienced in understanding Mapping documents, physical data model and high level design documents for ETL, API and BI Report Testing.
• Verifying and validating data with complex sql queries for ETL and BI reporting for PNL, WRT, incentive Applications.
• Execution and modification of QFAAS frame work automation scripts using selenium and cucumber test tools.

Environment: Terradata, SQL server, Informatica, TOAD, UNIX, DB2, JIRA. ALM, x-Ray, ETL, python, Postman, QFaas, Selinium, cucumber, NET, JAVA

Confidential, Chicago, IL

ETL Test lead

Responsibilities:

• Test lead for on primise and cloud computing DAP Modernization project involved with Data lake and EDW with Azure Synapse cloud computing.
• ABC Framework meta data testing involved with SQL server for data pipe line testing .Security layer validation for “SDP “Dashboard for Admin, power user, data steward and normal user roles
• Used some existing notebooks in migrating teh data from existing applications to Azure DW using Databricks.
• Analyzed Business requirements and existing software for High Level Design. Contributed in preparing System Requirement Specification (SRS) and Functional Design.
• Participated in migrating teh Data from SQL from scratch, and actively participated in Data migration validation from on premise to Azure Environment.
• Test scenarios and test cases developed in qtest tool for Data Lake, EDW and ABC Framework.
• Experienced in understanding mapping documents, physical data model and high level design documents for data migration projects involved with on primise to Azure Environment.
• Verifying and validating complex sql queries for Bluestar, claims and clinical which involves multiple tables with logical business process and transformations using Informatica.

Environment: Microsoft Azure, MS SQL Server, Data Lake, Informatica, EDW SSIS, SSRS, BIGData, UNIX TERRADATA, DB2, TALEND Server, JIRA, .NET.

Confidential

SR ETL Tester / Webservices

Responsibilities:

• Experienced as ETL tester for ABC Frame work project for APRIA Health care for AUDIT, BLOCK and Control validations
• Understand teh database development for this project with Mapping document, ER Diagrams, Report testing validation using SSRS.
• Web services testing using POSTMAN for Rest calls with WSDL for data validation
• Generating Source query for GL BU Distribution, GLBU staging, GL BU Accounting Journal, JDE GL Accounting, JDE GL CSV file.
• Mapping document verification for Cost Center Company, cost center Map and Cost center for workday project.
• Inbound and outbound file verification using rest webservices for data validation.
• Batch process validation for ABC frame work validation for journal header and Journal line
• Extracts file validation for teh CVS which are integrating with workday financial module

Environment: workday, SQL Server, JIRA, WINSCP, DB2, Mainframe, SSIS, SSRS, UNIX, JIRA.

Confidential, Chicago, IL

Test Lead ETL / DWH

Responsibilities:

• Experienced ETL and DWH on site coordinator involved in projects, codeset, provider CDC, member load, ECM load, clinical events and extracts validation.
• Developed test plans and teh test cases from source to target data base which involves sybase to sql server, SSIS as for ETL process
• Teh model involves devopp / Agile process two-week sprint model JIRA is teh toolused as story tracking and defect life cycle
• Experienced using complex sql queries for analysis and execution of teh test cases for incremental, full load and delta loading in member load and ECM load projects teh clients involved are BCBSGA, Anthem, BCBSNV, EMPIRE and AMERIGROUP.
• Test scenarios and test cases developed in ALM test management tool for data load, data cleaning, extract validation from source > staging > target
• Experienced in understanding ETL and DWH related complexprojects with conceptual, logical and Physical data model diagrams.
• Verifying and validating using complex sql queries for CODESET, providerCDC complex Health care ETL projects which involves multiple tables with logical business process and transformations.
• Extensively used Provider portal for DWH projects to generate teh extracts ACMP, GBD, GBD Letter validation by creating case open, case close for teh members reviewed by RS and MD.
• Involved extensively in NEXTGEN Architecture model from legacy systems to SQL server towards RabbitMQ for capturing teh events, validating complex transformations using SSIS and Report validation using SSRS.
• Experienced as a Test lead, Test coordinator and core member in ETL and DWH projects with positive thinking, as well as team player in ON shore off shore model.

Environment: SQL server, SSIS, DATA Stage, WINSCP, JIRA, Mango DB, DATA Services, ALM quality center, UNIX.

Confidential

Test Lead ETL

Responsibilities:

• Reviewed Back Office Server, Train Management Dispatcher System (TMDS), Mobile Device Manager (MDM) and I-ETMS requirements as well as related systems’ Interface Control Documents (ICD) used to implement Positive Train Control (PTC).
• Developed test plans and teh test cases for teh BackOffice applications in HP-ALM.
• Performed (Sanity, Regression, End to End) tests to validate teh BackOffice applications integrating with teh BOS instance and created evidence with screen shots for each test case and ran them in ALM.
• Extensively used SQL queries for data validation and backend testing.
• Validating teh data files from source to make sure correct data TEMPhas been captured to be loaded to target tables.
• Preparation of Test Cases based on ETL Specification Document, Use Cases, Low Level Design document.
• Test lead responsibilities for onshore /Offshore model

Environment: TMDS, MDM, BOS, Field Simulator, Quality Center, Informatica, SQL, Putty, Share Point, Win SCP, Wireshark

Confidential

Test Lead ETL/ BI

Responsibilities:

• ETL coordinator for onsite off shore model involved in BI and Back end testing.
• Security layer validation for “SDP “Dashboard for Admin, power user, data steward and normal user roles
• Verification and validation of data for incremental loading from share point, NG8, SN5, SN6 and Pillar data sources.
• Addressing Defect status, reporting and resolution activities
• Expertise with Unix platform, scheduling jobs and execution
• Expertise on Structured and NON-Structured data which involves ETL lifecycle
• Developing Test strategy, test plan and test summary reports.

Environment: ANZO Server, SOAP UI, BIGDATA, SOA Ontology, UNIX, GitBash, ALM QC, JIRA, Netezza, Regulus, SQL server, SSRS, Oracle

Confidential, Chicago, IL

Test Lead ETL & web services

Responsibilities:

• Experienced as Test Lead and onsite coordinator in ETL and web services testing.
• Web services testing using SOAP UI with WSDL for ScriptSyncDigital,SPOM,MedDdigitization projects
• Data validation using oracle and sql server at source and target databases
• UNIX Logs, Data power logs verification for submitted request in ECS and ESL Architechture
• Extensively worked in PBM, Retail, Specialty Domains in web services testing, system testing and end to end testing.
• Verification and validations for digital, mobility, Ipad, Iphone, android and tablet specifications.

Environment: SOAPUI, Oracle, SQL server, Quality center, Test Utility, SOA Architecture, UNIX, RXClaim

Confidential

Sr ETL Tester

Responsibilities:

• Experienced as Test coordinator to develop test plan, test conditions, test cases, test data and coordinating with development team, Business team to resolve defect life cycle
• Scheduling meetings for daily status and test team coordination to meet teh time lines
• Understand teh database development for this project with Mapping document, ER Diagrams
• Web services testing using SOAP UI with WSDL for data validation
• Analyze Dealer extranet views and stored procedure design to create test conditions, test data
• UNIX job process execution to generate Flat files and control files for teh extracts involved
• Involved in file transfer and validation after executing UNIX shell scripting to extract teh files
• Informatica 9.5.1 used for work flow manager to run workflows and monitor log verification
• Informatica Log and bin files are analyzed for sql design query for extract file, transformation rules verification
• Sysadmiral used as scheduler for different jobs execution

Environment: Rapid SQL, Informatica 9.5.1, SOAP UI, SQL Server, Oracle, ODS, Jama, windows, Unix,SSRS

Confidential

Test lead ETL

Responsibilities:

• Test Plan and Test case for NexSure Invoicing 10.4 Project for Operations, Accounting and Reports.
• Test coordinating with business and development team, participating in Defect call meetings.
• Experienced as a test lead coordinating with team members regarding work distribution and test case review and execution
• Report test cases execution for canned and custom reports in SSRS environment.
• End to End testing in Nexsure Application for different workflows for carriers and Issuing companies.
• Data verification and validation by using data model and data mapping documents.
• Executed, passed and failed test cases in quality center ALM.

Environment: Nexsure, Salesforce CRM Insurance, Finance, Oracle, SSIS, SQL server, ETL, SOAPUI, Quality center

Confidential

Test Lead ETL/BI

Responsibilities:

• Test Plan and Test case for ICM project using technical design, functional design and mapping documents in ETL Environment.
• Test lead for Invoice number project coordinating with business and development team.
• ICM data extracts data validation in back end by executing complex SQL queries.
• UNIX job process execution to generate Flat files and control files for teh extracts involved.
• Logs verification in UNIX environment by using putty.
• Test cases generation for full cycle of ETL process from source tables, staging, target tables.
• Executed, passed and failed test cases in quality center.
• Reported teh bugs, Email notifications to teh developers using Quality Center.
• BI Report validation with OBIEE tool.

Environment: Discoverer, OBIEE, SQL server, SQL developer, Quality center, ETL, core FTP, UNIX.

Confidential, OAKBROOK, IL

SR Webservice tester & SQL Tester

Responsibilities:

• Verification and validation of teh data for digital credits project using data model diagram.
• Responsible for creating test cases, test scripts according to teh stories in Mingle tool.
• Experienced as test coordination to resolve teh defects.
• Hands on experience to create and execute teh complex SQL scripts for verification and validating teh data.
• Generating sql queries by using data model diagrams.

Environment: SQL SERVER, Oracle, SOAPUI, Rest, Mingle, Quality center.

Confidential

ETL /BI tester

Responsibilities:

• Test case generation for Ingenix tools in quality center.
• Developing test approach and test plan document.
• Conducting meetings as part of test coordinator.
• Developing teh test scenarios for claim processing business process.
• Prepare status summary reports with details of executed, passed and failed test cases.
• Reported teh bugs, Email notifications to teh developers using Quality Center.
• Performed system testing for monthly deployments.
• BI report validation with Ingenix heath care tool.
• Validating claim processing business scenarios on teh System.
• Made extensive use of MS Office tools to create and maintain documents such as test plans, test execution and test results documents.
• Data validation testing staging and target databases.
• Participated in requirement and review meetings for application software enhancements.
• Good communication skills to coordinate between testing and development team.

Environment: Quality center, SQL Server, Oracle, Ingenix, SSIS, ETL, UNIX, MSOffice.