SUMMARY:

• 10+ years of Quality Assurance, Business Analysis, Data Analysis.
• Test Planning, Test Cases design, Test Environment setup, Test Data creation. Execute/Verify.
• Test Management using Target Process, Quality Center/ ALM, Vault, Jira, and Bugzilla.
• Test Types (Smoke, Component, Integration, Systems, Regression, Load, Performance, Browser - Compatibility, Comparison, XML Schema, 508 compliance).
• Extensive experience in QA (Black-Box, White-Box). Back-End and Front-End Testing.
• Experience in Test Automation using Java/Selenium/TestNG. Can work with QTP.
• Experience in Java using Eclipse.
• Object-Oriented skills in C++ and Java (Classes, Objects, inheritance, encapsulation, polymorphism, interfaces, and threads etc).
• Test-Deliverables manual installations, Automated Deployments using Octopus/Tentacle.
• Experience in Data Quality Checks using Informatica Developer, designing Mappings / Transformations / PDO.
• Experience in ETL Testing. Data Migration / Verification / Reconciliation / Merging from OLTP to common-format to OLAP.
• Experience in SQL scripting, stored procs, functions etc.
• Database normalization up to 3rd Normal Form.
• Data Warehousing / Data Mart, Denormalization STAR / SnowFlake Schemas (Fact/ Dimensions).
• ER diagrams, Functions, Stored Procedures, Views, Joins, Backup, Restore, Shrink etc.
• Hypervisor/virtual machine management. Services and Process management in dot NET.
• Requirement Engineering (Development, Change Management).
• SOA Middleware transactions, Message Queues (MSMQ Workflow Management/Service Broker) between BSS and OSS.
• Experience in Agile Scrum (Normal/Regulatory Sprints), Water Fall, and V Model.
• Protocols such as HTTP, TCP/IP, SSL, SNMP, SMTP, and UDP.
• Test Metrics, Test Plans, User Stories, Tasks, Test Cases, Test Summary Reports.
• Problem Solving, written and verbal communication, Mentor/ Training junior staff.
• Familiar with configuration/build management (Client Server SVN, Distributed GIT).

TECHNICAL SKILLS:

Operating Systems: Windows 7/95/98/2000, XP, NT, Linux, UNIX (Solaris)

Languages: PL/SQL, Java, C#, C++, Visual Basic 5.0/6.0, CSS, XML, HTML

Databases: Oracle 8i/9i/10g/11g, SQL Server 2005/2008/2012, MS Excel, MS-Access

Tools: TOAD, Informatica, SQL Developer, SQL*Plus, Oracle Data-Pump, Oracle Forms/Reports, Selenium/TestNG/, Bugzilla, Jira, QC/ALM, Test Director, QTP, Rational FT, Target Process, Eclipse, SQL Loader, Confluence, HipChat, SOAP UI

WORK EXPERIENCE:

Sr. QA Engineer

Confidential, Rockville, MD

Responsibilities:

• Perform testing on electric fusing-solution devices software.
• Update firmware(sofware packages) on simulated electric devices.
• Utilize Atlassian Jira for defect management.
• Utilize Atlassian Confluence for Requirement Management / Documentation.
• Create test-procedures and test-cases based upon Epics, User Stories, Dev Tasks/subTasks
• Utilize qTest for test case creation/management and execution.
• Perform Component, integration and regression testing.
• Utilize SQL DML for database transaction management (dBeaver/Casandra).
• Utilize Kafka message-queuing system for transaction processing (updating firmware on electric devices).

Sr. QA Engineer

Confidential, Columbia, MD

Responsibilities:

• Utilized Informatica Developer to perform Data Quality Checks.
• Designed extensive Informatica Mapping, by creating several Transformations.
• Incorporated reusability by creating Informatica Physical Data Objects either flat files or relational database.
• Utilized MicroStategy Reports to verify Data files received from heterogeneous sources (daily, weekly, monthly).
• Utilized Orion Job-Scheduler to upload Data from several different Client source files into staging environment, and migrate the data to Common Format, Pre-Load and Data-Warehouse.
• Performed ETL Automation Tests.
• Performed data reconciliation in Fact and Dimension tables.
• Investigate data inconsistency through Fact and Dimension tables.
• Create Test Data for QA purposes in SQL Server Environment.
• Resolve Client data issues through SalesForce tickets.

Sr. QA Engineer

Confidential, Columbia, MD

Responsibilities:

• Utilize Requirement docs, functional specs and flow diagrams to design test cases for Physicians and Hospital quality data verifications.
• Updated Requirement docs by incorporating Requirement Change Requests (RCRs) from end client.
• Generate SAS BI reports, using SQL, for physician quality data submission and validations.
• Designed Test Cases for data verification between OLTP and OLAP.
• Work closely with Project Manager / BA and perform detailed analysis of existing requirements, RCRs and provide input on inconsistencies/discrepancies, duplications and redundancies.
• Conduct Peer Review meetings and Provide gap analysis to Dev/BA and QA teams.
• Performed QA Automation using Selenium / Java / Eclipse.
• Performed 508 compliance testing.
• Upload test cases from excel sheets to ALM, Map requirements to test cases, generate Requirement Traceability Matrix. Utilized informatica for Data Quality Checks.
• Execute tests in ALM, identify, log and manage defects.
• Communicate with internal teams on functional requirements of GUI, screen, interface design, access and EWR etc.

Sr. QA Engineer

Confidential

Responsibilities:

• Utilized Selenium Web-driver to automate QA practices.
• Utilized Selenium for data-driven testing, taking parameters from excel database and plugging in web elements of browsers, updating Oracle database.
• Designed Automation FrameWork using Selenium (KeyWord-Driven + Data-Driven).
• Created Test Plans, Test Case for web-based / mobile advertising applications.
• Ensured the results compatibility on multiple browsers/mobile-devices and MAC.
• Clarified client requirements, business needs and project objectives in team meetings.
• Wrote SQL queries to verify data/results.
• Coordinated with BA/PM in order to ensure the deadlines are met and defect-free products are delivered.

Lead QA Engineer

Confidential

Responsibilities:

• Re-engineered database design in order to automate HealthCare Claim Processing.
• Designed SQL queries and sub-queries to isolate healthcare provider categories and create batches.
• Sent Claim records in batches to web server for processing, through API tickets, and created stored procedures and database views to collect the results.
• Verified data with inner and outer table joins and performed base-line comparisons.
• Linked Excel sheets with the relational databases and perform conditional formatting to extract and present data in a user-friendly Report format for analysis.
• Ensured that HealthCare Claim Reimbursement Applications performed according to the CMS standards and guidelines, in a distributed environment with diverse databases such as Oracle, SQL-Server, Access and Excel.
• Utilized Data-Pump/TOAD/SQL-Loader/bulk-copy to make structures/data of SQL-Server database compatible with Oracle database.
• Performed installations, backups and restoration of relational databases.
• Manually installed Web Applications / Databases and Utilized Octopus/ Tentacle for Automated web-server deployments.
• Utilized and maintain virtual machines in a hypervisor environment.
• Installed IIS Web Server/ Web Service/ Web site, Web Client.
• Installed SQL-Server (create static and dynamic databases and logins), Message Queuing Service (MSMQ Server install and uninstall), Pricing Engine (Back-End Processes installation and creating connection strings with the databases).
• Created Test Procedures and placed them in appropriate directories to assist team members.
• Clarified client requirements, business needs and project objectives in team meetings.
• Utilized user-stories, code, and logic flow diagrams for black box and white box testing.
• Designed and executed QA procedures for HealthCare web applications
• Provided Process Improvement and Automating testing practices.
• Verified Workflows through MSMQ message ID’s and Correlation ID’s.
• Utilize VAULT and Target Process for user-stories, tasks, bug reporting, and test management.
• Extensive Test Case Design and execution based upon user-stories.
• Created customized-models to suppress the default behavior of the enterprise application.
• Identified and reported flaws/improvement areas and made recommendations.
• Trained, assisted and mentored junior staff.

Technical Environment: Selenium/Eclipse, Agile Scrum, MS Excel, SQL, Oracle, SQL-Server, Target Process, TOAD, SQL Loader, Bulk Copy, VMWare

Senior QA Analyst

Confidential

Responsibilities:

• Provided services to clients such Home Depot and Holt Renfrew Ecommerce Retail Web Application, in Agile Scrum framework.
• Technical areas involved Custom websites, Catalog Browsers, Flyers and posters for retail clients.
• Transformed business requirements into functional requirements.
• Assisted PM in creating project plan and weekly report template, demonstrating work progress, with achieved milestones and timelines.
• Incorporated Accessibility requirements and testing in the application.
• Performed mobile and cross browser compatibility testing using 6 different browsers.
• Performed functional and non-functional testing.
• Extensive Test Case Design and execution based upon wireframes and requirement documents.
• Performed integration, system, interface, regression and production testing.
• Utilized SOAP UI for web services X-PATH verifications.
• Utilized Selenium web-driver with Eclipse for browser automation.
• Utilized Selenium for data-driven testing / Eclipse (Java) to automate testing practice.
• Incorporated IE driver and Chrome Driver for multiple browser automation testing.
• Wrote Java classes that picked up parameters from excel sheets to automate web applications.
• Incorporated Selenium (external Jar files) along with JDK jar files to utilize classes and functions for automation.
• Incorporated Apache POI jar files to manipulate excel rows and columns for data driven testing using Selenium.
• Communicated with internal and external teams on functional requirements of GUI, screen and interface design.
• Performed research on J2EE based B2B e-commerce enterprise retail applications.
• Clarified client requirements, business needs and project objectives in team meetings.
• Identified and reported flaws/improvement areas and made recommendations while comparison with competitors.
• Created Test Cases and Use Cases based upon wireframes and requirement documents.
• Incorporated alternate flows in use cases.
• Performed systems testing, wrote regression testing scripts using Rational FT, QTP.
• Utilized VMware for additional IE browser testing.
• Utilized Bugzilla/JIRA for test management, and MS Visio for workflow diagrams.
• Compiled business requirements while collaborating with marketing department and utilizing wireframes.
• Trained, assisted and mentored junior staff.

Technical Environment: Selenium, Apache, Eclipse, Agile Scrum, QTP, MS Excel, SQL, JIRA, Java, JQuery, Ajax, VMWare

Confidential

Responsibilities:

• Gathered requirements and created functional requirements based upon Business Requirements.
• Developed test cases and test data based upon customer requirements and implementation specifications.
• Developed Test Plan (scope, test-deliverables, item pass/fail criteria, techniques and specifications) for telecom middleware (BSS/OSS), three-tier J2EE application.
• Established and documented all possible business scenarios, and negative testing.
• Incorporated messaging rules for client programs and middleware services.
• Wrote Unix K-shell scripts for regression and load Testing.
• Wrote Unix K-shell scripts by Placing land line and cable provisioning transactions in a loop to see at what point the system breaks.
• Wrote Unix K-shell scripts for regression testing by placing transactions in a logical manner to see the provisioning takes place for inserts updates and deletes.
• Set-up test environment by installing the tar files on Unix Sun Solaris platform.
• Ran Unix scripts to create Oracle database schemas, tables and to populate the tables.
• Utilized SQL DML for database clean up procedures.
• Configured Unix environment to access the desired Oracle database instance.
• Performed Black-Box component, integration and systems testing using test drivers/stubs.
• Wrote Korn shell scripts for Regression and Load testing.
• Generated test summary reports, using MS Access, expressing expected test results Vs actual results, unresolved and closed issues.
• Identified and documented any unresolved issues in the defect tracking system.
• Notified developers of necessary changes or bugs.
• Utilized Test Director for test cases design, execution and defect management.
• Modified existing test cases as per End-User-Requirements.
• Escalated and resolved defects by assigning and interacting with development and configuration teams.
• Methodically documented all details while reporting or interacting with SME’s.
• Performed Smoke and Regression testing for all new bug fixes, enhancements and release-cycles.
• Performed Security and Performance Testing on all new application versions and test environments.
• Participated in upgrading of Test Director to HP Quality Center.
• Participated in risk analysis of Integrated Broadcasting Management application.
• Participated in preparing Test Summary Reports, after each regression and smoke test cycle
• Executed change requests.

Technical Environment: C++, Java, Oracle, Unix, MS Excel, SQL, Test Director 8.0, HP QC9, Citrix