SUMMARY

• Around 10+ years of Quality Assurance, Database (ETL & BI) experience in Manual Testing and Automated Testing using tools like Selenium, and Test Management tool ALM, Quality Center.
• Extensive experience in ETL Testing and Reports Testing.
• Extensive ETL testing experience using Ab - Initio, Informatica (Power Center/ Power Mart, DVO)
• Strong experience validating the data according to functionality of the applications.
• Working Experience with Agile Methodology, Water fall and Iterative Models.
• Experience in Defining Testing Methodologies; creating Test Plans and Test Cases, Verifying and Validating Application Software and Documentation based on standards for Software Development and effective QA implementation in all phases of Software Development Life Cycle (SDLC).
• Experience working with Data Warehousing, Data Validations, Data Scrubbing, Data Cleansing, Data Profiling and Data Frequency Analysis.
• Extensively used ETL methodology for supporting data extraction, transformations and loading processing, in a corporate-wide-ETL Solution using Informatica.
• Validated data consistency, data completeness, de-duping logics in data migration and data conversion projects. Experienced with development of automated and quick testing scenarios using TestComplete, HP Mercury tools QTP, win Runner, Load Runner.
• Experience in Performance testing tools like HP Load Runner.
• Experience in validating the ETL and PL/SQL batch jobs scheduled using Autosys.
• Experience in Dimensional Data Modeling using Star and Snow Flake Schema.
• Experience in BA, QA and software testing roles that includes requirements analysis, development of test plans, test strategy planning, creating test cases, and test case execution.
• Excellent working knowledge of software development life cycle (SDLC) and software testing life cycle (STLC) in requirements gathering, analysis, design, development, implementation and testing,
• Actively involved in business and system requirements document review and key resource for UAT phase and production roll-out.
• Good understanding of business intelligence concepts and concepts related to reporting tools such as SSRS, WebFOCUS and Tableau.
• Exposure in programming languages and script like Java, Gherkin, JavaScript, HTML, and Groovy.
• Automation experience using Selenium IDE/RC/ Web Driver and TestNG, Cucumber, JUnit TestComplete, Ready API,SoapUI, frameworks
• Good experience on DevOps tools such as Chef, Vagrant, Oracle Virtual Box, Jenkins, Maven, ANT, IBM uDeploy, CVS, SVN, GIT, Docker, Docker-compose, New Relic, Splunk.
• Used performance counters within Load Runner for monitoring windows resources, UNIX/Sun Solaris resources using Network monitors, Web Servers (Apache).
• Experience using Quality center, Rally, JIRA as test management tools.
• Tested WebServices /XML / SOAP and RESTFul services using SoapUI tool
• Experienced SQL Data Analyst / Data Reporting Analyst with strong background in design, development, and support of online databases and information products as well as data analysis / reporting / processing.
• Extensive experience in ETL process consisting of data transformation, sourcing, mapping, conversion and loading
• Proficient in Oracle, PL/SQL Development, Toad, DB2, SQL Server, PL/SQL Developer, SQL Navigator, Perl, UNIX.
• Ability to communicate effectively with customers to eliminate disruptive situations.
• Proven strength in problem solving, coordination and analysis.
• Strong experience in multi-tasking and meeting deadlines in time.
• Achievement oriented with excellent people management skills and an ability to manage change with ease.
• Strong communication, interpersonal, learning and organizing skills matched with the ability to manage stress, time and people effectively.

TECHNICAL SKILLS

Operating Systems: Windows 10/ 8/7/XP, UNIX (Linux, Sun Solaris, IBM AIX)

Testing Tools: Selenium, Soap UI, Load Runner, QTP, Webfocus, TestComplete

Test Management Tools: ALM, Quality Center, Rally, TFS, JIRA

Databases: Oracle 11g/10g/9i, Server 2008 R2/2005, DB2, BigData, Teradata

ETL Tools: Ab Initio,Informatica,SSRS

Reporting Tools: Tableau Desktop, Microstrategy 2019, SSIS, Cognos, Business Objects

Query Tools: Postgres, Toad, SQL Query Analyzer, SQL Plus, Teradata SQL Assistant

Scripting Languages: XML, VBScript, Java Script, HTML, Shell Scripting

Languages: SQL, PL/SQL, Siebel, Java

Packages: MS-Office, Visual Studio 2005

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, NC

Sr QA Test Automation Engineer

Responsibilities:

• Developed and maintained Test Plans, Test Cases and Test Scripts to ensure the development and delivery of software applications.
• Planned, managed, and executed tests in accordance with Test Strategy.
• Accomplished testing of Reporting System at various stages of Database Migration.
• Validated source and target Tables, Data Structures, Data, Count, duplicates, Lookups, joins, Mapping/ETL rules.
• Reviewed Test Cases and other testing artifacts created by other team members for completeness and accuracy.
• Developed and executed test strategies and plans for various testing types and levels.
• Participated in all phases of SDLC starting from Analysis to Delivery of the projects.
• Expertise in Developing Big data solutions using Data ingestion, Data Storage. Good experience in using Sqoop for traditional RDBMS data pulls.
• Worked in all cycles of STLC: Defect Tracing, Defect Raising, Fixing, Retesting, Closing, and Deferring.
• Conducted Manual/Functional testing such as: Smoke, Integration, Regression, End to End Testing.
• Coordinated testing efforts, responsible for test deliverables, status reporting to management, Issue Escalations.
• Performed Manual Tests according to Test Plan to identify system defects. This covered form object, resource, and deployment sections of the WebFocus Maintain application software. Both GUI and Back-endtests were executed.
• Created and executed TestComplete automated Test Scripts.
• Worked with deployment teams to understand current application deployment process and provided design for automated deployment solutions using DevOps tool sets uDeploy, Jenkins, TIBCO.
• Performed Volume, Performance, Load and Stress testing using Load Runner.
• Validated the ETL and PL/SQL batch jobs scheduled in Autosys.
• Performed GUI, Functional, and Performance Testing and also used QTP and Load Runner to automate the testing process.
• Used in lines style sheets and external style sheets (CSS) for both HTML pages and WebFOCUS Reports.
• Worked for multiple projects which use different set of tools at a time. Extensively used TestComplete, Name Mapping for Object repositories.
• Worked on BIGDATA Data Validation Testing using Green Plum for RRP and Confidential Projects
• Tested data in Staging area, Operational data store, Base Layer, and BI layer.
• Developed Test cases in a form of SQL query and stored procedures and triggers to verify logic for standard and Custom Reporting system.
• Managed the test cases, scripts and monitored the bug using Quality Center.
• Used JIRA for Test management and task management.
• Customized WebFOCUS Business Intelligent Dashboard (BID) by modifying the WORP files
• Worked in accordance to QA methodology, project schedule and time lines.
• Written Complex SQL scripts and analyzed them for effective Data validation and Data Integration purposes during ETL/Backend Testing.
• Tested the presentation layers of the application by cross browser behavior and browser logic to ensure positive experience for end user.
• Regeneration of old Load runner script written in the different protocol.
• Validated data moving from source to target using Informatica Data Validation Option.
• Used Data validation Option (DVO) for complete and effective data validation and testing
• Validated the initial and incremental loads.
• Created WebFOCUS reports from user specifications.
• Worked on application integration testing in SOA Architecture and validated the SOAP based web services.
• Validated several Microstrategy reports.
• Involved in Clinical Metric DataMart Source System (CMDM) based on WebFOCUS reports and metrics testing. Worked in Agile environment with product owners, developers and delivered the work in short Sprints. - actively involved in daily scrum, sprint review/retrospective meetings, backlog refinement meetings
• Participated in Story reviews, Daily agile scrum meeting, and retrospectives to discuss about the project.
• Validated the Microstrategy reports for data quality and lay out of the reports.
• Involved in onshore offshore coordination of projects.

Environment: Abnitio,Informatica Oracle 11g, Microstrategy 2019,SSIS, SSRS SQL, PL/SQL,Postgres, Soap UI Toad, SQL Server 2008 R2, Selenium, Java, Quality Center, Webfocus, TestComplete, Big data, Load Runner, UNIX, Shell Scripting, JIRA, Rational Requisite Pro, Clear Quest, Clear Case, Autosys

Confidential, Bloomington /Normal Illinois

QA Analyst / Data Analyst

Responsibilities:

• Prepared test strategies, test plans, test cases, test scripts for ETL and Report Testing.
• Validated the implementation of fact and dimension tables in Star Schema model based on requirements.
• Validated data requirements and elements used in XML transactions.
• Scripted various user scenarios and created Test Scripts to emulate the real user, using Load Runner's VuGen utility.
• Troubleshooted resolved and escalated data related issues and validated data to improve data quality.
• Validating data files from source to make sure correct data has been captured to be loaded to target tables.
• Validated Autosys batch jobs according to requirements.
• Responsible for automating these test cases into test scripts using WinRunner 8.2, QTP and LoadRunner.
• Designed and developed UNIX shell scripts.
• Developed complete automated features and regression test framework utilizing JQuery using TestComplete.
• Used Cognos Report studio, Analysis studio, Query studio for report validations.
• Designed and developed Big Data analytics platform for processing customer viewing preferences and social media comments using Java, Hadoop, Hive and Pig.
• Written SQLs to validate Ab Initio ETL graphs according to data mapping specifications.
• Used Quality Center to track and report system defects and bug fixes.
• Written modification requests for the bugs in the application and helped developers to track and resolve the problems.
• Used DD EXCEL DRIVER to read data from excel in order to implement Data driven approach for TestComplete Project.
• Created and scheduled Endurance, Load and Stress test Scenarios using Load Runner's Controller to test the application under all kinds of loads.
• Identifying the functional test cases for Regression Testing and automated these Test Scripts using QTP.
• Validated the migration of Cognos reports from 8.6 to Cognos 10.
• Validated the load process of ETL to make sure the target tables are populated according the data mapping provided that satisfies the transformation rules.
• Performed the file level, field level validations for loading of data into staging tables by Ab Initio graphs.
• Validated the archive process to purge the data that meet the defined business rules.
• Written complex SQL queries using Case Logic, Intersect, Minus, Sub Queries, Inline Views, and Union.
• Involved in validating the aggregate table based on the rollup process documented in the data mapping.
• Written several complex SQL queries for validating and verifying the data across different databases including Postgres and Oracle.
• Validated the business objects reports for data quality and the cosmetics.
• Prepared test plans/test schedules with inputs from Project manager and development team.

Environment: Oracle 10g, Ab Initio, SQL, PL/SQL, Quality Center, Big data, QTP, UNIX, SQL Server 2008,Postgres 10, Cognos 10, UNIX Shell Scripts, Autosys, XML, XML Spy, Business Objects XI, Doors, Rally, Clear Case, Clear Quest, Doors

Confidential, New York, NY

ETL QA Analyst / Data Analyst

Responsibilities:

• Prepared test strategies, test plans, test cases, test scripts for ETL and Report Testing.
• Validated the implementation of fact and dimension tables in Star Schema model based on requirements.
• Validated data requirements and elements used in XML transactions.
• Troubleshooted resolved and escalated data related issues and validated data to improve data quality.
• Validating data files from source to make sure correct data has been captured to be loaded to target tables.
• Validated Autosys batch jobs according to requirements.
• Designed and developed UNIX shell scripts.
• Used Cognos Report studio, Analysis studio, Query studio for report validations.
• Written SQLs to validate Ab Initio ETL graphs according to data mapping specifications.
• Used Quality Center to track and report system defects and bug fixes.
• Written modification requests for the bugs in the application and helped developers to track and resolve the problems.
• Written scripts using Load Runner to generate virtual users.
• Validated the migration of Cognos reports from 8.6 to Cognos 10.
• Validated the load process of ETL to make sure the target tables are populated according the data mapping provided that satisfies the transformation rules.
• Performed the file level, field level validations for loading of data into staging tables by Ab Initio graphs.
• Validated the archive process to purge the data that meet the defined business rules.
• Written complex SQL queries using Case Logic, Intersect, Minus, Sub Queries, Inline Views, and Union.
• Involved in validating the aggregate table based on the rollup process documented in the data mapping.
• Written several complex SQL queries for validating and verifying the data across different databases including SQL Server and Oracle.
• Validated the business objects reports for data quality and the cosmetics.
• Prepared test plans/test schedules with inputs from Project manager and development team.

Environment: Oracle 10g, Ab Initio, SQL, PL/SQL, Quality Center, QTP, UNIX, SQL Server 2008, Cognos 10, UNIX Shell Scripts, Autosys, XML, XML Spy, Business Objects XI, Load Runner, Doors, Rally, Clear Case, Clear Quest, Doors

Confidential

Web designer /Developer

Responsibilities:

• Conceptualizing creative ideas with clients.
• Testing and improving the design of the website.
• Establishing design guidelines, standards, and best practices.
• Maintaining the appearance of websites by enforcing content standards.
• Designing visual imagery for websites and ensuring that they are in line with branding for clients.
• Working with different content management systems.
• Communicating design ideas using user flows, process flows, site maps and wireframes.
• Incorporating functionalities and features into websites.
• Designing sample pages including colors and fonts.
• Preparing design plans and presenting the website structure.

Environment: PHP, Photoshop, CSS, HTML