PROFESSIONAL SUMMARY:

• 10 years of experience in Functional, data warehouse and ETL testing, Automated QA testing (using Selenium WebDriver,Test NG) and project management.
• Lead a 10+ member testing team. Liaison to offshore team with a proven track record of project management, delivery, strong strategic vision and demonstrating ability to inspire/mentor/manage QA teams and its activities in the geographically dispersed companies.
• Responsible for both offshore and onsite resource management, budget, forecasting / capacity planning, assignment and tracking
• Provide testing estimates (and re - estimates) to the project management team at each appropriate phase of the testing
• Review all documentation including Business Requirement Documents (BRD), Design documents, Technical Designs (HLD & LLD)
• Participate in JAD session, HLD and LLD sessions
• Establish strategy for critical function and User Acceptance Testing (UAT). Perform critical function testing and facilitates the UAT planning and testing process with business users and IT service providers.
• Work as a liaison between developers, business analysts and user representatives in application design and document reviews.
• Responsible for project planning, test strategy, test plan, defined QE scope and estimates,identify scenarios, designing test cases, scheduling, reviewing, executing, monitoring test deliverables reporting status.
• Expertise in Manual Testing, Integration Testing, interface testing, System Testing, and ETL Testing, End to End Testing,Risk Based Testing,Business Application testing.
• Possess excellent verbal and written communication skills, Ability to interact professionally with a diverse group of executives, managers, and subject matter experts.
• Ensure that testing environments, applications and tools are available and ready for offshore testers
• Expertise in designing and developing test strategy, test plan, test cases and generating test reports, defect reports and product quality assurance documentation.
• Experience in implementing and reviewing SDLC phases covering Waterfall Model and Agile methodologies
• Identify testing risks upfront and track them to closure
• Experience testing applications built on SOA architecture, expertise with Boundary value analysis, Equivalence partitioning and Error guessing techniques, Smoke, Functional, Regression, Beta testing, Database and Integration testing.
• Provide status report on weekly basis
• publish test summary report at the end of testing
• Good knowledge of FIX, Swift and XML protocols
• Good understanding of Equity and Options Markets, experience working on projects pertaining to Mortgage banking, treasury management services,corporate banking and investment banking
• Experience with Order Management Systems or Electronic Trading Applications
• Experience in working with Multiple Relational Databases like Oracle 9i/8i/7.x, SQL Server 2000, MS Access, XML and Flat Files.
• Experience with testing Web-based, Client/Server and batch applications
• Expertise in writing and executing complex SQL queries to verify the databases
• Good understanding of Hadoop File system (HDFS) architecture
• Familiarity with Hadoop based commercial packages (e.g. Cloudera, Hortonworks)
• Good understanding of large data sets and distributed computing (Hive/Hadoop)

TECHNICAL SKILLS:

Software quality assurance:  Writing and executing test plans and test cases in highly structured and loosely structured development environments and performing all types of testing (functional, security, acceptance, browser compatibility, load, stress, volume)

Software Test Tools/Defect Management:  HP Quality Center 10,JIRA,Quick Test Professional 9.5, MS Excel, XML, Beyond Compare 3,PL/SQL Developer, Oracle SQL Developer, Autosys, SoapUI, DbFit (Fitnesse),TIBCO(Spotfire)

Platforms:  UNIX, Linux, Windows (95, 98, Me, NT, 2000, XP, 2003, Vista), MS-DOS

Programming languages:  SQL, UNIX/Linux, Shell Scripting, HTML, C, C++, Java

Database systems:  Oracle, SQL Server

PROFESSIONAL EXPERIENCE:

Confidential, Charlotte

QA Lead/ Subject Matter Expect

• Led test team for implementation of internet banking for WF wholesale technology business needs
• Was responsible for extensive coordination with Development, QA and Global Infrastructure teams.
• Conducted weekly project team meetings and provided periodic updates to senior management
• Created test plan and test cases prepared in QC ALM 11.0 and coordinating defect fixes online with business users and developers.
• Was responsible for updating Schedules based on deliverables and timelines, track critical paths and identify potential risks.
• Involved in preparing the test plan to test out various conditions the GAMS (Global Application Middleware Services) layer conversion (ETL) of GI (generic Interface) files to Interface files consumable by various downstream systems
• Prepared and performed extensive tests for the ETL framework in place to validate the applicable business transformations logics
• Hands-on with Database query tools for retrieving data and writing SQL queries played a key role for production support for ongoing Global Branch Expansion module
• Core Banking - Detailed domain knowledge of core banking systems and overall knowledge of Banking business technology
• Experience in Misys Loan IQ
• Good knowledge in the Investment Banking Industry, Project Finance, Mortgage Loan Origination,Loan Servicing, Treasury Services (ACH, Wire Transfers etc.), Brokerage Services, Commercial Banking, Retail Banking
• Managing various QA phases and performing hands on testing including Regression, Functionality and Pre Release testing of the Loan IQ products.
• Understanding of detailed business and functional requirements for Loan IQ reporting and internal feeds to downstream systems
• Validated OBIEE reports for applicable Flexcube modules
• Prepared Use Cases and assisted test plans and facilitated any analysis and coordinated test efforts for SIT & UAT teams
• Supported UAT testing by analyzing test requirements, helping prepare UAT test plan and communicated UAT testing results and feedback to the stakeholders
• Guided SIT and UAT team to perform required tests depending on the functional requirements discussed from various requirement discussions
• Functional expertise in various financial Flexcube modules like CASA (customer accounts & savings accounts), FT (funds transfer), MM (Money Markets), Customer Profile and Information Reporting.
• In-depth understanding of Book/ Funds Transfer, Money Market, Foreign Exchange Contracts/Trades in Flexcube Application/Oracle
• Responsible to understand and validate FX and MM deals using STP and Non-STP rules
• Involved in analyzing the FATCA requirements and then ensuring the validation of all the functional requirements for the compliance of all the applicable accounts with the IRS FATCA regulations.
• Involved in invalidation of all the generic interface files and their transformation to the successful corresponding interface partner files.
• Responsible to perform all QA activities for end to end and integration tests during different phases of testing - unit testing, system integration testing and user acceptance testing
• Worked on SOA - Web Services technology, Validated Request and Response XML using Soap UI tool.
• Created Test Suite in Soap UI tool to validate the response XML.
• Added properties, property transfer to validate multiple Web Service calls for SOAP and RESTFul Services.

Confidential, Boston, Massachusetts; Charlotte, NC

• Lead a test team of 10 and manage all test activities through all the SDLC lifecycle
• Analyze business and system requirements, manage development of specifications to create and execute detailed test plans, and verify bug fixes.
• Creation of sandbox environment for Data Discovery for the subject area-market data,performance attribution and portfolio reference (fund benchmark reference and performance fee)
• Identify the proper test suite/coverage for the system
• Data Quality validation, Loader functionality validation and Batch Cycle validation
• Develop and execute complex SQL queries against Oracle, Teradata and Sybase platforms
• Write shell scripts to run PL/SQL programs and Autosys job scheduling
• Using putty to run Autosys jobs and check job statuses/error logs
• Use Beyond Compare and in-house automation tool to compare between files
• Execute batch processing and verify the jobs status and data in database tables
• Responsible for QA activities for ETL environment, following the Agile methodology
• Participate in the daily Scrum call to report issues or progress (represent QA team in the project for story, task ownership)
• Use Rational Team Concert (RTC) to update the QA side tasks of the project.
• Responsible for providing inputs towards capacity planning in the sprint planning meetings for QA activities
• Use daily Scrums to help update the team on the stories for the remainder of the sprint
• Use HP Quality Center ALM for defect management and updating test execution and test results
•  Familiarity with brokerage /financial services with a good understanding of brokerage transaction processing systems within the Fidelity Institutional Technology (FIT)
•  Knowledge of trading activity within the brokerage platform
• Manage QA activities, progresses and statuses, including reporting status to senior management, managing defect tracking and providing inputs for the improvements of QA activities for  FIT Platform
• Responsible to test ETL mappings and other ETL Processes (Data Warehouse Testing)
• Involved in mocking and manipulating the source data to validate complex ETL transformations to do negative testing scenarios and to validate the data quality checks
• Involved in writing SQL queries with joins and filters to validate the Referential integrity and Data integrity between different related tables in the Data warehouse
• Involved testing ETL transformations done using INFORMATICA tool and PL/SQL.
• Good understanding of OLAP and OLTP systems and how they are used to different business needs viz different type of business reporting along with report writing and data mining purposes
• Create Analytical Base Tables to support forensic testing requirements and validate the reports created using BI tool TIBCO Spotfire from various data marts.
• Responsible for performing regular smoke test for pre-production environments
• Performing tests involving carrying out the entire trade execution flow on Minerva and associated QA validation
• Developing test strategies, plans and test cases for the given requirements
• Use Quality Centre for repository, reporting and tracking bugs and providing updates on resolved bugs.
• Providing automation solutions in the QA space using Selenium/DBFit(Fitnesse).
• Responsible for QA activities in ETL environment viz testing iFeeds
• Use HP Quality Center ALM for defect and test management tool.
• Responsible for implementing and executing Independent verification and Validation (IVV)test methodology conforming to the full STLC on various tickets that team handles
• Analyze business and system requirements, manage development of specifications to create and execute detailed test plans, and verify bug fixes.
• Oversee 6 off-site QA analysts based out of China
• Use Quality Centre for repository, reporting and tracking bugs, and providing updates on resolved bugs.
• Providing end-to-end test execution on production and core & maintenance tickets for all the clients as needed.
• Working with XML files for middleware testing
• Working on automation framework using Selenium
• Development of SQL Queries for checking data transaction and database validation.

Confidential

Technical Test Lead

• Responsible for implementing and executing Independent verification and Validation (IVV)test methodology conforming to the full STLC on portal
• Analyze business and system requirements, manage development of specifications to create and execute detailed test plans, and verify bug fixes.
• Coordinate with off-site QA analysts and onsite coordinator
• Use Quality Centre for repository, reporting and tracking bugs, and providing updates on resolved bugs.

Confidential, North Carolina, Charlotte

Technical Test Lead/Test Analyst

• Responsible for implementing and executing Independent verification and Validation (IVV)test methodology conforming to the full STLC on portal
• Analyze business and system requirements, manage development of specifications to create and execute detailed test plans, and verify bug fixes.
• Prepare test plan and test metrics
• Oversee 6 on- and off-site QA analysts
• Use of JIRA for repository, reporting and tracking bugs, and providing updates on resolved bugs.
• Hands on experience with Web Service testing using SOAPUI
• creating and consuming web services including experience with technologies such as SOAP,WSDL and XML
• knowledge of both black box and white box techniques to uncover bugs
• perform web vulnerability scanning using OWASP,SQL Injection, XSS, data validation, denial-of-service, error codes, weak encryption
• Understanding & experience with Security testing aspects of the project and providing inputs from manual testing perspective to prevent web attacks

Confidential, Pennsylvania, Pittsburgh.

Test Engineer

• Determine testing requirements developed and reviewed scripts for positive and negative test scenarios, conducted baseline testing, and generated reports
• Design test plans and define cases for functional, integration system and user acceptance testing.
• Attend weekly defect report meetings and presented progress updates
• Involve in all phases of the QA Life Cycle and SDLC, with timely delivery against aggressive deadlines, with QA methodologies.
• Conduct all kinds of testing covering all server-side and client-side functionality of the product.
• Manage defects, test plan and test lab for various stages of SDLC lifecycle using HP Quality Center
• Oversee 3 off-site QA analysts

Confidential

Test Engineer

• Responsible for preparation and maintenance of Requirements Traceability Matrix
• Responsible for creation of Test Conditions and Test Steps
• Create test data matrix from the set of business rules
• Perform defect logging, tracking, reporting and validation using Mercury Test Director.
• Contribute in System Integration Testing, Regression Testing, User Interface Testing and GUI Regression Testing

Confidential

Test Engineer

• Prepare and maintain Requirements Traceability Matrix after analysing requirements and deriving test conditions out of them
• Develop test cases from test conditions
• Create test data matrix from the set of business rules
• Perform defect logging, tracking, reporting and validation using Mercury Test Director