SUMMARY:

• Over 7 years of experience in Testing/QA of various simulation products, client server, web based, healthcare and retail in diversified environments
• Hands on experience in different software development methodologies such as Waterfall model, Agile/Scrum
• Experience in Requirement Analysis, gathering, understanding and analyzing business, requirements gathering and all phases of SDLC
• Expertise in preparing test plans, test scenarios, test cases, test status & defect reports, developing and maintaining test scripts based on business and functional requirements. Documented all phases of the QA process
• Knowledge of SharePoint, Pro Track, Requisite Pro for maintaining test requirements and test flows
• Sound Knowledge of using tools such as ALM,JIRA, QC,Rational Clear Quest for management of test plans, test designs, test cases, test execution, defect/bug tracking,
• Extensive Working Experience in Integration Testing, Black Box testing such as System (Functional & Non Functional), Regression, UAT and Performance/Stress/Load testing in all stages of STLC
• Familiar wif writing and executing UNIX/LINUX commands Shell scripts for Scheduling jobs, status of jobs etc
• Proficient in writing SQL queries (complex, advanced) in SQL Server, Oracle MySql, Teradata, Oracle and DB2 for data base testing and Strong noledge of RDBMS concepts
• Experience in ETL Testing, wif Source to Confidential transformations, data loads in to data warehouse, rejects of invalid data etc
• Able to work under pressure in order to meet deadlines. Exhibit leadership and excel in a cross - functional environment as a team member as well as independently
• Excellent verbal and written communication skills wif the ability to successfully work wif all levels of IT professionals and end users
• Expertise in Oracle database architecture and design including few development DBA duties (export, import, data pump, SQL performance and tuning)
• Strong programming and debugging skills in PL/SQL, SQL, Dynamic SQL, C, C++ and UNIX shell scripting
• Proficient in SAS programming on Base SAS and Advanced SAS
• Extensive experience wif third party database tools like TOAD, PL/SQL Developer, SQL Assistant, SQL TOAST

TECHNICAL SKILLS:

Operating Systems: Windows, UNIX

Testing Tools: HP Quality Center, HP ALM, TestDirectorWinRunner, LoadRunner, Quick Test Pro 9.5/ 9.2, JIRA

Languages\Scripting: C, C++, PL/SQL, SQL, Shell Programming, Visual Basic, Java, PHPHTML

Databases: Oracle 8i, 9i,10g, SQL Server7.0, MS ACCESS, MY SQLTeradata

Data Modeling Tools: Erwin 4.1, Visio2000

Additional Skills: Adobe Acrobat, Toad, ClearQuest, MicrosoftFrontPage, MSOfficeMicrosoft Excel, Microsoft Visual Studio 6.0.

PROFESSIONAL EXPERIENCE:

Confidential

Sr. Systems Quality Analyst

Responsibilities:

• Led Systems Testing for numerous applications. Validated requirement compliance of newly added functionalities where screens wifin applications were rewritten from VB to .Net
• Planned test strategy for identifying business critical items, performed smoke and regression testing while maintaining them in various suites in HP ALM
• Prepared test scenarios and test scripts as per requirements, and executed them in Test Lab
• Validated that back-end tables are being updated in accordance wif front-end screen functionalities
• Performed data validations between upstream and downstream environments, and also between tables and files
• Organized and conducted test script peer review meetings wif the team and was instrumental in earning approval from various Business Stake Holders
• Monitored daily jobs, verified data accuracy between two different systems, and notified team when their were differences. Investigated root cause for differences and successfully completed validations
• Worked on Production Tickets and assisted UAT team as required
• Conducted monthly patch testing (Windows, Unix, Apache TomCat) by checking the status of jobs, validating NDM process completeness
• Actively participated in planning, design meetings, and implementation rehearsals
• Communicated effectively wif Business Analysts and Developers in gathering requirements and suggested modifications where necessary
• Logged as well as tracked production and environment release defects, and closed them after successful retesting
• Provided daily status updates on issues and progress on scrum calls

Environment: .Net, HP ALM 12, Linux, SQL, Version1, Microsoft Excel, Sql Toast, Sharepoint

Confidential

Business Data Quality Analyst

Responsibilities:

• Performed root cause analysis of data quality issues and provided accurate and timely retail data to client DataMart applications
• Prepared test cases and test scenarios on different Customer Requirements and tested ETL/ELT changes
• Conducted validations on weekly scheduled batch jobs that were run in order to analyze accuracy of flow completion and upstream released production data. Also identified missing records and took necessary steps to recover data
• Collaborated wif IT support teams to resolve production processes, data issues and tickets, theirby restoring functionality and data integrity in a timely manner
• Conducted regression testing and End to End testing by implementing SQL queries including foreign key validations, data distribution, join indexes, rounding issues, validations between landing, staging, foundation tables and semantic views, addition of new columns etc.
• Documented changes, after each release, to a learning document and subsequently uploaded to SharePoint
• Participated in design meetings and provided data standards to developers
• Communicated effectively wif Developers and Business Analysts for clarifications or changes. Seamlessly integrated wif Off-Shore team, and updated Project Managers on Project status as well as on tracking deadlines
• Met deadlines for all releases wifout fail

Environment: Teradata, HP ALM, JIRA, SharePoint, MS-Excel, Version1

Confidential

Manual Tester

Responsibilities:

• Conducted a review of the Functional Design Documentation in order to gain a better understanding of the ‘ Confidential ’ and ‘CRM’ applications
• Facilitated meetings wif other teams to gain noledge about Eligibility, Health Plan coverage and Tiers
• Actively participated in daily, weekly meetings for the planning and execution of sprints
• Involved in UAT, Functional testing, E2E Testing and Regression Testing.
• Conducted Integration testing where the CRM interface TEMPhas to interact wif the ‘ Confidential ’ application and display data from ‘ Confidential ’ and vice-versa
• Developed test cases in HP ALM for “SHOP’’ functionalities where Employers choose health plans for employees.
• Updated test cases to better reflect current business requirements.
• Prepared test data (Input files) for interpreting positive/negative/regression test results based on design requirements
• Executed test cases to validate functionality of the ‘CRM’ user interface in ALM
• Reported defects, attended defect calls, updated defect status accordingly in HP ALM and monitored defects until they were resolved
• Provided Production Support to customers by answering their questions and resolving errors received during their application access
• Consistently achieved project goals by meeting deadlines for all project releases

Environment: Windows 7, HP ALM, SharePoint, Oracle Right Now, Snipping Tool, Green Shot, Ms Excel

Confidential

QA Analyst

Responsibilities:

• Involved in preparing Test Strategy and Test Plan for applications in the project
• Extensively involved in writing test cases for new functionalities
• Developed and executed various manual testing scenarios
• Involved in System Testing, UAT, Regression Testing and Retesting
• Followed IEEE/ANSI X12N 270/271 standards for test plans, System testing and User Acceptance Testing
• Created Automation test scripts and performed Regression testing. Created User Defined Functions to enhance the maintainability of regression scripts
• Conducted internal review sessions to review the scenarios and test scripts created by the team
• Attended weekly project meetings and provided status of the testing
• Monitored and tracked defects by using HP QC 9.0
• Customized the Project in QC and Worked wif the defect life cycle: from identifying the defect, to filing the defect report, and assigning priority
• Prototyped the application, providing screen shots for better visualization
• Exceptionally documented the process of functional testing of the application
• Studied documentation on Business Requirements, System requirements and the application

Environment: QTP, Oracle11g, Java, IBM Mainframes System /360, HIPPA, HP QC 9.0

Confidential

Oracle Developer

Responsibilities:

• Run Audit Reports to check data stale on Jackcache
• Resolve issues when many records are stale on Jackcache
• Communicated wif other teams as necessary for getting required data and information and resolving issues
• Worked wif procedures, functions and packages
• Created procedures for moving data in to respective history tables once the process is done
• Created tables, views on different schemas
• Created indexes, hints for tuning SQL statements
• Worked on Analyze and DBMS STATS for gathering statistics. Also worked on existing tables for gathering statistics
• Used Database links to work on data in different environments
• Worked wif DBMS SCHEDULER for scheduling jobs
• Worked wif Explain plan, SQL Trace
• Worked on UNIX shell scripts
• Scheduled jobs on UNIX using CRON TAB
• Also loaded data from flat files using SQL LOADER
• Tested the code that is written, performed functional and performance testing

Environment: Oracle 10g, SQL *Loader, SQL PLUS, PLSQL DEVELOPER, UNIX

Confidential, New York

Oracle Developer

Responsibilities:

• Communicated effectively wif the business analysts to understand the logic and work accordingly
• Worked effectively wif team in comparing the design structures in Informix and Oracle
• Mapped all the tables in Informix wif Oracle and replaced some data fields from other tables
• Analyzed Informix code by decompiling it from the respective directories
• Converted all SQL statements, stored procedures and packages from Informix to Oracle
• Worked wif tables, views and synonyms
• Loaded data from flat files to tables using SQL LOADER
• Involved in tuning of SQL statements
• Worked wif Explain plan, SQL Trace and TKprof
• Worked extensively wif batch processes to find the embedded Informix code
• Converted the code in batch jobs from Informix to Oracle and provided them for execution
• Involved in testing. Conducted unit testing on the procedures and packages

Environment: Oracle 10.2.0.1, 10g, SQL & PL/SQL, SQL Loader, UNIX K-Shell, Solaris10, Toad, Java