Data Analyst with the EDW team - IDBI INTECH LIMITED
(2022-04)
- Data collection from Finacle, payment systems, treasury systems, further data profiling, data cleaning using sql & Python for semi-structure data
- Ensure data quality and consistency across the sources
- Exploring data to understand dataset, studying relationship between tables, finding outliers, analyzing data patterns using SQL & Python
- Experience in understanding of business requirements & design data models (Starschema/ Snowflake), relationships
- Provides insights into raw data
- Created digital payment dashboard in quarterly & half yearly meetings to ascertain the growth of digital payment
- Analyzing customer profiles, demographics data and transaction patterns
- Sound knowledge on data warehousing concept, Star & snowflake schema data models, Constraints
- Work collaboratively with cross-functional teams, business users and effectively communicate insights and recommendations
Iconnect Team member - IDBI INTECH LIMITED
(2018-06 - 2022-03)
Iconnect is a middleware application which enable all IDBI branch users to create NEFT & RTGS transactions either by bulk or single upload from Finacle.
- Performs UAT of CNEFT, CRTGS, and cps application whenever a new business requirement comes
- Does Patch movement and patch apply activity on production server
- Performs VA activity for applications, following up with the respective team till closure of VA points
- Responsible for application support and identifying run-time issues if any
Oracle DBA - Karnataka State Natural Disaster Monitoring Centre (KSNDMC) - Bangalore
(2015-03 - 2018-05)
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.
- Worked as Oracle DBA in KSNDMC datacenter project, Bangalore
- 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
DBA - Commercial Tax Office, Karnataka State
(2011-08 - 2015-03)
To manage, support and maintain Value Added Tax (VAT) database pertaining to commercial tax and transactions across Karnataka state. In co-ordination with National Information Center (NIC).
- 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
- Upgrade process of 8i version to 11G
