Sql Oracle
Resume:
ashish Oracle Apps Developer
Phone: 409-***-****
: ******.**********@*****.***
Resumes ID: 49157
Location:, Michigan
Posted: 05.02.2012
Resume Details:
ASHISH
Email: ******.**********@*****.***
Ph.: 409-***-****
Summary:
Over 8 years of IT experience as an Oracle PL/SQL developer with expertise in exhaustive analysis and development of PL/SQL stored procedures, functions, packages and triggers.
Extensive Programming experience in designing reports using Reports 10g/9i/6i, Discoverer 10g/4i, XML Publisherand designed user interfaces with Forms 10g/9i/6i.
Extensive working experience in database objects like creating tables, views, indexes, sequences, primary key, foreign keys and constraints
Well versed in using Views, Materialized view, Synonyms, Indexes, Joins, Sub-queries, Merge statement, Ref cursor, Table Partitioning, Global Temporary Table.
Extensively used Cursors, Ref Cursors, System Ref. Cursor, Exceptions and Anonymous blocks for generating reports
Experienced with usage of SQL*Loader through shell scripts as well as independently
Experienced in environments such as SQL*Plus, TOAD and SQL*Developer
Experience in Performance Tuning,Optimization using HINTS, EXPLAIN PLAN, TKProf, DBMS_PROFILER.
Experienced with the ETL process of moving the data from the source systems to the data warehouse using external table, staging table.
Good experience in UNIX Shell Scripting.
Strong understanding of the DataWarehouse, Data model and RDBMS concepts.
Excellent communication and interpersonal skills with the ability to manage responsibilities individually or as part of a team
Demonstrated high learning ability with regard to new skills such as programming languages and application tools/software.
Technical Skills:
Operating Systems
Windows 98/NT/2000/XP/2003, MS-DOS, UNIX
Languages
SQL, PL/SQL, Shell Scripting, XML, Delphi, C, C #, HTML
RDBMS
Oracle 9i/10g/11g, MS Access
GUI
Oracle Forms 6i/9i/10g, Oracle Reports 6i/9i/10g, Crystal Report, XML Publisher
Utilities
Toad, SQL*Plus, SQL*Loader, Tkprof, PUTTY, MS Office, WinSCP, SQL Developer
General Motors Warren, MI Nov 11 – Till date
Oracle PL/SQL Developer
Responsibilities:
Designed, developed and tested software using Agile Methodology.
Involved in daily stand up meeting and weekly demo for each sprint.
Worked in development, testing and production environment using packages, stored procedures, functions.
Developed application and database triggers, functions, procedures, and packages in PL/SQL, Oracle11g as back-end.
Created database objects like tables, views, procedures, packages using Oracle tools like SQL Developer.
Created various SQL and PL/SQL scripts for verification of the required functionalities.
Created Records, Tables, Objects, Collections (Nested Tables and Varrays), Table Partitioning and Error Handling.
Worked on optimizing existing procedures and functions using PL/SQL.
Worked on Dynamic SQL and PL/SQL block in PL/SQL.
Worked on modifying various existing packages, procedures, functions and triggers according to the new business needs.
Used merge statement, Global Temporary table extensively.
Developed triggers and packages to delete stored session data from various tables.
Used SQL Loader, external tables to load data.
Created, modified and tested SQL scripts.
Wrote various kinds of SQL queries involving Correlated Sub queries, UNION, Inner and Outer Joins
Involved in Performance Tuning.
Developed UNIX Shell Scripts to execute procedures and publish the files.
Have converted old data from Flat files to Oracle database Using SQL * Loader
Environment: SQL, PL/SQL, Oracle 11g, SQL*Plus, SQL*Loader, Tkprof, PUTTY, Unix Shell Scripting (ksh), VB.NET, Java, MS Office, Windows
Dollar General, Goodlettsville, TN Aug 11 – Nov 11
Oracle PL/SQL Developer
Responsibilities:
Analyzed the specification to suggest the right solutions based on client requirements
Worked in development, testing and production environment using SQL, PL/SQL procedure, shell script.
Developed application and database triggers, functions, procedures, and packages in PL/SQL, Oracle11g as back-end.
Creation of database objects like tables, views, procedures, packages using Oracle tools like SQL* Plus and Toad.
Created various SQL and PL/SQL scripts for verification of the required functionalities.
Created Records, Tables, Objects, Collections (Nested Tables and Varrays), and Error Handling.
Worked on optimizing existing procedures and functions using PL/SQL.
Worked on Dynamic SQL and PL/SQL block in PL/SQL.
Worked on modifying various existing packages, procedures, functions and triggers according to the new business needs.
Developed triggers and packages to delete stored session data from various tables.
Used SQL Loader and wrote control file scripts to load data from flat files to Oracle tables.
Used merge statement, Global Temporary table extensively.
Worked on SQL tuning using hints, explain plan, Tkprof
Created, modified and tested SQL scripts.
Wrote various kinds of SQL queries involving Correlated Sub queries, UNION, Inner and Outer Joins
Involved in Performance Tuning.
Developed UNIX Shell Scripts to execute procedures and publish the files.
Environment: SQL, PL/SQL, Unix Shell Scripting (ksh), Oracle 11g, SQL*Plus, SQL*Loader, Tkprof, PUTTY, Java, MS Office, Windows XP
Well Care, Tampa, FL Apr 11 – July 11
Oracle PL/SQL Developer
Responsibilities:
Worked with various functional experts to implement their functional knowledge into working procedures.
Developed application and database triggers, functions, procedures, and packages in PL/SQL, Oracle11g as back-end.
Creation of database objects like tables, views, procedures, packages using Oracle tools like SQL* Plus and PL/SQL Developer.
Created various SQL and PL/SQL scripts for verification of the required functionalities.
Created Records, Tables, Objects, Collections (Nested Tables and Varrays), and Error Handling.
Worked on Dynamic SQL and PL/SQL block in PL/SQL.
Worked on SQL tuning using hints, explain plan, Tkprof.
Created, modified and tested SQL scripts.
Wrote various kinds of SQL queries involving Correlated Sub queries, UNION, Inner and Outer Joins
Involved in Performance Tuning.
Have converted old data from Flat files to Oracle database Using SQL * Loader
Wrote various kinds of SQL queries involving Correlated Sub queries, UNION and Inner & Outer Joins
Developed UNIX Shell Scripts and PLSQL procedures to import and export data.
Environment: SQL, PL/SQL, Unix Shell Scripting, Oracle 11g, SQL*Plus, SQL*Loader, Tkprof, PUTTY, Crystal Report, MS Office, Windows XP
Merchant One, Inc., Miami Beach, Florida Mar 10 – Mar 11
Oracle PL/SQL Developer
Responsibilities:
Interacting with the Business Users and Project Management for analyzing the business needs and develop Design Specification.
Developed DDL Scripts for generating Tables, Views, and Functions etc.
Added/Changed Tables, columns and triggers.
Developed Views, PL/SQL procedures, functions, packages and Triggers.
Strong analytical ability and experience in developing, testing and troubleshooting SQL Queries.
Developed reports and modified the existing SQL reports using Reports 10g.
Customize the reports using XML Publisher.
Developed screens and reports using Oracle Forms 10g/Reports 10g.
Helped the front end application developers with their queries using Forms 10g.
Created Indexes to speed up the queries.
Creation of Stored Procedures for Batch Processing.
Skills and experience in a very-large-database environment
Involved in Debugging troubleshooting Procedures, functions, packages, customizing the existing ones.
Involved in debugging oracle problems like log files, process identification.
Involved in Performance tuning using hints, explain plan, tkprof, dbms_profiler.
Developed SQL Loader scripts.
Oracle-to-Oracle data loading using UNIX shell scripts and PL/SQL.
Reporting on a weekly basis to the project manager.
Environment:SQL, PL/SQL, Unix Shell Scripting, Oracle 11g, Toad, SQL*Plus, SQL*Loader, Tkprof, PUTTY, MS Office, Win SCP, Microsoft Visio 2003, Windows 2000/XP, Oracle Forms 10g, Oracle Reports 10g, XML Publisher, SQL Developer
Action for Results, Inc., Andover, MA Mar 09 – Feb 10
Oracle PL/SQL Developer
Responsibilities:
Worked with various functional experts to implement their functional knowledge into working procedures.
Developed application and database triggers, functions, procedures, and packages in PL/SQL, Oracle10g as back-end.
Creation of database objects like tables, views, procedures, packages using Oracle tools like SQL Loader, SQL* Plus and PL/SQL.
Created various SQL and PL/SQL scripts for verification of the required functionalities.
Created Records, Tables, Objects, Collections (Nested Tables and Varrays), Table Partitioning and Error Handling.
Worked on optimizing existing procedures and functions using PL/SQL.
Worked on User Exit, Dynamic SQL and PL/SQL block in PL/SQL.
Created various Database triggers using PL/SQL.
Involved in Performance Tuning.
Have converted old data from Flat files to Oracle database Using SQL * Loader
Developed screens and reports using Oracle Forms 10g/Reports 10g
Designed and developed user interfaces for customers using Oracle 9i/10g Forms Builder.
Wrote various kinds of SQL queries involving Correlated Sub queries, UNION, Inner and Outer Joins
Developed UNIX Shell Scripts and PLSQL procedures to import and export data.
Environment: SQL, PL/SQL, Unix Shell Scripting, Oracle 10g, Toad, SQL*Plus, SQL*Loader, Tkprof, PUTTY, MS Office, Windows XP, Oracle Reports 10g, Oracle Forms 10g
Cox Communications Inc., Atlanta, Apr 07 - Feb 09
Oracle PL/SQL Developer
Responsibilities:
Analyzed the Business requirements of the project by studying the Business Requirement Specification document.
Interact with business analysts to develop modeling techniques
Involved in database development by creating Oracle PL/SQL Functions, Procedures, Triggers, Packages, Records and Collections.
Run batch jobs for loading database tables from Flat Files using SQL*Loader.
Designed and implemented the interfaces for Sales Order information from legacy system to staging tables using SQL loader and wrote various procedures and function to perform validations to populate the data in the tables.
Customized and developed Oracle Forms and Reports using Oracle Forms 6i and Reports 6i.
Created Records, Tables, Objects, Collections (Nested Tables) and Error Handling.
Created number of database Triggers using PL/SQL.
Involved in Performance Tuning.
Creation of database objects like Tables, Views, Procedures, Packages using Oracle tools like PL/SQL, SQL*Plus, SQL*Loader.
Developed ad hoc reports using Discoverer 4i.
Created business area, new custom folders, complex folders, summary folder, hierarchies, and item classes and list of values using Discoverer 4i.
Environment: Oracle 9i/10g, SQL, PL/SQL, Discoverer 4i, Oracle Forms 9i/6i, Reports 9i/6i, TOAD, SQL*Plus, UNIX
Bharat Heavy Electricals Ltd. (BHEL), Ind Aug 05- Feb 07
Oracle PL/SQL Developer
Responsibilities:
Analyzed the Business requirements of the project by studying the Business Requirement Specification document.
Prepared program specifications for PL/SQL Procedures and Functions to do the data migration and conversion.
Worked with wide range of data types, tables, index types and scoped variables.
Creation of database objects like Tables, Views, Packages using Oracle tools like PL/SQL, SQL* Plus, SQL*Loader.
Designed the front end interface for the users, using Forms 6i
Involved in database development by creating Oracle PL/SQL Functions, Procedures, Triggers, Packages and Records.
Run batch jobs for loading database tables from Flat Files using SQL*Loader.
Developed necessary reports using Reports 6i.
Created number of database Triggers using PL/SQL.
Implemented project at client place.
Environment: Oracle 9i, Oracle Forms 6i, Reports 6i, SQL Loader, UNIX, Putty, Toad, SQL*LOADER
Wockhardt Ltd., India May 04 - Jun 05
Oracle PL/SQL Developer
Responsibilities:
Involved in the design and implementation of the process for loading data.
Used Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
Developed SQL queries, Triggers, Cursors and Advanced Database Objects using PL/SQL
Writing code for stored procedures, functions according to the requirements.
Performed good knowledge in the usage of Views, Synonyms, Indexes, JOINS and Sub-Queries.
Dealt with defining of custom applications, tables, forms, reports and customizing existing reports
Used Cursors, Ref Cursors, Cursor expressions & Exceptions extensively in coding.
Environment: Oracle 9i, SQL*Plus, PL/SQL, Oracle SQL*Loader, Oracle forms 6i, Reports 6i, UNIX, Putty
Contact this candidate