SUMMARY

• Over 7 years of Experience in Software Quality Assurance and Testing in different environments and platforms.
• Expertise in Automated Software Quality Testing & Manual Testing of Web based and Client - Server
• Well versed with various types Software Development methodologies- Waterfall, Agile, RUP, and Iterative.
• Extensive experience in reviewing Business Requirement Documents, Software Requirement Documents and preparing Test Cases, Test scripts and Execution.
• Extensive experience in Test Data Management, creating test data suite, tracking the results and using for regression testing
• Extensively worked as a Techno-Functional Testing consultant in providing CRM solution with excellent business domain experience in Siebel Sales, Siebel Financial Services, ePharma, Siebel Marketing Applications.
• Involved in fine tuning SQL overrides for performance Enhancements.
• Ability to develop complicated SQL script for Data validation testing by running SQL script, procedures.
• Extensively used HP ALM to upload requirements, write test cases.
• Proficient in SQL, Shell Scripting and PL/SQL coding and experience in Performance Tuning of SQL and Stored Procedures.
• Hands on experience in Performance Tuning of mappings, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings and sessions.
• Having excellent knowledge in Unit Testing, System testing, Integration, Regression, End to End Testing.
• Extensive experience with Capital Markets, Online Banking, SharePoint, LoadRunner, Quality Centre, Siebel CRM, SAP ERP, .NET, J2EE.
• Having knowledge in Doing Estimation and Preparing Schedule for Different phases of Test cycle.
• Excellent knowledge in preparing Test case plans and RTM.
• Excellent experience in working with Quality Center.
• Experience inSiebel CRMapplications in Testing, Data Migration, and Customization of Siebel 8.x
• Excellent knowledge in Handing Critical Defects and Production Related Defects.
• Strong technical Knowledge of UNIX Utilities, Shell Script to automate process.
• Experience in testing Business Report developed in Cognos
• Experience in Black box testing with a complete QA cycle - from testing, defect logging and verification of fixed bugs
• Extensive experience in Functional testing, Integration/System testing, Regression testing and User Acceptance testing.
• Good functional and QA working knowledge in Siebel CRM Testing Web Services and Callcenter modules.
• Extensive experience in Testing Siebel CRM 8.1/7.8/7.7/7.5/7. x versions
• Excellent team player and excellent communication skills.

TECHNICAL SKILLS

Reporting Tools: Business Object XI 3.1, Cognos 8.0 Suite, Crystal Reports, SSAS, SSRS, MicroStrategy 8.x

Data Modeling: Star-Schema Modeling, Snowflake-Schema Modeling, Fact and dimension tables, Pivot Tables, Erwin

Testing Tools: Win Runner, Load Runner, Test Director, HP Quality Center, Rational Tools

RDBMS: Oracle 10g/9i/8i/7.x, MS SQL Server 2005/2008, UDB DB2, Sybase, Teradata V2R6, MS Access 2008

Programming: UNIX Shell Scripting, Korn Shell, C Shell, Bourne Shell, Bash, SQL, SQL*Plus, PL/SQL, TOAD, C++

Web Technologies: JavaScript, HTML 4.0, and DHTML, .NET, Java, J2EE, XML, XSD, XSLT

Environment: UNIX, MVS, IBM AIX 4.2/4.3, Hyperion, Win 3.x/95/98, NT 4.0

Databases: Netezza NPS 8050

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, NC

QA Tester - Siebel CRM

Responsibilities:

• Involved in Business analysis and requirements gathering.
• Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
• Tested different reports, graphs and pivot reports in Microstrategy dashboards
• Formulate and coordinate the UAT strategy and plan for the entire NDM Program. Implement, lead and manage the UAT Strategy and Plan.
• Performed manual testing executing all the test cases in ALM before switching to automation testing.
• Worked on interfaces between Siebel CRM and third party system
• Reported defects using HP ALM Verified fixes and closed bugs during regression testing.
• Used HP ALM to Report, track and, monitor defects.
• Participate in the creation of Test Scenarios & Test Cases with the UAT Team and the Business Analysts.
• Executed test cases; the TC execution is tracked inside Microsoft Test Manager (MTM)
• Created UAT test cases and Executed them, helped the end users understand and use the application
• Tested Siebel CRM application for home depot special order and services.Client/Server applications such as CRM Siebel Financial package,
• Expertise in Analysis of Test scenarios and documenting Test cases and d
• Participated in Integration, System, Smoke and User Acceptance Testing.
• Created test data to satisfy the requirement needs and to identify the functionality of the transformations.
• Worked on Team Foundation Server (TFS) and Microsoft Test Manager (MTM) to effectively manage the product life cycle.
• Worked with business team to test the reports developed in Microstrategy. unit testing, integrated testing and validated results with Business Analyst and/or customer.
• Reviewed and approved database modifications
• Responsible to create, Execute Test Sets in HP ALM Test Lab
• Responsible to create defects using HP ALM
• Generate Reports using HP ALM at the time of execution and releases
• Performed Teradata SQL Queries, creating Tables, and Views by following Teradata Best Practices.
• Written several shell scripts using UNIX Korn shell for file transfers, error log creations and log file cleanup process.
• Worked on creating scripts for Siebel CRM to base testing for one files resides in many directory.
• Witten SQL queries to validate the reports generated from Microstrategy.
• Tested several UNIX shell scripting for File validation and also PL/SQL programming
• Used Clear Quest to track and report system defects and bug fixes. Written modification requests for the bugs in the application and helped developers to track and resolve the problems.
• Validating the Archive process to purge the data that meet the defined business rules.
• Writing complex SQL queries using Case Logic, Intersect, Minus, Sub Queries, Inline Views, and Union in Oracle.
• Performed Web based testing, Siebel CRM, Client Server Testing,White Box Testing and Black Box Testing.
• Involved in validating the aggregate table based on the rollup process documented in the data mapping.
• Generated test scenarios, test cases and test data. Executed tests, created problem reports
• Conducted various management activities by analyzing and verifying test results, providing status reports
• Worked with CRM Tools-Dynamics, Sales force for validating the packages
• Worked with business analysts, developers, and content department to resolve issues.
• Tested the application by writing SQL Queries and creating pivot views as to perform back-end testing.

Environment: SQL, PL/SQL, UNIX, Siebel CRM 8.1,Shell Scripts, ALM/HP Quality Center 11, Teradata 13, MLOAD, FLOAD, TPUMP, Microstrategy, Oracle, SQL Plus, Access, SOAP, XML, XML Spy, SQL

Confidential, Richmond, VA

QA Tester

Responsibilities:

• Analyzed business requirements, system requirements, data mapping requirement specifications, and responsible for documenting functional requirements and supplementary requirements in Quality Center 10
• Initiated Siebel CRM to Base testing process involves QA testing .Trained team members on Siebel to Base Testing
• Written numerous complex SQL Scripts to query the Teradata and Oracle DB for data validation.
• Interacted with users for designing UAT Test Plans and Test Cases
• Uploaded requirements into Quality Center and responsible for assigning the tasks in the Quality Center.
• Day-to-day Cognos administration activities like monitoring Scheduled jobs like Cube refresh, Impromptu scheduled reports, Backup and recovery maintenance.
• Upon completion of UAT with no outstanding issues, convey the message of successful UAT session to the Project Team and the Senior Managements for obtaining Approvals and Sign-off.
• Document all the findings/results/defects in UAT in ALM (Application Lifecycle Management). Work towards the quick resolution and resumption of testing.
• Provide the Business Users with all the required details/tools, user manuals & guides, related information to conduct their UAT
• Written several complex SQL queries for validating Cognos Reports.
• Get the daily, weekly and monthly status reports from the offshore and onsite team and Provide progress and status reports to the QA manager in one to one meetings
• Participated in test plan and test scenario walkthroughs and also in the UAT Kickoff Meetings
• Assisted in creation of Test plan documents with the lead and created numerous test scripts and test case documents and Traceability matrices.
• Performed risk assessed Functionality Testing.
• Tested SVS which was an IBM Main Frame Application Interfaced to Siebel CRM using unix
• Extensively worked on Oracle DB and queried the DB using TOAD.
• Responsible for different Data mapping activities from Source systems to Teradata.
• Queried Teradata Database and validated the data using SQL Assistant.
• Liaison between the offshore team and the onsite QA team.
• Tested whether the reports developed in Cognos are as per company standards.
• Run batch jobs for loading database tables from flat files using SQL*Loader
• Effectively communicated the requirements and helped the offshore team in understanding the requirements and arranged meetings with the business analysts
• Scheduled the jobs using Auto sys and automated the jobs to be run at specific time and automated the reports.
• Coordinated UAT with Business Users for all releases, production defects and application enhancements
• Written UNIX scripts to perform certain tasks and assisting developers with problems and SQL optimization.

Environment: MS SQL Server 2008, Oracle 11g, Siebel CRM, SQL, PL/SQL, IBM DB2, AGILE, Teradata 12.0, SQL *Loader, JCL, Mainframes, Toad, UNIX Shell Scripting, Windows XP/2000, Teradata SQL Assistant, Cognos 8.4, COBOL, ALM/HP Quality Center 11.

Confidential, Wilmington, DE

QA Tester

Responsibilities:

• Created test case scenarios, executed test cases and maintained defects in internal bug tracking systems
• Developed and executed various manual testing scenarios and exceptionally documented the process to perform functional testing of the application
• Tested reports in Cognos using Analysis studio, Report studio and query studio.
• Debugging the SQL-Statements and stored procedures for various business scenarios.
• Written extensive PERL and UNIX Shell scripting for data parsing and text parsing needs including archiving the old data, running backend jobs & setting up of job dependencies.
• Performed extensive Data Validation, Data Verification against Data Warehouse
• Loading Flat file Data into Teradata tables using UNIX Shell scripts.
• Tested several Cognos Reports for several business needs including Dashboards, Drill-Down, Master-Detailed, Aggregated, KPI’s and Web Reports.
• Tested and validated the Report Net reports by running similar SQL queries against the source system(s).
• Did work with SOA testing involving SOAP, XML, and REST.
• Tested data feeds from XML to Database.
• Tested SQL queries, PL/SQL scripts to validate the data and performance of the database
• Extracted data from various sources like Oracle, flat files and SQL Server
• Tested and validated the cube data, ensuring that the data is correct by comparing the data results to comparable source system reports or by querying individual transactions and forms.
• Testing the source and target databases for conformance to specifications
• Involved in testing Cognos reports for data quality and cosmetics according to requirements
• Conditional testing of constraints based on the business rules
• Design and execute the test cases on the application as per company standards and tracked the defects using HP Quality Center.
• Helped the testing team documenting the system requirements and testing system development. Designed and implemented basic SQL queries for QA testing and report / data validation. Set up definitions and process for test phases including Product, Integration, System and User Acceptance testing (UAT).
• Accessing Mainframes and validating the data
• Worked with SQL, PL/SQL and functions to test the database integrity (Oracle).
• Compared query result sets from different database systems using UNIX diff command.
• Designed and prepared scripts to monitor uptime/downtime of different system components
• Preventing occurrences of multiple runs by flagging processed dates
• Testing of records with logical delete using flags
• Analyzed and created the bug tracking reporting and summary report in the Quality Center
• Interacting with senior peers or subject matter experts to learn more about the data
• Identifying duplicate records in the staging area before data gets processed
• Extensively written test scripts for back-end validations

Environment: SQL, Teradata V2R6,, SQL Server 2008, Siebel CRM, HP Quality Center 10.0,XML, XSLT, PERL, DTS, T-SQL, TOAD, Mainframes, Teradata SQL Assistant 6.0, Oracle 9i/10g, PL/SQL, MVS, IBM DB2, SAS, Cognos ReportNet8.0, MS Access/Excel/Visio, UNIX Shell Scripting

Confidential, Chicago, IL

QA Tester

Responsibilities:

• Extensively involved in Business Analysis and Requirements Gathering
• Analyzed business requirements and interfaced with vendors for development and enhancement of a system to support multiple business areas including Asset Management, portfolio management and risk management.
• Involved in gathering, analyzing, distilling and clearly conveying complex information to business and project team members through JAD sessions
• Involved in analyzing the requests for new, enhanced, and modified systems, against user and business requirements using RUP methodology
• Conducted interviews and facilitate requirements gathering, process analysis, and application design sessions with company staff across all levels and functions
• Produced documents for business requirements (requirements matrix), design requirements, gap analysis, solution recommendations, test cases, test plans and reference guides
• Coordinated system walk through, training, User Acceptance Testing (UAT) and facilitate issue resolution
• Written several shell scripts using UNIX Korn shell for file transfers, error log creations and log file cleanup process.
• Developed SQL scripts to validate the data loaded into warehouse and Data Mart tables using Informatica.
• Developed Reports and Graphs to present the results to the management.
• Performed Data Driven Testing of the Application for different users/data sets
• Preparation of test data for various levels of testing
• Gave production support in scheduling and tested this data with the existing data.
• Developed Test cases for the data warehouse in Oracle System
• Worked on Oracle to implement the project and written the Test Plan and Test Cases for the module Sales Cycle
• Extensively used SQL programming in backend and front-end functions, procedures, packages to implement business rules and security
• Developed detailed System test plan including test procedures and test cases
• Conducted Integration testing, Performance testing, Functional testing and Load testing to ensure that the application meets the requirements and to ensure usability readiness
• Developed test automation scripts for Regression and Performance testing
• Identified and resolved many application bugs and bottlenecks
• Verified all the functional and load requirements are met

Environment: SQL, PL/SQL, SQL Server 2005/2008, UNIX, Shell Scripting, Toad,, VBScript, Windows NT, Sun Solaris, Oracle 9i, Business Objects

Confidential

QA Tester

Responsibilities:

• Did data reconciliation for all the DataStage jobs for testing needs..
• Involved in understanding of business processes to learn business requirements.
• Validated the data extracted from different systems into Source.
• Defined and implemented approaches to load and extract data from database using DataStage.
• Used Erwin for data modeling (i.e. modifying the staging and SQL scripts on Oracle and MS Access Environments).
• Conducted System testing for each phase of the application.
• Involved in preparing Test Scripts and Test cases based on the functional specifications.
• Executed backend testing of the application by writing SQL queries.
• Used Defect Tracking System Rational Clear Quest to report bugs found in different testing stages.
• Executed Test Procedures and documented Test Results
• Executed jobs through sequencer for better performance and easy maintenance.
• Used Data Stage Director to run and monitor the jobs for performance statistics.
• Involved in performance tuning of the jobs.
• Used T-SQL for validating the data generated at OLAP server.

Environment: Oracle, SQL*Plus, SQL, Rational Clear Quest, Clear Case, SQL Server 2000, PL/SQL, Visual Basic 6.0, Windows 95, Test Director, XML, XSD, XSLT, Java and UNIX, Korn Shell scripting