SUMMARY:

• Over 10+ years of excellent IT experience in requirement gathering, data analysis, design, development, Testing and Implementation of Web Application, Data Warehouses using ETL & Business Intelligence solutions, UNIX, OLAP for multiple domains.
• Strong unix command skill - (vi, wq, wc, grep, more, cat, ls, get, mget, put, top, gzip, gunzip)
• Excellent batch job design, scheduling, creation and implementation of job control language in ControlM/Autosys.
• Expertise in understanding Business/Functional/technical requirements and compliance rules.
• Experienced in writing test plans, test cases and test scenarios.
• Complete exposure to all stages of SDLC process with strong skills in writing various test plans, developing, maintaining test cases and test scenarios.
• Excellent Understanding in relational Data modelling, Dimensional data modelling, logical/Physical Design, ER Diagrams, analyzing data sources.
• Experience in testing complex reports generated by Cognos, SSRS, Business Objects including dashboards, summary reports, master detailed, drill down and score cards.
• Expertise in Data Analysis, Understanding in Dimensional Data Modelling, Data Extraction, Transformation & Loading (ETL), Cubes and End User Reports.
• Good Understanding on Star Schema Modelling, Snow-Flake Modelling, FACT and Dimension Tables, Physical and Logical Data Modeling.
• Extensive experience in using SQL, PL/SQL Procedures/Functions, Triggers and Packages for testing purposes.
• Experienced in functional, integration, regression, compatibility, security, back end, acceptance testing (UAT), and GUI Testing.
• Advanced user in using Test management tools like HP Quality Center/Test Director, JIRA.
• Worked on Oracle 11g/10g/9i/8/7.3, MS SQL Server 2008/2005/2000/7.0/6.5, IBM DB2 7.1/8.2/v9, Teradata V2R6/R5 databases.
• Prepared and loaded test data in different environments for different testing needs.
• Ability to quickly adapt to different project environments, work in teams and accomplish difficult tasks independently within time frame.
• A good team player with excellent written and verbal communication skills.
• Excellent problem solving skills with a strong technical background and good interpersonal skills.

TECHNICAL SKILLS:

ETL Tools: Data Stage 8.5, Informatica Power Center 9.X,8.5.1 (Designer, Workflow Manager, Workflow Monitor,), Data Stage 8.5, Abinitio GDE.

OLAP Tools: IBM Cognos v9, SSRS, SSIS, SSAS, SAP Business Objects 2010/2008/XIR2, Microstrategy 8.0

Data Modeling: E rwin, Microsoft Visio, Rational Rose (UML), ER Studio

Operating Systems: Windows NT/2000/2003/XP, UNIX, Solaris and MSDOS

Databases and Tools: Oracle 11g/10g/9i/8i, SQL Server 2008/2005, DB2, MS Access, Teradata V2R5, Toad 11.5, WebMethods

Testing Tools: Rational ClearQuest, Test Director, JIRA, HP Quality Center 9.0/9.2/10.0, Doors, Selenium2.5, QTP

Languages: XML, SQL, PL/SQL, C,C++, VB

Batch Scheduling Tool: Control M, Autosys.

PROFESSIONAL EXPERIENCE:

Confidential, MD

QA/ Lead Analyst

Responsibilities:

• Involved in reviewing/analyzing Business Requirement Documents/Functional specifications/use cases.
• Ran automation tests using UFT/Selenium to test internal credit card applications site.
• Used VBScripts in QTP to access webpage script variables.
• Used Quick Test Professional (QTP) for regression testing and running automation suite.
• Worked on GUI, Functional, Integration and Regression Testing.
• Enhanced overall functionality of the application, performed data driven testing and GUI Check points using QTP.
• Worked with Business Analysts, Developers, PMs while reviewing the Business Requirement Documents and when there are enhancements in the applications.
• Working on user stories - define, analyze, estimate, and execution of stories based on agile timelines.
• Wrote queries to verification/validation data using PL/SQL(TOAD).
• Used excel for data validations and summarized data in power point and presented to Business.
• Making the jobs run at certain time by setting up the hr, min, day of the week, month, schedule for the specific job.
• Performed overall test in different environment - UAT and PVT.
• Verification and Validation of the all the jobs in certain group etc and the status of the job.
• Peer reviewed test cases developed by QA team members and advice/point/discuss possible complex scenarios and make sure requirements are completely covered.
• Supported and provided test cases for UAT, staging and production.
• Participated in review meetings and attended training sessions to understand various business concepts.
• Exported Requirements, test plans and test cases to QC.
• Created Traceability Matrix to ensure that all requirements are covered in test cases.
• Develop Risk-based Test Strategy whenever required, to save time and to determine which test activities to carry out and created complexity matrices.
• Prepared Kickoff meeting PowerPoint and gave presentation on testing activities for each cycle of testing and for different releases.
• Communicated over defect meetings on daily bases to track defects status with functional leads and to speed up resolution process at end of each cycle.
• Interacting with developers, business analysts to communicate the defects.
• Involved in UAT process before rolling out to production when required.
• Created defects, manage defect reports and defect status in QC.
• Extensively tested Business Objects report by running the SQL queries on the database by reviewing the report requirement documentation.
• Developed and Executed SQL statements in Oracle to retrieve data and to validate data.
• Tested data migration to ensure that integrity of data was not compromised.
• Validated the data thru various stages of data movement from staging to Data Mart to Data Warehouse tables.
• Responsible for documentation of test results, test matrix, and participated in daily/weekly QA meetings.

Environment: Java, Oracle, HP Quality Center 9.2, Requirement Traceability Matrix (RTM), TOAD, MS Excel, QTP 11.0, Selenium 2.5

Confidential, DE

Lead Analyst

Responsibilities:

• Involved in reviewing/analyzing Business Requirement Documents/Functional specifications/use cases.
• Ran automation tests using Selenium to test internal credit card applications site.
• Used VBScripts in QTP to access webpage script variables.
• Used Quick Test Professional (QTP) for regression testing and running automation suite.
• Worked on GUI, Functional, Integration and Regression Testing.
• Enhanced overall functionality of the application, performed data driven testing and GUI Check points using QTP.
• Worked with Business Analysts, Developers, PMs while reviewing the Business Requirement Documents and when there are enhancements in the applications.
• Working on user stories - define, analyze, estimate, and execution of stories based on agile timelines.
• Wrote queries to verification/validation data using PL/SQL(TOAD).
• Used excel for data validations and summarized data in power point and presented to Business.
• Defining the job using job control language.
• Making the jobs run at certain time by setting up the hr, min, day of the week, month, schedule for the specific job.
• Performed overall test in different environment - UAT and PVT.
• Making sure that it runs per the scheduled time and the executable - script passed and other dependencies set
• Verification and Validation of the all the jobs in certain group etc and the status of the job.
• Developed Test Cases for Deployment Verification, ETL Data Validation, and Report testing.
• Tested the ETL process for both before data validation and after data validation process. Tested the messages published by ETL tool and data loaded into various databases.
• Peer reviewed test cases developed by QA team members and advice/point/discuss possible complex scenarios and make sure requirements are completely covered.
• Supported and provided test cases for UAT, staging and production.
• Participated in review meetings and attended training sessions to understand various business concepts.
• Prepared Entry and Exit criteria for Testing cycles, review with functional leads and PMO.
• Exported Requirements, test plans and test cases to QC.
• Created Traceability Matrix to ensure that all requirements are covered in test cases.
• Develop Risk-based Test Strategy whenever required, to save time and to determine which test activities to carry out and created complexity matrices.
• Prepared Kickoff meeting PowerPoint and gave presentation on testing activities for each cycle of testing and for different releases.
• Communicated over defect meetings on daily bases to track defects status with functional leads and to speed up resolution process at end of each cycle.
• Interacting with developers, business analysts to communicate the defects.
• Involved in UAT process before rolling out to production when required.
• Created defects, manage defect reports and defect status in QC.
• Extensively tested Business Objects report by running the SQL queries on the database by reviewing the report requirement documentation.
• Developed and Executed SQL statements in Oracle to retrieve data and to validate data.
• Tested data migration to ensure that integrity of data was not compromised.
• Validated the data thru various stages of data movement from staging to Data Mart to Data Warehouse tables.
• Responsible for documentation of test results, test matrix, and participated in daily/weekly QA meetings.

Environment: Data Stage, Oracle, HP Quality Center 9.2, Requirement Traceability Matrix (RTM), TOAD, MS Excel, MS Project, QTP 11.0, Selenium 2.5

Confidential, AZ

Sr. Analyst

Responsibilities:

• Analyzed the Functional requirements using Detailed Design Document.
• Setting up of environments to be used for testing and the range of functionalities to be tested as per technical specifications.
• Developed test cases and game plan based on requirement document.
• Working on user stories - define, analyze, estimate, and execution of stories based on agile timelines.
• Wrote queries to verification/validation data once the payment split is performed.
• Used excel for data validation and summarized data in power point and presented to Business.
• Worked with development team to ensure testing issues are resolved.
• Reviewed log files in UNIX for error cause when payment method scripts failed.
• Executed payments on WebMethod tool and documented results.
• Developed Test Strategy, Test plans, and Test scenarios using MS Word and MS Excel.
• Developed Test Cases and Test Scripts for System and UAT Testing.
• Performed Positive and Negative Testing for many scenarios and applications.
• Performed basic testing of security features using manual testing.
• Responsible for creating Test Strategy for Web Methods Tool.
• Conducted regression testing on the application under test and Debugging logs to execute the payment system.
• Extensively involved in Identifying defects and logged/tracked them using bug tracking tool Quality Center.
• Worked Extensively with Webmethod tool for different payment methods DAC, CHK and MTS to split the payments.
• Validated penny payments once they are processed in WebMethods Tool.
• Defects tracking, review, analyze and compare results using Quality Center.
• Preparation of various test documents for WebMethods process in Quality Center.
• Involved in time estimates for and reports validations.
• Executed test cases and documented test results in excel spreadsheet.

Environment: WebMethods, SQL, Quality Center 8.0, SQL Assistant, Unix, Ultraedit, XML, Windows XP, MS Office.

Confidential, VA

Sr. Analyst

Responsibilities:

• Involved in reviewing/analyzing Business Requirement Documents/Functional specifications/use cases.
• Worked with Business Analysts, developers while reviewing the Business Requirement Documents and when there are enhancements in the applications.
• Working on user stories - define, analyze, estimate, and execution of stories based on agile timelines.
• Wrote queries to verification/validation data using PL/SQL(TOAD).
• Used excel for data verification/validation and summarized data in power point and presented to Business.
• Developed Test Cases for Deployment Verification, ETL Data Validation, Cube Testing and Report testing.
• Defining the job using the job control language.
• Making the jobs run at certain time by setting up the hr, min, day of the week, month, schedule for the specific job.
• Performed overall test in different environment - SIT, UAT and Production job scheduler tool
• Making sure that it runs per the scheduled time and the executable - script passed and other dependencies set.
• Verification and Validation of the all the jobs in certain group etc and the status of the job.
• Tested the ETL process for both before data validation and after data validation process. Tested the messages published by ETL tool and data loaded into various databases
• Peer reviewed test cases developed by QA team members and advice/point/discuss possible complex scenarios and make sure requirements are completely covered.
• Executed Ab Initio/Data Stage ETL graphs from UNIX environment.
• Written SQL queries to validate Ab Initio graphs and transformations.
• Supported and provided test cases for UAT, staging and production.
• Participated in review meetings and attended training sessions to understand various business concepts.
• Prepared Entry and Exit criteria for Testing cycles, review with functional leads and PMO.
• Exported Requirements, test plans and test cases to QC 9.2.
• Created Traceability Matrix to ensure that all requirements are covered in test cases.
• Develop Risk-based Test Strategy whenever required, to save time and to determine which test activities to carry out and created complexity matrices.
• Prepared Kickoff meeting PowerPoint and gave presentation on testing activities for each cycle of testing and for different releases.
• Conducted Defect meetings on daily bases to track defects status with functional leads and to speed up resolution process at end of each cycle.
• Interacting with developers, business analysts to communicate the defects.
• Involved in UAT process before rolling out to production when required. Participated in debugging prod issues along with support team.
• Created defects, manage defect reports and defect status in ClearQuest tool
• Extensively tested the Business Objects report by running the SQL queries on the database by reviewing the report requirement documentation.
• Developed and Executed SQL statements in Toad to retrieve data and to validate data.
• Tested data migration to ensure that integrity of data was not compromised.
• Validated the data thru various stages of data movement from staging to Data Mart to Data Warehouse tables.
• Responsible for documentation of test results, test matrix, and participated in daily/weekly QA meetings.
• Conducted down test and up test for release builds pushed to UAT and to Production.

Environment: Ab initio, Data Stage, Oracle 10g,MS SQL, HP Quality Center 9.2, Requirement traceability Matrix (RTM), TOAD, Business Objects, MS Excel, MS Project.

Confidential, CA

Support Engineer

Responsibilities:

• Initiate as a Queue Monitor for case-tracking tool to recreate requests.
• Establish layer 2 and layer 3 connectivity and load appropriate IOS images.
• Address and Perform “Show commands” on IOS to configure and troubleshoot Cisco Routers and Switches such as 800series, 1800series, 2800 series, 3800series, CAT6500 series and 7600 series.
• Assist Network Engineers and resolve issues from recreate (NetworkTest-bed) requests.
• Familiar with Routing Protocols (OSPF, EIGRP, IGRP, RIPV1/2), Routed Protocols (TCP/IP and UDP) and LAN switching (Spanning-tree, VTP), VLAN’s.
• Familiar with Voice Protocols(SIP, SCCP, SGCP, H.323)
• Provide peer training and mentor newer co-ops.

Confidential, CA

QA Tester

Responsibilities:

• Key contributor in Enterprise Data warehouse group.
• Identified and fixed DW production issues in timely fashion.
• Developed JCL for script automation in SIT/UAT.
• Performed SIT, UAT and see smooth transition of projects into production.
• Co-ordinated with offshore to work on projects for various tasks.
• Updated and Maintained Project Release Report.
• Maintained internal department website.
• Write Test Cases from Master Test Plan.
• Co-ordinate with developers and test the code.
• Co-ordinate with offshore for test case execution.
• Verification/Validation of data in DB to provide quality data to business.
• Keep track of issues/bugs in Quality Center for bug and reporting requirements.

Environment: Quality Center, UAT, Windows XP, SQL/PL SQL, MS Excel.