SUMMARY

• Over 8+ Years of Extensive experience in IT Industry wif emphasis on Quality Assurance & Software Testing.
• More TEMPthan 15 months of experience in Data Warehousing/ ETL Testing wifin the environment of Oracle, SQL Server, Informatica Power Center.
• Experience includes testing of applications which use integrated database using Informatica, Business Objects, Oracle (11g, 10g, 9i, 8i) and DB2.
• Worked and reviewed along wif Business Analysts and Functional Team members to translate Business requirements into ETL technical specifications.
• Worked in multiple responsibilities such as reviewing of ETL architecture, ETL design, and analysis and ETL technical specifications.
• Tested ETL applications in relational databases and flat files using Informatica.
• Experience in UNIX; Unix knowledge in executing jobs, Mocking up the test data, debugging.
• Excellent Functional knowledge on various domains like Oil & Gas, Finance/Banking, ETL/Database management, Telecommunications, Education.
• Hands - on experience and strong understanding of Software Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC).
• Good experience of Quality Assurance methodologies like Waterfall, V-Model, Agile, Scrum, RAD, TDD.
• Experience in designing, documenting, and executing Test Plan/Strategy, test harness, test scenarios/scripts & test cases for manual, automated & bug tracking tools.
• Well versed wif writing detailed test cases for functional & Nonfunctional requirements.
• Experience in creating Traceability Matrix to ensure comprehensive test coverage of requirements.
• Expert in different types of testing that includes Black Box testing, Smoke testing, Functional testing, System Integration testing, End-to-End Testing, Regression testing & User Acceptance testing (UAT) & Involved in Load Testing, Performance Testing & Stress Testing.
• Proficiency in Back-End Testing/Database Testing specifically in developing and executing SQL queries to interact wif databases.
• Expertise in use of Quality Center & Test Director for writing test cases, test execution, defect management, defect tracking and Bug Reporting.
• Experience in developing, trouble shooting and customizing Performance scripts using J-Meter.
• Experience wif version control, configuration management and change control procedures using tools such as Rational Clear Case.
• Extensive experience in testing using automation Tool like Selenium and QC.
• Good working knowledge of major Operating Systems and tested applications on windows 98/NT/2000/XP, LINUX & UNIX environments.
• An TEMPeffective communicator wif strong analytical abilities combined wif skills to plan, implement & presentation of projects.

PROFESSIONAL EXPERIENCE

Confidential

ETL Testing, SQL Developer

Job Responsibilities:

• Interact wif the product delivery team; participate in product requirement/design reviews to provide input on completeness of functional requirements, product designs, and schedules.
• Identify interdependencies, ambiguities or omissions, and make suggestions to improve requirements and ensure usability/testability
• Review software documentation to ensure technical accuracy, compliance, or completeness, wif focus to mitigate risks.
• Design test plans, scenarios, scripts, and/or procedures to determine product quality or release readiness.
• Develop testing scenarios/cases to address areas such as database impacts, software scenarios, regression testing, boundary/negative testing, error or defect retests, and usability including automated scripts.
• Perform test execution, capture results documentation.
• Perform initial debugging procedures by reviewing configuration files, logs, or code pieces to determine breakdown source
• Adhere to defect tracking process; document software defects, using a defect tracking tool (ALM), monitor the progress in a timely manner, escalate aging and priority defects.
• Collect and report test results through various metrics reporting tools and communicating to key stakeholders on a regular basis.
• Assess readiness and deviation of project performance based on test results.
• Agile project management using Version one tool
• Execution of ETL jobs using UNIX
• ETL Testing using SQL scripts. Source and destination tables testing by writing SQL scripts in SQL developer
• SQL procedure performance testing.
• System Integration testing using top down and bottom up testing approaches.
• Review & Execution of Test cases
• Data load for UAT
• Coordination wif offshore team for testing related activities.

Confidential

Load Runner and J-meter for Performance Testing

Job Responsibilities:

• Risk identification and management
• Performance Test lead for Performance testing
• Creating effort estimation and Performance test plan.
• Building Performance Scripts for testing of developed system performance.
• Co-coordinating wif the client and development team regularly for Nonfunctional Requirements (NFR).
• Daily interaction wif client
• Task allocation to team members
• Conducting Knowledge Sharing Sessions
• Prioritization of tasks and test cases for execution
• Review of Performance Test scripts
• Logging and tracking of defects using Bugzilla.

Confidential

Selenium for Automate Test Scripts

Job Responsibilities:

• Test lead handling a team of 4 persons and was directly responsible for their productivity.
• Managing day-to-day testing activities like Test case execution, Defect tracking, Regression testing, Defect closure & daily test reports.
• Responsible for Test planning, Test development, Test execution, Test reporting, Test result analysis, Defect retesting, Regression testing, Test closure, RTM reports.
• Maintain requirement traceability matrix. Preparing and sharing the daily status report as applicable
• Performance Testing using Microsoft VSTS 2010. Generating performance reports.
• System Integration testing using top down and bottom up testing approaches.
• Developed test plans and test cases in accordance wif new application and application change requirements.
• Review & Execution of Test cases
• Project lead for functional & Integration testing

Confidential

Microsoft VSTS 2010, Biztalk Server & ETL and SAP BO Testing

Job Responsibilities:

• Responsible for Test planning, Test development, Test execution, Test reporting, Test result analysis, Defect retesting, Regression testing, Test closure, RTM reports
• Managing day-to-day testing activities like Test case execution, Defect tracking, Regression testing, Defect closure & daily test reports.
• Maintain requirement traceability matrix. Preparing and sharing the daily status report as applicable
• Performance Testing using Microsoft VSTS 2010. Generating performance reports.
• ETL Testing using SQL scripts. Source and destination tables testing by writing SQL scripts in SQL developer
• Unit testing using SOAP UI. Setup testing environment and Biztalk using As Built document. Interface installation testing by running specific executable in server.
• System Integration testing using top down and bottom up testing approaches.
• Developed test plans and test cases in accordance wif new application and application change requirements.
• Handling and testing of Business activity monitoring (BAM) which allows a dashboard, aggregated view on how the business processes are doing and how messages are processed.
• Installation testing of SAP business objects. Performance Testing of SAP BO dashboards

Confidential

PL/SQL, UNIX, Weblogic

Responsibilities:

• Responsible for handling credit & monitoring system for Confidential and vendor management, setting up dynamic credit limit for postpaid subscribers based on their credit worthiness.
• Preparing & maintaining the requirement traceability matrix and change request sheet
• Interacting wif business users to provide testing timelines & UAT offer dates.
• Responsible for deploying new patches on production as well as quality server according to deployment and rollback plan.
• Monitoring test execution progress & preparing test closure report on daily basis.
• Setup testing environment and deploy new builds on Weblogic server using deployment document.
• Developed test plans and test cases in accordance wif new application and application change requirements.

Confidential

UNIX, Telecom domain knowledge

Responsibilities:

• Analysis and setting up requirements for new features to be implemented.
• Logging the TR (Trouble report) found in FT phase in the MHWEB.
• Involved in feature testing of newly provisioned services like Domain (GUI) and Group service (CLI) and functionality of MML distribution, MML Reconciliation.
• Troubleshooting jumpstart server problem (Solaris) and NETSim for simulating network elements on the test and design servers.
• Preparation of test bed by installing all required hardware and software.
• Prepared Function Test Plan, Test strategy, Function Test specifications and System Part Verification Tests and other Release documents.
• Managing project scope and change control and escalating Confidential vendor’s issues where necessary.
• Interfacing wif BETE for all issues.
• Carried out proper test arrangement, design and management tools in the execution of test activities and utilize HP UNIX servers.
• Implemented verification and validation practices in the UNIX test environment.
• Indented and executed scripts and other UNIX utilities.
• Configured different hardware and software components as per requirement to support UNIX initiatives.
• Solved real time issues wif the help of engineer and co-workers.
• Basic Testing of new requirements sent by client and maintenance of test results before various releases.
• Handling AC’s (Approved Corrections) provided by the design team of Confidential locally and globally in test lab for various testing purposes.
• Provided support to the system test team
• Analysis and identification of changes to be made to the new versions of configuration files sent by the client.
• Worked on Live system.
• Provide support to customer queries.
• Design and Coding of new features being added.
• Hands on experience wif various Confidential tools like MHWEB,KBOSS,
• Updating the WIKI page specific to the project on the local Wiki Servers.

Confidential

UNIX, Telecom domain knowledge, OSS/BSS

Responsibilities:

• Analysis and setting up requirements for new features to be implemented.
• Logging the TR (Trouble report) found in FT phase in the MHWEB.
• Involved in feature testing of newly provisioned services like Domain (GUI) and Group service (CLI) and functionality of MML distribution, MML Reconciliation.
• Troubleshooting jumpstart server problem (Solaris) and NETSim for simulating network elements on the test and design servers.
• Preparation of test bed by installing all required hardware and software.
• Prepared Function Test Plan, Test strategy, Function Test specifications and System Part Verification Tests and other Release documents.
• Managing project scope and change control and escalating Confidential vendor’s issues where necessary.
• Interfacing wif BETE for all issues.
• Carried out proper test arrangement, design and management tools in the execution of test activities and utilize HP UNIX servers.
• Implemented verification and validation practices in the UNIX test environment.
• Indented and executed scripts and other UNIX utilities.
• Configured different hardware and software components as per requirement to support UNIX initiatives.
• Solved real time issues wif the help of engineer and co-workers.
• Basic Testing of new requirements sent by client and maintenance of test results before various releases.
• Handling AC’s (Approved Corrections) provided by the design team of Confidential locally and globally in test lab for various testing purposes.
• Provided support to the system test team
• Analysis and identification of changes to be made to the new versions of configuration files sent by the client.
• Worked on Live system.
• Provide support to customer queries.
• Design and Coding of new features being added.
• Hands on experience wif various Confidential tools like MHWEB,KBOSS,
• Updating the WIKI page specific to the project on the local Wiki Servers.

Confidential

UNIX, OSS/BSS knowledge, Core Java

Job Responsibilities:

• Analysis and setting up requirements for new features to be implemented.
• Basic Testing of new versions of MIM files sent by client and maintenance of test results before various releases.
• Analysis and identification of changes to be made to the new versions of MIM files sent by the client.
• Design and Coding of new features being added.
• Updating the WIKI page specific to the project on the local Wiki Servers

Confidential

UNIX, Core Java, J2EE, PL/SQL

Job Responsibilities:

• Design the web screens using Dream Weaver
• Developing Application Software and web Application using Core Java, Servlets, JSP, Struts, Hibernate, Java Script and J2EE Server, WebLogic Portal 10.3, CMS and Oracle as backend
• Interacted wif the business users for requirement gathering and was responsible for the Analysis, Design and Development of the System
• Responsible for changing the look and feel of portal on fly according to business requirements.
• SPOC for customer queries and UAT at client location
• Developed reports module for Aircel do not disturb application
• Deployment of new patches as .war files on Weblogic server.
• System Integration testing using top down and bottom up testing approaches.

Confidential

Core Java, J2EE, PL/SQL

Job Responsibilities:

• Interacted wif the business users for requirement gathering and was responsible for the Analysis, Design and Development of the System.
• Design the web screens using Dream Weaver• Developing Application Software and web Application using Core Java, Servlets, JSP, Struts, Java Script and J2EE Server, My SQL, and Oracle as backend
• Bug filing, Repro and Analysis
• Handled transaction using Java Transaction API.
• UAT Support at client location
• Debugging & Unit Testing
• SAP updates related to training programs using the SAP/R3 as the work station.
• Processing of Bills in SAP using the SAP Finance module Training Room Maintenance
• Coordinating all training room logistics
• Taking care of all the technical as well as behavioral training
• Conducting and evaluating all the assessments

TECHNICAL SKILLS

Operating Systems: Windows NT/2000/XP, Sun Solaris

Languages & Framework: Java, XML, PL/ SQL, MVC, Struts

Domain Knowledge: OSS/BSS, NMS/EMS, Oil & gas, Banking & Finance

Wireless Domain Knowledge: GSM, UMTS, LTE

Network Protocol: Netconf, SSH, SNMP, TCP/IP, VOIP, DNS, HTTP

Application Servers: Oracle 9i Application Server, Microsoft BizTalk, Web Logic 8.1, SAP BO, Tomcat and Apache Web Servers

Version Control: CVS, VSS, Clear Case

Code Coverage Tools: PMD, Cobertura.

Development Tools: Eclipse, Workshop for WebLogic10gR3, TFS

Databases: Oracle (9i, 10g), SQL Server 6.5/7, PL/SQL.

Testing: J Unit, Selenium, QTP, Bugzilla, Jira, VSTS2010, Load Runner, SOAP UI, J-Meter