SUMMARY

• Total 6+ years of experience as QA Analyst.
• Worked in Vibrant Screen Confidential . Confidential from .
• Worked in Tata Consultancy Services from .
• Worked in Confidential from .
• Experience in ETL/Manual testing/ Performance testing on Windows/Linux Environment. Experience in preparing/reviewing/executing Test cases, Defect logging/tracking/analysis
• Expertise in Test case management tool HPQC - 9.0/10.0, open source defect tracking tools like Jira.
• Good knowledge on Testing Life Cycle, Bug/Defect life cycle, Defect tracking and management.
• Expertise in ETL/DWH testing concepts, Informatica power center 10, Informatica power center 11, TOAD.
• Skilled in understanding Business requirements, Designed documents.
• Expertise on various manual testing types like System testing, Regression testing, Functional testing, UAT testing etc.
• Worked with Developers to understand requirements for the purpose of generating test cases.
• Expertise in ALM QC for defect tracking.
• Expertise on Jira for defect tracking.
• Provided Near Real Time solutions to avoid Data Latency using Informatica and UNIX shell scripting.
• Provided ETL Error Handling test scripts.
• Identified performance bottlenecks in ETL Process of data warehousing project and came up with solutions which reduced the run time of a batch.
• Automated production support process by incorporating email alert system in ETL jobs.
• Experience in testing complex mappings using various transformations, and developing strategies for Extraction, Transformation and Loading (ETL) mechanism by using Informatica PowerCenter.
• Good Knowledge in both dimensional and relational modeling concepts like Star-Schema modeling.

TECHNICAL PURVIEW

Domain: Confidential

Databases: Oracle 10g/9i/8i and SQL Server 2000 testing tools: HP ALM, Informatica IDQ, Informatica PowerCenter 10

Microsoft Tools: MS office suite (word, Excel, PowerPoint), communicator, SharePoint.

Test management tools: JIRA, Application Lifecycle Management, Confidential Rational AS400 systems

Programming Languages: VBScript HTML, SQL, JAVA, XML, ASP NET

Operating Systems: Windows NT/XP/2000, UNIX, Linux

Browsers: IE, Firefox, Safari, Chrome.

PROFESSIONAL EXPERIENCE

Confidential

QA Analyst

Responsibilities:

• Reviewed documents in epro to ensure benefit options were coded properly. Testing performed in production environment with live member data following agile methodology.
• Performed system and integration testing.
• Performed transaction testing.
• Performed End- to- End testing.
• Performed claim testing using Cigna specific tools.
• Performed user acceptance testing.
• Served both Re-implementation and transaction team simultaneously.
• Used multiple web- based tools to verify and validate benefits options and copay options.
• Reported and tracked issues.
• Led the installation for re-implementation frame work.
• Worked with facets.
• Experience in performance of build validation and verification, Ad-hoc (Exploratory) Testing
• Experience in manual testing of web applications and had on mobile applications
• Experience in designing test plans, developing test cases, analyzing defects and involving in test closure activities
• Engage with business analysts and developers to gather testing requirements
• Track and report upon testing activities, including testing results, test case coverage, required resources, defects discovered and their status.
• Attend daily and weekly review meetings
• Attended daily stand up and sprint ceremonies.
• Estimating, planning and tracking of all quality assurance and quality control activities.

Operating Systems: Windows XP

Hardware: 64-Bit Processor, 4GB RAM

Software / Special Tools: Agile, Excel, SharePoint, Rx NOVA, Vista

Confidential

Senior Process Associate

Responsibilities:

• Tested the code which converted from VB Script to informatica.
• Involved in ETL Testing, Design and Data Modeling.
• Prepare the Architecture Design document, Technical Design Specification document, Code review check list, unit test case, UAT handoff document for each Interface.
• Involved in creation of Informatica mappings to build business rules to load data.
• Tested the SQL overrides which used in mapping.
• Tested UNIX scripts.
• Testing all logics, Transformations, over rides, exceptions, data and count.

Operating Systems: Windows XP

Hardware: 64-Bit Processor, 4GB RAM

Software / Special Tools: Informatica 10, Sql Developer, Unix,WinScp, HPQC, ALM QC, Jira

Languages: UNIX Shell Scripting.

Confidential

Senior Process Associate

Responsibilities:

• ETL code/mapping Testing.
• Involved in ETL design.
• Prepare the Technical Design Specification document, Code review check list, unit test case, UAT handoff document for each Interface.
• Involved in creation of Informatica mappings to build business rules to load data.
• Testing all logics, Transformations, over rides, exceptions, data and count.
• Testing using prepared test scripts in SIT.

Operating Systems: Windows XP

Hardware: 64-Bit Processor, 4GB RAM

Software / Special Tools: Informatica 10, Sql Developer, Unix,WinScp, HPQC, ALM QC, Jira

Languages: UNIX Shell Scripting.

Senior Process Associate

Responsibilities:

• Performed functional testing activities by using the applications like CAPS, Salesforce, Facets, managing defects in tool- Rally.
• Good experience in the project life cycle phases like Analysis of User Requirements
• Develop test cases and prioritize testing activities.
• Involved in Functional Testing, Re-Testing, Regression Testing.
• Execute all the test cases and report defects, define severity and priority for each defect
• Carry-out regression testing every time when changes are made to the code to fix the defects
• Defect Tracking and Reporting in Rally tool
• Communicated the client & on-site leads on daily basis.