Sr. Quality Assurance Engineer Resume
Las Vegas, NV
SUMMARY:
- Dynamic and results driven technical professional with ten years of diverse experience delivering solutions to large scale projects for a diverse clientele.
- Proven ability to liaise between business and technology stakeholders using the Software Development and Software Testing Life - Cycle.
- Responsible for executing client methodologies including Agile, Waterfall, and Rapid Application Deployment (RAD).
- Promoted Automation and Manual Testing of UI and Web Applications using automation-tools including Quick Test Professional (QTP-UFT), Quality Center (QC-ALM), Selenium, SoapUI, and Load Runner.
- For the Core Banking System Replacement project - Deposits line of business (LOB), conducted Gap Analysis, Impact and Risk Analysis, Level of Effort (LoE) for Test Scripts. Authored SQL scripts for Back End testing as part of Data validation and to check for transformation logic between loading stages in the Datawarehouse.
- As a Senior QA part of the Global Infrastructure group, tested over 1,500 UNIX and Windows servers post build for multiple LOBs throughout EMEA, APAC and NA. Ushered LOBs through Proof of Concepts in utilizing the template build process and identified any gaps in requirements.
- Globally assisted Project Managers and Engineers in remediating defects and retested accordingly.
- Received multiple accolades for Client Delivery and Production.
- Oversaw and conducted UAT testing for Retail Replacement Project.
- Coordinated with vendors to ensure proper testing had taken place for custom code modification, interfaces and data migration to achieve a business ready deliverable solution.
- Conducted performance and load testing for up to 2 million batch records and 36,000 Point-of-Sales transactions per hour.
- Regularly called upon for oral and written communications on statuses to stakeholders with a proven ability to work with multicultural teams(s) across the globe.
TECHNICAL SKILLS:
Programming Languages: SQL, Java, UNIX/Linux Shell, PL/SQL, HTML
Testing Tools: Quick Test Pro/UFT, Selenium, SoapUI, XML SPY, TOAD, Clarity Test Manager, Win Runner, Load Runner, CA Rally, Quality Center/ALM, BugZilla
Database Systems: Oracle 11g, 10g, SQL Server (2005, 2008, 2012), MySQL
Web Server: IBM WebSphere, Data Power (IBM), Web Logic, Apache
Business Tools: MS Office Suite (Word, Excel, PowerPoint, MS Visio, MS Project)
PROFESSIONAL EXPERIENCE:
Sr. Quality Assurance Engineer
Confidential, Las Vegas, NV
Responsibilities:
- Created comprehensive Test Plan to test the system’s availability and durability on a global end-to-end scale.
- Conducted testing for data migrations from Aptos to MS Dynamics 365 with assistance from DBAs to prevent data loss
- Performed automated performance tests via LoadRunner to mimic a Production environment which consists of 2,000,000 batch records and 36,000 POS transactions per hour.
- Captured and recorded performance metrics such as response time, CPU, memory usage, and network latency between MGM systems and MS Dynamics 365 cloud environment
- Conducted smoke tests to test the connectivity to interfacing applications
- Logged defects via CA-Rally and presented findings in defect triage meetings with stakeholders and tracked till closure.
- Coordinated with third party vendors & development team (Internal/External) to MGMRI for defect fixes and retesting of defects
Sr. Quality Assurance Engineer
Confidential, Jersey City, NJ
Responsibilities:
- As a part of the Web Build team, coordinated with offshore QA group to test servers stemming from multiple projects, environments, and platforms.
- Provide updates for servers in queue and prioritize workflow via Template Tracker calls.
- Handle remediation with engineers and provide support to Client Delivery in informing Product Owners/PMs of defected servers.
- Test servers to be compliant with firm set policies and consistency of records on proprietary databases.
- Help remediate unique defects with database records and/or servers
- Identified and documented QA process gaps and aided in review of QA runbook
- Design and implement procedure changes and enhancements for QA-specific requirements with focus on speed and consistency.
- Assisted Asset Management in proof-of-concept for template build process by identifying gaps in requirements.
- Assisted other QA spaces in handling high volumes (e.g. OS and DB servers)
Sr. Business/Quality/Data Analyst
Confidential, Jersey City, NJ
Responsibilities:
- As a part of Enterprise Data Management and Business Solutions, worked on Business Analysis, Data Analysis, requirement gathering, GAP analysis, Data Mapping and Testing of ETL and BI Reporting requirements
- Analyzed and prepared data element mapping documents for Deposit products and responsible to maintain business glossary for Business object reporting aspects.
- Reconciled BRDs, and FRSs to and reflect various change controls that had occurred in the span of the project.
- Analyzed business areas; Liquid Deposits, Timed Deposits, Overnight Investments, Cash Pooling, Savings & Current Accounts, Transactional Data, and Valuation Types.
- Responsible for back office business line processing and supported Front Office\Operations team for defect analysis.
- Prepared field - to-field mappings for identified data elements. Worked with technology and upstream business team to understand the OVS (front end proprietary app) process and mapped data source with ETL data elements. Identified GAPs and documented results.
- Worked with ETL resources to source required data elements and applying transformation logic before loading into target tables. Worked with SOA ETL teams to implement new Informatica ETL process to fulfill the requirements
- Responsible for design, development and execution of testing activities, tasks, and deliverables required for UAT testing.
- Created extensive SQL scripts to validate DWH on ETL processing and data mart for various downstream systems.
- Worked with SAP Business Objects developers to map the data elements and BO Universe design process. Conducted various working sessions to finalize the BO Reporting requirements.
- Supported testing team for test scenarios and data input like Customer Onboarding, Cash Management Systems, YTD/MTD & Daily Balances. Alert processes, flexible processing options including multi-currency, multi-bank and multi-lingual capabilities, BI reporting etc.
- Orchestrated defect triage meetings, and hosted developer meetings to discuss modifications/improvements to ETL logic
Senior Quality Assurance Analyst
Confidential, Pennington, NJ
Responsibilities:
- Demonstrated and documented QA Test Plan with cross-functional team to approve business logic and baseline documents.
- Verified entrance criteria of QA and set up configuration data with developer and updated release notes.
- Performed sanity testing using post installation check using release notes and identified installation or code initial problems.
- Communicated with Project Management to establish LOE of each phase of SDLC and prioritized and mitigated QA task(s) efficiently.
- Ensured seamless transition for new and converted funds from implementation to production mode.
- Developed SQL Script to validate Data Transaction in Front End Testing via Toad and saved test result(s).
- Worked with peers in Development and other organizations to troubleshoot and resolve project issues both technical and non-technical in nature.
- Performed functional testing by deployment request, sanity testing, prioritized QA Test Cases within project plan.
- Performed Defect Root Cause Analysis, interacted with related Team.
- Coordinated with various Dev teams to explain all open defects in the defect review meeting.
- Used QC for process control, change control and defect log.
- Coordinated with build team members for subsequent code release for Bug fixing.
- Performed impact analysis and executed test scenario with Regression Testing.
- Involved in Back End Testing using UNIX Utilities and automated Regression Testing using Korn shell scripting.
- Involved in System Integration testing with external & internal interface team and performed E2E Testing.
- Assisted business & marketing team in execution of UAT by providing data.
- Involved in System Integration Testing with external/internal interface and understood overall customer business functionalities.
- Shared technical information with team, and involved in production testing with critical production problem.
- Interacted with QA Lead to provide daily QA status, discussed outstanding issue(s) and upcoming project functionalities.
Quality Assurance Analyst
Confidential, Basking Ridge, NJ
Responsibilities:
- Interacted with System Analyst to analyze business requirements to design and develop a Test Plan which adhered to the Testing methodology.
- Utilized Use Cases to cover all testable function in Positive & Negative Testing.
- Provided Test metrics on the results of system testing activities; coordinated and collaborated with others in analyzing collected requirements to ensure system development and implementation plans meet customer needs and expectations.
- Confirmed and prioritized project plans and deliverables per customer requirements and deadlines; stayed current on emerging tools, techniques and technologies related to software testing.
- Helped drive automation innovation (participated in testing tool analysis and/or reviews, assisted and/or trained other manual testers in automation, implemented recommendation to improve test automation).
- Developed SQL Script (Developed complicated SQL Script in Toad) to validate data, automated UNIX based process (Using Unix Utilities with Shell Scripting) and executed all test scenarios in minimal time.
- Set up Test Environment including refresh database from production, maintained test environment with upcoming release.
- Involved in key learning process after each release to implement process in future as a part of QA process Management., Kick Off Meeting and Release Management, Key learning Session.
- Assisted in continually improving our software development process and the development environment.
- Interacted with team to resolve daily issues in installation, code delivery, documentation, and defects.
- Involved in testing of multiple applications with QA, SIT and UAT testing by documenting, reviewing, resolving defects, follow up with interface sign-off.
- Supported Change Control by reviewing impact of all modules planned, all release schedules, and back out plan.
- Supported production support team in production Trouble Ticket to analyze root cause of problems and resolved with the team.
- Involved in production support testing assisted team in staging testing, support in change control request.
- Involved in different major and minor release testing by updating test plan with testing methodology, reviewed test results and analyzed defects and resolved with team.
QA Software Test Analyst
Confidential, New Brunswick, NJ
Responsibilities:
- Involved in the Review of Requirements Specification with functional manager and technical specialists of the application
- Design and execute Test Plans and Test Cases, generate Test Scripts and Test scenarios and baseline QA Test Plan.
- Prepared Test cases, according to the business specification and wrote test scripts and maintained them.
- Implemented the whole life cycle of QA methodology starting from planning, capturing, creating, executing reporting and tracking the defects using Test Director.
- Performed the Back end integration testing to ensure data consistency on front-end by writing and executing SQL statements on the database.
- Wrote UNIX shell scripts to automate basic script in regression testing to expedite processing all releases, in back end testing.
- Contributes to and monitors test planning, test preparation and scripting, test execution according to defined best practices, standards and procedures.
- Interfaces regularly with peers and management regarding test related topics including the coordination of test related initiatives with QA Test Leads, Project Managers, Development Managers, and other QA Core team members (SDLC Team)
- Participates in all phases of the IT Project Delivery Framework, including review of complex business and functional requirements.
- Assesses risk to quality service based upon results of verification and validation. Monitors adherence to established test standards and procedures. Standardized QA Process using Testing Methodology, Process Improvement.
- Expertise in Back End Testing and use of UNIX Utilities like awk, grep, sed, vi, network, process, file level, directory level, etc.), automation with Shell Scripting in data file validation testing. (Unix Log File Testing, Process validation, running process in background, etc.)
- Provides QA consultation services to support users of related test processes.
- Manages verification and validation activities for production modifications in production enhancement, interact with user, involved in automation of health check of application.
- Maintains document template libraries and internal project documentation like QA Test Plan, Local procedure(s), and Test Results.
- Organizes and/or facilitates team member training sessions in each new application to implement process.
- Participates in both internal and external process improvement projects like QA, SIT, UAT Testing with business & Marketing and External Vendors team.
- Strong Project Management skills like Test planning with LOE, test estimation and resource plans, Set up test environment
- Expertise with testing tools like QTP, JIRA, Quality Center and third party tool Toad, MQ Editor (IBM Queue Testing)
- Knowledge of relational databases like Oracle Database 11g to validate data testing in back end using complicated SQL script using Oracle functions.
