SUMMARY

• 7 Years of experience in Information Technology.
• Good domain Expertise in Health care, Financial Services and Manufacturing.
• Extensive experience in performing various levels of testing such as Smoke Testing, Functional Testing, Re - Testing, Regression Testing, System Integration Testing, Database Testing, User Interface Testing, Compatibility testing, User acceptance testing (UAT).
• Intensive experience in ETL testing using
• Hands on writing and executing the SQL queries for validation of reports and data flowing back and forth from UI to Database and vice versa.
• Experience in facilitating the Test status call with various Testing groups, Defect Management and participating in Defect Triage Meetings.
• Experience in Metrics Programs, computing metrics and analyzing results through graphs and reports.
• Expertise in Preparing and Reviewing Test Artifacts like Test Plan, Test Effort Estimation, Test Scenarios, Test Cases, SRTM (Software Requirement Traceability Matrix), Functional Checklist, Validation Document, Final Test Summary Reports and Signoff Document.
• Experience in eliciting, analyzing, and documenting the requirements for business processes, policies, and information systems. Worked with business stakeholders to understand business problems and opportunities in the context of requirements and recommend solutions that enable the organization to achieve its goals.
• Worked on defining and managing test requirements, project scope, schedule, risk, leading the test teams, business and technical documentation, testing and deployment planning, risk mitigation strategies and project status reporting.
• Co-ordination with Clients and SMEs to understand the requirement and analyze the work.
• Extensive experience working with Global delivery team for effective project management and onsite-offshore co-ordination.
• Experience in Agile- Scrum, Waterfall and Iterative Project Management Methodologies.
• Have worked on HIPAA 5010 validations, 820, 834, 835, 837 transactions and EDI validations
• Experience in doing test estimations for the requirements, Maintaining Resource Utilization, Scope Assessment and Training Plans metrics.
• Knowledge on Software Development Life Cycle, Software Testing Life Cycle, Test methodologies and Quality assurance activities.
• Doing configuration management of project related documents and artifacts in central repository using version control tools VSS (Visual Source Safe)
• Member of Internal Audit and SEPG team, the primary body responsible for guiding the organization towards achieving desired SEI-CMMI levels and ISO 9001:2000 certifications.
• Active participant in the continual improvement of the organization.
• Adapt readily to ever changing technologies and possesses demonstrated supervisory, customer relations and training / support ability.
• Have good analytical and problem solving skills
• Excellent Technical, Training, Planning, Communication, Presentation and Interpersonal skills.
• Expertise in preparation of Test Summary Report, Defect Trend Analysis, Test Case Development plan and Testing Dash Board on daily basis.

TECHNICAL SKILLS

Tools: and Applications: HP Metavance/MembersEdge, Mainframes, EDIFECs Transaction Management, Mainframes, Mind Map, WinSCP3, TOAD, Requisite Pro, Informatica etc.

Operating Systems: MS Windows

Languages: C, C++, SQL

SDLC Process: Agile, Water Fall, Spiral, V Model

Desktop Tools: Adobe Acrobat Reader, MS Project, MS-Word, MS Excel, XML, Microsoft Outlook, Microsoft PowerPoint, MPP, MS Visio

Databases: MS Access, MS SQL, Oracle 9i

Quality Standards: CMM, CMMIv1.2, ISO

Statistical Quality Control tools: Control Charts, Bar Diagrams, Histograms, Cause and Effect Diagram, Scatter Plots, Line Graphs etc.

Testing Tools: Quality Centre QC, Clear Quest CQTM

Documentation: RTM, Defect Log, Understanding document, Clarification Log, Test Case, Test Scenario, Test Cases, Test Summary Report, High level scenario, Minutes of Meeting etc.

Configuration Management: Visual Source Safe

PROFESSIONAL EXPERIENCE

Confidential, Eagan, Minnesota

Test Lead

Responsibilities:

• Analyze requirements to ensure they are specific, measurable, attainable, realistic, and testable
• Facilitated the team to clarify business and technical requirements across the project
• Drafted scope of project, test plan, and work breakdown structure.
• Worked on Test effort estimation for the project
• Prepared Test Plan, test scenarios and reviewed the test cases
• Coordinated with team to prepare the test data
• Managed defect triage meeting, status Involved in defect triage meeting setups, status updates, Defect tracking and Turnaround time tracking by establishing the defect resolution timelines
• Managing defect triage meeting, status updates meeting, Defect tracking and resolution
• Scheduling weekly call with key stake holders to provide status updates and track the progress of the project
• Coordinated onshore offshore activities
• Managed and implemented the change requests
• Involved in Resource planning, Delegation of work to the team members
• Provided adequate training relevant to the project team members
• Reviewed and analyzed the functional requirements
• Generating reports for various premium payment transactions and validating the fields updated in the database using SQL. It included XML files, General Ledger reports, BAR reports, X12 files etc
• Validated the transactions of X12 files for premium payment transactions in Edifecs
• Validated 820 file transmitting payment information for EDI format and HIPAA compliancy
• Validated 834 file transmitting member enrollment information for EDI format and HIPAA compliancy
• Validated 837 file transmitting claim input information for EDI format and HIPAA compliancy
• Validated 999 acknowledgements for x12 transactions
• Involved in Integration testing on Member enrollment, Billing, Cash payments and manual & automatic adjustments
• Analyzed and tested the General Ledger reports which are generated from Metavance tool for the contract coverage members
• Tested the reports in Mainframes
• Performed defect reporting and tracking in Clear Quest CQTM
• Delivered knowledge transfer documents for future usage
• Maintained Requirement Traceability Metrics
• Updated and reviewed Project status report

Environment: - Main Frames, CQTM, HP Metavance/MembersEdge, Edifecs, EDI, WinSCP, PL SQL, XML, MS word, X12

Confidential, Raleigh, North Carolina

Test Lead

Responsibilities:

• Analyzed Requirements of the project for data mapping specifications.
• Created Test Plan, Test Scenarios and the test cases for ETL flow.
• Analyzed and worked on change requests.
• Loaded target tables from Stage tables up on ETL mapping and transformation.
• Performed verification, validation and transformations on the input data like text files, XML files before loading into the target database Passport data warehouse to Field Reporting FR database.
• Tested mapping for extracting, cleansing transforming, integrating and loading data using Informatica.
• Run the ETL jobs that are scheduled for file transfer from one database to another.
• Executed Test Cases including SQL queries to validate the storage and movement of the data from Passport to FR database
• Writing SQL queries for various scenarios like Primary key test, duplicate test, attribute test, default check etc
• Coordinated with development team
• Migrate test cases to HP QC using HP Excel Quality Center Add In
• Performed functional reviews with regard to the customization, Design Document
• Preparing and validating the Test Data
• Performed testing to check the synchronization between Passport database and FR (Field Reporting) database
• Maintained the test repository, list of Defects encountered during the testing and verified the defects once claimed to be fixed by the Development team in Quality Center QC tool
• Prepared Test defect report and Test Summary report
• Maintained the Quality Standards set by the Project
• Prepared Understanding documents
• Maintained the Requirement traceability metrics
• Maintain the project status report weekly

Environment: - Oracle 9i, Toad, MS Excel, QC Quality Centre, Informatica

Confidential

Responsibilities:

• Analyzed Requirements of the project
• Involved in leading and supporting the test team
• Developed Test plan and Test Scenarios
• Prepared and reviewed the functional test cases, system integration test cases and regression test cases
• Executed Test Cases for User Interface with various version of web browsers
• Written and executed SQL queries for verifying the data storage flowing back and forth from User Interface to Backend database and vise versa.
• Maintained the list of Defects encountered during the testing and verified the defects once claimed to be fixed by the Development team in CQTM tool
• Coordinated onshore and off shore test activities
• Managing Offshore calls with teams including stack holders
• Maintained the Quality Standards set by the Project
• Delivered Understanding documents for future usage
• Managed trainings among teams
• Maintained the Requirement traceability metrics for testing activities
• Maintain the project status report weekly
• Worked on test estimations for the project requirements

Environment: - Oracle 9i, Java, MS Excel, IE 6 and IE8, QC Quality Center, Toad

Confidential

QA Engineer

Responsibilities:

• Analyzed Requirements of the project
• Developed Functional Test Cases, Regression Test Cases
• Performed Integration testing and User acceptance testing
• Executed Test Cases including SQL queries
• Written and executed SQL queries for back end system performance
• Prepared the test data
• Maintained the list of Defects encountered during the testing and verified the defects once claimed to be fixed by the Development team in CQTM tool
• Maintained the Quality Standards set by the Project
• Prepared Understanding documents
• Maintained the Requirement traceability metrics
• Maintain the project status report weekly
• Conducted internal audit for the project as an Internal Auditor of the company
• Gave presentation on the effort and cost estimations of the project being the part of SEPG (Software Engineering Process Group) team

Environment: - C++, Libpdf, MS word

Confidential

Software Engineer

Responsibilities:

• Analyzed Requirements of the project
• Developed Functional Test Cases, Regression Test Cases
• Performed Sanity testing, Integration testing for every new release of the product.
• Performed User acceptance testing
• Worked on Internet tap 100Mbps, 1Gbps and 10Gbps capture project Product Internet tap: Interception or capturing data on ISP side includes HTTP, POP3, and SMTP, E-mail attachments, Messengers Yahoo, Hotmail, ICQ, Pal talk, FTP, 25 various VOIP (SIP & RTP, H323) clients and reconstruct them and present data on GUI.
• Reporting and logging Bugs at initial stage of testing, Coordinating with development team.
• Configuration Management for project artifacts: Test Plan, Test Cases, Test Scenario Document, Bug Report, Project Status Report Test Summary Report etc.
• Prepared Understanding documents

Environment: - Visual C++ 6.0, Oracle 11g