Engineer Oracle
Resume:
Ramya Nallappan
Mobile :
E-mail :
***************@*****.***
Passionate Database Engineer with 2.5+ years of experience, seeking to leverage proven Oracle, Ms SQL and Oracle PL/SQL skills to grow efficiency both technically focused and customer oriented. Hardworking and committed to meeting corporate objectives.
SUMMARY
Having 2.5+ years of experience in Application Software development using Oracle 9i/10g.
Extensive experience in developing Stored Procedures, Functions, Triggers, Views, Cursors, Packages, Exceptions, Joins, Sub Queries and Set Operators.
Strong understanding of business processes with good experience in development.
Used Dialogue-mapping to gather requirements to customer satisfaction.
Used Oracle data modeling to boost productivity and production costs.
Quick-learner and self-directed.
Good experience of coordinating with various teams like Deployment, Testing Team to speed up development process.
WORK EXPERIENCE
Currently working as a Senior Systems Engineer in Infosys Limited, Bangalore from May 2016 to till date.
TECHNICAL SKILLS
Oracle Database Management 12c
Microsoft Sequel Server 2012 (Ms SQL)
Oracle PL/SQL
UNIX Shell Scripting
Relational Database Management System (RDBMS)
PROJECT DETAILS
12/2017 to Till Senior Systems Engineer
Infosys Pvt. Ltd – Bangalore, Karnataka
Technologies:
Oracle, Ms SQL, Oracle PL/SQL
Responsibilities:
Convert the Business need in to Technical complex queries.
Designing databases and ensuring their stability, reliability, and performance, Monitor system performance and ensure system availability and reliability.
Experience in data migration/conversation using SQL*Loader.
Develop and provide support to all system interfaces and coordinate with all project managers to provide specifications for all core modules
Expertise in writing procedures, functions, views, materialized views as required
Experience in Data migration using import and export.
Expertise in creating the indexes on tables and partitioning the table for SQL tuning purpose.
Responsible for performance tuning activities in the project.
12/2016 to 11/2017 Systems Engineer
Infosys Pvt. Ltd – Hyderabad, Karnataka
Technologies:
Oracle PL/SQL
Responsibilities:
Requirement gathering from the Business Team.
Convert the functional requirements into technical document as per the business standards.
Monitor and recommend changes if required to all PL/ SQL packages and provide stored procedures and design and develop various relational database.
Worked as per the CR Raised from the end user.
Created Database Objects like tables, Views, sequences, Synonyms, Stored Procedures, functions, Packages, Cursors, Ref Cursor and Triggers as per the Business requirements.
Perform DML, DDL Operations as per the Business requirement.
Wrote SQL Queries using Joins, Sub Queries and correlated sub Queries to retrieve data from the database.
Involved in peer-to-peer code reviews.
05/2016 to 11/2016 System Engineer Trainee
Infosys Pvt. Ltd – Mysore, Karnataka
Responsibilities:
Acquired all my skills in the IT field at Infosys during that period.
Trained in the field of Python basics, RDBMS, Oracle PL/SQL, Oracle 12c/11g, MS-SQL, UNIX Shell Scripting.
EDUCATION
Qualification/Degree
Institution
Duration of Program
CGPA
BE(ECE)
Sri Krishna College of Engineering and Technology, Coimbatore
2012 – 2016
9.07
Contact this candidate