PROFESSIONAL SUMMARY:

• Around Five years of programming knowledge as an Oracle PL/SQL Developer in Analysis, Design, Data Modeling (Logical and Physical), and Development of customer/server and multi - layered applications utilizing the Oracle Relational Database Management System(RDBMS), SQL, and PL/SQL on various stages like Windows NT/2000/XP, UNIX and Linux.
• Great experience of Performance Analysis and SQL inquiry tuning, while at the same time planning adaptable applications starting with no outside help and keeping up existing ones, utilizing Query Optimizer, Indexes, Execution Plans, Hints, Explain Plan, And Tk-prof.
• Experience in directing Requirement and Systems Analysis, Feasibility Studies, Design Reviews, Plan Reviews, Implementation, and Post Implementation studies. Exceptionally talented in Design, Development, Implementation, and Testing of business applications, Unit and System testing on the database.
• Oracle E-Business Suite (EBS) R12 Development and support.
• Involved in Development and Supporting Oracle EBS Application. The basic modules related to this undertaking are OM, INV, PO, and iStore.
• Proficient in PL/SQL programming - Stored Procedures, Functions, Packages, SQL tuning, and production of Oracle Objects - Tables, Views, Materialized Views, Triggers, Sequences, Synonyms, Database Links, and User Defined Data Types.
• Worked on successions, capacities, equivalent words, records, triggers, bundles, put away techniques, parts and allowing benefits on OLTP server.
• Experienced in Dynamic SQL, PL/SQL Collections, and Exception dealing with.
• Experience in cutting-edge PL/SQL ideas like Bulk gather, Multi Table embed, PL/SQL table, Cursors, Nested tables, V clusters, Records, Types and Dynamic SQL for DML activities for better execution.
• Proficient in Oracle 12c/11g/10g/9i/8i/7.3, PL/SQL backend applications advancement Toad, SQL Plus, and PL/SQL Developer.
• Experience with information stream outlines, information lexicon methods, Entity connection demonstrating and plan procedures, database standardization hypothesis.
• Expertise in Database Performance Tuning, Performance Monitoring and Optimization utilizing Oracle Hints, Explain designs, Tk-Prof and Table Partitioning.
• Experience in making SQL loader contents to stack information from level records into the database and furthermore making External Tables to oversee information which is store at the OS level.
• Develop numerous front-end applications utilizing APEX 4.2.
• Assist in outline and advancement of vast scale Perl applications and Created Perl contents utilizing DBI/DBD for information extraction
• Developed and planned dynamic arrangement wrapper in Perl to produce level store reports
• Worked on Oracle Forms 11g/10g/9i/6iReports 11g/10g/9i/6i.
• Well-versed in various phases of Software Development Life Cycle (SDLC).
• Extensively utilized PL/SQL to manufacture Oracle Reports 11g/10g and sees for preparing information, upholding referential respectability and required business rules.
• Experienced in Tuning Queries for better execution with a vast volume of information. Broad involvement in creating applications utilizing Oracle Forms/Reports. Involvement in every one of the variants of Forms/Reports.
• Excellent scientific, critical thinking, correspondence and relational abilities to oversee and interface with people at all levels. Ready to associate adequately with different individuals from the Business Engineering, Quality Assurance and different groups engaged in the System Development Lifecycle.
• Expertise in implementing ETL (extract, transform and load) by using Oracle Warehouse Builder (OWB).
• Experience in migration of source code using version control system (CVS, Arch, Visual source safe, svn, TFS).

TECHNICAL SKILLS:

Operating systems: UNIX, LINUX, Windows Vista/XP/2000/98, MS-DOS, MAC

Languages: SQL, PL/SQL, Unix Shell Scripts, JSP, C, C++, java, CSS, HTML, XML.

RDBMS: Oracle 12c/11g/10g/9i/8i, MS-SQL Server 2000/2005, Sybase, DB2, MS Access.

Oracle Utilities: SQL*Plus, SQL*Loader, SQL developer, TOAD.

GUI Tools: APEX 4.2,3.2, Oracle Forms 11g,10g,9i,6i and Reports 11g,10g,9i,6i, ERWIN, VISIO, Golden gate, Autosys, Control-M, JIRA and HP quality center, PAC 2000.

WORK EXPERIENCE:

Confidential

ORACLE PL/SQL DEVELOPER

Responsibilities:

• Worked as an Oracle Developer to give fundamental help to the customer for Database and Insurance Application. Additionally, offered help for essential level investigating (application issues)
• User interaction, requirement analysis, functional specification, design, development, and implementation.
• Involved in developing DB objects like tables, triggers, and Views.
• Involved in the development of Functions, Procedures, and Packages to transfer data into the database tables.
• Involved in formulating general methodologies, naming conventions and coding standards for various procedures and packages.
• Wrote SQL, PL/SQL, programs to retrieve data from the flat files
• Transferred data from flat files into the database tables using SQL* Loader.
• Extensively used IMPORT utility to load the exported files.
• Developed database objects including tables, clusters, Indexes, views, sequences, packages, triggers and procedures to troubleshoot any database problems.
• Used Explain Plan, HINTS, DBMS Profiler for performance tuning of SQL, Pl/SQL queries.
• Supported code push preparing change for new version release of application support to end jobs, also involve in Troubleshooting, fixed, and implemented bug fixes and enhancements within tight deadlines.
• Extensively used Cursors, User - defined Object types, Records, and Tables in PL/SQL Programming for generating worksheets.
• Create/maintain and modify complex database triggers and data migration scripts.
• Used SQL*LOADER to upload data into the tables.
• Data loaded from legacy systems (ETL Operations) using PL/SQL and SQL*Loader.
• Developed Procedures for efficient Error Handling process by capturing errors into user managed tables.
• Archived many applications in the existing system and retrieval of necessary data from them.
• Developed UNIX Shell scripts to automate table creation, execute procedures.
• Worked with Java developers to repair and enhance current base of PL/SQL packages to fix production issues and build new functionality and improve processing time through code optimizations and indexes.
• Used ORACLE SQL DEVELOPER for creating PL/SQL (trigger, sequence, stored procedure).

Environment: Oracle 12c/11g, SQL, PL/SQL, Oracle SQL developer, SQL navigator 7.2, Autosys, Oracle RDBMS, UNIX, Informatica Power Center, PAC2000.

Confidential

Oracle Developer

Responsibilities:

• Studied user requirements and functional specifications.
• Developed Entity Relationship diagrams/Dimensional Diagrams for business requirements
• Involved in designing ER diagram using VISIO, to set the logical and physical relationships of the database.
• Experience with Oracle partitioned tables and queries.
• High-Transaction environment experience.
• Loaded the data into database tables using SQL*loader from the text and excel files.
• Developed data model, SQL Coding, SQL Query tuning process, and Schemas.
• Developed SQL Scripts, Packages, and Procedures for Business rules check to implement business rules.
• Created scheduled and schedule now reports.
• Created SSISPackages to perform filtering operations and to import the data on daily basis from the OLTP system toSQLserver.
• Troubleshoot T-SQL, SSIS and SSRS errors and performance issues and address them as required
• Created Perl scripts usingDBI/DBDfor data extraction.
• Used variousCPAN Perl modulesto enhance the functionality
• Developed SQL and PL/SQL scripts to transfer tables across the schemas and databases.
• Developed Procedures for efficient Error Handling process by capturing errors into user managed tables.
• Using Swing Concepts in Java Front End Forms are designed.
• Developed and customized number of reports using Oracle Reports and Forms.
• Using Oracle JDeveloper Database tools to write triggers and procedures, Function.

Environment: OracleApplications (11i, R12), Oracle10g, SQL, PL/SQL, TOAD, UNIX, Formsand Reports 11g, MS Windows 7, VISIO, GOLDEN GATE, Informatica Power Center

Confidential

SQL Developer

Responsibilities:

• Developed Stored Procedures, Functions, Packages and SQL Scripts using PL/SQL.
• Developed data model, SQL Coding, SQL Query tuning process and Schemas.
• Migration of dbms jobs to control M.
• Scheduling jobs in control M and handling them.
• Created SQL*plus reports as per client's various needs, and developed business objects.
• Developed SQL Scripts, Packages and Procedures for Business rules check to implement business rules.
• Worked on the project that involved development and implementation of a data warehouse.
• Created Stored Procedures, Functions, Triggers, Indexes, and Views using T-SQL in all the environments for SQL Server 2000.
• Used Bulk Collections, Indexes, and Materialized Views to improve the query executions.
• Used Ref cursors and Collections for accessing complex data
• Developed DTS Packages to transfer the data between SQL Server and other database and files.
• Scheduled jobs & Re-Scheduled on Production Databases.
• Created report form with Stored Procedure using T-SQL
• Wrote and optimized Triggers, Stored Procedures, and Queries in T-SQL.
• Created database objects like tables, views, and indexes.

Environment: MS SQL Server 2000/2005, My SQL, Lotus Notes, MS Access, MS Office Suite (Word, PowerPoint, Excel).

Confidential

Jr. Oracle Developer

Responsibilities:

• Created PL/SQL stored procedures, functions, and packages for moving the data from staging.
• Created Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions in SQL Server.
• Created PL/SQL tables and global variables and also using IN and OUT parameters with TYPE, ROWTYPE, PL/SQL tables and PL/SQL records.
• Normalized to 3NF to acquire least data repetition.
• Performed SQL and PL/SQL Performance tuning and Application Tuning using various tools like TKPROF and AUTOTRACE.
• Using Bash script for database connectivity using DBI which connects to backend database drivers.
• Developed UNIX Shell scripts to run various utilities & wrote UNIX Crontab for the scheduled batch processes. created shell scripts and used Crontab in UNIX environment for scheduling routine tasks
• Involved in using dimensional modeling, created fact tables, dimensional tables and other database objects in the Star schema model.

Environment: Oracle 8i, SQL, PL/SQL, TOAD, SQL*Loader, SQL*Plus, Forms 6i, Reports 6i, Windows 2000.