• Masters in MIS with over 8+ Plus years of Professional experience in Siebel Quality Assurance, Data Analyst/Quality Assurance Methodologies with extensive experience in performing Manual and Automation Testing.
• Methodologies with extensive experience in performing Manual and Automation Testing.
• Strong experience in developing Test Plans and Test cases, Test Procedures and Test Scripts using requirements and design documents for functional testing, where as good understanding on mapping documents and write SQL queries for data verification.
• Expertise in performing different types of Testing: Black box, Module, Integration, Stress, Volume, System, Performance, User Acceptance Testing and Regression.
• Experience in gathering Business requirement, creating Functional detail documents, Technical detail documents and understanding scope of project.
• Responsible interacting with Business users and Technical team to transfer business requirements into technical specification and creating feasibility metrics.
• Experience in testing Siebel Module e.g. marketing, eSales, and Call Center, E-commerce, Credit Card Payment Processing and Client-Server applications on different environments.
• Strong knowledge of Software Development Life Cycle (SDLC).
• Experienced in Siebel application Analysis, Requirements Management, Quality Assurance, Modeling, Configuration Management and Change Management.
• Knowledge and Experience working with 21 CFR part 11 guidelines
• Good understanding of RDBM Systems (Oracle, SQL Server).
• Strong knowledge and experience in Siebel EIM developing Configuration (ifb) files and EIM jobs with working knowledge in SQL, PL/SQL and UNIX.
• Excellent knowledge on OLTP using Siebel EIM and OLAP using Informatica, PlSql Scripts.
• Excellent written and verbal communication skills.

SKILLS:
Siebel Expertise: Siebel EIM/Remote Administration/Configuration/BA/QA, Siebel 99/99.5/8, Siebel Workflows, Siebel Analytics.
O/S: Windows 9x / NT / 2000 / XP
Languages: SQL, PL/SQL, T-SQL,
Databases: Oracle 8/8i/9i, MS SQL Server, MS Access etc
Main Frames: AS-400 (Power MHS), I-Series
Testing Tools: Mercury suite (Test Director, Load Runner, QTP, Rational Suite (Test Manager), Clear Quest, HP Quality Center 10.0
Reporting Tools: Actuate 4.0/5.0/6.0/7.0, Analytics

EDUCATION:
Bachelor of Science
Other:

• Completed Siebel 7.5/7 Core Consultant Course (Burlington US) 2003
• Completed Siebel 2000 E-Business Essentials Course 2001
• Completed CRA (Clinical Research Associates) certification course

FUNCTIONAL AND TECHNICAL EXPERIENCE:

Vendor: Confidential
Client: Confidential
Role: Sr. Test Analyst Sep 2010- present

Project Responsibilities:

• Responsibilities include but not limited to definition, design, development, execution of Test Scripts for new business process integration.
• Major task is to validate and rollout third party software integration with Siebel applications, around the globe.
• Analyze business requirements and translate to technical specifications after coordinating with business user and development team.
• Design, develop and implement Test Scenarios, test scripts as well as integration solutions in Oracle/Siebel based applications.
• Uses a hands-on approach to provide solutions and follow standard SDLC Project Lifecycle and development methodologies.
• Effectively analyzes, troubleshoots any issues and defects encountered. 
  Support Release management and code migration processes.
• Configuring Siebel with Inventory control, Credit card processing, IBM workflows etc
• Validation Integration with other applications and data cleansing tools.
• Implementing match, merge, publish/subscribe features for all different type of Marriott property.
• Configuration and integration of Siebel reports with OBIEE and other applications.
• Prepared Test Plans for each release, written Test Cases and executed them as part of Functional Testing. Prepared Test Reports and Deliverables and submitted for version releases.
• Worked closely with developers to catch up with builds, release and cycles, Also Regular interaction with the core developers helped us in fixing the defects in less time.
• Used IBM Rational Clear Case for updating the status of all the Test Cases & Test Scripts that are executed during testing process.
• Experience in administering and configuring Siebel CRM application to include workflows, page layouts, user profiles, roles, security access, data validation, data utilities, reports and dashboards.
• Validated Siebel workflow rules, validation rules and functionality of different fields for Opportunity, Account, and Contacts in the Siebel CRM.
• Verified the ability of the system to create a Case for various record types in Siebel, on verifying pick list /LOVs for different fields in Siebel.
• Involved in data content, data relationships and structure, processes that manage, transform data mapping source fields to Siebel interface tables.
• Validated data imports into Siebel CRM and logged any discrepancies that were discovered.
• Support in using of Enterprise Integration Manager (EIM) for data conversions from non Siebel database to Siebel database and analyzing results.
• Worked for Version document with SME. Primary Liaison between Business User and Development Team.
• Upgraded the existing Test Scripts and created new scripts for client application to be able to work for new versions and patches, which improved product quality.

Vendor: Confidential
Client: Confidential 09/09- 08/10
Role: Siebel Test Analyst II

Project Responsibilities:

• Includes but not limited to Evaluate business requirement and technical specification documents in order to craft test strategies and LOE assessments which would account for, durations, constraints, assumptions, etc. that are needed in order to fulfill test objectives.
• Reviewed Technical Specs with Business and Technical team.
• Wrote Test Plans in MS Word for Manual Testing, System Testing, Integration Testing, Performance Testing, Regression Testing & reviewed their consistency with the business requirements.
• Performed functional testing, regression testing and UAT on Siebel 8.0 applications.
• Wrote Test Cases in HP Quality Center 10.0 for user registration, access to training material, and activity log-in, reviewed the test cases and finalized
• Documented the outcomes of all the testing in MS Word and MS PowerPoint
• Developed automated Test Scripts in Win Runner using Test Script Language (TSL) for Functional Testing, Regression Testing, Data Driven Testing, Usability Testing, and Verifying Specific content through using Checkpoints.
• Assisted in building a Business Analysis Process Model using Rational Rose and Visio.
• Review and validate design, EIM data mapping, and specifications so as to ensure requirements trace ability and to determine application/component functional readiness requirements.
• Create and maintain test plans that define test objectives, methods and tools to be employed for the assigned project.
• Create & contribute to the definition of detailed project schedules, conveying clearly defined milestones for test preparation, execution, and compliance reporting activities and deliverables. Execute assigned tasks in harmony with the test schedule.
• Participate in the creation, distribution, and walkthrough of software test cases, scripts and other documents surrounding testing activities and ensure that all testing activities and deliverables are conducted/produced in compliance with company standards.
• Organization, coordination and participation in test plan/case reviews, Design and preparation of test data.
• Responsible for SIEBEL base table data mapping to LEGACY Source data Transformation, Conversion and Validation using TOAD and writing SQL queries.
• Profile data to discover anomalies, Document, track and communicate data issues and remediation efforts leveraging change control procedures.
• Document the business rules of the data, Work with development team to ensure that data rules are being supported and properly maintained
• Leads the effort and partners with the business lines to identify and document data quality issues
• Rising, recording and retesting defects using QC 10.0. & Keep management update on progress reporting against assigned tasks.
• Influence the use of automation tools to manage problems, develop test cases, execute regression and load testing, and facilitate the creation of supporting documents

 Vendor: Confidential
Client: Confidential-Mellon, NY
Role: SR. Siebel QA 2/07- 04/08

Project Responsibilities:

• My role as a Sr. QA Person, writing Test Plans from the requirement documents and Use Cases.
• Also performed Siebel 7.5 Functional Testing, Backend Testing, Integration Testing, Regression Testing and UAT (User Acceptance Testing).
• Management mandates extensive/thorough testing of all enhancements and modifications to Quarterly/Phase releases software.
• Assignments including but not limited to Test planning, Creation of test data and Test scenarios, Test management and defect tracking/reporting.
• Participated in Load Testing and Stress Testing.
• Responsible to attend walkthrough meetings for requirement reviews and provided feedback to the Business Analysts.
• Involve in the SIEBEL data verification by running backend queries, wrote SQL queries directly to the database.
• Besides these, I was coordinating defect-tracking meeting with offshore and on shore resources.
• Responsible to maintain defects matrix using Test Director.
• Also responsible to manage and coordinate defects were fixed, duplicate and Status modification.
• Duties include planning, management and execution of test activities for migration of Mellon data into BONY database.
• Defect management – serving as defect administrator; serving as liaison between developers, business analysts and end-users to resolve defects; reporting defect information to management.
• Support Product Group with testing coordination during Customer System and Acceptance testing cycles and day-to-day Production Issues.

Vendor: Confidential
Client: Confidential, NC 6/06-12/06
Role: SR. Tester

• Contracted to participate on a software development team to develop a Siebel Analytic reports by transforming the current excel and manual reporting process to a web-based Siebel application.
• Also focus on analytics dashboards and Meta data to ensure that the configured dashboards meet Customers documented business requirements.
• Involve testing Scripts and execution Siebel upgrade version from 7.5 to Siebel 7.8.
• Tasked with documenting, analyzing, and defining the user and system requirements and features that included the use of a multi-server architecture, and the interfaces with existing Siebel Marketing module (OLTP) and Legacy DB.
• Organized and facilitated customers and internal stakeholders conducting requirements gathering sessions with the purpose of defining the functional business and system requirements utilizing use cases in work flow diagrams and textual descriptions, documenting requirements in a requirements database to track development.
• Wrote clear, concise detailed system requirements specification documents and user documentation in accordance to TIAA-CREF guidelines and standards at a level where developers designed and developed the application.
• Prepared routine reports on the progress of assigned tasks, identifying and resolving project constraints.
• Responsible for data quality and data validation, to assist Customer with testing overall data consistency and quality across Customers UAT and production environments.

Vendor: Confidential
Client: Confidential, NC 1/06-5/06
Role: Siebel QA

• Participated in SIEBEL Integration and System testing and involved in writing SIEBEL e-Business module Test plans, Test cases and Test Scripts using Test Director.
• Managed Siebel Business requirements using Test Director and Executed Manual and Automated tests cases. Transaction testing was carried out and the SQL queries are written for testing to retrieve data backend DB2.
• Create/maintain datasets records of test outcomes and issues had good understanding on Siebel EIM Data Mapping for Siebel Tables and legacy DB.
• Performed all phases of SIEBEL end-to-end testing, e.g. System, Functional, Regression.
• Worked according to HIPPA Guidelines
• Involved in Business Object Reports testing integrated with Siebel DB and Legacy DB.
• Developed 40% Siebel QTP scripts for Library functions for checking Data Driven and GUI object.
• Isolate and communicate defects and requirement variances into Test Director.
• Responsible for Issue escalation and weekly status reporting
• Identify improvements for system availability or services. Determines risk factors and creates mitigation plans.
• Takes initiative and responsibility for assign task. Demonstrates tenacity and ownership of issues throughout the resolution process.

Vendor: Confidential
Client: Confidential 7/05-12/05
Role: Data Analyst

• Serve as a member of a team providing support with Siebel eClinical data migration and integration requirement definitions.
• Worked as per 21 CFR part 11 guidelines and EMIA Guidelines.
• Perform requirements through document review and client interviews. Prepare requirements deliverables by collecting and analyzing written materials.
• Create designs through a thorough understanding of Siebel proprietary data structures and database system.
• Deploy Siebel data migration and integration solutions through a specific understanding of IT concepts, including unit and systems testing, release management, and production support.
• Define, design and build standardized reporting, data mining and analytic applications.
• Use SQL statements, scripting and other tools as necessary to automate development of expected results.
• Map data scenarios and test cases back to the underlying requirements
• Enter and track defects using Rational Clear Quest
• Maintain the test environments (e.g., data loads, database backups, restarting the servers, requesting deployments, troubleshooting issues).
• Communicate with support, business and development teams to resolve issues during test execution. Recent experience coding VBA (Visual Basic for Access) in Excel 2003.

Vendor: Confidential
Client: Confidential VA 3/05-7/05
Role: QA/Tester

• Created and maintained SIEBEL Call Center manual Test Cases and Test Plans for Siebel sales Enterprise
• Developed, implemented test strategy for content verification.
• Responsible for Testing Functional accuracy of SIEBEL MVG and pick lists after configuration changes. Access control; View level and Data level in Siebel Sales Enterprise.
• Tested Siebel customizations extensively for Accounts, Contacts, Opportunity, Products and Activities Screens, Views and Applets. Test configuration and customizations done by Developers for Business Components, Applets and Business Objects
• Responsible for load, stress, performance testing on Siebel 7.5.2 Sales using load Runner.
• During the load test measured throughput, response time, and server performance and gave scalability estimate.
• Data Requirements Analysis: Reviewed new data requirements for missing or unclear data information. Involved in Conversion from Siebel Smart Serve to One View.
• Creation of Test cases: Created test cases based on business requirements, design specifications and data mapping documents. Test cases created using SQL Queries.
• Data Quality Testing: Executed data validation test cases to verify all business rules are met for the interfaces. Reviewed and tested those data relationships 1:1, 1: M, M: M is correctly displayed in base tables and is displayed correctly on the GUI.
• Reported Defects into the QA track system where they are assigned on to Development.

Vendor: Confidential
Client: Confidential, NJ 2/04-2/05
Role: Data Analyst

• Responsible for Analyzing Functional Design Document and Business Requirement Document to prepare Test Plans, Test Cases, and Test Data for Siebel eClinical module.
• Conduct walk-through and Assessments with the Business Analysts and QA Managers to clarify issues related to Quality Assurance/Quality Control with given project tasks.
• Strategic outlining and mapping of Standard Operating Procedures of project sections in accordance with GCP and FDA guidelines.
• Identified defects and monitored status until issues were resolved through communication with Software Developers. Also responsible for cross checking of Database after modification made by DBA based on Consistency Checks reports in Siebel Test/Production Environment database.
• Created and updated the tractability matrix used to organize requirements and test cases. Assist database team for gathering Matrix and Benchmarking exercises.
• Train remote users to use Siebel Applications before granting them Siebel Access License, also responsible for Siebel Remote Client Configuration.

Employer: Confidential, NY 10/00-12/03
Role: Technical Officer

• This project involves the configuration of Siebel Call center Application for the client\'s financial activities. The main objective of this project is to upgrade the Siebel Version 6.3.1 to 7.7.2.
• Performed load, stress, and performance testing on Siebel Marketing 7 using load Runner.
• Also created and maintained manual Test Cases and Test Plans for Siebel Sales Enterprise.
• Developed, implemented test strategy for content verification.
• Test configuration and customizations done by developers for business components, applets and business objects.
• Testing Functional accuracy of Siebel MVG and pick lists after configuration changes.
• Involved in interfacing between Siebel Enterprise Applications and Legacy applications using Siebel EIM for Contacts, Accounts and Activities.
• Customized user Interface Objects to meet Business specifications.
• Tested Siebel customizations extensively for Accounts, Contacts, Opportunity, Products and Activities Screens, Views and Applets.
• Tested User interfaces Objects like Applets, Views, Forms etc., as per the requirements
• Used Load Runner extensively for the load and volume testing and Win Runner for Functional and Regression Testing
• Used Test Director as central repository for Test scripts and Test results for global access.