Sr. Qa (big Data Migration) Resume
NY
SUMMARY
- Nine Plus Years of experience in Software Quality Assurance as a Manual & Automation Testing Manager / Specialist / Lead (Functional & Performance Testing) coupled wif 9 years of experience in IT Industry wif expertise in System Analysis, Design, Coding, Development, Implementation, Performance Evaluation, Technical Writing and Training.
- Working as QA Team Lead / QA Manager executed several projects from initiation to implementation and played responsible role in functional validation, data migration, performance evaluation, team procurement, documentation, release management, production verification and change management.
- Well versed wif various Software Development Life Cycle Models like Waterfall, Extreme Programming, Rational Unified Process (RUP), Agile Scrum and Test - Driven Development.
- Worked closely wif cross functional teams and designed comprehensive Functional as well as Performance evaluation strategies and successfully executed the test efforts working wif both onsite and offshore teams.
- Designed automation frameworks for various projects and supported end to end functional automation and regression testing maintaining robust test suites.
- Extensively involved in performance evaluation of applications and used HP Mercury Load Runner / Performance Center to perform load, stress, scalability, performance and volume testing. Well versed wif installation and configuration of Load Runner and successfully handled performance evaluation of applications wif large Vusers and distributed loads.
- Performed web services testing working wif various third party and internal services and worked wif cross functional teams to build test harness and validation of return values and response codes. Worked wif tools like SOAPUI - RESTful WebServices / RESTful API’s
- Highly experienced in validating large volumes of data migration and successfully lead major Data Warehousing projects to certify Data Completeness, Transformation, Quality, Integration and Performance evaluation.
- Implemented the end to end QA process in many assignments and highly experienced in designing templates, Test plans, Test Scenarios, Status Reports, Work Flows and coordinating onsite and offshore teams.
- Conversant wif Financial Regulations like SOX, FSA, and also the various standards and guidelines followed to meet the requirements of Financial Regulatory Authorities like BASEL 1, BASEL II, CCAR, and LRMS & EPS. Proficient experience wif financial modules like KYC, AML (Anti Money Laundering). ACH, SWIFT, Wire Transfers, Personal & Corporate financing, Wealth Management & Mortgage.
TECHNICAL SKILLS
Languages: HTML, XML, JAVA, Visual Basic, SQL, PL/SQL, C, C#, C++, ASP, Power Builder, Pearl, Python
Operating Systems: MS-DOS, Unix, VAX, Win 95/ 98 / 2000 / Vista / XP / 7 / 10, Mac, AS/400, iOS, Android
Web Services: SOAPUI, RESTful API’s, RESTful Web Services
Database: Oracle, SQL Server, MS-Access, Sybase, DB2.
Big Data Tools: Streamsets, Elasticsearch, Kibana, Grafana, Hadoop, HDFS, HIVE, Cloudera, Kafka, Spark
Testing Tools: HP Load Runner, HP Performance Center, E-Load,, HP Quality Center-ALM, HP-Quick Test Professional - QTP, UFT, Rational Rose, Rational Clear Quest, Rational Clear Case, Silk, Silk Performer, SQA Suite, SQA Robot, SQA Administrator, SQA Manager, MS-TFS, Selenium, Robot Framework, Cucumber, Jasmine
Others: SaaS, TFS, Siebel, MS-Project, MS-Power Point, MS-Visio, Visual Source, Safe, Lotus Notes, iPhone, iPad, PVCS, MS-SharePoint, MS-Office, Cucumber
PROFESSIONAL EXPERIENCE
Confidential, NY
Sr. QA (Big Data Migration)
Responsibilities:
- Reviewed the project documentation and designed the comprehensive test plans for functional and performance testing.
- Presented the plan to all the stakeholders and received the needed approvals.
- Checked the data contracts associated wif every data source and designed detailed test cases to validate the end to end efforts. Test cased validated both qualitative and quantitative requirements.
- Executed Streamsets pipelines to migrate both historical and continuous ingestion data. Validated the data sources, targets, configuration, ingestion rate.
- Validated the migrated data completeness, volume, quality, integrity and readiness for downstream systems.
- Tested the end to end workflow of the migrated data in applications deployed on Docker containers.
- Used SSMS, DB2 Analyzer & HIVE, extensively to design queries and extract data. Used both manual and automation methods to compare and validate the data.
- Verification of the JSON documents against the data and validating the same for downstream readiness.
- Worked closely wif cross functional teams and played a key role in the successful migration effort.
- Used MS-Azure DevOps extensively for complete test management, status reporting, defect reporting and tracking.
Environment: Java, Python, SQL, Salesforce, Streamsets, Elasticsearch, Kibana, Grafana, Hadoop, HDFS, HIVE, Cloudera, Kafka, Spark, Beyond Compare, SSMS, Db2 Analyzer, Windows 10, MS-Azure DevOps.
Confidential, NY
Sr. QA Manager / Lead
Responsibilities:
- Test Strategy design and approval from all the stakeholders of the project.
- Test Environment setup and publication of standard templates for all the documents like, Requirements, Test Cases, Defect Reports, Traceability Matrix, Status Reports and Change Requests.
- Resource procurement, allocation of roles and responsibilities, off-shore team co-ordination, release management and UAT signoff.
- Test case designing and execution to validate the comprehensive functionality and coordination of test efforts of both onsite and offshore resources.
- Built automation framework using selenium and python to support functionality and regression testing.
- Data governance, review and quality assurance of various data sources including, trading, wealth management, investment banking, corporate banking, personal and HELOC.
- Designed the test harness to validate the Webservices and validated the Return codes and responses.
- Designed a comprehensive automation framework to cover the end to end automation efforts and managed robust regression suites to support CI/CD in DevOps.
- Designed and used Selenium, JavaScript, Jasmine & Robot Framework for UI automation and integrated the same wif Jenkins for test execution and reporting.
- Used TestComplete extensively for UI Automation and data driven testing.
- End to end validation of pre and post data consolidation scenario in Big Data Space. Hand on experience working wif HIVE and Data Analysis.
- Created test data to support RESTful API’s and RESTful Webservices.
- Created, updated and managed fully automated framework for end to end testing using C++ & python.
- Designed functional libraries, driver scripts, data driven tests and supported complex test scenarios involving various modules of the application and maintained robust test suites to support smoke, functionality, regression and end to end testing.
- Identified the key functional scenarios and designed the appropriate automation test stream to support detailed testing of the functionality.
- Designed detailed test scripts following the enterprise standards and supported, GUI, functional, DB, Integration, positive, negative, regression and end to end tests.
- Data validation in pre and post migration scenario to big data.
- Hands on experience of scripting, test case designing, test execution, debugging and analysis, defect reporting, tracking and maintenance of test suites.
- Directly reporting to the QA Director managed the onsite team as single point of contact and led the test efforts of both manual and automation teams.
Environment: Java, Python, Internet Explorer, Google Chrome, MS-Project,, HP Quality Center - ALM, HP Load Runner, JIRA, Confluence, SQL Server, SOAPUI, Salesforce, ROBOT Framework, TestComplete Selenium, JavaScript, Robot, Jasmine, HP Performance Center, Windows 7, Streamsets, Elasticsearch, Kibana, Grafana, HDFS, HIVE
Confidential, NJ
QA Manager
Responsibilities:
- Training the team wif the standardization procedures and providing the template for the project deliverables.
- Team procurement and training of the resources to support manual, test automation, performance testing and UAT.
- Reviewing and validating various documents designed to meet the project requirements like, Project Plan, Test Plan, BRD, FDD, DDD, Traceability Matric and comprehensive test cases to support Unit Testing, System Integration Testing (SIT), User Acceptance Testing (UAT) & Production Verification Testing (PVT).
- Documentation repository setup using MS-SharePoint to maintain version-controlled review process of the various project documents.
- Use case analysis designed used Rational Rose and test scenario designing for complex role based access systems
- Team Management & mentoring of both onsite and offshore teams and allocation of day to day activities.
- Created UI automated tests using testcomplete. Worked extensively wif managing and updating several data driven and frontend validation tests and regression test cases.
- Managed the test automation platform and updated the same using C++ & Python.
- Designed the automation framework and scripted the functional scenarios to support regression testing using java and selenium.
- End to End data quality validation and hands on experience working wif Bigdata in a cloud environment. Used tools like HIVE, Streamsets, Informatica and BusinessObjects.
- Scheduling and organizing regular meetings for knowledge transfer and sharing the project updates wif all the stakeholders of the project.
- Organizing the comprehensive test documentation repository of test cases, test results and defects using HP Quality Center - ALM. Responsibility also included installation and administration of the tool.
- Designed comprehensive test suites to support (BDD) adopting the cucumber approach and managed web desktop and android apps automated testing.
- Performed functional, regression, integration, load, stress, performance and latency testing in cloud based environments (WYSE) and served as one man contact for entire testing efforts to the senior management.
- Built web automation testing suite using Selenium Web Driver, TestNG and Junit.
- Supervision of the test efforts of manual, functional automation and performance testing and publication of Test Evaluation Matrix for senior management.
- Setup of Performance test environment, Installation of load generators, Integration wif monitoring tools, Scripting, test data provisioning and execution of several test scenarios.
- Performance monitoring of the applications to meet the response time SLA’s, creation and execution of various tests designed in Load Runner / Performance Center and publication of results for analysis.
- Working wif the development group and captured Java, SQL and Network counters for monitoring and assisted the troubleshooting and code analysis.
- Converted Vugen scripts to Java and designed the test scenarios to replicate typical business day scenarios.
- Worked wif development teams to review Java and database related issues and performed code reviews, troubleshooting and for updating the scripts. Integrated tools like jprobe & jmeter.
- Overall coordination of testing efforts involving resources from headquarters, onsite and offshore.
- Responsible for toll gate exits at various stages of the projects and publication of Test Evaluation Metrics periodically for senior management.
Environment: Java, XML, C#, Oracle, Toad,, Internet Explorer, Google Chrome, WYSE, SAAS, MS-Project, SharePoint, Rational Clear Quest, TestComplete.Rational Rose, HP Quality Center - ALM, HP Load Runner, HP Performance Center, Windows 7, BigData, HDFS, Hive, Cloudera, Streamsets
Confidential - Merrill Lynch, NJ
QA lead / Manager
Responsibilities:
- Designed comprehensive Test Strategy to lead the end to end test efforts of the application wif primary responsibilities of User Story reviews, Test Scenario Designing, Test Environment Setup and Maintenance, coordinating the release cycles, resource procurement and allocation of responsibilities.
- Executed detailed Test Cases, Documented Test Results, Reported defects, tracked defects and worked wif all the associated partners in resolving the issues and performed manual and automated regression.
- Implemented automated framework using QTP to support Regression Testing and contributed for the constant upgrade of the automated scripts from release to release. Maintenance of test environment, Release deployments, configuration of the integrated test environment and script updates were implied efforts.
- Identified the response time requirements, scripted the virtual user scripts to replicate the user experience using Vugen, Designed the Test Scenarios, Managed environmental configuration and load generators and performed Load, Stress & Scalability tests to support the overall performance evaluation and monitoring of the application. Used VuGen, Controller, Analysis, Performance Center & QC-ALM.
- Worked wif cross functional teams and successfully managed test efforts, documentation, training, functional test automation, Performance Evaluation, UAT, Change Management & Production verification Testing.
- Validated WebService requests and responses and used HttpMaster extensively.
- Evaluated the performance requirements of the application and played active role in the integrated setup of the environment to support load, stress, volume, scalability and performance testing.
- Implemented automation framework using selenium and java combination and maintained a comprehensive automated test bed to support end to end functionality testing.
- Designed complex test matrix to meet testing use case scenarios designed in Rational Rose and validated coverage analysis.
- Collected and prepared the needed test data for test execution and simulated large volumes of data to test Online Transaction Processing. Responsibility included confirmation of data integrity, accuracy and retrieval response.
Environment: Java, .Net, XML, C#, DB2, Oracle, Toad, Web Services, Internet Explorer, Google Chrome, iPad, iPhone, MS-Project, SharePoint, HP Quality Center - ALM, Selenium, Junit, TestNG, CSS, HP Load Runner, Selenium, Pearl, Python, Salesforce, Siebel, Rational Rose, Performance Center, Windows XP / 7.
Confidential, Princeton, NJ
SR QA Lead
Responsibilities:
- Designed and executed functional and performance test plans to support end to end functionality of the Fixed income products on the Confidential Terminal.
- Extensively used automation tools, QTP for functional automation and regression support, Quality Center for comprehensive test management, Load Runner / Performance Center for load, stress, volume & scalability testing and performance monitoring.
- Analyzed user logs and identified the application’s key components and designed detailed Vuser script to simulate the real time load. Scheduled and executed the scripts to monitor the applications behavior and analyzed the test results.
- Daily Scrum meetings, User Story Reviews, Updating the reviews on MS-SharePoint, Defects triage, consolidation of test beds for various iterations and status reporting to QA manager were daily responsibilities.
- Played active role in test environment setup, configuration, scenario designing, script writing, test execution, publication and analysis of both functional and performance testing.
- Used Open Source Selenium for test automation extensively and designed functional regression test beds to support automated functional testing.
- Used TestComplete extensively for Confidential Anywhere Automation.
- Hands on experience working wif the database and validation of data accuracy and integrity. Used SQL extensively to perform data checks and confirm the database updates.
- Validated various Batch routines designed in UNIX to support the backend updates and worked wif updating the routines, execution of the batch jobs, validating the in a pre and post update scenarios.
- Designed comprehensive automated test cases using Selenium to support continuous integration and robust regression testing.
- Implemented several check points to verify the objects and their associated properties.
- Designed comprehensive data driven and cross browser tests for parallel execution using Selenium WebDriver, TestNG and Selenium Grid.
- Validated the FIX protocols used trade and post-trade related messaging. Designed various test scenarios to validate the messages and confirm the accuracy.
- Verified several transactions from end to end and validated the corresponding FIX messages to ensure the transaction accuracy.
- Requirements Review, Test Planning, Test Execution, Documentation of Test Results, Defect reporting and triage, Risk Analysis, Change Management Control, Publication of Release documents and Trailing Material were key activities.
- Trained the off-shore and onsite teams to manage 24/7 test efforts and implemented the streamlined process.
- Worked wif the R&D team to setup the performance monitoring environment and played active role in setup, integration, scripting, test data integration, execution of tests, collection of raw data, data analysis, troubleshooting and publication of analysis reports.
- Working as Quality Center- ALM Administrator designed custom templates to meet project requirements, customer workflows, managed user profiles and work groups, integrated wif other tools and designed Management Information Reports.
Environment: Java, XML, SQL, Oracle, HP Mercury Quality Center - ALM, SAAS, Selenium, TestNG, Junit, Load Runner, HP Performance Center, Https, Https, FTP, SFTP, TCP/IP,, QTP, TestComplete,Unix, Salesforce, Unix, FIX, ASW, MS-Office
