SUMMARY:

• Expert in Project & Test Management Web/Mainframes/AS400/DW/ETL/Salesforce/Test data management/Data analysis and validation/Web services Testing/Test automation
• 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 13 years 10 months in software testing Industry includes over 7 years of software QA lead and user-acceptance testing experience and over 6 years of onshore co-ordination experience
• Ample experience in working at multi geographic locations and High-profile customers in countries India, UK and USA.
• 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
• More than 4 years of combined experience in Test data management using CA Test data manager and client Test harness tools
• Extensive experience in Data profiling, Data sub setting, Data masking and Data generation techniques from various files and Databases
• Provided Test data and support for Non-Production Environments QA, and Business team
• 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 Agile, V-model and Waterfall models, STLC life cycle and Defect life cycles
• 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
• 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.

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.

TECHNICAL SKILLS:

Tools: HP ALM 11.0/Quality Center/Test Director/Mantis/Bugzilla/Jira/Rational Test management QTP10.0, SOAP UI, REST and QA run, Rally, Query Surge and Jenkins Informatica 9.X and Informatica ILMR 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, AS400, Iseries navigator, Salesforce, Middleware, Thunderhead and Ameriview Imaging, Test Harness Applications

Database: SQL server 2008, Oracle 11g, DB2, DB400, Flat files and VSAM

Microsoft Applications: Excel, Word and PowerPoint 2010/13, SharePoint, Visio 2010/13, Outlook 2010/13, Project Planning(MPP) 2010/13

Scripting languages: 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 z/OS, Windows 2007, Windows Vista/7, Redhat Linux

PROFESSIONAL EXPERIENCE:

Confidential, Salt lake city, UT

Data migration test lead

Responsibilities:

• Customer is currently using old legacy core systems and vendors and products for the deposits and lending applications were nearing end of life.
• With growing complexity in using old system and benefits involved in migrating to Oracle database customer more favored toward Data migration.
• Core intention of this project is to migrate database from Mainframes to Oracle where lot of tables and data involved.
• My DM team is placed to ensure no business and data integrity is compromised as part of this migration activities.
• During the migration process validated the overall business and transformation rules are applied correctly for the completeness and correctness of the data.
• Derived the test strategy and approach for Database migration and test data management 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 PostgreSQL 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
• Performed Test data management activities by registering the connections for Source and Target databases (Oracle/Z/Os/CSV/flat files).
• Conducted Profiling for meta data, data structures and referential integrity.
• Performed test data engineering operations includes Data sub setting, Data masking and data synthesis
• Apply rules run time that are relevant to database
• Created a ODBC connection to Mainframes production environment to collect DB2 meta data and store in TDM repository
• Performed profiling and validation to understand the relationship between tables using GT diagrams, current state of data and to establish relationship between missing tables if required
• Discovery of PII and PCI sensitive table columns with the help of TDM tool and ensure they are accurate
• Worked with Internal data team to get approval on discovered PII and PCI columns to avoid later Issues
• Data sub setting using simple techniques (number of rows, percentage of data) or scenario based where it meets certain conditions
• Applied data masking techniques includes Substitution, Randomization, hashing, concatenation, sequencing, Date, Key and seed data masking techniques effectively and maintain in central repository
• Synthetic Data creation using Data painter tool or data cloning process to destination database for mass data generation
• 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.
• Maintained Audit report for each masking operation performed to compare before and after data
• 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 lead

Responsibilities:

• Serve as a Potential member of software development team as a lead QA tester on development projects for Automotive, Credit services and Hospital management industry clients.
• Supervise a 6 to 8-member software QA testing team in developing and implementing quality-assurance and quality-control methodologies to ensure compliance with QA standards, Legal compliance and customer specifications.

Confidential

Responsibilities:

• 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:
• 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 data validation using R programming tool for data transformation and data comparison
• 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.
• 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.
• 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.
• 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 to improve the quality deliverables of upcoming projects.
• Handled Service Now tickets in controlling the QA Environment access for various teams during the course of testing phase.
• Delivered a defect free automotive application for UK Customer ahead of the agreed timelines that pleased the customer in terms of ROI.
• Effectively used the Test Harness tool to create the miniature test data for Testing QA Environment to verify the Real time Business scenarios
• Passed all the phases of QA for Core banking front end application developed in .Net technology.
• Tested the legacy systems Vs DB2 and Conducted the data migration testing.
• To create reusable templates and identify time saving areas to implement macros.
• Successfully handled the projects in agile mode by conducted daily scrum meetings and by owning the sprints.
• Haven taken ownership of maintaining the burn down charts and monitored the progress.
• To implement the best practices of creating Job aids, documenting exhibits and maintaining Knowledge repository.
• Effectively communicate with different stake holders includes SME/BSA, Development team, PMO, UAT users and Business.
• Effectively Utilized the Test Director, JIRA, Bugzilla, Mantis and Track record for logging the defects.
• Effectively communicate Daily and Weekly status reports and chair the status calls.

Confidential

Sr Test advisor

Responsibilities:

• Have sound knowledge in online patient and physician online portal systems, online consultation, physician practice, Hospital and health management and al programs.
• Thoroughly involved in testing of web applications by applying industry standards, WCI compliances rules.
• Factored all the security standards in terms of User roles, access and privileges, Password protection, online payment systems set up and securing Patient and physician demographic information and disease information.
• Acted as team lead where ever required to ensure the smooth delivery of Project.
• Involved migration of backend database from SQL server as part of Upgrade.

Confidential

Test Engineer

Responsibilities:

• 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.
• 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.