SUMMARY:

• Hands on Functional Testing experience on Enterprise Web Applications Portals , ETL (Migration & Implementation) Projects, Business Intelligence Management Data Warehousing Applications, Business Intelligence OLAP/ROLAP Cubes and Reports (Standard, Executive Dash Board and SharePoint) Applications, Database, Mainframes Applications, SAP CRM, SAP ECC, CRM Mobile and SOAP Web Services backend, Java/J2EE Applications and .Net Applications
• Having expert level experience with JAVA, J2EE and Dot Net Applications Functional testing in respective of Functional System Integration testing, User Acceptance Test support and Non - functional whereas security testing areas
• SOAP Web service calls Functional Testing, Back end testing using SQL, Extraction Transformation Load/Extraction Load Transformation testing, Reports testing, OLAP/ROLAP Cubes testing and Data mart layer testing using BTEQ scripts
• Having proficiency in Release Management Processes, Test Methodologies, and Best Practices and standards, Project estimations in respective of effective resource estimations/utilization and effort estimations
• Hands on experience in Project change control mechanisms, Impact Analysis, Risk Analysis, Defect Management, End to End Testing and Production issues/defects ad-hoc and regression Testing & support
• Well experienced on designing Test Artifacts like Test plans, Test Strategies, Test Activity Planners, Test Scenarios, Test cases, Review records, Status metrics, Root cause analysis, Defect analysis, Impact analysis & Requirement tractability matrices.
• Having good experience with test automation tool QTP and having good exposure in test automation frameworks.
• Having very good experience with Test Methodologies like Waterfall/Sequential, Agile, ITUP, Test-driven development and Test factory in respective of implementation and maintenance projects.
• Hands on experience on Defect Management, Client meetings, Defect Triage calls, Status reporting on daily and weekly basis and Defect reports reporting on weekly and daily basis
• Having 4+ Years of Business Intelligence testing and Test Lead experience with ETL (Extraction, Transformation and Loading) Layer, Data Mart Layer, SSIS Packages, SSAS OLAP/ROLAP Cubes Analysis Layer, Data Warehousing End to End Testing, and BI Presentational layer testing with SSRS SharePoint and Tableau Reports.
• Well experienced on Schell scripts to combine lengthy and repetitive sequences of commands into a single, simple command in UNIX environment Confidential the time of system integration test validations    
• ETL Testing and Business Intelligence Testing expertise using Informatica Power Center, BODS in respective of ETL environments with different/heterogeneous databases like Oracle, SQL Server, SAP and Teradata.
• Executed tests on SAP CRM Applications, SAP ECC, SAP BW,SAP APO and SAP MDM extractors, landing zone (source files), staging area and target EDW
• Having 6 Months of Core Banking testing experience with Confidential and around 6 Months of Financial Services in Cards Domain testing experience with Confidential
• Having 4 Years of Telecom Domain Operational Subsystems and Network Subsystems applications testing experience with clients Confidential & Confidential and Confidential .
• Having excellent communication, presentational and interpersonal skills to handle and deliver projects as a project team lead or a member by putting industry best test practices and standards.

TECHNCIAL SKILLS:

Operating Systems: Windows and UNIX

Environments: SAP ECC, SAP CRM, Data Warehousing, Business Intelligence, ETL, Client/Server, ODS, Enterprise Web Portals, Telecom Dispatch Systems, Retail Supply Chain Management and Repositories and White box test on Real time systems

Databases: Teradata, Oracle, Sybase, DB2 and SQL Server

Internet Scripting Languages: HTML, VB Script and XML

Programming Languages: C and C++

Other ETL and Database Tools: Toad, Teradata SQL Assistance, BODS, Informatica Power Center, DB Visualizer, SQL Developer, Quick 3270 Secure Main Frame systems, AS400, QTP and XML Spy

Test Management Tools: Quality Center and Test Director

Configuration Management Tools: VSS, PRISM, IFP, P8 and SharePoint

White Box Testing Tools: Poly Space and Visual C/C++

Automation Tools: QTP

Domain Experience: SAP CRM, Retail Business Supply Chain Management, Banking, Telecommunication, Cards and Credit Bureau Systems

PROFESSIONAL EXPERIENCE:

Confidential, Columbus, IN

QA Test Professional

• System Testing on SAP CRM Sales, Account Management, Master Data, Marketing, Activities and CRM - Analytics areas
• Confidential Enterprise Portal Functional Testing
• Portal cross browser compatibility testing on Safari, IE9, IE10 and IE11
• US, Canadian and National Accounts User setup and performing role based testing.
• ECC System Testing on Equipment’s, Vehicles, Customers, BW Reports, Vehicles shipment and invoicing, Finance
• ECC System Testing of Incentive Management, Dealer Applications, Service parts, Warranty and Units on Order
• Defect Management Including Defect logging, Defect Tracking and Pulling Metrics Reports using HP Quality Center
• Regression Testing of existing Applications to ensure nothing disturbed due to newly introduced changes to the systems and applications.
• System Testing of National Accounts and Dealer tools, Incentive Management, Dealer Directory, Toyota Special Design Request, Territory Management, Goals Management, Factory Order and Retail Order Management
• System testing of Partner portals like FedEx, Home depot etc..

Software/ Tools/ Technologies Used: SAP, ECC, CRM, Enterprise Portal, HP Quality Center, SQL - Server

Confidential, Costa Mesa, CA

Senior Tester

• Playing a direct role in all aspects of web product manual and automated testing, this will include the use of both black box and grey box API testing mechanisms
• Create, document and maintain test plans, project launch plans and test cases for both existing and new product features like 3B Credit Monitoring, Identity Theft Insurance, Identity Alerts, Credit Limit and Utilization Alerts, Seamless Upgrades and Downgrades, Billing and Data Integrity and Reporting.
• Identifying testable requirements, test scenarios and involved in designing, updating and enhancing test cases and requirement traceability matrix
• Involved in GUI testing, Smoke Testing, Sanity Testing, Re-Testing, Regression Testing, Web services testing, data driven testing and Cognos and Informatica Reports Utilization.
• Created detailed product bug reports including steps to reproduce and other relevant information to streamline the process of correcting defects
• Worked with stakeholders, developers, product managers, and customer representatives to isolate, clarify and document both functional and visual defects
• Assisting in the creation and implementation of a QA workflow for the production team
• Defect logging and re-testing defects using Team Link and Reporting Jobs scheduling and running after test data set-up
• Cognos data Cubes functional testing
• GUI Functional Testing including cross browser compatibility, Regression testing, testing and proof reading.
• Browser compatibility testing, BC regressions, Full regressions on QA, Stage and Prod runways
• Test automation and exception handling.

Software / Tools / Technologies Used: Unix, Windows, Oracle, Internet explorer, Google Chrome, Safari, SQL Server Management Studio, Cognos Reports, Page filler, Control - M Job Scheduler, SharePoint, SRS

Confidential, Pasadena, CA

ETL Tester

• Test plans, Test strategy preparations based on Business, System technical and Release specifications
• Developing test scenarios and test cases based upon business and system requirements and architectural design
• Test data setup using UI tool to simulate test publishers and advertisers hierarchy in respective of business use cases.
• Data validations in respective of data grid, abacus and HP Vertica stage and QA environments
• Data validations in My- SQL server to HP Vertica data migrations
• Universe validations like dimensional usage and fact tables, measures and measure group validations
• SRS testing in user simulation perspective to cover all the dashboard scenarios as per use cases
• Defect logging and re-testing defects using JIRA
• GUI Functional Testing including cross browser compatibility testing

Software/ Tools/ Technologies Used: Shell Scripts, Perl Scripts, SQL Server, My-SQL, HP Vertica, UNIX, Windows, JIRA, HP Vertica

Confidential

ETL Test Lead

• Efforts estimations on resource perspective and cost estimations on budget and deliveries point of view on release basis.
• Test plans, Test strategy and Test activity planner preparations based on Business, System technical and Release specifications
• Developing test scripts and test cases based upon business and system requirements
• Identifying test scenarios to go for detailed test cases design of ETL area in Data Warehouse Source, Stage, EDW, and Semantic/Data mart layer which were built using BTEQ scripts, OLAP/ROLAP Cubes, Reports and Security Testing areas.
• Preparing test data requirement work sheet based on test cases and test scenarios to get data from various data sources like SAP MDM, APO, BW, BPC and operational data sources
• Continuous interaction with project stake holders and with onshore/offshore teams
• System test environment setup and connectivity testing and hands on experience with MLOAD and FAST loads
• Validating the system environments, database schemas & database tables in respective of data flow and data validations of DW ETL area.
• Tested several SSIS packages which were migrated from PL/SQL procedures. And hands on experience on writing PL/SQL programs, stored procedures, and database triggers.
• ETL Test executions based on BODS, Informatica and have thorough test executions of data migrations in enterprise warehouse environment and static, active transformations to verify the complex business rules and data migration
• Test executions on SSRS Share Point and Tableau reports by concentrating on GUI Compatibility, Navigation, User Experience, Usability, Look and Feel and Reports Security.
• Extensive knowledge on job scheduling and developing SQL and Stored procedures to achieve the data transformations
• Test executions on OLAP and ROLAP Cubes ad-hoc reporting area and Semantic/Data Mart Layer executions
• Test executions on ETL area by considering DW entry point ‘Landing Zone to Stage then EDW’
• Daily defect triage meetings and deliverables status meetings handling
• Extensive experience in developing SQL scripts to validate the databases tables and reports data for backend database testing.
• Test scripts design, execution results and defect logging maintained through Microsoft TFS tools.
• Performing regression tests on previous release deliverables using QTP to ensure existed functionality should not disturbed.
• Executing back-end data-driven test efforts with a focus on data transformations between various systems and a data warehouse

Software/ Tools/ Technologies Used: Informatica Power Center, Business Objects Xi, BODS, Quality Center, TFS, Teradata, SQL Server, SharePoint, SSIS, SSAS, SSRS, Tableau, QTP, SVN, Windows and UNIX

Confidential

Senior ETL Test Analyst

• Planning and Designing tests based on Agile methodology Scrums user stories and it’s use cases
• Designing test cases with high level scenarios to go for detailed test cases design after getting approvals from development and scrum master
• Preparing test data requirement work sheet based on test cases and test scenarios to get data from external system CDM and various other sources which are in scope
• Continuous interaction with project stake holders like development and scrum master and with onshore/offshore teams
• Providing early feedback, often, and on anything. It will save the cost of changing major things Confidential the end of the project
• Tests executions on SSIS packages and procedures to ensure data correctness and data integrity in test environments
• ETL Test executions based on Informatica and have through test executions of data migrations on SQL Server and static and active transformations to verify the complex business rules and data migration
• Validating system integration tests based on Test driven development approach, so the developer clearly understand the test features. Based the understanding of concerned developer, he can develop the specific functionality to meet certain test functionality based on use cases and user stories   to cover the requirements and exception conditions.
• Validating the system test environments, database schemas & database tables as part of sanity validations and connectivity testing.
• Project task allocation to team members & monitoring test activities and deliverables according to the timeliness and specifications
• Task and issues monitoring Confidential lead level and reporting to Confidential Delivery Leads.

Software/ Tools/ Technologies Used: Mainframes testing, Informatica, DB2, AS400, HP Quality Center, SQL Server, Oracle, SSIS, Agile-Scrum and Microsoft Office

Confidential

System Test Analyst

• Reviewing Agile Scrum cards and user stories with business and ETE architect teams to understand the architecture and functionality of the application.
• Understanding the sprint scope from functional and non-functional specifications to start system testing for the project.
• Analyzing technical high level designs to prepare Test scenarios, Test Cases for System testing and Regression testing.
• Testing of the product includes Functional Testing, Re-Testing, Regression testing, Compatibility Testing, Usability Testing and System Testing.
• Conducted manual testing of the Application and evaluated if it conforms to user requirement specifications.
• Executing the Test cases and reporting defects using Quality Center (Test and defect Management Tool)
• Performed walkthroughs with the project group for the application’s final move to UAT, Pre-Prod and Prod.
• Executed SIT Test Cases based on Test Driven Development architecture, this helps to conduct through tests on well defined components with its published interfaces and facilitating test creation and ensuring the highest fidelity between test and production unit configuration.
• Conducted Sanity, Smoke, Functional, Regression, System and User Acceptance Testing.
• Responsible for reporting, prioritizing and tracking defects and ensure fixes are included in Interim builds along with the new user stories.
• Manual Bug finding and reporting, re-producing customer filled issues and closing the issue in coordination with development team.
• Participated in weekly/daily review meetings to report the documented test metrics and defects found in the system.

Software/ Tools/ Technologies Used: Mainframes testing, DB2, AS400 HP Quality Center, Agile - Scrum, VSS and Microsoft Office

Confidential, IL

Test Lead

• Gathering Business, System and Change requirements from requirements team and clients based on Agile Scrum methodologies
• Planning the tests as per schedule with available resources on sprint basis
• Designing tests & executing test cases based on sprints detailed designs and use cases
• Continuous interaction with project stake holders (Development and Design Team to understanding scrum methodology sprints functionalities)
• System test environment setup and mentoring testers on Agile Test documentations.
• Performed Functional, GUI and Regression testing
• Responsible for preparing weekly and monthly Testing status reports
• Coordinated with System analyst and Network administrator to ensure server and machines qualify through complete Installation qualification (IQ) and Operational qualification (OQ) procedures.
• Executed walk through tests according to the use-cases to observe and analyze the application’s response in a real-world scenario
• Executing the Test cases and reporting defects.
• Time and cost estimation for requirements based on impact analysis
• Task allocation to the team members, mentoring team & monitoring

Software/ Tools/ Technologies Used: Java, J2EE, Web logic Server, SOAP XML, Oracle, Windows, UNIX, Shell Scripting, Message Queues, Quality Center, WFA Mainframe systems, Service Order processors, SQL Developer, ITUP, P8 and Microsoft Office

Confidential, IL

Onsite Coordinator & Test Lead

• ADSL (Asymmetric Digital subscriber line) & RTSOC (Real time Service order Completion) areas as a Test Lead from client side I am responsible for Test analysis, Test design, Onsite co-coordination, and Coverage analysis as well as familiarity with the system(s) to be tested and concerned test strategy to follow.
• As a Test Designer I am responsible for identifying and describing appropriate test techniques and supporting tools, specifying and verifying the required test environment configurations, and assessing the Test approach and Design and document system test plan and test cases and to follow appropriate baseline procedure.
• Test requirements gathering from requirements team and Analyzing the requirements for identifying the system test and support scope as well as arranging/hosting the test artifacts review calls
• Handful experience with Confidential & Confidential Express, Express one and ITUP process models.
• Impact analysis and time and cost estimations
• As a Team Lead, responsible to assign CR/DR on priority and make sure to transfer sufficient knowledge to get the task completion from off shore staff. Also owning the DR/CR on priority basis make sure to test and provide system test completions to client on tight schedules. Time and cost estimation for requirements based on impact analysis
• Executed Schell scripts to combine lengthy and repetitive sequences of commands into a single, simple command in UNIX environment Confidential the time of system integration test validations
• Executing the Test cases and reporting defects.
• Performed Functional, GUI and Regression testing
• Prepared Quality Metrics and Status Reports on daily/weekly basis to present in status meetings

Software / Tools / Technologies Used: Java, J2EE, Web logic Server, SOAP XML, Oracle, Windows, UNIX, Shell Scripting, Message Queues,AS400, Quality Center, WFA Mainframe systems, Service Order processors like SOP, SONAR, SQL Developer, PRISM and Microsoft Office

Confidential, NJ

ETL & EDB System Test Analyst & Test Lead

• Gathering Business, System requirements and Change requirements from requirements/project architectural team and clients
• Planning the tests as per schedule with available resources
• Designing tests & executing test cases based on release based detailed designs and use cases
• Continuous interaction with project stake holders (Development, System Architect and Design Teams to understanding system functionalities)
• System test environment setup and mentoring testers on project Test documentations and to overcome execution anomalies.
• Analyzing business and functional requirements/specifications to derive test estimations on release specific, test plans, test strategies, test activity planners, test scenarios, test cases, SQL scripts for testing SQL Server, Oracle and Teradata based data warehouse ETL, EDB, BO application areas.
• Validating Extract/Transform/Load (ETL) processes in respective of master and transactional data that load Teradata/Oracle/SQL Server test databases with data feeds from upstream applications GIOM, EFMS, USRP, CRM OMS, NSRP etc. … and provided information deliveries of warehouse data to downstream users.
• TOAD/SQL Developer/SQL Assistance/DB Visualizer is used to perform manual test in regular basis by writing SQL Scripts.
• Maintaining the Traceability Matrix which ensures system test coverage and completeness between Requirements, Design Components, Test Cases and Defects
• Executed test scripts associated to complex transformation logics using Stored procedures, Cursors and Triggers
• Tests executed on SSIS packages by concentrating data validations from source systems and transformation logics while populating target DW tables.
• Participating and hosting review/status/triage weekly/daily meetings with the project management team and walkthroughs
• Test Management activities like maintaining, uploading System Test scripts and various other project documentation into HP Quality Center.
• Used Quality Centre in order to maintain test documents and record test results and to log identified errors/bugs/defects.
• Testing several UNIX Shell Scripts for job scheduling and generalizing a sequence of operations on one set of data, into a procedure that can be applied to any similar set of data
• Tested various business reports which are developed using Business Objects reporting services tool.
• Coordinating with Architect, Design, Development and UAT Teams to drive project effectively into production by ensuring Quality in the product
• Performing regression tests on previous release deliverables using QTP to ensure existed functionality should not disturbed.

Software/ Tools/ Technologies Used: Java, J2EE, Web logic Server, SOP, SONAR, SOAP XML, Oracle, SQL Server, Teradata, SOAP UI, Internet explorer, Mozilla Fire Fox, Windows, UNIX, Shell Scripting, Message Queues, Quality Center, DWH Informatica, Cognos, Business Objects, SSIS, Oracle, SQL Server, Sybase, Teradata, Toad, SQL Developer, QTP, PRISM and Microsoft Office

Confidential

System Test Analyst

• Conducting thorough functional testing of Confidential GS Portal
• Gathering user stories based on Agile Scrums
• Continues interaction with the System Architects and Development team about the changes, Issues and Clarifications
• Planning the tests based on user expectations and user stories
• Designing test plans & test cases high level scenarios to go for detailed test cases design in respective of Web Application testing which includes compatibility testing, navigation testing, user experience, security testing and usability testing
• Test cases allocation to team members, mentoring team & monitoring test execution
• QC status maintenance about test status and reports should send on daily & weekly basis.
• Executed test scripts associated to complex Confidential -SQL scripts, Stored procedures, Cursors and Triggers
• TOAD/SQL Developer/SQL Assistance/DB Visualizer is used to perform manual test in regular basis by writing SQL Scripts
• Automation of Enterprise Confidential GS Portal using QTP

Software / Tools / Technologies Used: Java, J2EE, Web logic Server, Oracle, Windows, UNIX, Schell Scripting, QTP, Quality Center, Oracle, Terada data, SQL, Visual Source Safe, MS - Excel and MS - Word