Etl Qa Consultant Resume
Raritan, NJ
SUMMARY
- 11.5 Years of professional experience in Information Technology as a Quality Analyst Lead\Senior QA Tester
- Managed 5 - 15 people across various location including managing day to day work and appraisal
- Experience in testing application software designed for insurance, infrastructure, security and antivirus domain
- Extensively worked on understanding existing business process, working with users and stakeholders to understand business problems and gathering requirements about their expected solution.
- Worked on SDLC including designing, developing and implementing test plans, test cases and test processes.
- Good Experience on BDD(Cucmber)Selenium IDE,C# and creating Scripts in selenium --webdriver by using Jscript
- Automated suitable test cases and developed Selenium test scripts for Regression Testing
- Hands on experience in developing, documenting and executing test cases manually and generating automated scripts using HP Quick Test Professional (UFT).
- Expertise in executing VUGen scripts in Load Runner for Performance, Load and Stress Testing using Controller in Load Runner and generated reports using teh Analysis tool in Load Runner.
- Expert in documenting requirements, performing system analysis and preparing Requirement as well as System analysis document to present to Architects and Development team.
- Strong skills in using SQL on various RDBMS like SQL Server, Oracle, and Postgres SQL.
- Developed complex SQL queries to perform Backend Testing, Data Analysis and System Analysis.
- Developed and Maintained Test Schedule for Quality assurance deliverables.
- Extensive experience in Agile/Scrum model, Waterfall model
- Responsible for working with application team in UAT and Production Release.
- Tracked defects in Quality Center and provided test execution progress updates.
- Expertise in Unit, Functional, Regression(Bug), Integration, System, End to End, Performance, Load, Stress, Backend, Black Box, User Acceptance Test (UAT) for Web (N-Tier) and Client/Server Applications.
- Experienced on testing Mobile Apps on iOS 6,7 and Android Kit Kat
- Extensive experience in coordinating testing effort, responsible for test deliverables, status reporting to management.
- Extensive experience in Working as a Quality Analysts on System Development Life Cycle (SDLC) methodology.
- Expert in preparing detailed system requirements & specifications for existing & new capabilities.
- Extensive experience in preparing Test Metrics, Traceability Matrix.
- Worked with various groups like Stakeholders, users, architects, BA to design agenda and deliverable for business requirements and worked on follow up documentation and communications.
- Analyzed bugs and coordinated with development team in fixing teh defects.
- Good understanding of Use Cases, Functional specifications and Business Requirements documents.
- Proficiency in MS Word, Power Point, Excel, Project and Visio.
- Excellent Written and Verbal communication as well as prioritizing teh work activities.
TECHNICAL SKILLS
Quality Analysis: Quality Center 10, QTP 10(UFT), Load Runner, Selenium Web Driver, Selenium Grid, SharePoint 2007, 2010
Languages: SQL
Methodologies: Agile, Waterfall Method
Database: SQL Server 2005, SQL Server 2008 R2, SQL Server 2012, Postgres SQL
Team collaboration: SharePoint 2007, 2010
Web Technologies: HTML, XML,Web Services(Soap UI 4/3.0),Rest Services (Postman)
Bug Tracking Tool: PVCS,ETRACK,QC, MS Bug track, Bugzilla,Jira
Operating Systems: MS Windows XP, Vista, 7, 8, Server 2003,2008 R2
Software Tools: Soap UI 4/3.0,Rally,iRise,WTT.
Source control: SVN,BitBucket,Jenkins
PROFESSIONAL EXPERIENCE
Confidential, Raritan NJ
ETL QA Consultant
Responsibilities:
- Sprint Planning QA representative to identify key QA tasks and Requirement Analysis..
- Functional testing of Data Analytics Framework.
- Test Case preparation and Execution including defect management and reporting.
- Mentoring junior QA members and training new personnel
- Restful APi testing and Automation.
- Mobile App testing on iOS/IPAD for OS above 9.0.
Environment: Hadoop,Hive,Dataica,EDL and imphala Jmeter,Postman.Bitbucket,Jira,confluence,Xcode,SourceTree, iOS Emulator.
Confidential, Raritan NJ
Senior QA Consultant
Responsibilities:
- Sprint Planning QA representative to identify key QA tasks and Requirement Analysis..
- Functional testing of Core JJHWS products.
- Test Case preparation and Execution including defect management and reporting.
- Mentoring junior QA members and training new personnel
- Data sheets preparation for Automation tasks and identification of test suites for automation.
- Product improvement recommendation and customer issue analyzer. iOS,Android mobile testing.
Environment: Drupal, ColdFusion, SQL server 2012, Confidential Sharepoint, Percussion Web Content Management, Jira, FIT tracker.
Confidential, Minneapolis,MN
Agile Consultant
Responsibilities:
- Analyzed teh Requirements from Addendums to use for Business Process.
- Created Test Scripts for Unit testing, Integration testing and UAT testing for E-Commerce GCPS Site
- Prepared and executed Test scripts for various Clients/OpenCart CMS,B2C model.
- Designed automated tests, created test cases, test plans and executed tests usingSpock.
- Prepared daily estimation report and weekly report .Presented to top management about updates on project
- Performed requirement analysis based on Ecommerce business needs and recommended changes as per teh requirements.
- Documented Change request and risk analysis based on project status.
- Performed customer interaction and onshore/offshore coordination about daily status and project status.
- Complete ownership of testing process.
Environment: Ecommerce, Opencart CMS,MS Office, Version One, Confluence, XML,SQL Server 2012, Unix, MDM, SPOCK, github.
Confidential, Huntsville, AL
Software Quality Assurance Lead
Responsibilities:
- Analyzed teh Requirements from Addendums to use for Business Process.
- Created Test Scripts for Unit testing, Integration testing and UAT testing
- Prepared and executed Test scripts for various Clients
- Designed automated tests, created test cases, test plans and executed tests usingSelenium
- Worked on developing teh automation scripts usingSeleniumand executed theJUNITtests.
- Executed automated test scripts using Selenium, analyzed teh results and reported bugs in Bugzilla..
- Used Selenium IDE for Open source web testing
- Recorded and plays back test in Fire fox using Selenium IDE
- Developed SQL queries using Management Studio (SQL Server) based on built in functions, group by, having, Inner Joins, Outer Joins, Sub queries for efficient data quality analysis and testing Application Database and Data Integration.
- Performed extensive Backend data research/analysis using SQL.
- Conducted manual testing of front end Portals with teh test members and validated teh processed claims with adjudication system.
- Experience in logging defects using Bugzilla and actively participated in defect review meetings for defect tracking and updating defect statuses by Performing Bug Testing.
- Prepared and enhanced teh QA Testing documentation for its repeatability for different clients based on customization
- Conducted manual testing in important phases like Benefits Testing, Integration Testing, Regression Testing and User Acceptance Testing (UAT).
- Executed VUGen scripts in Performance center, Load and Stress Testing using Controller in Performance center and generated reports using teh Analysis tool in Performance center
- Executed Tests on Trellis Mobile App on iOS 6,7 and Android Kit Kat 4.3,4.4
- Identified teh performance bottlenecks, end to end performance, and web performance measures like server response time, throughput and network latency and discussed teh results with technical team.
- Participated in Planning Meetings and represented QA team.
- Performed documentation of online halp contents
- Shared product noledge to Sales, Marketing team.
- Performed webservices testing Using Soap UI 4.0
- Managed 6 junior team members, activities include allocation of work, resourcing and performance review.
Environment: MS Office, Net Framework (ASP), C#,SQL Server 2012, SharePoint 2010, JAVA, Selenium, Soap UI, Rally, Bugzilla, Ap Test Manager,iRise,Load Runner and Perfomance center.,Cucumber(1.0.5)
Confidential, Boston,MA
QA Test Lead
Responsibilities:
- Analyzed teh Requirements from design documents, psd and use case documents
- Created Test Scripts for Unit testing, Integration testing and UAT testing
- Designed automated tests, created test cases, test plans and executed tests usingSelenium
- Worked on developing teh automation scripts usingSeleniumand executed theJUNITtests.
- Executed automated test scripts using Selenium, analyzed teh results and reported bugs in Bugzilla..
- Used Selenium IDE for Open source web testing
- Recorded and plays back test in Fire fox using Selenium IDE.
- Conducted manual testing of HIP Portals with teh test members.
- Experience in logging defects using QC and actively participated in defect review meetings for defect tracking.
- Conducted manual testing in important phases like Benefits Testing, Integration Testing, Regression Testing and User Acceptance Testing (UAT).
- Participated in Planning Meetings and represented QA team.
- Performed webservices testing Using Soap UI 3.0
- Performed test metrics preparation, cost estimation and project metrics
- Performed documentation of Audit (CMMi L5)
- Performed Lean implementation across project
- Performed customer interaction and onshore/offshore coordination
- Performed team management
Environment: Windows XP\Vista\7, Mac Os, IE 6\7\8, QC, SVN, Rally, Selenium, Soap UI, Sql Server 2008,Postgres SQL, XML,HTML4.
Confidential, Northbrook, IL
Onsite Project Coordinator
Responsibilities:
- Performed customer interaction and onshore/offshore coordination about daily status and project status.
- Performed team management, allocated day today work and also managed teh schedule allocation,
- Prepared daily estimation report and weekly report .Presented to top management about updates on project
- Performed requirement analysis based on business needs and recommended changes as per teh requirements.
- Documented Change request and risk analysis based on project status.
- Performed functional testing on As400 Mainframe for various state insurance based on premium changes.
- Conducted Weekly test status meeting to top management and explained about project health.
- Performed appraisal reviews for junior members
Environment: AS400, Prism, QC, QTP.
Confidential, Santa Clara,CA
Senior Quality Assurnace Test Engineer
Responsibilities:
- Created Test Scripts for Unit testing, Integration testing and UAT testing
- Conducted manual testing in important phases like Benefits Testing, Integration Testing, Regression Testing and User Acceptance Testing (UAT).
- Participated in Planning Meetings and represented QA team.
- Coordination with onshore and offshore about function and technical specifications including requirement analysis and design analysis
- Prepared test bed for test execution, Test plan preparation and test case preparation based on requirements
- Participated in weekly status meeting, updated about module status and suggested improvements.
- Reporting defects in ETRACK and updating status based on development and business needs.
Environment: Windows XP, Windows Vista, ETRACK, Perforce, Autohalp tool, ccsettings tool, Araxis merge tool (Internal to Confidential ),SQL server 2005.
Confidential
Quality Assurnace Test Engineer
Responsibilities:
- Created Test Scripts for Unit testing, Integration testing and UAT testing
- Conducted manual testing in important phases like Benefits Testing, Integration Testing, Regression Testing and User Acceptance Testing (UAT).
- Participated in Planning Meetings and represented QA team.
- Coordination with onshore and offshore about function and technical specifications including requirement analysis and design analysis
- Performed localization testing for security product in Japanese language including kanji.
- Participated in weekly status meeting, updated about module status and suggested improvements.
- Reporting defects in Bugzilla and updating status based on development and business needs.
- Developed and executed formal test plans to ensure teh quality delivery of software applications.
- Developed and created reusable test data, and employing test strategies so as to minimize test collisions and maximum test efficiency
Environment: Solaris 8.0 / 9.0 / 10.0 , Windows 2000 / XP, Confidential Exchange Server / 5.5, Outlook Express, Outlook 2000 and Bugzilla.
Confidential, Redmond, WA
Test Engineer
Responsibilities:
- Created Test Scripts for Unit testing, Integration testing and UAT testing
- Conducted manual testing in important phases like Benefits Testing, Integration Testing, Regression Testing and User Acceptance Testing (UAT).
- Participated in Planning Meetings and represented QA team..
- Reporting defects in Bugzilla and updating status based on development and business needs.
- Preparing Test Bed using WTT to install various flavors of operating systems.
- Executed test automation scripts and verified logs based on teh requirements.
Environment: Windows 2000 / XP / Vista,.Net Framework (C#),WindowsTest Technologies Tool(WTT), MS Bug tracking tool, and Win Debugger.