SUMMARY:

• IT Professional with 12+ years experience in Quality Assurance of Software application including ETL, Telecom, complex financial systems, ERP, SAS, web based GUI and Client/Server Applications.
• Expertise in project management life cycle, Functional testing & Integration/ system testing, documentation, preparing test plans, test conditions and test scripts.
• Proficient in identifying business rules, functional capabilities, and business events, relating business rules to the process model, and developing an event model.
• Experience in testing SOA (Service Oriented Architecture) web services deployed on Weblogic 10.3 using Parasoft SOA tool, Soup UI and HP Service Test.
• Experience in using the Rational Tool set such as Clear Quest, and Functional Tester
• Experience in testing Weblogic/Websphere technology and its application within the Enterprise Middleware environment.
• Experience in testing technologies like JAX, Oracle Service Bus, and MQ Series.
• Experienced in software analysis, requirements management, quality assurance, configuration management and change management.
• Experience in the analysis of user needs and the development of practical measurements that evaluate the adequacy and accuracy of new system processes
• Experience as QA Teat Lead working on large software development projects
• Involved in performance testing of major E - commerce weblogic applications.
• Experience building framework for HP Automation tools like Load Runner, HP Service Test, QTP
• Basic knowledge of Java weblogic components like JDBC, JMS, Clustering,
• Experience in performing System Integration Testing (SIT), User Acceptance Testing (UAT), Integration Testing and Regression Testing.
• Excellent understanding of the System Development Life Cycle. Involved in analysis, design, development, testing, implementation, and maintenance of various applications.
• Extensive working knowledge of Human Services Programs like Medicaid, Temporary Assistance for Needy Families (TANF), Supplemental Nutrition Assistance Program (SNAP), and Low Income Home Energy Assistance Program (LIHEAP) and understanding their business policies
• Experience in coordinating deployment of complex J2EE applications on application servers like Weblogic, Websphere etc.
• Good Experience working with various Heterogeneous Source Systems like Oracle, Teradata, MS SQL Server, Flat files and Legacy Systems.
• Well experienced in using Enterprise Metadata Environment.
• Experience in working with DBMS Utilities such as SQL, PL/SQL, TOAD, SQL Server and Teradata SQL Assistant.
• Experience to develop, write, and review business requirements, test plans and test cases/scripts
• Very good knowledge of XML/Schema
• Good experience in testing business applications in Client/Server environments on Windows and UNIX platforms.
• Very good experience to work/collaborate with technical staff, program subject matter experts, stakeholders, and vendors to clearly communicate defects and system changes
• Motivated the team in achieving the set up goals and targets.
• Working experience in Agile and onsite off shore model projects.
• Expertise in developing and maintain overall test methodology and strategy, documenting Test plans, RTM, Test cases and executing Tests cases based on baseline requirements.
• Experience in testing Sun Identity Manager, Sun Role Manager, Microsoft Active directory, Microsoft IDM tools.
• Experience in testing ETL, WEB, GUI, Client Server and ERP Applications.
• Good team worker and has ability to understand and adapt to new technologies and environments.
• Experience in using JIRA and Version one tools for updating stories, tasks etc

TECHNICAL SKILLS:

ETL Tools: Ab Initio>OS (2.15/2.13/2.12. x/2.10.x),GDE (1.15/1.14/1.13/1.12/1.10 )

Databases: ORACLE 8.x/9.x/10 g, Teradata, DB2 UDB 7.8 EEE, SQL Server 7.0/2000, MS Access 97/2000.

Modeling Tools: Teradata V2R3/R4, Erwin 4.0, Oracle Developer/2000 & Designer 6.6.0

OS: UNIX, Windows 98/2000/NT, MVS.

Version Control Tools: Ab Initio EME

Test Automation Tools: Rational Functional Tester, QTP and Load Runner

PROFESSIONAL EXPERIENCE:

Confidential

Test Coordinator/ Test Lead

Responsibilities:

• Design and develop project plans that fully encompass the scope and objective of the test engagement.
• Construct an over-arching test strategy that covers all documented requirements/phases of the project lifecycle.
• Identifies, advocates and implements continuous enhancements to processes and procedures to improve staff effectiveness.
• Provides test event recaps/overviews, discusses test process successes and opportunities for improvement, and makes recommendations for action items; promotes continual improvement
• Insure testing focus remains focused on the delivery of quality software while meeting agreed upon test completion dates/milestones
• Advanced interpersonal skills to build and maintain strong partnerships with National IT technical managers and staff, application developers and strong working relationships with business lines
• Construct a Test Plan that covers all documented requirements as well as negative/positive test cases discovered during application walkthrough/learning phase (pre-test)
• Participate in product spec/design reviews to provide input on functional requirements, product designs, schedules, or potential problems regarding testability.
• Develop or specify standards, methods, or procedures to determine product quality or release readiness.
• Maintain documentation of test plans and their results using a test case management system.
• Study the issues escalated by customers and modify the system test scripts to reproduce the issues.
• Log software defects using a bug tracking system and work closely with software developers to analyze the defects and track them to resolution.
• Automated test cases using the test harness; contribute to the automation framework via coding and design

Confidential

BSA/QA Lead

Responsibilities:

• Defined and documented all Testing Processes based upon analyzing the business requirements and system specifications of the application
• Created Test Script categories and received sign off from the BSA and PM
• Prepared Test Case Template, upload some sample conversion test scripts based on the business requirement, data mapping, functional design, use cases design documents
• Build variation of test cases with conditions based on business rules in MF to validate the data after the Conversion run
• Created regression suite leveraging existing test sets and added new scenarios based on walkthrough session upon BSA and SME approval
• Responsible for leading the testing team consist of 10 members in managers absence
• Conducted Functional, Integration, UAT within QA development and Staging environments
• Set up Access in following tools: (MF test ) Mapper 05 and (MF Staging ) Mapper 06, Test Links, all the locality FIPS for Agencies, Clear Quest
• Facilitate with Tech lead to ensure all interfaces ( DIS, VDSS, DMAS, Federal HUB) are connected and working prior to testing
• Provided overview of scripts and demo to new team members to speed knowledge transfer process
• Participated in Daily Defect Tracking Meeting with Client and Vendor to discuss (Critical/ High / medium) Defects and quick resolution of action item
• Developing test scripts based on system requirements/Use Cases
• Executing test cases and logging defects in defect tracking tool (Clear Quest)

Confidential, VA

QA Lead

Responsibilities:

• Responsible for all critical deployments and Interact effectively with senior leadership team to communicate on issues and results.
• Responsible to Build Performance Test Suite using Load Runner
• Responsible to test SOA (Service Oriented Architecture) web services deployed on Weblogic 10.3 using Parasoft SOA tool, Soup UI and HP Service Test
• Participated in weekly DRB (Defect Review Board) meetings and responsible to own the defects.
• Preparing Business Assurance Strategy document and getting approvals from Business owners.
• Reviewing System Test cases in ALM based on the System Requirements and the detail design documents and Source to target mapping documents.
• Requirement Traceability Matrix (RTM) is created to trace all the system requirements to the test cases. The tracing of requirements to the test cases was done in Quality Center
• Worked on Up gradation of WebLogic 8.1 and 9.2 to 10G using Upgrade scripts
• Deploy the Web and Enterprise Applications in Production Environment by using WebLogic Console, Command-Line and Scripts.
• Migration deployments of mobile, enterprise and web applications on WebLogic Clustered environments.
• Taking Care of Customers (Change Management, Problem Management and Incident Management) Request by using HP Service Centre.
• Configuring Managed Servers, Node Managers, Clusters and Various resources like JDBC and JMS Resources to the WebLogic Server.
• Configure Data Source and Multi Data Source for Oracle Database Connectivity.
• Being an escalation point of contact, resolving Production issues and providing quality alternative solutions to challenging and new problems.

Environment: WebLogic Server 8.1/9.2/10/10 gR3, Aqua Logic Service Bus 2.6.X/Oracle Service Bus 10gr3, HP Quality Center, HPSM, Sitescope Monitoring Tool, WebSphere Application Server ND 5.x and 6.x, WebSphere MQ 6.0, Apache WebServer 2.0, Oracle 10g Database Aqualogic BPM, HP BAC 7.54, HP Diagnostics Server 8.05 and Red Hat Linux Machines.

Confidential, VA

QA Lead

Responsibilities:

• Participated in Business Analysis, Technical Requirements and High level System Design Document Reviews.
• Used Ab Initio to extract, transform and load data from multiple input sources like flat files, Oracle databases, and DB2 databases to the Teradata databases.
• Developed/Modified subject area graphs based on business requirements using various Ab Initio Components like Filter by Expression, Partition by Expression, reformat, join, gather, merge rollup, normalize, replicate etc.
• Extensively worked under the Unix Environment using Shell Scripts and Wrapper Scripts. Responsible for writing the wrapper scripts to invoke the deployed Ab Initio Graphs.
• Expertise in SQL queries for cross verification of data.
• Requesting TDM requests through HP Service manager.
• Created System and Integration Test plans and Test scenarios based on the System Requirements and the High-level design documents.
• Participated in reviewing and validating the Source to Target (S2T) transformations mapping document.
• Created System Test cases in ALM, Quality Center based on the System Requirements and the detail design documents and Source to target mapping documents.
• Requirement Traceability Matrix (RTM) is created to trace all the system requirements to the test cases. The tracing of requirements to the test cases was done in Quality Center.
• Involved in doing the System testing, Regression testing, Integration testing and volume testing for various projects which involves ETL Validations in the Data ware house with huge-volumes of data.
• Coordinated with various upstream and downstream systems to do integration and end to end testing for different projects.
• Supported and participated in UAT (User acceptance testing) by loading the data into the data warehouse for the users to do UAT and to clarify the technical related questions during the UAT.
• Involved in doing the Post- production validations on the data ware house and also supported the production support teams during the production implementation of various projects.
• Validated the source to target transformation mappings (ETL transformations ) for various projects which extracts and loads from different and multiple sources and targets like Teradata,DB2,Oracle databases and flat files, ebcdic files, XML files, etc.
• Involved in writing SQL queries with joins and filters to validate the Referential integrity and Data integrity between different related tables in the Data ware house.
• Validated the naming standards and Data Movement standards in the Ab Initio ETL code.
• Used TOAD, SQL Assistant, BTEQ tools to validate the data in the ORACLE and Teradata data ware houses.
• Involved in mocking and manipulating the source data to validate complex ETL transformations to do negative testing scenarios and to validate the data quality checks.
• Validated the Data lineage from source to target and Repository tracking of the Ab Initio graphs in the Ab Initio WEB EME.
• Participated in the implementation plan review meeting with production support teams to review the jobs schedule in production.
• Used Clear Quest and Quality center as defect tracking tool.
• Involved in generating reports from Clear Quest and Quality center regarding the defect and testing status updates and send to the teams an the time of system and integration testing .
• Used Ab Initio components like Sort, Rollups, Merge and created common XFRs during the data transformation phase. implemented partition techniques using MFS (Multi file system) with Partition by Key, Partition by Expression and Round Robin techniques on the data unloaded from multiple tables before sending the data through data quality checks

Environment: Ab Initio GDE 1.14/1.15, Co-Op 2.14/2.15, Teradata V2R3/R4, Oracle 10g, DB2, Sun Solaris, Windows XP, Linux 2.4.9, Mercury Quality Center 10.0, Clear Quest, TOAD,SQL Assistant, SQL, PL/SQL, and UNIX-AIX4.3,MVS.

Confidential, VA

QA Lead

Responsibilities:

• Analyze the Business Requirement Document, Design Document and Data Mapping documents to prepare Test Cases.
• Preparing Business Assurance Strategy document and getting approvals from Business owners
• Trained onsite/offshore resources for supporting the applications like Access Central, TEDS, SSO and OLAD.
• Involved in Smoke, Functional, Integration, Regression and System testing.
• Keeping track of the Hardware Configuration, Operating System, and Tools Used, Testing types & Results on different software versions.
• Create user data for the specific applications that are now involved in SSO.
• Configured the objects in SIMS application for generate manager reports.
• Tested the Access Central application based on the profiles provided by the business.
• Created user workflows that are used for other team mates.
• Tested various applications and functionalities using different browsers like IE, Netscape and Fire Fox.
• Coordinating deployment of Sun IDM application on application servers like Weblogic.
• Experienced in testing data ware house projects using Ab initio tool
• Experienced in executing and modifying the UNIX Shell scripts in VI-Editor for Data Extraction and verification.
• Experience in managing large onsite and offshore team
• Tested applications SLA response and actual response to all Web applications by using test data and executed the Test Scripts
• Experience in providing inputs to build Automation scripts for Access Central application using QTP.
• Performed Back End testing by writing SQL queries in TOAD to check the data integrity.
• Database testing using Oracle and verify the front-end data to the backend.
• Performed tests on multiple platforms and environments, which includes integration, system testing, functionality testing
• Analyzed user Requirements, prepared test strategies and Test Scenarios.
• Executed test Scenarios and verified actual results against expected results.
• Extensively involved in using Quality Center and Rational Clear Quest to report bugs.
• Conducted Regression Testing and interacted with developers to resolve the issues.
• Performed End to End testing for Laptop and MME Encryption project.

Environment: Ab Initio, Sun IDM, Sun Role Manager, Microsoft IDM, MS Active Directory, SharePoint, Entrust, SSO, Java Web services, weblogic 10.3, Quality Center, QTP, SQL Developer, TOAD, Teradata, Unix, PL/SQL, Oracle 9i/10g, Autosys, SQL Navigator.

Confidential, NY

Sr. QA Analyst

Responsibilities:

• Involved in End to End testing from placing an order from generic web order entry application and activated the unit on the Network and Gateway
• Keeping track of the Hardware Configuration, Operating System, Tools Used, Testing types & Results on different software versions.
• Performed End-to-End testing manually and was associated with User Acceptance Testing.
• Tested Web Access expected response and actual response to all Web applications by using test data and executed the Test Scripts
• Prepared test cases to test the backend Database by retrieving the data for the tables using SQL.
• The functional requirement ID’s that are listed in each use case have come from the functional specification document Based upon that we written a test cases.
• Tested the Web applications like Yahoo OWE and Yahoo ITM Portals from online.
• Tested various Online Portals and API’s from different browsers.
• Developed Automated scripts for Client Server Application using Win Runner
• Performed Back End testing by writing SQL queries to check data integrity.
• Database testing using Oracle and verify the front-end data to the backend.
• Experienced in executing and modifying the UNIX Shell scripts in VI-Editor for Data Extraction and verification.
• Involved in the creation of compiled modules (libraries) for system and user sessions and called them from test scripts.
• Performed tests on multiple platforms and environments, which includes system testing, functionality testing
• Involved in using Test Director to report bugs.
• Involved in Black box, functional testing, integration testing, load testing, regression and System testing.
• Worked with appropriate team leaders to ensure quality of test deliverables & timely completion of individual test plans.
• Involved in End to End testing from placing an order from web application and activated the unit on the Network and Gateway
• Developed test plans that includes test cases, test scenarios, expected results and prioritized tests
• Executed the Test Scripts for web application and verified expected response and actual response.
• Conducted system and regression testing, debugged the software errors and interacted With developers to resolve technical issues
• Tested Assigning receivable account, revenue account, unbilled account, fright account, clearing account, unearned account to transaction types, defining payment terms, discount rates, and memo lines.
• Defining accounting rules for revenue recognition & Parameterized the virtual user scripts so that the each virtual user login with a different set of realistic data.
• Monitored the schedules with varying Loads and conditions. Measured the system & Created Performance summary report and Performance evaluation report.

Environment: JAVA, J2EE, Servlets, Java Protocols, HTML,C++, Unix (Solaris 5.8), Windows CE/NT 4.0, Web sphere, TIBCO/ Rendezvous, Internet Explorer 4.0/5.0/6