Livecareer-Resume
Jessica Claire
  • , , 100 Montgomery St. 10th Floor
  • H: (555) 432-1000
  • C:
  • resumesample@example.com
  • Date of Birth:
  • India:
  • :
  • single:
Summary
  • 14 years of IT experience in system analysis, testing, support, implementation and maintenance of Data Warehouse ETL applications and Database application programs.
  • Domain expertise in Insurance, Investment Banking and Healthcare.
  • Strong experience in testing database application
  • Strong experience in developing and enhancing PL/SQL and SQL Server Application programs and Stored Procedures and expertise in using.
  • Good working knowledge of Big Data - Hadoop Ecosystem, HDFS Commands, Hive QL, Sqoop , Informatics, SAS
  • Proficient in Scheduling tools like Control-M
  • Experience working in UNIX environment and good understanding of Shell scripting.
  • Proficient in CM tools like VSS, SVN. ,Version 1
  • Strong understanding of BI-DW concepts, Fact tables, Dimension tables, Star schema, Snowflake schema, ETL designs.
  • Proficient in integration and transformation of various data sources from databases like Oracle, SQL Server and formats like flat-files, XML.
  • Experience in data analysis, data profiling, data cleansing and data mapping for ETL processes.
  • Worked in projects extensively using Waterfall, Agile and Scrum methodologies.
  • Experience in leading and managing testing teams working in offshore - onshore model, distributing/gathering tasks and providing status updates to stake holders in scrummeetings.
  • Experience in creating RFCs and involvement in various stages of SDLC.
Skills
  • Operating Systems UNIX, Windows 2000/NT/XP/7/10
  • Programming Languages Oracle, SQL, PL SQL UNIX, LINUX, VBScript,
  • Databases Oracle 10g, 11g, DB2, SQL Server, Postgres,Aura
  • ETL/DW Tools Informatica Power Center 9.x
  • Big Data HDFS
  • Version Control VSS, SVN,Version 1
  • DB Tools TOAD, Oracle SQL Developer, SQLDBX , Microsoft SSMS
  • Design Tools MS Visio
  • Methodology Waterfall, Agile, Scrum
  • Testing Tools Quality Center 11.0, JIRA,Version 1
  • Scheduling Tools ControlM,
  • Reporting Tools Qlikview, OBIEE, Tableau
  • PL SQL, SQL
  • Devops,TDD, BDD, CICD
Experience
Test Lead, 05/2018 - Current
Infosys Ltd Sidney, OH,
  • Clinical Quality, Correspondence Responsibilities:.
  • Played the role of QA Lead and actively involved in testing, enhancement and support of existing projects and any new projects.
  • Co-ordinate with off-shore and on-shore team.
  • Interacted with Business Users & BA’s to understand the requirements and prepared test strategy, and plan by coordinating with SME’s.
  • Onsite test lead, managing 8 member team.
  • Responsible for preparing the test artifacts like QA Test plan, Test strategy, Test execution metrics, Daily, Status reports.
  • Creating test case, using complex sqlqueries to validate transformation logic.
  • Creating mockup data, and creating negative test conditions for validations.
  • Following the Agile process for deliverables.
  • Aligning the release while understanding requirements by going through BRD and FRD’s and User stories.
  • Confirming QA drop dates to the development teams.
  • Finalizing testing dates to Change team and Project manager for various data streams, and specific CR/User Stories.
  • Managing E2E environments from maintenance and UAT readiness, while working with Platform Service,.
  • Test strategy, test plan and test case writing, and reviewing them with business for their sign offs for the testing to commence.
  • Ensuring the positive and negative criteria’s are met.
  • Publishing testing dates and the availability of the environments to the users.
  • Effectively manage and supervise QA Resources Planning, Task allocation based on dynamically changing project priorities and Project Traceability.
  • Conducting test case review with change and users.
  • Representing QA on stand up calls with Change team and Business Users, and publishing the defects and RCAand testing plans.
  • Preparing the test summary report, and sign off documents for business to approve, and development teams to start the code merging process for Go Live.
ETL Test Lead, 12/2010 - 04/2018
Infosys Ltd Wichita, KS,
  • Project: Regulatory IT(Basel3, and Basel4) Role: ETL Test Lead, Responsibilities:.
  • Played the role of ETL Test Lead and actively involved in testing, enhancement and support of existing projects and any new projects.
  • Co-ordinate with off-shore and on-shore team.
  • Interacted with Business Users & BA’s to understand the requirements and prepared test strategy, and plan by coordinating with SME’s.
  • Created Unix Shell Script to automate manualprocess of file processing, by creating poolto invoke the process prior to which it checks if the environment is free to process.
  • After which the process places the required risk files to be consumed.
  • Created PL/SQL Packages, and Procs to develop the functionalregression framework, by invoking the scripts through ControlM.
  • Onsite test lead, managing 12 member team.
  • Responsible for preparing the test artifacts like QA Test plan, Test strategy, Test execution metrics, Daily, Status reports.
  • Creating test case, using complex sqlqueries to validate transformation logic.
  • Creating mockup data, and creating negative test conditions for validations.
  • Reviewing code (Unix, PL SQL) for analysis on any build defects.
  • Reviewing performance, and finding the runtime execution to match production SLA’s.
  • Aligning the release while understanding requirements by going through BRD and FRD’s.
  • Working with Release Management, IT Coordinators and Project manager to align the scope to a given release, after understanding the impact and determining the complexity and feasibility of testing.
  • Confirming QA drop dates to the development teams.
  • Finalizing testing dates to Change team and Project manager for various data streams, and specific CR.
  • Managing E2E environments from maintenance and UAT readiness, while working with Platform Service,.
  • DBA team and supporting user access queries.
  • Including supporting any EOL(End of life Project) from Onboarding as per QArequirement to procuring and testing.
  • Test strategy, test plan and test case writing, and reviewing them with business for their sign offs for the testing to commence.
  • Ensuring the positive and negative criteria’s are met.
  • Publishing testing dates and the availability of the environments to the users.
  • Effectively manage and supervise QA Resources Planning, Task allocation based on dynamically changing project priorities and Project Traceability.
  • Conducting test case review with change and users.
  • Representing QA on stand up calls with Change team and Business Users, and publishing the defects and RCAand testing plans.
  • Preparing the test summary report, and sign off documents for business to approve, and development teams to start the code merging process for Go Live.
  • Used Cognizant proprietary tool(Platinum) to perform regression testing which basically involved comparing source to target.
Senior, 06/2007 - 12/2010
L&T Infotech Delhi, OH,
  • Development of the data conversion application using PL SQL as per the technical specification.
  • An analysis of the system.
  • Writing Unit test Cases.
  • Perform the Unit testing and System testing.
  • Logging and fixing the defect in the internal tool of Mastek.
Education and Training
Bachelor of Engineering: Computer Science, Expected in 2006
-
- ,
GPA:

By clicking Customize This Resume, you agree to our Terms of Use and Privacy Policy

Disclaimer

Resumes, and other information uploaded or provided by the user, are considered User Content governed by our Terms & Conditions. As such, it is not owned by us, and it is the user who retains ownership over such content.

How this resume score
could be improved?

Many factors go into creating a strong resume. Here are a few tweaks that could improve the score of this resume:

69Fair

resume Strength

  • Length
  • Personalization
  • Target Job

Resume Overview

School Attended

Job Titles Held:

  • Test Lead
  • ETL Test Lead
  • Senior

Degrees

  • Bachelor of Engineering

By clicking Customize This Resume, you agree to our Terms of Use and Privacy Policy

*As seen in: