Junior Oracle PL/SQL developer

JAYAKUMAR, M

*** ************ **

Piscataway, New Jersey

M: 660-***-**** Email: *********.*****@*****.***

OBJECTIVE

Seeking a position, where I can utilize my database programming skills, abilities and experience, for constituting

effectively growth of organization, and me as well.

SUMMARY

• Having 3 Years of expertise on Oracle PL/SQL with involvement at various levels of design, coding, and

testing phases of implementation.

• Worked as Process Engineer for TECHINFO SOLUTIONS, India for 1year.

• Worked as Process Associate at AXIS Bank, India for 1year and two months.

• Experience on database programming using SQL and PL/SQL with implementation of business

applications using the Oracle Relational Database Management System(RDBMS).

• Generated reports, created Tables, Synonyms, Sequences and Views using oracle Apex, based

on the requirements of the assigned project and used SQL LOADER for data migration.

• Expert in creating indexed Views, complex Stored Procedures, effective functions, and

appropriate Triggers to facilitate efficient data manipulation and data consistency.

• Experience in query optimization, performance and tuning (PL/SQL) using SQL

Trace, Table partitioning, Hints, Bulk Collect, Data Blocks, LOVs, Parameters.

• Strong knowledge in development of Oracle APEX applications with involvement at Coding,

testing and documentation phases of the project.

• Strong development skills in Oracle forms/reports 10g application development using Database

Packages, Stored Procedures/Functions.

• Excellent conceptual knowledge of Oracle 9i/10g/11g, UNIX, Data Warehouse Concepts,

ETL, Data Modeling, experience using Normalization and Dimensional Modeling.

• Experience in understanding ASP.Net and Java applications, and their performance issues from

end users and worked with DBA’s to suggest valuable ways to fix the problem

• Good interpersonal and communication skills, commitment, result oriented, smart working with a

quest and zeal to learn new technologies and undertake challenging tasks.

TECHNICAL APPLICATIONS

• RDBMS : Oracle 11g/10g/9i, MS Access

• GUI’S : Oracle Forms 10g, SQL developer

• LANGUAGES: SQL, PL/SQL, C, HTML, XML

ACADEMIC PROFILE

• Completed master’s degree in Computer Information Systems at University of Central

Missouri, MO, with a GPA of 3.77 in Dec 2014.

• Completed Bachelor’s in Computer Science Engineering from Jawaharlal Nehru Technological

University, Hyderabad, India with a 66.72% in May 2009.

EMPLOYMENT DETAILS

Company: Haveltech Software solutions

Client: UNION BANK, INDIA

Role: Oracle SQL Developer

Project: Employee Fraud Detection Warehouse for IROD.

Duration: SEP 12–AUG 2013

The purpose of this project is to build an enterprise data warehouse (EFDW) to facilitate the investigation

of employee activity as it may relate to fraud (IROD). The data warehouse will facilitate the analysis of

data in the areas of employees, customers, accounts, locations and time. The data from these source

systems will be scrubbed, normalized and organized into data structures star schema, dimensions,

aggregate tables suited to analysis by data mining tools.

Responsibilities:

• Collaborated with the Business analysts and the DBA for requirements gathering, business

analysis, testing and project coordination.

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

• Involved in creation of Conceptual Modeling covering all the business requirements.

• Created process force and deployed into run time depository using ware house builder

• Involved in logical modeling and physical modeling of application.

• Developed SQL scripts, packages and procedures for Business rules check to implement business

rules.

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

• 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.

•.

• Data loaded from legacy systems using PL/SQL and SQL*Loader.

• Used UTI_FILE PACKAGES for writing DBMS_OUTPUT messages to file.

Environment: Oracle 11g /10g/9i, SQL, PL/SQL, SQL*Loader, MS Access, Windows XP/2000

Client: GS Auto International Ltd, INDIA

Role: Associate Software Engineer

Duration : June 2011 to Aug 2012

The purpose of this project is to provide the Service Managers and support users the ability to view

details of Menu and Dashboard penetration as well as repair order counts and revenue amounts for their

given dealership. This project also allows user to compare their dealership’s performance in comparison

to their given nation, region, zone and district.

Responsibilities:

• Involved in the Analysis, Design, Coding and Testing of the application.

• Created PL/SQL stored procedures, functions and packages for moving the data from staging area

to data mart.

• Involved in logical and physical database design, Identified Fact Tables, Transaction Tables.

• Proactively tuned SQL queries and performed refinement of the database design to leading

significant improvement of system response time and efficiency.

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

• Developed SQL scripts to create database objects like tables, views and sequences.

• Used SQL*Loader to load bulk data from various flat files.

• Structured and optimized code in stored procedures, triggers and MS Access for processing data.

• Help the various testing teams by tracking the order details through databases, SAP and Idocs that

are created.

Environment: Oracle 10g, SQL, PLSQL, SQL*Loader, Oracle Forms 10g, Reports10g.

Client: CMC

Role: Associate Software Engineer

Duration : Jan 2011 to Jun 2011

• Developed SQL and PL/ SQL scripts for migration of data between databases.

• Developed complex triggers in reports before/after for validation of user input.

• Designed and developed user interfaces using Oracle Forms 10g.

• Used Toad for creating PL/SQL (trigger, sequence, stored procedure).

• Developed SQL scripts for Referential Integrity check, which checks validity of incoming data

with master tables in database

Worked as a Process Engineer at TECHINFO SOLUTIONS, India from August 2010 to Jan 2011.

Job Activities:

• Monitors and responds to hardware and software problems utilizing a variety of hardware and software testing

tools and techniques.

• Installing hardware and software systems at the various customer locations.

• Maintaining or repairing equipment.

• Troubleshooting a variety of computer issues.

• Maintenance of lab infrastructure.

Worked as Process Associate, back end operations with Trade Department of Axis Bank Ltd. NPC II,

Hyderabad, on behalf of M/s Synergy Relationship Management Services Private Limited from June 2009

to Aug 2010.

• Banking application: Finacle.10.2 and Intellect.

Job Activities:

• Processing of Import and export bills, remittance, demand drafts.

EXTRA CURRICULAR ACTIVITIES

• Volunteered at Show Me Justice Film Festival (SMJFF) 2014 at UCM, Warrensburg duringApril 10-12, 2014.

• Actively Volunteered at ISO Culture Night Festival at UCM on March 8th2014.

• Participated in Section Student Congress IEEE, Hyderabad Section held on August 11-12, 2007 held at

Mekaster, IETE Hyderabad.

• Was awarded with certificates of appreciation for organizing andvolunteering blood donation camp at under-

graduate college campus by Lion’s Club for MGM hospital at Warangal, India.

• Represented my college cricket team in various tournaments and was awarded with many certificates.

• Organized various social cultural activities at college campus.

Contact this candidate