SUMMARY

• Self - motivated IT professional with over 10.5 years of experience in testing Data Warehouse ETL and Reporting tools with extensive noledge in ETL and OLAP processes. Extensive Experience in testing End-to-End Data Warehousing/ Business Intelligence solutions for Healthcare, Banking & Financial Projects, Mortgage.
• Experience in all phases of Testing Lifecycle (SDLC and STLC) with expertise in the Integration and Functional, Input domain, Load Testing, User Interface, Sanity testing, Regression and Re-testing.
• Extensive experience of working in a complex, multi-priority organization.
• Building test and data validation scripts to test the data migration
• Extensive Experience in testing ETL Tools (Informatica Power Center, Data stage).
• Proficient in Data warehouse system and the concepts.
• Having good experience in using Reporting tools (Hyperion Essbase, OBIEE, Cognos).
• Good exposure with databases like Oracle, SQL Server, and IBM DB2, MySQL, Hive,AWS Athena, Dynamo DB.
• Worked closely with business analysts, programmers, and end users in a cross functional team
• Experience in Preparation of Test Plans, Test Scenarios, Test Cases and Test Data from requirements and Use Cases
• Experience in testing Data Warehouse (ETL) and Business Intelligence (BI) applications.
• Experience in Dimensional Data Modeling using Star and Snowflake Schema
• Experience with testing ETL tools IBM Data stage and Informatica power center reporting tools as Business objects and IBM Cognos.
• Expertise in Designing and implementing software robotics and process automation.
• Proficient in Analyzing, documenting and reengineering business processes in scope for automation and robotics.
• Sound Experience in Designing and Implementing solutions around RPA software UI Path.
• Experience in maintaining Full and Incremental loads through ETL tools on different environments.
• Good experience in writing SQL/PLSQL scripts to validate data in migration project as part of backend testing and comparing data from Flat files to database for the feeds.
• Good exposure with databases like Oracle 10g, DB2, SQL Server 2005
• Good expertise in using TOAD, SQL*Plus and RapidSql.
• Worked with different data sources ranging from VSAM files, flat files, and DB2, oracle and SQL Server databases.
• Experience in debugging the issues by analyzing the SQL queries.
• Experience in copy and configuring the Mainframe JCL’S from Prod env to SIT env and run them to load data into DW.
• Extensive Experience in Functionality Testing, Integration Testing, GUI Testing, Regression Testing, Sanity Testing, Smoke Testing, System Testing and UAT of various applications.
• Experience of working extensively in Agile Testing Environment (Agile /scrum model) and good expertise in attending Scrum calls, Sprint Planning, Reviews and retrospective meetings.
• Experience in testing applications of Domain Banking & Financial Services, Health Care, Mortgage, Retail.
• Experience in Web Services-SOA architecture, REST Web Services, API testing using industry standard tools like Postman.
• Expertise in system level Integration testing.
• Expertise in automating test cases with Selenium WebDriver using Core Java and TestNG, Cucumber framework.
• Experience in Data Driven and Hybrid Frameworks using Selenium WebDriver with TestNG.
• Expertise inBDD test framework with Cucumber and Selenium WebDriver using Java.
• Experience in object-oriented programing using Core Java.
• Work experience in integrating Automation scripts (Selenium WebDriver API) on Continuous Integration tools like Jenkins for nightly batch run of the Script.
• Has good experience in using Maven as build management Tool.
• 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.
• Experience in preparing reports with analyzing the defects with respect to metrics.
• Experience in analyzing defect severity, priority and documentation and scheduling for the fix.
• Experience in release management and defect control management.
• Good experience in UNIX and Windows platform along with Unix Batch processingand Shell Scripting.

TECHNICAL SKILLS:

Automation,SCM Tools & Utilities: Selenium Web Driver, Cucumber, Jenkins, GitHub, RPA (Robotic Process Automation) UiPath.

ETL Tools: Informatica power center, IBM Data Stage

BI Reporting Tools: OBIEE, Cognos, Hyperion Essbase

Cloud Based Technologies: Sales Force CRM (Sales Cloud, Service Cloud, Marketing Cloud)

Scheduling Tools: Autosys

Scripting: Shell Scripting

Languages: Java, C, C++, Python, C#

Management Tools: HP ALM, JIRA

Cloud Computing Platform: AWS (Amazon Web Services) S3, Athena, Lambda, Step Functions,EMR

Databases: IBM DB2, MySQL, Oracle, SQL Server, Hive, Postgre SQL

Domain Knowledge: Banking & Financial Services, Health Care, Mortgage, Retail

PROFESSIONAL EXPERIENCE:

Confidential, Miami, Florida

Onshore ETL/DB Tester/ Automation Lead

Responsibilities:

• Participate in design sessions, understand the business requirements.
• Derive the Master Test plan, Test Strategy from business requirements.
• Develop complex SQL queries to validate the all the mapping between NCR and NCR RAW DB.
• Develop complex SQL queries column wise to validate the transformation logic between new TLOG DB (AWS) with Existing TLOG DB (My SQL), New ROD, TROD DB to old ROD, TROD DB and AWS Redshift.
• Create a data lake buckets in Amazon S3 to segregate the API files coming from different POS’s.
• Validation of Json files coming from different POS, Parse them and load into TLOG.
• Validation of restaurant data in Dynamo DB.
• Validation of initial and incremental loads.
• Implement End to EndRobotic Process Automation(RPA) usingUiPath.
• Connect to MySQL workbench using database activities and perform the execution and retrieve the data from table and write into data table
• UsedExcel automationfor repetitiveExcel data entry, appending and for comparing columns between old and new TLOG
• Compare the new data table with existing data table and make sure there are no discrepancies in the data
• Work with Client teams to ensure proper communications and team management.
• Scope and deliverable review with Client.
• Coordinate tasks allocated to offshore team and track it to completion.
• Maintain awareness of deliverable quality, mentor, guide resources on maintaining delivery quality
• Provide Guidance and direction to Offshore Automation Team.
• Create Weekly status report and review sow owner.
• Identify barriers and work with Confidential stakeholders to remove them. Escalate issues as needed.
• Propose best practices/services that can be implemented in Confidential .
• Provide LOE for all work and make sure LOE is met.

Environment: Robotic Process Automation (RPA) UiPath, Informatica power center 10.2, Amazon S3, MySQL workbench, SQL server Management Studio, Hive, Jira, Athena, Amazon Redshift, Lambda Services Glue, DynamoDBEMR, Spark.

Confidential, McLean, Virginia

ETL QA Technical Architect

Roles and Responsibilities:

• Understanding the Business/System requirement specification documents.
• Develop Test strategy, test plan/design, execute test cases and defect management for the ETL & BI systems.
• Implementing logical and physical data modeling with STAR schema using Erwin in Data Marts
• Develop and execute detailed ETL related functional, performance, integration and regression test cases, and documentation
• Analyze and understand the ETL workflows developed
• Quality Management - Knowledge of quality management methods, tools and techniques
• Create UNIX shell scripts to access and move data from production to development environment
• Communicate- and manage expectations of the senior management team and affected stakeholders during the planning and roll out of project release.
• Involved in writing the QA Test Results and Evaluation Reports.
• Maintenance of web methods instances.
• Configuration of web method console as per environment.
• Configuration of DB and UI details in web methods console to capture the changes from source and process them to downstream systems.
• Creation of Contract, Loan, Pool data in Selling UI using Selenium framework.
• Validation of Contract, Loan, Pool data in TDS, STGG, ODS databases.
• Process the events to EVNT and EVNT MSG tables.
• Set up the schedulers in web methods to pick up the data based on events.
• Invoke the Java services through automation in order to process the data downstream systems.
• Analysis of production issues and the solution walk through to the client.
• Design Strategy & Results Walk through to the Business teams.
• Maintained Traceability Matrix to track the requirements to the test cases to ensure complete test coverage
• Support of L3 tickets and integration/User Acceptance/E2E/S2S validation

Environment:Web Methods, Data Stage, Mainframe DB2, HP ALM, Star Schema, IBM DB2, Autosys, Informtica power center.

Confidential, McLean, Virginia

Sr. ETL QA Lead

Roles and Responsibility:

• Understanding the Business/System requirement specification documents.
• Identified the list of tables for Full testing with all the scenarios like Insert, Update, Delete, Data Quality.
• Identified the list of tables for Pre and Post testing.
• Prepared complex SQL queries as per ETL population driver to perform the data validation in lower environment.
• Validated the same queries in migrated environment to make sure the ETL population driver is populating as expected and there is no count mismatch between loaded tables.
• Performed full load and incremental load in lower and migrated environment to ensure the process is working as expected.
• Involved in DDL Deployment from Development to the SIT/UAT environments
• Validated the data quality reports to make sure there are no differences in values for Critical data elements.
• Performed Pre-Testing in lower environment and Post testing in the migrated environment.
• Perform data analytical testing for the BI systems
• Validation of data transformations and perform End-to-End data validation for ETL & BI systems
• Involved in BI report validation developed using Cognos/OBIEE/Hyperion
• Involved in Data Stage Code Migration from Development to the SIT/UAT environments.
• Analysis of production issues and the solution walk through to the client.
• Design Strategy & Results Walk through to the Business teams.
• Creation Job Information Language (Jil) to invoke data stage jobs.
• Creation of SAS program scripts to generate data quality reports.
• Support of L3 tickets and integration/User Acceptance/E2E/S2S validation.
• Coordinating with team at offsite and onsite.
• Conducting quality audits.
• Customizing Autosys scripts s to meet the customer business requirements.
• Actively participated in the data certification, recon and end-to- end testing with QA team.

Environment:IBM Data Stage, Autosys, Informatica Power center, Mainframe, IBM DB2, STAR Schema, HP ALM, UNIX.

Confidential

Sr. SFDC Tester

Roles and Responsibilities:

• Functional Validations on SFDC TPA portal with different profiles.
• Extensively created and tested on custom Workflows, Approval Process, Email Alerts, Field Updates, Profiles and Permission Sets
• Understanding and documenting business requirements and preparation of BRD, Use Case and Activity Diagrams for future state processes
• Validation of functionalities in SFDC Agreement layout and TLLA with different profiles.
• Docusign functionality Validation.
• Apttus licence upgrade testing.
• Email validations which are generated by SFDC system.
• Creating TPA portal Users across Global using SFDC Org.
• Provides different access privileges/Profiles to Users.
• Creates Real time Vendor’s in UAT and Prod Environment
• Loads the Confidential Data into UAT and PROD Environment for end users using data loader and work bench.
• Adding the fields to customized Objects in UAT and PROD Environment.
• Verified the data which is loaded into SFDC by Firing SQL query in workbench and data loader.
• Provides the solutions to functional queries to Business Users on daily basis.
• Interacting with the onsite coordinator on daily bases and updating the testing status and discussing issue encounter while testing.

Environment: SFDC CRM, Informatica Power Center, DocuSign, HP Quality Center, UNIX, OBIEE.

Confidential

ETL Test Consultant

Role and Responsibilities:

• Developed a testing strategy for all upcoming data feeds.
• Prepared traceability matrix for point’s requirements from the completed test cases.
• Extensively involved with backend testing by writing complex SQL queries.
• Involved with extraction routines to verify all the required data loaded into Grids (Destiny).
• Processed reject records for business rules for both dimensions and facts.
• Conducted walkthroughs with the customer, project management, development team, and Business Analyst.
• Working with Fact and Dimension tables and Surrogate keys and version numbers
• Assisted business users to execute UAT test scenarios and test data as part of JVT (Joint Validation Testing)
• Worked with informatica sessions and batches.
• PreparedHigh-Level End to End Use CasesandIndividual Use Casesfor each5010 transaction.
• Created the Use cases forERP implementationbusiness and functional requirements.
• Effectively learnt all modules and trained new resources.
• Preparation of test scenario’s and test cases based on Mapping documents
• Worked with DDL, DML and DCL commands for creating and updating data into database
• Validated the Summary and detail reports with drill down options
• Experience on Data validation, Data merging, Data cleansing and Data aggregation activities.
• Validating the data against staging tables and 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.
• Working with Clear Quest and Quality center for logging the defects, tracking the defects and resolving the defects
• Performed Interface and Integration (SIT) Testing
• Extensively use SQL queries for data validation and back end testing.
• Working with Database testing Involved in Data Migration Testing and preparing documents. Functionality, Interface, and Regression testing.
• Track Sheet Maintenance and map the use case to requirement.
• Monitor Testing Activities within the team and report regular progress to the Test Manager.

Environment: Informatica Power Center, SQL Server 2008, Hyperion, HP Quality Center, UNIX, OBIEE.

Confidential, JP Morgan Chase, Pune

ETL Analyst

Roles and Responsibilities:

• Understands the business functionality & Analysis of business requirements.
• Wrote test cases based on the consolidated requirement documents.
• Uploaded the test cases in test Plan part of HP QC (Quality Center).
• Executed all test cases using Data Stage Director and PL/SQL Editor.
• Extracted the source files from Unix Putty sever and load into the MQ by using Web View MQ tool.
• Verify all the records from the source has been thoroughly loaded into the target Data Base.
• Verify the total number of records in the source and the target using MQ tool and PL/SQL Editor.
• Generated the Cognos reports from the loaded data in version 7 and 8.
• Compared Cognos 7 report with Cognos 8 by using comparison tool.
• Logged the Defects in HP QC (Quality Center), retesting the defects.
• Actively participated in meetings and update the status to client on daily basis.

Environment: Data Stage 7.5.1, 8.0.1, Pl/Sql Editor, Mainframes, UNIX, and Web view MQ.

Confidential

ETL Developer

Roles and Responsibilities:

• Understands the business functionality & Analysis of business requirements.
• Wrote Test Cases for EDW - Data warehouse (Source to Target) and Cognos Standard Reports, OLAP and CUBE.
• Validated ETL DW load statistics and Datamart Loads on an Ongoing Basis
• Validated Source - Target mappings applying various transformation rules and Business Rules.
• Validated Data warehouse oracle tables.
• Executed manual testing for the prepared test cases, recorded the results and analyzed the results.
• Manually wrote SQL queries to check the integrity of data.
• Running queries against databases to verify the correctness of Business logic.
• Interacted with the onsite coordinator on daily bases and updating the testing status and discussing issue encounter while testing.

Environment: Data Stage 7.5.1, Oracle 9i, Test director.