SUMMARY

• Over 6+ plus years of experience as Oracle PL/SQL Developer Application Development - Analysis, Design and Implementation of Business Applications.
• Strong Exposure in writing simple and Complex SQLs, PL/SQL Functions and Procedures, Packages and creation of Oracle Objects - Tables, Functions, Packages, Materialized views, Triggers, Synonyms, User Defined Data Types, Nested Tables and Collections.
• Proficient in writing complex SQL Queries, stored procedures, Normalization, Database Design, creating Indexes, Functions, Triggers, Sub Queries
• Proficient in tuning SQL queries using HINTS and EXPLAIN PLAN.
• Designing and developing application schemas, ER Diagram, Tables (Partitioned Tables, Index Organized Tables, External Tables and Global Temporary Tables), Clusters, Indexes, Views, Materialized views, Triggers, Procedures, Functions and Packages.
• Experience in advanced PL/SQL concepts like Bulk collect and FORALL. Expertise in Dynamic SQL, Records, Arrays and Exception Handling.
• Experience in writing UNIX Shell Script.
• Interacted with business users, collected the requirements, analyze the requirements, design and recommend solutions.
• Experience in translating business requirements into creation of Database Objects.
• Experience with Data flow diagrams, Data dictionary, Database normalization theory techniques, Entity relation modeling and design techniques.
• Good ability to quickly grasp and master new concepts and technologies.
• Strong problem solving & technical skills coupled with confident decision making for enabling effective solutions leading to high customer satisfaction.
• Involved in all phases of the SDLC from analysis, design, development, testing, implementation, maintenance and support with timely delivery with aggressive timelines.
• Excellent written and verbal communication skills.
• Proven proficiency in multi-tasking skills.
• Oracle Certified Professional - OCP Passed in April 2014

TECHNICAL SKILLS

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

Programming Languages: Oracle SQL, PLSQL, UNIX Shell scripting, Core Java, C, C++

Web Technologies: Servlets, JSP, HTML, Java ScriptERP Oracle Application 11i/R12 (AOL)

Operating Systems: Windows (XP/7/200). UNIX (Sun Solaris, HP-UX, Linux)

Tools: Toad, Oracle Forms, Reports, PVCS, Microsoft Visio, SQL Developer, Oracle Workflow Builder, SVN, SQL*PLUS, Kintana, SSH, MS Office

PROFESSIONAL EXPERIENCE

Oracle PL/SQL Developer

Responsibilities:

• Assisted Business Analysts and Users in requirement analysis.
• Created Designs for the Back End PL/SQL based upon requirement documents.
• Created database objects like Tables, Sequences and Constraints as per the business requirement.
• Created database views and materialized views.
• Created database triggers based on requirement analysis.
• Developed stored functions, packages based on requirement.
• Unit test and debug developed software.
• Extensive knowledge on UNIX shell scripting and commands.
• Worked on creating users and roles as needed for the applications.
• Worked in review of ETL architecture, design, analysis and technical specification.
• Created test scripts documentation for procedure testing.
• Worked to improve the database performance using various performance tuning tools like Oracle optimizer.

Environment: Oracle 10g, 9i Windows, PL/SQL, SQL plus, oracle forms 6i/10g, oracle reports 9i/10g, TOAD 9.0, Oracle Developer Suite 10g

Confidential, Des Moines, IA

Oracle PL/SQL Developer

Responsibilities:

• Created, debugged and modified stored procedures, functions, packages, tables, views, materialized views and SQL scripts using PL/SQL.
• Created UNIX shell scripts to automate table creation, execute procedures by using CRONTAB.
• Involved in performance tuning which included creating indices, table partitioning, SQL hints using explain plan utility.
• Involved in developing and maintaining control files for SQL loader to load the data from SQL server to oracle database tables.
• Worked on queries using Teradata SQL Assistant to connect various ODBC sources.
• Worked with DBAs to help them in data loading process, batch jobs and various administration tasks.
• Responsible for data mapping and creating Run-Books from legacy system to oracle.
• Extensive experience in working with different FTP clients such as IpSwitch, winSCP for extracting data from sources to own destination.
• Created synonyms and make sure that users have executable permissions on all objects.
• Performed re-org for several dimension and fact tables for space release management in data warehouse.
• Extensively used cursors, sequences and indexes in the procedures.
• Created PL/SQL based ETL process to transfer data from legacy sources to staging area and from staging area to data warehouse.
• Responsible for monthly ETL in SQL server which are used by the users for potential tableau reporting.
• Created stored procedures for daily database space monitoring.
• Wrote dynamic SQL queries in different procedures and packages to work on PIVOT function.
• Worked extensively on Exception handling to trouble shoot the PL/SQL code.
• Involved in automation of SQL server jobs that are performed manually which involves MS ACCESS.
• Worked in production support environment which involved in performing operation such as monitoring jobs, performing root cause analysis, troubleshooting the issues, monitoring top activity and long running queries, performance tuning and space management.
• Created and modified several UNIX shell scripts according to the changing needs of the project and client requirements.

Environment: Oracle 10g, SQL*PLUS, SQL LOADER, PL/SQL Developer, Teradata Client 13.0, IpSwitch, UNIX Shell script, SQL server 2008, MS Access, Business intelligent development studio 2008, windows 2007, MS office.

Confidential, Lansdale, PA

PL/SQL developer

Responsibilities:

• Involved in SDLC process. Prepared project plan with deliverables and time lines.
• Created the tables and sequences for the experimental data load capture.
• Extracted the data from ELN database by writing the procedure and loaded into the table.
• Used the Bulk binding techniques for query optimization.
• Created indexes on tables and optimized procedure queries.
• Retrieved the user’s email address from the LDAP Server and stored them in a table.
• Created PLSQL procedure, which sends an email notification to the users.
• Used the HTML Coding for sending email notification for the users.
• Used the UTL SMTP Server connection for sending emails.
• Created PLSQL procedure, used the DBMS SCHEDULER for automatic weakly sending emails to the users.
• Involved in UAT testing, Bugs fixing and the code was sent to Production.
• Developed Excel Report using the procedural code.
• Manipulated Stored Procedures, Triggers, Views, Functions and Packages using TOAD.
• Effort also included development of stored procedures.
• Prepared the Design specification and IQ Documents

Environment: Oracle 10g, PL/SQL, SQL*Plus, SQL developer, TOAD.

Confidential, St. Louis, MO

PL/SQL Developer

Responsibilities:

• Interacting with client and supervised in preparation of the technical documentation.
• Implementation of business requirements, gap analysis, and technical specifications.
• Worked in development, testing and production environment using packages, stored procedures, functions.
• Created various SQL and PL/SQL scripts for verification of the required functionalities.
• Experienced in resolving the issues in production environment.
• Analysed the specification to suggest the right solutions based on client requirements.
• Created the database objects like tables, views, procedures, packages using Oracle tools like SQL*Plus and Toad.
• Worked on REF CURSOR and collection data type for bulk collection
• Worked on optimizing existing procedures and functions using PL/SQL.
• Worked on Dynamic SQL and PL/SQL block in PL/SQL.
• Scheduled the jobs using DBMS Scheduler.
• Modified the various existing packages, procedures, functions and triggers according to the new business needs.
• Involved in Analyzing and Performance Tuning of the SQL queries using optimizer hints for joins, parallelism and Explain plan
• 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.
• Created, modified and tested SQL scripts.
• Wrote various kinds of SQL queries involving Correlated Sub queries, UNION, Inner and Outer Joins.
• Developed UNIX Shell Scripts to execute procedures and publish the files.
• Prepared unit test plan, test cases and requirements trace matrix and performed effective Unit Testing and resolved issues, if any, during the System or Acceptance Testing phase.

Environment: SQL, PL/SQL, UNIX Shell Scripting, Oracle 10g, SQL*Plus, Oracle Forms, Oracle Report, SQL*Loader, EditPlus.

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Coordinated with clients, Requirements gathering and designing.
• Participated in system analysis and data modeling, which included creating tables, views, indexes, synonyms, triggers, functions, procedures, cursors and packages.
• Created Indexes and sequences for faster retrieval of the visitor information.
• Worked with Bulk Collect & Bulk Bind to improve the retrieval of multi row.
• Implemented Join conditions, group by functions, correlated subqueries, nested subqueries.
• Created procedures and functions for validation of transaction records into interface tables.
• Database security by authenticating users, using logon triggers.
• Created triggers for auditing purpose and created group, tabular, and form reports.
• Created materialized view on remote database and automated scheduler of refreshing of materialized view.
• Created indexes on tables and optimized procedure queries.
• Design few pages using HTML and XML to interact with database.
• Used several Oracle provided packages such as UTL FILE, DBMS JOB, and DBMS SCHEDULER
• Used advanced SQL like analytical functions, aggregate functions for mathematical and statistical calculations.
• Involved in writing technical documentation, and writing test plan.

Environment: UNIX, Solaris 5.9, Oracle 9i, TOAD 10.4, PL/SQL, SQL*Plus 9.2.0.1, SQL Developer 2.9, Oracle Enterprise Manager, FileZilla 0.9.40, UML 2.1, BugZilla 4.0.0, MS Project 2010.