SUMMARY

• 8+ years of experience in complete Software Development Lifecycle (SDLC) using Oracle Exadata /11g/10g/9i/8i on Windows and UNIX platforms in the phases of Analysis, Designing, Development, Production support and Testing
• Thoroughly worked in creating, debugging and testing Procedures, Functions, Triggers and Packages using Oracle PL/SQL
• Extensively involved in writing SQL Queries (Sub queries and Join conditions), PL/SQL subprograms and Query Level Performance tuning.
• Experienced in Tuning the application using Explain plan and SQL Trace to optimize the cost and for higher efficiency.
• Extensive experience in Database query tuning, Performance tuning (HINTS, EXPLAIN PLAN and TKPROF utility) of Reports and troubleshooting Oracle Application issues on OLTP and DSS systems.
• Expert in Client - Server application development using Oracle 11g/10g/9i/8i, PL/SQL, SQL *PLUS, TOAD, SQL *LOADER.
• Experience in implementing ETL using Oracle PL/SQL, SQL LOADER, UTL FILE and UTL MAIL.
• Exposure in using Tools like TOAD, SQL Developer and SQL*Plus for writing PL/SQL Programs.
• Experience in creating complex triggers or generate packages and indexes to increase performance and complex SQL queries for joining multiple tables.
• Extensive experience developing External tables and using Oracle utility tools like SQL*Loader, Import and Export on UNIX platforms.
• Extensively involved in SQL tuning, troubleshooting, debugging and fixing the codes/scripts.
• Experienced in developing and modifying existing UNIX shells scripts and scheduling the jobs using Autosys and Crontab and monitor the batch processing.
• Solid understanding of relational databases.
• Experience with data migration.
• Experience in providing 24x7 production support.
• Worked in onsite - offshore model and experience in leading the technical team
• Energetic self-starter with excellent analytical and problem-solving skills. Good verbal, written, and presentation skill.

TECHNICAL SKILLS

Databases: Oracle 11g/10g/9i/8i/6i, SQL Server 2005/2008

Programming Languages: PL/SQL, SQL, C, UNIX Scripting

GUI Tools: Oracle Forms and Reports 6i/9i/10g, Oracle Enterprise Manager 10g (Grid Control), Oracle Discoverer 10g

Operating System: Windows NT 4.0, Windows Server 2003, Windows Vista/XP, Mac OS X UNIX (Linux, IBM Z, Solaris 9, AIX, HP-UX)

Other Tools & Utilities: SQL*Plus, TOAD, SQL Developer, SQL*Loader, Microsoft Excel, Microsoft Visio, Oracle Job scheduler, Autosys, Clear Case, PVCS, Visual Source Safe, WinSCP

PROFESSIONAL EXPERIENCE

Confidential

PL SQL Developer

Responsibilities:

• Analyzed the requirements and created a logical model of the Oracle database and represented the entity hierarchy and relationship using ER diagrams.
• Design and develop PL/SQL packages, Procedures and Functions, Cursors, Ref Cursors and Triggers.
• Responsible for the modification/enhancements/maintenance in the existing forms and reports to established standards and the deployment on production environment.
• Migrating database and applications to new releases and implemented changes to the Data Model.
• Worked Closely with Data Architect team to design and create scripts for objects such as tables, indexes, views, sequences, object types and collection types.
• Created new database objects like Sequences, Procedures, Functions, Packages, Triggers, Indexes and Views in Development and Production environment using PL/SQL and SQL*Plus.
• Designed Data Flow Diagrams (DFD’s), Entity Relationship Diagrams (ERD)
• Managed schedules and collaborated with different teams working on the project
• Prepared project progress reports and status reports and submitted to the management on an ongoing basis
• Assisted with required data analysis, interpretation, correction and document presentation for various assignments

Confidential

Oracle Pl SQL Developer

Responsibilities:

• Analyzed the requirements and created a logical model of the Oracle database and represented the entity hierarchy and relationship using ER diagrams.
• Design and develop PL/SQL packages, Procedures and Functions, Cursors, Ref Cursors and Triggers.
• Responsible for the modification/enhancements/maintenance in the existing forms and reports to established standards and the deployment on production environment.
• Migrating database and applications to new releases and implemented changes to the Data Model.
• Worked Closely with Data Architect team to design and create scripts for objects such as tables, indexes, views, sequences, object types and collection types.
• Developed UNIX Shell scripts for automating batch processes which manage critical processes of the CRM system.
• Tuned Complex Queries and performance bottlenecks (using Explain Plan, HINTS, DBMS STATS, SQL Trace, TKPROF and SQL Profiler).
• Worked on security track to assess vulnerability
• Version / Controlled Release management using CVS.
• Created new database objects like Sequences, Procedures, Functions, Packages, Triggers, Indexes and Views in Development and Production environment using PL/SQL and SQL*Plus.
• Designed Data Flow Diagrams (DFD’s), Entity Relationship Diagrams (ERD)
• Managed schedules and collaborated with different teams working on the project
• Prepared project progress reports and status reports and submitted to the management on an ongoing basis
• Assisted with required data analysis, interpretation, correction and document presentation for various assignments
• Use materialized views and Cached Query
• De-normalization to improve the performance for OLTP applications
• Effectively use of Indexes

Environment: Oracle 10g/9ig/8ig/6ig, Windows XP, UNIX, HP-UX, SQL, PL/SQL, SQL*PLUS, TOAD, SQL*Loader, Erwin, Oracle Forms 10g and Oracle Reports 10g.

Confidential, Rahway, NJ

Oracle Pl Sql developer

Responsibilities:

• Regular monitoring the production databases and applications for any provisioning issues.
• Opening new Confidential trials in the system and provisioning the users to the Confidential applications.
• Fixing production issues and defects raised by the business users.
• Performance tuning and enhancements of the existing application.
• Deploying the changes on the production database.
• Interacting with the business users and Confidential Leads and Managers daily for smooth execution of the project.
• Document the Run Book.
• Co-ordination between on-site and off-shore team members.
• Daily review of Remedy queue and distribution of tickets between on-site and off-shore team.
• Updating the HCL team site and Confidential team site regularly.
• Code review and co-ordination with testing team.
• Responsible for developing database objects and maintaining database deployment scripts, developing procedures, function and triggers.
• Designed and implemented a plan for all types of data movement or modification requested and approved by management.
• Performance tuning due to Migrating the application from Oracle 10g to 11g
• Created Update statements using Correlated sub queries to convert the data to the new symbiology.
• Involved in tuning the SQL queries, created database objects and optimally set storage parameters for tables and indexes.

Environment: Oracle 10g, Windows XP, UNIX, Solaris, IBM Z, SQL, PL/SQL, Oracle Enterprise ManagerSQL*PLUS, TOAD, SQL Developer, Materialized View,Loader, Export and Import,CDC

Confidential, NY

Consultant

Responsibilities:

• Involved in optimizing database performance by analyzing database objects, generating statistics and creating indexes.
• Used Dynamic SQL for DDL and DML commands in PL/SQL.
• Worked on Oracle Enterprise Manager (Grid Control) to manage and monitor the databases and to perform administrative and maintenance tasks.
• Developed database triggers to maintain audit tables.
• Created Views using a bunch of Joins, Union and minus operators on the reference tables which hold the data’s with new symbology specifications.
• Optimized and modified the triggers and stored procedures based on the business requirements.
• Created and managed External Tables using Oracle Loader and Oracle datapump types to access the data files.
• Performance tuning.
• Creating data flow diagram.
• Designing the feed Architecture.
• Perform reverse engineering.
• Used Export and Import utilities to transfer data objects from production environment for the test environment data refreshes.
• Worked closely with the business analyst and the user community to gather and clarify any business requirements.
• Testing using SOAP after changing the package
• Was actively involved in project meeting. Submitted technical knowledge document to the company’s knowledge portal.

Environment: Oracle 11g/10g, SQL Server 2005, Windows server 2003, Windows XP, UNIX, Solaris, IBM Z, SQL, PL/SQL, Oracle Enterprise Manager, SQL*PLUS, TOAD, SQL Developer, SQL Server Management Studio, Clear Case, SQL*Loader, Export and Import, UltraEdit-32, SOAP

Confidential, NY

Inventory Specialist

Responsibilities:

• Responsible for developing database objects and maintaining database deployment scripts, developing procedures, function and triggers.
• Designed and implemented a plan for all types of data movement or modification requested and approved by management.
• Created and used Table Partitions, Local and Global partitioned Indexes to further improve the performance while using tables containing large number of columns and rows.
• Involved in optimizing database performance by analyzing database objects, generating statistics and creating indexes.
• Used Dynamic SQL for DDL and DML commands in PL/SQL.
• Reviewed Business Requirements, Functional Specifications, and Detailed Design documents (including UML).
• Updated test plans, created test cases and test scenarios for assigned functional areas (including Transact SQL queries for data validation).
• Executed test cases.
• Logged and regressed bugs.
• Created and managed External Tables using Oracle
• Worked closely with the business analyst and the user community to gather and clarify any business requirements.

Environment: Oracle 10g, SQL Server 2005, Windows server 2003, Windows XP, UNIX, Solaris, IBM Z, SQL, PL/SQL, Oracle Enterprise Manager, SQL*PLUS, TOAD, SQL Developer, SQL Server Management Studio, Clear Case, SQL*Loader, Export and Import, UltraEdit-32.

Confidential, Salt Lake

Software Engineer

Responsibilities:

• Data Migration Ms-Access to Oracle 8i.
• Used SQL Loader to Migrate data from to Oracle.
• Understanding the customer requirements, analysis, design, development and implementation into the system, Gather and define business requirements, improve business processes.
• Designed and developed PL/SQL functions, stored procedures, cursors, packages, triggers.
• Involved in performance fine-tuning of the queries, report using PL/SQL and TOAD.
• Involved in Database Design & Data Modeling(ERWIN).
• Designed and developed GUI front-end using Oracle Forms 10g for user interaction with the database.
• Involved in writing complex queries to generate reports as per client request as a part of production support.
• Extensively used the advanced features of PL/SQL like Subtypes, Records, Tables, Object types and Dynamic SQL.
• Involved in optimizing database performance by analyzing database objects, creating indexes, creating materialized views etc.
• Developed Unix Shell Scripts to automate backend jobs, loading data into the Database using SQL* Loader.
• Provide functional requirements to describe system process, as well non-functional requirements to describe performance, scalability, security and usability requirements.
• Optimized different SQL queries to insure faster response time.
• Developed screen layouts, report layouts using Forms and Reports and participated in implementation.

Environment: Oracle 10g/9ig/8ig/6ig, Windows XP, UNIX, HP-UX, SQL, PL/SQL, SQL*PLUS, TOAD, SQL*Loader, ERwin, Oracle Forms 10g and Oracle Reports 10g.

Confidential

Research Associate

Responsibilities:

• Worked extensively in Designing, Developing, and Testing of Oracle PL/SQL and developer6i Forms and Reports.
• Wrote SQL Scripts for creation of database tables, synonyms, sequences and created users, roles and privileges.
• Writing Database Packages, Procedures and Triggers.
• Developed Forms, Menus, PL/SQL Libraries and Object Libraries extensively for code reusability and standardization.
• Worked extensively on the hierarchical model of Forms.
• Developed reports extensively on Oracle Reports 6i and its integration with the Application Forms.
• Written Stored Procedures, Functions and Packages using PL/SQL.
• Designed, developed and programmed interactive software in Oracle PL/SQL stored procedures.
• Converted existing system and codes to windows application (X and Oracle).
• Worked extensively in application development following all phases of system life cycle.
• Provided customer support, training and technical translation.