General Mills Sql Developer

CURRICULUM VITAE

Saurabh Ramesh Karle

Mobile: +91-808*******

Email: **************@*****.***

Summary:

•Currently working with Accenture Solutions Pvt Ltd, having overall 7.8 Years of experience in ETL Testing, Data Warehouse Testing, Cloud Migration Testing and Functional Testing

•Working experience on GCP cloud in data migration project.

•Experience in all release management activities including scope validation, creating deployment plans, communication with different business and technical teams to coordinate the release.

•Possesses strong Functional, Technical knowledge and Test management experience.

•Extensive experience in Functional testing, Integration/System testing, Regression testing and User Acceptance testing

•Experience in Waterfall and Agile methodology.

•Developed Test Plans, Test Strategy, Test Scenarios, Test Cases, Test Requirements, and documentation from business, technical and functional requirements.

•Hands on experience on execution of complex SQL queries to perform data completeness, correctness, data transformation and data quality testing for source to target mapping.

•Comprehensive knowledge on Software Testing Life Cycle tool like JIRA and ALM, Azure DevOps.

•Comprehensive knowledge about Banking and E-Commerce Domain.

•Strong influence and leadership skills

•Exceptionally organized, efficient and precise with strong liaison skills, strong verbal, written and interpersonal communication skills

•ISTQB Foundation Course Certification

Academic Details:

•Bachelor of Computer Engineering from Pune University passed out with 66.67%.

•HSC passed out with 81%.

•Matriculation passed out with 89.33 %.

Technical Knowledge:

Operating Systems

Windows 7, 10

DBMS

GCP cloud, Oracle 11g, PL SQL Developer, Putty, Bigquery

Testing Skill

ETL, DWH, Functional Testing

ETL Tool

Informatica, Talend

Test Management Tool

HP ALM, JIRA, Azure DevOps

Professional Experience

Accenture Solutions Pvt Ltd -- April 2021 till date

Client: General Mills

Project Name: Cloud Analytics Acceleration Program

Description: This E-commerce project involves migration of data from on-prem Hadoop legacy system to GCP cloud. Currently leading QA team of Supplychain POD within CAAP Program.

Roles & Responsibilities:

•Working in Agile-scrum environment.

•Review client requirement and provides feedback.

•Responsible for creating test plans and strategy and release document.

•Leading, guiding, and monitoring the analysis, design, implementation, and execution of the test cases and test suites.

•Azure DevOps as a Test management tool for managing all testing activities.

•Working with Product Managers and Owner to define work flow procedures and manage agile boards as well as process improvements

•Participating in daily status meetings and coordinated with the Developers, Testers and Product owner to resolve and close defects.

•Created detailed periodic status reports for senior management to keep them posted on the progress of implementation.

•Assists in coaching junior staff, by helping them to make decisions, solve problems, manage meetings and set goals, provides feedback on testing-related tasks, delegates and assigns testing responsibilities

Infosys India Pvt Ltd -- Mar 2018 to Mar 2021

Client: Deutsche Bank

Project Name: Data Acquisition and FDW Data Load

Description: Financial Data Warehouse (FDW) is the golden source for all financial, tax, risk, regulatory data for internal reporting and sending them over to the Master area For Reporting and Business analytics purposes. Data Loading is one of the UAT environment project in which data from multiple source system are loaded into Hadoop cluster by applying data cleansing rule. Once data is loaded in Hadoop different transformation, calculations and aggregation rules are applied to move the data from one layer to next layer to meet the business requirement and then Data Testing is performed.

Roles & Responsibilities:

•Closely working with Product owner, FA to get the requirement understanding

•Involved in getting the test data from different source system and providing to different stakeholders like ST, DS-SIT and FDW UAT team

•Process the data coming from various source system to FDW through various internal stages.

•Test the mappings as mentioned in JIRA requirement along with the regression Testing of unchanged entities.

•Test execution which includes Functional and Regression testing of the application.

•Coordinate meetings with the product committee, project manager and functional management to discuss project impediments or issues/delays in completing the task

•Involved in defect analysis in ALM.

•Preparation of Daily Status Reports.

•Test summary report preparation and closure activities.

•Preparation of understanding documents.

Capgemini Pvt Ltd: -- May 2016 to Feb 2018

Client: HSBC Bank

Duration: May 2016 – Feb 2018

Project: JE SIT Testing

Synopsis: The primary objective of the project was to construct an aggregated data warehouse. The client wanted to start the Global Data warehouse to meet its analytical reporting and decision support requirements as a QA I used to run the test cases for the end to end process in that data warehouse. Involved in Functional Testing.

Roles & Responsibilities:

•Requirement analysis, mapping document analysis, Test Plan Creation and Execution (Functional and Non-Functional)

•Involved in preparing test environment and test data set up to execute test cases.

•Creating Test Scenario, test case writing, test data preparation

•Executing testing activities as per the Testing Plan and adhering to guidelines and checklists

•Involved in ETL process testing using Informatica ETL tool.

•Involving in writing complex SQL queries to verify data quality and calculations from Source and Target.

•Performed data validation testing writing SQL queries.

•Involved in SCD Type 1 Testing.

•Using HP Quality Center for storing, maintaining the test repository, bug tracking and reporting

•Doing regular follow-up with Development team to identify root causes in delays pertaining to Bug closure & product feature query resolutions

•Involved in conducting review meeting within the Team and communication with the clients through conference calls.

•Taking decisions and providing suggestions and value addition to the clients

Clarosys Technologies Pvt Ltd -- Dec 2013 to April 2016

E-commerce Web Testing:

Synopsis: The primary objective of this project was to develop an e-commerce solution and sell the products online through their own e-stores. The application hosted a solution for small and medium size business that seek to target specific markets. Worked extensively to test the e-store including purchase order flows, renewal order flows, user registration and the corresponding display on web front end.

Roles & Responsibilities:

•Understanding the requirements based on BRD and analysis of mapping documents.

•Modification of test cases based on the requirement changes.

•Extensively interacted with developers, business& management teams to understand the project business requirements and ETL design document specifications.

•Creating test cases for ETL mappings and design documents for production support.

•Developed complex SQL queries for querying data against different data bases for data verification process.

•Did extensive work with ETL testing including Data Completeness, Data Transformation & Data Quality for various data feeds coming from source.

•Implemented SCD I, II to the extracts based on the business requirement and client expectations.

•Creating the expected results by executing the queries according to the test conditions.

•Raising defects where discrepancy found in the database and reporting it to development team.

•Guiding new resources to make them familiar with the project work

Personal Details:

Date of Birth

5th Sept 1990.

Contact Info

Flat -301, Shankeshwar Dang Ikon, Ravet-412101

Language known

English, Hindi and Marathi

Nationality

Indian

Marital Status

Single

Gender

Male

Declaration:

I consider myself confident of my ability to work in a team. I hereby declare that the above information is true to the best of my knowledge.

Date :

Place : Pune Saurabh Karle

Contact this candidate