SUMMARY:

• Completed all projects within stipulated contract periods with consistent high - quality, on-time deliverables.
• 6 plus years of Systems, Functional, Regression, Integration, Performance, Load, Security and Usability testing of web and standalone applications within waterfall, agile (scrum / kanban), RUP and iterative SDLC methodologies using test automation.
• 4 plus years of all-round information technology experience in SDLC lifecycles/ Bus architectures encompassing Data Warehouses, Data Marts, OLAP, BI, Web and Client/Server applications, solutions under Mainframe, Unix & Wintel environments.
• Proficient in Test Automation and White box, Manual, Hybrid and top down testing methodologies.
• Heavily involved in requirement revisions, functional and design specifications, developing and executing test cases along with reporting findings.
• Solid experience in interfacing with business users/customers in elucidation of business requirements and translating them into high level and detailed level design documents.
• Worked in Big Data framework (Hadoop, Hive, and Pig) and cloud technologies (AWS).
• Worked in various information source systems like Oracle, DB2, Sql Server, MySQL, Postgres and delimited Flat files.
• Proficiency in SQL, PL/SQL features along with bulk load utilities like Sql*Loader.
• Strong advocate of process improvement by implementing & extending best practices and standardization in design, development, testing, artifact documentation and change control process wherever possible thereby increasing ROI.
• Proficient in various UNIX flavors, wrappers and Bash shell scripts.

TECHNICAL SKILLS:

QA/Automation Tools: Selenium Webdriver, Selenium Grid, ALM 11.52, Quality Center 9.0/10, UFT 11.5, QTP 9.2, SQL, PL/SQL, ClearQuest, Karma, Jasmine, Protractor, Qunit, junit, TestNG, ant, Cucumber, Saucelabs, Appium, JMeter, SoapUI

Programming Languages: JavaScript, Core Java, Python, Shell Scripting, Node.JS, VBScript

Databases: Oracle 7.x/8.x/9i/11.0.2g, DB2 8.2, SQL Server 6.5/7.0, MS Access, MySQL 14.14, Postgres 9.0

Reporting: Pentaho Interactive Reports, Business Objects 3.1

Miscellaneous: AWS (S3, EC2, RDS), JIRA, Git, Toad, Remedy, Pl/SQL developer, JIRA, subversion, IntelliJ, Eclipse, Jenkins. Postman, JAMS, Cygwin

Web Technologies: HTML, CSS, JavaScript, Bootstrap, jQuery, json, xml, SOAP, REST, HTTP

Operating Systems: IBM AIX, Sun Solaris, Windows NT/2000, Linux

PROFESSIONAL EXPERIENCE:

Confidential, Rockville, MD

QA Analyst (Contractor)

Responsibilities:

• Extensively leveraged and enhanced BETA (BackEnd Test Automation) which is an in-house automation framework built in python, JDK and xml.
• Completely automated fully functional regression test suites for several complex patterns like LOD (limit order display) and cross market patterns which run 24/7.
• Provided efficient coverage of business requirements using risk based testing reducing test cycle’s duration to half.
• Load tested REST calls using both JMeter and python's “requests” and “threading” modules.
• Automated testing REST APIs via curl and frisby (Node.JS) and used “postman” for one-time checks.
• Researched and adopted efficient testing techniques (like all-pairs, equivalence partitioning, boundary value analysis, exhaustive production scenarios) to provide sufficient test coverage with absolute minimum number of test cases.
• Acted as liaison between business end users and development/test teams and played a major role in core design team (business side) with emphasis on technical impacts /limitations/dependencies.
• Frequently wrote Sql and shell scripts using regular expressions, checkpoints, feature enhancements to reduce/eliminate manual testing efforts.
• Designed Functions Library, Functions, Subroutine's, Common functions, Utilities functions, and Regular Expressions and Environmental variables using UFT (QTP) in VBscript as part of Automation Infrastructure Development.
• Actively participated in sprint planning sessions and provided clear, concise and exhaustive list of QC tasks per story with proper estimates.
• Performed test reviews (RTM style) early in test cycle to resolve requirement ambiguities and captured several defects before rollout to UAT and prod.
• Reviewed code and used static code checkers to analyze code for hardcoded values, incorrect joins, partitioning, security vulnerabilities and suggested improvements.
• Extensively used UFT (QTP) Integrated Environment (Step Generator, Synchronization, Actions, Recovery Scenarios and Methods) and configured shared object repositories.
• Performed data profiling on production objects and used open source tools for large volume test data generation for performance and integration tests.
• Tested Webapp for vulnerabilities like css injection and cross side scripting.
• Unit tested JavaScript code using Karma & Jasmine also familiar with Qunit and Mocha
• Participated in candidate interviews as part of building strong teams.
• Worked in company’s Big Data and cloud initiative and automated Hadoop framework extracts and ETL on AWS (amazon web services).
• Well maintained test artifacts (test plans, test scenarios, test strategy on subversion with version control as part of audit readiness and ease of knowledge transfer among team members.
• Designed a testing strategy to separate calc engine & GUI testing & end user pentaho reports (data and format) testing in parallel reducing test cycles by 60%.
• Developed several hive scripts as part of testing ETL jobs via AWS EMR.
• Completed the data profiling exercise at the inception of project and suggested several data model change control requests through ClearQuest.
• Owner of testing Aggregation process which is key for PDS and developed a test bed with easy to run test cases enabling painless test cycles for junior testers in the team.
• Involved in QA automation along with producing ST artifacts (Test Plan, Requirements Traceability Matrix, Test Summary and Detailed reports) and facilitated in PRR (Production Readiness Review), DTM preparation (Deliverable Traceability Matrix) and Audit process.
• Worked on “Test Oracle” parallel development process solely from business requirements using command line and SQL.
• Supported the automation framework which ties QC to result generator (Test Oracle) which uploads the mismatches between Dev vs Test enabling fast efficient testing process.

Environment: Oracle 11g, Netezza 7.0, GreenPlum 8.2.5, HPUFT 11.5, HPQC 11, Sun OS 5.10, Linux 2.6.32, IntelliJ, Eclipse SDK, Amazon Web Services (S3, EC2, EMR), Hadoop 2.0.0, Hive 13, xml, Apache Ant 1.9.2, JDK 1.6, JIRA 6.3, Jenkins

Confidential

Test Engineer (Employee)

Responsibilities:

• Created process flows and source to target documents to map complex ETL transforms which read disparate data sources (csv files from 3rd party tools, flat files, PeopleSoft views).
• Generated RTM (Requirements Traceability Matrix) mapping unit test cases and business requirements.
• Designed and developed a test strategy to translate frequently changing requirements from upstream and downstream teams to develop ETL routines.
• Wrote shell scripts/ wrappers for execution of processes and actively involved in implementation and migration.
• Actively involved in answering business queries and educated users on all round aspects of system functionality for their reports.
• Supported quick turnarounds to address ad hoc business requests with customs sqls and unix/python scripts.
• Developed a system test strategy for FRM10 application covering outlines, load and data rules, calc scripts, uda’s and functions using cell to cell compare between all possible multidimensional intersections.
• Involved in requirement revision process and suggested several changes in business requirements enabling ease of transition to design and development and also maintained thorough documentation of intermediate SDLC deliverables which reduced turnaround times while working under concurrent applications.
• Involved in debugging and backtracking account discrepancies by maintaining one version of truth between three different applications as part of integration testing.
• Actively participated in code reviews, developer peer reviews and design walkthrough’s.
• Involved in cross browser testing & GUI interface testing at client side using QTP for custom UI’s and Webapps.
• Performed data analysis and produced data flow, process flow and what if scenarios.
• Inserted verification checkpoints, synchronization points, and parameterized data using QTP.
• Handled different kinds of roles like Systems Tester, Data Analyst, and Developer on need basis to meet the stringent deadlines having company’s highest priorities in mind.
• Tested Complex transforms involving very dynamic requirements to derive new fields and in corporate business logic.
• Involved in all phases of testing, from dummy data creation to unit wise testing and created comprehensive documentation both process wise and implementation wise following better software practices.

Environment: Selenium, QTP9.2, Quality Center 10, EME, Clear Quest, Co>OS 2.14.77a, Oracle 11g/9i, Sun Solaris 8, Ksh, Pl/Sql developer, Business Objects XI 3.1, Crystal Reports 2008, Hyperion Essbase 9.3.1, Hyperion Excel Add-in, Rational RequisitePro, Clear Case, Toad for Oracle