SUMMARY

• Confidential has 10+ years of professional experience with Development and Testing of ETL/Data Warehouse, Client Server and Web Based applications with Confidential Certification.
• Working experience as Informatica ETL/Power center developer and ETL Tester with strong business understanding of client’s TDM/ILM life cycle management and SDLC and STLC testing methodologies
• Hands on experience with ETL mappings and scripts using Informatica power center (designer, work flow manager and monitor) and transformations Expression, Lookup, Joiner, Sorter, Filter, Sequence Generator and Update Strategy
• Strong experience using Oracle, SQL server,DB2,UDB,Sybase, SQL and PL/SQL
• Strong experience in writing SQL queries using ADS and SQL * plus SQL developer and Unix shell scripting
• Good experience with the Informatica ILM data masking and DVO data validation and OBIEE reporting tool, EPCG, PCS and CIP applications Extensive Quality Assurance Life Cycle (QALC) leading experience with Requirement Analysis, Test Scope Evaluation, Test Estimation, Test Strategy and Test Process, Test planning, Test Case Development, Test Execution, Status Reporting, Test result analysis, Retesting, Test closure activities like provide Test Summary Report and conduct defect triage meetings
• Strong experience in Automation tools like QTP, Quality Center, ALM and Test Director
• Strong experience in white box, black box, Functional, Integration, System, Regression, Back End, End to End, UAT Testing with Water fall and Agile/Sprint methodologies
• Strong experience with onsite and offshore co - ordination, mentoring, monitoring and preparing periodic status updates to the management
• Review and approval of test plan, test cases, test results and approve all the QA deliverable documents
• Manage onsite and offshore resource by delegating the QA activities
• Prepare and provide RTM and Test Results metrics to the higher Management in form of daily and weekly basis

TECHNICAL SKILLS

Languages: C, UNIX Shell, COBOL, C++, JAVA, Test Scripting Language (TSL)

Operating Systems: Windows 95/98/2000/XP/NT, Windows7, IBM-AIX, LinuxRDBMSOracle 8.0(SQL, PL/SQL), MS-Access, Sybase, UDB, SQL developer

Testing Tools: Win Runner, QTP, Quality Center/ALM

SCM Tools: RAD, CVS

RM Tools: Blue Print

GUI Tools: Developer 2000(Forms 5.0, Reports 3.0),OBIEE 11g

Packages: MS-Office

Informatica Tools: ILM, ETL/Power Center, and DVO

PROFESSIONAL EXPERIENCE

Confidential, Charlotte NC

QA Lead

Responsibilities:

• Requirements gathering and analysis based on BRD, FSD documents
• Create Test Estimations document and plan the resources for each sprint
• Reviewing the Wells testing methodologies and policies and updating periodically the process documents
• Prepare Test plan/Test strategy documents
• Lead and conduct walk through meetings to review test plan, Estimations with Business and Dev teams.
• Train offshore and new resources with QA and business processes and assist them with Technical issues.
• Prepare the project folder structure for each sprint for each release for PTS in QC test plan, test lab folders
• Perform RTM in ALM for test coverage verification.
• Plan the test execution, delegate and monitor the Test Results and update the status to the management.
• Schedule defect triage meetings with development team to discuss and tract the defect fixing status.
• Plan and prepare retesting activities to meet the timelines and budget.
• Provide the daily status to the management on testing/execution progress by using Confidential template documents and ALM for the requirement metrics, test case metrics and test results metrics

Environment: PTS web Application, VSS DB, TSC DB,ALM, JIRA, MS SQL Management Quality Center

Confidential, Charlotte NC

QA IT Svcs Lead

Responsibilities:

• Requirements gathering and analysis based on BRD, BSD, EIS stories documents
• Create Test Estimations document and plan the resources for each sprint
• Reviewing the Confidential testing methodologies and policies and updating periodically the process documents
• Prepare test plan/test strategy documents
• Lead and conduct walk through meetings to review test plan, Estimations with Business and Dev teams.
• Train offshore and new resources with QA and business processes and assist them with Technical issues.
• Prepare the project folder structure for each sprint for each domain like Home, Auto, Common, Flood, Submissions etc QC test plan, test lab folders
• Perform RTM in ALM for test coverage verification.
• Plan the test execution, delegate and monitor the Test Results and update the status to the management.
• Schedule defect triage meetings with development team to discuss and tract the defect fixing status.
• Plan and prepare retesting activities to meet the timelines and budget.
• Provide the daily status to the management on testing/execution progress by using Confidential template documents and ALM for the requirement metrics, test case metrics and test results metrics
• Execute Selenium automated test build for HOME, AUTO and Common Lob’s on Jenkin server

Environment: EPCG, PCS, CIP application, SQL server, ALM, Quality Center

Confidential, Charlotte NC

QA Lead

Responsibilities:

• Requirements gathering and analysis based on BRD, BSD, TDD and data model document and mapping documents
• Create Test Estimations document and plan the resources for each sprint
• Reviewing the Confidential testing methodologies and policies and updating periodically the process documents
• Prepare test plan/test strategy documents
• Lead and conduct walk through meetings to review test plan, Estimations with Business and Dev teams.
• Train offshore and new resources with QA and business processes and assist them with Technical issues.
• Prepare the required test data for the OBIEE report validation by using Smart View tool to generate smart view reports
• Review and approve test scenarios, test cases, sql’s and upload them in ALM
• Prepare the project folder structure for each sprint and ETL releases in ALM test plan, test lab folders
• Perform RTM in ALM for test coverage verification.
• Plan the test execution, delegate and monitor the Test Results and update the status to the management.
• Schedule defect triage meetings with development team to discuss and tract the defect fixing status.
• Plan and prepare retesting activities to meet the timelines and budget.
• Provide the daily status to the management on testing/execution progress by using Qlik View tool and ALM for the requirement metrics, test case metrics and test results metrics

Environment: OBIEE 10g/11g, Smart View reporting tool, ALM, Quality Center, Qlik View

Confidential

Responsibilities:

• Requirements gathering, analysis based on BRD, BSD, TDD and data model document and mapping documents
• Create Test Estimations document and plan the ETL resources
• Prepare test plan/test strategy document based on TDD and mappings document
• Work closely with offshore and onsite team to provide the project KT and TIAA QA process
• Review and approve data analysis documents which are created based on mapping list
• Review and approve test scenarios, test cases, test scripts (sql’s) which are created for different stages of data flow validation. Stage->pre stage->stage->target
• Review and provide test results or validation results to the development and business management teams
• Work with development team and DBA team with the defects and resolving the database access issues for project team.
• Conduct defect triage meetings and provide the defect status to the management
• Mentor and monitor the onsite and offshore team with the QA, business and project process
• Provide the QA status to the management work with QA closing activities by providing Test Summary Report
• Approve test cases, test scenarios and test plan documents and getting approvals from higher management
• Provide daily, weekly testing metrics reports to the higher management team by using Qlik view tool

Environment: Oracle SQL Developer 3.2, XXTC, DRM and OFSA databases and FA EDF oracle database OBIEE tool, ALM tool, Harvard DB, OBIEE tool

Confidential, Mooresville NC

TDM Lead

Responsibilities:

• Reviewed and Analyzed Business Requirements Document (BRD), Detail Design Document (DDD), Solution Design Document (SDD) and prepared test estimations, test scenarios and High level test plans.
• Analyzed the different scenarios to be tested and documented.
• Prepared manual test scripts covering different scenarios and documented in Mercury Quality center.
• Wrote the SQL queries on data staging tables and data warehouse tables to validate the data results.
• Used different joins on the tables to retrieve information from different sources, tables in database to check the database on a regular basis using SQL queries.
• Executed test scripts to check the data flow from Source tables to Data Warehouse and Data Marts.
• Procedures, Functions, Triggers and packages are validated for the business logic as per the Solution Design Document (SDD)
• Validated the data flow from source to target tables by verifying the mappings, transformations in Informatica Power center.
• Defect logs were created in Quality Center and coordinated with Development team in fixing the defects.
• Conducted Regression testing on the fixed defects and also to validate the related functionalities.
• Validated the application in multiple environments (QA, Stage and Prod) and also was actively involved in UAT activities.
• Involved in system testing, data integrity testing and ETL testing.
• Wrote and implemented System level Test plan, test cases and test scripts.
• Responsible for data validations for initials loads and deltas
• Involved in validating the ETL Expression, FILTER, SORTER, RANK, ROUTER, SQL lookup transformations.
• Responsible for validating the no. of records for the update transformations
• Interacted with Solutions analysts, system staff, ETL developers and the data load staff.
• Used DVO tool for the data masking validations and saved the DVO reports

Environment: Informatica ILM, ETL, DVO, Quality Center, Remedy Management tool 7.5, CVS, Linux, Shell Script, SQL server, AQUA data studio, Windows 7

Confidential, Mooresville NC

TDM Lead

Responsibilities:

• Working with the Confidential EIG/Security teams to understand and finalize the sensitive data from the applications
• Working closely with informatica by opening the SR’s in trouble shooting the issues.
• Working with the genesis and Confidential .com applications SME’s to drill down the impact with of application process by masking the sensitive columns.
• Coordinating assigning and monitoring the offshore vendor team on their daily tasks.
• Using Informatica ILM Power center (ETL) and DVO tools to provide the data masking and data sub setting for Genesis and Confidential .com.
• Working with DBA and ETL/Power Center admin in getting the gold copy of the production source data into TDM/Stage area environments and importing Meta data into ILM and ETL.
• Perform sensitive data analysis by using data discovery tool, sensitive data design, finalize the sensitive columns and tables
• Create the masking rules to mask the sensitive columns by using Informatica ILM tool based on masking techniques
• Profiling the database tables, columns in ILM and discover the sensitive columns and map the appropriate masking rules in ILM
• Create the mappings in Power center designer and generate and execute the work flows with the appropriate finalized sensitive tables and columns along with mapped masking rule in ILM
• Set up the environment and create connection between ILM, power center and DVO tools with source and target databases.
• Create the parameter files which connect with ETL, ILM and Database and include the connection information in ILM plan to generate and execute the workflows.
• Designing the source, transformations and target mappings in Designer, generate and execute the workflows and sessions/tasks in workflow manger, Validate and verify the logs in Monitor.
• Validate and compare the loaded masking and sub setting data between source and target databases by using the Aqua data studio.
• Perform UT, CIT and ST and support QA team with their regression testing
• Perform end to end testing after trouble shooting and fixing the issues encountered during the lifecycle and prepare and provide the gold copy of masked data to the lower environments.
• Creating required TDM process documents for the new team members.
• Used DVO tool for the data masking validations and saved the DVO reports

Environment: Informatica ILM, ETL, DVO, Quality Center, Remedy Management tool 7.5, CVS, Linux, Shell Script, SQL server, AQUA data studio, Windows 7

Confidential, Mooresville NC

Test Lead

Responsibilities:

• Analyzed Business Requirement Documents, Functional Specifications and Technical Specifications of the software module and provided the project team with the information on test estimations
• Did the project estimations in terms of Budget, resource and project timelines for several store projects.
• Created Test Estimations, Test Plans, detailed Test Cases, and Test Scripts based on the Business Requirement Documents, Functional Specification, and Technical Specification
• Created the Test Strategy and Management plans(TSMP), Test summary reports for several projects
• Wrote several SQL’s to manipulate and modify the database tables for testing the store labels.
• Lead the offshore and onsite testing team for the testing of the Genesis enhancements and in services R6 genesis PO applications, CCM and Click applications
• Mentored the Offshore and onsite contactors on the Confidential stores application called as Genesis and sterling and Click applications
• Provided the End to End Regression testing support of Stores Genesis PO process, click and CCM applications.

Environment: UNIX, shell scripts, Sybase, UDB, Genesis, QTP, QC, Windows XP, Sterling and Click

Confidential, Mooresville, NC

QC Analyst/CVS Admin

Responsibilities:

• Support for Mercury Test Director and Quality Center
• Application support for Quality Center Site Administration and Dashboard.
• Support for Source code management(CVS) tool
• Supporting Requirement management tool(Blue Print)
• As a Blueprint tool admin adding the users, deleting the users, creating the projects and repositories. Trouble shooting the problems reported by

Environment: Quality Center 9.2, RAD 7.5, Remedy Management tool 7.5, CVS, Blue print, UNIX, Shell Script, SQL server, Windows XP.

Confidential, Mooresville, NC

Senior Test Engineer

Responsibilities:

• Analyzed Business Requirement Documents, Functional Specifications and Technical Specifications of the software module and provided the project team with the information on test scope and time estimates
• Did the project estimations in terms of Budget, resource and project timelines for several store projects.
• Created Test Plans, detailed Test Cases, and Test Scripts based on the Business Requirement Documents, Functional Specification, and Technical Specification
• Created the Test Strategy and Management plans(TSMP), Test summary reports for several projects
• Wrote several SQL’s to manipulate and modify the database tables for testing the store labels.
• Lead the offshore team for testing the Kronos (Store staff budget management tool to record the employees punch in/out timings to calculate their work hours) application.
• Mentored the Offshore and onsite contactors on the Confidential stores application called as Genesis
• Provided the End to End Regression testing support of Stores Sales process, Return process, EOD process, Self-check out process, SOS process, install sales process
• Administration process during the AIX operating system upgrade on Genesis application servers.
• Did the regression testing of all Genesis modules while converting the Store systems database from Sybase to UDB.
• Created QTP automated test scripts to queue and print the store price labels.
• Created the performance test scripts using the load runner to test the gift card purchases by the customers using the Confidential .com

Environment: UNIX, shell scripts, Sybase, UDB, Genesis, QTP, QC, Windows XP

Confidential, Seattle, WA

Programmer

Responsibilities:

• Mainly involved in Analysis, User requirements and developing C Functions and deployment scripts.
• Writing the High level Design documents.
• Unit testing and Integration testing of C modules.
• Creating and maintaining of data using Sybase database.
• Wrote several SQL scripts for data transformation to be used by other Modules.

Environment: C, UNIX shell scripts, Sybase 11/11.5, Windows NT.

Confidential, Seattle, WA

Programmer/Tester

Responsibilities:

• Involved in software Requirements and Business Requirements document to get a better understanding of the system from both technical and business perspectives
• Created Test Cases and Test Scripts.
• Involved in the development of Test Cases for System and Regression Testing
• Performed Manual Testing for the entire application and reported the defects to the developer using Test Director
• Performed Black Box testing, Functional testing, Regression testing, Integration testing to check the application is error prone according the requirement specifications.
• Converted manual tests to automated test scripts in Win Runner for Regression testing
• Performed data driven test in Quick Test Pro to handle those scenario requiring multiple sets of data (flat file, Excel file)
• Created applications specific and generic functions in TSL to enhance modularity of scripts
• Used verification points and conducted data driven Test with the Test Data sets and verified the contents of the website using QuickTestPro
• Validated both functionality and automated business processes using quality center

Environment: Win Runner, QTP, Quality Center, TSL