SUMMARY

• SOFTWARE QUALITY ASSURANCE with full system development life cycle experience, including designing, developing and implementing Test strategy, Test plans, Test scenarios, Test cases, Test data and Test process fueling swift corrective actions, significant cost saving and fault free audits.
• Over 8 years of diversified experience in IT QUALITY ASSURANCE & BUSINESS ANALYSIS in domains like Banking and Financial services Applications, Insurance, Mortgages, Health care, Travel and Hospitality.
• Remote team management for onsite - offshore teams including mentoring, performance tracking and technical support and client co-ordination.
• High expertise in each stage of SDLC, STLC and Defect life cycle.
• Proficient in defining QA process, Resource management, Document version control and building release management and generation of reports.
• Knowledge of swift based format and other finance messaging standards
• Strong project & people management capabilities, analytical skills, evaluation and high degree of initiative. Manage, direct and co-ordination of all aspects of project estimation, scoping, planning, scheduling tasks and milestones, tracking & monitoring.
• Experience working in software development models like Agile scrum and waterfall.
• Co-ordinate in creation and execution of QA testing process, TEST plan, bug documentation, bug tracking and user requirement management and bug tracking tools like Quality center and Rational.
• Extensive experience in Interface Testing, Web services Testing, ETL Testing, Database Testing, User Acceptance Testing, System Testing, Integration Testing, Functional Testing, Mainframes Data verification Testing. Reports evaluation of Web based and client server application.
• Through Knowledge in validating business rules, mapping documents, Transforming mapping, job scheduling, email notification, workflows, job sequences, data dictionary documents, Business requirements for completeness and correctness.
• Proficient in defining the QA process, Resource management, document version controlling and build release management and generation of reports.
• Understanding of the physical data model for parent and child relationship tables, logical entity relationship between tables, user own data generation for new applications as required by business, compared source and target data schema, data tables using excel macros, MS visual studios 2016.
• Experienced in working in Agile Scrum, Agile XP, Waterfall, RUP, RAD and SDLC methodology environments
• Expertise in testing of front end and backend applications, Interface testing and report evaluation.
• Worked on web service testing using SOAP UI Tool.
• Good experience in testing both SOAP and REST services using SOAP UI, Postman, Rest Assured and tested both XML and JSON formats.
• Extensive experience in Test Management and Defect Management tools like IBM rational, HP QC(ALM), JIRA, TFS, BUGZILLA, defect tracking system.
• Participated in many production validations and expertise in working on testing/support provided on the client issue reported.
• Excellent knowledge of Database systems. Oracle, SQL server, Informatica, ETL and Data warehouse concepts.
• Extensive experience in developing SQL scripts to validate the databases tables and reports data for backend database testing.

TECHNICAL SKILLS

Software Methodologies: Agile, Waterfall

Testing Tools: R Tool, Ready API, SOAP UI, IBM Rational, Quality Center, JIRA, Pac 2000, Querry Surge. MS Access.

Programing languages: SQL, PL/SQL, DOT net, VB script, XML, HTML

Software packages: MS-Office, MS-Visio

Databases: Oracle 11g/10g/9i/8i/7.x, MS SQL Server 2008 R2, MS SQL Server 2005

Domain knowledge: Retail Banking, Mortgage, health care, securities, Retail and content Management.

PROFESSIONAL EXPERIENCE

Confidential, Salt Lake City UT

Data warehouse Tester

Responsibilities:

• Created Test strategy Test plans and Test scenario based on the user stories and enabler stories and reviewed it with the developers and Product owners.
• Performed, Functional, Integration, Regression, End to End testing and participated in User Acceptance Testing
• Actively participated in Sprint planning, User story refinement, Daily huddles, Sprint review and Retrospective meetings.
• Worked in an agile technology.
• Wrote Test cases in ALM and Defect report generation using ALM (Application Life cycle Management)
• Experience in working with data formats such as Xml, FixedLength, Delimeter, Swift, and EDI.
• Worked with batch jobs, monitoring and scheduling of jobs as part of the interface testing-validation of data flow between two systems as per predefined fields mapping sheet and mode of communication.
• Suggested the data formats on the front-end screen to ensure its compatibility with SWIFT format.
• Used SWIFT messaging system to test the flow of messages from and into the new system and was involved in ETL process.
• Created and Developed Reports and Graphs using ALM.
• Provided code coverage metrics to the team.
• Demoed sprint stories to product owner and the team for story acceptance..
• Strong understanding of Batch files and XML request/ Response validation
• SQL query writing to compare extract file / XML response data with Database
• Strong understanding of Core Banking Run calendar (End of Day, End of Quarter, End of Year etc.)
• To have frequent meetings with all stake holders for better clarity and understanding.
• Strong background in testing in an Agile/ SCRUM methodology

Confidential, Cleveland OH

Data warehouse Tester/ETL/BI Tester

Responsibilities:

• Involved in Design Review, Test Case Review meetings with business analysts and developers.
• Developed required SQL scripts for reports and extract generated EOD., by executing the SQL queries. Wrote SQL Queries to extract data from the Tables.
• Executed the Test Scripts on different releases and validated the actual results against the expected results.
• Involved in the complete SDLC- (System Development Life Cycle) from Requirement gathering to actual delivery of the Extracts which include all the loan origination and servicing data
• Designed and implemented complex SQL queries for QA testing and report/ data validation.
• Write SQL queries against the target Oracle database to generate reports and compare against legacy Access database reports.
• Worked in Agile technology with Scrum and waterfall models.
• Experienced in using Assure data standardizer tool to transform the data according to the pre-defined rules as part of the transformation process
• Provide support for technical integration and prod controls teams for execution of ETL mappings.
• Written Test Plan document, Test Cases, Reported Defects using HP ALM.
• Gathered requirements for sourcing and delivering the data and Interface requirements between various Partner Systems for Payments Processing for Corporate Banking purposes which involved detailed understanding of Payments and Processing Standards like IBANs, SWIFT, ACH etc.
• Defect tracking and Defect Report Generation are prepared using ALM and Quality Center
• Involved in manual and automated testing using informatica data validation option (DVO) and performed source and target table validation.
• Written several complex SQL queries for validating business object reports.
• Extensively tested business objects reports for static/cosmetic errors like header, footer, logos fonts etc. which may appear in all pages of the reports.
• Smoke testing for the new builds for QA acceptance.
• Responsible for defect management and driving to resolution and retesting the same.
• Wrote SQL queries to support the test case results.
• Performed negative testing using informatica to find how the workflow performs when it encounters invalid and unexpected values.
• Created SQL compare statements to validate actual results with the expected results.
• Tracked and executed the user Acceptance test cases (UAT) with respect to the requirements to determine the feature coverage.
• Estimated level of efforts (LOE) for testing efforts and reported to the test leads.
• Performed Quality Assurance activity for the data validation, data scrubbing and data profiling.
• Extensively used ETL methodology for testing and supporting data extraction, transformation and loading process in a corporate-wide-ETL solution using informatica DVO.
• Created test data for all ETL mapping rules to test the functionality according to the requirements.
• Used rational clear quest for defect management.
• Ensured quality products delivered and installed as specified in the statement of work (SOW).

Confidential, Reston VA

ETL/BI Tester

Responsibilities:

• Performance tuning by changing the existing cleanse functions, match rules etc.
• Work with subject matter experts, Finance & HR data analysts & other data modelers to create data modeling deliverables.
• Involved in gathering and reviewing Basel II DWH Stakeholders Scope and Business Requirements with Business and Dev teams.
• Experienced in data warehouse development works involving data migration, data conversion, ETL operations using Power Center 6.2/5.1
• Created the UAT Test Plan by entering high-level requirements from the Statement of Need and Functional documents, as well as identified test scenarios, into the UAT Test document.
• Ensuring the execution of UAT Test Cases and documentation of test results.
• Entered the defects into ALM and manages the resolution and documentation of these defects.
• Performed Development Integration, System Integration, End to End and User Acceptance Testing for the data services.
• Good in database testing by using SQL queries retrieved the data from database for data validation.
• Created Interface test cases, report test cases, expected results validation, defect tracking using clear quest, version control using Clear Case.
• Used SQL queries for organizing and abstracting data from MS access databases, created reports, forms on MS Access.
• Extracted Data using SSIS from DB2, XML, Oracle and flat files, Excel perform transformations and populate the data warehouse
• Performed happy path and unhappy path testing scenarios.
• Creating test case and test sets, tracing them to requirements and executing them in ALM.
• Analyze all Report Bugs for continuous process improvement and keep tracking on the SDLC critical path.
• Used SOAP UI to validate the response of web services with the data in Host.

Confidential, Auburn Hills MI

ETL/BI Tester

Responsibilities:

• Participated and involved in weekly project status meetings, team/management meetings, performed Internal Review, Tech Reviews.
• Responsible for Black box testing, GUI, System, Regression and User Acceptance Testing.
• Participated in meetings with Developers on Change requests, Critical issues, and modifications.
• Documented the bugs and worked with developers to eliminate the issues in the application, and track and report the issues in a timely manner within the deadlines.
• Responsible for analysing business requirements and business rules.
• Written Test Scenarios and the Test Cases as per the Requirement documents and High level design documents.
• Created, maintained and executed the test scripts.
• Identified the testing scenarios as per business needs of the application.
• Involved in the Back-end testing by writing and executing the SQL queries using Oracle DB.
• Identified the bugs in the application and reproduced them.