SUMMARY:

• Expert in Test Management Web/Mainframes/AS400/DW/ETL/Salesforce/Test data management/Data analysis and validation/Web services Testing
• 12 Years Record of Proven Results in Quality assurance
• Software Test Lead Specialist with full system development lifecycle experience, including designing, developing and implementing test strategy, Test plans, test cases, test data and test processes fueling swift corrective actions, significant cost savings and fault - free audits.
• Overall experience of 12 years in software testing Industry includes over 7 years of software QA lead and user-acceptance testing experience and over 5 years of onshore co-ordination experience.
• Ample experience in working at multi geographic locations and High profile customers in countries India, UK and USA.
• Backed by strong credentials including a Bachelor’s degree; ITIL Foundation V3 (2011) certification and ISTQB foundation certification; advanced command of various testing suites, agile and Waterfall methodologies; and cross-platform skills in Windows and Linux.
• Strong project & people management capabilities , analytical skills, evaluation and high degree of initiative. Manage, direct and co-ordinate of all aspects of project Estimation, Scoping, Planning, Scheduling tasks and milestones, Tracking & Monitoring.
• Able to generate simple and highly effective metrics, trends and dashboards to track the project progress efficiently.
• Demonstrated experience in Using Test and Defect management tools.
• Highly expertise in each stage of SDLC life cycles, STLC life cycle and Defect life cycles.
• Trained and implemented Data driven framework automation as the requirement demands.
• Proficient in defining QA process, Resource management, Document version controlling and Build release management and generation of reports.
• Effectively communicate different stake holders of the Project.
• Good at identifying potential risks, performing Gap analysis, Route cause analysis and creating QA templates.
• Sound Knowledge in Data migration, Data analysis and validation of Core and Retail banking applications, good hands on experience using R tool for data analysis and validation
• Expertise in testing of front end and backend applications, Interface testing and reports evaluation.
• Testing of Web services using Ready API tool Automotive applications.
• More than 4 years of combined experience in Test data management using Informatica ILM/TDM and client Test harness tools.
• Thorough knowledge in Validating the Business rules, Transformation mappings, job scheduling, email notifications, workflows, Job sequences, performance tuning techniques w.r.to DW/ETL testing.
• Organized QA meetings, Defect review meeting and participated in change management meetings.
• Involved in Online review and Desktop reviews.
• Have good knowledge in generating summary and closure reports.

Programing tool: Oracle SQL developer, SQL server management studio 2008, FROG

Toad and Rapid SQL: Beyond Compare and Notepad++

Applications: .Net

Java: Mainframes includes CICS, File aid, File Manager and JCL’s

SQL server 2008: Oracle 11g

DB2: DB400

Excel, Word and PowerPoint 2010/13: SharePoint

Visio 2010/13: Outlook 2010/13

VBA: XML

Java scripting: HTML

Methodologies: Agile with scrum

Waterfall: V- Model

RAD: W-Model

Browsers: Internet Explorer

Google Chrome: Mozilla Firefox

Safari: Netscape Navigator

Operating Systems: Windows XP/NT

OS : Windows 2007

Windows Vista/7: Redhat Linux

SKILLS SUMMARY:

• SQA Testing & Methodologies
• Effort estimate, Test Planning & Processes
• Functional and Non-Functional testing
• Imaging system and Letter generation testing
• Regression & Negative Testing
• UI & Compatibility Testing
• Data Interface & Migration Testing
• DW/ETL Testing and Mobile application testing
• Data integration and Data cleansing
• Test Automation
• Defect / Bug Tracking
• Test Strategies & approach
• Mainframes and AS400 legacy system Testing
• System and Integration testing.

PROFESSIONAL EXPERIENCE:

Confidential  

Customer

Responsibilities:

• Derived the test strategy and approach for Database migration activities
• Automating of test database migration and ETL activities using the Query Surge and beyond compare tools.
• Extensively using R programming tool (with Data table, XLConnect, SQLdf,RODBC, readr, dplyr,ggplot2 packages) for Data analysis and Validation
• Creation of functions using For and IF and Else conditions
• Filtering of data to plot histograms
• Analyze the data from visualization diagrams
• Extract sample number of records with specific criteria and perform analysis
• Extraction of source data using ProstgreSQL tool from Greenplum Data warehouse.
• Creating and using excel macros and MS access database solutions on daily basis for 100 % field data validation
• Validation of table summary, metadata specifications and mapping documents against the data migration development for accuracy
• Creation of test planning, requirements mapping, test cases and scripts, execution and defect logging through IBM Rational collaborative management tool
• Participating in the weekly status meetings to notify the current progress, highlight the issues and timely manner.

Confidential

Plano, TX

Software QA/Test lead Specialist

• Created and executed Project planning, effort estimation, software test plans, cases and scripts to uncover, identify and document software problems and their causes. Led QA testing that:
• Successfully integrated heterogeneous data sources and stored in Data warehousing for Business analysis.
• Thoroughly demonstrated the Transformation and Business rules with good number of sample test records to ensure data correctness and completeness is achieved.
• Improvised the quality of ETL and DW applications by applying the techniques such as
• Data Entity check/or Meta data testing
• Source to target validation testing
• Data integration, data cleansing, data completeness, data accuracy and Data Transformation testing.
• Applied slowly changing dimension techniques Based on customer specific requirements
• Verified the Transformation rules against Workflow mapping, Job scheduling, Error log and E-mail notification
• Assured that no data truncation is applied for any field during the load process.
• Pinpointed critical defect in Data migration project in the areas of slowly changing dimension approach.
• Performed Test data management activities Data sub setting, Data masking using Informatica ILM/TDM tool.
• Performed data validation using R programming tool for data transformation and data comparison
• Sized the Non production Test and Training Environments by applying TDM subsetting technique.
• Worked on oracle production DB Test data sub setting, by Importing metadata/data sources, Creating Entities, applying filter criteria for subsetting, creating plan, generation of workflows, execute and monitor the jobs for successful extraction of data.
• Created profiles by using the Entity/data domains and rules to identify the sensitive columns of the table from data source.
• Conducted Inplace and Instream data loading as required.
• Verified Source and Target databases after data sizing and masking to confirm accuracy of masked data.
• Masked the data by applying masking component rules, creating data domains, policies, assigning rules to table columns, creation of data dictionary flat files.
• Imported PPI,PHI and PCI policy packs to TDM tool to create rules.
• Used Substitution, Expression, Random, Date, Key masking techniques effectively.
• Utilized Notepad ++, and macros to mask the data as part of test data generation on enhancement projects.
• Effectively used Rally and Jenkins for Agile and continuous integration & deployments projects.
• Conducted the data integrity testing when more than one file formats are supplied as source.
• Improvised the quality of source file by ensuring Data cleansing and scrubbing techniques are applied correctly before extracting the data.
• Verified the layouts of staging library tables against the requirements to ensure Field label, File naming standards, data type, length and formats are taken care as required.
• Ensured the Naming standardization is followed rigorously as per the Design documentation.
• Verified the Data architect’s Physical and logical table’s in-line with the ETL Specification document.
• Validated the Interface between AS400 and DW tables using EOD jobs also between AS400 and standalone applications on daily basis.
• Worked on close to 50 AS400 enhancements to improvise the Iseries application
• Acting as an Admin for AS400/Iseries test environments to maintain the refresh status, data sensitiveness and granting access to various users on Test Environments.
• Successfully executed the projects in Waterfall mode by setting the definite Entry and Exit criteria’s.
• Effectively communicate with different stake holders includes SME/BSA, Development team, PMO, UAT users and Business.
• Mentored QA team members and monitored the progress during the course of project.
• Document lessons learnt at the end of each project and use it as reference to improve the quality deliverables of upcoming projects.
• Have sound Business Knowledge in Auto loan funding program right from loan origination, Loan servicing and collections, bankruptcy.
• Specialized in the area of Salesforce, Middleware, Thunderhead Integration, Credit Bureau reporting and automotive bankruptcy testing.
• Testing of Web services using Ready API tool by creating projects with Test Suites, Test cases and Test steps, Assertions.
• Tested .com applications and 3rd party RESTful API’s for XML and JSON formats.
• Validation of REST services using HTTP methods GET, PUT, POST and Delete methods
• Discussion with development team for API’s and ensure relevant data (Service end point, Resource end point, Required and Optional parameters) is collected for API testing
• Automation of API testing using Groovy scripting to test run continuity by defining context and TestRunner variables.
• Validation of web service results against the database and introduce Assertions for SQLS to verify the user scenarios.
• Implemented Test driven automation to deplete the regression effort and reuse the script where ever applicable.
• Effectively Utilized the HP ALM 11.0 and Quality center for logging the defects.
• Conducted formal and informal reviews throughout the software development lifecycle to provide input on functional requirements, product designs, schedules and potential issues. Leveraged developer background to communicate effectively with software design team, quickly gaining their respect and becoming a valued.
• Handled Service Now tickets in controlling the QA Environment access for various teams during the course of testing phase.

Confidential  

QA Tester

• QA Tester providing quality-assurance testing of software products in the area of Healthcare management systems.

Test Engineer

• Involved in overseeing quality-assurance testing of software products. Performed Black box, Functional, GUI, Integration Database testing.
• Provided status of Test scripts preparation and execution, identified bugs/flaws and recommended fixes.

Confidential 

Research manager software 

• Created company’s first Hospital management system product to go-live without any issues and generated sales revenue.
• Tested the application by mocking the real time data to replicate the production scenario to identify the possible issues.
• Documented software defects using bug tracking system and reported defects involving program functionality, output, online screen and content to software developers.
• Delivered thorough QA testing reports that determined product quality and release readiness.
• Regression test suit was identified to verify the enhancements with zero effort for test scripts preparation.