SUMMARY:

• Technically sophisticated & business savvy IT professional with around 12 years of extensive experience in Agile,functional & ETL testing in BFSI domain.
• Seasoned, technically inclined & highly empowered Professional with around 12 plus years of excellence in delivering optimal results & business value in high - growth environments in IT Operations and Project Management in the IT industry of repute. A consummate professional with impressive experience in all areas of software testing, coupled with Functional, Agile methodologies and ETL testing. Possess experience in testing & verifying Business functionality, Database and Security Standards for different client/server applications in the areas of Finance, Retail Banking, Investment Banking, Loans, Insurance and Retail.
• An ardent IT professional with comprehensive experience in creating manual tests, quality assurance programs and web-based application testing for a variety of applications. Demonstrated competencies in web services testing using SOAPUI tool and exposure to xml testing. Commended with core strengths in writing SQL queries and testing PL/SQL procedures to extract data from various source tables. Involved in cross-browser testing, Log Analysis and Interim release testing
• International exposure of working at different client locations globally around the world, communicating with business, delivery heads, product owners on daily basis for any frequent changes in a project.
• Solution oriented professional with excellent skills in performing entire gamut of testing process including designing of test plans & test cases,executing automation scripts, using QTP(UFT), SQL queries,finding logs in Unix, running autosys jobs to execute ETL load. Deft in performing ad hoc, manual, and automated testing. Involved in running Autosys jobs. Thorough professional equipped with the knack of designing and building intelligent systems that can explore a wide range of integration testing scenarios and with the skills to handle project activities and ensure their completion within stipulated time and cost constraints and as per schedule.
• Consummate professionalwith proven expertise in conducting Joint Application Development (JAD) sessions for interacting with the stake holders, development teams and other cross-functional business unit members to help identify, analyze, and resolve issues.Extensive experience in coordinating the testing effort, responsible for testing deliverables, status reporting to the management, and issue escalations. Adroit in working on different Testing life cycle methodologies and adept in identifying, documenting and reporting potential improvements identified during testing. like V-Model, Agile Model
• Progressive, decisive & innovative, highly valued for expertise interpreting corporate vision and strategy, translating objectives into actionable plans, and providing decisive leadership to more than 30 multi-cultural & cross-functional team members. Skilled in blending technical expertise with strong interpersonal and analytical skills while interacting with business analysts, project management, application support team and all personnel associated with the engagement to enhance the overall reliability and performance of the software test infrastructure.
• Credited as a quick learner, resource person, problem solver, and team player with excellent ability to coordinate with different people at one time and to bring out the best in others while creating a healthy and friendly work environment, thus enhancing operational efficiency.

TECHNICAL SKILLS:

OS: Windows 98/2000/XP, Windows 7, MS DOS, Linux, WindowsTestingGUI, System Integration (SIT), Functional, Integration, Security Testing, Interface testing, Regression, Unit

Testing Tools: Mercury Test Director, HP Quality Center, HP Quick Test Professional, Rational Functional Tester, ALM, JIRA, UFT, UFT,Doors.

Databases: DB2, Oracle 9i/11g, MS SQL Server, MS-Access 5.0, TOAD,AQT,Bloomberg

Language: SQL, PL-SQL, VBScript, Core Java

Applications: AQT, Microsoft Office 2005/2007, MS Access (queries, forms, reports), MS Excel VBA, Informatica, Putty, Toad

Office Tools: MS- Word, Excel, PowerPoint, Visio, Adobe Acrobat

Other Tools: DFA and Codec Tool

PROFESSIONAL EXPERIENCE:

Test Lead

Confidential, Chicago, IL

Environment: MTM, MS Office, Citrix, TFS,Web,Oracle,Selenium,Java,TestNG,Wen Driver

Responsibilities:

• Expertise in designing and developing test strategy, test plan, test suites and generating test reports, defect reports and product quality assurance documentation.
• Expertise in Problem solving and Bug Reports using Defect Tracking tool MTM.Raised defects and assigned it to the team member for resolution.
• Conducted a complete assessment of teams, processes and environment; defined issues and risks; and oversaw the design and introduction of tools, processes and best practices across testing life cycle to improve throughput, communication and on-time delivery of projects in restricted time.
• Assigning and validating task performed by automation and manual team.
• Sending report to the client and other parties involved in the project on daily basis and attending daily status call with clients and other team members(vendors) associated with project Raise defect and assign it to team member for resolution.
• Working with the development team to create a suite of test data that fully exercises complete scenarios.
• Maintain and monitor the error log for all issues identified.
• Designed and executed the Automation Test Scripts using Selenium Web Driver and TestNG.
• Configured the Test Cases to receive input Test Data Sets for the corresponding test cases using TestNG Data Provider Annotation.
• Experience in locating elements on the webpage using attributes such as Id, Name, Class, ClassName, LinkText, Partial LinkText, XPath, CSS and DOM. Handled keyboard and Mouse Hover Actions, drag and drop, Context click using Selenium. Extensively used Selenium API’s such as Take Screenshot for Capturing failed test cases. Handling the certificate errors using profile for Firefox and Desired Capabilities for IE and Chrome.
• Involved in Web services testing using SOAP UI. Validated request and response XML.
• Verified the integration of various components in the application and executed end-to-end testing.
• Participated in Release Review/Requirement Analysis and Design review meetings.

Confidential

Sr QA Analyst

Environment: ALM, Oracle SQL Developer, MS Office, MCH(Mainframe based),XML, BloombergRTC(Rational Team Concert),SOAP UI, Java, Selenium,Test NG,Web Driver

Responsibilities:

• Served as Onsite-Offshore coordinator for a team of 8 members and overall responsible for end to end test activities such as analyzing,validating and testing software development projects.
• Primarily tasked with performing day to day scrum activities and estimating stories.
• Responsible for developing Test Scenarios, Test Metrics, Test Cases, Test Scripts, Test Data & Traceability Matrix.
• Personally responsible for developing complex SQL queries for data validation and updating as per requirements. And also providing requirement to automation team with test data and SQL queries.
• Scrum Board implementation in RTC.
• Shouldered the responsibility for developing and executing system test cases for agile methodology to ensure product meets functional and design specifications.
• Handle responsibilities of planning & retrospective meeting, communicating test progress, test results, and other relevant information to project stakeholders & management.
• Attended off-shore meetings and collaborated with off shore members in implementing and supporting automated testing processes and tools.
• Verified the integration of various components in the application and executed end-to-end testing.
• Participated in Release Review/Requirement Analysis and Design review meetings.
• Prepared project metrics and summary reports, defect tracking reports to report the entire status to the product owners and the stakeholders serving as a point of contact.
• Created various scripts for complex Corporate Actions like MCAL,PCAL, Tender.
• Actively involved in running jobs through Mainframe application (MCH) and Unix
• Exexcutedregression of application through TAFF.
• Responsible for performing functional testing for Finance application that includes booking trades in domestic and international trades. Performing backend process of Trading application & storing data for trades in Gold Copy application.

Confidential

Senior UAT Tester

Environment: ALM,TOAD, MS Office, Putty, Autosys, Informatica, Doors

Responsibilities:

• Responsible for developing Test Scenarios, Test metrics, Test Cases, Test Scripts, Test Data and Traceability Matrix. And also developing &executing system test cases for an agile methodology.
• High-level responsibilities included working on Requirement Management, Test Planning, Test execution and Defect Tracking using ALM for ETL Testing.Applied sharp analytical skills in providing demo to the customer.
• Accountability of creating complex SQL queries for data validation, performing SQL and PL/SQL queries to access and map data from the database and other sources.
• Validated data flow between various services using Soap UI, It helped in catching any error before actual impelementation of code.
• Held accountability for verifying the implemented ETL code against the corresponding mapping document and loading the data loads from source files to the target tables using Autosys jobs and running jobs using informatica.
• Finding cause for failure using session logs.
• Meticulously involved in running Autosys job in Putty and mapping validation for two different databases.
• Judiciously validated various reports and developed complex queries to validate data with the database.
• Accountable for analyzing and interpreting reports and graphs for the test cases generated through Quality Center.
• Actively involved in reporting bugs, bug isolation, verifying fixed bugs and issue resolution.Built and nurtured relations with Project Managers, business partners, developers to coordinate project schedules and timelines.

Confidential

Senior QA Analyst/Scrum Master

Environment: HP QC 11.5, Rapid Sql 8.1.1, MS Office, Putty, ETL Testing, Soap UI 3.6.1,Autosys,Data Stage, Star Track, Autosys, EEM, Windows, Netezza, Doors, Selenium

Responsibilities:

• Working with team of more than 10 members in the offshore -onsite model.
• Responsible for developing functional and Web services Test Scenarios, Test metrics, Test Cases, Test Scripts, Test Data & Traceability Matrix.
• Able to create data-driven tests using external sources
• Accountable for developing and executing system test cases for agile methodology to ensure product meets functional and design specifications. Skillfully created Test Plan based on requirements and involved in test strategy.
• Actively involved in estimating stories; providing demo to customer; performing scrum master activities; managing Retrospective meeting.
• Attended off-shore meetings and collaborated with off shore members in implementing and supporting automated testing processes and tools.
• Responsible for identifying Test cases for automation, creating Automation Test Plan and gettings approval.
• Used FireBug, FirePath to debug, edit and locate the objects based on ID, Name, XPath, CssSelector, Link, Partial Link, Attributes and Tags.
• Used Java language and TestNG framework for scripting.
• Performed Data driven testing using Selenium WebDriver, TestNG functions and JDBC Connections which reads data from scripts using property and XML files.
• Used different modules in ALM to report and track the defects, and communicated issues with the developers for a better solution.
• Contributed significantly in allocating & reviewing task and execution, conducting daily stand-up meetings and tracking team member performance.Gained knowledge of Loan Cycle and process of calculating sunset dates for loan maturity.
• Exposure on Requirement Management, Test Planning, Test execution and Defect Tracking using Quality Center for Database Testing.
• Duties involved creating SQL queries for data validation, performing SQL queries to access data from database and other sources.
• Excellent troubleshooting and problem-solving skills
• Fully accountable for verifying the implemented ETL code against the corresponding mapping document, loading the data loads from source files to the target tables using Autosys jobs on Unix platform.
• Significantly involved in conducting UAT testing; running Autosys job in Putty and analyzing logs to verify if the results are has expected; mapping validation for two different databases and finding critical defects.
• Successfully validated different kind of reports and written complex queries to validate data with database.Analyzed and interpreted reports and graphs for the test cases generated through Quality Center.
• Judiciously reported bugs, bug isolation, verify fixed bugs and issue resolution.
• Responsible for performing security testing of web based and mobile applications.
• Tasked with examining sample record sets for consistency, data corruption and over all data quality.

Confidential

Senior QA Tester

Environment: Quality Center 10, TFS, Toad, Oracle 9I/SQL Server, DB2,AQT,SOAP UI TOOL,MS Office, JAVA, Flex, Unix.

Responsibilities:

• Donned with the responsibility of gathering business requirements, supporting transaction processing for Retail Banking Application, performed Manual and Automation testing for Retail banking application testing that involves testing Online banking application activities like account opening, funds transfer, documents delivery for transaction etc.
• Oversaw all aspects of Manual and Automation testing for Investment banking application testing that involves creating standing settlement Instructions and Trade settlement at the front end etc.
• Recognized for testing Loan Applications such as Mortgage, Student checking and verifying e-documents delivery for different stages of Loan.Solely responsible for performing end to end testing process along with defect management cycle.
• Shouldered the responsibility for planning/estimation of all phases of testing activities and ensuring completion of all daily deliverable of the team.Participated in Bug-Review meetings with software developers, QA engineers and managers.
• Dexterously executed Ad hoc testing, Smoke testing, sanity testing, security testing, Interface testing, Regression Testing, UAT testing, Web services testing and also defect tracking.
• Responsible for designing and reviewing KT Document, developing Traceability matrix, Test Cases, Test Plan & Test Reports.
• Handled the tasks of Web Testing, Execution of Automation, Mainframe, ETL testing and alsoassisted in SOA testing.
• Accountable for Insurance banking application testing ER2; logging defects in QC, ALM and JIRA; Investment banking applications testing using MS Office Suite, Database and Automation tool QTP.
• Instrumental in performing project management activities, metric analysis and reports generation.
• Significantly coordinated with onsite team, BA and client and also allocating the task to team members.
• Proactively involved in mainframe testing on TSYS server to validate data; Oracle Financial application testing; testing on the remote system.
• Deft in writing complex SQL queries and testing stored procedures and performing Autosys job scheduling.
• Gained hands-on experience in security testing of web based and mobile applications.
• Exposure to security testing
• Proactively involved in supporting UAT testing during onsite hours.