SUMMARY

• Over 8 years of IT experience with emphasis in Software development and over 4 years of Test Lead experience.
• Experience on oracle E - Business Suite 11i HRMS module, IBM Curam, Salesforce Sales Module and BMC Remedy Systems.
• Expertise in testing of applications developed using JAVA, J2EE, Angular-JS,VB and .NET architectures
• SOA Testing Experience.
• Experience with Relational Databases (Oracle, SQL Server and Teradata) and writing the complex SQL Queries.
• Experience testing Web Applications, Web Services, Desktop client application & database.
• Experience in Selenium Web driver Automation development using Java Language.
• Experience with Data Driven Framework, TestNG and Cucumber frameworks.
• Experience in designing the automation frameworks with advanced techniques like Page Object Model, Page Factory and Selenium Grid. Etc
• Experience in locating the objects using various locators and store in Object repository.
• Experience in developing the automation scripts for Browser less testing.
• API Testing Experience using SOAP UI.
• Experience with the Source Control tools like VSS, SVN & Git Hub.
• Knowledge on Continuous integration Test tools like Maven & Jenkins.
• Experience with Functional testing, Integrated system testing, Regression Testing, Accessibility Testing, Sanity Test, Smoke Test & Security Test.
• Experience in Data warehouse, ETL & BI Testing.
• Experience in different types of tests such as BuildKeys, Source to Target Testing, Metadata Testing, Data Completeness and Data Accuracy Testing.
• Well versed with the ETL Testing Process.
• Experience in Test Data Management.
• Experience in identifying and resolving the bottlenecks in Source, Target, Transformations, Mappings and Sessions for better performance.
• Experience in optimizing query performance, session performance and fine tuning the mappings for optimum performance.
• Experience in using Informatica Workflow Manager to create and schedule workflows.
• Experience in developing the Business Intelligence report Dashboards using Tableau.
• Experience in Telecommunication, Property & Casualty Insurance Business domains
• Extensive Experience in DevelopingTest Plan, Test Strategy, Test Scenarios, Traceability Matrixand Test Cases based onBusiness and Application requirements.
• Experience in Iterative, Waterfall and Agile Software Testing Methodologies.
• Good at defect-reporting and defect-tracking using the test management tools Quality Center, Application Life Cycle Management (ALM), and Jira & IBM RTC.
• Experience with UNIX and Windows Operating systems.
• Good knowledge of SDLC & STLC process.

TECHNICAL SKILLS:

Test Techniques: Manual Testing, Risk Base Testing, Pairwise Testing and Automation Testing

Test Tools: HP Quality Center, HP ALM,IBM RTC, SOAP UI, TIBCO BUS Tester, PICT Tool, QTP (HP UFT) and Selenium Web driver

Languages: Java, HTML, SQL & PLSQL

Database: Oracle, SQL Server, Teradata

Operating Systems: Windows and UNIX

ERP: Oracle E-Business Suite 11i HRMS, Sales Force.com (SFDC) Sales Module, Curam

ETL Tools: Informatica (Powermart, Powercenter 9.x) and Datastage

Other Tools: TOAD, SQL Developer, PL/SQL Developer, Teradata SQL Assistant, MS-Office, Putty, Win SCP, SVN, Caliber RM, Rally and Jira

PROFESSIONAL EXPERIENCE:

Confidential, TX

ETL Tester

Responsibilities:

• Created quality assurance (QA) plan and test case documents, created traceability from requirements to test cases and their respective defects logged during the testing cycle.
• Conducted user acceptance testing (UAT) and obtained signoffs from the stakeholders.
• Developed Oracle SQL Queries simple and complex for analysis and creating testing scripts.
• Analyzed the data extracts from Legacy Systems. Interacted with the Technical Analyst to determine the element source, format and its integrity within the system.
• Interacted extensively with data modeler andETL developers for creating the Data Functional Design documents.
• Worked throughout the quality assurance life cycle including requirements specifications, creating a test plan, creating test cases, executing test cases, reporting defects, generating reports and managing regression testing
• Established traceability from Business requirements to Functional requirements to user requirements
• Conducted formal and informal product design reviews throughout the software development
• Lifecycle to provide input on functional requirements, product designs, schedules and potential issues. Leveraged developer background to communicate effectively with software
• Responsibilities include writing advanced queries for data validation duringETL processes and on Business Dashboard Reports.
• Developed and Designed Test Cases based on the Business Rules and Mapping Documents.
• Database/Backend verification - executing basic and complex queries using Transact-SQL.
• Testing ofETL processes, Source Data Files, SRC to Target, Dashboard Reports.
• Tested Incremental load.
• Aggregated the data at source and compared with the Target to validate Transformations.
• Prepared Requirement Traceability Matrices to track the requirements with the test cases and make sure none of them have been missed.
• Defect Management using JIRA and Visual Studio 2010.
• Tested the reports drill down, drill up and Pivot reports generated from TFS.
• Worked with other members of the QA and Development teams and managed efforts with the team in improving the processes, methods, effectiveness, and efficiency.
• Worked on End to End BI Testing activities.
• Performed BI Report Testing using OBIEE, by writing SQL queries to validate the data on the report and compare with the DWH data, DataMart.
• Done the subject area testing and RPD testing in OBIEE reporting.

Confidential

Responsibilities:

• Review the Funtional requirements.
• Analyze the scope of UI automation.
• Automate the application functionality in Selenium Webdriver using Java language.
• Design the Automation framework with the huge volume of Test Coverage.
• Prepare the POC for automating the new features.
• Develop the new feature files for acceptance testing.
• Develop the automation scripts with the advanced techniques for better results.
• Work on ETL Testing when I’ve bandwidth.
• Review the ETL requirements,ETL Mapping Documents and Design documents.
• Provide the Test estimations.
• Prepare the Test plan and Strategy document and review with all the IT Stake holders.
• Identify the Testdata requirements and work with the different source systems to get the test data for the test execution.
• Perform the smoke testing after every build.
• Perform the MetaData Testing
• Perform Source to Target Testing.
• Perform Data Completeness Testing.
• Perform Data Accuracy and Data Transformation Testing.
• Validate the Reusable ETL Transformations which facilitate Daily, Weekly & Monthly Loading of Data.
• Verify the ODS DB to validate the GoldenGate process.
• Carry out different types of tests such as Primary Key, defaults and validate the ETL process
• Write the SQL Queries to get the required results for the BI reports.
• Provide UAT Support.
• Work on Adhoc requests when Management requests for any reports.
• Involved in Manul Test Exection (Testing the Web application).
• API Testing with the SOAP UI tool.
• Log the defects in HP ALM, if any found during the Test execution
• Attend the Defect Triage meetings and Work with the Developers in fixing the defects
• Helping the team in automation execution

Confidential

System Integration Test Lead

Responsibilities:

• Attend the backlog grooming and analyze the Application/system impacts due to the new User Stories.
• Create sprint related tasks for all the committed User stories.
• Attend the daily standup meetings and provide the status and any issues.
• Design the System Test Plan and review with the IT stake holders .
• Prepare the Functional Test Cases and identify the Regression cases to cover the user stories
• Coordinate with offshore regularly and assign the Tasks .
• Review the System Test cases with all the IT stake holders as well as Business and in corporate the review comments.
• Maintain the Traceability between the Test cases and requirements.
• Develop the automation framework for acceptance testing.
• Develop the Automation framework with huge volume of Test Coverage.
• Test Data Management - Setup the Test data as per the requirements and ensure the data is synchronized across all the applications.
• Validate the Webservices using SOAP UI.
• Validate the ordering systems functionality (CSG biller and DDP biller).
• Verify the order in all the network provisioning systems.
• Send the daily status to Management with the detail information about the release.
• Schedule Team level Retrospective meetings with offshore to discuss th lessons learned and any suggestions
• Attend the retrospective meetings and provide the feedback.
• Prepare the Test and send to the IT stake holders after the testing completion.
• Execute the Automation Scripts to perform the regression testing for each release.
• Automate the previous release changes using UFT automation tool IN Hybrid framework .

Confidential

SystemTest Lead

Responsibilities:

• Review the System / Business requirements for all the Change Requests planned for each release.
• Analyze the Application/system impacts due to the CRs .
• Analyze,if there is increase in the Load on the system due to the committed System requirements
• Analyze the performance related issues due to the new requirements
• Perform static testing on the requirements.
• Design the HighLevel Test Scenarios and review with the IT stake Holders
• Estimate the Efforts required for all the projects.
• Analyze,if Risk based testing can be performed to reduce the efforts .
• Design the System Test Plan and review with all the IT stake holders and dependency systems.
• Coordinate with offshore regularly and assign the Tasks
• Schedule Daily/Weekly Status meetings with offshore team to discuss the status and issues based on the criticality
• Involved in designing the System/Integration /Regression Test cases with respect to the Application requirements.
• Review the System Test cases with all the IT stake holders as well as Business and in corporate the review comments.
• Maintain the Traceability between the Test cases and requirements
• Test Data Management - Working with upstream and interface applications to collect the test data
• Involved in Execution of System/Inter System/Regression Test.
• Design the Test Execution Weekly Target (Milestones) and share with the IT Stake holders.
• Execute the system, inter system and Regression test cases.
• Identify the Mitigation plan,if test execution is not in the target.
• Provide Daily/Weekly status updates to Program Manager as well as Test Coordinator.
• Involving in the daily defect review meetings to provide the updates on the defects to Program.
• Support the End users during the User Acceptance Test.
• Design the Test and cascade to the Stake holders .
• Create the production sanity test plan and get it reviewed .
• Execute the Automation Scripts to perform the regression testing for each release
• Automate the previous release changes using Selenium Webdriver2 .
• Perform sanity test on post production deployment.
• Complete the Test Closeout activities(Risks,Issues,Lessons Learned,,etc)
• Develop the Test Metrics Report Dashboard and review the metrics with IT Stake holders .
• Participate in SEP Audit reviews.

Programmer

Responsibilities:

• Capturing Business process Requirements and managing business rules
• Evaluate business requirements, Create High Leve Design and Low Level Design, develop the test plan and scenarios .
• Deveop the PL/SQL Procedures to apply business logic to the data for further processing.
• Enhance the Unix shell scripts if required which will process the monthly preium/claims files.
• Load the claims & Premiums Data to database using SQL Loader and Shell scripts.
• Execute the scripts which extracts the transformed data to the Mainframe systems.
• Perform Unit Test
• Building test cases, constructing test-data from test cases and Verification of test results.
• Processing monthly Premium and Claims by executing the unix scripts in prod .
• Validating the Errored records(Premium & Claims) and reporting the reasons to clients
• Getting the Mainframe files to Datawarehouse and verfying the reports.
• Execution of automation test Scripts.
• Monitoring and Testing the ETL Jobs using Control M
• Preparation of weekly status report (Claims)based on the business
• Validation of test results and presenting to the clients.
• Communication with client in all the phases of a project.
• Notifying the Business team with the claims & premiums update after the Monthly ACT & PES closure

Confidential

Prod Support

Responsibilities:

• Resolve prod issues with in the SLA
• Smoke test after every build. work on the database queries to debug the issue.
• Working closely with users to track the Prod issues and producing the solution.
• Capturing New Business process Requirements and managing business rules
• Developing the configuration changes for those Business requirements
• Desigining and scheduling the concurrent jobs as per the business needs
• Handling Enhancements and new initiatives.
• Involved in the migration plan of Oracle Apps to Salesforce.com
• Trained in salesforce.com sales module
• Involved in testing the salesforce.com sales application.
• Housekeeping activities in the project.