SUMMARY

• 6+ years of experience in various phases of Software Development life cycle, including Designing, Development, Testing and Production Support using Oracle SQL, PL/SQL, and UNIX.
• Expertise Oracle, SQL, PL/SQL, Oracle Forms, Oracle Reports
• Experienced in working with utilities like SQL*Loader, External Tables, Import, Export to extract and load large volume of data.
• Extensive experience in Application development using Oracle Forms and Reports.
• Experienced in performance tuning using SQL Trace - TKPROF and Explain Plan.
• Developed various Unix Shell Scripts to manipulate data files, set-up environment variables, custom FTP utility, file archiving.
• Extensive work experience on Oracle 11g/10g/9i/8i, SQL server databases on UNIX, Linux and Windows enterprise platforms.
• Proficient in translating business requirements into logical data models, creating modularized enterprise applications
• Experience in interacting with users, analyzing client business processes, documenting business requirements, performing design analysis and developing technical design specifications.
• Experienced in using pl/sql,sql developer tools like TOAD, pl/sql developer
• Strong experience with Unix Shell Scripting (KORN, Bash).
• Providing assistance in logical/physical data modeling using ERWIN.
• Performance tuning using Explain Plan, SQL-Trace, TK-Prof oracle utilities and creating relevant system and users documentation
• Worked on Production Support, receiving production calls, troubleshooting the application and resolving bugs.
• Excellent analytical, problem solving, communication and interpersonal skills, with ability to interact with individuals at all levels.
• Ability to work in teams and independently with minimal supervision to meet deadlines.
• Experience in Dataware housing Management
• Strong understanding of object-oriented JavaScript
• Good knowledge in XML, HTML and CSS
• Excellent communication and interpersonal skills with the ability to manage responsibilities individually or as part of a team
• Demonstrated high learning ability with regard to new skills such as programming languages and application tools/software.
• Strong troubleshooting and Organizational skill, independent, self-managing and teamwork.
• Excellent communication, inter personal and business analytical skills, and ability to learn new concepts in a fast paced environment.

TECHNICAL SKILLS

Operating Systems: Windows 98/NT/2000/XP/2003, MS-DOS, UNIX

Languages: SQL, PL/SQL, Shell Scripting, XML, Delphi, C, C #, HTML

RDBMS: Oracle 9i/10g/11g, MS Access

GUI: Oracle Forms 6i/9i/10g, Oracle Reports 6i/9i/10g, Crystal Report, XML Publisher

Utilities: Toad, SQL*Plus, SQL*Loader, PUTTY, MS Office, Winscp, SQL Developer

PROFESSIONAL EXPERIENCE

Confidential, Dallas, TX

Oracle PL/SQL Developer

Responsibilities:

• Worked with various functional experts to implement their functional knowledge into working procedures.
• Developed application and database triggers, functions, procedures, and packages in PL/SQL, Oracle10g as back-end.
• Creation of database objects like tables, views, procedures, packages using Oracle tools like SQL Loader, SQL* Plus and PL/SQL.
• Created various SQL and PL/SQL scripts for verification of the required functionalities.
• Created Records, Tables, Objects, Collections (Nested Tables and Varrays), Table Partitioning and Error Handling.
• Worked on optimizing existing procedures and functions using PL/SQL.
• Worked on User Exit, Dynamic SQL and PL/SQL block in PL/SQL.
• Created various Database triggers using PL/SQL.
• Involved in Performance Tuning.
• Have converted old data from Flat files to Oracle database Using SQL * Loader
• Developed screens and reports using OracleForms 10g/Reports 10g
• Designed and developed user interfaces for customers using Oracle 9i/10g Forms Builder.
• Wrote various kinds of SQL queries involving Correlated Sub queries, UNION, Inner and Outer Joins
• Developed UNIX Shell Scripts and PLSQL procedures to import and export data.

Environment: SQL, PL/SQL, Unix Shell Scripting, Oracle 10g, Toad, SQL*Plus, SQL*Loader, PUTTY, MS Office, Windows XP, Oracle Reports 10g, Oracle Forms 10g

Confidential, Atlanta, GA

Oracle PL/SQL Developer

Responsibilities:

• Wrote PL/SQL Stored Procedures, Functions, Packages and Package Constructors to enforce Business rules.
• Extensively used Cursors, Ref Cursors and Exceptions in developing Packaged Procedures and Functions. Built and tested scripts, PL/SQL packages, procedures, triggers, and functions.
• As a team member interacted with Business Analysts, Data architect and client representatives for requirements gathering, research and solving client specific data issues.
• Written complex SQLs and procedures using joins, sub queries and correlated sub queries. Tuned the queries and stored procedures for better performance.
• Created different schemas and maintained schema objects. Created programming code using advanced concepts of Records, Collections, and Dynamic SQL.
• Extensively used UTL FILE an oracle built in function to transfer data from the source system to flat files to conversion staging area. Utilized Partitions to fine-tune SQL data load.
• Optimized SQL and PL/SQL performance using Oracle utilities like Explain Plan, SQL-Trace Analysis and TK-Prof.
• Involved in creating Database Design Relational models using ERWIN.
• Extensively used EXTERNAL TABLES for data conversion in staging area before loading the data into the respective dimensional and fact tables.
• Created control file scripts and used SQLLDR to load data into the staging table.
• Implemented complex Interface business rules using Oracle Database Triggers constructs.
• Extensively used dynamic SQL. Used INDEXES AND HINTS for better performance of queries.
• Extensively wrote UNIX Shell scripts for clean-up, logging, file manipulation and to automate the data load from SQLLDR to staging table.
• Created database tables, views, indexes and constraints Used Toad as an advanced SQL-PL/SQL editor. Performed functional testing for the procedures and packages.
• Involved in creating INDEXES to avoid the need for large-table, full-table scans and disk sorts, and for fast retrieval of data from database objects.
• Involved in generating Web Intelligence Reports to satisfy Ad-Hoc request.
• Participating in code walk through and review sessions with the Development and QA team.

Environment: Oracle 9i/10g, Oracle 10gR2,SQL* PLUS, PL/SQL, CVS, TOAD, SQL SERVER 2005/2008, Microsoft Visual Studio, ERWIN, Version Control, Windows XP, UNIX.

Confidential, NY

Oracle PL/SQL Developer

Responsibilities:

• Creating database objects like tables, synonyms, sequences and views
• Created, edited procedures and functions to suite the improved business requirements
• Created records and nested tables in the procedures for handling of data
• Used SQL Loader to load data into the database coming from Knipper and FICO
• Used export/ import and expdp/impdp database utilities for data transfer
• Coded complex SQL queries to retrieve data from the database depending on the need
• Created Cursors and Ref cursors as a part of the procedure to retrieve the selected data
• Made use of Bulk Collect feature to process the data from cursor/ Ref Cursors
• Creating and working with GTT (Global Temporary Table)
• Made use of Sub query-Factoring (WITH clause) to make complex SQL statements simple and make them more efficient
• Using set operators in PL/SQL like Union, Union all, Intersect and Minus
• Worked DBMS UTILITY.FORMAT CALL STACKandDBMS UTILITY.FORMAT ERROR STACK
• Performed exception handling for the procedures created
• Written and edited shell scripts to automate the execution of the procedures and report the results through e-mail
• Experience in resolving anomalies in the production database
• Created indexes for faster retrieval and improved query performance
• Worked with performance tuning tools like Oracle optimizer, explain plan, hints to improve the database performance
• Support for the development, test and the production databases
• Used SQL plus and TOAD to develop database applications
• Documentation of the technical work done

Environment: Oracle 9i (SQL, PL/SQL), Oracle Developer Suite 10g, oracle forms 9i/11g, oracle reports 9i/11g, TOAD 9.0, Erwin 4.0, UNIX, VSS

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Analyzed the Business requirements of the project by studying the Business Requirement Specification document.
• Prepared program specifications for PL/SQL Procedures and Functions to do the data migration and conversion.
• Worked with wide range of data types, tables, index types and scoped variables.
• Creation of database objects like Tables, Views, Packages using Oracle tools like PL/SQL, SQL* Plus, SQL*Loader.
• Designed the front end interface for the users, using Forms 6i
• Involved in database development by creating Oracle PL/SQL Functions, Procedures, Triggers, Packages and Records.
• Run batch jobs for loading database tables from Flat Files using SQL*Loader.
• Developed necessary reports using Reports 6i.
• Created number of database Triggers using PL/SQL.
• Implemented project at client place.

Environment: Oracle 9i, Oracle Forms 6i, Reports 6i, SQL Loader, UNIX, Putty, Toad, SQL*LOADER

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Designed, created and maintained the database.
• Used tools like SQL *Loader to load the data into the database tables from flat files and excel sheets.
• Designed Logical and Physical Models using Erwin, TOAD and ER diagrams.
• Created control files for fixed length data, variable length data and for data that has to be inserted in multiple tables within a database at a time.
• Used SQL*Plus to perform DML operations for small updates
• Performed several tasks like migrating data from one database to another, filtered and retrieved the data based on the requirements and submit them as reports.
• Customized different modules of reports after upgrade process using MS Access.
• Developed and facilitated implementation processes for requirements gathering, analysis, planning, tracking and delivery using MS Office.
• Developed Data entry, query and reports request screens and tuned the SQL queries.
• Actively involved in preparing Technical and Business documentation for the application in design, which could serve as future reference to the programmers and system developers.
• Developed customer strategies and improve business performance.
• Involved in programming, debugging, and unit and system integration testing of modules.

Environment: Oracle 9i, SQL*Plus, SQL*Loader, MS Word, MS Excel, MS SQL Server 8.0, MS Office Suite 2003, Erwin, MS Visio 2003, MS Access 2003,Crystal Reports.