SUMMARY

• Overall 9.5 years of experience in QA projects with Data warehouse testing, Database testing, Functional Testing and software testing life cycle (STLC) processes and disciplines.
• Excellent Data warehouse Testing and Database Testing experience with Oracle, Web based GUI Test, Integration Test, System & Regression Test
• Working knowledge with tools like Putty, BI Reporting tool & Oracle and Exposure in running UNIX
• Ab Initio data loading jobs and finding root causes for failures in jobs
• Extensive knowledge and experience in Oracle SQL queries and UNIX ksh shell scripting. Fair knowledge in Excel Macro using VB Script
• Writing Unix ksh shell scripting to automate functionalities in order to reduce manual effort and save dollars
• In depth knowledge in Agile and Waterfall Methodologies
• Capable of leading medium - large scale (enterprise level or multi-million $$) QA projects.
• Exposure to all phases of Software Testing Life Cycle (STLC) and Software Development Life Cycle (SDLC)
• Specialties: QA Management, Scope Management, Time and Cost Management, Project Management
• Ability to make clear, quick decisions and judgments in time-sensitive, pressure situations.
• Excellent communication skills both oral and written combined with a strong Technical and Analytical reasoning ability.
• Involved in preparation of Test scenario/case development, Test environment setup, Test data preparation, Test Plan preparation, Test case execution, Defects reporting, conducted Defect Triage meeting and driven Retrospective meetings (Test phase summary review)
• Expertise in Test management tools - HP ALM 11.0, Quality Center 10.0, Unix, Ab Initio, Oracle, SQL Developer
• Effective leader with demonstrated success in managing relationships, building cross-functional project teams, managing resources, and project execution

TECHNICAL SKILLS

Databases: Oracle9i

Testing/Productivity: HP ALM v11, QC 10, Oracle SQL Developer, Windows SharePoint Services, MS Office (Word, Excel, PowerPoint), Mainframe DB2, MS Visual Studio, Unix, Ab Initio, Business Intelligent (BI Reports)

Functional Areas: Data warehouse, Database Testing, Manual Testing, Mainframe Testing, Web Service Testing (SOUP UI), Unix Testing

Languages: SQL, Mainframe DB2, UNIX, VB

Methodologies/Tools: Ab Initio, Oracle, SQL Developer, BI

Domains: Banking and Finance (Payment Cards, Loans, Accounts and Client Relationship Management)

PROFESSIONAL EXPERIENCE

Confidential, Columbus, OH

Data Warehouse Automation Test Lead

Responsibilities:

• Responsible for project execution of 6 cycles in three releases in a year
• Participating in discussion with Environment Management Team for environment set up/Refresh, Prod data loading and Authorizing environment readiness
• Understanding release requirements by having discussions with Business Team and Producing test plans and ensuring they are followed.
• Preparing detail requirement doc and prepare the test scenarios and test cases for each module in a step by step procedure
• Assigning work to QA analysts and monitoring work progress, Clarifying business flow and technical queries
• Identifying feasibility to automating tests where ever applicable. Also, preparing excel macros to reduce manual efforts
• Producing and prioritizing bug reports, following up with dev team
• Check/Review the Test Scenarios and Test cases and uploading/executing test cases in ALM
• Responsible for defect prioritization and conducting daily defect status meeting with project stakeholders and involving Dev team to ensure timely resolution for defects.
• Sharing daily testing status with client manager and Marking tasks completion in TEP ( Test Execution Plan) hence ensuring testing plan is on schedule
• Escalate risks and issues to ensure timely resolution.
• Received excellent feedback from customers for the projects delivered for meeting or exceeding defined quality objectives on time and within budget.

Environment: /Products: Windows 7, UNIX Ab Initio, Oracle, BI, HP ALM

Confidential, Charlotte, NC

Database Tester

Responsibilities:

• Worked as a database Tester comparing mainframe file data and ODS table data
• Understanding Client requirements and Prepared Test plan, Test scenarios and Test cases and providing test cases walkthrough in client meeting calls
• Experienced in Mainframe DB2 to fetch file data based on business rules
• Ensured traceability of test cases to requirements, working with the project Business Analyst to ensure all requirements are tested.
• Worked with technical analysts to identify unit testing coverage and ensure any gaps are documented and addressed.
• Ensured that QA process is documented and communicated and adequate to ensure agreed quality levels for the application.
• Query ODS table based on Business rules and fetching results then comparing with mainframe results to ensure expected data flow after manipulation
• Performed QA issue prioritization and resolution facilitation.
• Accountable for conducting database Testing and provided Status Report on a regular basis to cross-functional teams
• Used best practices to implement a full quality program, including test writing, customization, execution, analysis and reporting results.
• All the testing engagements were completed within project timelines and consistently met live-date project deadlines.

Environment: Windows Vista, Mainframe DB2, Oracle, HP Quality Center

Confidential, Charlotte, NC

Functional Tester

Responsibilities:

• Good knowledge about 30 applications ( 15 are major, 10 medium, 5 small ) functionalities and business associated with
• Accountable for delivery of complex test Applications, coordinating and managing testing work across multiple applications and lines of business.
• Coordinated with multiple teams across geographies (Application team, Build team, Integration team, Environment team, Server team, Database team/DBA team, Security team, Service team etc) to ensure that all the applications working properly before we sign testing approvals
• Prepared understanding documents for the new features added, Enhancements hence we include all of them in subsequent releases to test the same
• Applied best practices to utilize technology in the quality assurance process in a way that will ensure the delivery of stable systems while reducing support.
• Giving KT for all new project joiners about the existing projects and BAU testing processes
• Prepared test cases and executing them and raising defects in QC
• Sending Weekly status report to client team with detail information about testing activities, Defects, Execution, and Enhancements.

Environment: /Products:Windows XP, Oracle, J2EE GUI (Internet web based Testing), HP Quality Center

Confidential, Charlotte, NC

ETL Tester

Responsibilities:

• Created test scenarios, traceability matrix for various testing functionalities
• Working with developers to perform root-cause analysis and preliminary problem diagnosis.
• Defect prioritization and daily defect “Business Review/Triage” meetings for defect status using Quality Center.
• Data flow was checked from Mart to ACM instances
• Created SQL queries in Oracle to ensure data count and data integrity checks
• Responsible for summarizing testing efforts and providing status reports to senior management and all stakeholders on regular basis.

Environment: /Products:Windows XP, Oracle, SQL, MSTR reports, HP Quality Center

Confidential, Jacksonville, FL

Functional Tester

Responsibilities:

• Analyze requirements documents and Use Cases to prepare the detailed understanding document, Test Cases and developing Test Scripts
• Test case walkthrough and Prepared test data based on test scenarios
• Raising defects in Clear Quest tool and tracking them in QC and following defect life cycle
• Worked with QA and Development staff to report, verify and close the defects and resolve any issues that arise during testing. Participate in defect triage, prioritization and review meetings on a daily basis.
• Provided test execution status report of each application area and escalate risks/issues to ensure timely resolution.

Environment: /Products: Windows XP, Oracle, CQ (clear quest), RTM (Rational Test Manager), QC

Confidential, Jacksonville, FL

Functional Tester

Responsibilities:

• Responsible for analyzing functional use case documents and getting business/technical queries from onsite coordinator
• Accountable for providing test estimates for my use cases (Consolidated Email functionalities, Customer On boarding).
• Responsible for creating High level test plan and test scenarios, test cases
• Responsible for analyzing and coordinating with different teams for cross functional testing within sawgrass customer relationship management
• Working closely with Business users to understand the system requirements and document.
• Responsible for raising defects and following up till it closed

Environment: /Products: Windows Xp, Oracle, MS Office, CQ (Clear Quest), RTM (Rational Test Manager)