SUMMARY:

• Proficient in Oracle 8i/9i/10g/11g/12c, PL/SQL, SQL and ability to work with UNIX shell scripting.
• Proficient in PL/SQL programming - Creating stored procedures, functions, triggers, packages, cursors, ref cursors, collections and user defined types.
• Extensively used PL/SQL, Built in Oracle Packages, stored procedures, functions, triggers, cursors, Ref Cursors.
• Worked with Oracle Analytical Functions, Aggregate functions, Exception Handling, Materialized views and views for processing data, enforcing referential integrity and needed business rules.
• Experience in Data Migration, SQL Loader.
• Expertise in Creating SQL Loader Scripts to load data from flat files into database and exporting data to flat files using external tables.
• Good exposure in tuning of procedures, packages, SQL.
• Expertise in performance Tuning- Tuning of SQL queries and complex procedures to improve performance & decrease response time utilizing Explain Plan, Hints and Index.
• Good understanding of normalization and de-normalization concepts of oracle.
• Experience on Oracle Total Recall
• Hands on experience on Data Modelling
• Good knowledge of database tools like SQL Developer, SQL Developer Data Modeler, TOAD etc.
• Good experience in job control tool like Autosys
• Good experience on Core Java, JSP/Servlets and HTML.
• Goods experience on Product Development using Agile methodologies
• Involved in all the stages of Software Development Life Cycle (Waterfall, V Model and Agile)
• Excellent analytical and problem solving skills and can work independently.
• Excellent Communication skills and responsible team player.
• Quick learner with ability to master new concepts and applications.

TECHNICAL SKILLS:

Operating Systems: Windows XP/ Windows 7, Linux Red Hat, IBM AIX, HP-UX, Solaris 10

Programming languages: Oracle PLSQL, SQL, Core Java

Script Languages: UNIX shell scripting

Tools: /Software products: SQL Developer, TOAD, SQL Developer Data Modeler, Eclipse, Tortoise SVN, Borland Star Team, Borland Caliber, HP Quality Center, PUTTY, MoBaXterm, WinSCP, MS Office 2003/2013

Database: Oracle 12c, 11g, 10g, 9i, 8i

Web Technologies: HTML, JSP/Servlets, Core Java

WORK EXPERIENCE:

Confidential

PL/SQL Developer

Responsibilities:

• Created High Level design documents.
• Created complex PL/SQL packages, procedures, triggers and functions to meet the business requirements.
• Used SQL Loader to load feed files.
• Created partitioning on large tables.
• Performance improvements by tuning PL/SQL code and SQL using the tools like explain plan.
• Data Modelling using SQL Developer Data Modeler
• Experience on Oracle Total Recall
• Used Autosys as a Job Control tool.
• Unix Shell scripting.
• Used advances oracle concepts of analytical and aggregate functions.
• Test case preparation, regression and integration testing.
• Deployment support

Tools: & Programming Languages:PL/SQL, SQL, Oracle 12c, PUTTY, MobaXterm, UNIX shell scripting, Tortoise SVN, SQL Developer, SQL Developer Data Modeler, Eclipse, Autosys

Confidential

Oracle PL/SQL & Java Developer

Responsibilities:

• Creating design documentation, process flow diagrams.
• Create complex PL/SQL packages, procedures, triggers and functions to meet the business requirements.
• Create DBMS SCHEDULER jobs
• Data Modelling using MS Visio
• Creation of Views and Materialized Views
• Design and development of web pages using HTML, JSPs/Servlets and JavaScript.
• Unix Shell Scripting.
• Used SQL Loader to load feed files.
• Test case preparation, regression and integration testing.
• Deployment support

Tools: & Programming Languages:PL/SQL, SQL, Oracle 11g, SQL Developer, Unix Shell scripting, Core Java, JSP/Servlet, Java Scripting, PUTTY, WinSCP

Confidential

Oracle PL/SQL developer

Responsibilities:

• Created Technical Analysis Design document.
• Create complex PL/SQL packages, procedures, triggers and functions to meet the business requirements.
• Design and develop web pages using HTML and JSP/Servlets.
• Integrate the workflows and the database code.
• Test case preparation, regression and integration testing.
• Deployment support

Tools: & Programming Languages:PL/SQL, SQL, Oracle 11g, SQL Developer, Core Java, JSP/Servlet, Eclipse, WinSCP

Confidential

Oracle PL/SQL developer

Responsibilities:

• Created Technical Analysis Design document.
• Migrate legacy data using SQL loader
• Create complex PL/SQL packages, procedures and functions to meet the business requirements.
• Create cron jobs to execute shell scripts
• Test case preparation, regression and integration testing.
• Deployment support

Tools: & Programming Languages:PL/SQL, SQL, Oracle 11g, SQL Developer, Unix Shell scripting, PUTTY

Confidential

Oracle PL/SQL and Java Developer

Responsibilities:

• Design documentation
• Load data using SQL loader
• Create complex PL/SQL packages, procedures, triggers and functions to meet the business rules.
• Used PL/SQL Collections and bulk collections.
• Unix Shell scripting to execute database packaged procedures
• Schedule job using Autosys
• Design and develop web pages using HTML and JSPs/Servlets.
• Test case preparation, regression and integration testing.
• Deployment support

Tools: & Programming Languages:PL/SQL, SQL, Oracle 10g, Toad, Borland Caliber, Borland Star Team, Eclipse

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Create design documentation for the process.
• Create complex PL/SQL packages, procedures, triggers and functions to meet the business rules.
• Create tables, views, indexes and synonyms.
• Test case preparation, regression and integration testing.
• Deployment support

Tools: & Programming Languages:PL/SQL, SQL, Oracle 10g, PL/SQL Developer, Unix Shell scripting, MS Visual Source Safe 6.0, MS Visio

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Create low level design documentation for the requirements.
• Used SQL Loader to load feed files.
• Involved in Data Migration
• Create complex PL/SQL packages, procedures, triggers and functions to meet the business rules.
• Create tables, views, indexes and synonyms.
• Unix Shell scripting.
• Test case preparation, regression and integration testing.
• Deployment support

Tools: & Programming Languages:PL/SQL, SQL, Oracle 9i, PL/SQL Developer, UNIX Shell scripting, PUTTY, WinSCP

Confidential

Oracle PL/SQL and Java Developer

Responsibilities:

• Create design documentation for the processes.
• Involved in Data loading and formatting it back to Mainframe understandable format.
• Used Loader to load csv and pipe delimited files.
• Create complex packages, procedures, triggers and functions to meet the business rules.
• Unix Shell scripting.
• Coding in Core Java.
• Test case preparation, regression and integration testing.
• Deployment support

Tools: & Programming Languages:PL/SQL, SQL, Unix Shell Scripting, Core Java, PUTTY, Eclipse