SUMMARY

• 7 years of total IT experience in Enterprise level systems in Health Care, Education, Telecom Sectors as an enterprise solutions level PL/SQL and Oracle developer.
• Expertise in the Oracle Database Administration.
• Expertise in client server applications development using Oracle 9i/10g/11g versions.
• Performed data extraction and conversion from different Legacy Systems into Oracle Databases.
• Interfaced the data from legacy systems to Oracle applications using API’s and Oracle utilities like UTL FILES, SQL*Loader, Import, Export utilities and External tables.
• Had done various projects using RMAN for Backup and recovery, Data guard for Disaster Recovery, Installation, Configuration, Migration, upgrade, cloning, patching, Performance Tuning.
• Excellent experience in Installation, Configuration of different databases on Operating Systems.
• Planning and scheduling the Physical (Cold/Hot) backups as well as Logical backups.
• Experience in management tools like Oracle Enterprise Manager, Toad and SQL Developer.
• Knowledge on Real Application Cluster(RAC).
• Provided 24x7 Remote/on - call production supports.
• Generating AWR Reports whenever required.
• Use of SQL diagnostic and tuning tools like AUTOTRACE (AWR/ADDM Reports).
• Diagnosis of the Alert and Notification.
• Database Links, Creating and Managing Table spaces and Data files, Creating and Rebuilding Indexes, Managing Database Security.
• Creating Database users and granting roles.
• Troubleshooting and maintenance of Oracle Database.
• Handling space issues.
• Extensively implemented and coded, carried out performance tuning in PL/SQL to develop Sub queries, scripts, triggers, functions, stored procedures, and packages.
• Experienced in using advanced PL/SQL concepts like Referential Cursors, Collections, Dynamic SQL and PL/SQL to achieve high levels of modularity and maintainability of code.
• Developed PL/SQL packages for several Inbound and Outbound interfaces
• Experience in developing reports and ad hoc reporting using tools like Discoverer, Oracle Developer Suite.
• Knowledge and experience in Testing Methodologies.
• Excellent documentation skills concerning Conversions (CV 0.040), Technical (MD 0.070), Functional (MD 0.050), BR 100 to document detailed project management.
• Extensive programming knowledge in PL/SQL, SQL*Plus, TOAD, SQL*Loader.
• Experience in development of Trigger, Procedures, Functions and Packages.
• Extensive experience in Complex SQL Queries, Dynamic SQL, Analytical function, Oracle Object and Collection, Bulk Collect etc.
• Experience in Oracle Data Warehouse Process Basic level.
• Experience in development and maintenance of data warehouse initiatives and reporting needs for the business.
• Expert in Data Conversion, Add-hoc reporting, Data Analysis and validation.
• Extensive knowledge in shell scripting.
• Proficient in transforming data from various sources (flat files, mainframe, Oracle) to Data warehouse using SQL*LOADER and External table.
• Competency in manual testing of User acceptance testing.
• Experience in code migrations from Development to QA, QA to UAT (Stage) and Stage to Production Environment.
• Experience in Query Optimization, Debugging and Tuning for improving performance of the applications.
• Experience in analyzing Data flow Diagram, ER Diagrams.
• Extensively involved in designing Database schemas
• Experience in using Version Manager (PVCS).
• Experience in Oracle Developer PL/SQL, SQL etc based multi-tire application development
• Extensively worked with all aspect of in-house system deployment for organization & experience in developing customized software solutions.
• Experienced in all phases of the system development life cycle (SDLC)
• Experience in Documentation that involves functional specification, user Manual and technical review.
• Strong interpersonal skills, ability to interact with people at all levels. Good communication and presentation skills.
• Good knowledge and hands on experience in SDLC methodologies like Agile, Scrum.

TECHNICAL SKILLS

OPERATING SYSTEMS: Dos, Windows 2000,NT, Unix, Linux.

RDBMS: Oracle 8i, 9iR2, 10gR1 & R2, 11gR1 & R2

Tuning Tools: TKPROF, EXPLAIN PLAN

Languages: C,C++,Java,c#,SQL,PL/SQL

SCRIPTS: Shell script

Web Technologies: HTML,XML,CSS,ASP.Net

Tools: SQLPLUS,TOAD,SQL*LOADER,SQL DEVELOPER AWR,ADDM etc.

Backup Methods: Cold&, Hot backup, RMAN,, Import/Export

PROFESSIONAL EXPERIENCE

Confidential, Tampa, FL

Oracle DBA & PL/SQL Developer

Responsibilities:

• Involved in developing & modifying SQL and PL/SQL tables, Packages, Functions, Procedures, cursors, views, indexes and database triggers.
• Developed PL/SQL packages, to enter data for the Customers Enrolled in the Health Insurance Policy.
• Click to Oracle Interface Package: Interface to bring in data from external systems.
• Developed an interface program returned in shell script to load data from legacy system and attached it to request set.
• Manage and support the Oracle databases
• Managing table spaces, data files, redo logs, tables and its segments.
• Maintaining data integrity also managing profiles, resources and password security.
• Managing Users, Privileges and Roles.
• Install Oracle software and patches.
• Upgrading the Database from lower version to higher version.
• Tune SQL statement against database and its objects.
• Developed PL/SQL packages to convert contacts (Contacts Conversion for employees) obtained from several carriers in the form of flat files using Oracle seeded APIs.
• Developed Customer Conversions to load the Customer information into Oracle tables.
• Involved in data migration from Flat files (.csv, .txt) into the respective Oracle Database tables using SQL* Loader scripts.
• Used Oracle Reports Builder 10g and XML Publisher for the development of reports.
• Developed scripts to migrate the LDT files between instances.
• Involved in Tuning SQL queries using Explain Plan and Tkprof utility to improve performance of the queries.
• Involved in Extraction and loading of data in between the schemas using oracle Export and Import utilities.
• Developed tables with partitions and created indexes, constraints, triggers, synonyms, database links, table spaces, roles etc in different schemas.
• Created scripts to load the data into staging tables from other database using DBlinks.
• Created stored procedures with cursors to load the data from staging to analysis tables.
• Worked with various complex queries with joins, sub-queries, and nested queries in SQL queries.
• Worked with UNIX shell scripts to load different Actimize instruments data in to analysis tables.
• Developed UNIX shell script to automate notification of Emails, to the users when a process fails in production.
• Worked with SQL loader and control files to load the data in different schema tables.
• Involved in the database administration and creating objects such as database, users, schema and table spaces.
• Involved in managing security, granting and revoking privileges on database objects
• Performed regular backups on the database using RMAN utility.
• Created some Custom reports and Forms for the end users to check the details and errors.
• Involved in production support by efficiently debugging the production issues.
• Coding, testing and documentation for Oracle Apex along with operational and system level documentation
• Worked on XML data, customer data used oracle in built XML functions for parsing andvalidating the XML data.
• Worked on Oracle Apex for the application user interface design and development

Environment: Oracle 10g, 11g TOAD for My SQL, TOAD, Control M 6.2.01,CVS, UNIX, Windows NTWindows, SQL Navigator, XML, MS Outlook 98,MS Office 2000.

Confidential

Oracle DBA Consultant

Responsibilities:

• Designed and created Entity-Relationship diagrams, data models and other database related information by reverse engineering defined data dictionary, database entities, parent child relationship keys, identifying primary and referential integrity constraints, sequences, stored procedures.
• Developed custom database objects like tables, materialized views, triggers, indexes, cursors to implement efficient data management techniques.
• Designed and created ER and Data Modeling diagrams using VISIO 2000 software.
• Installed, upgraded and patched Oracle software. Setup brand new machines including Oracle software installation, Oracle side configuration, third party backup software Legato troubleshoot and backup testing.
• Managed and resolved design issues during development.
• Moved database Schema changes to stage or production.
• Migrated and upgraded databases from version 8i to 9.
• Developed some Unix Shell scripts to automate database operation and database monitoring.
• Developed or modified some Oracle backup and recovery scripts. Used Oracle backup utility RMAN/EBU to implement Oracle backup and performed a number of times of disaster recovery.
• Implemented database refresh with the hot backup using DUPLICATE or full export. Used EXPORT/IMPORT to do table level and full database defragmentation.
• Performed database tuning using Explain Plan, hints, Toad, and Enterprise Manager.
• Provided on-call production database support.
• Used RMAN for backup, restore and recovery.
• Worked on extracting life events and benefits of employee information from Oracle Applications base tables to Intermediate tables for outbound interfaces.
• Developed custom packages, procedures and functions for the HR schema.
• Checked the functionality of screen GUI’s.
• Worked with the team to isolate production issues with accuracy and quick precision.
• Reviewed the Business Requirement Documents and the Technical Specification.
• Designed Test scripts and test cases in Test Director and MS-word.
• Generated automated test cases on first build of the module using QTP, Rational Tools.
• Developed automated test scripts from manual test cases for Regression testing based on the requirement documents using QTP.
• Analyzed Software Requirement Specification
• Involved in writing the Test cases and Test plans based on Source to Target Mapping documents and Data Model diagrams.
• Wrote Test cases for Enterprise Data Warehousing (EDW) Tables and Data Mart Staging Tables.
• Wrote SQL queries for each Test case and executed in SQL Plus to validate the data between Enterprise Data Warehousing and Data Mart Staging Tables.
• Used various checkpoints in the Informatics designer to check the data being transformed.
• Wrote and ran Unix Scripts for batch jobs.
• Performed backend database testing by writing SQL and PL/SQL scripts to verify data integrity.

Environment: Oracle9i, PL/SQL, SQL*Loader, UNIX, TOAD, MS-Excel, MS-Visio

Confidential

Oracle Technical Consultant

Responsibilities:

• Designed/developed/Modified tables, views, materialized view, stored procedures, packages and functions.
• Installation and configuration of Oracle 8.1.6 server and creation of databases.
• Database and SQL tuning to improve performance of loads.
• Implemented table partitioning to improve performance and data management.
• Performed SQL tuning by using Explain Plan and Tkprof.
• Bitmap indexes were used on low cardinality columns as they result in reduced response time for queries and substantial reduction of storage space.
• Assisted in logical and physical database design.
• Making structural changes to the databases when design changes are to be implemented.
• Developing Unix shell scripts and SQL scripts to carry out routine checks on databases.
• This includes checking whether all databases are running, listener is running, Unix error messages, disk space availability, segments with greater than 10 extents, segments nearing max extents, checking for errors in alert logs and trace files, etc.
• Coded PL-SQL packages and procedures to perform data loading, error handling and logging.
• Tuned database SQL statements and procedures by monitoring run times and system statistics.
• Used SQL loader to load the data from the files provided by the interfacing applications.
• Created new procedures, functions, triggers, materialized views, packages, simple Ref & Traditional cursors, Dynamic SQL, Table functions as part of project requirements.
• Wrote database triggers to implement the business rules in the application.
• Created external tables to handle huge volumes of data which is not used frequently.
• Optimized lot of SQL statements and PL/SQL blocks by analyzing the execute plans of sql statement and created and modified triggers, SQL queries, stored procedures for performance improvement.
• Developed various backend application programs such as views, functions, triggers, procedures and packages using SQL and PL/SQL.
• Implemented all modules logic by using triggers and integrity constraints.
• Involved in PL/SQL code review and modification for the development of new requirements.

Environment: Oracle9i, PL/SQL, SQL*Loader, UNIX, TOAD.

Confidential

Oracle Technical Consultant

Responsibilities:

• Involved in developing & modifying SQL and PL/SQL tables, Packages, Functions, Procedures, cursors, views, indexes and database triggers.
• Developed PL/SQL packages, to enter data for the Customers Enrolled in the Health Insurance Policy.
• Click to Oracle Interface Package: Interface to bring in data from external systems.
• Developed an interface program returned in shell script to load data from legacy system and attached it to request set.
• Developed PL/SQL packages to convert contacts (Contacts Conversion for employees) obtained from several carriers in the form of flat files using Oracle seeded APIs.
• Developed Customer Conversions to load the Customer information into Oracle tables.
• Involved in data migration from Flat files (.csv, .txt) into the respective Oracle Database tables using SQL* Loader scripts.
• Used Oracle Reports Builder 10g and XML Publisher for the development of reports.
• Developed scripts to migrate the LDT files between instances.
• Involved in Tuning SQL queries using Explain Plan and Tkprof utility to improve performance of the queries.
• Involved in Extraction and loading of data in between the schemas using oracle Export and Import utilities.
• Developed tables with partitions and created indexes, constraints, triggers, synonyms, database links, table spaces, roles etc in different schemas.
• Created scripts to load the data into staging tables from other database using DBlinks.
• Created stored procedures with cursors to load the data from staging to analysis tables.
• Worked with various complex queries with joins, sub-queries, and nested queries in SQL queries.
• Worked with UNIX shell scripts to load different Actimize instruments data in to analysis tables.
• Developed UNIX shell script to automate notification of Emails, to the users when a process fails in production.
• Worked with SQL loader and control files to load the data in different schema tables.
• Involved in the database administration and creating objects such as database, users, schema and table spaces.
• Involved in managing security, granting and revoking privileges on database objects
• Performed regular backups on the database using RMAN utility.
• Created some Custom reports and Forms for the end users to check the details and errors.
• Involved in production support by efficiently debugging the production issues.
• Coding, testing and documentation for Oracle Apex along with operational and system level documentation
• Worked on XML data, customer data used oracle in built XML functions for parsing andvalidating the XML data.
• Worked on Oracle Apex for the application user interface design and development

Environment: Oracle 10g,11g( TOAD for My SQL, TOAD, Control M 6.2.01,CVS Pro*C,, UNIX, Windows NTWindows,SQL Navigator, XML,MS Outlook 98,MS Office 2000.

Confidential

Oracle Developer

Responsibilities:

• Involved in incorporating additional functionality in the standard Oracle forms using Custom.pll.
• Used Ref Cursors in the Employee New Hire Packages for faster retrieval of information.
• Developed Year End reports using Sub queries, functions and procedures in PL/SQL and Oracle Reports Developer.
• Developed triggers and indexes for efficient data management.
• Developed ad hoc reports for the management using Discoverer Administrator.
• Created End User Layer for Discoverer Reports, migrated seeded and custom business areas to the new EUL.
• Defined expense report types that control reimbursement for different groups of employees.
• Modified existing API’s using PL/SQL procedure, triggers and functions in the Human Resources module.
• Used triggers to maintain Database integrity.
• Developed control files for SQL Loader and PL/SQL programs for loading and validating the data into the interface tables from the Legacy system.
• Performed Data Validations, Data Conversions for bringing the data from legacy system to Interface Tables.
• Performed SQL Tuning of existing procedures, packages and functions for faster query execution using TK Prof and Explain Plan utilities.
• Involved in setting up unit testing, integration testing and system testing to test the code functionality.
• As a part of a team, successfully completed the design, development and implementation of the system.
• Designed and Developed Staging tables, Data Conversion SQL Loader Program and Custom PL/SQL API to import the Items, Item Categories, Item Revisions & Open Purchase Orders from legacy system.
• Coded PL/SQL scripts to implement triggers and functions for various packages.
• Validation of data and inserting into Interface tables.
• Used Dynamic SQL statement for run time SQL query processing.
• Developed reports using XML/BI Publisher.
• Tested SQL code and PL/SQL and wrote indexes for efficient execution times.
• Setup testing for Module and Integration Settings.
• Documented the work by creating various reference manuals for reference by future testers and users.

Confidential

Oracle Technical Consultant

Responsibilities:

• Involved in developing & modifying SQL and PL/SQL tables, Packages, Functions, Procedures, cursors, views, indexes and database triggers.
• Developed PL/SQL packages, to enter data for the Customers Enrolled in the Health Insurance Policy.
• Developed tables with partitions and created indexes, constraints, triggers, synonyms, database links, table spaces, roles etc in different schemas.
• Created scripts to load the data into staging tables from other database using DBlinks.
• Created stored procedures with cursors to load the data from staging to analysis tables.
• Worked with various complex queries with joins, sub-queries, and nested queries in SQL queries.
• Developed UNIX shell script to automate notification of Emails, to the users when a process fails in production.
• Worked with SQL loader and control files to load the data in different schema tables.
• Involved in the database administration and creating objects such as database, users, schema and table spaces.
• Involved in managing security, granting and revoking privileges on database objects
• Performed regular backups on the database using RMAN utility.
• Created some Custom reports and Forms for the end users to check the details and errors.
• Involved in production support by efficiently debugging the production issues.
• Coding, testing and documentation for Oracle Apex along with operational and system level documentation

Environment: Oracle 10g,11g( TOAD for My SQL, TOAD, Control M 6.2.01,CVS, UNIX, Windows NTWindows,SQL Navigator, XML,MS Outlook 98,MS Office 2000.