SUMMARY:

• A IT professional having proven experience of Analysis, Design, Development and testing of 9+ years with a domain exposure of banking and finance.
• Strong experience in automation testing and PL\SQL development
• Strong experience on performing database testing on oracle database.
• Experience of working in TDD (Test Driven) and BDD (Business driven development) methodology.
• Experience on Oracle 10g and SQL server database Oracle PL/SQL Developer
• Experience in writing complexSQLqueries for extracting data from multiple tables.
• Involved in entire Software Development Life Cycle (SDLC) from business analysis to final deployment and testing.
• Experience in writing UNIX shell scripts in order to automate and schedule tasks.
• Experience in Creating and Maintaining Database objects like Tables, Indexes, Views, Synonyms, Object types and Collections.
• Experience with Views, Materialized views, Cursors (Implicit and Explicit), Ref Cursors, and External tables, table partitioning, Index partitioning and nested loops.
• Experienced in Database Administrative duties like Grants, Loads, and Backup/Recovery & Performance.
• Experience with XML packages, XML parsing and loading into oracle.
• Created and configured MQ Objects like Queue Managers, Remote Queues, Local Queues, and Queue Aliases.
• Extensive and Experience in Data Analysis and managing data warehouse and data marts.
• Strong technical expertise in UTL FILE, DBMS SQL, DBMS OUPUT, DBMS UTILITY, DBMS JOBS packages.
• Experience in performance tuning using Explain Plan and TKPROF Selenium Automation testing
• Experience of creating automation scripts in selenium web - driver integrated with cucumber.
• Good exposure to TSYS mainframe application.
• Experience on unit testing frameworks like JUnit and TestNG
• Experience on working in Agile Project development. (Scrum)
• Detailed knowledge of configuring selenium test scripts in Eclipse and Maven.
• Experience on Continuous Integration (CI) tools like Jenkins.
• Knowledge on Oracle databases and Teradata tool.
• Active participation in creation of automation proof of concepts for various projects.
• Active participation in creation of Test Strategy document, Test Plan and cross-block test plans.
• Gained experience in system integration on multiple platforms with domain experience on Investment Banking, Treasury and Credit Cards
• Proficient in handling testing team, client interactions and Offshore testing activities
• Exceptional ability to quickly master new concepts and capable of working in-group as well as independently with excellent communication skills.
• Experience in Test Case development and executing the same on business requirements and technical specifications and reporting to management.
• Possess sound knowledge of Testing Techniques, Types of Testing and Test Levels.
• Sound knowledge of test management and defect tracking tools like HP Quality center, TFS
• Ability to serve as consumer credit card QA Subject Matter Expert.

PROFESSIONAL EXPERIENCE:

Oracle Pl\SQL Developer

Confidential

Environment: Oracle 10g,PL/SQL, JOINS, Data Models, HTML,Web Services, SQL *Plus, Toad 9.7.2, Erwin 4.0, UNIX PowerScripts, SQL Loader.

Responsibilities:

• Monitored Indexes (XMLType: XMLIndex) and analyzed their status for performance tuning and query optimization.
• Designed/developed tables, views, materialized view, stored procedures, packages and functions.
• Used advanced Bulk techniques (FOR ALL, BULK COLLECT) to improve performance. Developed Installation scripts for all the deliverables.
• Parked data objects that were left from legacy system to new system for archiving purposes.
• Involved in performance tuning on SQL using AUTO TRACE, EXPLAIN PLAN, TKPROF utilities.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL*TRACE, TKPROF and AUTOTRACE.
• Created Oracle forms components such as object groups, property classes and visual attributes
• Created and manipulated stored procedures, functions, packages and triggers using TOAD. Wrote heavy stored procedures using dynamic SQL to populate data into temp tables from fact and dimensional tables for reporting purpose.
• Created PL/SQL scripts to extract the data from the operational database into simple flat text files using UTL FILE package.
• Created materialized views using different clauses like FAST, COMPLETE, FORCE, ON COMMIT.
• Experience in working with IMPLICIT CURSORS, EXPLICIT CURSORS, and REF CURSORS.
• Worked in unit testing the Stored Procedures and performance tuning the queries in order to obtain fine results.
• Worked extensively on web forms and data binding controls like Grid View, Data List and drop down boxes and Mapping page fields to the database fields.
• Created records, tables, collections (nested tables and arrays) for improving Query performance by reducing context switching.
• Supported unit testing, system testing and UAT testing.

Test Engineer(Automation and Database)

Confidential

Environment: Java, Mainframe

Responsibilities:

• Involved in Software Development Life Cycle(SDLC) methodologies such as AGILE and SCRUM.
• Analyzed Functional Requirements and Business Specification as a Testing perspective on early stages of SDLC.
• Created and executed manual Smoke, Functional, Regression, System, Integration, and Exploratory testing.
• WroteSQLqueries to validate source data versus data in the data warehouse including identification of duplicate records.
• Developed SQL queries to test Data Integrity.
• Extracted data from multiple tables using SQL for testing
• Responsible for creation, design, and execution of Test strategies, including writing Test plans, Test cases and Test scenarios.
• Developed test cases in JAVA with Selenium WebDriver by using Junit, TestNG Framework, and Page Object Model(POM) in Eclipse.
• Written BDD Test Cases by creating Feature File, Step Definition with the help of Cucumber Tool.
• Involved in design and implementation of Selenium Automation framework for Regression Test Suites.
• Developed test cases using Element Locaters, WebDriver methods with Java Programming Features and TestNG Annotations.
• Worked for setting up and running test cases through JENKINS pipeline for Continuous Integration.
• Prepared data-driven tests to validate API calls
• Identified, analyze, and document defects using JIRA defect tracking system.
• Worked with XML and JSON format for validating SOAP and REST based web service calls.
• Used GIT as code repository for managing code reviews.
• Responsibility includes Code Review and Peer to peer review for the project.
• Interaction with the offshore team regarding the testing activities.
• Developed automation test scripts both for Firefox and Chrome.
• Attend daily standup calls set up by the scrum master and update the offshore activity.
• Condition accounts on TSYS to meet the criteria for the automation set run.
• Prepare the Automation/UAT Test plan for the sprint.
• Configured Linux Box for efficient remote testing.
• Review the execution result every build and if there is failure assign the script back to developer and help them to fix that.
• Maintaining and update Project deliverables.
• Maintain Impact Matrix and update the End User with the daily project RAG sheet.

Testing Engineer

Confidential

Responsibilities:

• Manual testing role in agile methodology.
• Monitoring and configuring file transfer process in UAT environment.
• Conditioning accounts based on the project enhancement and partner request in TSYS.
• Daily coordination with partner to communicate project trend.
• Setting up goals to offshore based on sprints tasks and coordination.
• Monitoring control-M jobs and retrieving files from the linux server box.
• Setting up test accounts on TSYS for the complete cycle. (Originate and account, add a transaction, cycle an account, make a payment, add fraud transaction to an account, allow account to go delinquent)
• Verify Account and system setting to verify accuracy.
• Setting up and configuring various consumer card customer journeys.
• Payment
• Lost/Stolen
• Credit line increase
• Past Due
• Pricing/Fees
• Verifying files for the rewards earned and sent to the partners based on the request.
• Debugging file transfer issues in Linux environment and control-m batch job issues.
• Strong Debugging skills using database as a source to identify the reason for the failure of file transfer to the vendor.

Oracle PL\SQL devlopment

Confidential

Responsibilities:

• Created PL/SQL Packages, Procedures and Functions that suits business requirements for loading the data into the database tables.
• Created Dynamic SQL, Composite data types & Global Temporary Tables.
• Worked on Materialized Views and partitioning tables for performance reasons.
• Worked on packages, forms and reports using DBMS output, Forms debugger and Explain plan.
• Used SQL Loader to retrieve the data into the database tables from flat files and comma separated files (CSV).
• Created Tables, Constraints, Views, and Indexes in coordination with the application development team.
• Used PL/SQL Developer tool for faster application design and make the development environment flexible.
• Developed database objects including Indexes, views, sequences, packages, triggers, functions and procedures to troubleshoot any of the database problems.
• Prepared Test scenarios for various functionalities developed and assisted the testing team in creation of test scripts that are used in testing oracle stored procedures.
• Expertise in solving complex queries and improves the performance of application by performance tuning.
• Worked on requirement analysis for change requests and fixed the defects raised by the user community and other stakeholders.
• Experience in working with multi-tier environments.

Test Engineer

Confidential

Environment: Java, flex

Responsibilities:

• Participation in building the Selenium Web Driver Test scenarios supporting Continuous Integration Development.
• Suggested changes in Automation Framework to improve Development Velocity.
• Developed the reporting component.
• Prepare the UAT and Cross Block Test Plan
• Define the testing strategy for the sprint.
• Develop the Automation script for the sprint.
• Part of the review process so that a standard process is followed.
• Set up Jenkins Environment for testing
• Present the story to the business for the acceptance and approval
• Active participate in retrospective meeting
• Coordinate with the offshore people
• Overseeing smooth implementation of the application.
• Coordinating with team members for smooth progress of project work.
• Monitoring and ensuring customer delivery during the transition period.
• Ensuring adherence to quality norms throughout the development & implementation process.

Delivery Module lead

Confidential

Environment: and tools: Selenium, Page Object Model, Rally, Maven, Jenkins, Eclipse, SVN

Responsibilities:

• Used Behavior Driven Development (BDD) framework with Selenium for performing acceptance testing. Worked for creating Test Plans, Test Cases, Test Scripts and entire Testing process.
• Created feature file, scenario outlines by improvising Cucumber
• Performed SIT to Test different modules and component parts of the application to ensure that it functions properly
• Performed SIT, responsibilities of executing end - to-end testing for each module, components, and sub systems of the application.
• Involved in extensive DATA validation using SQL queries and back-end testing.
• Automation of test cases using Selenium Web driver, TestNG, Page object Model(POM)
• Used tools such as Selenium, SOAP UI.
• Design and document REST/HTTP, SOAP APIs, including JSON data formats and API versioning strategy.
• Writing simple to complex SQL queries for testing purpose.
• Performed REST API testing by Soap UI
• Used SOAP UI assertions and Groovy script for web service automation Testing.
• Excellent knowledge of Selenium tool (Selenium IDE, Selenium RC, or Selenium GRID)
• Performed white box testing using TestNG for class, method.
• Wrote scripts for automation testing for Mobile Native Apps.
• Generating the detailed reports of the Bugs, Test Execution summary reports.
• Conducted the team meetings for discussing the status and issues.
• Attended Weekly/Daily reports to clients based on the status of execution/defects.

Senior Enginner

Confidential

Environment: UFT /QTP-12, ALM, IE 6 or 8, Excel Macro, windows XP and 7,Attachment Extra, Reflection Workplace.

Responsibilities:

• Used Agile methodology (Scrum, Bug Scrub) to ensure the new features meet the customer requirements and acceptable quality assurance standards
• Participated in the Test Automation Planning.
• Estimated the automation development lifecycle
• Prepared and maintained the Daily productivity matrix, Review Tracker and related documents.
• Understanding the basic flow of the Application and performing the feasibility analysis.
• Efficiently created and presented the POC to the end user
• Analysis of the Regression test cases and Preparing the Analysis document
• Developed and reviewed the scripts developed by team members

Test Engineer

Confidential

Responsibilities:

• Tracing requirements, designing Test Cases and Bug reporting.
• Preparing various matrixes required for analysing progress of Testing and Quality of the product.
• Performing rigorous Functional and Performance Testing.
• Guiding team members technically as well as product knowledge wise.
• Testing the mainframe application provided by client based on functional specs made. Iteration testing is done for some modules depending on severity of failures.
• Maintaining Script for Updated client requirements.
• Overseeing smooth implementation of the application.
• Coordinating with team members for smooth progress of project work.
• Monitoring and ensuring customer delivery during the transition period.
• Ensuring adherence to quality norms throughout the development & implementation process.
• Understanding the product & client’s business requirements by constantly interfacing with the Client. ed as star of the quarter