SUMMARY

• Over 8 years of experience in Quality Assurance in Information Technology, involving analysis, both Manual and Automation testing of client server and web applications.
• 2+ years of hands - on testing experience in Azure Data Factory, Data Bricks using Python language.
• Strong knowledge of Software Development Life Cycle (SDLC - Feasibility Requirements Analysis, Design, Testing, Implementation, Support).
• Data mismatches & issues reported to Business Analyst as Defects
• Compared the data sets resulted from the databases Oracle andSQLServer using the tool,Toadfor Data Analysts.
• Experienced in interacting with Clients, Business Analysts, UAT Users and Developers
• Involved in Developing Test Plans and Developed Test Cases/Test Strategy with input from the assigned Business Analysts.
• Good experience in Alteryx platform, and involved in data preparation, data blending, and the creation of data models, data sets using Alteryx
• Responsible for designing, building, and testing workflows in Alteryx.
• As a QA Analyst - Worked on various industry verticals - Supply Chain, Financials, Telecommunications and Retail.
• Expert knowledge in creating Test Plans, Test Cases, Test Scenarios and Test Strategies, Defect Management to ensure Quality Assurance and to test all the business requirements.
• Experience in preparing test reports from Quality Center and prepared daily test status reports to communicate the test status with the team.
• Experience in using Automation Tool in Quick Test Professional (QTP) and Quality Center (QC) in Client/Server.
• Actively involved in User Acceptance Testing (UAT) and Training of the end users. Participated in cross-functional teams to reengineer and improve business processes.
• Extensive testing ETL experience using Informatica 8.1/7.1/6.2 (Power Center/ Power Mart) (Designer, Workflow Manager, Workflow Monitor and Server Manager).
• Excellent Knowledge of Database Systems - Oracle 10g, SQL server, DB2 and Data warehouse concepts.
• Extensive experience in developing SQL scripts to validate the databases tables and reports data for backend database testing.
• Proficient in troubleshooting database issues and experienced in using performance monitor/profiler to solve dead locks/ long running queries.
• Experience in RDBMS, Microsoft SQL Server (T-SQL), Oracle (PL/SQL), MS Access and associated SQL Programming Knowledge.
• Extensive Working experience in applying Relational Database Concepts, Entity Relation diagrams and Normalization concepts.
• Experience in Business Intelligence testing in various reports using Cognos, Business Objects, Crystal Reports and Crystal Dashboards Xcelsius).
• Experience in developing web-based applications using Python 3.4/2.7, Django 2.0/1.3, Java, Webapp2, Angular.js, HTML5/CSS3, JavaScript and jQuery.
• Used Ansible, Vagrant, and Dockers for managing the application environments.
• Worked on creating the Dockers containers and Dockers consoles for managing the application life.
• Developed and tested many features in an AGILE environment using Ruby on Rails, Java/JEE, jQuery, JIRA, Crucible, HTML5, Rspec, SAML, AWS, JRuby, SSO, Advanced JS (Node.js, Twitter Bootstrap).
• Extensive experience working in SaaS, IaaS, PaaS.
• Experience in troubleshooting old Perl, Shell CGI scripts.
• Experienced with data modeling of traditional RDBMS and NoSQL databases.
• Having good knowledge in using NoSQL databases like Apache Cassandra (1.2, 2.0 and 2.1) and MongoDB (2.6, 2.4), Orient DB.
• Proficient in Front end development experience using HTML, XML, CSS 5, JQuery, React, JSON and JavaScript, CSS 5, Bootstrap.
• Having experienced in Agile Methodologies, Scrum stories and sprints experience in a Python based environment, along with data analytics, data wrangling and Excel data extracts.

TECHNICAL SKILLS

Testing Tools: HP Quality Center 9.0/11.0 (ALM), QTP 9.0, Alteryx,Pentaho

Databases: Oracle 8i/9i/10g/11g, DB2 8.0/7.0, SQL Server 2005/2008, Teradata MS Access

Utility Tools: SQL Developer, TOAD and SQL Assistant

ETL Tools: Informatica 8.1, informatica10.4, Abinitio, and DataStage 7.0 and 8.0

Reporting Tools: Business Objects 3.1 and Cognos reports

Web services: SOAPUI

Operation Systems: Windows XP/2000/2007, Linux and UNIX

Microsoft Office: Word, PPT, Excel and Visio

Programming: PL/SQL, C, and C++

PROFESSIONAL EXPERIENCE

Confidential, Milwaukie WI

Sr. ETL Data warehouse Tester

Responsibilities:

• Thorough out the project in various iterations/Sprints - conducted system testing, integration testing, functional testing, and integration testing.
• Developed complex SQL queries for querying data against different data bases for data verification process.
• Handled Web Services testing using SoapUI tool in Python and created test data using XML.
• Experience in Agile Methodologies, Scrum stories and sprints experience in aPythonbased environment.
• Experience in using Microsoft Azure for Data and Analytics solutions ( Azure Data Lake, Azure Data Factory, Azure Data Lake Analytics/ USQL, Azure Stream Analytics, Azure Machine Learning, Azure Storage )
• Experience with Microsoft Azure ML and/or AWS ML
• Experience with cloud-based platforms, such as Azure
• Participated in KT meetings with Business Analysts and SMEs.
• Worked with Business analysts to understand requirements in order to transform business requirements into functional specifications.
• Created Test cases by taking input from Business Analysts and Technical Manager
• Designed and developed ETL workflows and datasets in Alteryx.
• Used Alteryx for Data Preparation and then Tableau for Visualization and Reporting. Processed data in Alteryx to create TDE for tableau reporting.
• Prepared the Test Plan and Testing Strategies for Data Warehousing Application
• Developed ETL test scripts based on technical specifications/Data design documents and Source to Target mappings.
• Extensively interacted with developers, business& management teams to understand the OPM project business requirements and ETL design document specifications.
• Participated in regular project status meetings and QA status meetings.
• Extensively used and developed SQL scripts/queries in backend testing of Databases.
• Written test cases to test the application in Quality Center 9.0 and 11.0(ALM)
• Defects identified in testing environment are communicated to the developers using Quality Center - Defects module.
• Prepared daily status reports with details of executed, passed, and failed test cases and defect status.
• Tested a number of complex ETL mappings, mapplets and reusable transformations for daily data loads.
• Creating test cases for ETL mappings and design documents for production support
• Scheduled, monitoring the jobs using Job Control System in Development/QA/Prod
• Extensively worked with flat files and excel sheet data sources. Wrote scripts to test the flat files data in the databases,
• Scheduled and automated jobs to be run in a batch process.
• Effectively communicate testing activities and findings in oral and written formats
• Worked with ETL groups and Acquisition team and business analyst for understating mappings for dimensions and facts.
• Extracted data from various sources like Oracle, flat files and DB2 server.
• Worked on issues with migration of Data from development to QA-Test Environment
• Extensively tested several Business Objects Reports - Crystal’s reports and Dashboards to validate the reports the data and cosmetics of the report.

Environment: Oracle 10g/11g, Alteryx, Pentaho, Informatica Power Center 8.1, informatica 10.4(Power Center Designer, workflow manager, workflow monitor), SAP Business Objects 3.1 - Crystal Reports and Dashboard, HP QC 9.0/11.0, SQL developer, TOAD, SQL and PL/SQL, Web Services.

Confidential, SAN ANTONIO, TX

Sr. ETL Data warehouse Tester

Responsibilities:

• Analyzed the business process workflows and mapping document indicating the source tables, columns, data types, transformations required, business rules to be applied, target tables, columns, and data types.
• Hands on with Python, with prior experience in handling ETL/ELT workload using Python Scripts
• Experience in Agile Methodologies, Scrum stories and sprints experience in aPythonbased environment.
• Build capabilities with existing software tools e.g., Microsoft Azure.
• Experience developing highly reliable, fault-tolerant distributed applications with focus on performance and scale in the Cloud (PaaS/SaaS - Azure, AWS, etc.)
• Utilized Alteryx to Prepare, blend and analyze all your data using a repeatable workflow.
• Alteryx workflows creation, Alteryx ETL, Data Science & Data Preparation
• Alteryx workflows & ETL Processes worked with Business analysts to understand High Level/System requirements in order to transform business requirements into functional specifications.
• Worked closely with Developers, Business Analysts, and Subject Matter experts to help facilitate the quick resolution of issues / defects found during testing.
• Reviewed Business Requirement Document (BRD) for accuracy and Completeness.
• Worked closely with Business user in Understanding designing and documenting the Functional testing plan and then Writing, executing, documenting the results and Logging Written ETL test specifications including test source data preparation, writing test cases to test Data Completeness, Data Transformations, Data quality, Performance and scalability, Data aggregations− match aggregated data against staging tables and/or ODS, and Granularity of data is as per specifications
• Created the use cases, activity diagrams and sequence diagrams.
• Created detail Test cases for each test phase to ensure complete coverage. Test Cases were incorporated both positive and negative test conditions.
• Maintained Traceability Matrix to track the requirements to the test cases to ensure complete test coverage.
• Involved in designing and Preparing Test Scenarios, Test Plans, Test Cases and Test Data.
• Worked with IT Development team to ensure feasibility of design and clarify user requirements.
• Developed SQL Queries/Scripts and similar Artifacts to validate the Completeness, Integrity and Accuracy of Data within an ETL process testing cycle.
• Performed Data Analysis and developed Data Mapping documents for ETL (SSIS) projects.
• Developed Test Cases and SQL Queries to perform various Validations.
• Performed Count Validation, Source Isolation, Dimensional Analysis, Statistical Analysis and Data Quality Validation in Data Migration.
• Performed Unit Testing, Integration Testing, User Acceptance Testing and Requirement Testing
• Executed Test Cases with respect to Source and Target database tables.
• Written SQL queries to validate reports against the database.
• Extensive SQL querying on Staging, Datawarehouse and Data Marts.
• Used Agile Test Methods to provide rapid feedback to the developers significantly helping them uncover important risks.
• Validated reports based on Functional Requirements.
• Analyzed various reports generated by SSRS.
• Checked the reports for any naming inconsistencies and to improve user readability.
• Used Mercury Quality Center for Bug Tracking, Reporting and Analysis.

Environment: MS SQL Server 2005, Alteryx, MS SQL Server Reporting Services 2005, MS SQL Server Integration Services 2005, Flat Files, informatica 10.4, DB2, TOAD 9.5, MS Office, XML, Windows Server 2003, Mercury Quality Center 9.2, Lotus Notes 7.0.3, Agile Scrum, Web services, HTML and JavaScript.

Confidential, Austin, TX

ETL TESTER/Data Analyst

Responsibilities:

• Worked closely with business users to gather requirements, define project specifications, develop implementation, and test plans for the projects & enhancements.
• Designed, created and tested reports to meet business requirements.
• Documented business workflows textually as well as in UML diagrams (State diagrams) according to RUP, for the stakeholder review.
• Business Views, Cascading pick-lists, Drill-through, Hyperlinks, sub-reports etc., functionality into these reports.
• Produced the visual models for the application to create use cases, state charts, sequence diagrams and activity diagrams.
• Created quarterly reports for each department in respect of their adherence to standard operating procedures and audit manuals.
• Worked with ETL group for understating mappings for dimensions and facts.
• Documented and maintained RTM to ensure that all requirements are traceable from top to bottom and to provide a basis for test plan.
• Performed Data Analysis, writing SQL Queries for Testing and Troubleshooting against Data Warehouse.
• Created data mapping documents mapping Logical Data Elements to Physical Data Elements and Source Data Elements to Destination Data Elements.
• Maintained documentation related to difficulties, complexities and anomalies that may arise during the ETL process.
• Ability to analyze root cause of a problem and demonstrate good sense when handing the problem over to development.

Environment: Informatica Power Center 9.5, SQL, PL/SQL, DB2, Oracle 11g, TOAD, Web services, TFS, API, Soap UI, XML, SharePoint, Quality Center ALM 11.0, Agile, OBIEE, Autosys, SQL Server 2012, UNIX

Confidential, Bowie, MD

Sr. SQL/ETL Tester

Responsibilities:

• Developed test plans based on test strategy. Created and executed test cases based on test strategy and test plans based on ETL mapping document
• Written complex SQL queries for querying data against different data bases for data verification process
• Designed the data flow diagrams using VISIO
• Prepared the Test Plan and Testing Strategies for Data Warehousing Application
• Preparation of technical specifications and Source to Target mappings
• Extensively used SQL programming in backend and front-end functions, procedures, packages to implement business rules and security
• Written test cases to test the application manually in Quality Center and automated using Quick Test Pro
• Defects identified in testing environment where communicated to the developers using defect tracking tool Mercury Test Director
• Developed scripts, utilities, simulators, data sets and other programmatic test tools as required executing test plans.
• Tested a number of complex ETL mappings, mapplets and reusable transformations for daily data loads
• Created test cases for ETL mappings and design documents for production support
• Setting up, monitoring, and using Job Control System in Development/QA/Prod
• Extensively worked with flat files and excel sheet data sources. Wrote scripts to convert excel to flat files.
• Scheduled and automated jobs to be run in a batch process
• Effectively communicate testing activities and findings in oral and written formats
• Worked with ETL group for understating mappings for dimensions and facts
• Extracted data from various sources like Oracle, flat files and SQL Server
• Worked on issues with migration from development to testing
• Extensively tested several Cognos reports for data quality, fonts, headers & cosmetic

Environment: Oracle, Informatica Power Center, informatica 10.4(Power Center Designer, workflow manager, workflow monitor), Alteryx, Pentaho,Mercury Test Director 7.0, SQL, Cognos 7.0 Series, Oracle8i,, TOAD, PL/SQL

Confidential

Sr. SQL/ETL Tester

Responsibilities:

• Developed test plans based on test strategy. Created and executed test cases based on test strategy and test plans based on ETL mapping document
• Wrote complex SQL queries for querying data against different data bases for data verification process
• Designed the data flow diagrams using VISIO
• Prepared the Test Plan and Testing Strategies for Data Warehousing Application
• Preparation of technical specifications and Source to Target mappings
• Extensively used SQL programming in backend and front-end functions, procedures, packages to implement business rules and security
• Written test cases to test the application manually in Quality Center and automated using Quick Test Pro
• Defects identified in testing environment where communicated to the developers using defect tracking tool Mercury Test Director
• Developed scripts, utilities, simulators, data sets and other programmatic test tools as required executing test plans.
• Tested a number of complex ETL mappings, mapplets and reusable transformations for daily data loads
• Created test cases for ETL mappings and design documents for production support.
• Setting up, monitoring, and using Job Control System in Development/QA/Prod
• Extensively worked with flat files and excel sheet data sources. Wrote scripts to convert excel to flat files
• Scheduling and automating jobs to be run in a batch process
• Effectively communicate testing activities and findings in oral and written formats
• Worked with ETL group for understating mappings for dimensions and facts
• Extracted data from various sources like Oracle, flat files and SQL Server
• Worked on issues with migration from development to testing
• Extensively tested several Cognos reports for data quality, fonts, headers & cosmetic.

Environment: Oracle, Informatica Power Center (Power Center Designer, workflow manager, workflow monitor), Mercury Test Director 7.0, SQL, Cognos 7.0 Series, Oracle8i,, TOAD, PL/SQL.