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