PROFILE SUMMARY:

• Skilled Software Professional with 9 years of experience having extended knowledge and experience as Software Quality Analyst and Technology Lead, well acquainted with SDLC and STLC processes. Self - motivated team player with excellent Analytical, Technical and Communication skills. Have E2E Implementation, Testing, Project Management experience and Strong Technical expertise in
• Translating requirements, Provide feasibility reports, Solution designing and developing functional/technical artifacts.
• Defining test strategy, test estimation, creating test plans, test case documents, traceability matrix, defect reporting and bug tracking.
• Extensive experience in System testing, Functional, Integration, Regression testing and verify data integrity using Structured Query Language.
• High Proficiency in Big Data Testing, ETL Testing, Siebel E2E Agile Testing, SFDC Testing, Data Integration Testing, Confidential E2E Implementation and Production Support
• Expertise in testing large & complex products that follows agile, waterfall and other iterative test methodologies.
• Strong knowledge on Hadoop HDFS architecture and experience in testing ETL Processes and Mapping Rules.
• Experience in testing marketing solutions designed for campaign management using IBM Unica Campaign Management tool.
• Testing Salesforce (SFDC) application customized for order processing and fulfillment modules.
• Expert in developing and understanding complex SQL queries.
• Experience in Siebel Configuration, Scripting & Workflows with Proficiency in Quote, Order Management and Pricing Administration
• Functional testing experience in various domains like Telecom, Retail, Technology and CRM verticals like Call Center, Sales and eCommunications.
• Siebel Architecture and Data Model and proficient with Siebel Tools and Client in configuration and customization of Siebel Objects at multiple levels.
• Develop and maintain strong working relationships with other IT Services, IT solutions functions and customers to expedite delivery of IT solution.
• Agile sprint planning, daily scrum, organizing triage and review meetings.
• Have been a key player in Providing Optimal Solutions for Performance tuning.
• Expertise in Application and Test Management using HP ALM / Quality Center and JIRA.
• Quick learner and flexible to use any functional / automation testing tool.
• Managing the testing team as a QA lead and working on onsite/offshore model.
• Certified Force.Com Developer (DEV401) and Salesforce Administrator (ADM201).

TECHNICAL SUMMARY:

CRM Application: Siebel Sales/ Callcenter, Salesforce

Marketing Application: IBM Unica Campaign

Testing Tools: SoapUI, Toad, Cucumber

Tracking Tools: HP ALM / Quality Center, JIRA, Rational ClearQuest

Languages: Siebel eScript, Gherkin, SQL, HiveQL

Version Control: Rational Clear Case, VSS

Database: Oracle, SQL Server, Tera Data, Hadoop

Other Tools: Aginity Amp, Sqoop, MS Office, Visio

Operating System: Windows, UNIX

EXPERIENCE SUMMARY:

Confidential

QA Consultant

Tools: & Technologies: Hadoop, Hive, Aginity Amp, SQL Server, Teradata, Sqoop, IBM Campaign (UNICA), JIRA, HP ALM 12.01, Putty, SharePoint, Microsoft Office

Responsibilities:

• Analyze business and system requirements, create detailed test plans and identifying proper test suite/coverage as per requirements.
• Identifying the source data to validate complex ETL transformations to cover different test scenarios and to validate the data quality checks.
• Involved in validating the files from FMW and other 3rd party servers against the database tables.
• Analyze the Meta data & Mapping documents to understand the business rules and logic for data transformation and validate the Data Marts.
• Validating the marketing solutions designed for campaign management in IBM Unica Campaign Management tool.
• Writing Complex Queries to validate the Referential and Data integrity between related tables from multiple databases like Oracle, SQL Server, Teradata and Hadoop.
• Responsible for analyzing root-cause for identified defects, reporting the issues and follow up with developers and track it to closure.
• Maintaining requirements, test scripts, execution status in HP ALM and determine the associated KPI’s for the tasks.
• Handle daily status call with off-shore team, review test cases, co-ordinate test execution and verify the test result set.
• Work together with Business Analysts, Developers and Data Architects to ensure the highest quality product delivery

Confidential

CRM QA Consultant

Tools: & Technologies: SFDC, HTML, Oracle 10g, JIRA, Windows, Microsoft Office, Visio

Responsibilities:

• Trained and Certified on Salesforce.Com
• Delivered Test estimates, Test Strategy/Test Plan,Test Progress/Defect metrics and regular status reporting.
• Documented high-level requirements identified in project documentation into testable, detailed requirements
• Executed the UI testing for the customized application created by force.com for customer order tracking and fulfillment, logged the defects and analyzed the configurations and code to identify the root cause of the defects.
• Collaborated with Business Analyst, Project Managers and Technical team to ensure business acceptance.
• Organized status meetings, design reviews, peer reviews and defect triage calls.
• Co-ordinated the QA team and provided quality deliverables.

Confidential

Technology Lead

Tools: & Technologies: Siebel 7.7, Siebel Application Server, Siebel Call Center, HP ALM, Oracle 9i, SQL, Toad, Windows, Microsoft Office

Responsibilities:

• Tech Lead to handle multiple modules, tracked the daily activities, attended standup calls & onsite/offshore sync up.
• Analyzed requirements and translated the Business Requirement Document to Functional Specification Document and Detailed Design Document
• Developed technical solutions ensuring quality checklists.
• Worked closely with the Business Analysts in planning and implementing appropriate solutions.
• Delivered the Code with defined quality, Design Review, Code Review, unit testing & support SQA during functional testing.
• Build Kit / documentation for deployment into production.
• Reported development status through various metrics and communicated to key stakeholders on regular basis.
• Facilitated resolution and communication of cross-application / organization architectural issues and decisions

Confidential

CRM Support Lead

Tools: & Technologies: Visual Source Safe, HP Quality Center, Oracle 9i, SQL, Toad, Siebel 8.0, Siebel Tools, eScript, Siebel Application Server, Siebel Sales, Microsoft Office, Visio

Responsibilities:

• Production support to Enterprise Order Capture application Enterprise Sales Application that supports Account management, Lead Management, Quote Management, Products & Pricing and Customer Order Management.
• Coordinated the team to increase the % of deliveries with Zero escaped defects.
• Responsible to maintain bug fix quality and SLA Adherence.
• Involved on preparing various reports and attending status meeting.
• To monitor the application performance constantly and implement various application performance improvement techniques in case of performance issue.
• Conducted sessions and mentored the new resources
• Involved in RCA Analysis and identifying solution for recurring RCAs to reduce the inflow of production support tickets

CRM Developer

Confidential

Responsibilities:

• Involved in Requirement Analysis, Identifying Application Impact, Determine LOE and task level breakdown.
• Acquired the knowledge of Quote Management, Products & Pricing and Customer Order Management.
• Prepared functional specification document based on the Business requirement and prepared High Level Solution and Detailed Design Document.
• Customized the Siebel application for most critical Pricing & Quotes module through various configurations, scripting, process automation using workflow and involved in unit testing and code review.
• Co-ordinated the configuration control, defect prevention activities and represented the project for Organization wide Quality Audit.
• Responsible for Onsite-Offshore Sync up and Status Report on development activities.
• Developed unit testing plan and involved in unit testing and code reviews.
• Coordinated the bug fixing for System Integration Testing & UAT
• Involved in Application Performance tuning and implemented various Performance Improvement techniques.

Confidential

Senior Software Engineer

Tools: & Technologies: Visual Source Safe, HP Quality Center, Oracle 8i, SQL, Toad, Windows, Siebel 7.8, Siebel Application Server, Siebel Call Center Application, Microsoft Office.

Responsibilities:

• Test execution Lead for a team of 17 members for 5 releases and presented quality deliverables.
• Involved in sprint planning, daily scrum and review meetings.
• Prepared test estimates, resource estimates, traceability matrix, regression coverage matrix and finalized regression suites and its automation feasibilities.
• Performed integration testing between Account, Contact, Opportunity, Order and Agreement modules.
• Attended regular client calls and discuss the execution status and defect progress.
• Delivered test closure reports and participated in the Production business calls.
• Facilitated resolution and communication of cross-application / organization architectural issues & decisions.
• Mentored team members on functional and technical aspects.
• Involved in User acceptance testing

Quality Analyst

Confidential

Responsibilities:

• Involved in finalizing regression suite and its automation feasibilities.
• Performed regression test execution, both automation and manual.
• Performed billing verification testing on database using complex SQL queries.
• Utilized defect management and test tracking tools for defect logging and test execution status reports throughout the testing lifecycle.
• Effectively lead issue triage meetings with scrum team to plan defect fixes for sprints by reviewing the defect priority and severity with product owner
• Developed Automation scripts for the common E2E functional scenarios.
• Worked together with developers and E2E designer in resolving technical issues.
• Circulated daily status reports and sprint Progress reports to the senior management.

Test Engineer

Confidential

Responsibilities:

• Developed and executed manual test cases based on the Requirement documents.
• Involved in testing the online order processing functionality through Bt.Com online channel, the web based application developed using Java.
• Executed IVR testing scenarios to verify various business processes.
• Performed database validation using complex SQL queries
• Performed integration testing between Account, Contact and Service Request modules.
• Documented the test cases and execution results in Quality Center.
• Reported defects in the tracking tool, follow up with developers and track it to closure.
• Participated in Agile Scrum meetings, design reviews, peer reviews and execution status calls.
• Involved in Database black box testing at the interface to verify mappings, incoming/outgoing data values.

Tools: & Technologies: Rational ClearQuest, Oracle 8, SQL, Toad, Windows XP/NT, Siebel 7.5, Siebel Application Server, Siebel Sales, Microsoft Office

Test Engineer

Confidential

Responsibilities:

• Involved in Identifying test conditions, creating test designs and test cases.
• Performed test execution and logged the results in test management tool.
• Used SQL queries to extract the data from the database and to check the data flow process.
• Executed interface test cases and involved in regression testing phase.
• Analyzed test results, reported and tracked defects using defect tracking tool.
• Assisted application developers and technical support team in identifying and resolving defects.