Data Developer

R.RENUGAMBAL

EMAIL: ***********@*****.***

Mobile: +91-809*******

Experience Summary

To serve the organization to the best of my ability and to contribute successfully to the overall development of the organization.

An effective communicator, coordinator with excellent verbal, written, documentation, presentation, and organizational skills to build the customer/client relationships.

Capable of challenging, motivating and friendly environment.

Owned the application production support with 5+ years of experience in IT industry.

Experience with applications in Banking and Financial Services.

Experience in PL/SQL Collections, Bulk Collect .

Data loading to database through SQL Loader &loading and unloading from database.

Proficient in creation/modification of database objects like Procedures, Functions and Packages using SQL and PL/SQL.

Creation/modification of database objects like Tables, Packages, Procedures, Functions, Views, and Sequences.

Expertise in Cursors, Exception handling .

Experience in performance tuning.

Ability to be an effective team player and work under time constraints.

Skills Summary

Programming Languages : SQL, PL/SQL, and UNIX.

Database : Oracle RDBMS (10g,11g)

Database Administration Tools : SQL Developer

Operating system : Windows XP, 7, 10, UNIX.

Work Experience

Working as a Software Engineer in Terrain InfoTech from April 2014 till date

+Education

Year

College/ University

B.TECH

2014

THIRUVALLUVAR COLLEGE OF ENGINERRING AND TECHNOLOGY

Class XII

2010

GOVT GIRLS HIGHER SECONDARY SCHOOL

Class X

2008

GOVT SECONDARY SCHOOL

Education:

Project engagement

1. TITLE: EDR 1.0

Client : EDEKA

Role : Program Developer with team size of 5

Technology : Java, Oracle 10g, UNIX, QC tool.

Duration :july 2014 to oct 2015

Description:

The Edeka Group is the largest German supermarket corporation, currently holding a market share of 26%. Founded in 1898, it consists today of several cooperatives of independent supermarkets all operating under the umbrella organization Edeka Zentrale AG & Co KG, with headquarters in Hamburg. There are approximately 4,100 stores with the Edeka nameplate that range from small corner stores to hypermarkets.

Roles and Responsibilities:

Developed Stored Procedures, Functions, Packages and SQL Scripts using PL/SQL.

Loaded the data into database tables using SQL*loader from text and excel files.

Developed data model, SQL Queries, SQL Query tuning process and Schemas.

Created SQL*plus reports as per client's various needs, and developed business objects.

Developed SQL scripts for Referential Integrity check, which checks validity of incoming data with master tables in database.

Developed SQL and PL/SQL scripts to transfer tables across the schemas and databases.

Involved in implementing the data integrity validation checks through constraints and triggers.

Writing SQL reports and scheduling these reports from UNIX scripts.

Created SQL*Loader control files for moving the data from flat files to staging area tables.

Worked on performance issues and used EXPLAIN PLAN for tuning the queries.

Developed code with discussion from Front end users.

2. TITLE: BOA-431

client : Bank of Aland

Role : Program Developer

Technology : Java, Oracle 10g, UNIX, QC tool.

Duration : oct 2015to till date

Description:

Bank of Aland is a Finnish commercial bank and banking group with over 700 employees and operations in Aland, Finland and Sweden. The bank was founded in 1919 and was listed on the stock exchange in 1942. Its president and CEO is Peter Wiklof. Bank of Aland has 300 branch offices across Finland and Sweden. In Finland, Bank of Aland is a full service bank focused on private banking and premium banking. The Swedish branch, Aland banking Service, has private banking and asset management as its main business areas.

Roles and Responsibilities:

Writing SQL reports and scheduling these reports from UNIX scripts.

Worked on performance issues and used EXPLAIN PLAN for tuning the queries.

Developed Stored Procedures, Functions, Packages and SQL Scripts using PL/SQL.

Created SQL*plus reports as per client's various needs, and developed business objects.

Developed SQL scripts for Referential Integrity check, which checks validity of incoming data with master tables in database.

Developed code with discussion from Front end users.

Developed data model, SQL Queries, SQL Query tuning process and Schemas.

Developed SQL and PL/SQL scripts to transfer tables across the schemas and databases.

Created SQL*Loader control files for moving the data from flat files to staging area tables.

Loaded the data into database tables using SQL*loader from text and excel files.

Developed SQL scripts for Referential Integrity check, which checks validity of incoming data with master tables in database.

Involved in implementing the data integrity validation checks through constraints and triggers.

Personal Profile

Fathers Name : A.RAVANAN

Date of Birth : 05-6-1993

Nationality : Indian

Marital Status : Married

Languages : English, Tamil, Telugu

Declaration

I hereby declare that the details furnished above are true to the best of my knowledge.

R.Renugambal

Contact this candidate