Summary
Overview
Work History
Education
Skills
Websites
Languages
Accomplishments
Timeline
Generic
Kanika Narang

Kanika Narang

Delhi-NCR

Summary

PL/SQL Developer with 9 years of experience in designing, developing, and optimising Oracle database applications. Proven expertise in PL/SQL programming, performance tuning, stored procedures, packages, triggers, and data migration. Adept at collaborating with cross-functional teams to deliver scalable, high-performance database solutions in healthcare and insurance domains.

Overview

9
9
years of professional experience

Work History

Technology Analyst

Infosys
Noida
04.2022 - Current
  • Led full development cycle for MaxLife Insurance, covering planning, analysis, design, testing, and implementation.
  • Automated ETL and data validation processes, reducing manual efforts by 50%.
  • Collaborated with business analysts and QA teams to ensure thorough requirement analysis.
  • Designed data entry structures and indexing strategies to enhance reporting speed.
  • Developed complex stored procedures and packages for MyAgent data management.
  • Optimised Oracle RDBMS performance using strategic hints for thePfizer project.
  • Crafted tailored SQL and PL/SQL queries to meet specific client requirements.
  • Formulated migration documentation and deployment scripts for seamless code transitions.

Consultant

Capgemini
Noida
08.2021 - 04.2022
  • Worked on BigData in Healthcare Project.
  • Created framework for ingestion and transformation of data using AWS, EC2, Python, S3, Amazon Redshift, Postgre, JIRA.

System Engineer

Tata Consultancy Ltd
Pune
07.2016 - 08.2021
  • Worked as Oracle ERP technical Consultant.
  • Created and Implemented Oracle Reports, WebADI, XML reports using PLSQL, SQL, UNIX.

Education

B.E -

Medicaps Institute of Technology and Management
Indore
06.2016

Skills

  • PLSQL
  • UNIX
  • Python(Beginner)
  • JIRA
  • GITHUB
  • AWS

Languages

  • English
  • Hindi

Accomplishments

  • Tech Domain Maestro Award for FY23

Timeline

Technology Analyst

Infosys
04.2022 - Current

Consultant

Capgemini
08.2021 - 04.2022

System Engineer

Tata Consultancy Ltd
07.2016 - 08.2021

B.E -

Medicaps Institute of Technology and Management
Kanika Narang