PROFESSIONAL SUMMARY

• Over 7 years of experience in Database development using Oracle, SQL, PL/SQL.
• Experienced in backend database development using tools SQL PLUS,SQL Loader, Oracle Designer, Oracle TOAD with good understanding of RDBMS and Normalization Techniques.
• Substantial development experience in creating Procedures, Packages, Functions, Triggers views, Cursors, PL/SQL Collections andoptimizing query performance and other database objects using SQL, PL/SQL.
• Experienced in environments requiring direct customer interaction during specifications, design, and development and product implementation phases.
• Experience in developing forms and generating reports.
• Extensively worked with various SQL scripts for relational databases.
• Proficient in Application Performance Tuning and Query Optimization.
• Writing scripts for collection of statistics, reorganization of tables and indexes, and creation of indexes for enhancing performance for data access.
• Strong knowledge of Data Extraction, Data Mapping, Data Conversion and Data Loading process using UNIX Shell scripting, SQL, PL/SQL and SQL Loader.
• Enforcing data integrity using integrity constraints and database triggers.
• Extensively worked on Triggers for implementing complex data integrity checks and for auditing tables.
• Developed Extraction, Transformation and Loading Using Pre-Stage, Stage, Pre-Target and Target tables.
• Knowledge in Test Scripts, Test Cases, and SQL QA scripts to perform Unit testing, System Testing and load testing. Seamlessly migrated the Code from Development to Testing, UAT and Production.
• Good understanding of Oracle Data Dictionary, RDBMS and Normalization techniques.
• Experienced in requirement analysis, coding and testing various modules in a software development life cycle.
• Excellent interpersonal skills, team player and ability to work well with all levels of an organization with effective presentation, verbal and written communication skills.
• Ability to utilize new tools and technologies in a changing environment.
• A Self-starter with a positive attitude, willingness to learn new concepts and accept challenges.

TECHNICAL SKILLS :

Work Summary

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Participated in client requirement sessions to analyze and gather business requirements.
• Involved in the Analysis, Design, Coding and Testing of the application and participated in discussion meetings about requirements.
• Developed ER Diagrams, Data flow diagrams based on the requirement.
• Involved in logical and physical database design.
• Developed SQL scripts to create database objects liketables, views and sequences.
• Wrote complex PL/SQL queries and performed data analysis.
• Created and Modified PL/SQLTriggers, Procedures, Functions and packages
• Extensively used for all and bulk collect to fetch large volumes of data from table.
• Used SQL Loader to load bulk data from various flat files and legacy systems.
• Developed SQL and PL/ SQL scripts for transfer of data between databases.
• Used Ref cursors and Collectionsfor accessing complex data resulted from joining of large number of tables.
• Optimized long running application queries, Analyzing tables, tuned stored procedures for maximumefficiency in various schemas across databases.
• Worked extensively on performance tuning handling large volume of datasets >500 million rows .
• Modified and enhanced existing systems to incorporate new functionality and to optimize them for performance.
• Worked extensively onperformance tuning and Query Tuning Generating Plan Table, Explain Plan, optimizer with Hints, Analyze, Indexing strategy, SQL Trace, TKPROF,AWR and ADDM reports .
• Designed the PL/SQL Procedures to load data from Flat files and Oracle into the target Oracle database.
• Developed UNIX shell scripts to automate data extraction using VI editor, SQL scripts and PL/SQL scripts. Scheduled all the shell scripts in crontab and monitor them by logging them in to a separate table.
• Worked on the integration on various legacy systems to the main process which included the data migrationand maintenance.
• Worked on data imports / Exports, Data pumps, SQL Loader.
• Worked on Database Design, Data Modeling, Migration, and Systems Architecture, Planning, Testing Query Optimization and Trouble Shooting.
• Involved in Code Review and User Acceptance Testing UAT of the application.
• Understanding the process and Interacting with functional team to resolve the issues in the given objects.
• Was responsible to update and maintain all process related documents and coordinate the effort within teams.
• Helped in maintaining an effective documentation process to track the version control and requirementchanges.

Environments: Oracle 11g, PL/SQL, TOAD, Erwin, Windows XP, RedHat LinuxEE 5.3, SVN.

Confidential

Oracle Developer

Responsibilities:

• Created complex functions, stored procedures and packages by using PL/SQL.
• Generated SQL and PL/SQL scripts to install building database objects including: tables, views, primary keys, indexes, constraints, packages, sequences, grants and synonyms with oracle 10gdatabase.
• Participated in Designing databases schemas to ensure that the relationship between data is guided bytightly bound Key constraints.
• Responsible working with user groups, analyzing reported problems, performing root cause analysis andpresenting alternatives to correct the problem.
• Developed back end interfaces using PL/SQL packages, stored procedures, functions, Object Types, Pipelined functions, Oracle queues and used Collections, Bulk Collects to improve performance by minimizing the number of context switches between the PL/SQL and SQL engines.
• Wrote complex SQL queries using Joins, sub queries and inline views to retrieve data from the database.
• Created Cursors, Collections and database triggers for maintaining complex integrity constraints and implementing the complex business rules.
• Worked on various tables to create Indexes to improve query performance. Also worked on partitioning large tables using Range Partitioning, creating Index Organized Table, Rollback Tablespace.
• Involved in Data Extraction, Transformation and Loading ETL process from Source to target And Worked on Windows Batch scripting, scheduling jobs and monitoring logs.
• Involved in Dimensional modeling and developed the star and snowflake schemas.
• Designed and developed complex reports to meet end user requirements and deployed using Oracle Report 10g.
• Developed complex triggers in reports before/after for validation of user input.
• Designed and developed user interfaces using Oracle Forms 10g.
• Converted oracle form application 6i to 10g using migration assistant.
• Performed unit testing and supported integration testing and end user testing.
• Extensively worked on production issues with effective defect management.
• Proactively tuned SQL queries and performed refinement of the database design leading to significant improvement of system response time and efficiency.
• Developed SQR's for loading data from feed file to staging tables.
• Involved in SQL tuning, PL/SQL tuning and Application tuning using various tools like TKPROF, EXPLAIN PLAN etc.
• Design and development of conversions, interfaces, customizations, Custom Forms, Reports and all Technical design and solutions.

Environments: Oracle 10g/11g, Oracle forms/reports 10g, SQL, PL/SQL, SQL Plus, Toad, MSSQL Server, Windows NT, HTML, XML.

Confidential

Oracle Developer

Responsibilities:

• Developed Stored Procedures, Function and Packages for the Financial System.
• Setup, tested and implemented new descriptive flex fields in Oracle Financials.
• Used database triggers and PL/SQL for development of system.
• Extensively used PL/SQL to write Cursors for acquiring information to be used in calculations written in stored procedures.
• Developed interfaces using PL/SQL packages, stored procedures, functions, Object Types, Cursors, Pipelined functions, Oracle queues and used Collections and Bulk Collects.
• Worked extensively on tuning of SQL and PL/SQL code using various tools like explain plan, TKPROF, SQL tuning advisor and SQL trace to enhance the performance.
• Created Korn Shell scripts which act as a wrapper for various tasks like - for executing the SQL Loadercommand lines, for refreshing the materialized views and for updating the Fact and the Dimension tables.
• Worked on various projects involving gap and map analysis, design and customization as per the businessrules and worked on custom applications development involving.
• Load the data into Oracle 9i, Oracle High -Performance, scalable database. Change of Accounts, Currencies, defining calendars, setup books and Multiorg setup.
• Design, development, testing and implementation of a custom billing System and order entry system.
• Implemented using Oracle 9i and Forms 6i.
• Developed forms to view payments, accept payments, view financial transactions, maintain and view cashassignments, view refunds, credit accounts, and transfer debit balances.
• Involved in Tuning Database Application performance using Explain Plan, TKprof, resolving lock contentions, identifying killing sessions.

Environments: Oracle 10g, SQL, PL/SQL, UNIX, SQL Plus, Reports 6i, Forms 6i/4.5, SQL LOADER, TOAD, Discoverer 6i.

Confidential

PL/SQL Developer

Responsibilities:

• Interacting with Business users, gathering and analyzing requirements.
• Analyzed Financial Markets Data and mapped Source Systems Data to Finance Data warehouse.
• Created system design document with high-level design and requirement document. Conducted walk throughfor requirement and system design.
• Created and modified SQL, PLSQL and SQL Loader scripts for data conversions to load data from flat filesinto oracle interface tables.
• Developed SQL Queries to fetch complex data from different tables from different databases using databaselinks and inserted the results into the newly developed tables.
• Created views, materialized views and synonyms for developers to hide the complexity and secure the directaccess of DB Tables.
• Developed various Oracle sub functions like Stored Procedures, Functions, and Packages using PL/SQL asper the Design Documents.
• Involved in uploading and downloading of the flat files from UNIX server using FTP.
• Undertook Code Optimization and Performance Tuning of the application using Explain Plan, hints, indexingand Partitioning of tables.
• Worked on Data Modeling tool which includes both Logical and Physical Models.
• Generated UNIX Shell scripts to automate Batch Jobs and Loading Process.

Environments: Oracle10g/9i, SQL, Pl/SQL, Toad, SQL Loader, Win XP, UNIX.

Confidential

PL/SQL Developer

Responsibilities:

• Responsible for writing database programming to Store/Retrieve the information from the database usingSQL.
• Designing and creating schema objects like Database tables, indexes, views, synonyms, and all schemaobjects in Oracle.
• Responsible for managing production, development test databases and applications.
• Wrote Stored Procedures according to specs and control files for input to SQL Loader utilities for loading data from external files into the Oracle database.
• Used Oracle UTL file features to create flat files and Procedures for Data Extraction.
• Creation of Users and Granting them privileges and roles.
• Creation of Table space, Data files, Indexes, Rollback Segment and monitoring them.
• Creating databases, objects, roles and privileges.
• Partitioned large tables to increase the performance.
• Configured scripts to monitor activity with database.
• Wrote extensive Sub Queries, PL/SQL procedures, functions, database triggers and packages.
• Writing Pl/SQL procedures and functions. Writing shell scripts to automate the data loading.
• Monitoring the data loading jobs and tuning the SQL queries.

Environments: Oracle 8i,9i, SQL Server 2000, UNIX Sun Solaris , Windows NT/2000/Advanced Server , TOAD, SQL PLUS, Explain Plan, UNIX Shell Scripting, Quest software tools.

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Involved in all phases of SDLC from requirement, design, and development and testing.
• Worked with BA's in gathering the requirements from the on shore business users and documenting them.
• Worked with PL/SQL programming in functions, procedures, and packages to implement business rules.
• Participated in system analysis and data modeling, which included creating tables, views, indexes, synonyms,triggers, functions, procedures, cursors and packages.
• Created scripts for database objects such as tables, views, indexes and sequences according to businessrequirements.
• Done extensive bulk loading into the target using Oracle SQL Loader.
• Extensively used Triggers to fire a particular event. Extensively tuned and optimized the SQL, PL/SQL code.
• Executed test cases according to the functional and user requirements.
• Implemented various integrity constraints for data integrity like Referential integrity using primary key andforeignkey relationships.
• Wrote Unix Shell scripts in UNIX.

Environments: Oracle 9i, SQL Plus, SQL Loader, PL/SQL, HP-UX, TOAD, Windows 2000.