SUMMARY

• 7+ years of programming experience as an Oracle PL/SQL Developer in Analysis, Design, and Implementation of Business Applications.
• Involved in all phases of teh SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and support/maintenance with timely delivery against aggressive deadlines.
• Experience with Data flow diagrams, Data dictionary and Database normalization theory techniques, Entity relation modeling and design techniques.
• Experience in Client - Server application development using Oracle 12c/11g/10g/9i/8i, PL/SQL, SQL *PLUS, TOAD.
• Created Packages, Procedures, Functions, Triggers, and Cursors using PL/SQL for application databases.
• Good experience in creating PL/SQL Packages, Procedures, Functions, Triggers and Materialized Views to retrieve, manipulate and migrate complex data sets in Oracle Databases.
• TEMPEffectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions.
• Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
• Created Tables, Views, Sequences, Constraints, Indexes (B Tree, Bitmap and Function Based).
• Experience in Oracle supplied packages, Dynamic SQL, Records, PL/SQL Tables and Exception Handling.
• Experience with Oracle Supplied Packages such as DBMS SQL, DBMS JOB, UTL FILE.
• Created Packages and Procedures to automatically drop table indexes and create indexes for teh tables.
• Experience in performance tuning and Query optimization using Explain Plan, SQL Trace utilities.
• Good noledge of key Oracle performance related features, such as Query Optimizer, Execution Plans and Indexes, for faster execution.
• Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team.
• Involved in testing of phases for unit testing, system testing, regression testing and user acceptance testing.

TECHNICAL SKILLS

Databases: Oracle 10g/11g/12c, SQL Server, MS access

Programming Languages: SQL, PL/SQL, unix, sas(statistical analysis system)

Tools: and Utilities: SQL*PLUS, SQL*LOADER, PL/SQL Developer, Toad

Operating Systems: UNIX, Windows (98/2000), DOS

PROFESSIONAL EXPERIENCE

Confidential, Indianapolis, IN

Oracle PL/SQL Developer

Responsibilities:

• Created tables in oracle staging area.
• Writes technical mapping documentation based on teh documents prepared by BA’s.
• Write PL/SQL procedures dat will handle teh conversion task from legacy system to target system
• Fine tune PL/SQL procedures and SQL queries.
• Data loaded from legacy systems using PL/SQL and SQL*Loader.
• Used Toad for creating PL/SQL (trigger, sequence, stored procedure).
• Used UTI FILE PACKAGES for writing DBMS OUTPUT messages to file.
• Created Packages, Procedures, Functions, Triggers, Cursors using PL/SQL in UNIX and Windows environment.
• Wrote Unix Shell Scripts for scheduling jobs in Unix/Linux, regular backups, instance start/shutdown and migrating data into tables.
• Direct in writing and maintaining data conversion code from documented logic and instructions of limited to moderate complexity
• Study and perform data analysis and executes data conversions.
• Performs code and unit testing for moderate to complex scope data conversion routines.
• Involved in unit testing, integration testing, system testing, user acceptance testing.
• Developed thePL/SQLvalidations to eliminate teh unrequited data.
• Verified existing functional requirements with users and gatheird missing requirements from users.
• Interacted with Business Analysts and Users in requirement gathering, built complex queries using SQL and wrote stored procedures using PL/SQL.
• Used Oracle packages like DBMS STATS to collect statistics of many different kinds as an aid to improve teh performance and UTL FILE to read and write operating system text files.

Environment: Oracle 11g/12c, Windows NT/2000/XP, UNIX Shell Script, HTML, PL/SQL, SQL*Loader.

Confidential

PL/SQL Developer

Responsibilities:

• Developed Stored Procedures, Functions, Packages and SQL Scripts using PL/SQL.
• Loaded teh data into database tables using SQL*loader from text and excel files.
• Client Interaction for freezing requirement.
• Coding to cater to new business needs and frequent change requests.
• Key member in functional Analysis and logic/workflow designing of different modules.
• Responsible for code troubleshooting with team, issue resolution.
• Tracking teh defects on weekly basis and reporting to clients as well as international channels.
• 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.
• Data loaded from systems (ETL Operations) using PL/SQL and SQL*Loader.
• Developed Procedures for efficient Error Handling process by capturing errors into user managed tables.
• 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.
• Developed UNIX Shell scripts to automate table creation, execute procedures.
• Used Bulk Collections, Indexes, and Materialized Views to improve teh query executions.
• Used Ref cursors and Collections for accessing complex data resulted from joining of large number of tables in pl/sql blocks and even have experience with exception handling..
• Atomized routine jobs using DBMS JOB. On completion of these jobs an email will be sent out automatically with teh help of UTL MAIL.
• Developed SQL and PL/SQL scripts to transfer tables across teh schemas and databases.
• 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.

Environment: Oracle 10g, Windows XP, SQL, PL/SQL, SQL*Loader, PL/SQL Developer, UNIX, TOAD, PL/SQL developer