SUMMARY:

• Developed and maintained data preparation and validation routines to support data warehousing
• 7years of experience in Application development and Production support using Oracle SQL, PL/SQL.
• Expertise in performing Data export, Import and various operations using TOAD, SQL DEVELOPER, FORMS AND REPORTS.
• Extensively worked in Client-Server application development using Oracle 11g/10g/9i FORMS 9i/6i, REPORTS 10g/6i, Oracle Import and Export Utilities.
• Experience in application development using various advanced features of Oracle like Bulk Collections, Table Functions, Autonomous Transactions, Dynamic SQL, Object types and Records.
• Supported Advance PL/SQL using Cursor, REF Cursor, and Native Dynamic SQL.
• Developed Complex trigger using PL/SQL for data integrity and enforcing business rules.
• Moved columns of data in and out of database tables using PL/SQL program units by passing collections as parameters.
• Extensive experience in data migration techniques using Oracle External Tables, SQL LOADER, UTIL file loader and batch processing.
• Experienced in data analysis, data modeling, development, testing and documentation of projects.
• Carried out testing in test database for upgrading/migrating from Oracle 9i to Oracle 10g.
• Experience in developing logical and physical database design, data modeling using Erwin Informatica Power Center 6.1 .
• Experience with Oracle APEX to develop new and support existing business applications.
• Involved in creating mappings, transformations in Informatica, tuning monitoring workflows.
• Used Cursor Variables to pass query results sets between PL/SQL programs and client application.
• Extensively worked on the Extraction, Transformation and Load ETL process using PL/SQL to populate the tables in database.
• Experience with DBA activities like creating table spaces, granting and revoking privileges on database objects.
• Improve the performance of the slow SQL queries by implementing indexes, using FORALL and BULK COLLECT.
• Extensively involved in Oracle SQL, PL/SQL tuning in OLTP and DWH applications using STATSPACK, Explain Plan, TKPROF, and Hints in Oracle 9i.
• Experience in UNIX Shell Scripting for batch processing.
• Comfortable to work with a team or work individually.
• Highly motivated self-learner with ability to develop proficiency and adapt to new technologies and methods in a short period of time.

PROFESSIONAL EXPERIENCE:

Role: Oracle PL/SQL developer

Description:

DST Health Solutions DSTHS , a leading provider of technology solutions and services to health plans, integrated delivery systems, and health care providers. DST Health Solutions offers one of the most comprehensive suites of clinical and administrative solutions in the industry. DST's integrated care management suite is core platform agnostic and designed to integrate with any claims administrative system.

Responsibilities:

• Analyzed the performance of the SQL queries and created the scripts for indexes.
• Building PL/SQL code using the technical and functional specifications.
• Developed test procedures to Unit test the application.
• Design and implementation of stored procedures and triggers for automating tasks.
• Generated SQL and PL/SQL scripts to install create and drop database objects, including tables, views, primary keys, indexes, constraints, packages, sequences, grants and synonyms.
• Developed SQL loader scripts to load data in the custom tables.
• Used Version Control tools like Microsoft Visual SourceSafe for Source Control.
• Worked closely with users and developers team to resolve issues in the developed reports.
• Maintained a series of UNIX Shell Scripts to manage batch order processing.
• Used ETL tools to extract and load data from SQL Server and flat files to Oracle database.

Environment: Oracle 11g, Oracle APEX, UNIX Server 4.3, SQL DEVELOPER, Windows NT, SQL PLUS, SQL Navigator and TOAD.

Confidential

Role: Oracle PL/SQL developer

Description:

Confidential offer a variety of insurance products to all segments of population, including large employer groups, small business and individuals. The HPS project will manage enrollments and billing for applicable on and off exchange members. Also, provide the data required to derive delinquency for applicable on and off change members.

Responsibilities:

• Primary responsibilities included system analysis, coding, testing, debugging and deploying.
• Created scripts to create new tables, views, queries for new enhancement in the application using TOAD.
• Created PL/SQL scripts to extract the data from the operational database into simple flat text files using UTL FILE package
• Used SQL LOADER and UTIL file loader to upload bulk data by writing scripts for the Control file.
• Design and implementation of stored procedures and triggers for automating tasks
• Developed the UNIX scripts using KORN shell to automate jobs.
• Analyze the source data structure and perform the Logical mappings.
• Created Forms using forms builder to showcase the data to users and enable them to perform the required updates
• Monitored the database and tuned the application code for better performance using with TKPROF.
• Modified existing packages to add new functionality and to optimize the performance.
• Wrote technical specification requirements and provided production Support.
• PowerBuilder used for simplifying migration process.

Environment: Oracle 11g/10g, Oracle Developer Suite 10g Forms and Designer , Oracle Application Servers, PowerBuilder12, UNIX Server 4.3, Windows NT, SQL PLUS, SQL Navigator and TOAD.

Confidential

Role: Oracle PL/SQL developer

Description:

Confidential , which provides reinsurance to many life insurance clients, by sharing the Net Amount at Risk NAAR . This system maintains information about company details, insurance plans and premiums. Other important feature of this application is that it keeps track of the details of Company Codes and concerned action taken.

Responsibilities:

• Writing backend stored procedures.
• Documentation of the business process through Designer.
• Involved in performance tuning using with TKPROF.
• Created documentation, design and implemented rich user interfaces using Oracle Apex.
• Developed UNIX Shell scripting for job automation and daily backup.
• Created partitions for parallel processing of data.
• Working on the ETL side of the process to load data into database from different servers.
• Used SQL LOADER and UTIL file loader to upload bulk data by writing scripts for the Control file.
• Design and Development of data validation, load processes, test cases using PL/SQL, Stored Procedures, Functions, Triggers using Oracle 11g.
• Involved in analysis, design and coding of Oracle processes in PL/SQL to build packages.
• Designed and Developed several reports using Oracle Reports 10g.
• Developed Procedures, Functions and Triggers to be implemented in the Reports.
• Developed data models for adding new tables and fields to the data warehouse.
• Writing event driven triggers, functions, and packages as needed
• Writing SQL queries, Cursors using embedded SQL, PL/SQL.
• Testing and debugging of the applications.
• Implementation and end user training.
• Worked on production support, and receive production calls, and working on trouble reports which are received from clients

Environment: Oracle 11g, Oracle 10g, Oracle APEX, Oracle Application Servers, UNIX Server 4.3, Windows NT, SQL LOADER, and TOAD.

Confidential

Role: Oracle Developer

Description:

Confidential is a Health Care Insurance Company, which provides a competitive health insurance plans for individuals and families. This system maintains information about customer details, products supplied and warranty. Other important feature of this application is that it keeps track of the details of customer complaints and concerned action taken.

Responsibilities:

• Analyze and understand business requirements for enhancements and additions to the datawarehouse.
• Database design and development including Tables, Primary and Foreign Keys, Indexes, Stored Procedures and Database access policies for the company's education system.
• Generated SQL and PL/SQL scripts to install create and drop database objects, including tables, views, primary keys, indexes, constraints, packages, sequences, grants and synonyms.
• Maintained a series of UNIX shell scripts to manage batch order processing.
• Database performance monitoring and identifying bottlenecks hindering the performance of the database.
• Developed web applications and business solutions using Oracle APEX.
• Created changes in the database according new requirements new tables in the existing database and fields in the existing tables .
• Constructed and implemented multiple-table links requiring complex JOIN statements, including outer-joins and self-joins.
• Developed and implemented Oracle Forms 9i and Oracle Reports 9i
• Tuned SQL statements using hints for maximum efficiency and performance, created and Maintain/modify PL/SQL packages, mentor others with the creation of complex SQL statements, perform data modeling and create/maintain and modify complex database triggers and data migration scripts.
• Created Web based applications using APEX.
• Created complex Stored Procedures and Views to be used for the Reports.

Environment: Oracle 11g/10g, Oracle REPORTS Developer 11g , UNIX Server 4.3, Rational Clear Quest, and Oracle APEX, SQL NAVIGATOR, JavaScript, HTML, XML, CSS.

Confidential

Role: Oracle Programmer/Developer

Confidential is the world's leading provider of over-the-phone interpretation services. It supports to communicate with immigrants from all corners of the world over-the-phone interpretation every day to overcome the language barriers between themselves and their limited English speaking customers, patients and citizens. The Project was aimed at construction of a data ware house to support the creation and ongoing generation of the client strategy session.

Responsibilities:

• Developed PL/SQL Packages, Procedures and Functions in Oracle 9i.
• Developed PL/SQL package procedures using REF cursor, Collections and Dynamic SQL.
• Developed PL/SQL package procedures to fetch bulk rows from cursor variable to collections.
• Developed Business logic using C .
• Incorporated bulk incremental inserts in PL/SQL procedures.
• Created Database Trigger to audit search events.
• Embedded SQL queries in PL/SQL procedures and ran them dynamically.
• Operated BLOBS, CLOBS and BFILES using PL/SQL DBMS LOB packages.
• Enhanced database functionality using Oracle supplied PL/SQL packages.
• Developed Java Stored Procedures and loaded Java Classes into Oracle.
• Designed Data Model Diagram using Designer 10g.
• Designed and Developed logical and physical database using Designer 10g.
• Created views, table, sequences, indexes and synonyms database objects.
• Created partitioned tables and indexes.
• Developed UNIX Korn shell scripts to process file feeds.
• Tuned PL/SQL packages to improve performance of the application.
• The data file to Corporate Central Repository.
• Created User Interfaces for search functionality using Oracle FORMS 10g.
• Created Menus, Object Libraries, and Properties Classes and integrated in application using Oracle FORMS 10g.
• Integrated Pluggable Java Beans into Oracle FORMS 10g Applications.
• Created and developed REPORTS for financial reporting using Oracle REPORTS 10g.
• Developed Oracle JSP REPORTS and integrated in Oracle Web FORMS.
• Tuned SQL queries using tuning techniques like TKProf.
• Created Designed Documents and technical documents.

Environment: Oracle 9i/RAC, Oracle FORMS 10g, REPORTS 10g, Designer 10g, TOAD,SQL DEVELOPER, UNIX, UNIX SHELL Scripting.

Confidential

Role: Oracle Developer

Responsibilities:

• Planning Backup/Restoration Strategy, Executing UNIX Shell Scripts using jobs, Planning and scheduling Backups, taking Logical Backups with Export / Import utilities .
• Tuning Applications, Tuning Memory and Tuning Disk Usage.
• Sizing the database for future growth.
• Coding procedures, functions, and triggers and generating the specified reports.
• Tuning of the SQL queries using Explain Plan, SQL Trace and TKPROF.
• Refreshing the test database with the production database.
• Created the database from full export for the Table space point in time recovery.
• Responsible for the creation and testing of hot and cold backup scripts using PL/SQL.
• Created and maintained the UNIX shell scripts to automate common tasks.
• Involved in analysis, design and development of the system.
• Created database objects tables, indexes, views, synonyms
• Created stored procedures, functions, triggers.
• Created of Roles, Users, Table spaces, database triggers, procedures etc.
• Modifying the database design and structure, as necessary, from time to time upon information given by application users and developers.
• Implemented integrity constraints on database tables.
• Created FORMS and REPORTS using Visual Basic.
• Testing and debugging
• Involved in preparing documentation and providing user training.

Environment: Sun Solaris 7, Oracle9i, Oracle Enterprise Manager, SQL LOADER/Import/Export Scripts, Erwin, TOAD, Visual Basic 5.0, Crystal Reports.