PROFESSIONAL SUMMARY

• Over 7 years of experience in Database development using Oracle, SQL, PL/SQL.
• Substantial development experience in creating Procedures, Packages, Functions, Triggers views, Cursors, PL/SQL Collections and optimizing query performance and other database objects using 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.
• 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

Confidential

Oracle PL/SQL Developer

• CVS Health formerly CVS Caremark Corporation is an American retailer and health care company. One of the nation's leading pharmacy benefit management PBM companies, provides comprehensive prescription benefit management services to over 2,000 health plans, including corporations, managed care organizations, insurance companies, unions and government entities.
• The project involved in development of the Web portal application used by the pharmacists to enter the dispensing information and also used by pharmacists as search based application.

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.
• Involved in logical and physical database design.
• Developed ER Diagrams, Data flow diagrams based on the requirement.
• Developed SQL scripts to create database objects like tables, views and sequences.
• Wrote complex PL/SQL queries and performed data analysis.
• Created and Modified PL/SQL Triggers, 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 Collections for accessing complex data resulted from joining of large number of tables.
• Optimized long running application queries, Analyzing tables, tuned stored procedures for maximum efficiency 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 on performance 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 migration and 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 requirement changes.

Environments: Oracle 11g, PL/SQL, TOAD, Erwin, Windows XP, Red Hat Linux EE 5.3, SVN.

Confidential

Oracle Developer

Hanger Prosthetics and Orthotics a division of Hanger Orthopedic Group provides prosthetic and orthotic patient care services in the United States. Hanger Prosthetics and Orthotics operates under the corporate umbrella of Hanger Orthopedic Group, Inc., headquartered in Austin, TX formerly Bethesda, MD . Project Involved in development of the Patient Care portal application PCPA .

Responsibilities:

• 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 Table space.
• Created Cursors, Collections and database triggers for maintaining complex integrity constraints and implementing the complex business rules.
• Responsible working with user groups, analyzing reported problems, performing root cause analysis and presenting alternatives to correct the problem.
• Participated in Designing databases schemas to ensure that the relationship between data is guided by tightly bound Key constraints.
• 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.
• 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.
• 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

Confidential is an American company specializing in business service management BSM software. It develops, markets and sells software used for multiple functions, including IT service management, data center automation, performance management, virtualization lifecycle management and cloud computing management.

Responsibilities:

• Developed interfaces using PL/SQL packages, stored procedures, functions, Object Types, Cursors, Pipelined functions, Oracle queues and used Collections and Bulk Collects.
• 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.
• 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 Loader command 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 business rules 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 Multi org 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 cash assignments, 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

Franklin Resources Inc. is an American holding company that, together with its subsidiaries, is referred to as Franklin Templeton Investments it is a global investment firm originally founded in New York in 1947 as Franklin Distributors, Inc.

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 through for requirement and system design.
• Created and modified SQL, PLSQL and SQL Loader scripts for data conversions to load data from flat files into oracle interface tables.
• Developed SQL Queries to fetch complex data from different tables from different databases using database links and inserted the results into the newly developed tables.
• Created views, materialized views and synonyms for developers to hide the complexity and secure the direct access 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, indexing and 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

Vision Technologies VT is the leading technology and professional service providing company, we've successfully served the technology needs of customers from diverse industries and locations. Vision Technologies has a well-earned reputation of addressing its client's complex challenges with business acumen and innovative technical solutions. VT specializes in full-lifecycle project.

Responsibilities:

• Responsible for writing database programming to Store/Retrieve the information from the database using SQL.
• Designing and creating schema objects like Database tables, indexes, views, synonyms, and all schema objects 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

Pramati Technologies is a privately held company software services company based in Hyderabad, India. Pramati Server 3.0, was the industry's first independently developed application server to achieve J2EEv 1.3 compatibility. Achieving this industry first involved passing over 15,000 tests in the Sun Microsystems J2EE Compatibility Test Suite.

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.
• Participated in system analysis and data modeling, which included creating tables, views, indexes, synonyms, triggers, functions, procedures, cursors and packages.
• Worked with PL/SQL programming in functions, procedures, and packages to implement business rules.
• Created scripts for database objects such as tables, views, indexes and sequences according to business requirements.
• 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 and foreign key relationships.
• Wrote Unix Shell scripts in UNIX.

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