Satyam Kumar Keshri
Bangalore
Summary
Detail-oriented, organized and meticulous employee. Enthusiastic team player ready to contribute to company success. Highly skilled System Engineer with significant experience in managing large scale IT projects. Over 3+ years of experience as an Oracle PL/SQL developer in Analysis, Design and Implementation of Business Applications using in Oracle Relational Database Management System.
Overview
3
3
years of professional experience
Work History
System Engineer • PLSQL Developer
Tata Consultancy Services
07.2021 - Current
- Worked on SQL and PL/SQL to develop new procedures, fix existing code issues, and fine-tune the queries.
- Carried out data analysis for finding data issues and code defects.
- Developed complex database objects like Oracle stored procedures, tables, and views optimized for data retrieval, persistence, low latency, and optimal query structure, packages, triggers using PL/SQL.
- Strong knowledge on logical and physical data modeling using normalizing techniques.
- Experience with data flow diagrams, data dictionary, database normalization theory techniques, entity relation modeling, and design techniques.
- Coordinating ETL and data migrations to move data through environments (Development, Test and Production), synchronize data as necessary, and protect production data by seeding non-prod databases with accurate test data.
- Developed materialized views for data replication in distributed environments.
Education
B.Tech -
Chandigarh Engineering College
Chandigarh06.2021
Intermediate -
Maharaja College
Arrah04.2016
Matriculation -
Jean Paul's High School
Arrah04.2014
Skills
- Oracle PL/SQL
- SQL
- SAP Business Objects
- OBIEE
- Data Warehousing
- Java / Python (Basics)
- ETL
- Linux/ Unix
- Oracle General Ledger
- Performance Optimization
- Programming (Java/Python)
- HTML/ CSS/ JavaScript
Accomplishments
- Service and Commitment Award (May 2022)
- Best Project Automation of the Unit for the Year 2022 - 2023
- Special Achievement Award - Raising star of the Month.
Languages
Hindi
First Language
English
Proficient (C2)
C2
Projects
NEST, Jul 2021 - Present, The National Employment Savings Trust (NEST) is a defined contribution workplace pension scheme in the United Kingdom. The project involves Extracting data from different sources, cleansing and processing the data in data warehouse and delivering the processed data for different business requirements. It also involved in ETL and data migration to move data through different environments and ensure data integrity. My role encompassed tasked such as analysis, design, development, data analysis, automations, error handling, code review and communication with Stakeholders.
Affiliations
- Fitness Enthusiast: Regularly engage in gym workouts to maintain a healthy and active lifestyle
- Cooking or Baking
Timeline
System Engineer • PLSQL Developer
Tata Consultancy Services
07.2021 - Current
B.Tech -
Chandigarh Engineering College
Intermediate -
Maharaja College
Matriculation -
Jean Paul's High School
Similar Profiles
Vrunda ChindhadeVrunda Chindhade
HR Manager at Tata Consultancy Services, TCS, Tata Consultancy Services LimitedHR Manager at Tata Consultancy Services, TCS, Tata Consultancy Services Limited
Sreya BasuSreya Basu
Procare Analyst at Tata Steel(Tata Consultancy Services)Procare Analyst at Tata Steel(Tata Consultancy Services)
Arun VArun V
Program Manager at Tata consultancy services | Financial Ombudsman ServicesProgram Manager at Tata consultancy services | Financial Ombudsman Services
Naimish AgnihotriNaimish Agnihotri
Assistant Delivery Manager at Tata Consultancy Services, Global Shared ServicesAssistant Delivery Manager at Tata Consultancy Services, Global Shared Services
Sangeetha NaikSangeetha Naik
Lead Software Engineer at Wells FargoLead Software Engineer at Wells Fargo