SUMMARY

• Accomplished IT professional with 17+ years of progressive experience and proven record of significant, successful contribution in Business analysis, Quality management, Data Analysis, Project management, Process improvement life cycle methodologies in various domain viz Financial/Banking, Media, Marketing, HR and Payroll.
• Over 13+ years of experience in Test Management, Test Design, Test Planning and Test Execution.
• Over 4+ years of experience in Business Analysis, requirements elicitation, create functional and technical requirements, wireframes, flow diagrams, BRD, SRS, DFD, Use Cases, User Stories and User Manuals.
• Translated stakeholder requirements into tangible deliverables such as functional specifications, metadata mapping, use cases, user stories (JIRA), workflow and process diagrams and data flow/data model diagrams.
• Good understanding on Non - Cleared Margin Rules(NCMR) for Collateral Management under Dodd Frank Act.
• Good understanding on trade life cycle, on Legal Documents such as ISDA, CSA, MSFTA, CCP's and other Bilateral Derivatives Agreements.
• Extensive understanding of various software life cycle models like Waterfall and Agile with a very good knowledge of all the testing phases of SDLC using different platforms & workstations.
• Experience in Implementing HP's leading edge Business Process Testing (BPT) module for driving test automation using HP ALM.
• Expertise in testing SOA applications and experienced in using tools like SOAP UI, XMP Spy, Fiddler etc.
• Expert knowledge of SWIFT formatting, data mapping and field content.
• Good understanding about OLAP and OLTP systems.
• Technical skill includes working with Unix commands, MS SQL, Sybase, Oracle, My SQL, Crystal report, Micro strategy reports.
• Extensive experience in data cleansing, analysis, data validation from various data sources like flatfile, CSV, DBlinks, DB tables etc. Using Excel pivot tables, formulas (v-lookup and others).
• Adept in end-to-end understanding of Cloud, Web, Desktop products from requirement analysis to system study, testing, documentation.
• Has hands-on experience on defect management tools that include HP ALM, PVCS tracker, Test director, Bugzilla, Test track pro, Scarab etc.
• 5+ years of experience in agile/hybrid project management, collaborating with stake holders for developing project plans, recommending/approving scope based on the criticality.
• Experience with widely successful Agile techniques: User Stories, ATDD, Continuous Integration, Continuous Testing, Automated Testing, Agile Games.
• Experience in organizing Daily Stand-Up, Sprint Planning, Backlog Grooming, Sprint Retro & test planning.
• Excellent team building, collaborative, coaching and mentoring, stake holder and vendor management, client communication capabilities.
• Well experienced in managing large Global (Onsite & Offshore) teams.

TECHNICAL SKILLS

Database & Data Analysis: Oracle, MS SQL, My SQL, MS Excel, MS Access

Products/Tools: HP ALM, QTP, Ruby, MS SQL, MySQL, Oracle, Sybase, MS office, VSS, Reuters CMS, MS SharePoint server, Bugzilla, Test track pro, Scarab, Crystal Report, Microstratergy, Sybase, IIS Server, Tomcat Server, PWS server, SOAP UI, Shell Scripting, JIRA GreenHopper, Sharepoint, Oracle, Toad, Fiddler, Firebug, Putty(Unix), HttpWatch, XML Spy, QlickView, SQLDeveloper, Bugzilla, VM Ware. MS Outlook, MS Excel/Word/Access/ Powerpoint, Microsoft Project Plan.

Knowledge on: Selenium Test Automation, Python, Storage devices (EVA, MSA, XP), OS installation, SAN knowledge.

PROFESSIONAL EXPERIENCE

Confidential, Houston, Texas

Business Analyst/Scrum Master

Responsibilities:

• Organize Daily Stand-Up, Sprint Planning, Backlog Grooming, Sprint Retro testing kick-off meetings and define the testing scope and test strategy.
• Delivered functional requirements under Non-Cleared Derivatives Collateral Management program.
• Managed and supported multiple projects, ensuring they aligned to business goals, well documented and appropriately reported.
• Organize requirement elicitation session and create functional and technical requirements, wireframes, AS-IS & TO-BE flow diagrams, BRD, SRS, DFD, Use Cases, User Stories, User Manuals and conduct walkthroughs and FRS reviews sessions with stakeholders.
• Engaged third-party Custodians (Bank of NY Mellon, State Street, Euroclear and others) to combine requirements for Collateral pledge and return via SWIFT vehicle.
• Tested SWIFT formatting, data mapping and field content for accuracy.
• Do Data Analysis, Use case determination and creating user stories in Jira.
• Responsible for work estimation, resource allocation and project planning.
• Responsible for creating and driving Functional, E2E test plan, test execution, test reporting, defect tracking and analysis.
• Develop Automation Test Scripts Gherkins in Cucumber and keep them updated based on changes to the systems and execute them for migration of legacy manual functional test for Margin and Settlement workflows into Selenium automation framework.
• Perform analysis on large trade data set to better understand relationship between variable and derive multiple use cases.
• Test web services (SOAP & REST) and XML with tools like ‘SOAP UI’ & XML Spy for the local WSDL/With URL.
• Validate ETL Job logic by comparing source and the report data.
• Review Gap analysis for assigned projects.
• Reporting, prioritizing, tracking, and monitoring the vulnerability lifecycle till closure.
• Provided statistical analysis, review project reports on planned workstack, resource utilization, highlight risks and issues related to project lifecycle.
• Develop & execute test cases that address areas such as database impacts, software scenarios, regression testing, negative testing, error or bug retests, or usability.
• Perform functional and database testing to validate the correctness of functionality, Data accuracy and cross application data workflow.
• Responsible for researching and improving quality testing productivity and effectiveness.

Confidential, New Jersey

Test Manager

Responsibilities:

• To function as onsite project lead and act as the single point of contact between stakeholders, development and testing teams.
• Involved in Scrums, Sprint Planning Sessions, Backlog Grooming, Sizing, Sprint Retrospectives & Reviews, and Daily Standups.
• Review and understand Business Requirement documents to estimate time and resources to perform testing.
• Organize the testing kick-off meetings and define the testing scope and test strategy.
• Coordination with team across multiple location, assign, review and report work allocation.
• Plan, Develop tasks, dependencies and risk mitigation strategies and review with stakeholders.
• Analyze historical data derive critical uses cases and maximum test coverage.
• Perform database testing on Oracle & Vertica db’s to validate the data type, field size, constraints, indexes stored procedures and joins.
• Develop, document & execute test cases that address areas such as database impacts, software scenarios, regression testing, negative testing, error or bug retests, or usability.
• Test web services (SOAP & REST) and XML with tools like ‘SOAP UI’ & XML Spy for the local WSDL/With URL.
• Validate ETL job logic and check COGNOS reports against the DB for data correctness.
• Check data flow between multiple layers like UI, Application server and DB using tools like Fiddler & Firebug.
• Responsible for researching and improving quality testing productivity and effectiveness.
• Document, implement, monitor, and enforce all processes for testing as per standards defined by the organization.
• Keep track of the new requirements / change in requirements of the project.
• Attend the regular client call, discuss the testing status and publish report of activities like test results, test case coverage, defects discovered, defect status, performance baselines, execution status report (daily, weekly etc.) to the client.
• Prepare & publish the metrics dashboard Daily, weekly and during sprint completion.
• Escalate the issues about project requirements (software, hardware, resources) to Project Manager

Confidential

Project Lead

Responsibilities:

• Responsible for working on all phases of software life cycle including Requirement Review, Test plan development, Test case development, Test Execution & Implementation (Prod checkout).
• Created automation framework using RUBY Watir & FireWatir gems to automate web application in both IE and Firefox browser.
• Testing ETL test results and flat file data for accuracy by writing UNIX Shell script.
• Tested Web services (SOAP and REST) and XML with tool called 'SOAP UI' for the local WSDL / with URL.
• Perform database testing on Oracle, MYSQL, Sybase databases to check the field size, data type validation, check constraints, indexes, stored procedures and Joins; ensure data integrity and validate the inserted and updated data.
• Tested TIBCO messaging which was used to communicate information between multiple web services.
• Testing FTP and SMPT services.
• Worked on platforms including Client Server Architecture, Web applications, SOA architecture, and web services.
• Designed Test Strategy, Use Cases, Functional test cases and Regression test suites.
• Check the data flow between UI, Middleware and DB using Fiddler & Firebug.
• Working with an Agile, Scrum methodology to ensure delivery of high quality work with every iteration.
• Participated in Sprint Planning meetings, review; user stories for the upcoming sprint.
• Testing Determine effective quality metrics, Establish quality criteria / release criteria.
• Testing applications under test for Browser Compatibility, Operating System Compatibility, Functionality, Navigation, Presentation, and Usability.
• Defect management using Bugzilla.
• Ensuring content and structure of all the testing artifacts are documented in SharePoint Tool.
• Building test strategy for Web applications, SOA applications & Client server applications.
• Testing applications in multiple platforms like MYSql, Sybase, Flex, J2EE and Operating system Unix, Linux, Mac and Windows.
• Experience in test planning, reporting, risk analysis, tracking key measures and metrics.
• Experience in working with teams located in different geographies.

Confidential

SQA

Responsibilities:

• Responsible for working on all phases of software life cycle including Requirement Review, Test case development, Test Execution & Implementation (Prod checkout).
• Designed Functional test cases and Regression test suites.
• Tested Micro strategy and Crystal reports by comparing UI against the business logic and upstream databases.
• Participated in test planning meetings; review user stories for the upcoming release.
• Perform database testing on MSSql to check the field size, data type validation, check constraints, indexes, stored procedures and Joins; ensure data integrity and validate the inserted and updated data.
• Testing applications under test for Browser Compatibility, Operating System Compatibility, Functionality, Navigation, Presentation, and Usability.
• Defect management using Test Director & PVCS Tracker.
• Responsible for communicate with project managers, development managers, release managers and developers to ensure comprehensive test planning and execution.
• Additional duties entailed the following; business knowledge and proficiency in building test strategy for Web applications, Client server applications.
• Ensuring content and structure of all the testing artifacts are documented in SharePoint Tool.
• Ensure all testing documents / artifacts are documented and maintained and adheres to CMM Standards.
• Reporting, QA communications, Go-No Go Decisions and Stabilization support.
• Experience in working with teams located in different geographies.

Confidential

Test Engineer

Responsibilities:

• Participate in requirement review, develop and execute test scenarios that address areas such as database impacts, Functional lapses, regression testing, negative testing, error or bug retests, or usability.
• Tested Client Server Architecture, Web applications and Desktop applications.
• Designed Test Strategy, Use Cases, Functional test cases and Regression test suites.
• Perform database testing on MSSql, Sybase and Oracle databases to check the field size & data type validation, check constraints, indexes and stored procedures.
• Check DB Backup/Restore jobs.
• Testing web application installation and uninstallation on webservers like TOMCAT and IIS. Testing SMTP service email distribution.
• Test the daily ETL job that transfers data from excel & flat file to Oracle/MSSql database.
• Document software defects, using a bug tracking system bugzilla, and report defects to software developers.
• Provide technical support during software installation or configuration.