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,
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.
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.
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:
