We provide IT Staff Augmentation Services!

Lead Functional Testing/ Database Testing Resume

Boston, MA

SUMMARY:

  • Having more than 12 years of experience in Software testing includes Data warehouse testing (ETL QA), Functional Testing, and Siebel Testing and diversified experience across various Domains (Financial - Securities, Insurance, Healthcare, Retail, Pharmaceutical) & Technologies.
  • Extensive experience in Data Warehousing testing, Data Migration testing using Data stage and Informatica and expertise in writing Complex SQL Queries and data validation of Data Warehouse & BI applications.
  • Experience working in different domains like Financials, Securities, Medical, Life Sciences, Pharmaceutical, Retail and Technology.
  • Around 2 years of experience in Retail Domain and part of MDM testing in Retail space.
  • Experience of more 4 years in Siebel Applications like Siebel Sales, Siebel Call Center and Siebel eMedical. And have very good Knowledge of Salesforce CRM testing.
  • Experience in working Oracle Retain RPAS, RDF, and Oracle Sitehub, Oracle Hyperion DRM (Data Relationship Management).
  • Experience in Cognos BI Reporting testing.
  • Knowledge of SOA - SOAP UI test process.
  • Experience on Agile project and involved in Scrum process.
  • Gained immense knowledge in Siebel Functionality and very much comfort in SQL Server 2008 and wrote many queries and procedures in database testing.
  • Good experience in Quality Center for Test case Design and Bug Tracking.
  • Experience spanning the entire Software Development Life cycle (SDLC) and Testing Life Cycle including Requirements understanding, Test design, Test development, System Testing/Integration Testing, User Acceptance testing (UAT), documentation.
  • Experienced in Microsoft SQL Server Backend testing and UI Testing.
  • Good Presentation and communication skills, Ability to work as a team member as well as individually.
  • Good Correspondence with Excellent Email Etiquettes.

TECHNICAL SKILLS:

Databases: Oracle, SQL Server 2008, Teradata

Development/Productivity Tools: MS Office, MS SQL Server 2008, PL/SQL Developer, Quality Center, HP ALM, Oracle, Unix, TWS (Tivoli Workload Scheduler), JIRA

CRM/ERP Tools: Siebel CRM, Oracle Retails RPAS, RDF, MDM - Oracle Hyperion DRM (Data Relationship Management), MDM - Oracle Site Hub

Functional Areas: Customer Relationship Management, HR

Programming Languages: C#, Java, VB.NET

Software Engineering Methodologies/Tools/Technologies: ETL Testing, Database Testing, SOFTWARE TESTING

Verticals: Retail, Securities, Health Care, Insurance

ETL Tools: Data Stage, Informatica Power Center, OBIEE, SSIS

PROFESSIONAL EXPERIENCE:

Confidential, Boston, MA

Lead Functional testing/ Database testing

Responsibilities:

  • Test Planning, analysis and test data creation.
  • Transfer the knowledge to the individual team members.
  • Written SQL queries for checking the Data transformations and Database Integrity in Oracle.
  • Responsible for Data Mapping testing by writing complex SQL Queries.
  • Verifying the functionality of the application, and checking trade flow to DTCC.
  • Responsible for executing the Test Cases using Quality Centre.
  • Test Planning, test execution and reporting. Interact with functional and technical team on mitigating risks and closing issues.
  • Conduct defect tracking meetings.
  • Deploying the jobs or bundles in GTH ServiceMix.
  • Stop, refresh, start, uninstalling the bundles.
  • Verifying the jobs in UNIX environment.
  • Recycling the GTH environment.
  • Supporting the inbound and outbound teams for their activities.

Environment: Oracle, UNIX, Apache ServiceMix, JIRA, Data warehouse ETL environment (UDW), Agile, IBM - Rational Team Concert (RTC)

Confidential, Boston, MA

Lead ETL Tester/ Functional testing

Responsibilities:

  • Test Planning, analysis and test data creation
  • Transfer the knowledge to the individual team members.
  • Written SQL queries for checking the Data Migration, Data transformations and Database Integrity in Oracle.
  • ETL and BI testing in Data warehousing environment /projects.
  • Responsible for Data Mapping testing by writing complex SQL Queries.
  • Verifying the functionality of the application, and checking the approval workflow.
  • Responsible for executing the Test Cases using Quality Centre.
  • Verifying the jobs in UNIX environment.
  • Test Planning, test execution and reporting. Interact with functional and technical team on mitigating risks and closing issues.
  • Tracking defects in JIRA tool.
  • Conduct defect tracking meetings.
  • Coordinating and supporting the UAT testing.

Environment: ETL, Oracle, Informatica, UNIX, JIRA, Data warehouse ETL environment (UDW)

Confidential, Rocky Hill, CT

Lead ETL Tester

Responsibilities:

  • Test Planning, analysis and test data creation
  • Transfer the knowledge to the individual team members.
  • ETL and BI testing in Data warehousing environment /projects.
  • Written SQL queries for checking the Data Migration, Data transformations and Database Integrity in Teradata.
  • Responsible for Data Mapping testing by writing complex SQL Queries.
  • End-to-End data validation for ETL and BI systems
  • Responsible for executing the Test Cases using Quality Centre.
  • Scheduling and monitoring ETL jobs in TWS (Tivoli Workload Scheduler)
  • Running OnDemand jobs in UNIX environment.
  • Test Planning, test execution and reporting. Interact with functional and technical team on mitigating risks and closing issues.
  • Tracking defects in HP ALM.
  • Conduct defect tracking meetings.
  • Coordinates activities between onsite and offshore testing team.

Environment: Windows-7, ETL, Teradata, Data Stage, Unix, TWS (Tivoli Workload Scheduler), HP Quality Center, Teradata Data warehouse ETL environment (UDW)

Confidential, Marlborough, MA

Sr. ETL Tester/ QA Tester

Responsibilities:

  • Gathering requirement documents and analysis.
  • Transfer the knowledge to the individual team members.
  • Define Test Plan. Responsible for work allocation and tracking. Plan and prioritize testing activities on a day to day basis. Determined testing scope and prioritized deliverables in different phases.
  • Walkthrough the test plan to the stake holders and managers.
  • Written SQL queries for checking the Data Transactions and Database Integrity in SQL Server.
  • Responsible for Data Mapping testing by writing complex SQL Queries.
  • Verified the functionalities of MDM applications like DRM, and sitehub.
  • Verified the Data extractions from source systems.
  • Created SQL compare statements to validate Actual results with the Expected Results.
  • Verified the Cognos BI Reporting and tested the functionality.
  • Verified OBIEE interfaces and validated the functionality.
  • Responsible for executing the Test Cases using Quality Centre.
  • Test Planning, test execution and reporting. Interact with functional and technical team on mitigating risks and closing issues.
  • Coordinates activities between onsite and offshore testing team

Environment: Operating System(s) Windows-7, ETL, SQL Server, Data Stage, HP Quality Center, Data warehouse ETL environment (EDW)

Confidential, Marlborough, MA

Sr. ETL Tester

Responsibilities:

  • Perform estimation of the effort and time required.
  • Develop Test Plan. Responsible for the overall testing related project activities and deliverables. Gathering requirement documents and analysis.
  • Written SQL queries for checking the Data Transactions and Database Integrity in SQL Server.
  • Performed Database (metadata) validation before loading the data in to the target tables.
  • Verifying the target tables using SQL queries after Data Conversion.
  • Created SQL compare statements to validate Actual results with the Expected Results.
  • Define framework for High and Low level Test cases.
  • Review Test cases and get sign-off from respective stakeholders. Perform Peer review on deliverables.
  • Verified the SSRS Reports and tested the functionality.
  • Test Planning, test execution and reporting. Interact with functional and technical team on mitigating risks and closing issues.
  • Conduct defect tracking meetings.
  • Supporting UAT test activities.

Environment: ETL, SQL Server, SSIS (SQL Server Integration Services), Oracle retail RPAS, RDF, HP Quality Center, Oracle retail RPAS, Data Warehouse, Windows-7, SSRS (SQL Server Reporting Services)

Confidential, Minneapolis, MN

ETL Tester

Responsibilities:

  • Coordinating with Confidential manager for the tasks related to GCH project, and assigning the tasks to offshore team. Coordinating with source systems for complaints which are coming to GCH application.
  • Worked on Batch Processing ETL, PL/SQL subprograms and performed backend testing.
  • Extensively written SQL to confirm the data transfer from source to target.
  • Preparing Daily Status, weekly Status and Monthly status Reports. Writing and executing the Test Scripts for GCH interfaces.
  • Supporting upstream projects like Seibel eMedical
  • Attending daily and weekly meetings with client Managers.

Environment: Oracle, Siebel, SAP, Siebel CRM, Oracle, HealthCare, ETL, Informatica, Windows-XP

Confidential, Dublin, OH

Onsite Coordinator, Functional Tester

Responsibilities:

  • Coordinating with Order Express manager for tasks related to CSOS integration with OE and .com
  • Coordinating with downstream applications VAPS, EDI, Distrack for order flow and verify the status in each application. And verify the outbound docs generated by Distrack
  • Preparing Daily Status, weekly Status and Monthly status Reports. Writing and executing the Test cases or Test Scripts. Supporting Downstream projects like VAPS, EDI. Attending daily and weekly meetings with client Managers.

Environment: Oracle, HealthCare, Windows-XP, Oracle, Java, Distrack

Confidential, Boston, MA

Onsite Coordinator, Functional QA

Responsibilities:

  • Coordinating with client and onsite, and assisting the task to offshore team in the Project. Preparing Daily Status, weekly Status and Monthly status Reports.
  • Writing Test cases for the Application. Executing Test Scripts. Supporting Downstream projects. Managing Test servers for running the jobs. Reviewing of Test cases.

Environment: Java, Oracle, IBM Mainframes, Oracle Database 10g,J2EE,Java,Securities, Windows-XP

Confidential, Boston, MA

Onsite Coordinator, Functional QA

Responsibilities:

  • Coordinating with offshore team and assisting them in the Project. Writing Test cases for the Application. Executing Test Scripts. Supporting Downstream projects. Managing Test servers for running the jobs. Reviewing of Test cases.

Environment: Java, Oracle, IBM Mainframes, Oracle 9i, Java, Securities, Windows-XP

Hire Now