Summary
Overview
Work History
Education
Skills
Certification
Skillset
Languages
Timeline
Generic

SUSHIL KULKARNI

Bangalore

Summary

A data enthusiast seeking for transition into data engineering. Having 10 +years experience in RDBMS, ETL , banking and IT domain. Experienced on RDBMs. SQL, data warehouse, data analysis, development of Business Intelligence solutions using Data engineering & Data Warehouse.

Overview

19
19
years of professional experience
1
1
Certification

Work History

Data engineer & ETL Developer in EDW team

IDBI INTECH LIMITED
04.2021 - Current
  • Company Overview: IDBI Intech Limited is a technology-led business transformation organization specializing in the Banking, Financial Services and Insurance industry vertical.
  • Data ingestion from RDBMs & flat file sources, and perform required data transformations before loading into the staging/ target data warehouse.
  • Analyzed and designed source and target mapping documents to design the ETL jobs.
  • Good understanding of data warehousing.
  • Written data-driven SQL / recommendations and create reports and visualizations to communicate insights.
  • Database Performance tuning, collecting statistics, ETL mapping tuning analyzing explains & determining which stats generating for the tables.
  • IDBI Intech Limited is a technology-led business transformation organization specializing in the Banking, Financial Services and Insurance industry vertical.

Team member

Iconnect
06.2018 - 06.2020
  • Supported IDBI NEFT & RTGS operations for IDBI branches across India.

Oracle DBA

Karnataka State Natural Disaster Monitoring Center (KSNDMC)
03.2015 - 05.2018
  • Company Overview: KSNDMC is providing a formal common platform to achieve synergy in the field of disaster management in Karnataka. KSNDMC has got 6000 TRG stations across the state, which stores the data at every 15 min of intervals in the database.
  • Proactive monitoring and maintenance of production database, working on Oracle 11g R2 RAC node cluster.
  • RMAN Configuration and Maintenance; Rman Backup/Recovery of Database.
  • Database backup & recovery.
  • Server tuning includes tuning of the shared pool, database buffer.
  • Sizing the database objects for effective space management.
  • Maintenance of DR site, physical standby database.
  • Cloning & refresh of production database for development environment.
  • Analyzing and Rebuilding of Indexes, Creating the Tablespace.
  • Performance tuning using AWR, ADDM, DBMS_STATS, Explain Plan, SQL
  • Trace. Oracle SQL Query optimization.
  • Managing the database security and creating and assigning roles and privileges as required by the client and application.
  • Maintains and monitors all procedural standard documents related to all database projects.
  • Working closely with other technical team for the smoother movement of the projects.
  • KSNDMC is providing a formal common platform to achieve synergy in the field of disaster management in Karnataka. KSNDMC has got 6000 TRG stations across the state, which stores the data at every 15 min of intervals in the database.

DBA

Commercial Tax Office, Karnataka State
08.2011 - 03.2015
  • Lead database Creation & Installation.
  • Analysis of Alert log file, Trace file, and checking listener status.
  • As per the requirement of development team refreshing/cloning of production database with the RMAN.
  • Implemented RMAN backup & recovery policy for production database.
  • Overseeing tasks of running import/export & data pump utilities, Lsnrctl, DB verify.
  • Successfully moved databases from local servers across Karnataka, to one centralized server. Which happened to be upgrade process of 8i version to 11G.

Reliance Communications
04.2006 - 05.2009
  • Company Overview: Had worked in Enterprise Business Support System (eBSS) team as Circle coordinator.
  • Had worked in Enterprise Business Support System (eBSS) team as Circle coordinator.

Education

Masters in Information Technology (MBA I.T.) -

01.2016

Bachelors of Science (B.Sc. I.T.) - undefined

01.2007

Skills

  • Python
  • Core Java
  • Oracle
  • SQL Server
  • RDS
  • SQL
  • Pandas
  • Numpy
  • Apache Spark
  • AWS
  • Amazon Redshift
  • S3
  • Glue
  • Informatica Powercenter
  • Linux
  • Aix
  • Windows

Certification

  • Big Data Hadoop & Spark Developer Certification, Simplilearn, MM/DD/YY
  • Oracle 10g OCP Certification, MM/DD/YY

Skillset

Python, Core Java, Oracle, SQL Server, RDS, SQL, Pandas, Numpy, Apache Spark, AWS, Amazon Redshift, S3, Glue, Informatica Powercenter, Linux, Aix, Windows

Languages

Hindi
English
Bilingual or Proficient (C2)
Marathi

Timeline

Data engineer & ETL Developer in EDW team

IDBI INTECH LIMITED
04.2021 - Current

Team member

Iconnect
06.2018 - 06.2020

Oracle DBA

Karnataka State Natural Disaster Monitoring Center (KSNDMC)
03.2015 - 05.2018

DBA

Commercial Tax Office, Karnataka State
08.2011 - 03.2015

Reliance Communications
04.2006 - 05.2009

Bachelors of Science (B.Sc. I.T.) - undefined

Masters in Information Technology (MBA I.T.) -

SUSHIL KULKARNI