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 wif 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 teh results and using for regression testing
• Extensively worked as a Techno-Functional Testing consultant in providing CRM solution wif 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 wif 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 wif 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 wif 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 teh UAT strategy and plan for teh entire NDM Program. Implement, lead and manage teh UAT Strategy and Plan.
• Performed manual testing executing all teh 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 teh creation of Test Scenarios & Test Cases wif teh UAT Team and teh Business Analysts.
• Executed test cases; teh TC execution is tracked inside Microsoft Test Manager (MTM)
• Created UAT test cases and Executed them, halped teh end users understand and use teh 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 teh requirement needs and to identify teh functionality of teh transformations.
• Worked on Team Foundation Server (TFS) and Microsoft Test Manager (MTM) to TEMPeffectively manage teh product life cycle.
• Worked wif business team to test teh reports developed in Microstrategy. unit testing, integrated testing and validated results wif 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 teh 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 teh 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 teh bugs in teh application and halped developers to track and resolve teh problems.
• Validating teh Archive process to purge teh data dat meet teh 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 teh aggregate table based on teh rollup process documented in teh 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 wif CRM Tools-Dynamics, Sales force for validating teh packages
• Worked wif business analysts, developers, and content department to resolve issues.
• Tested teh 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 teh Teradata and Oracle DB for data validation.
• Interacted wif users for designing UAT Test Plans and Test Cases
• Uploaded requirements into Quality Center and responsible for assigning teh tasks in teh 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 wif no outstanding issues, convey teh message of successful UAT session to teh Project Team and teh Senior Managements for obtaining Approvals and Sign-off.
• Document all teh findings/results/defects in UAT in ALM (Application Lifecycle Management). Work towards teh quick resolution and resumption of testing.
• Provide teh Business Users wif all teh required details/tools, user manuals & guides, related information to conduct their UAT
• Written several complex SQL queries for validating Cognos Reports.
• Get teh daily, weekly and monthly status reports from teh offshore and onsite team and Provide progress and status reports to teh QA manager in one to one meetings
• Participated in test plan and test scenario walkthroughs and also in teh UAT Kickoff Meetings
• Assisted in creation of Test plan documents wif teh 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 teh DB using TOAD.
• Responsible for different Data mapping activities from Source systems to Teradata.
• Queried Teradata Database and validated teh data using SQL Assistant.
• Liaison between teh offshore team and teh onsite QA team.
• Tested whether teh reports developed in Cognos are as per company standards.
• Run batch jobs for loading database tables from flat files using SQL*Loader
• TEMPEffectively communicated teh requirements and halped teh offshore team in understanding teh requirements and arranged meetings wif teh business analysts
• Scheduled teh jobs using Auto sys and automated teh jobs to be run at specific time and automated teh reports.
• Coordinated UAT wif Business Users for all releases, production defects and application enhancements
• Written UNIX scripts to perform certain tasks and assisting developers wif 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 teh process to perform functional testing of teh application
• Tested reports in Cognos using Analysis studio, Report studio and query studio.
• Debugging teh 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 teh 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 teh Report Net reports by running similar SQL queries against teh source system(s).
• Did work wif SOA testing involving SOAP, XML, and REST.
• Tested data feeds from XML to Database.
• Tested SQL queries, PL/SQL scripts to validate teh data and performance of teh database
• Extracted data from various sources like Oracle, flat files and SQL Server
• Tested and validated teh cube data, ensuring dat teh data is correct by comparing teh data results to comparable source system reports or by querying individual transactions and forms.
• Testing teh 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 teh business rules
• Design and execute teh test cases on teh application as per company standards and tracked teh defects using HP Quality Center.
• Helped teh testing team documenting teh 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 teh data
• Worked wif SQL, PL/SQL and functions to test teh 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 wif logical delete using flags
• Analyzed and created teh bug tracking reporting and summary report in teh Quality Center
• Interacting wif senior peers or subject matter experts to learn more about teh data
• Identifying duplicate records in teh 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 wif 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 teh 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 wif 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 teh data loaded into warehouse and Data Mart tables using Informatica.
• Developed Reports and Graphs to present teh results to teh management.
• Performed Data Driven Testing of teh Application for different users/data sets
• Preparation of test data for various levels of testing
• Gave production support in scheduling and tested this data wif teh existing data.
• Developed Test cases for teh data warehouse in Oracle System
• Worked on Oracle to implement teh project and written teh Test Plan and Test Cases for teh 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 dat teh application meets teh 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 teh 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 teh DataStage jobs for testing needs..
• Involved in understanding of business processes to learn business requirements.
• Validated teh 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 (me.e. modifying teh staging and SQL scripts on Oracle and MS Access Environments).
• Conducted System testing for each phase of teh application.
• Involved in preparing Test Scripts and Test cases based on teh functional specifications.
• Executed backend testing of teh 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 teh jobs for performance statistics.
• Involved in performance tuning of teh jobs.
• Used T-SQL for validating teh 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