| 20,000+ Fresh Resumes Monthly | |
|
|
| | Click here or scroll down to respond to this candidate Candidate's Name Valliappan
O racle PL/SQL Developer
EMAIL AVAILABLE PHONE NUMBER AVAILABLE
Summary
Over 7+ years of programming experience as an Oracle PL/SQL Developer
in Analysis, Design and Implementation of Business Applications using the
Oracle Relational Database Management System (RDBMS).
Involved in leading software development on software projects from
conception through implementation, execution and maintenance with
timely delivery against aggressive deadlines.
Efficiently worked and deployed distinct Client-Server applications using
Oracle 12c/11g/10g PL/SQL, iSQLPLUS, SQL *PLUS, TOAD and
SQL*LOADER
Proficient in writing PL/SQL Stored Procedures, Functions, Cursors,
Triggers and Packages
Created Tables, Views, Constraints
Created Shell Scripts for invoking SQL scripts
Have automated many jobs using unix crontab in unix
Have used Autosys as automated job control system for scheduling,
monitoring and reporting jobs.
Strong skill set in using Oracle utilities like iSQLPLUS, SQL*PLUS,
SQL*Loader, TOAD.
Loaded Data into Oracle Tables using SQL Loader.
Expertise in complex SQL queries including inline queries and subqueries
for faster data retrieval from multiple tables.
Partitioned large Tables using range partition technique.
Tuned SQL queries to improve performance.
Good knowledge on SQL Performance tuning using Cost-Based
Optimization (CBO) and Exception handling.
Good experience in Oracle performance related features such as Query
Optimizer, Execution Plans and Indexes.
Experience in using Bulk collect, and Bulk binds
Troubleshoot and debug system and/or data errors.
Uncommon determination to learn and ability to learn fast
Technical Skills
Database:
Oracle 10g/11g/12c (SQL, PL/SQL)
Operating System:
UNIX, Windows NT/2000, and Windows XP
Programming Languages:
C, C++, Perl, Python, PL/SQL, Shell Scripting (sh/ksh/csh)
RDBMS:
ORACLE
Markup Languages:
XML, HTML, XHTML
Utilities:
SQL*PLUS, iSQLPLUS, SQL*Loader, and TOAD
Education
Bachelor of Engineering in Electrical and Electronics
Work Experience
Client: AT&T, Alpharetta, GA
Period: APR 2017 Present
Position: Oracle PL/SQL Developer
Responsibilities
Worked on data extraction and population process
Implemented solutions for data quality issues
Devloped database objects to facilitate consistent data entry into the
database
Created staging tables to load data files from source systems
Worked on views and Jsons to populate data to target tables
Worked on mappings before a table sits on database
Worked on new requirements as well as enhancements
Assisted testing team after the code has been moved from build stage
Involved in creation of various indexes on relational tables
Developed back end interfaces using packages and procedures
Worked on query optimization and performance tuning
Have done couple of performance tuning using collections, bind variables,
indexes, and partitioning
Used Tortoise SVN for version control
Translated business into technical requirements
Environment
Oracle 11g, DB Visualizer, Tortoise SVN, Windows XP
Client: JPMorgan Chase, Tampa, FL
Period: OCT 2016 APR 2017
Position: Oracle PL/SQL Developer
Responsibilities
Worked on risk and fraud control applications
Followed agile methodology, a fast paced working environment and made
releases every 2 weeks
Used toad 12.1 as oracle database tool
Created SCR (Software change request) to meet the business requirements
Worked on oracle 11g
Have used bulk data loading utilities like sql loader nad external tables
Have done export / import schemas and tables
Used oracle hints like index, no index and parallel
Have run queries in parallel to improve performance
Worked on JavaScipt and AngularJS to support internal error report portal
Worked on large database having trillions of records
Have done couple of performance tuning using collections, bind variables,
indexes, and partitioning
Used GIT for version control to checkin and checkout code and to run
scripts to make changes in database objects
Once the development and unit testing is done, rolled it to integration
environments and finally to prod
Supported the issues raise in QA and redelivered the patch on time
Environment
Oracle 11g, TOAD, GIT, SQL Developer, Windows XP
Client: Comerica Bank, Auburn Hills, MI
Period: April 2014 June 2016
Position: Oracle PL/SQL Developer
Responsibilities
Worked on a banking application that involves lots of transaction,
Financial information and lot other details in Oracle database
Using Shell scripting and Oracle as database worked on database
development and maintenance project
Wrote tuned SQL queries to fetch huge number of data without any time
delay and processed it as required
Created database objects like procedures, functions, triggers, views to
accommodate the new functionality as per the client requests
Extensively Worked on Packages, Procedures, Functions, Views, cursors,
ref cursors, table functions and Triggers in Oracle PL/SQL 12c/11g
Changed database objects without affecting the other modules which
depend on it and have done the regression testing, if required
Used SQL*LOADER to load data into database from flat files
Worked with high volume data and Performance Tuning using various
types of Hints, Partitioning and Indexes
Have automated data loading in database from various format flat files by
creating unix shell scripts
Extensively used global temporary tables and ref cursors to store and
process data
Actively involved in creating indexes and partitions on tables for
Optimization and Tuning for enabling maximum database efficiency
Created functions for complex data parsing of multiple input parameters in
Oracle
Used Autosys JIL (Job information Language) to create jobs.
Created new documents as well as maintained and updated the existing
documents of the project
Environment
Oracle 12c, 11g, SQL * Plus, iSQLPLUS, TOAD, SQL*Loader, SQL
Developer, Shell Scripts, UNIX, Windows XP
Client: Flagstar Bank, Troy, MI
Period: September 2011 January 2014
Position: Oracle PL/SQL Developer
Responsibilities
Involved in various phases like Analysis, Detailed design, Development,
Maintenance, Testing and deployment
Created User Schemas, tables, indexes, sequences, and views.
Created and developed Oracle PL/SQL packages, stored procedures,
functions, and anonymous blocks
Involved in creating UNIX shell scripting.
Have done defragmentation of tables, partitioning, compressing and
indexes for improved performance and efficiency.
Involved in table redesigning with implementation of Partitions Table and
Partition Indexes to make Database Faster and easier to maintain.
Modified existing Code according to the requirements
Documented all modules for user level and system level maintenance
Performed complex scripting and querying in both the development,
testing as well as production environment
Worked on Data Transformations, Data Loading, Database Modeling and
Performance Tuning
Worked on troubleshooting defects in timely manner.
Resolved technical related issues and documented procedures
Environment
Oracle 10g/11g, PL/SQL, SQL*LOADER, SQL PLUS, TOAD, UNIX
Shell scripting, Windows XP
Client: AIG United Guaranty, Greensboro, NC
Period: January 2011 July 2011
Position: Oracle PL/SQL Developer
Responsibilities
Worked for a billing Application Maintenance Project on which
maintained and extended the application system for better performance
and efficiency
Created and reorganized all types of Oracle database objects including
tables, views, indexes, sequences, synonyms and setting proper
parameters and values for all the objects
Wrote Oracle database triggers, stored procedures, stored functions, and
stored packages to perform various automated tasks for better
performance
Created indexes on the tables for faster retrieval of the data to enhance
database performance.
Created Shell Scripts for invoking SQL scripts
Created and modified several UNIX shell scripts according to the
changing needs of the project.
Used different joins, sub-queries and nested queries in SQL query
Effectively made use of Table Functions, Indexes, Table Partitioning,
Analytical functions, and Materialized Views
Used the Cursor for Loop to fetch unconditional number of rows
Imported/Exported data from/to different databases using utilities like
SQL*Loader
Experience with Performance Tuning for Oracle RDBMS using Explain
Plan and HINTS.
Involved in the continuous enhancements and fixing of production
problems.
Verified and validated data using SQL queries
Analyzed and prepared High and low level designs
Made clear, maintainable, efficient and reusable codes
Environment
Oracle 10g/11g SQL, PL/SQL, UNIX, SQL*Loader, SQL Navigator,
TOAD, SQL DEVELOPER
Client: Mindtree Ltd, Bangalore, India
Period: September 2008 July 2010
Position: Programmer Analyst
Responsibilities
Programmed in Perl using Oracle as database on UNIX environment to
accomplish the requirements of the client
Have done production support with 24/7 uptime
Have done debugging, monitoring and support kind of work
Developed a mapping technique using Perl script that would take the SQL
data and generate the XML output file on the UNIX system
Created Tables, Views, Constraints
Developed Complex database objects like Stored Procedures, Functions,
Packages and Triggers using SQL and PL/SQL.
Created High level and Low level design documents to make
enhancements in the existing database and on Unix server
Responsible for gathering requirements
Used Oracle utilities like SQL*Loader, TOAD, SQL*Navigator
Created scripts to create new tables, views, queries for new enhancement
in the application using TOAD.
Loaded Data into Oracle Tables using SQL Loader.
Partitioned large Tables using range partition technique
Worked on CRs(Change requests) as equal as the new requirements
Written bug free code to the possible extent and tested by self to avoid the
bug elevation to the testing environment
Identified the problem and fixed it, when something went wrong in
production environmrent
Handled errors using Exception Handling extensively for the ease of
debugging and displaying the error messages in the application.
Had inter team and client interactions and discussions before the start of
any work to avoid the miscommunication and to get the work neatly
done.
Environment
UNIX, SQL*Loader, TOAD, SQL*Navigator, Oracle 9i/10g database,
Shell scripting, Perl, XML
|