Deepak B. Email & Phone Number

Bahrain

Bahrain

Working Closely with Compliance team and supporting for AMLapplication issues and queries.Monitoring job scheduled for data upload activities for different entities.Developing new scenarios/rules based on Compliance requirementDeploying & Testing new functionalities and fixes shared by vendor anddeploying the same in production environment with UAT signoff.Developing and testing reports as per the compliance ,& other teamrequirement.Writing SQL queries and providing data as per request from complianceand other team .Interaction with the Compliance team on daily basis for any issues andproviding resolutions.

Hyderabad, Telangana, India

Understand the requirements from Business Requirement Document.Reviewing Source and target mappings with the mapping documents as perbusiness requirementsInvolved in developing tables , procedures , functions , & views in Netezzadatabase for object and data migrationPerform data validations, data transformations check available through ETLin Netezza.

Mumbai Area, India

• Understand the Business requirements from BRD (Business Requirement Document).• Creating staging tables as per DI Mapping Sheet and perform mapping to the main tables.• Developing procedures, functions and other SQL objects based as per the requirement of the Client.• Perform data validations, data transformations check available through ETL in the staging tables.• Loading the staging data into various tables accessed by the application and perform validations• Developing and testing reports as per the client requirement.• Performing the SIT, UAT and Production deployment activities i.e. installation of tomcat, Java, Database restoration & Application release for UAT environment setup.• Creating indexes for increasing the performance of the queries through optimizer.• Interaction with the Clients on daily basis for Production/UAT issues and providing resolution.• Raise Application issues to the Off-shore team and get it done within timelines.• Creating and providing the daily status report as well as the overall report for each of the releases.

Mumbai Area, India

• Identify and develop test cases to ensure thorough, repeatable testing that can be carried out by others.• Perform data load and data migration of the schemas through the product.• Write SQL scripts to validate data accuracy and consistency.• Perform data analysis, testing and validation using SQL queries and data-driven testing methodologies to create reusable tests that leverage source to target validation.• Identify and document issues found in defect tools• Involved in writing different SQL queries to perform report data validations, SQL objects code validation and performance evaluation.• Performed migration activities such as schema migration, SQL object migration along with table data migration.• Perform data analysis, issue research and resolution to confirm high data quality.• Interaction with the Clients regarding the issues and providing resolution• Product training and user documentation review• Understanding the business requirements from the BRD.• Creating and executing ETL test cases to validate the business requirements.• Reviewing Source and target mappings with the mapping documents as per business requirements• Executing back-end-data-driven test efforts with a focus on data transformations between various systems and data warehouse.• Develop test plan, execute test cases and defect management for the ETL and BI systems.• Executing and Monitoring batch jobs, schedulers, re-processing the failed Batch Jobs on SAP BODS.• Involved in creating SQL queries for validating data between source and target and also validating transforms used in the jobs.• Raising Defects in bug tracking tool to the Development team.• Involved in Sanity, Functional and Regression testing.

Mumbai

Understanding the business requirement and functional specifications.Involved in developing and executing etl as well as functional test cases to validate business requirements.Used SSIS to schedule the jobs, execute the jobs and validate the mapping done in the jobs with the mapping documents and requirements.Involved in validating the data moving from source to target based on the different filter criteria, transformations and lookup conditions.Developed ETL test scripts based on technical specifications/Data, design documents and Source to Target mappings.Defect tracking and management using Web prompt. .Validate the data in Oracle (source) and sybase(target) database after ETL process.Involved in testing and providing daily, monthly and yearly reports to the client.Involved in Sanity,Functional and regression testing.