summary

• Over 6 years of experience as Oracle Developer in development and production environments.
• Extensive working experience in Oracle Database 11g/10g/9i . SQL, PL/SQL, Stored Procedures, Functions, Ref Cursors, Constraints, Triggers, Indexes, Views, Materialized Views, SQL Loader.
• Used range and list partition technique for larger table partitioning.
• Substantial development experience in creating stored procedures, PL/SQL Packages, Triggers and Functions. Strong knowledge in Oracle cursor management and exception handling.
• Worked in debugging and Tuning the PL/SQL code, Explain plan, tuning queries and optimization for the Oracle database.
• Exposure in using CASE tools like TOAD, PLSQL Developer and SQL Developer for writing PL/SQL programs.
• Extensive experience in Database query and Performance tuning Explain Plan and TKPROF utility of Reports and troubleshooting Oracle Application issues on OLTP and DSS systems.
• Expertise in design, development and deployment of end user screens and reports using Oracle tools, Oracle Forms 10g/9i/6i/4.5, Reports 10g/9i/6i/2.5.
• Experience of Data modeling both transactional OLTP and dimensional OLAP .
• Good knowledge in using data modeling tools like ER-WIN and ER diagrams with Modelmart exposure. Normalization Techniques for designing database with Relational technology on N-Tier Architecture.
• Experience in Oracle supplied packages, Dynamic SQL, Records and PL/SQL Tables.
• Experience in using several built in database packages as DBMS JOB, DBMS OUTPUT, UTL FILE and DBMS SQL are few to be named.
• Loaded Data into Oracle Tables using SQL Loader.
• Experience in creating master detail forms and adding Alerts.
• Experience in Deploying Forms and Reports on the web.
• Experience in query optimization, Performance Tuning PL/SQL using SQL Trace, TKPROF, Explain Plan, Indexing, Hints, Bulk Binds, BulkCollect, Creation of global temporary tables and table partitioning.
• Making changes to the existing APEX applications in the production.
• Good knowledge of Java, C, C and ASP.NET.
• Good experience in UNIX Shell Scripting and Python.
• Expertise with all ODI tools - Topology, Security Manager, Designer and Operator.
• As a professional developer involved in code review of all the team members.
• Superior communication, presentation, analytical and problem solving skill. Work well with all levels of business.
• Highly analytical thinking with demonstrated talent for identifying, scrutinizing, improving, and streamlining complex work processes.

TECHNICALSKILLS

• Databases: MySQL, ORACLE 9i/10g/11g, Oracle forms 10g/9i/6i, Oracle reports 10g/ SQL Server 2005, Microsoft Access.
• Programming languages: C, C , JAVA, MATLAB, UNIX and VHDL.
• Web Technologies: Java Script, CSS/CSS3, HTML/HTML5, PHP.
• Operating systems: Win Xp, Vista, Win 7 and Mac Os.
• Development Tools: TOAD, PLSQL Developer., SQL loader, SQL plus, Oracle Enterprise Manager OEM , Dream weaver, Eclipse, VM ware.

PROFESSIONAL EXPERIANCE

Role: Oracle developer/Associate Tech. Specialist

Description: Confidential. is an American multinational telecommunications corporation. As an oracle developer created tables for ordering systems. Main job was to see the tables created for the systems are taking the orders correctly without any flaws. Created parent and child relations to tables. Worked for production support to update the data base instances when the orders were not flowing correctly. Used K shell to find in which system the error is in and created fixes for them.

Responsibilities:

• Involved in the continuous enhancements and fixing of production problems.
• Resolved different kinds of tickets issued to us which involved in UNIX shell scripting, modifying database tables, hands on UI changes using HTML5.
• Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
• Developed PL/SQL triggers on master tables for automatic creation of primary keys.
• Created scripts to create new tables, views, queries for new enhancement in the application using TOAD.
• Created indexes on the tables for faster retrieval of the data to enhance database performance.
• Upgraded Oracle 10g to 11g software in different environments for latest features and also tested databases.
• Developed and modified triggers, packages, functions and stored procedures for data conversions and PL/SQL procedures to create database objects dynamically based on user inputs.
• Performance tuned the interfaces, queries through use of indexes, ranks, Oracle hints, exchange partitions etc.
• Wrote SQL, PL/SQL, SQL Plus programs required to retrieve data using cursors and exception handling.
• Provide technical support for database maintenance and disaster recovery.

Environment: Oracle 10g/11g,K-Shell, PL/SQL, SQL, SQL developer, SQL Loader, TOAD, Soap UI.

Confidential

Role: Oracle Developer

Description: Reinsurance Group of America, Incorporated NYSE: RGA , which is an international global life and health reinsurance company. As the Oracle Database Developer for the project performed development activities to design and develop relational databases in Oracle Real Application Clusters RAC and Linux environment. The Database environment for the project is Oracle and provided technical support and suggest the best hands on practices and demonstrated hands on experiences to guide team to develop a secure database application as per the client's security policy.

Responsibilities:

• Performed database and query tuning and performance monitoring.
• Monitored growth of data and managed space allocation accordingly.
• Enforced database integrity using primary keys and foreign keys.
• Creating and managing schema objects such as tables, views, indexes, procedures, triggers maintaining Referential Integrity.
• Used Cursors both implicit and explicit to capture many rows within a PL/SQL block.
• Used TYPE and ROWTYPE for anchoring the variables to the database data types.
• Used package like DBMS JOB to determine if there are any jobs that are to be performed, or any changes are made to the program or procedure.
• Backup strategies, scheduling the backups. Backing up and restoring the databases for the needs necessary.
• Actively involved in coding SQL statements in PL/SQL.
• Developed various Complex Queries, Views for Generating Reports.
• Fine-tuned the logic in Procedures, Functions and Triggers for optimum performance.
• Performed off site on call 24x7 production support for Oracle 10g database administration activities.
• Extensively involved in writing PL/SQL code for stored Procedures, Functions, Packages, Libraries and other database triggers etc. Written interfaces to transfer/interact data with various external systems.
• Trouble shooting performance issues using Explain Plan and TKPROF.
• Created public synonyms on the database links for easy reuse.
• Used built-in functions in oracle forms.
• Used Quest TOAD to tune query performance.
• Created database links to retrieve data from multiple servers.
• Made Forms customization on various existing forms.
• Used EXPORT/IMPORT to do table level and full database de-fragmentation.
• Created Parameterized Reports and Customized Existing Reports for presentations using Cross-Tab reports and Sub-reports and Running Totals/Formulas in crystal report.
• Created layout wizard and data block wizard in oracle forms.
• Managed Table spaces, Rollback segment, Indexes for various applications like Financials Accounts, Inventory Control System and Payroll Personnel Administration System.
• Created and customized UNIX shell scripts for automating regular maintenance and batch jobs.

Environment: Oracle10g/11g, Oracle Applications R12/11i, SQL, PL/SQL, Toad for Oracle, SQL Plus.

Confidential

Role: Oracle Developer

Description: FedEx provides customers and businesses worldwide with a broad portfolio of transportation, e-commerce and business services. They offer integrated business applications through operating companies competing collectively and managed collaboratively, under the respected FedEx brand. Managing the data base of the products and writing queries to extract the exact data required with user access to front end to see the details of the product and client.

Responsibilities:

• Involved in the maintenance and enhancement of the application.
• Maintained good rapport with Business Analyst Business Users to identify information needs as per business requirements.
• Document the business process flows.
• Schedule meetings and present technical issues to business users and developers.
• Performed discussions with data modeler to update the data model for new requirements.
• Extensively developed complex PL/SQL packages for Invoice Processing.
• Designed/developed tables, views, various SQL queries, stored procedures, functions.
• Involved in PL/SQL code review and modification for the development of new requirements.
• Extensively worked with Dynamic SQL, Composite data types Global Temporary Tables.
• Used Pl/Sql tables, array structures as a part of oracle collections.
• Involved in partitioning of very large tables. Used list and range partitioning.
• Associated with DBA in monitoring the performance related issues using Explain plan, SQL Trace and TKPRO Futility.
• Create maintained box jobs using Shell Scripts.
• Developed scenarios for Unit, Integration testing to ensure that all the components work correctly when integrated.
• Communicate issues and progress to project manager.
• Solving day-to-day problems, giving support to the users.
• Worked with Dynamic SQL, Global Temporary Tables.
• Used PL/SQL Tables, Ref Cursors to process huge volumes of data and used bulk collect and bulk bind for mass update as performance improvement process.
• Import/Export utility is used for transforming data from one place to another from testing to Production.
• Involved in SQL Tuning by creation of indexes, rebuilding Indexes using Explain Plan, SQL Trace and TKPROF Tools.
• Prepared the procedures to update the internal structures to reflect the newly loaded data. Created the materialized views.
• Involved in Production Support and troubleshooting data quality and integrity issues

Environment: Oracle 10g/11g, Oracle Applications 12/11i, SQL, PL/SQL, Toad for Oracle, SQL Plus.

Confidential

Role: Oracle developer

Responsibilities:

• Custom tables and new custom objects were designed as per business requirements.
• Created database Triggers to validate complex integrity.
• PL/SQL Procedures, Functions,Cursors, Triggers and Packages were created using TOAD.
• Developed and maintained Oracle Forms and Reports for various applications using SQL Plus and PL/SQL.
• Developed PL/SQL procedures to support Forms and perform standalone functions.
• Developed complex SQL Coding and used in creating Reports and Forms.
• UNIX shell scripting was used for scheduling batch jobs. The system was used to run batch processes and reports that utilized PL/SQL and Oracle Reports.
• Responsible for SQL Tuning using Explain Plan and SQL trace facilities.
• Performed unit testing and Integration testing for the scenarios mentioned in the test scripts.

Environment: Oracle 10g, sql developer, Solaris, Reports 6i, Forms 6i, TOAD, SQL Loader, PL/SQL, SQL Plus.

Confidential

Role: Oracle Developer

Responsibilities:

• Involved in Database Design and Analysis.
• Analyzed and Created Partitions on the tables to improve the performance and enhance parallel processing.
• Design and Developed data validation, load processes using PL/SQL, Stored Procedures, Functions, and Triggers using Oracle 10g.
• Created Control Files and used SQL Loader to upload bulk data into database from external files.
• Actively involved in Production Support by Performing Tests, Trouble Shooting and Bug Fixing.
• Involved in formulating general methodologies, naming conventions and coding standards for various procedures and packages
• Involved in Code Standardization and Documentation.
• Involved in Logical and Physical Database design. Identified the tables and relationship between tables.
• Used for all and bulk collect to fetch large volumes of data in PL/SQL objects.
• Involved in database Performance Tuning and monitoring.
• Designed Report output formats, complex filtering and formula calculations, as well as the rendering of multi-band and multi-grouped reports.
• Developed complex triggers in reports before/after for validation of user input.
• Coordinated between management, users and technical teams for Requirement Gathering
• Involved in various activities like preparation of Technical Documentation, Client Discussions for purposed solution and User Acceptance Testing.

Environment: ORACLE 11g/10g, Reports 6i/9i, PL/SQL, SQL Loader, SQL plus.