SUMMARY:

• Over 8 years of experience in Information Technology with expertise in Database Development, Implementation, Maintenance and Support.
• Experience in Client Server and Web applications using SQL, PL/SQL, Oracle Forms/Reports, PERL, and Shell Scripts and relational databases like Oracle 9i/10g/11g on UNIX and Windows platforms.
• Have knowledge in all aspects SDLC methods including architecture, analysis, design, development, testing, implementation and maintenance of application software in client/server and Multi - tiered environments.
• Experienced in SQL*Loader, External Tables, Import, Export, Optimization using Analyze, Explain Plan, TKPROF, snapshots.
• Used supplied packages to extend the functionality of PL/SQL programs such as DBMS JOB for scheduling, UTL file to read and write from database, DBMS SQL to write dynamic SQL etc.
• Experience in interacting with users, analyzing client business processes, documenting business requirements, performing design analysis and developing design specifications.
• Experience in retrieving data from Business Objects Universes, Personal Data Files, and Stored Procedures.
• Proficient in designing, modeling, creating and maintaining Oracle database.
• Excellent Knowledge in creating complex reports by linking data from multiple sources, using functionalities like Slice and Dice, Drill Down, Master Detail.
• Good experience in gathering requirements, data modeling and database design.
• Excellent Analytical and Problem solving skills.
• Ability to perform well as a Team member and as an Individual, with dexterity to blend well in any situation and environment.

WORK EXPERIENCE:

Confidential

Oracle DBA/ PL SQL Developer

Responsibilities:

• Design and implementation of backup and recovery strategy using RMAN.
• Administration of 11g Data Guard for high availability.
• Involved with installation and maintenance of ORACLE 11g RAC database for high availability.
• Performance tuning for Oracle Real ApplicationClusters (RAC).
• Disaster recovery using Standby database and Database cloning.
• Configured ASM file system and administered ASM Instances and Disk Groups in RAC.
• Monitoring database health by scheduling shell scripts through cron jobs.
• Designing Logical and Physical Layout of the databases.
• Enforcing data integrity constraints on the tables in accordance with data model.
• Performance tuning of SQL statements using Explain Plan, SQL Trace and Tkprof.
• Creating snapshots, database links that are required for distributed databases.
• Responsible for creating new indexes and analyzing tables and design the queries to improve the query performance.
• Monitoring daily refresh of reporting databases.
• Responsible for the scheduling of the batch programs.
• Supporting the database full time during the batch programs, analyzing the failure of the batch program and escalating the issues to the corresponding teams.

Confidential

PL/SQL Developer

Responsibilities:

• Coordinated with users to collect requirements and wrote Complex Packages, Procedures, Functions and Triggers for implementing that Business Logic in PL/SQL.
• Created the Detail Design Documents based on the requirements.
• Created tables, indexes, constraints, triggers, synonyms and database links wherever needed.
• Created adhoc reports using sql queries as per the requirements.
• Used Dynamic sql to create run time Temporary Tables.
• Wrote PL/SQL code for Data Archiving.
• Extensively used Partition Exchanging and dropping for the Data Archiving process.
• Wrote stored procedures and functions for disabling and enabling the triggers for a service request.
• Made use of the PL/SQL WRAP utility for encrypting the codes for security purpose and to make it portable across platforms.
• Wrote Test Plans and Test Cases for the verification of the code changes, jobs enhancements.
• Wrote Shell scripts for handling the calling pl/sql code.
• Worked with the Business Analyst and the Business Users to coordinate the User Acceptance Testing.
• Participated in the weekly status meetings, code reviews and requirements gathering meetings.

Confidential

PL/SQL Developer

Responsibilities:

• Interacting with Business Users to understand the Business requirements.
• Created adhoc sql queries and reports as per user requirements.
• Performance tuned applications and pl/sql procedures.
• Implemented packages, functions and procedures using Dynamic SQL.
• Developed customized scripts to extract data for downstream systems using UTL FILE package.
• Created and altered database objects like tables, views, sequences and synonyms.
• Responded to the user queries and weekend production support calls.
• Worked closely with DBA group in doing the database refresh and backup’s for the database.
• Produced Design Documents and Test plans.
• Developed shell scripts to extract the data from text file and load the records to staging tables.
• Developed wrapper scripts to invoke batch jobs using ControlM command line utility.
• Developed shell scripts to send auto emails based on pre defined events.
• Worked with External Tables, sql * loader and creation of control files.
• Scheduled and Monitored Daily, Weekly and Monthly jobs using BMC Citrix.
• Used SQL Loader to load files received everyday from Trade Agents.
• Created procedures to summarize data based on year parameter.
• Coordinated with the Business Analyst in filling out the Business Unit Approval forms during turnovers.
• Maintained the versions of files for the source code using Serena PVCS.
• Created Change Requests for the turnover of codes.
• Created tickets for notifying job failures using the HP Service Center.
• Wrote Test Plans and Test Cases for the verification of the code changes, jobs enhancements.
• Worked with the Business Analyst and the Business Users to coordinate the User Acceptance Testing.

Confidential

Oracle Developer

Responsibilities:

• Wrote Complex Packages, Procedures, Functions and Triggers for implementing Business Logic in PL/SQL using Toad.
• Created Database Triggers in PL/SQL to accommodate for data integrity and additional Referential Integrity.
• Developed new Oracle Forms as per the design documents.
• Responsible for Analysis, Design, Development/Customization and Testing/debugging of the reports.
• Expertise in Unix environment and shell scripting. Excellent knowledge in Batch Jobs using UNIX CRON, AWK UNIX Shell Script (csh, bash, ksh) and API’s Using PERL Scripts.
• Designed and implemented client-server application using Oracle Forms.
• Developed the new reports from scratch for the application utilizing Oracle Reports
• Converted reports to browser supportable XML format.
• Created the indexes to optimize the performance of the data retrieval process.
• Tuned stored procedures and triggers identified for better performance.
• Responsible for writing test plan documents and unit testing for the application modules.
• Wrote Shell Scripts, control files to load data into DW tables.
• Effective Interaction with Support and other Application groups through on call for high priority issues.
• Analysis of customer reported issues, which could be a code issue, data fix issue, performance issue, setup issue, functional issue or an RDBMS issue.
• Used SQL*Loaders to download the data into warehouse database from the flat files and other data files across different platforms.
• Transported tablespaces between databases using Import and export utilities.

Confidential

PL/SQL Developer

Responsibilities:

• Involved with Client engagement, Business Requirements elicitation, Business & Data Analysis, software configuration and customization.
• Attended regular walkthroughs with Clients and Developers.
• Analyzed, designed, optimized and tuned PL/SQL Procedures, Oracle Stored Procedures and used SQL*Loader to load the Historical data into the data warehouse.
• Built triggers to log the information about users and the operations they perform in their session. Developed procedures to load data from staging tables to target tables.
• Extensively worked on performance tuning of the load process using Explain Plan and DBMS STATS package.
• Involved in design, implementation, and deployment of Forms using Forms 6i.
• Involved in generating new reports using Reports 6i and Report Templates.
• Involved in preparing documents, fixing bugs, and improving the performance by working with development and testing team.
• Performed testing of various packages, functions and procedures to check the functionality and to develop Test cases.
• Involved in developing and running K-Shell scripts to download and upload data between different hosts as well as created a FTP Process Shell Script which dumps file from remote server which is schedule using Crontab Utility.
• Developed Oracle Forms and Reports as per the requirements.
• Supported production requests on ad-hoc basis in production environment.
• Created various Documents like Source to Target Data mapping Document, Unit Test Cases and Data Migration Document.

Confidential, Reston, VA

Oracle Developer

Responsibilities:

• Coordinated with users to define and design needs, developed technical solutions ensuring software integrity.
• Extensively developed PL/SQL Procedures, Functions, Triggers and Packages.
• Created tables, indexes, constraints, triggers, synonyms, database links etc.
• Developed web based front-end screens using Forms 6i. Data was loaded in to forms using Data Loader.
• Used Execute Immediate, UTIL FILE (file handler), DBMS JOB, DBMS ALERT and other utility BUILT-IN packages in PL/SQL.
• Developed master-detail, matrix, and nested summary detail reports, using Reports builder and Discoverer.
• Developed Database Triggers to enforce security.
• Analyzed and prepared Statement of Work and Requirement Definition Document.
• Wrote Unix shell scripts for automating batch jobs.
• Troubleshooting performance issues and fine-tuning queries and stored procedures.
• Implemented basic replication using snapshots.
• Developed Test Plans and tested the application to ensure proper functionality, data accuracy, and that modifications have no adverse Impact on integrated system environment.

Confidential, Clinton, NJ

Oracle Developer

Responsibilities:

• Involved in dumping data from international data warehouse to domestic data warehouse.
• Involved in writing and executing stored procedures, functions, and packages for products, bookings, invoices, customers and Sales men in PL/SQL and database triggers.
• Created packages, functions and procedures using Dynamic SQL.
• Used SQL Navigator to develop and debug PL/SQL and create, execute and optimize SQL queries.
• Generated reports using Pro*C and PL/SQL packages.
• Created and executed Perl programs to manipulate the database.
• Created and build the shell scripts to run the batch processes and scheduling the jobs at nightly, weekly and monthly base.

Confidential

Oracle Developer

Responsibilities:

• Involved in system study, development and implementation of the project.
• Servlets coded to act as Controllers and Dispatchers between JSP and Beans.
• Developed several PL/SQL stored procedures, packages and triggers.
• Developed GUI using HTML and JSP for dynamic page generation.
• Designed and developed dynamic menus using DHTML and CSS.
• Extensively used JavaScript for Server-side and for client-side validations.
• Involved in unit and integration Testing.