KELLA RAJSEKHAR
Vishakapatnam
Summary
- Over 6.9 years of expertise in PL/SQL and ETL Informatica PowerCenter, providing production support at Tech Mahindra and Clover Infotech Pvt. Ltd.
- Proficient in SQL and PL/SQL programming with a strong track record of developing complex queries, stored procedures, functions, packages, and triggers. Demonstrated ability to optimize database performance and enhance data retrieval processes. Experienced in collaborating with cross-functional teams to deliver data-driven solutions. Consistently meets project deadlines while maintaining high-quality standards.
- practical experience in data migration utilizing SQL Loader and Oracle Loader.
- strong expertise in performance optimization methods (bulk collect, bulk bind, indexing, partitioning)
- exposure to ETL development and support utilizing Informatica PowerCenter.
- expertise in both development and maintenance initiatives.
- quick learner with strong analytical skills in debugging and problem-solving.
- exceptional communication and teamwork skills.
Overview
8
8
years of professional experience
Work History
Informatica Developer & Support
Axis Bank
04.2024 - Current
- Risk Data Mart is used to calculate the risk on different banking products based on daily EOD data.
- Interacted with users for integrating new data sets into the Risk Data Mart.
- Performed unit testing of mappings and workflows, documenting test results.
- Analyzed execution time and applied performance tuning to optimize workflows.
- Handled ad-hoc requests to load data from flat files provided by business teams.
- Managed production databases, including table and procedure modifications.
- Built mappings and workflows as per business logic and solution documentation.
- Deployed code in production and scheduled jobs as per client requirements.
- Environment: Informatica PowerCenter 10.1.1 | Database: Oracle 10g/11g/9c
SQL Developer
ICICI Bank
12.2021 - 03.2024
- Developed and maintained backend database systems for ICICI Bank’s financial applications, focusing on automating and optimizing key processes like customer creation, EMI, and DPD calculations.
- Designed and implemented database objects including tables, views, sequences, and indexes.
- Optimized performance using Bulk Collect, Bulk Bind, Partitioned Tables, and Indexes.
- Developed business logic for customer onboarding, EMI, DPD, and LPC calculations.
- Utilized DBMS_UTILITY, UTL_FILE, and DBMS_JOBS packages for automation and job scheduling.
- Created triggers and SQL scripts for data manipulation.
- Supported database objects in development and testing environments.
- Environment: Informatica, SQL Developer, Unix
PL/SQL Developer
Teletalk
09.2018 - 03.2021
- Handled the settlement process for multiple telecom networks, managing international and local call data processing, billing, and provisioning tasks such as CAF details, MDN changes, and plan management.
- Developed and maintained PL/SQL procedures, functions, packages, and triggers.
- Created and managed tables, indexes, and other database objects.
- Used SQL Loader and Oracle Loader for data migration.
- Performed production support and testing activities.
- Involved in PL/SQL coding, debugging, and performance improvement.
Education
B.Tech - undefined
Kaushik College of Engineering
Intermediate - undefined
Sri Chaitanya College
10th -
Abhyudaya High School
Bobbili Andhra Pradesh Skills
Database: Oracle 12c, Oracle 11g, Oracle 10g
Languages: SQL, PL/SQL
ETL Tools: Informatica PowerCenter 1011,IICS
Operating Systems: Windows Family, Unix
Tools: SQL Developer, PL/SQL Developer, ETL
DECLARATION
I hereby declare that the above details are true to the best of my knowledge. (KELLA RAJSEKHAR)
PERSONAL ATTRIBUTES
- Effective team member with excellent client interaction skills.
- Self-motivated and goal-oriented.
- Strong planning and organizational abilities.
- Broad conceptual thinking while handling sensitive data.
Timeline
Informatica Developer & Support
Axis Bank
04.2024 - Current
SQL Developer
ICICI Bank
12.2021 - 03.2024
PL/SQL Developer
Teletalk
09.2018 - 03.2021
B.Tech - undefined
Kaushik College of Engineering
Intermediate - undefined
Sri Chaitanya College
10th -
Abhyudaya High School