PROFESSIONAL SUMMARY:

• 16+ years of IT experience in Quality Assurance for ETL, Business Intelligence, Data Warehousing, Web based, Client/Server, Mobile applications using Manual and Automated testing tools.
• 12+ years of QA Lead Experience
• 2+ year of Software Development Experience in Informatica and Salesforce Integrations
• Experience in Sales force financial cloud services
• Led QA teams from 15 - 30 members in different Geographical locations like offshore/nearshore/onsite
• Define QA processes, tools and implement overall quality strategies to ensure quality product releases.
• Worked closely with Product Management and Engineering Dev Management to better communicate product enhancements to the team
• Encouraged collaboration and growth of individual QA team members to take ownership of features
• Facilitated moving the team move to new test case management tool from excel sheets
• Created a highly effective QA team with a 1 to 4 development ratio without sacrificing Quality.
• Participated in customers’ requirement identification and engineering design reviews. Led the development comprehensive test plans, test cases, reports and automation.
• Proficient in writing SQL queries to perform data driven tests and involved in front-end and back-end testing. Strong knowledge of RDBMS concepts. Developed SQL queries in Oracle databases to conduct DB testing.
• IT industry experience in Banking, Financial, Software Services and Telecommunication industries with strong Business and Functional knowledge and Ability to evaluate ETL/BI specification, verify it with systems and Experienced with Master Data Management (MDM)
• Familiar with Informatica Repository Manager, Designer, Workflow Manager, Workflow Monitor
• Comfortable in working with fixed length, delimited flat files and also worked with large volume of data in the database/data warehouse.
• Scheduling the jobs using Autosys GUI.
• Expertise in developing test cases/ test scripts for Inbound and Outbound ETL processes.
• Experience in testing/validating the Source, Stage and Target (End-to-End).
• Expert in analyzing the error caused to failure of the ETL load with to the log file and report them to the corresponding team to get it rectified.
• Strong knowledge of working with Data Marts (Star Schema and Snowflake Schema)
• Extensively worked on AWS Cloud applications like Athena, S3 Buckets, Redshift
• Extensively worked on Mobile testing with Perfecto Cloud
• Extensively worked on Selenium Automation with BDD and Junit
• Launched Perfecto cloud maintenance for different mobile devices and administration
• Worked extensively on INFORMATICA 8.1/8.5/8.6.1/9.6.1 /10.4.1
• Involved in providing production support to various ETL jobs and Database programs.
• Worked on Mobile Automation using Appium integrated with perfecto cloud
• Worked extensively on automating the ETL Test cases using DVO 9.1.4,9.5.0,9.6.0 and ICEDQ for reducing the regression effort of ETL Testing

PROFESSIONAL EXPERIENCE:

Confidential

QA Lead/Test Manager

Responsibilities:

• Joined as QA Lead and has been working with different QA engineer onsite, offshore and near shore
• Worked with Interns to bring fresh ideas to the team and cost effectiveness
• Implemented mobile cloud devices using Perfecto Cloud and managed to get the Mobile testing from offshore team
• Developed a process for resume and candidate validation that significantly increased the quality of candidates interviewed in offshore and onsite.
• Delivered 15 projects on time and under budget with very high quality
• Delivered prestigious Mobile application speed to market by encouraging QA team towards Agile Methodology and Mobile Automation
• Reduced defects found in production by 90%
• Dramatically increased offshore/Near Shore contractors’ utilization by process implementation, improved communications and
• Preventing occurrences of multiple runs by flagging processed dates
• Worked extensively with the SCD dimensions in order to maintain the historical data, identify the flags for exception and history load
• Analyzed test results, generate test reports, file bugs and follow up on resolution with development & support team.
• Used LSF to run the data load jobs
• Worked on Upgrading Informatica Migration from 8.6.1 to 10.4.0
• Created ETL test data for all ETL mapping rules to test the functionality of the Informatica
• Interaction with business and development to understand the business functionality
• Excellent experience in coordinating with offshore and onsite model.
• Written Test Cases for ETL to compare Source and Target database systems
• Identifying duplicate records in the staging area before data gets processed
• Extensively written test scripts for back-end validations
• Created ETL test data for all ETL mapping rules to test the functionality of Informatica mappings
• Written SQL scripts to test the mappings and tested Interactive Reports
• Worked on different Mobile applications with teams from different time zone in Agile Methodology
• Worked extensively with different cross groups to provide their data needs and streamlined the process in requesting data to the Informatica Rules Engine.
• Worked on High priority projects like Banker profile, Lantern, TMA, Horizon, ORR etc.
• Travelled to India for setting up the Mobile QA team in Pune
• Trained QA team on testing of different web services SOAP UI on multiple applications
• Management of Physical devices and setting up the different mobile devices for the Wells Fargo network to support device testing
• Worked on Automating the ETL processes using Informatica DVO 9.5
• Extensively worked on Databases like SQL Server 2008 to SQL Server 2016, Oracle, DB2
• Extensively worked on IBM Message Queue testing
• Worked on Automating the Mobile Applications and Web application using Selenium.
• Extensively creating personas for various Applications as per the user’s perspective and reduced lot of issues
• Involved in JAD session as an SME for the applications
• Involved in Writing test plan, test cases, traceability matrix and QA signoff. setup the automation frame work for tableau reports using selenium Java, BDD and Sikuli
• Created an performance test using selenium grid and leverage the same automation scripts to run on parallel execution with 50 multiple accounts and provided the performance results for team
• Worked on AWS cloud environment for the data validation
• Worked on RestAPI Automation for validation of the service call and the updates to backend tables around 6 API and 83 tables.
• Created a frame work on python to read data from 1500 xml file and generate a CSV file to compare the data against Athena tables
• Created a frame work using Selenium java for business users to compare the data from Tableau reports to the legacy system which reduced their manual effort and saved a cost of 3500 hours
• Worked on different tool like Athena, hive, S3 Buckets, Redshift, Impala on the AWS Cloud and Cloudera
• Worked on the Protegrity tool for testing of Tokenization and Detokenization of Data
• Working on Agile methodology and having experience in working with scrum of scrums
• Working on with Onshore and Offshore model
• Using qTest for managing the test cases
• Using Bitbucket for code repository

Environment: SQL Server 2008, ETL Tools Informatica 9.6.1, DVO 9.5,TOAD, ALM, Oracle, Perfecto Mobile, Responsive Web Design, Web services, SOAP UI, Big Data Hadoop, ICEDQ, Jira, qtest, Teradata, tableau, java sencha, selenium java, eclipse, maven, Bitbucket, AWS, IAM, ICEDQ

Confidential

Test Lead

Responsibilities:

• Supervising the QA team onshore/offshore accomplishing their tasks as per the deadlines.
• Working with offshore team to make sure they understand the complexity and business requirements of the application
• Involved in Product Design to understand the performance challenges in application.
• Analyzed the use cases given by the business analysts and developed test cases using them.
• Worked with the Business to coordinate the test case turnover process proceeding each cycle and selectively executed the test cases to verify that they are kept current
• Excellent experience in coordinating with offshore and onsite model.
• Developed Traceability Matrix of Business Requirements mapped to Test Scripts to ensure any Change Control in requirements leads to test case update
• Involved in metrics gathering, analysis and reporting to concerned team
• Conducted & Knowledge Transfer Sessions on new applications to QA Analysts
• Sending weekly reports to high level management regarding the status of test execution
• Providing the high-level QA estimates for funding by reviewing the Project Definition Document
• Reviewing the estimates provided by the QA engineers and submitting for approval
• Application was built on Agile (Scrum) methodology.
• Reviewed Test Strategy, test plans and test scenarios for the application.
• Define Device test strategy related to device testing for mobile applications
• Involved in research of industry trends with respect to new mobile devices and operating systems
• Prepared traceability Matrix
• Strong Hands-on Expertise in using tools like Perfecto Mobile for Android, IPhone, Black berry devices
• Performed Backend Testing using SQL to ensure the authentic retrieval of the data from the database
• Extensively used ALM to store and execute the UFT Scripts and for defect tracking.
• Worked on Responsive web applications across cross browsers and different Mobile devices

Environment: SQL Server 2008, Siebel 8.0, MAINFRAMES OS 390, Windows XP, ETL Tools Informatica 8.6, TOAD, Quality Center 10, OBIEE DAC, Cognos Reports.

Confidential

Test Lead

Responsibilities:

• Supervising the QA team onshore/offshore accomplishing their tasks as per the deadlines.
• Working with offshore team to make sure they understand the complexity and business requirements of the application
• Involved in Design and development of test plans based on high-level and detailed designs.
• Analyzed the use cases given by the business analysts and developed test cases using them.
• Worked with the Business to coordinate the test case turnover process proceeding each cycle and selectively executed the test cases to verify that they are kept current.
• Tested the ETL business logic for different feeds and checking the log files for data counts.
• Worked with Quality Center for executing test cases and reporting defects
• Analyzed test results, generate test reports, file bugs and follow up on resolution with development & support team.
• Data Integration testing for products, Data and Customer master data management (MDM)
• Used Informatica workflows to run the data load jobs
• Monitored the workflows using Informatica workflow monitor and performed end to end testing of Informatica data load jobs.
• Tested Informatica mapping with respect to mapping document and tailed the log files
• Performed black box/functional testing, regression testing on Application Under Test
• Performed manual testing on various modules of the ETL applications
• Generates functional test cases that capture actual code behavior as a deployed application is exercised.
• Proven capability in testing List Reports, Cross Tabs, Master/Detail, Charts and user defined reports
• Ability to test multi-prompt reports with drill-thru capabilities and conditional layouts
• Experience in writing easy steps to reproduce issues and report them to Bug tracking tool with full information including logs
• Involved in UI Application testing

Environment: SSIS, SSRS, SSAS, Informatica, UNIX, SQL, .NET, ASP.NET Windows XP, SQL Server 2008, ETL Tools, TOAD, Remedy, VSTF 2008.

Confidential

Sr QA Tester

Responsibilities:

• Analyzed business requirements, system requirements, data mapping requirement specifications, and responsible for documenting functional requirements and supplementary requirements in Visual Studio 2010
• Created test data for testing specific functionality
• Promoted SQL Server 2008 application releases from development to QA and to UAT environments as required
• Extracted certain column of data from a number to files using SQL Scripts
• Used DBSincera for automating all the types of modules at a time
• Involved in entire QA Life Cycle, which includes Designing, Developing, and Documentation of Test Plans, Test Cases and manage them using VSTF 2010 and providing them for Project team review
• Extraction of test data from tables and loading of data into SQL tables
• Written several complex SQL queries for validating MSRA Reports
• Responsible for Data mapping testing by writing complex SQL Queries using SQL Server Management Studio
• Involved in execution of unit testing, functionality testing, smoke testing, Regression and UAT testing
• Validating the data passed to downstream systems
• Worked with data validation, constraints, source to target row counts
• Performed Smoke testing on the new builds as a part of Build Acceptance Testing
• Strong in writing SQL queries and makes table queries to profile and analyze the data in MS Access
• Worked with Data Extraction, Transformation and Loading (ETL)
• Experience in writing easy steps to reproduce issues and report them to Bug tracking tool with full information including logs.
• Involved in testing the UI applications
• Worked with business team to test the reports developed in MSRA
• Used Microsoft excel and Word 2003 to document the test status reports and the Test Data
• Used VSTF 2010 to track and report system defects

Environment: SQL Server 2008, Windows 2008, .Net, Visual Studio Team Server 2010, SSIS,SSAS,SSRS, T-SQL, SQL, Microsoft Visio 2007, MS Access, Flat Files, Dbsincera, Onyx, Octopus, Metal, MSRA Reports.

Confidential

Sr QA Tester

Responsibilities:

• Designed & Created Test Cases based on the Business requirements (Also referred Source to Target Detailed mapping document & Transformation rules document).
• Participate in Requirement Development, Automation test script code reviews, MIS configuration and change control, and Go/No-Go decisions.
• Created and configured the GUI maps for the standard and custom objects.
• Tested ETL jobs developed in Informatica environment and Worked with work flow monitor for monitoring the job status.
• Involved in extensive DATA validation using SQL queries and back-end testing
• Used SQL for Querying the database in UNIX environment
• Tested SCD Type II and history tables.
• Scheduling the jobs for transferring the data from OLTP system to OLAP using Autosys GUI.
• Worked extensively in scheduling the Autosys jobs.
• Developed separate test cases for ETL process (Inbound & Outbound) and reporting
• Involved with Design and Development team to implement the requirements.
• Developed and Performed execution of Test Scripts manually to verify the expected results
• Design and development of ETL processes using Informatica ETL tool for dimension and fact file creation
• Involved in Manual and Automated testing using QTP and Quality Center.
• Conducted Black Box - Functional, Regression and Data Driven. White box - Unit and Integration Testing (positive and negative scenarios).
• Defects tracking, review, analyze and compare results using Quality Center.
• Tested several complex reports generated by Congo’s including summary reports, Master detailed, Drill Down reports.
• Defined the Scope for System and Integration Testing
• Identifying field and data defects with required information in Abinitio ETL process in various jobs and one to one mapping.
• Involved in collecting Business Intelligence reporting data from managers, staff across divisions and across geographies
• Worked Extensively with SSIS to import, export and transform the data between the linked servers
• Written Several SQL Queries for validating Congo’s Reports.
• Worked and coordinated with business people in testing Reports.
• Document and publish test results, troubleshoot and escalate issues
• Preparation of various test documents for ETL process in Quality Center.
• Involved in Test Scheduling and milestones with the dependencies
• Identify, assess and intimate potential risks associated to testing scope, quality of the product and schedule
• Identified & presented effort estimations related to testing efforts to Project Management Team
• Responsible for identifying and defining the Key Performance Indicators in Fact tables.
• Responsible to understand and train others on the enhancements or new features developed
• Conduct load testing and provide input into capacity planning efforts.
• Provide support to client with assessing how many virtual user licenses would be needed for performance testing, specifically load testing using Load Runner
• Create and execute test scripts, cases, and scenarios that will determine optimal system performance according to specifications.
• Modified the automated scripts from time to time to accommodate the changes/upgrades in the application interface.
• Sending package install requests for new builds and verifying proper packages are installed.
• Tested the database to check field size validation, check constraints, stored procedures and cross verifying the field size defined within the application with metadata.

Environment: SQL,, T-SQL, Cognos, XML, VSAM Files, SQL Server 2005, Quality Center 9.0, Oracle 10g, Java, Unix AIX 5.2,Autosys,data stage.

Confidential

BI Test Analyst

Responsibilities:

• Involved in Design and development of test plans based on high-level and detailed designs.
• Analyzed the use cases given by the business analysts and developed test cases using them.
• Worked with the team lead to coordinate the test case turnover process proceeding each cycle and selectively executed the test cases to verify that they are kept current.
• Tested the ETL business logic for different feeds and checking the log files for data counts.
• Worked with Quality Center for executing test cases and reporting defects
• Analyzed test results, generate test reports, file bugs and follow up on resolution with development & support team.
• Data Integration testing for products, Data and Customer master data management (MDM)
• Used Informatica PowerCenter work flow manager to run the data load jobs
• Monitored the workflows using Informatica workflow monitor and performed end to end testing of Informatica data load jobs.
• Tested Informatica mapping with respect to mapping document and tailed the log files
• Performed black box/functional testing, regression testing on Application Under Test
• Performed manual testing on various modules of the ETL applications
• Generates functional test cases that capture actual code behavior as a deployed application is exercised
• Did extensive backend testing using SQL, UNIX and PL/SQL
• Written complex SQL queries for data validation and data verification.
• Executes the test suite to identify regressions and unexpected side effects
• Parameterizes test cases for use with varied, controlled test input values (runtime-generated, user-defined, or from data sources)
• Monitors test coverage and achieves high coverage using branch coverage analysis
• Tests individual methods, classes, or large, complex applications
• Tracks how test results and code quality change over time
• Conducted performance and load testing using Load Runner
• Analyzed, reported and kept track of defects using Test Director.
• Provided testing results and weekly status report to the QA lead, provided test summary report once project was fully completed.

Environment: Informatica 6.1, Windows NT, HTML, .NET, ASP.NET, MS-Office Tools, PERL, Shell Scripting, SQL, PL/SQL, XML, XSLT, IBM DB2, Manual Testing, Test Director, Load Runner, Oracle, Java, Servlets and Java Script

Confidential

Software Test Engineer

Responsibilities:

• Understanding of complex financial business requirements
• Writing test plans and test scripts
• Maintained Progress Report of team members for update on individual work during test execution cycle.
• Performed testing in mainframe environment
• High Level Test Case Design and writing detailed test cases
• Involved in extensive DATA validation using SQL queries and back-end testing
• Reported periodic project status and updates to the QA Lead and QA Manager
• Heavily involved in interacting with UNIX Shell scripts.
• Analyzed Business Requirements and Developed the Test Plan, Test Scripts and Test Cases
• Exporting test cases to Test Director
• Preparation of Data Requirements
• Data Mapping (one-to-one mappings)
• Accessing mainframes and validating the data
• Identify & record defects with required information for issue to be reproduced by other teams.
• Worked with high-volume, real-time DB2 database applications and systems
• Conducted Bug Review meetings for update on defects from development team & retesting of bug fix. Worked with developers to fix faults found in the structure and functionality of the application.
• Experienced in coordinating resources within Onsite-Offshore model
• Conducted Sessions and Knowledge Transfer Sessions on new applications
• Managing testing documents in Test Director.

Environment: Windows, SQL, PL/SQL, Mainframes, MVS, COBOL II, VSAM Files, JCL, .Net, DB2, ASP.Net, Test Director