Summary
Overview
Work History
Education
Skills
Personal Information
Projects
Timeline

Kumar Dewashish

Consultant
Bangalore

Summary

Looking for a challenging role in a reputable organization to utilize my technical, database, and management skills for the growth of the organization as well as to enhance my knowledge about new and emerging trends in the IT sector.

Over 6 years in IT industry with emphasis on Development, Implementation and Support of project. Involved in all phases of the SDLC(Software Development Life Cycle ) from analysis, design, development, testing and implementation and maintenance with timely delivery against aggressive deadline. Strong exposure in writing Simple and Complex SQLs, PL/SQL Functions and Procedures, Packages and creation of Tables, Materialized views, Triggers, Unix Commands and basic DBA activities. Created Tables, Views, Constraints, Index. Experienced and result oriented professional with a sound track record in Banking & Insurance Domain. Good exposures in Dynamic SQL, Exceptions, Joins, Sub-queries. Goal oriented team player, self starter and quick learner. Working experience in Banking domain (CBS, AML). Good experience in SQL language like DDL, DML, TCL and DCL. Good at using Integrity Constraints at column and table levels. Good knowledge in various Operators like arithmetic, relational, logical etc. Good knowledge on SQL Server (SSMS), PLSQL, ORACLE. Good experience in all types of Joins in SQL. SQL Performance Tuning. Worked extensively on PL/SQL programming. Good knowledge of Linux commands. An articulate communicator with proven interpersonal and technical skills, honed with excellence and ability to work under pressure in a fast-paced and sensitive environment.

Overview

7
7
years of professional experience

Work History

AML Implementation and support

Kiya.ai
06.2019 - Current
  • Involved in understanding the project requirements and the entities available in the project
  • Wrote SQL queries to retrieve the data from the database
  • Used the concept of Correlated, Joins & derived tables while working with the complex queries
  • Participated in discussions involving the application creation and understanding the requirements
  • Understanding and analysis of user's requirement for minor enhancements
  • Identification of bug and the provision of immediate workaround
  • Response to end user's functional queries
  • Product implementation and set up
  • Schema design, Code review and SQL query tuning
  • Module changes as per the business requirement
  • Diagnose and troubleshoot database error and identify the root cause and fixes to database object
  • Created report as per the business requirement
  • Maintaining relationships between tables, Creating Database objects like Procedure, Function, View, Materialized View
  • Hands on experience in creating complex DB queries, procedures, functions, DDL & DML for defect resolution and reporting
  • Managing and handling production as well as UAT issues, release patches in Qc, Dev, UAT as well as production environment.

Logipro Software
11.2016 - 05.2019

Education

B.E. in CSE -

Rajarajeswari College of Engineering, Bangalore

Skills

    Plsql

undefined

Personal Information

  • Father's Name: Mr. Rabindra Jha
  • Mother's Name: Mrs. Lalita Jha
  • Date of Birth: 01/04/89

Projects

Anti-Money Laundering Implementation and Support, 06/2019 - Present, SQL Server, Oracle, AML Implementation and support, Banking, Anti-Money Laundering (AML) is an end-to-end Solution for transaction and customer screening and regulatory reporting. The solution is designed to meet the compliance requirements of organization that are first time adopters of compliance policies and which want to expand the compliance network across the organization. Accordingly, the solution is available in basic and advanced versions; each designed to suit your institution’s evolving compliance program., Involved in understanding the project requirements and the entities available in the project., Wrote SQL queries to retrieve the data from the database., Used the concept of Correlated, Joins & derived tables while working with the complex queries., Participated in discussions involving the application creation and understanding the requirements., Understanding and analysis of user’s requirement for minor enhancements., Identification of bug and the provision of immediate workaround., Response to end user’s functional queries., Product implementation and set up., Schema design, Code review and SQL query tuning., Module changes as per the business requirement., Diagnose and troubleshoot database error and identify the root cause and fixes to database object., Created report as per the business requirement., Maintaining relationships between tables, Creating Database objects like Procedure, Function, View, Materialized View, Hands on experience in creating complex DB queries, procedures, functions, DDL & DML for defect resolution and reporting, Managing and handling production as well as UAT issues, release patches in Qc, Dev, UAT as well as production environment

Timeline

AML Implementation and support - Kiya.ai
06.2019 - Current
- Logipro Software
11.2016 - 05.2019
Rajarajeswari College of Engineering - B.E. in CSE,

Similar Profiles

CREATE PROFILE
Kumar DewashishConsultant