SUMMARY:

• Over 6 years of experience in Software Design, Development, Testing and Maintenance of secure, Internet/Intranet and client - server applications.
• Proficient in designing, modeling, creating and maintaining Oracle database.
• Worked on complex queries, PL/SQL packages, functions, stored procedures, triggers, views etc.
• Strong know ledged in Oracle Cursor management, Exception Handling, Collections like REF Cursors, Nested tables, VARRAYS & IOTs.
• Developed database scheduler scripts and applications using Unix shell scripts, PL/SQL, SQL *Plus script.
• Performed of SQL server, Ms-Access, My Sql databases.
• Proficient in XML schema designing,GUI development using Oracle Forms and Reports Developer/2000.
• Worked on Oracle Forms 4.5/5/6.0/6i/10g, Reports 4.5/5/6.0/6i/10g.
• Proficient in Oracle database creation, table space management, creating database links, schemas, profiles and roles, managing control, redo log and data files.
• Involved in exhaustive Performance Tuning, Monitoring and Optimization of PL/SQL blocks in both Development and Production environment, for Oracle and SQL server databases.
• Worked on Inbound and Outbound Interfaces .
• Worked on HTML, DHTML, JAVA, JavaScript, VB Script, and XSL.
• Worked on understanding about Normalization, ISO Standards.
• Adept at all stages of project lifecycle, from business requirements and technical definitions to development, testing, user acceptance testing (UAT), production support, and completion.
• Worked on various oracle tools TOAD, ER-win, SQL Navigator 4.3, Oracle discoverer, Data Modeler, ETL Tools, OLAP Tools, Korn / Perl shell scripts and SQL *Loader.
• Performed on Unix/Windows networking tools plus operating systems like Solaris, HP-Unix, Windows 2000/XP professional/server/advance server.
• Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team

TECHNICAL SKILLS:

Operating Systems: Unix Sun Solaris 7/8/9/10 Windows 00/98/XP Client/Servers,HP-UX/UX 11i v2 and IBM AIX/AIX 6.1

Oracle Databases Versions/RDBMS: Oracle 8i/9i/10g/11g, Informix 10/11/11.5, DB2 9.5/9.7, Sybase ASE 12.5SQL Server 2008, My SQL 5.0/5.1, PowerBuilder 11.5.

Shell Scripts/Program Languages: UNIX Shell Scripts (bourne/korn/c), SQL *Plus, PL/SQL,PL/SQL, XML, XSL, XQuery, Cartridge, T-SQL,Pro *C, Java Script, C, C++, ASP and VB Script.

System Networks: Oracle Net, Windows Servers, OLAP/MSMQ series, ODBCHTML/DHTML, .Net Framework, MessageQ, IBM MQ Series, DCL and CVS

Database Design Tools: Oracle Forms 6i/9i/10g, Reports 6i/9i/10g, PB 4.0/5.0, VB, ASP, Oracle 10g tools, Data Modeler, Crystal Reports Writer 8.0/5.0/4.6,TOAD 9.7, Oracle Discoverer, ER-win, Power Designer 5.0, Oracle Designer 6.0, ETL Tools, ER-Studio, Lotus Notes, Informatica 8.6, JDeveloper

PROFESSIONAL EXPERIENCE:

Confidential, NY

Oracle Developer

Responsibilities:

• Developed PL/SQL Stored Procedures, Functions, Packages and Triggers to implement business rules into teh application.
• Designed and created all teh required tables, indexes, sequences and views using SQL*Plus and Toad.
• Written Procedures to Load Data into data warehouse system.
• Involved in developing Object data types and collections.
• Developed various Complex Queries, Views for Generating Reports.
• Used Hints to Achieve teh Performance and Tuned SQL Queries and Stored Procedures, improved teh performance of teh reports.
• Written SQL scripts for implementation and mentored teh end users
• Responsible for Study, Analysis, Design, Development/Customization and Testing/debugging of teh reports.
• Written Shell Scripts, control files to load data into staging tables and DW tables.
• Developed and Tested applications for loading inventory data into database tables.
• Fine-tuned teh logic in Procedures, Functions and Triggers for optimum performance.
• Involved in Unit testing PL/ SQLStored Procedures andFunctions.
• Involved in using of new features of Oracle 10g like Flash back Query.
• Perform analysis of key requirements and transfer knowledge accordingly to teh end users
• Extensively used PL/SQL Procedures and Functions to transform data before teh loading process.
• Designed and developed dynamic menus using DHTML and CSS.
• Involved in quality assurance of data, automation of processes, programming for data manipulation validation of programming, andpresentation of results.
• Created SQL reports, data extraction and data loading scripts for different databases and schemas.
• Designed Perl scripts to enhance database functionality.
• Loading data from flat files into database tables using SQL* Loader
• Expertise in Unix environment and shell scripting. Excellent knowledge in Batch Jobs using UNIX KORN, AWK UNIX Shell Script (csh, bash, ksh) and API’s Using PEARL Scripts.
• Optimizing database objects and streamlining applications.
• Analysis of customer reported issues, which could be a code issue, data fix issue, performance issue, setup issue, functional issue or an RDBMS issue
• Developed forms and reports using Forms 6i/9i/10g and Reports 6i/9i/10g
• Setting teh data for teh maintenance tables through Maker and Checker.
• Worked on Oracle tools like Oracle Warehouse Builder .which are used for Tuning, Database software, SQL programming in oracle database.
• Involved in XML parsing and loading XML files into teh database.

Environment: SQL, PL/SQL, Oracle9i/10g, Perl, Pro*C, PVCS MS-Word, TOAD, Pearl Scripts,Unix Shell scripting,HTML, XML, Oracle Tools,Reports(6i/9i/10g), Forms(6i/9i/10g), MS-Excel, Edit Plus, WS-FTP, UNIX.

Confidential, Calforina

Oracle Developer

Responsibilities:

• Participated in teh design and development of teh project.
• Created new database objects like Sequences, Procedures, Functions, Packages, Triggers, Indexes and Views in Development and Production environment using PL/SQL, Toad, Dynamic SQL and SQL*Plus.
• Involved in performance tuning of PL/SQL blocks.
• Involved in migration of Ms Access database to Oracle 10g database tables - Client profile migrations using SQL*Loader.
• Developed Unix Shell scripts to automate repetitive database processes.
• Developed korn shell scripts to kick off back end PL/SQL, SQL, Pro*C programs.
• Worked on Oracle Cursor management, Exception Handling, Collections like REF Cursors, Nested tables, VARRAYS & IOTs.
• Involved in writing complex queries to get teh reporting data.
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and Bulk collects.
• Checked to see if databases and data models are in synch or not.
• Developed screens and Forms 10g using Oracle Forms/Reports 6i/9i. Also developed reports using Pro*C and PL/SQL.
• Worked on Data mining by using OLAP tools.
• Also performed Migration to Forms/Reports 9i from Forms/Reports 6i.
• Designed and refined Perl modules and scripts involving various functions wif database.
• Worked on ETL tools to extract and load data from SQL Server, and flat files to Oracle database.
• Involved in Data Migration, Integration and Conversion phases of development.
• Worked on Database Migration from 9i to 10g.
• Handled system utilization issues, performance statistics, capacity planning, integrity monitoring, maintenance, reorganization,and recovery of databases.
• Extensive usage of Oracle 10g Reporting tool.
• Customized teh Forms 10g for functional areas of Financial Management System.
• Preparing documentation for requirements, design, install and Unit testing and System Integration.

Environment: PL/SQL, Oracle 9i/10g, SQL*Plus SQL * Loader, TOAD,ETL Tools, OLAP Tools, Pro*C, UNIX Shell Scripting, Korn shell scripting, Perl, Developer 2000 (Forms 9i/10g and Reports 9i/10g)

Confidential

Oracle Developer

Responsibilities:

• Analysis of Sources data, analyzing teh Oracle Source Objects and identifying teh method for migrating data to target.
• Created and used EXTERNAL TABLES for migrating flat file data into target.
• Identified teh row migration and row chaining rows and modified teh target design to minimize them in teh target.
• Created teh Staging tables to avoid teh lookup on large tables. Developed procedures to load data from staging tables to Target tables.
• Responsible for teh creation of Packages, Functions and Procedures
• Performed Testing of teh Packages, Procedures and Functions.
• Worked on Crystal reports. Worked on troubleshooting of database connectivity and performance tuning.
• Optimized teh performance of teh database queries and involved in De-normalization of teh queries.
• Worked on oracle Discoverer 2000.
• Worked on UTL file utility to transfer data from Oracle application to external systems.
• Exported teh reports into teh required formats
• Developed various Oracle Applications using PL/SQL, SQL*Plus, Forms, Reports, Workflow Builder, and Application Object Library.
• Worked wif users through all Software Development Lifecycle (SDLC) phases
• Wrote technical design documents for conversions, extensions, interfaces, and reports
• Recovered troubleshoot issues, including creation/follow-up of Oracle service requests (SRs). Conducted quality reviews of code developed by other development staff.
• Developed several complex reports using various features like multiple grouping, drill down, parameterized fields, formulas and conditional formatting using Crystal reports

Environment: Discoverer 2000, Crystal report, TOAD, PLSQL Developer, Oracle 10g, Developer 2000, Forms 9i/6i, Reports 9i/6i, Sun Solaris 8.0, Windows XP Professional, PL/SQL, Java applications, Shell Scripts.

Confidential, Boston, MA

Oracle Developer

Responsibilities:

• Involved in System Coding, Data conversion, Development and Implementation of External Tables to extract data from teh flat files.
• Developed Functions & Procedures to manipulate teh data and to load to teh tables.
• Extensively involved in writing SQL queries (Sub queries and Join conditions), PL/SQL programming, and Oracle Partitioning to extract data from large database.
• Created Database Triggers in PL/SQL to accommodate for data integrity and additional Referential Integrity.
• Migration from Oracle 9i to Oracle 10g.
• Developed Korn Shell Scripts to ingest data on a daily basis from external source (flat file).
• Involved in developing UNIX shell scripts required for maintaining and processing job.
• Involved in Package modifications to reflect teh changes.
• Importing/Exporting data from/to different databases using utilities like SQL*Loader, Import/Export.
• Involved in export and import at schema level.
• Developed forms and reports using Forms 9i/10g and Reports 9i/10g
• Created Object Types in PL/SQL.
• Performed customization on existing Forms appearance, validation logic, and behavior and incorporating new functionalities for control purpose.
• Responsible for Analysis, Design, Development/Customization and Testing/debugging of teh reports.
• Using of Built-In-Packages of Oracle in PL/SQL procedures and functions

Environment: Oracle 10g, Oracle Forms 9i/10g, Reports 9i/10g, PL/SQL, SQL*LOADER, UNIX shell scripting, PRO*C, TOAD, UNIX Shell scripting, Korn Shell, Bourne Shell, SED, AWK, CRON, Windows NT/Windows XP, Solaris 7

Confidential

Jr.Oracle Developer

Responsibilities:

• PL/SQL was extensively utilized for coding and writing complex database triggers, stored procedures and packages.
• Various features of PL/SQL such as Dynamic SQL and parameter passing of PL/SQL tables were evaluated
• Developed SQL Applications for extracting teh data from teh Oracle tables.
• Extensive testing was done on teh programs for achieving accuracy, timely processing of data.
• Involved in teh development of backend procedures by using PL/SQL for ledger posting and for reversing teh journal ledgers.
• Wrote triggers and packages by using PL/SQL for giving security privileges.
• Developed forms using Forms 6i.
• Developed Reports using Reports 6i.

Environment: SQL *Plus, Oracle 9i, PL/SQL, SQL*Loader, Developer 2000, Forms 6i, Reports 6i, Shell Scripting, UNIX, Java, HTML.

Confidential

Jr.Oracle Developer

Responsibilities:

• Involved in system study, development and implementation of teh project.
• 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.

Environment: SQL *Plus, Oracle8i, PL/SQL, JSP, JDBC, SQL*Loader, Shell Scripting, UNIX, HTML.