Summary:

• 8 years of experience in Software Application development using Oracle, PL/SQL and VB.
• Good Experience in tools like SQL Plus, Toad, PL/SQL Developer.
• Developed complex queries on Data Warehousing and developed Warehouse using PL/SQL procedures to give in nice strategic plans to higher level of management.
• Extensive experience writing Stored Procedures, Functions, Packages, PL/SQL routines, Database triggers, Shell-Scripting, unit testing integrity and also involved in complex back end data extraction, transformation and loading operations ETL on oracle using SQL Loader.
• Created multiple customized PL/SQL Procedures, Functions and Packages for various business needs, transforming data before the loading process, manipulating and sorting data for the Reports specifications.
• Well experienced in Query Optimization and Tuning using index, bulk collections, Hints, Explain Plan, SQL AUTOTRACE. Experienced in creating External tables, Uploading/Downloading data using SQL Loader control files.
• Analyzed and overviewed the database design for better understanding the relations, associations and dependencies within the database.
• Developed database objects including tables, clusters, Indexes, views, sequences, packages, triggers and procedures to troubleshoot any database problems.
• Strong work experience in Query construction, Stored Procedures, application based Triggers and User Defined Functions using SQL, PL/SQL
• Excellent domain knowledge in Finance Banking.
• Tuned complex Stored Procedures for faster execution and Developed database structures, according to the requirements in Oracle data warehousing.
• Wrote DDL Scripts to create new database objects like tables, views, synonyms and indexes.
• Self-motivated and results oriented person with good analytical and problem solving skills
• Creative, independent, good team player with and ability to accept responsibilities and meet tough deadlines.

Project Summary:

Confidential

Sr.Oracle Pl/SQL Developer

Responsibilities:

• Responsible in requirements gathering, analysis, design and development of any enhancements in the application.
• Involved in maintaining and updating the procedure for ETL process.
• Extensively involved in writing and managing PL/SQL stored procedures, functions, triggers and packages to meet the business requirements and update the existing objects based on change requests.
• Created and maintained database objects like tables, views, materialized views, and synonyms to meet the business requirements.
• Understanding the business logic to modify existing SQL Code and Performance Tuning, indexing, table partitioning.
• Used bulk processing for better performance and easy retrieval of data, being a part of performance tuning of the procedures and packages.
• Created custom PL/SQL procedures to read data from flat files to dump to Oracle database using SQL Loader.
• Created PL/SQL scripts to extract the data from the operational database into simple flat text files using UTL FILE package.
• Used the Explain Plan for tuning the queries and also used the TKprof for tuning the procedures by setting up the trace and generating the trace files.
• Modification of the existing forms and reports and registering those in Application.
• Analyzed and overviewed the database design for better understanding the relations, associations and dependencies within the database.
• Provided knowledge transfer to other team members about the new technology and allocation of tasks to the team.
• Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
• Written UNIX shell scripts to automate processes like data load.

Environment: PL/SQL, TOAD, SQL Loader, Oracle 11g, UNIX, Erwin, SQL Plus, and Oracle Forms.

Confidential

PL/SQL Analyst

Responsibilities:

• Developed applications by using SQL queries and implemented PL/SQL codes by using Procedures, Functions, triggers and Packages.
• Executed and maintained SQL and PL/SQL statements to insert update and delete database applications by using tables, views, constraints and packages.
• Wrote Procedures, packages, SQL sub queries and PL/SQL fundamentals to ensure that data is populated into the correct tables and data integrity is maintained.
• Extensively used SQL loader to load data into the database.
• Utilized performance enhancements features of Oracle to optimize query and the batch processes.
• Optimized the queries.
• Performance tuning of SQL Stored Procedures.
• Involved in Troubleshooting, fixed and implemented bug fixes and enhancements within tight deadlines
• Build ad-hoc reports.
• Created SQL Loader scripts to load data into the temporary staging tables.
• Analyzed and overviewed the database design for better understanding the relations, associations and dependencies within the database.
• Developed database objects including tables, clusters, Indexes, views, sequences, packages, triggers and procedures to troubleshoot any database problems.

Confidential

Oracle Developer

Responsibilities:

• Participated in all phases including Requirement Analysis Client Interaction Design, Coding, Testing and Documentation.
• Converted functional specifications to technical specifications.
• Designed Logical and Physical Models.
• Extracted huge volumes of data from legacy systems and uploaded into Oracle using SQL Loader and PL/SQL.
• Data Modeling Responsibilities.
• Created data mart with complete start schema for OLAP reporting.
• Star Schema was designed for the outlay of the OLAP Oracle Database.
• Developed ETL processes
• Developed Stored procedures and packages to update the clients database
• Wrote procedures for allocating income, expenses, realized and unrealized gains and losses to multi class funds with STAR accounting system.
• Wrote Functions and triggers to process and performance calculations of the investments.
• Optimized the queries.
• Performance tuning of SQL Stored Procedures
• Designed and Developed and tested universes for supporting ad-hoc reports ad implemented advance features such as aggregate awareness, context.
• Created various classes and objects for universe. Measure, dimension and details were created to meet the needs of end user Human resources requirements
• Testing the STAR Accounting system

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Ensured conformance to code standards and documentation requirements.
• Made structural changes to database objects using Oracle tools like SQL Plus and TOAD.
• Wrote complex SQL queries, Sub queries and nested loops for faster data retrieval.
• Extensively used cursors, sequences, indexes in the procedures according to the requirement.
• Involved in Performance Tuning for the SQL, PL/SQL scripts.
• Extensive Knowledge and working of Bulk Collect and Bulk Binding for data retrieval.
• Modify and made tables for the loading of data from different sources using SQL loader.
• Used exception handling methods along with pragma exception init in order to associate our own created exception names.
• Programmed in T-SQL to implement Stored Procedures and Functions for different tasks.
• Handled XML Files for data loading purposes.