SUMMARY:

• Excellent knowledge in complete Software Test Life Cycle (STLC).
• Very good understanding of the Software Development Life Cycle (SDLC) methodologies.
• Worked in Onsite, Offshore, Near Shore, Multi - Vendor delivery models.
• Worked as Onsite Coordinator/Lead as well as Offshore Lead owning all QA activities.
• Extensive experience in Manual Testing using Black box Testing, Grey box and white box testing.
• Good Experience in QA Methodology and Validations to ensure industry standards.
• Excellent troubleshooting and debugging skills.
• Worked on Mobile/PDA applications testing.
• Very good experience in developing automation frameworks for automating the data/ETL validation. Performance Testing of ETL Jobs.
• Extensive experience in writing Test Plans, Test Cases/Scenarios, Traceability Matrix and Status Reporting.
• Worked on Business domains like eCommerce, Travel, CRM, ERP, Accounting, Order Management / Billing / Invoicing, Sales, Stock Accounting, Finance / Securities (BFSI), Life Sciences, Pharma / Medical, Healthcare, Contract Management, Business Process Management (BPM), and Human Resources (HR).
• Extensively used ETL methodology for supporting data extraction, transformations and loading processing, in a corporate-wide-ETL Solution using SSIS, Datastage, XTelligent, Informatica and HIVE (Big Data Hadoop) .
• Extensive testing experience in Business Intelligence tools like Actuate, Click-view, SSRS, Business Objects, Cognos and Crystal Reports testing.
• Worked on Enterprise Application Integration (EAI) implementations (BizTalk & TIBCO) testing. Experience in Web, e-Commerce, SOA, Client/Server, Mainframes applications testing. Knowledge of PEGA.
• Involved in testing the technical features like Index Management, Data Compression & Resource Governor as part of Dog Fooding in Confidential .
• Worked on 250+ Terra bytes Data Warehouse DB applications.
• Good knowledge of Database architecture and Database Server/DBA Concepts.
• Having experience in testing Data Conversion. (migrating data from legacy / heterogeneous applications/databases to new system / Up-gradation testing).
• Good Collaboration and mentoring skills. And good technical/domain knowledge to actively participate in technical discussions with Developers, Architects, and PMs.
• Extensive Experience in writing complex PL/SQL, and SQL Statements in Oracle, SQL Server, DB2, Sybase, Teradata databases and Big Data Hadoop. Good knowledge in developing Packages, Stored Procedures, Functions and Triggers.
• Good knowledge of using Oracle APIs (Dynamic SQL, DBMS PIPE, DBMS ALERT etc).
• Hands on testing experience in SIEBEL Loyalty and SIABEL CTMS data migration.
• Proven experience in Automation, Functional Testing, Regression Testing, Integration Testing, End-to-End, Unit, Compatibility, Installation Testing.
• Excellent at Problem Solving, anticipating risks, and finding/proposing Solutions for the Project risks/issues.
• Ability to work independently as well as in team with excellent inter-personnel, problem solving skills.
• Flexible and versatile to adapt any new environment and work on any project without supervision and full accountability. Quick onboarding in the new projects.

TECHNICAL SKILLS:

ETL: Informatica 8.x, Datastage 7.X, Abinitio, SAP Data Services XI, SQL* Loader, Snap Logic, Shell Scripts.

Reporting Tools: Actuate, Click View, Crystal Reports, Cognos, Flex, Business Objects

RDBMS: Big Data, Hadoop, Cloudera Impala, Vertica, Oracle, SQL Server, Teradata, DB2, Sybase, Pervasive, MS-Access, Clipper, FoxPro and dBase

Testing Tools: Confidential Internal DB automation framework, VSTF, QTP 8.0, WinRunner7.x, TestComplete 3.x, Clear Quest, Bugzilla, Product Studio, VSTF, Clarify, HP Quality Center, ALM, JIRA

Config. / Content Management Tools: VSTF, Surround SCM, Visual Source Safe, WIKI, Sharepoint

Packages / Tools: MS-Office, Borland Office, Star Office, TOAD, Benthic, SQL*Plus, SSMS, Putty, Tidal job Schedular, HIVE, dbVisualizer, dBeaver

Languages / Scripting: Visual Basic, Java, VB Script, PL/SQL, T-SQL, SQL, VBA, HTML, XML, PHP, Ruby

Operating System: Windows, Linux/Unix, DOS

PROFESSIONAL EXPERIENCE:

Confidential, Grapevine-TX

Sr. QA Analyst

Responsibilities:

• Simultaneously worked on multiple projects (handled 4 projects in parallel at one point of time). And responsible for all QA deliverables.
• Implemented ETL QA Process.
• Creation of Test Data and validating ETL Jobs.
• Validation of BI Reports.

Environment: Big Data, Hadoop, Cloudera Impala, HIVE, Vertica, SQL Server, Oracle, TeraData, UNIX, Shell Scripts, Tidal Job Scheduler, SSIS, SnapLogic, Informatica, TIBCO, Ruby.

Confidential, Richardson-TX

Data Quality Analyst

Responsibilities:

• Test Planning, execution, and status reporting.
• Test Data creation for ETL Jobs validation.
• Creating SQL scripts / source data to verify Batch/Real time data loading jobs using test automation jobs.

Environment: DataStage, DB2, TeraData, BigData, Hive, XML, UNIX.

Confidential, Dallas-TX

QA Analyst

Responsibilities:

• Testing Air, Hotel and Car ecommerce modules.
• Validating SIEBEL Loyalty application. And Mobile applications testing.
• Verifying data in mainframe application (SABRE and AMADEUS GDS) where all booking information is stored.
• Worked on technical features, Reports and database performance tuning features testing using complex SQL queries. Validated Perl / Shell scripts.
• Performing System, Regression, Data validation testing on below applications:
• Swalife.com - used by southwest employees and other airlines employees for booking their Air tickets.
• Exchange tickets related application.
• Application used by customer support agents in airports (QIK, CS2).
• Creation of Promotional Codes with various business rules for testing (alice.com).
• Written complex VBA macros to generate customized reports from Quality Center and to format them in Confidential Excel for Management.
• Created Automation Test Scripts.

Environment: Windows, UNIX, Java, BizTalk, HP Quality Center/ALM, JIRA, XML, Teradata, Oracle, SQL Server, Abinitio, Oracle Jobs, Perl / Shell Scripts, VBA, SIEBEL, SABRE View.

Confidential, Bellevue-WA

Test Design Engineer

Responsibilities:

• Worked in Enterprise Data Warehouse group.
• Provided guidance and support to off-shore team (in China).
• Test Planning for multiple projects and Task allocation to the offshore resources.
• Test scenario and test case authoring.
• Written Complex SQL Queries to Check the data loads in Different Stages
• Performed Hardware Upgrade testing and User Acceptance Testing (UAT) of the RAIDs (requirements / defects are called as RAIDs).
• Building the code and deploying it in TEST and Pre-Production (PPE) Environments. And validating the applications.
• Verifying the build deployment in Production environment (there will be daily Production deployments in EDW Group) and validating data.
• ETL & Reports testing developed in SAP Data Services, Informatica & BO.
• Testing of HR Data Mart, Problem Management DB ETL and BI applications testing.
• Responsible for Final Journal Entry & Confidential Affiliate Network applications hotfixes and enhancements testing.

Environment: DB2, SQL Server 2005, Informatica, SAP Data Services, SSIS, SSRS, HIVE (Big Data Hadoop), Business Objects, PeopleSoft, Product Studio (RAID), Perforce, Toad, SSMS, WinSCP, Windows Server 2003, LINUX, Pearl, Shell Scripts.

Confidential

Lead QA

Responsibilities:

• Created Test Plan / Test Strategy / Effort Estimation for SIEBEL CTMS Data Migration Project.
• Implemented new approach for ETL data validation.
• Developed automation framework for automating the data validation test cases.
• Interacted with BA/Data Analysts and Developers to analyze and resolve the issues.
• Performed Validation testing on the heterogeneous applications (Siebel, PeopleSoft, SalesForce, MDM Master Data Management System and legacy).
• Closely worked with Data warehousing developers to understand the implementation of ETL mappings for data transfer from Source Staging T arget databases.
• Performed B ack end / Schema Validation, Database testing using SQL.
• Attended regular requirements walk-throughs, project meetings and weekly team meeting. Tested reports developed in Cognos, Flex.
• Performed Data testing, Transformation testing, Business rules and Data quality
• Collaborated with other application groups for knowledge transfer.
• Suggested architecture level changes in implementation.

Environment: Oracle 10g, SQL Server 2000, Informatica 8.x, Cognos, Flex, Application Server, OSB, Siebel CTMS, PeopleSoft, SalesForce, MDM (Master Data Management), Legacy Applications, MS Office, Windows XP, Unix, Quality Center, QTP & PL/SQL.

Confidential

Test Lead / SDET

Responsibilities:

• Test Planning and Involved in preparing Rough Order of Magnitude (ROM).
• Created Test Scenarios, Test Cases based on Functional Specification, Data Mapping and Technical Specification.
• Automating test cases using the Confidential internal automation tools.
• Involved in performing Data validation of Source, Delta, Staging, Factory & Repository databases in 2.5 Terra Byte data warehouse environment.
• Used Product Studio & VSTF for defect tracking also followed up with development team to verify bug fixes and re-tested the fixed issues.
• Tested Data movement and Data validation from various source’s to Data Warehouses (Factory & Repository servers).
• Tested Resource Governor Technical feature in SQL Server.
• Tested the functionalities as per business requirements in SQL Server Reporting Services (SSRS) for analyzing the data.
• Performed the database testing by writing the SQL queries to validate the data.
• Validated Windows NT Batch Jobs which pulls data from MSP COR LW databases.
• Integration testing was performed on BizTalk implementation, validated the XML messages schema and data flow from LW BizTalk SAP.
• Attended regular project meetings and weekly team meeting.
• Hands on Experience in developing of Requirement Traceability Matrix (RTM).
• Worked on License Wizard suite of applications (Web & Client/Server).

Environment: SQL Server 2005/2008, DTS, SSIS, SSRS, SSMS, Windows NT Batch, Windows 2003 Server, Visual Basic, ASP.Net, SAP, BiZTalk, MS-Access, SAP.

Confidential

Module Leader

Responsibilities:

• Worked on Credit Risk application as part of BASEL-II implementation.
• Tested ETL, Reports and Web applications in the project and delivered highest quality deliverables.
• Reviewing Business/Functional requirements and technical specifications of the application.
• Analyzing the test requirements and written new Test Cases as per the requirements.
• Performed Manual Testing on Web and Reports applications as per the requirements. Created SQL for reports validation based on Reports Requirements and Technical Specification documents.
• Involved in various kinds of testing (Regressions Testing, Functional Testing, System Testing) .
• Validated data enrichment logic based on the Data Enrichment Logic document.
• Written SQL Queries and PL/SQL Anonymous Blocks to perform database testing.
• Validated data flow from various sources like Text files, Oracle and SQL Server databases implemented using Data Stage jobs.
• Tested various reports developed in Actuate.
• Developed various reports to communicate testing issues with the project manager/client.

Environment: Oracle 9i, PL/SQL, Data Stage, Java, Web Spear, AutoSys, TextPad, FTP, Rational Clear Quest, Rational Robot, Windows 2000, Unix, MS Office, TOAD.

Confidential

Sr. Test Engineer

Responsibilities:

• Worked on Life Science CRM - Sales Force Automation (SFA) implementations testing for Solvay Pharmaceuticals, UCB and Sanofi, Pfizer.
• Performed Integration, Functional, Regression, Sanity, Installation and End-to-End testing.
• Validated Enterprise Application Integration (EAI) implementation (TIBCO) by performing Integration and End-to-End testing.
• Mobile/PDA applications testing and validation of data according to the Data mapping.
• Worked on Application Integration Services (AIS) Testing.
• Performed Feature Testing, System Testing, UAT Testing, mock Go Live testing.
• Worked with Meta Data files used in the project and modified them to suit to the QA requirements.
• Used DataStage for Extracting, cleansing, transforming, integrating and loading data into data warehouse.
• Mentored team in understanding Integration and Database testing.
• Performed security testing to see how well the system is protected against unauthorized access (User Manager Application).

Environment: Oracle 9i, Sybase, PL/SQL, Benthic, SQL* Plus, Data Stage, Informatica, XTelligent, TIBCO, EMS, Informatica, Clarify, Surround SCM, QTP, Test Complete, Windows 2000.

Confidential

I T-Officer

Responsibilities:

• Developed application to consolidate different Factories Financial and Cost accounting information.
• Converted Legacy FoxPro application which consolidates different branches Sales and Accounting data into Visual Basic.
• Designed Finance and Costing reporting applications which provides reporting based on European / Indian Financial requirements (calendar / financial year).
• Worked on Order Management / Billing / Invoicing, Sales & Stock Accounting applications extensively. Processing of month-end data and consolidating it.
• Developed Human Resources (HR) application to track all the employees’ information and reports generation.
• Monthly reports generation and MIS preparation based on the various sources data.
• Co-ordinated with the external vendor for implementation of the Sales and Stock Accounting System development / testing / implementation activities.
• Co-ordinated application and data migration testing activities.
• Lotus Notes and GiftUlti mail administration. IT Assets tracking and management.
• Network / System administration, Helpdesk support and Vendor Management.

Environment: Windows 2000, LAN, WAN, Lotus Notes Mail, GiftUlti Mail, MS-Access 2000, FoxPro, Visual Basic 6.0 and VBA, Oracle 8i, Developper/2000, ASP.NET, C#, XML, VB/JavaScript, MS-SQL 2000 & Crystal Reports, SAP.

Confidential

Responsibilities:

• Supported client’s IT infrastructure as part of Compaq / Digital Equipment India’s Facilities Management Services.
• Helpdesk support for all the desktops at various client locations. Installation of Hardware and Software. System administration of Novell Netware, Windows NT and UNIX. Access control and user administration.
• Performed Mail servers (cc-Mail) admin. Windows and Lotus Notes clients config.
• Daily, Weekly and Monthly MIS reports generation.
• Co-ordinated with various vendors for H/W, S/W and Network related issues.
• Developed application to track Helpdesk calls in Developper/2000 and Oracle.

Environment: LAN, Novell Netware 3.x/4.x, Windows NT/3.11, 95, SCO UNIX, DOS, Ingress, Oracle, cc-Mail, Lotus Notes, Borland Office, Confidential Office.

Confidential

Systems Officer

Responsibilities:

• Handling all branch related IT operations.
• Computerization of other branches and training the users on applications.
• Collecting data from branches and consolidation of data.
• Working on Order Management and Stock Accounting applications.

Environment: Windows, Novell Netware, Delphi, Power Builder.