SUMMARY:

• Over 18 years of experience in software testing,
• Over 15 years of experience in back - end testing.
• 5 years of Confidential domain experience spreading over to 3+ Confidential programs including nearly 2 years of experience on Confidential Foreign Account Tax Compliance Act (FATCA) program.
• Substantial knowledge of test tools, methodologies, and approaches.
• Extensive experience in building Testing Frameworks using multiple test automation tools and platforms.
• Expert-level knowledge experience working with Rational Tools
• Over 7 years of experience working on healthcare projects in both public (state and federal) and private sectors.
• Extensive experience with writing and analyzing business rules, program/business, user functional requirements as well as non-functional IT requirements.
• Additional Confidential Enterprise Architecture experience
• Practical knowledge of Service Oriented Architecture
• Experience testing web services (both SOAP and REST)
• Working experience with Informatica and Big Data databases.
• Extensive knowledge of data analysis including data mining, data mart and working with non-normalized data wear-houses.
• Motivated team player with excellent communicational skills.
• Expert level SQL skills

STANDARDS/METHODOLOGIES:

• Agile
• Waterfall (Traditional)
• Section 508 Compliance
• Enterprise Life Cycle (ELC)
• RUP

TECHNICAL SKILLS:

Databases: Oracle 7x/8x/9x /10G/11G (DBA level administration, data architecture, installation, setup, querying, scripting, logical and physical data design), MS Access 2.0/7.0/8.0, MS SQL Server, Green Plum, Paradox

Operating Systems: UNIX Sun/HP/AIX (shell/perl scripting, admin, setup), Windows NT/ 95/98/2000/2003/ XP/Vista/7

Automated Test Tools: QTP (proficient scripting, admin),HP Quality Center (user, admin), Load Runner, IBM Rational Robot (proficient scripting, admin), IBM Rational Manual Tester (user, admin, installation), IBM Rational Functional Tester (proficient scripting), IBM Rational Requisite Pro (user, admin, installation), IBM Rational ClearQuest (user, admin, installation), IBM Rational ClearCase (user), IBM Rational Team Concert, IBM Rational Quality Manager, IBM Rational Requirements Composer.

Empirix E: Test Suite (user, admin, installation), Team Track (user)/ PVCS Tracker (user), DOORS (user), StarTeam (user)

Languages/Development/Software Tools: PL/SQL; SQL; SQL*PLUS, TOAD/SQL Developer/Pg Admin, XML and XPath, JSON, Visual Basic and VB Script, Perl, Shell Scripts, SQL Loader

ETL (technology): Java (only as pertaining to RFT and Junit tools), Informatica (Power Center and DVO), Tableau, SharePoint (user), MS Office, MS Project Visio

PROFESSIONAL EXPERIENCE:

Confidential

Senior Automated Tester/Test Architect

Responsibilities:

• Developed keyword-driven test architecture employed for testing Artificial Intelligence (AI)-based Safety Unmanned Aerial Vehicle (UAV) application utilized to protect and defend major potential target points in entire Washington DC Metro area with drone swamp sketch.
• Test architecture consisted of single Rational Functional Tester (RFT) script running based on RFT libraries and invoking over 100 test cases written in CSV format.
• Automation framework included integration with multiple Oracle and GreenPlum databases.
• Test cases were developed based on multiple Test Plans and stored in Rational Quality Manager (RQM) test suite.
• Applied Rational Requirement Composer (RRC) to store business and systems requirement, and to utilize real time stakeholder comments.

Confidential

Enterprise Solution Architect

Responsibilities:

• Developed content for technical sections of Solution Architecture (SA) documents for FATCA Releases 3.0, 4.0 and 4.1.
• Developed data architecture and technical architecture contents for Release 5.0 SA document.
• Utilized Enterprise Architecture Guidelines (EAGs) to create static diagrams specifying communication protocols, messages types and communication types for every integration point defined in Integration Control Documents (ICDs)
• Employed ESB Design Patterns utilizing Web Services Development Guidance Document
• Developed a set of architectural diagrams for FATCA End-2-End, ICCM, FI Registration and W& R systems for FATCA releases 4.0 and 4.1
• Worked closely with Business Architecture teams to identify any requirement/business use cases gaps and to align all the sections within Solution Architecture document.
• Participated in FATCA R5.0 Coordinated Sessions initiated by Large Business & International (LB&I)
• Developed Solution Concept for Release 5.0 including architectural alternatives
• Facilitated technical brainstorming session within internal Release 5.0 team.
• Participated in technical deep dive sessions with different client teams within an Confidential .
• Proposed design of new common services, including Enterprise Identity Verification Environment (EIVE) service to manage Confidential identifiers.
• Participated in developing Service Oriented Architecture (SOA) target approach that defined data access, business and presentation layers.
• Developed data architecture and technical architecture sections for Release 5.0 SA document.
• Developed FATCA 5.0 architectural diagrams for SA document, outlining new systems, integrations and functionality.
• Managed FATCA-related Interface Control Documents (ICDs).
• Performed analysis and assessment of Tableau software for use as a future Confidential Data Reporting Analytics tool.
• Facilitated working sessions with Business Architects from Enterprise Architecture team.
• Led development of Logical Architecture, Infrastructure Architecture and Environments sections of FATCA Program BSR 5.0 and 6.0 document.
• Converted business use cases into system use cases.
• Incorporated existing Confidential functionality, such as Enterprise TIN Validation and TIN Discovery Services, and Negative Tin Service (NTIN) into FATCA design.

Confidential

Senior Tester/Business Analyst

Responsibilities:

• Assisted testing team to develop test conditions based on requirements and use cases.
• Worked closely with stakeholders to develop and manage new and existing Business and Customer requirements using Requisite Pro.
• Analyzed existing requirements: identified ambiguous and requirements and fixed them.
• Identified gaps in existing requirements and created new requirements to close those gaps.
• Identified duplicate parent requirements and aligned its children requirement with a right parent
• Created test cases to ensure that SOA/WSDL requests sent from AFA Web Portal into AIR got stored in AIR Database and generated correct synchronies and asynchronies responses
• Consulted automation team regarding Rational Functional Tester use for automation of AFA Web test cases.
• Created Use Cases and Process Flow diagrams.
• Reviewed DSRs, BSRs and ICDs.
• Created testing strategy for testing AIR 4.1 and 6.2 utilizing Confidential Internal Revenue Manual (IRM)

Confidential

Senior Back-End Tester

Responsibilities:

• Analyzed BMF, BRTF, CDR, CTW, EPMF, FATCA, IRDB, IMF, IRMF and IRTF systems.
• Employed Excel Data Plug-In to perform data analysis to identify differences between data in Source and Target databases.
• Configured Power Center Manager to execute workflows and Power Center Monitor to track errors. Informatica Power Center was used to automate ETL testing process.
• Utilized Rational Quality Manager and Requisite Pro to link requirements to existing test case
• Managed suspect links
• Utilized RQM to write test cases to test IPM and IRDB tables’ database structure.
• Developed QA Process Improvement document and introduced them to Project Manager and stakeholders. Document was approved by upper management and most items were utilized.

Confidential

Senior Back-End Tester

Responsibilities:

• Co-Led Coverage Data Repository (CDR) project level effort (as part of Confidential Release 4.0) CDR Oracle Data Repository serves a central database created to obtain and store submissions from Center of Medicare and Medicaid (CMS) and Human Health Services (HHS) agencies.
• Created User Stories.
• Worked with stakeholders to create a Mapping and Transformation Rules documents specifying business rules for data mapping between Exchange XML files (and its elements) and multiple schemas of CDR database.
• Developed test cases in Rational Quality Manager (RQM) to ensure data migration process completed successfully by running Oracle queries and validating its results against source XML data based on Transformation Rules defining XML Elements based on pre-defined XPath’s.
• Create Oracle SQL scripts to validate ETL process in between CDR Staging and CDR Exchange database schemas.
• Manage everyday team activities using Rational Team Concept (RTC).
• Utilized Rational Clear Quest to store defects and change requests.
• Attended sprint kickoff sessions and facilitated scrum and stand-up meetings.
• Trained junior team members on all business and technical aspects of CDR project.

Confidential

Senior Automated Tester

Responsibilities:

• Designed business rules for keyword-driven, object-based automated framework, which allowed an automation of over 30 critical ICE applications in less than 6 months period (Robust framework greatly minimized amount of code needed to be written in Quick Test Pro (QTP) as functions were developed for object classes as opposed to individual objects)
• Performed data analysis and helped to create data staging QTP module using Enforce application which were used across ICE application by the testing team
• Managed daily execution of QTP batch, consisted of over 300 automated test cases and configured it to run under different versions of application systems.

Confidential

Senior Test Automation Architect/Back-End Tester

Responsibilities:

• Designed and implemented automated architecture using keyword-driven framework (standard set of Quick Test Pro (QTP) libraries, Windows API libraries, Excel spreadsheets, which included test actions and verifications, data inputs, actual and expected outputs and database queries and scripts; Single script serves as main engine in a middle of framework and kicks off a batch set of over 600 regression test cases.)
• Automated batch run can be triggered at any time and can be auto-scheduled from Windows with any number of regression test cases included
• Developed QTP database libraries to allow QTP’s communication with Oracle databases (of different versions) via ADO to allow execution of SQL Queries and Oracle scripts
• Designed ‘single configuration concept’ which allows to store all server, database and web addresses information in a single configuration file in a fully secured decrypted view; which allows for multiple machine to run automated batches against multiple environments in parallel
• Performed Data Migration and ETL testing on over 10 large databases including IDENT ( Confidential -owned), Enforce and VIMS (FBI-owned)
• Managed multiple test databases and assisted Test Team of more 40 people with Oracle installations/configuration and creation of complex SQL queries and SQL scripts
• Modified and ran Perl scripts (in UNIX environment) with embedded SQL calls
• Created XML and XOP messages, sent them via SOA requests to IDENT databases and ensured its synchronies and asynchronies responses.
• Helped to integrate QTP with HP Quality Center 8.2 and 9.2
• Developed detailed Rational Robot and Rational Functional Tester documentation to serve as a for government users of Rational Robot, ranging from beginners to advanced users
• Developed object hierarchy, including asset registries, test plans, file locations and configured test cases in Clear Quest Test Manager
• Developed a document to train end user in integration between Rational Test Manager and Requisite Pro.
• Developed and tested integration between Clear Quest Test Manager and other Rational testing tools, including Rational Functional Tester 7.0 and Rational Manual Tester 7.0
• Managed Performance Testing efforts to New Portal Interface (NPI) project using Rational Robot VU, Rational Performance Tester and Rational TestManager
• Provided full support to end-users of IBM Rational Products

Senior Business Analyst

Confidential

Responsibilities:

• Led verification and validation effort of various versions of company’s flagship hc2 (Hybrid Capture) product, meant to produce and report results of DNA and RNA tests for human papillomavirus (HPV) disease, used for Cervical Cancer prevention
• Developed Requirement Traceability Matrix (RTM)
• Developed use cases for the Research and Development team use
• Created test plans and subsequent test cases for the UL release of hc2 and LumiCheck Products utilizing use cases.
• Performed product integration testing to ensure safety and proper communication between software and plate measuring instruments
• Evaluated HP, IBM/Rational and Borland’s automated test tools including but not limited to Quick Test Pro 9.0, Rational Robot, IBM Functional Tester and Borland SilkTest and presented comparison report to the Software Director
• Developed and outlined Mercury’s Quality Center requirements gathering and QA processes for company needs.
• Designed automated scripts using Quick Test Pro (QTP)

QA Lead

Confidential, Bethesda, MD

Responsibilities:

• Participated, as part of company’s tiger team, in creation of business rules.
• Managed a team in development and execution of test plans and test cases for multiple Automated Underwriting and Desktop Underwriting application based on business rules.
• Performed full evaluation and comparison of IBM and Mercury automated test tools as a founder of QA group
• Set up Rational Functional Tester repositories and projects
• Designed and executed Rational Functional Tester scripts for multi-clients projects using Functional Tester Applied Java commands and statements into automated scripts where needed
• Developed Oracle queries to test front-end data
• Developed and executed Oracle SQL scripts to manage data in QA and UAT environments
• Utilized Team Track bug-tracking and management tool

Senior Member of Technical Stuff: Database and Test Automation Specialist

Confidential

Responsibilities:

• Managed testing teams including scheduling, work assignments, and assignment breakdowns
• Developed test approaches, methodologies, processes as well as plans, cases, and scenarios for all required levels of QA including Integration, Regression, System, and User Acceptance Testing of required applications
• Designed Rational Robot automated test scenarios using ‘keyword driven methodology’ to test large government military healthcare system (CHCSII)
• Participated in the database design, modeling, and normalization
• Designed stored procedures and triggers, using PL/SQL, served to test financial applications
• Executed batch jobs by executing Unix shell scripts on daily basis
• Executed multiple Unix scripts that were used to call SQL scripts, migrating data from Production to Test databases

Database Administrator

Confidential, Rockville, MD

Responsibilities:

• Performed daily DB monitoring, data quality analysis, debugging, tuning, performance, and storage management responsibilities
• Maintained 5 parallel versions of Development, Test, and Production databases on Unix and NT platforms
• Migrated data from Development to Test database using Import/Export utilities and SQL scripts
• Performed system analysis and design activities to develop working solutions using PL/SQL, SQL and SQL Plus
• Created automated scripts using Rational Robot to test an application including normal application flow, database connectivity and database clean-up