Pursuing opportunities to leverage nearly 5

years of experience in Oracle PL/SQL and SQL

development to optimize database systems, Ajeet Kumar
enhance performance, and support data-
driven decision-making. Targeting to
PROFILE SUMMARY
contribute experience in PL/SQL
programming, data migration, and SQL query
 Focused professional with wealth of experience in optimizing PL/SQL code for
optimization in a role that fosters both
complex business applications; skilled in designing scalable and efficient stored
professional growth and organizational
procedures, functions, triggers, and packages that streamline back-end
success.
operations and enhance database performance.
 Expertise in architecting high-performance Oracle databases, including schema
development, data integrity assurance, and indexing strategies; skilled in
database normalization, partitioning, and space management to support
business growth.
 Proficient in advanced SQL and PL/SQL techniques, such as Bulk Collect,
FORALL, Dynamic SQL, and large data volumes handling; successful in improving
query performance and ensuring high system uptime through optimization and
performance analysis.
CONTACT  Effective collaborator with Developers, QA Engineers, and business
stakeholders, translating complex requirements into efficient, maintainable SQL
solutions; experienced in technical documentation, unit testing, and
ajeet08tit@gmail.com
deployment planning.
+91 9310148939  Experienced in managing the database development lifecycle, from
Bhojpur, 802158, Bihar requirements gathering and design to coding, testing, migrations, and
production deployment.
 Proven capability to diagnose performance bottlenecks and optimize SQL
queries, functions, and database structures, improving application
performance and system scalability through strategic tuning and
troubleshooting.
 Recognized for leadership in knowledge sharing, mentoring teams, and driving
automation initiatives to enhance operational efficiency and team productivity.

TECHNICAL SKILLS
CORE COMPETENCIES
 Oracle SQL
PL/SQL Programming  PL/SQL (10g, 11g, 12c)
SQL & PL/SQL Performance Tuning  Oracle Architecture
 Database Design
Database Design & Architecture
 Report Generation (Using PL/SQL)
Data Integrity & Validation  PL/SQL Programming: Triggers, Stored Procedures, Functions, Packages
Data Migration & ETL Processes  Advanced PL/SQL Concepts: Bulk Collect, Bulk Exception Handling, Collections,
Oracle Database Management FORALL, Cursors (including Ref-Cursors), Exception Handling, Anonymous
Blocks
Database Security & User
 RepTechnical Documentation: Writing Technical Design Documents,
Management
Developing Unit Test Documents
Backup, Recovery & Disaster  Oracle Database Administration (DBA) Responsibilities: Management
Recovery (Synonyms, Privileges, Roles, Table Partitioning, Index Sequences), Space
SQL Query Development & Management (Tablespaces, Rollback Segments)
Optimization  Tools: PL/SQL Developer, TOAD, SQL*Plus
Reporting & Data Analysis
Database Performance Monitoring ORGANISATIONAL EXPERIENCE
Cross-Platform SQL Development
Sep'21 - Dec'24 | Engineering Analyst | Qualtech Consultants Pvt. Ltd.

Project: MMMA (MyMoney & MyAgent)

Client: Max Life Insurance
Period: Sep’21 – Dec’24

Key Result Areas:

 Constructed efficient PL/SQL programs—including functions, procedures,
EDUCATION triggers, and packages—to support back-end workflow and enable modular,
reusable components across systems.
Bachelor of Technology (B.Tech.) in  Refined and optimized SQL and PL/SQL statements to improve query
Electronics and Communication performance, minimize execution time, and ensure seamless integration
Engineering between back-end databases and application interfaces.
TIT, 2016  Engaged with Development Teams to understand project requirements and
shaped database structures using Oracle 10g/11g/12c that aligned with system
architecture and supported long-term scalability.
 Applied robust data validation rules and enforced integrity through constraints,
exceptions, and PL/SQL collections to ensure consistent and accurate data
handling.
ACHIEVEMENTS  Documented all development efforts, including changes to SQL queries, stored
procedures, and data logic, to support team collaboration, future maintenance,
Client Recognition: Commended for and audit readiness.
exceptional performance in  Translated business requirements into detailed technical specifications and
independently designing and proactively troubleshot issues using tools like PL/SQL Developer, TOAD, and
maintaining unit tests for SQL and SQL*Plus to maintain database stability and performance.
PL/SQL programs.
Highlights:
Team Contribution: Honored as
 Identified manual, repetitive tasks and collaborated with teams to implement
"Team Player of the Month" for
automation solutions, notably reducing turnaround time and operational
consistently supporting team goals
overhead.
and delivering impactful results in
 Created knowledge assets and conducted technical training sessions to upskill
offshore operations.
team members, fostering a culture of continuous learning and improving overall
Stakeholder Appreciation: Frequently
team productivity.
acknowledged by onshore and
 Proactively addressed critical database issues and performance bottlenecks,
offshore clients for swift issue
resulting in faster deployments and improved system reliability for end-users.
resolution and delivering timely,
effective solutions.
Knowledge Leadership: Authored Project: Group Asia
detailed technical documentation and Client: Max Life Insurance
facilitated team training sessions, Period: Apr’24 – Dec’24
earning praise for enhancing Highlights:
collective technical proficiency.  Collaborated with Business Analysts to resolve group policy claim settlement
Process Optimization: Initiated and issues by reviewing Functional Specification Documents (FSDs) and
supported automation efforts to interpreting business requirements to identify necessary system modifications.
streamline manual processes, notably  Updated existing code to align with new specifications, followed by
improving operational efficiency and comprehensive testing to ensure performance accuracy and system integrity.
accuracy.  Compiled test results for Business Analyst review; upon successful validation
and user confirmation, supported seamless deployment of the updated code to
the production environment.

Apr'21 - Aug'21 | Software Developer | Nelito Systems Private Limited

Project: Comprehensive Annuity Management System

Client: ICICI Prudential Life
DATA MIGRATION PROJECT Period: Apr’21 – Aug’21
Highlights:
Project: Data Migration from Source to
 Designed, developed, and maintained SQL & PL/SQL databases based on
Target Table
detailed specifications, implementing unit tests and resolving performance,
Responsibilities:
capacity, and replication issues.
 Analyzed source (SQL Server) and target
(Oracle) database schemas, mapping
 Created and deployed data models and physical database structures, facilitating
smooth transitions between Development, QA, and Production environments.
tables, columns, and relationships.
 Extracted data from SQL Server, flat  Developed complex SQL queries, triggers, procedures, and scripts to support
files, and CSV files using ETL tools like Development Teams, ensuring code efficiency and accuracy.
Informatica.  Monitored database systems for errors, conducted troubleshooting, and
 Applied business rules and used PL/SQL addressed production and development issues to ensure high availability and
and SQL for data cleansing and smooth performance.
transformation.  Documented processes, shared technical knowledge within the team, and
 Loaded transformed data into target configured database network connectivity to support seamless system
Oracle tables using bulk loading operations.
techniques and optimized SQL scripts.
 Validated data integrity and consistency Jun'20 - Apr'21 | Software Developer | Vareli Tecnac Pvt. Ltd.
using SQL Server Management Studio
(SSMS) and Oracle SQL Developer. Project: BCCL-COALNET
Client: Coal India
Period: Jun’20 – Apr’21
Highlights:
 Collaborated with the client to gather new requirements, conducted analysis,
and developed comprehensive project documentation.
 Designed and modified database objects, including procedures, functions,
triggers, packages, tables, and views, to meet client specifications and business
needs.
PERSONAL DETAILS  Implemented business rules, constraints, and created audit tables to monitor
data changes, ensuring system integrity.
Date of Birth: 16th January 1995
 Developed custom Oracle reports and debugged defects, focusing on resolving
Languages Known: English, Hindi, issues in business logic implementation.
Bhojpuri  Troubleshot and addressed system issues during development, ensuring
smooth functionality and timely resolution of problems.