Shruthi H C
Bangalore
Summary
Having 3.8 years of relevant working experience as a Oracle Database SQL/PLSQL Developer, which includes Software Design, Coding and Implementation on Windows Environments in relating to Database System in Software Application Development. Experience in Developing and Designing Queries Using Joins, Sub-queries, Set Operators, Pseudo Columns, Group Functions, Analytic Functions. Experience in Creating and Managing Tables, Integrity Constraints, Views, Indexes, Sequences and Synonyms. Constructive skill in Developing Stored Procedures, Functions, Packages, Application of Cursors and Runtime Handling of Error Using Exceptions in PLSQL. Having experience on Bulk Collect, Bulk Bind and Collections. Experience in Creating DDL, DML and TCL Queries in SQL. Having experience on hierarchical query's. Knowledge in Loading data into Oracle database utilizing SQL*Loader. Knowledge on Performance Tuning and Oracle Architecture.
Overview
4
4
years of professional experience
1
1
Certification
Work History
Software Engineer
Technoforte Software Pvt.ltd , Client - Toyota Kirloskar Auto Parts(TKAP).
Bangalore
2022.05 - Current
- Design and develop Oracle Forms and Reports applications based on business requirements.
- Create and maintain database objects, such as tables, views, and stored procedures
- Write and optimize AQL and PL/SQL code for database interaction and business logic.
- Conduct thorough testing of Oracle Forms and Reports applications to identify and address any issues.
- Collaborate with QA teams to perform system, integration, and regression testing.
- Optimize application and database performance through effective SQL tuning and query optimization.
- Identify and resolve performance bottlenecks to ensure optimal system responsiveness.
- Create and maintain technical documentation, including design specifications, user manuals, and release notes.
- Work closely with end-users to understand requirements and deliver solutions that meet or exceed expectations.
Process Consultant
Hinduja Global Solutions
Bangalore
2020.05 - 2022.04
- Design, develop, and maintain SQL databases and schemas to meet application requirements.
- Create and optimize complex SQL queries, stored procedures, and functions.
- Perform data modeling to visualize database structure and relationships.
- Ensure data integrity and normalization within the database.
- Optimize database performance through effective indexing, query optimization, and performance monitoring.
- Conduct regular database maintenance tasks, including backups, restores, and updates.
- Collaborate with other team members to integrate SQL solutions with various applications.
Education
Master of Science - Computer Science
Jannabharati Campus, Bangalore University
Bangalore2019-07
Bachelor of Science - Computer Science And Programming
Shree Siddaganga College, Tumkur
Tumkur2016-07
Skills
- Ul>
- Oracle SQL
- P>PL/SQL
- P>Oracle Forms (Oracle form Builder)
- P>Oracle Reports
- P>Unix
- P>Filezilla
- P>Oracle sql developer 12c
- P>Putty
Certification
SQL , PL/SQL, Core java and Manual testing in Aradhya's Brilliance Center, Vijayanagar-Bangalore
Timeline
Software Engineer
Technoforte Software Pvt.ltd , Client - Toyota Kirloskar Auto Parts(TKAP).
2022.05 - Current
Process Consultant
Hinduja Global Solutions
2020.05 - 2022.04
Master of Science - Computer Science
Jannabharati Campus, Bangalore University
Bachelor of Science - Computer Science And Programming
Shree Siddaganga College, Tumkur
SQL , PL/SQL, Core java and Manual testing in Aradhya's Brilliance Center, Vijayanagar-Bangalore
Similar Profiles
Vinay Krishna VadranamVinay Krishna Vadranam
Section Head at Kirloskar Toyota Textile Machinery Pvt.LtdSection Head at Kirloskar Toyota Textile Machinery Pvt.Ltd
Ramaprasad Ramaprasad null
Welding Supervisor & Instructor @ Toyota L&D at Toyota Kirloskar Motor Pvt.Ltd.Welding Supervisor & Instructor @ Toyota L&D at Toyota Kirloskar Motor Pvt.Ltd.
Sameer RathSameer Rath
Supply chain management executive at Polyplastics Auto, Components PVT LTD, Suzuki India LTD, Toyota Kirloskar Motor PVT LTDSupply chain management executive at Polyplastics Auto, Components PVT LTD, Suzuki India LTD, Toyota Kirloskar Motor PVT LTD