SUMMARY

• Over 10 years of IT experience in the field of Design, Development, Production Support, Report Analyst and Software Quality Assurance for the Healthcare and Consulting Company.
• For past 10 years tested multiple applications in the software QA and DEV environments.
• Thorough understanding of Software Development Life Cycle (SDLC) and involved in entire QA life cycle, which includes Test Planning, Requirements Review, Test Design, Test Execution, Defect Tracking and Reporting process.
• Extensive experience in Gathering, Analysis, Design, Development and Testing.
• Involve in various phases of testing like Functional/System, Regression, Web, and Integration testing.
• Strong hands on experience with testing tools like QualityCenter (TestDirector). Knowledge and Experience on automation tools like QTP.
• Strong experience in creating SQL’s and execute them using TOAD and SQL Navigator to validate and manipulate test data.
• Ability to think “outside of the box”, creative problem solver, strong analytical & reasoning skills, goals oriented and priority focused. Ability to multi task to meet critical deliverable dates, quick learner and passionate to learn new tools and technologies.

TECHNICAL SKILLS

Testing Tools: Mercury’s Quality Center (Test Director and QTP 10.0)

DEFECT TRACKING TOOLS: QC, Bugzilla, Jira

WEB TESTING TOOLS: SoapUI 3.5, WSDL, Firebug, Google Analytics

RDBMS: Oracle 10G/9i/8i/7.x, MS Access 2003

SOFTWARE LANGUAGE: SQL, PL/SQL, SQL*Plus, Visual Basics, Java

DEVELOPMENT TOOLS: Developer 2000 (Forms 6i, Reports 6i)

DESIGINING TOOLS: Designer 2000, Oracle Discoverer, SQL* Loader, Business Objects

OPERATING SYSTEMS: Windows XP/NT, UNIX (Solaris 2.x)OTHERS TOAD, CA - Unicenter, Citrix, MS Office, Share Point

PROFESSIONAL EXPERIENCE

Software QA Analyst II

Confidential

Responsibilities:

• Followed the Agile methodology for frequent delivery of a software
• Participated in Requirements review, Project status and Defect Review in stand up meetings
• Performed Functional, Integration, Browser Compatibility and regression testing
• Tested images, text, hyper links, header, footer, menus appear correctly in the web application.
• Used Firebug to test and track bugs in the application
• Used Google Analytics for monitoring Web Services
• Collaborated with Developers to resolve Defects and test environment issues
• Designed and Executed test cases for Manual testing using in QC 10.0
• Bug Reporting, Tracking & Verification, documented results and updated Defect tracking systems

Software QA Analyst

Confidential

Responsibilities:

• Followed the SDLC and QA life cycle for every project delivered to the client
• Reviewed Business/System requirements and Change Requests for internal systems and work with Business and System Analysts for Gap analysis
• Participated in Requirements review, Project status and Defect Review Meetings
• Performed exploratory testing and identify Defects due to missing requirements
• Developed and executed test Procedures, test cases and test scripts
• Documented data requirements and performed test data set-up
• Facilitated weekly test scenarios review meetings
• Designed and executed Manual and Automated tests using Quality Center (Test Director), and Automation tool (QTP) for multiple applications.
• Executed tests with Black box, White box, Integration, Regression testing methods using different testing techniques
• Used Quality Center to log Requirements, to map Test Cases and Defects
• Used Test plan, Test lab functions of Quality center for documentation and execution of tests.
• Logged and tracked Defects with Defects function
• Collaborated with Systems Analyst and Developers to resolve Defects and test environment issues
• Performed administrative tasks like Project customization, Creating and maintaining users in Quality center
• Tested XML scripts using SoapUI and WSDL
• Performed database testing by checking the data flow among the tables
• Checked the data flow between user interface and database.
• Created SQL queries and executed them on various DB editors like TOAD, SQL Navigator to validate and manipulate test data
• Document management in SharePoint, Bugzilla
• Performed testing for Data Extracts using Business Intelligence and run ETL
• Tested ETL components by executing SQL queries to make sure that records are loaded correctly from Source to Target Tables
• Validated data for accuracy, completeness (missing and invalid data) and inconsistencies
• Designed and Execute test cases for Data Extracts in QC
• Trained other team members on application functionality.

Report Analyst

Confidential

Responsibilities:

• Designed, developed, modified, tested, and implemented, QC and deliver internal and client reports.
• Worked effectively with Program Managers, Clients, Business Analysts, Finance, Call Center leadership, Operations Analysts and Technology partners.
• Acted as liaison between Business Analysts, Program Managers and Application Technology partners to ensure warehouse, universe and data cubes satisfy the reporting requirements.
• Analyzed complex reporting requirements and provide input to high-level business requirements.
• Developed complex standard, ad hoc and custom reports to satisfy business requests.
• Performed Quality Control on report deliverables according to Standard Operating Procedures.
• Ensured reports are scheduled and delivered according to Service Level Agreements.

Software Engineer

Confidential

Responsibilities:

• Analyzed, coded, tested, troubleshoot, and modified Oracle based software programs using UNIX system
• Created and modified stored procedures, functions using SQL, PL/SQL on UNIX system
• Implemented modifications to existing applications per user requirement
• Analyzed and reviewed software applications using standard SDLC methodologies.
• Used RCS Source Code Control system for implementation of an application on the Unix server
• Prepared and submitted change control requests to initiate changes to programs using MVS
• Conducted the unit and system testing and verified the results to implement application into production
• Monitored to ensure programs were operating efficiently and accurately
• Created and/or modified production job documentation to inform computer operations personnel of changes to batch job processing
• Worked closely with business team regarding client’s requirements and needs
• Supported in monitoring the production jobs and data loads for monthly and quarterly processing for clients
• Responded to 24-hour calls for assistance to provide emergency technical support
• Prioritized assigned tasks to ensure efficient utilization of time and completion of assignments

Programmer - Oracle Developer

Confidential

Responsibilities:

• Created SQL*Loader control, parameter scripts and batch scripts for Windows NT.
• Prepared conceptual Designed per user requirements
• Developed Packages, Stored Functions and Stored Procedures using SQL, PL/SQL and SQL*Plus
• Developed and Generated customized Forms & Reports in Designed Editor
• Developed template for Reports and Forms
• Assisted in the development of applications for a client