We provide IT Staff Augmentation Services!

Test Data Track Owner And Solution Architect Resume

SUMMARY:

  • 14+ Years of experience in Software Testing Methodologies.
  • Assessment and expertise in proposing QA solution in Data Warehouse & Business Intelligence, Test Data Management in Airline domain and recommending process improvements.
  • Excellent Functional, Manual and Database skills in DW/BI, Data Migration, Databases, ETL and Reporting tools, Test Data Management in offsite/onsite model on Web - based and client/server applications at all levels of STLC.
  • Developed automation framework and automated ETL mapping conditions using PLSQL stored procedure.
  • In depth technical knowledge and understanding of Data Warehousing, Data Validations, UNIX, SQL, SQL Server, Oracle, ETL and BI Reporting.
  • Experience in Data Analysis, Data Validation, Data Cleansing, Data Verification and identifying data mismatch.
  • In depth understanding of all phases of SDLC (Agile, V Model), excellent technical writing skills with hands on experience creating Business Requirements, Functional Specifications, Mapping Documents, Test Plans, Test Scripts, Status Reports, Defect Report, Test Completion report, Traceability etc.
  • Experience in software testing in multi-tier infrastructures, including concepts of Black box, Negative, Boundary, Performance, Scalability, Functional, System, Integration, E2E, Regression and UAT.
  • Experience in working as an individual contributor and leading medium sized Teams spread across multiple time zones and countries
  • Expertise in driving Test Management using Quality Center (QC)/ Microsoft Test Manager, document Test Cases and conduct triage meetings to resolve issues.
  • Experience working with huge volumes of data, analyzing record sets for Data Quality, Data Validation using SQL and Stored Procedures.
  • Expert level understanding in customization & implementation of ETL or Data Migration process.
  • Learned and practiced various HADOOP ecosystem components like, PIG, Hive, HBase, Sqoop, MongoDB and MapReduce. Completed company sponsored BigData from Edureka.
  • Excellent knowledge in SQL Server, Oracle, Teradata Database Systems and Unix Platform
  • Worked in domains like Airline, Insurance, Financial services sector, Retail, Healthcare, ERP, CRM.
  • Experience in owning delivery tracks of couple of new large customers starting from day1 which includes transition planning and execution, setting up team from scratch, revenue target & billing generation, delivery ownership & tracking, team management and higher CSAT score.
  • Experienced in project execution and management in agile, waterfall, iterative, onsite/offsite model in managed delivery model in SLA driven environment.
  • Ensure on time delivery, tracking, and identifying delivery risk to customer with acceptable reasons and timely mitigation plan.
  • Project effort estimation, status monitoring and task allocation, effort distribution, status reporting to customer.
  • SLA compliance, root cause analysis and prevention plan, escalation handling and closure.
  • Willing to go extra mile and put additional effort for the tasks which I encounter 1st time in my carrier.
  • Dynamic team player who is consistently motivated toward success and completion of projects with an ability to work independently.
  • Good communication, collaboration, team building and project management skills with proficiency at grasping new technical concepts quickly and utilize the same in a productive manner

STRENGTH:

  • Strong determination to succeed
  • Smart learner and hardworking
  • Adapt quickly to new working environments
  • Work independently and as part of a team
  • Effective communicator - can liaise with clients and communicate ideas with a wide range of people

TECHNICAL SKILLS:

Testing skills: PLSQL Test Automation, Functional, UI, Regression and Compatibility testing in Data Warehouse and Reports, Data Migration, MDM, TPF, Mainframe etc.

Operating systems: Windows and Unix/Linux

Defect Tracking Tool: Clear Quest, HP Quality Center, Mingle, Jira, MS Test Manager

Test Case management Tool: Jira, HP Quality Center, MS Test Manager and Microsoft excel

Functional / Regression testing Tool: TOAD, SQL Developer, Putty, Query Surge, MS Excel, WinSCP

Configuration Management Tool: VSS, SharePoint, TFS

Database: MS SQL Server 2012 and Oracle 11g, DB2, Teradata, MongoDB

ETL Tool: Informatica, Datastage, SSIS, BODS, Abinitio

Reporting Tool: OBIEE, Cognos, SSRS

Programming Language: SQL, PL/SQL, Java (Basic knowledge), Unix Scripting

PROFESSIONAL EXPERIENCE:

Confidential

Environment: IBM z/TPF, Travelport, Mainframe, eNCI, AXIS and SNAPP booking platform, SunTrak, Revenue and booking, Oracle, SQL Server, DB2, Teradata, Mainframe

Test Data Track owner and solution architect

Responsibilities:

  • Own the test data management (TDM) team to provide accurate and flawless data using innovative ways by automating manual work or using airline domain expertise.
  • Perform data transactions on z/TPF (IBM Mainframe) using DLTerm which requires skills to perform command based operations/programming to create, manipulate or modify data specific to data requirements.
  • Use of eTAM (Enterprise Test Automation and Management) to fast-track the data creation which requires expertise to create, debug and execute scripts in ETAM.
  • Perform transactions using third party vender applications like Travelport, SABRE, SunTrack, ENCI reservation management systems.
  • Working knowledge in Extract Transform and Load (ETL) techniques and PLSQL programming.
  • Architect and drive solution implement of Test Data Management self-service and portal. This involves interactions with various channel project teams, understand their data need, architect a viable solution and demonstrate by a POC.
  • Estimate the test data creation effort by analyzing the requirements stated in data request.
  • Define and plan strategy and build a team of professionals with appropriate skills, attitude and motivation to execute the plan.
  • Maintain and manage all data request task allocation, dependencies and contacts required to mitigate the risks to achieve the targeted milestone with maximum quality.
  • Define and maintain data metrics and publish to stakeholders.
  • Check, review the deliverables and liaise with requester for further query/ clarification.
  • Keep track of environments refresh schedule and maintain backup of test data already available.
  • Organize the status meetings and maintain/ circulate the Status Report (Daily, Weekly etc.) to stakeholders.

Confidential

Environment: SQL Server 2014, SSIS, Stored Procedure ETL, TFS

Individual Contributor

Responsibilities:

  • Test the data cleansing, data matching, exception handling and reporting with capabilities by writing stored procedures.
  • Test the business rules and related quality check.
  • Maintain a repository of critical data quality business rule checks.
  • Automate the ETL packages testing using T-SQL stored procedures and SQL Agent jobs.
  • Requirement understanding and understanding the mappings, transformations, business rules.
  • Test all the join conditions in each package to ensure the joins don’t lead to drop of eligible records to warehouse.
  • Schedule testing jobs. Troubleshoot and fix QA job failure in case of issues with test SQLs/test Stored Procedure code.
  • Create complex SQL queries and stored procedure to test the data quality and expected behavior.
  • Test the netstat and GURU reports created or enhanced to ensure no data loss, proper layout, drill through mechanism and demo of report to stakeholder at end of each report test completion.
  • Identify scope and define plans, timelines and roadmaps.
  • Prioritize issues for discussions in triage meetings.
  • Work closely with stakeholders and ask right questions to carry out the work.
  • Identify potential issue or risk areas and do the impact analysis with respect to rework, quality, and timelines.
  • Prepare and present progress reports on a weekly basis.
  • Involved in production release during day 1.

Confidential

Environment: BODS 4.2, Oracle, SQL server, Mainframe

Test lead

Responsibilities:

  • Touch base with customer partners for any new projects and requirements.
  • Create/review the test plan and present to customer for sign off.
  • Identify/write/track the test case creation and provide review comments
  • Execute test cases and at the end prepare test summary report for final sign off.
  • Involved in technical assistance to team members for testing deliverables.
  • Prepared and presented progress reports on daily/weekly basis.
  • Ensure and own the deliveries from offshore and spoc for testing related activity to the customer. This involves Test plan, test case, progress report, defect report creation/ review/ sign off, actively participate in test execution, Test Issue resolution, co-ordination, tracking, RCA, escalation resolution and mitigation plan, customer interaction and business scenario sign off and satisfaction etc.

Confidential

Environment: Teradata, Abinitio, UNIX, SQL, MS Excel, Stored Procedures, Agile

Test Lead

Responsibilities:

  • Participate in requirement and design review, sprint plan and stand up meeting to understand the project scope and test planning.
  • Understand the business logics, transformation rules, business process flows, use cases, H/W & S/W environment needs.
  • Prepared Business Assurance plan (BAS) i.e. test plan, risk and scenario based test cases.
  • Execute/ provide technical guidance in executing test cases, capture defects in tracking tool, preparing traceability matrix and formal closure by providing sign off.
  • Automated test case creation activities by creating excel macro.
  • Other responsible activities were Effort Estimation and scheduling of project tasks, Customer interaction, escalation handling, Process improvement, owning all the deliverables day by day basis, Review of deliverables, Technical issue resolution, Customer satisfaction, Getting more work products and increased billability.

Confidential

Environment: Informatica, QC, Oracle, Toad

SSE/ Team Lead

Responsibilities:

  • Contributed to effort estimation and scheduling of project tasks.
  • Created Test Plan and Test Cases.
  • Customer point of contact for project deliverables.
  • Ownership and tracking of all the deliverables on day by day basis.
  • Review, rework and sign off of deliverables.
  • Convert the business requirement and transformation rules into testable SQL queries for data validation, data quality, and data completeness.
  • Test execution, issue reporting and defect triage for issue closure.
  • Technical and functional issue resolution.

Confidential

Environment: Unix, Siebel, Oracle

Test Consultant

Responsibilities:

  • Data Migration validation strategy preparation at onsite before final bidding.
  • Responsible to understand the customer current infrastructure and process during the discovery phase and based on that came up with the test approach document to test the data migration.

Confidential

Environment: Unix, dataStage, Toad

Associate Consultant

Responsibilities:

  • Involved in testing and client interaction.
  • Individual contributor role.
  • Responsible to test the DataStage jobs and validate the data accuracy and related functionalities as per the documentation provided.
  • Raise issue/concerns for any deviation and successful closure.

Confidential

Environment: TeraData, Oracle, UNIX, Informatica

Team Lead

Responsibilities:

  • Contributed to effort estimation and scheduling of project tasks.
  • Created Test Plan and Test Cases.
  • Ownership and tracking of all the deliverables on day by day basis.
  • Review, rework and sign off of deliverables.
  • Test execution, issue reporting and defect triage for issue closure.
  • Technical and functional issue resolution.

Confidential

Environment: SSIS, SSRS, Cognos, Jira, SQL Server

Test lead

Responsibilities:

  • Used SQL server and studio extensively to test the SSIS packages.
  • Prepared test plan, test cases and executed as per timeline and quality.
  • Identified and facilitated the automation of source .xml file received from PEGA to arrange the data in parent child hierarchy in excel format to enhance the data comparison with staging tables.
  • Involved in technical assistance for testing Quote, policy and claim related deliverables.
  • Used xsd relationship documentation to test various parent and child node relationships and consistency.
  • Extensively used SQL queries to validate data in SQL server and Cognos/ SSRS reports.
  • Extensively tested the new reports created to ensure no data loss, proper layout, drill through mechanism, demo of report to customer at end of each report test completion.
  • Proactively identified issue areas and assessed impact on timelines and deliverables.
  • Prepared and presented progress reports on a weekly basis.
  • Worked closely with developers and customer QA representatives to understand the functionalities from early stage, proactively asked questions and clarifications and ensure the product/application developed meets the end user expectations.
  • Own and arranged the issue/ defect/ clarification call proactively with the relevant stake holders and notified the problematic area in advance.

Hire Now