SUMMARY

• 8 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.
• 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 Oracle developer tools like TOAD, PL/SQL developer
• Extensive experience in Application development using Oracle Forms and Reports.
• 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 teh Application and resolving bugs.
• Excellent analytical, problem solving, communication and interpersonal skills, with ability to interact with individuals at all levels.
• Strong understanding of object-oriented JavaScript
• Ability to work in teams and independently with minimal supervision to meet deadlines.
• Experience in Data warehousing Management

TECHNICAL SKILLS

Databases: Oracle 11g/10g/9i/8.x, MS SQL Server, MS-Access

Languages: SQL, PL/SQL, T-SQL, Shell Script, Batch script, XML

Database Utilities: TOAD 8.5/8.0/7.1, SQL-Developer, PL-SQL Developer, SQL*Plus, SQL*Loader, Import and Export, Explain Plan TKPROF.

Operating System: Windows XP/NT/2000/98/95, Unix

Scripting Languages: Unix Shell Script, Batch File

Front End: Oracle Forms, Reports 6i, VB 6.0

Others: ERWIN, Crystal Report, Oracle Migration Workbench (OMWB), SQL Server migration assistance

PROFESSIONAL EXPERIENCE

Confidential, San Francisco, CA

Oracle PL/SQL Developer

Responsibilities:

• Wrote high-level specifications and detailed specifications.
• Wrote PL/SQL Database triggers to implement business rules.
• Used ETL software to extract, transform and load needed data.
• Gatheird and analyzed business requirements from end users.
• Worked with applications specialists to understand teh new data requirements.
• Collaborated with teh DBA in creating tables required for teh application.
• Used SQL*loader to load teh data from teh files provided by teh interfacing applications.
• Performed staging, and cleansing on data per requirement.
• Wrote PL/SQL Stored Procedures, Functions, and Packages to implement Business Rules.
• Worked with DBA on logical and physical data models, and metadata repository.
• Trained analysts and developers in design tools and data modeling techniques.
• Extensively used SQL to create Insert programs for loading data.
• Modified existing procedures according to new enhancements.
• Performed data partitioning.
• Used explain plan to increase performance of SQL statements.
• Modified SQL statements to increase teh overall performance as a part of performance tuning.
• Merged data from one database to another database.
• Created indexes as a part of tuning.
• Documented every phase like Technical specifications, source to target mappings, data models (using ERWIN), UAT (tests cases and results), and release notes.
• Used Informatica to extract data from different types of sources and load to oracle database.
• Knowledge of full life cycle implementation in building a Data Warehouse.
• DataExtraction Transformation and Loading (ETL) Using Informatica Power center
• Migrated enhancement from appropriate dev Area to Test Areas/prod Areas.
• Issued Grants to teh business users for appropriate DM tables to design their Universes.
• Wrote UNIX shell scripts to load data.
• Interacted with production support team regarding production issues.
• Documented and transferred knowledge regarding teh various projects.
• Attended meeting with business analyst to get new requirements for teh application.

Environment: Oracle 10g/11g, PL/SQL, SQL plus, SQL Navigator, UNIX, Shell Scripts, ETL, Dataware house design SQL Loader, Business Object, IIS, C++, C#,PL/SQL with Pro C, ASP, ASP.NET MS Excel, MS- Visio, ERWin, WinSCP, VI Editor, NDM, Autosys 4.5/4.5.1,HTML,Java script.

Confidential, DE

Oracle PL/SQL developer

Responsibilities:

• Involved in various stages of SDLC like Requirement gathering, high level design, low-level design, Coding.
• Testing, Quality assurance Documentation, Implementation and Project Planning.
• Wrote Package containing several Procedures and Functions in PL/SQL to validate before loading into Application database.
• Worked on sequences, functions, synonyms, indexes, triggers, packages, stored procedures, roles and granting privileges on OLTP server.
• Involved in Creation of tables, Partioning tables, Join conditions, correlated sub queries, and nested queries, views for teh business application development.
• Created temporary tables and developed SQL*Loader control files to load teh legacy data into teh temporary tables.
• Wrote Materialized views and complicated queries using SQL.
• Extensively involved in writing SQL queries (Sub queries and Join conditions), PL/SQL programming.
• Extensively used teh advanced features of PL/SQL like collections, nested table, array& Dynamic SQL.
• Experience with merging data files coming from teh customer into teh existing data warehouse.
• Worked with Oracle Enterprise Manager, Net configuration assistant.
• Logical and Physical data modeling using ERWIN.
• Created teh indexes and analyzed teh table for better performance.
• Experience in using packages like DBMS JOBS, DBMS SCHEDULER to schedule tasks
• Moved teh tables to different table space and rebuild teh indexes.
• Wrote both implicit and explicit Cursors to capture many rows within a PL/SQL block, and applied business rules on them.
• Developed Unix Shell Scripts and loading data into teh Database using SQL* Loader.
• Copying of data from development to test and production by using utilities like Export/Import.
• Used Explain plan and TK PROF for Tuning teh SQL statements by creating indexes. Generated session level trace and used teh TKPROF utility to get teh report for teh trace file.
• Experience with Pl/SQL Tuning using DBMS PROFILER.
• Extensive use of Optimizer Hints to tune teh Sql Queries.
• Worked extensively on Exception handling to error handling and tracking.
• Used PRAGMA AUTONOMUOS TRANSACTION to avoid mutating problem in database triggers.
• Extensive use of Crontab in UNIX environment for scheduling routine tasks.
• Wrote teh shell scripts and scheduled with using cronjob for teh database backups and old archive log deletion. Also done teh logical backup (database structure export only) of teh development instances every day using shell script
• Extensive experience in working different FTP clients like Smart FTP, Cute FTP, SFTP using F-Secure
• Extensively used TOAD for database access and PL/SQL Development and SQL tuning.
• Documented business rules, technical designs, test cases, and user guides.
• Involved in unit testing, integration testing, system testing.

Environment: Oracle 10g, 11g, Windows 2003, PL/SQL, SQL Navigator, SQL*Loader, Redhat 4.1, SQL*Loader, Ervin 4.14, Oracle Enterprise Manager.

Confidential, OH

ORACLE PL/SQL DEVELOPER

Responsibilities:

• Created database objects like Tables, Sequences and Constraints as per teh business requirement.
• Converted SQL server scripts in to Oracle scripts.
• Created database views and materialized views.
• Created database triggers based on business requirement.
• Developed stored functions, packages based on requirement.
• Developed numerous stored procedures which basic input for teh crystal reports.
• Created ref cursors to get teh result set which is used by teh crystal reports.
• Extensively used Toad to create database objects, develop packages and statistics of all SQL queries.
• Converted SQL Server processes scripts in to Oracle scripts.
• Created test scripts documentation for all teh procedures dat me have created.
• Used Mercury Quality Center to write test cases for teh reports.
• Involved in production support, like monitoring teh performance of teh Unix jobs.
• Researching and resolving teh problems occurred with teh Jobs and also involved with teh end user to resolve teh problems.
• Worked with performance tuning tools like Oracle optimizer, explain plan, hints to improve teh database performance

Environment: Oracle 10g, 9i Windows, PL/SQL, SQL plus, oracle forms 6i/10g, oracle reports 9i/10g, TOAD 9.0, Oracle Developer Suite 10g.

Confidential, NY

ORACLE, PL/SQL DEVELOPER

Responsibilities:

• Gathering business requirements
• Creating database objects like tables, synonyms, sequences and views
• Created, edited procedures and functions to suite teh improved business requirements
• Created records and nested tables in teh procedures for handling of data
• Used SQL Loader to load data into teh 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 teh database depending on teh need
• Created Cursors and Ref cursors as a part of teh procedure to retrieve teh selected data
• Made use of Bulk Collect feature to process teh 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 teh procedures created
• Written and edited shell scripts to automate teh execution of teh procedures and report teh results through e-mail
• Experience in resolving anomalies in teh production database
• Created indexes for faster retrieval and improved query performance
• Worked with performance tuning tools like Oracle optimizer, explain plan, hints to improve teh database performance
• Support for teh development, test and teh production databases
• Used SQL plus and TOAD to develop database applications
• Documentation of teh technical work done

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

Confidential, IL

Oracle Developer

Responsibilities:

• Gatheird and analyzed requirements from business analyst.
• Created database objects like tables, synonyms, sequences, triggers, and views.
• Created, edited procedures and functions for improved business requirements.
• Used SQL Developer to Load / Extract data into and from Excel files.
• Used Hints, Explain Plan, and Indexes for query tuning and optimizations.
• Conducted impact analysis and designed structures to enhance performance.
• Involved in data cleaning, merging and conversion.
• Created Test Cases and Technical Design Documents.
• Used Jira and TortoiseSVN for defect creation/resolution and Code repository, respectively.
• Collaborated with Data Warehouse in impact analysis to crystal reports.
• Supported development and test databases.
• Used SQL Developer and TOAD to develop code.
• Scheduled and led progress meetings.

Environment: Oracle 9i, Toad, SQL Developer 2.1, PL/SQL, SQL, WindowsXP

Confidential

Oracle, Pl/SQL developer

Responsibilities:

• Involved in planning, control and implementation of teh DBMS using SDLC
• Developed capacity plan for teh database, estimated teh table sizes.
• Worked with systems and business analysts to design requirement specifications.
• Implemented data integrity validation checks through constraints and triggers.
• Performance monitoring and tuning of SQL code.
• Responsible for creation of new user ids and setting up privileges and policies for Protection of data.
• Wrote functions and stored procedures for order entry and other searching applications.
• Used Borland Delphi to establish connectivity among teh various databases.
• Creation of database objects like tables, indexes and views.
• Developed packages for implementing business logic through procedures and functions.
• Developed UNIX shell scripts to automate routine tasks.
• Responsible for SQL tuning using explain plans and SQL trace facilities.
• Responsible for teh dealing with teh problems, DB bug fixing andtroubleshooting
• Involved in developing Oracle Reports which are further added to Web pages.
• Worked on Erwin Data Modeler for mapping both user-defined and default data types.
• Worked extensively on C for low level programming and embedded work.
• Oracle 10g forms upgrade experience.
• Involved in Performance.
• Used XML for data transmissions from applications.

Environment: Oracle PL/SQL, SQL, UNIX, Korn Shell Scripting, TOAD, UML