Amrit Robin Ekka

Associate Consultant

Bengaluru, Karnataka, India17 yrs 11 mos experience

Highly Stable

Key Highlights

17+ years of experience in Oracle Database technologies.
Expertise in data analysis and performance tuning.
Author of 'Must Know Growth Pointers' on career development.

Stackforce AI infers this person is a Backend-heavy Fullstack professional with extensive experience in Data Management and Oracle technologies.

Contact

Skills

Core Skills

PlsqlPerformance TuningData Migration

Other Skills

Analytical SkillsApplication SupportBug FixingCore JavaData AnalysisInformatica Power CenterMaintenance and EnhancementMicrosoft SQL ServerPL/SQLProblem SolvingPython (Programming Language)SQLSQL Server Integration Services (SSIS)SQL TuningShell Scripting

About

I am a Oracle Database Tech Lead with expertise in Data Profiling,Data Migration, Maintenance, Data Analysis,Gap Analysis, Performance Tuning, Bug Fixing, and the development of client apps using Oracle. Given below are my career highlights. 1. PLSQL Lead with 17+ Years of Experience. 2. Expertise in requirement gathering, data analysis, code analysis, performance tuning, bug fixing, and backend development with Oracle PLSQL and Shell Scripting. 3. Expertise in writing VBA Macros for automating manual processes. 4. Good hands-on experience working in Informatica Power Center and Informatica Data Quality. 5. Have 5 years of Onsite Work Experience. 6. Expertise in providing training to freshers/new joiners. 7. Worked with Tech Giants only throughout my career. I am also part of Tech interview panel that conducts technical rounds for recruiting laterals resources. Apart from these, I spend my time reading books, organizing events, Adventure Activities, and Music Jamming. I am also the author of the Book 'Must Know Growth Pointers' where I shared different aspects of a career that has huge impacts and it should be worked upon as early as possible. Below is the link to my book. Book Link: https://www.amazon.in/Must-Growth-Pointer-Amrit-Robin-ebook/dp/B08BZ8ZHCF

Experience

Cgi

Associate Consultant

Nov 2022 – Present · 3 yrs 4 mos · Bengaluru, Karnataka, India · Hybrid

Maintenance and Enhancement , Bug Fixing, Performace Tuning

Maintenance and EnhancementBug FixingPerformance TuningPLSQL

Idc technologies solutions pvt ltd

Technical Lead

Apr 2021 – Jun 2022 · 1 yr 2 mos · Pune, Maharashtra, India

Cognizant

Associate - Projects

Sep 2007 – Jan 2021 · 13 yrs 4 mos · Kolkata Area, India

Involved in designing, developing, and testing of PL/SQL stored procedures, packages and triggers.
Created database objects like Tables, views,synonyms, Indexes.
Loading data into Client environment using SQL Loader,External Tables,UTL_FILE.
Experience in SQL Tuning and Performance Enhancement using TKPROF and Explain Plans.
Writing wrapper functions to call Java/C/Shell Script from Oracle Package.
Creating and scheduling Jobs using DMBS_JOB package/Cron Jobs.
Writing Shell Script to automate task from UNIX/LINUX environment.
Actively participated in requirement gathering and business meeting with client.
Experience in issue analysis and applying quick fix for Priority 1 issue.
Experience in Data Analysis.
Experience in Data Migration project.
Experience in preparing requirement document,Low level and High level designs and test plan documents.
Identifying automation requirement of Project and automated various tasks using Excel Macros/VBA.
Experience in Data analysis,data profiling,creating scorecards,data cleansing, data standardization using Informatica Developer/Analyst.
Experience in creating mapping/wokflows using Informatica Developer and promote it to PROD using Informatica Power Center.
Experience in giving technical training to new resources in PL/SQL,Unix,Inforrmatica Power Center/Informatia Data Quality.
Informatica Power Center/Informatica Developer Installation and Configuring various services ie Repository service ,Integration service,Model Repository Analyst,Data Integration Service and Analyst Service