Ramya Nallappan

**th MAY ****

Mobile :

+91-974*******

E-mail :

ac89z1@r.postjobfree.com

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