SUMMARY

• 14 Years of experience in software industry of which
• 4 Years as ETL QA Analyst.
• 5 Years as Sr. QA Analyst( Manual & Automation)
• 2 Years of experience in Sales Force CRM Testing.
• 3 Years as a Siebel developer.
• Good experience in Finance, Insurance, Retail and Telecom domains.
• Strong understanding of QA Process, SDLC, Waterfall, Agile methodologies and worked through different releases of product.
• Strong understanding on RDBMS, ETL Processing and DW Concepts.
• Extensive testing ETL experience SSIS and SSRS.
• Expertise in Test Automation Framework withCucumberandSelenium WebDriver.
• Involved in Regression testing which includes execution of Automation scripts, logging and tracking defects.
• Hands on experience testing Rest/SOAP APIs using SOAP UI, Postman tools.
• Extensively worked in various Siebel Enterprise modules such as Siebel Call Center, Siebel Financial Services, Siebel Marketing, and Siebel Automotive.
• Good experience in Configuration, Workflows and e - Scripting. Worked extensively with Technical Design from Functional Specifications. Strong understanding of Siebel systems and Siebel CRM business processes as well as experience working with application data and data relationships.
• Hands on experience in testing the Salesforce CRM UI system and customized APIs in banking domain.
• Extensive experience in developing SQL scripts to validate the databases tables and reports data for backend database testing.
• Experience in writingTest Plans, definingTest Cases, developing and maintainingtest scripts, analyzing the results of scripts, interaction with team members in fixing the errors.
• Good Knowledge on tools like JIRA, Confluence, GitHub, Maven, Microsoft TFS and HP ALM.
• Travelled to Australia, Japan and Vietnam as a part of project assignments.
• Good Knowledge in Informatica 8.1/7.1/6.2 (Power Center/ Power Mart) (Designer, Workflow Manager, Workflow Monitor and Server Manager).

TECHNICAL SKILLS

ETL Tools: Microsoft SSIS 2012, Informatica, DataStage, Ab Initio.

Databases: Oracle SQL, MS-SQL Server, MySQL, MS-Access.

API Testing Tools: SOAP UI, Postman.

Automation Test Tools: Selenium WebDriver, Cucumber, TestNG .

CRM: Siebel 8.1, Siebel 8.0, Siebel 7.5, Siebel 7.8, Siebel 6.3, Siebel Configuration and Sales force(SFDC).

Test Management Tool: HP ALM, Microsoft TFS, JIRA.

Reports: SSRS, PowerBI, Tableau.

Version Control Tools: SVN, Github.

Utility Tools: SQL Developer, TOAD.

Programming: PL/SQL, Core Java

Operating Systems: Windows NT/ 2000, UNIX and LINUX.

Functional: Order Management, Siebel Call Center, Siebel eAutomotives, Siebel Sales and UCM, Call Center, Sales, Marketing, ePharma, eCommunication, eMedia, Automotive, Partner Portal, Oil and Gas, Consumer Goods and experience in SIA/SEA applications.

Industry: Banking & Financial Services, Consumer Packaged Goods, Automobile, Public Sector and Telecommunications.

PROFESSIONAL EXPERIENCE

Confidential

Sr. QA Analyst

Responsibilities:

• Analyzed the system requirements and developed detailed test plans and test cases and provided the documentation. Collaborated with product management teams in an agile environment to develop a comprehensive set of tests for web-based applications.
• Involved in testing the migrated data from different systems to Microsoft SSIS data warehousing tool.
• Tested a number of complex ETL mappings and reusable transformations for daily data loads.
• Creating test cases for ETL mappings and design documents for production support.
• Developed ETL test scripts based on technical specifications/Data design documents and Source to Target mappings.
• Developed complex SQL queries for querying data against different data bases for data verification process.
• Create, Maintain and Execution of test Scripts using BDD Framework through Cucumber and Selenium web driver.
• Involved in testing the various objects like accounts, Contacts, Tasks, Opportunity and Lead.
• Involved in API testing using SOAP UI.
• Performed role-based testing to ensure that the protected data is available only to the authorized users of the respective organization.
• Tested page layouts, search layouts to organize fields, custom links, related lists and VF Pages on a record detail and edit page.
• Tested Custom objects, Custom tabs, validation rules, Workflow Rules, Auto-Response Rules, Page layouts which were customized as per the business requirements.
• Tested several custom reports which have been created and deployed using salesforce.com platform.

Confidential

Business Analyst/ Functional Tester

Responsibilities:

• Gathered and documented business requirements for existing and future business systems.
• Responsible for capturing the requirements for the Integration between Network and OSS/BSS applications.
• Delivered business requirements, high level and detailed technical specifications and then lead the development and business teams through design, testing and implementation phases.
• Analyzed and DevelopedTest Plan, Test Cases, Test Scripts, Expected Test ResultsandTest Procedurefromfunctional requirement.
• SupportedEnd-to-endtesting for downstream systems.
• Involved in test HSD(High Speed Data) - Internet activation / deactivation functionality from Siebel.
• Involved in test HSD purchase functionality from portal to order flow to OSM, UIM inventory and check in ASAP Activation system.
• Involved in large business (B2B) orders testing from Siebel to OSM.
• Involved in testing the billing system for the large business orders.

Confidential

Sr.QA Analyst

Responsibilities:

• Gathered and documented business requirements for existing and future business systems.
• Delivered business requirements, high level and detailed technical specifications and then lead the development and business teams through design, testing and implementation phases.
• Extensively involved in writing and designing templates for theTest PlansandTest cases
• Identified theTest Casesand documented them inQuality Center.
• Designed and AnalyzedTest casedesign document basing on theFunctional Requirement Specificationsto implement through testing process.
• Followed inPage Object Design Patternfor writing test cases inTestNg.
• Base-lineandRegressiontests were scheduled and performed on every Release and build.
• SupportedEnd-to-endtesting for downstream systems.
• Loaded theTest Datainto the HPQC to prepare for the execution ofTest Cases
• Expertise in generating thedaily defectdetailedreportusing Quality Center for the other project stake holders and the project Management
• Maintained bug lists for critical issues usingQuality Center
• Develop/Execute ETL Test cases to validate business requirements.

Confidential

QA Analyst

Responsibilities:

• Extensively involved in writing and designing templates for theTest PlansandTest cases
• Identified theTest Casesand documented them inQuality Center.
• Worked with the Developers and the Test Lead to verify theTest Cases.
• Designed and AnalyzedTest casedesign document basing on theFunctional Requirement Specificationsto implement through testing process.
• Tested web services using Soap UI.
• Involved in creating theTraceability matrixbased onFunctional requirementin each module.
• Base-lineandRegressiontests were scheduled and performed on every Release and build.
• Expertise in generating thedaily defectdetailedreportusing Quality Center for the other project stake holders and the project Management
• Maintained bug lists for critical issues usingQuality Center.

Confidential

QA Analyst

Responsibilities:

• Extensively involved in writing and designing templates for theTest PlansandTest cases
• Identified theTest Casesand documented them inQuality Center.
• Worked with the Developers and the Test Lead to verify theTest Cases.
• Analyzed and DevelopedTest Plan, Test Cases, Test Scripts, Expected Test ResultsandTest Procedurefromfunctional.
• Involved in creating theTraceability matrixbased onFunctional requirementin each module.
• Base-lineandRegressiontests were scheduled and performed on every Release and build.
• Loaded theTest Datainto the HPQC to prepare for the execution ofTest Cases
• Expertise in generating thedaily defectdetailedreportusing Quality Center for the other project stake holders and the project Management
• Maintained bug lists for critical issues usingQuality Center

Confidential

QA Engineer

Responsibilities:

• Understand Functional Requirements and analysis.
• Created Test Plan and the strategy documents.
• Participated in Code walk-troughs
• Raising defects in Quality center & tracking them to closure
• Participated in defect tracking meetings with the development team
• Review the scripts created by peers to adhere to conventions
• Created Design document for the scripts created.

Environment: s: Siebel 8.1, Oracle 10g.

Confidential

QA Engineer

Responsibilities:

• Understand Functional Requirements and analysis.
• Created Test Plan and the strategy documents.
• Participated in Code walk-troughs
• Raising defects in Quality center & tracking them to closure
• Participated in defect tracking meetings with the development team
• Review the scripts created by peers to adhere to conventions
• Created Design document for the scripts created.

Environment: s: Siebel 8.1, Oracle 10g.

Confidential

Senior Siebel Consultant

Responsibilities:

• Developed the reports using Siebel BI Publisher.
• Involved in the BI Publisher server installation.
• Implemented the connectivity between Siebel and BI server.
• Involved in creating Master detail reports, conditional reports
• Involved in testing, fixing the bugs and deploying the reports.

Environment: s: Siebel 8.1, Oracle 10g